Файл: install/mysql.sql
Строк: 152
-- phpMyAdmin SQL Dump
-- version 3.4.3.2
--
http://www.phpmyadmin.net
--
-- Хост: 10.0.0.104:3309
-- Время
создания: Янв 07 2015 г., 05:08
-- Версия
сервера: 5.1.66
-- Версия PHP: 5.3.14
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 */;
--
-- База данных: `zeocms`
--
--
--------------------------------------------------------
--
--
Структура таблицы `forump`
--
CREATE TABLE IF NOT
EXISTS `forump` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg`
varchar(15000) DEFAULT NULL,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`tema` int(11) NOT NULL DEFAULT
'0',
`cit` varchar(250) DEFAULT NULL,
`edit` varchar(200) DEFAULT
NULL,
`forums` int(11) NOT NULL DEFAULT '0',
`razdel` int(11) NOT
NULL DEFAULT '0',
`otvet` varchar(250) CHARACTER SET utf8 COLLATE
utf8_danish_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=141 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forumr`
--
CREATE TABLE IF NOT
EXISTS `forumr` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
varchar(288) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forums`
--
CREATE TABLE IF NOT
EXISTS `forums` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
varchar(288) DEFAULT NULL,
`razdel` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3
;
--
--------------------------------------------------------
--
--
Структура таблицы `forumt`
--
CREATE TABLE IF NOT
EXISTS `forumt` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
varchar(60) DEFAULT NULL,
`forums` int(11) NOT NULL DEFAULT '0',
`razdel` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT
'0',
`close` int(11) NOT NULL DEFAULT '0',
`up` int(11) NOT NULL
DEFAULT '0',
`msg` mediumtext,
`user` int(11) NOT NULL DEFAULT '0',
`edit` varchar(200) DEFAULT NULL,
`timenew` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=17 ;
--
--------------------------------------------------------
--
--
Структура таблицы `lenta`
--
CREATE TABLE IF NOT EXISTS
`lenta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT
NULL,
`kto` varchar(100) NOT NULL,
`komy` varchar(100) NOT NULL,
`time` varchar(100) NOT NULL,
`readlen` varchar(1) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=46 ;
--
--------------------------------------------------------
--
--
Структура таблицы `mail`
--
CREATE TABLE IF NOT EXISTS
`mail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT
NULL,
`id_kont` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg`
varchar(1024) NOT NULL,
`read` set('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`,`id_kont`),
KEY `read`
(`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=151 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS
`news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`admin` int(11) NOT
NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`msg`
varchar(20000) DEFAULT NULL,
`edit` int(11) NOT NULL DEFAULT '0',
`editm` varchar(150) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3
;
--
--------------------------------------------------------
--
--
Структура таблицы `newstime`
--
CREATE TABLE IF NOT
EXISTS `newstime` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg`
varchar(288) DEFAULT NULL,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`otvet` varchar(150) DEFAULT
NULL,
`admin` int(11) NOT NULL DEFAULT '0',
`close` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=26 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_comm`
--
CREATE TABLE IF NOT
EXISTS `news_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`msg` varchar(20000) DEFAULT NULL,
`news` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=11 ;
--
--------------------------------------------------------
--
--
Структура таблицы `settings`
--
CREATE TABLE IF NOT
EXISTS `settings` (
`value` text NOT NULL,
`key` text NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `settings`
--
INSERT INTO `settings` (`value`, `key`)
VALUES
('close_reg', '1'),
('index', 'ZeoCms движок для
вашего сайта !'),
('thems', '1');
--
--------------------------------------------------------
--
--
Структура таблицы `smiles`
--
CREATE TABLE IF NOT
EXISTS `smiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`command`
varchar(50) NOT NULL,
`folder` varchar(50) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
--
--
Дамп данных таблицы `smiles`
--
INSERT INTO `smiles`
(`id`, `command`, `folder`) VALUES
(1, '!1', '/images/smiles/1.png'),
(2,
'!2', '/images/smiles/2.png'),
(3, '!3', '/images/smiles/3.png'),
(4,
'!4', '/images/smiles/4.png'),
(5, '!5', '/images/smiles/5.png'),
(6,
'!6', '/images/smiles/6.png'),
(7, '!7', '/images/smiles/7.png'),
(8,
'!8', '/images/smiles/8.png'),
(9, '!9', '/images/smiles/9.png'),
(10,
'!10', '/images/smiles/10.png'),
(11, '!11',
'/images/smiles/11.png'),
(12, '!12', '/images/smiles/12.png'),
(13,
'!13', '/images/smiles/13.png'),
(14, '!14',
'/images/smiles/14.png'),
(15, '!15', '/images/smiles/15.png'),
(16,
'!16', '/images/smiles/16.png'),
(17, '!17',
'/images/smiles/17.png'),
(18, '!18', '/images/smiles/18.png'),
(19,
'!19', '/images/smiles/19.png'),
(20, '!20',
'/images/smiles/20.png'),
(21, '!21', '/images/smiles/21.png'),
(22,
'!22', '/images/smiles/22.png'),
(23, '!23',
'/images/smiles/23.png'),
(24, '!24', '/images/smiles/24.png'),
(25,
'!25', '/images/smiles/25.png'),
(26, '!26',
'/images/smiles/26.png'),
(27, '!27', '/images/smiles/27.png'),
(28,
'!28', '/images/smiles/28.png'),
(29, '!29',
'/images/smiles/29.png'),
(30, '!30', '/images/smiles/30.png'),
(31,
'!31', '/images/smiles/31.png'),
(32, '!32',
'/images/smiles/32.png'),
(33, '!33', '/images/smiles/33.png'),
(34,
'!34', '/images/smiles/34.png'),
(35, '!35',
'/images/smiles/35.png'),
(36, '!36', '/images/smiles/36.png'),
(37,
'!37', '/images/smiles/37.png'),
(38, '!38',
'/images/smiles/38.png'),
(39, '!39', '/images/smiles/39.png'),
(40,
'!40', '/images/smiles/40.png');
--
--------------------------------------------------------
--
--
Структура таблицы `stena`
--
CREATE TABLE IF NOT EXISTS
`stena` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` varchar(288)
DEFAULT NULL,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT
NULL DEFAULT '0',
`otvet` varchar(150) DEFAULT NULL,
`admin` int(11)
NOT NULL DEFAULT '0',
`close` int(11) NOT NULL DEFAULT '0',
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;
--
--------------------------------------------------------
--
--
Структура таблицы `user`
--
CREATE TABLE IF NOT EXISTS
`user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nick`
varchar(30) NOT NULL,
`pass` varchar(110) NOT NULL,
`sex` int(11) NOT
NULL DEFAULT '0',
`timereg` int(11) NOT NULL DEFAULT '0',
`admin`
int(11) NOT NULL DEFAULT '0',
`mail` varchar(32) DEFAULT NULL,
`datelast` int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT
'10',
`news` int(1) NOT NULL DEFAULT '1',
`strlen` varchar(10) NOT
NULL DEFAULT '500',
`ip` varchar(30) DEFAULT NULL,
`sekpass`
varchar(15) DEFAULT NULL,
`ua` varchar(199) DEFAULT NULL,
`ava`
varchar(130) DEFAULT NULL,
`imya` varchar(15) DEFAULT NULL,
`osebe`
varchar(200) DEFAULT NULL,
`bd` varchar(2) DEFAULT NULL,
`bm`
varchar(2) DEFAULT NULL,
`by` varchar(4) DEFAULT NULL,
`strana`
varchar(20) DEFAULT NULL,
`gorod` varchar(20) DEFAULT NULL,
`icq`
int(9) DEFAULT NULL,
`site` varchar(15) DEFAULT NULL,
`open_forum`
int(1) NOT NULL DEFAULT '1',
`thems` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30
;
-- --------------------------------------------------------
--
--
Структура таблицы `users_konts`
--
CREATE TABLE IF NOT
EXISTS `users_konts` (
`id_user` int(11) NOT NULL,
`id_kont` int(11)
NOT NULL,
`time` int(11) NOT NULL,
`new_msg` int(11) NOT NULL DEFAULT
'0',
`type` enum('common','ignor','favorite','deleted') NOT NULL DEFAULT
'common',
`name` varchar(64) DEFAULT NULL,
UNIQUE KEY `id_user`
(`id_user`,`id_kont`),
KEY `type` (`type`),
KEY `time` (`time`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!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 */;