-- to run this channel altering script:
-- mysql -umythtv -p -h192.168.1.1 --database mythconverg < mythtv-retune-all.sql

-- Last updated 2012-03-21

-- Make all stations invisible
#UPDATE channel SET visible=FALSE;
UPDATE channel SET channum = channum+100000, visible=FALSE;

-- Clear out the pish
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%';

-- Re-tune all FreeView channels (already re-named with T- prefix) and make visible when required
update channel SET channum=1,  visible=1, xmltvid="scotland.bbc1.bbc.co.uk"                 WHERE name='T-BBC ONE Scot';
update channel SET channum=2,  visible=1, xmltvid="scotland.bbc2.bbc.co.uk"                 WHERE name='T-BBC TWO Scot';
update channel SET channum=3,  visible=1, xmltvid="central.stv.tv"                          WHERE name='T-STV';
update channel SET channum=4,  visible=1, xmltvid="channel4.com"                            WHERE name='T-Channel 4';
update channel SET channum=5,  visible=1, xmltvid="channel5.co.uk"                          WHERE name='T-Channel 5';
update channel SET channum=6,  visible=1, xmltvid="itv2.itv.co.uk"                          WHERE name='T-ITV2';
update channel SET channum=7,  visible=1, xmltvid="bbcthree.bbc.co.uk"                      WHERE name='T-BBC THREE';
update channel SET channum=8,  visible=1, xmltvid="alba.bbc.co.uk"                          WHERE name='T-BBC ALBA';
update channel SET channum=9,  visible=1, xmltvid="bbcfour.bbc.co.uk"                       WHERE name='T-BBC FOUR';
update channel SET channum=10, visible=1, xmltvid="itv3.itv.co.uk"                          WHERE name='T-ITV3';
update channel SET channum=11, visible=1, xmltvid="sky-three.sky.com"                       WHERE name='T-Pick TV';
update channel SET channum=12, visible=1, xmltvid="yesterday.uktv.co.uk"                    WHERE name='T-Yesterday';
update channel SET channum=13, visible=1, xmltvid="tsod.plus-1.channel4.com"                WHERE name='T-Channel 4+1';
update channel SET channum=14, visible=1, xmltvid="more4.channel4.com"                      WHERE name='T-More 4';
update channel SET channum=15, visible=1, xmltvid="filmfour.channel4.com"                   WHERE name='T-Film4';
update channel SET channum=16, visible=0, xmltvid="qvcuk.com"                               WHERE name='T-QVC';
update channel SET channum=17, visible=0                                                    WHERE name='T-G.O.L.D.';
update channel SET channum=18, visible=1, xmltvid="4music.channel4.com"                     WHERE name='T-4Music';
update channel SET channum=19, visible=1, xmltvid="dave.uktv.co.uk"                         WHERE name='T-Dave';
update channel SET channum=20, visible=1, xmltvid="really.uktv.co.uk"                       WHERE name='T-Really';
update channel SET channum=21, visible=1, xmltvid="uk.viva.tv"                              WHERE name='T-VIVA';
update channel SET channum=22, visible=0, xmltvid="idealworld.tv"                           WHERE name='T-Ideal World';
update channel SET channum=23, visible=0, xmltvid="bid.tv"                                  WHERE name='T-Bid TV';
update channel SET channum=24, visible=1, xmltvid="itv4.itv.co.uk"                          WHERE name='T-ITV4';
update channel SET channum=25, visible=1, xmltvid="tsod.plus-1.dave.uktv.co.uk"             WHERE name='T-Dave aj vu';
update channel SET channum=26, visible=0                                                    WHERE name='T-Home';
update channel SET channum=27, visible=1, xmltvid="tsod.plus-1.itv2.itv.co.uk"              WHERE name='T-ITV2 +1';
update channel SET channum=28, visible=1, xmltvid="e4.channel4.com"                         WHERE name='T-E4';
update channel SET channum=29, visible=1, xmltvid="tsod.plus-1.e4.channel4.com"             WHERE name='T-E4+1';
update channel SET channum=30, visible=1, xmltvid="fiver.channel5.co.uk"                    WHERE name='T-5*';
update channel SET channum=31, visible=1, xmltvid="fiveusa.channel5.co.uk"                  WHERE name='T-5 USA';
update channel SET channum=32, visible=0                                                    WHERE name='T-Big Deal';
update channel SET channum=33, visible=1, xmltvid="tsod.plus-1.central.stv.tv"              WHERE name='T-STV+1';
update channel SET channum=36, visible=0                                                    WHERE name='T-Create & Craft';
update channel SET channum=37, visible=0, xmltvid="price-drop.tv"                           WHERE name='T-Price-Drop TV';
update channel SET channum=38, visible=1, xmltvid="quest.discoveryeurope.com"               WHERE name='T-Quest';
update channel SET channum=39, visible=0                                                    WHERE name='T-The Zone';
update channel SET channum=40, visible=0                                                    WHERE name='T-Rocks & Co 1';
update channel SET channum=43, visible=0                                                    WHERE name='T-Gems TV';
update channel SET channum=44, visible=1, xmltvid="tsod.plus-1.channel5.co.uk"              WHERE name='T-Channel 5+1';
update channel SET channum=45, visible=0                                                    WHERE name='T-Lottery Xtra';
update channel SET channum=46, visible=1                                                    WHERE name='T-Challenge';
update channel SET channum=48, visible=0                                                    WHERE name='QVC Beauty';
update channel SET channum=49, visible=1, xmltvid="freeview.foodnetwork.com"                WHERE name='T-Food Network';
update channel SET channum=50, visible=0, xmltvid="hd.bbc1.bbc.co.uk"                       WHERE name='T-BBC One HD';
update channel SET channum=51, visible=0, xmltvid="hd.scotland-macro.stv.tv"                WHERE name='T-STV HD';
update channel SET channum=52, visible=0, xmltvid="hd.channel4.com"                         WHERE name='T-Channel 4 HD';
update channel SET channum=54, visible=0, xmltvid="hd.bbc.co.uk"                            WHERE name='T-BBC HD';
update channel SET channum=60, visible=0                                                    WHERE name='T-The Jewellery Channel';
update channel SET channum=70, visible=1, xmltvid="cbbc.bbc.co.uk"                          WHERE name='T-CBBC';
update channel SET channum=71, visible=1, xmltvid="cbeebies.bbc.co.uk"                      WHERE name='T-CBeebies';
update channel SET channum=72, visible=1, xmltvid="citv.itv.co.uk"                          WHERE name='T-CITV';
update channel SET channum=80, visible=1, xmltvid="news.bbc.co.uk"                          WHERE name='T-BBC NEWS';
update channel SET channum=81, visible=0, xmltvid="parliament.bbc.co.uk"                    WHERE name='T-BBC Parliament';
update channel SET channum=82, visible=1, xmltvid="sky-news.sky.com"                        WHERE name='T-Sky News';
update channel SET channum=85, visible=0                                                    WHERE name='T-Russia Today';
update channel SET channum=87, visible=1, xmltvid="freeview.communitychannel.org"           WHERE name='T-Community Channel';
update channel SET channum=89, visible=0, xmltvid="freeview.aljazeera.net"                  WHERE name='T-Al Jazeera Eng';
update channel SET channum=105,visible=0                                                    WHERE name='T-BBC Red Button';
update channel SET channum=116,visible=0                                                    WHERE name='T-Racing UK';
update channel SET channum=301,visible=0                                                    WHERE name='T-301';
update channel SET channum=307,visible=0                                                    WHERE name='T-TOPUP Anytime1';
update channel SET channum=309,visible=0                                                    WHERE name='T-TOPUP Anytime3';
update channel SET channum=310,visible=0                                                    WHERE name='T-TOPUP Anytime5';
update channel SET channum=311,visible=0                                                    WHERE name='T-TOPUP Anytime6';

