X-Git-Url: https://git.rmz.io/dotfiles.git/blobdiff_plain/61d7dd11d4a450a64f2817ee4db0ec7fa5880b42..b9e4a0c3af29391c27e9a020693541b9a86c4d14:/bin/fix_channel_numbers.sql

diff --git a/bin/fix_channel_numbers.sql b/bin/fix_channel_numbers.sql
deleted file mode 100644
index ffe47ad..0000000
--- a/bin/fix_channel_numbers.sql
+++ /dev/null
@@ -1,65 +0,0 @@
-use mythconverg;
-delete * FROM channel WHERE callsign REGEXP 'INCONN*'
-update channel SET channum=1 WHERE name='BBC 1 London';
-update channel SET channum=2 WHERE name='BBC 2 England';
-update channel SET channum=3 WHERE name='ITV1 Meridian S';
-update channel SET channum=4 WHERE name='Channel 4';
-update channel SET channum=5 WHERE name='Five';
-update channel SET channum=6 WHERE name='BBC THREE';
-update channel SET channum=7 WHERE name='BBC FOUR';
-update channel SET channum=8 WHERE name='ITV2';
-update channel SET channum=9 WHERE name='ITV4';
-update channel SET channum=10 WHERE name='E4';
-update channel SET channum=11 WHERE name='More4';
-update channel SET channum=12 WHERE name='e4';
-update channel SET channum=13 WHERE name='ITV2+1';
-update channel SET channum=14 WHERE name='Channel 4 +1';
-update channel SET channum=15 WHERE name='More4 +1';
-update channel SET channum=16 WHERE name='EMTV';
-update channel SET channum=17 WHERE name='E4+1';
-update channel SET channum=18 WHERE name='Men & Motors';
-update channel SET channum=19 WHERE name='Nuts TV';
-update channel SET channum=20 WHERE name='Nuts TV +1';
-update channel SET channum=21 WHERE name='Fight Network';
-update channel SET channum=25 WHERE name='CBBC Channel';
-update channel SET channum=26 WHERE name='CBeebies';
-update channel SET channum=27 WHERE name='CITV';
-update channel SET channum=28 WHERE name='Tiny Pop';
-update channel SET channum=29 WHERE name='POP';
-update channel SET channum=30 WHERE name='Tiny Pop +1';
-update channel SET channum=31 WHERE name='PopGirl';
-update channel SET channum=32 WHERE name='PopGirl +1';
-update channel SET channum=33 WHERE name='Kix!';
-update channel SET channum=35 WHERE name='Film4';
-update channel SET channum=36 WHERE name='Film4 +1';
-update channel SET channum=37 WHERE name='True Movies';
-update channel SET channum=38 WHERE name='True Movies 2';
-update channel SET channum=39 WHERE name='movies4men';
-update channel SET channum=40 WHERE name='movies4men 2';
-update channel SET channum=41 WHERE name='mov4men+1';
-update channel SET channum=42 WHERE name='mov4men2 +1';
-update channel SET channum=43 WHERE name='AIT Movistar';
-update channel SET channum=44 WHERE name='World Movies';
-update channel SET channum=45 WHERE name='Movies Active';
-update channel SET channum=46 WHERE name='Film DAL';
-update channel SET channum=47 WHERE name='Film24';
-update channel SET channum=50 WHERE name='BBC NEWS';
-update channel SET channum=51 WHERE name='BBC PARL\'MNT';
-update channel SET channum=52 WHERE name='Sky News';
-update channel SET channum=53 WHERE name='ATN';
-update channel SET channum=54 WHERE name='sportsXchange';
-update channel SET channum=55 WHERE name='CNN';
-update channel SET channum=56 WHERE name='EuroNews';
-update channel SET channum=57 WHERE name='France 24';
-update channel SET channum=58 WHERE name='Channel S NTV';
-update channel SET channum=59 WHERE name='CCTV-9';
-update channel SET channum=60 WHERE name='PCNE Chinese';
-update channel SET channum=61 WHERE name='Russia Today';
-update channel SET channum=65 WHERE name='BBC R1';
-update channel SET channum=66 WHERE name='BBC R2';
-update channel SET channum=67 WHERE name='BBC R3';
-update channel SET channum=68 WHERE name='BBC R4 FM';
-update channel SET channum=69 WHERE name='BBC R5L';
-update channel SET channum=70 WHERE name='BBC 6 Music';
-update channel SET channum=71 WHERE name='BBC Radio 7';
-update channel SET channum=75 WHERE name='BBC HD';