| 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;
|
|---|