update channel SET channum=93, visible=0                                                    WHERE name='T-Television X';
update channel SET channum=94, visible=0                                                    WHERE name='T-ADULT smileTV2';
update channel SET channum=95, visible=0                                                    WHERE name='T-ADULT smileTV3';
update channel SET channum=96, visible=0                                                    WHERE name='T-ADULT Babestn';
update channel SET channum=97, visible=0                                                    WHERE name='T-ADULT PARTY';
update channel SET channum=98, visible=0                                                    WHERE name='T-ADULT Blue';
update channel SET channum=193,visible=0                                                    WHERE name='T-ADULT Babestn2';
update channel SET channum=194,visible=0                                                    WHERE name='T-ADULT Playboy';

-- Re-tune all FreeSat channels (already re-named with S- prefix) and make visible when required
-- Entertainment
update channel SET channum=101, visible=1, xmltvid="scotland.bbc1.bbc.co.uk"                 WHERE name='S-BBC 1 Scotland';
update channel SET channum=102, visible=1, xmltvid="scotland.bbc2.bbc.co.uk"                 WHERE name='S-BBC 2 Scotland';
update channel SET channum=103, visible=1, xmltvid="central.stv.tv"                          WHERE name='S-STV';
update channel SET channum=104, visible=1, xmltvid="channel4.com"                            WHERE name='S-Channel 4';
update channel SET channum=105, visible=1, xmltvid="channel5.co.uk"                          WHERE name='S-Channel 5';
update channel SET channum=106, visible=1, xmltvid="bbcthree.bbc.co.uk"                      WHERE name='S-BBC THREE';
update channel SET channum=107, visible=1, xmltvid="bbcfour.bbc.co.uk"                       WHERE name='S-BBC FOUR';
update channel SET channum=108, visible=1, xmltvid="hd.bbc1.bbc.co.uk"                       WHERE name='S-BBC One HD';
update channel SET channum=109, visible=1, xmltvid="hd.bbc.co.uk"                            WHERE name='S-BBC HD';
update channel SET channum=110, visible=1, xmltvid="alba.bbc.co.uk"                          WHERE name='S-BBC ALBA';
update channel SET channum=112, visible=1, xmltvid="tsod.plus-1.london-macro.itv1.itv.co.uk" WHERE name='S-ITV1 +1';
update channel SET channum=113, visible=1, xmltvid="itv2.itv.co.uk"                          WHERE name='S-ITV2';
update channel SET channum=114, visible=1, xmltvid="tsod.plus-1.itv2.itv.co.uk"              WHERE name='S-ITV2 +1';
update channel SET channum=115, visible=1, xmltvid="itv3.itv.co.uk"                          WHERE name='S-ITV3';
update channel SET channum=116, visible=1, xmltvid="tsod.plus-1.itv3.itv.co.uk"              WHERE name='S-ITV3 +1';
update channel SET channum=117, visible=1, xmltvid="itv4.itv.co.uk"                          WHERE name='S-ITV4';
update channel SET channum=118, visible=1, xmltvid="tsod.plus-1.itv4.itv.co.uk"              WHERE name='S-ITV4 +1';
update channel SET channum=119, visible=1, xmltvid="hd.london-macro.itv1.itv.co.uk"          WHERE name='S-ITV1 HD';
update channel SET channum=120, visible=1, xmltvid="s4c.co.uk"                               WHERE name='S-S4C';
update channel SET channum=121, visible=1, xmltvid="tsod.plus-1.channel4.com"                WHERE name='S-Channel 4 +1';
update channel SET channum=122, visible=1, xmltvid="e4.channel4.com"                         WHERE name='S-E4';
update channel SET channum=123, visible=1, xmltvid="tsod.plus-1.e4.channel4.com"             WHERE name='S-E4 +1';
update channel SET channum=124, visible=1, xmltvid="more4.channel4.com"                      WHERE name='S-More4';
update channel SET channum=125, visible=1, xmltvid="tsod.plus-1.more4.channel4.com"          WHERE name='S-More4 +1';
update channel SET channum=126, visible=1, xmltvid="hd.channel4.com"                         WHERE name='S-Channel 4 HD';
update channel SET channum=134, visible=1, xmltvid="drama.cbs.com"                           WHERE name='S-CBS Drama';
update channel SET channum=135, visible=1, xmltvid="reality.cbs.com"                         WHERE name='S-CBS Reality';
update channel SET channum=136, visible=1, xmltvid="tsod.plus-1.reality.cbs.com"             WHERE name='S-CBS Reality +1';
update channel SET channum=137, visible=1, xmltvid="action.cbs.com"                          WHERE name='S-CBS Action';
update channel SET channum=138, visible=1, xmltvid="horror.cbs.com"                          WHERE name='S-Horror Channel';
update channel SET channum=139, visible=1, xmltvid="tsod.plus-1.horror.cbs.com"              WHERE name='S-Horror Channel +1';
update channel SET channum=140, visible=0, xmltvid="international.bet.com"                   WHERE name='S-Bet';
update channel SET channum=141, visible=0, xmltvid="tsod.plus-1.international.bet.com"       WHERE name='S-Bet +1';
update channel SET channum=142, visible=1, xmltvid="entertainment.truemovies.tv"             WHERE name='S-True Ent';
update channel SET channum=143, visible=1                                                    WHERE name='S-Men & Movies';

