Table	Create Table
record	CREATE TABLE `record` (\n  `recordid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n  `type` int(10) unsigned NOT NULL DEFAULT 0,\n  `chanid` int(10) unsigned DEFAULT NULL,\n  `starttime` time DEFAULT NULL,\n  `startdate` date DEFAULT NULL,\n  `endtime` time DEFAULT NULL,\n  `enddate` date DEFAULT NULL,\n  `title` varchar(128) NOT NULL DEFAULT '',\n  `subtitle` varchar(128) NOT NULL DEFAULT '',\n  `description` varchar(16000) NOT NULL DEFAULT '',\n  `season` smallint(5) NOT NULL,\n  `episode` smallint(5) NOT NULL,\n  `category` varchar(64) NOT NULL DEFAULT '',\n  `profile` varchar(128) NOT NULL DEFAULT 'Default',\n  `recpriority` int(10) NOT NULL DEFAULT 0,\n  `autoexpire` int(11) NOT NULL DEFAULT 0,\n  `maxepisodes` int(11) NOT NULL DEFAULT 0,\n  `maxnewest` int(11) NOT NULL DEFAULT 0,\n  `startoffset` int(11) NOT NULL DEFAULT 0,\n  `endoffset` int(11) NOT NULL DEFAULT 0,\n  `recgroup` varchar(32) NOT NULL DEFAULT 'Default',\n  `dupmethod` int(11) NOT NULL DEFAULT 6,\n  `dupin` int(11) NOT NULL DEFAULT 15,\n  `station` varchar(20) NOT NULL DEFAULT '',\n  `seriesid` varchar(64) DEFAULT NULL,\n  `programid` varchar(64) DEFAULT NULL,\n  `inetref` varchar(40) NOT NULL,\n  `search` int(10) unsigned NOT NULL DEFAULT 0,\n  `autotranscode` tinyint(1) NOT NULL DEFAULT 0,\n  `autocommflag` tinyint(1) NOT NULL DEFAULT 0,\n  `autouserjob1` tinyint(1) NOT NULL DEFAULT 0,\n  `autouserjob2` tinyint(1) NOT NULL DEFAULT 0,\n  `autouserjob3` tinyint(1) NOT NULL DEFAULT 0,\n  `autouserjob4` tinyint(1) NOT NULL DEFAULT 0,\n  `autometadata` tinyint(1) NOT NULL DEFAULT 0,\n  `findday` tinyint(4) NOT NULL DEFAULT 0,\n  `findtime` time NOT NULL DEFAULT '00:00:00',\n  `findid` int(11) NOT NULL DEFAULT 0,\n  `inactive` tinyint(1) NOT NULL DEFAULT 0,\n  `parentid` int(11) NOT NULL DEFAULT 0,\n  `transcoder` int(11) NOT NULL DEFAULT 0,\n  `playgroup` varchar(32) NOT NULL DEFAULT 'Default',\n  `prefinput` int(10) NOT NULL DEFAULT 0,\n  `next_record` datetime DEFAULT NULL,\n  `last_record` datetime DEFAULT NULL,\n  `last_delete` datetime DEFAULT NULL,\n  `storagegroup` varchar(32) NOT NULL DEFAULT 'Default',\n  `avg_delay` int(11) NOT NULL DEFAULT 100,\n  `filter` int(10) unsigned NOT NULL DEFAULT 0,\n  `recgroupid` smallint(4) NOT NULL DEFAULT 1,\n  PRIMARY KEY (`recordid`),\n  UNIQUE KEY `chanid` (`chanid`,`starttime`,`startdate`,`title`,`type`),\n  KEY `title` (`title`),\n  KEY `seriesid` (`seriesid`),\n  KEY `programid` (`programid`),\n  KEY `maxepisodes` (`maxepisodes`),\n  KEY `search` (`search`),\n  KEY `type` (`type`),\n  KEY `recgroupid` (`recgroupid`)\n) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8