Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `program` (
- `chanid` int(10) unsigned NOT NULL DEFAULT '0',
- `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `endtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `title` varchar(128) NOT NULL DEFAULT '',
- `subtitle` varchar(128) NOT NULL DEFAULT '',
- `description` varchar(16000) NOT NULL DEFAULT '',
- `category` varchar(64) NOT NULL DEFAULT '',
- `category_type` varchar(64) NOT NULL DEFAULT '',
- `airdate` year(4) NOT NULL DEFAULT '0000',
- `stars` float NOT NULL DEFAULT '0',
- `previouslyshown` tinyint(4) NOT NULL DEFAULT '0',
- `title_pronounce` varchar(128) NOT NULL DEFAULT '',
- `stereo` tinyint(1) NOT NULL DEFAULT '0',
- `subtitled` tinyint(1) NOT NULL DEFAULT '0',
- `hdtv` tinyint(1) NOT NULL DEFAULT '0',
- `closecaptioned` tinyint(1) NOT NULL DEFAULT '0',
- `partnumber` int(11) NOT NULL DEFAULT '0',
- `parttotal` int(11) NOT NULL DEFAULT '0',
- `seriesid` varchar(64) NOT NULL DEFAULT '',
- `originalairdate` date DEFAULT NULL,
- `showtype` varchar(30) NOT NULL DEFAULT '',
- `colorcode` varchar(20) NOT NULL DEFAULT '',
- `syndicatedepisodenumber` varchar(20) NOT NULL DEFAULT '',
- `programid` varchar(64) NOT NULL DEFAULT '',
- `manualid` int(10) unsigned NOT NULL DEFAULT '0',
- `generic` tinyint(1) DEFAULT '0',
- `listingsource` int(11) NOT NULL DEFAULT '0',
- `first` tinyint(1) NOT NULL DEFAULT '0',
- `last` tinyint(1) NOT NULL DEFAULT '0',
- `audioprop` set('STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR') NOT NULL,
- `subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') NOT NULL,
- `videoprop` set('HDTV','WIDESCREEN','AVC') NOT NULL,
- `inetref` varchar(40) DEFAULT '',
- `season` int(4) NOT NULL DEFAULT '0',
- `episode` int(4) NOT NULL DEFAULT '0',
- `totalepisodes` int(4) NOT NULL DEFAULT '0',
- PRIMARY KEY (`chanid`,`starttime`,`manualid`),
- KEY `endtime` (`endtime`),
- KEY `title_pronounce` (`title_pronounce`),
- KEY `seriesid` (`seriesid`),
- KEY `id_start_end` (`chanid`,`starttime`,`endtime`),
- KEY `program_manualid` (`manualid`),
- KEY `previouslyshown` (`previouslyshown`),
- KEY `programid` (`programid`,`starttime`),
- KEY `starttime` (`starttime`),
- KEY `subtitle` (`subtitle`),
- KEY `description` (`description`(255)),
- KEY `title_subtitle_start` (`title`,`subtitle`,`starttime`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement