DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` int NOT NULL DEFAULT '2',
  `email` varchar(50) NOT NULL UNIQUE,
  `password` char(64) NOT NULL,
  `name` varchar(50) NOT NULL,
  `username` varchar(50) NOT NULL UNIQUE,
  `location` varchar(200) NOT NULL,
  `bio` varchar(200) NOT NULL,
  `phone_number` char(11) DEFAULT NULL,
  `picture` varchar(100) DEFAULT NULL,
  `confirmation_token` char(64) DEFAULT NULL,
  `password_reset_token` char(64) DEFAULT NULL,
  `archived` boolean NOT NULL,
  PRIMARY KEY (`id`)
);