Файл: install/db_tables/db_clubwm.sql
Строк: 438
-- Структура таблицы `admin_log`
--
CREATE TABLE IF NOT
EXISTS `admin_log` (
`id` int(10) unsigned NOT NULL auto_increment,
`id_user` int(10) unsigned NOT NULL,
`time` int(10) unsigned NOT NULL,
`mod` int(11) NOT NULL,
`act` int(11) NOT NULL,
`opis` text NOT NULL,
PRIMARY KEY (`id`),
KEY `mod` (`mod`),
KEY `act` (`act`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_log_act`
--
CREATE TABLE IF NOT
EXISTS `admin_log_act` (
`id` int(11) NOT NULL auto_increment,
`id_mod`
int(11) NOT NULL,
`name` varchar(64) default NULL,
PRIMARY KEY
(`id`),
KEY `act` (`name`),
KEY `id_mod` (`id_mod`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_log_mod`
--
CREATE TABLE IF NOT
EXISTS `admin_log_mod` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(64) NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `all_accesses`
--
CREATE TABLE IF NOT
EXISTS `all_accesses` (
`type` varchar(32) NOT NULL,
`name` varchar(64)
NOT NULL,
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `arti_conf`
--
CREATE TABLE IF NOT
EXISTS `arti_conf` (
`open` varchar(2) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `arti_genom`
--
CREATE TABLE IF NOT
EXISTS `arti_genom` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(150) NOT NULL,
`opis` varchar(250) NOT NULL,
`price` int(11)
NOT NULL,
`price2` int(11) NOT NULL,
`path` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `arti_odezhda`
--
CREATE TABLE IF NOT
EXISTS `arti_odezhda` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(150) NOT NULL,
`opis` varchar(250) NOT NULL,
`price` int(11)
NOT NULL,
`price2` int(11) NOT NULL,
`path` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `arti_oruzhie`
--
CREATE TABLE IF NOT
EXISTS `arti_oruzhie` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(150) NOT NULL,
`opis` varchar(250) NOT NULL,
`price` int(11)
NOT NULL,
`price2` int(11) NOT NULL,
`path` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `arti_pechati`
--
CREATE TABLE IF NOT
EXISTS `arti_pechati` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(150) NOT NULL,
`opis` varchar(250) NOT NULL,
`price` int(11)
NOT NULL,
`price2` int(11) NOT NULL,
`path` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `arti_svitki`
--
CREATE TABLE IF NOT
EXISTS `arti_svitki` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(150) NOT NULL,
`opis` varchar(250) NOT NULL,
`price` int(11)
NOT NULL,
`price2` int(11) NOT NULL,
`path` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `ban`
--
CREATE TABLE IF NOT EXISTS
`ban` (
`id` int(11) NOT NULL auto_increment,
`time` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`id_ban` int(11) NOT NULL,
`prich`
varchar(1024) NOT NULL,
`view` set('1','0') NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`,`id_ban`),
KEY `time`
(`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `ban_ip`
--
CREATE TABLE IF NOT EXISTS
`ban_ip` (
`min` bigint(20) NOT NULL,
`max` bigint(20) NOT NULL,
KEY
`min` (`min`,`max`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `characters`
--
CREATE TABLE IF NOT
EXISTS `characters` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(50) NOT NULL,
`uname` varchar(50) NOT NULL,
`derevn`
varchar(50) NOT NULL,
`path` varchar(15) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `chat_post`
--
CREATE TABLE IF NOT
EXISTS `chat_post` (
`id` int(11) NOT NULL auto_increment,
`room`
int(11) NOT NULL,
`id_user` int(11) default NULL,
`time` int(11) NOT
NULL,
`msg` varchar(1024) default NULL,
`vopros` int(11) default NULL,
`umnik_st` set('0','1','2','3','4') default '0',
`shutnik` set('0','1')
NOT NULL default '0',
`privat` int(11) default NULL,
PRIMARY KEY
(`id`),
KEY `room` (`room`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `chat_rooms`
--
CREATE TABLE IF NOT
EXISTS `chat_rooms` (
`id` int(11) NOT NULL auto_increment,
`pos`
int(11) NOT NULL,
`name` varchar(32) NOT NULL,
`umnik` set('0','1')
default '0',
`shutnik` set('0','1') default '0',
`opis` varchar(256)
NOT NULL,
PRIMARY KEY (`id`),
KEY `pos` (`pos`,`umnik`,`shutnik`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `chat_shutnik`
--
CREATE TABLE IF NOT
EXISTS `chat_shutnik` (
`id` int(11) NOT NULL auto_increment,
`anek`
varchar(1024) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=501 ;
--
--------------------------------------------------------
--
--
Структура таблицы `chat_vopros`
--
CREATE TABLE IF NOT
EXISTS `chat_vopros` (
`id` int(11) NOT NULL auto_increment,
`vopros`
varchar(1024) NOT NULL,
`otvet` varchar(32) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=502 ;
--
--------------------------------------------------------
--
--
Структура таблицы `chat_who`
--
CREATE TABLE IF NOT EXISTS
`chat_who` (
`id_user` int(11) NOT NULL,
`room` int(11) NOT NULL,
`time` int(11) NOT NULL,
KEY `id_user` (`id_user`,`room`,`time`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `cron`
--
CREATE TABLE IF NOT EXISTS
`cron` (
`id` varchar(32) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_f`
--
CREATE TABLE IF NOT EXISTS
`forum_f` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(32)
NOT NULL,
`pos` int(11) NOT NULL,
`opis` varchar(512) NOT NULL,
`adm`
set('0','1') NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_files`
--
CREATE TABLE IF NOT
EXISTS `forum_files` (
`id` int(11) NOT NULL auto_increment,
`id_post`
int(11) NOT NULL,
`name` varchar(64) default NULL,
`ras` varchar(32)
NOT NULL,
`size` int(11) NOT NULL,
`type` varchar(32) NOT NULL,
`count` int(11) NOT NULL default '0',
`rating` int(11) NOT NULL default
'0',
PRIMARY KEY (`id`),
KEY `id_post` (`id_post`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_files_rating`
--
CREATE TABLE IF
NOT EXISTS `forum_files_rating` (
`id_file` int(11) NOT NULL,
`id_user`
int(11) NOT NULL,
`rating` int(11) default '0',
KEY `id_file`
(`id_file`),
KEY `id_user` (`id_user`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_p`
--
CREATE TABLE IF NOT EXISTS
`forum_p` (
`id` int(11) NOT NULL auto_increment,
`id_forum` int(11)
NOT NULL,
`id_razdel` int(11) NOT NULL,
`id_them` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg`
varchar(1024) NOT NULL,
`cit` int(11) default NULL,
PRIMARY KEY
(`id`),
KEY `id_user` (`id_user`),
KEY `time` (`time`),
KEY
`id_forum` (`id_forum`),
KEY `id_razdel` (`id_razdel`),
KEY `id_them`
(`id_them`),
FULLTEXT KEY `msg` (`msg`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_r`
--
CREATE TABLE IF NOT EXISTS
`forum_r` (
`id` int(11) NOT NULL auto_increment,
`id_forum` int(11)
NOT NULL,
`name` varchar(32) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_forum` (`id_forum`,`time`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_t`
--
CREATE TABLE IF NOT EXISTS
`forum_t` (
`id` int(11) NOT NULL auto_increment,
`id_forum` int(11)
NOT NULL,
`id_razdel` int(11) default NULL,
`name` varchar(32) NOT
NULL,
`id_user` int(11) default NULL,
`time_create` int(11) NOT NULL,
`time` int(11) NOT NULL,
`up` set('0','1') NOT NULL default '0',
`close` set('0','1') NOT NULL default '0',
PRIMARY KEY (`id`),
KEY
`id_forum` (`id_forum`,`id_razdel`),
FULLTEXT KEY `name` (`name`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_zakl`
--
CREATE TABLE IF NOT
EXISTS `forum_zakl` (
`id_user` int(11) NOT NULL,
`id_them` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`time_obn` int(11) NOT NULL,
KEY
`id_user` (`id_user`,`id_them`,`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `gallery`
--
CREATE TABLE IF NOT EXISTS
`gallery` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT
NULL,
`name` varchar(32) NOT NULL,
`time_create` int(11) NOT NULL,
`time` int(11) NOT NULL,
`opis` varchar(256) NOT NULL,
PRIMARY KEY
(`id`),
KEY `id_user` (`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `gallery_foto`
--
CREATE TABLE IF NOT
EXISTS `gallery_foto` (
`id` int(11) NOT NULL auto_increment,
`id_gallery` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
`ras`
varchar(4) NOT NULL,
`type` varchar(64) NOT NULL,
`opis` varchar(1024)
NOT NULL,
`rating` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `id_gallery` (`id_gallery`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `gallery_komm`
--
CREATE TABLE IF NOT
EXISTS `gallery_komm` (
`id` int(11) NOT NULL auto_increment,
`id_foto`
int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_foto`
(`id_foto`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `gallery_rating`
--
CREATE TABLE IF NOT
EXISTS `gallery_rating` (
`id_foto` int(11) NOT NULL,
`id_user` int(11)
NOT NULL,
KEY `id_foto` (`id_foto`,`id_user`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `guest`
--
CREATE TABLE IF NOT EXISTS
`guest` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT
NULL default '0',
`time` int(11) NOT NULL,
`msg` varchar(1024)
character set utf8 collate utf8_unicode_ci default NULL,
PRIMARY KEY
(`id`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `guests`
--
CREATE TABLE IF NOT EXISTS
`guests` (
`ip` bigint(20) NOT NULL,
`ua` varchar(32) NOT NULL,
`date_aut` int(11) NOT NULL,
`date_last` int(11) NOT NULL,
`url`
varchar(64) NOT NULL,
`pereh` int(11) NOT NULL default '0',
KEY `ip_2`
(`ip`,`ua`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `konts`
--
CREATE TABLE IF NOT EXISTS
`konts` (
`id_user` int(11) NOT NULL,
`id_kont` int(11) NOT NULL,
`time` int(11) NOT NULL,
KEY `id_user` (`id_user`,`id_kont`,`time`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `k_characters`
--
CREATE TABLE IF NOT
EXISTS `k_characters` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(50) NOT NULL,
`opis` varchar(150) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `lib_dir`
--
CREATE TABLE IF NOT EXISTS
`lib_dir` (
`id` int(11) NOT NULL auto_increment,
`num` int(11) NOT
NULL default '0',
`name` varchar(64) NOT NULL,
`dir` varchar(512) NOT
NULL default '/',
`dir_osn` varchar(512) default '/',
PRIMARY KEY
(`id`),
KEY `num` (`num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `lib_files`
--
CREATE TABLE IF NOT
EXISTS `lib_files` (
`id` int(11) NOT NULL auto_increment,
`id_user`
int(11) NOT NULL,
`id_dir` int(11) NOT NULL,
`name` varchar(128) NOT
NULL,
`time` int(11) NOT NULL,
`time_last` int(11) NOT NULL,
`size`
int(11) default NULL,
`k_loads` int(11) NOT NULL default '0',
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `loads_komm`
--
CREATE TABLE IF NOT
EXISTS `loads_komm` (
`id` int(11) NOT NULL auto_increment,
`file`
varchar(64) NOT NULL,
`size` int(11) NOT NULL,
`time` int(11) NOT
NULL,
`msg` varchar(512) NOT NULL,
`id_user` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `file` (`file`),
KEY `size` (`size`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `loads_list`
--
CREATE TABLE IF NOT
EXISTS `loads_list` (
`name` varchar(256) NOT NULL,
`size` int(11) NOT
NULL,
`path` varchar(1000) NOT NULL default '/',
`time` int(11) NOT
NULL,
`loads` int(11) NOT NULL default '0',
KEY `time` (`time`),
KEY
`size` (`size`),
KEY `name` (`name`),
KEY `loads` (`loads`),
FULLTEXT
KEY `path_2` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `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=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `mail_to_send`
--
CREATE TABLE IF NOT
EXISTS `mail_to_send` (
`id` int(11) NOT NULL auto_increment,
`mail`
varchar(64) NOT NULL,
`them` varchar(32) NOT NULL,
`msg` varchar(1000)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `media_info`
--
CREATE TABLE IF NOT
EXISTS `media_info` (
`id` int(11) NOT NULL auto_increment,
`file`
varchar(64) NOT NULL,
`size` int(11) NOT NULL,
`lenght` varchar(32) NOT
NULL,
`bit` varchar(32) NOT NULL,
`codec` varchar(32) NOT NULL,
`wh`
varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `file`
(`file`,`size`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS
`news` (
`id` int(11) NOT NULL auto_increment,
`msg` varchar(1024)
default NULL,
`time` int(11) NOT NULL,
`title` varchar(32) default
NULL,
`main_time` int(11) NOT NULL default '0',
`link` varchar(64) NOT
NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_komm`
--
CREATE TABLE IF NOT
EXISTS `news_komm` (
`id` int(11) NOT NULL auto_increment,
`id_user`
int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`time` int(11) NOT
NULL,
`id_news` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `obmennik_dir`
--
CREATE TABLE IF NOT
EXISTS `obmennik_dir` (
`id` int(11) NOT NULL auto_increment,
`num`
int(11) default '0',
`name` varchar(64) NOT NULL,
`ras` varchar(128)
NOT NULL,
`maxfilesize` int(11) NOT NULL,
`dir` varchar(512) NOT NULL
default '/',
`dir_osn` varchar(512) default '/',
`upload` set('1','0')
NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `num` (`num`),
KEY
`dir` (`dir`(333))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `obmennik_files`
--
CREATE TABLE IF NOT
EXISTS `obmennik_files` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`id_dir` int(11) NOT NULL,
`name`
varchar(128) NOT NULL,
`ras` varchar(36) NOT NULL,
`type` varchar(64)
NOT NULL,
`time` int(11) NOT NULL,
`time_last` int(11) NOT NULL,
`size` int(11) NOT NULL,
`k_loads` int(11) default '0',
`opis` text NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `obmennik_komm`
--
CREATE TABLE IF NOT
EXISTS `obmennik_komm` (
`id` int(11) NOT NULL auto_increment,
`id_file` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`time` int(11)
NOT NULL,
`msg` varchar(1024) NOT NULL,
PRIMARY KEY (`id`),
KEY
`id_file` (`id_file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `opsos`
--
CREATE TABLE IF NOT EXISTS
`opsos` (
`min` bigint(11) default NULL,
`max` bigint(11) default
NULL,
`opsos` varchar(64) character set utf8 collate utf8_unicode_ci
default NULL,
KEY `min` (`min`,`max`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `reg_mail`
--
CREATE TABLE IF NOT EXISTS
`reg_mail` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11)
NOT NULL,
`mail` varchar(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE
KEY `mail` (`mail`),
KEY `id_user` (`id_user`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `rekl`
--
CREATE TABLE IF NOT EXISTS
`rekl` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(32) NOT
NULL,
`img` varchar(64) NOT NULL,
`link` varchar(64) NOT NULL,
`time_last` int(11) NOT NULL,
`sel` set('1','2','3','4') NOT NULL default
'1',
`count` int(11) NOT NULL default '0',
`dop_str` set('0','1') NOT
NULL default '1',
PRIMARY KEY (`id`),
KEY `sel` (`sel`),
KEY
`time_last` (`time_last`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `survey_v`
--
CREATE TABLE IF NOT EXISTS
`survey_v` (
`id_s` int(11) NOT NULL,
`id_r` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`time` int(11) NOT NULL,
KEY `id_s`
(`id_s`,`id_r`,`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `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;
--
--------------------------------------------------------
--
--
Структура таблицы `user_collision`
--
CREATE TABLE IF NOT
EXISTS `user_collision` (
`id_user` int(11) NOT NULL,
`id_user2`
int(11) NOT NULL,
`type` set('sess','ip_ua_time') NOT NULL default
'sess',
KEY `id_user` (`id_user`,`id_user2`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `user_group`
--
CREATE TABLE IF NOT
EXISTS `user_group` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(32) NOT NULL,
`level` int(10) unsigned NOT NULL default
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=16 ;
--
--------------------------------------------------------
--
--
Структура таблицы `user_group_access`
--
CREATE TABLE IF
NOT EXISTS `user_group_access` (
`id_group` int(10) unsigned NOT NULL,
`id_access` varchar(32) NOT NULL,
KEY `id_group`
(`id_group`,`id_access`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `user_log`
--
CREATE TABLE IF NOT EXISTS
`user_log` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11)
NOT NULL,
`method` set('1','0') NOT NULL default '0',
`time` int(11)
NOT NULL,
`ip` bigint(20) NOT NULL default '0',
`ua` varchar(32)
default NULL,
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`),
KEY
`time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
-- --------------------------------------------------------
--
--
Структура таблицы `user_ref`
--
CREATE TABLE IF NOT EXISTS
`user_ref` (
`id` int(10) unsigned NOT NULL auto_increment,
`time`
int(10) unsigned NOT NULL,
`id_user` int(10) unsigned NOT NULL,
`url`
varchar(1024) default NULL,
`type_input` varchar(12) default 'cookie',
PRIMARY KEY (`id`),
KEY `time` (`time`,`id_user`),
KEY `type_input`
(`type_input`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `user_tehnik`
--
CREATE TABLE IF NOT
EXISTS `user_tehnik` (
`id` int(11) NOT NULL auto_increment,
`tid`
int(11) NOT NULL,
`uid` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`chakra` varchar(50) NOT NULL,
`opis` varchar(512) NOT NULL,
`opit`
int(11) NOT NULL,
`zvan` int(11) NOT NULL,
`type` varchar(50) NOT
NULL,
`path` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
--------------------------------------------------------
--
--
Структура таблицы `user_voice2`
--
CREATE TABLE IF NOT
EXISTS `user_voice2` (
`id_user` int(11) NOT NULL,
`id_kont` int(11)
NOT NULL,
`rating` int(11) NOT NULL default '0',
`msg` varchar(256)
default NULL,
`time` int(11) NOT NULL,
KEY `id_user`
(`id_user`,`id_kont`),
KEY `time` (`time`),
KEY `rating` (`rating`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `user_weapon`
--
CREATE TABLE IF NOT
EXISTS `user_weapon` (
`id` int(11) NOT NULL auto_increment,
`tid`
int(11) NOT NULL,
`uid` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`en` varchar(50) NOT NULL,
`opis` varchar(512) NOT NULL,
`raz` int(11)
NOT NULL,
`kol` int(11) NOT NULL,
`type` varchar(50) NOT NULL,
`path`
varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `visit_everyday`
--
CREATE TABLE IF NOT
EXISTS `visit_everyday` (
`time` int(11) NOT NULL,
`host` int(11) NOT
NULL,
`hit` int(11) NOT NULL,
`host_ip_ua` int(11) NOT NULL,
KEY
`time` (`time`),
KEY `host` (`host`),
KEY `hit` (`hit`),
KEY
`host_ip_ua` (`host_ip_ua`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `visit_today`
--
CREATE TABLE IF NOT
EXISTS `visit_today` (
`ip` bigint(11) NOT NULL,
`ua` varchar(128)
default NULL,
`time` int(11) NOT NULL,
KEY `ip` (`ip`),
KEY `ua`
(`ua`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;