USE mythconverg;
UPDATE channel SET xmltvid='north-west.bbc1.bbc.co.uk', icon='/usr/share/mythtv/icons/tv/bbc1.gif',useonairguide=0 WHERE name='BBC ONE';
UPDATE channel SET xmltvid='north-west.bbc2.bbc.co.uk', icon='/usr/share/mythtv/icons/tv/bbc2.gif',useonairguide=0 WHERE name='BBC TWO';
UPDATE channel SET xmltvid='granadatv.co.uk', icon='/usr/share/mythtv/icons/tv/itv1.png',useonairguide=0 WHERE name='ITV1';
UPDATE channel SET xmltvid='channel4.com', icon='/usr/share/mythtv/icons/tv/channel4.gif',useonairguide=0 WHERE name='Channel 4';
UPDATE channel SET xmltvid='channel5.co.uk', icon='/usr/share/mythtv/icons/tv/five.gif',useonairguide=0 WHERE name='five';
UPDATE channel SET xmltvid='itv2.itv.co.uk', icon='/usr/share/mythtv/icons/tv/itv2.png',useonairguide=0 WHERE name='ITV2';
UPDATE channel SET xmltvid='choice.bbc.co.uk', icon='/usr/share/mythtv/icons/tv/bbc3.gif',useonairguide=0 WHERE name='BBC THREE';
UPDATE channel SET xmltvid='knowledge.bbc.co.uk', icon='/usr/share/mythtv/icons/tv/bbc4.gif',useonairguide=0 WHERE name='BBC FOUR';
UPDATE channel SET xmltvid='itv3.itv.co.uk', icon='/usr/share/mythtv/icons/tv/itv3.png',useonairguide=0 WHERE name='ITV3';
UPDATE channel SET xmltvid='sky-three.sky.com', icon='/usr/share/mythtv/icons/tv/sky3.gif',useonairguide=0 WHERE name='SKY THREE';
UPDATE channel SET xmltvid='ukhistory.tv', icon='/usr/share/mythtv/icons/tv/ukhistory.gif',useonairguide=0 WHERE name='UKTV History';
UPDATE channel SET xmltvid='more4.channel4.com', icon='/usr/share/mythtv/icons/tv/more4.jpg',useonairguide=0  WHERE name='More 4';
UPDATE channel SET xmltvid='e4.channel4.com', icon='/usr/share/mythtv/icons/tv/e4.gif',useonairguide=0 WHERE name='E4';
UPDATE channel SET xmltvid='abc1.disney.com', icon='/usr/share/mythtv/icons/tv/abc1.gif',useonairguide=0 WHERE name='abc1';
UPDATE channel SET xmltvid='qvcuk.com', icon='/usr/share/mythtv/icons/tv/qvc.gif',useonairguide=0 WHERE name='QVC';
UPDATE channel SET xmltvid='the-hits.emap.com', icon='/usr/share/mythtv/icons/tv/thehits.gif',useonairguide=0 WHERE name='The HITS';
UPDATE channel SET xmltvid='ukbrightideas.tv', icon='/usr/share/mythtv/icons/tv/ukbright.gif',useonairguide=0 WHERE name='UKTV Br\'tIdeas';
UPDATE channel SET xmltvid='1.virginmedia.com', icon='/usr/share/mythtv/icons/tv/virgin1.png',useonairguide=0 WHERE name='Virgin1';
UPDATE channel SET xmltvid='tmf.nl', icon='/usr/share/mythtv/icons/tv/tmf.gif',useonairguide=0 WHERE name='TMF';
UPDATE channel SET xmltvid='idealworld.tv', icon='/usr/share/mythtv/icons/tv/idealworld.gif',useonairguide=0 WHERE name='Ideal World';
UPDATE channel SET xmltvid='bid-up.tv', icon='/usr/share/mythtv/icons/tv/bidup.gif',useonairguide=0 WHERE name='bid tv';
UPDATE channel SET xmltvid='price-drop.tv', icon='/usr/share/mythtv/icons/tv/pricedrop.gif',useonairguide=0 WHERE name='price-drop tv';
UPDATE channel SET xmltvid='itv4.itv.co.uk', icon='/usr/share/mythtv/icons/tv/itv4.png',useonairguide=0 WHERE name='ITV4';
UPDATE channel SET xmltvid='filmfour.channel4.com', icon='/usr/share/mythtv/icons/tv/filmfour.gif',useonairguide=0 WHERE name='Film4';
UPDATE channel SET xmltvid='plus-1.e4.channel4.com', icon='/usr/share/mythtv/icons/tv/e4_plus.gif',useonairguide=0 WHERE name='E4+1';
UPDATE channel SET xmltvid='us.channel5.co.uk', icon='/usr/share/mythtv/icons/tv/fiveus.png',useonairguide=0 WHERE name='Five US';
UPDATE channel SET xmltvid='life.channel5.co.uk', icon='/usr/share/mythtv/icons/tv/fivelife.png',useonairguide=0 WHERE name='Five Life';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/setanta.gif' WHERE name='SETANTA SPORTS';
UPDATE channel SET xmltvid='play.itv.co.uk', icon='/usr/share/mythtv/icons/tv/itvplay.gif',useonairguide=0 WHERE name='ITV Play';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/quizcall.png' WHERE name='Quiz Call';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/smiletv.png' WHERE name='smileTV';
UPDATE channel SET xmltvid='cbbc.bbc.co.uk', icon='/usr/share/mythtv/icons/tv/cbbc.gif',useonairguide=0 WHERE name='CBBC Channel';
UPDATE channel SET xmltvid='cbeebies.bbc.co.uk', icon='/usr/share/mythtv/icons/tv/cbeeb.gif',useonairguide=0 WHERE name='CBeebies';
UPDATE channel SET xmltvid='communitychannel.org', icon='/usr/share/mythtv/icons/tv/community.gif',useonairguide=0 WHERE name='Community';
UPDATE channel SET xmltvid='citv.itv.co.uk', icon='/usr/share/mythtv/icons/tv/citv.png',useonairguide=0 WHERE name='CITV';
UPDATE channel SET xmltvid='news-24.bbc.co.uk', icon='/usr/share/mythtv/icons/tv/bbcnews24.gif',useonairguide=0 WHERE name='BBC NEWS 24';
UPDATE channel SET xmltvid='parliament.bbc.co.uk', icon='/usr/share/mythtv/icons/tv/bbcparliament.gif',useonairguide=0 WHERE name='BBC PARLMNT';
UPDATE channel SET xmltvid='sky-news.sky.com', icon='/usr/share/mythtv/icons/tv/skynews.png',useonairguide=0 WHERE name='Sky News';
UPDATE channel SET xmltvid='news.sports.sky.com', icon='/usr/share/mythtv/icons/tv/skysportsnews.png',useonairguide=0 WHERE name='Sky Spts News';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/community.gif' WHERE name='Community';
UPDATE channel SET xmltvid='dvb.teachers.tv', icon='/usr/share/mythtv/icons/tv/teacherstv.gif',useonairguide=0  WHERE name='Teachers\' TV';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/redhot.gif' WHERE name='Red Hot';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/teletext.png' WHERE name='Teletext';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/teletextholidays.png' WHERE name='Ttext Holidays';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/teletextcars.png' WHERE name='Teletext Cars';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/teletext4.png' WHERE name='Teletext on 4';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/bbci.png' WHERE name='BBCi';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/bbci.png' WHERE name='301';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/bbci.png' WHERE name='302';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/bbci.png' WHERE name='303';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/bbci.png' WHERE name='305';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/yooplay.gif' WHERE name='YooPlay Games';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/topup.png' WHERE name='TopUp Active';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/skytext.png' WHERE name='Sky Text';
UPDATE channel SET icon='/usr/share/mythtv/icons/tv/4tvinteractive.png' WHERE name='4TVinteractive';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcradio1.gif' WHERE name='BBC Radio 1';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbc1xtra.gif' WHERE name='1Xtra BBC';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcradio2.gif' WHERE name='BBC Radio 2';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcradio3.gif' WHERE name='BBC Radio 3';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcradio4.gif' WHERE name='BBC Radio 4';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcradio5.gif' WHERE name='BBC R5 Live';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbc5sport.gif' WHERE name='BBC 5L SportsX';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcradio6.gif' WHERE name='BBC 6 Music';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcradio7.gif' WHERE name='BBC 7';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcasiannet.gif' WHERE name='BBC Asian Net.';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/bbcworldservice.gif' WHERE name='BBC World Sv.';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/thehits.gif' WHERE name='The Hits Radio';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/smashhits.gif' WHERE name='Smash Hits!';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/kiss.gif' WHERE name='Kiss';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/heat.gif' WHERE name='heat';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/magic.gif' WHERE name='Magic';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/q.gif' WHERE name='Q';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/oneword.gif' WHERE name='oneword';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/smooth.gif' WHERE name='smooth fm';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/mojo.gif' WHERE name='MOJO';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/kerrang.gif' WHERE name='Kerrang!';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/talksport.png' WHERE name='talkSPORT';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/3c.gif' WHERE name='3C';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/pcr.png' WHERE name='Premier Radio';
UPDATE channel SET icon='/usr/share/mythtv/icons/radio/virginradio.gif' WHERE name='Virgin Radio';