Ticket #2084: tables.sql.2.txt

File tables.sql.2.txt, 13.8 KB (added by tharding@…, 14 years ago)

table dump

Line 
1-- MySQL dump 10.9
2--
3-- Host: babe    Database: mythconverg
4-- ------------------------------------------------------
5-- Server version       4.1.20-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15
16--
17-- Table structure for table `capturecard`
18--
19
20DROP TABLE IF EXISTS `capturecard`;
21CREATE TABLE `capturecard` (
22  `cardid` int(10) unsigned NOT NULL auto_increment,
23  `videodevice` varchar(128) default NULL,
24  `audiodevice` varchar(128) default NULL,
25  `vbidevice` varchar(128) default NULL,
26  `cardtype` varchar(32) default 'V4L',
27  `defaultinput` varchar(32) default 'Television',
28  `audioratelimit` int(11) default NULL,
29  `hostname` varchar(255) default NULL,
30  `dvb_swfilter` int(11) default '0',
31  `dvb_recordts` int(11) default '1',
32  `dvb_sat_type` int(11) NOT NULL default '0',
33  `dvb_wait_for_seqstart` int(11) NOT NULL default '1',
34  `skipbtaudio` tinyint(1) default '0',
35  `dvb_on_demand` tinyint(4) NOT NULL default '0',
36  `dvb_diseqc_type` smallint(6) default NULL,
37  `firewire_port` int(10) unsigned NOT NULL default '0',
38  `firewire_node` int(10) unsigned NOT NULL default '2',
39  `firewire_speed` int(10) unsigned NOT NULL default '0',
40  `firewire_model` varchar(32) default NULL,
41  `firewire_connection` int(10) unsigned NOT NULL default '0',
42  `dvb_hw_decoder` int(11) default '0',
43  `dbox2_port` int(10) unsigned NOT NULL default '31338',
44  `dbox2_httpport` int(10) unsigned NOT NULL default '80',
45  `dbox2_host` varchar(32) default NULL,
46  `signal_timeout` int(11) NOT NULL default '1000',
47  `channel_timeout` int(11) NOT NULL default '3000',
48  `parentid` int(10) NOT NULL default '0',
49  `dvb_tuning_delay` int(10) unsigned NOT NULL default '0',
50  `contrast` int(11) NOT NULL default '0',
51  `brightness` int(11) NOT NULL default '0',
52  `colour` int(11) NOT NULL default '0',
53  `hue` int(11) NOT NULL default '0',
54  `diseqcid` int(10) unsigned default NULL,
55  PRIMARY KEY  (`cardid`)
56) ENGINE=MyISAM DEFAULT CHARSET=latin1;
57
58--
59-- Dumping data for table `capturecard`
60--
61
62
63/*!40000 ALTER TABLE `capturecard` DISABLE KEYS */;
64LOCK TABLES `capturecard` WRITE;
65INSERT INTO `capturecard` VALUES (1,'/dev/v4l/video0','/dev/dsp','/dev/v4l/vbi0','V4L','Television',0,'mythbackend',0,1,0,1,0,0,NULL,0,2,0,NULL,0,0,31338,80,NULL,1000,3000,0,0,0,0,0,0,0),(2,'0','','','DVB','Television',NULL,'mythbackend',0,1,0,1,0,1,NULL,0,2,0,NULL,0,0,31338,80,NULL,3000,5500,0,0,0,0,0,0,0);
66UNLOCK TABLES;
67/*!40000 ALTER TABLE `capturecard` ENABLE KEYS */;
68
69--
70-- Table structure for table `dtv_multiplex`
71--
72
73DROP TABLE IF EXISTS `dtv_multiplex`;
74CREATE TABLE `dtv_multiplex` (
75  `mplexid` smallint(6) NOT NULL auto_increment,
76  `sourceid` smallint(6) default NULL,
77  `transportid` int(11) default NULL,
78  `networkid` int(11) default NULL,
79  `frequency` int(11) default NULL,
80  `inversion` char(1) default 'a',
81  `symbolrate` int(11) default NULL,
82  `fec` varchar(10) default 'auto',
83  `polarity` char(1) default NULL,
84  `modulation` varchar(10) default 'auto',
85  `bandwidth` char(1) default 'a',
86  `lp_code_rate` varchar(10) default 'auto',
87  `transmission_mode` char(1) default 'a',
88  `guard_interval` varchar(10) default 'auto',
89  `visible` smallint(1) NOT NULL default '0',
90  `constellation` varchar(10) default 'auto',
91  `hierarchy` varchar(10) default 'auto',
92  `hp_code_rate` varchar(10) default 'auto',
93  `sistandard` varchar(10) default 'dvb',
94  `serviceversion` smallint(6) default '33',
95  `updatetimestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
96  PRIMARY KEY  (`mplexid`)
97) ENGINE=MyISAM DEFAULT CHARSET=latin1;
98
99--
100-- Dumping data for table `dtv_multiplex`
101--
102
103
104/*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */;
105LOCK TABLES `dtv_multiplex` WRITE;
106UNLOCK TABLES;
107/*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */;
108
109--
110-- Table structure for table `channel`
111--
112
113DROP TABLE IF EXISTS `channel`;
114CREATE TABLE `channel` (
115  `chanid` int(10) unsigned NOT NULL default '0',
116  `channum` varchar(10) NOT NULL default '',
117  `freqid` varchar(10) default NULL,
118  `sourceid` int(10) unsigned default NULL,
119  `callsign` varchar(20) NOT NULL default '',
120  `name` varchar(64) NOT NULL default '',
121  `icon` varchar(255) NOT NULL default 'none',
122  `finetune` int(11) default NULL,
123  `videofilters` varchar(255) NOT NULL default '',
124  `xmltvid` varchar(64) NOT NULL default '',
125  `recpriority` int(10) NOT NULL default '0',
126  `contrast` int(11) default '32768',
127  `brightness` int(11) default '32768',
128  `colour` int(11) default '32768',
129  `hue` int(11) default '32768',
130  `tvformat` varchar(10) NOT NULL default 'Default',
131  `commfree` tinyint(4) NOT NULL default '0',
132  `visible` tinyint(1) NOT NULL default '1',
133  `outputfilters` varchar(255) NOT NULL default '',
134  `useonairguide` tinyint(1) default '0',
135  `mplexid` smallint(6) default NULL,
136  `serviceid` mediumint(8) unsigned default NULL,
137  `atscsrcid` int(11) default NULL,
138  `tmoffset` int(11) NOT NULL default '0',
139  `atsc_major_chan` int(10) unsigned NOT NULL default '0',
140  `atsc_minor_chan` int(10) unsigned NOT NULL default '0',
141  PRIMARY KEY  (`chanid`),
142  KEY `channel_src` (`channum`,`sourceid`)
143) ENGINE=MyISAM DEFAULT CHARSET=latin1;
144
145--
146-- Dumping data for table `channel`
147--
148
149
150/*!40000 ALTER TABLE `channel` DISABLE KEYS */;
151LOCK TABLES `channel` WRITE;
152INSERT INTO `channel` VALUES (1050,'5.0','50',1,'KCEC','KCEC','',0,'','10371',0,32768,32768,32768,32768,'Default',0,1,'',1,32767,0,NULL,0,50,0),(1071,'7.1','17',1,'KMGHDT','KMGHDT (KMGH-DT)','',0,'','20293',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,17,0),(1021,'2.1','34',1,'KWGNDT','KWGNDT (KWGN-DT)','',0,'','20370',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,34,0),(1041,'4.1','35',1,'KCNCDT','KCNCDT (KCNC-DT)','',0,'','21297',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,35,0),(1091,'9.1','16',1,'KUSADT','KUSADT (KUSA-DT)','',0,'','21298',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,16,0),(1311,'31.1','32',1,'KDVRDT','KDVRDT (KDVR-DT)','',0,'','21319',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,32,0),(1061,'6.1','18',1,'KRMADT','KRMADT (KRMA-DT)','',0,'','21723',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,18,0),(1531,'53.1','46',1,'KWHDDT','KWHDDT (KWHD-DT)','',0,'','35650',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,46,0),(1123,'12.3','38',1,'KBDIDT3','KBDIDT3 (KBDI-DT3)','',0,'','35816',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,38,0),(1122,'12.2','38',1,'KBDIDT2','KBDIDT2 (KBDI-DT2)','',0,'','35818',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,38,0),(1121,'12.1','38',1,'KBDIDT','KBDIDT (KBDI-DT)','',0,'','35856',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,38,0),(1022,'2.2','34',1,'KWGNDT2','KWGNDT2 (KWGN-DT2)','',0,'','43074',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,34,0),(1092,'9.2','16',1,'KUSADT2','KUSADT2 (KUSA-DT2)','',0,'','46171',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,16,0),(2064,'64','64',2,'AMC','AMC','/root/.mythtv/channels/amc_30.jpg',0,'','10021',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,64,0),(2095,'95','95',2,'BET','Black Entertainment Television','',0,'','10051',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,95,0),(2057,'57','57',2,'CSPAN','Cable Satellite Public Affairs Network','/root/.mythtv/channels/cspan_30.jpg',0,'','10161',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,57,0),(2096,'96','96',2,'CSPAN2','Cable Satellite Public Affairs Network 2','',0,'','10162',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,96,0),(2012,'12','12',2,'KBDI','KBDI','/root/.mythtv/channels/pbs_30.jpg',0,'','10342',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,12,0),(2004,'4','4',2,'KCNC','KCNC','/root/.mythtv/channels/cbs_30.jpg',0,'','10380',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,4,0),(2013,'13','13',2,'KDVR','KDVR','/root/.mythtv/channels/fox_30.jpg',0,'','10422',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,13,0),(2007,'7','7',2,'KMGH','KMGH','/root/.mythtv/channels/abc_30.jpg',0,'','10567',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,7,0),(2006,'6','6',2,'KRMA','KRMA','/root/.mythtv/channels/pbs_30.jpg',0,'','10669',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,6,0),(2003,'3','3',2,'KTVD','KTVD','/root/.mythtv/channels/upn_30.jpg',0,'','10748',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,3,0),(2017,'17','17',2,'KPXC','KPXC','/root/.mythtv/channels/i.jpg',0,'','10771',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,17,0),(2009,'9','9',2,'KUSA','KUSA','/root/.mythtv/channels/nbc_30.jpg',0,'','10780',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,9,0),(2002,'2','2',2,'KWGN','KWGN','/root/.mythtv/channels/wb_30.jpg',0,'','10816',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,2,0),(2053,'53','53',2,'KWHD','KWHD','',0,'','10818',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,53,0),(2048,'48','48',2,'SCIFI','Sci-Fi Channel','',0,'','11097',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,48,0),(2011,'11','11',2,'DSC','The Discovery Channel','/root/.mythtv/channels/discoverychannel_30.jpg',0,'','11150',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,11,0),(2022,'22','22',2,'TLC','The Learning Channel','/root/.mythtv/channels/tlc.jpg',0,'','11158',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,22,0),(2058,'58','58',2,'HALMRK','Hallmark Channel','',0,'','11221',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,58,0),(2049,'49','49',2,'TBS','Turner Broadcasting System','/root/.mythtv/channels/tbs_30.jpg',0,'','11867',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,49,0),(2047,'47','47',2,'FOOD','Food Network','',0,'','12574',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,47,0),(2077,'77','77',2,'SPEED','Speed Channel','',0,'','16011',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,77,0),(2078,'78','78',2,'TVLAND','TV Land','',0,'','16123',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,78,0),(2059,'59','59',2,'FITV','Fit Tv','',0,'','16125',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,59,0),(2065,'65','65',2,'MSNBC','MSNBC','/root/.mythtv/channels/msnbc.jpg',0,'','16300',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,65,0),(2099,'99','99',2,'TVGC','TV Guide Channel','',0,'','16715',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,99,0),(2052,'52','52',2,'WGNSAT','WGN/UVTV Satellite Group','/root/.mythtv/channels/sswgn30x30.jpg',0,'','17098',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,52,0),(2020,'20','20',2,'KDEN','KDEN','',0,'','18082',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,20,0),(2100,'22','22',2,'EDAC022','Educational Access - EDAC022','',0,'','22136',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,22,0),(2008,'8','8',2,'GOAC008','Government Access - GOAC008','',0,'','22221',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,8,0),(2005,'5','5',2,'LOOR005','Local Origination - LOOR005','',0,'','23313',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,5,0),(2054,'54','54',2,'PUAC054','Public Access - PUAC054','',0,'','23529',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,54,0),(2061,'61','61',2,'LEAC061','Leased Access - LEAC061','',0,'','23736',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,61,0),(2051,'51','51',2,'KZCSLP','KZCSLP','',0,'','46256',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,51,0);
153UNLOCK TABLES;
154/*!40000 ALTER TABLE `channel` ENABLE KEYS */;
155
156--
157-- Table structure for table `cardinput`
158--
159
160DROP TABLE IF EXISTS `cardinput`;
161CREATE TABLE `cardinput` (
162  `cardinputid` int(10) unsigned NOT NULL auto_increment,
163  `cardid` int(10) unsigned NOT NULL default '0',
164  `sourceid` int(10) unsigned NOT NULL default '0',
165  `inputname` varchar(32) NOT NULL default '',
166  `externalcommand` varchar(128) default NULL,
167  `preference` int(11) NOT NULL default '0',
168  `shareable` char(1) default 'N',
169  `tunechan` varchar(5) NOT NULL default '',
170  `startchan` varchar(5) NOT NULL default '',
171  `freetoaironly` tinyint(1) default '1',
172  `diseqc_port` smallint(6) default NULL,
173  `diseqc_pos` float default NULL,
174  `lnb_lof_switch` int(11) default '11700000',
175  `lnb_lof_hi` int(11) default '10600000',
176  `lnb_lof_lo` int(11) default '9750000',
177  `displayname` varchar(64) NOT NULL default '',
178  `radioservices` tinyint(1) default '1',
179  `childcardid` int(10) NOT NULL default '0',
180  `dishnet_eit` tinyint(1) NOT NULL default '0',
181  `recpriority` int(11) NOT NULL default '0',
182  PRIMARY KEY  (`cardinputid`)
183) ENGINE=MyISAM DEFAULT CHARSET=latin1;
184
185--
186-- Dumping data for table `cardinput`
187--
188
189
190/*!40000 ALTER TABLE `cardinput` DISABLE KEYS */;
191LOCK TABLES `cardinput` WRITE;
192INSERT INTO `cardinput` VALUES (1,1,2,'Television','',0,'N','','64',1,NULL,NULL,11700000,10600000,9750000,'',1,0,0,0),(2,2,1,'DVBInput',NULL,0,'N','','2.1',1,NULL,NULL,11700000,10600000,9750000,'',1,0,0,1);
193UNLOCK TABLES;
194/*!40000 ALTER TABLE `cardinput` ENABLE KEYS */;
195
196/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
197/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
198/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
199/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
200/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
201/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
202/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
203