InterWeb Task Force

If you run a MythTV Freesat box, this SQL will update your channel plan to resemble a freesat set top box channel plan. Some channels are not on Freesat EPG so for those channels I have picked channel numbers which most resemble the Freesat channel categories and also are numbers that I don’t anticipate Freesat using any time soon. This plan also removes various test channels, customer channels and other clutter.

Connect to your MySQL DB and run the following SQL:

use mythconverg;
delete from channel where callsign like '%MMS%';
delete from channel where callsign like '%Test%';
delete from channel where callsign like '%Cust%';
delete FROM channel where callsign REGEXP '^[0-9]';
delete from channel where callsign like '%background%';
update channel set channum ='101' where callsign = 'BBC 1 Wales';
update channel set channum ='102' where callsign = 'BBC 2 Wales';
update channel set channum ='103' where callsign = 'ITV1 Wales';
update channel set channum ='104' where callsign = 'Channel 4';
update channel set channum ='105' where callsign = 'Five';
update channel set channum ='106' where callsign = 'BBC Three';
update channel set channum ='107' where callsign = 'BBC Four';
update channel set channum ='108' where callsign = 'BBC HD';
update channel set channum ='110' where callsign = 'BBC Alba';
update channel set channum ='112' where callsign = 'ITV1+1';
update channel set channum ='113' where callsign = 'ITV2';
update channel set channum ='114' where callsign = 'ITV2+1';
update channel set channum ='115' where callsign = 'ITV3';
update channel set channum ='116' where callsign = 'ITV3+1';
update channel set channum ='117' where callsign = 'ITV4';
update channel set channum ='118' where callsign = 'ITV4+1';
update channel set channum ='120' where callsign = 'S4C Digidol';
update channel set channum ='121' where callsign = 'Channel 4 +1';
update channel set channum ='122' where callsign = 'E4';
update channel set channum ='123' where callsign = 'E4+1';
update channel set channum ='124' where callsign = 'More4';
update channel set channum ='125' where callsign = 'More4 +1';
update channel set channum ='135' where callsign = 'CBS Drama';
update channel set channum ='136' where callsign = 'CBS Reality';
update channel set channum ='137' where callsign = 'CBS Action';
update channel set channum ='138' where callsign = 'Zone Horror';
update channel set channum ='139' where callsign = 'Zone Horror+1';
update channel set channum ='140' where callsign = 'BET';
update channel set channum ='141' where callsign = 'BET +1';
update channel set channum ='196' where callsign = 'True Ent';
update channel set channum ='197' where callsign = 'OBE';
update channel set channum ='198' where callsign = 'Luxe TV';
update channel set channum ='199' where callsign = 'Luxe TV HD';
update channel set channum ='200' where callsign = 'BBC News';
update channel set channum ='201' where callsign like 'BBC Parl%';
update channel set channum ='202' where callsign = 'S4C2';
update channel set channum ='203' where callsign = 'Al Jazeera Eng';
update channel set channum ='204' where callsign = 'Euronews';
update channel set channum ='205' where callsign = 'France 24';
update channel set channum ='206' where callsign = 'Russia Today';
update channel set channum ='207' where callsign = 'CNN';
update channel set channum ='208' where callsign = 'Bloomberg';
update channel set channum ='298' where callsign =  'Sky News';
update channel set channum ='299' where callsign = 'Sky News Eire (Cable';
update channel set channum ='300' where callsign = 'Film4';
update channel set channum ='301' where callsign = 'Film4 +1';
update channel set channum ='302' where callsign = 'True Movies';
update channel set channum ='303' where callsign = 'True Movies 2';
update channel set channum ='304' where callsign = 'Movies4Men';
update channel set channum ='305' where callsign = 'mov4men+1';
update channel set channum ='306' where callsign = 'Movies4Men 2';
update channel set channum ='307' where callsign = 'mov4men2 +1';
update channel set channum ='398' where callsign = 'Brit Shorts';
update channel set channum = 399 where callsign = 'Film24';
update channel set channum ='401' where callsign = 'wedding TV Asia';
update channel set channum ='402' where callsign = 'Information TV';
update channel set channum ='403' where callsign = 'Rural TV';
update channel set channum ='450' where callsign = 'Men & Motors';
update channel set channum ='499' where callsign = 'Faith';
update channel set channum ='500' where callsign = 'Chart Show TV';
update channel set channum ='501' where callsign = 'The Vault';
update channel set channum ='502' where callsign = 'Flava';
update channel set channum ='504' where callsign = 'B4U Music';
update channel set channum ='505' where callsign = 'NME TV';
update channel set channum ='509' where callsign = 'Zing';
update channel set channum ='514' where callsign = 'Clubland TV';
update channel set channum ='595' where callsign = 'Brit Asia TV';
update channel set channum ='596' where callsign = 'propeller';
update channel set channum ='597' where callsign = 'bliss';
update channel set channum ='598' where callsign = 'scuzz';
update channel set channum ='599' where callsign = 'flaunt';
update channel set channum ='600' where callsign = 'CBBC Channel';
update channel set channum ='601' where callsign = 'CBeebies';
update channel set channum ='602' where callsign = 'CITV';
update channel set channum ='603' where callsign = 'POP';
update channel set channum ='604' where callsign = 'POPGirl';
update channel set channum ='605' where callsign = 'Tiny POP';
update channel set channum ='610' where callsign = 'tiny pop+1';
update channel set channum ='611' where callsign = 'popgirl +1';
update channel set channum ='606' where callsign = 'Kix!';
update channel set channum ='650' where callsign = 'Teachers TV';
update channel set channum ='690' where callsign = 'Inspiration';
update channel set channum ='691' where callsign = 'DAYSTAR';
update channel set channum ='700' where callsign = 'BBC R1';
update channel set channum ='701' where callsign = 'BBC 1Xtra';
update channel set channum ='702' where callsign = 'BBC R2';
update channel set channum ='703' where callsign = 'BBC R3';
update channel set channum ='704' where callsign = 'BBC R4';
update channel set channum ='705' where callsign = 'BBC R5L';
update channel set channum ='706' where callsign = 'BBC R5SX';
update channel set channum ='707' where callsign = 'BBC 6 Music';
update channel set channum ='708' where callsign = 'BBC 7';
update channel set channum ='709' where callsign = 'BBC Asian';
update channel set channum ='710' where callsign = 'BBC R4 LW';
update channel set channum ='711' where callsign = 'BBC WS';
update channel set channum ='712' where callsign = 'BBC R Scot.';
update channel set channum ='713' where callsign = 'BBC R n Gael';
update channel set channum ='714' where callsign = 'BBC R Wales';
update channel set channum ='715' where callsign = 'BBC R Cymru';
update channel set channum ='716' where callsign = 'BBC R Ulster';
update channel set channum ='718' where callsign = 'BBC  London';
update channel set channum ='719' where callsign = 'Capital';
update channel set channum ='720' where callsign = 'Choice FM';
update channel set channum ='721' where callsign = 'Classic fm';
update channel set channum ='722' where callsign = 'Gold';
update channel set channum ='723' where callsign = 'XFM';
update channel set channum ='724' where callsign = 'Absolute';
update channel set channum ='725' where callsign = 'Absolute CR';
update channel set channum ='726' where callsign = 'Absolute 80s';
update channel set channum ='727' where callsign = 'NME';
update channel set channum ='728' where callsign = 'WRN Europe';
update channel set channum ='729' where callsign = 'Jazz FM';
update channel set channum ='730' where callsign = 'Planet Rock';
update channel set channum ='731' where callsign = 'talkSPORT';
update channel set channum ='750' where callsign = 'RTE Radio 1';
update channel set channum ='751' where callsign = 'RTE 2FM';
update channel set channum ='752' where callsign = 'RTE Lyric FM';
update channel set channum ='753' where callsign = 'RTE R na G';
update channel set channum ='777' where callsign = 'InsightRadio';
update channel set channum ='786' where callsign = 'BFBS Radio';
update channel set channum ='790' where callsign = 'TWR';
update channel set channum ='800' where callsign = 'QVC';
update channel set channum ='801' where callsign = 'price-drop tv';
update channel set channum ='802' where callsign = 'Bid TV';
update channel set channum ='803' where callsign = 'Pitch TV';
update channel set channum ='804' where callsign = 'Pitch World';
update channel set channum ='805' where callsign = 'Gems.TV 1';
update channel set channum ='806' where callsign = 'TV Shop';
update channel set channum ='808' where callsign = 'JML Home&DIY';
update channel set channum ='809' where callsign = 'JML Direct';
update channel set channum ='810' where callsign = 'JML CookShop';
update channel set channum ='811' where callsign = 'Thane Direct';
update channel set channum ='812' where callsign = 'Ideal World';
update channel set channum ='813' where callsign = 'Create & Craft';
update channel set channum ='814' where callsign = 'Speedauctiontv';
update channel set channum ='815' where callsign = 'Jewellery Ch.';
update channel set channum ='825' where callsign = 'Shop on TV';
update channel set channum ='826' where callsign = 'V Channel';
update channel set channum ='827' where callsign = 'Thomas Cook';
update channel set channum ='861' where callsign = 'Gala TV';
update channel set channum ='862' where callsign = 'Monte Carlo TV';
update channel set channum ='872' where callsign = 'XPLICIT XXX';
update channel set channum ='873' where callsign = 'Tease Me';
update channel set channum ='874' where callsign = 'Tease Me 2';
update channel set channum ='875' where callsign = 'Tease Me 3';
update channel set channum ='876' where callsign = 'GayDateTV';
update channel set channum ='878' where callsign = 'Over 18 TV';
update channel set channum ='879' where callsign = 'HBW TV';
update channel set channum ='950' where callsign = 'BBC 1 London';
update channel set channum ='951' where callsign = 'BBC 1 Channel Islands';
update channel set channum ='952' where callsign = 'BBC 1 East Midlands';
update channel set channum ='953' where callsign = 'BBC 1 East (E)';
update channel set channum ='954' where callsign = 'BBC 1 East (W)';
update channel set channum ='955' where callsign = 'BBC 1 North West';
update channel set channum ='956' where callsign = 'BBC 1 North East & Cumbria';
update channel set channum ='957' where callsign = 'BBC 1 Northern Ireland';
update channel set channum ='958' where callsign = 'BBC 1 Oxford';
update channel set channum ='959' where callsign = 'BBC 1 South East';
update channel set channum ='960' where callsign = 'BBC 1 Scotland';
update channel set channum ='961' where callsign = 'BBC 1 South';
update channel set channum ='962' where callsign = 'BBC 1 South West';
update channel set channum ='963' where callsign = 'BBC 1 West Midlands';
update channel set channum ='965' where callsign = 'BBC 1 West';
update channel set channum ='966' where callsign = 'BBC 1 Yorks';
update channel set channum ='967' where callsign = 'BBC 1 East Yorks & Lincs';
update channel set channum ='968' where callsign = 'BBC 2 England';
update channel set channum ='969' where callsign = 'BBC 2 Northern Ireland';
update channel set channum ='970' where callsign = 'BBC 2 Scotland';
update channel set channum ='977' where callsign = 'ITV London';
update cardinput set startchan = '101';