CREATE TABLE umm_users user_id int 11 NOT NULL auto_increment group_id

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
CREATE TABLE `umm_users` (
`user_id` int(11) NOT NULL auto_increment,
`group_id` int(11) NOT NULL,
`name` char(255) default NULL,
`login` char(255) default NULL,
`password` char(32) default NULL,
`email` char(255) default NULL,
`inst_id` int(11) NOT NULL,
`last_login` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`phone` char(255) default NULL,
`post` char(255) default NULL,
`sub_group_id` int(11) NOT NULL,
`deleted` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Таблица с пользователями';