Ticket #8694: mythconverg.record.sql

File mythconverg.record.sql, 3.0 KB (added by Federico <federico.ferri@…>, 10 years ago)
Line 
1--
2-- Table structure for table `record`
3--
4
5DROP TABLE IF EXISTS `record`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `record` (
9  `recordid` int(10) unsigned NOT NULL AUTO_INCREMENT,
10  `type` int(10) unsigned NOT NULL DEFAULT '0',
11  `chanid` int(10) unsigned DEFAULT NULL,
12  `starttime` time NOT NULL DEFAULT '00:00:00',
13  `startdate` date NOT NULL DEFAULT '0000-00-00',
14  `endtime` time NOT NULL DEFAULT '00:00:00',
15  `enddate` date NOT NULL DEFAULT '0000-00-00',
16  `title` varchar(128) NOT NULL DEFAULT '',
17  `subtitle` varchar(128) NOT NULL DEFAULT '',
18  `description` varchar(16000) NOT NULL DEFAULT '',
19  `category` varchar(64) NOT NULL DEFAULT '',
20  `profile` varchar(128) NOT NULL DEFAULT 'Default',
21  `recpriority` int(10) NOT NULL DEFAULT '0',
22  `autoexpire` int(11) NOT NULL DEFAULT '0',
23  `maxepisodes` int(11) NOT NULL DEFAULT '0',
24  `maxnewest` int(11) NOT NULL DEFAULT '0',
25  `startoffset` int(11) NOT NULL DEFAULT '0',
26  `endoffset` int(11) NOT NULL DEFAULT '0',
27  `recgroup` varchar(32) NOT NULL DEFAULT 'Default',
28  `dupmethod` int(11) NOT NULL DEFAULT '6',
29  `dupin` int(11) NOT NULL DEFAULT '15',
30  `station` varchar(20) NOT NULL DEFAULT '',
31  `seriesid` varchar(40) NOT NULL DEFAULT '',
32  `programid` varchar(40) NOT NULL DEFAULT '',
33  `search` int(10) unsigned NOT NULL DEFAULT '0',
34  `autotranscode` tinyint(1) NOT NULL DEFAULT '0',
35  `autocommflag` tinyint(1) NOT NULL DEFAULT '0',
36  `autouserjob1` tinyint(1) NOT NULL DEFAULT '0',
37  `autouserjob2` tinyint(1) NOT NULL DEFAULT '0',
38  `autouserjob3` tinyint(1) NOT NULL DEFAULT '0',
39  `autouserjob4` tinyint(1) NOT NULL DEFAULT '0',
40  `findday` tinyint(4) NOT NULL DEFAULT '0',
41  `findtime` time NOT NULL DEFAULT '00:00:00',
42  `findid` int(11) NOT NULL DEFAULT '0',
43  `inactive` tinyint(1) NOT NULL DEFAULT '0',
44  `parentid` int(11) NOT NULL DEFAULT '0',
45  `transcoder` int(11) NOT NULL DEFAULT '0',
46  `playgroup` varchar(32) NOT NULL DEFAULT 'Default',
47  `prefinput` int(10) NOT NULL DEFAULT '0',
48  `next_record` datetime NOT NULL,
49  `last_record` datetime NOT NULL,
50  `last_delete` datetime NOT NULL,
51  `storagegroup` varchar(32) NOT NULL DEFAULT 'Default',
52  `avg_delay` int(11) NOT NULL DEFAULT '100',
53  PRIMARY KEY (`recordid`),
54  KEY `chanid` (`chanid`,`starttime`),
55  KEY `title` (`title`),
56  KEY `seriesid` (`seriesid`),
57  KEY `programid` (`programid`),
58  KEY `maxepisodes` (`maxepisodes`),
59  KEY `search` (`search`),
60  KEY `type` (`type`)
61) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `record`
66--
67
68LOCK TABLES `record` WRITE;
69/*!40000 ALTER TABLE `record` DISABLE KEYS */;
70INSERT INTO `record` VALUES (1,9,0,'11:50:58','2010-08-05','11:50:58','2010-08-05','lost (Title Search)','','lost','','Default',0,1,0,0,0,0,'Default',6,15,'','','',2,0,1,0,0,0,0,5,'00:00:00',734354,0,0,0,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','Default',100);
71/*!40000 ALTER TABLE `record` ENABLE KEYS */;
72UNLOCK TABLES;