
CREATE TABLE `permisos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(191) 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Volcado de tabla permisos_asignados
# ------------------------------------------------------------


CREATE TABLE `permisos_asignados` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `permiso_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permisos_asignados_user_id_foreign` (`user_id`),
  KEY `permisos_asignados_permiso_id_foreign` (`permiso_id`),
  CONSTRAINT `permisos_asignados_permiso_id_foreign` FOREIGN KEY (`permiso_id`) REFERENCES `permisos` (`id`),
  CONSTRAINT `permisos_asignados_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Volcado de tabla prestamos
# ------------------------------------------------------------


CREATE TABLE `prestamos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cliente_id` int(10) unsigned NOT NULL,
  `promotor_id` int(10) unsigned DEFAULT NULL,
  `inicio_prestamo` date DEFAULT NULL,
  `fin_prestamo` date DEFAULT NULL,
  `estatus` enum('Inactivo','Normal','Mora','Completado') COLLATE utf8mb4_unicode_ci DEFAULT 'Inactivo',
  `calificacion` float DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `solicitud_id` int(11) unsigned DEFAULT NULL,
  `fecha_finalizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `prestamo_promotor` (`promotor_id`),
  KEY `prestamo_cliente` (`cliente_id`),
  KEY `prestamo_solicitud` (`solicitud_id`),
  CONSTRAINT `prestamo_cliente` FOREIGN KEY (`cliente_id`) REFERENCES `clientes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `prestamo_promotor` FOREIGN KEY (`promotor_id`) REFERENCES `promotores` (`id`) ON DELETE CASCADE,
  CONSTRAINT `prestamo_solicitud` FOREIGN KEY (`solicitud_id`) REFERENCES `solicitudes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `prestamos` (`id`, `cliente_id`, `promotor_id`, `inicio_prestamo`, `fin_prestamo`, `estatus`, `calificacion`, `created_at`, `updated_at`, `deleted_at`, `solicitud_id`, `fecha_finalizado`)
VALUES
	(1,1,1,'2019-11-15','2020-02-28','Completado',90,'2020-04-21 18:09:26','2020-04-22 01:21:17',NULL,1,'2020-01-31 00:00:00'),
	(2,2,1,'2019-11-15','2020-02-28','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:35:08',NULL,2,'2020-02-07 00:00:00'),
	(3,3,1,'2019-11-15','2020-02-28','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:35:08',NULL,3,'2020-02-07 00:00:00'),
	(4,4,1,'2019-11-15','2020-02-28','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:35:48',NULL,4,'2020-03-23 00:00:00'),
	(5,5,1,'2019-11-15','2020-02-28','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:21:17',NULL,5,'2020-01-31 00:00:00'),
	(6,6,1,'2019-11-15','2020-02-28','Completado',90,'2020-04-21 18:09:27','2020-04-22 00:17:19',NULL,6,'2019-12-27 00:00:00'),
	(7,7,2,'2019-11-15','2020-02-28','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:09:49',NULL,7,'2020-02-28 00:00:00'),
	(8,8,1,'2019-11-22','2020-03-06','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:13:33',NULL,8,'2020-01-24 00:00:00'),
	(9,9,1,'2019-11-22','2020-03-06','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:21:17',NULL,9,'2020-01-31 00:00:00'),
	(10,10,1,'2019-11-22','2020-03-06','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:16:01',NULL,10,'2020-03-06 00:00:00'),
	(11,11,2,'2019-11-22','2020-03-06','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:16:01',NULL,11,'2020-03-06 00:00:00'),
	(12,12,3,'2019-11-22','2020-03-06','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:16:01',NULL,12,'2020-03-06 00:00:00'),
	(13,13,3,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:49:32',NULL,13,'2020-02-14 00:00:00'),
	(14,14,3,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:55:10',NULL,14,'2020-02-21 00:00:00'),
	(15,15,4,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:24:13',NULL,15,'2020-03-13 00:00:00'),
	(16,16,4,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:24:13',NULL,16,'2020-03-13 00:00:00'),
	(17,17,3,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:49:32',NULL,17,'2020-02-14 00:00:00'),
	(18,18,3,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:49:32',NULL,18,'2020-02-14 00:00:00'),
	(19,19,1,'2019-11-29','2020-03-13','Normal',90,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,19,NULL),
	(20,20,4,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:55:10',NULL,20,'2020-02-21 00:00:00'),
	(21,21,1,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:21:17',NULL,21,'2020-01-31 00:00:00'),
	(22,22,1,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:35:08',NULL,22,'2020-02-07 00:00:00'),
	(23,23,1,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,23,NULL),
	(24,24,3,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:35:08',NULL,24,'2020-02-07 00:00:00'),
	(25,25,5,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:24:13',NULL,25,'2020-03-13 00:00:00'),
	(26,26,2,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 02:24:13',NULL,26,'2020-03-13 00:00:00'),
	(27,27,1,'2019-11-29','2020-03-13','Completado',90,'2020-04-21 18:09:27','2020-04-22 01:55:10',NULL,27,'2020-02-21 00:00:00'),
	(28,28,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 01:21:17',NULL,28,'2020-01-31 00:00:00'),
	(29,29,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:24:13',NULL,29,'2020-03-13 00:00:00'),
	(30,30,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:16:01',NULL,30,'2020-03-06 00:00:00'),
	(31,31,1,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:24:13',NULL,31,'2020-03-13 00:00:00'),
	(32,32,1,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:09:49',NULL,32,'2020-02-28 00:00:00'),
	(33,33,2,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 01:35:08',NULL,33,'2020-02-07 00:00:00'),
	(34,34,2,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 01:07:41',NULL,34,'2020-01-10 00:00:00'),
	(35,35,4,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:29:55',NULL,35,'2020-03-20 00:00:00'),
	(36,36,4,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:29:55',NULL,36,'2020-03-20 00:00:00'),
	(37,37,5,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 01:35:08',NULL,37,'2020-02-07 00:00:00'),
	(38,38,1,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:24:13',NULL,38,'2020-03-13 00:00:00'),
	(39,39,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 01:21:17',NULL,39,'2020-01-31 00:00:00'),
	(40,40,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 01:35:08',NULL,40,'2020-02-07 00:00:00'),
	(41,41,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:24:13',NULL,41,'2020-03-13 00:00:00'),
	(42,42,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:16:01',NULL,42,'2020-03-06 00:00:00'),
	(43,43,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:16:01',NULL,43,'2020-03-06 00:00:00'),
	(44,44,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:29:55',NULL,44,'2020-03-20 00:00:00'),
	(45,45,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:29:55',NULL,45,'2020-03-20 00:00:00'),
	(46,46,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:29:55',NULL,46,'2020-03-20 00:00:00'),
	(47,47,1,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:24:13',NULL,47,'2020-03-13 00:00:00'),
	(48,48,2,'2019-12-06','2020-03-20','Normal',90,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,48,NULL),
	(49,49,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:24:13',NULL,49,'2020-03-13 00:00:00'),
	(50,50,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:16:01',NULL,50,'2020-03-06 00:00:00'),
	(51,51,5,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:29:55',NULL,51,'2020-03-20 00:00:00'),
	(52,52,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:29:55',NULL,52,'2020-03-20 00:00:00'),
	(53,53,3,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:16:01',NULL,53,'2020-03-06 00:00:00'),
	(54,54,2,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:28','2020-04-22 02:29:55',NULL,54,'2020-03-20 00:00:00'),
	(55,55,5,'2019-12-06','2020-03-20','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:35:08',NULL,55,'2020-02-07 00:00:00'),
	(56,56,3,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:21:17',NULL,56,'2020-01-31 00:00:00'),
	(57,57,3,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:29:55',NULL,57,'2020-03-20 00:00:00'),
	(58,58,3,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:49:32',NULL,58,'2020-02-14 00:00:00'),
	(59,59,3,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:29:55',NULL,59,'2020-03-20 00:00:00'),
	(60,60,3,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:49:32',NULL,60,'2020-02-14 00:00:00'),
	(61,61,5,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:29:55',NULL,61,'2020-03-20 00:00:00'),
	(62,62,4,'2019-12-13','2020-03-27','Normal',90,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,62,NULL),
	(63,63,5,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:13:33',NULL,63,'2020-01-24 00:00:00'),
	(64,64,4,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:09:49',NULL,64,'2020-02-28 00:00:00'),
	(65,65,2,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:55:10',NULL,65,'2020-02-21 00:00:00'),
	(66,66,2,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:13:33',NULL,66,'2020-01-24 00:00:00'),
	(67,67,3,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:35:48',NULL,67,'2020-03-27 00:00:00'),
	(68,68,3,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:29:55',NULL,68,'2020-03-20 00:00:00'),
	(69,69,3,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:35:48',NULL,69,'2020-03-27 00:00:00'),
	(70,70,1,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:10:54',NULL,70,'2020-01-17 00:00:00'),
	(71,71,1,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:49:32',NULL,71,'2020-02-14 00:00:00'),
	(72,72,3,'2019-12-13','2020-03-27','Normal',90,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,72,NULL),
	(73,73,1,'2019-12-13','2020-03-27','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:09:49',NULL,73,'2020-02-28 00:00:00'),
	(74,74,6,'2019-12-23','2020-04-10','Completado',90,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,74,NULL),
	(75,75,2,'2019-12-20','2020-04-03','Normal',90,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,75,NULL),
	(76,76,2,'2019-12-20','2020-04-03','Normal',90,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,76,NULL),
	(77,77,3,'2019-12-20','2020-04-03','Completado',90,'2020-04-21 18:09:29','2020-04-22 01:49:32',NULL,77,'2020-02-14 00:00:00'),
	(78,78,3,'2019-12-20','2020-04-03','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:35:48',NULL,78,'2020-03-27 00:00:00'),
	(79,79,3,'2019-12-20','2020-04-03','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:35:48',NULL,79,'2020-03-27 00:00:00'),
	(80,80,4,'2019-12-20','2020-04-03','Completado',90,'2020-04-21 18:09:29','2020-04-22 02:35:48',NULL,80,'2020-03-27 00:00:00'),
	(81,81,4,'2019-12-20','2020-04-03','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,81,NULL),
	(82,82,4,'2019-12-20','2020-04-03','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,82,NULL),
	(83,83,4,'2019-12-20','2020-04-03','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:40:46',NULL,83,'2020-04-03 00:00:00'),
	(84,84,5,'2019-12-20','2020-04-03','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:29:55',NULL,84,'2020-03-20 00:00:00'),
	(85,85,1,'2019-12-20','2020-04-03','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:09:49',NULL,85,'2020-02-28 00:00:00'),
	(86,86,1,'2019-12-20','2020-04-03','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:40:46',NULL,86,'2020-04-03 00:00:00'),
	(87,87,3,'2019-12-27','2020-04-10','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:40:46',NULL,87,'2020-04-03 00:00:00'),
	(88,88,3,'2019-12-27','2020-04-10','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,88,NULL),
	(89,89,3,'2019-12-27','2020-04-10','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,89,NULL),
	(90,90,3,'2019-12-27','2020-04-10','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:35:48',NULL,90,'2020-03-27 00:00:00'),
	(91,91,3,'2019-12-27','2020-04-10','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,91,NULL),
	(92,92,2,'2019-12-27','2020-04-10','Completado',90,'2020-04-21 18:09:30','2020-04-22 01:13:33',NULL,92,'2020-01-24 00:00:00'),
	(93,93,2,'2019-12-27','2020-04-10','Completado',90,'2020-04-21 18:09:30','2020-04-22 01:55:10',NULL,93,'2020-02-21 00:00:00'),
	(94,94,5,'2019-12-27','2020-04-10','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:40:46',NULL,94,'2020-04-03 00:00:00'),
	(95,95,3,'2019-12-27','2020-04-10','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:16:01',NULL,95,'2020-03-06 00:00:00'),
	(96,96,3,'2019-12-27','2020-04-10','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:40:46',NULL,96,'2020-04-03 00:00:00'),
	(97,97,1,'2019-12-27','2020-04-10','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,97,NULL),
	(98,98,1,'2019-12-27','2020-04-10','Completado',90,'2020-04-21 18:09:30','2020-04-22 01:13:33',NULL,98,'2020-01-24 00:00:00'),
	(99,99,6,'2020-02-23','2020-06-12','Completado',90,'2020-04-21 18:09:30','2020-04-22 00:17:20',NULL,99,'2020-02-28 00:00:00'),
	(100,100,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,100,NULL),
	(101,101,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,101,NULL),
	(102,102,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,102,NULL),
	(103,103,3,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:16:01',NULL,103,'2020-02-07 00:00:00'),
	(104,104,3,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:30','2020-04-22 02:16:01',NULL,104,'2020-02-07 00:00:00'),
	(105,105,3,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:30','2020-04-22 01:55:10',NULL,105,'2020-01-24 00:00:00'),
	(106,106,1,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:30','2020-04-22 01:13:33',NULL,106,'2019-12-27 00:00:00'),
	(107,107,1,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:30','2020-04-21 18:09:31',NULL,107,NULL),
	(108,108,1,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,108,NULL),
	(109,109,1,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,109,NULL),
	(110,110,2,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 02:29:55',NULL,110,'2020-02-21 00:00:00'),
	(111,111,2,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 02:09:49',NULL,111,'2020-01-31 00:00:00'),
	(112,112,5,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,112,NULL),
	(113,113,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,113,NULL),
	(114,114,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,114,NULL),
	(115,115,3,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 02:40:46',NULL,115,'2020-03-06 00:00:00'),
	(116,116,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,116,NULL),
	(117,117,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,117,NULL),
	(118,118,1,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,118,NULL),
	(119,119,1,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,119,NULL),
	(120,120,2,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,120,NULL),
	(121,121,2,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 01:55:10',NULL,121,'2020-01-17 00:00:00'),
	(122,122,1,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,122,NULL),
	(123,123,1,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,123,NULL),
	(124,124,2,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 02:24:14',NULL,124,'2020-02-07 00:00:00'),
	(125,125,3,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 02:24:14',NULL,125,'2020-02-07 00:00:00'),
	(126,126,3,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 02:35:48',NULL,126,'2020-02-21 00:00:00'),
	(127,127,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,127,NULL),
	(128,128,3,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 01:55:10',NULL,128,'2020-01-17 00:00:00'),
	(129,129,3,'2019-12-03','2020-03-20','Completado',90,'2020-04-21 18:09:31','2020-04-22 02:29:55',NULL,129,'2020-02-14 00:00:00'),
	(130,130,3,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,130,NULL),
	(131,131,4,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,131,NULL),
	(132,132,5,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,132,NULL),
	(133,133,5,'2019-12-03','2020-03-20','Normal',90,'2020-04-21 18:09:31','2020-04-21 18:09:32',NULL,133,NULL),
	(134,134,1,'2020-01-10','2020-04-24','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,134,NULL),
	(135,135,2,'2020-01-10','2020-04-24','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,135,NULL),
	(136,136,2,'2020-01-10','2020-04-24','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,136,NULL),
	(137,137,2,'2020-01-10','2020-04-24','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,137,NULL),
	(138,138,3,'2020-01-10','2020-04-24','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,138,NULL),
	(139,139,5,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,139,NULL),
	(140,140,2,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,140,NULL),
	(141,141,3,'2020-01-17','2020-05-01','Completado',90,'2020-04-21 18:09:32','2020-04-22 02:40:46',NULL,141,'2020-04-03 00:00:00'),
	(142,142,3,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,142,NULL),
	(143,143,3,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,143,NULL),
	(144,144,2,'2020-01-17','2020-05-01','Completado',90,'2020-04-21 18:09:32','2020-04-22 02:16:01',NULL,144,'2020-03-06 00:00:00'),
	(145,145,1,'2020-01-17','2020-05-01','Completado',90,'2020-04-21 18:09:32','2020-04-22 01:21:18',NULL,145,'2020-01-31 00:00:00'),
	(146,146,5,'2020-01-17','2020-05-01','Completado',90,'2020-04-21 18:09:32','2020-04-22 02:24:14',NULL,146,'2020-03-13 00:00:00'),
	(147,147,5,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,147,NULL),
	(148,148,3,'2020-01-17','2020-05-01','Completado',90,'2020-04-21 18:09:32','2020-04-22 02:16:01',NULL,148,'2020-03-06 00:00:00'),
	(149,149,3,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,149,NULL),
	(150,150,2,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,150,NULL),
	(151,151,2,'2020-01-17','2020-05-01','Completado',90,'2020-04-21 18:09:32','2020-04-22 02:35:48',NULL,151,'2020-03-27 00:00:00'),
	(152,152,4,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,152,NULL),
	(153,153,1,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,153,NULL),
	(154,154,1,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,154,NULL),
	(155,155,3,'2020-01-17','2020-05-01','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,155,NULL),
	(156,156,4,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,156,NULL),
	(157,157,3,'2020-01-24','2020-05-08','Completado',90,'2020-04-21 18:09:32','2020-04-22 02:40:46',NULL,157,'2020-04-03 00:00:00'),
	(158,158,4,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,158,NULL),
	(159,159,1,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:32','2020-04-21 18:09:33',NULL,159,NULL),
	(160,160,1,'2020-01-24','2020-05-08','Completado',90,'2020-04-21 18:09:33','2020-04-22 01:55:10',NULL,160,'2020-02-21 00:00:00'),
	(161,161,1,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,161,NULL),
	(162,162,5,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,162,NULL),
	(163,163,1,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,163,NULL),
	(164,164,1,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,164,NULL),
	(165,165,5,'2020-01-24','2020-05-08','Completado',90,'2020-04-21 18:09:33','2020-04-22 02:40:46',NULL,165,'2020-04-03 00:00:00'),
	(166,166,5,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,166,NULL),
	(167,167,1,'2020-01-24','2020-05-08','Completado',90,'2020-04-21 18:09:33','2020-04-22 01:49:33',NULL,167,'2020-02-14 00:00:00'),
	(168,168,2,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,168,NULL),
	(169,169,2,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,169,NULL),
	(170,170,3,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,170,NULL),
	(171,171,3,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,171,NULL),
	(172,172,3,'2020-01-24','2020-05-08','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,172,NULL),
	(173,173,1,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,173,NULL),
	(174,174,1,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,174,NULL),
	(175,175,2,'2020-01-31','2020-05-15','Completado',90,'2020-04-21 18:09:33','2020-04-22 01:55:10',NULL,175,'2020-02-21 00:00:00'),
	(176,176,3,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,176,NULL),
	(177,177,5,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,177,NULL),
	(178,178,3,'2020-01-31','2020-05-15','Completado',90,'2020-04-21 18:09:33','2020-04-22 02:40:46',NULL,178,'2020-04-03 00:00:00'),
	(179,179,4,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,179,NULL),
	(180,180,4,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,180,NULL),
	(181,181,4,'2020-01-31','2020-05-15','Completado',90,'2020-04-21 18:09:33','2020-04-22 02:40:46',NULL,181,'2020-04-03 00:00:00'),
	(182,182,1,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,182,NULL),
	(183,183,1,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,183,NULL),
	(184,184,1,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,184,NULL),
	(185,185,1,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:33','2020-04-21 18:09:34',NULL,185,NULL),
	(186,186,1,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,186,NULL),
	(187,187,3,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,187,NULL),
	(188,188,3,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,188,NULL),
	(189,189,2,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,189,NULL),
	(190,190,2,'2020-01-31','2020-05-15','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,190,NULL),
	(191,191,4,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,191,NULL),
	(192,192,6,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,192,NULL),
	(193,193,3,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,193,NULL),
	(194,194,3,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,194,NULL),
	(195,195,1,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,195,NULL),
	(196,196,2,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,196,NULL),
	(197,197,1,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,197,NULL),
	(198,198,1,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,198,NULL),
	(199,199,1,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,199,NULL),
	(200,200,1,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,200,NULL),
	(201,201,3,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,201,NULL),
	(202,202,1,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,202,NULL),
	(203,203,1,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,203,NULL),
	(204,204,1,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,204,NULL),
	(205,205,3,'2020-01-07','2020-04-24','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,205,NULL),
	(206,206,5,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,206,NULL),
	(207,207,4,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,207,NULL),
	(208,208,3,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,208,NULL),
	(209,209,3,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,209,NULL),
	(210,210,1,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,210,NULL),
	(211,211,1,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,211,NULL),
	(212,212,2,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:34','2020-04-21 18:09:35',NULL,212,NULL),
	(213,213,1,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,213,NULL),
	(214,214,5,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,214,NULL),
	(215,215,5,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,215,NULL),
	(216,216,5,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,216,NULL),
	(217,217,1,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,217,NULL),
	(218,218,1,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,218,NULL),
	(219,219,1,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,219,NULL),
	(220,220,1,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,220,NULL),
	(221,221,5,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,221,NULL),
	(222,222,5,'2020-02-14','2020-05-29','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,222,NULL),
	(223,223,3,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,223,NULL),
	(224,224,3,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,224,NULL),
	(225,225,3,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,225,NULL),
	(226,226,3,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,226,NULL),
	(227,227,3,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,227,NULL),
	(228,228,2,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,228,NULL),
	(229,229,1,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,229,NULL),
	(230,230,1,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,230,NULL),
	(231,231,1,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,231,NULL),
	(232,232,1,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,232,NULL),
	(233,233,1,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,233,NULL),
	(234,234,1,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,234,NULL),
	(235,235,1,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,235,NULL),
	(236,236,2,'2020-02-21','2020-06-05','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,236,NULL),
	(237,237,2,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,237,NULL),
	(238,238,4,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,238,NULL),
	(239,239,4,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,239,NULL),
	(240,240,1,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,240,NULL),
	(241,241,4,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,241,NULL),
	(242,242,4,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,242,NULL),
	(243,243,2,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,243,NULL),
	(244,244,2,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,244,NULL),
	(245,245,1,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,245,NULL),
	(246,246,5,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,246,NULL),
	(247,247,5,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,247,NULL),
	(248,248,3,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,248,NULL),
	(249,249,3,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,249,NULL),
	(250,250,1,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,250,NULL),
	(251,251,1,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,251,NULL),
	(252,252,1,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,252,NULL),
	(253,253,1,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,253,NULL),
	(254,254,3,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,254,NULL),
	(255,255,3,'2020-02-28','2020-06-12','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,255,NULL),
	(256,256,3,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,256,NULL),
	(257,257,2,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,257,NULL),
	(258,258,4,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,258,NULL),
	(259,259,1,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,259,NULL),
	(260,260,5,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,260,NULL),
	(261,261,1,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,261,NULL),
	(262,262,1,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,262,NULL),
	(263,263,1,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,263,NULL),
	(264,264,1,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:36','2020-04-21 18:09:37',NULL,264,NULL),
	(265,265,1,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,265,NULL),
	(266,266,1,'2020-03-06','2020-06-19','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,266,NULL),
	(267,267,4,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,267,NULL),
	(268,268,3,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,268,NULL),
	(269,269,2,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,269,NULL),
	(270,270,5,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,270,NULL),
	(271,271,5,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,271,NULL),
	(272,272,1,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,272,NULL),
	(273,273,1,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,273,NULL),
	(274,274,3,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,274,NULL),
	(275,275,3,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,275,NULL),
	(276,276,3,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,276,NULL),
	(277,277,5,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,277,NULL),
	(278,278,2,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,278,NULL),
	(279,279,3,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,279,NULL),
	(280,280,1,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,280,NULL),
	(281,281,4,'2020-03-13','2020-06-26','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,281,NULL),
	(282,282,1,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,282,NULL),
	(283,283,1,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,283,NULL),
	(284,284,2,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,284,NULL),
	(285,285,3,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,285,NULL),
	(286,286,4,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,286,NULL),
	(287,287,4,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,287,NULL),
	(288,288,4,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,288,NULL),
	(289,289,3,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,289,NULL),
	(290,290,2,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,290,NULL),
	(291,291,2,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,291,NULL),
	(292,292,5,'2020-03-20','2020-07-03','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,292,NULL),
	(293,293,4,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,293,NULL),
	(294,294,3,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,294,NULL),
	(295,295,4,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,295,NULL),
	(296,296,1,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,296,NULL),
	(297,297,1,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,297,NULL),
	(298,298,4,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,298,NULL),
	(299,299,5,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,299,NULL),
	(300,300,2,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,300,NULL),
	(301,301,3,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,301,NULL),
	(302,302,5,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,302,NULL),
	(303,303,3,'2020-03-27','2020-07-10','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,303,NULL),
	(304,304,3,'2020-04-02','2020-07-17','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,304,NULL),
	(305,305,3,'2020-04-02','2020-07-17','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,305,NULL),
	(306,306,3,'2020-04-02','2020-07-17','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,306,NULL),
	(307,307,2,'2020-04-02','2020-07-17','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,307,NULL),
	(308,308,2,'2020-04-02','2020-07-17','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,308,NULL),
	(309,309,4,'2020-04-10','2020-07-24','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,309,NULL),
	(310,310,4,'2020-04-10','2020-07-24','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,310,NULL),
	(311,311,3,'2020-04-10','2020-07-24','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,311,NULL),
	(312,312,3,'2020-04-10','2020-07-24','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,312,NULL),
	(313,313,5,'2020-04-10','2020-07-24','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,313,NULL),
	(314,314,5,'2020-04-10','2020-07-24','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,314,NULL),
	(315,315,1,'2020-04-10','2020-07-24','Normal',90,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,315,NULL);



# Volcado de tabla promotores
# ------------------------------------------------------------


CREATE TABLE `promotores` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `codigo_promotor` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supervisor_id` int(10) unsigned DEFAULT NULL,
  `territorio_id` int(11) unsigned DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `promotores_usuarios` (`user_id`),
  KEY `promotor_territorio` (`territorio_id`),
  KEY `promotor_supervisor` (`supervisor_id`),
  CONSTRAINT `promotor_supervisor` FOREIGN KEY (`supervisor_id`) REFERENCES `supervisores` (`id`) ON DELETE CASCADE,
  CONSTRAINT `promotor_territorio` FOREIGN KEY (`territorio_id`) REFERENCES `territorios` (`id`) ON DELETE CASCADE,
  CONSTRAINT `promotores_usuarios` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `promotores` (`id`, `user_id`, `created_at`, `updated_at`, `deleted_at`, `codigo_promotor`, `supervisor_id`, `territorio_id`, `score`)
