bin/fix_channel_numbers.sql

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