Skip to content

Instantly share code, notes, and snippets.

@dapi

dapi/epg.sql

Created July 22, 2020 08:52
Show Gist options
  • Save dapi/f84c29062342a8e3e69565b29b424ca6 to your computer and use it in GitHub Desktop.
Save dapi/f84c29062342a8e3e69565b29b424ca6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment