Вход Регистрация
Файл: sys/db_tables/user.sql
Строк: 114
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', `date_aut`
int(11) NOT NULL DEFAULT '0', `date_last` int(11) NOT NULL DEFAULT '0',
`balls` 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', `url` varchar(64) NOT NULL DEFAULT '/',
`show_url` enum('0','1') NOT NULL DEFAULT '0', `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_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 '20', `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 'default', `set_them2` varchar(32) DEFAULT
'default', `meteo_country` int(11) NOT NULL DEFAULT '0', `autorization`
enum('0','1') NOT NULL DEFAULT '0', `add_konts` int(11) NOT NULL DEFAULT
'1', `privat_ank` set('1','2') NOT NULL DEFAULT '1', `ank_skype`
varchar(32) DEFAULT NULL, `ank_strana` varchar(32) DEFAULT NULL,
`rating2` int(11) NOT NULL DEFAULT '0', `ank_familia` varchar(50) DEFAULT
NULL, `cel_love` enum('0','1','2','3','4','5','6','7','8') NOT NULL
DEFAULT '0', `prosm` int(100) NOT NULL DEFAULT '0', `hello` varchar(35)
DEFAULT NULL, `hellocolor` varchar(10) NOT NULL, `ball` varchar(8)
DEFAULT NULL, `pr` int(10) NOT NULL DEFAULT '0', `ncolor2` varchar(10)
NOT NULL, `ncolor` varchar(10) NOT NULL, `set_times` enum('1','0') NOT
NULL DEFAULT '0', `show_title` set('0','1','2') DEFAULT '0',
`vkl_title` int(11) NOT NULL DEFAULT '0', `mcolor` varchar(10) DEFAULT
NULL, `podcolor` varchar(10) NOT NULL, `p_forum` varchar(100) DEFAULT
NULL, `p_chat` varchar(100) DEFAULT NULL, `guest_closed` set('0','1')
NOT NULL DEFAULT '0', `us_guest` varchar(100) DEFAULT NULL, `inst`
varchar(64) DEFAULT NULL, `schast` varchar(64) DEFAULT NULL, `xyd`
varchar(64) DEFAULT NULL, `myz` varchar(64) DEFAULT NULL, `otkr`
varchar(64) DEFAULT NULL, `sovet` varchar(64) DEFAULT NULL, `razmer`
varchar(64) DEFAULT NULL, `cen` varchar(64) DEFAULT NULL, `error`
varchar(64) DEFAULT NULL, `literatyra` varchar(64) DEFAULT NULL,
`dostigenia` varchar(64) DEFAULT NULL, `neydacha` varchar(64) DEFAULT
NULL, `cel` varchar(64) DEFAULT NULL, `religia` varchar(64) DEFAULT
NULL, `mechta` varchar(64) DEFAULT NULL, `gde` varchar(64) DEFAULT
NULL, `kto` varchar(64) DEFAULT NULL, `esli` varchar(64) DEFAULT NULL,
`dlya_was` varchar(64) DEFAULT NULL, `odnim_slovom` varchar(64) DEFAULT
NULL, `nenravitsya_orient` varchar(64) DEFAULT NULL, `lyubimoe_blyudo`
varchar(64) DEFAULT NULL, `kakix` varchar(64) DEFAULT NULL, `xarakter`
varchar(64) DEFAULT NULL, `nedostatok` varchar(64) DEFAULT NULL,
`deviz` varchar(64) DEFAULT NULL, `dyx` varchar(64) DEFAULT NULL,
`ank_file` set('1','2','3') DEFAULT '1', `game1` enum('0','1') NOT NULL
DEFAULT '0', `game2` enum('0','1') NOT NULL DEFAULT '0', `game3`
enum('0','1') NOT NULL DEFAULT '0', `game4` enum('0','1') NOT NULL
DEFAULT '0', `game5` enum('0','1') NOT NULL DEFAULT '0', `game6`
enum('0','1') NOT NULL DEFAULT '0', `game7` enum('0','1') NOT NULL
DEFAULT '0', `game8` enum('0','1') NOT NULL DEFAULT '0', `game9`
enum('0','1') NOT NULL DEFAULT '0', `game10` enum('0','1') NOT NULL
DEFAULT '0', `game11` enum('0','1') NOT NULL DEFAULT '0', `game12`
enum('0','1') NOT NULL DEFAULT '0', `game13` enum('0','1') NOT NULL
DEFAULT '0', `game14` enum('0','1') NOT NULL DEFAULT '0', `imlove`
varchar(256) DEFAULT NULL, `ilove` set('0','1') NOT NULL DEFAULT '0',
`ank_enterf` set('1','2','3') DEFAULT '1', `kol_blog` int(11) NOT NULL
DEFAULT '0', `komm_blog` int(11) NOT NULL DEFAULT '0', `time` int(11)
NOT NULL, `perehodu` int(11) NOT NULL, `dei_pn` int(11) NOT NULL
DEFAULT '0', `dei_ob` int(11) NOT NULL DEFAULT '0', `dei_ruk` int(11)
NOT NULL DEFAULT '0', `dei_cel` int(11) NOT NULL DEFAULT '0', `dei_gn`
int(11) NOT NULL DEFAULT '0', `dei_wink` int(11) NOT NULL DEFAULT '0',
`dei_kruzhki` int(11) NOT NULL DEFAULT '0', `dei_disko` int(11) NOT NULL
DEFAULT '0', `dei_inlove` int(11) NOT NULL DEFAULT '0', `dei_vzasos`
int(11) NOT NULL DEFAULT '0', `dei_zhopa` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`), UNIQUE KEY `nick` (`nick`), KEY `url` (`url`),
KEY `set_them` (`set_them`,`set_them2`), KEY `set_them_2`
(`set_them`,`set_them2`), KEY `set_them_3` (`set_them`,`set_them2`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
Онлайн: 4
Реклама