-- News & Sport
update channel SET channum=200, visible=1, xmltvid="news.bbc.co.uk"                          WHERE name='S-BBC NEWS';
update channel SET channum=201, visible=0, xmltvid="parliament.bbc.co.uk"                    WHERE name='S-BBC Parliament';
update channel SET channum=203, visible=0, xmltvid="aljazeera.net"                           WHERE name='S-Al Jazeera Eng';
update channel SET channum=204, visible=1, xmltvid="euronews.com"                            WHERE name='S-Euronews';
update channel SET channum=205, visible=0                                                    WHERE name='S-France 24';
update channel SET channum=206, visible=0                                                    WHERE name='S-Russia Today';
update channel SET channum=207, visible=1, xmltvid="europe.cnn.com"                          WHERE name='S-CNN';
update channel SET channum=208, visible=0, xmltvid="bloomberg.com"                           WHERE name='S-Bloomberg';
update channel SET channum=209, visible=0, xmltvid="world.nhk.or.jp"                         WHERE name='S-NHK World HD';
update channel SET channum=210, visible=0, xmltvid="europe.cnbc.com"                         WHERE name='S-CNBC';

-- Movies
update channel SET channum=300, visible=1, xmltvid="filmfour.channel4.com"                   WHERE name='S-Film4';
update channel SET channum=301, visible=1, xmltvid="tsod.plus-1.filmfour.channel4.com"       WHERE name='S-Film4 +1';
update channel SET channum=302, visible=1, xmltvid="1.truemovies.tv"                         WHERE name='S-True Movies 1';
update channel SET channum=303, visible=1, xmltvid="2.truemovies.tv"                         WHERE name='S-True Movies 2';
update channel SET channum=304, visible=1, xmltvid="1.movies4men.co.uk"                      WHERE name='S-Movies4Men';
update channel SET channum=305, visible=1, xmltvid="tsod.plus-1.1.movies4men.co.uk"          WHERE name='S-Movies4Men +1';
update channel SET channum=306, visible=1, xmltvid="2.movies4men.co.uk"                      WHERE name='S-Movies4Men 2';
update channel SET channum=307, visible=1, xmltvid="tsod.plus-1.2.movies4men.co.uk"          WHERE name='S-Movies4Men 2 +1';

