Ticket #2084: tables.sql.2.txt
File tables.sql.2.txt, 13.8 KB (added by , 18 years ago) |
---|
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 | |
20 | DROP TABLE IF EXISTS `capturecard`; |
21 | CREATE 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 */; |
64 | LOCK TABLES `capturecard` WRITE; |
65 | INSERT 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); |
66 | UNLOCK TABLES; |
67 | /*!40000 ALTER TABLE `capturecard` ENABLE KEYS */; |
68 | |
69 | -- |
70 | -- Table structure for table `dtv_multiplex` |
71 | -- |
72 | |
73 | DROP TABLE IF EXISTS `dtv_multiplex`; |
74 | CREATE 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 */; |
105 | LOCK TABLES `dtv_multiplex` WRITE; |
106 | UNLOCK TABLES; |
107 | /*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */; |
108 | |
109 | -- |
110 | -- Table structure for table `channel` |
111 | -- |
112 | |
113 | DROP TABLE IF EXISTS `channel`; |
114 | CREATE 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 */; |
151 | LOCK TABLES `channel` WRITE; |
152 | INSERT 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); |
153 | UNLOCK TABLES; |
154 | /*!40000 ALTER TABLE `channel` ENABLE KEYS */; |
155 | |
156 | -- |
157 | -- Table structure for table `cardinput` |
158 | -- |
159 | |
160 | DROP TABLE IF EXISTS `cardinput`; |
161 | CREATE 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 */; |
191 | LOCK TABLES `cardinput` WRITE; |
192 | INSERT 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); |
193 | UNLOCK 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 |