DROP TABLE IF EXISTS `dle_alloha`; CREATE TABLE `dle_alloha` ( `id` int(20) unsigned NOT NULL AUTO_INCREMENT, `kp_id` int(20) unsigned NOT NULL, `year` int(6) unsigned NOT NULL, `quality` varchar(100) NOT NULL, `news_id` int(12) unsigned NOT NULL DEFAULT '0', `type` varchar(100) NOT NULL, `episode` int(6) unsigned NOT NULL DEFAULT '0', `season` int(6) unsigned NOT NULL, `status` int(20) unsigned NOT NULL DEFAULT '2', `err_time` int(12) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `status` (`status`), KEY `year` (`year`), KEY `episode` (`episode`), KEY `err_time` (`err_time`), KEY `type` (`type`), KEY `kp_id` (`kp_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `dle_post` ADD `kinopoisk_id` int(12) NOT NULL AFTER `tags`; ALTER TABLE `dle_post` ADD INDEX `kinopoisk_id` (`kinopoisk_id`); INSERT IGNORE INTO `dle_admin_sections` (`name`, `title`, `descr`, `icon`, `allow_groups`) VALUES ('alloha', 'DLE Alloha', 'Модуль для автоматического добавления, и обновления фильмов и сериалов сайта DLE по базе alloha', '', '1');