Файл: adultscript-2.0.3-pro/files/install/sqls/asp-1.0beta4-to-asp-1.0rc1.sql
Строк: 137
DROP TABLE IF EXISTS `adv_category`;
CREATE TABLE `adv_category` (
`adv_group_id` int(11) unsigned NOT NULL DEFAULT '0',
`cat_id` int(11)
unsigned NOT NULL DEFAULT '0',
`adv_id` int(11) unsigned NOT NULL DEFAULT
'0',
KEY `adv_group_cat` (`adv_group_id`,`cat_id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `adv_embed_category`;
CREATE
TABLE `adv_embed_category` (
`adv_id` int(11) unsigned NOT NULL DEFAULT
'0',
`cat_id` int(11) unsigned NOT NULL DEFAULT '0',
KEY `adv_id`
(`adv_id`),
KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `adv_player`;
CREATE TABLE `adv_player`
(
`adv_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL
DEFAULT '0',
`adv_name` varchar(100) NOT NULL DEFAULT '',
`adv_desc`
varchar(255) NOT NULL DEFAULT '',
`type` enum('text','image','video') NOT
NULL DEFAULT 'image',
`title` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`url` varchar(255) NOT
NULL DEFAULT '',
`media_type` enum('file','url') NOT NULL DEFAULT
'file',
`media_url` varchar(255) NOT NULL DEFAULT '',
`media_ext`
varchar(4) NOT NULL DEFAULT '',
`cuepoint` mediumint(4) unsigned NOT NULL
DEFAULT '0',
`position` mediumint(3) NOT NULL DEFAULT '0',
`duration`
mediumint(3) unsigned NOT NULL DEFAULT '0',
`clicks` int(11) unsigned NOT
NULL DEFAULT '0',
`views` bigint(11) unsigned NOT NULL DEFAULT '0',
`expire` date NOT NULL DEFAULT '0000-00-00',
`status` enum('0','1') NOT
NULL DEFAULT '1',
PRIMARY KEY (`adv_id`),
KEY `type` (`type`),
KEY
`status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `adv_player_clicks`;
CREATE TABLE
`adv_player_clicks` (
`adv_id` int(11) unsigned NOT NULL DEFAULT '0',
`ip` int(10) unsigned NOT NULL DEFAULT '0',
`referer` varchar(255) NOT
NULL DEFAULT '',
`click_date` datetime NOT NULL DEFAULT '0000-00-00
00:00:00',
KEY `ip` (`ip`),
KEY `click_date` (`click_date`),
KEY
`adv_id` (`adv_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `adv_player_default`;
CREATE TABLE `adv_player_default` (
`player_id` int(11) NOT NULL DEFAULT '0',
`type`
enum('text','image','video') NOT NULL DEFAULT 'text',
`adv_id` int(11)
NOT NULL DEFAULT '0',
KEY `player_id` (`player_id`),
KEY `type`
(`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`adv_player_video`;
CREATE TABLE `adv_player_video` (
`video_id` int(11)
NOT NULL DEFAULT '0',
`type` enum('text','image','video') NOT NULL
DEFAULT 'text',
`adv_id` int(11) NOT NULL DEFAULT '0',
KEY `video_id`
(`video_id`),
KEY `video_type` (`video_id`,`type`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
ALTER TABLE `link` ADD `hardlink` enum('0', '1') NOT
NULL default '0';
ALTER TABLE `model` ADD `url` varchar(255) NOT NULL
DEFAULT '';
ALTER TABLE `model` ADD `nationality` varchar(100) NOT NULL
default '';
ALTER TABLE `model` ADD `skin_color` varchar(100) NOT NULL
default '';
ALTER TABLE `model` ADD `age` tinyint(2) unsigned NOT NULL
DEFAULT '0';
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`news_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11)
unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`slug` varchar(255) NOT NULL DEFAULT '',
`content` text NOT NULL,
`meta_title` text NOT NULL,
`meta_desc` text NOT NULL,
`meta_keys` text
NOT NULL,
`total_views` bigint(20) unsigned NOT NULL DEFAULT '0',
`add_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status`
enum('0','1') NOT NULL DEFAULT '1',
PRIMARY KEY (`news_id`),
UNIQUE KEY
`slug` (`slug`),
KEY `add_date` (`add_date`),
KEY `status` (`status`)
)
ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `package`
ADD `fields` text NOT NULL;
ALTER TABLE `video_categories` ADD `parent_id`
int(11) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `video_categories` ADD
`adv_text_id` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `video_categories`
ADD `adv_image_id` int(11) NOT NULL DEFAULT '0';
ALTER TABLE
`video_categories` ADD `adv_video` text NOT NULL;
ALTER TABLE
`video_categories` ADD `title` text NOT NULL;
ALTER TABLE
`video_categories` ADD `meta_title` text NOT NULL;
ALTER TABLE
`video_categories` ADD `meta_desc` text NOT NULL;
ALTER TABLE
`video_categories` ADD `meta_keys` text NOT NULL;
DROP TABLE IF EXISTS
`video_feeds`;
CREATE TABLE `video_feeds` (
`feed_id` int(11) unsigned
NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT
'0',
`sponsor_id` int(11) unsigned NOT NULL DEFAULT '0',
`name`
varchar(100) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL
DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT '',
`method`
enum('host','hotlink','embed') NOT NULL DEFAULT 'host',
`method_thumb`
enum('generate','download') NOT NULL DEFAULT 'download',
`categories`
text NOT NULL,
`type` enum('public','private') NOT NULL DEFAULT
'public',
`premium` enum('0','1') NOT NULL DEFAULT '0',
`allow_comment`
enum('0','1') NOT NULL DEFAULT '1',
`allow_embed` enum('0','1') NOT NULL
DEFAULT '1',
`allow_rating` enum('0','1') NOT NULL DEFAULT '1',
`allow_download` enum('0','1') NOT NULL DEFAULT '1',
`mobile`
enum('0','1') NOT NULL DEFAULT '0',
`block_duplicates` enum('0','1') NOT
NULL DEFAULT '1',
`last_updated` datetime NOT NULL DEFAULT '0000-00-00
00:00:00',
`update_limit` int(11) NOT NULL DEFAULT '10',
`status`
enum('0','1') NOT NULL DEFAULT '1',
`total_videos` int(11) unsigned NOT
NULL DEFAULT '0',
PRIMARY KEY (`feed_id`),
KEY `user_id` (`user_id`),
KEY `sponsor_id` (`sponsor_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `video_feeds_imported`;
CREATE TABLE
`video_feeds_imported` (
`feed_id` int(11) unsigned NOT NULL DEFAULT
'0',
`unique_id` varchar(255) NOT NULL DEFAULT '',
KEY `feed_id`
(`feed_id`),
KEY `unique_id` (`unique_id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `video_meta`;
CREATE TABLE `video_meta`
(
`video_id` int(11) unsigned NOT NULL DEFAULT '0',
`meta_title` text
NOT NULL,
`meta_desc` text NOT NULL,
`meta_keys` text NOT NULL,
UNIQUE KEY `video_id` (`video_id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
ALTER TABLE `video_sponsors` ADD `adv_text_id` int(11)
unsigned NOT NULL default '0';
ALTER TABLE `video_sponsors` ADD
`adv_image_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE
`video_sponsors` ADD `adv_video` text NOT NULL;