--
-- Структура таблицы `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` VARCHAR(20) NOT NULL DEFAULT '',
`ip_via_proxy` VARCHAR(20) NOT NULL DEFAULT '',
`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',
`place` VARCHAR(100) NOT NULL DEFAULT '',
PRIMARY KEY (`session_id`),
KEY `lastdate` (`lastdate`),
KEY `place` (`place`)
)
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;
--
-- Структура таблицы `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;
--
-- Структура таблицы `forum`
--
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`refid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`type` CHAR(1) NOT NULL DEFAULT '',
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`from` VARCHAR(25) NOT NULL DEFAULT '',
`realid` INT(3) NOT NULL DEFAULT '0',
`ip` VARCHAR(20) NOT NULL DEFAULT '',
`ip_via_proxy` VARCHAR(20) NOT NULL DEFAULT '',
`soft` TEXT NOT NULL,
`text` TEXT NOT NULL,
`close` TINYINT(1) NOT NULL DEFAULT '0',
`close_who` VARCHAR(25) NOT NULL DEFAULT '',
`vip` TINYINT(1) NOT NULL DEFAULT '0',
`edit` TEXT NOT NULL,
`tedit` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`kedit` INT(2) UNSIGNED NOT NULL DEFAULT '0',
`curators` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `refid` (`refid`),
KEY `type` (`type`),
KEY `time` (`time`),
KEY `close` (`close`),
KEY `user_id` (`user_id`),
FULLTEXT KEY `text` (`text`)
)
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` VARCHAR(20) NOT NULL DEFAULT '',
`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;
--
-- Структура таблицы `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` VARCHAR(20) NOT NULL DEFAULT '',
`ip_via_proxy` VARCHAR(20) NOT NULL DEFAULT '',
`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',
`place` VARCHAR(30) NOT NULL DEFAULT '',
`set_user` TEXT NOT NULL,
`set_forum` TEXT NOT NULL,
`set_mail` TEXT NOT NULL,
`comm_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`comm_old` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`smileys` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `name_lat` (`name_lat`),
KEY `lastdate` (`lastdate`),
KEY `place` (`place`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8mb4;