-# CREATE users TABLE
-#####################################
-DROP TABLE IF EXISTS `users`;
-CREATE TABLE `users` (
- `id` int(11) NOT NULL auto_increment,
- `login` varchar(80) NOT NULL default '',
- `salted_password` varchar(40) NOT NULL default '',
- `email` varchar(60) NOT NULL default '',
- `firstname` varchar(40) default NULL,
- `lastname` varchar(40) default NULL,
- `salt` varchar(40) NOT NULL default '',
- `verified` int(11) default '0',
- `role` varchar(40) default NULL,
- `security_token` varchar(40) default NULL,
- `token_expiry` datetime default NULL,
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- `logged_in_at` datetime default NULL,
- `deleted` int(11) default '0',
- `delete_after` datetime default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;