· 7 years ago · Dec 25, 2018, 06:58 AM
1-- MySQL dump 10.13 Distrib 5.7.23, for Linux (x86_64)
2--
3-- Host: 192.168.10.10 Database: fastifyjs
4-- ------------------------------------------------------
5-- Server version 5.7.22-0ubuntu18.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `authentication`
20--
21
22DROP TABLE IF EXISTS `authentication`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `authentication` (
26 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
27 `user_id` int(10) unsigned NOT NULL,
28 `secret_id` int(10) unsigned NOT NULL,
29 `expires_at` datetime NOT NULL,
30 `created_at` timestamp NULL DEFAULT NULL,
31 `updated_at` timestamp NULL DEFAULT NULL,
32 UNIQUE KEY `authentication_id_unique` (`id`),
33 KEY `authentication_secret_id_foreign` (`secret_id`),
34 KEY `authentication_user_id_foreign` (`user_id`),
35 CONSTRAINT `authentication_secret_id_foreign` FOREIGN KEY (`secret_id`) REFERENCES `secret` (`id`),
36 CONSTRAINT `authentication_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `authentication`
42--
43
44LOCK TABLES `authentication` WRITE;
45/*!40000 ALTER TABLE `authentication` DISABLE KEYS */;
46/*!40000 ALTER TABLE `authentication` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `migrations`
51--
52
53DROP TABLE IF EXISTS `migrations`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `migrations` (
57 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
58 `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
59 `batch` int(11) NOT NULL,
60 PRIMARY KEY (`id`)
61) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `migrations`
66--
67
68LOCK TABLES `migrations` WRITE;
69/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
70INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2018_12_25_033250_secret_table',1),(3,'2018_12_25_033443_auth_table',1),(4,'2018_12_25_033848_todo_table',1);
71/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `secret`
76--
77
78DROP TABLE IF EXISTS `secret`;
79/*!40101 SET @saved_cs_client = @@character_set_client */;
80/*!40101 SET character_set_client = utf8 */;
81CREATE TABLE `secret` (
82 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
83 `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
84 `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
85 `permission` json NOT NULL,
86 `created_at` timestamp NULL DEFAULT NULL,
87 `updated_at` timestamp NULL DEFAULT NULL,
88 PRIMARY KEY (`id`),
89 UNIQUE KEY `secret_secret_unique` (`secret`)
90) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `secret`
95--
96
97LOCK TABLES `secret` WRITE;
98/*!40000 ALTER TABLE `secret` DISABLE KEYS */;
99INSERT INTO `secret` VALUES (1,'7f46165474d11ee5836777d85df2cdab','Mobile Secret Key','{}','2018-12-25 13:00:10','2018-12-25 13:00:10'),(2,'3d4fe7a00bc6fb52a91685d038733d6f','Web Secret Key','{}','2018-12-25 13:00:50','2018-12-25 13:00:50');
100/*!40000 ALTER TABLE `secret` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `todo`
105--
106
107DROP TABLE IF EXISTS `todo`;
108/*!40101 SET @saved_cs_client = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `todo` (
111 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
112 `user_id` int(10) unsigned NOT NULL,
113 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
114 `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
115 `created_at` timestamp NULL DEFAULT NULL,
116 `updated_at` timestamp NULL DEFAULT NULL,
117 PRIMARY KEY (`id`),
118 KEY `todo_user_id_foreign` (`user_id`),
119 CONSTRAINT `todo_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
120) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
121/*!40101 SET character_set_client = @saved_cs_client */;
122
123--
124-- Dumping data for table `todo`
125--
126
127LOCK TABLES `todo` WRITE;
128/*!40000 ALTER TABLE `todo` DISABLE KEYS */;
129/*!40000 ALTER TABLE `todo` ENABLE KEYS */;
130UNLOCK TABLES;
131
132--
133-- Table structure for table `users`
134--
135
136DROP TABLE IF EXISTS `users`;
137/*!40101 SET @saved_cs_client = @@character_set_client */;
138/*!40101 SET character_set_client = utf8 */;
139CREATE TABLE `users` (
140 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
141 `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
142 `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
143 `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
144 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
145 `created_at` timestamp NULL DEFAULT NULL,
146 `updated_at` timestamp NULL DEFAULT NULL,
147 PRIMARY KEY (`id`),
148 UNIQUE KEY `users_email_unique` (`email`)
149) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
150/*!40101 SET character_set_client = @saved_cs_client */;
151
152--
153-- Dumping data for table `users`
154--
155
156LOCK TABLES `users` WRITE;
157/*!40000 ALTER TABLE `users` DISABLE KEYS */;
158INSERT INTO `users` VALUES (1,'Kiddy','kiddy@gmail.com','9d6fd5b8694b6d3ca3067c562098a7242098c3f8','e9b0bb468f8131294b3be49291a4d35c0636f6993abd773a95ca49cfe886af09','2018-12-25 13:40:24','2018-12-25 13:40:24'),(3,'Kiddy','kiddydhana@gmail.com','9d6fd5b8694b6d3ca3067c562098a7242098c3f8','f5772f8fc91c8fab7088062ee1eb1ead0bbdd70c12207b26ed94679297a1316c','2018-12-25 13:41:39','2018-12-25 13:41:39');
159/*!40000 ALTER TABLE `users` ENABLE KEYS */;
160UNLOCK TABLES;
161
162--
163-- Dumping events for database 'fastifyjs'
164--
165
166--
167-- Dumping routines for database 'fastifyjs'
168--
169/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
170
171/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
172/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
173/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
174/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
175/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
176/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
177/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
178
179-- Dump completed on 2018-12-25 13:49:21