Sviesta Ciba |

iedarbīgas zāles (
bez4pieci) rakstīja,
CREATE TABLE `obj11_users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nick` varchar(20) NOT NULL default '',
  `pass` varchar(32) default NULL,
  `name` varchar(50) default NULL,
  `surname` varchar(50) default NULL,
  `info` text,
  `title_id` tinyint(1) unsigned default NULL,
  `email` varchar(50) default NULL,
  `arh_sert_num` varchar(10) default NULL,
  `show_name` enum('0','1') NOT NULL default '0',
  `send_comments` enum('0','1') NOT NULL default '0',
  `blog_motivation` text,
  `blog_info` text,
  `allow_blog` enum('0','1') NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_access` datetime default NULL,
  `last_ip_id` int(10) unsigned default NULL,
  `logged_in` enum('0','1') NOT NULL default '0',
  `must_change_pass` enum('0','1') NOT NULL default '0',
  `pass_change_hash` varchar(32) default NULL,
  `disabled` enum('1','0') NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `nick` (`nick`),
  KEY `pass_change_hash` (`pass_change_hash`)
) TYPE=MyISAM AUTO_INCREMENT=371 ;
(Lasīt komentārus)
Nopūsties:
Navigate:
