Файл: SQL/monstercms.sql
Строк: 254
-- phpMyAdmin SQL Dump
-- version 4.0.10.14
--
http://www.phpmyadmin.net
--
-- Хост: localhost:3306
-- Время
создания: Авг 31 2016 г., 21:50
-- Версия сервера:
5.5.50-cll
-- Версия PHP: 5.6.20
SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;
--
-- База данных: `pheno464_monstercms`
--
--
--------------------------------------------------------
--
--
Структура таблицы `monstercms_account`
--
CREATE TABLE IF
NOT EXISTS `monstercms_account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`language` varchar(2) NOT NULL DEFAULT '1',
`access` int(11) NOT NULL
DEFAULT '1',
`verif` int(2) NOT NULL DEFAULT '0',
`rating` varchar(255)
NOT NULL DEFAULT '0.00',
`style` varchar(50) NOT NULL DEFAULT 'default',
`size_ico` int(11) NOT NULL DEFAULT '16',
`avatar` varchar(500) NOT NULL
DEFAULT 'no.png',
`nick` varchar(30) NOT NULL,
`day` varchar(30) NOT
NULL,
`month` varchar(30) NOT NULL,
`th` varchar(30) NOT NULL,
`country` varchar(30) NOT NULL,
`city` varchar(30) NOT NULL,
`login`
varchar(30) NOT NULL,
`password` varchar(255) NOT NULL,
`email`
varchar(155) NOT NULL,
`monsters` varchar(255) NOT NULL DEFAULT '0.00',
`sex` enum('1','2') NOT NULL DEFAULT '1',
`status` varchar(255) NOT
NULL,
`datareg` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`browser` varchar(255) NOT NULL,
`online` varchar(255) NOT NULL,
`about` longtext NOT NULL,
`open_wall` int(11) NOT NULL DEFAULT '1',
`open_wall_site` int(11) NOT NULL DEFAULT '2',
`down_file` int(11) NOT
NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`monstercms_forum_section`
--
CREATE TABLE IF NOT EXISTS
`monstercms_forum_section` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`autor` varchar(11) NOT NULL,
`time` int(11) NOT NULL,
`del` int(11)
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`monstercms_forum_subsection`
--
CREATE TABLE IF NOT EXISTS
`monstercms_forum_subsection` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_section` varchar(11) NOT NULL,
`name_section` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`autor` int(11) NOT NULL,
`time` int(11) NOT NULL,
`del` int(11) NOT
NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`monstercms_forum_theme`
--
CREATE TABLE IF NOT EXISTS
`monstercms_forum_theme` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_section` int(11) NOT NULL,
`id_subsection` varchar(11) NOT NULL,
`subsection_name` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`description` longtext NOT NULL,
`autor` int(11) NOT NULL,
`time`
int(11) NOT NULL,
`repost` int(11) NOT NULL DEFAULT '0',
`likes`
int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '0',
`comm` int(11) NOT NULL,
`access` int(11) NOT NULL DEFAULT '0',
PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `monstercms_forum_theme_comm`
--
CREATE
TABLE IF NOT EXISTS `monstercms_forum_theme_comm` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_section` varchar(11) NOT NULL,
`id_subsection`
varchar(11) NOT NULL,
`id_theme` varchar(11) NOT NULL,
`name`
varchar(255) NOT NULL,
`text` text NOT NULL,
`autor` int(11) NOT NULL,
`time` int(11) NOT NULL,
`del` int(11) NOT NULL DEFAULT '0',
PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `monstercms_forum_visitors`
--
CREATE
TABLE IF NOT EXISTS `monstercms_forum_visitors` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_theme` int(11) NOT NULL,
`user` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`monstercms_info`
--
CREATE TABLE IF NOT EXISTS `monstercms_info` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL DEFAULT
'Monster',
`basis` varchar(250) NOT NULL DEFAULT 'CMS',
`assembly_view`
varchar(250) NOT NULL DEFAULT 'core',
`version` varchar(250) NOT NULL
DEFAULT '0.1',
`info_license` varchar(250) NOT NULL DEFAULT 'no',
`license` varchar(250) NOT NULL,
`language_packs` varchar(250) NOT NULL
DEFAULT 'one',
`style` varchar(250) NOT NULL DEFAULT 'default',
`default_lang` varchar(250) NOT NULL DEFAULT 'RU',
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Дамп
данных таблицы `monstercms_info`
--
INSERT INTO
`monstercms_info` (`id`, `name`, `basis`, `assembly_view`, `version`,
`info_license`, `license`, `language_packs`, `style`, `default_lang`)
VALUES
(1, 'Monster', 'CMS', 'cms', '0.5', 'yes',
'd573d4c0c65bcec0a5571188617393d9', 'one', 'default', 'RU');
--
--------------------------------------------------------
--
--
Структура таблицы `monstercms_journal`
--
CREATE TABLE IF
NOT EXISTS `monstercms_journal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` varchar(155) NOT NULL,
`theme` varchar(155) NOT NULL,
`info`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`ank_id` int(11) NOT NULL,
`status` int(11) NOT NULL DEFAULT '1',
`del` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`monstercms_license`
--
CREATE TABLE IF NOT EXISTS `monstercms_license` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`info` varchar(250) NOT NULL
DEFAULT '6d6321a8459243771b0bacdf5d3438d4',
`license` varchar(250) NOT
NULL DEFAULT '628dd76947769330432e4c0911e0e8b8',
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Дамп
данных таблицы `monstercms_license`
--
INSERT INTO
`monstercms_license` (`id`, `info`, `license`) VALUES
(1, '1',
'6d6321a8459243771b0bacdf5d3438d4'),
(2, '2',
'628dd76947769330432e4c0911e0e8b8');
--
-- Структура
таблицы `monstercms_news`
--
CREATE TABLE IF NOT EXISTS
`monstercms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`autor`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`theme` varchar(155) NOT
NULL,
`msg` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы
`monstercms_news`
--
INSERT INTO `monstercms_news` (`id`, `autor`, `time`,
`theme`, `msg`) VALUES
(1, 1, 1471264354, 'Добро
пожаловать', 'MonsterCMS ver. 0.6 запущен в beta
тестировании.');
--
--------------------------------------------------------
--
--
Структура таблицы `monstercms_news_comm`
--
CREATE TABLE
IF NOT EXISTS `monstercms_news_comm` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_news` int(11) NOT NULL,
`user` varchar(155) NOT
NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`del_mes`
int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`monstercms_rating_history`
--
CREATE TABLE IF NOT EXISTS
`monstercms_rating_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` varchar(155) NOT NULL,
`theme` varchar(155) NOT NULL,
`info`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`user` int(11) NOT NULL,
`status` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура
таблицы `monstercms_reports`
--
CREATE TABLE IF NOT EXISTS
`monstercms_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_reports` int(11) NOT NULL,
`ank_reports` int(11) NOT NULL,
`msg`
text NOT NULL,
`time` int(11) NOT NULL,
`status` int(11) NOT NULL
DEFAULT '1',
`reports` varchar(2) NOT NULL DEFAULT '1',
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `monstercms_site_setting`
--
CREATE
TABLE IF NOT EXISTS `monstercms_site_setting` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`style` varchar(110) NOT NULL DEFAULT 'default',
`size_ico` int(11) NOT NULL DEFAULT '16',
`title` varchar(255) NOT NULL,
`site_open` varchar(11) NOT NULL DEFAULT '1',
`reg_open` varchar(11) NOT
NULL DEFAULT '1',
`ava_rating` varchar(255) DEFAULT '0.02',
`theme_rating` varchar(11) NOT NULL DEFAULT '0.01',
`theme_post_rating`
varchar(11) NOT NULL DEFAULT '0.01',
`wall_rating` varchar(11) NOT NULL
DEFAULT '0.01',
`down_rating` varchar(11) NOT NULL DEFAULT '0.03',
`down_comm_rating` varchar(11) NOT NULL DEFAULT '0.01',
`news_comm_rating` varchar(11) NOT NULL DEFAULT '0.01',
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--
Дамп данных таблицы `monstercms_site_setting`
--
INSERT
INTO `monstercms_site_setting` (`id`, `style`, `size_ico`, `title`,
`site_open`, `reg_open`, `ava_rating`, `theme_rating`, `theme_post_rating`,
`wall_rating`, `down_rating`, `down_comm_rating`, `news_comm_rating`)
VALUES
(1, 'default', 16, 'MonsterCMS 1.0', '1', '1', '0.02', '0.04',
'0.01', '0.01', '0.03', '0.01', '0.01');
--
--------------------------------------------------------
--
--
Структура таблицы `monstercms_wall_site`
--
CREATE TABLE
IF NOT EXISTS `monstercms_wall_site` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` varchar(155) NOT NULL,
`ank` varchar(155) NOT
NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`del_mes`
int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;