'users', 'CREATE TABLE `users` (
`index` int(8) unsigned NOT NULL auto_increment,
`fullname` varchar(60) character set latin1 NOT NULL default '',
`plant` smallint(4) unsigned default '451',
`position` varchar(60) character set latin1 default NULL,
`phone` varchar(60) character set latin1 default NULL,
`email` varchar(60) character set latin1 NOT NULL default '',
`username` varchar(20) character set latin1 NOT NULL default '',
`passwd` varchar(20) character set latin1 NOT NULL default '',
`can_edit` tinyint(1) unsigned NOT NULL default '0',
`logon` datetime NOT NULL default '0000-00-00 00:00:00',
`status` tinyint(1) default '0',
`tech` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`index`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8'
Partager