-- Lifestyle
update channel SET channum=400, visible=0, xmltvid="weddingtv.com"                           WHERE name='S-Wedding TV';
update channel SET channum=402, visible=0, xmltvid="showcase.information.tv"                 WHERE name='S-Information TV';
update channel SET channum=403, visible=0, xmltvid="showcase.information.tv"                 WHERE name='S-Showcase';
update channel SET channum=405, visible=1, xmltvid="foodnetwork.com"                         WHERE name='S-Food Network';
update channel SET channum=406, visible=1, xmltvid="tsod.plus-1.foodnetwork.com"             WHERE name='S-Food Network +1';

-- Music
update channel SET channum=500, visible=1, xmltvid="chartshow.com"                           WHERE name='S-Chart Show TV';
update channel SET channum=501, visible=1                                                    WHERE name='S-The Vault';
update channel SET channum=502, visible=1, xmltvid="essentialflava.com"                      WHERE name='S-Flava';
update channel SET channum=503, visible=1, xmltvid="scuzz.tv"                                WHERE name='S-Scuzz';
update channel SET channum=504, visible=1, xmltvid="b4utv.com"                               WHERE name='S-B4U Music';
update channel SET channum=509, visible=1                                                    WHERE name='S-Zing';
update channel SET channum=514, visible=1                                                    WHERE name='S-Clubland TV';
update channel SET channum=515, visible=1                                                    WHERE name='S-Vintage TV';
update channel SET channum=516, visible=1                                                    WHERE name='S-NME TV';
update channel SET channum=517, visible=1, xmltvid="bliss.co.uk"                             WHERE name='S-Bliss';

