--
-- Host: localhost    Database: cmitucu
-- ------------------------------------------------------


--
-- 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=2602 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=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `cmis` VALUES (1,1,1,1,'Ganacia mensual CT','Cant de dólares ganados por CT','kpi',3,16,0.00,1000.00,900.00,700.00,'A',0.00,0.00,NULL,3,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-11-20 22:29:27','2020-11-21 13:09:16'),(2,1,1,15,'Ganancia por Tostión','Cantidad de dólares obtenidos por tostion a otros','kpi',3,16,0.00,380.00,250.00,200.00,'A',0.00,0.00,NULL,3,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-11-30 21:34:41','2020-11-30 21:45:17'),(3,1,1,18,'Ganacia mensual CC','Cant de dólares ganados por CC','kpi',3,16,0.00,15000.00,12000.00,10000.00,'A',0.00,0.00,NULL,3,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-11-30 21:56:19','2020-11-30 21:56:19'),(4,1,2,3,'Engagement IG','Porcentaje de enganche en IG','kpi',1,16,10.00,25.00,20.00,15.00,'A',0.00,0.00,NULL,4,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-11-30 22:36:31','2020-11-30 22:37:49'),(5,1,2,3,'Notoriedad de la marca','Porcentaje de Reconocimiento de la marca','kpi',1,16,0.00,60.00,50.00,35.00,'A',0.00,0.00,NULL,4,'M','N',NULL,NULL,0,'2021-02-01','2021-12-31','','2020-11-30 22:40:51','2020-11-30 22:46:56'),(6,1,2,3,'Nro de Embajadores','Involucración con la marca','kpi',1,16,1.00,80.00,50.00,30.00,'A',0.00,0.00,NULL,4,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-11-30 23:04:33','2020-11-30 23:04:33'),(7,1,3,5,'Cant de Kg producidos','Cantida de kg producidos/mes','kpi',3,16,0.00,450.00,400.00,350.00,'A',0.00,0.00,NULL,3,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-11-30 23:27:38','2020-11-30 23:27:38'),(8,1,2,13,'Cant de Clientes Fidelizados','Cantidad de Clientes que compran de manera reiterativa','kpi',3,16,3.00,450.00,320.00,250.00,'A',0.00,0.00,NULL,4,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-12-04 22:01:10','2020-12-04 22:01:10'),(9,1,3,8,'Cant de Kg producidos CC','Cantida de kg producidos/mes CC','kpi',3,16,35.00,4500.00,3000.00,2000.00,'A',0.00,0.00,NULL,3,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-12-04 22:27:57','2020-12-04 22:27:57'),(10,1,3,16,'Cant de Prod de Café Dif','Cantidad de Caficultores/Productores de CD','kpi',3,16,3.00,30.00,20.00,10.00,'A',0.00,0.00,NULL,3,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-12-04 22:36:47','2020-12-04 22:36:47'),(11,1,3,17,'Cant de Cafeterías o Restaurantes o Bodegones','Cantida de Cafeterías donde se degusta CT','kpi',3,16,2.00,30.00,25.00,15.00,'A',0.00,0.00,NULL,4,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-12-04 22:52:24','2020-12-04 22:52:24'),(12,1,3,17,'Cant de Clientes por Internet','Cant de Clientes obtenidos por Pág Web','kpi',3,16,0.00,400.00,200.00,100.00,'A',0.00,0.00,NULL,4,'M','N',NULL,NULL,0,'2021-01-01','2021-12-31','','2020-12-04 22:58:13','2020-12-04 22:58:13');

