Файл: install/sql/install.sql
Строк: 285
--
-- Структура таблицы `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;