· 7 years ago · Jan 16, 2019, 07:24 PM
1-- MySQL dump 10.13 Distrib 8.0.12, for osx10.13 (x86_64)
2--
3-- Host: 127.0.0.1 Database: eindhoven-api
4-- ------------------------------------------------------
5-- Server version 8.0.12
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 SET NAMES utf8mb4 ;
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 `message`
20--
21
22DROP TABLE IF EXISTS `message`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24 SET character_set_client = utf8mb4 ;
25CREATE TABLE `message` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `content` text NOT NULL,
28 `created_at` datetime NOT NULL,
29 `senderId` int(11) DEFAULT NULL,
30 `receiverId` int(11) DEFAULT NULL,
31 PRIMARY KEY (`id`),
32 KEY `FK_bc096b4e18b1f9508197cd98066` (`senderId`),
33 KEY `FK_71fb36906595c602056d936fc13` (`receiverId`),
34 CONSTRAINT `FK_71fb36906595c602056d936fc13` FOREIGN KEY (`receiverId`) REFERENCES `user` (`id`),
35 CONSTRAINT `FK_bc096b4e18b1f9508197cd98066` FOREIGN KEY (`senderId`) REFERENCES `user` (`id`)
36) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `message`
41--
42
43LOCK TABLES `message` WRITE;
44/*!40000 ALTER TABLE `message` DISABLE KEYS */;
45INSERT INTO `message` (`id`, `content`, `created_at`, `senderId`, `receiverId`) VALUES (1,'jemoeder','2019-01-05 20:01:28',1,1);
46/*!40000 ALTER TABLE `message` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `question`
51--
52
53DROP TABLE IF EXISTS `question`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55 SET character_set_client = utf8mb4 ;
56CREATE TABLE `question` (
57 `id` int(11) NOT NULL AUTO_INCREMENT,
58 `question` text NOT NULL,
59 `userId` int(11) DEFAULT NULL,
60 `status` varchar(255) NOT NULL,
61 `created_at` datetime NOT NULL,
62 `priority` varchar(255) NOT NULL,
63 PRIMARY KEY (`id`),
64 KEY `FK_80f29cc01d0bd1644e389cc13be` (`userId`),
65 CONSTRAINT `FK_80f29cc01d0bd1644e389cc13be` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
66) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `question`
71--
72
73LOCK TABLES `question` WRITE;
74/*!40000 ALTER TABLE `question` DISABLE KEYS */;
75INSERT INTO `question` (`id`, `question`, `userId`, `status`, `created_at`, `priority`) VALUES (138,'hallo',2,'Wordt geholpen','2019-01-10 10:54:35','hallo'),(139,'Kan iemand boodschappen voor me doen?',2,'WACHT OP HULPBEHOEVENDE','2019-01-10 12:51:48','sterk om mijn boodschappen te dragen hihihihiihihihihihihihihi'),(140,'adsfdsafsda',1,'CREATED','2019-01-16 18:46:32','sadfasdf'),(141,'sadfdasfasd',1,'CREATED','2019-01-16 19:38:56','fsdafsda');
76/*!40000 ALTER TABLE `question` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `question_helper`
81--
82
83DROP TABLE IF EXISTS `question_helper`;
84/*!40101 SET @saved_cs_client = @@character_set_client */;
85 SET character_set_client = utf8mb4 ;
86CREATE TABLE `question_helper` (
87 `id` int(11) NOT NULL AUTO_INCREMENT,
88 `helperId` int(11) DEFAULT NULL,
89 `questionId` int(11) DEFAULT NULL,
90 `accepted` tinyint(4) NOT NULL,
91 PRIMARY KEY (`id`),
92 KEY `FK_55357d7491d897b03f875423fe4` (`helperId`),
93 KEY `FK_cd204598565354815bc34401d4f` (`questionId`),
94 CONSTRAINT `FK_55357d7491d897b03f875423fe4` FOREIGN KEY (`helperId`) REFERENCES `user` (`id`),
95 CONSTRAINT `FK_cd204598565354815bc34401d4f` FOREIGN KEY (`questionId`) REFERENCES `question` (`id`)
96) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
97/*!40101 SET character_set_client = @saved_cs_client */;
98
99--
100-- Dumping data for table `question_helper`
101--
102
103LOCK TABLES `question_helper` WRITE;
104/*!40000 ALTER TABLE `question_helper` DISABLE KEYS */;
105INSERT INTO `question_helper` (`id`, `helperId`, `questionId`, `accepted`) VALUES (1,2,141,0),(2,3,141,1);
106/*!40000 ALTER TABLE `question_helper` ENABLE KEYS */;
107UNLOCK TABLES;
108
109--
110-- Table structure for table `question_reply`
111--
112
113DROP TABLE IF EXISTS `question_reply`;
114/*!40101 SET @saved_cs_client = @@character_set_client */;
115 SET character_set_client = utf8mb4 ;
116CREATE TABLE `question_reply` (
117 `id` int(11) NOT NULL AUTO_INCREMENT,
118 `replyText` text NOT NULL,
119 `date` datetime NOT NULL,
120 `userId` int(11) DEFAULT NULL,
121 `questionId` int(11) DEFAULT NULL,
122 PRIMARY KEY (`id`),
123 KEY `FK_ae9a2c365d7bc9db295c31f8610` (`userId`),
124 KEY `FK_a7d765ccd50c970b362c50ca4d4` (`questionId`),
125 CONSTRAINT `FK_a7d765ccd50c970b362c50ca4d4` FOREIGN KEY (`questionId`) REFERENCES `question` (`id`),
126 CONSTRAINT `FK_ae9a2c365d7bc9db295c31f8610` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
127) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8;
128/*!40101 SET character_set_client = @saved_cs_client */;
129
130--
131-- Dumping data for table `question_reply`
132--
133
134LOCK TABLES `question_reply` WRITE;
135/*!40000 ALTER TABLE `question_reply` DISABLE KEYS */;
136INSERT INTO `question_reply` (`id`, `replyText`, `date`, `userId`, `questionId`) VALUES (99,'hallo','2019-01-10 12:44:51',3,138),(100,'hallo2','2019-01-10 12:45:51',2,138),(101,'Mag ik het doen hihihi','2019-01-10 12:52:01',2,139),(102,'asdfsdaf','2019-01-15 16:40:07',3,139),(103,' sadfsadf','2019-01-15 16:40:09',3,139),(104,'sadfadsf ','2019-01-15 16:40:12',3,141),(105,'hallo','2019-01-16 18:46:55',1,138),(106,'eee','2019-01-16 19:53:36',1,141),(107,' eee','2019-01-16 19:53:38',1,141),(108,' ','2019-01-16 19:53:39',1,141),(109,' qewrqwr','2019-01-16 19:53:40',1,141),(110,'ee','2019-01-16 19:53:56',1,141),(111,' fff','2019-01-16 19:53:58',1,141),(112,' ewrrq','2019-01-16 19:54:01',1,141),(113,' e','2019-01-16 19:54:22',1,141),(114,' wee','2019-01-16 19:54:26',1,141),(115,' eweqrqkwk','2019-01-16 19:54:28',1,141);
137/*!40000 ALTER TABLE `question_reply` ENABLE KEYS */;
138UNLOCK TABLES;
139
140--
141-- Table structure for table `question_skill`
142--
143
144DROP TABLE IF EXISTS `question_skill`;
145/*!40101 SET @saved_cs_client = @@character_set_client */;
146 SET character_set_client = utf8mb4 ;
147CREATE TABLE `question_skill` (
148 `questionId` int(11) NOT NULL,
149 `skillId` int(11) NOT NULL,
150 PRIMARY KEY (`questionId`,`skillId`),
151 KEY `FK_5880ce540ee0714ffd2c1aa546a` (`skillId`),
152 CONSTRAINT `FK_5880ce540ee0714ffd2c1aa546a` FOREIGN KEY (`skillId`) REFERENCES `skill` (`id`),
153 CONSTRAINT `FK_59388d433cc8f5b5b0ed4c04582` FOREIGN KEY (`questionId`) REFERENCES `question` (`id`)
154) ENGINE=InnoDB DEFAULT CHARSET=utf8;
155/*!40101 SET character_set_client = @saved_cs_client */;
156
157--
158-- Dumping data for table `question_skill`
159--
160
161LOCK TABLES `question_skill` WRITE;
162/*!40000 ALTER TABLE `question_skill` DISABLE KEYS */;
163INSERT INTO `question_skill` (`questionId`, `skillId`) VALUES (138,96),(139,97),(139,98),(140,99),(141,100);
164/*!40000 ALTER TABLE `question_skill` ENABLE KEYS */;
165UNLOCK TABLES;
166
167--
168-- Table structure for table `role`
169--
170
171DROP TABLE IF EXISTS `role`;
172/*!40101 SET @saved_cs_client = @@character_set_client */;
173 SET character_set_client = utf8mb4 ;
174CREATE TABLE `role` (
175 `id` int(11) NOT NULL AUTO_INCREMENT,
176 `rolename` varchar(255) NOT NULL,
177 PRIMARY KEY (`id`)
178) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
179/*!40101 SET character_set_client = @saved_cs_client */;
180
181--
182-- Dumping data for table `role`
183--
184
185LOCK TABLES `role` WRITE;
186/*!40000 ALTER TABLE `role` DISABLE KEYS */;
187INSERT INTO `role` (`id`, `rolename`) VALUES (1,'Caretaker'),(2,'Caregiver'),(3,'Admin');
188/*!40000 ALTER TABLE `role` ENABLE KEYS */;
189UNLOCK TABLES;
190
191--
192-- Table structure for table `skill`
193--
194
195DROP TABLE IF EXISTS `skill`;
196/*!40101 SET @saved_cs_client = @@character_set_client */;
197 SET character_set_client = utf8mb4 ;
198CREATE TABLE `skill` (
199 `id` int(11) NOT NULL AUTO_INCREMENT,
200 `skill` varchar(255) NOT NULL,
201 `userId` int(11) DEFAULT NULL,
202 PRIMARY KEY (`id`),
203 UNIQUE KEY `IDX_d5ee9b00fdfc9828c76ef120be` (`skill`),
204 KEY `FK_c08612011a88745a32784544b28` (`userId`),
205 CONSTRAINT `FK_c08612011a88745a32784544b28` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
206) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
207/*!40101 SET character_set_client = @saved_cs_client */;
208
209--
210-- Dumping data for table `skill`
211--
212
213LOCK TABLES `skill` WRITE;
214/*!40000 ALTER TABLE `skill` DISABLE KEYS */;
215INSERT INTO `skill` (`id`, `skill`, `userId`) VALUES (21,'safsadfsafsadfsafsadf',NULL),(23,'eee',NULL),(25,'afdsfdasf',NULL),(53,'ree',NULL),(56,'reeeef',NULL),(57,'reeefa',NULL),(61,'await Question.save(question);',NULL),(68,'test',NULL),(69,'ayy',NULL),(74,'lief',NULL),(75,'e',NULL),(82,'ekekewkjeew',NULL),(83,'ekekekeke',NULL),(84,'a',NULL),(85,'fabs',NULL),(86,'met de auto',NULL),(87,'typen',NULL),(88,'aaa',NULL),(89,'baaaaaab',NULL),(90,'homo',NULL),(96,'reee',NULL),(97,'flexibel',NULL),(98,'sterk',NULL),(99,'qwerqwe',NULL),(100,'asdfsad',NULL);
216/*!40000 ALTER TABLE `skill` ENABLE KEYS */;
217UNLOCK TABLES;
218
219--
220-- Table structure for table `user`
221--
222
223DROP TABLE IF EXISTS `user`;
224/*!40101 SET @saved_cs_client = @@character_set_client */;
225 SET character_set_client = utf8mb4 ;
226CREATE TABLE `user` (
227 `id` int(11) NOT NULL AUTO_INCREMENT,
228 `email` varchar(255) NOT NULL,
229 `password` varchar(255) NOT NULL,
230 `account_status` varchar(255) NOT NULL,
231 `coc_url` varchar(255) NOT NULL,
232 `passport_photograph` varchar(255) NOT NULL,
233 `roleId` int(11) DEFAULT NULL,
234 PRIMARY KEY (`id`),
235 KEY `FK_c28e52f758e7bbc53828db92194` (`roleId`),
236 CONSTRAINT `FK_c28e52f758e7bbc53828db92194` FOREIGN KEY (`roleId`) REFERENCES `role` (`id`)
237) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
238/*!40101 SET character_set_client = @saved_cs_client */;
239
240--
241-- Dumping data for table `user`
242--
243
244LOCK TABLES `user` WRITE;
245/*!40000 ALTER TABLE `user` DISABLE KEYS */;
246INSERT INTO `user` (`id`, `email`, `password`, `account_status`, `coc_url`, `passport_photograph`, `roleId`) VALUES (1,'ayylmao@admin.com','$2b$12$lvLVNUDGNBkCYbvK14B8b.OVwpFvRcb87An6Y5.3KFgPBNi35VhDm','Active','4bb9bfbb-c202-4a2a-b01c-6e9bfc1ca8d8','debug',3),(2,'ayylmao@caretaker.com','$2b$12$6a4JLIxjqK6uSwHbrPsooed3X/lXloDEUyoCveXESvVE1KMxjOVMm','Active','ebbff7a6-27ca-4ada-b74a-a51dfb9b12cf','geen',1),(3,'ayylmao@caregiver.com','$2b$12$lvLVNUDGNBkCYbvK14B8b.OVwpFvRcb87An6Y5.3KFgPBNi35VhDm','Active','81dbad89-8229-42ab-ac65-8602ed3808ef','debug',2);
247/*!40000 ALTER TABLE `user` ENABLE KEYS */;
248UNLOCK TABLES;
249/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
250
251/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
252/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
253/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
254/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
255/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
256/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
257/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
258
259-- Dump completed on 2019-01-16 20:21:21