bin/fix_channel_numbers_new.sql

   1 USE mythconverg;
   2
   3 UPDATE channel SET channum = 1000;
   4
   5 -- Fix Names for your region;
   6 UPDATE channel SET name='BBC One', callsign='BBC One' WHERE name='BBC 1 London';
   7 UPDATE channel SET name='BBC Two', callsign='BBC Two' WHERE name='BBC 2 England';
   8
   9 -- Fix Names;
  10 UPDATE channel SET name='ITV', callsign='ITV' WHERE name='ITV1 Granada';
  11 UPDATE channel SET name='ITV', callsign='ITV' WHERE name='ITV1';
  12 UPDATE channel SET name='ITV2 +1', callsign='ITV2 +1' WHERE name='ITV2+1';
  13 UPDATE channel SET name='ITV3 +1', callsign='ITV3 +1' WHERE name='ITV3+1';
  14 UPDATE channel SET name='ITV4 +1', callsign='ITV4 +1' WHERE name='ITV4+1';
  15 UPDATE channel SET name='Sky3', callsign='Sky3' WHERE name='SKY THREE';
  16 UPDATE channel SET name='Channel 4 +1', callsign='Channel 4 +1' WHERE name='Channel 4+1';
  17 UPDATE channel SET name='More4', callsign='More4' WHERE name='More 4';
  18 UPDATE channel SET name='E4', callsign='E4' WHERE name='e4';
  19 UPDATE channel SET name='Virgin 1', callsign='Virgin 1' WHERE name='Virgin1';
  20 UPDATE channel SET name='Virgin 1 +1', callsign='Virgin 1 +1' WHERE name='Virgin1+1';
  21 UPDATE channel SET name='Zone Horror +1', callsign='Zone Horror +1' WHERE name='Zone Horror+1';
  22 UPDATE channel SET name='CBS Reality +1', callsign='CBS Reality +1' WHERE name='CBS Reality+1';
  23 UPDATE channel SET name='CBBC', callsign='CBBC' WHERE name='CBBC Channel';
  24 UPDATE channel SET name='Jazeera Children', callsign='Jazeera Children' WHERE name='jazeerachildren';
  25 UPDATE channel SET name='POP Girl', callsign='POP Girl' WHERE name='POPGirl';
  26 UPDATE channel SET name='Movies4Men 2 +1', callsign='Movies4Men 2 +1' WHERE name='mov4men2 +1';
  27 UPDATE channel SET name='RT', callsign='RT' WHERE name='Russia Today';
  28 UPDATE channel SET name='Al Jazeera English', callsign='Al Jazeera English' WHERE name='Al Jazeera Eng';
  29 UPDATE channel SET name='Bloomberg Television', callsign='Bloomberg Television' WHERE name='Bloomberg';
  30 UPDATE channel SET name='Sky Sports News', callsign='Sky Sports News' WHERE name='Sky Spts News';
  31 UPDATE channel SET name='CNN International', callsign='CNN International' WHERE name='CNN';
  32 UPDATE channel SET name='Teacher\'s TV', callsign='Teacher\'s TV' WHERE name='Teachers TV';
  33 UPDATE channel SET name='BBC Asian Network', callsign='BBC Asian Network' WHERE name='BBC Asian Net.';
  34 UPDATE channel SET name='BBC World Service', callsign='BBC World Service' WHERE name='BBC World Sv.';
  35 UPDATE channel SET name='BBC Radio 1Xtra', callsign='BBC Radio 1Xtra' WHERE name='BBC 1Xtra';
  36 UPDATE channel SET name='BBC Radio 5 Live Sports Extra', callsign='BBC Radio 5 Live Sports Extra' WHERE name='BBC R5SX';
  37 UPDATE channel SET name='BBC Radio 5 Live', callsign='BBC Radio 5 Live' WHERE name='BBC R5L';
  38
  39 -- Entertainment;
  40 UPDATE channel SET channum=101 WHERE name='BBC One';
  41 UPDATE channel SET channum=102 WHERE name='BBC Two';
  42 UPDATE channel SET channum=103 WHERE name='ITV';
  43 UPDATE channel SET channum=104 WHERE name='Channel 4';
  44 UPDATE channel SET channum=105 WHERE name='Channel 4 +1';
  45 UPDATE channel SET channum=106 WHERE name='BBC Three';
  46 UPDATE channel SET channum=107 WHERE name='BBC Four';
  47 UPDATE channel SET channum=108 WHERE name='BBC HD';
  48 UPDATE channel SET channum=109 WHERE name='ITV1 HD';
  49 UPDATE channel SET channum=110 WHERE name='BBC Alba';
  50 UPDATE channel SET channum=111 WHERE name='Dave';
  51 UPDATE channel SET channum=112 WHERE name='Dave ja vu';
  52
  53 UPDATE channel SET channum=113 WHERE name='ITV2';
  54 UPDATE channel SET channum=114 WHERE name='ITV2 +1';
  55 UPDATE channel SET channum=115 WHERE name='ITV3';
  56 UPDATE channel SET channum=116 WHERE name='ITV3 +1';
  57 UPDATE channel SET channum=117 WHERE name='ITV4';
  58 UPDATE channel SET channum=118 WHERE name='ITV4 +1';
  59
  60 UPDATE channel SET channum=120 WHERE name='S4C Digidol';
  61 UPDATE channel SET channum=121 WHERE name='Five';
  62 UPDATE channel SET channum=122 WHERE name='E4';
  63 UPDATE channel SET channum=123 WHERE name='E4+1';
  64 UPDATE channel SET channum=124 WHERE name='More4';
  65 UPDATE channel SET channum=125 WHERE name='More4 +1';
  66 UPDATE channel SET channum=126 WHERE name='Virgin 1';
  67 UPDATE channel SET channum=127 WHERE name='Virgin 1 +1';
  68 UPDATE channel SET channum=128 WHERE name='Quest';
  69 UPDATE channel SET channum=129 WHERE name='Yesterday';
  70 UPDATE channel SET channum=129 WHERE name='G.O.L.D.';
  71 UPDATE channel SET channum=129 WHERE name='Sky3';
  72 UPDATE channel SET channum=129 WHERE name='Fiver';
  73 UPDATE channel SET channum=129 WHERE name='Five USA';
  74
  75 UPDATE channel SET channum=135 WHERE name='CBS Drama';
  76 UPDATE channel SET channum=136 WHERE name='CBS Reality';
  77 UPDATE channel SET channum=137 WHERE name='CBS Reality +1';
  78 UPDATE channel SET channum=138 WHERE name='CBS Action';
  79 UPDATE channel SET channum=139 WHERE name='Zone Horror';
  80 UPDATE channel SET channum=140 WHERE name='Zone Horror +1';
  81 UPDATE channel SET channum=141 WHERE name='BET';
  82 UPDATE channel SET channum=142 WHERE name='BET +1';
  83
  84 -- News and Sport
  85 UPDATE channel SET channum=200 WHERE name='BBC News';
  86 UPDATE channel SET channum=201 WHERE name='BBC Parliament';
  87 UPDATE channel SET channum=202 WHERE name='S4C2';
  88 UPDATE channel SET channum=203 WHERE name='Al Jazeera English';
  89 UPDATE channel SET channum=204 WHERE name='EuroNews';
  90 UPDATE channel SET channum=205 WHERE name='France 24';
  91 UPDATE channel SET channum=206 WHERE name='RT';
  92 UPDATE channel SET channum=207 WHERE name='CNN International';
  93 UPDATE channel SET channum=208 WHERE name='Bloomberg Television';
  94 UPDATE channel SET channum=209 WHERE name='NHK World TV';
  95 UPDATE channel SET channum=210 WHERE name='Sky News';
  96 UPDATE channel SET channum=211 WHERE name='Sky Sports News';
  97 UPDATE channel SET channum=212 WHERE name='ESPN';
  98 UPDATE channel SET channum=213 WHERE name='BBC World Service';
  99 UPDATE channel SET channum=214 WHERE name='TV News';
 100
 101 -- Movies;
 102 UPDATE channel SET channum=300 WHERE name='Film4';
 103 UPDATE channel SET channum=301 WHERE name='Film4 +1';
 104 UPDATE channel SET channum=302 WHERE name='True Movies';
 105 UPDATE channel SET channum=303 WHERE name='True Movies 2';
 106 UPDATE channel SET channum=304 WHERE name='Movies4Men';
 107 UPDATE channel SET channum=306 WHERE name='Movies4Men 2';
 108 UPDATE channel SET channum=307 WHERE name='Movies4Men 2 +1';
 109 UPDATE channel SET channum=308 WHERE name='Film24';
 110
 111 -- Lifestyle;
 112 UPDATE channel SET channum=400 WHERE name='Wedding TV';
 113 UPDATE channel SET channum=401 WHERE name='Wedding TV Asia';
 114 UPDATE channel SET channum=402 WHERE name='Information TV';
 115 UPDATE channel SET channum=403 WHERE name='Rural TV';
 116 UPDATE channel SET channum=405 WHERE name='Food Network';
 117 UPDATE channel SET channum=406 WHERE name='Food Network +1';
 118 UPDATE channel SET channum=450 WHERE name='Men & Motors';
 119
 120 -- Music;
 121 UPDATE channel SET channum=500 WHERE name='Chart Show TV';
 122 UPDATE channel SET channum=501 WHERE name='The Vault';
 123 UPDATE channel SET channum=502 WHERE name='Flava';
 124 UPDATE channel SET channum=503 WHERE name='VIVA';
 125 UPDATE channel SET channum=504 WHERE name='B4U Music';
 126 UPDATE channel SET channum=505 WHERE name='4Music';
 127 UPDATE channel SET channum=509 WHERE name='Zing';
 128 UPDATE channel SET channum=514 WHERE name='Clubland TV';
 129 UPDATE channel SET channum=515 WHERE name='NME TV';
 130
 131 -- Children;
 132 UPDATE channel SET channum=600 WHERE name='CBBC';
 133 UPDATE channel SET channum=601 WHERE name='CBeebies';
 134 UPDATE channel SET channum=602 WHERE name='CITV';
 135 UPDATE channel SET channum=603 WHERE name='POP';
 136 UPDATE channel SET channum=604 WHERE name='Pop Girl';
 137 UPDATE channel SET channum=605 WHERE name='Tiny Pop';
 138 UPDATE channel SET channum=606 WHERE name='Kix!';
 139 UPDATE channel SET channum=607 WHERE name='Jazeera Children';
 140
 141 -- Special Interest;
 142 UPDATE channel SET channum=650 WHERE name='Teacher\'s TV';
 143 UPDATE channel SET channum=690 WHERE name='Inspiration';
 144 UPDATE channel SET channum=691 WHERE name='Dayster TV';
 145 UPDATE channel SET channum=692 WHERE name='Genesis TV';
 146
 147 -- Radio;
 148 UPDATE channel SET channum=700 WHERE name='BBC Radio 1';
 149 UPDATE channel SET channum=701 WHERE name='BBC Radio 1Xtra';
 150 UPDATE channel SET channum=702 WHERE name='BBC Radio 2';
 151 UPDATE channel SET channum=703 WHERE name='BBC Radio 3';
 152 UPDATE channel SET channum=704 WHERE name='BBC Radio 4';
 153 UPDATE channel SET channum=705 WHERE name='BBC Radio 5 Live';
 154 UPDATE channel SET channum=706 WHERE name='BBC Radio 5 Live Sports Extra';
 155 UPDATE channel SET channum=707 WHERE name='BBC 6 Music';
 156 UPDATE channel SET channum=708 WHERE name='BBC Radio 7';
 157 UPDATE channel SET channum=709 WHERE name='BBC Asian Network';
 158 UPDATE channel SET channum=710 WHERE name='BBC Radio 4 LW';
 159 UPDATE channel SET channum=711 WHERE name='BBC World Service';
 160 UPDATE channel SET channum=712 WHERE name='BBC Radio Scotland';
 161 UPDATE channel SET channum=713 WHERE name='BBC Radio nan Gaidheal';
 162 UPDATE channel SET channum=714 WHERE name='BBC Radio Wales';
 163 UPDATE channel SET channum=715 WHERE name='BBC Radio Cymru';
 164 UPDATE channel SET channum=716 WHERE name='BBC Radio Ulster';
 165 UPDATE channel SET channum=718 WHERE name='BBC Radio London';
 166 UPDATE channel SET channum=719 WHERE name='Capital 95.8';
 167 UPDATE channel SET channum=720 WHERE name='Choice FM';
 168 UPDATE channel SET channum=721 WHERE name='Classic FM';
 169 UPDATE channel SET channum=722 WHERE name='Gold';
 170 UPDATE channel SET channum=723 WHERE name='Xfm London';
 171 UPDATE channel SET channum=724 WHERE name='Absolute Radio';
 172 UPDATE channel SET channum=725 WHERE name='Absolute Classic Rock';
 173 UPDATE channel SET channum=726 WHERE name='Absolute 80s';
 174 UPDATE channel SET channum=727 WHERE name='NME Radio';
 175 UPDATE channel SET channum=728 WHERE name='WRN Radio';
 176 UPDATE channel SET channum=729 WHERE name='Jazz FM';
 177 UPDATE channel SET channum=730 WHERE name='Planet Rock';
 178 UPDATE channel SET channum=731 WHERE name='Talksport';
 179 UPDATE channel SET channum=732 WHERE name='Q';
 180 UPDATE channel SET channum=733 WHERE name='Magic';
 181 UPDATE channel SET channum=734 WHERE name='The Hits Radio';
 182 UPDATE channel SET channum=735 WHERE name='Smooth Radio';
 183 UPDATE channel SET channum=736 WHERE name='Kerrang!';
 184 UPDATE channel SET channum=737 WHERE name='heat';
 185 UPDATE channel SET channum=738 WHERE name='Kiss';
 186 UPDATE channel SET channum=738 WHERE name='Heart';
 187 UPDATE channel SET channum=738 WHERE name='Smash Hits!';
 188 UPDATE channel SET channum=750 WHERE name='RTE Radio 1';
 189 UPDATE channel SET channum=751 WHERE name='RTE Radio 2fm';
 190 UPDATE channel SET channum=752 WHERE name='RTE Radio lyric fm';
 191 UPDATE channel SET channum=753 WHERE name='RTE Radio na Gaeltacta';
 192 UPDATE channel SET channum=777 WHERE name='Insight Radio';
 193 UPDATE channel SET channum=786 WHERE name='BFBS Radio';
 194 UPDATE channel SET channum=790 WHERE name='TWR';
 195
 196 -- Shopping;
 197 UPDATE channel SET channum=800 WHERE name='QVC';
 198 UPDATE channel SET channum=801 WHERE name='price-drop tv';
 199 UPDATE channel SET channum=802 WHERE name='bid tv';
 200 UPDATE channel SET channum=803 WHERE name='Pitch TV';
 201 UPDATE channel SET channum=804 WHERE name='Gems TV';
 202 UPDATE channel SET channum=805 WHERE name='TV Shop';
 203 UPDATE channel SET channum=806 WHERE name='JML Home & DIY';
 204 UPDATE channel SET channum=808 WHERE name='JML Direct';
 205 UPDATE channel SET channum=809 WHERE name='JML Cookshop';
 206 UPDATE channel SET channum=810 WHERE name='Thane Direct';
 207 UPDATE channel SET channum=812 WHERE name='Ideal World';
 208 UPDATE channel SET channum=813 WHERE name='Create and Craft';
 209 UPDATE channel SET channum=814 WHERE name='speed auction tv';
 210 UPDATE channel SET channum=815 WHERE name='The Jewellery Channel';
 211
 212 -- Gaming and Dating;
 213 UPDATE channel SET channum=851 WHERE name='Netplay TV';
 214 UPDATE channel SET channum=861 WHERE name='Gala TV';
 215
 216 -- Adult;
 217 UPDATE channel SET channum=869 WHERE name='READ ME';
 218 UPDATE channel SET channum=870 WHERE name='Babestation';
 219 UPDATE channel SET channum=874 WHERE name='Filth';
 220
 221 -- Testing;
 222 UPDATE channel SET channum=900 WHERE name='BBC Red Button';
 223 UPDATE channel SET channum=901 WHERE name='Home';
 224
 225 -- Delete all excess channels;
 226 -- DELETE FROM channel WHERE channum > 999 OR channum < 100;
 227
 228 -- Mark BBC channals as addfree
 229 UPDATE channel set commmethod=-2 WHERE name LIKE '%BBC%' OR name = 'CBeebies';