--
-- Host: localhost    Database: cmi
-- ------------------------------------------------------


--
-- Table structure for table `audits`
--

CREATE TABLE `audits` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `event` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `auditable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `auditable_id` bigint(20) unsigned NOT NULL,
  `old_values` text COLLATE utf8mb4_unicode_ci,
  `new_values` text COLLATE utf8mb4_unicode_ci,
  `url` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tags` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audits_auditable_type_auditable_id_index` (`auditable_type`,`auditable_id`),
  KEY `audits_user_id_user_type_index` (`user_id`,`user_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2183 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audits`
--



--
-- Table structure for table `cmis`
--

CREATE TABLE `cmis` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phase_id` int(10) unsigned NOT NULL,
  `perspective_id` int(10) unsigned NOT NULL,
  `objective_id` int(10) unsigned NOT NULL,
  `kpi` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `indicator_type` enum('kpi','kri') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'kpi',
  `measure_id` int(10) unsigned NOT NULL,
  `frequency_id` int(10) unsigned NOT NULL,
  `reference` decimal(11,2) NOT NULL,
  `optimum` decimal(11,2) NOT NULL,
  `acceptable` decimal(11,2) NOT NULL,
  `deficient` decimal(11,2) NOT NULL,
  `direction` enum('A','B') COLLATE utf8_unicode_ci NOT NULL,
  `result` decimal(11,2) DEFAULT NULL,
  `deviation` decimal(5,2) DEFAULT NULL,
  `result_date` date DEFAULT NULL,
  `responsable_id` int(10) unsigned NOT NULL,
  `type` enum('A','M') COLLATE utf8_unicode_ci NOT NULL,
  `on_board` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `board_position` smallint(6) DEFAULT NULL,
  `on_board_wd` decimal(6,2) DEFAULT NULL,
  `is_sensible` tinyint(1) NOT NULL,
  `init_date` date NOT NULL,
  `due_date` date DEFAULT NULL,
  `api_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cmis_phase_id_foreign` (`phase_id`),
  KEY `cmis_perspective_id_foreign` (`perspective_id`),
  KEY `cmis_objective_id_foreign` (`objective_id`),
  KEY `cmis_measure_id_foreign` (`measure_id`),
  KEY `cmis_frequency_id_foreign` (`frequency_id`),
  KEY `cmis_responsable_id_foreign` (`responsable_id`),
  CONSTRAINT `cmis_frequency_id_foreign` FOREIGN KEY (`frequency_id`) REFERENCES `frequencies` (`id`),
  CONSTRAINT `cmis_measure_id_foreign` FOREIGN KEY (`measure_id`) REFERENCES `measures` (`id`),
  CONSTRAINT `cmis_objective_id_foreign` FOREIGN KEY (`objective_id`) REFERENCES `objectives` (`id`),
  CONSTRAINT `cmis_perspective_id_foreign` FOREIGN KEY (`perspective_id`) REFERENCES `perspectives` (`id`),
  CONSTRAINT `cmis_phase_id_foreign` FOREIGN KEY (`phase_id`) REFERENCES `phases` (`id`),
  CONSTRAINT `cmis_responsable_id_foreign` FOREIGN KEY (`responsable_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cmis`
--

INSERT INTO `cmis` VALUES (7,1,3,6,'Respuesta Solicitudes de Insumos','Disminuir los tiempos de respuesta a 10 días','kpi',9,6,30.00,10.00,20.00,25.00,'B',-1.00,200.00,'2020-03-07',7,'M','N',NULL,NULL,1,'2019-08-01','2019-12-31',NULL,'2019-07-30 01:35:35','2020-03-08 05:54:52'),(9,1,2,12,'Nuevos Clientes x Mes','Cantidad de nuevos Clientes por mes','kpi',3,4,6.00,12.00,10.00,8.00,'A',11.00,0.00,'2019-11-01',4,'M','N',NULL,NULL,0,'2019-08-01','2019-12-31',NULL,'2019-08-26 04:42:26','2020-03-08 05:02:45'),(34,4,114,180,'Nuevos Clientes x Mes','Cantidad de nuevos Clientes por mes','kpi',3,4,11.00,12.00,10.00,8.00,'A',12.00,0.00,'2019-12-01',4,'M','N',NULL,NULL,0,'2019-11-01','2020-04-30',NULL,'2019-09-12 22:44:01','2019-09-13 03:55:08'),(35,4,114,180,'Ganar 6 Nuevos Clientes x Mes','Adquirir seis nuevos Clientes cada mes','kpi',3,4,5.00,6.00,4.00,2.00,'A',6.00,0.00,'2019-12-01',6,'M','N',NULL,NULL,0,'2019-11-01','2020-04-30',NULL,'2019-09-12 22:44:01','2019-09-12 23:30:40'),(36,4,115,181,'Tiempo de elaboracion de un CRUD','Minutos requeridos para la elaboración de un CRUD de una tabla sencilla','kpi',7,6,19.00,-1.00,9.00,14.00,'B',0.00,0.00,NULL,1,'M','N',NULL,NULL,0,'2019-11-01','2020-04-30',NULL,'2019-09-12 22:44:02','2019-09-12 22:44:02'),(37,4,116,183,'Dólares ahorrados x Mes','Cantidad de dólares ahorrados por mes','kpi',3,4,7.00,15.00,10.00,8.00,'A',0.00,0.00,NULL,1,'M','N',NULL,NULL,0,'2019-11-01','2020-04-30',NULL,'2019-09-12 22:44:05','2019-09-12 22:44:05'),(42,4,116,185,'Cubrir 2 Cursos OnLine x Mes','Cubrir dos Cursos OnLine por Mes','kpi',3,4,0.00,3.00,2.00,1.00,'A',0.00,0.00,NULL,5,'M','N',NULL,NULL,0,'2019-11-01','2020-03-31',NULL,'2019-09-13 04:50:24','2019-09-13 04:50:24'),(43,4,115,182,'Cantidad de Errores detectados','Cantidad de Errores detectados durante las pruebas','kpi',3,6,20.00,8.00,10.00,15.00,'B',0.00,0.00,NULL,9,'M','N',NULL,NULL,0,'2019-11-01','2020-03-31',NULL,'2019-09-13 04:52:47','2019-09-13 04:52:47'),(44,6,122,201,'Nuevos Clientes x Mes','Cantidad de nuevos Clientes por mes','kpi',3,4,11.00,12.00,10.00,8.00,'A',0.00,0.00,NULL,4,'M','N',NULL,NULL,0,'2019-11-01','2020-04-30',NULL,'2019-09-21 19:31:20','2019-09-21 19:31:20'),(45,6,122,201,'Ganar 6 Nuevos Clientes x Mes','Adquirir seis nuevos Clientes cada mes','kpi',3,4,5.00,6.00,4.00,2.00,'A',0.00,0.00,NULL,6,'M','N',NULL,NULL,0,'2019-11-01','2020-04-30',NULL,'2019-09-21 19:31:21','2019-09-21 19:31:21'),(46,6,123,202,'Tiempo de elaboracion de un CRUD','Minutos requeridos para la elaboración de un CRUD de una tabla sencilla','kpi',7,6,19.00,-1.00,9.00,14.00,'B',0.00,0.00,NULL,1,'M','N',NULL,NULL,0,'2019-11-01','2020-04-30',NULL,'2019-09-21 19:31:22','2019-09-21 19:31:22'),(47,6,124,204,'Dólares ahorrados x Mes','Cantidad de dólares ahorrados por mes','kpi',3,4,7.00,15.00,10.00,8.00,'A',0.00,0.00,NULL,1,'M','N',NULL,NULL,0,'2019-11-01','2020-04-30',NULL,'2019-09-21 19:31:25','2019-09-21 19:31:25');

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `president` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `mission` text COLLATE utf8_unicode_ci NOT NULL,
  `vision` text COLLATE utf8_unicode_ci NOT NULL,
  `vision1` text COLLATE utf8_unicode_ci,
  `vision3` text COLLATE utf8_unicode_ci,
  `vision5` text COLLATE utf8_unicode_ci,
  `values` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` VALUES (1,'Delcop','Jhonatan Yllas','Proveer los mejores soluciones, suministros y partes de imprenta para nuestros Clientes.','Delcop será lider en latinoamérica, en soluciones de imprenta.',NULL,NULL,NULL,'Innovación, Calidad en el Servicio y Atención Personalizada',NULL,'2019-10-18 05:41:37');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iata` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `countries_language_id_foreign` (`language_id`),
  CONSTRAINT `countries_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'Venezuela','VE',5,'2019-08-28 01:55:21','2019-09-25 04:47:12',NULL),(2,'Colombia','CO',6,'2019-08-28 01:55:36','2019-09-25 04:47:24',NULL),(3,'España','ES',5,'2019-08-28 01:55:52','2019-09-25 04:49:33',NULL);

--
-- Table structure for table `cruds`
--

CREATE TABLE `cruds` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cruds_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cruds`
--

INSERT INTO `cruds` VALUES (1,'User','2019-09-18 21:05:26','2019-09-18 21:05:26'),(3,'Country','2019-09-22 01:28:31','2019-09-22 01:28:31'),(4,'Frequency','2019-09-22 01:30:29','2019-09-22 01:30:29'),(5,'Dimension','2019-09-22 01:31:31','2019-09-22 01:31:31'),(6,'Company','2019-09-22 01:31:57','2019-09-22 01:31:57'),(7,'Phase','2019-09-22 01:32:12','2019-09-22 01:32:12'),(8,'Role','2019-09-22 01:32:40','2019-09-22 01:32:40'),(9,'Permission','2019-09-22 01:32:58','2019-09-22 01:32:58'),(10,'Cmi','2019-09-22 03:39:08','2019-09-22 03:39:08'),(11,'Map','2019-09-22 17:18:25','2019-09-22 17:18:25');

--
-- Table structure for table `frequencies`
--

CREATE TABLE `frequencies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `function` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `quantity` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `frequencies_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `frequencies`
--

INSERT INTO `frequencies` VALUES (1,'Semestral','1',6,'2019-07-10 14:11:43','2019-10-05 21:59:44','2019-10-05 21:59:44'),(2,'Trimestral','1',3,'2019-07-10 14:11:43','2019-07-10 14:11:43',NULL),(3,'Bimensual','1',2,'2019-07-10 14:11:43','2019-07-11 23:13:45',NULL),(4,'Mensual','1',1,'2019-07-10 14:11:43','2019-07-10 14:11:43',NULL),(5,'Quincenal','2',2,'2019-07-10 14:11:43','2019-07-10 14:11:43',NULL),(6,'Semanal','2',1,'2019-07-10 14:11:43','2019-07-10 14:11:43',NULL),(7,'InterDaria','3',2,'2019-07-10 14:11:44','2019-07-24 02:09:59',NULL),(9,'Diaria','3',1,'2019-07-11 23:57:39','2019-07-15 19:28:19',NULL),(13,'Anual','1',12,'2019-07-13 04:01:41','2019-10-05 21:59:31','2019-10-05 21:59:31'),(14,'1ero de c/mes','6',1,'2019-10-04 05:58:13','2019-10-04 05:58:13',NULL),(15,'1 y 15 c/mes','5',1,'2019-10-04 05:58:45','2019-10-04 05:58:45',NULL),(16,'Ultimo de mes','7',1,'2019-10-05 22:02:42','2019-10-05 22:02:42',NULL),(17,'Primero de mes','8',1,'2019-10-05 23:47:37','2019-10-05 23:47:37',NULL);

--
-- Table structure for table `indicators`
--

CREATE TABLE `indicators` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `confirmed` tinyint(1) NOT NULL DEFAULT '0',
  `perspective_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `indicators_name_unique` (`name`),
  KEY `indicators_perspective_id_foreign` (`perspective_id`),
  CONSTRAINT `indicators_perspective_id_foreign` FOREIGN KEY (`perspective_id`) REFERENCES `perspectives` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `indicators`
--

INSERT INTO `indicators` VALUES (1,'% de Incr. de las Ventas','Porcentaje de aumento de las ventas mensuales',0,1,'2019-07-10 14:11:44','2019-07-10 14:11:44'),(2,'% Cuota de Mercando','Porcentaje de participación en el mercando',0,1,'2019-07-10 14:11:44','2019-07-10 14:11:44'),(3,'% Reducc. Gastos Admin','Porcentaje de Reducción de Gastos Administrativos',0,1,'2019-07-10 14:11:44','2019-07-10 14:11:44'),(4,'% Ingreso Nuevos Clientes','Porcentaje mensual de captura de nuevos Clientes',0,2,'2019-07-10 14:11:44','2019-07-10 14:11:44'),(5,'% Satisfacción de Clientes','Porcentaje de satisfacción de la Cartera actual de Clientes',0,2,'2019-07-10 14:11:44','2019-07-10 14:11:44');

--
-- Table structure for table `initiatives`
--

CREATE TABLE `initiatives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cmi_id` int(10) unsigned NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `done` decimal(5,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `initiatives_cmi_id_foreign` (`cmi_id`),
  CONSTRAINT `initiatives_cmi_id_foreign` FOREIGN KEY (`cmi_id`) REFERENCES `cmis` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `initiatives`
--

INSERT INTO `initiatives` VALUES (3,7,'Estudiar a fondo la herramienta CrestApp',0.00,'2019-07-31 15:52:14','2019-08-24 01:19:39'),(4,7,'Crear nuestro propio generador de codigo',0.00,'2019-08-01 04:29:16','2019-08-24 01:19:48'),(7,9,'Otorgar descuentos a los Clientes que traigan nuevos Clientes',0.00,'2019-08-26 04:43:26','2019-08-26 04:43:26'),(8,9,'Campaña de publicidad por E-mail',0.00,'2019-08-26 04:43:48','2019-08-26 04:43:48');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `languages_code_unique` (`code`),
  UNIQUE KEY `languages_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (5,'es','Español','2019-09-25 02:46:34','2019-09-25 02:46:34',NULL),(6,'en','Ingles','2019-09-25 02:46:35','2019-09-25 02:46:35',NULL),(7,'pt','Portugues','2019-09-25 02:46:35','2019-09-25 02:46:35',NULL),(8,'it','Italiano','2019-09-25 02:46:35','2019-09-25 02:46:35',NULL);

--
-- Table structure for table `measurements`
--

CREATE TABLE `measurements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cmi_id` int(10) unsigned NOT NULL,
  `result` decimal(11,2) DEFAULT NULL,
  `result_date` date DEFAULT NULL,
  `estimated_result` decimal(11,2) DEFAULT NULL,
  `estimated_date` date DEFAULT NULL,
  `deviation` decimal(5,2) DEFAULT NULL,
  `type` enum('A','M') COLLATE utf8_unicode_ci DEFAULT NULL,
  `responsable_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `measurements_cmi_id_foreign` (`cmi_id`),
  KEY `measurements_responsable_id_foreign` (`responsable_id`),
  CONSTRAINT `measurements_cmi_id_foreign` FOREIGN KEY (`cmi_id`) REFERENCES `cmis` (`id`) ON DELETE CASCADE,
  CONSTRAINT `measurements_responsable_id_foreign` FOREIGN KEY (`responsable_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=457 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `measurements`
--

INSERT INTO `measurements` VALUES (1,7,28.00,'2019-08-08',29.00,'2019-08-08',3.45,NULL,NULL,'2019-07-30 01:35:35','2019-08-27 21:14:47'),(2,7,28.00,'2019-08-15',28.00,'2019-08-15',0.00,NULL,NULL,'2019-07-30 01:35:35','2019-08-27 21:15:09'),(3,7,29.00,'2019-08-22',27.00,'2019-08-22',-7.41,NULL,NULL,'2019-07-30 01:35:35','2019-08-28 01:06:46'),(4,7,19.00,'2019-08-30',26.00,'2019-08-29',0.00,NULL,NULL,'2019-07-30 01:35:36','2020-03-08 05:46:23'),(5,7,-1.00,'2020-03-07',25.00,'2019-09-05',200.00,NULL,NULL,'2019-07-30 01:35:36','2020-03-08 05:54:52'),(6,7,NULL,NULL,24.00,'2019-09-12',NULL,NULL,NULL,'2019-07-30 01:35:36','2019-07-30 01:35:36'),(7,7,NULL,NULL,23.00,'2019-09-19',NULL,NULL,NULL,'2019-07-30 01:35:36','2019-07-30 01:35:36'),(8,7,NULL,NULL,22.00,'2019-09-26',NULL,NULL,NULL,'2019-07-30 01:35:37','2019-07-30 01:35:37'),(9,7,NULL,NULL,21.00,'2019-10-03',NULL,NULL,NULL,'2019-07-30 01:35:37','2019-07-30 01:35:37'),(10,7,NULL,NULL,20.00,'2019-10-10',NULL,NULL,NULL,'2019-07-30 01:35:37','2019-07-30 01:35:37'),(11,7,NULL,NULL,20.00,'2019-10-17',NULL,NULL,NULL,'2019-07-30 01:35:37','2019-07-30 01:35:37'),(12,7,NULL,NULL,19.00,'2019-10-24',NULL,NULL,NULL,'2019-07-30 01:35:37','2019-07-30 01:35:37'),(13,7,NULL,NULL,18.00,'2019-10-31',NULL,NULL,NULL,'2019-07-30 01:35:37','2019-07-30 01:35:37'),(14,7,NULL,NULL,17.00,'2019-11-07',NULL,NULL,NULL,'2019-07-30 01:35:38','2019-07-30 01:35:38'),(15,7,NULL,NULL,16.00,'2019-11-14',NULL,NULL,NULL,'2019-07-30 01:35:38','2019-07-30 01:35:38'),(16,7,NULL,NULL,15.00,'2019-11-21',NULL,NULL,NULL,'2019-07-30 01:35:38','2019-07-30 01:35:38'),(17,7,NULL,NULL,14.00,'2019-11-28',NULL,NULL,NULL,'2019-07-30 01:35:38','2019-07-30 01:35:38'),(18,7,NULL,NULL,13.00,'2019-12-05',NULL,NULL,NULL,'2019-07-30 01:35:38','2019-07-30 01:35:38'),(19,7,NULL,NULL,12.00,'2019-12-12',NULL,NULL,NULL,'2019-07-30 01:35:38','2019-07-30 01:35:38'),(20,7,NULL,NULL,11.00,'2019-12-19',NULL,NULL,NULL,'2019-07-30 01:35:38','2019-07-30 01:35:38'),(21,7,NULL,NULL,10.00,'2019-12-26',NULL,NULL,NULL,'2019-07-30 01:35:38','2019-07-30 01:35:38'),(22,9,7.00,'2019-08-26',7.00,'2019-09-01',0.00,NULL,NULL,'2019-08-26 04:42:27','2019-08-27 21:39:47'),(23,9,9.00,'2019-10-01',9.00,'2019-10-01',0.00,NULL,NULL,'2019-08-26 04:42:27','2019-08-29 01:19:09'),(24,9,11.00,'2019-11-01',10.00,'2019-11-01',0.00,NULL,NULL,'2019-08-26 04:42:27','2019-08-29 02:53:32'),(25,9,NULL,NULL,12.00,'2019-12-01',NULL,NULL,NULL,'2019-08-26 04:42:27','2019-08-26 04:42:27'),(312,34,12.00,'2019-12-01',11.00,'2019-12-01',0.00,NULL,NULL,'2019-09-12 22:44:01','2019-09-13 03:55:08'),(313,34,NULL,NULL,11.00,'2020-01-01',NULL,NULL,NULL,'2019-09-12 22:44:01','2019-09-12 22:44:01'),(314,34,NULL,NULL,12.00,'2020-02-01',NULL,NULL,NULL,'2019-09-12 22:44:01','2019-09-12 22:44:01'),(315,34,NULL,NULL,12.00,'2020-03-01',NULL,NULL,NULL,'2019-09-12 22:44:01','2019-09-12 22:44:01'),(316,34,NULL,NULL,12.00,'2020-04-01',NULL,NULL,NULL,'2019-09-12 22:44:01','2019-09-12 22:44:01'),(317,35,6.00,'2019-12-01',5.00,'2019-12-01',0.00,NULL,NULL,'2019-09-12 22:44:01','2019-09-12 23:30:40'),(318,35,NULL,NULL,5.00,'2020-01-01',NULL,NULL,NULL,'2019-09-12 22:44:02','2019-09-12 22:44:02'),(319,35,NULL,NULL,6.00,'2020-02-01',NULL,NULL,NULL,'2019-09-12 22:44:02','2019-09-12 22:44:02'),(320,35,NULL,NULL,6.00,'2020-03-01',NULL,NULL,NULL,'2019-09-12 22:44:02','2019-09-12 22:44:02'),(321,35,NULL,NULL,6.00,'2020-04-01',NULL,NULL,NULL,'2019-09-12 22:44:02','2019-09-12 22:44:02'),(322,36,NULL,NULL,18.00,'2019-11-08',NULL,NULL,NULL,'2019-09-12 22:44:02','2019-09-12 22:44:02'),(323,36,NULL,NULL,17.00,'2019-11-15',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(324,36,NULL,NULL,17.00,'2019-11-22',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(325,36,NULL,NULL,16.00,'2019-11-29',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(326,36,NULL,NULL,15.00,'2019-12-06',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(327,36,NULL,NULL,14.00,'2019-12-13',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(328,36,NULL,NULL,13.00,'2019-12-20',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(329,36,NULL,NULL,13.00,'2019-12-27',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(330,36,NULL,NULL,12.00,'2020-01-03',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(331,36,NULL,NULL,11.00,'2020-01-10',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(332,36,NULL,NULL,10.00,'2020-01-17',NULL,NULL,NULL,'2019-09-12 22:44:03','2019-09-12 22:44:03'),(333,36,NULL,NULL,9.00,'2020-01-24',NULL,NULL,NULL,'2019-09-12 22:44:04','2019-09-12 22:44:04'),(334,36,NULL,NULL,9.00,'2020-01-31',NULL,NULL,NULL,'2019-09-12 22:44:04','2019-09-12 22:44:04'),(335,36,NULL,NULL,8.00,'2020-02-07',NULL,NULL,NULL,'2019-09-12 22:44:04','2019-09-12 22:44:04'),(336,36,NULL,NULL,7.00,'2020-02-14',NULL,NULL,NULL,'2019-09-12 22:44:04','2019-09-12 22:44:04'),(337,36,NULL,NULL,6.00,'2020-02-21',NULL,NULL,NULL,'2019-09-12 22:44:04','2019-09-12 22:44:04'),(338,36,NULL,NULL,5.00,'2020-02-28',NULL,NULL,NULL,'2019-09-12 22:44:04','2019-09-12 22:44:04'),(339,36,NULL,NULL,5.00,'2020-03-06',NULL,NULL,NULL,'2019-09-12 22:44:04','2019-09-12 22:44:04'),(340,36,NULL,NULL,4.00,'2020-03-13',NULL,NULL,NULL,'2019-09-12 22:44:04','2019-09-12 22:44:04'),(341,36,NULL,NULL,3.00,'2020-03-20',NULL,NULL,NULL,'2019-09-12 22:44:05','2019-09-12 22:44:05'),(342,36,NULL,NULL,2.00,'2020-03-27',NULL,NULL,NULL,'2019-09-12 22:44:05','2019-09-12 22:44:05'),(343,36,NULL,NULL,1.00,'2020-04-03',NULL,NULL,NULL,'2019-09-12 22:44:05','2019-09-12 22:44:05'),(344,36,NULL,NULL,1.00,'2020-04-10',NULL,NULL,NULL,'2019-09-12 22:44:05','2019-09-12 22:44:05'),(345,36,NULL,NULL,0.00,'2020-04-17',NULL,NULL,NULL,'2019-09-12 22:44:05','2019-09-12 22:44:05'),(346,36,NULL,NULL,-1.00,'2020-04-24',NULL,NULL,NULL,'2019-09-12 22:44:05','2019-09-12 22:44:05'),(347,37,NULL,NULL,9.00,'2019-12-01',NULL,NULL,NULL,'2019-09-12 22:44:05','2019-09-12 22:44:05'),(348,37,NULL,NULL,10.00,'2020-01-01',NULL,NULL,NULL,'2019-09-12 22:44:06','2019-09-12 22:44:06'),(349,37,NULL,NULL,12.00,'2020-02-01',NULL,NULL,NULL,'2019-09-12 22:44:06','2019-09-12 22:44:06'),(350,37,NULL,NULL,13.00,'2020-03-01',NULL,NULL,NULL,'2019-09-12 22:44:06','2019-09-12 22:44:06'),(351,37,NULL,NULL,15.00,'2020-04-01',NULL,NULL,NULL,'2019-09-12 22:44:06','2019-09-12 22:44:06'),(392,42,NULL,NULL,1.00,'2019-12-01',NULL,NULL,NULL,'2019-09-13 04:50:25','2019-09-13 04:50:25'),(393,42,NULL,NULL,2.00,'2020-01-01',NULL,NULL,NULL,'2019-09-13 04:50:25','2019-09-13 04:50:25'),(394,42,NULL,NULL,2.00,'2020-02-01',NULL,NULL,NULL,'2019-09-13 04:50:25','2019-09-13 04:50:25'),(395,42,NULL,NULL,3.00,'2020-03-01',NULL,NULL,NULL,'2019-09-13 04:50:25','2019-09-13 04:50:25'),(396,43,NULL,NULL,19.00,'2019-11-08',NULL,NULL,NULL,'2019-09-13 04:52:47','2019-09-13 04:52:47'),(397,43,NULL,NULL,19.00,'2019-11-15',NULL,NULL,NULL,'2019-09-13 04:52:47','2019-09-13 04:52:47'),(398,43,NULL,NULL,18.00,'2019-11-22',NULL,NULL,NULL,'2019-09-13 04:52:47','2019-09-13 04:52:47'),(399,43,NULL,NULL,18.00,'2019-11-29',NULL,NULL,NULL,'2019-09-13 04:52:47','2019-09-13 04:52:47'),(400,43,NULL,NULL,17.00,'2019-12-06',NULL,NULL,NULL,'2019-09-13 04:52:47','2019-09-13 04:52:47'),(401,43,NULL,NULL,17.00,'2019-12-13',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(402,43,NULL,NULL,16.00,'2019-12-20',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(403,43,NULL,NULL,15.00,'2019-12-27',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(404,43,NULL,NULL,15.00,'2020-01-03',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(405,43,NULL,NULL,14.00,'2020-01-10',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(406,43,NULL,NULL,14.00,'2020-01-17',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(407,43,NULL,NULL,13.00,'2020-01-24',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(408,43,NULL,NULL,13.00,'2020-01-31',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(409,43,NULL,NULL,12.00,'2020-02-07',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(410,43,NULL,NULL,11.00,'2020-02-14',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(411,43,NULL,NULL,11.00,'2020-02-21',NULL,NULL,NULL,'2019-09-13 04:52:48','2019-09-13 04:52:48'),(412,43,NULL,NULL,10.00,'2020-02-28',NULL,NULL,NULL,'2019-09-13 04:52:49','2019-09-13 04:52:49'),(413,43,NULL,NULL,10.00,'2020-03-06',NULL,NULL,NULL,'2019-09-13 04:52:49','2019-09-13 04:52:49'),(414,43,NULL,NULL,9.00,'2020-03-13',NULL,NULL,NULL,'2019-09-13 04:52:49','2019-09-13 04:52:49'),(415,43,NULL,NULL,9.00,'2020-03-20',NULL,NULL,NULL,'2019-09-13 04:52:49','2019-09-13 04:52:49'),(416,43,NULL,NULL,8.00,'2020-03-27',NULL,NULL,NULL,'2019-09-13 04:52:49','2019-09-13 04:52:49'),(417,44,NULL,NULL,11.00,'2019-12-01',NULL,NULL,NULL,'2019-09-21 19:31:20','2019-09-21 19:31:20'),(418,44,NULL,NULL,11.00,'2020-01-01',NULL,NULL,NULL,'2019-09-21 19:31:20','2019-09-21 19:31:20'),(419,44,NULL,NULL,12.00,'2020-02-01',NULL,NULL,NULL,'2019-09-21 19:31:20','2019-09-21 19:31:20'),(420,44,NULL,NULL,12.00,'2020-03-01',NULL,NULL,NULL,'2019-09-21 19:31:21','2019-09-21 19:31:21'),(421,44,NULL,NULL,12.00,'2020-04-01',NULL,NULL,NULL,'2019-09-21 19:31:21','2019-09-21 19:31:21'),(422,45,NULL,NULL,5.00,'2019-12-01',NULL,NULL,NULL,'2019-09-21 19:31:21','2019-09-21 19:31:21'),(423,45,NULL,NULL,5.00,'2020-01-01',NULL,NULL,NULL,'2019-09-21 19:31:21','2019-09-21 19:31:21'),(424,45,NULL,NULL,6.00,'2020-02-01',NULL,NULL,NULL,'2019-09-21 19:31:21','2019-09-21 19:31:21'),(425,45,NULL,NULL,6.00,'2020-03-01',NULL,NULL,NULL,'2019-09-21 19:31:21','2019-09-21 19:31:21'),(426,45,NULL,NULL,6.00,'2020-04-01',NULL,NULL,NULL,'2019-09-21 19:31:21','2019-09-21 19:31:21'),(427,46,NULL,NULL,18.00,'2019-11-08',NULL,NULL,NULL,'2019-09-21 19:31:22','2019-09-21 19:31:22'),(428,46,NULL,NULL,17.00,'2019-11-15',NULL,NULL,NULL,'2019-09-21 19:31:22','2019-09-21 19:31:22'),(429,46,NULL,NULL,17.00,'2019-11-22',NULL,NULL,NULL,'2019-09-21 19:31:22','2019-09-21 19:31:22'),(430,46,NULL,NULL,16.00,'2019-11-29',NULL,NULL,NULL,'2019-09-21 19:31:22','2019-09-21 19:31:22'),(431,46,NULL,NULL,15.00,'2019-12-06',NULL,NULL,NULL,'2019-09-21 19:31:22','2019-09-21 19:31:22'),(432,46,NULL,NULL,14.00,'2019-12-13',NULL,NULL,NULL,'2019-09-21 19:31:22','2019-09-21 19:31:22'),(433,46,NULL,NULL,13.00,'2019-12-20',NULL,NULL,NULL,'2019-09-21 19:31:22','2019-09-21 19:31:22'),(434,46,NULL,NULL,13.00,'2019-12-27',NULL,NULL,NULL,'2019-09-21 19:31:23','2019-09-21 19:31:23'),(435,46,NULL,NULL,12.00,'2020-01-03',NULL,NULL,NULL,'2019-09-21 19:31:23','2019-09-21 19:31:23'),(436,46,NULL,NULL,11.00,'2020-01-10',NULL,NULL,NULL,'2019-09-21 19:31:23','2019-09-21 19:31:23'),(437,46,NULL,NULL,10.00,'2020-01-17',NULL,NULL,NULL,'2019-09-21 19:31:23','2019-09-21 19:31:23'),(438,46,NULL,NULL,9.00,'2020-01-24',NULL,NULL,NULL,'2019-09-21 19:31:23','2019-09-21 19:31:23'),(439,46,NULL,NULL,9.00,'2020-01-31',NULL,NULL,NULL,'2019-09-21 19:31:23','2019-09-21 19:31:23'),(440,46,NULL,NULL,8.00,'2020-02-07',NULL,NULL,NULL,'2019-09-21 19:31:23','2019-09-21 19:31:23'),(441,46,NULL,NULL,7.00,'2020-02-14',NULL,NULL,NULL,'2019-09-21 19:31:23','2019-09-21 19:31:23'),(442,46,NULL,NULL,6.00,'2020-02-21',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(443,46,NULL,NULL,5.00,'2020-02-28',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(444,46,NULL,NULL,5.00,'2020-03-06',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(445,46,NULL,NULL,4.00,'2020-03-13',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(446,46,NULL,NULL,3.00,'2020-03-20',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(447,46,NULL,NULL,2.00,'2020-03-27',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(448,46,NULL,NULL,1.00,'2020-04-03',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(449,46,NULL,NULL,1.00,'2020-04-10',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(450,46,NULL,NULL,0.00,'2020-04-17',NULL,NULL,NULL,'2019-09-21 19:31:24','2019-09-21 19:31:24'),(451,46,NULL,NULL,-1.00,'2020-04-24',NULL,NULL,NULL,'2019-09-21 19:31:25','2019-09-21 19:31:25'),(452,47,NULL,NULL,9.00,'2019-12-01',NULL,NULL,NULL,'2019-09-21 19:31:25','2019-09-21 19:31:25'),(453,47,NULL,NULL,10.00,'2020-01-01',NULL,NULL,NULL,'2019-09-21 19:31:25','2019-09-21 19:31:25'),(454,47,NULL,NULL,12.00,'2020-02-01',NULL,NULL,NULL,'2019-09-21 19:31:25','2019-09-21 19:31:25'),(455,47,NULL,NULL,13.00,'2020-03-01',NULL,NULL,NULL,'2019-09-21 19:31:25','2019-09-21 19:31:25'),(456,47,NULL,NULL,15.00,'2020-04-01',NULL,NULL,NULL,'2019-09-21 19:31:26','2019-09-21 19:31:26');

--
-- Table structure for table `measures`
--

CREATE TABLE `measures` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `abbr` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `measures_name_unique` (`name`),
  UNIQUE KEY `measures_abbr_unique` (`abbr`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `measures`
--

INSERT INTO `measures` VALUES (1,'Porcentaje','Ptj','2019-07-10 14:11:44','2019-07-10 14:11:44',NULL),(2,'Puntos','Pts','2019-07-10 14:11:44','2019-07-10 14:11:44',NULL),(3,'Cantidad','Cnt','2019-07-10 14:11:44','2019-07-10 14:11:44',NULL),(4,'Kilos','Kgs','2019-07-11 06:49:45','2019-07-23 19:59:27',NULL),(5,'Toneladas','Tns','2019-07-11 06:50:47','2019-07-11 06:54:04',NULL),(6,'Bolsas','Bls','2019-07-11 06:51:36','2019-09-22 19:05:04',NULL),(7,'Minutos','Mnt','2019-07-29 03:09:44','2019-07-29 03:09:44',NULL),(8,'Millones','Mll','2019-09-20 21:16:10','2019-09-20 21:16:52',NULL),(9,'Dias','Dis','2019-10-18 15:26:32','2019-10-18 15:26:45',NULL);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES ('2014_10_12_000000_create_users_table',1),('2014_10_12_100000_create_password_resets_table',1),('2018_07_16_163544_create_frequencies_table',1),('2018_07_16_185510_create_measures_table',1),('2018_07_16_233554_create_companies_table',1),('2018_07_16_234855_create_phases_table',1),('2018_07_16_234860_create_perspectives_table',1),('2018_07_19_004857_create_indicators_table',1),('2018_07_20_213840_create_parameters_table',1),('2018_07_30_171204_create_objectives_table',1),('2018_08_01_120947_create_cmis_table',1),('2018_08_07_150022_create_measurements_table',1),('2018_10_16_214013_create_initiatives_table',1),('2018_10_17_153803_create_tasks_table',1),('2018_10_27_191227_create_notes_table',1),('2019_07_10_175912_create_audits_table',2),('2019_07_10_180322_create_permission_tables',3),('2019_07_10_201550_add_softdelete_to_parameter_table',4),('2019_07_17_103739_add_softdelete_to_roles_table',5),('2019_07_17_114038_add_softdelete_to_permissions_table',6),('2019_07_17_194146_create_cruds_table',7),('2019_07_24_001904_add_softdelete_to_user_table',8),('2019_07_24_002926_delete_role_from_users_table',9),('2019_08_20_145527_add_colorhexa_to_objective_table',10),('2019_08_27_213714_create_countries_table',11),('2019_08_27_215656_add_country_to_phase_table',12),('2019_08_27_225802_add_country_to_user_table',13),('2019_09_03_135229_add_phase_to_objective_table',14),('2019_09_03_172314_modify_unique_idx_in_perspective_table',15),('2019_09_03_184332_modify_unique_idx_in_objectives_table',16),('2019_09_11_224244_modify_unique_name_in_phases_table',17),('2019_09_16_230225_drop_spatie_tables',18),('2015_01_20_084450_create_roles_table',19),('2015_01_20_084525_create_role_user_table',19),('2015_01_24_080208_create_permissions_table',19),('2015_01_24_080433_create_permission_role_table',19),('2015_12_04_003040_add_special_role_column',19),('2017_10_17_170735_create_permission_user_table',19),('2019_09_21_210320_drop_deleted_at_column_from_crud_table',20),('2019_09_24_193727_create_languages_table',21),('2019_09_24_210044_add_language_to_country_table',22),('2019_10_05_202731_add_sensible_column_to_cmi_table',23),('2019_12_31_014127_add_work_for_column_to_users',24),('2019_12_31_125647_add_is_ceo_column_to_users',25),('2020_01_31_201534_add_kpi_type_column_to_cmis',26),('2020_02_02_164526_add_on_board_column_to_cmis',26),('2020_02_06_125843_enlarge_mv_in_companies_table',26),('2020_02_10_144703_add_board_position_column_to_cmis',27),('2020_02_24_151528_add_vision1_column_to_companies_table',28),('2020_03_08_003758_change_value_to_decimal_in_cmis_table',29),('2020_03_08_011201_change_values_to_decimal_in_measurements_table',30),('2020_03_24_214301_add_api_url_column_to_cmis_table',31),('2020_03_25_223130_add_column_on_board_wd_to_cmis_table',32),('2020_03_28_221519_add_avatar_column_to_users_table',33);

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(10) unsigned NOT NULL,
  `comment` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notes_task_id_foreign` (`task_id`),
  KEY `notes_user_id_foreign` (`user_id`),
  CONSTRAINT `notes_task_id_foreign` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notes`
--

INSERT INTO `notes` VALUES (1,4,'Esta es la primera nota',1,'2019-08-25 21:58:59','2019-08-25 21:58:59'),(2,4,'Esta es la segunda nota de la primera tarea',1,'2019-08-25 22:00:00','2019-08-25 22:00:00'),(3,4,'Esta es la 3ra nota',1,'2019-08-27 01:49:06','2019-08-27 01:49:06'),(4,4,'Esta es la 4ta nota, la cual esta siendo creada únicamente para probar como se ve una tarea con varias notas en la venta modal',1,'2019-08-27 03:07:31','2019-08-27 03:07:31'),(5,4,'Nuevamente creamos otra nota, para poder evidenciar el comportamiento de la ventana cuando la cantiadad de notas exceda el tamaño de la ventana',1,'2019-08-27 03:10:34','2019-08-27 03:10:34');

--
-- Table structure for table `objectives`
--

CREATE TABLE `objectives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `phase_id` int(10) unsigned DEFAULT NULL,
  `perspective_id` int(10) unsigned NOT NULL,
  `result` decimal(5,2) DEFAULT NULL,
  `color` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `colorhexa` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `objectives_name_phase_id_unique` (`name`,`phase_id`),
  KEY `objectives_perspective_id_foreign` (`perspective_id`),
  KEY `objectives_phase_id_foreign` (`phase_id`),
  CONSTRAINT `objectives_perspective_id_foreign` FOREIGN KEY (`perspective_id`) REFERENCES `perspectives` (`id`),
  CONSTRAINT `objectives_phase_id_foreign` FOREIGN KEY (`phase_id`) REFERENCES `phases` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `objectives`
--

INSERT INTO `objectives` VALUES (6,'Optimizar Distribución, de Insumos',1,3,19.00,'bg-green','#28a745','2019-07-28 01:44:44','2020-03-08 05:46:35'),(12,'Incrementar Cuota, de Mercado',1,2,11.00,'bg-green','#28a745','2019-08-26 04:39:45','2020-01-25 20:07:43'),(176,'Reducir, los Costos',4,113,0.00,'bg-red','#dc3545','2019-09-12 22:44:00','2019-09-12 22:44:00'),(177,'Aumentar la, Rentabilidad',4,113,0.00,'bg-red','#dc3545','2019-09-12 22:44:00','2019-09-12 22:44:00'),(178,'Incrementar, las Ventas',4,113,0.00,'bg-red','#dc3545','2019-09-12 22:44:00','2019-09-12 22:44:00'),(179,'Aumentar la, Satisfacción de los Clientes',4,114,0.00,'bg-red','#dc3545','2019-09-12 22:44:01','2019-09-12 22:44:01'),(180,'Incrementar Cuota, de Mercado',4,114,0.00,'bg-green','#28a745','2019-09-12 22:44:01','2019-09-13 03:55:08'),(181,'Optimizar los, tiempos de Distribucion',4,115,0.00,'bg-red','#dc3545','2019-09-12 22:44:02','2019-09-12 22:44:02'),(182,'Implementar Política, Pocos Errores.',4,115,0.00,'bg-red','#dc3545','2019-09-12 22:44:05','2019-09-12 22:44:30'),(183,'Certifiación CCS, Couching para MaGa',4,116,0.00,'bg-red','#dc3545','2019-09-12 22:44:05','2019-09-12 22:44:05'),(184,'Formación Lean, Production para Mary y Dany',4,116,0.00,'bg-red','#dc3545','2019-09-12 22:44:06','2019-09-12 22:44:06'),(185,'Capacitacion, Flutter',4,116,0.00,'bg-red','#dc3545','2019-09-12 22:44:06','2019-09-12 22:44:06'),(197,'Reducir, los Costos',6,121,0.00,'bg-red','#dc3545','2019-09-21 19:31:20','2019-09-21 19:31:20'),(198,'Aumentar la, Rentabilidad',6,121,0.00,'bg-red','#dc3545','2019-09-21 19:31:20','2019-09-21 19:31:20'),(199,'Incrementar, las Ventas',6,121,0.00,'bg-red','#dc3545','2019-09-21 19:31:20','2019-09-21 19:31:20'),(200,'Aumentar la, Satisfacción de los Clientes',6,122,0.00,'bg-red','#dc3545','2019-09-21 19:31:20','2019-09-21 19:31:20'),(201,'Incrementar Cuota, de Mercado',6,122,0.00,'bg-red','#dc3545','2019-09-21 19:31:20','2019-09-21 19:31:20'),(202,'Optimizar los, tiempos de Distribucion',6,123,0.00,'bg-red','#dc3545','2019-09-21 19:31:22','2019-09-21 19:31:22'),(203,'Implementar Política, Cero Errores !!!',6,123,0.00,'bg-red','#dc3545','2019-09-21 19:31:25','2019-09-21 19:31:25'),(204,'Certifiación CCS, Couching para MaGa',6,124,0.00,'bg-red','#dc3545','2019-09-21 19:31:25','2019-09-21 19:31:25'),(205,'Formación Lean, Production para Mary y Dany',6,124,0.00,'bg-red','#dc3545','2019-09-21 19:31:26','2019-09-21 19:31:26'),(206,'Capacitacion, Flutter',6,124,0.00,'bg-red','#dc3545','2019-09-21 19:31:26','2019-09-21 19:31:26'),(207,'Curso, VueJS',6,124,0.00,'bg-red','#dc3545','2019-09-21 19:31:26','2019-09-21 19:31:26'),(212,'Incrementar, las ventas',1,1,0.00,'bg-red','#dc3545','2020-01-26 18:51:06','2020-01-26 18:51:06'),(213,'Curso de, Excel',1,4,0.00,'bg-red','#dc3545','2020-03-13 05:14:31','2020-03-13 05:14:31'),(214,'Apoyo al Emprendedor',1,125,0.00,'bg-red','#dc3545','2020-03-13 05:14:49','2020-03-13 05:14:49');

--
-- Table structure for table `parameters`
--

CREATE TABLE `parameters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `index` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `text1` text COLLATE utf8_unicode_ci,
  `text2` text COLLATE utf8_unicode_ci,
  `text3` text COLLATE utf8_unicode_ci,
  `text4` text COLLATE utf8_unicode_ci,
  `text5` text COLLATE utf8_unicode_ci,
  `value1` decimal(14,2) DEFAULT NULL,
  `value2` decimal(14,2) DEFAULT NULL,
  `value3` decimal(14,2) DEFAULT NULL,
  `value4` decimal(14,2) DEFAULT NULL,
  `value5` decimal(14,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `parameters_index_code_unique` (`index`,`code`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `parameters`
--

INSERT INTO `parameters` VALUES (1,'FreqFunc','1','Meses','addMonth',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:41','2019-07-10 14:11:41',NULL),(2,'FreqFunc','2','Semanas','addWeek',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:41','2019-07-10 14:11:41',NULL),(3,'FreqFunc','3','Dias','addDay',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:41','2019-07-10 14:11:41',NULL),(4,'FreqFunc','4','Horas','addHour',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:41','2019-07-10 14:11:41',NULL),(5,'ObjecColor','1','Verde','success-gradient',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:41','2019-07-10 14:11:41',NULL),(6,'ObjecColor','2','Azul Claro','info-gradient',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:41','2019-07-10 14:11:41',NULL),(7,'ObjecColor','3','Azul Activo','primary-gradient',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:41','2019-07-10 14:11:41',NULL),(8,'ObjecColor','4','Rojo','danger-gradient',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:41','2019-07-10 14:11:41',NULL),(9,'ObjecColor','5','Amarillo','warning-gradient',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:42','2019-07-10 14:11:42',NULL),(10,'ObjecColor','6','Oscuro','dark-gradient',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:42','2019-07-10 14:11:42',NULL),(12,'KpiDirecti','A','Alza',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:42','2019-07-10 14:11:42',NULL),(13,'KpiDirecti','B','Baja',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:42','2019-07-10 14:11:42',NULL),(14,'KpiTypes','A','Automatizado',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:42','2019-07-10 14:11:42',NULL),(15,'KpiTypes','M','Manual',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-07-10 14:11:42','2019-07-10 14:11:42',NULL),(16,'active','country','Active Country Id',NULL,NULL,NULL,NULL,NULL,1.00,NULL,NULL,NULL,NULL,'2019-09-12 21:23:22','2019-10-02 19:20:28',NULL),(17,'FreqFunc','5','1 y 15 c/mes','specificDays','1,15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'FreqFunc','6','1ero c/mes','specificDays','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'FreqFunc','7','Ultimo de mes','endOfMonth',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'FreqFunc','8','Primero de mes','firstOfMonth',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Temporary table structure for view `pending_measurements`
--

/*!50001 DROP VIEW IF EXISTS `pending_measurements`*/;
/*!50001 CREATE VIEW `pending_measurements` AS SELECT 
 1 AS `kpi_id`,
 1 AS `kpi_description`,
 1 AS `initiative_id`,
 1 AS `initiative_description`,
 1 AS `measurement_id`,
 1 AS `estimated_date`,
 1 AS `estimated_result`,
 1 AS `responsable_id`,
 1 AS `email`,
 1 AS `days`*/;

--
-- Temporary table structure for view `pending_tasks`
--

/*!50001 DROP VIEW IF EXISTS `pending_tasks`*/;
/*!50001 CREATE VIEW `pending_tasks` AS SELECT 
 1 AS `kpi_id`,
 1 AS `kpi_description`,
 1 AS `initiative_id`,
 1 AS `initiative_description`,
 1 AS `task_id`,
 1 AS `task_description`,
 1 AS `init_date`,
 1 AS `due_date`,
 1 AS `responsable_id`,
 1 AS `email`,
 1 AS `days`,
 1 AS `done`*/;

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_role_permission_id_index` (`permission_id`),
  KEY `permission_role_role_id_index` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` VALUES (20,92,5,'2019-09-22 01:36:52','2019-09-22 01:36:52'),(21,88,5,'2019-09-22 01:36:52','2019-09-22 01:36:52'),(22,90,5,'2019-09-22 01:36:52','2019-09-22 01:36:52'),(23,60,5,'2019-09-22 01:36:52','2019-09-22 01:36:52'),(24,56,5,'2019-09-22 01:36:52','2019-09-22 01:36:52'),(25,58,5,'2019-09-22 01:36:52','2019-09-22 01:36:52'),(32,100,5,'2019-09-22 01:36:53','2019-09-22 01:36:53'),(33,96,5,'2019-09-22 01:36:53','2019-09-22 01:36:53'),(34,98,5,'2019-09-22 01:36:53','2019-09-22 01:36:53'),(35,120,5,'2019-09-22 01:57:32','2019-09-22 01:57:32'),(36,121,5,'2019-09-22 01:57:32','2019-09-22 01:57:32'),(37,81,6,'2019-09-22 03:59:17','2019-09-22 03:59:17'),(38,86,6,'2019-09-22 03:59:17','2019-09-22 03:59:17'),(39,84,6,'2019-09-22 03:59:18','2019-09-22 03:59:18'),(40,85,6,'2019-09-22 03:59:18','2019-09-22 03:59:18'),(41,83,6,'2019-09-22 03:59:18','2019-09-22 03:59:18'),(42,80,6,'2019-09-22 03:59:18','2019-09-22 03:59:18'),(43,87,6,'2019-09-22 03:59:18','2019-09-22 03:59:18'),(44,82,6,'2019-09-22 03:59:18','2019-09-22 03:59:18'),(45,121,6,'2019-09-22 03:59:18','2019-09-22 03:59:18'),(46,65,7,'2019-09-22 04:00:03','2019-09-22 04:00:03'),(47,70,7,'2019-09-22 04:00:03','2019-09-22 04:00:03'),(48,68,7,'2019-09-22 04:00:03','2019-09-22 04:00:03'),(49,69,7,'2019-09-22 04:00:04','2019-09-22 04:00:04'),(50,67,7,'2019-09-22 04:00:04','2019-09-22 04:00:04'),(51,64,7,'2019-09-22 04:00:04','2019-09-22 04:00:04'),(52,71,7,'2019-09-22 04:00:04','2019-09-22 04:00:04'),(53,66,7,'2019-09-22 04:00:04','2019-09-22 04:00:04'),(54,121,7,'2019-09-22 04:00:04','2019-09-22 04:00:04'),(55,122,6,'2019-09-22 17:40:27','2019-09-22 17:40:27'),(56,116,6,'2019-09-22 17:40:27','2019-09-22 17:40:27'),(57,112,6,'2019-09-22 17:40:27','2019-09-22 17:40:27'),(58,138,6,'2019-09-22 17:46:29','2019-09-22 17:46:29'),(59,123,2,'2019-10-08 03:14:01','2019-10-08 03:14:01'),(60,132,2,'2019-10-08 03:14:01','2019-10-08 03:14:01'),(61,133,2,'2019-10-08 03:14:01','2019-10-08 03:14:01'),(62,137,2,'2019-10-08 03:14:01','2019-10-08 03:14:01'),(63,128,2,'2019-10-08 03:14:01','2019-10-08 03:14:01'),(64,136,2,'2019-10-08 03:14:01','2019-10-08 03:14:01'),(65,125,2,'2019-10-08 03:14:02','2019-10-08 03:14:02'),(66,142,2,'2019-10-08 03:14:02','2019-10-08 03:14:02'),(67,138,2,'2019-10-08 03:14:02','2019-10-08 03:14:02'),(68,96,2,'2019-10-08 03:14:02','2019-10-08 03:14:02'),(69,98,2,'2019-10-08 03:14:02','2019-10-08 03:14:02'),(70,104,2,'2019-10-08 03:14:02','2019-10-08 03:14:02'),(71,106,2,'2019-10-08 03:14:02','2019-10-08 03:14:02'),(72,72,2,'2019-10-08 03:14:02','2019-10-08 03:14:02'),(73,74,2,'2019-10-08 03:14:02','2019-10-08 03:14:02');

--
-- Table structure for table `permission_user`
--

CREATE TABLE `permission_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` bigint(20) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_user_permission_id_index` (`permission_id`),
  KEY `permission_user_user_id_index` (`user_id`),
  CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_user`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--



--
-- Table structure for table `perspectives`
--

CREATE TABLE `perspectives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `order` smallint(6) NOT NULL,
  `phase_id` int(10) unsigned NOT NULL,
  `color` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `perspectives_name_phase_id_unique` (`name`,`phase_id`),
  KEY `perspectives_phase_id_foreign` (`phase_id`),
  CONSTRAINT `perspectives_phase_id_foreign` FOREIGN KEY (`phase_id`) REFERENCES `phases` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `perspectives`
--

INSERT INTO `perspectives` VALUES (1,'Financial',1,1,'2','2019-07-10 14:11:44','2019-09-04 06:22:46',NULL),(2,'Customers',2,1,'3','2019-07-10 14:11:44','2019-09-04 06:22:47',NULL),(3,'Processes',3,1,'1','2019-07-28 01:44:14','2019-09-04 06:22:47',NULL),(4,'Peopel',4,1,'5','2019-07-28 01:44:55','2019-10-18 05:45:36',NULL),(113,'Financiera',1,4,'2','2019-09-12 22:44:00','2019-09-12 22:44:00',NULL),(114,'Cliente',2,4,'3','2019-09-12 22:44:00','2019-09-12 22:44:00',NULL),(115,'Procesos',3,4,'1','2019-09-12 22:44:02','2019-09-12 22:44:02',NULL),(116,'Gente',4,4,'5','2019-09-12 22:44:05','2019-09-12 22:44:05',NULL),(121,'Financiera',1,6,'2','2019-09-21 19:31:19','2019-09-21 19:31:19',NULL),(122,'Cliente',2,6,'3','2019-09-21 19:31:20','2019-09-21 19:31:20',NULL),(123,'Procesos',3,6,'1','2019-09-21 19:31:21','2019-09-21 19:31:21',NULL),(124,'Gente',4,6,'5','2019-09-21 19:31:25','2019-09-21 19:31:25',NULL),(125,'Social',5,1,'4','2020-03-13 05:13:43','2020-03-13 05:16:34','2020-03-13 05:16:34');

--
-- Table structure for table `phases`
--

CREATE TABLE `phases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `country_id` int(10) unsigned DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `active` tinyint(1) NOT NULL,
  `pessimistic` tinyint(1) NOT NULL DEFAULT '1',
  `perspective_o` decimal(5,2) DEFAULT '70.00',
  `perspective_a` decimal(5,2) DEFAULT '60.00',
  `perspective_d` decimal(5,2) DEFAULT '50.00',
  `objective_o` decimal(5,2) DEFAULT '70.00',
  `objective_a` decimal(5,2) DEFAULT '60.00',
  `objective_d` decimal(5,2) DEFAULT '50.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `phases_name_country_id_unique` (`name`,`country_id`),
  KEY `phases_country_id_foreign` (`country_id`),
  CONSTRAINT `phases_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phases`
--

INSERT INTO `phases` VALUES (1,'First',1,'2018-08-01','2020-02-28',1,0,70.00,60.00,50.00,70.00,60.00,50.00,'2019-07-10 14:11:44','2019-10-03 17:44:58'),(4,'First',2,'2019-11-01','2020-04-30',1,1,70.00,60.00,50.00,70.00,60.00,50.00,'2019-09-12 02:51:34','2019-09-12 02:51:34'),(6,'Tercera',1,'2019-11-01','2020-04-30',0,1,70.00,60.00,50.00,70.00,60.00,50.00,'2019-09-12 22:31:31','2019-10-03 17:44:58'),(7,'Second',1,'2020-03-01','2020-12-31',0,0,65.00,60.00,50.00,65.00,60.00,50.00,'2019-09-21 19:33:58','2019-09-24 22:15:34');

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `role_user_role_id_index` (`role_id`),
  KEY `role_user_user_id_index` (`user_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` VALUES (1,1,1,NULL,NULL),(2,2,7,'2019-09-18 19:57:44','2019-09-18 19:57:44'),(6,6,4,'2019-09-22 04:00:28','2019-09-22 04:00:28');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `special` enum('all-access','no-access') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin','admin','System Administrator','2019-09-17 16:53:02','2019-09-17 16:53:02','all-access'),(2,'Manager','manager','Gerente de Departamento','2019-09-18 18:30:08','2019-09-20 04:09:21',NULL),(5,'Visitor','visitor','Visitor','2019-09-22 01:35:46','2019-09-22 01:35:46',NULL),(6,'Solo Dimensions','dimensions','Solo Dimensions','2019-09-22 03:58:48','2019-09-22 03:58:48',NULL),(7,'Solo Frequencies','frequency','Solo Frequencies','2019-09-22 03:59:47','2019-09-22 03:59:47',NULL);

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `initiative_id` int(10) unsigned NOT NULL,
  `description` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `init_date` date NOT NULL,
  `due_date` date NOT NULL,
  `done` decimal(5,2) DEFAULT NULL,
  `notes` text COLLATE utf8_unicode_ci,
  `responsable_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tasks_initiative_id_foreign` (`initiative_id`),
  KEY `tasks_responsable_id_foreign` (`responsable_id`),
  CONSTRAINT `tasks_initiative_id_foreign` FOREIGN KEY (`initiative_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tasks_responsable_id_foreign` FOREIGN KEY (`responsable_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` VALUES (4,3,'Tarea 1 de la Inicitiva Test','2019-08-11','2019-08-15',20.00,NULL,1,'2019-08-01 05:12:53','2019-08-27 01:48:37'),(7,4,'Debe considerar los registros con softdelete','2019-08-30','2019-09-15',20.00,NULL,1,'2019-08-24 01:20:26','2019-08-24 01:54:02'),(8,7,'Pedir al proveedor de Sistema que implemente la relación recomendado-recomendador','2019-09-01','2019-09-23',0.00,NULL,4,'2019-08-26 04:44:51','2019-09-29 20:22:32'),(9,7,'Implementar política de descuento por recomendación','2019-09-01','2019-10-15',0.00,NULL,4,'2019-08-26 04:45:27','2019-09-29 20:22:48'),(10,3,'Nueva tarea que debe ser asignada a un responsable','2020-02-15','2020-02-28',0.00,NULL,7,'2020-01-06 03:37:26','2020-01-06 03:37:26');

--
-- Final view structure for view `pending_measurements`
--

/*!50001 DROP VIEW IF EXISTS `pending_measurements`*/;

--
-- Final view structure for view `pending_tasks`
--

/*!50001 DROP VIEW IF EXISTS `pending_tasks`*/;


