Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.13 Distrib 8.0.12, for osx10.13 (x86_64)
- --
- -- Host: 127.0.0.1 Database: eindhoven-api
- -- ------------------------------------------------------
- -- Server version 8.0.12
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- SET NAMES utf8mb4 ;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `message`
- --
- DROP TABLE IF EXISTS `message`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
- CREATE TABLE `message` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `content` text NOT NULL,
- `created_at` datetime NOT NULL,
- `senderId` int(11) DEFAULT NULL,
- `receiverId` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FK_bc096b4e18b1f9508197cd98066` (`senderId`),
- KEY `FK_71fb36906595c602056d936fc13` (`receiverId`),
- CONSTRAINT `FK_71fb36906595c602056d936fc13` FOREIGN KEY (`receiverId`) REFERENCES `user` (`id`),
- CONSTRAINT `FK_bc096b4e18b1f9508197cd98066` FOREIGN KEY (`senderId`) REFERENCES `user` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `message`
- --
- LOCK TABLES `message` WRITE;
- /*!40000 ALTER TABLE `message` DISABLE KEYS */;
- INSERT INTO `message` (`id`, `content`, `created_at`, `senderId`, `receiverId`) VALUES (1,'jemoeder','2019-01-05 20:01:28',1,1);
- /*!40000 ALTER TABLE `message` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `question`
- --
- DROP TABLE IF EXISTS `question`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
- CREATE TABLE `question` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `question` text NOT NULL,
- `userId` int(11) DEFAULT NULL,
- `status` varchar(255) NOT NULL,
- `created_at` datetime NOT NULL,
- `priority` varchar(255) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK_80f29cc01d0bd1644e389cc13be` (`userId`),
- CONSTRAINT `FK_80f29cc01d0bd1644e389cc13be` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `question`
- --
- LOCK TABLES `question` WRITE;
- /*!40000 ALTER TABLE `question` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `question` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `question_helper`
- --
- DROP TABLE IF EXISTS `question_helper`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
- CREATE TABLE `question_helper` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `helperId` int(11) DEFAULT NULL,
- `questionId` int(11) DEFAULT NULL,
- `accepted` tinyint(4) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK_55357d7491d897b03f875423fe4` (`helperId`),
- KEY `FK_cd204598565354815bc34401d4f` (`questionId`),
- CONSTRAINT `FK_55357d7491d897b03f875423fe4` FOREIGN KEY (`helperId`) REFERENCES `user` (`id`),
- CONSTRAINT `FK_cd204598565354815bc34401d4f` FOREIGN KEY (`questionId`) REFERENCES `question` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `question_helper`
- --
- LOCK TABLES `question_helper` WRITE;
- /*!40000 ALTER TABLE `question_helper` DISABLE KEYS */;
- INSERT INTO `question_helper` (`id`, `helperId`, `questionId`, `accepted`) VALUES (1,2,141,0),(2,3,141,1);
- /*!40000 ALTER TABLE `question_helper` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `question_reply`
- --
- DROP TABLE IF EXISTS `question_reply`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
- CREATE TABLE `question_reply` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `replyText` text NOT NULL,
- `date` datetime NOT NULL,
- `userId` int(11) DEFAULT NULL,
- `questionId` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FK_ae9a2c365d7bc9db295c31f8610` (`userId`),
- KEY `FK_a7d765ccd50c970b362c50ca4d4` (`questionId`),
- CONSTRAINT `FK_a7d765ccd50c970b362c50ca4d4` FOREIGN KEY (`questionId`) REFERENCES `question` (`id`),
- CONSTRAINT `FK_ae9a2c365d7bc9db295c31f8610` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `question_reply`
- --
- LOCK TABLES `question_reply` WRITE;
- /*!40000 ALTER TABLE `question_reply` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `question_reply` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `question_skill`
- --
- DROP TABLE IF EXISTS `question_skill`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
- CREATE TABLE `question_skill` (
- `questionId` int(11) NOT NULL,
- `skillId` int(11) NOT NULL,
- PRIMARY KEY (`questionId`,`skillId`),
- KEY `FK_5880ce540ee0714ffd2c1aa546a` (`skillId`),
- CONSTRAINT `FK_5880ce540ee0714ffd2c1aa546a` FOREIGN KEY (`skillId`) REFERENCES `skill` (`id`),
- CONSTRAINT `FK_59388d433cc8f5b5b0ed4c04582` FOREIGN KEY (`questionId`) REFERENCES `question` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `question_skill`
- --
- LOCK TABLES `question_skill` WRITE;
- /*!40000 ALTER TABLE `question_skill` DISABLE KEYS */;
- INSERT INTO `question_skill` (`questionId`, `skillId`) VALUES (138,96),(139,97),(139,98),(140,99),(141,100);
- /*!40000 ALTER TABLE `question_skill` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `role`
- --
- DROP TABLE IF EXISTS `role`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
- CREATE TABLE `role` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `rolename` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `role`
- --
- LOCK TABLES `role` WRITE;
- /*!40000 ALTER TABLE `role` DISABLE KEYS */;
- INSERT INTO `role` (`id`, `rolename`) VALUES (1,'Caretaker'),(2,'Caregiver'),(3,'Admin');
- /*!40000 ALTER TABLE `role` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `skill`
- --
- DROP TABLE IF EXISTS `skill`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
- CREATE TABLE `skill` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `skill` varchar(255) NOT NULL,
- `userId` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `IDX_d5ee9b00fdfc9828c76ef120be` (`skill`),
- KEY `FK_c08612011a88745a32784544b28` (`userId`),
- CONSTRAINT `FK_c08612011a88745a32784544b28` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `skill`
- --
- LOCK TABLES `skill` WRITE;
- /*!40000 ALTER TABLE `skill` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `skill` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `user`
- --
- DROP TABLE IF EXISTS `user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
- CREATE TABLE `user` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `email` varchar(255) NOT NULL,
- `password` varchar(255) NOT NULL,
- `account_status` varchar(255) NOT NULL,
- `coc_url` varchar(255) NOT NULL,
- `passport_photograph` varchar(255) NOT NULL,
- `roleId` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FK_c28e52f758e7bbc53828db92194` (`roleId`),
- CONSTRAINT `FK_c28e52f758e7bbc53828db92194` FOREIGN KEY (`roleId`) REFERENCES `role` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `user`
- --
- LOCK TABLES `user` WRITE;
- /*!40000 ALTER TABLE `user` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `user` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2019-01-16 20:21:21
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement