Просмотр архива Эро-соцка

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 '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 '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',
  `mycity` int(6) NOT NULL,
  `ank_modeltelefona` varchar(20) DEFAULT
NULL,
  `ank_operator` varchar(20) DEFAULT NULL,
  `ank_xobbi` varchar(512)
DEFAULT NULL,
  `ank_sait` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`),

 UNIQUE KEY `nick` (`nick`),
  KEY `url` (`url`),
  KEY `set_them`
(`set_them`,`set_them2`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;