--
-- 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,'Café Tucusito','Juvenal y Shahrazad','Ofrecer al consumidor un producto que cumpla con los estándares de calidad interncionales.  Con características de cuerpo, sabor y aromas, privilegiados, propios de un café difirenciado y bajo la premisa del trato justo con el productor.\r\nLograr que en Venezuela se produzca, se consuma, se comercialice y exporte Café de tipo Diferenciado y de Especialidad.','Ser reconocidos como la compañía tostadora de café de mayor calidad en Venezuela. Dando la oportunidad al mundo de disfrutar un café venezolano de especialidad que promueva la caficultura sostenible.','En un año tendremos y/o seremos:\r\n- Joint Venture con 4 negocios de café en Caracas y 2 en el interior.\r\n- Negociación con dueños de cafeterías donde solo nosotros venderíamos Café Tucusito. Logrando el posicionamiento de nuestra marca. Logrando también que aumente el consumo de café especial en Venezuela.\r\n- Una cuenta activa de instagram para vender por internet 450 kg mensuales.\r\n- Café Yautana a cafeterías y restaurantes en Caracacas(50 en Ccs y 20 en el interior) 1.500 kg mensuales.\r\n- Vender Café Yautana 3.000 kg. mensuales en los supermercados (hacer joint venture con el negrito u otra torrefactora grande).\r\n- Tener un local más grande, tostadora más grande, molino industrial. Pensando en maquinarias para empaquetado.','En 3 años tendremos y/o seremos:\r\n- Tener 2 cafeterías propias en Caracas y una en el interior.\r\n- Exportar café verde y tostado de especialidad 10.000kg al año.USA, Chile y España\r\n-Tener en Caracas Joint Venture con 6 negocios de café y 6 en el interior  \r\n- Joint venture con alguien en España. Sede en España.\r\n- Vender Café Yautana en toda Venezuela. 20.000kg mensuales','En 5 años tendremos y/o seremos:\r\n- La empresa de café especial más importante en Venezuela.\r\n- Exportar café verde y tostado de especialidad 48.0000 kg al año.\r\n- Joint venture o cafetería propia en Londres o Estocolmo y la segunda en España.\r\n- Tener 06 cafeterías en Caracas, 06 en el interior.','Ética, Calidad e Innovación',NULL,'2020-11-20 15:09:02');

--
-- 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=2 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);

--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `initiatives` VALUES (1,8,'Promocionar el consumo en Cafeterías',0.00,'2020-12-04 22:01:42','2020-12-04 22:01:42'),(2,8,'Promocionar el consumo en Restaurantes',0.00,'2020-12-04 22:02:16','2020-12-04 22:02:16'),(3,8,'Alianzas comerciales y de promoción (Licores, Chocolates y Vinos)',0.00,'2020-12-04 22:05:45','2020-12-04 22:06:59'),(4,10,'Conversar con los productores',0.00,'2020-12-04 22:38:32','2020-12-04 22:38:32'),(5,10,'Publicidad de Café, para que los productores nos llamen',0.00,'2020-12-04 22:39:24','2020-12-04 22:39:24');

