INSERT INTO Channel
                      (name, isRadio, isTv, timesWatched, totalTimeWatched, grabEpg, lastGrabTime, sortOrder, visibleInGuide, externalId, freetoair, displayName, epgHasGaps)
SELECT 'Al Jazeera', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Al Jazeera', 'False'
UNION ALL
SELECT 'Bloomberg', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Bloomberg', 'False'
UNION ALL
SELECT 'Channel News Asia', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Channel News Asia', 'False'
UNION ALL
SELECT 'World of Fashion', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'World of Fashion', 'False'
UNION ALL
SELECT 'EuroSport', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'EuroSport', 'False'
UNION ALL
SELECT 'Eurosport News', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Eurosport News', 'False'
UNION ALL
SELECT 'Deutsche Welle', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Deutsche Welle', 'False'
UNION ALL
SELECT 'Phoenix InfoNews', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Phoenix InfoNews', 'False'
UNION ALL
SELECT 'TRT', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'TRT', 'False'
UNION ALL
SELECT 'TVE International', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'TVE International', 'False'
UNION ALL
SELECT 'Chinese TV1', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Chinese TV1', 'False'
UNION ALL
SELECT 'Chinese TV2', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Chinese TV2', 'False'
UNION ALL
SELECT 'Chinese TV3', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Chinese TV3', 'False'
UNION ALL
SELECT 'Chinese TV4', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Chinese TV4', 'False'
UNION ALL
SELECT 'Chinese TV5', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Chinese TV5', 'False'
UNION ALL
SELECT 'Chinese TV6', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Chinese TV6', 'False'
UNION ALL
SELECT 'Cuba Vision', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Cuba Vision', 'False'
UNION ALL
SELECT 'BVN TV', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'BVN TV', 'False'
UNION ALL
SELECT 'Greek TV', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Greek TV', 'False'
UNION ALL
SELECT 'Hungarian TV', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Hungarian TV', 'False'
UNION ALL
SELECT 'Indonesian TV', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Indonesian TV', 'False'
UNION ALL
SELECT 'Malaysian TV', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Malaysian TV', 'False'
UNION ALL
SELECT 'Movie Classics', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Movie Classics', 'False'
UNION ALL
SELECT 'Russia Today', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Russia Today', 'False'
UNION ALL
SELECT 'SCTV', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'SCTV', 'False'
UNION ALL
SELECT 'TV5MONDE', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'TV5MONDE', 'False'
UNION ALL
SELECT 'Voice Of America', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Voice Of America', 'False'
UNION ALL
SELECT 'NASA TV', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'NASA TV', 'False'
UNION ALL
SELECT 'Hindi Entertainment', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Hindi Entertainment', 'False'
UNION ALL
SELECT 'Indian News', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Indian News', 'False'
UNION ALL
SELECT 'Indian Sports', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Indian Sports', 'False'
UNION ALL
SELECT 'Thai TV5', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Thai TV5', 'False'
UNION ALL
SELECT 'VTV4', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'VTV4', 'False'
UNION ALL
SELECT 'Playboy TV', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Playboy TV (R)', 'False'
UNION ALL
SELECT 'Adult One', 'False', 'True', 0, '1/01/2000 12:00:00 AM', 'True', '1/01/2000 12:00:00 AM', 6, 'True', ' ', 'True', 'Adult One (R)', 'False'


DECLARE @IDALJA int
DECLARE @IDBLOO int
DECLARE @IDNEWA int
DECLARE @IDFASH int
DECLARE @IDEURO int
DECLARE @IDEUNE int
DECLARE @IDDEUT int
DECLARE @IDPHOE int
DECLARE @IDTRT int
DECLARE @IDTVE int
DECLARE @IDCTV1 int
DECLARE @IDCTV2 int
DECLARE @IDCTV3 int
DECLARE @IDCTV4 int
DECLARE @IDCTV5 int
DECLARE @IDCTV6 int
DECLARE @IDCUBA int
DECLARE @IDBVN int
DECLARE @IDGREE int
DECLARE @IDHUNG int
DECLARE @IDINDO int
DECLARE @IDMALA int
DECLARE @IDMOVI int
DECLARE @IDRUSS int
DECLARE @IDSCTV int
DECLARE @IDTV5M int
DECLARE @IDVOIC int
DECLARE @IDNASA int
DECLARE @IDHIND int
DECLARE @IDINDN int
DECLARE @IDINDS int
DECLARE @IDTHAI int
DECLARE @IDVTV4 int
DECLARE @IDPLAY int
DECLARE @IDADUL int


