I am facing the below error. Shown in the screenshot..
Problem On Installing Johncms 9
1.22K
kantry
3 апр 2020 г., 14:16
Hey guys! Finally I'm gonna change status!?
Armanbinrahman, You must manually make queries from the install.sql.
To find out in which table the long key.
Also in which table the second index is created.
Armanbinrahman
3 апр 2020 г., 16:23
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;
Simba
3 апр 2020 г., 20:40
Кадило крутится, лавэха мутится
Unpack this archive to the folder: install/sql
Прикрепленные файлы:
366
(4.73 KB)
Armanbinrahman
3 апр 2020 г., 21:39
Simba, Still not working, after unzipping the file you provided.
Its saying the following new error:
Прикрепленные файлы:
422
(111.67 KB)
Simba
3 апр 2020 г., 22:47
Кадило крутится, лавэха мутится
# Armanbinrahman (03.04.2020 / 21:39)You are using an old version of mysql.
Simba, Still not working, after unzipping the file you provided.
Its saying the following new error:
Armanbinrahman
4 апр 2020 г., 5:41
Simba, ok thanks... can you suggest me new any of free hosting provider where i can host johncms for completely free?
Simba
4 апр 2020 г., 11:52
Кадило крутится, лавэха мутится
Armanbinrahman, https://www.000webhost.com/
Armanbinrahman
7 апр 2020 г., 20:52
Simba, i couldn't connect the database from 000webost either. can i use bestdc.org hosting for johncms 9.2?
Simba
7 апр 2020 г., 21:11
Кадило крутится, лавэха мутится
Armanbinrahman, I don't know, try it. I tested 000webost and there were no problems on it.
Всего: 11
© 2026, JohnCMS