Problem On Installing Johncms 9

--
-- Структура таблицы `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;