Файл: s-klub_install/tables/user.sql
Строк: 67
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,
`ank_sait` VARCHAR( 20 ) NOT NULL,
`ank_strana`
enum('0','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT '0',
`ncolor` varchar(10) NOT NULL,
`ncolor2` varchar(10) NOT NULL,
`wmid`
varchar(12) NOT NULL;
`wmr` varchar(12) NOT 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,
`date_reg` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL,
`date_aut` int(11) NOT NULL DEFAULT '0',
`date_last` int(11) NOT NULL
DEFAULT '0',
`balls` int(11) NOT NULL DEFAULT '0',
`bra` int(11) NOT
NULL DEFAULT '0',
`rating` int(11) NOT NULL DEFAULT '0',
`level`
enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`group_access` int(10)
unsigned NOT NULL DEFAULT '0',
`pol` enum('0','1') NOT NULL DEFAULT '1',
`dop` enum('0','1') NOT NULL DEFAULT '0',
`url` varchar(64) NOT NULL
DEFAULT '/',
`show_url` enum('0','1') NOT NULL DEFAULT '1',
`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_o_sebe`
varchar(512) DEFAULT NULL,
`ank_icq` int(9) DEFAULT NULL,
`ank_skype`
varchar(16) DEFAULT NULL,
`ank_mail` varchar(32) DEFAULT NULL,
`ank_n_tel` varchar(11) DEFAULT NULL,
`ank_name` varchar(32) DEFAULT
NULL,
`ank_fam` varchar(32) DEFAULT NULL,
`set_time_chat` int(11)
DEFAULT '30',
`set_p_str` int(11) DEFAULT '7',
`set_show_icon`
set('0','1','2') DEFAULT '1',
`set_translit` enum('0','1') 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 's-klub_black',
`set_them2` varchar(32) DEFAULT 's-klub_black',
`sell` enum('0','1','2',
'3', '4', '5', '6', '7') NOT NULL DEFAULT '0',
`meteo_country` int(11)
NOT NULL DEFAULT '0',
`autorization` enum('0','1') NOT NULL DEFAULT '0',
`add_konts` enum('0','1','2') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `nick` (`nick`),
KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;