RzYR6WnM

1-- MySQL dump 10.13  Distrib 8.0.17, for Win64 (x86_64)
2--
3-- Host: localhost    Database: acme-jobs
4-- ------------------------------------------------------
5-- Server version	8.0.17
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/*!50503 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 `acunniabulletin`
20--
21
22DROP TABLE IF EXISTS `acunniabulletin`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `acunniabulletin` (
26  `id` int(11) NOT NULL,
27  `version` int(11) NOT NULL,
28  `author` varchar(255) DEFAULT NULL,
29  `contact` varchar(255) DEFAULT NULL,
30  `moment` datetime(6) DEFAULT NULL,
31  `text` varchar(255) DEFAULT NULL,
32  `vehicle` bit(1) DEFAULT NULL,
33  PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `acunniabulletin`
39--
40
41LOCK TABLES `acunniabulletin` WRITE;
42/*!40000 ALTER TABLE `acunniabulletin` DISABLE KEYS */;
43INSERT INTO `acunniabulletin` VALUES (10,0,'Manuel','954125264','2019-09-09 08:00:00.000000','Hola mundo!',_binary '
'),(11,0,'Paco','correo@deprue.ba','2019-09-09 13:55:00.000000','I\'m your father',_binary '\0');
44/*!40000 ALTER TABLE `acunniabulletin` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `administrator`
49--
50
51DROP TABLE IF EXISTS `administrator`;
52/*!40101 SET @saved_cs_client     = @@character_set_client */;
53/*!50503 SET character_set_client = utf8mb4 */;
54CREATE TABLE `administrator` (
55  `id` int(11) NOT NULL,
56  `version` int(11) NOT NULL,
57  `user_account_id` int(11) DEFAULT NULL,
58  PRIMARY KEY (`id`),
59  KEY `FK_2a5vcjo3stlfcwadosjfq49l1` (`user_account_id`),
60  CONSTRAINT `FK_2a5vcjo3stlfcwadosjfq49l1` FOREIGN KEY (`user_account_id`) REFERENCES `user_account` (`id`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `administrator`
66--
67
68LOCK TABLES `administrator` WRITE;
69/*!40000 ALTER TABLE `administrator` DISABLE KEYS */;
70INSERT INTO `administrator` VALUES (4,0,3);
71/*!40000 ALTER TABLE `administrator` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `anonymous`
76--
77
78DROP TABLE IF EXISTS `anonymous`;
79/*!40101 SET @saved_cs_client     = @@character_set_client */;
80/*!50503 SET character_set_client = utf8mb4 */;
81CREATE TABLE `anonymous` (
82  `id` int(11) NOT NULL,
83  `version` int(11) NOT NULL,
84  `user_account_id` int(11) DEFAULT NULL,
85  PRIMARY KEY (`id`),
86  KEY `FK_6lnbc6fo3om54vugoh8icg78m` (`user_account_id`),
87  CONSTRAINT `FK_6lnbc6fo3om54vugoh8icg78m` FOREIGN KEY (`user_account_id`) REFERENCES `user_account` (`id`)
88) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Dumping data for table `anonymous`
93--
94
95LOCK TABLES `anonymous` WRITE;
96/*!40000 ALTER TABLE `anonymous` DISABLE KEYS */;
97INSERT INTO `anonymous` VALUES (2,0,1);
98/*!40000 ALTER TABLE `anonymous` ENABLE KEYS */;
99UNLOCK TABLES;
100
101--
102-- Table structure for table `authenticated`
103--
104
105DROP TABLE IF EXISTS `authenticated`;
106/*!40101 SET @saved_cs_client     = @@character_set_client */;
107/*!50503 SET character_set_client = utf8mb4 */;
108CREATE TABLE `authenticated` (
109  `id` int(11) NOT NULL,
110  `version` int(11) NOT NULL,
111  `user_account_id` int(11) DEFAULT NULL,
112  PRIMARY KEY (`id`),
113  KEY `FK_h52w0f3wjoi68b63wv9vwon57` (`user_account_id`),
114  CONSTRAINT `FK_h52w0f3wjoi68b63wv9vwon57` FOREIGN KEY (`user_account_id`) REFERENCES `user_account` (`id`)
115) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
116/*!40101 SET character_set_client = @saved_cs_client */;
117
118--
119-- Dumping data for table `authenticated`
120--
121
122LOCK TABLES `authenticated` WRITE;
123/*!40000 ALTER TABLE `authenticated` DISABLE KEYS */;
124INSERT INTO `authenticated` VALUES (5,0,3);
125/*!40000 ALTER TABLE `authenticated` ENABLE KEYS */;
126UNLOCK TABLES;
127
128--
129-- Table structure for table `consumer`
130--
131
132DROP TABLE IF EXISTS `consumer`;
133/*!40101 SET @saved_cs_client     = @@character_set_client */;
134/*!50503 SET character_set_client = utf8mb4 */;
135CREATE TABLE `consumer` (
136  `id` int(11) NOT NULL,
137  `version` int(11) NOT NULL,
138  `user_account_id` int(11) DEFAULT NULL,
139  `company` varchar(255) DEFAULT NULL,
140  `sector` varchar(255) DEFAULT NULL,
141  PRIMARY KEY (`id`),
142  KEY `FK_6cyha9f1wpj0dpbxrrjddrqed` (`user_account_id`),
143  CONSTRAINT `FK_6cyha9f1wpj0dpbxrrjddrqed` FOREIGN KEY (`user_account_id`) REFERENCES `user_account` (`id`)
144) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
145/*!40101 SET character_set_client = @saved_cs_client */;
146
147--
148-- Dumping data for table `consumer`
149--
150
151LOCK TABLES `consumer` WRITE;
152/*!40000 ALTER TABLE `consumer` DISABLE KEYS */;
153/*!40000 ALTER TABLE `consumer` ENABLE KEYS */;
154UNLOCK TABLES;
155
156--
157-- Table structure for table `hibernate_sequence`
158--
159
160DROP TABLE IF EXISTS `hibernate_sequence`;
161/*!40101 SET @saved_cs_client     = @@character_set_client */;
162/*!50503 SET character_set_client = utf8mb4 */;
163CREATE TABLE `hibernate_sequence` (
164  `next_val` bigint(20) DEFAULT NULL
165) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
166/*!40101 SET character_set_client = @saved_cs_client */;
167
168--
169-- Dumping data for table `hibernate_sequence`
170--
171
172LOCK TABLES `hibernate_sequence` WRITE;
173/*!40000 ALTER TABLE `hibernate_sequence` DISABLE KEYS */;
174INSERT INTO `hibernate_sequence` VALUES (18);
175/*!40000 ALTER TABLE `hibernate_sequence` ENABLE KEYS */;
176UNLOCK TABLES;
177
178--
179-- Table structure for table `luisbulletin`
180--
181
182DROP TABLE IF EXISTS `luisbulletin`;
183/*!40101 SET @saved_cs_client     = @@character_set_client */;
184/*!50503 SET character_set_client = utf8mb4 */;
185CREATE TABLE `luisbulletin` (
186  `id` int(11) NOT NULL,
187  `version` int(11) NOT NULL,
188  `email` varchar(255) DEFAULT NULL,
189  `moment` datetime(6) DEFAULT NULL,
190  `name` varchar(255) DEFAULT NULL,
191  `number` varchar(255) DEFAULT NULL,
192  `surname` varchar(255) DEFAULT NULL,
193  PRIMARY KEY (`id`)
194) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
195/*!40101 SET character_set_client = @saved_cs_client */;
196
197--
198-- Dumping data for table `luisbulletin`
199--
200
201LOCK TABLES `luisbulletin` WRITE;
202/*!40000 ALTER TABLE `luisbulletin` DISABLE KEYS */;
203INSERT INTO `luisbulletin` VALUES (15,0,'luiselflow199@gmail.com','2019-08-09 08:00:00.000000','Luis','10','Chacon'),(16,0,'luiselflow199@gmail.com','2019-07-09 08:00:00.000000','Pepe','9','Botella');
204/*!40000 ALTER TABLE `luisbulletin` ENABLE KEYS */;
205UNLOCK TABLES;
206
207--
208-- Table structure for table `martosbulletin`
209--
210
211DROP TABLE IF EXISTS `martosbulletin`;
212/*!40101 SET @saved_cs_client     = @@character_set_client */;
213/*!50503 SET character_set_client = utf8mb4 */;
214CREATE TABLE `martosbulletin` (
215  `id` int(11) NOT NULL,
216  `version` int(11) NOT NULL,
217  `author` varchar(255) DEFAULT NULL,
218  `contact` varchar(255) DEFAULT NULL,
219  `date` datetime(6) DEFAULT NULL,
220  `moment` datetime(6) DEFAULT NULL,
221  `text` varchar(255) DEFAULT NULL,
222  PRIMARY KEY (`id`)
223) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
224/*!40101 SET character_set_client = @saved_cs_client */;
225
226--
227-- Dumping data for table `martosbulletin`
228--
229
230LOCK TABLES `martosbulletin` WRITE;
231/*!40000 ALTER TABLE `martosbulletin` DISABLE KEYS */;
232INSERT INTO `martosbulletin` VALUES (8,0,'Rodolfo','easyjob@worker.com','2019-10-23 13:55:00.000000','2019-10-21 13:55:00.000000','Work for a day!'),(9,0,'Marta','easyjob2@worker.com','2019-10-23 13:55:00.000000','2019-10-21 13:55:00.000000','This IS your job!');
233/*!40000 ALTER TABLE `martosbulletin` ENABLE KEYS */;
234UNLOCK TABLES;
235
236--
237-- Table structure for table `pazosbulletin`
238--
239
240DROP TABLE IF EXISTS `pazosbulletin`;
241/*!40101 SET @saved_cs_client     = @@character_set_client */;
242/*!50503 SET character_set_client = utf8mb4 */;
243CREATE TABLE `pazosbulletin` (
244  `id` int(11) NOT NULL,
245  `version` int(11) NOT NULL,
246  `author` varchar(255) DEFAULT NULL,
247  `contact` varchar(255) DEFAULT NULL,
248  `experience` bit(1) DEFAULT NULL,
249  `food_handler` bit(1) DEFAULT NULL,
250  `moment` datetime(6) DEFAULT NULL,
251  `text` varchar(255) DEFAULT NULL,
252  PRIMARY KEY (`id`)
253) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
254/*!40101 SET character_set_client = @saved_cs_client */;
255
256--
257-- Dumping data for table `pazosbulletin`
258--
259
260LOCK TABLES `pazosbulletin` WRITE;
261/*!40000 ALTER TABLE `pazosbulletin` DISABLE KEYS */;
262INSERT INTO `pazosbulletin` VALUES (12,0,'Rick S.','rick@email.com',_binary '\0',_binary '
','2019-09-09 08:00:00.000000','FH no exp'),(13,0,'Michael Scott','michael@email.com',_binary '
',_binary '
','2019-09-09 13:55:00.000000','FH 15y of exp'),(14,0,'Arthur Fleck','arthur@email.com',_binary '
',_binary '
','2019-10-11 15:01:00.000000','FH 3y of exp');
263/*!40000 ALTER TABLE `pazosbulletin` ENABLE KEYS */;
264UNLOCK TABLES;
265
266--
267-- Table structure for table `provider`
268--
269
270DROP TABLE IF EXISTS `provider`;
271/*!40101 SET @saved_cs_client     = @@character_set_client */;
272/*!50503 SET character_set_client = utf8mb4 */;
273CREATE TABLE `provider` (
274  `id` int(11) NOT NULL,
275  `version` int(11) NOT NULL,
276  `user_account_id` int(11) DEFAULT NULL,
277  `company` varchar(255) DEFAULT NULL,
278  `sector` varchar(255) DEFAULT NULL,
279  PRIMARY KEY (`id`),
280  KEY `FK_b1gwnjqm6ggy9yuiqm0o4rlmd` (`user_account_id`),
281  CONSTRAINT `FK_b1gwnjqm6ggy9yuiqm0o4rlmd` FOREIGN KEY (`user_account_id`) REFERENCES `user_account` (`id`)
282) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
283/*!40101 SET character_set_client = @saved_cs_client */;
284
285--
286-- Dumping data for table `provider`
287--
288
289LOCK TABLES `provider` WRITE;
290/*!40000 ALTER TABLE `provider` DISABLE KEYS */;
291/*!40000 ALTER TABLE `provider` ENABLE KEYS */;
292UNLOCK TABLES;
293
294--
295-- Table structure for table `santosbulletin`
296--
297
298DROP TABLE IF EXISTS `santosbulletin`;
299/*!40101 SET @saved_cs_client     = @@character_set_client */;
300/*!50503 SET character_set_client = utf8mb4 */;
301CREATE TABLE `santosbulletin` (
302  `id` int(11) NOT NULL,
303  `version` int(11) NOT NULL,
304  `author` varchar(255) DEFAULT NULL,
305  `contact` varchar(255) DEFAULT NULL,
306  `language` varchar(255) DEFAULT NULL,
307  `level` varchar(255) DEFAULT NULL,
308  `moment` datetime(6) DEFAULT NULL,
309  `text` varchar(255) DEFAULT NULL,
310  PRIMARY KEY (`id`)
311) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
312/*!40101 SET character_set_client = @saved_cs_client */;
313
314--
315-- Dumping data for table `santosbulletin`
316--
317
318LOCK TABLES `santosbulletin` WRITE;
319/*!40000 ALTER TABLE `santosbulletin` DISABLE KEYS */;
320INSERT INTO `santosbulletin` VALUES (17,0,'Pablo de los Santos','pabdecar@alumn.us.es','Francés','B1','2019-10-21 19:35:00.000000','Se necesita personal en recepción de hotel.');
321/*!40000 ALTER TABLE `santosbulletin` ENABLE KEYS */;
322UNLOCK TABLES;
323
324--
325-- Table structure for table `shout`
326--
327
328DROP TABLE IF EXISTS `shout`;
329/*!40101 SET @saved_cs_client     = @@character_set_client */;
330/*!50503 SET character_set_client = utf8mb4 */;
331CREATE TABLE `shout` (
332  `id` int(11) NOT NULL,
333  `version` int(11) NOT NULL,
334  `author` varchar(255) DEFAULT NULL,
335  `moment` datetime(6) DEFAULT NULL,
336  `text` varchar(255) DEFAULT NULL,
337  PRIMARY KEY (`id`)
338) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
339/*!40101 SET character_set_client = @saved_cs_client */;
340
341--
342-- Dumping data for table `shout`
343--
344
345LOCK TABLES `shout` WRITE;
346/*!40000 ALTER TABLE `shout` DISABLE KEYS */;
347INSERT INTO `shout` VALUES (6,0,'Manuel','2019-09-09 08:00:00.000000','Hola mundo!'),(7,0,'Paco','2019-09-09 13:55:00.000000','I\'m your father');
348/*!40000 ALTER TABLE `shout` ENABLE KEYS */;
349UNLOCK TABLES;
350
351--
352-- Table structure for table `user_account`
353--
354
355DROP TABLE IF EXISTS `user_account`;
356/*!40101 SET @saved_cs_client     = @@character_set_client */;
357/*!50503 SET character_set_client = utf8mb4 */;
358CREATE TABLE `user_account` (
359  `id` int(11) NOT NULL,
360  `version` int(11) NOT NULL,
361  `enabled` bit(1) NOT NULL,
362  `identity_email` varchar(255) DEFAULT NULL,
363  `identity_name` varchar(255) DEFAULT NULL,
364  `identity_surname` varchar(255) DEFAULT NULL,
365  `password` varchar(255) DEFAULT NULL,
366  `username` varchar(255) DEFAULT NULL,
367  PRIMARY KEY (`id`),
368  UNIQUE KEY `UK_castjbvpeeus0r8lbpehiu0e4` (`username`)
369) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
370/*!40101 SET character_set_client = @saved_cs_client */;
371
372--
373-- Dumping data for table `user_account`
374--
375
376LOCK TABLES `user_account` WRITE;
377/*!40000 ALTER TABLE `user_account` DISABLE KEYS */;
378INSERT INTO `user_account` VALUES (1,0,_binary '\0','john.doe@acme.com','John','Doe','$2a$05$AGICVscBib1s8NIrPzrRCuAnUHHGfBV7wRKjvFHll7uB4BGUP43Hy','anonymous'),(3,0,_binary '
','administrator@acme.com','Administrator','Acme.com','$2a$05$zYzuvDhZe8JgG1CSWjUI3.nSNCWsbLuFkGg/siXjeMxg06WEBsoV6','administrator');
379/*!40000 ALTER TABLE `user_account` ENABLE KEYS */;
380UNLOCK TABLES;
381/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
382
383/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
384/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
385/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
386/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
387/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
388/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
389/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
390
391-- Dump completed on 2019-10-22 19:39:51