Ticket #2142: mythconverg.2.sql

File mythconverg.2.sql, 54.2 KB (added by panzaeron, 19 years ago)
Line 
1-- MySQL dump 10.10
2--
3-- Host: localhost Database: mythconverg
4-- ------------------------------------------------------
5-- Server version 5.0.22
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/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `callsignnetworkmap`
20--
21
22DROP TABLE IF EXISTS `callsignnetworkmap`;
23CREATE TABLE `callsignnetworkmap` (
24 `id` int(11) NOT NULL auto_increment,
25 `callsign` varchar(20) NOT NULL default '',
26 `network` varchar(20) NOT NULL default '',
27 PRIMARY KEY (`id`),
28 UNIQUE KEY `callsign` (`callsign`)
29) ENGINE=MyISAM DEFAULT CHARSET=latin1;
30
31--
32-- Dumping data for table `callsignnetworkmap`
33--
34
35
36/*!40000 ALTER TABLE `callsignnetworkmap` DISABLE KEYS */;
37LOCK TABLES `callsignnetworkmap` WRITE;
38UNLOCK TABLES;
39/*!40000 ALTER TABLE `callsignnetworkmap` ENABLE KEYS */;
40
41--
42-- Table structure for table `capturecard`
43--
44
45DROP TABLE IF EXISTS `capturecard`;
46CREATE TABLE `capturecard` (
47 `cardid` int(10) unsigned NOT NULL auto_increment,
48 `videodevice` varchar(128) default NULL,
49 `audiodevice` varchar(128) default NULL,
50 `vbidevice` varchar(128) default NULL,
51 `cardtype` varchar(32) default 'V4L',
52 `defaultinput` varchar(32) default 'Television',
53 `audioratelimit` int(11) default NULL,
54 `hostname` varchar(255) default NULL,
55 `dvb_swfilter` int(11) default '0',
56 `dvb_recordts` int(11) default '1',
57 `dvb_sat_type` int(11) NOT NULL default '0',
58 `dvb_wait_for_seqstart` int(11) NOT NULL default '1',
59 `skipbtaudio` tinyint(1) default '0',
60 `dvb_on_demand` tinyint(4) NOT NULL default '0',
61 `dvb_diseqc_type` smallint(6) default NULL,
62 `firewire_port` int(10) unsigned NOT NULL default '0',
63 `firewire_node` int(10) unsigned NOT NULL default '2',
64 `firewire_speed` int(10) unsigned NOT NULL default '0',
65 `firewire_model` varchar(32) default NULL,
66 `firewire_connection` int(10) unsigned NOT NULL default '0',
67 `dvb_hw_decoder` int(11) default '0',
68 `dbox2_port` int(10) unsigned NOT NULL default '31338',
69 `dbox2_httpport` int(10) unsigned NOT NULL default '80',
70 `dbox2_host` varchar(32) default NULL,
71 `signal_timeout` int(11) NOT NULL default '1000',
72 `channel_timeout` int(11) NOT NULL default '3000',
73 `parentid` int(10) NOT NULL default '0',
74 `dvb_tuning_delay` int(10) unsigned NOT NULL default '0',
75 `contrast` int(11) NOT NULL default '0',
76 `brightness` int(11) NOT NULL default '0',
77 `colour` int(11) NOT NULL default '0',
78 `hue` int(11) NOT NULL default '0',
79 `diseqcid` int(10) unsigned default NULL,
80 PRIMARY KEY (`cardid`)
81) ENGINE=MyISAM DEFAULT CHARSET=latin1;
82
83--
84-- Dumping data for table `capturecard`
85--
86
87
88/*!40000 ALTER TABLE `capturecard` DISABLE KEYS */;
89LOCK TABLES `capturecard` WRITE;
90INSERT INTO `capturecard` VALUES (1,'0','','','DVB','DVBInput #1',NULL,'zenslack',0,1,0,1,0,0,NULL,0,2,0,NULL,0,0,31338,80,NULL,60000,62500,0,0,0,0,0,0,1);
91UNLOCK TABLES;
92/*!40000 ALTER TABLE `capturecard` ENABLE KEYS */;
93
94--
95-- Table structure for table `cardinput`
96--
97
98DROP TABLE IF EXISTS `cardinput`;
99CREATE TABLE `cardinput` (
100 `cardinputid` int(10) unsigned NOT NULL auto_increment,
101 `cardid` int(10) unsigned NOT NULL default '0',
102 `sourceid` int(10) unsigned NOT NULL default '0',
103 `inputname` varchar(32) NOT NULL default '',
104 `externalcommand` varchar(128) default NULL,
105 `preference` int(11) NOT NULL default '0',
106 `shareable` char(1) default 'N',
107 `tunechan` varchar(10) default NULL,
108 `startchan` varchar(10) default NULL,
109 `freetoaironly` tinyint(1) default '1',
110 `diseqc_port` smallint(6) default NULL,
111 `diseqc_pos` float default NULL,
112 `lnb_lof_switch` int(11) default '11700000',
113 `lnb_lof_hi` int(11) default '10600000',
114 `lnb_lof_lo` int(11) default '9750000',
115 `displayname` varchar(64) NOT NULL default '',
116 `radioservices` tinyint(1) default '1',
117 `childcardid` int(10) NOT NULL default '0',
118 `dishnet_eit` tinyint(1) NOT NULL default '0',
119 `recpriority` int(11) NOT NULL default '0',
120 PRIMARY KEY (`cardinputid`)
121) ENGINE=MyISAM DEFAULT CHARSET=latin1;
122
123--
124-- Dumping data for table `cardinput`
125--
126
127
128/*!40000 ALTER TABLE `cardinput` DISABLE KEYS */;
129LOCK TABLES `cardinput` WRITE;
130INSERT INTO `cardinput` VALUES (1,1,1,'DVBInput',NULL,0,'N',NULL,'1',0,NULL,NULL,11700000,10600000,9750000,'',1,0,0,0);
131UNLOCK TABLES;
132/*!40000 ALTER TABLE `cardinput` ENABLE KEYS */;
133
134--
135-- Table structure for table `channel`
136--
137
138DROP TABLE IF EXISTS `channel`;
139CREATE TABLE `channel` (
140 `chanid` int(10) unsigned NOT NULL default '0',
141 `channum` varchar(10) NOT NULL default '',
142 `freqid` varchar(10) default NULL,
143 `sourceid` int(10) unsigned default NULL,
144 `callsign` varchar(20) NOT NULL default '',
145 `name` varchar(64) NOT NULL default '',
146 `icon` varchar(255) NOT NULL default 'none',
147 `finetune` int(11) default NULL,
148 `videofilters` varchar(255) NOT NULL default '',
149 `xmltvid` varchar(64) NOT NULL default '',
150 `recpriority` int(10) NOT NULL default '0',
151 `contrast` int(11) default '32768',
152 `brightness` int(11) default '32768',
153 `colour` int(11) default '32768',
154 `hue` int(11) default '32768',
155 `tvformat` varchar(10) NOT NULL default 'Default',
156 `commfree` tinyint(4) NOT NULL default '0',
157 `visible` tinyint(1) NOT NULL default '1',
158 `outputfilters` varchar(255) NOT NULL default '',
159 `useonairguide` tinyint(1) default '0',
160 `mplexid` smallint(6) default NULL,
161 `serviceid` mediumint(8) unsigned default NULL,
162 `atscsrcid` int(11) default NULL,
163 `tmoffset` int(11) NOT NULL default '0',
164 `atsc_major_chan` int(10) unsigned NOT NULL default '0',
165 `atsc_minor_chan` int(10) unsigned NOT NULL default '0',
166 PRIMARY KEY (`chanid`),
167 KEY `channel_src` (`channum`,`sourceid`)
168) ENGINE=MyISAM DEFAULT CHARSET=latin1;
169
170--
171-- Dumping data for table `channel`
172--
173
174
175/*!40000 ALTER TABLE `channel` DISABLE KEYS */;
176LOCK TABLES `channel` WRITE;
177INSERT INTO `channel` VALUES (29130,'28130',NULL,1,'Test-R','Test-R','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',0,33,28130,NULL,0,0,0),(29107,'28107',NULL,1,'Bayerisches FS','Bayerisches FS','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28107,NULL,0,0,0),(29111,'28111',NULL,1,'WDR Köln','WDR Köln','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28111,NULL,0,0,0),(29109,'28109',NULL,1,'arte','arte','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28109,NULL,0,0,0),(29106,'1',NULL,1,'Das Erste','Das Erste','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28106,NULL,0,0,0),(29108,'28108',NULL,1,'hr-fernsehen','hr-fernsehen','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28108,NULL,0,0,0),(29112,'28112',NULL,1,'BR-alpha','BR-alpha','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28112,NULL,0,0,0),(29113,'28113',NULL,1,'SÜDWEST Ferns. BW','SÜDWEST Ferns. BW','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28113,NULL,0,0,0),(29114,'28114',NULL,1,'Phoenix','Phoenix','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28114,NULL,0,0,0),(29007,'28007',NULL,1,'3sat','3sat','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28007,NULL,0,0,0),(29012,'28012',NULL,1,'DKULTUR','DKULTUR','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28012,NULL,0,0,0),(29013,'28013',NULL,1,'DLF','DLF','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28013,NULL,0,0,0),(29008,'28008',NULL,1,'KiKa','KiKa','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28008,NULL,0,0,0),(29006,'2',NULL,1,'ZDF','ZDF','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28006,NULL,0,0,0),(29014,'28014',NULL,1,'ZDFdokukanal','ZDFdokukanal','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28014,NULL,0,0,0),(29011,'28011',NULL,1,'ZDFinfokanal','ZDFinfokanal','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28011,NULL,0,0,0),(29016,'28016',NULL,1,'ZDFtheaterkanal','ZDFtheaterkanal','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28016,NULL,0,0,0);
178UNLOCK TABLES;
179/*!40000 ALTER TABLE `channel` ENABLE KEYS */;
180
181--
182-- Table structure for table `codecparams`
183--
184
185DROP TABLE IF EXISTS `codecparams`;
186CREATE TABLE `codecparams` (
187 `profile` int(10) unsigned NOT NULL default '0',
188 `name` varchar(128) NOT NULL default '',
189 `value` varchar(128) default NULL,
190 PRIMARY KEY (`profile`,`name`)
191) ENGINE=MyISAM DEFAULT CHARSET=latin1;
192
193--
194-- Dumping data for table `codecparams`
195--
196
197
198/*!40000 ALTER TABLE `codecparams` DISABLE KEYS */;
199LOCK TABLES `codecparams` WRITE;
200UNLOCK TABLES;
201/*!40000 ALTER TABLE `codecparams` ENABLE KEYS */;
202
203--
204-- Table structure for table `credits`
205--
206
207DROP TABLE IF EXISTS `credits`;
208CREATE TABLE `credits` (
209 `person` mediumint(8) unsigned NOT NULL default '0',
210 `chanid` int(10) unsigned NOT NULL default '0',
211 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
212 `role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '',
213 UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),
214 KEY `person` (`person`,`role`)
215) ENGINE=MyISAM DEFAULT CHARSET=latin1;
216
217--
218-- Dumping data for table `credits`
219--
220
221
222/*!40000 ALTER TABLE `credits` DISABLE KEYS */;
223LOCK TABLES `credits` WRITE;
224UNLOCK TABLES;
225/*!40000 ALTER TABLE `credits` ENABLE KEYS */;
226
227--
228-- Table structure for table `customexample`
229--
230
231DROP TABLE IF EXISTS `customexample`;
232CREATE TABLE `customexample` (
233 `rulename` varchar(64) NOT NULL,
234 `fromclause` text NOT NULL,
235 `whereclause` text NOT NULL,
236 PRIMARY KEY (`rulename`)
237) ENGINE=MyISAM DEFAULT CHARSET=latin1;
238
239--
240-- Dumping data for table `customexample`
241--
242
243
244/*!40000 ALTER TABLE `customexample` DISABLE KEYS */;
245LOCK TABLES `customexample` WRITE;
246UNLOCK TABLES;
247/*!40000 ALTER TABLE `customexample` ENABLE KEYS */;
248
249--
250-- Table structure for table `diseqc_config`
251--
252
253DROP TABLE IF EXISTS `diseqc_config`;
254CREATE TABLE `diseqc_config` (
255 `cardinputid` int(10) unsigned NOT NULL,
256 `diseqcid` int(10) unsigned NOT NULL,
257 `value` varchar(16) NOT NULL default '',
258 KEY `id` (`cardinputid`)
259) ENGINE=MyISAM DEFAULT CHARSET=latin1;
260
261--
262-- Dumping data for table `diseqc_config`
263--
264
265
266/*!40000 ALTER TABLE `diseqc_config` DISABLE KEYS */;
267LOCK TABLES `diseqc_config` WRITE;
268UNLOCK TABLES;
269/*!40000 ALTER TABLE `diseqc_config` ENABLE KEYS */;
270
271--
272-- Table structure for table `diseqc_tree`
273--
274
275DROP TABLE IF EXISTS `diseqc_tree`;
276CREATE TABLE `diseqc_tree` (
277 `diseqcid` int(10) unsigned NOT NULL auto_increment,
278 `parentid` int(10) unsigned default NULL,
279 `ordinal` tinyint(3) unsigned NOT NULL,
280 `type` varchar(16) NOT NULL default '',
281 `subtype` varchar(16) NOT NULL default '',
282 `description` varchar(32) NOT NULL default '',
283 `switch_ports` tinyint(3) unsigned NOT NULL default '0',
284 `rotor_hi_speed` float NOT NULL default '0',
285 `rotor_lo_speed` float NOT NULL default '0',
286 `rotor_positions` varchar(255) NOT NULL default '',
287 `lnb_lof_switch` int(10) NOT NULL default '0',
288 `lnb_lof_hi` int(10) NOT NULL default '0',
289 `lnb_lof_lo` int(10) NOT NULL default '0',
290 PRIMARY KEY (`diseqcid`),
291 KEY `parentid` (`parentid`)
292) ENGINE=MyISAM DEFAULT CHARSET=latin1;
293
294--
295-- Dumping data for table `diseqc_tree`
296--
297
298
299/*!40000 ALTER TABLE `diseqc_tree` DISABLE KEYS */;
300LOCK TABLES `diseqc_tree` WRITE;
301INSERT INTO `diseqc_tree` VALUES (1,NULL,0,'lnb','voltage_tone','LNB',0,0,0,'',11700000,10600000,9750000);
302UNLOCK TABLES;
303/*!40000 ALTER TABLE `diseqc_tree` ENABLE KEYS */;
304
305--
306-- Table structure for table `dtv_multiplex`
307--
308
309DROP TABLE IF EXISTS `dtv_multiplex`;
310CREATE TABLE `dtv_multiplex` (
311 `mplexid` smallint(6) NOT NULL auto_increment,
312 `sourceid` smallint(6) default NULL,
313 `transportid` int(11) default NULL,
314 `networkid` int(11) default NULL,
315 `frequency` int(11) default NULL,
316 `inversion` char(1) default 'a',
317 `symbolrate` int(11) default NULL,
318 `fec` varchar(10) default 'auto',
319 `polarity` char(1) default NULL,
320 `modulation` varchar(10) default 'auto',
321 `bandwidth` char(1) default 'a',
322 `lp_code_rate` varchar(10) default 'auto',
323 `transmission_mode` char(1) default 'a',
324 `guard_interval` varchar(10) default 'auto',
325 `visible` smallint(1) NOT NULL default '0',
326 `constellation` varchar(10) default 'auto',
327 `hierarchy` varchar(10) default 'auto',
328 `hp_code_rate` varchar(10) default 'auto',
329 `sistandard` varchar(10) default 'dvb',
330 `serviceversion` smallint(6) default '33',
331 `updatetimestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
332 PRIMARY KEY (`mplexid`)
333) ENGINE=MyISAM DEFAULT CHARSET=latin1;
334
335--
336-- Dumping data for table `dtv_multiplex`
337--
338
339
340/*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */;
341LOCK TABLES `dtv_multiplex` WRITE;
342INSERT INTO `dtv_multiplex` VALUES (1,1,1,133,12070500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(2,1,2,133,11797500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(3,1,3,133,11719500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(4,1,4,133,12031500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(5,1,5,133,12460500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(6,1,7,133,12148500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(7,1,17,133,11758500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(8,1,33,133,12480000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(9,1,1119,1,12721500,'a',22000000,'2/3','h','auto',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(10,1,1092,1,12246000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(11,1,1024,1,11567500,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(12,1,1066,1,11739000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(13,1,1068,1,11778000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(14,1,1070,1,11817000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(15,1,1113,1,12633250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(16,1,1074,1,11895000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(17,1,1076,1,11934000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(18,1,1078,1,11973000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(19,1,1079,1,1359440,NULL,NULL,NULL,NULL,'auto',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',3,'2006-08-09 21:34:04'),(20,1,1080,1,12012000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(21,1,1082,1,12051000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(22,1,1086,1,12129000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(23,1,1089,1,12187500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(24,1,1059,1,10861750,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(25,1,1090,1,12207000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(26,1,1091,1,12226500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(27,1,1094,1,12285000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(28,1,1095,1,12304500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(29,1,1096,1,12324000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(30,1,1097,53,12343500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(31,1,1098,1,12363050,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(32,1,1099,1,12382500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(33,1,1101,1,11836500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',19,'2006-08-09 21:34:04'),(34,1,1201,1,12421500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(35,1,1100,1,12402000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(36,1,1105,53,12515250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(37,1,1108,1,12551500,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(38,1,1109,53,12574250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(39,1,1073,1,12109500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(40,1,1057,1,10832250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(41,1,1116,1,12669500,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(42,1,1111,1,12603750,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(43,1,1008,1,11317500,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(44,1,1026,1,11597000,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(45,1,1038,1,11038000,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(46,1,1046,1,11156000,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(47,1,1279,1,11992500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(48,1,1117,1,12692250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53');
343UNLOCK TABLES;
344/*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */;
345
346--
347-- Table structure for table `dtv_privatetypes`
348--
349
350DROP TABLE IF EXISTS `dtv_privatetypes`;
351CREATE TABLE `dtv_privatetypes` (
352 `sitype` varchar(4) NOT NULL default '',
353 `networkid` int(11) NOT NULL default '0',
354 `private_type` varchar(20) NOT NULL default '',
355 `private_value` varchar(100) NOT NULL default ''
356) ENGINE=MyISAM DEFAULT CHARSET=latin1;
357
358--
359-- Dumping data for table `dtv_privatetypes`
360--
361
362
363/*!40000 ALTER TABLE `dtv_privatetypes` DISABLE KEYS */;
364LOCK TABLES `dtv_privatetypes` WRITE;
365INSERT INTO `dtv_privatetypes` VALUES ('dvb',9018,'channel_numbers','131'),('dvb',9018,'guide_fixup','2'),('dvb',256,'guide_fixup','1'),('dvb',257,'guide_fixup','1'),('dvb',256,'tv_types','1,150,134,133'),('dvb',257,'tv_types','1,150,134,133'),('dvb',4100,'sdt_mapping','1'),('dvb',4101,'sdt_mapping','1'),('dvb',4102,'sdt_mapping','1'),('dvb',4103,'sdt_mapping','1'),('dvb',4104,'sdt_mapping','1'),('dvb',4105,'sdt_mapping','1'),('dvb',4106,'sdt_mapping','1'),('dvb',4107,'sdt_mapping','1'),('dvb',4097,'sdt_mapping','1'),('dvb',4098,'sdt_mapping','1'),('dvb',4100,'tv_types','1,145,154'),('dvb',4101,'tv_types','1,145,154'),('dvb',4102,'tv_types','1,145,154'),('dvb',4103,'tv_types','1,145,154'),('dvb',4104,'tv_types','1,145,154'),('dvb',4105,'tv_types','1,145,154'),('dvb',4106,'tv_types','1,145,154'),('dvb',4107,'tv_types','1,145,154'),('dvb',4097,'tv_types','1,145,154'),('dvb',4098,'tv_types','1,145,154'),('dvb',4100,'guide_fixup','1'),('dvb',4101,'guide_fixup','1'),('dvb',4102,'guide_fixup','1'),('dvb',4103,'guide_fixup','1'),('dvb',4104,'guide_fixup','1'),('dvb',4105,'guide_fixup','1'),('dvb',4106,'guide_fixup','1'),('dvb',4107,'guide_fixup','1'),('dvb',4096,'guide_fixup','5'),('dvb',4097,'guide_fixup','1'),('dvb',4098,'guide_fixup','1'),('dvb',94,'tv_types','1,128'),('atsc',1793,'guide_fixup','3'),('dvb',40999,'guide_fixup','4'),('dvb',70,'force_guide_present','yes'),('dvb',70,'guide_ranges','80,80,96,96'),('dvb',4112,'channel_numbers','131'),('dvb',4115,'channel_numbers','131'),('dvb',4116,'channel_numbers','131'),('dvb',12802,'channel_numbers','131'),('dvb',12803,'channel_numbers','131'),('dvb',12829,'channel_numbers','131'),('dvb',40999,'parse_subtitle_list','1070,1308,1041,1306,1307,1030,1016,1131,1068,1069'),('dvb',4096,'guide_fixup','5');
366UNLOCK TABLES;
367/*!40000 ALTER TABLE `dtv_privatetypes` ENABLE KEYS */;
368
369--
370-- Table structure for table `eit_cache`
371--
372
373DROP TABLE IF EXISTS `eit_cache`;
374CREATE TABLE `eit_cache` (
375 `chanid` int(10) NOT NULL,
376 `eventid` smallint(5) unsigned NOT NULL,
377 `tableid` tinyint(3) unsigned NOT NULL,
378 `version` tinyint(3) unsigned NOT NULL,
379 `endtime` int(10) unsigned NOT NULL,
380 PRIMARY KEY (`chanid`,`eventid`)
381) ENGINE=MyISAM DEFAULT CHARSET=latin1;
382
383--
384-- Dumping data for table `eit_cache`
385--
386
387
388/*!40000 ALTER TABLE `eit_cache` DISABLE KEYS */;
389LOCK TABLES `eit_cache` WRITE;
390UNLOCK TABLES;
391/*!40000 ALTER TABLE `eit_cache` ENABLE KEYS */;
392
393--
394-- Table structure for table `favorites`
395--
396
397DROP TABLE IF EXISTS `favorites`;
398CREATE TABLE `favorites` (
399 `favid` int(11) unsigned NOT NULL auto_increment,
400 `userid` int(11) unsigned NOT NULL default '0',
401 `chanid` int(11) unsigned NOT NULL default '0',
402 PRIMARY KEY (`favid`)
403) ENGINE=MyISAM DEFAULT CHARSET=latin1;
404
405--
406-- Dumping data for table `favorites`
407--
408
409
410/*!40000 ALTER TABLE `favorites` DISABLE KEYS */;
411LOCK TABLES `favorites` WRITE;
412UNLOCK TABLES;
413/*!40000 ALTER TABLE `favorites` ENABLE KEYS */;
414
415--
416-- Table structure for table `housekeeping`
417--
418
419DROP TABLE IF EXISTS `housekeeping`;
420CREATE TABLE `housekeeping` (
421 `tag` varchar(64) NOT NULL default '',
422 `lastrun` datetime default NULL,
423 PRIMARY KEY (`tag`)
424) ENGINE=MyISAM DEFAULT CHARSET=latin1;
425
426--
427-- Dumping data for table `housekeeping`
428--
429
430
431/*!40000 ALTER TABLE `housekeeping` DISABLE KEYS */;
432LOCK TABLES `housekeeping` WRITE;
433UNLOCK TABLES;
434/*!40000 ALTER TABLE `housekeeping` ENABLE KEYS */;
435
436--
437-- Table structure for table `inuseprograms`
438--
439
440DROP TABLE IF EXISTS `inuseprograms`;
441CREATE TABLE `inuseprograms` (
442 `chanid` int(10) unsigned NOT NULL default '0',
443 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
444 `recusage` varchar(128) NOT NULL default '',
445 `lastupdatetime` datetime NOT NULL default '0000-00-00 00:00:00',
446 `hostname` varchar(255) NOT NULL default '',
447 KEY `chanid` (`chanid`,`starttime`)
448) ENGINE=MyISAM DEFAULT CHARSET=latin1;
449
450--
451-- Dumping data for table `inuseprograms`
452--
453
454
455/*!40000 ALTER TABLE `inuseprograms` DISABLE KEYS */;
456LOCK TABLES `inuseprograms` WRITE;
457UNLOCK TABLES;
458/*!40000 ALTER TABLE `inuseprograms` ENABLE KEYS */;
459
460--
461-- Table structure for table `jobqueue`
462--
463
464DROP TABLE IF EXISTS `jobqueue`;
465CREATE TABLE `jobqueue` (
466 `id` int(11) NOT NULL auto_increment,
467 `chanid` int(10) NOT NULL default '0',
468 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
469 `inserttime` datetime NOT NULL default '0000-00-00 00:00:00',
470 `type` int(11) NOT NULL default '0',
471 `cmds` int(11) NOT NULL default '0',
472 `flags` int(11) NOT NULL default '0',
473 `status` int(11) NOT NULL default '0',
474 `statustime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
475 `hostname` varchar(255) NOT NULL default '',
476 `args` blob NOT NULL,
477 `comment` varchar(128) NOT NULL default '',
478 PRIMARY KEY (`id`),
479 UNIQUE KEY `chanid` (`chanid`,`starttime`,`type`,`inserttime`)
480) ENGINE=MyISAM DEFAULT CHARSET=latin1;
481
482--
483-- Dumping data for table `jobqueue`
484--
485
486
487/*!40000 ALTER TABLE `jobqueue` DISABLE KEYS */;
488LOCK TABLES `jobqueue` WRITE;
489UNLOCK TABLES;
490/*!40000 ALTER TABLE `jobqueue` ENABLE KEYS */;
491
492--
493-- Table structure for table `jumppoints`
494--
495
496DROP TABLE IF EXISTS `jumppoints`;
497CREATE TABLE `jumppoints` (
498 `destination` varchar(128) NOT NULL default '',
499 `description` varchar(255) default NULL,
500 `keylist` varchar(128) default NULL,
501 `hostname` varchar(255) NOT NULL default '',
502 PRIMARY KEY (`destination`,`hostname`)
503) ENGINE=MyISAM DEFAULT CHARSET=latin1;
504
505--
506-- Dumping data for table `jumppoints`
507--
508
509
510/*!40000 ALTER TABLE `jumppoints` DISABLE KEYS */;
511LOCK TABLES `jumppoints` WRITE;
512UNLOCK TABLES;
513/*!40000 ALTER TABLE `jumppoints` ENABLE KEYS */;
514
515--
516-- Table structure for table `keybindings`
517--
518
519DROP TABLE IF EXISTS `keybindings`;
520CREATE TABLE `keybindings` (
521 `context` varchar(32) NOT NULL default '',
522 `action` varchar(32) NOT NULL default '',
523 `description` varchar(255) default NULL,
524 `keylist` varchar(128) default NULL,
525 `hostname` varchar(255) NOT NULL default '',
526 PRIMARY KEY (`context`,`action`,`hostname`)
527) ENGINE=MyISAM DEFAULT CHARSET=latin1;
528
529--
530-- Dumping data for table `keybindings`
531--
532
533
534/*!40000 ALTER TABLE `keybindings` DISABLE KEYS */;
535LOCK TABLES `keybindings` WRITE;
536INSERT INTO `keybindings` VALUES ('Global','UP','Up Arrow','Up','zenslack'),('Global','DOWN','Down Arrow','Down','zenslack'),('Global','LEFT','Left Arrow','Left','zenslack'),('Global','RIGHT','Right Arrow','Right','zenslack'),('Global','SELECT','Select','Return,Enter,Space','zenslack'),('Global','ESCAPE','Escape','Esc','zenslack'),('Global','MENU','Pop-up menu','M','zenslack'),('Global','INFO','More information','I','zenslack'),('Global','PAGEUP','Page Up','PgUp','zenslack'),('Global','PAGEDOWN','Page Down','PgDown','zenslack'),('Global','PREVVIEW','Previous View','Home','zenslack'),('Global','NEXTVIEW','Next View','End','zenslack'),('Global','HELP','Help','F1','zenslack'),('Global','EJECT','Eject Removable Media','','zenslack'),('Global','0','0','0','zenslack'),('Global','1','1','1','zenslack'),('Global','2','2','2','zenslack'),('Global','3','3','3','zenslack'),('Global','4','4','4','zenslack'),('Global','5','5','5','zenslack'),('Global','6','6','6','zenslack'),('Global','7','7','7','zenslack'),('Global','8','8','8','zenslack'),('Global','9','9','9','zenslack'),('qt','DELETE','Delete','D','zenslack'),('qt','EDIT','Edit','E','zenslack');
537UNLOCK TABLES;
538/*!40000 ALTER TABLE `keybindings` ENABLE KEYS */;
539
540--
541-- Table structure for table `keyword`
542--
543
544DROP TABLE IF EXISTS `keyword`;
545CREATE TABLE `keyword` (
546 `phrase` varchar(128) NOT NULL default '',
547 `searchtype` int(10) unsigned NOT NULL default '3',
548 UNIQUE KEY `phrase` (`phrase`,`searchtype`)
549) ENGINE=MyISAM DEFAULT CHARSET=latin1;
550
551--
552-- Dumping data for table `keyword`
553--
554
555
556/*!40000 ALTER TABLE `keyword` DISABLE KEYS */;
557LOCK TABLES `keyword` WRITE;
558UNLOCK TABLES;
559/*!40000 ALTER TABLE `keyword` ENABLE KEYS */;
560
561--
562-- Table structure for table `mythlog`
563--
564
565DROP TABLE IF EXISTS `mythlog`;
566CREATE TABLE `mythlog` (
567 `logid` int(10) unsigned NOT NULL auto_increment,
568 `module` varchar(32) NOT NULL default '',
569 `priority` int(11) NOT NULL default '0',
570 `acknowledged` tinyint(1) default '0',
571 `logdate` datetime default NULL,
572 `host` varchar(128) default NULL,
573 `message` varchar(255) NOT NULL default '',
574 `details` text,
575 PRIMARY KEY (`logid`)
576) ENGINE=MyISAM DEFAULT CHARSET=latin1;
577
578--
579-- Dumping data for table `mythlog`
580--
581
582
583/*!40000 ALTER TABLE `mythlog` DISABLE KEYS */;
584LOCK TABLES `mythlog` WRITE;
585UNLOCK TABLES;
586/*!40000 ALTER TABLE `mythlog` ENABLE KEYS */;
587
588--
589-- Table structure for table `networkiconmap`
590--
591
592DROP TABLE IF EXISTS `networkiconmap`;
593CREATE TABLE `networkiconmap` (
594 `id` int(11) NOT NULL auto_increment,
595 `network` varchar(20) NOT NULL default '',
596 `url` varchar(255) NOT NULL default '',
597 PRIMARY KEY (`id`),
598 UNIQUE KEY `network` (`network`)
599) ENGINE=MyISAM DEFAULT CHARSET=latin1;
600
601--
602-- Dumping data for table `networkiconmap`
603--
604
605
606/*!40000 ALTER TABLE `networkiconmap` DISABLE KEYS */;
607LOCK TABLES `networkiconmap` WRITE;
608UNLOCK TABLES;
609/*!40000 ALTER TABLE `networkiconmap` ENABLE KEYS */;
610
611--
612-- Table structure for table `oldfind`
613--
614
615DROP TABLE IF EXISTS `oldfind`;
616CREATE TABLE `oldfind` (
617 `recordid` int(11) NOT NULL default '0',
618 `findid` int(11) NOT NULL default '0',
619 PRIMARY KEY (`recordid`,`findid`)
620) ENGINE=MyISAM DEFAULT CHARSET=latin1;
621
622--
623-- Dumping data for table `oldfind`
624--
625
626
627/*!40000 ALTER TABLE `oldfind` DISABLE KEYS */;
628LOCK TABLES `oldfind` WRITE;
629UNLOCK TABLES;
630/*!40000 ALTER TABLE `oldfind` ENABLE KEYS */;
631
632--
633-- Table structure for table `oldprogram`
634--
635
636DROP TABLE IF EXISTS `oldprogram`;
637CREATE TABLE `oldprogram` (
638 `oldtitle` varchar(128) NOT NULL default '',
639 `airdate` datetime NOT NULL default '0000-00-00 00:00:00',
640 PRIMARY KEY (`oldtitle`)
641) ENGINE=MyISAM DEFAULT CHARSET=latin1;
642
643--
644-- Dumping data for table `oldprogram`
645--
646
647
648/*!40000 ALTER TABLE `oldprogram` DISABLE KEYS */;
649LOCK TABLES `oldprogram` WRITE;
650UNLOCK TABLES;
651/*!40000 ALTER TABLE `oldprogram` ENABLE KEYS */;
652
653--
654-- Table structure for table `oldrecorded`
655--
656
657DROP TABLE IF EXISTS `oldrecorded`;
658CREATE TABLE `oldrecorded` (
659 `chanid` int(10) unsigned NOT NULL default '0',
660 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
661 `endtime` datetime NOT NULL default '0000-00-00 00:00:00',
662 `title` varchar(128) NOT NULL default '',
663 `subtitle` varchar(128) NOT NULL default '',
664 `description` text NOT NULL,
665 `category` varchar(64) NOT NULL default '',
666 `seriesid` varchar(12) NOT NULL default '',
667 `programid` varchar(20) NOT NULL default '',
668 `findid` int(11) NOT NULL default '0',
669 `recordid` int(11) NOT NULL default '0',
670 `station` varchar(20) NOT NULL default '',
671 `rectype` int(10) unsigned NOT NULL default '0',
672 `duplicate` tinyint(1) NOT NULL default '0',
673 `recstatus` int(11) NOT NULL default '0',
674 `reactivate` smallint(6) NOT NULL default '0',
675 `generic` tinyint(1) default '0',
676 PRIMARY KEY (`station`,`starttime`,`title`),
677 KEY `endtime` (`endtime`),
678 KEY `title` (`title`),
679 KEY `seriesid` (`seriesid`),
680 KEY `programid` (`programid`),
681 KEY `recordid` (`recordid`),
682 KEY `recstatus` (`recstatus`,`programid`,`seriesid`),
683 KEY `recstatus_2` (`recstatus`,`title`,`subtitle`)
684) ENGINE=MyISAM DEFAULT CHARSET=latin1;
685
686--
687-- Dumping data for table `oldrecorded`
688--
689
690
691/*!40000 ALTER TABLE `oldrecorded` DISABLE KEYS */;
692LOCK TABLES `oldrecorded` WRITE;
693UNLOCK TABLES;
694/*!40000 ALTER TABLE `oldrecorded` ENABLE KEYS */;
695
696--
697-- Table structure for table `people`
698--
699
700DROP TABLE IF EXISTS `people`;
701CREATE TABLE `people` (
702 `person` mediumint(8) unsigned NOT NULL auto_increment,
703 `name` char(128) NOT NULL default '',
704 PRIMARY KEY (`person`),
705 UNIQUE KEY `name` (`name`(41))
706) ENGINE=MyISAM DEFAULT CHARSET=latin1;
707
708--
709-- Dumping data for table `people`
710--
711
712
713/*!40000 ALTER TABLE `people` DISABLE KEYS */;
714LOCK TABLES `people` WRITE;
715UNLOCK TABLES;
716/*!40000 ALTER TABLE `people` ENABLE KEYS */;
717
718--
719-- Table structure for table `pidcache`
720--
721
722DROP TABLE IF EXISTS `pidcache`;
723CREATE TABLE `pidcache` (
724 `chanid` smallint(6) NOT NULL default '0',
725 `pid` int(11) NOT NULL default '-1',
726 `tableid` int(11) NOT NULL default '-1',
727 KEY `chanid` (`chanid`)
728) ENGINE=MyISAM DEFAULT CHARSET=latin1;
729
730--
731-- Dumping data for table `pidcache`
732--
733
734
735/*!40000 ALTER TABLE `pidcache` DISABLE KEYS */;
736LOCK TABLES `pidcache` WRITE;
737UNLOCK TABLES;
738/*!40000 ALTER TABLE `pidcache` ENABLE KEYS */;
739
740--
741-- Table structure for table `playgroup`
742--
743
744DROP TABLE IF EXISTS `playgroup`;
745CREATE TABLE `playgroup` (
746 `name` varchar(32) NOT NULL default '',
747 `titlematch` varchar(255) NOT NULL default '',
748 `skipahead` int(11) NOT NULL default '0',
749 `skipback` int(11) NOT NULL default '0',
750 `timestretch` int(11) NOT NULL default '0',
751 `jump` int(11) NOT NULL default '0',
752 PRIMARY KEY (`name`)
753) ENGINE=MyISAM DEFAULT CHARSET=latin1;
754
755--
756-- Dumping data for table `playgroup`
757--
758
759
760/*!40000 ALTER TABLE `playgroup` DISABLE KEYS */;
761LOCK TABLES `playgroup` WRITE;
762INSERT INTO `playgroup` VALUES ('Default','',30,5,100,0);
763UNLOCK TABLES;
764/*!40000 ALTER TABLE `playgroup` ENABLE KEYS */;
765
766--
767-- Table structure for table `profilegroups`
768--
769
770DROP TABLE IF EXISTS `profilegroups`;
771CREATE TABLE `profilegroups` (
772 `id` int(10) unsigned NOT NULL auto_increment,
773 `name` varchar(128) default NULL,
774 `cardtype` varchar(32) NOT NULL default 'V4L',
775 `is_default` int(1) default '0',
776 `hostname` varchar(255) default NULL,
777 PRIMARY KEY (`id`),
778 UNIQUE KEY `name` (`name`,`hostname`)
779) ENGINE=MyISAM DEFAULT CHARSET=latin1;
780
781--
782-- Dumping data for table `profilegroups`
783--
784
785
786/*!40000 ALTER TABLE `profilegroups` DISABLE KEYS */;
787LOCK TABLES `profilegroups` WRITE;
788INSERT INTO `profilegroups` VALUES (1,'Software Encoders (v4l based)','V4L',1,NULL),(2,'MPEG-2 Encoders (PVR-x50, PVR-500)','MPEG',1,NULL),(3,'Hardware MJPEG Encoders (Matrox G200-TV, Miro DC10, etc)','MJPEG',1,NULL),(4,'Hardware HDTV','HDTV',1,NULL),(5,'Hardware DVB Encoders','DVB',1,NULL),(6,'Transcoders','TRANSCODE',1,NULL),(7,'FireWire Input','FIREWIRE',1,NULL),(8,'USB Mpeg-4 Encoder (Plextor ConvertX, etc)','GO7007',1,NULL),(9,'DBOX2 Input','DBOX2',1,NULL),(10,'Freebox Input','Freebox',1,NULL),(11,'HDHomeRun Recorders','HDHOMERUN',1,NULL),(12,'CRC IP Recorders','CRC_IP',1,NULL);
789UNLOCK TABLES;
790/*!40000 ALTER TABLE `profilegroups` ENABLE KEYS */;
791
792--
793-- Table structure for table `program`
794--
795
796DROP TABLE IF EXISTS `program`;
797CREATE TABLE `program` (
798 `chanid` int(10) unsigned NOT NULL default '0',
799 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
800 `endtime` datetime NOT NULL default '0000-00-00 00:00:00',
801 `title` varchar(128) NOT NULL default '',
802 `subtitle` varchar(128) NOT NULL default '',
803 `description` text NOT NULL,
804 `category` varchar(64) NOT NULL default '',
805 `category_type` varchar(64) NOT NULL default '',
806 `airdate` year(4) NOT NULL default '0000',
807 `stars` float NOT NULL default '0',
808 `previouslyshown` tinyint(4) NOT NULL default '0',
809 `title_pronounce` varchar(128) NOT NULL default '',
810 `stereo` tinyint(1) NOT NULL default '0',
811 `subtitled` tinyint(1) NOT NULL default '0',
812 `hdtv` tinyint(1) NOT NULL default '0',
813 `closecaptioned` tinyint(1) NOT NULL default '0',
814 `partnumber` int(11) NOT NULL default '0',
815 `parttotal` int(11) NOT NULL default '0',
816 `seriesid` varchar(12) NOT NULL default '',
817 `originalairdate` date default NULL,
818 `showtype` varchar(30) NOT NULL default '',
819 `colorcode` varchar(20) NOT NULL default '',
820 `syndicatedepisodenumber` varchar(20) NOT NULL default '',
821 `programid` varchar(20) NOT NULL default '',
822 `manualid` int(10) unsigned NOT NULL default '0',
823 `generic` tinyint(1) default '0',
824 `listingsource` int(11) NOT NULL default '0',
825 `first` tinyint(1) NOT NULL default '0',
826 `last` tinyint(1) NOT NULL default '0',
827 PRIMARY KEY (`chanid`,`starttime`,`manualid`),
828 KEY `endtime` (`endtime`),
829 KEY `title` (`title`),
830 KEY `title_pronounce` (`title_pronounce`),
831 KEY `seriesid` (`seriesid`),
832 KEY `programid` (`programid`),
833 KEY `id_start_end` (`chanid`,`starttime`,`endtime`)
834) ENGINE=MyISAM DEFAULT CHARSET=latin1;
835
836--
837-- Dumping data for table `program`
838--
839
840
841/*!40000 ALTER TABLE `program` DISABLE KEYS */;
842LOCK TABLES `program` WRITE;
843UNLOCK TABLES;
844/*!40000 ALTER TABLE `program` ENABLE KEYS */;
845
846--
847-- Table structure for table `programgenres`
848--
849
850DROP TABLE IF EXISTS `programgenres`;
851CREATE TABLE `programgenres` (
852 `chanid` int(10) unsigned NOT NULL default '0',
853 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
854 `relevance` char(1) NOT NULL default '',
855 `genre` char(30) default NULL,
856 PRIMARY KEY (`chanid`,`starttime`,`relevance`),
857 KEY `genre` (`genre`)
858) ENGINE=MyISAM DEFAULT CHARSET=latin1;
859
860--
861-- Dumping data for table `programgenres`
862--
863
864
865/*!40000 ALTER TABLE `programgenres` DISABLE KEYS */;
866LOCK TABLES `programgenres` WRITE;
867UNLOCK TABLES;
868/*!40000 ALTER TABLE `programgenres` ENABLE KEYS */;
869
870--
871-- Table structure for table `programrating`
872--
873
874DROP TABLE IF EXISTS `programrating`;
875CREATE TABLE `programrating` (
876 `chanid` int(10) unsigned NOT NULL default '0',
877 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
878 `system` char(8) NOT NULL default '',
879 `rating` char(8) NOT NULL default '',
880 UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`),
881 KEY `starttime` (`starttime`,`system`)
882) ENGINE=MyISAM DEFAULT CHARSET=latin1;
883
884--
885-- Dumping data for table `programrating`
886--
887
888
889/*!40000 ALTER TABLE `programrating` DISABLE KEYS */;
890LOCK TABLES `programrating` WRITE;
891UNLOCK TABLES;
892/*!40000 ALTER TABLE `programrating` ENABLE KEYS */;
893
894--
895-- Table structure for table `recgrouppassword`
896--
897
898DROP TABLE IF EXISTS `recgrouppassword`;
899CREATE TABLE `recgrouppassword` (
900 `recgroup` varchar(32) NOT NULL default '',
901 `password` varchar(10) NOT NULL default '',
902 PRIMARY KEY (`recgroup`),
903 UNIQUE KEY `recgroup` (`recgroup`)
904) ENGINE=MyISAM DEFAULT CHARSET=latin1;
905
906--
907-- Dumping data for table `recgrouppassword`
908--
909
910
911/*!40000 ALTER TABLE `recgrouppassword` DISABLE KEYS */;
912LOCK TABLES `recgrouppassword` WRITE;
913UNLOCK TABLES;
914/*!40000 ALTER TABLE `recgrouppassword` ENABLE KEYS */;
915
916--
917-- Table structure for table `record`
918--
919
920DROP TABLE IF EXISTS `record`;
921CREATE TABLE `record` (
922 `recordid` int(10) unsigned NOT NULL auto_increment,
923 `type` int(10) unsigned NOT NULL default '0',
924 `chanid` int(10) unsigned default NULL,
925 `starttime` time NOT NULL default '00:00:00',
926 `startdate` date NOT NULL default '0000-00-00',
927 `endtime` time NOT NULL default '00:00:00',
928 `enddate` date NOT NULL default '0000-00-00',
929 `title` varchar(128) NOT NULL default '',
930 `subtitle` varchar(128) NOT NULL default '',
931 `description` text NOT NULL,
932 `category` varchar(64) NOT NULL default '',
933 `profile` varchar(128) NOT NULL default 'Default',
934 `recpriority` int(10) NOT NULL default '0',
935 `autoexpire` int(11) NOT NULL default '0',
936 `maxepisodes` int(11) NOT NULL default '0',
937 `maxnewest` int(11) NOT NULL default '0',
938 `startoffset` int(11) NOT NULL default '0',
939 `endoffset` int(11) NOT NULL default '0',
940 `recgroup` varchar(32) NOT NULL default 'Default',
941 `dupmethod` int(11) NOT NULL default '6',
942 `dupin` int(11) NOT NULL default '15',
943 `station` varchar(20) NOT NULL default '',
944 `seriesid` varchar(12) NOT NULL default '',
945 `programid` varchar(20) NOT NULL default '',
946 `search` int(10) unsigned NOT NULL default '0',
947 `autotranscode` tinyint(1) NOT NULL default '0',
948 `autocommflag` tinyint(1) NOT NULL default '0',
949 `autouserjob1` tinyint(1) NOT NULL default '0',
950 `autouserjob2` tinyint(1) NOT NULL default '0',
951 `autouserjob3` tinyint(1) NOT NULL default '0',
952 `autouserjob4` tinyint(1) NOT NULL default '0',
953 `findday` tinyint(4) NOT NULL default '0',
954 `findtime` time NOT NULL default '00:00:00',
955 `findid` int(11) NOT NULL default '0',
956 `inactive` tinyint(1) NOT NULL default '0',
957 `parentid` int(11) NOT NULL default '0',
958 `transcoder` int(11) NOT NULL default '0',
959 `tsdefault` float NOT NULL default '1',
960 `playgroup` varchar(32) NOT NULL default 'Default',
961 `prefinput` int(10) NOT NULL default '0',
962 PRIMARY KEY (`recordid`),
963 KEY `chanid` (`chanid`,`starttime`),
964 KEY `title` (`title`),
965 KEY `seriesid` (`seriesid`),
966 KEY `programid` (`programid`)
967) ENGINE=MyISAM DEFAULT CHARSET=latin1;
968
969--
970-- Dumping data for table `record`
971--
972
973
974/*!40000 ALTER TABLE `record` DISABLE KEYS */;
975LOCK TABLES `record` WRITE;
976UNLOCK TABLES;
977/*!40000 ALTER TABLE `record` ENABLE KEYS */;
978
979--
980-- Table structure for table `recorded`
981--
982
983DROP TABLE IF EXISTS `recorded`;
984CREATE TABLE `recorded` (
985 `chanid` int(10) unsigned NOT NULL default '0',
986 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
987 `endtime` datetime NOT NULL default '0000-00-00 00:00:00',
988 `title` varchar(128) NOT NULL default '',
989 `subtitle` varchar(128) NOT NULL default '',
990 `description` text NOT NULL,
991 `category` varchar(64) NOT NULL default '',
992 `hostname` varchar(255) NOT NULL default '',
993 `bookmark` tinyint(1) NOT NULL default '0',
994 `editing` int(10) unsigned NOT NULL default '0',
995 `cutlist` tinyint(1) NOT NULL default '0',
996 `autoexpire` int(11) NOT NULL default '0',
997 `commflagged` int(10) unsigned NOT NULL default '0',
998 `recgroup` varchar(32) NOT NULL default 'Default',
999 `recordid` int(11) default NULL,
1000 `seriesid` varchar(12) NOT NULL default '',
1001 `programid` varchar(20) NOT NULL default '',
1002 `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1003 `filesize` bigint(20) NOT NULL default '0',
1004 `stars` float NOT NULL default '0',
1005 `previouslyshown` tinyint(1) default '0',
1006 `originalairdate` date default NULL,
1007 `preserve` tinyint(1) NOT NULL default '0',
1008 `findid` int(11) NOT NULL default '0',
1009 `deletepending` tinyint(1) NOT NULL default '0',
1010 `transcoder` int(11) NOT NULL default '0',
1011 `timestretch` float NOT NULL default '1',
1012 `recpriority` int(11) NOT NULL default '0',
1013 `basename` varchar(128) NOT NULL default '',
1014 `progstart` datetime NOT NULL default '0000-00-00 00:00:00',
1015 `progend` datetime NOT NULL default '0000-00-00 00:00:00',
1016 `playgroup` varchar(32) NOT NULL default 'Default',
1017 `profile` varchar(32) NOT NULL default '',
1018 `duplicate` tinyint(1) NOT NULL default '0',
1019 `transcoded` tinyint(1) NOT NULL default '0',
1020 PRIMARY KEY (`chanid`,`starttime`),
1021 KEY `endtime` (`endtime`),
1022 KEY `seriesid` (`seriesid`),
1023 KEY `programid` (`programid`),
1024 KEY `title` (`title`),
1025 KEY `recordid` (`recordid`)
1026) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1027
1028--
1029-- Dumping data for table `recorded`
1030--
1031
1032
1033/*!40000 ALTER TABLE `recorded` DISABLE KEYS */;
1034LOCK TABLES `recorded` WRITE;
1035UNLOCK TABLES;
1036/*!40000 ALTER TABLE `recorded` ENABLE KEYS */;
1037
1038--
1039-- Table structure for table `recordedcredits`
1040--
1041
1042DROP TABLE IF EXISTS `recordedcredits`;
1043CREATE TABLE `recordedcredits` (
1044 `person` mediumint(8) unsigned NOT NULL default '0',
1045 `chanid` int(10) unsigned NOT NULL default '0',
1046 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
1047 `role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '',
1048 UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),
1049 KEY `person` (`person`,`role`)
1050) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1051
1052--
1053-- Dumping data for table `recordedcredits`
1054--
1055
1056
1057/*!40000 ALTER TABLE `recordedcredits` DISABLE KEYS */;
1058LOCK TABLES `recordedcredits` WRITE;
1059UNLOCK TABLES;
1060/*!40000 ALTER TABLE `recordedcredits` ENABLE KEYS */;
1061
1062--
1063-- Table structure for table `recordedmarkup`
1064--
1065
1066DROP TABLE IF EXISTS `recordedmarkup`;
1067CREATE TABLE `recordedmarkup` (
1068 `chanid` int(10) unsigned NOT NULL default '0',
1069 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
1070 `mark` bigint(20) NOT NULL default '0',
1071 `offset` varchar(32) default NULL,
1072 `type` int(11) NOT NULL default '0',
1073 PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`)
1074) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1075
1076--
1077-- Dumping data for table `recordedmarkup`
1078--
1079
1080
1081/*!40000 ALTER TABLE `recordedmarkup` DISABLE KEYS */;
1082LOCK TABLES `recordedmarkup` WRITE;
1083UNLOCK TABLES;
1084/*!40000 ALTER TABLE `recordedmarkup` ENABLE KEYS */;
1085
1086--
1087-- Table structure for table `recordedprogram`
1088--
1089
1090DROP TABLE IF EXISTS `recordedprogram`;
1091CREATE TABLE `recordedprogram` (
1092 `chanid` int(10) unsigned NOT NULL default '0',
1093 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
1094 `endtime` datetime NOT NULL default '0000-00-00 00:00:00',
1095 `title` varchar(128) NOT NULL default '',
1096 `subtitle` varchar(128) NOT NULL default '',
1097 `description` text NOT NULL,
1098 `category` varchar(64) NOT NULL default '',
1099 `category_type` varchar(64) NOT NULL default '',
1100 `airdate` year(4) NOT NULL default '0000',
1101 `stars` float unsigned NOT NULL default '0',
1102 `previouslyshown` tinyint(4) NOT NULL default '0',
1103 `title_pronounce` varchar(128) NOT NULL default '',
1104 `stereo` tinyint(1) NOT NULL default '0',
1105 `subtitled` tinyint(1) NOT NULL default '0',
1106 `hdtv` tinyint(1) NOT NULL default '0',
1107 `closecaptioned` tinyint(1) NOT NULL default '0',
1108 `partnumber` int(11) NOT NULL default '0',
1109 `parttotal` int(11) NOT NULL default '0',
1110 `seriesid` varchar(12) NOT NULL default '',
1111 `originalairdate` date default NULL,
1112 `showtype` varchar(30) NOT NULL default '',
1113 `colorcode` varchar(20) NOT NULL default '',
1114 `syndicatedepisodenumber` varchar(20) NOT NULL default '',
1115 `programid` varchar(20) NOT NULL default '',
1116 `manualid` int(10) unsigned NOT NULL default '0',
1117 `generic` tinyint(1) default '0',
1118 `listingsource` int(11) NOT NULL default '0',
1119 `first` tinyint(1) NOT NULL default '0',
1120 `last` tinyint(1) NOT NULL default '0',
1121 PRIMARY KEY (`chanid`,`starttime`,`manualid`),
1122 KEY `endtime` (`endtime`),
1123 KEY `title` (`title`),
1124 KEY `title_pronounce` (`title_pronounce`),
1125 KEY `seriesid` (`seriesid`),
1126 KEY `programid` (`programid`),
1127 KEY `id_start_end` (`chanid`,`starttime`,`endtime`)
1128) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1129
1130--
1131-- Dumping data for table `recordedprogram`
1132--
1133
1134
1135/*!40000 ALTER TABLE `recordedprogram` DISABLE KEYS */;
1136LOCK TABLES `recordedprogram` WRITE;
1137UNLOCK TABLES;
1138/*!40000 ALTER TABLE `recordedprogram` ENABLE KEYS */;
1139
1140--
1141-- Table structure for table `recordedrating`
1142--
1143
1144DROP TABLE IF EXISTS `recordedrating`;
1145CREATE TABLE `recordedrating` (
1146 `chanid` int(10) unsigned NOT NULL default '0',
1147 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
1148 `system` char(8) NOT NULL default '',
1149 `rating` char(8) NOT NULL default '',
1150 UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`),
1151 KEY `starttime` (`starttime`,`system`)
1152) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1153
1154--
1155-- Dumping data for table `recordedrating`
1156--
1157
1158
1159/*!40000 ALTER TABLE `recordedrating` DISABLE KEYS */;
1160LOCK TABLES `recordedrating` WRITE;
1161UNLOCK TABLES;
1162/*!40000 ALTER TABLE `recordedrating` ENABLE KEYS */;
1163
1164--
1165-- Table structure for table `recordedseek`
1166--
1167
1168DROP TABLE IF EXISTS `recordedseek`;
1169CREATE TABLE `recordedseek` (
1170 `chanid` int(10) unsigned NOT NULL default '0',
1171 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
1172 `mark` bigint(20) NOT NULL default '0',
1173 `offset` varchar(32) default NULL,
1174 `type` int(11) NOT NULL default '0',
1175 PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`)
1176) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1177
1178--
1179-- Dumping data for table `recordedseek`
1180--
1181
1182
1183/*!40000 ALTER TABLE `recordedseek` DISABLE KEYS */;
1184LOCK TABLES `recordedseek` WRITE;
1185UNLOCK TABLES;
1186/*!40000 ALTER TABLE `recordedseek` ENABLE KEYS */;
1187
1188--
1189-- Table structure for table `recordingprofiles`
1190--
1191
1192DROP TABLE IF EXISTS `recordingprofiles`;
1193CREATE TABLE `recordingprofiles` (
1194 `id` int(10) unsigned NOT NULL auto_increment,
1195 `name` varchar(128) default NULL,
1196 `videocodec` varchar(128) default NULL,
1197 `audiocodec` varchar(128) default NULL,
1198 `profilegroup` int(10) unsigned NOT NULL default '0',
1199 PRIMARY KEY (`id`)
1200) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1201
1202--
1203-- Dumping data for table `recordingprofiles`
1204--
1205
1206
1207/*!40000 ALTER TABLE `recordingprofiles` DISABLE KEYS */;
1208LOCK TABLES `recordingprofiles` WRITE;
1209INSERT INTO `recordingprofiles` VALUES (1,'Default',NULL,NULL,1),(2,'Live TV',NULL,NULL,1),(3,'High Quality',NULL,NULL,1),(4,'Low Quality',NULL,NULL,1),(5,'Default',NULL,NULL,2),(6,'Live TV',NULL,NULL,2),(7,'High Quality',NULL,NULL,2),(8,'Low Quality',NULL,NULL,2),(9,'Default',NULL,NULL,3),(10,'Live TV',NULL,NULL,3),(11,'High Quality',NULL,NULL,3),(12,'Low Quality',NULL,NULL,3),(13,'Default',NULL,NULL,4),(14,'Live TV',NULL,NULL,4),(15,'High Quality',NULL,NULL,4),(16,'Low Quality',NULL,NULL,4),(17,'Default',NULL,NULL,5),(18,'Live TV',NULL,NULL,5),(19,'High Quality',NULL,NULL,5),(20,'Low Quality',NULL,NULL,5),(21,'RTjpeg/MPEG4',NULL,NULL,6),(22,'MPEG2',NULL,NULL,6),(23,'Default',NULL,NULL,8),(24,'Live TV',NULL,NULL,8),(25,'High Quality',NULL,NULL,8),(26,'Low Quality',NULL,NULL,8),(27,'High Quality',NULL,NULL,6),(28,'Medium Quality',NULL,NULL,6),(29,'Low Quality',NULL,NULL,6),(30,'Default',NULL,NULL,10),(31,'Live TV',NULL,NULL,10),(32,'High Quality',NULL,NULL,10),(33,'Low Quality',NULL,NULL,10),(34,'Default',NULL,NULL,11),(35,'Live TV',NULL,NULL,11),(36,'High Quality',NULL,NULL,11),(37,'Low Quality',NULL,NULL,11),(38,'Default',NULL,NULL,12),(39,'Live TV',NULL,NULL,12),(40,'High Quality',NULL,NULL,12),(41,'Low Quality',NULL,NULL,12);
1210UNLOCK TABLES;
1211/*!40000 ALTER TABLE `recordingprofiles` ENABLE KEYS */;
1212
1213--
1214-- Table structure for table `recordmatch`
1215--
1216
1217DROP TABLE IF EXISTS `recordmatch`;
1218CREATE TABLE `recordmatch` (
1219 `recordid` int(10) unsigned default NULL,
1220 `chanid` int(10) unsigned default NULL,
1221 `starttime` datetime default NULL,
1222 `manualid` int(10) unsigned default NULL,
1223 KEY `recordid` (`recordid`)
1224) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1225
1226--
1227-- Dumping data for table `recordmatch`
1228--
1229
1230
1231/*!40000 ALTER TABLE `recordmatch` DISABLE KEYS */;
1232LOCK TABLES `recordmatch` WRITE;
1233UNLOCK TABLES;
1234/*!40000 ALTER TABLE `recordmatch` ENABLE KEYS */;
1235
1236--
1237-- Table structure for table `schemalock`
1238--
1239
1240DROP TABLE IF EXISTS `schemalock`;
1241CREATE TABLE `schemalock` (
1242 `schemalock` int(1) default NULL
1243) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1244
1245--
1246-- Dumping data for table `schemalock`
1247--
1248
1249
1250/*!40000 ALTER TABLE `schemalock` DISABLE KEYS */;
1251LOCK TABLES `schemalock` WRITE;
1252UNLOCK TABLES;
1253/*!40000 ALTER TABLE `schemalock` ENABLE KEYS */;
1254
1255--
1256-- Table structure for table `settings`
1257--
1258
1259DROP TABLE IF EXISTS `settings`;
1260CREATE TABLE `settings` (
1261 `value` varchar(128) NOT NULL default '',
1262 `data` text,
1263 `hostname` varchar(255) default NULL,
1264 KEY `value` (`value`,`hostname`)
1265) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1266
1267--
1268-- Dumping data for table `settings`
1269--
1270
1271
1272/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
1273LOCK TABLES `settings` WRITE;
1274INSERT INTO `settings` VALUES ('mythfilldatabaseLastRunStart',NULL,NULL),('mythfilldatabaseLastRunEnd',NULL,NULL),('mythfilldatabaseLastRunStatus',NULL,NULL),('DataDirectMessage',NULL,NULL),('HaveRepeats','0',NULL),('DBSchemaVer','1155',NULL),('DefaultTranscoder','0',NULL),('MythFillSuggestedRunTime','1970-01-01T00:00:00',NULL),('MythFillGrabberSuggestsTime','1',NULL),('Language','DE','zenslack'),('BackendServerIP','127.0.0.1','zenslack'),('BackendServerPort','6543','zenslack'),('BackendStatusPort','6544','zenslack'),('MasterServerIP','127.0.0.1',NULL),('MasterServerPort','6543',NULL),('RecordFilePrefix','/video/store/','zenslack'),('TVFormat','PAL',NULL),('VbiFormat','PAL Teletext',NULL),('FreqTable','europe-west',NULL),('TimeOffset','None',NULL),('MasterBackendOverride','1',NULL),('DeletesFollowLinks','0',NULL),('EITTimeOffset','Auto',NULL),('EITTransportTimeout','5',NULL),('EITIgnoresSource','0',NULL),('EITCrawIdleStart','60',NULL),('startupCommand','',NULL),('blockSDWUwithoutClient','1',NULL),('idleTimeoutSecs','0',NULL),('idleWaitForRecordingTime','15',NULL),('StartupSecsBeforeRecording','120',NULL),('WakeupTimeFormat','hh:mm yyyy-MM-dd',NULL),('SetWakeuptimeCommand','',NULL),('ServerHaltCommand','sudo /sbin/halt -p',NULL),('preSDWUCheckCommand','',NULL),('WOLbackendReconnectWaitTime','0',NULL),('WOLbackendConnectRetry','5',NULL),('WOLbackendCommand','',NULL),('WOLslaveBackendsCommand','',NULL),('JobQueueMaxSimultaneousJobs','1','zenslack'),('JobQueueCheckFrequency','60','zenslack'),('JobQueueWindowStart','00:00','zenslack'),('JobQueueWindowEnd','23:59','zenslack'),('JobQueueCPU','0','zenslack'),('JobAllowCommFlag','1','zenslack'),('JobAllowTranscode','1','zenslack'),('JobAllowUserJob1','0','zenslack'),('JobAllowUserJob2','0','zenslack'),('JobAllowUserJob3','0','zenslack'),('JobAllowUserJob4','0','zenslack'),('JobsRunOnRecordHost','0',NULL),('AutoCommflagWhileRecording','0',NULL),('JobQueueCommFlagCommand','mythcommflag',NULL),('JobQueueTranscodeCommand','mythtranscode',NULL),('AutoTranscodeBeforeAutoCommflag','0',NULL),('SaveTranscoding','0',NULL),('UserJobDesc1','User Job #1',NULL),('UserJob1','',NULL),('UserJobDesc2','User Job #2',NULL),('UserJob2','',NULL),('UserJobDesc3','User Job #3',NULL),('UserJob3','',NULL),('UserJobDesc4','User Job #4',NULL),('UserJob4','',NULL);
1275UNLOCK TABLES;
1276/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
1277
1278--
1279-- Table structure for table `tvchain`
1280--
1281
1282DROP TABLE IF EXISTS `tvchain`;
1283CREATE TABLE `tvchain` (
1284 `chanid` int(10) unsigned NOT NULL default '0',
1285 `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
1286 `chainid` varchar(128) NOT NULL default '',
1287 `chainpos` int(10) NOT NULL default '0',
1288 `discontinuity` tinyint(1) NOT NULL default '0',
1289 `watching` int(10) NOT NULL default '0',
1290 `hostprefix` varchar(128) NOT NULL default '',
1291 `cardtype` varchar(32) NOT NULL default 'V4L',
1292 `input` varchar(32) NOT NULL default '',
1293 `channame` varchar(32) NOT NULL default '',
1294 `endtime` datetime NOT NULL default '0000-00-00 00:00:00',
1295 PRIMARY KEY (`chanid`,`starttime`)
1296) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1297
1298--
1299-- Dumping data for table `tvchain`
1300--
1301
1302
1303/*!40000 ALTER TABLE `tvchain` DISABLE KEYS */;
1304LOCK TABLES `tvchain` WRITE;
1305UNLOCK TABLES;
1306/*!40000 ALTER TABLE `tvchain` ENABLE KEYS */;
1307
1308--
1309-- Table structure for table `videobookmarks`
1310--
1311
1312DROP TABLE IF EXISTS `videobookmarks`;
1313CREATE TABLE `videobookmarks` (
1314 `filename` varchar(255) NOT NULL default '',
1315 `bookmark` varchar(128) default NULL,
1316 PRIMARY KEY (`filename`)
1317) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1318
1319--
1320-- Dumping data for table `videobookmarks`
1321--
1322
1323
1324/*!40000 ALTER TABLE `videobookmarks` DISABLE KEYS */;
1325LOCK TABLES `videobookmarks` WRITE;
1326UNLOCK TABLES;
1327/*!40000 ALTER TABLE `videobookmarks` ENABLE KEYS */;
1328
1329--
1330-- Table structure for table `videosource`
1331--
1332
1333DROP TABLE IF EXISTS `videosource`;
1334CREATE TABLE `videosource` (
1335 `sourceid` int(10) unsigned NOT NULL auto_increment,
1336 `name` varchar(128) NOT NULL default '',
1337 `xmltvgrabber` varchar(128) default NULL,
1338 `userid` varchar(128) NOT NULL default '',
1339 `freqtable` varchar(16) NOT NULL default 'default',
1340 `lineupid` varchar(64) default NULL,
1341 `password` varchar(64) default NULL,
1342 `useeit` smallint(6) NOT NULL default '0',
1343 PRIMARY KEY (`sourceid`),
1344 UNIQUE KEY `name` (`name`)
1345) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1346
1347--
1348-- Dumping data for table `videosource`
1349--
1350
1351
1352/*!40000 ALTER TABLE `videosource` DISABLE KEYS */;
1353LOCK TABLES `videosource` WRITE;
1354INSERT INTO `videosource` VALUES (1,'dvb','eitonly','','default',NULL,NULL,1);
1355UNLOCK TABLES;
1356/*!40000 ALTER TABLE `videosource` ENABLE KEYS */;
1357/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1358
1359/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1360/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1361/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1362/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1363/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1364/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1365/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1366