This list was constructed for my last MythTV channel entry update session, dating from around the time of the switch to digital. Entries are based upon the Hannington transmitter values.
Rebuilding the MythTV list of channels I find invariably requires an update to one or more of the entries in the MythTV channel table.
-- General; UPDATE channel SET visible=1, xmltvid="south.bbc1.bbc.co.uk" WHERE name='BBC One'; UPDATE channel SET visible=1, xmltvid="bbc2.bbc.co.uk" WHERE name='BBC Two'; UPDATE channel SET name='ITV1', callsign='ITV1' WHERE name='ITV1 Meridian S'; UPDATE channel SET visible=1, xmltvid="meridian.itv1.itv.co.uk" WHERE name='ITV1'; UPDATE channel SET name='Channel4', callsign='Channel4' WHERE name='Channel 4'; UPDATE channel SET visible=1, xmltvid="channel4.com" WHERE name='Channel4'; UPDATE channel SET name='Channel5', callsign='Channel5' WHERE name='Channel 5'; UPDATE channel SET visible=1, xmltvid="channel5.co.uk" WHERE name='Channel5'; UPDATE channel SET name='BBC Three', callsign='BBC Three' WHERE name='BBC THREE'; UPDATE channel SET visible=1, xmltvid="bbcthree.bbc.co.uk" WHERE name='BBC Three'; UPDATE channel SET name='BBC Four', callsign='BBC Four' WHERE name='BBC FOUR'; UPDATE channel SET visible=1, xmltvid="bbcfour.bbc.co.uk" WHERE name='BBC Four'; UPDATE channel SET visible=1, xmltvid="hd.bbc.co.uk" WHERE name='BBC HD'; UPDATE channel SET name='BBC One HD', callsign='BBC One HD' WHERE name='BBC1 HD'; UPDATE channel SET visible=1, xmltvid="hd.bbc1.bbc.co.uk" WHERE name='BBC One HD'; UPDATE channel SET visible=1, xmltvid="alba.bbc.co.uk" WHERE name='BBC Alba'; UPDATE channel SET visible=1, xmltvid="freeview.dave.uktv.co.uk" WHERE name='Dave'; UPDATE channel SET visible=1, xmltvid="tsod.plus1.freeview.dave.uktv.co.uk" WHERE name='Dave ja vu'; UPDATE channel SET visible=1, xmltvid="itv2.itv.co.uk" WHERE name='ITV2'; UPDATE channel SET name='ITV2 +1', callsign='ITV2 +1' WHERE name='ITV2+1'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.itv2.itv.co.uk" WHERE name='ITV2 +1'; UPDATE channel SET visible=1, xmltvid="itv3.itv.co.uk" WHERE name='ITV3'; UPDATE channel SET name='ITV3 +1', callsign='ITV3 +1' WHERE name='ITV3+1'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.itv3.itv.co.uk" WHERE name='ITV3 +1'; UPDATE channel SET visible=1, xmltvid="itv4.itv.co.uk" WHERE name='ITV4'; UPDATE channel SET name='ITV4 +1', callsign='ITV4 +1' WHERE name='ITV4+1'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.itv4.itv.co.uk" WHERE name='ITV4 +1'; UPDATE channel SET visible=1, xmltvid="meridian.itv1.itv.co.uk" WHERE name='ITV1 HD'; UPDATE channel SET name='Channel4 +1', callsign='Channel4 +1' WHERE name='Channel 4 +1'; UPDATE channel SET name='Channel4 +1', callsign='Channel4 +1' WHERE name='Channel 4+1'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.channel4.com" WHERE name='Channel4 +1'; UPDATE channel SET name='Channel5 +1', callsign='Channel5 +1' WHERE name='Channel 5 +1'; UPDATE channel SET name='Channel5 +1', callsign='Channel5 +1' WHERE name='Channel 5+1'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.channel5.co.uk" WHERE name='Channel5 +1'; UPDATE channel SET name='E4', callsign='E4' WHERE name='e4'; UPDATE channel SET visible=1, xmltvid="e4.channel4.com" WHERE name='E4'; UPDATE channel SET name='E4 +1', callsign='E4 +1' WHERE name='E4+1'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.e4.channel4.com" WHERE name='E4 +1'; UPDATE channel SET name='More4', callsign='More4' WHERE name='More 4'; UPDATE channel SET visible=1, xmltvid="more4.channel4.com" WHERE name='More4'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.more4.channel4.com" WHERE name='More4 +1'; UPDATE channel SET visible=1 WHERE name='Channel 4 HD'; UPDATE channel SET visible=1 WHERE name='Home'; UPDATE channel SET name='Quest', callsign='Quest' WHERE name='QUEST'; UPDATE channel SET visible=1, xmltvid="freeview.quest.discoveryeurope.com" WHERE name='Quest'; UPDATE channel SET visible=1, xmltvid="yesterday.uktv.co.uk" WHERE name='Yesterday'; UPDATE channel SET visible=1, xmltvid="gold.uktv.co.uk" WHERE name='G.O.L.D.'; UPDATE channel SET name='Sky3', callsign='Sky3' WHERE name='SKY THREE'; UPDATE channel SET visible=1, xmltvid="sky-three.sky.com" WHERE name='Sky3'; UPDATE channel SET visible=1, xmltvid="fiver.channel5.co.uk" WHERE name='5*'; UPDATE channel SET visible=1, xmltvid="fiveusa.channel5.co.uk" WHERE name='5 USA'; UPDATE channel SET visible=1, xmltvid="drama.cbs.com" WHERE name='CBS Drama'; UPDATE channel SET visible=1, xmltvid="reality.cbs.com" WHERE name='CBS Reality'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.reality.cbs.com" WHERE name='CBS Reality +1'; UPDATE channel SET visible=1, xmltvid="action.cbs.com" WHERE name='CBS Action'; UPDATE channel SET name='ITV1 +1', callsign='ITV1 +1' WHERE name='ITV1+1'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.itv1.itv.co.uk" WHERE name='ITV1 +1'; UPDATE channel SET name='Channel5 +1', callsign='Channel5 +1' WHERE name='Channel 5+1'; UPDATE channel SET visible=1 WHERE name='Channel5 +1'; UPDATE channel SET visible=1 WHERE name='5* +1'; UPDATE channel SET visible=1 WHERE name='5 USA +1';-- News and Sport UPDATE channel SET visible=1, xmltvid="news.bbc.co.uk" WHERE name='BBC News'; UPDATE channel SET name='Al Jazeera English', callsign='Al Jazeera English' WHERE name='Al Jazeera Eng'; UPDATE channel SET visible=1, xmltvid="freeview.aljazeera.net" WHERE name='Al Jazeera English'; UPDATE channel SET visible=1, xmltvid="euronews.com" WHERE name='EuroNews'; UPDATE channel SET name='CNN International', callsign='CNN International' WHERE name='CNN'; UPDATE channel SET visible=1 WHERE name='Russia Today'; UPDATE channel SET visible=1, xmltvid="freeview.europe.cnn.com" WHERE name='CNN International'; UPDATE channel SET name='Bloomberg Television', callsign='Bloomberg Television' WHERE name='Bloomberg'; UPDATE channel SET visible=1, xmltvid="bloomberg.com" WHERE name='Bloomberg Television'; UPDATE channel SET visible=1, xmltvid="world.nhk.or.jp" WHERE name='NHK World TV'; UPDATE channel SET visible=1, xmltvid="europe.cnbc.com" WHERE name='CNBC'; UPDATE channel SET visible=1, xmltvid="sky-news.sky.com" WHERE name='Sky News';-- Films; UPDATE channel SET visible=1, xmltvid="filmfour.channel4.com" WHERE name='Film4'; UPDATE channel SET visible=1, xmltvid="tsod.plus-1.filmfour.channel4.com" WHERE name='Film4 +1';-- Children; UPDATE channel SET name='CBBC', callsign='CBBC' WHERE name='CBBC Channel'; UPDATE channel SET visible=1, xmltvid="cbbc.bbc.co.uk" WHERE name='CBBC'; UPDATE channel SET visible=1, xmltvid="cbeebies.bbc.co.uk" WHERE name='CBeebies'; UPDATE channel SET visible=1, xmltvid="citv.itv.co.uk" WHERE name='CITV'; UPDATE channel SET name='Jazeera Children', callsign='Jazeera Children' WHERE name='JazeeraChildren'; UPDATE channel SET visible=1 WHERE name='Jazeera Children';-- Radio; UPDATE channel SET name='BBC Radio 1', callsign='BBC Radio 1' WHERE name='BBC R1'; UPDATE channel SET visible=1 WHERE name='BBC Radio 1'; UPDATE channel SET visible=1, xmltvid="radio-1.bbc.co.uk" WHERE name='BBC Radio 1'; UPDATE channel SET name='BBC Radio 1Xtra', callsign='BBC Radio 1Xtra' WHERE name='BBC 1Xtra'; UPDATE channel SET name='BBC Radio 1Xtra', callsign='BBC Radio 1Xtra' WHERE name='BBC R1X'; UPDATE channel SET visible=1 WHERE name='BBC Radio 1Xtra'; UPDATE channel SET name='BBC Radio 2', callsign='BBC Radio 2' WHERE name='BBC R2'; UPDATE channel SET visible=1 WHERE name='BBC Radio 2'; UPDATE channel SET visible=1, xmltvid="radio-2.bbc.co.uk" WHERE name='BBC Radio 2'; UPDATE channel SET name='BBC Radio 3', callsign='BBC Radio 3' WHERE name='BBC R3'; UPDATE channel SET visible=1 WHERE name='BBC Radio 3'; UPDATE channel SET visible=1, xmltvid="radio-3.bbc.co.uk" WHERE name='BBC Radio 3'; UPDATE channel SET name='BBC Radio 4', callsign='BBC Radio 4' WHERE name='BBC R4 FM'; UPDATE channel SET visible=1 WHERE name='BBC Radio 4'; UPDATE channel SET visible=1, xmltvid="radio-4.bbc.co.uk" WHERE name='BBC Radio 4'; UPDATE channel SET name='BBC Radio 5 Live', callsign='BBC Radio 5 Live' WHERE name='BBC R5L'; UPDATE channel SET visible=1 WHERE name='BBC Radio 5 Live'; UPDATE channel SET visible=1, xmltvid="radio-5.bbc.co.uk" WHERE name='BBC Radio 5 Live'; UPDATE channel SET name='BBC Radio 5 Live Sports Extra', callsign='BBC Radio 5 Live Sports Extra' WHERE name='BBC R5SX'; UPDATE channel SET visible=1 WHERE name='BBC Radio 5 Live Sports Extra'; UPDATE channel SET visible=1 WHERE name='BBC 6 Music'; UPDATE channel SET visible=1, xmltvid="radio-6.bbc.co.uk" WHERE name='BBC Radio 6'; UPDATE channel SET name='BBC Asian Network', callsign='BBC Asian Network' WHERE name='BBC Asian Net.'; UPDATE channel SET name='BBC Asian Network', callsign='BBC Asian Network' WHERE name='BBC Asian'; UPDATE channel SET visible=1 WHERE name='BBC Asian Network'; UPDATE channel SET name='BBC Radio 4 LW', callsign='BBC Radio 4 LW' WHERE name='BBC R4 LW'; UPDATE channel SET visible=1 WHERE name='BBC Radio 4 LW'; UPDATE channel SET name='BBC World Service', callsign='BBC World Service' WHERE name='BBC World Sv.'; UPDATE channel SET visible=1 WHERE name='BBC World Service'; UPDATE channel SET name='BBC Radio 4 Extra', callsign='BBC Radio 4 Extra' WHERE name='BBC Radio 4 Ex'; UPDATE channel SET name='BBC Radio 4 Extra', callsign='BBC Radio 4 Extra' WHERE name='BBC R4 Ex'; UPDATE channel SET visible=1 WHERE name='BBC Radio 4 Extra'; UPDATE channel SET visible=1 WHERE name='Choice FM'; UPDATE channel SET visible=1 WHERE name='Classic FM'; UPDATE channel SET visible=1 WHERE name='Gold'; UPDATE channel SET visible=1 WHERE name='Xfm London'; UPDATE channel SET visible=1 WHERE name='Absolute Radio'; UPDATE channel SET name='Absolute Classic Rock', callsign='Absolute Classic Rock' WHERE name='absolute CR'; UPDATE channel SET visible=1 WHERE name='Absolute Classic Rock'; UPDATE channel SET name='Absolute 80s', callsign='Absolute 80s' WHERE name='absolute80s'; UPDATE channel SET visible=1 WHERE name='Absolute 80s'; UPDATE channel SET name='NME Radio', callsign='NME Radio' WHERE name='NME'; UPDATE channel SET visible=1 WHERE name='NME Radio'; UPDATE channel SET name='WRN Radio', callsign='WRN Radio' WHERE name='WRN europe'; UPDATE channel SET visible=1 WHERE name='WRN Radio'; UPDATE channel SET visible=1 WHERE name='Jazz FM'; UPDATE channel SET visible=1 WHERE name='Planet Rock'; UPDATE channel SET visible=1 WHERE name='Talksport'; UPDATE channel SET visible=1 WHERE name='Q'; UPDATE channel SET visible=1 WHERE name='Magic'; UPDATE channel SET visible=1 WHERE name='The Hits Radio'; UPDATE channel SET visible=1 WHERE name='Smooth Radio'; UPDATE channel SET visible=1 WHERE name='Kerrang!'; UPDATE channel SET visible=1 WHERE name='heat'; UPDATE channel SET visible=1 WHERE name='Kiss'; UPDATE channel SET visible=1 WHERE name='Heart'; UPDATE channel SET visible=1 WHERE name='Smash Hits!'; UPDATE channel SET visible=1 WHERE name='RTE Radio 1'; UPDATE channel SET name='Insight Radio', callsign='Insight Radio' WHERE name='insightradio'; UPDATE channel SET visible=1 WHERE name='Insight Radio'; UPDATE channel SET visible=1 WHERE name='BFBS Radio'; UPDATE channel SET visible=1 WHERE name='TWR'; -- Shopping; UPDATE channel SET visible=1, xmltvid="qvcuk.com" WHERE name='QVC'; UPDATE channel SET visible=1, xmltvid="price-drop.tv" WHERE name='price-drop tv'; UPDATE channel SET visible=1, xmltvid="bid.tv" WHERE name='bid tv'; UPDATE channel SET visible=1, xmltvid="gemstv.co.uk" WHERE name='Gems TV'; UPDATE channel SET visible=1, xmltvid="idealworld.tv" WHERE name='Ideal World'; -- Sport; UPDATE channel SET name='BBC Sport Interactive', callsign='BBC Sport Interactive' WHERE name='BBC Red Button'; UPDATE channel SET name='BBC Sport Interactive', callsign='BBC Sport Interactive' WHERE name='BBC Sport Interactive: BBC1'; UPDATE channel SET visible=1, xmltvid="interactive.sport.bbc.co.uk" WHERE name='BBC Sport Interactive'; UPDATE channel SET name='BBC Sport Interactive: BBC1', callsign='BBC Sport Interactive: BBC1' WHERE name='301'; UPDATE channel SET visible=1, xmltvid="bbc1.interactive.sport.bbc.co.uk" WHERE name='301'; UPDATE channel SET name='BBC Sport Interactive: BBC2', callsign='BBC Sport Interactive: BBC2' WHERE name='302'; UPDATE channel SET visible=1, xmltvid="bbc2.interactive.sport.bbc.co.uk" WHERE name='BBC Sport Interactive: BBC2'; UPDATE channel SET name='BBC Sport Interactive: BBC3', callsign='BBC Sport Interactive: BBC3' WHERE name='303'; UPDATE channel SET visible=1, xmltvid="bbc3.interactive.sport.bbc.co.uk" WHERE name='BBC Sport Interactive: BBC3';
