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';
