66qMVj0X

1-- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
2--
3-- Host: localhost    Database: interview_1212
4-- ------------------------------------------------------
5-- Server version	5.7.22
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 `Admin`
20--
21
22DROP TABLE IF EXISTS `Admin`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `Admin` (
26  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
27  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
28  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `Admin`
35--
36
37LOCK TABLES `Admin` WRITE;
38/*!40000 ALTER TABLE `Admin` DISABLE KEYS */;
39INSERT INTO `Admin` VALUES (18,'test@test.com','$2b$10$/wKGfC4A8bFC7poLolaoCewF1PVCuAUJbMmH0ct1/bv10PtXlw9WW');
40/*!40000 ALTER TABLE `Admin` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `Member`
45--
46
47DROP TABLE IF EXISTS `Member`;
48/*!40101 SET @saved_cs_client     = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `Member` (
51  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
52  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
53  `gender` enum('female','male','others') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
54  `birthday` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
55  PRIMARY KEY (`id`)
56) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
57/*!40101 SET character_set_client = @saved_cs_client */;
58
59--
60-- Dumping data for table `Member`
61--
62
63LOCK TABLES `Member` WRITE;
64/*!40000 ALTER TABLE `Member` DISABLE KEYS */;
65INSERT INTO `Member` VALUES (2,'name5','others','2000-10-10T00:00:00.000Z'),(3,'name2','male','2000-01-01T00:00:00.000Z'),(4,'name3','others','2000-01-01T00:00:00.000Z'),(5,'name4AA','female','2000-01-21T00:00:00.000Z');
66/*!40000 ALTER TABLE `Member` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `knex_migrations`
71--
72
73DROP TABLE IF EXISTS `knex_migrations`;
74/*!40101 SET @saved_cs_client     = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `knex_migrations` (
77  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
78  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
79  `batch` int(11) DEFAULT NULL,
80  `migration_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
81  PRIMARY KEY (`id`)
82) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Dumping data for table `knex_migrations`
87--
88
89LOCK TABLES `knex_migrations` WRITE;
90/*!40000 ALTER TABLE `knex_migrations` DISABLE KEYS */;
91INSERT INTO `knex_migrations` VALUES (1,'20181213175712_create_Member.js',1,'2018-12-13 11:22:23'),(2,'20181213222827_alter_Member.js',2,'2018-12-13 14:31:41'),(3,'20181214030005_creat_admin.js',3,'2018-12-13 19:01:59');
92/*!40000 ALTER TABLE `knex_migrations` ENABLE KEYS */;
93UNLOCK TABLES;
94
95--
96-- Table structure for table `knex_migrations_lock`
97--
98
99DROP TABLE IF EXISTS `knex_migrations_lock`;
100/*!40101 SET @saved_cs_client     = @@character_set_client */;
101/*!40101 SET character_set_client = utf8 */;
102CREATE TABLE `knex_migrations_lock` (
103  `index` int(10) unsigned NOT NULL AUTO_INCREMENT,
104  `is_locked` int(11) DEFAULT NULL,
105  PRIMARY KEY (`index`)
106) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
107/*!40101 SET character_set_client = @saved_cs_client */;
108
109--
110-- Dumping data for table `knex_migrations_lock`
111--
112
113LOCK TABLES `knex_migrations_lock` WRITE;
114/*!40000 ALTER TABLE `knex_migrations_lock` DISABLE KEYS */;
115INSERT INTO `knex_migrations_lock` VALUES (1,0);
116/*!40000 ALTER TABLE `knex_migrations_lock` ENABLE KEYS */;
117UNLOCK TABLES;
118/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
119
120/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
121/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
122/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
123/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
124/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
125/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
126/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
127
128-- Dump completed on 2018-12-17 14:51:28