96fWLs2K

1-- MySQL dump 10.13  Distrib 8.0.16, for Win64 (x86_64)
2--
3-- Host: localhost    Database: uniweb_facebank
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 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 `appearance`
20--
21
22DROP TABLE IF EXISTS `appearance`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24 SET character_set_client = utf8mb4 ;
25CREATE TABLE `appearance` (
26  `id` bigint(20) NOT NULL AUTO_INCREMENT,
27  `name` varchar(255) NOT NULL,
28  PRIMARY KEY (`id`)
29ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Dumping data for table `appearance`
34--
35
36LOCK TABLES `appearance` WRITE;
37/*!40000 ALTER TABLE `appearance` DISABLE KEYS */;
38INSERT INTO `appearance` VALUES (1,'box'),(2,'list'),(3,'floating'),(4,'favorite'),(5,'workflow'),(6,'header');
39/*!40000 ALTER TABLE `appearance` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `assignation`
44--
45
46DROP TABLE IF EXISTS `assignation`;
47/*!40101 SET @saved_cs_client     = @@character_set_client */;
48 SET character_set_client = utf8mb4 ;
49CREATE TABLE `assignation` (
50  `id` bigint(20) NOT NULL AUTO_INCREMENT,
51  `behavior` bigint(20) NOT NULL,
52  `component` bigint(20) NOT NULL,
53  `vision` bigint(20) NOT NULL,
54  PRIMARY KEY (`id`),
55  KEY `FK_e1lefkhxufufyx57n1rf8qdmw` (`behavior`),
56  KEY `FK_s58ekh61doi4576pyrco87jc2` (`component`),
57  KEY `FK_ltcsanep9s50xjfpauovklxeb` (`vision`),
58  CONSTRAINT `FK_e1lefkhxufufyx57n1rf8qdmw` FOREIGN KEY (`behavior`) REFERENCES `behavior` (`id`),
59  CONSTRAINT `FK_ltcsanep9s50xjfpauovklxeb` FOREIGN KEY (`vision`) REFERENCES `vision` (`id`),
60  CONSTRAINT `FK_s58ekh61doi4576pyrco87jc2` FOREIGN KEY (`component`) REFERENCES `component` (`id`)
61) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `assignation`
66--
67
68LOCK TABLES `assignation` WRITE;
69/*!40000 ALTER TABLE `assignation` DISABLE KEYS */;
70INSERT INTO `assignation` VALUES (1,2,41,29),(2,2,22,29),(3,2,21,29),(4,2,70,29),(5,2,41,33),(6,2,22,33),(7,2,21,33),(8,2,70,33),(9,3,29,33),(10,3,30,33);
71/*!40000 ALTER TABLE `assignation` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `auditabledetail`
76--
77
78DROP TABLE IF EXISTS `auditabledetail`;
79/*!40101 SET @saved_cs_client     = @@character_set_client */;
80 SET character_set_client = utf8mb4 ;
81CREATE TABLE `auditabledetail` (
82  `id` bigint(20) NOT NULL AUTO_INCREMENT,
83  `key` varchar(255) DEFAULT NULL,
84  `value` longtext,
85  `event_id` bigint(20) DEFAULT NULL,
86  PRIMARY KEY (`id`),
87  KEY `FK_dic7y2hk79ofunj9tw5efwisf` (`event_id`),
88  CONSTRAINT `FK_dic7y2hk79ofunj9tw5efwisf` FOREIGN KEY (`event_id`) REFERENCES `auditableevent` (`id`)
89) ENGINE=InnoDB DEFAULT CHARSET=utf8;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Dumping data for table `auditabledetail`
94--
95
96LOCK TABLES `auditabledetail` WRITE;
97/*!40000 ALTER TABLE `auditabledetail` DISABLE KEYS */;
98/*!40000 ALTER TABLE `auditabledetail` ENABLE KEYS */;
99UNLOCK TABLES;
100
101--
102-- Table structure for table `auditableevent`
103--
104
105DROP TABLE IF EXISTS `auditableevent`;
106/*!40101 SET @saved_cs_client     = @@character_set_client */;
107 SET character_set_client = utf8mb4 ;
108CREATE TABLE `auditableevent` (
109  `id` bigint(20) NOT NULL AUTO_INCREMENT,
110  `contextId` bigint(20) DEFAULT NULL,
111  `contextName` varchar(255) DEFAULT NULL,
112  `date` bigint(20) DEFAULT NULL,
113  `element` varchar(255) DEFAULT NULL,
114  `userId` bigint(20) DEFAULT NULL,
115  `username` varchar(255) DEFAULT NULL,
116  `type` bigint(20) DEFAULT NULL,
117  PRIMARY KEY (`id`),
118  KEY `FK_3urhysyecv39xa3v0t9v840kx` (`type`),
119  CONSTRAINT `FK_3urhysyecv39xa3v0t9v840kx` FOREIGN KEY (`type`) REFERENCES `auditableeventtype` (`id`)
120) ENGINE=InnoDB DEFAULT CHARSET=utf8;
121/*!40101 SET character_set_client = @saved_cs_client */;
122
123--
124-- Dumping data for table `auditableevent`
125--
126
127LOCK TABLES `auditableevent` WRITE;
128/*!40000 ALTER TABLE `auditableevent` DISABLE KEYS */;
129/*!40000 ALTER TABLE `auditableevent` ENABLE KEYS */;
130UNLOCK TABLES;
131
132--
133-- Table structure for table `auditableeventtype`
134--
135
136DROP TABLE IF EXISTS `auditableeventtype`;
137/*!40101 SET @saved_cs_client     = @@character_set_client */;
138 SET character_set_client = utf8mb4 ;
139CREATE TABLE `auditableeventtype` (
140  `id` bigint(20) NOT NULL AUTO_INCREMENT,
141  `name` varchar(255) NOT NULL,
142  PRIMARY KEY (`id`)
143) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
144/*!40101 SET character_set_client = @saved_cs_client */;
145
146--
147-- Dumping data for table `auditableeventtype`
148--
149
150LOCK TABLES `auditableeventtype` WRITE;
151/*!40000 ALTER TABLE `auditableeventtype` DISABLE KEYS */;
152INSERT INTO `auditableeventtype` VALUES (1,'access'),(2,'create'),(3,'update'),(4,'delete'),(5,'invoke');
153/*!40000 ALTER TABLE `auditableeventtype` ENABLE KEYS */;
154UNLOCK TABLES;
155
156--
157-- Table structure for table `authenticationattribute`
158--
159
160DROP TABLE IF EXISTS `authenticationattribute`;
161/*!40101 SET @saved_cs_client     = @@character_set_client */;
162 SET character_set_client = utf8mb4 ;
163CREATE TABLE `authenticationattribute` (
164  `id` bigint(20) NOT NULL AUTO_INCREMENT,
165  `name` varchar(255) DEFAULT NULL,
166  `value` varchar(255) DEFAULT NULL,
167  `authenticationProfile` bigint(20) DEFAULT NULL,
168  PRIMARY KEY (`id`),
169  UNIQUE KEY `UK_4fjj9ixftu4e05qj7gu8fhc5e` (`name`),
170  KEY `FK_7hjumg8v1fsagq155f6djix74` (`authenticationProfile`),
171  CONSTRAINT `FK_7hjumg8v1fsagq155f6djix74` FOREIGN KEY (`authenticationProfile`) REFERENCES `authenticationprofile` (`id`)
172) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `authenticationattribute`
177--
178
179LOCK TABLES `authenticationattribute` WRITE;
180/*!40000 ALTER TABLE `authenticationattribute` DISABLE KEYS */;
181INSERT INTO `authenticationattribute` VALUES (1,'expirationDaysConstraint','30',1),(2,'mustContainUppercaseConstraint','false',1),(3,'minLengthConstraint','1',1),(4,'mustContainLowercaseConstraint','false',1),(5,'mustContainLettersConstraint','false',1),(6,'maxLengthConstraint','20',1),(7,'mustContainDigitsConstraint','false',1),(8,'mustContainSymbolsConstraint','false',1),(9,'domain','',2),(10,'host','',2),(11,'dataBase','',2),(12,'LdapUsername','',2),(13,'LdapPassword','',2),(14,'LdapAccountName','',2),(15,'LdapForename','',2),(16,'LdapLastName','',2),(17,'LdapMail','',2),(18,'LdapQuery','',2);
182/*!40000 ALTER TABLE `authenticationattribute` ENABLE KEYS */;
183UNLOCK TABLES;
184
185--
186-- Table structure for table `authenticationprofile`
187--
188
189DROP TABLE IF EXISTS `authenticationprofile`;
190/*!40101 SET @saved_cs_client     = @@character_set_client */;
191 SET character_set_client = utf8mb4 ;
192CREATE TABLE `authenticationprofile` (
193  `id` bigint(20) NOT NULL AUTO_INCREMENT,
194  `name` varchar(255) DEFAULT NULL,
195  `bean` varchar(255) NOT NULL,
196  PRIMARY KEY (`id`),
197  UNIQUE KEY `UK_rda8118ekaikym52gtmo7jhyl` (`bean`),
198  UNIQUE KEY `UK_drvbb7qtf4knyeftlhuwpk38r` (`name`)
199) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
200/*!40101 SET character_set_client = @saved_cs_client */;
201
202--
203-- Dumping data for table `authenticationprofile`
204--
205
206LOCK TABLES `authenticationprofile` WRITE;
207/*!40000 ALTER TABLE `authenticationprofile` DISABLE KEYS */;
208INSERT INTO `authenticationprofile` VALUES (1,'local','localAuthenticationService'),(2,'ldap','activeDirectoryAuthenticationService');
209/*!40000 ALTER TABLE `authenticationprofile` ENABLE KEYS */;
210UNLOCK TABLES;
211
212--
213-- Table structure for table `behavior`
214--
215
216DROP TABLE IF EXISTS `behavior`;
217/*!40101 SET @saved_cs_client     = @@character_set_client */;
218 SET character_set_client = utf8mb4 ;
219CREATE TABLE `behavior` (
220  `id` bigint(20) NOT NULL AUTO_INCREMENT,
221  `name` varchar(255) NOT NULL,
222  `priority` int(11) DEFAULT NULL,
223  PRIMARY KEY (`id`),
224  UNIQUE KEY `UK_d0t4sn3yu62g6xu4bdu5yyec0` (`name`)
225) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
226/*!40101 SET character_set_client = @saved_cs_client */;
227
228--
229-- Dumping data for table `behavior`
230--
231
232LOCK TABLES `behavior` WRITE;
233/*!40000 ALTER TABLE `behavior` DISABLE KEYS */;
234INSERT INTO `behavior` VALUES (1,'enabled',1),(2,'disabled',2),(3,'hidden',3);
235/*!40000 ALTER TABLE `behavior` ENABLE KEYS */;
236UNLOCK TABLES;
237
238--
239-- Table structure for table `category`
240--
241
242DROP TABLE IF EXISTS `category`;
243/*!40101 SET @saved_cs_client     = @@character_set_client */;
244 SET character_set_client = utf8mb4 ;
245CREATE TABLE `category` (
246  `id` bigint(20) NOT NULL AUTO_INCREMENT,
247  `name` varchar(255) NOT NULL,
248  `attribute_name` varchar(255) DEFAULT NULL,
249  `attribute_value` varchar(255) DEFAULT NULL,
250  `show_order` bigint(20) DEFAULT NULL,
251  `inbox` bigint(20) NOT NULL,
252  PRIMARY KEY (`id`),
253  KEY `FK_n22i684hkakb6pkabv32fos5k` (`inbox`),
254  CONSTRAINT `FK_n22i684hkakb6pkabv32fos5k` FOREIGN KEY (`inbox`) REFERENCES `inbox` (`id`)
255) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `category`
260--
261
262LOCK TABLES `category` WRITE;
263/*!40000 ALTER TABLE `category` DISABLE KEYS */;
264INSERT INTO `category` VALUES (1,'Alta de cliente','id_category','Alta_de_clientes',1,1),(2,'Alta_de_cliente','id_category','Alta_de_clientes',2,1);
265/*!40000 ALTER TABLE `category` ENABLE KEYS */;
266UNLOCK TABLES;
267
268--
269-- Table structure for table `component`
270--
271
272DROP TABLE IF EXISTS `component`;
273/*!40101 SET @saved_cs_client     = @@character_set_client */;
274 SET character_set_client = utf8mb4 ;
275CREATE TABLE `component` (
276  `id` bigint(20) NOT NULL AUTO_INCREMENT,
277  `name` varchar(255) DEFAULT NULL,
278  `label` varchar(255) DEFAULT NULL,
279  `order` double DEFAULT NULL,
280  `reference` varchar(255) DEFAULT NULL,
281  `type` varchar(255) DEFAULT NULL,
282  `functionality_id` bigint(20) NOT NULL,
283  `parent_id` bigint(20) DEFAULT NULL,
284  PRIMARY KEY (`id`),
285  KEY `FK_fn5t85kay2la2bnwlpd9w7eq2` (`functionality_id`),
286  KEY `FK_83myy9bwi8mx5nhmtv2pnpwk5` (`parent_id`),
287  CONSTRAINT `FK_83myy9bwi8mx5nhmtv2pnpwk5` FOREIGN KEY (`parent_id`) REFERENCES `component` (`id`),
288  CONSTRAINT `FK_fn5t85kay2la2bnwlpd9w7eq2` FOREIGN KEY (`functionality_id`) REFERENCES `functionality` (`id`)
289) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8;
290/*!40101 SET character_set_client = @saved_cs_client */;
291
292--
293-- Dumping data for table `component`
294--
295
296LOCK TABLES `component` WRITE;
297/*!40000 ALTER TABLE `component` DISABLE KEYS */;
298INSERT INTO `component` VALUES (1,NULL,NULL,NULL,'Cargo desempeñado',NULL,30,NULL),(2,NULL,NULL,NULL,'Tipo de operacion',NULL,30,NULL),(3,NULL,NULL,NULL,'Moneda',NULL,30,NULL),(4,NULL,NULL,NULL,'Email',NULL,30,NULL),(5,NULL,NULL,NULL,'Tipo de documento',NULL,30,NULL),(6,NULL,NULL,NULL,'Estado civil',NULL,30,NULL),(7,NULL,NULL,NULL,'Fecha de apertura',NULL,30,NULL),(8,NULL,NULL,NULL,'Tipo de cuenta',NULL,30,NULL),(9,NULL,NULL,NULL,'Observacion financiera',NULL,30,NULL),(10,NULL,NULL,NULL,'Fecha de ingreso',NULL,30,NULL),(11,NULL,NULL,NULL,'Riesgo',NULL,30,NULL),(12,NULL,NULL,NULL,'Codigo de profesion',NULL,30,NULL),(13,NULL,NULL,NULL,'Grupo Economico',NULL,30,NULL),(14,NULL,NULL,NULL,'Productos / Servicios que ofrece - Retirado',NULL,30,NULL),(15,NULL,NULL,NULL,'Segundo apellido',NULL,30,NULL),(16,NULL,NULL,NULL,'Cargo desempeñado - Retirado',NULL,30,NULL),(17,NULL,NULL,NULL,'Datos del referente',NULL,30,NULL),(18,NULL,NULL,NULL,'Nombres completos',NULL,30,NULL),(19,NULL,NULL,NULL,'Observación',NULL,30,NULL),(20,NULL,NULL,NULL,'Monto',NULL,30,NULL),(21,NULL,NULL,NULL,'Tipo de referencia financiera',NULL,30,NULL),(22,NULL,NULL,NULL,'Tipo de referencia comercial',NULL,30,NULL),(23,NULL,NULL,NULL,'Direccion',NULL,30,NULL),(24,NULL,NULL,NULL,'Tipo de direccion',NULL,30,NULL),(25,NULL,NULL,NULL,'Nombre de tarjeta de credito',NULL,30,NULL),(26,NULL,NULL,NULL,'Respuesta a pregunta secreta',NULL,30,NULL),(27,NULL,NULL,NULL,'Salario mensual - Retirado',NULL,30,NULL),(28,NULL,NULL,NULL,'Codigo',NULL,30,NULL),(29,NULL,NULL,NULL,'Boton aprobar',NULL,30,NULL),(30,NULL,NULL,NULL,'Boton rechazar',NULL,30,NULL),(31,NULL,NULL,NULL,'Ciudad',NULL,30,NULL),(32,NULL,NULL,NULL,'Cupo / consumo',NULL,30,NULL),(33,NULL,NULL,NULL,'Sueldo Mensual',NULL,30,NULL),(34,NULL,NULL,NULL,'Numero mensual de cheques depositados',NULL,30,NULL),(35,NULL,NULL,NULL,'Compania',NULL,30,NULL),(36,NULL,NULL,NULL,'Fecha de emision de pasaporte',NULL,30,NULL),(37,NULL,NULL,NULL,'Moneda - Retirado',NULL,30,NULL),(38,NULL,NULL,NULL,'Cantidad',NULL,30,NULL),(39,NULL,NULL,NULL,'Nacionalidad',NULL,30,NULL),(40,NULL,NULL,NULL,'Actividad',NULL,30,NULL),(41,NULL,NULL,NULL,'Tipo de referencia bancaria',NULL,30,NULL),(42,NULL,NULL,NULL,'Empleador previo',NULL,30,NULL),(43,NULL,NULL,NULL,'Clasificacion de cupo',NULL,30,NULL),(44,NULL,NULL,NULL,'Estado de operacion',NULL,30,NULL),(45,NULL,NULL,NULL,'Origen de fondos iniciales',NULL,30,NULL),(46,NULL,NULL,NULL,'Observacion de tarjeta de credito',NULL,30,NULL),(47,NULL,NULL,NULL,'Cargo',NULL,30,NULL),(48,NULL,NULL,NULL,'Número de telefono',NULL,30,NULL),(49,NULL,NULL,NULL,'Motivo de apertura',NULL,30,NULL),(50,NULL,NULL,NULL,'Productos / Servicios que ofrece',NULL,30,NULL),(51,NULL,NULL,NULL,'Fecha de expiracion de documento',NULL,30,NULL),(52,NULL,NULL,NULL,'Tipo de telefono',NULL,30,NULL),(53,NULL,NULL,NULL,'Sexo',NULL,30,NULL),(54,NULL,NULL,NULL,'Fecha de ingreso - Retirado',NULL,30,NULL),(55,NULL,NULL,NULL,'Estado',NULL,30,NULL),(56,NULL,NULL,NULL,'Numero de tarjeta de credito',NULL,30,NULL),(57,NULL,NULL,NULL,'Fecha de egreso',NULL,30,NULL),(58,NULL,NULL,NULL,'Fecha de nacimiento',NULL,30,NULL),(59,NULL,NULL,NULL,'Calificación',NULL,30,NULL),(60,NULL,NULL,NULL,'Banco',NULL,30,NULL),(61,NULL,NULL,NULL,'Fecha',NULL,30,NULL),(62,NULL,NULL,NULL,'Nombre de la empresa',NULL,30,NULL),(63,NULL,NULL,NULL,'Numero de cuenta',NULL,30,NULL),(64,NULL,NULL,NULL,'fecha de expiracion',NULL,30,NULL),(65,NULL,NULL,NULL,'Telefono',NULL,30,NULL),(66,NULL,NULL,NULL,'Primer apellido',NULL,30,NULL),(67,NULL,NULL,NULL,'Fecha de emision de documento',NULL,30,NULL),(68,NULL,NULL,NULL,'Lugar de nacimiento',NULL,30,NULL),(69,NULL,NULL,NULL,'Pregunta secreta',NULL,30,NULL),(70,NULL,NULL,NULL,'Tipo de referencia tarjeta de credito',NULL,30,NULL),(71,NULL,NULL,NULL,'Cargo - Retirado',NULL,30,NULL),(72,NULL,NULL,NULL,'Pais',NULL,30,NULL),(73,NULL,NULL,NULL,'fecha de inicio',NULL,30,NULL),(74,NULL,NULL,NULL,'Fecha de expiracion de pasaporte',NULL,30,NULL),(75,NULL,NULL,NULL,'Clasificacion de saldo',NULL,30,NULL),(76,NULL,NULL,NULL,'Calificacion financiera',NULL,30,NULL),(77,NULL,NULL,NULL,'Transferencias',NULL,30,NULL),(78,NULL,NULL,NULL,'Numero de referencia economica',NULL,30,NULL),(79,NULL,NULL,NULL,'Fecha de apertura de tarjeta de credito',NULL,30,NULL),(80,NULL,NULL,NULL,'Referido por',NULL,30,NULL),(81,NULL,NULL,NULL,'Condicion laboral - Retirado',NULL,30,NULL),(82,NULL,NULL,NULL,'Numero mensual de cheques girados',NULL,30,NULL),(83,NULL,NULL,NULL,'Boton enviar',NULL,30,NULL),(84,NULL,NULL,NULL,'Saldo',NULL,30,NULL),(85,NULL,NULL,NULL,'Numero de documento',NULL,30,NULL),(86,NULL,NULL,NULL,'Combo de bdf',NULL,30,NULL),(87,NULL,NULL,NULL,'Usuario BV Login',NULL,30,NULL),(88,NULL,NULL,NULL,'Nombre de oficial',NULL,30,NULL),(89,NULL,NULL,NULL,'Numero de pasaporte',NULL,30,NULL),(90,NULL,NULL,NULL,'Condicion Laboral',NULL,30,NULL),(91,NULL,NULL,NULL,'Proposito de cheques girados',NULL,30,NULL),(92,NULL,NULL,NULL,'Condicion de propiedad',NULL,30,NULL);
299/*!40000 ALTER TABLE `component` ENABLE KEYS */;
300UNLOCK TABLES;
301
302--
303-- Table structure for table `context`
304--
305
306DROP TABLE IF EXISTS `context`;
307/*!40101 SET @saved_cs_client     = @@character_set_client */;
308 SET character_set_client = utf8mb4 ;
309CREATE TABLE `context` (
310  `id` bigint(20) NOT NULL AUTO_INCREMENT,
311  `name` varchar(255) NOT NULL,
312  `configFileName` varchar(255) DEFAULT NULL,
313  `path` varchar(255) DEFAULT NULL,
314  `organization` bigint(20) DEFAULT NULL,
315  PRIMARY KEY (`id`),
316  KEY `FK_dmlmm48pdqxf4yghrbycsffnl` (`organization`),
317  CONSTRAINT `FK_dmlmm48pdqxf4yghrbycsffnl` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`)
318) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
319/*!40101 SET character_set_client = @saved_cs_client */;
320
321--
322-- Dumping data for table `context`
323--
324
325LOCK TABLES `context` WRITE;
326/*!40000 ALTER TABLE `context` DISABLE KEYS */;
327INSERT INTO `context` VALUES (1,'uniweb',NULL,NULL,NULL),(2,'facebank','facebank.configuration.properties','%CLASSPATH%',1);
328/*!40000 ALTER TABLE `context` ENABLE KEYS */;
329UNLOCK TABLES;
330
331--
332-- Table structure for table `dayofweek`
333--
334
335DROP TABLE IF EXISTS `dayofweek`;
336/*!40101 SET @saved_cs_client     = @@character_set_client */;
337 SET character_set_client = utf8mb4 ;
338CREATE TABLE `dayofweek` (
339  `id` bigint(20) NOT NULL AUTO_INCREMENT,
340  `name` varchar(255) NOT NULL,
341  `value` int(11) DEFAULT NULL,
342  PRIMARY KEY (`id`)
343) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
344/*!40101 SET character_set_client = @saved_cs_client */;
345
346--
347-- Dumping data for table `dayofweek`
348--
349
350LOCK TABLES `dayofweek` WRITE;
351/*!40000 ALTER TABLE `dayofweek` DISABLE KEYS */;
352INSERT INTO `dayofweek` VALUES (1,'sunday',1),(2,'monday',2),(3,'tuesday',3),(4,'wednesday',4),(5,'thursday',5),(6,'friday',6),(7,'saturday',7);
353/*!40000 ALTER TABLE `dayofweek` ENABLE KEYS */;
354UNLOCK TABLES;
355
356--
357-- Table structure for table `detail`
358--
359
360DROP TABLE IF EXISTS `detail`;
361/*!40101 SET @saved_cs_client     = @@character_set_client */;
362 SET character_set_client = utf8mb4 ;
363CREATE TABLE `detail` (
364  `id` bigint(20) NOT NULL AUTO_INCREMENT,
365  `name` varchar(255) NOT NULL,
366  `attribute_name` varchar(255) DEFAULT NULL,
367  `detail_order` bigint(20) DEFAULT NULL,
368  `relevant` tinyint(1) DEFAULT NULL,
369  `inbox` bigint(20) NOT NULL,
370  PRIMARY KEY (`id`),
371  KEY `FK_om5w6yaf16usn0yajcyrfnl9t` (`inbox`),
372  CONSTRAINT `FK_om5w6yaf16usn0yajcyrfnl9t` FOREIGN KEY (`inbox`) REFERENCES `inbox` (`id`)
373) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
374/*!40101 SET character_set_client = @saved_cs_client */;
375
376--
377-- Dumping data for table `detail`
378--
379
380LOCK TABLES `detail` WRITE;
381/*!40000 ALTER TABLE `detail` DISABLE KEYS */;
382INSERT INTO `detail` VALUES (1,'workflow','name',1,1,1);
383/*!40000 ALTER TABLE `detail` ENABLE KEYS */;
384UNLOCK TABLES;
385
386--
387-- Table structure for table `favorite`
388--
389
390DROP TABLE IF EXISTS `favorite`;
391/*!40101 SET @saved_cs_client     = @@character_set_client */;
392 SET character_set_client = utf8mb4 ;
393CREATE TABLE `favorite` (
394  `id` bigint(20) NOT NULL AUTO_INCREMENT,
395  `name` varchar(255) NOT NULL,
396  `background_color` varchar(255) DEFAULT NULL,
397  `font_color` varchar(255) DEFAULT NULL,
398  `icon` varchar(255) DEFAULT NULL,
399  `functionalityNode_id` bigint(20) DEFAULT NULL,
400  `user_id` bigint(20) DEFAULT NULL,
401  PRIMARY KEY (`id`),
402  KEY `FK_3dc5ttabrnsj6g48uxo3aeauq` (`functionalityNode_id`),
403  KEY `FK_8f4j36u3ealttx057oeppnphm` (`user_id`),
404  CONSTRAINT `FK_3dc5ttabrnsj6g48uxo3aeauq` FOREIGN KEY (`functionalityNode_id`) REFERENCES `functionality_node` (`id`),
405  CONSTRAINT `FK_8f4j36u3ealttx057oeppnphm` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
406) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
407/*!40101 SET character_set_client = @saved_cs_client */;
408
409--
410-- Dumping data for table `favorite`
411--
412
413LOCK TABLES `favorite` WRITE;
414/*!40000 ALTER TABLE `favorite` DISABLE KEYS */;
415INSERT INTO `favorite` VALUES (6,'Alta de cliente','#607D8B','#ffffff','USER_PLUS',32,2),(7,'Carga de Datos','#607D8B','#ffffff','ADJUST',30,3),(8,'Carga de Datos','#607D8B','#ffffff','ADJUST',30,4),(9,'Carga de Datos','#607D8B','#ffffff','ADJUST',30,5),(10,'Carga de Datos','#607D8B','#ffffff','ADJUST',30,6);
416/*!40000 ALTER TABLE `favorite` ENABLE KEYS */;
417UNLOCK TABLES;
418
419--
420-- Table structure for table `functionality`
421--
422
423DROP TABLE IF EXISTS `functionality`;
424/*!40101 SET @saved_cs_client     = @@character_set_client */;
425 SET character_set_client = utf8mb4 ;
426CREATE TABLE `functionality` (
427  `id` bigint(20) NOT NULL AUTO_INCREMENT,
428  `name` varchar(255) NOT NULL,
429  `bean` varchar(255) NOT NULL,
430  `description` varchar(255) DEFAULT NULL,
431  `enabled` tinyint(1) NOT NULL,
432  `pinTab` tinyint(1) NOT NULL,
433  `context` bigint(20) DEFAULT NULL,
434  `organization` bigint(20) DEFAULT NULL,
435  PRIMARY KEY (`id`),
436  KEY `FK_k15xxx89sl3p5kgsmxgn5s9y3` (`context`),
437  KEY `FK_fjtvu5la0erwlfmc2arufoh1h` (`organization`),
438  CONSTRAINT `FK_fjtvu5la0erwlfmc2arufoh1h` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`),
439  CONSTRAINT `FK_k15xxx89sl3p5kgsmxgn5s9y3` FOREIGN KEY (`context`) REFERENCES `context` (`id`)
440) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
441/*!40101 SET character_set_client = @saved_cs_client */;
442
443--
444-- Dumping data for table `functionality`
445--
446
447LOCK TABLES `functionality` WRITE;
448/*!40000 ALTER TABLE `functionality` DISABLE KEYS */;
449INSERT INTO `functionality` VALUES (1,'importconf','importLayout','Importar configuraciones',1,1,1,NULL),(2,'export','exportLayout','Exportar configuraciones',1,1,1,NULL),(3,'security','securityLayout','Administración de seguridad',1,1,1,NULL),(4,'language','i18nLayout','Administración de lenguajes',1,1,1,NULL),(5,'user','userLayout','Administración de usuarios',1,1,1,NULL),(6,'organization','organizationLayout','Administración de empresas',1,1,1,NULL),(7,'role','roleLayout','Administración de roles',1,1,1,NULL),(8,'group','groupLayout','Administración de los grupos',1,1,1,NULL),(9,'functionality','functionalityLayout','Administración de las funcionalidades',1,1,1,NULL),(10,'vision','visionLayout','Administración de vistas',1,1,1,NULL),(11,'link','functionalityLinkLayout','Administración de los enlaces entre funcionalidades',1,1,1,NULL),(12,'menu','menuLayout','Administración del menú',1,1,1,NULL),(13,'publicity','publicityLayout','Administración de las publicidades',1,1,1,NULL),(14,'inbox','inboxLayout','Administración del inbox',1,1,1,NULL),(15,'notification','notificationLayout','Administración de notificaciones',1,1,1,NULL),(16,'workflowInbox','workflowInboxLayout','Administración de inbox de workflow',1,1,1,NULL),(17,'navigator','navigatorLayout','Administración de navigadores',1,1,1,NULL),(18,'navigable','navigableLayout','Administración de navegables',1,1,1,NULL),(19,'nodes','navigableNodeLayout','Administración de nodos navegables',1,0,1,NULL),(20,'workflowproc','processLayout','Administración de procesos de workflow',1,1,1,NULL),(21,'context','contextLayout','Administración de contextos de aplicaciones cliente',1,1,1,NULL),(22,'permission','','Carpeta contenedora de permisos',1,0,1,NULL),(23,'application','','Carpeta contenedora de funcionalidades de la aplicación cliente',1,0,1,NULL),(24,'content','','Carpeta contenedora de contenido',1,0,1,NULL),(25,'messaging','','Carpeta contenedora de bandejas de entrada',1,0,1,NULL),(26,'processes','','Carpeta contenedora de procesos',1,0,1,NULL),(27,'configuration','','Carpeta contenedora de configuraciones de uniweb',1,0,1,NULL),(28,'audit','auditLayout','Consulta de log de auditoría',1,0,1,NULL),(29,'transactActivityAddresseeLayout','transactActivityAddresseeLayout','',1,1,2,1),(30,'Carga de datos','tabsLayout','',1,1,2,1),(31,'controlConsoleLayout','controlConsoleLayout','',1,1,2,1),(32,'Alta de cliente','newClientRegisterLayout','',1,1,2,1),(33,'documentaryManagerLayout','documentaryManagerLayout','',1,1,2,1);
450/*!40000 ALTER TABLE `functionality` ENABLE KEYS */;
451UNLOCK TABLES;
452
453--
454-- Table structure for table `functionality_node`
455--
456
457DROP TABLE IF EXISTS `functionality_node`;
458/*!40101 SET @saved_cs_client     = @@character_set_client */;
459 SET character_set_client = utf8mb4 ;
460CREATE TABLE `functionality_node` (
461  `id` bigint(20) NOT NULL AUTO_INCREMENT,
462  `name` varchar(255) NOT NULL,
463  `icon` varchar(255) NOT NULL,
464  `leaf` tinyint(1) DEFAULT NULL,
465  `node_order` bigint(20) DEFAULT NULL,
466  `functionality` bigint(20) DEFAULT NULL,
467  `organization` bigint(20) DEFAULT NULL,
468  `parent` bigint(20) DEFAULT NULL,
469  PRIMARY KEY (`id`),
470  KEY `FK_n7b8t14eev8wxaayns9yd7p36` (`functionality`),
471  KEY `FK_ooiensbh24x68ctmip50hjy2a` (`organization`),
472  KEY `FK_b04wf0ntwaul73ne5vwqwhwfw` (`parent`),
473  CONSTRAINT `FK_b04wf0ntwaul73ne5vwqwhwfw` FOREIGN KEY (`parent`) REFERENCES `functionality_node` (`id`),
474  CONSTRAINT `FK_n7b8t14eev8wxaayns9yd7p36` FOREIGN KEY (`functionality`) REFERENCES `functionality` (`id`),
475  CONSTRAINT `FK_ooiensbh24x68ctmip50hjy2a` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`)
476) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
477/*!40101 SET character_set_client = @saved_cs_client */;
478
479--
480-- Dumping data for table `functionality_node`
481--
482
483LOCK TABLES `functionality_node` WRITE;
484/*!40000 ALTER TABLE `functionality_node` DISABLE KEYS */;
485INSERT INTO `functionality_node` VALUES (1,'user','USER',1,1,5,NULL,NULL),(2,'organization','BRIEFCASE',1,2,6,NULL,NULL),(3,'permission','KEY',0,3,NULL,NULL,NULL),(4,'role','SITEMAP',1,1,7,NULL,3),(5,'group','GROUP',1,2,8,NULL,3),(6,'application','DESKTOP',0,4,NULL,NULL,NULL),(7,'context','CUBES',1,1,21,NULL,6),(8,'functionality','MAGIC',1,2,9,NULL,6),(9,'vision','EYE',1,3,10,NULL,6),(10,'menu','BARS',1,4,12,NULL,6),(11,'link','LINK',1,5,11,NULL,6),(12,'content','OBJECT_GROUP',0,5,NULL,NULL,NULL),(13,'publicity','IMAGE',1,1,13,NULL,12),(14,'messaging','ENVELOPE',0,6,NULL,NULL,NULL),(15,'inbox','INBOX',1,1,14,NULL,14),(16,'notification','BELL_O',1,2,15,NULL,14),(17,'workflowInbox','CODE_FORK',1,3,16,NULL,14),(18,'processes','PUZZLE_PIECE',0,7,NULL,NULL,NULL),(19,'workflowproc','CODE_FORK',1,1,20,NULL,18),(20,'navigator','TH',1,2,17,NULL,18),(21,'navigable','TH',1,3,18,NULL,18),(22,'nodes','TH',1,4,19,NULL,18),(23,'configuration','COG',0,8,NULL,NULL,NULL),(24,'language','LANGUAGE',1,1,4,NULL,23),(25,'security','LOCK',1,2,3,NULL,23),(26,'export','SIGN_OUT',1,3,2,NULL,23),(27,'importconf','SIGN_IN',1,4,1,NULL,23),(28,'audit','CLIPBOARD',1,9,28,NULL,NULL),(29,'destinatarios','ENVELOPE_SQUARE',1,5,29,1,NULL),(30,'Carga de datos','ALIGN_JUSTIFY',1,7,30,1,NULL),(31,'consola de control','ALIGN_JUSTIFY',1,1,31,1,NULL),(32,'Alta de cliente','USER_PLUS',1,3,32,1,NULL),(33,'Documentos','DOT_CIRCLE_O',1,8,33,1,NULL);
486/*!40000 ALTER TABLE `functionality_node` ENABLE KEYS */;
487UNLOCK TABLES;
488
489--
490-- Table structure for table `functionalitylink`
491--
492
493DROP TABLE IF EXISTS `functionalitylink`;
494/*!40101 SET @saved_cs_client     = @@character_set_client */;
495 SET character_set_client = utf8mb4 ;
496CREATE TABLE `functionalitylink` (
497  `id` bigint(20) NOT NULL AUTO_INCREMENT,
498  `name` varchar(255) NOT NULL,
499  `icon` varchar(255) DEFAULT NULL,
500  `popup` tinyint(1) DEFAULT NULL,
501  `sourceComponent` bigint(20) DEFAULT NULL,
502  `sourceFunctionality` bigint(20) NOT NULL,
503  `targetFunctionality` bigint(20) DEFAULT NULL,
504  PRIMARY KEY (`id`),
505  KEY `FK_g62ttv47dcgxb6gke2n7j16j6` (`sourceComponent`),
506  KEY `FK_9lo070ey9sfkvlc13pykenj90` (`sourceFunctionality`),
507  KEY `FK_tlck82m38h8qwnhr8ax8mm5ig` (`targetFunctionality`),
508  CONSTRAINT `FK_9lo070ey9sfkvlc13pykenj90` FOREIGN KEY (`sourceFunctionality`) REFERENCES `functionality` (`id`),
509  CONSTRAINT `FK_g62ttv47dcgxb6gke2n7j16j6` FOREIGN KEY (`sourceComponent`) REFERENCES `component` (`id`),
510  CONSTRAINT `FK_tlck82m38h8qwnhr8ax8mm5ig` FOREIGN KEY (`targetFunctionality`) REFERENCES `functionality` (`id`)
511) ENGINE=InnoDB DEFAULT CHARSET=utf8;
512/*!40101 SET character_set_client = @saved_cs_client */;
513
514--
515-- Dumping data for table `functionalitylink`
516--
517
518LOCK TABLES `functionalitylink` WRITE;
519/*!40000 ALTER TABLE `functionalitylink` DISABLE KEYS */;
520/*!40000 ALTER TABLE `functionalitylink` ENABLE KEYS */;
521UNLOCK TABLES;
522
523--
524-- Table structure for table `group`
525--
526
527DROP TABLE IF EXISTS `group`;
528/*!40101 SET @saved_cs_client     = @@character_set_client */;
529 SET character_set_client = utf8mb4 ;
530CREATE TABLE `group` (
531  `id` bigint(20) NOT NULL AUTO_INCREMENT,
532  `name` varchar(255) NOT NULL,
533  `description` varchar(255) DEFAULT NULL,
534  `enabled` tinyint(1) NOT NULL,
535  `organization` bigint(20) NOT NULL,
536  PRIMARY KEY (`id`),
537  KEY `FK_3v86ee1srlftbi4bpj3pirj2s` (`organization`),
538  CONSTRAINT `FK_3v86ee1srlftbi4bpj3pirj2s` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`)
539) ENGINE=InnoDB DEFAULT CHARSET=utf8;
540/*!40101 SET character_set_client = @saved_cs_client */;
541
542--
543-- Dumping data for table `group`
544--
545
546LOCK TABLES `group` WRITE;
547/*!40000 ALTER TABLE `group` DISABLE KEYS */;
548/*!40000 ALTER TABLE `group` ENABLE KEYS */;
549UNLOCK TABLES;
550
551--
552-- Table structure for table `inbox`
553--
554
555DROP TABLE IF EXISTS `inbox`;
556/*!40101 SET @saved_cs_client     = @@character_set_client */;
557 SET character_set_client = utf8mb4 ;
558CREATE TABLE `inbox` (
559  `id` bigint(20) NOT NULL AUTO_INCREMENT,
560  `name` varchar(255) NOT NULL,
561  `bean` varchar(255) DEFAULT NULL,
562  `icon` varchar(255) DEFAULT NULL,
563  `timer` bigint(20) DEFAULT NULL,
564  `appearance` bigint(20) NOT NULL,
565  `context` bigint(20) DEFAULT NULL,
566  `navigator` bigint(20) DEFAULT NULL,
567  `organization` bigint(20) NOT NULL,
568  PRIMARY KEY (`id`),
569  KEY `FK_pp9bd78d1gx7e1hus9d52m55x` (`appearance`),
570  KEY `FK_3bmcc4yh9kf1wf6gvspviif31` (`context`),
571  KEY `FK_aloslau7aifmlyy1gddfa8rx0` (`navigator`),
572  KEY `FK_iw1swltv2qicntrfa67f8eefp` (`organization`),
573  CONSTRAINT `FK_3bmcc4yh9kf1wf6gvspviif31` FOREIGN KEY (`context`) REFERENCES `context` (`id`),
574  CONSTRAINT `FK_aloslau7aifmlyy1gddfa8rx0` FOREIGN KEY (`navigator`) REFERENCES `navigator` (`id`),
575  CONSTRAINT `FK_iw1swltv2qicntrfa67f8eefp` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`),
576  CONSTRAINT `FK_pp9bd78d1gx7e1hus9d52m55x` FOREIGN KEY (`appearance`) REFERENCES `appearance` (`id`)
577) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
578/*!40101 SET character_set_client = @saved_cs_client */;
579
580--
581-- Dumping data for table `inbox`
582--
583
584LOCK TABLES `inbox` WRITE;
585/*!40000 ALTER TABLE `inbox` DISABLE KEYS */;
586INSERT INTO `inbox` VALUES (1,'workflow','workflowMessageProvider','CODE_FORK',60000,5,1,NULL,1);
587/*!40000 ALTER TABLE `inbox` ENABLE KEYS */;
588UNLOCK TABLES;
589
590--
591-- Table structure for table `inbox_presentation`
592--
593
594DROP TABLE IF EXISTS `inbox_presentation`;
595/*!40101 SET @saved_cs_client     = @@character_set_client */;
596 SET character_set_client = utf8mb4 ;
597CREATE TABLE `inbox_presentation` (
598  `inbox_id` bigint(20) NOT NULL,
599  `presentation_id` bigint(20) NOT NULL,
600  PRIMARY KEY (`inbox_id`,`presentation_id`),
601  KEY `FK_qt5llnm8hniiuupmtlmkhntqc` (`presentation_id`),
602  KEY `FK_qvuwwiaskue3k49mw4l1midan` (`inbox_id`),
603  CONSTRAINT `FK_qt5llnm8hniiuupmtlmkhntqc` FOREIGN KEY (`presentation_id`) REFERENCES `presentation` (`id`),
604  CONSTRAINT `FK_qvuwwiaskue3k49mw4l1midan` FOREIGN KEY (`inbox_id`) REFERENCES `inbox` (`id`)
605) ENGINE=InnoDB DEFAULT CHARSET=utf8;
606/*!40101 SET character_set_client = @saved_cs_client */;
607
608--
609-- Dumping data for table `inbox_presentation`
610--
611
612LOCK TABLES `inbox_presentation` WRITE;
613/*!40000 ALTER TABLE `inbox_presentation` DISABLE KEYS */;
614INSERT INTO `inbox_presentation` VALUES (1,1);
615/*!40000 ALTER TABLE `inbox_presentation` ENABLE KEYS */;
616UNLOCK TABLES;
617
618--
619-- Table structure for table `inbox_role`
620--
621
622DROP TABLE IF EXISTS `inbox_role`;
623/*!40101 SET @saved_cs_client     = @@character_set_client */;
624 SET character_set_client = utf8mb4 ;
625CREATE TABLE `inbox_role` (
626  `inbox_id` bigint(20) NOT NULL,
627  `role_id` bigint(20) NOT NULL,
628  PRIMARY KEY (`inbox_id`,`role_id`),
629  KEY `FK_7bqkswu211m9hvny7dmwh4h67` (`role_id`),
630  KEY `FK_j222293c3ihc7ggj7wv5bc3wd` (`inbox_id`),
631  CONSTRAINT `FK_7bqkswu211m9hvny7dmwh4h67` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
632  CONSTRAINT `FK_j222293c3ihc7ggj7wv5bc3wd` FOREIGN KEY (`inbox_id`) REFERENCES `inbox` (`id`)
633) ENGINE=InnoDB DEFAULT CHARSET=utf8;
634/*!40101 SET character_set_client = @saved_cs_client */;
635
636--
637-- Dumping data for table `inbox_role`
638--
639
640LOCK TABLES `inbox_role` WRITE;
641/*!40000 ALTER TABLE `inbox_role` DISABLE KEYS */;
642INSERT INTO `inbox_role` VALUES (1,6),(1,7),(1,8),(1,9);
643/*!40000 ALTER TABLE `inbox_role` ENABLE KEYS */;
644UNLOCK TABLES;
645
646--
647-- Table structure for table `inboxlink`
648--
649
650DROP TABLE IF EXISTS `inboxlink`;
651/*!40101 SET @saved_cs_client     = @@character_set_client */;
652 SET character_set_client = utf8mb4 ;
653CREATE TABLE `inboxlink` (
654  `id` bigint(20) NOT NULL AUTO_INCREMENT,
655  `name` varchar(255) NOT NULL,
656  `attribute_name` varchar(255) DEFAULT NULL,
657  `attribute_value` varchar(255) DEFAULT NULL,
658  `external` tinyint(1) DEFAULT NULL,
659  `icon` varchar(255) DEFAULT NULL,
660  `popup` tinyint(1) DEFAULT NULL,
661  `functionality` bigint(20) DEFAULT NULL,
662  `inbox` bigint(20) DEFAULT NULL,
663  `navigable` bigint(20) DEFAULT NULL,
664  PRIMARY KEY (`id`),
665  KEY `FK_s6nyca4ls169ydfrjsbdx1l5b` (`functionality`),
666  KEY `FK_pjmj9k7qlon6uk8s0vxl21u6u` (`inbox`),
667  KEY `FK_pfw4io3tf10nqpegrhraqve0n` (`navigable`),
668  CONSTRAINT `FK_pfw4io3tf10nqpegrhraqve0n` FOREIGN KEY (`navigable`) REFERENCES `navigable` (`id`),
669  CONSTRAINT `FK_pjmj9k7qlon6uk8s0vxl21u6u` FOREIGN KEY (`inbox`) REFERENCES `inbox` (`id`),
670  CONSTRAINT `FK_s6nyca4ls169ydfrjsbdx1l5b` FOREIGN KEY (`functionality`) REFERENCES `functionality` (`id`)
671) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
672/*!40101 SET character_set_client = @saved_cs_client */;
673
674--
675-- Dumping data for table `inboxlink`
676--
677
678LOCK TABLES `inboxlink` WRITE;
679/*!40000 ALTER TABLE `inboxlink` DISABLE KEYS */;
680INSERT INTO `inboxlink` VALUES (2,'Carga de datos','functionality','Carga de datos',0,NULL,1,30,1,NULL);
681/*!40000 ALTER TABLE `inboxlink` ENABLE KEYS */;
682UNLOCK TABLES;
683
684--
685-- Table structure for table `internationalization`
686--
687
688DROP TABLE IF EXISTS `internationalization`;
689/*!40101 SET @saved_cs_client     = @@character_set_client */;
690 SET character_set_client = utf8mb4 ;
691CREATE TABLE `internationalization` (
692  `id` bigint(20) NOT NULL AUTO_INCREMENT,
693  `name` varchar(255) NOT NULL,
694  `country` varchar(255) NOT NULL,
695  `language` varchar(255) NOT NULL,
696  PRIMARY KEY (`id`),
697  UNIQUE KEY `UK_hjb10cm4s12ax4i1ohvpyl709` (`name`)
698) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
699/*!40101 SET character_set_client = @saved_cs_client */;
700
701--
702-- Dumping data for table `internationalization`
703--
704
705LOCK TABLES `internationalization` WRITE;
706/*!40000 ALTER TABLE `internationalization` DISABLE KEYS */;
707INSERT INTO `internationalization` VALUES (1,'Español','AR','es');
708/*!40000 ALTER TABLE `internationalization` ENABLE KEYS */;
709UNLOCK TABLES;
710
711--
712-- Table structure for table `login`
713--
714
715DROP TABLE IF EXISTS `login`;
716/*!40101 SET @saved_cs_client     = @@character_set_client */;
717 SET character_set_client = utf8mb4 ;
718CREATE TABLE `login` (
719  `id` bigint(20) NOT NULL AUTO_INCREMENT,
720  `automatic` tinyint(1) NOT NULL,
721  `organization` bigint(20) DEFAULT NULL,
722  PRIMARY KEY (`id`),
723  KEY `FK_fj1ttm5ph5f1vn2kng3r4afu` (`organization`),
724  CONSTRAINT `FK_fj1ttm5ph5f1vn2kng3r4afu` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`)
725) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
726/*!40101 SET character_set_client = @saved_cs_client */;
727
728--
729-- Dumping data for table `login`
730--
731
732LOCK TABLES `login` WRITE;
733/*!40000 ALTER TABLE `login` DISABLE KEYS */;
734INSERT INTO `login` VALUES (1,0,1);
735/*!40000 ALTER TABLE `login` ENABLE KEYS */;
736UNLOCK TABLES;
737
738--
739-- Table structure for table `navigable`
740--
741
742DROP TABLE IF EXISTS `navigable`;
743/*!40101 SET @saved_cs_client     = @@character_set_client */;
744 SET character_set_client = utf8mb4 ;
745CREATE TABLE `navigable` (
746  `id` bigint(20) NOT NULL AUTO_INCREMENT,
747  `name` varchar(255) DEFAULT NULL,
748  `bean` varchar(255) DEFAULT NULL,
749  `enabled` tinyint(1) DEFAULT NULL,
750  `navOrder` int(11) NOT NULL,
751  `context` bigint(20) DEFAULT NULL,
752  `navigator` bigint(20) NOT NULL,
753  PRIMARY KEY (`id`),
754  KEY `FK_s83polww22pjoqwjnl2tt6mju` (`context`),
755  KEY `FK_l16bmaai0ikhhu5809m47jmyf` (`navigator`),
756  CONSTRAINT `FK_l16bmaai0ikhhu5809m47jmyf` FOREIGN KEY (`navigator`) REFERENCES `navigator` (`id`),
757  CONSTRAINT `FK_s83polww22pjoqwjnl2tt6mju` FOREIGN KEY (`context`) REFERENCES `context` (`id`)
758) ENGINE=InnoDB DEFAULT CHARSET=utf8;
759/*!40101 SET character_set_client = @saved_cs_client */;
760
761--
762-- Dumping data for table `navigable`
763--
764
765LOCK TABLES `navigable` WRITE;
766/*!40000 ALTER TABLE `navigable` DISABLE KEYS */;
767/*!40000 ALTER TABLE `navigable` ENABLE KEYS */;
768UNLOCK TABLES;
769
770--
771-- Table structure for table `navigable_node`
772--
773
774DROP TABLE IF EXISTS `navigable_node`;
775/*!40101 SET @saved_cs_client     = @@character_set_client */;
776 SET character_set_client = utf8mb4 ;
777CREATE TABLE `navigable_node` (
778  `id` bigint(20) NOT NULL AUTO_INCREMENT,
779  `name` varchar(255) NOT NULL,
780  `background_color` varchar(255) DEFAULT NULL,
781  `font_color` varchar(255) DEFAULT NULL,
782  `icon` varchar(255) NOT NULL,
783  `leaf` tinyint(1) DEFAULT NULL,
784  `node_order` bigint(20) DEFAULT NULL,
785  `functionality` bigint(20) DEFAULT NULL,
786  `navigator` bigint(20) DEFAULT NULL,
787  `parent` bigint(20) DEFAULT NULL,
788  PRIMARY KEY (`id`),
789  KEY `FK_4lg14gw4qy6bt47ac79ws2pyq` (`functionality`),
790  KEY `FK_5289fp3sf7a7x01rr8hti1xn3` (`navigator`),
791  KEY `FK_9w5teumhv3chjw92jrqir0vf4` (`parent`),
792  CONSTRAINT `FK_4lg14gw4qy6bt47ac79ws2pyq` FOREIGN KEY (`functionality`) REFERENCES `functionality` (`id`),
793  CONSTRAINT `FK_5289fp3sf7a7x01rr8hti1xn3` FOREIGN KEY (`navigator`) REFERENCES `navigator` (`id`),
794  CONSTRAINT `FK_9w5teumhv3chjw92jrqir0vf4` FOREIGN KEY (`parent`) REFERENCES `navigable_node` (`id`)
795) ENGINE=InnoDB DEFAULT CHARSET=utf8;
796/*!40101 SET character_set_client = @saved_cs_client */;
797
798--
799-- Dumping data for table `navigable_node`
800--
801
802LOCK TABLES `navigable_node` WRITE;
803/*!40000 ALTER TABLE `navigable_node` DISABLE KEYS */;
804/*!40000 ALTER TABLE `navigable_node` ENABLE KEYS */;
805UNLOCK TABLES;
806
807--
808-- Table structure for table `navigator`
809--
810
811DROP TABLE IF EXISTS `navigator`;
812/*!40101 SET @saved_cs_client     = @@character_set_client */;
813 SET character_set_client = utf8mb4 ;
814CREATE TABLE `navigator` (
815  `id` bigint(20) NOT NULL AUTO_INCREMENT,
816  `name` varchar(255) NOT NULL,
817  `bean` varchar(255) DEFAULT NULL,
818  `enabled` tinyint(1) NOT NULL,
819  `groupers` tinyint(1) DEFAULT NULL,
820  `icon` varchar(255) DEFAULT NULL,
821  `context` bigint(20) DEFAULT NULL,
822  `organization` bigint(20) NOT NULL,
823  PRIMARY KEY (`id`),
824  KEY `FK_ovd7ow9vta93wql66o0dh4uih` (`context`),
825  KEY `FK_ree5kier173fhpd14gcrbiwex` (`organization`),
826  CONSTRAINT `FK_ovd7ow9vta93wql66o0dh4uih` FOREIGN KEY (`context`) REFERENCES `context` (`id`),
827  CONSTRAINT `FK_ree5kier173fhpd14gcrbiwex` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`)
828) ENGINE=InnoDB DEFAULT CHARSET=utf8;
829/*!40101 SET character_set_client = @saved_cs_client */;
830
831--
832-- Dumping data for table `navigator`
833--
834
835LOCK TABLES `navigator` WRITE;
836/*!40000 ALTER TABLE `navigator` DISABLE KEYS */;
837/*!40000 ALTER TABLE `navigator` ENABLE KEYS */;
838UNLOCK TABLES;
839
840--
841-- Table structure for table `navigator_role`
842--
843
844DROP TABLE IF EXISTS `navigator_role`;
845/*!40101 SET @saved_cs_client     = @@character_set_client */;
846 SET character_set_client = utf8mb4 ;
847CREATE TABLE `navigator_role` (
848  `navigator_id` bigint(20) NOT NULL,
849  `role_id` bigint(20) NOT NULL,
850  PRIMARY KEY (`navigator_id`,`role_id`),
851  KEY `FK_5dlsa18i3y7d3my5qadjy5l5m` (`role_id`),
852  KEY `FK_nrqxvbqxknd0ibu0fewy9ayka` (`navigator_id`),
853  CONSTRAINT `FK_5dlsa18i3y7d3my5qadjy5l5m` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
854  CONSTRAINT `FK_nrqxvbqxknd0ibu0fewy9ayka` FOREIGN KEY (`navigator_id`) REFERENCES `navigator` (`id`)
855) ENGINE=InnoDB DEFAULT CHARSET=utf8;
856/*!40101 SET character_set_client = @saved_cs_client */;
857
858--
859-- Dumping data for table `navigator_role`
860--
861
862LOCK TABLES `navigator_role` WRITE;
863/*!40000 ALTER TABLE `navigator_role` DISABLE KEYS */;
864/*!40000 ALTER TABLE `navigator_role` ENABLE KEYS */;
865UNLOCK TABLES;
866
867--
868-- Table structure for table `organization`
869--
870
871DROP TABLE IF EXISTS `organization`;
872/*!40101 SET @saved_cs_client     = @@character_set_client */;
873 SET character_set_client = utf8mb4 ;
874CREATE TABLE `organization` (
875  `id` bigint(20) NOT NULL AUTO_INCREMENT,
876  `name` varchar(255) NOT NULL,
877  `description` varchar(255) DEFAULT NULL,
878  `enabled` tinyint(1) NOT NULL,
879  `path` varchar(255) NOT NULL,
880  `template` bigint(20) NOT NULL,
881  PRIMARY KEY (`id`),
882  UNIQUE KEY `UK_8j5y8ipk73yx2joy9yr653c9t` (`name`),
883  UNIQUE KEY `UK_e90f3oe2c1i6ua915ss9975if` (`path`),
884  KEY `FK_3kf2aj9i8hms54i4x34waau9c` (`template`),
885  CONSTRAINT `FK_3kf2aj9i8hms54i4x34waau9c` FOREIGN KEY (`template`) REFERENCES `template` (`id`)
886) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
887/*!40101 SET character_set_client = @saved_cs_client */;
888
889--
890-- Dumping data for table `organization`
891--
892
893LOCK TABLES `organization` WRITE;
894/*!40000 ALTER TABLE `organization` DISABLE KEYS */;
895INSERT INTO `organization` VALUES (1,'facebank','',1,'facebank',2);
896/*!40000 ALTER TABLE `organization` ENABLE KEYS */;
897UNLOCK TABLES;
898
899--
900-- Table structure for table `organization_internationalization`
901--
902
903DROP TABLE IF EXISTS `organization_internationalization`;
904/*!40101 SET @saved_cs_client     = @@character_set_client */;
905 SET character_set_client = utf8mb4 ;
906CREATE TABLE `organization_internationalization` (
907  `id` bigint(20) NOT NULL AUTO_INCREMENT,
908  `is_default` tinyint(1) NOT NULL,
909  `internationalization` bigint(20) NOT NULL,
910  `organization` bigint(20) DEFAULT NULL,
911  PRIMARY KEY (`id`),
912  KEY `FK_5wacjur00j4l8wsdsl8fv2a12` (`internationalization`),
913  KEY `FK_cyw3tuwjhydka9a2lrmb4emov` (`organization`),
914  CONSTRAINT `FK_5wacjur00j4l8wsdsl8fv2a12` FOREIGN KEY (`internationalization`) REFERENCES `internationalization` (`id`),
915  CONSTRAINT `FK_cyw3tuwjhydka9a2lrmb4emov` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`)
916) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
917/*!40101 SET character_set_client = @saved_cs_client */;
918
919--
920-- Dumping data for table `organization_internationalization`
921--
922
923LOCK TABLES `organization_internationalization` WRITE;
924/*!40000 ALTER TABLE `organization_internationalization` DISABLE KEYS */;
925INSERT INTO `organization_internationalization` VALUES (1,1,1,NULL),(3,1,1,1);
926/*!40000 ALTER TABLE `organization_internationalization` ENABLE KEYS */;
927UNLOCK TABLES;
928
929--
930-- Table structure for table `pass`
931--
932
933DROP TABLE IF EXISTS `pass`;
934/*!40101 SET @saved_cs_client     = @@character_set_client */;
935 SET character_set_client = utf8mb4 ;
936CREATE TABLE `pass` (
937  `id` bigint(20) NOT NULL AUTO_INCREMENT,
938  `created` bigint(20) NOT NULL,
939  `hash` varchar(255) NOT NULL,
940  `reset` tinyint(1) NOT NULL,
941  `user_id` bigint(20) NOT NULL,
942  PRIMARY KEY (`id`),
943  KEY `FK_8e1hbf76qrk23464o8ay73ghm` (`user_id`),
944  CONSTRAINT `FK_8e1hbf76qrk23464o8ay73ghm` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
945) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
946/*!40101 SET character_set_client = @saved_cs_client */;
947
948--
949-- Dumping data for table `pass`
950--
951
952LOCK TABLES `pass` WRITE;
953/*!40000 ALTER TABLE `pass` DISABLE KEYS */;
954INSERT INTO `pass` VALUES (3,1563379367437,'+g3Iw5iTLfE=',1,2),(4,1563379394135,'a9Xcw9LkMh4=',0,2),(5,1563379394136,'hCqfZ1HjyaljniB3qnNNTA==',1,3),(10,1563479741287,'a9Xcw9LkMh4=',0,3),(11,1563479741288,'hCqfZ1HjyaljniB3qnNNTA==',1,4),(12,1563479741289,'hCqfZ1HjyaljniB3qnNNTA==',1,5),(13,1563560963484,'a9Xcw9LkMh4=',0,4),(14,1563560963485,'hCqfZ1HjyaljniB3qnNNTA==',1,6),(15,1563568437957,'a9Xcw9LkMh4=',0,6);
955/*!40000 ALTER TABLE `pass` ENABLE KEYS */;
956UNLOCK TABLES;
957
958--
959-- Table structure for table `presentation`
960--
961
962DROP TABLE IF EXISTS `presentation`;
963/*!40101 SET @saved_cs_client     = @@character_set_client */;
964 SET character_set_client = utf8mb4 ;
965CREATE TABLE `presentation` (
966  `id` bigint(20) NOT NULL AUTO_INCREMENT,
967  `name` varchar(255) NOT NULL,
968  PRIMARY KEY (`id`),
969  UNIQUE KEY `UK_dit9ap1o6nyujn0ujrjjwj0ok` (`name`)
970) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
971/*!40101 SET character_set_client = @saved_cs_client */;
972
973--
974-- Dumping data for table `presentation`
975--
976
977LOCK TABLES `presentation` WRITE;
978/*!40000 ALTER TABLE `presentation` DISABLE KEYS */;
979INSERT INTO `presentation` VALUES (1,'desktop'),(2,'mobile');
980/*!40000 ALTER TABLE `presentation` ENABLE KEYS */;
981UNLOCK TABLES;
982
983--
984-- Table structure for table `process`
985--
986
987DROP TABLE IF EXISTS `process`;
988/*!40101 SET @saved_cs_client     = @@character_set_client */;
989 SET character_set_client = utf8mb4 ;
990CREATE TABLE `process` (
991  `id` bigint(20) NOT NULL AUTO_INCREMENT,
992  `name` varchar(255) DEFAULT NULL,
993  `description` varchar(255) DEFAULT NULL,
994  `key` varchar(255) NOT NULL,
995  `path` varchar(255) NOT NULL,
996  `reference` varchar(255) NOT NULL,
997  `organization` bigint(20) DEFAULT NULL,
998  PRIMARY KEY (`id`),
999  KEY `FK_iveolbfh9dptgirv4hnkp5lw6` (`organization`),
1000  CONSTRAINT `FK_iveolbfh9dptgirv4hnkp5lw6` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`)
1001) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1002/*!40101 SET character_set_client = @saved_cs_client */;
1003
1004--
1005-- Dumping data for table `process`
1006--
1007
1008LOCK TABLES `process` WRITE;
1009/*!40000 ALTER TABLE `process` DISABLE KEYS */;
1010INSERT INTO `process` VALUES (2,'Alta_de_cliente','','Alta_de_clientes','1563460727297_Alta_de_clientes.bpmn20.xml','2501',1);
1011/*!40000 ALTER TABLE `process` ENABLE KEYS */;
1012UNLOCK TABLES;
1013
1014--
1015-- Table structure for table `profile`
1016--
1017
1018DROP TABLE IF EXISTS `profile`;
1019/*!40101 SET @saved_cs_client     = @@character_set_client */;
1020 SET character_set_client = utf8mb4 ;
1021CREATE TABLE `profile` (
1022  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1023  `name` varchar(255) DEFAULT NULL,
1024  PRIMARY KEY (`id`)
1025) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
1026/*!40101 SET character_set_client = @saved_cs_client */;
1027
1028--
1029-- Dumping data for table `profile`
1030--
1031
1032LOCK TABLES `profile` WRITE;
1033/*!40000 ALTER TABLE `profile` DISABLE KEYS */;
1034INSERT INTO `profile` VALUES (2,NULL),(5,NULL),(6,NULL),(7,NULL),(8,NULL),(9,NULL),(10,NULL),(11,NULL);
1035/*!40000 ALTER TABLE `profile` ENABLE KEYS */;
1036UNLOCK TABLES;
1037
1038--
1039-- Table structure for table `profile_organization_internationalization`
1040--
1041
1042DROP TABLE IF EXISTS `profile_organization_internationalization`;
1043/*!40101 SET @saved_cs_client     = @@character_set_client */;
1044 SET character_set_client = utf8mb4 ;
1045CREATE TABLE `profile_organization_internationalization` (
1046  `profile_id` bigint(20) NOT NULL,
1047  `organization_internationalization_id` bigint(20) NOT NULL,
1048  PRIMARY KEY (`profile_id`,`organization_internationalization_id`),
1049  KEY `FK_f4wmlv1f3ypaap232pr490te2` (`organization_internationalization_id`),
1050  KEY `FK_ilp9oi3ey2xij24gu2237xqsl` (`profile_id`),
1051  CONSTRAINT `FK_f4wmlv1f3ypaap232pr490te2` FOREIGN KEY (`organization_internationalization_id`) REFERENCES `organization_internationalization` (`id`),
1052  CONSTRAINT `FK_ilp9oi3ey2xij24gu2237xqsl` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`)
1053) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1054/*!40101 SET character_set_client = @saved_cs_client */;
1055
1056--
1057-- Dumping data for table `profile_organization_internationalization`
1058--
1059
1060LOCK TABLES `profile_organization_internationalization` WRITE;
1061/*!40000 ALTER TABLE `profile_organization_internationalization` DISABLE KEYS */;
1062/*!40000 ALTER TABLE `profile_organization_internationalization` ENABLE KEYS */;
1063UNLOCK TABLES;
1064
1065--
1066-- Table structure for table `publicity`
1067--
1068
1069DROP TABLE IF EXISTS `publicity`;
1070/*!40101 SET @saved_cs_client     = @@character_set_client */;
1071 SET character_set_client = utf8mb4 ;
1072CREATE TABLE `publicity` (
1073  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1074  `name` varchar(255) NOT NULL,
1075  `path` varchar(255) NOT NULL,
1076  `timer` bigint(20) DEFAULT NULL,
1077  `organization` bigint(20) NOT NULL,
1078  PRIMARY KEY (`id`),
1079  KEY `FK_arn40mewxdxw97lfgfqmjf6w5` (`organization`),
1080  CONSTRAINT `FK_arn40mewxdxw97lfgfqmjf6w5` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`)
1081) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1082/*!40101 SET character_set_client = @saved_cs_client */;
1083
1084--
1085-- Dumping data for table `publicity`
1086--
1087
1088LOCK TABLES `publicity` WRITE;
1089/*!40000 ALTER TABLE `publicity` DISABLE KEYS */;
1090/*!40000 ALTER TABLE `publicity` ENABLE KEYS */;
1091UNLOCK TABLES;
1092
1093--
1094-- Table structure for table `publicity_presentation`
1095--
1096
1097DROP TABLE IF EXISTS `publicity_presentation`;
1098/*!40101 SET @saved_cs_client     = @@character_set_client */;
1099 SET character_set_client = utf8mb4 ;
1100CREATE TABLE `publicity_presentation` (
1101  `publicity_id` bigint(20) NOT NULL,
1102  `presentation_id` bigint(20) NOT NULL,
1103  PRIMARY KEY (`publicity_id`,`presentation_id`),
1104  KEY `FK_52fvwuxj0kt3uyysmimshgr8u` (`presentation_id`),
1105  KEY `FK_4mydjub399lukdf760emnolx5` (`publicity_id`),
1106  CONSTRAINT `FK_4mydjub399lukdf760emnolx5` FOREIGN KEY (`publicity_id`) REFERENCES `publicity` (`id`),
1107  CONSTRAINT `FK_52fvwuxj0kt3uyysmimshgr8u` FOREIGN KEY (`presentation_id`) REFERENCES `presentation` (`id`)
1108) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1109/*!40101 SET character_set_client = @saved_cs_client */;
1110
1111--
1112-- Dumping data for table `publicity_presentation`
1113--
1114
1115LOCK TABLES `publicity_presentation` WRITE;
1116/*!40000 ALTER TABLE `publicity_presentation` DISABLE KEYS */;
1117/*!40000 ALTER TABLE `publicity_presentation` ENABLE KEYS */;
1118UNLOCK TABLES;
1119
1120--
1121-- Table structure for table `publicity_role`
1122--
1123
1124DROP TABLE IF EXISTS `publicity_role`;
1125/*!40101 SET @saved_cs_client     = @@character_set_client */;
1126 SET character_set_client = utf8mb4 ;
1127CREATE TABLE `publicity_role` (
1128  `publicity_id` bigint(20) NOT NULL,
1129  `role_id` bigint(20) NOT NULL,
1130  PRIMARY KEY (`publicity_id`,`role_id`),
1131  KEY `FK_4gjpfn9s6qb1iyr8xenkv4350` (`role_id`),
1132  KEY `FK_oahvtx13x7jxuy19jade0svw1` (`publicity_id`),
1133  CONSTRAINT `FK_4gjpfn9s6qb1iyr8xenkv4350` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
1134  CONSTRAINT `FK_oahvtx13x7jxuy19jade0svw1` FOREIGN KEY (`publicity_id`) REFERENCES `publicity` (`id`)
1135) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1136/*!40101 SET character_set_client = @saved_cs_client */;
1137
1138--
1139-- Dumping data for table `publicity_role`
1140--
1141
1142LOCK TABLES `publicity_role` WRITE;
1143/*!40000 ALTER TABLE `publicity_role` DISABLE KEYS */;
1144/*!40000 ALTER TABLE `publicity_role` ENABLE KEYS */;
1145UNLOCK TABLES;
1146
1147--
1148-- Table structure for table `role`
1149--
1150
1151DROP TABLE IF EXISTS `role`;
1152/*!40101 SET @saved_cs_client     = @@character_set_client */;
1153 SET character_set_client = utf8mb4 ;
1154CREATE TABLE `role` (
1155  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1156  `name` varchar(255) NOT NULL,
1157  `description` varchar(255) DEFAULT NULL,
1158  `enabled` tinyint(1) NOT NULL,
1159  `organization` bigint(20) DEFAULT NULL,
1160  `organizationLogin` bigint(20) DEFAULT NULL,
1161  PRIMARY KEY (`id`),
1162  KEY `FK_9kvx4q0ygmqy7k5mp3vnwdcsx` (`organization`),
1163  KEY `FK_sdhkerum5dajqcixlo8xljsnn` (`organizationLogin`),
1164  CONSTRAINT `FK_9kvx4q0ygmqy7k5mp3vnwdcsx` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`),
1165  CONSTRAINT `FK_sdhkerum5dajqcixlo8xljsnn` FOREIGN KEY (`organizationLogin`) REFERENCES `login` (`id`)
1166) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
1167/*!40101 SET character_set_client = @saved_cs_client */;
1168
1169--
1170-- Dumping data for table `role`
1171--
1172
1173LOCK TABLES `role` WRITE;
1174/*!40000 ALTER TABLE `role` DISABLE KEYS */;
1175INSERT INTO `role` VALUES (1,'Administrador','Administrador del sistema',1,NULL,NULL),(6,'BDF','',1,1,NULL),(7,'Cliente','',1,1,NULL),(8,'Ejecutivo de cuenta','',1,1,NULL),(9,'Empleado','',1,1,NULL);
1176/*!40000 ALTER TABLE `role` ENABLE KEYS */;
1177UNLOCK TABLES;
1178
1179--
1180-- Table structure for table `roleschedule`
1181--
1182
1183DROP TABLE IF EXISTS `roleschedule`;
1184/*!40101 SET @saved_cs_client     = @@character_set_client */;
1185 SET character_set_client = utf8mb4 ;
1186CREATE TABLE `roleschedule` (
1187  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1188  `access_permitted` tinyint(1) NOT NULL,
1189  `end_date` int(11) DEFAULT NULL,
1190  `end_time` int(11) DEFAULT NULL,
1191  `start_date` int(11) DEFAULT NULL,
1192  `start_time` int(11) DEFAULT NULL,
1193  `role` bigint(20) DEFAULT NULL,
1194  PRIMARY KEY (`id`),
1195  KEY `FK_7v0ototxw2i290yuwkg7a279t` (`role`),
1196  CONSTRAINT `FK_7v0ototxw2i290yuwkg7a279t` FOREIGN KEY (`role`) REFERENCES `role` (`id`)
1197) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1198/*!40101 SET character_set_client = @saved_cs_client */;
1199
1200--
1201-- Dumping data for table `roleschedule`
1202--
1203
1204LOCK TABLES `roleschedule` WRITE;
1205/*!40000 ALTER TABLE `roleschedule` DISABLE KEYS */;
1206/*!40000 ALTER TABLE `roleschedule` ENABLE KEYS */;
1207UNLOCK TABLES;
1208
1209--
1210-- Table structure for table `roleschedule_dayofweek`
1211--
1212
1213DROP TABLE IF EXISTS `roleschedule_dayofweek`;
1214/*!40101 SET @saved_cs_client     = @@character_set_client */;
1215 SET character_set_client = utf8mb4 ;
1216CREATE TABLE `roleschedule_dayofweek` (
1217  `roleSchedule_id` bigint(20) NOT NULL,
1218  `dayOfWeek_id` bigint(20) NOT NULL,
1219  PRIMARY KEY (`roleSchedule_id`,`dayOfWeek_id`),
1220  KEY `FK_91cav7pbt03nkq1017clagdg8` (`dayOfWeek_id`),
1221  KEY `FK_4slod5tgkcyaeh5n933g1ekgq` (`roleSchedule_id`),
1222  CONSTRAINT `FK_4slod5tgkcyaeh5n933g1ekgq` FOREIGN KEY (`roleSchedule_id`) REFERENCES `roleschedule` (`id`),
1223  CONSTRAINT `FK_91cav7pbt03nkq1017clagdg8` FOREIGN KEY (`dayOfWeek_id`) REFERENCES `dayofweek` (`id`)
1224) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1225/*!40101 SET character_set_client = @saved_cs_client */;
1226
1227--
1228-- Dumping data for table `roleschedule_dayofweek`
1229--
1230
1231LOCK TABLES `roleschedule_dayofweek` WRITE;
1232/*!40000 ALTER TABLE `roleschedule_dayofweek` DISABLE KEYS */;
1233/*!40000 ALTER TABLE `roleschedule_dayofweek` ENABLE KEYS */;
1234UNLOCK TABLES;
1235
1236--
1237-- Table structure for table `security`
1238--
1239
1240DROP TABLE IF EXISTS `security`;
1241/*!40101 SET @saved_cs_client     = @@character_set_client */;
1242 SET character_set_client = utf8mb4 ;
1243CREATE TABLE `security` (
1244  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1245  `name` varchar(255) DEFAULT NULL,
1246  `authenticationProfile` bigint(20) NOT NULL,
1247  PRIMARY KEY (`id`),
1248  UNIQUE KEY `UK_qh8hv59re5mnmb8xeqrqfat3g` (`name`),
1249  KEY `FK_j7rasq0irmpiwpyqm2dqthrir` (`authenticationProfile`),
1250  CONSTRAINT `FK_j7rasq0irmpiwpyqm2dqthrir` FOREIGN KEY (`authenticationProfile`) REFERENCES `authenticationprofile` (`id`)
1251) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1252/*!40101 SET character_set_client = @saved_cs_client */;
1253
1254--
1255-- Dumping data for table `security`
1256--
1257
1258LOCK TABLES `security` WRITE;
1259/*!40000 ALTER TABLE `security` DISABLE KEYS */;
1260INSERT INTO `security` VALUES (1,'unisafe',1);
1261/*!40000 ALTER TABLE `security` ENABLE KEYS */;
1262UNLOCK TABLES;
1263
1264--
1265-- Table structure for table `template`
1266--
1267
1268DROP TABLE IF EXISTS `template`;
1269/*!40101 SET @saved_cs_client     = @@character_set_client */;
1270 SET character_set_client = utf8mb4 ;
1271CREATE TABLE `template` (
1272  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1273  `name` varchar(255) DEFAULT NULL,
1274  `headerSize` varchar(255) DEFAULT NULL,
1275  `icon` varchar(255) DEFAULT NULL,
1276  `inbox_position` varchar(255) DEFAULT NULL,
1277  `lastConnectionVisible` tinyint(1) NOT NULL,
1278  `leftSidebarVisible` tinyint(1) NOT NULL,
1279  `login_background` varchar(255) DEFAULT NULL,
1280  `login_color` varchar(255) NOT NULL,
1281  `login_font_color` varchar(255) NOT NULL,
1282  `login_logo` varchar(255) DEFAULT NULL,
1283  `login_message` varchar(255) DEFAULT NULL,
1284  `login_title` varchar(255) DEFAULT NULL,
1285  `logo` varchar(255) DEFAULT NULL,
1286  `menu_position` varchar(255) DEFAULT NULL,
1287  `notification_position` varchar(255) DEFAULT NULL,
1288  `primary_color` varchar(255) NOT NULL,
1289  `primary_font_color` varchar(255) NOT NULL,
1290  `rightSidebarVisible` tinyint(1) NOT NULL,
1291  `secondary_color` varchar(255) NOT NULL,
1292  `secondary_font_color` varchar(255) NOT NULL,
1293  `welcomeUserVisible` tinyint(1) NOT NULL,
1294  PRIMARY KEY (`id`)
1295) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1296/*!40101 SET character_set_client = @saved_cs_client */;
1297
1298--
1299-- Dumping data for table `template`
1300--
1301
1302LOCK TABLES `template` WRITE;
1303/*!40000 ALTER TABLE `template` DISABLE KEYS */;
1304INSERT INTO `template` VALUES (1,'UniWeb',NULL,NULL,'right',1,1,'uniweb-login-background.jpg','#007acc','#fafafa','uniweb-logo.png',NULL,NULL,NULL,'right','right','#004c98','#fafafa',1,'#60a0ea','#fafafa',1),(2,NULL,'large',NULL,'left',1,1,'uniweb-login-background.jpg','#007acc','#fafafa','uniweb-logo.png',NULL,NULL,NULL,'right','right','#004c98','#fafafa',1,'#60a0ea','#fafafa',1);
1305/*!40000 ALTER TABLE `template` ENABLE KEYS */;
1306UNLOCK TABLES;
1307
1308--
1309-- Table structure for table `user`
1310--
1311
1312DROP TABLE IF EXISTS `user`;
1313/*!40101 SET @saved_cs_client     = @@character_set_client */;
1314 SET character_set_client = utf8mb4 ;
1315CREATE TABLE `user` (
1316  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1317  `name` varchar(255) NOT NULL,
1318  `current_connection` bigint(20) DEFAULT NULL,
1319  `enabled` tinyint(1) NOT NULL,
1320  `forename` varchar(255) DEFAULT NULL,
1321  `last_connection` bigint(20) DEFAULT NULL,
1322  `lastname` varchar(255) DEFAULT NULL,
1323  `mail` varchar(255) DEFAULT NULL,
1324  `profile` bigint(20) NOT NULL,
1325  PRIMARY KEY (`id`),
1326  UNIQUE KEY `UK_gj2fy3dcix7ph7k8684gka40c` (`name`),
1327  KEY `FK_r5p1ntvt8hai6jxysng0nmrsg` (`profile`),
1328  CONSTRAINT `FK_r5p1ntvt8hai6jxysng0nmrsg` FOREIGN KEY (`profile`) REFERENCES `profile` (`id`)
1329) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
1330/*!40101 SET character_set_client = @saved_cs_client */;
1331
1332--
1333-- Dumping data for table `user`
1334--
1335
1336LOCK TABLES `user` WRITE;
1337/*!40000 ALTER TABLE `user` DISABLE KEYS */;
1338INSERT INTO `user` VALUES (2,'carlos.olivares',1563890026724,1,'Carlos',1563888871670,'Olivares','carlos.olivares@accusys.com.ar',2),(3,'MAURICIOMEZA',1563553150206,1,'Mauricio',1563543001957,'Meza','mauricio.meza@accusys.com.ar',7),(4,'A',1563560963580,1,'a',1563560953587,'a','a@a.com',9),(5,'B',NULL,1,'b',NULL,'b','b@b.com',10),(6,'GUIDOSALCEDO',1563568780602,1,'Guido',1563568438058,'Salcedo','guido.salcedo@accusys.com.ar',11);
1339/*!40000 ALTER TABLE `user` ENABLE KEYS */;
1340UNLOCK TABLES;
1341
1342--
1343-- Table structure for table `user_group`
1344--
1345
1346DROP TABLE IF EXISTS `user_group`;
1347/*!40101 SET @saved_cs_client     = @@character_set_client */;
1348 SET character_set_client = utf8mb4 ;
1349CREATE TABLE `user_group` (
1350  `user_id` bigint(20) NOT NULL,
1351  `group_id` bigint(20) NOT NULL,
1352  PRIMARY KEY (`user_id`,`group_id`),
1353  KEY `FK_789v3ejjs9uj5vu1ufexj2tbv` (`group_id`),
1354  KEY `FK_mps81qti05d9he0y66y5jt845` (`user_id`),
1355  CONSTRAINT `FK_789v3ejjs9uj5vu1ufexj2tbv` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`),
1356  CONSTRAINT `FK_mps81qti05d9he0y66y5jt845` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
1357) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1358/*!40101 SET character_set_client = @saved_cs_client */;
1359
1360--
1361-- Dumping data for table `user_group`
1362--
1363
1364LOCK TABLES `user_group` WRITE;
1365/*!40000 ALTER TABLE `user_group` DISABLE KEYS */;
1366/*!40000 ALTER TABLE `user_group` ENABLE KEYS */;
1367UNLOCK TABLES;
1368
1369--
1370-- Table structure for table `user_role`
1371--
1372
1373DROP TABLE IF EXISTS `user_role`;
1374/*!40101 SET @saved_cs_client     = @@character_set_client */;
1375 SET character_set_client = utf8mb4 ;
1376CREATE TABLE `user_role` (
1377  `user_id` bigint(20) NOT NULL,
1378  `role_id` bigint(20) NOT NULL,
1379  PRIMARY KEY (`user_id`,`role_id`),
1380  KEY `FK_it77eq964jhfqtu54081ebtio` (`role_id`),
1381  KEY `FK_apcc8lxk2xnug8377fatvbn04` (`user_id`),
1382  CONSTRAINT `FK_apcc8lxk2xnug8377fatvbn04` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1383  CONSTRAINT `FK_it77eq964jhfqtu54081ebtio` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
1384) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1385/*!40101 SET character_set_client = @saved_cs_client */;
1386
1387--
1388-- Dumping data for table `user_role`
1389--
1390
1391LOCK TABLES `user_role` WRITE;
1392/*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
1393INSERT INTO `user_role` VALUES (2,1),(2,6),(2,7),(3,7),(4,7),(5,7),(6,7),(2,8),(2,9);
1394/*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
1395UNLOCK TABLES;
1396
1397--
1398-- Table structure for table `userschedule`
1399--
1400
1401DROP TABLE IF EXISTS `userschedule`;
1402/*!40101 SET @saved_cs_client     = @@character_set_client */;
1403 SET character_set_client = utf8mb4 ;
1404CREATE TABLE `userschedule` (
1405  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1406  `access_permitted` tinyint(1) NOT NULL,
1407  `end_date` int(11) DEFAULT NULL,
1408  `end_time` int(11) DEFAULT NULL,
1409  `start_date` int(11) DEFAULT NULL,
1410  `start_time` int(11) DEFAULT NULL,
1411  `user` bigint(20) DEFAULT NULL,
1412  PRIMARY KEY (`id`),
1413  KEY `FK_8p1jf8pstlq9n6lhpamooqs70` (`user`),
1414  CONSTRAINT `FK_8p1jf8pstlq9n6lhpamooqs70` FOREIGN KEY (`user`) REFERENCES `user` (`id`)
1415) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1416/*!40101 SET character_set_client = @saved_cs_client */;
1417
1418--
1419-- Dumping data for table `userschedule`
1420--
1421
1422LOCK TABLES `userschedule` WRITE;
1423/*!40000 ALTER TABLE `userschedule` DISABLE KEYS */;
1424/*!40000 ALTER TABLE `userschedule` ENABLE KEYS */;
1425UNLOCK TABLES;
1426
1427--
1428-- Table structure for table `userschedule_dayofweek`
1429--
1430
1431DROP TABLE IF EXISTS `userschedule_dayofweek`;
1432/*!40101 SET @saved_cs_client     = @@character_set_client */;
1433 SET character_set_client = utf8mb4 ;
1434CREATE TABLE `userschedule_dayofweek` (
1435  `userSchedule_id` bigint(20) NOT NULL,
1436  `dayOfWeek_id` bigint(20) NOT NULL,
1437  PRIMARY KEY (`userSchedule_id`,`dayOfWeek_id`),
1438  KEY `FK_9t2w7ivq3csqf1r29n074llf5` (`dayOfWeek_id`),
1439  KEY `FK_2qh9kml9id45r4uswxehmhfs5` (`userSchedule_id`),
1440  CONSTRAINT `FK_2qh9kml9id45r4uswxehmhfs5` FOREIGN KEY (`userSchedule_id`) REFERENCES `userschedule` (`id`),
1441  CONSTRAINT `FK_9t2w7ivq3csqf1r29n074llf5` FOREIGN KEY (`dayOfWeek_id`) REFERENCES `dayofweek` (`id`)
1442) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1443/*!40101 SET character_set_client = @saved_cs_client */;
1444
1445--
1446-- Dumping data for table `userschedule_dayofweek`
1447--
1448
1449LOCK TABLES `userschedule_dayofweek` WRITE;
1450/*!40000 ALTER TABLE `userschedule_dayofweek` DISABLE KEYS */;
1451/*!40000 ALTER TABLE `userschedule_dayofweek` ENABLE KEYS */;
1452UNLOCK TABLES;
1453
1454--
1455-- Table structure for table `vision`
1456--
1457
1458DROP TABLE IF EXISTS `vision`;
1459/*!40101 SET @saved_cs_client     = @@character_set_client */;
1460 SET character_set_client = utf8mb4 ;
1461CREATE TABLE `vision` (
1462  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1463  `name` varchar(255) NOT NULL,
1464  `functionality_id` bigint(20) NOT NULL,
1465  PRIMARY KEY (`id`),
1466  KEY `FK_amtpnq48wrx0i0utomk09ev4i` (`functionality_id`),
1467  CONSTRAINT `FK_amtpnq48wrx0i0utomk09ev4i` FOREIGN KEY (`functionality_id`) REFERENCES `functionality` (`id`)
1468) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
1469/*!40101 SET character_set_client = @saved_cs_client */;
1470
1471--
1472-- Dumping data for table `vision`
1473--
1474
1475LOCK TABLES `vision` WRITE;
1476/*!40000 ALTER TABLE `vision` DISABLE KEYS */;
1477INSERT INTO `vision` VALUES (1,'Vista del Administrador',1),(2,'Vista del Administrador',2),(3,'Vista del Administrador',3),(4,'Vista del Administrador',4),(5,'Vista del Administrador',5),(6,'Vista del Administrador',6),(7,'Vista del Administrador',7),(8,'Vista del Administrador',8),(9,'Vista del Administrador',9),(10,'Vista del Administrador',10),(11,'Vista del Administrador',11),(12,'Vista del Administrador',12),(13,'Vista del Administrador',13),(14,'Vista del Administrador',14),(15,'Vista del Administrador',15),(16,'Vista del Administrador',16),(17,'Vista del Administrador',17),(18,'Vista del Administrador',18),(19,'Vista del Administrador',19),(20,'Vista del Administrador',20),(21,'Vista del Administrador',21),(22,'Vista del Administrador',22),(23,'Vista del Administrador',23),(24,'Vista del Administrador',24),(25,'Vista del Administrador',25),(26,'Vista del Administrador',26),(27,'Vista del Administrador',27),(28,'Vista del Administrador',28),(29,'bdf',30),(30,'l',31),(31,'vista bdf',32),(32,'vista',29),(33,'Vista de cliente',30),(34,'Vista admin',33);
1478/*!40000 ALTER TABLE `vision` ENABLE KEYS */;
1479UNLOCK TABLES;
1480
1481--
1482-- Table structure for table `vision_presentation`
1483--
1484
1485DROP TABLE IF EXISTS `vision_presentation`;
1486/*!40101 SET @saved_cs_client     = @@character_set_client */;
1487 SET character_set_client = utf8mb4 ;
1488CREATE TABLE `vision_presentation` (
1489  `vision_id` bigint(20) NOT NULL,
1490  `presentation_id` bigint(20) NOT NULL,
1491  PRIMARY KEY (`vision_id`,`presentation_id`),
1492  KEY `FK_8cfsvegjh5yd44a5qbaye5n8y` (`presentation_id`),
1493  KEY `FK_qwty3uji1enmobmv4fa9wdly4` (`vision_id`),
1494  CONSTRAINT `FK_8cfsvegjh5yd44a5qbaye5n8y` FOREIGN KEY (`presentation_id`) REFERENCES `presentation` (`id`),
1495  CONSTRAINT `FK_qwty3uji1enmobmv4fa9wdly4` FOREIGN KEY (`vision_id`) REFERENCES `vision` (`id`)
1496) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1497/*!40101 SET character_set_client = @saved_cs_client */;
1498
1499--
1500-- Dumping data for table `vision_presentation`
1501--
1502
1503LOCK TABLES `vision_presentation` WRITE;
1504/*!40000 ALTER TABLE `vision_presentation` DISABLE KEYS */;
1505INSERT INTO `vision_presentation` VALUES (29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(29,2),(31,2),(33,2);
1506/*!40000 ALTER TABLE `vision_presentation` ENABLE KEYS */;
1507UNLOCK TABLES;
1508
1509--
1510-- Table structure for table `vision_role`
1511--
1512
1513DROP TABLE IF EXISTS `vision_role`;
1514/*!40101 SET @saved_cs_client     = @@character_set_client */;
1515 SET character_set_client = utf8mb4 ;
1516CREATE TABLE `vision_role` (
1517  `vision_id` bigint(20) NOT NULL,
1518  `role_id` bigint(20) NOT NULL,
1519  PRIMARY KEY (`vision_id`,`role_id`),
1520  KEY `FK_i41k0ln608sx86i94eoc906i` (`role_id`),
1521  KEY `FK_hkn4jlckrw94afvcqw08vin71` (`vision_id`),
1522  CONSTRAINT `FK_hkn4jlckrw94afvcqw08vin71` FOREIGN KEY (`vision_id`) REFERENCES `vision` (`id`),
1523  CONSTRAINT `FK_i41k0ln608sx86i94eoc906i` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
1524) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1525/*!40101 SET character_set_client = @saved_cs_client */;
1526
1527--
1528-- Dumping data for table `vision_role`
1529--
1530
1531LOCK TABLES `vision_role` WRITE;
1532/*!40000 ALTER TABLE `vision_role` DISABLE KEYS */;
1533INSERT INTO `vision_role` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,6),(31,6),(32,6),(34,6),(30,7),(32,7),(33,7),(34,7),(34,8),(34,9);
1534/*!40000 ALTER TABLE `vision_role` ENABLE KEYS */;
1535UNLOCK TABLES;
1536/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1537
1538/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1539/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1540/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1541/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1542/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1543/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1544/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1545
1546-- Dump completed on 2019-07-23 12:36:09