VALUES
	(1,31,'2020-04-20 05:33:27','2020-04-20 05:33:27',NULL,'PRO-0031',7,1,NULL),
	(2,32,'2020-04-20 05:33:27','2020-04-20 05:33:27',NULL,'PRO-0032',7,2,NULL),
	(3,33,'2020-04-20 05:33:27','2020-04-20 05:33:27',NULL,'PRO-0033',7,3,NULL),
	(4,34,'2020-04-20 05:33:27','2020-04-20 05:33:27',NULL,'PRO-0034',7,4,NULL),
	(5,35,'2020-04-20 05:33:28','2020-04-20 05:33:28',NULL,'PRO-0035',7,5,NULL),
	(6,36,'2020-04-21 16:39:27','2020-04-21 16:39:27',NULL,'OFI-000',7,6,NULL);



# Volcado de tabla referencias
# ------------------------------------------------------------


CREATE TABLE `referencias` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cliente_id` int(11) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `nombre` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `a_paterno` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `a_materno` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parentesco` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `numero_referencia` int(11) DEFAULT NULL,
  `telefono_celular` varchar(14) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telefono_casa` varchar(14) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `domicilio_id` int(11) unsigned DEFAULT NULL,
  `contactada` bit(1) DEFAULT NULL,
  `parentesco_otro` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `referencia_cliente` (`cliente_id`),
  KEY `referencia_domicilio` (`domicilio_id`),
  CONSTRAINT `referencia_cliente` FOREIGN KEY (`cliente_id`) REFERENCES `clientes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `referencia_domicilio` FOREIGN KEY (`domicilio_id`) REFERENCES `domicilios` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Volcado de tabla referencias_validacion
