· 6 years ago · Jun 11, 2019, 11:12 AM
1-- MySQL dump 10.13 Distrib 8.0.15, for Win64 (x86_64)
2--
3-- Host: 127.0.0.1 Database: docker
4-- ------------------------------------------------------
5-- Server version 8.0.16
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 `auth_authority`
20--
21
22DROP TABLE IF EXISTS `auth_authority`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24 SET character_set_client = utf8mb4 ;
25CREATE TABLE `auth_authority` (
26 `id` bigint(20) NOT NULL AUTO_INCREMENT,
27 `name` varchar(255) NOT NULL,
28 PRIMARY KEY (`id`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Dumping data for table `auth_authority`
34--
35
36LOCK TABLES `auth_authority` WRITE;
37/*!40000 ALTER TABLE `auth_authority` DISABLE KEYS */;
38/*!40000 ALTER TABLE `auth_authority` ENABLE KEYS */;
39UNLOCK TABLES;
40
41--
42-- Table structure for table `auth_role`
43--
44
45DROP TABLE IF EXISTS `auth_role`;
46/*!40101 SET @saved_cs_client = @@character_set_client */;
47 SET character_set_client = utf8mb4 ;
48CREATE TABLE `auth_role` (
49 `id` bigint(20) NOT NULL AUTO_INCREMENT,
50 `name` varchar(255) NOT NULL,
51 PRIMARY KEY (`id`)
52) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
53/*!40101 SET character_set_client = @saved_cs_client */;
54
55--
56-- Dumping data for table `auth_role`
57--
58
59LOCK TABLES `auth_role` WRITE;
60/*!40000 ALTER TABLE `auth_role` DISABLE KEYS */;
61/*!40000 ALTER TABLE `auth_role` ENABLE KEYS */;
62UNLOCK TABLES;
63
64--
65-- Table structure for table `auth_roles_authority`
66--
67
68DROP TABLE IF EXISTS `auth_roles_authority`;
69/*!40101 SET @saved_cs_client = @@character_set_client */;
70 SET character_set_client = utf8mb4 ;
71CREATE TABLE `auth_roles_authority` (
72 `role_id` bigint(20) NOT NULL,
73 `authority_id` bigint(20) NOT NULL,
74 PRIMARY KEY (`role_id`,`authority_id`),
75 KEY `FKda3bmpvxquu8ockt10ioijxye` (`authority_id`),
76 CONSTRAINT `FKb3cb72fhie2fsvitqaw469m97` FOREIGN KEY (`role_id`) REFERENCES `auth_role` (`id`),
77 CONSTRAINT `FKda3bmpvxquu8ockt10ioijxye` FOREIGN KEY (`authority_id`) REFERENCES `auth_authority` (`id`)
78) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
79/*!40101 SET character_set_client = @saved_cs_client */;
80
81--
82-- Dumping data for table `auth_roles_authority`
83--
84
85LOCK TABLES `auth_roles_authority` WRITE;
86/*!40000 ALTER TABLE `auth_roles_authority` DISABLE KEYS */;
87/*!40000 ALTER TABLE `auth_roles_authority` ENABLE KEYS */;
88UNLOCK TABLES;
89
90--
91-- Table structure for table `auth_user`
92--
93
94DROP TABLE IF EXISTS `auth_user`;
95/*!40101 SET @saved_cs_client = @@character_set_client */;
96 SET character_set_client = utf8mb4 ;
97CREATE TABLE `auth_user` (
98 `id` bigint(20) NOT NULL AUTO_INCREMENT,
99 `created_at` datetime(6) DEFAULT NULL,
100 `updated_at` datetime(6) DEFAULT NULL,
101 `active` bit(1) DEFAULT NULL,
102 `password` varchar(255) DEFAULT NULL,
103 `email` varchar(255) DEFAULT NULL,
104 `employ_id` varchar(255) DEFAULT NULL,
105 `gender` char(1) NOT NULL,
106 `last_name` varchar(255) NOT NULL,
107 `name` varchar(255) NOT NULL,
108 `role_id` bigint(20) DEFAULT NULL,
109 `department_id` bigint(20) DEFAULT NULL,
110 `position_id` bigint(20) DEFAULT NULL,
111 PRIMARY KEY (`id`),
112 KEY `FKh4b20gq5w82i9vfobmew4972y` (`role_id`),
113 KEY `FKt6dokhll3ojpqb39a4ytm77pl` (`department_id`),
114 KEY `FK5ke7vh2g6vdwxj422jqc09kqb` (`position_id`),
115 CONSTRAINT `FK5ke7vh2g6vdwxj422jqc09kqb` FOREIGN KEY (`position_id`) REFERENCES `org_position` (`id`),
116 CONSTRAINT `FKh4b20gq5w82i9vfobmew4972y` FOREIGN KEY (`role_id`) REFERENCES `auth_role` (`id`),
117 CONSTRAINT `FKt6dokhll3ojpqb39a4ytm77pl` FOREIGN KEY (`department_id`) REFERENCES `org_department` (`id`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `auth_user`
123--
124
125LOCK TABLES `auth_user` WRITE;
126/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;
127/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;
128UNLOCK TABLES;
129
130--
131-- Table structure for table `infrastructure_element`
132--
133
134DROP TABLE IF EXISTS `infrastructure_element`;
135/*!40101 SET @saved_cs_client = @@character_set_client */;
136 SET character_set_client = utf8mb4 ;
137CREATE TABLE `infrastructure_element` (
138 `id` bigint(20) NOT NULL AUTO_INCREMENT,
139 `created_at` datetime(6) DEFAULT NULL,
140 `updated_at` datetime(6) DEFAULT NULL,
141 `name` varchar(255) DEFAULT NULL,
142 `project_id` bigint(20) DEFAULT NULL,
143 `type_id` bigint(20) DEFAULT NULL,
144 PRIMARY KEY (`id`),
145 KEY `FK1lcliygxjr10l27j45e03bcm3` (`project_id`),
146 KEY `FK4307w7i5fahrm8nygeu12cbxe` (`type_id`),
147 CONSTRAINT `FK1lcliygxjr10l27j45e03bcm3` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
148 CONSTRAINT `FK4307w7i5fahrm8nygeu12cbxe` FOREIGN KEY (`type_id`) REFERENCES `infrastructure_type` (`id`)
149) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
150/*!40101 SET character_set_client = @saved_cs_client */;
151
152--
153-- Dumping data for table `infrastructure_element`
154--
155
156LOCK TABLES `infrastructure_element` WRITE;
157/*!40000 ALTER TABLE `infrastructure_element` DISABLE KEYS */;
158/*!40000 ALTER TABLE `infrastructure_element` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `infrastructure_group`
163--
164
165DROP TABLE IF EXISTS `infrastructure_group`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167 SET character_set_client = utf8mb4 ;
168CREATE TABLE `infrastructure_group` (
169 `id` bigint(20) NOT NULL AUTO_INCREMENT,
170 `name` varchar(255) DEFAULT NULL,
171 PRIMARY KEY (`id`)
172) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `infrastructure_group`
177--
178
179LOCK TABLES `infrastructure_group` WRITE;
180/*!40000 ALTER TABLE `infrastructure_group` DISABLE KEYS */;
181INSERT INTO `infrastructure_group` VALUES (1,'Compute'),(2,'Database'),(3,'Storage'),(4,'S3'),(5,'Route');
182/*!40000 ALTER TABLE `infrastructure_group` ENABLE KEYS */;
183UNLOCK TABLES;
184
185--
186-- Table structure for table `infrastructure_paid`
187--
188
189DROP TABLE IF EXISTS `infrastructure_paid`;
190/*!40101 SET @saved_cs_client = @@character_set_client */;
191 SET character_set_client = utf8mb4 ;
192CREATE TABLE `infrastructure_paid` (
193 `id` bigint(20) NOT NULL AUTO_INCREMENT,
194 `created_at` datetime(6) DEFAULT NULL,
195 `updated_at` datetime(6) DEFAULT NULL,
196 `name` varchar(255) DEFAULT NULL,
197 `price` double DEFAULT NULL,
198 `project_id` bigint(20) DEFAULT NULL,
199 `type_id` bigint(20) DEFAULT NULL,
200 PRIMARY KEY (`id`),
201 KEY `FKdype2p0qgdiuy5q9htiy378o0` (`project_id`),
202 KEY `FK2h8leta5l3vieth80r6m2avvy` (`type_id`),
203 CONSTRAINT `FK2h8leta5l3vieth80r6m2avvy` FOREIGN KEY (`type_id`) REFERENCES `infrastructure_type` (`id`),
204 CONSTRAINT `FKdype2p0qgdiuy5q9htiy378o0` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`)
205) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `infrastructure_paid`
210--
211
212LOCK TABLES `infrastructure_paid` WRITE;
213/*!40000 ALTER TABLE `infrastructure_paid` DISABLE KEYS */;
214/*!40000 ALTER TABLE `infrastructure_paid` ENABLE KEYS */;
215UNLOCK TABLES;
216
217--
218-- Table structure for table `infrastructure_type`
219--
220
221DROP TABLE IF EXISTS `infrastructure_type`;
222/*!40101 SET @saved_cs_client = @@character_set_client */;
223 SET character_set_client = utf8mb4 ;
224CREATE TABLE `infrastructure_type` (
225 `id` bigint(20) NOT NULL AUTO_INCREMENT,
226 `name` varchar(255) DEFAULT NULL,
227 `price` double DEFAULT NULL,
228 `group_id` bigint(20) DEFAULT NULL,
229 `generation` int(11) DEFAULT NULL,
230 `size` int(11) DEFAULT NULL,
231 PRIMARY KEY (`id`),
232 KEY `FK5hwf8mu9dx663bn2pv9siuqci` (`group_id`),
233 CONSTRAINT `FK5hwf8mu9dx663bn2pv9siuqci` FOREIGN KEY (`group_id`) REFERENCES `infrastructure_group` (`id`)
234) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
235/*!40101 SET character_set_client = @saved_cs_client */;
236
237--
238-- Dumping data for table `infrastructure_type`
239--
240
241LOCK TABLES `infrastructure_type` WRITE;
242/*!40000 ALTER TABLE `infrastructure_type` DISABLE KEYS */;
243INSERT INTO `infrastructure_type` VALUES (1,'EC2 t2.micro',0.0132,1,2,1),(2,'EC2 t2.small',0.0264,1,2,2),(3,'EC2 t2.medium',0.528,1,2,3),(4,'EC2 t3.micro',0.0118,1,3,1),(5,'EC2 t3.small',0.0236,1,3,2),(6,'EC2 t3.medium',0.0472,1,3,3),(7,'MySql t2.micro',0.019,2,2,1),(8,'MySql t2.small',0.038,2,2,2),(9,'MySql t3.micro',0.019,2,3,1),(10,'MySql t3.small',0.038,2,3,2),(11,'Oracle t2.micro',0.041,2,2,1),(12,'Oracle t2.small',0.081,2,2,2),(13,'Oracle t3.micro',0.041,2,3,1),(14,'Oracle t3.small',0.081,2,3,2),(15,'SQL t2.micro',0.024,2,2,2),(16,'SQL t2.small',0.048,2,2,3);
244/*!40000 ALTER TABLE `infrastructure_type` ENABLE KEYS */;
245UNLOCK TABLES;
246
247--
248-- Table structure for table `org_department`
249--
250
251DROP TABLE IF EXISTS `org_department`;
252/*!40101 SET @saved_cs_client = @@character_set_client */;
253 SET character_set_client = utf8mb4 ;
254CREATE TABLE `org_department` (
255 `id` bigint(20) NOT NULL AUTO_INCREMENT,
256 `name` varchar(255) DEFAULT NULL,
257 PRIMARY KEY (`id`)
258) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
259/*!40101 SET character_set_client = @saved_cs_client */;
260
261--
262-- Dumping data for table `org_department`
263--
264
265LOCK TABLES `org_department` WRITE;
266/*!40000 ALTER TABLE `org_department` DISABLE KEYS */;
267/*!40000 ALTER TABLE `org_department` ENABLE KEYS */;
268UNLOCK TABLES;
269
270--
271-- Table structure for table `org_position`
272--
273
274DROP TABLE IF EXISTS `org_position`;
275/*!40101 SET @saved_cs_client = @@character_set_client */;
276 SET character_set_client = utf8mb4 ;
277CREATE TABLE `org_position` (
278 `id` bigint(20) NOT NULL AUTO_INCREMENT,
279 `name` varchar(255) DEFAULT NULL,
280 PRIMARY KEY (`id`)
281) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
282/*!40101 SET character_set_client = @saved_cs_client */;
283
284--
285-- Dumping data for table `org_position`
286--
287
288LOCK TABLES `org_position` WRITE;
289/*!40000 ALTER TABLE `org_position` DISABLE KEYS */;
290/*!40000 ALTER TABLE `org_position` ENABLE KEYS */;
291UNLOCK TABLES;
292
293--
294-- Table structure for table `project`
295--
296
297DROP TABLE IF EXISTS `project`;
298/*!40101 SET @saved_cs_client = @@character_set_client */;
299 SET character_set_client = utf8mb4 ;
300CREATE TABLE `project` (
301 `id` bigint(20) NOT NULL AUTO_INCREMENT,
302 `created_at` datetime(6) DEFAULT NULL,
303 `updated_at` datetime(6) DEFAULT NULL,
304 `name` varchar(255) DEFAULT NULL,
305 PRIMARY KEY (`id`)
306) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
307/*!40101 SET character_set_client = @saved_cs_client */;
308
309--
310-- Dumping data for table `project`
311--
312
313LOCK TABLES `project` WRITE;
314/*!40000 ALTER TABLE `project` DISABLE KEYS */;
315INSERT INTO `project` VALUES (1,'2019-06-10 20:10:03.312000','2019-06-10 20:10:03.312000','servidor des'),(2,'2019-06-10 20:10:03.312000','2019-06-10 20:10:03.312000','saleslink'),(3,'2019-06-10 20:10:03.312000','2019-06-10 20:10:03.312000','coop idl'),(4,'2019-06-10 20:10:03.312000','2019-06-10 20:10:03.312000','copernicus'),(5,'2019-06-10 20:10:03.312000','2019-06-10 20:10:03.312000','obbio');
316/*!40000 ALTER TABLE `project` ENABLE KEYS */;
317UNLOCK TABLES;
318/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
319
320/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
321/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
322/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
323/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
324/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
325/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
326/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
327
328-- Dump completed on 2019-06-11 13:06:24