Файл: install/db_tables/user.sql
Строк: 328
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`nick` varchar(32) NOT NULL,
`pass` varchar(32) NOT
NULL,
`sess` varchar(32) DEFAULT NULL,
`activation` varchar(32) DEFAULT
NULL,
`ban` int(11) NOT NULL DEFAULT '0',
`ban_pr` varchar(64) DEFAULT
NULL,
`ip` bigint(20) NOT NULL DEFAULT '0',
`ip_cl` bigint(20) NOT NULL
DEFAULT '0',
`ip_xff` bigint(20) NOT NULL DEFAULT '0',
`ua` varchar(32)
DEFAULT NULL,
`region` varchar(32) NOT NULL DEFAULT 'Не
заполнено',
`add_konts` enum('0','1','2') NOT NULL default '1',
`date_reg` int(11) NOT NULL DEFAULT '0',
`date_aut` int(11) NOT NULL
DEFAULT '0',
`date_last` int(11) NOT NULL DEFAULT '0',
`sort` int(1)
DEFAULT '0',
`diary_desc` text,
`diary_time` int(11) DEFAULT NULL,
`diary_text` varchar(1024) DEFAULT NULL,
`ncolor` varchar(10) NOT NULL,
`ncolor2` varchar(10) NOT NULL,
`do_cmpl` enum('1','0') DEFAULT '1',
`do_cmpl_diary` enum('1','0') DEFAULT '1',
`online` varchar(7) DEFAULT
'online',
`write_diary` enum('1','0') DEFAULT '1',
`money` int(11) NOT
NULL DEFAULT '0',
`activity` int(11) NOT NULL DEFAULT '0',
`rating`
int(11) NOT NULL DEFAULT '0',
`viewing` int(11) NOT NULL DEFAULT '0',
`wall_password` mediumtext,
`wall_access`
enum('all','only_me','friends','pass','auth') DEFAULT 'all',
`wall_komm`
enum('all','only_me','friends') DEFAULT 'all',
`wall_nokomm`
enum('0','1') NOT NULL DEFAULT '1',
`profile_access`
enum('all','only_me','friends','pass') DEFAULT 'all',
`profile_password`
varchar(128) DEFAULT NULL,
`anketa_access`
enum('all','only_me','friends','pass') DEFAULT 'all',
`friends_access`
enum('all','only_me','friends','pass') DEFAULT 'all',
`friends_password`
varchar(128) DEFAULT NULL,
`friendship` enum('0','1') NOT NULL DEFAULT
'0',
`level` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`group_access` int(10) unsigned NOT NULL DEFAULT '0',
`foot_sit`
enum('left','center','right') DEFAULT 'left',
`sex` enum('0','1') NOT
NULL DEFAULT '1',
`url` varchar(64) NOT NULL DEFAULT '/',
`show_url`
enum('0','1') NOT NULL DEFAULT '0',
`show_foot` enum('on','off') DEFAULT
'on',
`show_foot_type` enum('icons','text') DEFAULT 'text',
`ank_iq`
int(11) NOT NULL,
`ank_g_r` int(4) DEFAULT NULL,
`ank_m_r` int(2)
DEFAULT NULL,
`ank_d_r` int(2) DEFAULT NULL,
`ank_city` varchar(32)
DEFAULT NULL,
`ank_about_me` varchar(512) DEFAULT NULL,
`ank_icq`
int(9) DEFAULT NULL,
`ank_mail` varchar(32) DEFAULT NULL,
`ank_n_tel`
varchar(11) DEFAULT NULL,
`ank_n_tel_home` varchar(11) DEFAULT NULL,
`welcome` varchar(150) NOT NULL DEFAULT 'Я с DCMS Special',
`ank_name`
varchar(32) default NULL,
`ank_surname` varchar(50) DEFAULT NULL,
`ank_patronymic` varchar(50) DEFAULT NULL,
`ank_goal_dating`
enum('0','1') NOT NULL DEFAULT '0',
`ank_goal_dating2` enum('0','1') NOT
NULL DEFAULT '0',
`ank_goal_dating3` enum('0','1') NOT NULL DEFAULT '0',
`ank_goal_dating4` enum('0','1') NOT NULL DEFAULT '0',
`ank_goal_dating5` enum('0','1') NOT NULL DEFAULT '0',
`ank_goal_dating6`
enum('0','1') NOT NULL DEFAULT '0',
`ank_goal_dating7` enum('0','1') NOT
NULL DEFAULT '0',
`ank_goal_dating8` enum('0','1') NOT NULL DEFAULT '0',
`ank_marriage` enum('0','1','2','3') NOT NULL DEFAULT '0',
`ank_orientation` enum('0','1','2','3') NOT NULL DEFAULT '0',
`ank_hair`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_eye`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_height`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_weight`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_physique`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`ank_music`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_films`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_books`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_course`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_passion`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_occupation`
enum('0','1','2','3','4','5','6','7','8') NOT NULL DEFAULT '0',
`ank_profession` varchar(32) NOT NULL DEFAULT 'Не заполнено',
`ank_smoking` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`country`
varchar(32) NOT NULL DEFAULT 'Не заполнено',
`time_on` int(11)
NOT NULL,
`set_time_chat` int(11) DEFAULT '30',
`set_online`
enum('0','1','2') DEFAULT '1',
`set_mail` enum('1','2') DEFAULT '1',
`set_p_str` int(11) DEFAULT '7',
`set_forum` enum('0','1','2') DEFAULT
'1',
`set_times` enum('1','0') NOT NULL DEFAULT '1',
`set_files`
enum('0','1') NOT NULL DEFAULT '0',
`set_timesdvig` int(11) NOT NULL
DEFAULT '0',
`set_news_to_mail` enum('0','1') NOT NULL DEFAULT '0',
`set_show_mail` enum('0','1') NOT NULL DEFAULT '0',
`set_them`
varchar(32) DEFAULT 'default',
`set_them2` varchar(32) DEFAULT 'web',
`meteo_country` int(11) NOT NULL DEFAULT '0',
`autorization`
enum('0','1') NOT NULL DEFAULT '0',
`time` int(11) NOT NULL,
`perehodu`
int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nick` (`nick`),
KEY
`url` (`url`),
KEY `set_them` (`set_them`,`set_them2`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
CREATE TABLE `user_dir` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`dir` int(11) NOT NULL,
`ras` varchar(150) NOT NULL,
`upload` int(11) NOT NULL,
`id_user`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;
CREATE TABLE `user_files` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`dir` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`time` int(11) NOT NULL,
`k_loads`
int(11) NOT NULL,
`opis` varchar(2500) NOT NULL,
`size` varchar(20) NOT
NULL,
`ras` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;
CREATE TABLE `user_files_komm` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`id_file` int(11) NOT NULL,
`id_user` int(11)
NOT NULL,
`text` varchar(10000) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
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;
CREATE TABLE `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;
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 ;
INSERT INTO `user_group` (`id`, `name`, `level`) VALUES
(1,
'Пользователь', 0),
(2, 'Модератор форума',
1),
(3, 'Модератор загруз-центра', 1),
(4,
'Модератор библиотеки', 1),
(5, 'Модератор
фотогалереи', 1),
(6, 'Супермодератор', 2),
(7,
'Администратор', 3),
(8, 'Главный
администратор', 9),
(15, 'Создатель', 10);
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;
INSERT INTO
`user_group_access` (`id_group`, `id_access`) VALUES
(2,
'adm_banlist'),
(2, 'adm_panel_show'),
(2, 'adm_set_forum'),
(2,
'adm_show_adm'),
(2, 'adm_statistic'),
(2, 'forum_for_edit'),
(2,
'forum_post_ed'),
(2, 'forum_razd_create'),
(2, 'forum_razd_edit'),
(2,
'forum_them_del'),
(2, 'forum_them_edit'),
(2, 'user_ban_set_h'),
(2,
'user_prof_edit'),
(2, 'user_show_add_info'),
(2, 'user_show_ip'),
(2,
'user_show_ua'),
(3, 'adm_info'),
(3, 'adm_panel_show'),
(3,
'adm_set_loads'),
(3, 'adm_show_adm'),
(3, 'adm_statistic'),
(4,
'adm_info'),
(4, 'adm_panel_show'),
(4, 'adm_ref'),
(4,
'adm_set_foto'),
(4, 'adm_statistic'),
(4, 'user_ban_set_h'),
(4,
'user_prof_edit'),
(5, 'adm_banlist'),
(5, 'adm_info'),
(5,
'adm_panel_show'),
(5, 'adm_set_foto'),
(5, 'adm_show_adm'),
(5,
'adm_statistic'),
(5, 'foto_alb_del'),
(5, 'foto_foto_edit'),
(5,
'user_ban_set_h'),
(5, 'user_show_ua'),
(6, 'adm_banlist'),
(6,
'adm_panel_show'),
(6, 'adm_set_forum'),
(6, 'adm_set_foto'),
(6,
'adm_statistic'),
(6, 'forum_razd_create'),
(6, 'forum_razd_edit'),
(6,
'forum_them_edit'),
(6, 'foto_foto_edit'),
(6, 'guest_clear'),
(6,
'guest_delete'),
(6, 'guest_show_ip'),
(6, 'user_ban_set_h'),
(6,
'user_collisions'),
(6, 'user_prof_edit'),
(6, 'user_show_add_info'),
(6,
'user_show_ua'),
(7, 'adm_banlist'),
(7, 'adm_ban_ip'),
(7,
'adm_forum_sinc'),
(7, 'adm_info'),
(7, 'adm_news'),
(7,
'adm_panel_show'),
(7, 'adm_ref'),
(7, 'adm_set_forum'),
(7,
'adm_set_foto'),
(7, 'adm_set_loads'),
(7, 'adm_show_adm'),
(7,
'adm_statistic'),
(7, 'forum_for_create'),
(7, 'forum_for_delete'),
(7,
'forum_for_edit'),
(7, 'forum_post_ed'),
(7, 'forum_razd_create'),
(7,
'forum_razd_edit'),
(7, 'forum_them_del'),
(7, 'forum_them_edit'),
(7,
'foto_alb_del'),
(7, 'foto_foto_edit'),
(7, 'guest_clear'),
(7,
'guest_delete'),
(7, 'guest_show_ip'),
(7, 'user_ban_set'),
(7,
'user_ban_set_h'),
(7, 'user_ban_unset'),
(7, 'user_change_group'),
(7,
'user_change_nick'),
(7, 'user_collisions'),
(7, 'user_delete'),
(7,
'user_prof_edit'),
(7, 'user_show_add_info'),
(7, 'user_show_ip'),
(7,
'user_show_ua'),
(8, 'adm_banlist'),
(8, 'adm_ban_ip'),
(8,
'adm_forum_sinc'),
(8, 'adm_info'),
(8, 'adm_ip_edit'),
(8,
'adm_log_read'),
(8, 'adm_menu'),
(8, 'adm_news'),
(8, 'adm_news_add'),
(8,
'adm_news_edit'),
(8, 'adm_news_delete'),
(8,
'adm_news_delete_comments'),
(8, 'adm_panel_show'),
(8, 'adm_ref'),
(8,
'adm_rekl'),
(8, 'adm_chmod'),
(8, 'adm_set_forum'),
(8,
'adm_set_foto'),
(8, 'adm_set_loads'),
(8, 'adm_set_sys'),
(8,
'adm_set_user'),
(8, 'adm_conf_server'),
(8, 'adm_set_bb'),
(8,
'adm_set_bb_moder'),
(8, 'adm_set_bb_super_moder'),
(8,
'adm_set_bb_admin'),
(8, 'adm_show_adm'),
(8, 'adm_statistic'),
(8,
'adm_themes'),
(8, 'forum_for_create'),
(8, 'forum_for_delete'),
(8,
'forum_for_edit'),
(8, 'forum_post_close'),
(8, 'forum_post_ed'),
(8,
'forum_razd_create'),
(8, 'forum_razd_edit'),
(8, 'forum_them_del'),
(8,
'forum_them_edit'),
(8, 'foto_alb_del'),
(8, 'foto_foto_edit'),
(8,
'guest_clear'),
(8, 'guest_delete'),
(8, 'guest_show_ip'),
(8,
'user_ban_set'),
(8, 'user_ban_set_h'),
(8, 'user_ban_unset'),
(8,
'user_change_group'),
(8, 'user_change_nick'),
(8, 'user_collisions'),
(8,
'user_delete'),
(8, 'user_mass_delete'),
(8, 'user_prof_edit'),
(8,
'user_show_add_info'),
(8, 'user_show_ip'),
(8, 'user_show_ua'),
(15,
'adm_accesses'),
(15, 'adm_banlist'),
(15, 'adm_ban_ip'),
(15,
'adm_send_money'),
(15, 'adm_send_mess'),
(15, 'adm_send_tape'),
(15,
'adm_forum_sinc'),
(15, 'adm_info'),
(15, 'adm_ip_edit'),
(15,
'adm_log_delete'),
(15, 'adm_log_read'),
(15, 'adm_menu'),
(15,
'adm_mysql'),
(15, 'adm_news'),
(15, 'adm_news_add'),
(15,
'adm_news_edit'),
(15, 'adm_news_delete'),
(15,
'adm_news_delete_comments'),
(15, 'adm_panel_show'),
(15, 'adm_ref'),
(15,
'adm_rekl'),
(15, 'adm_chmod'),
(15, 'adm_set_forum'),
(15,
'adm_set_foto'),
(15, 'adm_conf_server'),
(15, 'adm_changelog'),
(15,
'adm_set_loads'),
(15, 'adm_set_sys'),
(15, 'adm_set_user'),
(15,
'adm_set_bb'),
(15, 'adm_set_bb_moder'),
(15,
'adm_set_bb_super_moder'),
(15, 'adm_set_bb_admin'),
(15,
'adm_show_adm'),
(15, 'adm_statistic'),
(15, 'adm_themes'),
(15,
'forum_for_create'),
(15, 'forum_for_delete'),
(15, 'forum_for_edit'),
(15,
'forum_post_close'),
(15, 'forum_post_ed'),
(15, 'forum_razd_create'),
(15,
'forum_razd_edit'),
(15, 'forum_them_del'),
(15, 'forum_them_edit'),
(15,
'foto_alb_del'),
(15, 'foto_foto_edit'),
(15, 'guest_clear'),
(15,
'guest_delete'),
(15, 'guest_show_ip'),
(15, 'user_ban_set'),
(15,
'user_ban_set_h'),
(15, 'user_ban_unset'),
(15, 'user_change_group'),
(15,
'user_change_nick'),
(15, 'user_collisions'),
(15, 'user_delete'),
(15,
'user_mass_delete'),
(15, 'user_prof_edit'),
(15,
'user_show_add_info'),
(15, 'user_show_ip'),
(15, 'user_show_ua');
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;
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;
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',
KEY `id_user` (`id_user`,`id_kont`),
KEY `rating`
(`rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT
EXISTS `user_blacklist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_ank` int(11) NOT NULL,
`time` int(11)
NOT NULL,
`time_to` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`forever` set('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;