# ------------------------------------------------------------


CREATE TABLE `referencias_validacion` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parentesco` blob,
  `telefono_solicitante` blob,
  `referencia_interesada` blob,
  `sueldo` blob,
  `auto` blob,
  `refrigerador` blob,
  `gas` blob,
  `periodo_pago` blob,
  `direccion` blob,
  `actividad` blob,
  `trabajo` blob,
  `recomienda` blob,
  `referencia_id` int(11) 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 `referencia_validacion_referencia` (`referencia_id`),
  CONSTRAINT `referencia_validacion_referencia` FOREIGN KEY (`referencia_id`) REFERENCES `referencias` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Volcado de tabla rompimiento_politicas
# ------------------------------------------------------------


CREATE TABLE `rompimiento_politicas` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tipo_error` varchar(100) DEFAULT NULL,
  `concepto` varchar(100) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `promotor_id` int(11) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Volcado de tabla secciones
# ------------------------------------------------------------


CREATE TABLE `secciones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `clave` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direccion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `grupo_secciones_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `secciones_grupo_seccion` (`grupo_secciones_id`),
  CONSTRAINT `secciones_grupo_seccion` FOREIGN KEY (`grupo_secciones_id`) REFERENCES `grupo_secciones` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `secciones` (`id`, `nombre`, `clave`, `direccion`, `created_at`, `updated_at`, `deleted_at`, `grupo_secciones_id`)