SET @IDALJA = (SELECT idChannel from Channel where name='Al Jazeera')
SET @IDBLOO = (SELECT idChannel from Channel where name='Bloomberg')
SET @IDNEWA = (SELECT idChannel from Channel where name='Channel News Asia')
SET @IDFASH = (SELECT idChannel from Channel where name='World of Fashion')
SET @IDEURO = (SELECT idChannel from Channel where name='EuroSport')
SET @IDEUNE = (SELECT idChannel from Channel where name='Eurosport News')
SET @IDDEUT = (SELECT idChannel from Channel where name='Deutsche Welle')
SET @IDPHOE = (SELECT idChannel from Channel where name='Phoenix InfoNews')
SET @IDTRT = (SELECT idChannel from Channel where name='TRT')
SET @IDTVE = (SELECT idChannel from Channel where name='TVE International')
SET @IDCTV1 = (SELECT idChannel from Channel where name='Chinese TV1')
SET @IDCTV2 = (SELECT idChannel from Channel where name='Chinese TV2')
SET @IDCTV3 = (SELECT idChannel from Channel where name='Chinese TV3')
SET @IDCTV4 = (SELECT idChannel from Channel where name='Chinese TV4')
SET @IDCTV5 = (SELECT idChannel from Channel where name='Chinese TV5')
SET @IDCTV6 = (SELECT idChannel from Channel where name='Chinese TV6')
SET @IDCUBA = (SELECT idChannel from Channel where name='Cuba Vision')
SET @IDBVN = (SELECT idChannel from Channel where name='BVN TV')
SET @IDGREE = (SELECT idChannel from Channel where name='Greek TV')
SET @IDHUNG = (SELECT idChannel from Channel where name='Hungarian TV')
SET @IDINDO = (SELECT idChannel from Channel where name='Indonesian TV')
SET @IDMALA = (SELECT idChannel from Channel where name='Malaysian TV')
SET @IDMOVI = (SELECT idChannel from Channel where name='Movie Classics')
SET @IDRUSS = (SELECT idChannel from Channel where name='Russia Today')
SET @IDSCTV = (SELECT idChannel from Channel where name='SCTV')
SET @IDTV5M = (SELECT idChannel from Channel where name='TV5MONDE')
SET @IDVOIC = (SELECT idChannel from Channel where name='Voice Of America')
SET @IDNASA = (SELECT idChannel from Channel where name='NASA TV')
SET @IDHIND = (SELECT idChannel from Channel where name='Hindi Entertainment')
SET @IDINDN = (SELECT idChannel from Channel where name='Indian News')
SET @IDINDS = (SELECT idChannel from Channel where name='Indian Sports')
SET @IDTHAI = (SELECT idChannel from Channel where name='Thai TV5')
SET @IDVTV4 = (SELECT idChannel from Channel where name='VTV4')
SET @IDPLAY = (SELECT idChannel from Channel where name='Playboy TV')
SET @IDADUL = (SELECT idChannel from Channel where name='Adult One')

INSERT INTO TuningDetail (idChannel,name,provider,channelType,channelNumber,frequency,countryId,isRadio,isTv,networkId,transportId,serviceId,pmtPid,freeToAir,modulation,polarisation,symbolrate,diseqc,switchingFrequency,bandwidth,majorChannel,minorChannel,pcrPid,videoSource,tuningSource,videoPid,audioPid,band,satIndex,innerFecRate,pilot,rollOff,url,bitrate)

SELECT @IDALJA,'Al Jazeera','TPG',7,301,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.2:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDBLOO,'Bloomberg','TPG',7,302,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.3:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDNEWA,'Channel News Asia','TPG',7,303,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.8:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDFASH,'World of Fashion','TPG',7,304,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.20:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDEURO,'EuroSport','TPG',7,305,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.27:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDEUNE,'Eurosport News','TPG',7,306,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.28:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDDEUT,'Deutsche Welle','TPG',7,307,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.4:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDPHOE,'Phoenix InfoNews','TPG',7,308,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.6:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDTRT,'TRT','TPG',7,309,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.9:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDTVE,'TVE International','TPG',7,310,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.14:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDCTV1,'Chinese TV1','TPG',7,311,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.18:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDCTV2,'Chinese TV2','TPG',7,312,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.19:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDCTV3,'Chinese TV3','TPG',7,313,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.25:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDCTV4,'Chinese TV4','TPG',7,314,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.24:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDCTV5,'Chinese TV5','TPG',7,315,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.29:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDCTV6,'Chinese TV6','TPG',7,316,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.17:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDCUBA,'Cuba Vision','TPG',7,317,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.11:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDBVN,'BVN TV','TPG',7,318,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.26:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDGREE,'Greek TV','TPG',7,319,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.21:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDHUNG,'Hungarian TV','TPG',7,320,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.16:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDINDO,'Indonesian TV','TPG',7,321,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.12:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDMALA,'Malaysian TV','TPG',7,322,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.22:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDMOVI,'Movie Classics','TPG',7,323,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.39:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDRUSS,'Russia Today','TPG',7,324,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.10:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDSCTV,'SCTV','TPG',7,327,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.7:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDTV5M,'TV5MONDE','TPG',7,328,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.5:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDVOIC,'Voice Of America','TPG',7,329,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.13:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDNASA,'NASA TV','TPG',7,330,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.69:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDHIND,'Hindi Entertainment','TPG',7,331,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.65:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDINDN,'Indian News','TPG',7,332,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.67:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDINDS,'Indian Sports','TPG',7,333,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.66:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDTHAI,'Thai TV5','TPG',7,334,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.30:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDVTV4,'VTV4','TPG',7,335,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.68:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDPLAY,'Playboy TV','TPG',7,398,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.41:1234:t=m2t/rtp',0
UNION ALL
SELECT @IDADUL,'Adult One','TPG',7,399,0,31,'False','True',0,1,1,16,'True',0,0,0,0,0,0,-1,-1,224,0,0,224,192,0,-1,-1,-1,-1,'elecard://233.29.121.42:1234:t=m2t/rtp',0