| 1 | -- MySQL dump 9.11
|
|---|
| 2 | --
|
|---|
| 3 | -- Host: localhost Database: mythconverg
|
|---|
| 4 | -- ------------------------------------------------------
|
|---|
| 5 | -- Server version 4.0.27
|
|---|
| 6 |
|
|---|
| 7 | --
|
|---|
| 8 | -- Table structure for table `channel`
|
|---|
| 9 | --
|
|---|
| 10 |
|
|---|
| 11 | CREATE TABLE channel (
|
|---|
| 12 | chanid int(10) unsigned NOT NULL default '0',
|
|---|
| 13 | channum varchar(10) NOT NULL default '',
|
|---|
| 14 | freqid varchar(10) default NULL,
|
|---|
| 15 | sourceid int(10) unsigned default NULL,
|
|---|
| 16 | callsign varchar(20) NOT NULL default '',
|
|---|
| 17 | name varchar(64) NOT NULL default '',
|
|---|
| 18 | icon varchar(255) NOT NULL default 'none',
|
|---|
| 19 | finetune int(11) default NULL,
|
|---|
| 20 | videofilters varchar(255) NOT NULL default '',
|
|---|
| 21 | xmltvid varchar(64) NOT NULL default '',
|
|---|
| 22 | recpriority int(10) NOT NULL default '0',
|
|---|
| 23 | contrast int(11) default '32768',
|
|---|
| 24 | brightness int(11) default '32768',
|
|---|
| 25 | colour int(11) default '32768',
|
|---|
| 26 | hue int(11) default '32768',
|
|---|
| 27 | tvformat varchar(10) NOT NULL default 'Default',
|
|---|
| 28 | commfree tinyint(4) NOT NULL default '0',
|
|---|
| 29 | visible tinyint(1) NOT NULL default '1',
|
|---|
| 30 | outputfilters varchar(255) NOT NULL default '',
|
|---|
| 31 | useonairguide tinyint(1) default '0',
|
|---|
| 32 | mplexid smallint(6) default NULL,
|
|---|
| 33 | serviceid mediumint(8) unsigned default NULL,
|
|---|
| 34 | atscsrcid int(11) default NULL,
|
|---|
| 35 | tmoffset int(11) NOT NULL default '0',
|
|---|
| 36 | atsc_major_chan int(10) unsigned NOT NULL default '0',
|
|---|
| 37 | atsc_minor_chan int(10) unsigned NOT NULL default '0',
|
|---|
| 38 | PRIMARY KEY (chanid),
|
|---|
| 39 | KEY channel_src (channum,sourceid)
|
|---|
| 40 | ) TYPE=MyISAM;
|
|---|
| 41 |
|
|---|
| 42 | --
|
|---|
| 43 | -- Dumping data for table `channel`
|
|---|
| 44 | --
|
|---|
| 45 |
|
|---|
| 46 | INSERT INTO channel VALUES (1006,'994','11',1,'C4_T','C4','/home/g8ecj/.mythtv/channels/c4_nz.jpg',0,'','C4.mr.geek.nz',-5,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 47 | INSERT INTO channel VALUES (2105,'64','64',2,'Sky Box Office 4','Sky Box Office 4','/home/g8ecj/.mythtv/channels/sky_box_office_nz.jpg',0,'','SBO4.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 48 | INSERT INTO channel VALUES (2106,'65','65',2,'Sky Box Office 5','Sky Box Office 5','/home/g8ecj/.mythtv/channels/sky_box_office_nz.jpg',0,'','SBO5.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 49 | INSERT INTO channel VALUES (2107,'66','66',2,'Sky Box Office 6','Sky Box Office 6','/home/g8ecj/.mythtv/channels/sky_box_office_nz.jpg',0,'','SBO6.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 50 | INSERT INTO channel VALUES (2108,'67','67',2,'Sky Box Office 7','Sky Box Office 7','/home/g8ecj/.mythtv/channels/sky_box_office_nz.jpg',0,'','SBO7.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 51 | INSERT INTO channel VALUES (2109,'60','60',2,'Sky Box Office','Sky Box Office','/home/g8ecj/.mythtv/channels/sky_box_office_nz.jpg',0,'','SkyBoxOffice.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 52 | INSERT INTO channel VALUES (2110,'999','',3,'VCR','VCR','none',0,'','',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 53 | INSERT INTO channel VALUES (2111,'102','102',2,'ConcertFM','ConcertFM','none',0,'','ConcertFM.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 54 | INSERT INTO channel VALUES (1028,'996','62',1,'Prime_T','Prime','/home/g8ecj/.mythtv/channels/prime_nz.jpg',0,'','Prime.mr.geek.nz',-5,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 55 | INSERT INTO channel VALUES (1052,'991','3',1,'TV One_T','TV One','/home/g8ecj/.mythtv/channels/tv1_newzealand.jpg',150,'','TV1.mr.geek.nz',-5,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 56 | INSERT INTO channel VALUES (1053,'992','8',1,'TV 2_T','TV 2','/home/g8ecj/.mythtv/channels/tv2_newzealand.jpg',0,'','TV2.mr.geek.nz',-5,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 57 | INSERT INTO channel VALUES (1054,'993','6',1,'TV 3_T','TV 3','/home/g8ecj/.mythtv/channels/tv3_newzealand.jpg',0,'','TV3.mr.geek.nz',-5,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 58 | INSERT INTO channel VALUES (1055,'997','58',1,'Trackside_T','Trackside','/home/g8ecj/.mythtv/channels/tab_trackside.jpg',0,'','Trackside.mr.geek.nz',-5,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 59 | INSERT INTO channel VALUES (2001,'52','52',2,'Animal Planet','Animal Planet','/home/g8ecj/.mythtv/channels/animalplanet.jpg',0,'','AnimalPlanet.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 60 | INSERT INTO channel VALUES (2003,'41','41',2,'Cartoon Network','Cartoon Network','/home/g8ecj/.mythtv/channels/cartoon_network.jpg',0,'','CartoonNetwork.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 61 | INSERT INTO channel VALUES (2004,'59','59',2,'Arts Channel','Arts Channel','/home/g8ecj/.mythtv/channels/arts_channel.jpg',0,'','ArtsChannel.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 62 | INSERT INTO channel VALUES (2005,'55','55',2,'BBC World','BBC World','/home/g8ecj/.mythtv/channels/bbcworld.jpg',0,'','BBCWorld.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 63 | INSERT INTO channel VALUES (2006,'32','32',2,'C4','C4','/home/g8ecj/.mythtv/channels/c4_nz.jpg',0,'','C4.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 64 | INSERT INTO channel VALUES (2007,'56','56',2,'CNN','CNN','/home/g8ecj/.mythtv/channels/cnn.jpg',0,'','CNN.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 65 | INSERT INTO channel VALUES (2013,'8','8',2,'Living Channel','Living Channel','/home/g8ecj/.mythtv/channels/living_channel.jpg',0,'','LivingChannel.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 66 | INSERT INTO channel VALUES (2014,'50','50',2,'Discovery','Discovery','/home/g8ecj/.mythtv/channels/discovery.jpg',0,'','Discovery.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 67 | INSERT INTO channel VALUES (2015,'40','40',2,'Disney','Disney','/home/g8ecj/.mythtv/channels/disney_channel.jpg',0,'','DisneyChannel.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 68 | INSERT INTO channel VALUES (2016,'7','7',2,'E!','E!','/home/g8ecj/.mythtv/channels/e.jpg',0,'','E.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 69 | INSERT INTO channel VALUES (2017,'13','13',2,'ESPN','ESPN','/home/g8ecj/.mythtv/channels/espn.jpg',0,'','ESPN.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 70 | INSERT INTO channel VALUES (2018,'53','53',2,'History','History','/home/g8ecj/.mythtv/channels/historychannel.jpg',0,'','History.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 71 | INSERT INTO channel VALUES (2019,'31','31',2,'J2','J2','/home/g8ecj/.mythtv/channels/j2_tv.jpg',0,'','J2.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 72 | INSERT INTO channel VALUES (2020,'80','80',2,'JTV','JTV','/home/g8ecj/.mythtv/channels/wtv_jtv.jpg',0,'','JTV.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 73 | INSERT INTO channel VALUES (2021,'30','30',2,'Juice TV','Juice TV','/home/g8ecj/.mythtv/channels/juicetv_nz.jpg',0,'','JuiceTV.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 74 | INSERT INTO channel VALUES (2022,'81','81',2,'KTV','KTV','/home/g8ecj/.mythtv/channels/wtv_ktv.jpg',0,'','KTV.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 75 | INSERT INTO channel VALUES (2023,'33','33',2,'Maori Television','Maori Television','/home/g8ecj/.mythtv/channels/maori_tv.jpg',0,'','MaoriTV.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 76 | INSERT INTO channel VALUES (2025,'51','51',2,'Nat. Geographic','Nat. Geographic','/home/g8ecj/.mythtv/channels/natgeochannel.jpg',0,'','NatGeographic.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 77 | INSERT INTO channel VALUES (2026,'42','42',2,'Nickelodeon','Nickelodeon','/home/g8ecj/.mythtv/channels/nickelodeon.jpg',0,'','Nickelodeon.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 78 | INSERT INTO channel VALUES (2028,'6','6',2,'Prime','Prime','/home/g8ecj/.mythtv/channels/prime_nz.jpg',0,'','Prime.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 79 | INSERT INTO channel VALUES (2039,'5','5',2,'SKY 1','SKY 1','/home/g8ecj/.mythtv/channels/sky1_nz.jpg',0,'','SKY1.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 80 | INSERT INTO channel VALUES (2043,'54','54',2,'SKY News Aust/NZ','SKY News Aust/NZ','/home/g8ecj/.mythtv/channels/skynewsaus.jpg',0,'','SKYNews.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 81 | INSERT INTO channel VALUES (2047,'99','99',2,'Shine','Shine','/home/g8ecj/.mythtv/channels/shine_tv.jpg',0,'','Shine.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 82 | INSERT INTO channel VALUES (2048,'90','90',2,'Southland TV','Southland TV','/home/g8ecj/.mythtv/channels/mainlandtv_nz.jpg',0,'','SouthlandTV.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 83 | INSERT INTO channel VALUES (2052,'1','1',2,'TV One','TV One','/home/g8ecj/.mythtv/channels/tv1_newzealand.jpg',0,'','TV1.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 84 | INSERT INTO channel VALUES (2053,'2','2',2,'TV 2','TV 2','/home/g8ecj/.mythtv/channels/tv2_newzealand.jpg',0,'','TV2.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 85 | INSERT INTO channel VALUES (2054,'3','3',2,'TV 3','TV 3','/home/g8ecj/.mythtv/channels/tv3_newzealand.jpg',0,'','TV3.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 86 | INSERT INTO channel VALUES (2056,'4','4',2,'UKTV','UKTV','/home/g8ecj/.mythtv/channels/uktv_au.jpg',0,'','UKTV.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,1,0,0,0,0,0);
|
|---|
| 87 | INSERT INTO channel VALUES (2093,'20','20',2,'Sky Movies 1','Sky Movies 1','/home/g8ecj/.mythtv/channels/sky_movies1_nz.jpg',0,'','SKYMovies1.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 88 | INSERT INTO channel VALUES (2092,'38','38',2,'Food TV','Food','/home/g8ecj/.mythtv/channels/food_channel_au.jpg',0,'','FoodTV.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 89 | INSERT INTO channel VALUES (2104,'63','63',2,'Sky Box Office 3','Sky Box Office 3','/home/g8ecj/.mythtv/channels/sky_box_office_nz.jpg',0,'','SBO3.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 90 | INSERT INTO channel VALUES (2103,'62','62',2,'Sky Box Office 2','Sky Box Office 2','/home/g8ecj/.mythtv/channels/sky_box_office_nz.jpg',0,'','SBO2.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 91 | INSERT INTO channel VALUES (2102,'61','61',2,'Sky Box Office 1','Sky Box Office 1','/home/g8ecj/.mythtv/channels/sky_box_office_nz.jpg',0,'','SBO1.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 92 | INSERT INTO channel VALUES (2101,'15','15',2,'Rugby','Rugby','/home/g8ecj/.mythtv/channels/rugby_channel.jpg',0,'','RugbyChannel.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 93 | INSERT INTO channel VALUES (2100,'12','12',2,'Sky Sports 3','Sky Sports 3','/home/g8ecj/.mythtv/channels/sky_sport3_nz.jpg',0,'','SKYSport3.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 94 | INSERT INTO channel VALUES (2099,'11','11',2,'Sky Sports 2','Sky Sports 2','/home/g8ecj/.mythtv/channels/sky_sport2_nz.jpg',0,'','SKYSport2.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 95 | INSERT INTO channel VALUES (2098,'10','10',2,'Sky Sports 1','Sky Sports 1','/home/g8ecj/.mythtv/channels/sky_sport1_nz.jpg',0,'','SKYSport1.mr.geek.nz',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 96 | INSERT INTO channel VALUES (2097,'24','24',2,'TCM','TCM','/home/g8ecj/.mythtv/channels/tcm_us.jpg',0,'','TCM.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 97 | INSERT INTO channel VALUES (2096,'23','23',2,'Rialto','Rialto','/home/g8ecj/.mythtv/channels/rialto_channel.jpg',0,'','Rialto.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 98 | INSERT INTO channel VALUES (2095,'22','22',2,'MGM','MGM','/home/g8ecj/.mythtv/channels/mgm.jpg',0,'','MGM.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 99 | INSERT INTO channel VALUES (2094,'21','21',2,'Sky Movies 2','Sky Movies 2','/home/g8ecj/.mythtv/channels/sky_movies2_nz.jpg',0,'','SKYMovies2.mr.geek.nz',0,32768,32768,32768,32768,'Default',1,1,'',0,NULL,NULL,NULL,0,0,0);
|
|---|
| 100 |
|
|---|
