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