-- WARNING: The following line clears out dtv_multiplex table
DELETE FROM dtv_multiplex WHERE sourceid=1;
-- Frequency table from SCTE-65 CDS
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=1,frequency=75250000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=2,frequency=57000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=3,frequency=63000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=4,frequency=69000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=5,frequency=79000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=6,frequency=85000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=7,frequency=177000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=8,frequency=183000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=9,frequency=189000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=10,frequency=195000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=11,frequency=201000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=12,frequency=207000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=13,frequency=213000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=14,frequency=123000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=15,frequency=129000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=16,frequency=135000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=17,frequency=141000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=18,frequency=147000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=19,frequency=153000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=20,frequency=159000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=21,frequency=165000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=22,frequency=171000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=23,frequency=219000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=24,frequency=225000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=25,frequency=231000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=26,frequency=237000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=27,frequency=243000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=28,frequency=249000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=29,frequency=255000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=30,frequency=261000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=31,frequency=267000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=32,frequency=273000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=33,frequency=279000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=34,frequency=285000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=35,frequency=291000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=36,frequency=297000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=37,frequency=303000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=38,frequency=309000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=39,frequency=315000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=40,frequency=321000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=41,frequency=327000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=42,frequency=333000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=43,frequency=339000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=44,frequency=345000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=45,frequency=351000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=46,frequency=357000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=47,frequency=363000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=48,frequency=369000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=49,frequency=375000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=50,frequency=381000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=51,frequency=387000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=52,frequency=393000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=53,frequency=399000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=54,frequency=405000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=55,frequency=411000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=56,frequency=417000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=57,frequency=423000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=58,frequency=429000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=59,frequency=435000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=60,frequency=441000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=61,frequency=447000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=62,frequency=453000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=63,frequency=459000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=64,frequency=465000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=65,frequency=471000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=66,frequency=477000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=67,frequency=483000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=68,frequency=489000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=69,frequency=495000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=70,frequency=501000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=71,frequency=507000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=72,frequency=513000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=73,frequency=519000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=74,frequency=525000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=75,frequency=531000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=76,frequency=537000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=77,frequency=543000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=78,frequency=549000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=79,frequency=555000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=80,frequency=561000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=81,frequency=567000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=82,frequency=573000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=83,frequency=579000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=84,frequency=585000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=85,frequency=591000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=86,frequency=597000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=87,frequency=603000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=88,frequency=609000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=89,frequency=615000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=90,frequency=621000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=91,frequency=627000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=92,frequency=633000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=93,frequency=639000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=94,frequency=645000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=95,frequency=93000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=96,frequency=99000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=97,frequency=105000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=98,frequency=111000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=99,frequency=117000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=100,frequency=651000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=101,frequency=657000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=102,frequency=663000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=103,frequency=669000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=104,frequency=675000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=105,frequency=681000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=106,frequency=687000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=107,frequency=693000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=108,frequency=699000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=109,frequency=705000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=110,frequency=711000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=111,frequency=717000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=112,frequency=723000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=113,frequency=729000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=114,frequency=735000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=115,frequency=741000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=116,frequency=747000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=117,frequency=753000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=118,frequency=759000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=119,frequency=765000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=120,frequency=771000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=121,frequency=777000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=122,frequency=783000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=123,frequency=789000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=124,frequency=795000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=125,frequency=801000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=126,frequency=807000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=127,frequency=813000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=128,frequency=819000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=129,frequency=825000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=130,frequency=831000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=131,frequency=837000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=132,frequency=843000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=133,frequency=849000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=134,frequency=855000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=135,frequency=861000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=136,frequency=867000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=137,frequency=873000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=138,frequency=879000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=139,frequency=885000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=140,frequency=891000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=141,frequency=897000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=142,frequency=903000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=143,frequency=909000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=144,frequency=915000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=145,frequency=921000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=146,frequency=927000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=147,frequency=933000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=148,frequency=939000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=149,frequency=945000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=150,frequency=951000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=151,frequency=957000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=152,frequency=963000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=153,frequency=969000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=154,frequency=975000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=155,frequency=981000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=156,frequency=987000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=157,frequency=993000000,modulation='qam_256',sourceid=1;
INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=158,frequency=999000000,modulation='qam_256',sourceid=1;



