cleaning up bin

[dotfiles.git] / bin / old / fix_channel_numbers.sql

diff --git a/bin/old/fix_channel_numbers.sql b/bin/old/fix_channel_numbers.sql
new file mode 100644 (file)
index 0000000..ffe47ad
--- /dev/null
+++ b/bin/old/fix_channel_numbers.sql
@@ -0,0 +1,65 @@
+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';