kantry,
where should i change? pls fix from the following code below
sql (+/-)
--
-- Структура таблицы `cms_ads`
--
DROP TABLE IF EXISTS `cms_ads`;
CREATE TABLE `cms_ads`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`view` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`layout` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`count_link` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` TEXT NOT NULL,
`link` TEXT NOT NULL,
`to` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`color` VARCHAR(10) NOT NULL DEFAULT '',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`day` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`mesto` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`bold` TINYINT(1) NOT NULL DEFAULT '0',
`italic` TINYINT(1) NOT NULL DEFAULT '0',
`underline` TINYINT(1) NOT NULL DEFAULT '0',
`show` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_album_cat`
--
DROP TABLE IF EXISTS `cms_album_cat`;
CREATE TABLE `cms_album_cat`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`sort` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(40) NOT NULL DEFAULT '',
`description` TEXT NOT NULL,
`password` VARCHAR(20) NOT NULL DEFAULT '',
`access` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `access` (`access`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_album_comments`
--
DROP TABLE IF EXISTS `cms_album_comments`;
CREATE TABLE `cms_album_comments`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`sub_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`text` TEXT NOT NULL,
`reply` TEXT NOT NULL,
`attributes` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `sub_id` (`sub_id`),
KEY `user_id` (`user_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_album_downloads`
--
DROP TABLE IF EXISTS `cms_album_downloads`;
CREATE TABLE `cms_album_downloads`
(
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`file_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`, `file_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_album_files`
--
DROP TABLE IF EXISTS `cms_album_files`;
CREATE TABLE `cms_album_files`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT NULL,
`album_id` INT(10) UNSIGNED NOT NULL,
`description` TEXT NOT NULL,
`img_name` VARCHAR(100) NOT NULL DEFAULT '',
`tmb_name` VARCHAR(100) NOT NULL DEFAULT '',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`comments` TINYINT(1) NOT NULL DEFAULT '1',
`comm_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`access` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`vote_plus` INT(11) NOT NULL DEFAULT '0',
`vote_minus` INT(11) NOT NULL DEFAULT '0',
`views` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`downloads` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`unread_comments` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `album_id` (`album_id`),
KEY `access` (`access`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_album_views`
--
DROP TABLE IF EXISTS `cms_album_views`;
CREATE TABLE `cms_album_views`
(
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`file_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`, `file_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_album_votes`
--
DROP TABLE IF EXISTS `cms_album_votes`;
CREATE TABLE `cms_album_votes`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`file_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`vote` TINYINT(2) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `file_id` (`file_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_ban_ip`
--
DROP TABLE IF EXISTS `cms_ban_ip`;
CREATE TABLE `cms_ban_ip`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`ip1` BIGINT(11) NOT NULL DEFAULT '0',
`ip2` BIGINT(11) NOT NULL DEFAULT '0',
`ban_type` TINYINT(4) NOT NULL DEFAULT '0',
`link` VARCHAR(100) NOT NULL DEFAULT '',
`who` VARCHAR(25) NOT NULL DEFAULT '',
`reason` TEXT NOT NULL,
`date` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `ip1` (`ip1`),
UNIQUE KEY `ip2` (`ip2`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_ban_users`
--
DROP TABLE IF EXISTS `cms_ban_users`;
CREATE TABLE `cms_ban_users`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL DEFAULT '0',
`ban_time` INT(11) NOT NULL DEFAULT '0',
`ban_while` INT(11) NOT NULL DEFAULT '0',
`ban_type` TINYINT(4) NOT NULL DEFAULT '1',
`ban_who` VARCHAR(30) NOT NULL DEFAULT '',
`ban_ref` INT(11) NOT NULL DEFAULT '0',
`ban_reason` TEXT NOT NULL,
`ban_raz` VARCHAR(30) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `ban_time` (`ban_time`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_contact`
--
DROP TABLE IF EXISTS `cms_contact`;
CREATE TABLE IF NOT EXISTS `cms_contact`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`from_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
`friends` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`ban` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`man` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id_user` (`user_id`, `from_id`),
KEY `time` (`time`),
KEY `ban` (`ban`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_counters`
--
DROP TABLE IF EXISTS `cms_counters`;
CREATE TABLE `cms_counters`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`sort` INT(10) NOT NULL DEFAULT '1',
`name` VARCHAR(30) NOT NULL DEFAULT '',
`link1` TEXT NOT NULL,
`link2` TEXT NOT NULL,
`mode` TINYINT(4) NOT NULL DEFAULT '1',
`switch` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_forum_files`
--
DROP TABLE IF EXISTS `cms_forum_files`;
CREATE TABLE `cms_forum_files`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`cat` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`subcat` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`topic` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`post` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`filename` TEXT NOT NULL,
`filetype` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`dlcount` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`del` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `cat` (`cat`),
KEY `subcat` (`subcat`),
KEY `topic` (`topic`),
KEY `post` (`post`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_forum_rdm`
--
DROP TABLE IF EXISTS `cms_forum_rdm`;
CREATE TABLE `cms_forum_rdm`
(
`topic_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`topic_id`, `user_id`),
KEY `time` (`time`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_forum_vote`
--
DROP TABLE IF EXISTS `cms_forum_vote`;
CREATE TABLE `cms_forum_vote`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` INT(2) NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`topic` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(200) NOT NULL,
`count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `topic` (`topic`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_forum_vote_users`
--
DROP TABLE IF EXISTS `cms_forum_vote_users`;
CREATE TABLE `cms_forum_vote_users`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user` INT(11) NOT NULL DEFAULT '0',
`topic` INT(11) NOT NULL,
`vote` INT(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `topic` (`topic`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_mail`
--
DROP TABLE IF EXISTS `cms_mail`;
CREATE TABLE IF NOT EXISTS `cms_mail`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`from_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`text` TEXT NOT NULL,
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`read` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`sys` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`delete` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`file_name` VARCHAR(100) NOT NULL DEFAULT '',
`count` INT(10) NOT NULL DEFAULT '0',
`size` INT(10) NOT NULL DEFAULT '0',
`them` VARCHAR(100) NOT NULL DEFAULT '',
`spam` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `from_id` (`from_id`),
KEY `time` (`time`),
KEY `read` (`read`),
KEY `sys` (`sys`),
KEY `delete` (`delete`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_sessions`
--
DROP TABLE IF EXISTS `cms_sessions`;
CREATE TABLE `cms_sessions`
(
`session_id` CHAR(32) NOT NULL DEFAULT '',
`ip` BIGINT(11) NOT NULL DEFAULT '0',
`ip_via_proxy` BIGINT(11) NOT NULL DEFAULT '0',
`browser` VARCHAR(255) NOT NULL DEFAULT '',
`lastdate` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`sestime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`views` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`movings` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`place` VARCHAR(100) NOT NULL DEFAULT '',
PRIMARY KEY (`session_id`),
KEY `lastdate` (`lastdate`),
KEY `place` (`place`(10))
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_users_data`
--
DROP TABLE IF EXISTS `cms_users_data`;
CREATE TABLE `cms_users_data`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`key` VARCHAR(30) NOT NULL DEFAULT '',
`val` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `key` (`key`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_users_guestbook`
--
DROP TABLE IF EXISTS `cms_users_guestbook`;
CREATE TABLE `cms_users_guestbook`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`sub_id` INT(10) UNSIGNED NOT NULL,
`time` INT(11) NOT NULL,
`user_id` INT(10) UNSIGNED NOT NULL,
`text` TEXT NOT NULL,
`reply` TEXT NOT NULL,
`attributes` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `sub_id` (`sub_id`),
KEY `user_id` (`user_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_users_iphistory`
--
DROP TABLE IF EXISTS `cms_users_iphistory`;
CREATE TABLE `cms_users_iphistory`
(
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT NULL,
`ip` BIGINT(11) NOT NULL DEFAULT '0',
`ip_via_proxy` BIGINT(11) NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `user_ip` (`ip`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `download__bookmark`
--
DROP TABLE IF EXISTS `download__bookmark`;
CREATE TABLE `download__bookmark`
(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL,
`file_id` INT(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `file_id` (`file_id`),
KEY `user_id` (`user_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `download__category`
--
DROP TABLE IF EXISTS `download__category`;
CREATE TABLE `download__category`
(
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`refid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`dir` TEXT NOT NULL,
`sort` INT(11) NOT NULL DEFAULT '0',
`name` TEXT NOT NULL,
`total` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`rus_name` TEXT NOT NULL,
`text` TEXT NOT NULL,
`field` INT(11) NOT NULL DEFAULT '0',
`desc` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `refid` (`refid`),
KEY `total` (`total`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `download__comments`
--
DROP TABLE IF EXISTS `download__comments`;
CREATE TABLE `download__comments`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`sub_id` INT(10) UNSIGNED NOT NULL,
`time` INT(11) NOT NULL,
`user_id` INT(10) UNSIGNED NOT NULL,
`text` TEXT NOT NULL,
`reply` TEXT NOT NULL,
`attributes` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `sub_id` (`sub_id`),
KEY `user_id` (`user_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `download__files`
--
DROP TABLE IF EXISTS `download__files`;
CREATE TABLE `download__files`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`refid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`dir` TEXT NOT NULL,
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` TEXT NOT NULL,
`type` INT(2) UNSIGNED NOT NULL DEFAULT '0',
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`rus_name` TEXT NOT NULL,
`text` TEXT NOT NULL,
`field` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`rate` VARCHAR(30) NOT NULL DEFAULT '0|0',
`about` TEXT NOT NULL,
`desc` TEXT NOT NULL,
`comm_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `refid` (`refid`),
KEY `comm_count` (`comm_count`),
KEY `type` (`type`),
KEY `user_id` (`user_id`),
KEY `time` (`time`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `download__more`
--
DROP TABLE IF EXISTS `download__more`;
CREATE TABLE `download__more`
(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`refid` INT(11) NOT NULL,
`time` INT(11) NOT NULL,
`name` TEXT NOT NULL,
`rus_name` TEXT NOT NULL,
`size` INT(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `refid` (`refid`),
KEY `time` (`time`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `guest`
--
DROP TABLE IF EXISTS `guest`;
CREATE TABLE `guest`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`adm` TINYINT(1) NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(25) NOT NULL DEFAULT '',
`text` TEXT NOT NULL,
`ip` BIGINT(11) NOT NULL DEFAULT '0',
`browser` TINYTEXT NOT NULL,
`admin` VARCHAR(25) NOT NULL DEFAULT '',
`otvet` TEXT NOT NULL,
`otime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`edit_who` VARCHAR(25) NOT NULL DEFAULT '',
`edit_time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`edit_count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `ip` (`ip`),
KEY `adm` (`adm`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `karma_users`
--
DROP TABLE IF EXISTS `karma_users`;
CREATE TABLE `karma_users`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(50) NOT NULL DEFAULT '',
`karma_user` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`points` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`text` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `karma_user` (`karma_user`),
KEY `type` (`type`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `library_cats`
--
DROP TABLE IF EXISTS `library_cats`;
CREATE TABLE `library_cats`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(200) NOT NULL DEFAULT '',
`description` TEXT NOT NULL,
`dir` TINYINT(1) NOT NULL DEFAULT '0',
`pos` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`user_add` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `library_texts`
--
DROP TABLE IF EXISTS `library_texts`;
CREATE TABLE `library_texts`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`cat_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`text` MEDIUMTEXT NOT NULL,
`name` VARCHAR(250) NOT NULL DEFAULT '',
`announce` TEXT,
`uploader` VARCHAR(100) NOT NULL DEFAULT '',
`uploader_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`count_views` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`premod` TINYINT(1) NOT NULL DEFAULT '0',
`comments` TINYINT(1) NOT NULL DEFAULT '0',
`comm_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
FULLTEXT KEY `text` (`text`),
KEY `name` (`name`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `library_tags`
--
DROP TABLE IF EXISTS `library_tags`;
CREATE TABLE `library_tags`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`lib_text_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`tag_name` VARCHAR(250) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `lib_text_id` (`lib_text_id`),
KEY `tag_name` (`tag_name`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_library_comments`
--
DROP TABLE IF EXISTS `cms_library_comments`;
CREATE TABLE `cms_library_comments`
(
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`sub_id` INT(11) UNSIGNED NOT NULL,
`time` INT(11) NOT NULL,
`user_id` INT(11) UNSIGNED NOT NULL,
`text` TEXT NOT NULL,
`reply` TEXT,
`attributes` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `sub_id` (`sub_id`),
KEY `user_id` (`user_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `cms_library_rating`
--
DROP TABLE IF EXISTS `cms_library_rating`;
CREATE TABLE IF NOT EXISTS `cms_library_rating`
(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL,
`st_id` INT(11) NOT NULL,
`point` TINYINT(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`, `st_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `news`
--
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`avt` VARCHAR(25) NOT NULL DEFAULT '',
`name` TEXT NOT NULL,
`text` TEXT NOT NULL,
`kom` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(25) NOT NULL DEFAULT '',
`name_lat` VARCHAR(40) NOT NULL DEFAULT '',
`password` VARCHAR(32) NOT NULL DEFAULT '',
`rights` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`failed_login` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`imname` VARCHAR(100) NOT NULL DEFAULT '',
`sex` VARCHAR(2) NOT NULL DEFAULT '',
`komm` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`postforum` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`postguest` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`yearofbirth` INT(4) NOT NULL DEFAULT '0',
`datereg` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`lastdate` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`mail` VARCHAR(50) NOT NULL DEFAULT '',
`icq` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`skype` VARCHAR(50) NOT NULL DEFAULT '',
`jabber` VARCHAR(50) NOT NULL DEFAULT '',
`www` VARCHAR(50) NOT NULL DEFAULT '',
`about` TEXT NOT NULL,
`live` VARCHAR(100) NOT NULL DEFAULT '',
`mibile` VARCHAR(50) NOT NULL DEFAULT '',
`status` VARCHAR(100) NOT NULL DEFAULT '',
`ip` BIGINT(11) NOT NULL DEFAULT '0',
`ip_via_proxy` BIGINT(11) NOT NULL DEFAULT '0',
`browser` TEXT NOT NULL,
`preg` TINYINT(1) NOT NULL DEFAULT '0',
`regadm` VARCHAR(25) NOT NULL DEFAULT '',
`mailvis` TINYINT(1) NOT NULL DEFAULT '0',
`dayb` INT(2) NOT NULL DEFAULT '0',
`monthb` INT(2) NOT NULL DEFAULT '0',
`sestime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`total_on_site` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`lastpost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`rest_code` VARCHAR(32) NOT NULL DEFAULT '',
`rest_time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`movings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`place` VARCHAR(100) NOT NULL DEFAULT '',
`set_user` TEXT NOT NULL,
`set_forum` TEXT NOT NULL,
`set_mail` TEXT NOT NULL,
`karma_plus` INT(11) NOT NULL DEFAULT '0',
`karma_minus` INT(11) NOT NULL DEFAULT '0',
`karma_time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`karma_off` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`comm_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`comm_old` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`smileys` TEXT NOT NULL,
`notification_settings` TEXT COMMENT 'Notification settings',
PRIMARY KEY (`id`),
KEY `name_lat` (`name_lat`),
KEY `lastdate` (`lastdate`),
KEY `place` (`place`)
)
ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4;
--
-- Структура таблицы `forum_messages`
--
DROP TABLE IF EXISTS `forum_messages`;
CREATE TABLE `forum_messages`
(
`id` bigint(20) NOT NULL,
`topic_id` bigint(20) NOT NULL,
`text` longtext NOT NULL,
`date` int(11) DEFAULT NULL,
`user_id` bigint(20) NOT NULL,
`user_name` varchar(255) DEFAULT NULL,
`user_agent` varchar(255) DEFAULT NULL,
`ip` bigint(20) DEFAULT NULL,
`ip_via_proxy` bigint(20) DEFAULT NULL,
`pinned` tinyint(1) DEFAULT NULL,
`editor_name` varchar(255) DEFAULT NULL,
`edit_time` int(11) DEFAULT NULL,
`edit_count` int(11) DEFAULT NULL,
`deleted` tinyint(1) DEFAULT NULL,
`deleted_by` varchar(255) DEFAULT NULL,
`old_id` int(11) DEFAULT NULL
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4;
-- --------------------------------------------------------
--
-- Структура таблицы `forum_redirects`
--
DROP TABLE IF EXISTS `forum_redirects`;
CREATE TABLE `forum_redirects`
(
`old_id` int(11) NOT NULL,
`new_link` varchar(255) NOT NULL
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4;
-- --------------------------------------------------------
--
-- Структура таблицы `forum_sections`
--
DROP TABLE IF EXISTS `forum_sections`;
CREATE TABLE `forum_sections`
(
`id` int(11) NOT NULL,
`parent` int(11) DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8 NOT NULL,
`description` text CHARACTER SET utf8,
`sort` int(11) DEFAULT '100',
`access` int(11) DEFAULT NULL,
`section_type` int(11) DEFAULT NULL,
`old_id` int(11) DEFAULT NULL
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4;
-- --------------------------------------------------------
--
-- Структура таблицы `forum_topic`
--
DROP TABLE IF EXISTS `forum_topic`;
CREATE TABLE `forum_topic`
(
`id` bigint(20) UNSIGNED NOT NULL,
`section_id` int(10) UNSIGNED NOT NULL COMMENT 'Id родительского раздела',
`name` varchar(255) NOT NULL COMMENT 'Название темы',
`description` mediumtext COMMENT 'Краткое описание',
`view_count` bigint(20) DEFAULT NULL COMMENT 'Количество просмотров',
`user_id` bigint(20) NOT NULL COMMENT 'Id автора темы',
`user_name` varchar(255) DEFAULT NULL COMMENT 'Имя автора',
`created_at` datetime DEFAULT NULL COMMENT 'Дата создания темы',
`post_count` int(11) DEFAULT NULL COMMENT 'Количество постов',
`mod_post_count` int(11) DEFAULT NULL COMMENT 'Количество постов с учетом удаленных',
`last_post_date` int(11) DEFAULT NULL COMMENT 'Дата последнего поста',
`last_post_author` bigint(20) DEFAULT NULL COMMENT 'id автора последнего поста',
`last_post_author_name` varchar(255) DEFAULT NULL COMMENT 'Имя автора последнего поста',
`last_message_id` bigint(20) DEFAULT NULL COMMENT 'Id последнего сообщения',
`mod_last_post_date` int(11) DEFAULT NULL COMMENT 'Дата последнего поста для модератора',
`mod_last_post_author` bigint(20) DEFAULT NULL COMMENT 'id автора последнего поста для модератора',
`mod_last_post_author_name` varchar(255) DEFAULT NULL COMMENT 'Имя автора последнего поста для модератора',
`mod_last_message_id` bigint(20) DEFAULT NULL COMMENT 'Id последнего поста для модератора',
`closed` tinyint(1) DEFAULT NULL COMMENT 'Флаг закрытия темы',
`closed_by` varchar(255) DEFAULT NULL COMMENT 'Имя закрывшего тему',
`deleted` tinyint(1) DEFAULT NULL COMMENT 'Флаг удаленной темы',
`deleted_by` varchar(255) DEFAULT NULL COMMENT 'Имя удалившего тему',
`curators` mediumtext COMMENT 'Кураторы',
`pinned` tinyint(1) DEFAULT NULL COMMENT 'Флаг закрепленной темы',
`has_poll` tinyint(1) DEFAULT NULL COMMENT 'Флаг наличия опроса',
`old_id` int(11) DEFAULT NULL
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4;
--
-- Индексы сохранённых таблиц
--
--
-- Индексы таблицы `forum_messages`
--
ALTER TABLE `forum_messages`
ADD PRIMARY KEY (`id`),
ADD KEY `topic` (`topic_id`),
ADD KEY `deleted` (`deleted`),
ADD KEY `old_id` (`old_id`);
ALTER TABLE `forum_messages`
ADD FULLTEXT KEY `text` (`text`);
--
-- Индексы таблицы `forum_redirects`
--
ALTER TABLE `forum_redirects`
ADD UNIQUE KEY `old_id` (`old_id`);
--
-- Индексы таблицы `forum_sections`
--
ALTER TABLE `forum_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `parent` (`parent`),
ADD KEY `old_id` (`old_id`);
--
-- Индексы таблицы `forum_topic`
--
ALTER TABLE `forum_topic`
ADD PRIMARY KEY (`id`),
ADD KEY `deleted` (`deleted`);
--
-- AUTO_INCREMENT для таблицы `forum_messages`
--
ALTER TABLE `forum_messages`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT = 1;
--
-- AUTO_INCREMENT для таблицы `forum_sections`
--
ALTER TABLE `forum_sections`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT = 1;
--
-- AUTO_INCREMENT для таблицы `forum_topic`
--
ALTER TABLE `forum_topic`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT = 1;
DROP TABLE IF EXISTS `notifications`;
CREATE TABLE `notifications`
(
`id` int(10) UNSIGNED NOT NULL,
`module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Module name',
`event_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event type',
`user_id` int(10) UNSIGNED NOT NULL COMMENT 'User identifier',
`sender_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Sender identifier',
`entity_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Entity identifier',
`fields` text COLLATE utf8mb4_unicode_ci COMMENT 'Event fields',
`read_at` timestamp NULL DEFAULT NULL COMMENT 'Read date',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_unicode_ci;
--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
ADD PRIMARY KEY (`id`),
ADD KEY `notifications_user_id_module_event_type_entity_id_index` (`user_id`, `module`, `event_type`, `entity_id`),
ADD KEY `notifications_user_id_index` (`user_id`);
--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
ADD CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;