-- WARNING: The following line clears out channel table
DELETE FROM channel WHERE sourceid=1;
-- VCT_ID 3110 (0x0c26) at 387012500hz, version 10
INSERT INTO channel SET mplexid=99,serviceid=10,freqid=2,chanid=1002,sourceid=1,channum='2',callsign='KGAN';
INSERT INTO channel SET mplexid=82,serviceid=7,freqid=3,chanid=1003,sourceid=1,channum='3',callsign='WGN';
INSERT INTO channel SET mplexid=118,serviceid=2,freqid=4,chanid=1004,sourceid=1,channum='4',callsign='City Channel Iowa';
INSERT INTO channel SET mplexid=118,serviceid=3,freqid=5,chanid=1005,sourceid=1,channum='5',callsign='Local (11238)';
INSERT INTO channel SET mplexid=119,serviceid=2,freqid=6,chanid=1006,sourceid=1,channum='6',callsign='KPXR';
INSERT INTO channel SET mplexid=99,serviceid=12,freqid=7,chanid=1007,sourceid=1,channum='7',callsign='KWWL';
INSERT INTO channel SET mplexid=99,serviceid=4,freqid=8,chanid=1008,sourceid=1,channum='8',callsign='KFXA';
INSERT INTO channel SET mplexid=99,serviceid=6,freqid=9,chanid=1009,sourceid=1,channum='9',callsign='KCRG';
INSERT INTO channel SET mplexid=118,serviceid=4,freqid=10,chanid=1010,sourceid=1,channum='10',callsign='ICPL';
INSERT INTO channel SET mplexid=117,serviceid=3,freqid=11,chanid=1011,sourceid=1,channum='11',callsign='Kirkwood EDU';
INSERT INTO channel SET mplexid=82,serviceid=1,freqid=12,chanid=1012,sourceid=1,channum='12',callsign='QVC';
INSERT INTO channel SET mplexid=99,serviceid=18,freqid=13,chanid=1013,sourceid=1,channum='13',callsign='KDIN   /KSIN/KRIN/KIIN';
INSERT INTO channel SET mplexid=82,serviceid=3,freqid=14,chanid=1014,sourceid=1,channum='14',callsign='CSPAN';
INSERT INTO channel SET mplexid=99,serviceid=16,freqid=15,chanid=1015,sourceid=1,channum='15',callsign='KFXB';
INSERT INTO channel SET mplexid=118,serviceid=5,freqid=17,chanid=1017,sourceid=1,channum='17',callsign='UOFI';
INSERT INTO channel SET mplexid=118,serviceid=6,freqid=18,chanid=1018,sourceid=1,channum='18',callsign='PA TV';
INSERT INTO channel SET mplexid=82,serviceid=23,freqid=19,chanid=1019,sourceid=1,channum='19',callsign='HSN';
INSERT INTO channel SET mplexid=99,serviceid=8,freqid=20,chanid=1020,sourceid=1,channum='20',callsign='KWKB';
INSERT INTO channel SET mplexid=118,serviceid=7,freqid=21,chanid=1021,sourceid=1,channum='21',callsign='Local (11224)';
INSERT INTO channel SET mplexid=99,serviceid=20,freqid=22,chanid=1022,sourceid=1,channum='22',callsign='Mediacom Connections';
INSERT INTO channel SET mplexid=51,serviceid=13,freqid=23,chanid=1023,sourceid=1,channum='23',callsign='FNC';
INSERT INTO channel SET mplexid=55,serviceid=5,freqid=24,chanid=1024,sourceid=1,channum='24',callsign='ESPN';
INSERT INTO channel SET mplexid=55,serviceid=13,freqid=25,chanid=1025,sourceid=1,channum='25',callsign='ESPN2';
INSERT INTO channel SET mplexid=53,serviceid=13,freqid=26,chanid=1026,sourceid=1,channum='26',callsign='TVLAND';
INSERT INTO channel SET mplexid=53,serviceid=17,freqid=27,chanid=1027,sourceid=1,channum='27',callsign='MTV';
INSERT INTO channel SET mplexid=54,serviceid=17,freqid=28,chanid=1028,sourceid=1,channum='28',callsign='LIFE';
INSERT INTO channel SET mplexid=51,serviceid=11,freqid=29,chanid=1029,sourceid=1,channum='29',callsign='DSC';
INSERT INTO channel SET mplexid=54,serviceid=11,freqid=30,chanid=1030,sourceid=1,channum='30',callsign='A&E';
INSERT INTO channel SET mplexid=52,serviceid=21,freqid=31,chanid=1031,sourceid=1,channum='31',callsign='USA';
INSERT INTO channel SET mplexid=53,serviceid=21,freqid=32,chanid=1032,sourceid=1,channum='32',callsign='MSNBC';
INSERT INTO channel SET mplexid=53,serviceid=1,freqid=33,chanid=1033,sourceid=1,channum='33',callsign='CNN';
INSERT INTO channel SET mplexid=55,serviceid=19,freqid=34,chanid=1034,sourceid=1,channum='34',callsign='TWC';
INSERT INTO channel SET mplexid=52,serviceid=1,freqid=35,chanid=1035,sourceid=1,channum='35',callsign='FX';
INSERT INTO channel SET mplexid=53,serviceid=9,freqid=36,chanid=1036,sourceid=1,channum='36',callsign='TNT';
INSERT INTO channel SET mplexid=54,serviceid=15,freqid=37,chanid=1037,sourceid=1,channum='37',callsign='VH1';
INSERT INTO channel SET mplexid=52,serviceid=19,freqid=38,chanid=1038,sourceid=1,channum='38',callsign='ANIMAL';
INSERT INTO channel SET mplexid=53,serviceid=3,freqid=39,chanid=1039,sourceid=1,channum='39',callsign='HN';
INSERT INTO channel SET mplexid=51,serviceid=19,freqid=40,chanid=1040,sourceid=1,channum='40',callsign='TLC East';
INSERT INTO channel SET mplexid=54,serviceid=23,freqid=41,chanid=1041,sourceid=1,channum='41',callsign='AMC';
INSERT INTO channel SET mplexid=52,serviceid=9,freqid=42,chanid=1042,sourceid=1,channum='42',callsign='SPEED';
INSERT INTO channel SET mplexid=54,serviceid=7,freqid=43,chanid=1043,sourceid=1,channum='43',callsign='DISNEY';
INSERT INTO channel SET mplexid=55,serviceid=15,freqid=44,chanid=1044,sourceid=1,channum='44',callsign='Comcast Sports';
INSERT INTO channel SET mplexid=51,serviceid=7,freqid=45,chanid=1045,sourceid=1,channum='45',callsign='COMEDY';
INSERT INTO channel SET mplexid=52,serviceid=15,freqid=46,chanid=1046,sourceid=1,channum='46',callsign='BRAVO';
INSERT INTO channel SET mplexid=54,serviceid=3,freqid=47,chanid=1047,sourceid=1,channum='47',callsign='HGTV';
INSERT INTO channel SET mplexid=51,serviceid=5,freqid=48,chanid=1048,sourceid=1,channum='48',callsign='ABCFAM';
INSERT INTO channel SET mplexid=53,serviceid=19,freqid=49,chanid=1049,sourceid=1,channum='49',callsign='NIK';
INSERT INTO channel SET mplexid=51,serviceid=1,freqid=50,chanid=1050,sourceid=1,channum='50',callsign='HALLMARK';
INSERT INTO channel SET mplexid=52,serviceid=13,freqid=57,chanid=1057,sourceid=1,channum='57',callsign='BET';
INSERT INTO channel SET mplexid=53,serviceid=15,freqid=58,chanid=1058,sourceid=1,channum='58',callsign='CMT';
INSERT INTO channel SET mplexid=53,serviceid=11,freqid=59,chanid=1059,sourceid=1,channum='59',callsign='SPK';
INSERT INTO channel SET mplexid=54,serviceid=13,freqid=60,chanid=1060,sourceid=1,channum='60',callsign='HIST';
INSERT INTO channel SET mplexid=51,serviceid=21,freqid=61,chanid=1061,sourceid=1,channum='61',callsign='WE';
INSERT INTO channel SET mplexid=52,serviceid=11,freqid=62,chanid=1062,sourceid=1,channum='62',callsign='Univision East';
INSERT INTO channel SET mplexid=52,serviceid=23,freqid=63,chanid=1063,sourceid=1,channum='63',callsign='TRAVEL';
INSERT INTO channel SET mplexid=54,serviceid=1,freqid=64,chanid=1064,sourceid=1,channum='64',callsign='FOOD';
INSERT INTO channel SET mplexid=55,serviceid=27,freqid=65,chanid=1065,sourceid=1,channum='65',callsign='NGC';
INSERT INTO channel SET mplexid=53,serviceid=7,freqid=66,chanid=1066,sourceid=1,channum='66',callsign='TBS';
INSERT INTO channel SET mplexid=53,serviceid=5,freqid=67,chanid=1067,sourceid=1,channum='67',callsign='TOON';
INSERT INTO channel SET mplexid=52,serviceid=17,freqid=68,chanid=1068,sourceid=1,channum='68',callsign='CNBC';
INSERT INTO channel SET mplexid=52,serviceid=7,freqid=69,chanid=1069,sourceid=1,channum='69',callsign='VS.';
INSERT INTO channel SET mplexid=54,serviceid=21,freqid=70,chanid=1070,sourceid=1,channum='70',callsign='Syfy';
INSERT INTO channel SET mplexid=56,serviceid=1,freqid=71,chanid=1071,sourceid=1,channum='71',callsign='FITTV';
INSERT INTO channel SET mplexid=51,serviceid=25,freqid=72,chanid=1072,sourceid=1,channum='72',callsign='Big Ten Network (IA)';
INSERT INTO channel SET mplexid=56,serviceid=5,freqid=73,chanid=1073,sourceid=1,channum='73',callsign='SOAP';
INSERT INTO channel SET mplexid=52,serviceid=5,freqid=74,chanid=1074,sourceid=1,channum='74',callsign='E!';
INSERT INTO channel SET mplexid=51,serviceid=15,freqid=75,chanid=1075,sourceid=1,channum='75',callsign='TCM';
INSERT INTO channel SET mplexid=51,serviceid=3,freqid=76,chanid=1076,sourceid=1,channum='76',callsign='LMN';
INSERT INTO channel SET mplexid=53,serviceid=23,freqid=77,chanid=1077,sourceid=1,channum='77',callsign='truTV';
INSERT INTO channel SET mplexid=56,serviceid=9,freqid=78,chanid=1078,sourceid=1,channum='78',callsign='Oxygen East';
INSERT INTO channel SET mplexid=82,serviceid=21,freqid=87,chanid=1087,sourceid=1,channum='87',callsign='CSPAN2';
INSERT INTO channel SET mplexid=82,serviceid=13,freqid=88,chanid=1088,sourceid=1,channum='88',callsign='CSPAN3';
INSERT INTO channel SET mplexid=99,serviceid=9,freqid=89,chanid=1089,sourceid=1,channum='89',callsign='BYU';
INSERT INTO channel SET mplexid=82,serviceid=19,freqid=90,chanid=1090,sourceid=1,channum='90',callsign='3 Angels Broadcasting';
INSERT INTO channel SET mplexid=82,serviceid=11,freqid=91,chanid=1091,sourceid=1,channum='91',callsign='Church Channel';
INSERT INTO channel SET mplexid=82,serviceid=5,freqid=92,chanid=1092,sourceid=1,channum='92',callsign='TBN';
INSERT INTO channel SET mplexid=82,serviceid=15,freqid=93,chanid=1093,sourceid=1,channum='93',callsign='INSP';
INSERT INTO channel SET mplexid=82,serviceid=17,freqid=94,chanid=1094,sourceid=1,channum='94',callsign='EWTN';
INSERT INTO channel SET mplexid=82,serviceid=9,freqid=97,chanid=1097,sourceid=1,channum='97',callsign='ShopNBC';
INSERT INTO channel SET mplexid=114,serviceid=3,freqid=106,chanid=1106,sourceid=1,channum='106',callsign='KWWL-RTN';
INSERT INTO channel SET mplexid=114,serviceid=2,freqid=107,chanid=1107,sourceid=1,channum='107',callsign='KWWL THIS Network';
INSERT INTO channel SET mplexid=115,serviceid=6,freqid=109,chanid=1109,sourceid=1,channum='109',callsign='KCRG-DT';
INSERT INTO channel SET mplexid=89,serviceid=8,freqid=118,chanid=1118,sourceid=1,channum='118',callsign='IPTV LEARNS';
INSERT INTO channel SET mplexid=89,serviceid=10,freqid=119,chanid=1119,sourceid=1,channum='119',callsign='IPTV WORLD';
INSERT INTO channel SET mplexid=117,serviceid=5,freqid=123,chanid=1123,sourceid=1,channum='123',callsign='Mediacom Mainstreet(13669)';
INSERT INTO channel SET mplexid=82,serviceid=1,freqid=814,chanid=1814,sourceid=1,channum='814',callsign='QVC';
INSERT INTO channel SET mplexid=115,serviceid=4,freqid=828,chanid=1828,sourceid=1,channum='828',callsign='KFXA (Fox 28) HD';
INSERT INTO channel SET mplexid=94,serviceid=256,freqid=1000,chanid=11000,sourceid=1,channum='1000',callsign='Digital EAS';