DROP TABLE IF EXISTS `groups`;

CREATE TABLE `groups` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(200) NOT NULL,

`level` int(11) NOT NULL,

`is_admin` tinyint(1) NOT NULL,

`parent` int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(50) NOT NULL,

`email` varchar(50) NOT NULL,

`password` varchar(81) NOT NULL,

`password_reset_hash` varchar(81) NOT NULL,

`temp_password` varchar(81) NOT NULL,

`remember_me` varchar(81) NOT NULL,

`activation_hash` varchar(81) NOT NULL,

`last_login` int(11) NOT NULL,

`ip_address` varchar(50) NOT NULL,

`updated_at` int(11) NOT NULL,

`created_at` int(11) NOT NULL,

`status` tinyint(1) NOT NULL,

`activated` tinyint(4) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `users_groups`;

CREATE TABLE `users_groups` (

`user_id` int(11) NOT NULL,

`group_id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `users_metadata`;

CREATE TABLE `users_metadata` (

`user_id` int(11) NOT NULL,

`first_name` varchar(50) NOT NULL,

`last_name` varchar(50) NOT NULL,

PRIMARY KEY (`user_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `users_suspended`;

CREATE TABLE `users_suspended` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`login_id` varchar(50) NOT NULL,

`attempts` int(50) NOT NULL,

`ip` varchar(25) NOT NULL,

`last_attempt_at` int(11) NOT NULL,

`suspended_at` int(11) NOT NULL,

`unsuspend_at` int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;