-- MySQL dump 10.13 Distrib 5.7.33, for Linux (x86_64) -- -- Host: localhost Database: cameyacl_fonavi -- ------------------------------------------------------ -- Server version 5.7.33 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `adjuntos` -- DROP TABLE IF EXISTS `adjuntos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adjuntos` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `extension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `grupo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `modulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `adjuntos` -- LOCK TABLES `adjuntos` WRITE; /*!40000 ALTER TABLE `adjuntos` DISABLE KEYS */; INSERT INTO `adjuntos` VALUES (2,'foto.jpg','jpg','SLIDER_HOME','SLIDER','2019-01-24 08:54:28','2019-02-02 22:51:24'),(3,'foto.jpg','jpg','SLIDER_HOME','SLIDER','2019-01-24 08:55:30','2019-01-24 08:55:30'),(4,'asos-chaqueta-de-traje-ajustada-para-boda-con-cuadros-sutiles-en-azul-y-forro-estampado-de-asos.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-03 01:09:50','2019-02-03 01:09:50'),(6,'Felipe','jpg','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-04 05:35:50','2019-02-04 05:35:50'),(7,'prueba pdf','pdf','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-04 05:44:02','2019-02-04 05:44:02'),(8,'Otro archvo','docx','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-04 05:44:50','2019-02-04 05:44:50'),(9,'asdfchivo','pdf','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-08 05:37:46','2019-02-08 05:37:46'),(10,'asdf','png','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-08 05:58:03','2019-02-08 05:58:03'),(11,'sd','png','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-08 05:59:30','2019-02-08 05:59:30'),(12,'pdf.png','png','SLIDER_HOME','SLIDER','2019-02-12 08:43:37','2019-02-12 08:43:37'),(13,'pdf.png','png','SLIDER_HOME','SLIDER','2019-02-12 08:46:30','2019-02-12 08:46:30'),(14,'folder.png','png','SLIDER_HOME','SLIDER','2019-02-12 08:47:28','2019-02-12 08:47:37'),(15,'pdf.png','png','SLIDER_HOME','SLIDER','2019-02-12 08:48:40','2019-02-12 08:48:40'),(16,'1.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-15 07:16:59','2019-02-15 07:16:59'),(17,'2.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-15 07:17:00','2019-02-15 07:17:00'),(18,'3.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-15 07:17:00','2019-02-15 07:17:00'),(19,'4.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-15 07:17:00','2019-02-15 07:17:00'),(20,'5.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-15 07:17:00','2019-02-15 07:17:00'),(21,'6.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-15 07:17:00','2019-02-15 07:17:00'),(22,'asdf','jpg','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-19 19:07:49','2019-02-19 19:07:49'),(23,'Koala.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-19 19:10:55','2019-02-19 19:10:55'),(24,'Chrysanthemum.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-19 19:38:39','2019-02-19 19:51:27'),(25,'Penguins.jpg','jpg','SLIDER_HOME','SLIDER','2019-02-19 19:51:52','2019-02-19 19:51:52'),(26,'trre','pdf','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-20 19:21:30','2019-02-20 19:21:30'),(27,'rtrt','jpg','BIBLIOTECA_FILE','BIBLIOTECA','2019-02-20 19:21:52','2019-02-20 19:21:52'),(28,'ganador-de-lavadora.png','png','SLIDER_HOME','SLIDER','2019-05-03 19:57:55','2019-05-03 19:57:55'),(29,'informe-ecn-asamblea-2019.png','png','SLIDER_HOME','SLIDER','2019-05-03 19:57:55','2019-05-03 19:57:55'),(30,'renuevate.jpg','jpg','SLIDER_HOME','SLIDER','2019-05-03 19:57:55','2019-05-03 19:57:55'),(31,'excursion-europa.png','png','SLIDER_HOME','SLIDER','2019-05-03 19:57:55','2019-05-03 19:57:55'),(32,'credito-vehiculo.jpg','jpg','SLIDER_HOME','SLIDER','2019-05-06 06:13:16','2019-05-06 06:13:16'),(33,'plan-recordar-banner.jpg','jpg','SLIDER_HOME','SLIDER','2019-05-06 06:15:31','2019-05-06 06:15:31'),(34,'consulta_estado_cuenta.png','png','SLIDER_HOME','SLIDER','2019-05-06 06:22:04','2019-05-06 06:22:04'),(35,'Imagen1.png','png','SLIDER_HOME','SLIDER','2019-05-06 06:22:04','2019-08-30 19:51:19'),(36,'PIPE - WIN_20150603_212840.JPG','JPG','TIPOS_CONVENIO','TIPOS_CONVENIO','2019-06-04 01:31:56','2019-06-04 06:04:16'),(37,'PIPE - WIN_20150603_212840.JPG','JPG','TIPOS_CONVENIO','TIPOS_CONVENIO','2019-06-04 06:16:08','2019-06-04 06:16:08'),(38,'PIPE - WIN_20150603_212840.JPG','JPG','CONVENIOS','CONVENIOS','2019-06-04 08:58:04','2019-06-04 08:58:04'),(39,'PIPE - WIN_20150603_212840.JPG','JPG','CONVENIOS','CONVENIOS','2019-06-04 08:59:21','2019-06-04 08:59:21'),(40,'PIPE - WIN_20150603_212820.JPG','JPG','CONVENIOS','CONVENIOS','2019-06-06 05:42:54','2019-06-06 05:42:54'),(41,'000_1HJ8EH.jpg','jpg','CONVENIOS','CONVENIOS','2019-06-17 05:11:36','2019-06-17 05:11:36'),(42,'smileArt.jpg','jpg','CONVENIOS','CONVENIOS','2019-06-26 10:15:34','2019-06-26 10:15:34'); /*!40000 ALTER TABLE `adjuntos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `administracion_acciones` -- DROP TABLE IF EXISTS `administracion_acciones`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `administracion_acciones` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `modulos_id` int(11) NOT NULL, `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `administracion_acciones` -- LOCK TABLES `administracion_acciones` WRITE; /*!40000 ALTER TABLE `administracion_acciones` DISABLE KEYS */; INSERT INTO `administracion_acciones` VALUES (1,1,'Acceso','Acceso a las funcionalidades del modulo Publicaciones','2019-06-09 01:58:16','2019-06-09 01:58:32'),(2,2,'Acceso','Acceso a las funcionalidades del modulo Menú','2019-06-09 01:59:14','2019-06-09 01:59:14'),(3,4,'Acceso','Acceso a las funcionalidades del modulo Perfiles','2019-06-09 01:59:34','2019-06-09 01:59:34'),(4,5,'Acceso','Acceso a las funcionalidades del modulo Slider','2019-06-09 02:00:14','2019-06-09 02:00:14'),(5,6,'Acceso','Acceso a las funcionalidades del modulo Biblioteca','2019-06-09 02:00:36','2019-06-09 02:00:36'),(6,7,'Acceso','Acceso a las funcionalidades del modulo Usuarios','2019-06-09 02:01:02','2019-06-09 02:01:02'),(7,8,'Acceso','Acceso a las funcionalidades del modulo Tipo Convenio','2019-06-09 02:01:22','2019-06-09 02:01:22'),(8,9,'Acceso','Acceso a las funcionalidades del modulo Convenios','2019-06-09 02:01:41','2019-06-09 02:01:41'),(10,10,'Acceso','Acceso a las funcionalidades del modulo \"Módulos\"','2019-06-10 04:56:09','2019-06-10 04:56:09'),(11,11,'Acceso','Acceso al módulo','2019-06-26 18:52:04','2019-06-26 18:52:04'),(12,12,'Acceso','Restricción de acceso','2019-07-29 04:36:54','2019-07-29 04:36:54'); /*!40000 ALTER TABLE `administracion_acciones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `administracion_modulos` -- DROP TABLE IF EXISTS `administracion_modulos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `administracion_modulos` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `icono` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `administracion_modulos` -- LOCK TABLES `administracion_modulos` WRITE; /*!40000 ALTER TABLE `administracion_modulos` DISABLE KEYS */; INSERT INTO `administracion_modulos` VALUES (1,'Publicaciones','fa-magic','Publicaciones','Este modulo permite gestionar la visualización de las paginas internas del portal web.','2018-12-29 23:00:16','2018-12-29 23:00:16'),(2,'Menú','fa-navicon','Menu','Desde este módulo podrás personalizar las opciones que se visualizarán en el menú del portal web y también el orden en que se imprime.','2018-12-29 23:41:39','2018-12-29 23:41:39'),(4,'Perfiles','fa-lock','Perfiles','Desde este módulo se podrán gestionar los perfiles que tendrán los usuarios y adicional a eso se podrán configurar los permisos para cada uno de esos perfiles','2018-12-29 23:51:32','2018-12-29 23:51:32'),(5,'Slider','fa-repeat','Slider/Configurar/2','Encargado de controlar los sliders que existan en el Home de la pagina.','2019-01-20 22:04:41','2019-02-03 21:48:11'),(6,'Biblioteca','fa-book','Biblioteca','Desde este módulo se podrán gestionar todos los archivos y documentos, también se pueden desplegar los grupos de documentos deseados.','2019-02-04 00:30:51','2019-02-04 00:30:51'),(7,'Usuarios','fa-group','Usuarios','Administración de usuarios','2019-05-09 08:07:35','2019-05-09 08:07:35'),(8,'Tipo Convenio','fa-balance-scale','Tipos/Lista','Tipos de convenio','2019-05-27 04:59:06','2019-06-06 06:46:35'),(9,'Convenios','fa-adjust','Convenios/Lista','Convenios','2019-06-06 06:47:07','2019-06-06 06:47:07'),(10,'Modulos','fa-sitemap','Modulos','Módulos del sistema','2019-06-10 04:55:17','2019-06-10 04:55:17'),(11,'Clientes','fa-handshake-o','Clientes/Extracto','En este módulo el usuario podrá descargar el extracto del mes que desee sin ningún problema','2019-06-26 18:52:04','2019-06-26 18:52:04'),(12,'Parametros Simulador','fa-calculator','ParametrosSimulador','Modulo que permite crear los parametros para el simulador de credito publicado en la pagina web','2019-07-29 04:35:36','2019-07-29 04:35:36'); /*!40000 ALTER TABLE `administracion_modulos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `administracion_perfiles` -- DROP TABLE IF EXISTS `administracion_perfiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `administracion_perfiles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `administracion_perfiles` -- LOCK TABLES `administracion_perfiles` WRITE; /*!40000 ALTER TABLE `administracion_perfiles` DISABLE KEYS */; INSERT INTO `administracion_perfiles` VALUES (9,'Administracion','Este Perfil','2018-12-30 09:22:22','2018-12-30 10:08:36'),(12,'Prueba','avcceso','2019-06-10 04:39:23','2019-06-10 04:39:23'),(13,'Cliente','Perfil del cliente','2019-08-30 20:01:18','2019-08-30 20:01:18'); /*!40000 ALTER TABLE `administracion_perfiles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `administracion_permisos` -- DROP TABLE IF EXISTS `administracion_permisos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `administracion_permisos` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `acciones_id` int(11) NOT NULL, `perfiles_id` int(11) NOT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `administracion_permisos` -- LOCK TABLES `administracion_permisos` WRITE; /*!40000 ALTER TABLE `administracion_permisos` DISABLE KEYS */; INSERT INTO `administracion_permisos` VALUES (48,1,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(49,2,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(50,3,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(51,4,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(52,5,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(53,6,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(54,7,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(55,8,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(56,10,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(57,11,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(58,12,9,NULL,'2019-08-06 01:53:36','2019-08-06 01:53:36'),(59,11,12,NULL,'2019-08-28 01:53:23','2019-08-28 01:53:23'),(60,11,13,NULL,'2019-08-30 20:01:18','2019-08-30 20:01:18'); /*!40000 ALTER TABLE `administracion_permisos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `componente_biblioteca_archivo` -- DROP TABLE IF EXISTS `componente_biblioteca_archivo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `componente_biblioteca_archivo` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `biblioteca_categoria_id` int(11) NOT NULL, `adjunto_id` int(11) NOT NULL, `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `componente_biblioteca_archivo` -- LOCK TABLES `componente_biblioteca_archivo` WRITE; /*!40000 ALTER TABLE `componente_biblioteca_archivo` DISABLE KEYS */; /*!40000 ALTER TABLE `componente_biblioteca_archivo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `componente_biblioteca_categoria` -- DROP TABLE IF EXISTS `componente_biblioteca_categoria`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `componente_biblioteca_categoria` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_padre` int(11) NOT NULL DEFAULT '0', `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci NOT NULL, `Visible` int(11) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `componente_biblioteca_categoria` -- LOCK TABLES `componente_biblioteca_categoria` WRITE; /*!40000 ALTER TABLE `componente_biblioteca_categoria` DISABLE KEYS */; /*!40000 ALTER TABLE `componente_biblioteca_categoria` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `componente_menu` -- DROP TABLE IF EXISTS `componente_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `componente_menu` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `json` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `componente_menu` -- LOCK TABLES `componente_menu` WRITE; /*!40000 ALTER TABLE `componente_menu` DISABLE KEYS */; INSERT INTO `componente_menu` VALUES (3,'[{\"nombre\":\"Institucional\",\"icono\":false,\"enlace\":\"#\",\"enlaceArticulo\":\"NO\",\"pestannia\":false,\"id\":34627,\"hijos\":[{\"nombre\":\"¿Quienes Somos?\",\"icono\":false,\"enlace\":\"5/%C2%BFQuienes+Somos%3F\",\"enlaceArticulo\":\"SI\",\"pestannia\":false,\"id\":88423}]},{\"nombre\":\"Servicios Sociales\",\"icono\":false,\"enlace\":\"http://platform.prograymer.com/Inicio\",\"enlaceArticulo\":\"NO\",\"pestannia\":false,\"id\":206939},{\"nombre\":\"Servicios Financieros\",\"icono\":false,\"enlace\":\"http://platform.prograymer.com/Inicio\",\"enlaceArticulo\":\"NO\",\"pestannia\":false,\"id\":930202},{\"nombre\":\"Lineas de Ahorro\",\"icono\":false,\"enlace\":\"http://platform.prograymer.com/Inicio\",\"enlaceArticulo\":\"NO\",\"pestannia\":false,\"id\":869134},{\"nombre\":\"Convenios\",\"icono\":false,\"enlace\":\"http://cameya.club/fonavi/public/Convenios\",\"enlaceArticulo\":\"NO\",\"pestannia\":false,\"id\":903408},{\"nombre\":\"Publicaciones y Eventos\",\"icono\":false,\"enlace\":\"http://platform.prograymer.com/Inicio\",\"enlaceArticulo\":\"NO\",\"pestannia\":false,\"id\":938185},{\"nombre\":\"Consulta Web\",\"icono\":false,\"enlace\":\"http://platform.prograymer.com/Inicio\",\"enlaceArticulo\":\"NO\",\"pestannia\":false,\"id\":503418},{\"nombre\":\"Prueba PDF\",\"icono\":false,\"enlace\":\"http://sistema.finprogreso.co/temp/CartaPreaprobado138.pdf\",\"enlaceArticulo\":\"NO\",\"pestannia\":true,\"id\":216419}]','2018-12-28 22:31:45','2020-02-12 21:01:16'); /*!40000 ALTER TABLE `componente_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `componente_publicaciones` -- DROP TABLE IF EXISTS `componente_publicaciones`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `componente_publicaciones` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `contenido` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `estado` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `componente_publicaciones` -- LOCK TABLES `componente_publicaciones` WRITE; /*!40000 ALTER TABLE `componente_publicaciones` DISABLE KEYS */; INSERT INTO `componente_publicaciones` VALUES (3,'jkljn','jkljn','

lklkmlñkllkmlk

','ACTIVO','2019-05-06 03:29:39','2019-05-06 03:29:39'),(5,'¿Quienes Somos?','%C2%BFQuienes+Somos%3F','

 

\n\n

¿QUIENES SOMOS?

\n\n

FONAVIEMCALI es el Fondo de Empleados de las Empresas Municipales de Cali, una organización solida fundamentada en principios y valores integrales, empresariales y sociales, que propende por el desarrollo integral del Ser como parte central de la sociedad en la cual pueda interactuar sin ningún tipo de discriminación racial, de credo, de opinión, de sexo y de filosofía.

\n\n

Trabajamos manteniendo una relación franca transparente y sin barreras jerárquicas o funcionales, dirigiendo nuestros esfuerzos a brindar servicios orientados en un mejoramiento continuo del núcleo familiar de los Asociados, para lo cual hemos consolidado una organización de alto desempeño fundamentada en competencias y soporte tecnológico e innovador.

\n\n

\"\"

','INACTIVO','2019-05-06 07:56:58','2019-08-30 03:23:09'); /*!40000 ALTER TABLE `componente_publicaciones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `componente_slider` -- DROP TABLE IF EXISTS `componente_slider`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `componente_slider` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `clave` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `componente_slider` -- LOCK TABLES `componente_slider` WRITE; /*!40000 ALTER TABLE `componente_slider` DISABLE KEYS */; INSERT INTO `componente_slider` VALUES (2,'Home','SLIDER_PRINCIPAL','2019-01-24 08:54:28','2019-02-15 06:30:49'); /*!40000 ALTER TABLE `componente_slider` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `componente_slider_diapositivas` -- DROP TABLE IF EXISTS `componente_slider_diapositivas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `componente_slider_diapositivas` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `adjunto_id` int(11) NOT NULL, `slider_id` int(11) NOT NULL, `enlace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `pestannia` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `posicion` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `componente_slider_diapositivas` -- LOCK TABLES `componente_slider_diapositivas` WRITE; /*!40000 ALTER TABLE `componente_slider_diapositivas` DISABLE KEYS */; INSERT INTO `componente_slider_diapositivas` VALUES (13,28,2,'#','NO','ganador de lavadora',1,'2019-05-03 19:57:55','2019-05-03 19:57:55'),(14,29,2,'https://www.youtube.com/watch?v=6lR4Gbdpf6E&t=11s','SI','asamblea',2,'2019-05-03 19:57:55','2019-05-06 06:05:42'),(15,30,2,'#','NO','renuevate',3,'2019-05-03 19:57:55','2019-05-03 19:57:55'),(16,31,2,'https://www.fonaviemcali.com.co/images/banner-principal/afiche-excursin-europa.jpg','SI','excursion europa',4,'2019-05-03 19:57:55','2019-05-06 06:06:41'),(17,32,2,'https://www.fonaviemcali.com.co/images/banner-principal/credito-vehiculo-volante.jpg','SI','Credito vehiculo',5,'2019-05-06 06:13:17','2019-05-06 06:13:17'),(18,33,2,'https://www.fonaviemcali.com.co/images/banner-principal/plan-recordar.jpg','SI','Plan Recordar',6,'2019-05-06 06:15:31','2019-05-06 06:15:31'); /*!40000 ALTER TABLE `componente_slider_diapositivas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `convenio` -- DROP TABLE IF EXISTS `convenio`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `convenio` ( `id` int(11) NOT NULL AUTO_INCREMENT, `id_tipo` int(11) NOT NULL, `adjunto_id` int(10) DEFAULT NULL, `beneficios` varchar(1000) COLLATE utf8_bin NOT NULL, `contacto` varchar(100) COLLATE utf8_bin NOT NULL, `telefono` varchar(200) COLLATE utf8_bin NOT NULL, `direccion` varchar(250) COLLATE utf8_bin NOT NULL, `sedes` varchar(500) COLLATE utf8_bin NOT NULL, `titulo` varchar(255) COLLATE utf8_bin NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `convenio` -- LOCK TABLES `convenio` WRITE; /*!40000 ALTER TABLE `convenio` DISABLE KEYS */; INSERT INTO `convenio` VALUES (1,2,39,'beneficios','contacto','3155068120','carrera 49a # 51 - 17','sedes','titulo','2019-06-17 03:31:13','2019-06-17 08:31:13'),(2,2,40,'asdfs','asdfa','asdfsa','asdfa','asdfa','titulo','2019-06-06 05:42:54','2019-06-06 05:42:54'),(3,3,41,'asdfa','asdfa','8889','asdfas','asdfsa','Messi','2019-06-17 05:11:37','2019-06-17 05:11:37'); /*!40000 ALTER TABLE `convenio` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2018_08_27_020045_table_af_menu',1),(4,'2018_10_05_161731_componente_publicaciones',1),(6,'2018_12_27_211432_administracion_modulos',1),(7,'2018_12_27_211502_administracion_perfiles',1),(8,'2018_12_27_211525_administracion_acciones',1),(9,'2018_12_27_211554_administracion_permisos',1),(12,'2018_10_27_175201_adjuntos',2),(13,'2019_01_20_182240_slider',2),(15,'2019_01_24_005004_slider_diapositivas',3),(16,'2019_02_03_173941_componente_biblioteca_categoria',4),(17,'2019_02_03_174120_componente_biblioteca_archivo',4); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `parametros_simulador` -- DROP TABLE IF EXISTS `parametros_simulador`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parametros_simulador` ( `id` int(11) NOT NULL AUTO_INCREMENT, `descripcion` varchar(300) NOT NULL, `monto_minimo` int(11) NOT NULL, `monto_maximo` int(11) NOT NULL, `plazo_minimo` int(11) NOT NULL, `plazo_maximo` int(11) NOT NULL, `tasa` decimal(14,12) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `parametros_simulador` -- LOCK TABLES `parametros_simulador` WRITE; /*!40000 ALTER TABLE `parametros_simulador` DISABLE KEYS */; INSERT INTO `parametros_simulador` VALUES (3,'Bono Supermercado',1,500000,0,3,8.098593120000,'2019-06-26 04:47:17','2019-06-26 04:47:17'),(4,'Credito Express',1,828116,1,6,16.823640000000,'2019-06-26 04:48:09','2019-06-26 04:48:09'),(5,'Educacion con Beca',1,24843480,0,6,8.098593120000,'2019-06-26 04:49:00','2019-06-26 04:49:00'),(6,'Educativo Rotativo',1,24843480,6,48,16.823640000000,'2019-06-26 04:49:43','2019-06-26 04:49:43'),(7,'Eventos',1,24843480,0,72,16.823640000000,'2019-06-26 04:50:12','2019-06-26 04:50:12'),(8,'Exequial',1,8281160,6,24,16.823640000000,'2019-06-26 04:50:57','2019-06-26 04:50:57'),(9,'Fomento',2484348,20702900,18,48,16.823640000000,'2019-06-26 04:51:36','2019-06-26 04:51:36'),(10,'Libre Inv Dos Veces Aporte+Ahorro',1,24843480,0,72,16.823640000000,'2019-06-26 04:52:22','2019-06-26 04:52:22'),(11,'Libre Inv Sin Garantia',1,57968120,0,72,16.823640000000,'2019-06-26 04:52:53','2019-06-26 04:52:53'),(12,'Vehiculo con Convenio',4968696,57968120,0,72,14.069569000000,'2019-06-26 04:53:40','2019-06-26 04:53:40'),(13,'Vehiculo Credito Ordinario',6624929,28984060,24,72,14.069569000000,'2019-06-26 04:54:22','2019-06-26 04:54:22'),(14,'Vivienda Ord Primera',1,19330080,0,72,10.318210000000,'2019-06-26 04:54:59','2019-06-26 04:54:59'),(15,'Vivienda Ord Segunda',1,20683620,0,72,11.112000000000,'2019-06-26 04:55:47','2019-06-26 04:55:47'),(16,'Vivienda Primera',1,77320000,0,216,10.318210000000,'2019-06-26 04:56:31','2019-06-26 04:56:31'),(17,'Vivienda Segunda',1,77320320,0,216,11.112000000000,'2019-06-26 04:57:02','2019-06-26 04:57:02'); /*!40000 ALTER TABLE `parametros_simulador` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tipo_convenio` -- DROP TABLE IF EXISTS `tipo_convenio`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tipo_convenio` ( `id` int(11) NOT NULL AUTO_INCREMENT, `descripcion` varchar(255) COLLATE utf8_bin NOT NULL, `comentario` varchar(300) COLLATE utf8_bin DEFAULT NULL, `adjunto_id` int(10) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `usuario_creacion` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tipo_convenio` -- LOCK TABLES `tipo_convenio` WRITE; /*!40000 ALTER TABLE `tipo_convenio` DISABLE KEYS */; INSERT INTO `tipo_convenio` VALUES (2,'tipo bien','tipo bien',36,'2019-06-04 01:31:56','2019-06-04 01:31:56',1),(3,'Odontologia','Odontologia',NULL,'2019-06-17 04:21:40','2019-06-17 04:21:40',1); /*!40000 ALTER TABLE `tipo_convenio` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `identificacion` int(25) NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `perfil` int(10) NOT NULL, `estado` int(10) NOT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `users_email_unique` (`email`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Administrador',0,'admin@gmail.com',9,1,'$2y$10$D33F9CuAqsr8FZe1kIleMeWuQwEOSNQor.p0vKzF.ICpfGy4D..6e','N3ZIvqxyvgHA5TwfSlxzDJHdHY6jhjMwVFAZnEcOJA8AKqBO3IChReNIZyfO','2018-12-28 07:20:55','2018-12-31 12:31:54'),(3,'prueba',1212121212,'prueba@gmail.com',12,1,'$2y$10$IT1lQrNUUpRuS981O9nZ9uBsMRjK3AofLRGDmE1LtGufSC8xXLi8e',NULL,'2019-06-10 04:39:57','2019-08-28 01:48:42'),(4,'Usuario Cliente',1144166678,'jefer@gmail.com',13,1,'$2y$10$kpOykXAr1zEfyrlKZHklwu5vK32ahLSg2u3uvbzQqvP1A7bM16vBi','W7m8ee2PfTIk63NWi55ES8eoOOse9TNECoRslruqudiXBaTWV4cfjBo7Sv6O','2019-08-30 20:01:49','2019-08-30 20:01:49'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2021-02-08 16:13:11