Файл: 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 ;