· 8 years ago · Jun 02, 2018, 01:54 PM
1DROP TABLE IF EXISTS `dietzeEnterprise`.`dtz_management_users`;
2CREATE TABLE `dietzeEnterprise`.`dtz_management_users` (
3 `id` int(10) NOT NULL auto_increment,
4 `user_alias` varchar(200) NOT NULL,
5 `user_passphrase` text NOT NULL,
6 `user_email` varchar(255) default NULL,
7 `user_role` tinyint(4) NOT NULL,
8 `timestamp` int(15) NOT NULL,
9 `removed` tinyint(1) default '0',
10 `last_login` int(15) default '0',
11 `reset_passphrase` tinyint(1) default '0',
12 PRIMARY KEY (`id`)
13) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;