-- Childrens
update channel SET channum=600, visible=1, xmltvid="cbbc.bbc.co.uk"                          WHERE name='S-CBBC Channel';
update channel SET channum=601, visible=1, xmltvid="cbeebies.bbc.co.uk"                      WHERE name='S-CBeebies';
update channel SET channum=602, visible=1, xmltvid="citv.itv.co.uk"                          WHERE name='S-CITV';
update channel SET channum=603, visible=1, xmltvid="popfun.co.uk"                            WHERE name='S-POP';
update channel SET channum=604, visible=1                                                    WHERE name='S-PopGirl';
update channel SET channum=605, visible=1, xmltvid="tinypop.com"                             WHERE name='S-Tiny Pop';
update channel SET channum=606, visible=1                                                    WHERE name='S-Kix!';

-- Special Interest
update channel SET channum=650, visible=0                                                    WHERE name='S-OceanFinance';
update channel SET channum=651, visible=0                                                    WHERE name='S-Renault TV';
update channel SET channum=652, visible=0                                                    WHERE name='S-Psychic TV';
update channel SET channum=690, visible=0                                                    WHERE name='S-Inspiration';
update channel SET channum=691, visible=0                                                    WHERE name='S-DAYSTAR';
update channel SET channum=692, visible=0                                                    WHERE name='S-revelation';
update channel SET channum=693, visible=0                                                    WHERE name='S-Islam Channel';
update channel SET channum=694, visible=0, xmltvid="god.tv"                                  WHERE name='S-GOD Channel';

