 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `bucket` (
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
-  `id_user` bigint(20) NOT NULL,
-  `type` varchar(45) NOT NULL,
-  `content` int(11) NOT NULL DEFAULT '-1',
-  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  `id_user` bigint(20) DEFAULT NULL,
+  `type` varchar(200) DEFAULT NULL,
+  `content` int(11) DEFAULT NULL,
+  `timestamp` datetime DEFAULT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `user_type_unique` (`id_user`,`type`),
-  KEY `bucket_user_idx` (`id_user`),
-  CONSTRAINT `bucket_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
+  CONSTRAINT `bucket_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `confirmtoken`
 --
 
-DROP TABLE IF EXISTS `confirmtoken`;
+
+DROP TABLE IF EXISTS `confirm_token`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `confirmtoken` (
+CREATE TABLE `confirm_token` (
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
-  `id_user` bigint(20) NOT NULL,
-  `validity` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `token` varchar(255) NOT NULL,
+  `id_user` bigint(20) DEFAULT NULL,
+  `validity` datetime DEFAULT NULL,
+  `token` varchar(200) DEFAULT NULL,
   PRIMARY KEY (`id`),
-  UNIQUE KEY `id_user_unique` (`id_user`),
-  KEY `confirmtoken_user_idx` (`id_user`),
-  CONSTRAINT `confirmtoken_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
+  UNIQUE KEY `id_user` (`id_user`),
+  UNIQUE KEY `token` (`token`),
+  CONSTRAINT `confirm_token_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `resettoken`
 --
 
-DROP TABLE IF EXISTS `resettoken`;
+DROP TABLE IF EXISTS `reset_token`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `resettoken` (
+CREATE TABLE `reset_token` (
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
-  `id_user` bigint(20) NOT NULL,
-  `validity` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `token` varchar(255) NOT NULL,
+  `id_user` bigint(20) DEFAULT NULL,
+  `validity` datetime DEFAULT NULL,
+  `token` varchar(200) DEFAULT NULL,
   PRIMARY KEY (`id`),
-  UNIQUE KEY `id_user_unique` (`id_user`),
-  KEY `resettoken_user_idx` (`id_user`),
-  CONSTRAINT `resettoken_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
+  UNIQUE KEY `id_user` (`id_user`),
+  UNIQUE KEY `token` (`token`),
+  CONSTRAINT `reset_token_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bucket`
--


/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `email` varchar(250) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `salt` varchar(50) DEFAULT NULL,
  `auth_source` varchar(250) DEFAULT NULL,
  `locale` varchar(50) DEFAULT NULL,
  `blocked` tinyint(1) DEFAULT NULL,
  `confirmed` tinyint(1) DEFAULT NULL,
  `screen_name` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

