Ticket #9670: mythconverg 20110810 0812.sql

File mythconverg 20110810 0812.sql, 56.2 KB (added by raymondboettcher@…, 14 years ago)

Dump of Schema created by failed myth-setup. (Schema was initially empty).

Line 
1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version 5.1.46
5
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
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema mythconverg
19--
20
21CREATE DATABASE IF NOT EXISTS mythconverg;
22USE mythconverg;
23
24--
25-- Definition of table `callsignnetworkmap`
26--
27
28DROP TABLE IF EXISTS `callsignnetworkmap`;
29CREATE TABLE `callsignnetworkmap` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `callsign` varchar(20) NOT NULL DEFAULT '',
32 `network` varchar(20) NOT NULL DEFAULT '',
33 PRIMARY KEY (`id`),
34 UNIQUE KEY `callsign` (`callsign`)
35) ENGINE=MyISAM DEFAULT CHARSET=utf8;
36
37--
38-- Dumping data for table `callsignnetworkmap`
39--
40
41/*!40000 ALTER TABLE `callsignnetworkmap` DISABLE KEYS */;
42/*!40000 ALTER TABLE `callsignnetworkmap` ENABLE KEYS */;
43
44
45--
46-- Definition of table `capturecard`
47--
48
49DROP TABLE IF EXISTS `capturecard`;
50CREATE TABLE `capturecard` (
51 `cardid` int(10) unsigned NOT NULL AUTO_INCREMENT,
52 `videodevice` varchar(128) DEFAULT NULL,
53 `audiodevice` varchar(128) DEFAULT NULL,
54 `vbidevice` varchar(128) DEFAULT NULL,
55 `cardtype` varchar(32) DEFAULT 'V4L',
56 `defaultinput` varchar(32) DEFAULT 'Television',
57 `audioratelimit` int(11) DEFAULT NULL,
58 `hostname` varchar(64) DEFAULT NULL,
59 `dvb_swfilter` int(11) DEFAULT '0',
60 `dvb_sat_type` int(11) NOT NULL DEFAULT '0',
61 `dvb_wait_for_seqstart` int(11) NOT NULL DEFAULT '1',
62 `skipbtaudio` tinyint(1) DEFAULT '0',
63 `dvb_on_demand` tinyint(4) NOT NULL DEFAULT '0',
64 `dvb_diseqc_type` smallint(6) DEFAULT NULL,
65 `firewire_speed` int(10) unsigned NOT NULL DEFAULT '0',
66 `firewire_model` varchar(32) DEFAULT NULL,
67 `firewire_connection` int(10) unsigned NOT NULL 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 `dvb_tuning_delay` int(10) unsigned NOT NULL DEFAULT '0',
74 `contrast` int(11) NOT NULL DEFAULT '0',
75 `brightness` int(11) NOT NULL DEFAULT '0',
76 `colour` int(11) NOT NULL DEFAULT '0',
77 `hue` int(11) NOT NULL DEFAULT '0',
78 `diseqcid` int(10) unsigned DEFAULT NULL,
79 `dvb_eitscan` tinyint(1) NOT NULL DEFAULT '1',
80 PRIMARY KEY (`cardid`)
81) ENGINE=MyISAM DEFAULT CHARSET=utf8;
82
83--
84-- Dumping data for table `capturecard`
85--
86
87/*!40000 ALTER TABLE `capturecard` DISABLE KEYS */;
88/*!40000 ALTER TABLE `capturecard` ENABLE KEYS */;
89
90
91--
92-- Definition of table `cardinput`
93--
94
95DROP TABLE IF EXISTS `cardinput`;
96CREATE TABLE `cardinput` (
97 `cardinputid` int(10) unsigned NOT NULL AUTO_INCREMENT,
98 `cardid` int(10) unsigned NOT NULL DEFAULT '0',
99 `sourceid` int(10) unsigned NOT NULL DEFAULT '0',
100 `inputname` varchar(32) NOT NULL DEFAULT '',
101 `externalcommand` varchar(128) DEFAULT NULL,
102 `shareable` char(1) DEFAULT 'N',
103 `tunechan` varchar(10) DEFAULT NULL,
104 `startchan` varchar(10) DEFAULT NULL,
105 `freetoaironly` tinyint(1) DEFAULT '1',
106 `displayname` varchar(64) NOT NULL DEFAULT '',
107 `radioservices` tinyint(1) DEFAULT '1',
108 `dishnet_eit` tinyint(1) NOT NULL DEFAULT '0',
109 `recpriority` int(11) NOT NULL DEFAULT '0',
110 `quicktune` tinyint(4) NOT NULL DEFAULT '0',
111 PRIMARY KEY (`cardinputid`)
112) ENGINE=MyISAM DEFAULT CHARSET=utf8;
113
114--
115-- Dumping data for table `cardinput`
116--
117
118/*!40000 ALTER TABLE `cardinput` DISABLE KEYS */;
119/*!40000 ALTER TABLE `cardinput` ENABLE KEYS */;
120
121
122--
123-- Definition of table `channel`
124--
125
126DROP TABLE IF EXISTS `channel`;
127CREATE TABLE `channel` (
128 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
129 `channum` varchar(10) NOT NULL DEFAULT '',
130 `freqid` varchar(10) DEFAULT NULL,
131 `sourceid` int(10) unsigned DEFAULT NULL,
132 `callsign` varchar(20) NOT NULL DEFAULT '',
133 `name` varchar(64) NOT NULL DEFAULT '',
134 `icon` varchar(255) NOT NULL DEFAULT 'none',
135 `finetune` int(11) DEFAULT NULL,
136 `videofilters` varchar(255) NOT NULL DEFAULT '',
137 `xmltvid` varchar(64) NOT NULL DEFAULT '',
138 `recpriority` int(10) NOT NULL DEFAULT '0',
139 `contrast` int(11) DEFAULT '32768',
140 `brightness` int(11) DEFAULT '32768',
141 `colour` int(11) DEFAULT '32768',
142 `hue` int(11) DEFAULT '32768',
143 `tvformat` varchar(10) NOT NULL DEFAULT 'Default',
144 `visible` tinyint(1) NOT NULL DEFAULT '1',
145 `outputfilters` varchar(255) NOT NULL DEFAULT '',
146 `useonairguide` tinyint(1) DEFAULT '0',
147 `mplexid` smallint(6) DEFAULT NULL,
148 `serviceid` mediumint(8) unsigned DEFAULT NULL,
149 `tmoffset` int(11) NOT NULL DEFAULT '0',
150 `atsc_major_chan` int(10) unsigned NOT NULL DEFAULT '0',
151 `atsc_minor_chan` int(10) unsigned NOT NULL DEFAULT '0',
152 `last_record` datetime NOT NULL,
153 `default_authority` varchar(32) NOT NULL DEFAULT '',
154 `commmethod` int(11) NOT NULL DEFAULT '-1',
155 PRIMARY KEY (`chanid`),
156 KEY `channel_src` (`channum`,`sourceid`),
157 KEY `sourceid` (`sourceid`,`xmltvid`,`chanid`),
158 KEY `visible` (`visible`)
159) ENGINE=MyISAM DEFAULT CHARSET=utf8;
160
161--
162-- Dumping data for table `channel`
163--
164
165/*!40000 ALTER TABLE `channel` DISABLE KEYS */;
166/*!40000 ALTER TABLE `channel` ENABLE KEYS */;
167
168
169--
170-- Definition of table `channelgroup`
171--
172
173DROP TABLE IF EXISTS `channelgroup`;
174CREATE TABLE `channelgroup` (
175 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
176 `chanid` int(11) unsigned NOT NULL DEFAULT '0',
177 `grpid` int(11) NOT NULL DEFAULT '1',
178 PRIMARY KEY (`id`)
179) ENGINE=MyISAM DEFAULT CHARSET=utf8;
180
181--
182-- Dumping data for table `channelgroup`
183--
184
185/*!40000 ALTER TABLE `channelgroup` DISABLE KEYS */;
186/*!40000 ALTER TABLE `channelgroup` ENABLE KEYS */;
187
188
189--
190-- Definition of table `channelgroupnames`
191--
192
193DROP TABLE IF EXISTS `channelgroupnames`;
194CREATE TABLE `channelgroupnames` (
195 `grpid` int(10) unsigned NOT NULL AUTO_INCREMENT,
196 `name` varchar(64) NOT NULL DEFAULT '0',
197 PRIMARY KEY (`grpid`)
198) ENGINE=MyISAM DEFAULT CHARSET=utf8;
199
200--
201-- Dumping data for table `channelgroupnames`
202--
203
204/*!40000 ALTER TABLE `channelgroupnames` DISABLE KEYS */;
205/*!40000 ALTER TABLE `channelgroupnames` ENABLE KEYS */;
206
207
208--
209-- Definition of table `channelscan`
210--
211
212DROP TABLE IF EXISTS `channelscan`;
213CREATE TABLE `channelscan` (
214 `scanid` int(3) unsigned NOT NULL AUTO_INCREMENT,
215 `cardid` int(3) unsigned NOT NULL,
216 `sourceid` int(3) unsigned NOT NULL,
217 `processed` tinyint(1) unsigned NOT NULL,
218 `scandate` datetime NOT NULL,
219 PRIMARY KEY (`scanid`)
220) ENGINE=MyISAM DEFAULT CHARSET=utf8;
221
222--
223-- Dumping data for table `channelscan`
224--
225
226/*!40000 ALTER TABLE `channelscan` DISABLE KEYS */;
227/*!40000 ALTER TABLE `channelscan` ENABLE KEYS */;
228
229
230--
231-- Definition of table `channelscan_channel`
232--
233
234DROP TABLE IF EXISTS `channelscan_channel`;
235CREATE TABLE `channelscan_channel` (
236 `transportid` int(6) unsigned NOT NULL,
237 `scanid` int(3) unsigned NOT NULL,
238 `mplex_id` smallint(6) NOT NULL,
239 `source_id` int(3) unsigned NOT NULL,
240 `channel_id` int(3) unsigned NOT NULL DEFAULT '0',
241 `callsign` varchar(20) NOT NULL DEFAULT '',
242 `service_name` varchar(64) NOT NULL DEFAULT '',
243 `chan_num` varchar(10) NOT NULL DEFAULT '',
244 `service_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
245 `atsc_major_channel` int(4) unsigned NOT NULL DEFAULT '0',
246 `atsc_minor_channel` int(4) unsigned NOT NULL DEFAULT '0',
247 `use_on_air_guide` tinyint(1) NOT NULL DEFAULT '0',
248 `hidden` tinyint(1) NOT NULL DEFAULT '0',
249 `hidden_in_guide` tinyint(1) NOT NULL DEFAULT '0',
250 `freqid` varchar(10) NOT NULL DEFAULT '',
251 `icon` varchar(255) NOT NULL DEFAULT '',
252 `tvformat` varchar(10) NOT NULL DEFAULT 'Default',
253 `xmltvid` varchar(64) NOT NULL DEFAULT '',
254 `pat_tsid` int(5) unsigned NOT NULL DEFAULT '0',
255 `vct_tsid` int(5) unsigned NOT NULL DEFAULT '0',
256 `vct_chan_tsid` int(5) unsigned NOT NULL DEFAULT '0',
257 `sdt_tsid` int(5) unsigned NOT NULL DEFAULT '0',
258 `orig_netid` int(5) unsigned NOT NULL DEFAULT '0',
259 `netid` int(5) unsigned NOT NULL DEFAULT '0',
260 `si_standard` varchar(10) NOT NULL,
261 `in_channels_conf` tinyint(1) unsigned NOT NULL DEFAULT '0',
262 `in_pat` tinyint(1) unsigned NOT NULL DEFAULT '0',
263 `in_pmt` tinyint(1) unsigned NOT NULL DEFAULT '0',
264 `in_vct` tinyint(1) unsigned NOT NULL DEFAULT '0',
265 `in_nit` tinyint(1) unsigned NOT NULL DEFAULT '0',
266 `in_sdt` tinyint(1) unsigned NOT NULL DEFAULT '0',
267 `is_encrypted` tinyint(1) unsigned NOT NULL DEFAULT '0',
268 `is_data_service` tinyint(1) unsigned NOT NULL DEFAULT '0',
269 `is_audio_service` tinyint(1) unsigned NOT NULL DEFAULT '0',
270 `is_opencable` tinyint(1) unsigned NOT NULL DEFAULT '0',
271 `could_be_opencable` tinyint(1) unsigned NOT NULL DEFAULT '0',
272 `decryption_status` smallint(2) unsigned NOT NULL DEFAULT '0'
273) ENGINE=MyISAM DEFAULT CHARSET=utf8;
274
275--
276-- Dumping data for table `channelscan_channel`
277--
278
279/*!40000 ALTER TABLE `channelscan_channel` DISABLE KEYS */;
280/*!40000 ALTER TABLE `channelscan_channel` ENABLE KEYS */;
281
282
283--
284-- Definition of table `channelscan_dtv_multiplex`
285--
286
287DROP TABLE IF EXISTS `channelscan_dtv_multiplex`;
288CREATE TABLE `channelscan_dtv_multiplex` (
289 `transportid` int(6) unsigned NOT NULL AUTO_INCREMENT,
290 `scanid` int(3) unsigned NOT NULL,
291 `mplexid` smallint(6) unsigned NOT NULL,
292 `frequency` bigint(12) unsigned NOT NULL,
293 `inversion` char(1) NOT NULL DEFAULT 'a',
294 `symbolrate` bigint(12) unsigned NOT NULL DEFAULT '0',
295 `fec` varchar(4) NOT NULL DEFAULT 'auto',
296 `polarity` char(1) NOT NULL DEFAULT '',
297 `hp_code_rate` varchar(4) NOT NULL DEFAULT 'auto',
298 `lp_code_rate` varchar(4) NOT NULL DEFAULT 'auto',
299 `modulation` varchar(4) NOT NULL DEFAULT 'auto',
300 `transmission_mode` char(1) NOT NULL DEFAULT 'a',
301 `guard_interval` varchar(4) NOT NULL DEFAULT 'auto',
302 `hierarchy` varchar(4) NOT NULL DEFAULT 'auto',
303 `bandwidth` char(1) NOT NULL DEFAULT 'a',
304 `sistandard` varchar(10) NOT NULL,
305 `tuner_type` smallint(2) unsigned NOT NULL,
306 PRIMARY KEY (`transportid`)
307) ENGINE=MyISAM DEFAULT CHARSET=utf8;
308
309--
310-- Dumping data for table `channelscan_dtv_multiplex`
311--
312
313/*!40000 ALTER TABLE `channelscan_dtv_multiplex` DISABLE KEYS */;
314/*!40000 ALTER TABLE `channelscan_dtv_multiplex` ENABLE KEYS */;
315
316
317--
318-- Definition of table `codecparams`
319--
320
321DROP TABLE IF EXISTS `codecparams`;
322CREATE TABLE `codecparams` (
323 `profile` int(10) unsigned NOT NULL DEFAULT '0',
324 `name` varchar(128) NOT NULL DEFAULT '',
325 `value` varchar(128) DEFAULT NULL,
326 PRIMARY KEY (`profile`,`name`)
327) ENGINE=MyISAM DEFAULT CHARSET=utf8;
328
329--
330-- Dumping data for table `codecparams`
331--
332
333/*!40000 ALTER TABLE `codecparams` DISABLE KEYS */;
334/*!40000 ALTER TABLE `codecparams` ENABLE KEYS */;
335
336
337--
338-- Definition of table `credits`
339--
340
341DROP TABLE IF EXISTS `credits`;
342CREATE TABLE `credits` (
343 `person` mediumint(8) unsigned NOT NULL DEFAULT '0',
344 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
345 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
346 `role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL DEFAULT '',
347 UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),
348 KEY `person` (`person`,`role`)
349) ENGINE=MyISAM DEFAULT CHARSET=utf8;
350
351--
352-- Dumping data for table `credits`
353--
354
355/*!40000 ALTER TABLE `credits` DISABLE KEYS */;
356/*!40000 ALTER TABLE `credits` ENABLE KEYS */;
357
358
359--
360-- Definition of table `customexample`
361--
362
363DROP TABLE IF EXISTS `customexample`;
364CREATE TABLE `customexample` (
365 `rulename` varchar(64) NOT NULL,
366 `fromclause` text NOT NULL,
367 `whereclause` text NOT NULL,
368 `search` tinyint(4) NOT NULL DEFAULT '0',
369 PRIMARY KEY (`rulename`)
370) ENGINE=MyISAM DEFAULT CHARSET=utf8;
371
372--
373-- Dumping data for table `customexample`
374--
375
376/*!40000 ALTER TABLE `customexample` DISABLE KEYS */;
377INSERT INTO `customexample` (`rulename`,`fromclause`,`whereclause`,`search`) VALUES
378 ('New Flix','','program.category_type = \'movie\' AND program.airdate >= \n YEAR(DATE_SUB(NOW(), INTERVAL 1 YEAR)) \nAND program.stars > 0.5 ',1);
379/*!40000 ALTER TABLE `customexample` ENABLE KEYS */;
380
381
382--
383-- Definition of table `diseqc_config`
384--
385
386DROP TABLE IF EXISTS `diseqc_config`;
387CREATE TABLE `diseqc_config` (
388 `cardinputid` int(10) unsigned NOT NULL,
389 `diseqcid` int(10) unsigned NOT NULL,
390 `value` varchar(16) NOT NULL DEFAULT '',
391 KEY `id` (`cardinputid`)
392) ENGINE=MyISAM DEFAULT CHARSET=utf8;
393
394--
395-- Dumping data for table `diseqc_config`
396--
397
398/*!40000 ALTER TABLE `diseqc_config` DISABLE KEYS */;
399/*!40000 ALTER TABLE `diseqc_config` ENABLE KEYS */;
400
401
402--
403-- Definition of table `diseqc_tree`
404--
405
406DROP TABLE IF EXISTS `diseqc_tree`;
407CREATE TABLE `diseqc_tree` (
408 `diseqcid` int(10) unsigned NOT NULL AUTO_INCREMENT,
409 `parentid` int(10) unsigned DEFAULT NULL,
410 `ordinal` tinyint(3) unsigned NOT NULL,
411 `type` varchar(16) NOT NULL DEFAULT '',
412 `subtype` varchar(16) NOT NULL DEFAULT '',
413 `description` varchar(32) NOT NULL DEFAULT '',
414 `switch_ports` tinyint(3) unsigned NOT NULL DEFAULT '0',
415 `rotor_hi_speed` float NOT NULL DEFAULT '0',
416 `rotor_lo_speed` float NOT NULL DEFAULT '0',
417 `rotor_positions` varchar(255) NOT NULL DEFAULT '',
418 `lnb_lof_switch` int(10) NOT NULL DEFAULT '0',
419 `lnb_lof_hi` int(10) NOT NULL DEFAULT '0',
420 `lnb_lof_lo` int(10) NOT NULL DEFAULT '0',
421 `cmd_repeat` int(11) NOT NULL DEFAULT '1',
422 `lnb_pol_inv` tinyint(4) NOT NULL DEFAULT '0',
423 PRIMARY KEY (`diseqcid`),
424 KEY `parentid` (`parentid`)
425) ENGINE=MyISAM DEFAULT CHARSET=utf8;
426
427--
428-- Dumping data for table `diseqc_tree`
429--
430
431/*!40000 ALTER TABLE `diseqc_tree` DISABLE KEYS */;
432/*!40000 ALTER TABLE `diseqc_tree` ENABLE KEYS */;
433
434
435--
436-- Definition of table `displayprofilegroups`
437--
438
439DROP TABLE IF EXISTS `displayprofilegroups`;
440CREATE TABLE `displayprofilegroups` (
441 `name` varchar(128) NOT NULL,
442 `hostname` varchar(64) NOT NULL,
443 `profilegroupid` int(10) unsigned NOT NULL AUTO_INCREMENT,
444 PRIMARY KEY (`name`,`hostname`),
445 UNIQUE KEY `profilegroupid` (`profilegroupid`)
446) ENGINE=MyISAM DEFAULT CHARSET=utf8;
447
448--
449-- Dumping data for table `displayprofilegroups`
450--
451
452/*!40000 ALTER TABLE `displayprofilegroups` DISABLE KEYS */;
453/*!40000 ALTER TABLE `displayprofilegroups` ENABLE KEYS */;
454
455
456--
457-- Definition of table `displayprofiles`
458--
459
460DROP TABLE IF EXISTS `displayprofiles`;
461CREATE TABLE `displayprofiles` (
462 `profilegroupid` int(10) unsigned NOT NULL,
463 `profileid` int(10) unsigned NOT NULL AUTO_INCREMENT,
464 `value` varchar(128) NOT NULL,
465 `data` varchar(255) NOT NULL DEFAULT '',
466 KEY `profilegroupid` (`profilegroupid`),
467 KEY `profileid` (`profileid`,`value`),
468 KEY `profileid_2` (`profileid`)
469) ENGINE=MyISAM DEFAULT CHARSET=utf8;
470
471--
472-- Dumping data for table `displayprofiles`
473--
474
475/*!40000 ALTER TABLE `displayprofiles` DISABLE KEYS */;
476/*!40000 ALTER TABLE `displayprofiles` ENABLE KEYS */;
477
478
479--
480-- Definition of table `dtv_multiplex`
481--
482
483DROP TABLE IF EXISTS `dtv_multiplex`;
484CREATE TABLE `dtv_multiplex` (
485 `mplexid` smallint(6) NOT NULL AUTO_INCREMENT,
486 `sourceid` smallint(6) DEFAULT NULL,
487 `transportid` int(11) DEFAULT NULL,
488 `networkid` int(11) DEFAULT NULL,
489 `frequency` int(11) DEFAULT NULL,
490 `inversion` char(1) DEFAULT 'a',
491 `symbolrate` int(11) DEFAULT NULL,
492 `fec` varchar(10) DEFAULT 'auto',
493 `polarity` char(1) DEFAULT NULL,
494 `modulation` varchar(10) DEFAULT 'auto',
495 `bandwidth` char(1) DEFAULT 'a',
496 `lp_code_rate` varchar(10) DEFAULT 'auto',
497 `transmission_mode` char(1) DEFAULT 'a',
498 `guard_interval` varchar(10) DEFAULT 'auto',
499 `visible` smallint(1) NOT NULL DEFAULT '0',
500 `constellation` varchar(10) DEFAULT 'auto',
501 `hierarchy` varchar(10) DEFAULT 'auto',
502 `hp_code_rate` varchar(10) DEFAULT 'auto',
503 `sistandard` varchar(10) DEFAULT 'dvb',
504 `serviceversion` smallint(6) DEFAULT '33',
505 `updatetimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
506 PRIMARY KEY (`mplexid`)
507) ENGINE=MyISAM DEFAULT CHARSET=utf8;
508
509--
510-- Dumping data for table `dtv_multiplex`
511--
512
513/*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */;
514/*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */;
515
516
517--
518-- Definition of table `dtv_privatetypes`
519--
520
521DROP TABLE IF EXISTS `dtv_privatetypes`;
522CREATE TABLE `dtv_privatetypes` (
523 `sitype` varchar(4) NOT NULL DEFAULT '',
524 `networkid` int(11) NOT NULL DEFAULT '0',
525 `private_type` varchar(20) NOT NULL DEFAULT '',
526 `private_value` varchar(100) NOT NULL DEFAULT ''
527) ENGINE=MyISAM DEFAULT CHARSET=utf8;
528
529--
530-- Dumping data for table `dtv_privatetypes`
531--
532
533/*!40000 ALTER TABLE `dtv_privatetypes` DISABLE KEYS */;
534INSERT INTO `dtv_privatetypes` (`sitype`,`networkid`,`private_type`,`private_value`) VALUES
535 ('dvb',9018,'channel_numbers','131'),
536 ('dvb',9018,'guide_fixup','2'),
537 ('dvb',256,'guide_fixup','1'),
538 ('dvb',257,'guide_fixup','1'),
539 ('dvb',256,'tv_types','1,150,134,133'),
540 ('dvb',257,'tv_types','1,150,134,133'),
541 ('dvb',4100,'sdt_mapping','1'),
542 ('dvb',4101,'sdt_mapping','1'),
543 ('dvb',4102,'sdt_mapping','1'),
544 ('dvb',4103,'sdt_mapping','1'),
545 ('dvb',4104,'sdt_mapping','1'),
546 ('dvb',4105,'sdt_mapping','1'),
547 ('dvb',4106,'sdt_mapping','1'),
548 ('dvb',4107,'sdt_mapping','1'),
549 ('dvb',4097,'sdt_mapping','1'),
550 ('dvb',4098,'sdt_mapping','1'),
551 ('dvb',4100,'tv_types','1,145,154'),
552 ('dvb',4101,'tv_types','1,145,154'),
553 ('dvb',4102,'tv_types','1,145,154'),
554 ('dvb',4103,'tv_types','1,145,154'),
555 ('dvb',4104,'tv_types','1,145,154'),
556 ('dvb',4105,'tv_types','1,145,154'),
557 ('dvb',4106,'tv_types','1,145,154'),
558 ('dvb',4107,'tv_types','1,145,154'),
559 ('dvb',4097,'tv_types','1,145,154'),
560 ('dvb',4098,'tv_types','1,145,154'),
561 ('dvb',4100,'guide_fixup','1'),
562 ('dvb',4101,'guide_fixup','1'),
563 ('dvb',4102,'guide_fixup','1'),
564 ('dvb',4103,'guide_fixup','1'),
565 ('dvb',4104,'guide_fixup','1'),
566 ('dvb',4105,'guide_fixup','1'),
567 ('dvb',4106,'guide_fixup','1'),
568 ('dvb',4107,'guide_fixup','1'),
569 ('dvb',4096,'guide_fixup','5'),
570 ('dvb',4097,'guide_fixup','1'),
571 ('dvb',4098,'guide_fixup','1'),
572 ('dvb',94,'tv_types','1,128'),
573 ('atsc',1793,'guide_fixup','3'),
574 ('dvb',40999,'guide_fixup','4'),
575 ('dvb',70,'force_guide_present','yes'),
576 ('dvb',70,'guide_ranges','80,80,96,96'),
577 ('dvb',4112,'channel_numbers','131'),
578 ('dvb',4115,'channel_numbers','131'),
579 ('dvb',4116,'channel_numbers','131'),
580 ('dvb',12802,'channel_numbers','131'),
581 ('dvb',12803,'channel_numbers','131'),
582 ('dvb',12829,'channel_numbers','131'),
583 ('dvb',40999,'parse_subtitle_list','1070,1308,1041,1306,1307,1030,1016,1131,1068,1069'),
584 ('dvb',4096,'guide_fixup','5');
585/*!40000 ALTER TABLE `dtv_privatetypes` ENABLE KEYS */;
586
587
588--
589-- Definition of table `dvdbookmark`
590--
591
592DROP TABLE IF EXISTS `dvdbookmark`;
593CREATE TABLE `dvdbookmark` (
594 `serialid` varchar(16) NOT NULL DEFAULT '',
595 `name` varchar(32) DEFAULT NULL,
596 `title` smallint(6) NOT NULL DEFAULT '0',
597 `audionum` tinyint(4) NOT NULL DEFAULT '-1',
598 `subtitlenum` tinyint(4) NOT NULL DEFAULT '-1',
599 `framenum` bigint(20) NOT NULL DEFAULT '0',
600 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
601 PRIMARY KEY (`serialid`)
602) ENGINE=MyISAM DEFAULT CHARSET=utf8;
603
604--
605-- Dumping data for table `dvdbookmark`
606--
607
608/*!40000 ALTER TABLE `dvdbookmark` DISABLE KEYS */;
609/*!40000 ALTER TABLE `dvdbookmark` ENABLE KEYS */;
610
611
612--
613-- Definition of table `eit_cache`
614--
615
616DROP TABLE IF EXISTS `eit_cache`;
617CREATE TABLE `eit_cache` (
618 `chanid` int(10) NOT NULL,
619 `eventid` int(10) unsigned NOT NULL DEFAULT '0',
620 `tableid` tinyint(3) unsigned NOT NULL,
621 `version` tinyint(3) unsigned NOT NULL,
622 `endtime` int(10) unsigned NOT NULL,
623 `status` tinyint(4) NOT NULL DEFAULT '0',
624 PRIMARY KEY (`chanid`,`eventid`,`status`)
625) ENGINE=MyISAM DEFAULT CHARSET=utf8;
626
627--
628-- Dumping data for table `eit_cache`
629--
630
631/*!40000 ALTER TABLE `eit_cache` DISABLE KEYS */;
632/*!40000 ALTER TABLE `eit_cache` ENABLE KEYS */;
633
634
635--
636-- Definition of table `housekeeping`
637--
638
639DROP TABLE IF EXISTS `housekeeping`;
640CREATE TABLE `housekeeping` (
641 `tag` varchar(64) NOT NULL DEFAULT '',
642 `lastrun` datetime DEFAULT NULL,
643 PRIMARY KEY (`tag`)
644) ENGINE=MyISAM DEFAULT CHARSET=utf8;
645
646--
647-- Dumping data for table `housekeeping`
648--
649
650/*!40000 ALTER TABLE `housekeeping` DISABLE KEYS */;
651INSERT INTO `housekeeping` (`tag`,`lastrun`) VALUES
652 ('BackupDB','2011-08-10 07:26:02');
653/*!40000 ALTER TABLE `housekeeping` ENABLE KEYS */;
654
655
656--
657-- Definition of table `inputgroup`
658--
659
660DROP TABLE IF EXISTS `inputgroup`;
661CREATE TABLE `inputgroup` (
662 `cardinputid` int(10) unsigned NOT NULL,
663 `inputgroupid` int(10) unsigned NOT NULL,
664 `inputgroupname` varchar(32) NOT NULL
665) ENGINE=MyISAM DEFAULT CHARSET=utf8;
666
667--
668-- Dumping data for table `inputgroup`
669--
670
671/*!40000 ALTER TABLE `inputgroup` DISABLE KEYS */;
672/*!40000 ALTER TABLE `inputgroup` ENABLE KEYS */;
673
674
675--
676-- Definition of table `inuseprograms`
677--
678
679DROP TABLE IF EXISTS `inuseprograms`;
680CREATE TABLE `inuseprograms` (
681 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
682 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
683 `recusage` varchar(128) NOT NULL DEFAULT '',
684 `lastupdatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
685 `hostname` varchar(64) NOT NULL DEFAULT '',
686 `rechost` varchar(64) NOT NULL,
687 `recdir` varchar(255) NOT NULL DEFAULT '',
688 KEY `chanid` (`chanid`,`starttime`),
689 KEY `recusage` (`recusage`,`lastupdatetime`)
690) ENGINE=MyISAM DEFAULT CHARSET=utf8;
691
692--
693-- Dumping data for table `inuseprograms`
694--
695
696/*!40000 ALTER TABLE `inuseprograms` DISABLE KEYS */;
697/*!40000 ALTER TABLE `inuseprograms` ENABLE KEYS */;
698
699
700--
701-- Definition of table `jobqueue`
702--
703
704DROP TABLE IF EXISTS `jobqueue`;
705CREATE TABLE `jobqueue` (
706 `id` int(11) NOT NULL AUTO_INCREMENT,
707 `chanid` int(10) NOT NULL DEFAULT '0',
708 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
709 `inserttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
710 `type` int(11) NOT NULL DEFAULT '0',
711 `cmds` int(11) NOT NULL DEFAULT '0',
712 `flags` int(11) NOT NULL DEFAULT '0',
713 `status` int(11) NOT NULL DEFAULT '0',
714 `statustime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
715 `hostname` varchar(64) NOT NULL DEFAULT '',
716 `args` blob NOT NULL,
717 `comment` varchar(128) NOT NULL DEFAULT '',
718 `schedruntime` datetime NOT NULL DEFAULT '2007-01-01 00:00:00',
719 PRIMARY KEY (`id`),
720 UNIQUE KEY `chanid` (`chanid`,`starttime`,`type`,`inserttime`)
721) ENGINE=MyISAM DEFAULT CHARSET=utf8;
722
723--
724-- Dumping data for table `jobqueue`
725--
726
727/*!40000 ALTER TABLE `jobqueue` DISABLE KEYS */;
728/*!40000 ALTER TABLE `jobqueue` ENABLE KEYS */;
729
730
731--
732-- Definition of table `jumppoints`
733--
734
735DROP TABLE IF EXISTS `jumppoints`;
736CREATE TABLE `jumppoints` (
737 `destination` varchar(128) NOT NULL DEFAULT '',
738 `description` varchar(255) DEFAULT NULL,
739 `keylist` varchar(128) DEFAULT NULL,
740 `hostname` varchar(64) NOT NULL DEFAULT '',
741 PRIMARY KEY (`destination`,`hostname`)
742) ENGINE=MyISAM DEFAULT CHARSET=utf8;
743
744--
745-- Dumping data for table `jumppoints`
746--
747
748/*!40000 ALTER TABLE `jumppoints` DISABLE KEYS */;
749/*!40000 ALTER TABLE `jumppoints` ENABLE KEYS */;
750
751
752--
753-- Definition of table `keybindings`
754--
755
756DROP TABLE IF EXISTS `keybindings`;
757CREATE TABLE `keybindings` (
758 `context` varchar(32) NOT NULL DEFAULT '',
759 `action` varchar(32) NOT NULL DEFAULT '',
760 `description` varchar(255) DEFAULT NULL,
761 `keylist` varchar(128) DEFAULT NULL,
762 `hostname` varchar(64) NOT NULL DEFAULT '',
763 PRIMARY KEY (`context`,`action`,`hostname`)
764) ENGINE=MyISAM DEFAULT CHARSET=utf8;
765
766--
767-- Dumping data for table `keybindings`
768--
769
770/*!40000 ALTER TABLE `keybindings` DISABLE KEYS */;
771INSERT INTO `keybindings` (`context`,`action`,`description`,`keylist`,`hostname`) VALUES
772 ('Global','UP','Up Arrow','Up','nythtv03'),
773 ('Global','DOWN','Down Arrow','Down','nythtv03'),
774 ('Global','LEFT','Left Arrow','Left','nythtv03'),
775 ('Global','RIGHT','Right Arrow','Right','nythtv03'),
776 ('Global','NEXT','Move to next widget','Tab','nythtv03'),
777 ('Global','PREVIOUS','Move to preview widget','Backtab','nythtv03'),
778 ('Global','SELECT','Select','Return,Enter,Space','nythtv03'),
779 ('Global','BACKSPACE','Backspace','Backspace','nythtv03'),
780 ('Global','ESCAPE','Escape','Esc','nythtv03'),
781 ('Global','MENU','Pop-up menu','M','nythtv03'),
782 ('Global','INFO','More information','I','nythtv03'),
783 ('Global','DELETE','Delete','D','nythtv03'),
784 ('Global','EDIT','Edit','E','nythtv03'),
785 ('Global','SCREENSHOT','Save screenshot','','nythtv03'),
786 ('Global','HANDLEMEDIA','Play a media resource','','nythtv03'),
787 ('Global','PAGEUP','Page Up','PgUp','nythtv03'),
788 ('Global','PAGEDOWN','Page Down','PgDown','nythtv03'),
789 ('Global','PAGETOP','Page to top of list','','nythtv03'),
790 ('Global','PAGEMIDDLE','Page to middle of list','','nythtv03'),
791 ('Global','PAGEBOTTOM','Page to bottom of list','','nythtv03'),
792 ('Global','PREVVIEW','Previous View','Home','nythtv03'),
793 ('Global','NEXTVIEW','Next View','End','nythtv03'),
794 ('Global','HELP','Help','F1','nythtv03'),
795 ('Global','EJECT','Eject Removable Media','','nythtv03'),
796 ('Global','CUT','Cut text from textedit','Ctrl+X','nythtv03'),
797 ('Global','COPY','Copy text from textedit','Ctrl+C','nythtv03'),
798 ('Global','PASTE','Paste text into textedit','Ctrl+V','nythtv03'),
799 ('Global','UNDO','Undo','Ctrl+Z','nythtv03'),
800 ('Global','REDO','Redo','Ctrl+Y','nythtv03'),
801 ('Global','SEARCH','Show incremental search dialog','Ctrl+S','nythtv03'),
802 ('Global','0','0','0','nythtv03'),
803 ('Global','1','1','1','nythtv03'),
804 ('Global','2','2','2','nythtv03'),
805 ('Global','3','3','3','nythtv03'),
806 ('Global','4','4','4','nythtv03'),
807 ('Global','5','5','5','nythtv03'),
808 ('Global','6','6','6','nythtv03'),
809 ('Global','7','7','7','nythtv03'),
810 ('Global','8','8','8','nythtv03'),
811 ('Global','9','9','9','nythtv03'),
812 ('Global','SYSEVENT01','Trigger System Key Event #1','','nythtv03'),
813 ('Global','SYSEVENT02','Trigger System Key Event #2','','nythtv03'),
814 ('Global','SYSEVENT03','Trigger System Key Event #3','','nythtv03'),
815 ('Global','SYSEVENT04','Trigger System Key Event #4','','nythtv03'),
816 ('Global','SYSEVENT05','Trigger System Key Event #5','','nythtv03'),
817 ('Global','SYSEVENT06','Trigger System Key Event #6','','nythtv03'),
818 ('Global','SYSEVENT07','Trigger System Key Event #7','','nythtv03'),
819 ('Global','SYSEVENT08','Trigger System Key Event #8','','nythtv03'),
820 ('Global','SYSEVENT09','Trigger System Key Event #9','','nythtv03'),
821 ('Global','SYSEVENT10','Trigger System Key Event #10','','nythtv03'),
822 ('Browser','ZOOMIN','Zoom in on browser window','.,>','nythtv03'),
823 ('Browser','ZOOMOUT','Zoom out on browser window',',,<','nythtv03'),
824 ('Browser','TOGGLEINPUT','Toggle where keyboard input goes to','F1','nythtv03'),
825 ('Browser','MOUSEUP','Move mouse pointer up','2','nythtv03'),
826 ('Browser','MOUSEDOWN','Move mouse pointer down','8','nythtv03'),
827 ('Browser','MOUSELEFT','Move mouse pointer left','4','nythtv03'),
828 ('Browser','MOUSERIGHT','Move mouse pointer right','6','nythtv03'),
829 ('Browser','MOUSELEFTBUTTON','Mouse Left button click','5','nythtv03'),
830 ('Browser','PAGEDOWN','Scroll down half a page','9','nythtv03'),
831 ('Browser','PAGEUP','Scroll up half a page','3','nythtv03'),
832 ('Browser','PAGELEFT','Scroll left half a page','7','nythtv03'),
833 ('Browser','PAGERIGHT','Scroll right half a page','1','nythtv03'),
834 ('Browser','NEXTLINK','Move selection to next link','Z','nythtv03'),
835 ('Browser','PREVIOUSLINK','Move selection to previous link','Q','nythtv03'),
836 ('Browser','FOLLOWLINK','Follow selected link','Return,Space,Enter','nythtv03'),
837 ('Browser','HISTORYBACK','Go back to previous page','R,Backspace','nythtv03'),
838 ('Browser','HISTORYFORWARD','Go forward to previous page','F','nythtv03'),
839 ('Main Menu','EXIT','System Exit','','nythtv03'),
840 ('Main Menu','EXITPROMPT','Display System Exit Prompt','Esc','nythtv03');
841/*!40000 ALTER TABLE `keybindings` ENABLE KEYS */;
842
843
844--
845-- Definition of table `keyword`
846--
847
848DROP TABLE IF EXISTS `keyword`;
849CREATE TABLE `keyword` (
850 `phrase` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
851 `searchtype` int(10) unsigned NOT NULL DEFAULT '3',
852 UNIQUE KEY `phrase` (`phrase`,`searchtype`)
853) ENGINE=MyISAM DEFAULT CHARSET=utf8;
854
855--
856-- Dumping data for table `keyword`
857--
858
859/*!40000 ALTER TABLE `keyword` DISABLE KEYS */;
860/*!40000 ALTER TABLE `keyword` ENABLE KEYS */;
861
862
863--
864-- Definition of table `mythlog`
865--
866
867DROP TABLE IF EXISTS `mythlog`;
868CREATE TABLE `mythlog` (
869 `logid` int(10) unsigned NOT NULL AUTO_INCREMENT,
870 `module` varchar(32) NOT NULL DEFAULT '',
871 `priority` int(11) NOT NULL DEFAULT '0',
872 `acknowledged` tinyint(1) DEFAULT '0',
873 `logdate` datetime DEFAULT NULL,
874 `host` varchar(128) DEFAULT NULL,
875 `message` varchar(255) NOT NULL DEFAULT '',
876 `details` text,
877 PRIMARY KEY (`logid`),
878 KEY `module` (`module`)
879) ENGINE=MyISAM DEFAULT CHARSET=utf8;
880
881--
882-- Dumping data for table `mythlog`
883--
884
885/*!40000 ALTER TABLE `mythlog` DISABLE KEYS */;
886/*!40000 ALTER TABLE `mythlog` ENABLE KEYS */;
887
888
889--
890-- Definition of table `networkiconmap`
891--
892
893DROP TABLE IF EXISTS `networkiconmap`;
894CREATE TABLE `networkiconmap` (
895 `id` int(11) NOT NULL AUTO_INCREMENT,
896 `network` varchar(20) NOT NULL DEFAULT '',
897 `url` varchar(255) NOT NULL DEFAULT '',
898 PRIMARY KEY (`id`),
899 UNIQUE KEY `network` (`network`)
900) ENGINE=MyISAM DEFAULT CHARSET=utf8;
901
902--
903-- Dumping data for table `networkiconmap`
904--
905
906/*!40000 ALTER TABLE `networkiconmap` DISABLE KEYS */;
907/*!40000 ALTER TABLE `networkiconmap` ENABLE KEYS */;
908
909
910--
911-- Definition of table `oldfind`
912--
913
914DROP TABLE IF EXISTS `oldfind`;
915CREATE TABLE `oldfind` (
916 `recordid` int(11) NOT NULL DEFAULT '0',
917 `findid` int(11) NOT NULL DEFAULT '0',
918 PRIMARY KEY (`recordid`,`findid`)
919) ENGINE=MyISAM DEFAULT CHARSET=utf8;
920
921--
922-- Dumping data for table `oldfind`
923--
924
925/*!40000 ALTER TABLE `oldfind` DISABLE KEYS */;
926/*!40000 ALTER TABLE `oldfind` ENABLE KEYS */;
927
928
929--
930-- Definition of table `oldprogram`
931--
932
933DROP TABLE IF EXISTS `oldprogram`;
934CREATE TABLE `oldprogram` (
935 `oldtitle` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
936 `airdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
937 PRIMARY KEY (`oldtitle`)
938) ENGINE=MyISAM DEFAULT CHARSET=utf8;
939
940--
941-- Dumping data for table `oldprogram`
942--
943
944/*!40000 ALTER TABLE `oldprogram` DISABLE KEYS */;
945/*!40000 ALTER TABLE `oldprogram` ENABLE KEYS */;
946
947
948--
949-- Definition of table `oldrecorded`
950--
951
952DROP TABLE IF EXISTS `oldrecorded`;
953CREATE TABLE `oldrecorded` (
954 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
955 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
956 `endtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
957 `title` varchar(128) NOT NULL DEFAULT '',
958 `subtitle` varchar(128) NOT NULL DEFAULT '',
959 `description` text NOT NULL,
960 `category` varchar(64) NOT NULL DEFAULT '',
961 `seriesid` varchar(40) NOT NULL DEFAULT '',
962 `programid` varchar(40) NOT NULL DEFAULT '',
963 `findid` int(11) NOT NULL DEFAULT '0',
964 `recordid` int(11) NOT NULL DEFAULT '0',
965 `station` varchar(20) NOT NULL DEFAULT '',
966 `rectype` int(10) unsigned NOT NULL DEFAULT '0',
967 `duplicate` tinyint(1) NOT NULL DEFAULT '0',
968 `recstatus` int(11) NOT NULL DEFAULT '0',
969 `reactivate` smallint(6) NOT NULL DEFAULT '0',
970 `generic` tinyint(1) DEFAULT '0',
971 PRIMARY KEY (`station`,`starttime`,`title`),
972 KEY `endtime` (`endtime`),
973 KEY `title` (`title`),
974 KEY `seriesid` (`seriesid`),
975 KEY `programid` (`programid`),
976 KEY `recordid` (`recordid`),
977 KEY `recstatus` (`recstatus`,`programid`,`seriesid`),
978 KEY `recstatus_2` (`recstatus`,`title`,`subtitle`)
979) ENGINE=MyISAM DEFAULT CHARSET=utf8;
980
981--
982-- Dumping data for table `oldrecorded`
983--
984
985/*!40000 ALTER TABLE `oldrecorded` DISABLE KEYS */;
986/*!40000 ALTER TABLE `oldrecorded` ENABLE KEYS */;
987
988
989--
990-- Definition of table `people`
991--
992
993DROP TABLE IF EXISTS `people`;
994CREATE TABLE `people` (
995 `person` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
996 `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
997 PRIMARY KEY (`person`),
998 UNIQUE KEY `name` (`name`(41))
999) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1000
1001--
1002-- Dumping data for table `people`
1003--
1004
1005/*!40000 ALTER TABLE `people` DISABLE KEYS */;
1006/*!40000 ALTER TABLE `people` ENABLE KEYS */;
1007
1008
1009--
1010-- Definition of table `pidcache`
1011--
1012
1013DROP TABLE IF EXISTS `pidcache`;
1014CREATE TABLE `pidcache` (
1015 `chanid` smallint(6) NOT NULL DEFAULT '0',
1016 `pid` int(11) NOT NULL DEFAULT '-1',
1017 `tableid` int(11) NOT NULL DEFAULT '-1',
1018 KEY `chanid` (`chanid`)
1019) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1020
1021--
1022-- Dumping data for table `pidcache`
1023--
1024
1025/*!40000 ALTER TABLE `pidcache` DISABLE KEYS */;
1026/*!40000 ALTER TABLE `pidcache` ENABLE KEYS */;
1027
1028
1029--
1030-- Definition of table `playgroup`
1031--
1032
1033DROP TABLE IF EXISTS `playgroup`;
1034CREATE TABLE `playgroup` (
1035 `name` varchar(32) NOT NULL DEFAULT '',
1036 `titlematch` varchar(255) NOT NULL DEFAULT '',
1037 `skipahead` int(11) NOT NULL DEFAULT '0',
1038 `skipback` int(11) NOT NULL DEFAULT '0',
1039 `timestretch` int(11) NOT NULL DEFAULT '0',
1040 `jump` int(11) NOT NULL DEFAULT '0',
1041 PRIMARY KEY (`name`)
1042) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1043
1044--
1045-- Dumping data for table `playgroup`
1046--
1047
1048/*!40000 ALTER TABLE `playgroup` DISABLE KEYS */;
1049INSERT INTO `playgroup` (`name`,`titlematch`,`skipahead`,`skipback`,`timestretch`,`jump`) VALUES
1050 ('Default','',30,5,100,0);
1051/*!40000 ALTER TABLE `playgroup` ENABLE KEYS */;
1052
1053
1054--
1055-- Definition of table `powerpriority`
1056--
1057
1058DROP TABLE IF EXISTS `powerpriority`;
1059CREATE TABLE `powerpriority` (
1060 `priorityname` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1061 `recpriority` int(10) NOT NULL DEFAULT '0',
1062 `selectclause` text NOT NULL,
1063 PRIMARY KEY (`priorityname`)
1064) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1065
1066--
1067-- Dumping data for table `powerpriority`
1068--
1069
1070/*!40000 ALTER TABLE `powerpriority` DISABLE KEYS */;
1071/*!40000 ALTER TABLE `powerpriority` ENABLE KEYS */;
1072
1073
1074--
1075-- Definition of table `profilegroups`
1076--
1077
1078DROP TABLE IF EXISTS `profilegroups`;
1079CREATE TABLE `profilegroups` (
1080 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1081 `name` varchar(128) DEFAULT NULL,
1082 `cardtype` varchar(32) NOT NULL DEFAULT 'V4L',
1083 `is_default` int(1) DEFAULT '0',
1084 `hostname` varchar(64) DEFAULT NULL,
1085 PRIMARY KEY (`id`),
1086 UNIQUE KEY `name` (`name`,`hostname`),
1087 KEY `cardtype` (`cardtype`)
1088) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
1089
1090--
1091-- Dumping data for table `profilegroups`
1092--
1093
1094/*!40000 ALTER TABLE `profilegroups` DISABLE KEYS */;
1095INSERT INTO `profilegroups` (`id`,`name`,`cardtype`,`is_default`,`hostname`) VALUES
1096 (1,'Software Encoders (v4l based)','V4L',1,NULL),
1097 (2,'IVTV MPEG-2 Encoders','MPEG',1,NULL),
1098 (3,'Hardware MJPEG Encoders (Matrox G200-TV, Miro DC10, etc)','MJPEG',1,NULL),
1099 (4,'Hardware HDTV','HDTV',1,NULL),
1100 (5,'Hardware DVB Encoders','DVB',1,NULL),
1101 (6,'Transcoders','TRANSCODE',1,NULL),
1102 (7,'FireWire Input','FIREWIRE',1,NULL),
1103 (8,'USB Mpeg-4 Encoder (Plextor ConvertX, etc)','GO7007',1,NULL),
1104 (9,'DBOX2 Input','DBOX2',1,NULL),
1105 (10,'Freebox Input','Freebox',1,NULL),
1106 (11,'HDHomeRun Recorders','HDHOMERUN',1,NULL),
1107 (12,'CRC IP Recorders','CRC_IP',1,NULL),
1108 (13,'HD-PVR Recorders','HDPVR',1,NULL);
1109/*!40000 ALTER TABLE `profilegroups` ENABLE KEYS */;
1110
1111
1112--
1113-- Definition of table `program`
1114--
1115
1116DROP TABLE IF EXISTS `program`;
1117CREATE TABLE `program` (
1118 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1119 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1120 `endtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1121 `title` varchar(128) NOT NULL DEFAULT '',
1122 `subtitle` varchar(128) NOT NULL DEFAULT '',
1123 `description` text NOT NULL,
1124 `category` varchar(64) NOT NULL DEFAULT '',
1125 `category_type` varchar(64) NOT NULL DEFAULT '',
1126 `airdate` year(4) NOT NULL DEFAULT '0000',
1127 `stars` float NOT NULL DEFAULT '0',
1128 `previouslyshown` tinyint(4) NOT NULL DEFAULT '0',
1129 `title_pronounce` varchar(128) NOT NULL DEFAULT '',
1130 `stereo` tinyint(1) NOT NULL DEFAULT '0',
1131 `subtitled` tinyint(1) NOT NULL DEFAULT '0',
1132 `hdtv` tinyint(1) NOT NULL DEFAULT '0',
1133 `closecaptioned` tinyint(1) NOT NULL DEFAULT '0',
1134 `partnumber` int(11) NOT NULL DEFAULT '0',
1135 `parttotal` int(11) NOT NULL DEFAULT '0',
1136 `seriesid` varchar(40) NOT NULL DEFAULT '',
1137 `originalairdate` date DEFAULT NULL,
1138 `showtype` varchar(30) NOT NULL DEFAULT '',
1139 `colorcode` varchar(20) NOT NULL DEFAULT '',
1140 `syndicatedepisodenumber` varchar(20) NOT NULL DEFAULT '',
1141 `programid` varchar(40) NOT NULL DEFAULT '',
1142 `manualid` int(10) unsigned NOT NULL DEFAULT '0',
1143 `generic` tinyint(1) DEFAULT '0',
1144 `listingsource` int(11) NOT NULL DEFAULT '0',
1145 `first` tinyint(1) NOT NULL DEFAULT '0',
1146 `last` tinyint(1) NOT NULL DEFAULT '0',
1147 `audioprop` set('STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR') NOT NULL,
1148 `subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') NOT NULL,
1149 `videoprop` set('HDTV','WIDESCREEN','AVC') NOT NULL,
1150 PRIMARY KEY (`chanid`,`starttime`,`manualid`),
1151 KEY `endtime` (`endtime`),
1152 KEY `title` (`title`),
1153 KEY `title_pronounce` (`title_pronounce`),
1154 KEY `seriesid` (`seriesid`),
1155 KEY `id_start_end` (`chanid`,`starttime`,`endtime`),
1156 KEY `program_manualid` (`manualid`),
1157 KEY `previouslyshown` (`previouslyshown`),
1158 KEY `programid` (`programid`,`starttime`),
1159 KEY `starttime` (`starttime`)
1160) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1161
1162--
1163-- Dumping data for table `program`
1164--
1165
1166/*!40000 ALTER TABLE `program` DISABLE KEYS */;
1167/*!40000 ALTER TABLE `program` ENABLE KEYS */;
1168
1169
1170--
1171-- Definition of table `programgenres`
1172--
1173
1174DROP TABLE IF EXISTS `programgenres`;
1175CREATE TABLE `programgenres` (
1176 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1177 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1178 `relevance` char(1) NOT NULL DEFAULT '',
1179 `genre` varchar(30) DEFAULT NULL,
1180 PRIMARY KEY (`chanid`,`starttime`,`relevance`),
1181 KEY `genre` (`genre`)
1182) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1183
1184--
1185-- Dumping data for table `programgenres`
1186--
1187
1188/*!40000 ALTER TABLE `programgenres` DISABLE KEYS */;
1189/*!40000 ALTER TABLE `programgenres` ENABLE KEYS */;
1190
1191
1192--
1193-- Definition of table `programrating`
1194--
1195
1196DROP TABLE IF EXISTS `programrating`;
1197CREATE TABLE `programrating` (
1198 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1199 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1200 `system` varchar(8) DEFAULT NULL,
1201 `rating` varchar(16) DEFAULT NULL,
1202 UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`),
1203 KEY `starttime` (`starttime`,`system`)
1204) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1205
1206--
1207-- Dumping data for table `programrating`
1208--
1209
1210/*!40000 ALTER TABLE `programrating` DISABLE KEYS */;
1211/*!40000 ALTER TABLE `programrating` ENABLE KEYS */;
1212
1213
1214--
1215-- Definition of table `recgrouppassword`
1216--
1217
1218DROP TABLE IF EXISTS `recgrouppassword`;
1219CREATE TABLE `recgrouppassword` (
1220 `recgroup` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
1221 `password` varchar(10) NOT NULL DEFAULT '',
1222 PRIMARY KEY (`recgroup`),
1223 UNIQUE KEY `recgroup` (`recgroup`)
1224) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1225
1226--
1227-- Dumping data for table `recgrouppassword`
1228--
1229
1230/*!40000 ALTER TABLE `recgrouppassword` DISABLE KEYS */;
1231/*!40000 ALTER TABLE `recgrouppassword` ENABLE KEYS */;
1232
1233
1234--
1235-- Definition of table `record`
1236--
1237
1238DROP TABLE IF EXISTS `record`;
1239CREATE TABLE `record` (
1240 `recordid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1241 `type` int(10) unsigned NOT NULL DEFAULT '0',
1242 `chanid` int(10) unsigned DEFAULT NULL,
1243 `starttime` time NOT NULL DEFAULT '00:00:00',
1244 `startdate` date NOT NULL DEFAULT '0000-00-00',
1245 `endtime` time NOT NULL DEFAULT '00:00:00',
1246 `enddate` date NOT NULL DEFAULT '0000-00-00',
1247 `title` varchar(128) NOT NULL DEFAULT '',
1248 `subtitle` varchar(128) NOT NULL DEFAULT '',
1249 `description` text NOT NULL,
1250 `category` varchar(64) NOT NULL DEFAULT '',
1251 `profile` varchar(128) NOT NULL DEFAULT 'Default',
1252 `recpriority` int(10) NOT NULL DEFAULT '0',
1253 `autoexpire` int(11) NOT NULL DEFAULT '0',
1254 `maxepisodes` int(11) NOT NULL DEFAULT '0',
1255 `maxnewest` int(11) NOT NULL DEFAULT '0',
1256 `startoffset` int(11) NOT NULL DEFAULT '0',
1257 `endoffset` int(11) NOT NULL DEFAULT '0',
1258 `recgroup` varchar(32) NOT NULL DEFAULT 'Default',
1259 `dupmethod` int(11) NOT NULL DEFAULT '6',
1260 `dupin` int(11) NOT NULL DEFAULT '15',
1261 `station` varchar(20) NOT NULL DEFAULT '',
1262 `seriesid` varchar(40) NOT NULL DEFAULT '',
1263 `programid` varchar(40) NOT NULL DEFAULT '',
1264 `search` int(10) unsigned NOT NULL DEFAULT '0',
1265 `autotranscode` tinyint(1) NOT NULL DEFAULT '0',
1266 `autocommflag` tinyint(1) NOT NULL DEFAULT '0',
1267 `autouserjob1` tinyint(1) NOT NULL DEFAULT '0',
1268 `autouserjob2` tinyint(1) NOT NULL DEFAULT '0',
1269 `autouserjob3` tinyint(1) NOT NULL DEFAULT '0',
1270 `autouserjob4` tinyint(1) NOT NULL DEFAULT '0',
1271 `findday` tinyint(4) NOT NULL DEFAULT '0',
1272 `findtime` time NOT NULL DEFAULT '00:00:00',
1273 `findid` int(11) NOT NULL DEFAULT '0',
1274 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1275 `parentid` int(11) NOT NULL DEFAULT '0',
1276 `transcoder` int(11) NOT NULL DEFAULT '0',
1277 `tsdefault` float NOT NULL DEFAULT '1',
1278 `playgroup` varchar(32) NOT NULL DEFAULT 'Default',
1279 `prefinput` int(10) NOT NULL DEFAULT '0',
1280 `next_record` datetime NOT NULL,
1281 `last_record` datetime NOT NULL,
1282 `last_delete` datetime NOT NULL,
1283 `storagegroup` varchar(32) NOT NULL DEFAULT 'Default',
1284 `avg_delay` int(11) NOT NULL DEFAULT '100',
1285 PRIMARY KEY (`recordid`),
1286 KEY `chanid` (`chanid`,`starttime`),
1287 KEY `title` (`title`),
1288 KEY `seriesid` (`seriesid`),
1289 KEY `programid` (`programid`),
1290 KEY `maxepisodes` (`maxepisodes`),
1291 KEY `search` (`search`),
1292 KEY `type` (`type`)
1293) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1294
1295--
1296-- Dumping data for table `record`
1297--
1298
1299/*!40000 ALTER TABLE `record` DISABLE KEYS */;
1300/*!40000 ALTER TABLE `record` ENABLE KEYS */;
1301
1302
1303--
1304-- Definition of table `recorded`
1305--
1306
1307DROP TABLE IF EXISTS `recorded`;
1308CREATE TABLE `recorded` (
1309 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1310 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1311 `endtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1312 `title` varchar(128) NOT NULL DEFAULT '',
1313 `subtitle` varchar(128) NOT NULL DEFAULT '',
1314 `description` text NOT NULL,
1315 `category` varchar(64) NOT NULL DEFAULT '',
1316 `hostname` varchar(64) NOT NULL DEFAULT '',
1317 `bookmark` tinyint(1) NOT NULL DEFAULT '0',
1318 `editing` int(10) unsigned NOT NULL DEFAULT '0',
1319 `cutlist` tinyint(1) NOT NULL DEFAULT '0',
1320 `autoexpire` int(11) NOT NULL DEFAULT '0',
1321 `commflagged` int(10) unsigned NOT NULL DEFAULT '0',
1322 `recgroup` varchar(32) NOT NULL DEFAULT 'Default',
1323 `recordid` int(11) DEFAULT NULL,
1324 `seriesid` varchar(40) NOT NULL DEFAULT '',
1325 `programid` varchar(40) NOT NULL DEFAULT '',
1326 `lastmodified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1327 `filesize` bigint(20) NOT NULL DEFAULT '0',
1328 `stars` float NOT NULL DEFAULT '0',
1329 `previouslyshown` tinyint(1) DEFAULT '0',
1330 `originalairdate` date DEFAULT NULL,
1331 `preserve` tinyint(1) NOT NULL DEFAULT '0',
1332 `findid` int(11) NOT NULL DEFAULT '0',
1333 `deletepending` tinyint(1) NOT NULL DEFAULT '0',
1334 `transcoder` int(11) NOT NULL DEFAULT '0',
1335 `timestretch` float NOT NULL DEFAULT '1',
1336 `recpriority` int(11) NOT NULL DEFAULT '0',
1337 `basename` varchar(255) NOT NULL,
1338 `progstart` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1339 `progend` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1340 `playgroup` varchar(32) NOT NULL DEFAULT 'Default',
1341 `profile` varchar(32) NOT NULL DEFAULT '',
1342 `duplicate` tinyint(1) NOT NULL DEFAULT '0',
1343 `transcoded` tinyint(1) NOT NULL DEFAULT '0',
1344 `watched` tinyint(4) NOT NULL DEFAULT '0',
1345 `storagegroup` varchar(32) NOT NULL DEFAULT 'Default',
1346 PRIMARY KEY (`chanid`,`starttime`),
1347 KEY `endtime` (`endtime`),
1348 KEY `seriesid` (`seriesid`),
1349 KEY `programid` (`programid`),
1350 KEY `title` (`title`),
1351 KEY `recordid` (`recordid`),
1352 KEY `deletepending` (`deletepending`,`lastmodified`),
1353 KEY `recgroup` (`recgroup`,`endtime`)
1354) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1355
1356--
1357-- Dumping data for table `recorded`
1358--
1359
1360/*!40000 ALTER TABLE `recorded` DISABLE KEYS */;
1361/*!40000 ALTER TABLE `recorded` ENABLE KEYS */;
1362
1363
1364--
1365-- Definition of table `recordedcredits`
1366--
1367
1368DROP TABLE IF EXISTS `recordedcredits`;
1369CREATE TABLE `recordedcredits` (
1370 `person` mediumint(8) unsigned NOT NULL DEFAULT '0',
1371 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1372 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1373 `role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL DEFAULT '',
1374 UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),
1375 KEY `person` (`person`,`role`)
1376) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1377
1378--
1379-- Dumping data for table `recordedcredits`
1380--
1381
1382/*!40000 ALTER TABLE `recordedcredits` DISABLE KEYS */;
1383/*!40000 ALTER TABLE `recordedcredits` ENABLE KEYS */;
1384
1385
1386--
1387-- Definition of table `recordedfile`
1388--
1389
1390DROP TABLE IF EXISTS `recordedfile`;
1391CREATE TABLE `recordedfile` (
1392 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1393 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1394 `basename` varchar(128) NOT NULL DEFAULT '',
1395 `filesize` bigint(20) NOT NULL DEFAULT '0',
1396 `width` smallint(5) unsigned NOT NULL DEFAULT '0',
1397 `height` smallint(5) unsigned NOT NULL DEFAULT '0',
1398 `fps` float(6,3) NOT NULL DEFAULT '0.000',
1399 `aspect` float(8,6) NOT NULL DEFAULT '0.000000',
1400 `audio_sample_rate` smallint(5) unsigned NOT NULL DEFAULT '0',
1401 `audio_bits_per_sample` smallint(5) unsigned NOT NULL DEFAULT '0',
1402 `audio_channels` tinyint(3) unsigned NOT NULL DEFAULT '0',
1403 `audio_type` varchar(255) NOT NULL DEFAULT '',
1404 `video_type` varchar(255) NOT NULL DEFAULT '',
1405 `comment` varchar(255) NOT NULL DEFAULT '',
1406 PRIMARY KEY (`chanid`,`starttime`),
1407 KEY `basename` (`basename`)
1408) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1409
1410--
1411-- Dumping data for table `recordedfile`
1412--
1413
1414/*!40000 ALTER TABLE `recordedfile` DISABLE KEYS */;
1415/*!40000 ALTER TABLE `recordedfile` ENABLE KEYS */;
1416
1417
1418--
1419-- Definition of table `recordedmarkup`
1420--
1421
1422DROP TABLE IF EXISTS `recordedmarkup`;
1423CREATE TABLE `recordedmarkup` (
1424 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1425 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1426 `mark` mediumint(8) unsigned NOT NULL DEFAULT '0',
1427 `type` tinyint(4) NOT NULL DEFAULT '0',
1428 `data` int(11) unsigned DEFAULT NULL,
1429 PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`)
1430) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1431
1432--
1433-- Dumping data for table `recordedmarkup`
1434--
1435
1436/*!40000 ALTER TABLE `recordedmarkup` DISABLE KEYS */;
1437/*!40000 ALTER TABLE `recordedmarkup` ENABLE KEYS */;
1438
1439
1440--
1441-- Definition of table `recordedprogram`
1442--
1443
1444DROP TABLE IF EXISTS `recordedprogram`;
1445CREATE TABLE `recordedprogram` (
1446 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1447 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1448 `endtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1449 `title` varchar(128) NOT NULL DEFAULT '',
1450 `subtitle` varchar(128) NOT NULL DEFAULT '',
1451 `description` text NOT NULL,
1452 `category` varchar(64) NOT NULL DEFAULT '',
1453 `category_type` varchar(64) NOT NULL DEFAULT '',
1454 `airdate` year(4) NOT NULL DEFAULT '0000',
1455 `stars` float unsigned NOT NULL DEFAULT '0',
1456 `previouslyshown` tinyint(4) NOT NULL DEFAULT '0',
1457 `title_pronounce` varchar(128) NOT NULL DEFAULT '',
1458 `stereo` tinyint(1) NOT NULL DEFAULT '0',
1459 `subtitled` tinyint(1) NOT NULL DEFAULT '0',
1460 `hdtv` tinyint(1) NOT NULL DEFAULT '0',
1461 `closecaptioned` tinyint(1) NOT NULL DEFAULT '0',
1462 `partnumber` int(11) NOT NULL DEFAULT '0',
1463 `parttotal` int(11) NOT NULL DEFAULT '0',
1464 `seriesid` varchar(40) NOT NULL DEFAULT '',
1465 `originalairdate` date DEFAULT NULL,
1466 `showtype` varchar(30) NOT NULL DEFAULT '',
1467 `colorcode` varchar(20) NOT NULL DEFAULT '',
1468 `syndicatedepisodenumber` varchar(20) NOT NULL DEFAULT '',
1469 `programid` varchar(40) NOT NULL DEFAULT '',
1470 `manualid` int(10) unsigned NOT NULL DEFAULT '0',
1471 `generic` tinyint(1) DEFAULT '0',
1472 `listingsource` int(11) NOT NULL DEFAULT '0',
1473 `first` tinyint(1) NOT NULL DEFAULT '0',
1474 `last` tinyint(1) NOT NULL DEFAULT '0',
1475 `audioprop` set('STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR') NOT NULL,
1476 `subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') NOT NULL,
1477 `videoprop` set('HDTV','WIDESCREEN','AVC') NOT NULL,
1478 PRIMARY KEY (`chanid`,`starttime`,`manualid`),
1479 KEY `endtime` (`endtime`),
1480 KEY `title` (`title`),
1481 KEY `title_pronounce` (`title_pronounce`),
1482 KEY `seriesid` (`seriesid`),
1483 KEY `programid` (`programid`),
1484 KEY `id_start_end` (`chanid`,`starttime`,`endtime`)
1485) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1486
1487--
1488-- Dumping data for table `recordedprogram`
1489--
1490
1491/*!40000 ALTER TABLE `recordedprogram` DISABLE KEYS */;
1492/*!40000 ALTER TABLE `recordedprogram` ENABLE KEYS */;
1493
1494
1495--
1496-- Definition of table `recordedrating`
1497--
1498
1499DROP TABLE IF EXISTS `recordedrating`;
1500CREATE TABLE `recordedrating` (
1501 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1502 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1503 `system` varchar(8) DEFAULT NULL,
1504 `rating` varchar(16) DEFAULT NULL,
1505 UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`),
1506 KEY `starttime` (`starttime`,`system`)
1507) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1508
1509--
1510-- Dumping data for table `recordedrating`
1511--
1512
1513/*!40000 ALTER TABLE `recordedrating` DISABLE KEYS */;
1514/*!40000 ALTER TABLE `recordedrating` ENABLE KEYS */;
1515
1516
1517--
1518-- Definition of table `recordedseek`
1519--
1520
1521DROP TABLE IF EXISTS `recordedseek`;
1522CREATE TABLE `recordedseek` (
1523 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1524 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1525 `mark` mediumint(8) unsigned NOT NULL DEFAULT '0',
1526 `offset` bigint(20) unsigned NOT NULL,
1527 `type` tinyint(4) NOT NULL DEFAULT '0',
1528 PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`)
1529) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1530
1531--
1532-- Dumping data for table `recordedseek`
1533--
1534
1535/*!40000 ALTER TABLE `recordedseek` DISABLE KEYS */;
1536/*!40000 ALTER TABLE `recordedseek` ENABLE KEYS */;
1537
1538
1539--
1540-- Definition of table `recordingprofiles`
1541--
1542
1543DROP TABLE IF EXISTS `recordingprofiles`;
1544CREATE TABLE `recordingprofiles` (
1545 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1546 `name` varchar(128) DEFAULT NULL,
1547 `videocodec` varchar(128) DEFAULT NULL,
1548 `audiocodec` varchar(128) DEFAULT NULL,
1549 `profilegroup` int(10) unsigned NOT NULL DEFAULT '0',
1550 PRIMARY KEY (`id`),
1551 KEY `profilegroup` (`profilegroup`)
1552) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;
1553
1554--
1555-- Dumping data for table `recordingprofiles`
1556--
1557
1558/*!40000 ALTER TABLE `recordingprofiles` DISABLE KEYS */;
1559INSERT INTO `recordingprofiles` (`id`,`name`,`videocodec`,`audiocodec`,`profilegroup`) VALUES
1560 (1,'Default',NULL,NULL,1),
1561 (2,'Live TV',NULL,NULL,1),
1562 (3,'High Quality',NULL,NULL,1),
1563 (4,'Low Quality',NULL,NULL,1),
1564 (5,'Default',NULL,NULL,2),
1565 (6,'Live TV',NULL,NULL,2),
1566 (7,'High Quality',NULL,NULL,2),
1567 (8,'Low Quality',NULL,NULL,2),
1568 (9,'Default',NULL,NULL,3),
1569 (10,'Live TV',NULL,NULL,3),
1570 (11,'High Quality',NULL,NULL,3),
1571 (12,'Low Quality',NULL,NULL,3),
1572 (13,'Default',NULL,NULL,4),
1573 (14,'Live TV',NULL,NULL,4),
1574 (15,'High Quality',NULL,NULL,4),
1575 (16,'Low Quality',NULL,NULL,4),
1576 (17,'Default',NULL,NULL,5),
1577 (18,'Live TV',NULL,NULL,5),
1578 (19,'High Quality',NULL,NULL,5),
1579 (20,'Low Quality',NULL,NULL,5),
1580 (21,'RTjpeg/MPEG4',NULL,NULL,6),
1581 (22,'MPEG2',NULL,NULL,6),
1582 (23,'Default',NULL,NULL,8),
1583 (24,'Live TV',NULL,NULL,8),
1584 (25,'High Quality',NULL,NULL,8),
1585 (26,'Low Quality',NULL,NULL,8),
1586 (27,'High Quality',NULL,NULL,6),
1587 (28,'Medium Quality',NULL,NULL,6),
1588 (29,'Low Quality',NULL,NULL,6),
1589 (30,'Default',NULL,NULL,10),
1590 (31,'Live TV',NULL,NULL,10),
1591 (32,'High Quality',NULL,NULL,10),
1592 (33,'Low Quality',NULL,NULL,10),
1593 (34,'Default',NULL,NULL,11),
1594 (35,'Live TV',NULL,NULL,11),
1595 (36,'High Quality',NULL,NULL,11),
1596 (37,'Low Quality',NULL,NULL,11),
1597 (38,'Default',NULL,NULL,12),
1598 (39,'Live TV',NULL,NULL,12),
1599 (40,'High Quality',NULL,NULL,12),
1600 (41,'Low Quality',NULL,NULL,12),
1601 (42,'Default',NULL,NULL,7),
1602 (43,'Live TV',NULL,NULL,7),
1603 (44,'High Quality',NULL,NULL,7),
1604 (45,'Low Quality',NULL,NULL,7),
1605 (46,'Default',NULL,NULL,9),
1606 (47,'Live TV',NULL,NULL,9),
1607 (48,'High Quality',NULL,NULL,9),
1608 (49,'Low Quality',NULL,NULL,9),
1609 (50,'Default',NULL,NULL,13),
1610 (51,'Live TV',NULL,NULL,13),
1611 (52,'High Quality',NULL,NULL,13),
1612 (53,'Low Quality',NULL,NULL,13);
1613/*!40000 ALTER TABLE `recordingprofiles` ENABLE KEYS */;
1614
1615
1616--
1617-- Definition of table `recordmatch`
1618--
1619
1620DROP TABLE IF EXISTS `recordmatch`;
1621CREATE TABLE `recordmatch` (
1622 `recordid` int(10) unsigned DEFAULT NULL,
1623 `chanid` int(10) unsigned DEFAULT NULL,
1624 `starttime` datetime DEFAULT NULL,
1625 `manualid` int(10) unsigned DEFAULT NULL,
1626 `oldrecduplicate` tinyint(1) DEFAULT NULL,
1627 `recduplicate` tinyint(1) DEFAULT NULL,
1628 `findduplicate` tinyint(1) DEFAULT NULL,
1629 `oldrecstatus` int(11) DEFAULT NULL,
1630 KEY `recordid` (`recordid`)
1631) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1632
1633--
1634-- Dumping data for table `recordmatch`
1635--
1636
1637/*!40000 ALTER TABLE `recordmatch` DISABLE KEYS */;
1638/*!40000 ALTER TABLE `recordmatch` ENABLE KEYS */;
1639
1640
1641--
1642-- Definition of table `schemalock`
1643--
1644
1645DROP TABLE IF EXISTS `schemalock`;
1646CREATE TABLE `schemalock` (
1647 `schemalock` int(1) DEFAULT NULL
1648) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1649
1650--
1651-- Dumping data for table `schemalock`
1652--
1653
1654/*!40000 ALTER TABLE `schemalock` DISABLE KEYS */;
1655/*!40000 ALTER TABLE `schemalock` ENABLE KEYS */;
1656
1657
1658--
1659-- Definition of table `settings`
1660--
1661
1662DROP TABLE IF EXISTS `settings`;
1663CREATE TABLE `settings` (
1664 `value` varchar(128) NOT NULL DEFAULT '',
1665 `data` text,
1666 `hostname` varchar(64) DEFAULT NULL,
1667 KEY `value` (`value`,`hostname`)
1668) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1669
1670--
1671-- Dumping data for table `settings`
1672--
1673
1674/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
1675INSERT INTO `settings` (`value`,`data`,`hostname`) VALUES
1676 ('mythfilldatabaseLastRunStart',NULL,NULL),
1677 ('mythfilldatabaseLastRunEnd',NULL,NULL),
1678 ('mythfilldatabaseLastRunStatus',NULL,NULL),
1679 ('DataDirectMessage',NULL,NULL),
1680 ('HaveRepeats','0',NULL),
1681 ('DBSchemaVer','1226',NULL),
1682 ('DefaultTranscoder','0',NULL);
1683/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
1684
1685
1686--
1687-- Definition of table `storagegroup`
1688--
1689
1690DROP TABLE IF EXISTS `storagegroup`;
1691CREATE TABLE `storagegroup` (
1692 `id` int(11) NOT NULL AUTO_INCREMENT,
1693 `groupname` varchar(32) NOT NULL,
1694 `hostname` varchar(64) NOT NULL DEFAULT '',
1695 `dirname` varchar(235) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
1696 PRIMARY KEY (`id`),
1697 UNIQUE KEY `grouphostdir` (`groupname`,`hostname`,`dirname`),
1698 KEY `hostname` (`hostname`)
1699) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1700
1701--
1702-- Dumping data for table `storagegroup`
1703--
1704
1705/*!40000 ALTER TABLE `storagegroup` DISABLE KEYS */;
1706/*!40000 ALTER TABLE `storagegroup` ENABLE KEYS */;
1707
1708
1709--
1710-- Definition of table `tvchain`
1711--
1712
1713DROP TABLE IF EXISTS `tvchain`;
1714CREATE TABLE `tvchain` (
1715 `chanid` int(10) unsigned NOT NULL DEFAULT '0',
1716 `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1717 `chainid` varchar(128) NOT NULL DEFAULT '',
1718 `chainpos` int(10) NOT NULL DEFAULT '0',
1719 `discontinuity` tinyint(1) NOT NULL DEFAULT '0',
1720 `watching` int(10) NOT NULL DEFAULT '0',
1721 `hostprefix` varchar(128) NOT NULL DEFAULT '',
1722 `cardtype` varchar(32) NOT NULL DEFAULT 'V4L',
1723 `input` varchar(32) NOT NULL DEFAULT '',
1724 `channame` varchar(32) NOT NULL DEFAULT '',
1725 `endtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1726 PRIMARY KEY (`chanid`,`starttime`)
1727) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1728
1729--
1730-- Dumping data for table `tvchain`
1731--
1732
1733/*!40000 ALTER TABLE `tvchain` DISABLE KEYS */;
1734/*!40000 ALTER TABLE `tvchain` ENABLE KEYS */;
1735
1736
1737--
1738-- Definition of table `upnpmedia`
1739--
1740
1741DROP TABLE IF EXISTS `upnpmedia`;
1742CREATE TABLE `upnpmedia` (
1743 `intid` int(10) unsigned NOT NULL DEFAULT '0',
1744 `class` varchar(64) NOT NULL DEFAULT '',
1745 `itemtype` varchar(128) NOT NULL DEFAULT '',
1746 `parentid` int(10) unsigned NOT NULL DEFAULT '0',
1747 `itemproperties` varchar(255) NOT NULL DEFAULT '',
1748 `filepath` varchar(512) NOT NULL DEFAULT '',
1749 `title` varchar(255) NOT NULL DEFAULT '',
1750 `filename` varchar(512) NOT NULL DEFAULT '',
1751 `coverart` varchar(512) NOT NULL DEFAULT '',
1752 PRIMARY KEY (`intid`),
1753 KEY `class` (`class`),
1754 KEY `filepath` (`filepath`(333)),
1755 KEY `parentid` (`parentid`)
1756) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1757
1758--
1759-- Dumping data for table `upnpmedia`
1760--
1761
1762/*!40000 ALTER TABLE `upnpmedia` DISABLE KEYS */;
1763/*!40000 ALTER TABLE `upnpmedia` ENABLE KEYS */;
1764
1765
1766--
1767-- Definition of table `videosource`
1768--
1769
1770DROP TABLE IF EXISTS `videosource`;
1771CREATE TABLE `videosource` (
1772 `sourceid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1773 `name` varchar(128) NOT NULL DEFAULT '',
1774 `xmltvgrabber` varchar(128) DEFAULT NULL,
1775 `userid` varchar(128) NOT NULL DEFAULT '',
1776 `freqtable` varchar(16) NOT NULL DEFAULT 'default',
1777 `lineupid` varchar(64) DEFAULT NULL,
1778 `password` varchar(64) DEFAULT NULL,
1779 `useeit` smallint(6) NOT NULL DEFAULT '0',
1780 PRIMARY KEY (`sourceid`),
1781 UNIQUE KEY `name` (`name`)
1782) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1783
1784--
1785-- Dumping data for table `videosource`
1786--
1787
1788/*!40000 ALTER TABLE `videosource` DISABLE KEYS */;
1789/*!40000 ALTER TABLE `videosource` ENABLE KEYS */;
1790
1791
1792
1793
1794/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1795/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1796/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1797/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1798/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1799/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1800/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;