epg.sql

CREATE TABLE `epg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestart` timestamp NULL DEFAULT NULL,
  `timestop` timestamp NULL DEFAULT NULL,
  `title` varchar(256) DEFAULT NULL,
  `desc` text,
  `epg_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `cdnvideo` tinyint(1) DEFAULT '0',
  `rating` smallint(6) DEFAULT NULL,
  `director_id` int(11) DEFAULT NULL,
  `year` smallint(6) DEFAULT NULL,
  `time_zone` varchar(255) NOT NULL DEFAULT 'UTC+03:00',
  PRIMARY KEY (`id`),
  KEY `epg_id` (`epg_id`),
  KEY `date` (`date`),
  KEY `epg_tst_tsp` (`epg_id`,`timestart`,`timestop`)
) ENGINE=InnoDB AUTO_INCREMENT=23694966 DEFAULT CHARSET=utf8;