· 5 years ago · May 15, 2020, 10:48 AM
1DROP TABLE IF EXISTS `users`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!50503 SET character_set_client = utf8mb4 */;
4CREATE TABLE `users` (
5 `id` int NOT NULL AUTO_INCREMENT,
6 `email` varchar(255) NOT NULL DEFAULT '',
7 `encrypted_password` varchar(255) NOT NULL DEFAULT '',
8 `reset_password_token` varchar(255) DEFAULT NULL,
9 `reset_password_sent_at` datetime DEFAULT NULL,
10 `remember_created_at` datetime DEFAULT NULL,
11 `sign_in_count` int NOT NULL DEFAULT '0',
12 `current_sign_in_at` datetime DEFAULT NULL,
13 `last_sign_in_at` datetime DEFAULT NULL,
14 `current_sign_in_ip` varchar(255) DEFAULT NULL,
15 `last_sign_in_ip` varchar(255) DEFAULT NULL,
16 `created_at` datetime NOT NULL,
17 `updated_at` datetime NOT NULL,
18 `username` varchar(255) DEFAULT NULL,
19 `auth_state` varchar(255) DEFAULT NULL,
20 PRIMARY KEY (`id`),
21 UNIQUE KEY `index_users_on_email` (`email`),
22 UNIQUE KEY `index_users_on_reset_password_token` (`reset_password_token`)
23) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
24/*!40101 SET character_set_client = @saved_cs_client */;
25
26--
27-- Dumping data for table `users`
28--
29
30LOCK TABLES `users` WRITE;
31/*!40000 ALTER TABLE `users` DISABLE KEYS */;
32INSERT INTO `users` VALUES (2,'doublebeep7@gmail.com','$2a$11$IXk7nmr2h.nv8.7dFdiP..YktEdwkIReFuShkLYjssS2C53c8r62i',NULL,NULL,NULL,1,'2020-05-15 10:27:17','2020-05-15 10:27:17','127.0.0.1','127.0.0.1','2020-05-15 10:27:17','2020-05-15 10:27:17','double-beep',NULL);
33/*!40000 ALTER TABLE `users` ENABLE KEYS */;
34UNLOCK TABLES;