Просмотр архива Акул сайт

DROP TABLE IF EXISTS `cron`;
CREATE TABLE `cron` (
  `script_name`
varchar(100) NOT NULL DEFAULT '',
  `last_executed` int(11) unsigned NOT
NULL DEFAULT '0',
  `status` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY
KEY (`script_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE
`guest` ADD `duration` float NOT NULL defalt '0';
ALTER TABLE `guest` ADD
`views` int(11) NOT NULL defalt '0';

DROP TABLE IF EXISTS
`module_files`;
CREATE TABLE `module_files` (
  `module_id` int(11) NOT
NULL DEFAULT '0',
  `file` varchar(255) NOT NULL DEFAULT '',
  `md5sum`
varchar(32) NOT NULL DEFAULT '',
  KEY `module_id` (`module_id`),
  KEY
`file_md5` (`file`,`md5sum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER
TABLE `photo_comments` ADD `nickname` varchar(100) NOT NULL DEFAULT
'';

DROP TABLE IF EXISTS `playlist`;
CREATE TABLE `playlist` (
 
`playlist_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11)
unsigned NOT NULL DEFAULT '0',
  `thumb_id` int(11) unsigned NOT NULL
DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `type`
enum('public','private') NOT NULL DEFAULT 'public',
  `add_time` int(11)
unsigned NOT NULL DEFAULT '0',
  `slug` varchar(100) NOT NULL DEFAULT '',
 
`total_videos` int(3) unsigned NOT NULL DEFAULT '0',
  `duration` float NOT
NULL DEFAULT '0',
  `total_views` int(11) unsigned NOT NULL DEFAULT '0',
 
PRIMARY KEY (`playlist_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS
`playlist_videos`;
CREATE TABLE `playlist_videos` (
  `playlist_id` int(11)
unsigned NOT NULL DEFAULT '0',
  `video_id` int(11) unsigned NOT NULL
DEFAULT '0',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0',
  KEY
`playlist_id` (`playlist_id`),
  KEY `video_id` (`video_id`),
  KEY
`add_time` (`add_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE
IF EXISTS `user_premium_ips`;
CREATE TABLE `user_premium_ips` (
  `user_id`
int(11) unsigned NOT NULL DEFAULT '0',
  `ip` int(11) unsigned NOT NULL
DEFAULT '0',
  KEY `user_id` (`user_id`),
  KEY `user_ip`
(`user_id`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `video`
ADD `featured` enum('0','1') NOT NULL DEFAULT '0';
ALTER TABLE `video` ADD
`s3` enum('0','1') NOT NULL DEFAULT '0';

ALTER TABLE `video_category` DROP
KEY `cat_id`;
ALTER TABLE `video_category` DROP KEY `video_categ`;
ALTER
TABLE `video_category` ADD KEY `cat_video` (`cat_id`,`video_id`);

ALTER
TABLE `video_comments` ADD `nickname` varchar(100) NOT NULL DEFAULT
'';

DROP TABLE IF EXISTS `video_embeds`;
CREATE TABLE `video_embeds` (
 
`video_id` int(11) NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL
DEFAULT '',
  `view_time` int(11) NOT NULL DEFAULT '0',
  KEY `embed`
(`video_id`,`view_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE
`video_feeds` ADD `format` enum('smart','nats') NOT NULL DEFAULT
'smart';

ALTER TABLE `video_history` DROP COLUMN `view_date`;
ALTER TABLE
`video_history` DROP COLUMN `status`;
ALTER TABLE `video_history` DROP KEY
`ip`;
ALTER TABLE `video_history` DROP KEY `status`;
ALTER TABLE
`video_history` ADD KEY `view_time` (`view_time`);