-- Radio
update channel SET channum=700, visible=1                                                    WHERE name='S-BBC R1';
update channel SET channum=701, visible=1                                                    WHERE name='S-BBC R1X';
update channel SET channum=702, visible=1                                                    WHERE name='S-BBC R2';
update channel SET channum=703, visible=1                                                    WHERE name='S-BBC R3';
update channel SET channum=704, visible=1                                                    WHERE name='S-BBC R4 FM';
update channel SET channum=705, visible=1                                                    WHERE name='S-BBC R5L';
update channel SET channum=706, visible=1                                                    WHERE name='S-BBC R5SX';
update channel SET channum=707, visible=1                                                    WHERE name='S-BBC 6 Music';
update channel SET channum=708, visible=1                                                    WHERE name='S-BBC R4 Ex';
update channel SET channum=709, visible=1                                                    WHERE name='S-BBC Asian';
update channel SET channum=710, visible=1                                                    WHERE name='S-BBC R4 LW';
update channel SET channum=711, visible=1                                                    WHERE name='S-BBC WS';
update channel SET channum=712, visible=1                                                    WHERE name='S-BBC R Scot.';
update channel SET channum=713, visible=1                                                    WHERE name='S-BBC R n Gael';
update channel SET channum=714, visible=1                                                    WHERE name='S-BBC R Wales';
update channel SET channum=715, visible=1                                                    WHERE name='S-BBC R Cymru';
update channel SET channum=716, visible=1                                                    WHERE name='S-BBC R Ulster';
update channel SET channum=718, visible=1                                                    WHERE name='S-BBC London';
update channel SET channum=719, visible=1                                                    WHERE name='S-Capital FM';
update channel SET channum=720, visible=1                                                    WHERE name='S-Choice FM';
update channel SET channum=721, visible=1                                                    WHERE name='S-Classic FM';
update channel SET channum=722, visible=1                                                    WHERE name='S-Gold';
update channel SET channum=723, visible=1                                                    WHERE name='S-XFM';
update channel SET channum=724, visible=1                                                    WHERE name='S-Absolute';
update channel SET channum=725, visible=1                                                    WHERE name='S-Absolute CR';
update channel SET channum=726, visible=1                                                    WHERE name='S-Absolute80s';
update channel SET channum=727, visible=1                                                    WHERE name='S-NME';
update channel SET channum=728, visible=1                                                    WHERE name='S-WRN Europe';
update channel SET channum=729, visible=1                                                    WHERE name='S-Jazz FM';
update channel SET channum=730, visible=1                                                    WHERE name='S-Planet Rock';
update channel SET channum=731, visible=1                                                    WHERE name='S-TalkSport';
update channel SET channum=732, visible=1                                                    WHERE name='S-Smooth';
update channel SET channum=733, visible=1                                                    WHERE name='S-Heart';
update channel SET channum=750, visible=1                                                    WHERE name='S-RTE Radio 1';
update channel SET channum=751, visible=1                                                    WHERE name='S-RTE 2FM';
update channel SET channum=752, visible=1                                                    WHERE name='S-RTE Lyric fm';
update channel SET channum=753, visible=1                                                    WHERE name='S-RTE R na G';
update channel SET channum=777, visible=1                                                    WHERE name='S-InsightRadio';
update channel SET channum=786, visible=1                                                    WHERE name='S-BFBS Radio';
update channel SET channum=790, visible=1                                                    WHERE name='S-TWR';

-- Shopping
update channel SET channum=800, visible=0, xmltvid="qvcuk.com"                               WHERE name='S-QVC';
update channel SET channum=801, visible=0, xmltvid="price-drop.tv"                           WHERE name='S-Price-Drop TV';
update channel SET channum=802, visible=0, xmltvid="bid.tv"                                  WHERE name='S-Bid TV';
update channel SET channum=803, visible=0                                                    WHERE name='S-Pitch TV';
update channel SET channum=804, visible=0                                                    WHERE name='S-Pitch World';
update channel SET channum=805, visible=0, xmltvid="gemstv.co.uk"                            WHERE name='S-Gems TV';
update channel SET channum=806, visible=0                                                    WHERE name='S-TV SHOP';
update channel SET channum=807, visible=0                                                    WHERE name='S-Jewelry Maker';
update channel SET channum=808, visible=0                                                    WHERE name='S-JML';
update channel SET channum=809, visible=0                                                    WHERE name='S-JML Choice';
update channel SET channum=810, visible=0                                                    WHERE name='S-Ideal Extra';
update channel SET channum=812, visible=0                                                    WHERE name='S-Ideal World';
update channel SET channum=813, visible=0                                                    WHERE name='S-Create & Craft';
update channel SET channum=814, visible=0                                                    WHERE name='S-speedauctiontv';
update channel SET channum=815, visible=0                                                    WHERE name='S-Jewellery Ch.';
update channel SET channum=816, visible=0                                                    WHERE name='S-QVC Beauty';
update channel SET channum=817, visible=0                                                    WHERE name='S-Rocks & Co 1';
update channel SET channum=818, visible=0                                                    WHERE name='S-Gems TV Extra';

