Вход Регистрация
Файл: install/db_tables/user.sql
Строк: 74
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, `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', `swmr` int(11) NOT NULL default '0', `verh_panel`
enum('0','1') NOT NULL DEFAULT '0', `prodavec` int(11) NOT NULL default
'0', `sell` enum('0','1','2') NOT NULL DEFAULT '0', `wmid` varchar(12)
DEFAULT NULL, `wmr` varchar(12) DEFAULT NULL, `wmu` varchar(12) DEFAULT
NULL, `wme` varchar(12) DEFAULT NULL, `wmb` varchar(12) DEFAULT NULL,
`wmz` varchar(12) DEFAULT NULL, `prodazha` enum('0','1') NOT NULL DEFAULT
'0', `pokupka` enum('0','1') NOT NULL DEFAULT '0', `vvod` enum('0','1')
NOT NULL DEFAULT '0', `vivod` enum('0','1') NOT NULL DEFAULT '0',
`perevod` enum('0','1') NOT NULL DEFAULT '0', `sms` enum('0','1') NOT
NULL DEFAULT '0', `send_by` enum('0','1') NOT NULL DEFAULT '0',
`send_kom` enum('0','1') 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', `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, `set_time_chat`
int(11) default '30', `set_p_str` int(11) default '7', `set_show_icon`
enum('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 'default', `set_them2`
varchar(32) default 'web', `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;
Онлайн: 0
Реклама