· 7 years ago · Sep 08, 2018, 11:44 AM
1CREATE DATABASE IF NOT EXISTS `mptvdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `mptvdb`;
3-- MySQL dump 10.13 Distrib 5.1.58, for debian-linux-gnu (x86_64)
4--
5-- Host: 192.168.0.3 Database: mptvdb
6-- ------------------------------------------------------
7-- Server version 5.5.16
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `channellinkagemap`
22--
23
24DROP TABLE IF EXISTS `channellinkagemap`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `channellinkagemap` (
28 `idMapping` int(11) NOT NULL AUTO_INCREMENT,
29 `idPortalChannel` int(11) NOT NULL,
30 `idLinkedChannel` int(11) NOT NULL,
31 `displayName` varchar(200) NOT NULL,
32 PRIMARY KEY (`idMapping`)
33) ENGINE=MyISAM AUTO_INCREMENT=18834 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Table structure for table `cardgroup`
38--
39
40DROP TABLE IF EXISTS `cardgroup`;
41/*!40101 SET @saved_cs_client = @@character_set_client */;
42/*!40101 SET character_set_client = utf8 */;
43CREATE TABLE `cardgroup` (
44 `idCardGroup` int(11) NOT NULL AUTO_INCREMENT,
45 `name` varchar(255) NOT NULL,
46 PRIMARY KEY (`idCardGroup`)
47) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Table structure for table `cardgroupmap`
52--
53
54DROP TABLE IF EXISTS `cardgroupmap`;
55/*!40101 SET @saved_cs_client = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `cardgroupmap` (
58 `idMapping` int(11) NOT NULL AUTO_INCREMENT,
59 `idCard` int(11) NOT NULL,
60 `idCardGroup` int(11) NOT NULL,
61 PRIMARY KEY (`idMapping`),
62 KEY `FK_CardGroupMap_Card` (`idCard`),
63 KEY `FK_CardGroupMap_CardGroup` (`idCardGroup`)
64) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Table structure for table `tuningdetail`
69--
70
71DROP TABLE IF EXISTS `tuningdetail`;
72/*!40101 SET @saved_cs_client = @@character_set_client */;
73/*!40101 SET character_set_client = utf8 */;
74CREATE TABLE `tuningdetail` (
75 `idTuning` int(11) NOT NULL AUTO_INCREMENT,
76 `idChannel` int(11) NOT NULL,
77 `name` varchar(200) NOT NULL,
78 `provider` varchar(200) NOT NULL,
79 `channelType` int(11) NOT NULL,
80 `channelNumber` int(11) NOT NULL,
81 `frequency` int(11) NOT NULL,
82 `countryId` int(11) NOT NULL,
83 `isRadio` bit(1) NOT NULL,
84 `isTv` bit(1) NOT NULL,
85 `networkId` int(11) NOT NULL,
86 `transportId` int(11) NOT NULL,
87 `serviceId` int(11) NOT NULL,
88 `pmtPid` int(11) NOT NULL,
89 `freeToAir` bit(1) NOT NULL,
90 `modulation` int(11) NOT NULL,
91 `polarisation` int(11) NOT NULL,
92 `symbolrate` int(11) NOT NULL,
93 `diseqc` int(11) NOT NULL,
94 `switchingFrequency` int(11) NOT NULL,
95 `bandwidth` int(11) NOT NULL,
96 `majorChannel` int(11) NOT NULL,
97 `minorChannel` int(11) NOT NULL,
98 `videoSource` int(11) NOT NULL,
99 `tuningSource` int(11) NOT NULL,
100 `band` int(11) NOT NULL,
101 `satIndex` int(11) NOT NULL,
102 `innerFecRate` int(11) NOT NULL,
103 `pilot` int(11) NOT NULL,
104 `rollOff` int(11) NOT NULL,
105 `url` varchar(200) NOT NULL,
106 `bitrate` int(11) NOT NULL,
107 `audioSource` int(1) NOT NULL,
108 `isVCRSignal` bit(1) NOT NULL,
109 PRIMARY KEY (`idTuning`),
110 KEY `IDX_TuningDetail1` (`idChannel`),
111 KEY `IDX_TuningDetail_Edit` (`networkId`,`transportId`,`serviceId`)
112) ENGINE=MyISAM AUTO_INCREMENT=4432 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
113/*!40101 SET character_set_client = @saved_cs_client */;
114
115--
116-- Table structure for table `timespan`
117--
118
119DROP TABLE IF EXISTS `timespan`;
120/*!40101 SET @saved_cs_client = @@character_set_client */;
121/*!40101 SET character_set_client = utf8 */;
122CREATE TABLE `timespan` (
123 `idTimespan` int(11) NOT NULL AUTO_INCREMENT,
124 `idKeyword` int(11) NOT NULL,
125 `startTime` datetime NOT NULL,
126 `endTime` datetime NOT NULL,
127 `dayOfWeek` int(11) NOT NULL,
128 PRIMARY KEY (`idTimespan`)
129) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
130/*!40101 SET character_set_client = @saved_cs_client */;
131
132--
133-- Table structure for table `satellite`
134--
135
136DROP TABLE IF EXISTS `satellite`;
137/*!40101 SET @saved_cs_client = @@character_set_client */;
138/*!40101 SET character_set_client = utf8 */;
139CREATE TABLE `satellite` (
140 `idSatellite` int(11) NOT NULL AUTO_INCREMENT,
141 `satelliteName` varchar(200) NOT NULL,
142 `transponderFileName` varchar(200) NOT NULL,
143 PRIMARY KEY (`idSatellite`)
144) ENGINE=MyISAM AUTO_INCREMENT=211 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
145/*!40101 SET character_set_client = @saved_cs_client */;
146
147--
148-- Table structure for table `radiochannelgroup`
149--
150
151DROP TABLE IF EXISTS `radiochannelgroup`;
152/*!40101 SET @saved_cs_client = @@character_set_client */;
153/*!40101 SET character_set_client = utf8 */;
154CREATE TABLE `radiochannelgroup` (
155 `idGroup` int(11) NOT NULL AUTO_INCREMENT,
156 `groupName` varchar(200) NOT NULL,
157 `sortOrder` int(11) NOT NULL,
158 PRIMARY KEY (`idGroup`),
159 KEY `IDX_RadioChannelGroup` (`sortOrder`)
160) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Table structure for table `program`
165--
166
167DROP TABLE IF EXISTS `program`;
168/*!40101 SET @saved_cs_client = @@character_set_client */;
169/*!40101 SET character_set_client = utf8 */;
170CREATE TABLE `program` (
171 `idProgram` int(11) NOT NULL AUTO_INCREMENT,
172 `idChannel` int(11) NOT NULL,
173 `startTime` datetime NOT NULL,
174 `endTime` datetime NOT NULL,
175 `title` varchar(2000) NOT NULL,
176 `description` text NOT NULL,
177 `seriesNum` varchar(200) NOT NULL,
178 `episodeNum` varchar(200) NOT NULL,
179 `genre` varchar(200) NOT NULL,
180 `originalAirDate` datetime NOT NULL,
181 `classification` varchar(200) NOT NULL,
182 `starRating` int(11) NOT NULL,
183 `parentalRating` int(11) NOT NULL,
184 `episodeName` text NOT NULL,
185 `episodePart` text NOT NULL,
186 `state` int(11) NOT NULL DEFAULT '0',
187 PRIMARY KEY (`idProgram`),
188 UNIQUE KEY `idProgramBeginEnd` (`idChannel`,`startTime`,`endTime`),
189 KEY `IDX_Program_State` (`state`)
190) ENGINE=MyISAM AUTO_INCREMENT=2527958 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
191/*!40101 SET character_set_client = @saved_cs_client */;
192
193--
194-- Table structure for table `canceledschedule`
195--
196
197DROP TABLE IF EXISTS `canceledschedule`;
198/*!40101 SET @saved_cs_client = @@character_set_client */;
199/*!40101 SET character_set_client = utf8 */;
200CREATE TABLE `canceledschedule` (
201 `idCanceledSchedule` int(11) NOT NULL AUTO_INCREMENT,
202 `idSchedule` int(11) NOT NULL,
203 `cancelDateTime` datetime NOT NULL,
204 `idChannel` int(11) NOT NULL DEFAULT '0',
205 PRIMARY KEY (`idCanceledSchedule`),
206 KEY `FK_CanceledSchedule_Schedule` (`idSchedule`)
207) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
208/*!40101 SET character_set_client = @saved_cs_client */;
209
210--
211-- Table structure for table `groupmap`
212--
213
214DROP TABLE IF EXISTS `groupmap`;
215/*!40101 SET @saved_cs_client = @@character_set_client */;
216/*!40101 SET character_set_client = utf8 */;
217CREATE TABLE `groupmap` (
218 `idMap` int(11) NOT NULL AUTO_INCREMENT,
219 `idGroup` int(11) NOT NULL,
220 `idChannel` int(11) NOT NULL,
221 `SortOrder` int(11) NOT NULL,
222 PRIMARY KEY (`idMap`),
223 KEY `FK_GroupMap_Channel` (`idChannel`),
224 KEY `FK_GroupMap_ChannelGroup` (`idGroup`)
225) ENGINE=MyISAM AUTO_INCREMENT=4269 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
226/*!40101 SET character_set_client = @saved_cs_client */;
227
228--
229-- Table structure for table `keywordmap`
230--
231
232DROP TABLE IF EXISTS `keywordmap`;
233/*!40101 SET @saved_cs_client = @@character_set_client */;
234/*!40101 SET character_set_client = utf8 */;
235CREATE TABLE `keywordmap` (
236 `idKeywordMap` int(11) NOT NULL AUTO_INCREMENT,
237 `idKeyword` int(11) NOT NULL,
238 `idChannelGroup` int(11) NOT NULL,
239 PRIMARY KEY (`idKeywordMap`)
240) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
241/*!40101 SET character_set_client = @saved_cs_client */;
242
243--
244-- Table structure for table `card`
245--
246
247DROP TABLE IF EXISTS `card`;
248/*!40101 SET @saved_cs_client = @@character_set_client */;
249/*!40101 SET character_set_client = utf8 */;
250CREATE TABLE `card` (
251 `idCard` int(11) NOT NULL AUTO_INCREMENT,
252 `devicePath` varchar(2000) NOT NULL,
253 `name` varchar(200) NOT NULL,
254 `priority` int(11) NOT NULL,
255 `grabEPG` bit(1) NOT NULL,
256 `lastEpgGrab` datetime NOT NULL,
257 `recordingFolder` varchar(256) NOT NULL,
258 `idServer` int(11) NOT NULL,
259 `enabled` bit(1) NOT NULL,
260 `camType` int(11) NOT NULL,
261 `timeshiftingFolder` varchar(256) NOT NULL,
262 `recordingFormat` int(11) NOT NULL,
263 `decryptLimit` int(11) NOT NULL,
264 `preload` bit(1) NOT NULL,
265 `CAM` bit(1) NOT NULL,
266 `NetProvider` tinyint(4) NOT NULL DEFAULT '0',
267 `stopgraph` bit(1) NOT NULL DEFAULT b'1',
268 PRIMARY KEY (`idCard`),
269 KEY `FK_Card_Server` (`idServer`)
270) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
271/*!40101 SET character_set_client = @saved_cs_client */;
272
273--
274-- Table structure for table `channelmap`
275--
276
277DROP TABLE IF EXISTS `channelmap`;
278/*!40101 SET @saved_cs_client = @@character_set_client */;
279/*!40101 SET character_set_client = utf8 */;
280CREATE TABLE `channelmap` (
281 `idChannelMap` int(11) NOT NULL AUTO_INCREMENT,
282 `idChannel` int(11) NOT NULL,
283 `idCard` int(11) NOT NULL,
284 `epgOnly` bit(1) DEFAULT NULL,
285 PRIMARY KEY (`idChannelMap`),
286 KEY `FK_ChannelMap_Cards` (`idCard`),
287 KEY `FK_ChannelMap_Channels` (`idChannel`)
288) ENGINE=MyISAM AUTO_INCREMENT=4320 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
289/*!40101 SET character_set_client = @saved_cs_client */;
290
291--
292-- Table structure for table `keyword`
293--
294
295DROP TABLE IF EXISTS `keyword`;
296/*!40101 SET @saved_cs_client = @@character_set_client */;
297/*!40101 SET character_set_client = utf8 */;
298CREATE TABLE `keyword` (
299 `idKeyword` int(11) NOT NULL AUTO_INCREMENT,
300 `keywordName` varchar(200) NOT NULL,
301 `rating` int(11) NOT NULL,
302 `autoRecord` bit(1) NOT NULL,
303 `searchIn` int(11) NOT NULL,
304 PRIMARY KEY (`idKeyword`)
305) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
306/*!40101 SET character_set_client = @saved_cs_client */;
307
308--
309-- Table structure for table `channelgroup`
310--
311
312DROP TABLE IF EXISTS `channelgroup`;
313/*!40101 SET @saved_cs_client = @@character_set_client */;
314/*!40101 SET character_set_client = utf8 */;
315CREATE TABLE `channelgroup` (
316 `idGroup` int(11) NOT NULL AUTO_INCREMENT,
317 `groupName` varchar(200) NOT NULL,
318 `sortOrder` int(11) NOT NULL,
319 PRIMARY KEY (`idGroup`),
320 KEY `IDX_ChannelGroup` (`sortOrder`)
321) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
322/*!40101 SET character_set_client = @saved_cs_client */;
323
324--
325-- Table structure for table `schedule`
326--
327
328DROP TABLE IF EXISTS `schedule`;
329/*!40101 SET @saved_cs_client = @@character_set_client */;
330/*!40101 SET character_set_client = utf8 */;
331CREATE TABLE `schedule` (
332 `id_Schedule` int(11) NOT NULL AUTO_INCREMENT,
333 `idChannel` int(11) NOT NULL,
334 `scheduleType` int(11) NOT NULL,
335 `programName` varchar(256) NOT NULL,
336 `startTime` datetime NOT NULL,
337 `endTime` datetime NOT NULL,
338 `maxAirings` int(11) NOT NULL,
339 `priority` int(11) NOT NULL,
340 `directory` varchar(1024) NOT NULL,
341 `quality` int(11) NOT NULL,
342 `keepMethod` int(11) NOT NULL,
343 `keepDate` datetime NOT NULL,
344 `preRecordInterval` int(11) NOT NULL,
345 `postRecordInterval` int(11) NOT NULL,
346 `canceled` datetime NOT NULL,
347 `recommendedCard` int(11) NOT NULL,
348 `series` bit(1) NOT NULL,
349 `idParentSchedule` int(11) NOT NULL DEFAULT '0',
350 PRIMARY KEY (`id_Schedule`),
351 KEY `FK_Schedule_Channel` (`idChannel`),
352 KEY `IDX_Schedule_ScheduleType` (`scheduleType`),
353 KEY `IDX_Schedule_ProgramName` (`programName`),
354 KEY `IDX_Schedule_StartTime` (`startTime`),
355 KEY `IDX_Schedule_EndTime` (`endTime`)
356) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
357/*!40101 SET character_set_client = @saved_cs_client */;
358
359--
360-- Table structure for table `favorite`
361--
362
363DROP TABLE IF EXISTS `favorite`;
364/*!40101 SET @saved_cs_client = @@character_set_client */;
365/*!40101 SET character_set_client = utf8 */;
366CREATE TABLE `favorite` (
367 `idFavorite` int(11) NOT NULL AUTO_INCREMENT,
368 `idProgram` int(11) NOT NULL,
369 `priority` int(11) NOT NULL,
370 `timesWatched` int(11) NOT NULL,
371 PRIMARY KEY (`idFavorite`),
372 KEY `FK_Favorites_Programs` (`idProgram`)
373) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
374/*!40101 SET character_set_client = @saved_cs_client */;
375
376--
377-- Table structure for table `server`
378--
379
380DROP TABLE IF EXISTS `server`;
381/*!40101 SET @saved_cs_client = @@character_set_client */;
382/*!40101 SET character_set_client = utf8 */;
383CREATE TABLE `server` (
384 `idServer` int(11) NOT NULL AUTO_INCREMENT,
385 `isMaster` bit(1) NOT NULL,
386 `hostName` varchar(256) NOT NULL,
387 `rtspPort` int(11) NOT NULL DEFAULT '554',
388 PRIMARY KEY (`idServer`)
389) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
390/*!40101 SET character_set_client = @saved_cs_client */;
391
392--
393-- Table structure for table `recording`
394--
395
396DROP TABLE IF EXISTS `recording`;
397/*!40101 SET @saved_cs_client = @@character_set_client */;
398/*!40101 SET character_set_client = utf8 */;
399CREATE TABLE `recording` (
400 `idRecording` int(11) NOT NULL AUTO_INCREMENT,
401 `idChannel` int(11) NOT NULL,
402 `startTime` datetime NOT NULL,
403 `endTime` datetime NOT NULL,
404 `title` varchar(2000) NOT NULL,
405 `description` varchar(8000) NOT NULL,
406 `genre` varchar(200) NOT NULL,
407 `fileName` varchar(260) NOT NULL,
408 `keepUntil` int(11) NOT NULL,
409 `keepUntilDate` datetime NOT NULL,
410 `timesWatched` int(11) NOT NULL,
411 `idServer` int(11) NOT NULL,
412 `stopTime` int(11) NOT NULL,
413 `episodeName` text NOT NULL,
414 `seriesNum` varchar(200) NOT NULL,
415 `episodeNum` varchar(200) NOT NULL,
416 `episodePart` text NOT NULL,
417 `isRecording` bit(1) NOT NULL DEFAULT b'0',
418 `idSchedule` int(11) NOT NULL DEFAULT '0',
419 PRIMARY KEY (`idRecording`),
420 KEY `FK_Recording_Server` (`idServer`),
421 KEY `FK_Recordings_Channels` (`idChannel`),
422 KEY `IDX_Recording_Filename` (`fileName`)
423) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
424/*!40101 SET character_set_client = @saved_cs_client */;
425
426--
427-- Table structure for table `radiogroupmap`
428--
429
430DROP TABLE IF EXISTS `radiogroupmap`;
431/*!40101 SET @saved_cs_client = @@character_set_client */;
432/*!40101 SET character_set_client = utf8 */;
433CREATE TABLE `radiogroupmap` (
434 `idMap` int(11) NOT NULL AUTO_INCREMENT,
435 `idGroup` int(11) NOT NULL,
436 `idChannel` int(11) NOT NULL,
437 `SortOrder` int(11) NOT NULL,
438 PRIMARY KEY (`idMap`),
439 KEY `FK_RadioGroupMap_Channel` (`idChannel`),
440 KEY `FK_RadioGroupMap_ChannelGroup` (`idGroup`),
441 KEY `IDX_RadioGroupMap_SortOrder` (`SortOrder`)
442) ENGINE=MyISAM AUTO_INCREMENT=341 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
443/*!40101 SET character_set_client = @saved_cs_client */;
444
445--
446-- Table structure for table `personaltvguidemap`
447--
448
449DROP TABLE IF EXISTS `personaltvguidemap`;
450/*!40101 SET @saved_cs_client = @@character_set_client */;
451/*!40101 SET character_set_client = utf8 */;
452CREATE TABLE `personaltvguidemap` (
453 `idPersonalTVGuideMap` int(11) NOT NULL AUTO_INCREMENT,
454 `idKeyword` int(11) NOT NULL,
455 `idProgram` int(11) NOT NULL,
456 PRIMARY KEY (`idPersonalTVGuideMap`)
457) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
458/*!40101 SET character_set_client = @saved_cs_client */;
459
460--
461-- Table structure for table `version`
462--
463
464DROP TABLE IF EXISTS `version`;
465/*!40101 SET @saved_cs_client = @@character_set_client */;
466/*!40101 SET character_set_client = utf8 */;
467CREATE TABLE `version` (
468 `idVersion` int(11) NOT NULL AUTO_INCREMENT,
469 `versionNumber` int(11) NOT NULL,
470 PRIMARY KEY (`idVersion`)
471) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
472/*!40101 SET character_set_client = @saved_cs_client */;
473
474--
475-- Table structure for table `channel`
476--
477
478DROP TABLE IF EXISTS `channel`;
479/*!40101 SET @saved_cs_client = @@character_set_client */;
480/*!40101 SET character_set_client = utf8 */;
481CREATE TABLE `channel` (
482 `idChannel` int(11) NOT NULL AUTO_INCREMENT,
483 `name` varchar(200) NOT NULL,
484 `isRadio` bit(1) NOT NULL,
485 `isTv` bit(1) NOT NULL,
486 `timesWatched` int(11) NOT NULL,
487 `totalTimeWatched` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
488 `grabEpg` bit(1) NOT NULL,
489 `lastGrabTime` datetime NOT NULL DEFAULT '2012-01-01 00:00:01',
490 `sortOrder` int(11) NOT NULL,
491 `visibleInGuide` bit(1) NOT NULL,
492 `externalId` varchar(200) NOT NULL,
493 `freetoair` bit(1) NOT NULL,
494 `displayName` varchar(200) NOT NULL,
495 `epgHasGaps` bit(1) DEFAULT NULL,
496 PRIMARY KEY (`idChannel`),
497 KEY `idxChannel` (`isTv`,`sortOrder`),
498 KEY `idxChannelRadio` (`isRadio`)
499) ENGINE=MyISAM AUTO_INCREMENT=1414421111 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
500/*!40101 SET character_set_client = @saved_cs_client */;
501
502--
503-- Table structure for table `conflict`
504--
505
506DROP TABLE IF EXISTS `conflict`;
507/*!40101 SET @saved_cs_client = @@character_set_client */;
508/*!40101 SET character_set_client = utf8 */;
509CREATE TABLE `conflict` (
510 `idConflict` int(11) NOT NULL AUTO_INCREMENT,
511 `idSchedule` int(11) NOT NULL,
512 `idConflictingSchedule` int(11) NOT NULL,
513 `idChannel` int(11) NOT NULL,
514 `conflictDate` datetime NOT NULL,
515 `idCard` int(11) DEFAULT NULL,
516 PRIMARY KEY (`idConflict`),
517 KEY `FK_Conflict_Channel` (`idChannel`),
518 KEY `FK_Conflict_Schedule` (`idSchedule`),
519 KEY `FK_Conflict_Schedule1` (`idConflictingSchedule`)
520) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
521/*!40101 SET character_set_client = @saved_cs_client */;
522
523--
524-- Table structure for table `pendingdeletion`
525--
526
527DROP TABLE IF EXISTS `pendingdeletion`;
528/*!40101 SET @saved_cs_client = @@character_set_client */;
529/*!40101 SET character_set_client = utf8 */;
530CREATE TABLE `pendingdeletion` (
531 `idPendingDeletion` int(11) NOT NULL AUTO_INCREMENT,
532 `fileName` varchar(260) NOT NULL,
533 PRIMARY KEY (`idPendingDeletion`)
534) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
535/*!40101 SET character_set_client = @saved_cs_client */;
536
537--
538-- Table structure for table `softwareencoder`
539--
540
541DROP TABLE IF EXISTS `softwareencoder`;
542/*!40101 SET @saved_cs_client = @@character_set_client */;
543/*!40101 SET character_set_client = utf8 */;
544CREATE TABLE `softwareencoder` (
545 `idEncoder` int(11) NOT NULL AUTO_INCREMENT,
546 `priority` int(11) NOT NULL,
547 `name` varchar(200) NOT NULL,
548 `type` int(11) NOT NULL,
549 `reusable` bit(1) NOT NULL DEFAULT b'1',
550 PRIMARY KEY (`idEncoder`)
551) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
552/*!40101 SET character_set_client = @saved_cs_client */;
553
554--
555-- Table structure for table `history`
556--
557
558DROP TABLE IF EXISTS `history`;
559/*!40101 SET @saved_cs_client = @@character_set_client */;
560/*!40101 SET character_set_client = utf8 */;
561CREATE TABLE `history` (
562 `idHistory` int(11) NOT NULL AUTO_INCREMENT,
563 `idChannel` int(11) NOT NULL,
564 `startTime` datetime NOT NULL,
565 `endTime` datetime NOT NULL,
566 `title` varchar(1000) NOT NULL,
567 `description` text NOT NULL,
568 `genre` varchar(1000) NOT NULL,
569 `recorded` bit(1) NOT NULL,
570 `watched` int(11) NOT NULL,
571 PRIMARY KEY (`idHistory`),
572 KEY `FK_History_Channel` (`idChannel`)
573) ENGINE=MyISAM AUTO_INCREMENT=3970 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
574/*!40101 SET character_set_client = @saved_cs_client */;
575
576--
577-- Table structure for table `setting`
578--
579
580DROP TABLE IF EXISTS `setting`;
581/*!40101 SET @saved_cs_client = @@character_set_client */;
582/*!40101 SET character_set_client = utf8 */;
583CREATE TABLE `setting` (
584 `idSetting` int(11) NOT NULL AUTO_INCREMENT,
585 `tag` varchar(200) NOT NULL,
586 `value` varchar(4096) NOT NULL,
587 PRIMARY KEY (`idSetting`),
588 KEY `IDX_Setting_Tag` (`tag`)
589) ENGINE=MyISAM AUTO_INCREMENT=169 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
590/*!40101 SET character_set_client = @saved_cs_client */;
591
592--
593-- Table structure for table `tvmoviemapping`
594--
595
596DROP TABLE IF EXISTS `tvmoviemapping`;
597/*!40101 SET @saved_cs_client = @@character_set_client */;
598/*!40101 SET character_set_client = utf8 */;
599CREATE TABLE `tvmoviemapping` (
600 `idMapping` int(11) NOT NULL AUTO_INCREMENT,
601 `idChannel` int(11) NOT NULL,
602 `stationName` varchar(200) NOT NULL,
603 `timeSharingStart` varchar(200) NOT NULL,
604 `timeSharingEnd` varchar(200) NOT NULL,
605 PRIMARY KEY (`idMapping`),
606 KEY `FK_TvMovieMapping_Channel` (`idChannel`)
607) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
608/*!40101 SET character_set_client = @saved_cs_client */;
609
610--
611-- Table structure for table `diseqcmotor`
612--
613
614DROP TABLE IF EXISTS `diseqcmotor`;
615/*!40101 SET @saved_cs_client = @@character_set_client */;
616/*!40101 SET character_set_client = utf8 */;
617CREATE TABLE `diseqcmotor` (
618 `idDiSEqCMotor` int(11) NOT NULL AUTO_INCREMENT,
619 `idCard` int(11) NOT NULL,
620 `idSatellite` int(11) NOT NULL,
621 `position` int(11) NOT NULL,
622 PRIMARY KEY (`idDiSEqCMotor`),
623 KEY `FK_DisEqcMotor_Satellite` (`idSatellite`),
624 KEY `FK_DisEqcMotor_Card` (`idCard`)
625) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
626/*!40101 SET character_set_client = @saved_cs_client */;
627/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
628
629/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
630/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
631/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
632/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
633/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
634/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
635/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
636
637-- Dump completed on 2012-02-01 22:59:10