-- Adult
update channel SET channum=870, visible=0                                                    WHERE name='S-Babestation';
update channel SET channum=874, visible=0                                                    WHERE name='S-Filth';

-- Regional Variations
update channel SET channum=950, visible=0, xmltvid="london.bbc1.bbc.co.uk"                   WHERE name='S-BBC 1 London';
update channel SET channum=951, visible=0, xmltvid="ci.south-west.bbc1.bbc.co.uk"            WHERE name='S-BBC 1 CI';
update channel SET channum=952, visible=0, xmltvid="east-midlands.bbc1.bbc.co.uk"            WHERE name='S-BBC 1 E Mids';
update channel SET channum=953, visible=0, xmltvid="east.bbc1.bbc.co.uk"                     WHERE name='S-BBC 1 East (E)';
update channel SET channum=954, visible=0, xmltvid="west.east.bbc1.bbc.co.uk"                WHERE name='S-BBC 1 East (W)';
update channel SET channum=955, visible=0, xmltvid="north-west.bbc1.bbc.co.uk"               WHERE name='S-BBC 1 N West';
update channel SET channum=956, visible=0, xmltvid="north-east.bbc1.bbc.co.uk"               WHERE name='S-BBC 1 NE & C';
update channel SET channum=957, visible=0, xmltvid="northern-ireland.bbc1.bbc.co.uk"         WHERE name='S-BBC 1 NI';
update channel SET channum=958, visible=0, xmltvid="oxford.south.bbc1.bbc.co.uk"             WHERE name='S-BBC 1 Oxford';
update channel SET channum=959, visible=0, xmltvid="south-east.bbc1.bbc.co.uk"               WHERE name='S-BBC 1 S East';
#update channel SET channum=960, visible=0, xmltvid="scotland.bbc1.bbc.co.uk"                 WHERE name='S-BBC 1 Scotland';
update channel SET channum=961, visible=0, xmltvid="south.bbc1.bbc.co.uk"                    WHERE name='S-BBC 1 South';
update channel SET channum=962, visible=0, xmltvid="south-west.bbc1.bbc.co.uk"               WHERE name='S-BBC 1 S West';
update channel SET channum=963, visible=0, xmltvid="west-midlands.bbc1.bbc.co.uk"            WHERE name='S-BBC 1 W Mids';
update channel SET channum=964, visible=0, xmltvid="wales.bbc1.bbc.co.uk"                    WHERE name='S-BBC 1 Wales';
update channel SET channum=965, visible=0, xmltvid="west.bbc1.bbc.co.uk"                     WHERE name='S-BBC 1 West';
update channel SET channum=966, visible=0, xmltvid="yorkshire.bbc1.bbc.co.uk"                WHERE name='S-BBC 1 Yorks';
update channel SET channum=967, visible=0, xmltvid="yorkslincs.bbc1.bbc.co.uk"               WHERE name='S-BBC 1 Yrks&Lin';
update channel SET channum=968, visible=0, xmltvid="south.bbc2.bbc.co.uk"                    WHERE name='S-BBC 2 England';
update channel SET channum=969, visible=0, xmltvid="northern-ireland.bbc2.bbc.co.uk"         WHERE name='S-BBC 2 NI';
#update channel SET channum=970, visible=0, xmltvid="scotland.bbc2.bbc.co.uk"                 WHERE name='S-BBC 2 Scotland';
update channel SET channum=971, visible=0, xmltvid="wales.bbc2.bbc.co.uk"                    WHERE name='S-BBC 2 Wales';
update channel SET channum=974, visible=0                                                    WHERE name='S-C4 l';
update channel SET channum=977, visible=0, xmltvid="london.itv1.itv.co.uk"                   WHERE name='S-ITV1 London';

-- Mark BBC channals as addfree and not requiring commercial flagging.
UPDATE channel set commmethod=-2 WHERE name LIKE '%BBC%' OR name LIKE '%CBeebies';