text: 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;
  