Файл: adultscript-2.0.3-pro/files/install/sqls/asp-1.0beta1-to-asp-1.0beta2.sql
Строк: 253
CREATE TABLE `link_in` (
`link_id` int(11) 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 `link_id` (`link_id`),
KEY `ip` (`ip`),
KEY `referer`
(`referer`),
KEY `click_date` (`click_date`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
ALTER TABLE `link` ADD `traffic` int(11) unsigned NOT NULL
default '0';
ALTER TABLE `link` ADD `pagerank` tinyint(1) unsigned NOT NULL
default '0';
ALTER TABLE `link` ADD KEY `traffic` (`traffic`);
ALTER TABLE
`link` ADD KEY `linkback` (`linkback`);
CREATE TABLE `model_albums` (
`model_id` int(11) NOT NULL DEFAULT '0',
`album_id` int(11) NOT NULL
DEFAULT '0',
KEY `album_id` (`album_id`),
KEY `model_id` (`model_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `model_bio` ADD `performs`
text NOT NULL;
DROP TABLE IF EXISTS `photo`;
CREATE TABLE `photo` (
`photo_id` int(11) NOT NULL AUTO_INCREMENT,
`album_id` int(11) NOT NULL
DEFAULT '0',
`caption` varchar(255) NOT NULL DEFAULT '',
`ext`
varchar(4) NOT NULL DEFAULT '',
`total_views` bigint(20) unsigned NOT
NULL DEFAULT '0',
`total_comments` int(11) unsigned NOT NULL DEFAULT
'0',
`total_favorites` int(11) unsigned NOT NULL DEFAULT '0',
`rating`
float NOT NULL DEFAULT '0',
`rated_by` int(11) NOT NULL DEFAULT '0',
`allow_comment` enum('0','1') NOT NULL DEFAULT '1',
`allow_rating`
enum('0','1') NOT NULL DEFAULT '1',
`size` bigint(20) NOT NULL DEFAULT
'0',
`add_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`flagged` enum('0','1') NOT NULL DEFAULT '0',
`status` enum('0','1') NOT
NULL DEFAULT '1',
PRIMARY KEY (`photo_id`),
KEY `album_id`
(`album_id`),
KEY `flagged` (`flagged`),
KEY `status` (`status`)
)
ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`photo_album_views`;
CREATE TABLE `photo_album_views` (
`album_id`
int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`ip` int(10) unsigned NOT NULL DEFAULT '0',
`view_date` datetime NOT NULL
DEFAULT '0000-00-00 00:00:00',
KEY `album_id` (`album_id`),
KEY
`user_id` (`user_id`),
KEY `ip` (`ip`),
KEY `view_date` (`view_date`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`photo_albums`;
CREATE TABLE `photo_albums` (
`album_id` int(11) NOT NULL
AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0',
`slug`
varchar(100) NOT NULL DEFAULT '',
`title` varchar(100) NOT NULL DEFAULT
'',
`description` text NOT NULL,
`total_photos` int(3) unsigned NOT
NULL DEFAULT '0',
`total_views` bigint(20) unsigned NOT NULL DEFAULT
'0',
`total_comments` int(11) unsigned NOT NULL DEFAULT '0',
`total_favorites` int(5) unsigned NOT NULL DEFAULT '0',
`rating` float
NOT NULL DEFAULT '0',
`rated_by` int(11) unsigned NOT NULL DEFAULT '0',
`adv` int(11) NOT NULL DEFAULT '0',
`locked` enum('0','1') NOT NULL
DEFAULT '0',
`cover` int(11) NOT NULL DEFAULT '0',
`type`
enum('public','private') NOT NULL DEFAULT 'public',
`add_date` datetime
NOT NULL DEFAULT '0000-00-00 00:00:00',
`view_date` datetime NOT NULL
DEFAULT '0000-00-00 00:00:00',
`flagged` enum('0','1') NOT NULL DEFAULT
'0',
`status` enum('0','1','2','3') NOT NULL DEFAULT '0',
PRIMARY KEY
(`album_id`),
KEY `user_id` (`user_id`),
KEY `slug` (`slug`),
KEY
`total_photos` (`total_photos`),
KEY `total_views` (`total_views`),
KEY
`total_favorites` (`total_favorites`),
KEY `total_comments`
(`total_comments`),
KEY `rating` (`rating`,`rated_by`),
KEY `status`
(`status`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `photo_categories`;
CREATE TABLE `photo_categories` (
`cat_id` int(11) NOT NULL AUTO_INCREMENT,
`slug` varchar(100) NOT NULL
DEFAULT '',
`name` varchar(100) NOT NULL DEFAULT '',
`description` text
NOT NULL,
`total_albums` int(11) unsigned NOT NULL DEFAULT '0',
`adv`
int(11) NOT NULL DEFAULT '0',
`status` enum('0','1') NOT NULL DEFAULT
'1',
PRIMARY KEY (`cat_id`),
UNIQUE KEY `slug` (`slug`),
KEY `status`
(`status`),
KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `photo_category`;
CREATE TABLE
`photo_category` (
`album_id` int(11) NOT NULL DEFAULT '0',
`cat_id`
int(11) NOT NULL DEFAULT '0',
KEY `cat_id` (`cat_id`),
KEY `album_id`
(`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`photo_comments`;
CREATE TABLE `photo_comments` (
`comment_id` int(11)
unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) unsigned NOT NULL
DEFAULT '0',
`photo_id` int(11) unsigned NOT NULL DEFAULT '0',
`user_id` int(11) unsigned NOT NULL DEFAULT '0',
`ip` int(10) NOT NULL
DEFAULT '0',
`comment` text NOT NULL,
`add_date` datetime NOT NULL
DEFAULT '0000-00-00 00:00:00',
`status` enum('0','1') NOT NULL DEFAULT
'1',
`spam` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY
(`comment_id`),
KEY `parent_id` (`parent_id`),
KEY `photo_id`
(`photo_id`),
KEY `user_id` (`user_id`),
KEY `ip` (`ip`),
KEY
`status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `photo_favorites`;
CREATE TABLE
`photo_favorites` (
`photo_id` int(11) NOT NULL DEFAULT '0',
`user_id`
int(11) NOT NULL DEFAULT '0',
KEY `photo_id` (`photo_id`),
KEY
`user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `photo_flags`;
CREATE TABLE `photo_flags` (
`flag_id` int(11) NOT
NULL AUTO_INCREMENT,
`photo_id` int(11) NOT NULL DEFAULT '0',
`user_id`
int(11) NOT NULL DEFAULT '0',
`ip` int(10) unsigned NOT NULL DEFAULT
'0',
`reason` varchar(20) NOT NULL DEFAULT '',
`message` text NOT
NULL,
`add_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` enum('0','1') NOT NULL DEFAULT '1',
PRIMARY KEY (`flag_id`),
KEY `photo_id` (`photo_id`),
KEY `user_id` (`user_id`),
KEY `ip`
(`ip`),
KEY `reason` (`reason`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `photo_rating`;
CREATE TABLE
`photo_rating` (
`rating_id` bigint(10) NOT NULL AUTO_INCREMENT,
`photo_id` int(11) unsigned NOT NULL DEFAULT '0',
`voter_id` int(11)
unsigned NOT NULL DEFAULT '0',
`voter_ip` int(11) unsigned NOT NULL
DEFAULT '0',
`rating` float 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 (`rating_id`),
KEY `photo_id` (`photo_id`),
KEY `voter_id` (`voter_id`),
KEY `voter_ip` (`voter_ip`),
KEY `status`
(`status`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `photo_tags`;
CREATE TABLE `photo_tags` (
`tag_id`
int(11) unsigned NOT NULL AUTO_INCREMENT,
`album_id` int(11) NOT NULL
DEFAULT '0',
`name` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY
(`tag_id`),
KEY `album_id` (`album_id`),
KEY `name` (`name`)
)
ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`photo_views`;
CREATE TABLE `photo_views` (
`photo_id` int(11) NOT NULL
DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`ip` int(10)
unsigned NOT NULL DEFAULT '0',
`view_date` datetime NOT NULL DEFAULT
'0000-00-00 00:00:00',
KEY `photo_id` (`photo_id`),
KEY `user_id`
(`user_id`),
KEY `ip` (`ip`),
KEY `view_date` (`view_date`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `user_activity` ADD
`total_albums` int(11) unsigned NOT NULL default '0';
ALTER TABLE
`user_activity` ADD `total_photos` int(11) unsigned NOT NULL default
'0';
ALTER TABLE `user_preferences` ADD `show_albums`
enum('no','all','friends') NOT NULL DEFAULT 'all';
ALTER TABLE
`user_preferences` ADD `show_photo_favorites` enum('no','all','friends')
NOT NULL DEFAULT 'all';
ALTER TABLE `user_preferences` ADD
`show_photo_history` enum('no','all','friends') NOT NULL DEFAULT
'all';
INSERT INTO `module` SET `name` = 'photo', `description` = 'Photo
Module', `version` = '1.0.0', `provider` = 'adultscriptpro', `config` =
'a:47:{s:10:\"components\";a:11:{s:6:\"browse\";i:1;s:6:\"albums\";i:1;s:6:\"photos\";i:1;s:3:\"tag\";i:1;s:6:\"search\";i:1;s:6:\"upload\";i:1;s:5:\"album\";i:1;s:8:\"category\";i:1;s:5:\"photo\";i:1;s:4:\"edit\";i:1;s:9:\"slideshow\";i:1;}s:11:\"browse_type\";s:6:\"albums\";s:15:\"browse_category\";i:1;s:12:\"browse_order\";i:1;s:15:\"browse_timeline\";i:1;s:15:\"browse_per_page\";i:20;s:13:\"search_method\";N;s:15:\"search_per_page\";i:20;s:3:\"rss\";i:1;s:8:\"rss_type\";s:6:\"simple\";s:12:\"rss_per_page\";i:20;s:12:\"tag_per_page\";i:20;s:11:\"view_access\";s:3:\"all\";s:9:\"view_desc\";i:1;s:14:\"album_per_page\";i:20;s:12:\"view_related\";i:1;s:16:\"related_category\";i:0;s:13:\"related_total\";i:58;s:16:\"related_per_page\";i:12;s:13:\"view_comments\";i:1;s:13:\"allow_comment\";i:1;s:16:\"approve_comments\";i:0;s:17:\"comments_per_page\";i:10;s:12:\"allow_rating\";i:1;s:12:\"rating_count\";i:1;s:11:\"rating_type\";s:4:\"user\";s:14:\"upload_enabled\";i:1;s:11:\"upload_perm\";s:9:\"anonymous\";s:17:\"photo_allowed_ext\";a:4:{i:0;s:3:\"jpg\";i:1;s:4:\"jpeg\";i:2;s:3:\"png\";i:3;s:3:\"gif\";}s:14:\"photo_max_size\";i:2;s:7:\"approve\";i:0;s:17:\"cover_resize_type\";s:4:\"crop\";s:11:\"cover_width\";i:125;s:12:\"cover_height\";i:150;s:11:\"photo_width\";i:625;s:12:\"photo_height\";i:0;s:11:\"thumb_width\";i:120;s:12:\"thumb_height\";i:140;s:14:\"delete_enabled\";i:1;s:13:\"delete_method\";s:6:\"change\";s:15:\"delete_username\";s:9:\"anonymous\";s:16:\"title_min_length\";i:3;s:16:\"title_max_length\";i:100;s:15:\"desc_min_length\";i:3;s:15:\"desc_max_length\";i:1000;s:15:\"tags_min_length\";i:3;s:15:\"tags_max_length\";i:100;}',
`config_cache` =
'a:47:{s:10:\"components\";a:11:{s:6:\"browse\";i:1;s:6:\"albums\";i:1;s:6:\"photos\";i:1;s:3:\"tag\";i:1;s:6:\"search\";i:1;s:6:\"upload\";i:1;s:5:\"album\";i:1;s:8:\"category\";i:1;s:5:\"photo\";i:1;s:4:\"edit\";i:1;s:9:\"slideshow\";i:1;}s:11:\"browse_type\";s:6:\"albums\";s:15:\"browse_category\";i:1;s:12:\"browse_order\";i:1;s:15:\"browse_timeline\";i:1;s:15:\"browse_per_page\";i:20;s:13:\"search_method\";N;s:15:\"search_per_page\";i:20;s:3:\"rss\";i:1;s:8:\"rss_type\";s:6:\"simple\";s:12:\"rss_per_page\";i:20;s:12:\"tag_per_page\";i:20;s:11:\"view_access\";s:3:\"all\";s:9:\"view_desc\";i:1;s:14:\"album_per_page\";i:20;s:12:\"view_related\";i:1;s:16:\"related_category\";i:0;s:13:\"related_total\";i:58;s:16:\"related_per_page\";i:12;s:13:\"view_comments\";i:1;s:13:\"allow_comment\";i:1;s:16:\"approve_comments\";i:0;s:17:\"comments_per_page\";i:10;s:12:\"allow_rating\";i:1;s:12:\"rating_count\";i:1;s:11:\"rating_type\";s:4:\"user\";s:14:\"upload_enabled\";i:1;s:11:\"upload_perm\";s:9:\"anonymous\";s:17:\"photo_allowed_ext\";a:4:{i:0;s:3:\"jpg\";i:1;s:4:\"jpeg\";i:2;s:3:\"png\";i:3;s:3:\"gif\";}s:14:\"photo_max_size\";i:2;s:7:\"approve\";i:0;s:17:\"cover_resize_type\";s:4:\"crop\";s:11:\"cover_width\";i:125;s:12:\"cover_height\";i:150;s:11:\"photo_width\";i:625;s:12:\"photo_height\";i:0;s:11:\"thumb_width\";i:120;s:12:\"thumb_height\";i:140;s:14:\"delete_enabled\";i:1;s:13:\"delete_method\";s:6:\"change\";s:15:\"delete_username\";s:9:\"anonymous\";s:16:\"title_min_length\";i:3;s:16:\"title_max_length\";i:100;s:15:\"desc_min_length\";i:3;s:15:\"desc_max_length\";i:1000;s:15:\"tags_min_length\";i:3;s:15:\"tags_max_length\";i:100;}';
UPDATE
`module` SET `config` =
'a:6:{s:5:\"order\";s:7:\"link_id\";s:14:\"backlink_check\";i:1;s:12:\"pagerank_min\";i:0;s:11:\"cheat_check\";i:1;s:13:\"referer_limit\";i:1;s:7:\"widgets\";a:3:{s:4:\"left\";i:1;s:5:\"right\";i:1;s:6:\"footer\";i:1;}}',
`config_cache` =
'a:6:{s:5:\"order\";s:7:\"link_id\";s:14:\"backlink_check\";i:1;s:12:\"pagerank_min\";i:0;s:11:\"cheat_check\";i:1;s:13:\"referer_limit\";i:1;s:7:\"widgets\";a:3:{s:4:\"left\";i:1;s:5:\"right\";i:1;s:6:\"footer\";i:1;}}'
WHERE `name` = 'link';