--
-- 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=228 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `measurements` VALUES (37,1,NULL,NULL,83.00,'2021-01-31',NULL,NULL,NULL,'2020-11-21 13:09:16','2020-11-21 13:09:16'),(38,1,NULL,NULL,167.00,'2021-02-28',NULL,NULL,NULL,'2020-11-21 13:09:16','2020-11-21 13:09:16'),(39,1,NULL,NULL,250.00,'2021-03-31',NULL,NULL,NULL,'2020-11-21 13:09:16','2020-11-21 13:09:16'),(40,1,NULL,NULL,333.00,'2021-04-30',NULL,NULL,NULL,'2020-11-21 13:09:16','2020-11-21 13:09:16'),(41,1,NULL,NULL,417.00,'2021-05-31',NULL,NULL,NULL,'2020-11-21 13:09:16','2020-11-21 13:09:16'),(42,1,NULL,NULL,500.00,'2021-06-30',NULL,NULL,NULL,'2020-11-21 13:09:16','2020-11-21 13:09:16'),(43,1,NULL,NULL,583.00,'2021-07-31',NULL,NULL,NULL,'2020-11-21 13:09:17','2020-11-21 13:09:17'),(44,1,NULL,NULL,667.00,'2021-08-31',NULL,NULL,NULL,'2020-11-21 13:09:17','2020-11-21 13:09:17'),(45,1,NULL,NULL,750.00,'2021-09-30',NULL,NULL,NULL,'2020-11-21 13:09:17','2020-11-21 13:09:17'),(46,1,NULL,NULL,833.00,'2021-10-31',NULL,NULL,NULL,'2020-11-21 13:09:17','2020-11-21 13:09:17'),(47,1,NULL,NULL,917.00,'2021-11-30',NULL,NULL,NULL,'2020-11-21 13:09:17','2020-11-21 13:09:17'),(48,1,NULL,NULL,1000.00,'2021-12-31',NULL,NULL,NULL,'2020-11-21 13:09:17','2020-11-21 13:09:17'),(61,2,NULL,NULL,32.00,'2021-01-31',NULL,NULL,NULL,'2020-11-30 21:45:18','2020-11-30 21:45:18'),(62,2,NULL,NULL,63.00,'2021-02-28',NULL,NULL,NULL,'2020-11-30 21:45:18','2020-11-30 21:45:18'),(63,2,NULL,NULL,95.00,'2021-03-31',NULL,NULL,NULL,'2020-11-30 21:45:18','2020-11-30 21:45:18'),(64,2,NULL,NULL,127.00,'2021-04-30',NULL,NULL,NULL,'2020-11-30 21:45:18','2020-11-30 21:45:18'),(65,2,NULL,NULL,158.00,'2021-05-31',NULL,NULL,NULL,'2020-11-30 21:45:18','2020-11-30 21:45:18'),(66,2,NULL,NULL,190.00,'2021-06-30',NULL,NULL,NULL,'2020-11-30 21:45:18','2020-11-30 21:45:18'),(67,2,NULL,NULL,222.00,'2021-07-31',NULL,NULL,NULL,'2020-11-30 21:45:18','2020-11-30 21:45:18'),(68,2,NULL,NULL,253.00,'2021-08-31',NULL,NULL,NULL,'2020-11-30 21:45:18','2020-11-30 21:45:18'),(69,2,NULL,NULL,285.00,'2021-09-30',NULL,NULL,NULL,'2020-11-30 21:45:19','2020-11-30 21:45:19'),(70,2,NULL,NULL,317.00,'2021-10-31',NULL,NULL,NULL,'2020-11-30 21:45:19','2020-11-30 21:45:19'),(71,2,NULL,NULL,348.00,'2021-11-30',NULL,NULL,NULL,'2020-11-30 21:45:19','2020-11-30 21:45:19'),(72,2,NULL,NULL,380.00,'2021-12-31',NULL,NULL,NULL,'2020-11-30 21:45:19','2020-11-30 21:45:19'),(73,3,NULL,NULL,1250.00,'2021-01-31',NULL,NULL,NULL,'2020-11-30 21:56:20','2020-11-30 21:56:20'),(74,3,NULL,NULL,2500.00,'2021-02-28',NULL,NULL,NULL,'2020-11-30 21:56:20','2020-11-30 21:56:20'),(75,3,NULL,NULL,3750.00,'2021-03-31',NULL,NULL,NULL,'2020-11-30 21:56:20','2020-11-30 21:56:20'),(76,3,NULL,NULL,5000.00,'2021-04-30',NULL,NULL,NULL,'2020-11-30 21:56:20','2020-11-30 21:56:20'),(77,3,NULL,NULL,6250.00,'2021-05-31',NULL,NULL,NULL,'2020-11-30 21:56:20','2020-11-30 21:56:20'),(78,3,NULL,NULL,7500.00,'2021-06-30',NULL,NULL,NULL,'2020-11-30 21:56:20','2020-11-30 21:56:20'),(79,3,NULL,NULL,8750.00,'2021-07-31',NULL,NULL,NULL,'2020-11-30 21:56:20','2020-11-30 21:56:20'),(80,3,NULL,NULL,10000.00,'2021-08-31',NULL,NULL,NULL,'2020-11-30 21:56:20','2020-11-30 21:56:20'),(81,3,NULL,NULL,11250.00,'2021-09-30',NULL,NULL,NULL,'2020-11-30 21:56:21','2020-11-30 21:56:21'),(82,3,NULL,NULL,12500.00,'2021-10-31',NULL,NULL,NULL,'2020-11-30 21:56:21','2020-11-30 21:56:21'),(83,3,NULL,NULL,13750.00,'2021-11-30',NULL,NULL,NULL,'2020-11-30 21:56:21','2020-11-30 21:56:21'),(84,3,NULL,NULL,15000.00,'2021-12-31',NULL,NULL,NULL,'2020-11-30 21:56:21','2020-11-30 21:56:21'),(97,4,NULL,NULL,11.00,'2021-01-31',NULL,NULL,NULL,'2020-11-30 22:37:49','2020-11-30 22:37:49'),(98,4,NULL,NULL,13.00,'2021-02-28',NULL,NULL,NULL,'2020-11-30 22:37:49','2020-11-30 22:37:49'),(99,4,NULL,NULL,14.00,'2021-03-31',NULL,NULL,NULL,'2020-11-30 22:37:49','2020-11-30 22:37:49'),(100,4,NULL,NULL,15.00,'2021-04-30',NULL,NULL,NULL,'2020-11-30 22:37:49','2020-11-30 22:37:49'),(101,4,NULL,NULL,16.00,'2021-05-31',NULL,NULL,NULL,'2020-11-30 22:37:49','2020-11-30 22:37:49'),(102,4,NULL,NULL,18.00,'2021-06-30',NULL,NULL,NULL,'2020-11-30 22:37:50','2020-11-30 22:37:50'),(103,4,NULL,NULL,19.00,'2021-07-31',NULL,NULL,NULL,'2020-11-30 22:37:50','2020-11-30 22:37:50'),(104,4,NULL,NULL,20.00,'2021-08-31',NULL,NULL,NULL,'2020-11-30 22:37:50','2020-11-30 22:37:50'),(105,4,NULL,NULL,21.00,'2021-09-30',NULL,NULL,NULL,'2020-11-30 22:37:50','2020-11-30 22:37:50'),(106,4,NULL,NULL,23.00,'2021-10-31',NULL,NULL,NULL,'2020-11-30 22:37:50','2020-11-30 22:37:50'),(107,4,NULL,NULL,24.00,'2021-11-30',NULL,NULL,NULL,'2020-11-30 22:37:50','2020-11-30 22:37:50'),(108,4,NULL,NULL,25.00,'2021-12-31',NULL,NULL,NULL,'2020-11-30 22:37:50','2020-11-30 22:37:50'),(133,5,NULL,NULL,5.00,'2021-02-28',NULL,NULL,NULL,'2020-11-30 22:46:56','2020-11-30 22:46:56'),(134,5,NULL,NULL,11.00,'2021-03-31',NULL,NULL,NULL,'2020-11-30 22:46:56','2020-11-30 22:46:56'),(135,5,NULL,NULL,16.00,'2021-04-30',NULL,NULL,NULL,'2020-11-30 22:46:56','2020-11-30 22:46:56'),(136,5,NULL,NULL,22.00,'2021-05-31',NULL,NULL,NULL,'2020-11-30 22:46:56','2020-11-30 22:46:56'),(137,5,NULL,NULL,27.00,'2021-06-30',NULL,NULL,NULL,'2020-11-30 22:46:56','2020-11-30 22:46:56'),(138,5,NULL,NULL,33.00,'2021-07-31',NULL,NULL,NULL,'2020-11-30 22:46:56','2020-11-30 22:46:56'),(139,5,NULL,NULL,38.00,'2021-08-31',NULL,NULL,NULL,'2020-11-30 22:46:57','2020-11-30 22:46:57'),(140,5,NULL,NULL,44.00,'2021-09-30',NULL,NULL,NULL,'2020-11-30 22:46:57','2020-11-30 22:46:57'),(141,5,NULL,NULL,49.00,'2021-10-31',NULL,NULL,NULL,'2020-11-30 22:46:57','2020-11-30 22:46:57'),(142,5,NULL,NULL,55.00,'2021-11-30',NULL,NULL,NULL,'2020-11-30 22:46:57','2020-11-30 22:46:57'),(143,5,NULL,NULL,60.00,'2021-12-31',NULL,NULL,NULL,'2020-11-30 22:46:57','2020-11-30 22:46:57'),(144,6,NULL,NULL,8.00,'2021-01-31',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(145,6,NULL,NULL,14.00,'2021-02-28',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(146,6,NULL,NULL,21.00,'2021-03-31',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(147,6,NULL,NULL,27.00,'2021-04-30',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(148,6,NULL,NULL,34.00,'2021-05-31',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(149,6,NULL,NULL,41.00,'2021-06-30',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(150,6,NULL,NULL,47.00,'2021-07-31',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(151,6,NULL,NULL,54.00,'2021-08-31',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(152,6,NULL,NULL,60.00,'2021-09-30',NULL,NULL,NULL,'2020-11-30 23:04:34','2020-11-30 23:04:34'),(153,6,NULL,NULL,67.00,'2021-10-31',NULL,NULL,NULL,'2020-11-30 23:04:35','2020-11-30 23:04:35'),(154,6,NULL,NULL,73.00,'2021-11-30',NULL,NULL,NULL,'2020-11-30 23:04:35','2020-11-30 23:04:35'),(155,6,NULL,NULL,80.00,'2021-12-31',NULL,NULL,NULL,'2020-11-30 23:04:35','2020-11-30 23:04:35'),(156,7,NULL,NULL,38.00,'2021-01-31',NULL,NULL,NULL,'2020-11-30 23:27:38','2020-11-30 23:27:38'),(157,7,NULL,NULL,75.00,'2021-02-28',NULL,NULL,NULL,'2020-11-30 23:27:38','2020-11-30 23:27:38'),(158,7,NULL,NULL,113.00,'2021-03-31',NULL,NULL,NULL,'2020-11-30 23:27:38','2020-11-30 23:27:38'),(159,7,NULL,NULL,150.00,'2021-04-30',NULL,NULL,NULL,'2020-11-30 23:27:38','2020-11-30 23:27:38'),(160,7,NULL,NULL,188.00,'2021-05-31',NULL,NULL,NULL,'2020-11-30 23:27:38','2020-11-30 23:27:38'),(161,7,NULL,NULL,225.00,'2021-06-30',NULL,NULL,NULL,'2020-11-30 23:27:38','2020-11-30 23:27:38'),(162,7,NULL,NULL,263.00,'2021-07-31',NULL,NULL,NULL,'2020-11-30 23:27:39','2020-11-30 23:27:39'),(163,7,NULL,NULL,300.00,'2021-08-31',NULL,NULL,NULL,'2020-11-30 23:27:39','2020-11-30 23:27:39'),(164,7,NULL,NULL,338.00,'2021-09-30',NULL,NULL,NULL,'2020-11-30 23:27:39','2020-11-30 23:27:39'),(165,7,NULL,NULL,375.00,'2021-10-31',NULL,NULL,NULL,'2020-11-30 23:27:39','2020-11-30 23:27:39'),(166,7,NULL,NULL,413.00,'2021-11-30',NULL,NULL,NULL,'2020-11-30 23:27:39','2020-11-30 23:27:39'),(167,7,NULL,NULL,450.00,'2021-12-31',NULL,NULL,NULL,'2020-11-30 23:27:39','2020-11-30 23:27:39'),(168,8,NULL,NULL,40.00,'2021-01-31',NULL,NULL,NULL,'2020-12-04 22:01:10','2020-12-04 22:01:10'),(169,8,NULL,NULL,78.00,'2021-02-28',NULL,NULL,NULL,'2020-12-04 22:01:10','2020-12-04 22:01:10'),(170,8,NULL,NULL,115.00,'2021-03-31',NULL,NULL,NULL,'2020-12-04 22:01:10','2020-12-04 22:01:10'),(171,8,NULL,NULL,152.00,'2021-04-30',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(172,8,NULL,NULL,189.00,'2021-05-31',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(173,8,NULL,NULL,227.00,'2021-06-30',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(174,8,NULL,NULL,264.00,'2021-07-31',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(175,8,NULL,NULL,301.00,'2021-08-31',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(176,8,NULL,NULL,338.00,'2021-09-30',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(177,8,NULL,NULL,376.00,'2021-10-31',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(178,8,NULL,NULL,413.00,'2021-11-30',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(179,8,NULL,NULL,450.00,'2021-12-31',NULL,NULL,NULL,'2020-12-04 22:01:11','2020-12-04 22:01:11'),(180,9,NULL,NULL,407.00,'2021-01-31',NULL,NULL,NULL,'2020-12-04 22:27:57','2020-12-04 22:27:57'),(181,9,NULL,NULL,779.00,'2021-02-28',NULL,NULL,NULL,'2020-12-04 22:27:57','2020-12-04 22:27:57'),(182,9,NULL,NULL,1151.00,'2021-03-31',NULL,NULL,NULL,'2020-12-04 22:27:57','2020-12-04 22:27:57'),(183,9,NULL,NULL,1523.00,'2021-04-30',NULL,NULL,NULL,'2020-12-04 22:27:57','2020-12-04 22:27:57'),(184,9,NULL,NULL,1895.00,'2021-05-31',NULL,NULL,NULL,'2020-12-04 22:27:57','2020-12-04 22:27:57'),(185,9,NULL,NULL,2268.00,'2021-06-30',NULL,NULL,NULL,'2020-12-04 22:27:57','2020-12-04 22:27:57'),(186,9,NULL,NULL,2640.00,'2021-07-31',NULL,NULL,NULL,'2020-12-04 22:27:57','2020-12-04 22:27:57'),(187,9,NULL,NULL,3012.00,'2021-08-31',NULL,NULL,NULL,'2020-12-04 22:27:58','2020-12-04 22:27:58'),(188,9,NULL,NULL,3384.00,'2021-09-30',NULL,NULL,NULL,'2020-12-04 22:27:58','2020-12-04 22:27:58'),(189,9,NULL,NULL,3756.00,'2021-10-31',NULL,NULL,NULL,'2020-12-04 22:27:58','2020-12-04 22:27:58'),(190,9,NULL,NULL,4128.00,'2021-11-30',NULL,NULL,NULL,'2020-12-04 22:27:58','2020-12-04 22:27:58'),(191,9,NULL,NULL,4500.00,'2021-12-31',NULL,NULL,NULL,'2020-12-04 22:27:58','2020-12-04 22:27:58'),(192,10,NULL,NULL,5.00,'2021-01-31',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(193,10,NULL,NULL,8.00,'2021-02-28',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(194,10,NULL,NULL,10.00,'2021-03-31',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(195,10,NULL,NULL,12.00,'2021-04-30',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(196,10,NULL,NULL,14.00,'2021-05-31',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(197,10,NULL,NULL,17.00,'2021-06-30',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(198,10,NULL,NULL,19.00,'2021-07-31',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(199,10,NULL,NULL,21.00,'2021-08-31',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(200,10,NULL,NULL,23.00,'2021-09-30',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(201,10,NULL,NULL,26.00,'2021-10-31',NULL,NULL,NULL,'2020-12-04 22:36:48','2020-12-04 22:36:48'),(202,10,NULL,NULL,28.00,'2021-11-30',NULL,NULL,NULL,'2020-12-04 22:36:49','2020-12-04 22:36:49'),(203,10,NULL,NULL,30.00,'2021-12-31',NULL,NULL,NULL,'2020-12-04 22:36:49','2020-12-04 22:36:49'),(204,11,NULL,NULL,4.00,'2021-01-31',NULL,NULL,NULL,'2020-12-04 22:52:24','2020-12-04 22:52:24'),(205,11,NULL,NULL,7.00,'2021-02-28',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(206,11,NULL,NULL,9.00,'2021-03-31',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(207,11,NULL,NULL,11.00,'2021-04-30',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(208,11,NULL,NULL,14.00,'2021-05-31',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(209,11,NULL,NULL,16.00,'2021-06-30',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(210,11,NULL,NULL,18.00,'2021-07-31',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(211,11,NULL,NULL,21.00,'2021-08-31',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(212,11,NULL,NULL,23.00,'2021-09-30',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(213,11,NULL,NULL,25.00,'2021-10-31',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(214,11,NULL,NULL,28.00,'2021-11-30',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(215,11,NULL,NULL,30.00,'2021-12-31',NULL,NULL,NULL,'2020-12-04 22:52:25','2020-12-04 22:52:25'),(216,12,NULL,NULL,33.00,'2021-01-31',NULL,NULL,NULL,'2020-12-04 22:58:13','2020-12-04 22:58:13'),(217,12,NULL,NULL,67.00,'2021-02-28',NULL,NULL,NULL,'2020-12-04 22:58:13','2020-12-04 22:58:13'),(218,12,NULL,NULL,100.00,'2021-03-31',NULL,NULL,NULL,'2020-12-04 22:58:13','2020-12-04 22:58:13'),(219,12,NULL,NULL,133.00,'2021-04-30',NULL,NULL,NULL,'2020-12-04 22:58:13','2020-12-04 22:58:13'),(220,12,NULL,NULL,167.00,'2021-05-31',NULL,NULL,NULL,'2020-12-04 22:58:13','2020-12-04 22:58:13'),(221,12,NULL,NULL,200.00,'2021-06-30',NULL,NULL,NULL,'2020-12-04 22:58:14','2020-12-04 22:58:14'),(222,12,NULL,NULL,233.00,'2021-07-31',NULL,NULL,NULL,'2020-12-04 22:58:14','2020-12-04 22:58:14'),(223,12,NULL,NULL,267.00,'2021-08-31',NULL,NULL,NULL,'2020-12-04 22:58:14','2020-12-04 22:58:14'),(224,12,NULL,NULL,300.00,'2021-09-30',NULL,NULL,NULL,'2020-12-04 22:58:14','2020-12-04 22:58:14'),(225,12,NULL,NULL,333.00,'2021-10-31',NULL,NULL,NULL,'2020-12-04 22:58:14','2020-12-04 22:58:14'),(226,12,NULL,NULL,367.00,'2021-11-30',NULL,NULL,NULL,'2020-12-04 22:58:14','2020-12-04 22:58:14'),(227,12,NULL,NULL,400.00,'2021-12-31',NULL,NULL,NULL,'2020-12-04 22:58:14','2020-12-04 22:58:14');

--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `objectives` VALUES (1,'Generar $900, Mensuales CT',1,1,0.00,'bg-red','#dc3545','2020-03-14 02:24:02','2020-11-20 22:12:25'),(3,'Posicionar, la marca',1,2,0.00,'bg-red','#dc3545','2020-03-14 02:29:09','2020-11-20 16:11:54'),(4,'Sistematizar, los procesos',1,4,0.00,'bg-red','#dc3545','2020-03-14 02:33:59','2020-11-18 17:37:31'),(5,'Producir 450k/m,\r\nCafé Tucusito',1,3,0.00,'bg-red','#dc3545','2020-03-14 02:41:41','2020-11-20 15:11:29'),(7,'Formación, QGrader',1,4,0.00,'bg-red','#dc3545','2020-03-14 03:00:09','2020-11-20 15:20:41'),(8,'Producir 4500k/m, Café Comercial',1,3,0.00,'bg-red','#dc3545','2020-03-14 03:01:45','2020-11-20 15:11:39'),(9,'Formación en, Tostión',1,4,0.00,'bg-red','#dc3545','2020-03-14 03:05:18','2020-11-20 15:22:33'),(12,'Adiestrar al, Personal',1,4,0.00,'bg-red','#dc3545','2020-03-14 03:09:25','2020-03-14 03:09:25'),(13,'Increm. Cuota, de mercado',1,2,0.00,'bg-red','#dc3545','2020-11-18 17:23:59','2020-11-20 16:12:19'),(14,'Reducir Costos,\r\nOperativos',1,1,0.00,'bg-red','#dc3545','2020-11-20 16:11:04','2020-11-20 16:11:04'),(15,'Generar $380, por Tostión/m',1,1,0.00,'bg-red','#dc3545','2020-11-20 21:47:58','2020-11-30 21:58:31'),(16,'Conseguir Prod, Café Dif.',1,3,0.00,'bg-red','#dc3545','2020-11-20 21:49:48','2020-12-04 19:28:10'),(17,'Acercar Producto, al Consumidor',1,3,0.00,'bg-red','#dc3545','2020-11-20 21:59:13','2020-11-20 21:59:21'),(18,'Generar $15K, mensuales CC',1,1,0.00,'bg-red','#dc3545','2020-11-20 22:12:56','2020-11-30 21:52:54');

--
-- 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=193 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'),(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'),(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'),(74,132,8,'2020-03-04 20:55:31','2020-03-04 20:55:31'),(75,133,8,'2020-03-04 20:55:31','2020-03-04 20:55:31'),(76,137,8,'2020-03-04 20:55:31','2020-03-04 20:55:31'),(77,128,8,'2020-03-04 20:55:31','2020-03-04 20:55:31'),(78,136,8,'2020-03-04 20:55:32','2020-03-04 20:55:32'),(79,124,8,'2020-03-04 20:55:32','2020-03-04 20:55:32'),(80,146,8,'2020-03-04 20:55:32','2020-03-04 20:55:32'),(81,144,8,'2020-03-04 20:55:32','2020-03-04 20:55:32'),(82,142,8,'2020-03-04 20:55:32','2020-03-04 20:55:32'),(83,143,8,'2020-03-04 20:55:32','2020-03-04 20:55:32'),(84,138,8,'2020-03-04 20:55:32','2020-03-04 20:55:32'),(85,122,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(86,120,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(87,123,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(88,121,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(89,129,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(90,134,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(91,132,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(92,133,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(93,137,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(94,128,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(95,136,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(97,92,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(98,93,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(99,88,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(102,60,9,'2020-03-04 20:59:37','2020-03-04 20:59:37'),(103,61,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(104,56,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(106,58,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(107,124,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(108,81,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(109,84,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(110,85,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(111,80,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(112,87,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(113,82,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(115,68,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(117,64,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(119,66,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(120,146,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(121,144,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(122,142,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(123,143,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(124,138,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(125,116,9,'2020-03-04 20:59:38','2020-03-04 20:59:38'),(126,112,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(127,114,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(128,100,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(129,101,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(130,96,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(131,98,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(134,108,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(136,104,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(138,106,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(139,73,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(140,76,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(141,77,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(142,72,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(143,74,9,'2020-03-04 20:59:39','2020-03-04 20:59:39'),(144,120,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(145,121,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(146,92,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(147,93,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(148,88,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(149,124,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(150,84,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(151,80,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(152,68,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(153,64,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(154,146,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(155,144,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(156,143,2,'2020-11-20 15:40:18','2020-11-20 15:40:18'),(157,125,9,'2020-11-20 15:42:35','2020-11-20 15:42:35'),(158,122,2,'2020-11-20 15:45:50','2020-11-20 15:45:50'),(159,129,2,'2020-11-20 15:45:50','2020-11-20 15:45:50'),(160,134,2,'2020-11-20 15:45:50','2020-11-20 15:45:50'),(161,56,2,'2020-11-20 15:45:50','2020-11-20 15:45:50'),(162,147,2,'2020-11-20 15:53:38','2020-11-20 15:53:38'),(163,148,2,'2020-11-20 16:10:21','2020-11-20 16:10:21'),(164,149,2,'2020-11-20 16:10:21','2020-11-20 16:10:21'),(165,166,2,'2020-11-20 18:04:02','2020-11-20 18:04:02'),(166,167,2,'2020-11-20 18:04:02','2020-11-20 18:04:02'),(167,159,2,'2020-11-20 18:04:02','2020-11-20 18:04:02'),(169,81,2,'2020-11-20 18:04:02','2020-11-20 18:04:02'),(170,85,2,'2020-11-20 18:04:02','2020-11-20 18:04:02'),(171,82,2,'2020-11-20 18:04:03','2020-11-20 18:04:03'),(172,156,2,'2020-11-20 18:04:03','2020-11-20 18:04:03'),(173,157,2,'2020-11-20 18:04:03','2020-11-20 18:04:03'),(174,66,2,'2020-11-20 18:04:03','2020-11-20 18:04:03'),(175,100,2,'2020-11-20 18:04:03','2020-11-20 18:04:03'),(176,108,2,'2020-11-20 18:04:03','2020-11-20 18:04:03'),(177,76,2,'2020-11-20 18:04:03','2020-11-20 18:04:03'),(178,166,9,'2020-11-20 18:05:33','2020-11-20 18:05:33'),(179,167,9,'2020-11-20 18:05:33','2020-11-20 18:05:33'),(180,159,9,'2020-11-20 18:05:33','2020-11-20 18:05:33'),(181,153,9,'2020-11-20 18:05:33','2020-11-20 18:05:33'),(182,156,9,'2020-11-20 18:05:33','2020-11-20 18:05:33'),(183,157,9,'2020-11-20 18:05:33','2020-11-20 18:05:33'),(184,148,9,'2020-11-20 18:05:33','2020-11-20 18:05:33'),(185,149,9,'2020-11-20 18:05:34','2020-11-20 18:05:34'),(186,147,9,'2020-11-20 18:05:34','2020-11-20 18:05:34'),(187,150,9,'2020-11-20 18:05:34','2020-11-20 18:05:34'),(188,151,9,'2020-11-20 18:05:34','2020-11-20 18:05:34'),(189,101,2,'2020-12-08 15:38:12','2020-12-08 15:38:12'),(190,161,2,'2020-12-08 15:38:12','2020-12-08 15:38:12'),(191,77,2,'2020-12-08 15:38:12','2020-12-08 15:38:12'),(192,151,2,'2020-12-08 15:38:12','2020-12-08 15:38:12');

--
-- 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=168 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=5 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,'4','2019-07-10 14:11:44','2020-11-30 22:37:15',NULL),(3,'Processes',3,1,'1','2019-07-28 01:44:14','2019-09-04 06:22:47',NULL),(4,'Peopel',4,1,'6','2019-07-28 01:44:55','2020-11-20 20:38:33',NULL);

--
-- 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=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `phases` VALUES (1,'Uno',1,'2021-01-01','2021-12-31',1,0,70.00,60.00,50.00,70.00,60.00,50.00,'2019-07-10 14:11:44','2020-11-18 16:59:13');

--
-- 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,4,'2020-11-20 15:56:08','2020-11-20 15:56:08'),(4,1,2,'2020-11-20 15:57:03','2020-11-20 15:57:03'),(5,2,3,'2020-12-08 14:40:59','2020-12-08 14:40:59'),(6,9,5,'2020-12-08 14:41:51','2020-12-08 14:41:51');

--
-- 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=10 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),(8,'Gte Ventas','gteventas','Gerente de Ventas','2020-03-04 20:54:03','2020-03-04 20:54:03',NULL),(9,'Accionista','accionista','Accionista o Dueño de la Empresa','2020-03-04 20:56:25','2020-03-04 20:56:25',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=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `tasks` VALUES (1,3,'Sanders','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:10:42','2020-12-04 22:10:42'),(2,3,'Santo Bocado','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:11:16','2020-12-04 22:11:16'),(6,3,'Licoteca','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:12:19','2020-12-04 22:12:19'),(7,3,'María Fernanda Di Giacobe','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:12:56','2020-12-04 22:12:56'),(8,2,'Moreno','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:15:14','2020-12-04 22:15:14'),(9,2,'Alto','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:15:25','2020-12-04 22:15:25'),(10,2,'El Bosque','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:15:35','2020-12-04 22:15:35'),(11,1,'Cata en Galaxy Market','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:19:02','2020-12-04 22:19:02'),(12,1,'Preparar la Inducción','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:19:41','2020-12-04 22:19:41'),(13,1,'La Taza','2020-12-07','2020-12-15',0.00,NULL,4,'2020-12-04 22:21:38','2020-12-04 22:21:38');

--
-- 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`*/;


