Ticket #2142: mythconverg.2.sql

File mythconverg.2.sql, 54.2 KB (added by panzaeron, 18 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