VALUES
	(1,'Seccion 1','SEC-001','Descripcion 1','2020-03-27 01:25:39','2020-03-27 01:27:05',NULL,2),
	(2,'Seccion 2','SEC-002','Descripcion 2','2020-03-27 01:26:01','2020-03-27 01:27:05',NULL,2),
	(3,'Seccion 3','SEC-003','Descripcion 3','2020-03-27 01:26:25','2020-03-27 01:27:45',NULL,3);



# Volcado de tabla solicitudes
# ------------------------------------------------------------


CREATE TABLE `solicitudes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `promotor_id` int(10) unsigned DEFAULT NULL,
  `cliente_id` int(10) unsigned DEFAULT NULL,
  `comprobante_domicilio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `estado_cuenta` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rfc` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `homoclave` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credito_carro` enum('Si','No') COLLATE utf8mb4_unicode_ci DEFAULT 'No',
  `status` enum('Aprobada','Rechazada','Proceso','Paso 2','Paso 3','Paso 4','Paso 5','Supervisión','Validación','Preaprobado') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cantidad_solicitada` float DEFAULT NULL,
  `cantidad_aprobada` float DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `domicilio_id` int(11) unsigned DEFAULT NULL,
  `comision_apertura` float DEFAULT NULL,
  `total_financiar` float DEFAULT NULL,
  `plazo_credito` int(11) DEFAULT NULL,
  `tasa_interes_anual` float DEFAULT NULL,
  `costo_anual_total` float DEFAULT NULL,
  `cargo_servicio` float DEFAULT NULL,
  `primer_pago` float DEFAULT NULL,
  `pago_semanal` float DEFAULT NULL,
  `prestamo_empresas_otras` enum('Si','No') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `madre_soltera` enum('Si','No') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_propio` enum('Si','No') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firma` blob,
  `tipo_prestamo` enum('Renovación','Paralelo','Refinanciamiento','Normal') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primer_viernes` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `solicitud_domicilio` (`domicilio_id`),
  KEY `solicitud_cliente` (`cliente_id`),
  CONSTRAINT `solicitud_cliente` FOREIGN KEY (`cliente_id`) REFERENCES `clientes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `solicitud_domicilio` FOREIGN KEY (`domicilio_id`) REFERENCES `domicilios` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `solicitudes` (`id`, `promotor_id`, `cliente_id`, `comprobante_domicilio`, `estado_cuenta`, `rfc`, `homoclave`, `credito_carro`, `status`, `cantidad_solicitada`, `cantidad_aprobada`, `created_at`, `updated_at`, `deleted_at`, `domicilio_id`, `comision_apertura`, `total_financiar`, `plazo_credito`, `tasa_interes_anual`, `costo_anual_total`, `cargo_servicio`, `primer_pago`, `pago_semanal`, `prestamo_empresas_otras`, `madre_soltera`, `auto_propio`, `firma`, `tipo_prestamo`, `primer_viernes`)
VALUES
	(1,1,1,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:26','2020-04-21 18:09:26',NULL,1,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2019-11-15'),
	(2,1,2,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,2,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-15'),
	(3,1,3,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,3,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-15'),
	(4,1,4,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,4,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-15'),
	(5,1,5,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,5,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-15'),
	(6,1,6,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,6,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-15'),
	(7,2,7,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,7,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-15'),
	(8,1,8,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,8,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-22'),
	(9,1,9,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,9,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2019-11-22'),
	(10,1,10,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,10,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-22'),
	(11,2,11,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,11,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-22'),
	(12,3,12,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,12,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-22'),
	(13,3,13,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,13,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(14,3,14,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,14,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(15,4,15,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,15,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(16,4,16,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,16,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(17,3,17,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,17,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(18,3,18,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,18,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(19,1,19,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,19,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(20,4,20,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,20,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(21,1,21,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,21,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(22,1,22,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,22,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(23,1,23,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,23,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(24,3,24,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,24,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(25,5,25,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,25,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(26,2,26,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,26,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(27,1,27,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:27','2020-04-21 18:09:27',NULL,27,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-11-29'),
	(28,3,28,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,28,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(29,3,29,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,29,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(30,3,30,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,30,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(31,1,31,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,31,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(32,1,32,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,32,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(33,2,33,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,33,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(34,2,34,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,34,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(35,4,35,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,35,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(36,4,36,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,36,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(37,5,37,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,37,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(38,1,38,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,38,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(39,3,39,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,39,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(40,3,40,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,40,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(41,3,41,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,41,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(42,3,42,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,42,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(43,3,43,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,43,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(44,3,44,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,44,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(45,3,45,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,45,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(46,3,46,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,46,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(47,1,47,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,47,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(48,2,48,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,48,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(49,3,49,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,49,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(50,3,50,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,50,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(51,5,51,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,51,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(52,3,52,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,52,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(53,3,53,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,53,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(54,2,54,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:28','2020-04-21 18:09:28',NULL,54,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(55,5,55,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,55,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2019-12-06'),
	(56,3,56,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,56,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(57,3,57,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,57,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(58,3,58,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,58,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(59,3,59,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,59,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(60,3,60,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,60,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(61,5,61,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,61,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(62,4,62,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,62,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(63,5,63,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,63,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(64,4,64,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,64,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(65,2,65,NULL,NULL,NULL,NULL,'No','Aprobada',12000,12000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,65,NULL,19680,16,NULL,NULL,7680,1680,1200,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(66,2,66,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,66,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(67,3,67,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,67,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(68,3,68,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,68,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(69,3,69,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,69,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(70,1,70,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,70,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(71,1,71,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,71,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(72,3,72,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,72,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(73,1,73,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,73,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-13'),
	(74,6,74,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,74,NULL,16400,16,NULL,NULL,6400,11200,0,NULL,NULL,NULL,NULL,'Normal','2019-12-23'),
	(75,2,75,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,75,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(76,2,76,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,76,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(77,3,77,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,77,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(78,3,78,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,78,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(79,3,79,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,79,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(80,4,80,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:29','2020-04-21 18:09:29',NULL,80,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(81,4,81,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,81,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(82,4,82,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,82,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(83,4,83,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,83,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(84,5,84,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,84,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(85,1,85,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,85,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(86,1,86,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,86,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-20'),
	(87,3,87,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,87,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(88,3,88,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,88,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(89,3,89,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,89,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(90,3,90,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,90,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(91,3,91,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,91,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(92,2,92,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,92,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(93,2,93,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,93,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(94,5,94,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,94,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(95,3,95,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,95,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(96,3,96,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,96,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(97,1,97,NULL,NULL,NULL,NULL,'No','Aprobada',12000,12000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,97,NULL,19680,16,NULL,NULL,7680,1680,1200,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(98,1,98,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,98,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-27'),
	(99,6,99,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,99,NULL,24600,16,NULL,NULL,9600,15900,0,NULL,NULL,NULL,NULL,'Normal','2020-02-23'),
	(100,3,100,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,100,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(101,3,101,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,101,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(102,3,102,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,102,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(103,3,103,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,103,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(104,3,104,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,104,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(105,3,105,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,105,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(106,1,106,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,106,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(107,1,107,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:30','2020-04-21 18:09:30',NULL,107,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(108,1,108,NULL,NULL,NULL,NULL,'No','Aprobada',12000,12000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,108,NULL,19680,16,NULL,NULL,7680,1680,1200,NULL,NULL,NULL,NULL,'Refinanciamiento','2019-12-03'),
	(109,1,109,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,109,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(110,2,110,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,110,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(111,2,111,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,111,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(112,5,112,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,112,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(113,3,113,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,113,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(114,3,114,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,114,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(115,3,115,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,115,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(116,3,116,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,116,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(117,3,117,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,117,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(118,1,118,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,118,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Refinanciamiento','2019-12-03'),
	(119,1,119,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,119,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(120,2,120,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,120,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(121,2,121,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,121,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(122,1,122,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,122,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(123,1,123,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,123,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(124,2,124,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,124,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(125,3,125,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,125,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(126,3,126,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,126,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(127,3,127,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,127,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(128,3,128,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,128,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(129,3,129,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,129,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(130,3,130,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,130,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(131,4,131,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,131,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(132,5,132,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,132,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(133,5,133,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:31','2020-04-21 18:09:31',NULL,133,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2019-12-03'),
	(134,1,134,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,134,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2020-01-10'),
	(135,2,135,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,135,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-01-10'),
	(136,2,136,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,136,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-10'),
	(137,2,137,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,137,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-01-10'),
	(138,3,138,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,138,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-01-10'),
	(139,5,139,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,139,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(140,2,140,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,140,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(141,3,141,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,141,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(142,3,142,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,142,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(143,3,143,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,143,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(144,2,144,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,144,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(145,1,145,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,145,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(146,5,146,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,146,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(147,5,147,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,147,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(148,3,148,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,148,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(149,3,149,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,149,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(150,2,150,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,150,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(151,2,151,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,151,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-17'),
	(152,4,152,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,152,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(153,1,153,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,153,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(154,1,154,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,154,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(155,3,155,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,155,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-17'),
	(156,4,156,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,156,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(157,3,157,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,157,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(158,4,158,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,158,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(159,1,159,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:32','2020-04-21 18:09:32',NULL,159,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(160,1,160,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,160,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(161,1,161,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,161,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-24'),
	(162,5,162,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,162,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(163,1,163,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,163,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(164,1,164,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,164,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(165,5,165,NULL,NULL,NULL,NULL,'No','Aprobada',11000,11000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,165,NULL,18040,16,NULL,NULL,7040,1540,1100,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-24'),
	(166,5,166,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,166,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(167,1,167,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,167,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(168,2,168,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,168,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(169,2,169,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,169,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(170,3,170,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,170,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(171,3,171,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,171,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(172,3,172,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,172,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-24'),
	(173,1,173,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,173,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-31'),
	(174,1,174,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,174,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(175,2,175,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,175,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(176,3,176,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,176,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(177,5,177,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,177,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(178,3,178,NULL,NULL,NULL,NULL,'No','Aprobada',12000,12000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,178,NULL,19680,16,NULL,NULL,7680,1680,1200,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(179,4,179,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,179,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(180,4,180,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,180,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(181,4,181,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,181,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(182,1,182,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,182,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(183,1,183,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,183,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(184,1,184,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,184,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(185,1,185,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:33','2020-04-21 18:09:33',NULL,185,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-31'),
	(186,1,186,NULL,NULL,NULL,NULL,'No','Aprobada',12000,12000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,186,NULL,19680,16,NULL,NULL,7680,1680,1200,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-31'),
	(187,3,187,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,187,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-31'),
	(188,3,188,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,188,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-31'),
	(189,2,189,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,189,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-31'),
	(190,2,190,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,190,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-31'),
	(191,4,191,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,191,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(192,6,192,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,192,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(193,3,193,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,193,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(194,3,194,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,194,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(195,1,195,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,195,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(196,2,196,NULL,NULL,NULL,NULL,'No','Aprobada',13000,13000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,196,NULL,21320,16,NULL,NULL,8320,1820,1300,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(197,1,197,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,197,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-07'),
	(198,1,198,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,198,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-07'),
	(199,1,199,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,199,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(200,1,200,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,200,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-07'),
	(201,3,201,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,201,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-07'),
	(202,1,202,NULL,NULL,NULL,NULL,'No','Aprobada',12000,12000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,202,NULL,19680,16,NULL,NULL,7680,1680,1200,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-01-07'),
	(203,1,203,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,203,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(204,1,204,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,204,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(205,3,205,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,205,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2020-01-07'),
	(206,5,206,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,206,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(207,4,207,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,207,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(208,3,208,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,208,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(209,3,209,NULL,NULL,NULL,NULL,'No','Aprobada',12000,12000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,209,NULL,19680,16,NULL,NULL,7680,1680,1200,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-14'),
	(210,1,210,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,210,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-14'),
	(211,1,211,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,211,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-14'),
	(212,2,212,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:34','2020-04-21 18:09:34',NULL,212,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-14'),
	(213,1,213,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,213,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-14'),
	(214,5,214,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,214,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(215,5,215,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,215,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(216,5,216,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,216,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-14'),
	(217,1,217,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,217,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(218,1,218,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,218,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(219,1,219,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,219,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(220,1,220,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,220,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(221,5,221,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,221,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-02-14'),
	(222,5,222,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,222,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-14'),
	(223,3,223,NULL,NULL,NULL,NULL,'No','Aprobada',13000,13000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,223,NULL,21320,16,NULL,NULL,8320,1820,1300,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-21'),
	(224,3,224,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,224,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-02-21'),
	(225,3,225,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,225,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-21'),
	(226,3,226,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,226,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-21'),
	(227,3,227,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,227,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-21'),
	(228,2,228,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,228,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2020-02-21'),
	(229,1,229,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,229,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-21'),
	(230,1,230,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,230,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-02-21'),
	(231,1,231,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,231,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-21'),
	(232,1,232,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,232,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-21'),
	(233,1,233,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,233,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-02-21'),
	(234,1,234,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,234,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-21'),
	(235,1,235,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,235,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2020-02-21'),
	(236,2,236,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,236,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-21'),
	(237,2,237,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:35','2020-04-21 18:09:35',NULL,237,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(238,4,238,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,238,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(239,4,239,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,239,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(240,1,240,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,240,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(241,4,241,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,241,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(242,4,242,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,242,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(243,2,243,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,243,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(244,2,244,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,244,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(245,1,245,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,245,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(246,5,246,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,246,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(247,5,247,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,247,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(248,3,248,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,248,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(249,3,249,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,249,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(250,1,250,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,250,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(251,1,251,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,251,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(252,1,252,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,252,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(253,1,253,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,253,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-02-28'),
	(254,3,254,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,254,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(255,3,255,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,255,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-02-28'),
	(256,3,256,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,256,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-03-06'),
	(257,2,257,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,257,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-06'),
	(258,4,258,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,258,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-03-06'),
	(259,1,259,NULL,NULL,NULL,NULL,'No','Aprobada',13000,13000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,259,NULL,21320,16,NULL,NULL,8320,1820,1300,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-06'),
	(260,5,260,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,260,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-03-06'),
	(261,1,261,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,261,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-03-06'),
	(262,1,262,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,262,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-03-06'),
	(263,1,263,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,263,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-03-06'),
	(264,1,264,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:36','2020-04-21 18:09:36',NULL,264,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-06'),
	(265,1,265,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,265,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-06'),
	(266,1,266,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,266,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Renovación','2020-03-06'),
	(267,4,267,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,267,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-13'),
	(268,3,268,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,268,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(269,2,269,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,269,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-13'),
	(270,5,270,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,270,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-13'),
	(271,5,271,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,271,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(272,1,272,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,272,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(273,1,273,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,273,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(274,3,274,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,274,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-13'),
	(275,3,275,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,275,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-13'),
	(276,3,276,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,276,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-13'),
	(277,5,277,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,277,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(278,2,278,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,278,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(279,3,279,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,279,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(280,1,280,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,280,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(281,4,281,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,281,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Normal','2020-03-13'),
	(282,1,282,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,282,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-20'),
	(283,1,283,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,283,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-20'),
	(284,2,284,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,284,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-20'),
	(285,3,285,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,285,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-03-20'),
	(286,4,286,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,286,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2020-03-20'),
	(287,4,287,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,287,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2020-03-20'),
	(288,4,288,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,288,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-03-20'),
	(289,3,289,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:37','2020-04-21 18:09:37',NULL,289,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-03-20'),
	(290,2,290,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,290,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Normal','2020-03-20'),
	(291,2,291,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,291,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-03-20'),
	(292,5,292,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,292,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Renovación','2020-03-20'),
	(293,4,293,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,293,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-03-27'),
	(294,3,294,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,294,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-27'),
	(295,4,295,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,295,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Renovación','2020-03-27'),
	(296,1,296,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,296,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-03-27'),
	(297,1,297,NULL,NULL,NULL,NULL,'No','Aprobada',6000,6000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,297,NULL,9840,16,NULL,NULL,3840,840,600,NULL,NULL,NULL,NULL,'Normal','2020-03-27'),
	(298,4,298,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,298,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Normal','2020-03-27'),
	(299,5,299,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,299,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-27'),
	(300,2,300,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,300,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-27'),
	(301,3,301,NULL,NULL,NULL,NULL,'No','Aprobada',9000,9000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,301,NULL,14760,16,NULL,NULL,5760,1260,900,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-27'),
	(302,5,302,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,302,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-03-27'),
	(303,3,303,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,303,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-03-27'),
	(304,3,304,NULL,NULL,NULL,NULL,'No','Aprobada',10000,10000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,304,NULL,16400,16,NULL,NULL,6400,1400,1000,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-04-02'),
	(305,3,305,NULL,NULL,NULL,NULL,'No','Aprobada',8000,8000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,305,NULL,13120,16,NULL,NULL,5120,1120,800,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-04-02'),
	(306,3,306,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,306,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-04-02'),
	(307,2,307,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,307,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2020-04-02'),
	(308,2,308,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,308,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-04-02'),
	(309,4,309,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,309,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-04-10'),
	(310,4,310,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,310,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Normal','2020-04-10'),
	(311,3,311,NULL,NULL,NULL,NULL,'No','Aprobada',7000,7000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,311,NULL,11480,16,NULL,NULL,4480,980,700,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-04-10'),
	(312,3,312,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,312,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-04-10'),
	(313,5,313,NULL,NULL,NULL,NULL,'No','Aprobada',4000,4000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,313,NULL,6560,16,NULL,NULL,2560,560,400,NULL,NULL,NULL,NULL,'Normal','2020-04-10'),
	(314,5,314,NULL,NULL,NULL,NULL,'No','Aprobada',15000,15000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,314,NULL,24600,16,NULL,NULL,9600,2100,1500,NULL,NULL,NULL,NULL,'Refinanciamiento','2020-04-10'),
	(315,1,315,NULL,NULL,NULL,NULL,'No','Aprobada',5000,5000,'2020-04-21 18:09:38','2020-04-21 18:09:38',NULL,315,NULL,8200,16,NULL,NULL,3200,700,500,NULL,NULL,NULL,NULL,'Normal','2020-04-10');



# Volcado de tabla supervisores
# ------------------------------------------------------------


CREATE TABLE `supervisores` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `supervisor_id` int(10) unsigned DEFAULT NULL,
  `codigo_supervisor` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `gerente_supervisor_id` int(10) unsigned DEFAULT NULL,
  `seccion_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `supervisores_usuarios` (`user_id`),
  KEY `supervisor_gerente_supervisor` (`gerente_supervisor_id`),
  KEY `supervisores_secciones` (`seccion_id`),
  CONSTRAINT `supervisor_gerente_supervisor` FOREIGN KEY (`gerente_supervisor_id`) REFERENCES `gerentes_supervisores` (`id`) ON DELETE CASCADE,
  CONSTRAINT `supervisores_secciones` FOREIGN KEY (`seccion_id`) REFERENCES `secciones` (`id`) ON DELETE CASCADE,
  CONSTRAINT `supervisores_usuarios` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `supervisores` (`id`, `user_id`, `supervisor_id`, `codigo_supervisor`, `created_at`, `updated_at`, `deleted_at`, `gerente_supervisor_id`, `seccion_id`)
