Файл: muzxit.ru/install/install/install.sql
Строк: 602
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
--
Хост: 127.0.0.1
-- Время создания: Янв 31 2013 г.,
22:17
-- Версия сервера: 5.5.25
-- Версия PHP:
5.3.13
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 */;
--
-- База данных: `musicjohn`
--
--
--------------------------------------------------------
--
--
Структура таблицы `cms_ads`
--
CREATE TABLE IF NOT EXISTS
`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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_album_cat`
--
CREATE TABLE IF NOT
EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_album_comments`
--
CREATE TABLE IF
NOT EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_album_downloads`
--
CREATE TABLE IF
NOT EXISTS `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=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_album_files`
--
CREATE TABLE IF NOT
EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_album_views`
--
CREATE TABLE IF NOT
EXISTS `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=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_album_votes`
--
CREATE TABLE IF NOT
EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_ban_ip`
--
CREATE TABLE IF NOT
EXISTS `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,
`who` varchar(25) NOT NULL,
`reason` text NOT NULL,
`date`
int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ip1` (`ip1`),
UNIQUE KEY `ip2` (`ip2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_ban_users`
--
CREATE TABLE IF NOT
EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_counters`
--
CREATE TABLE IF NOT
EXISTS `cms_counters` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sort` int(10) NOT NULL DEFAULT '1',
`name` varchar(30) NOT NULL,
`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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_forum_files`
--
CREATE TABLE IF NOT
EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_forum_rdm`
--
CREATE TABLE IF NOT
EXISTS `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=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_forum_vote`
--
CREATE TABLE IF NOT
EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_forum_vote_users`
--
CREATE TABLE
IF NOT EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_sessions`
--
CREATE TABLE IF NOT
EXISTS `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=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_settings`
--
CREATE TABLE IF NOT
EXISTS `cms_settings` (
`key` tinytext NOT NULL,
`val` text NOT NULL,
PRIMARY KEY (`key`(30))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--
Дамп данных таблицы `cms_settings`
--
INSERT INTO
`cms_settings` (`key`, `val`) VALUES
('lng', 'uz'),
('homeurl',
'http://musicjohn.loc'),
('email', 'musicjohn@mail.ru'),
('timeshift',
'0'),
('copyright', 'Powered by JohnCMS'),
('admp', 'panel'),
('flsz',
'4000'),
('gzip', '1'),
('clean_time', '1359651516'),
('mod_reg',
'2'),
('mod_forum', '2'),
('mod_guest', '2'),
('mod_lib', '2'),
('mod_gal',
'2'),
('mod_down_comm', '1'),
('mod_down', '2'),
('mod_lib_comm',
'1'),
('mod_gal_comm', '1'),
('meta_key', ''),
('meta_desc', 'Powered by
JohnCMS http://johncms.com'),
('skindef', 'wap'),
('news',
'a:8:{s:4:"view";i:1;s:4:"size";i:200;s:8:"quantity";i:5;s:4:"days";i:3;s:6:"breaks";i:1;s:7:"smileys";i:1;s:4:"tags";i:1;s:3:"kom";i:1;}'),
('karma',
'a:6:{s:12:"karma_points";i:5;s:10:"karma_time";i:86400;s:5:"forum";i:20;s:4:"time";i:0;s:2:"on";i:1;s:3:"adm";i:0;}'),
('antiflood',
'a:5:{s:4:"mode";i:2;s:3:"day";i:10;s:5:"night";i:30;s:7:"dayfrom";i:10;s:5:"dayto";i:22;}'),
('active',
'1'),
('webskindef', 'web'),
('lng_list',
'a:2:{s:2:"ru";s:9:"O''zbekcha";s:2:"uz";s:9:"O''zbekcha";}');
--
--------------------------------------------------------
--
--
Структура таблицы `cms_users_data`
--
CREATE TABLE IF NOT
EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_users_guestbook`
--
CREATE TABLE IF
NOT EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `cms_users_iphistory`
--
CREATE TABLE IF
NOT EXISTS `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=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `downfiles`
--
CREATE TABLE IF NOT
EXISTS `downfiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type`
int(2) NOT NULL DEFAULT '0',
`pathid` int(11) NOT NULL,
`way` text NOT
NULL,
`name` text NOT NULL,
`desc` text NOT NULL,
`time` int(11) NOT
NULL,
`rating` varchar(3) NOT NULL DEFAULT '0',
`gol` text NOT NULL,
`count` int(11) NOT NULL DEFAULT '0',
`size` int(11) NOT NULL,
`login`
text NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '1',
`themeid`
int(11) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
FULLTEXT KEY `desc` (`desc`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `downkomm`
--
CREATE TABLE IF NOT EXISTS
`downkomm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fileid` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`text` text
NOT NULL,
`plus` int(11) NOT NULL,
`minus` int(11) NOT NULL,
`golos`
text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `download`
--
CREATE TABLE IF NOT EXISTS
`download` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`refid`
int(11) NOT NULL DEFAULT '0',
`adres` text NOT NULL,
`time` int(11) NOT
NULL DEFAULT '0',
`name` text NOT NULL,
`type` varchar(4) NOT NULL
DEFAULT '',
`avtor` varchar(25) NOT NULL DEFAULT '',
`ip` text NOT
NULL,
`soft` text NOT NULL,
`text` text NOT NULL,
`screen` text NOT
NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `refid`
(`refid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `downpath`
--
CREATE TABLE IF NOT EXISTS
`downpath` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`refid` int(11) NOT
NULL,
`way` text NOT NULL,
`name` text NOT NULL,
`desc` text NOT
NULL,
`position` int(11) NOT NULL,
`dost` int(11) NOT NULL,
`types`
text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
ROW_FORMAT=DYNAMIC AUTO_INCREMENT=7 ;
--
-- Дамп данных
таблицы `downpath`
--
INSERT INTO `downpath` (`id`, `refid`, `way`,
`name`, `desc`, `position`, `dost`, `types`) VALUES
(1, 0, 'uzbek/',
'O`zbekcha', 'O`zbekcha taronalar', 0, 1, 'mp3'),
(2, 0, 'russian/',
'Ruscha', 'Ruscha qo`shiqlar', 0, 1, 'mp3'),
(3, 0, 'xorij/', 'Zarubejka',
'Xorij taronalari', 0, 1, 'mp3'),
(4, 0, 'kazax/', 'Qozoqcha', 'Qozoqcha
qo`shiqlar', 0, 1, 'mp3'),
(5, 0, 'karakalpak/', 'Qoraqalpoqcha',
'Qoraqalpoqcha qo`shiqlar', 0, 1, 'mp3'),
(6, 0, 'harxil/', 'Har-xil
taronalar', 'Har-xil qo`shiqlar', 0, 1, 'mp3');
--
--------------------------------------------------------
--
--
Структура таблицы `downscreen`
--
CREATE TABLE IF NOT
EXISTS `downscreen` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fileid`
int(11) NOT NULL,
`way` text NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `down_bookmarks`
--
CREATE TABLE IF NOT
EXISTS `down_bookmarks` (
`user` int(11) NOT NULL,
`file` int(11) NOT
NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`time`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `forum`
--
CREATE TABLE IF NOT EXISTS
`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` bigint(11) NOT NULL DEFAULT
'0',
`ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
`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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `gallery`
--
CREATE TABLE IF NOT EXISTS
`gallery` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`refid`
int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`type` varchar(2) NOT NULL DEFAULT '',
`avtor` varchar(25) NOT NULL
DEFAULT '',
`text` text NOT NULL,
`name` text NOT NULL,
`user`
binary(1) NOT NULL DEFAULT '\0',
`ip` text NOT NULL,
`soft` text NOT
NULL,
PRIMARY KEY (`id`),
KEY `refid` (`refid`),
KEY `type`
(`type`),
KEY `time` (`time`),
KEY `avtor` (`avtor`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `guest`
--
CREATE TABLE IF NOT EXISTS
`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(20) 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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `karma_users`
--
CREATE TABLE IF NOT
EXISTS `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=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `lib`
--
CREATE TABLE IF NOT EXISTS
`lib` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`refid` int(10)
unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT
'0',
`type` varchar(4) NOT NULL DEFAULT '',
`name` tinytext NOT NULL,
`announce` text NOT NULL,
`avtor` varchar(25) NOT NULL DEFAULT '',
`text` mediumtext NOT NULL,
`ip` int(11) NOT NULL DEFAULT '0',
`soft`
text NOT NULL,
`moder` tinyint(1) NOT NULL DEFAULT '0',
`count` int(10)
unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `type`
(`type`),
KEY `moder` (`moder`),
KEY `time` (`time`),
KEY `refid`
(`refid`),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY `text` (`text`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS
`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=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `privat`
--
CREATE TABLE IF NOT EXISTS
`privat` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user`
varchar(25) NOT NULL DEFAULT '',
`text` text NOT NULL,
`time` int(10)
unsigned NOT NULL DEFAULT '0',
`author` varchar(25) NOT NULL DEFAULT '',
`type` char(3) NOT NULL DEFAULT '',
`chit` char(3) NOT NULL DEFAULT '',
`temka` text NOT NULL,
`otvet` tinyint(1) unsigned NOT NULL DEFAULT
'0',
`me` varchar(25) NOT NULL DEFAULT '',
`cont` varchar(25) NOT NULL
DEFAULT '',
`ignor` varchar(25) NOT NULL DEFAULT '',
`attach` text NOT
NULL,
PRIMARY KEY (`id`),
KEY `me` (`me`),
KEY `ignor` (`ignor`),
KEY `type` (`type`),
KEY `chit` (`chit`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `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(50) 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(30) NOT NULL DEFAULT '',
`set_user` text NOT NULL,
`set_forum` 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,
PRIMARY
KEY (`id`),
KEY `name_lat` (`name_lat`),
KEY `lastdate` (`lastdate`),
KEY `place` (`place`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;