1 | -- |
---|
2 | -- Table structure for table `record` |
---|
3 | -- |
---|
4 | |
---|
5 | DROP TABLE IF EXISTS `record`; |
---|
6 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
7 | /*!40101 SET character_set_client = utf8 */; |
---|
8 | CREATE 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 | |
---|
68 | LOCK TABLES `record` WRITE; |
---|
69 | /*!40000 ALTER TABLE `record` DISABLE KEYS */; |
---|
70 | INSERT 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 */; |
---|
72 | UNLOCK TABLES; |
---|