VALUES
	(1,11,NULL,'S-000111','2020-03-27 01:09:32','2020-03-27 01:09:32',NULL,1,NULL),
	(2,12,NULL,'S-000121','2020-03-27 01:10:36','2020-03-27 01:10:36',NULL,2,NULL),
	(3,13,NULL,'S-000131','2020-03-27 01:12:06','2020-03-27 01:12:06',NULL,3,NULL),
	(4,14,NULL,'S-000221','2020-03-27 01:13:01','2020-03-27 01:13:01',NULL,4,NULL),
	(5,15,NULL,'S-000311','2020-03-27 01:13:59','2020-03-27 01:13:59',NULL,5,NULL),
	(6,16,NULL,'S-000321','2020-03-27 01:14:59','2020-03-27 01:14:59',NULL,6,NULL),
	(7,29,NULL,'S-000','2020-04-19 23:52:01','2020-04-19 23:52:01',NULL,1,NULL);



# Volcado de tabla territorios
# ------------------------------------------------------------


CREATE TABLE `territorios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `clave` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direccion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `seccion_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `territorio_seccion` (`seccion_id`),
  CONSTRAINT `territorio_seccion` FOREIGN KEY (`seccion_id`) REFERENCES `secciones` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `territorios` (`id`, `nombre`, `clave`, `direccion`, `created_at`, `updated_at`, `deleted_at`, `seccion_id`)
VALUES
	(1,'Territorio 1','TR-001','Descripcion 1','2020-03-27 01:19:54','2020-03-27 01:25:39',NULL,1),
	(2,'territorio 2','TR-002','Descripcion 2','2020-03-27 01:20:32','2020-03-27 01:25:39',NULL,1),
	(3,'Territorio 3','TR-003','Descripcion 3','2020-03-27 01:23:05','2020-03-27 01:26:01',NULL,2),
	(4,'Territorio 4','TR-004','Descripcion 4','2020-03-27 01:23:58','2020-03-27 01:26:01',NULL,2),
	(5,'Territorio 5','TR-005','Descripcion 5','2020-03-27 01:24:30','2020-03-27 01:26:25',NULL,3),
	(6,'Territorio 6','TR-006','Descripcion 6','2020-03-27 01:25:03','2020-03-27 01:26:25',NULL,3);



# Volcado de tabla validadores
# ------------------------------------------------------------


CREATE TABLE `validadores` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `codigo_validador` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `administrador_usuario` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Volcado de tabla visitas
# ------------------------------------------------------------


CREATE TABLE `visitas` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `cliente_id` int(11) unsigned DEFAULT NULL,
  `promotor_id` int(11) unsigned DEFAULT NULL,
  `comentario` varchar(300) DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `long` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `validacion` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `visita_cliente` (`cliente_id`),
  KEY `visita_promotor` (`promotor_id`),
  CONSTRAINT `visita_cliente` FOREIGN KEY (`cliente_id`) REFERENCES `clientes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `visita_promotor` FOREIGN KEY (`promotor_id`) REFERENCES `promotores` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;




