-- Table structure for table `loans`
--

CREATE TABLE `loans` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `borrower_id` int NOT NULL,
  `loan_product_id` int NOT NULL,
  `reference` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `release_date` date DEFAULT NULL,
  `maturity_date` date DEFAULT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `interest_start_date` date DEFAULT NULL,
  `first_payment_date` date DEFAULT NULL,
  `loan_disbursed_by_id` int DEFAULT NULL,
  `principal` decimal(65,4) DEFAULT NULL,
  `interest_method` enum('flat_rate','declining_balance_equal_installments','declining_balance_equal_principal','interest_only','compound_interest') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'flat_rate',
  `interest_rate` decimal(10,4) DEFAULT NULL,
  `interest_period` enum('day','week','month','year') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'day',
  `override_interest` tinyint NOT NULL DEFAULT '0',
  `override_interest_amount` decimal(10,4) DEFAULT '0.0000',
  `loan_duration` int DEFAULT NULL,
  `loan_duration_type` enum('day','week','month','year') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'year',
  `repayment_cycle` enum('daily','weekly','monthly','bi_monthly','quarterly','semi_annually','annually') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'monthly',
  `decimal_places` enum('round_off_to_two_decimal','round_off_to_integer') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'round_off_to_two_decimal',
  `repayment_order` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `loan_fees_schedule` enum('dont_include','distribute_fees_evenly','charge_fees_on_released_date','charge_fees_on_first_payment','charge_fees_on_last_payment') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'distribute_fees_evenly',
  `grace_on_interest_charged` int DEFAULT NULL,
  `loan_status_id` int DEFAULT NULL,
  `files` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `loan_status` enum('open','fully_paid','defaulted','restructured','processing') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'open',
  `balance` decimal(65,4) DEFAULT NULL,
  `override` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `status` enum('pending','approved','disbursed','declined','withdrawn','written_off','closed','pending_reschedule','rescheduled') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'pending',
  `applied_amount` decimal(65,4) DEFAULT NULL,
  `approved_amount` decimal(65,4) DEFAULT NULL,
  `approved_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `disbursed_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `withdrawn_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `closed_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `rescheduled_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `declined_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `written_off_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `approved_date` date DEFAULT NULL,
  `disbursed_date` date DEFAULT NULL,
  `withdrawn_date` date DEFAULT NULL,
  `closed_date` date DEFAULT NULL,
  `rescheduled_date` date DEFAULT NULL,
  `declined_date` date DEFAULT NULL,
  `written_off_date` date DEFAULT NULL,
  `approved_by_id` int DEFAULT NULL,
  `disbursed_by_id` int DEFAULT NULL,
  `withdrawn_by_id` int DEFAULT NULL,
  `declined_by_id` int DEFAULT NULL,
  `written_off_by_id` int DEFAULT NULL,
  `rescheduled_by_id` int DEFAULT NULL,
  `closed_by_id` int DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  `processing_fee` decimal(65,4) DEFAULT NULL,
  `product_check_out_id` int DEFAULT NULL,
  `loan_officer_id` int DEFAULT NULL,
  `pay_off_interest_rate` decimal(10,4) DEFAULT '0.0000',
  PRIMARY KEY (`id`),
  KEY `loans_id_index` (`id`),
  KEY `loans_month_index` (`month`),
  KEY `loans_year_index` (`year`),
  KEY `loans_release_date_index` (`release_date`),
  KEY `loans_maturity_date_index` (`maturity_date`)
) ENGINE=InnoDB AUTO_INCREMENT=262 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `loans`
--

INSERT INTO `loans` VALUES (1,4,1,1,NULL,'2019-10-07','2020-03-07','10','2019',NULL,'2019-11-07',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-07 22:53:46','2019-11-14 02:53:00',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-10-07','2019-10-07',NULL,NULL,NULL,NULL,NULL,4,8,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,0.0000),(2,8,2,1,NULL,'2019-11-14','2020-04-14','11','2019',NULL,'2019-12-14',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-13 22:50:31','2019-11-14 02:20:26','2019-11-14 02:20:26','disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-14','2019-11-14',NULL,NULL,NULL,NULL,NULL,8,8,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(3,8,3,1,NULL,'2019-10-09','2020-03-09','10','2019',NULL,'2019-11-09',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-14 02:31:09','2019-11-14 02:58:28','2019-11-14 02:58:28','disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-14','2019-10-09',NULL,NULL,NULL,NULL,NULL,8,8,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(4,8,4,1,NULL,'2019-10-08','2020-03-08','10','2019',NULL,'2019-11-08',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-14 03:55:41','2020-02-07 02:24:05',NULL,'closed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-14','2019-10-08',NULL,NULL,NULL,NULL,NULL,8,8,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,0.0000),(5,8,5,1,NULL,'2019-10-08','2020-03-08','10','2019',NULL,'2019-11-08',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-14 04:11:54','2019-11-20 21:11:04',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-14','2019-11-08',NULL,NULL,NULL,NULL,NULL,8,8,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,0.0000),(6,1,3,1,NULL,'2019-10-09','2020-03-09','10','2019',NULL,'2019-11-09',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-15 21:59:27','2019-11-15 22:08:00',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-16','2019-10-09',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(7,1,6,1,NULL,'2019-10-10','2020-03-10','10','2019',NULL,'2019-11-10',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-15 22:16:42','2020-02-10 03:59:54',NULL,'closed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-16','2019-10-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(8,1,7,1,NULL,'2019-10-11','2020-03-11','10','2019',NULL,'2019-11-11',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-15 22:33:17','2019-11-15 22:37:29',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-16','2019-10-11',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,0.0000),(9,1,8,1,NULL,'2019-10-14','2020-03-14','10','2019',NULL,'2019-11-14',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-15 22:52:19','2020-02-13 23:14:41',NULL,'closed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-16','2019-10-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(10,1,9,1,NULL,'2019-11-18','2020-04-15','11','2019',NULL,'2019-12-15',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-18 04:16:48','2019-11-22 02:53:49','2019-11-22 02:53:49','disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-18','2019-11-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,0.0000),(11,1,10,1,NULL,'2019-10-12','2020-03-12','10','2019',NULL,'2019-11-12',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-20 21:10:36','2020-03-01 21:30:54',NULL,'closed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-21','2019-10-12',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(12,1,11,1,NULL,'2019-11-21','2020-03-15','11','2019',NULL,'2019-11-15',NULL,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-20 21:26:29','2019-11-20 22:23:44','2019-11-20 22:23:44','approved',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-21',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(13,1,12,1,NULL,'2019-10-14','2020-03-14','10','2019',NULL,'2019-11-14',1,10000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-20 22:36:56','2020-02-13 22:29:38',NULL,'closed',10000.0000,10000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-21','2019-10-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(14,1,13,1,NULL,'2019-10-16','2020-03-15','10','2019',NULL,'2019-11-15',1,2000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-20 23:23:19','2019-11-20 23:28:09',NULL,'disbursed',2000.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-21','2019-10-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,0.0000),(15,1,14,1,NULL,'2019-10-16','2020-03-15','10','2019',NULL,'2019-11-15',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-20 23:41:10','2019-11-20 23:45:51',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-21','2019-10-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,0.0000),(16,1,15,1,NULL,'2019-10-16','2020-05-15','10','2019',NULL,'2019-11-15',1,500.0000,'interest_only',2.5000,'month',0,0.0000,6,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-22 03:00:55','2019-11-22 03:05:13',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-22','2019-10-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(17,1,16,1,NULL,'2019-10-16','2020-03-15','10','2019',NULL,'2019-11-15',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-22 03:23:15','2019-11-22 03:30:17',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-22','2019-10-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,0.0000),(18,1,17,1,NULL,'2019-10-16','2020-03-15','10','2019',NULL,'2019-11-15',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-22 03:41:00','2020-02-14 03:10:56',NULL,'closed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-22','2019-10-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(19,1,18,1,NULL,'2019-10-17','2020-03-01','10','2019',NULL,'2019-11-01',1,7000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-22 03:55:59','2019-11-22 04:03:07',NULL,'disbursed',7000.0000,7000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-22','2019-10-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,0.0000),(20,1,19,1,NULL,'2019-11-25','2020-04-15','11','2019',NULL,'2019-12-15',NULL,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-24 23:21:41','2019-11-25 04:24:26','2019-11-25 04:24:26','pending',700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(21,1,20,1,NULL,'2019-10-17','2020-03-15','10','2019',NULL,'2019-11-15',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-26 21:12:07','2019-12-08 22:53:33',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-10-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(22,1,21,1,NULL,'2019-11-29','2020-12-10','11','2019',NULL,'2019-12-10',1,1000.0000,'flat_rate',3.0000,'month',0,0.0000,12,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-11-28 23:07:38','2019-11-29 04:23:06','2019-11-29 04:23:06','disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-11-29','2019-11-29',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(23,1,22,1,NULL,'2019-12-03','2021-01-03','12','2019',NULL,'2020-01-03',1,1000.0000,'flat_rate',3.0000,'month',0,0.0000,12,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-02 21:54:33','2019-12-02 22:01:21',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-03','2019-12-03',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(24,1,23,1,NULL,'2019-12-09','2020-05-09','12','2019',NULL,'2020-01-09',1,5000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-08 21:46:41','2019-12-08 21:52:28',NULL,'disbursed',5000.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-12-09',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(25,1,24,1,NULL,'2019-10-18','2020-03-10','10','2019',NULL,'2019-11-10',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-08 22:35:10','2020-02-10 04:26:19','2020-02-10 04:26:19','rescheduled',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-10-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(26,1,25,1,NULL,'2019-10-18','2020-03-01','10','2019',NULL,'2019-11-01',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-08 22:52:41','2019-12-08 23:00:03',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-10-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(27,1,26,1,NULL,'2019-12-09','2020-05-09','12','2019',NULL,'2020-01-09',1,6000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-08 23:23:53','2019-12-08 23:33:40','2019-12-08 23:33:40','disbursed',6000.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-12-09',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(28,1,26,1,NULL,'2019-12-09','2020-05-09','12','2019',NULL,'2020-01-09',1,6000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-08 23:34:15','2019-12-08 23:50:28',NULL,'disbursed',6000.0000,6000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-12-09',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(29,1,27,1,NULL,'2019-10-18','2020-03-10','10','2019',NULL,'2019-11-10',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-09 02:41:39','2019-12-09 02:45:20',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-10-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(30,1,28,1,NULL,'2019-10-18','2020-03-15','10','2019',NULL,'2019-11-15',1,3500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-09 02:49:27','2020-02-09 23:02:29',NULL,'closed',3500.0000,3500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-10-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(31,1,29,1,NULL,'2019-12-09','2020-05-09','12','2019',NULL,'2020-01-09',1,5000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-09 03:23:35','2019-12-09 03:29:52',NULL,'disbursed',5000.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-09','2019-12-09',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(32,1,10,1,NULL,'2019-12-10','2020-05-10','12','2019',NULL,'2020-01-10',1,1100.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-09 21:39:20','2019-12-09 21:44:03',NULL,'disbursed',1100.0000,1100.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-10','2019-12-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(33,1,31,1,NULL,'2019-12-11','2020-05-11','12','2019',NULL,'2020-01-11',1,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-11 03:31:34','2019-12-11 03:37:42',NULL,'disbursed',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-11','2019-12-11',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(34,1,32,1,NULL,'2019-12-12','2020-05-12','12','2019',NULL,'2020-01-12',1,6000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-11 21:13:33','2019-12-11 21:17:09',NULL,'disbursed',6000.0000,6000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-12','2019-12-12',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(35,1,33,1,NULL,'2019-12-12','2020-05-12','12','2019',NULL,'2020-01-12',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-12 03:05:07','2019-12-12 03:07:43',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-12','2019-12-12',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(36,1,34,1,NULL,'2019-12-13','2020-05-13','12','2019',NULL,'2020-01-13',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-13 04:16:15','2019-12-13 04:20:04',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-13','2019-12-13',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(37,1,35,1,NULL,'2019-10-18','2020-03-01','10','2019',NULL,'2019-11-01',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-13 20:37:03','2019-12-13 20:45:49',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-14','2019-10-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(38,1,36,1,NULL,'2019-12-14','2020-05-14','12','2019',NULL,'2020-01-14',1,1300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-13 20:55:03','2019-12-13 20:57:18',NULL,'disbursed',1300.0000,1300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-14','2019-12-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(39,1,37,1,NULL,'2019-12-14','2020-05-14','12','2019',NULL,'2020-01-14',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-13 21:07:52','2019-12-13 21:11:45',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-14','2019-12-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(40,1,12,1,NULL,'2019-12-14','2020-05-14','12','2019',NULL,'2020-01-14',1,13000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-13 21:44:32','2019-12-13 21:51:40',NULL,'disbursed',13000.0000,13000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-14','2019-12-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(41,1,38,1,NULL,'2019-12-14','2020-05-14','12','2019',NULL,'2020-01-14',1,150.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-13 22:30:03','2019-12-13 22:33:05',NULL,'disbursed',150.0000,150.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-14','2019-12-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(42,1,8,1,NULL,'2019-12-16','2020-05-15','12','2019',NULL,'2020-01-15',1,1300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-15 21:56:05','2020-02-13 23:22:28',NULL,'closed',1300.0000,1300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-16','2019-12-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(43,1,39,1,NULL,'2019-12-16','2020-05-15','12','2019',NULL,'2020-01-15',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-15 23:09:05','2019-12-15 23:11:39',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-16','2019-12-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(44,1,40,1,NULL,'2019-12-16','2020-05-06','12','2019',NULL,'2020-01-06',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-15 23:28:13','2019-12-15 23:39:16',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-16','2019-12-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(45,1,41,1,NULL,'2019-12-16','2020-05-05','12','2019',NULL,'2020-01-05',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-16 03:10:34','2019-12-16 03:12:21',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-16','2019-12-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(46,1,42,1,NULL,'2019-12-17','2020-05-15','12','2019',NULL,'2020-01-15',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-17 02:34:53','2019-12-17 02:41:09',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-17','2019-12-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(47,1,26,1,NULL,'2019-12-17','2020-05-15','12','2019',NULL,'2020-01-15',1,10000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-17 02:59:23','2019-12-17 03:01:56',NULL,'disbursed',10000.0000,10000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-17','2019-12-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(48,1,43,1,NULL,'2019-12-17','2020-05-15','12','2019',NULL,'2020-01-15',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-17 03:22:52','2019-12-17 03:24:53',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-17','2019-12-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(49,1,44,1,NULL,'2019-12-17','2020-05-10','12','2019',NULL,'2020-01-10',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-17 04:31:43','2019-12-17 04:36:59',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-17','2019-12-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(50,1,45,1,NULL,'2019-12-18','2020-05-10','12','2019',NULL,'2020-01-10',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-17 21:17:17','2019-12-17 21:19:05',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-18','2019-12-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(51,1,46,1,NULL,'2019-12-18','2020-05-05','12','2019',NULL,'2020-01-05',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-18 02:54:23','2019-12-18 02:57:52',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-18','2019-12-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(52,1,47,1,NULL,'2019-12-23','2020-05-05','12','2019',NULL,'2020-01-05',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-22 20:37:14','2020-03-01 21:03:28','2020-03-01 21:03:28','rescheduled',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-23','2019-12-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(53,1,14,1,NULL,'2019-12-23','2020-05-15','12','2019',NULL,'2020-01-15',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-22 21:24:38','2019-12-22 21:28:52',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-23','2019-12-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(54,1,48,1,NULL,'2019-12-23','2020-05-15','12','2019',NULL,'2020-01-15',1,10000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-22 23:17:53','2019-12-22 23:21:17',NULL,'disbursed',10000.0000,10000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-23','2019-12-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(55,1,49,1,NULL,'2019-12-23','2020-05-05','12','2019',NULL,'2020-01-05',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-22 23:33:33','2019-12-22 23:38:12',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-23','2019-12-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(56,1,50,1,NULL,'2019-12-23','2020-05-15','12','2019',NULL,'2020-01-15',1,4000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-23 00:08:55','2019-12-23 00:11:06',NULL,'disbursed',4000.0000,4000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-23','2019-12-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(57,1,51,1,NULL,'2019-12-23','2020-05-10','12','2019',NULL,'2020-01-10',1,650.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-23 01:56:37','2019-12-23 01:59:00',NULL,'disbursed',650.0000,650.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-23','2019-12-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(58,1,52,1,NULL,'2019-12-23','2020-05-15','12','2019',NULL,'2020-01-15',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-23 02:15:58','2019-12-23 02:25:31',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-23','2019-12-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(59,1,53,1,NULL,'2019-12-24','2020-05-12','12','2019',NULL,'2020-01-12',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-23 20:09:33','2019-12-23 20:13:22',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-24','2019-12-24',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(60,1,54,1,NULL,'2019-12-24','2020-05-12','12','2019',NULL,'2020-01-12',1,5000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-23 21:40:29','2019-12-23 21:46:12',NULL,'disbursed',5000.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-24','2019-12-24',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(61,1,55,1,NULL,'2019-12-25','2020-05-03','12','2019',NULL,'2020-01-03',1,200.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-24 21:33:12','2019-12-24 21:35:27',NULL,'disbursed',200.0000,200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-25','2019-12-25',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(62,1,56,1,NULL,'2019-12-25','2020-05-05','12','2019',NULL,'2020-01-05',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-25 03:16:07','2019-12-25 03:20:07',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-25','2019-12-25',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(63,1,57,1,NULL,'2019-12-26','2020-05-10','12','2019',NULL,'2020-01-10',1,1300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-25 22:31:20','2019-12-25 22:39:13',NULL,'disbursed',1300.0000,1300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-26','2019-12-26',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(64,1,44,1,NULL,'2019-12-26','2020-05-10','12','2019',NULL,'2020-01-10',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-26 02:16:39','2019-12-26 02:20:01',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-26','2019-12-26',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(65,1,58,1,NULL,'2019-12-26','2020-05-12','12','2019',NULL,'2020-01-12',1,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-26 03:00:25','2019-12-26 03:04:13',NULL,'disbursed',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-26','2019-12-26',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(66,1,59,1,NULL,'2019-12-27','2020-05-09','12','2019',NULL,'2020-01-09',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-27 02:51:47','2019-12-27 02:56:12',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-27','2019-12-27',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(67,1,60,1,NULL,'2019-12-28','2020-05-10','12','2019',NULL,'2020-01-10',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-27 21:48:32','2019-12-27 21:57:15',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-28','2019-12-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(68,1,61,1,NULL,'2019-12-30','2020-05-05','12','2019',NULL,'2020-01-05',1,2000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-29 22:42:13','2019-12-29 22:45:45',NULL,'disbursed',2000.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-30','2019-12-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(69,1,62,1,NULL,'2019-12-30','2020-11-05','12','2019',NULL,'2020-01-05',1,400.0000,'flat_rate',3.0000,'month',0,0.0000,10,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-29 23:12:43','2019-12-29 23:15:34',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-30','2019-12-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(70,1,63,1,NULL,'2019-12-30','2020-05-15','12','2019',NULL,'2020-01-15',1,10000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-29 23:30:13','2019-12-29 23:32:58',NULL,'disbursed',10000.0000,10000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-30','2019-12-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(71,1,64,1,NULL,'2019-12-30','2020-05-10','12','2019',NULL,'2020-01-10',1,2000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-29 23:45:27','2020-02-10 03:53:59',NULL,'closed',2000.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-30','2019-12-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(72,1,65,1,NULL,'2019-12-30','2020-05-15','12','2019',NULL,'2020-01-15',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-30 02:03:07','2019-12-30 02:06:37',NULL,'disbursed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-30','2019-12-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(73,1,66,1,NULL,'2019-12-30','2020-05-13','12','2019',NULL,'2020-01-13',1,1100.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-30 03:33:01','2019-12-30 03:35:07',NULL,'disbursed',1100.0000,1100.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-30','2019-12-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(74,1,67,1,NULL,'2019-12-30','2020-05-01','12','2019',NULL,'2020-01-01',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-30 03:56:33','2019-12-30 04:01:32',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-30','2019-12-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(75,1,1,1,NULL,'2019-12-31','2020-05-02','12','2019',NULL,'2020-01-02',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2019-12-30 22:53:20','2019-12-30 22:55:06',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-12-31','2019-12-31',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(76,1,68,1,NULL,'2020-01-02','2020-06-02','01','2020',NULL,'2020-02-02',1,12000.0000,'interest_only',1.5000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-01 20:22:49','2020-01-01 21:28:55',NULL,'disbursed',12000.0000,12000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-02','2020-01-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,1.5000),(77,1,69,1,NULL,'2020-01-02','2020-06-02','01','2020',NULL,'2020-02-02',1,1200.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-01 22:20:44','2020-01-01 22:22:30',NULL,'disbursed',1200.0000,1200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-02','2020-01-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(78,1,70,1,NULL,'2019-10-19','2020-03-05','10','2019',NULL,'2019-11-05',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-01 23:08:48','2020-01-02 03:08:31',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-02','2019-10-19',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(79,1,71,1,NULL,'2019-10-19','2020-03-15','10','2019',NULL,'2019-11-15',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-01 23:27:03','2020-02-14 22:37:10',NULL,'closed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-02','2019-10-19',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(80,1,72,1,NULL,'2019-10-19','2020-03-15','10','2019',NULL,'2019-11-15',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-02 01:33:39','2020-01-02 03:09:15',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-02','2019-10-19',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(81,1,73,1,NULL,'2019-10-22','2020-03-15','10','2019',NULL,'2019-11-15',1,25000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-02 03:24:17','2020-01-03 02:46:39',NULL,'disbursed',25000.0000,25000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-03','2019-10-22',NULL,NULL,NULL,NULL,NULL,9,9,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(82,1,74,1,NULL,'2019-10-21','2020-03-07','10','2019',NULL,'2019-11-07',NULL,4500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-02 03:41:07','2020-01-02 23:31:10','2020-01-02 23:31:10','pending',4500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(83,1,74,1,NULL,'2019-10-21','2020-03-07','10','2019',NULL,'2019-11-07',1,4500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-02 03:41:09','2020-01-03 02:46:28',NULL,'disbursed',4500.0000,4500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-03','2019-10-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(84,1,75,1,NULL,'2019-10-21','2020-03-15','10','2019',NULL,'2019-11-15',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-02 03:54:27','2020-01-03 02:46:55',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-03','2019-10-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(85,1,76,1,NULL,'2020-01-03','2020-06-03','01','2020',NULL,'2020-02-03',1,1300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-02 23:06:09','2020-01-02 23:12:07',NULL,'disbursed',1300.0000,1300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-03','2020-01-03',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(86,1,77,1,NULL,'2020-01-03','2020-06-03','01','2020',NULL,'2020-02-03',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-03 02:19:42','2020-01-03 02:26:00',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-03','2020-01-03',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(87,1,78,1,NULL,'2020-01-06','2020-06-06','01','2020',NULL,'2020-02-06',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 02:18:25','2020-02-05 21:40:32',NULL,'closed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-06','2020-01-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(88,1,79,1,NULL,'2020-01-06','2020-06-06','01','2020',NULL,'2020-02-06',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 02:59:41','2020-01-06 03:03:04',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-06','2020-01-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(89,1,80,1,NULL,'2020-01-06','2020-06-06','01','2020',NULL,'2020-02-06',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 03:10:42','2020-01-06 03:15:43',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-06','2020-01-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(90,1,81,1,NULL,'2020-01-06','2020-06-06','01','2020',NULL,'2020-02-06',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 03:31:45','2020-01-06 03:33:49',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-06','2020-01-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(91,1,82,1,NULL,'2020-01-06','2020-06-06','01','2020',NULL,'2020-02-06',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 04:18:55','2020-01-06 04:22:54',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-06','2020-01-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(92,1,83,1,NULL,'2019-10-25','2020-03-15','10','2019',NULL,'2019-11-15',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:03:35','2020-01-07 23:14:43',NULL,'disbursed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-25',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(93,1,84,1,NULL,'2019-10-25','2020-03-15','10','2019',NULL,'2019-11-15',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:11:21','2020-01-06 22:14:16',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-07','2019-10-25',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(94,1,85,1,NULL,'2019-10-23','2020-03-15','10','2019',NULL,'2019-11-15',1,15000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:19:44','2020-01-07 23:19:30',NULL,'disbursed',15000.0000,15000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(95,1,86,1,NULL,'2019-10-28','2020-05-15','10','2019',NULL,'2019-11-15',1,6000.0000,'interest_only',2.5000,'month',0,0.0000,6,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:21:44','2020-01-06 22:23:38',NULL,'disbursed',6000.0000,6000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-07','2019-10-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,2.5000),(96,1,87,1,NULL,'2019-10-28','2020-03-15','10','2019',NULL,'2019-11-15',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:25:48','2020-01-06 22:30:28',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-07','2019-10-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(97,1,89,1,NULL,'2019-10-28','2020-03-05','10','2019',NULL,'2019-11-05',1,200.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:34:01','2020-01-06 22:38:05',NULL,'disbursed',200.0000,200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-07','2019-10-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(98,1,88,1,NULL,'2019-10-25','2020-03-10','10','2019',NULL,'2019-11-10',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:34:20','2020-01-07 23:16:48',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-25',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(99,1,90,1,NULL,'2019-10-28','2020-03-15','10','2019',NULL,'2019-11-15',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:42:12','2020-02-14 20:19:58',NULL,'rescheduled',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-07','2019-10-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(100,1,91,1,NULL,'2019-10-23','2020-03-15','10','2019',NULL,'2019-11-15',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 22:43:46','2020-01-07 23:19:58',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(101,1,92,1,NULL,'2020-01-07','2020-06-07','01','2020',NULL,'2020-02-07',1,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 23:00:21','2020-01-08 03:52:57','2020-01-08 03:52:57','closed',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-07','2020-01-07',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(102,1,93,1,NULL,'2019-10-25','2020-03-03','10','2019',NULL,'2019-11-03',1,1700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 23:05:29','2020-01-07 23:18:44',NULL,'disbursed',1700.0000,1700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-25',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(103,1,94,1,NULL,'2020-01-07','2020-06-07','01','2020',NULL,'2020-02-07',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 23:21:07','2020-01-06 23:32:23',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-07','2020-01-07',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(104,1,95,1,NULL,'2019-10-28','2020-03-15','10','2019',NULL,'2019-11-15',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-06 23:41:34','2020-01-06 23:46:13',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-07','2019-10-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(105,1,96,1,NULL,'2019-11-04','2020-04-04','11','2019',NULL,'2019-12-04',1,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-07 23:09:51','2020-01-07 23:20:56',NULL,'disbursed',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-11-04',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(106,1,97,1,NULL,'2019-10-28','2020-03-15','10','2019',NULL,'2019-11-15',1,5500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-07 23:14:11','2020-03-02 04:31:08',NULL,'closed',5500.0000,5500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(107,1,99,1,NULL,'2019-10-28','2020-05-05','10','2019',NULL,'2019-11-05',1,5000.0000,'interest_only',2.5000,'month',0,0.0000,6,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 01:53:38','2020-01-08 02:04:20',NULL,'disbursed',5000.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,2.5000),(108,1,98,1,NULL,'2019-10-31','2020-03-09','10','2019',NULL,'2019-11-09',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 01:56:17','2020-02-10 03:44:39',NULL,'closed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-31',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(109,1,100,1,NULL,'2019-10-30','2020-03-03','10','2019',NULL,'2019-11-03',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 02:09:18','2020-01-08 02:15:21',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(110,1,102,1,NULL,'2019-10-30','2020-03-15','10','2019',NULL,'2019-11-15',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 02:18:14','2020-02-14 20:33:28',NULL,'closed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(111,1,101,1,NULL,'2019-10-31','2020-03-05','10','2019',NULL,'2019-11-05',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 02:23:17','2020-01-08 03:36:46',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-10-31',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(112,1,103,1,NULL,'2019-11-06','2020-04-06','11','2019',NULL,'2019-12-06',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 02:33:25','2020-01-08 03:36:13',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-11-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(113,1,104,1,NULL,'2019-11-05','2020-04-05','11','2019',NULL,'2019-12-05',1,4000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 02:38:38','2020-01-08 02:42:35',NULL,'disbursed',4000.0000,4000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-11-05',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(114,1,92,1,NULL,'2020-01-08','2020-06-08','01','2020',NULL,'2020-02-08',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 03:11:16','2020-01-08 03:53:38','2020-01-08 03:53:38','disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2020-01-08',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(115,1,106,1,NULL,'2019-11-08','2020-04-08','11','2019',NULL,'2019-12-08',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 03:28:45','2020-01-14 04:28:36',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2019-11-08',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(116,1,108,1,NULL,'2019-11-08','2020-04-08','11','2019',NULL,'2019-12-08',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 03:40:53','2020-01-14 04:28:57',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2019-11-08',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(117,1,2,1,NULL,'2019-11-04','2020-04-04','11','2019',NULL,'2019-12-04',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 03:46:07','2020-02-07 02:47:09',NULL,'closed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-11-04',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(118,1,92,1,NULL,'2019-11-14','2020-04-14','11','2019',NULL,'2019-12-14',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 03:50:38','2020-01-14 04:28:12',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2019-11-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(119,1,2,1,NULL,'2019-11-14','2020-04-14','11','2019',NULL,'2019-12-14',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 04:01:38','2020-01-08 04:10:30',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-08','2019-11-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(120,1,109,1,NULL,'2020-01-09','2020-06-09','01','2020',NULL,'2020-02-09',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 20:31:54','2020-01-08 20:35:44',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-09','2020-01-09',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(121,1,110,1,NULL,'2019-11-08','2020-04-08','11','2019',NULL,'2019-12-08',1,10000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 21:10:57','2020-01-14 04:29:23',NULL,'disbursed',10000.0000,10000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2019-11-08',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(122,1,111,1,NULL,'2019-11-08','2020-04-08','11','2019',NULL,'2019-12-08',1,8000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-08 21:50:36','2020-01-14 04:29:44',NULL,'disbursed',8000.0000,8000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2019-11-08',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(123,1,64,1,NULL,'2020-01-10','2020-06-10','01','2020',NULL,'2020-02-10',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-09 22:39:22','2020-01-09 22:49:42',NULL,'disbursed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-10','2020-01-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(124,1,112,1,NULL,'2020-01-10','2020-06-10','01','2020',NULL,'2020-02-10',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-10 03:17:41','2020-01-14 04:30:11',NULL,'closed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-10','2020-01-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(125,1,113,1,NULL,'2020-01-13','2020-06-13','01','2020',NULL,'2020-02-13',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-12 23:52:15','2020-01-12 23:58:15',NULL,'disbursed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-13','2020-01-13',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(126,1,114,1,NULL,'2020-01-13','2020-06-13','01','2020',NULL,'2020-02-13',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-13 02:24:46','2020-01-13 02:31:51',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-13','2020-01-13',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(127,1,115,1,NULL,'2020-01-13','2020-06-13','01','2020',NULL,'2020-02-13',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-13 03:50:43','2020-01-13 03:53:44',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-13','2020-01-13',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(128,1,116,1,NULL,'2020-01-14','2020-06-14','01','2020',NULL,'2020-02-14',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-14 02:10:31','2020-01-22 03:57:07',NULL,'closed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2020-01-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(129,1,117,1,NULL,'2020-01-14','2020-06-14','01','2020',NULL,'2020-02-14',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-14 02:30:16','2020-01-14 02:34:31',NULL,'disbursed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2020-01-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(130,1,118,1,NULL,'2020-01-14','2020-06-14','01','2020',NULL,'2020-02-14',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-14 02:47:56','2020-01-14 02:54:26',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2020-01-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(131,1,112,1,NULL,'2020-01-14','2020-06-14','01','2020',NULL,'2020-02-14',1,2500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-14 04:01:15','2020-01-14 04:09:44',NULL,'disbursed',2500.0000,2500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-14','2020-01-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(132,1,13,1,NULL,'2020-01-15','2020-06-15','01','2020',NULL,'2020-02-15',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-14 21:22:00','2020-01-14 21:37:29',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-15','2020-01-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(133,1,119,1,NULL,'2020-01-15','2020-06-15','01','2020',NULL,'2020-02-15',1,1300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-14 22:36:41','2020-01-14 22:40:50',NULL,'disbursed',1300.0000,1300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-15','2020-01-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(134,1,120,1,NULL,'2020-01-16','2020-06-05','01','2020',NULL,'2020-02-05',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-15 22:35:11','2020-01-15 22:41:26',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-16','2020-01-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(135,1,121,1,NULL,'2020-01-16','2020-06-05','01','2020',NULL,'2020-02-05',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-15 23:17:51','2020-01-15 23:24:32',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-16','2020-01-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(136,1,122,1,NULL,'2020-01-16','2020-06-10','01','2020',NULL,'2020-02-10',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-16 01:46:28','2020-01-16 01:56:03',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-16','2020-01-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(137,1,123,1,NULL,'2020-01-16','2020-06-08','01','2020',NULL,'2020-02-08',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-16 03:33:34','2020-01-16 03:36:26',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-16','2020-01-16',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(138,1,124,1,NULL,'2020-01-17','2020-06-10','01','2020',NULL,'2020-02-10',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-16 22:20:17','2020-01-16 22:28:08',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-17','2020-01-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(139,1,125,1,NULL,'2020-01-17','2020-06-10','01','2020',NULL,'2020-02-10',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-17 02:07:15','2020-01-17 02:11:00',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-17','2020-01-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(140,1,126,1,NULL,'2020-01-17','2020-06-10','01','2020',NULL,'2020-02-10',1,900.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-17 02:19:07','2020-01-17 02:21:21',NULL,'disbursed',900.0000,900.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-17','2020-01-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(141,1,127,1,NULL,'2020-01-20','2020-06-10','01','2020',NULL,'2020-02-10',1,1100.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-19 22:09:16','2020-01-19 22:11:59',NULL,'disbursed',1100.0000,1100.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-20','2020-01-20',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(142,1,128,1,NULL,'2020-01-20','2020-06-07','01','2020',NULL,'2020-02-07',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-19 22:58:46','2020-01-19 23:02:31',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-20','2020-01-20',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(143,1,51,1,NULL,'2020-01-20','2020-06-10','01','2020',NULL,'2020-02-10',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-19 23:07:39','2020-01-19 23:11:49',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-20','2020-01-20',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(144,1,129,1,NULL,'2020-01-20','2020-06-05','01','2020',NULL,'2020-02-05',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-20 01:42:31','2020-01-20 01:48:01',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-20','2020-01-20',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(145,1,130,1,NULL,'2020-01-20','2020-06-10','01','2020',NULL,'2020-02-10',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-20 04:27:19','2020-01-20 04:30:13',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-20','2020-01-20',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(146,1,74,1,NULL,'2020-01-21','2020-06-07','01','2020',NULL,'2020-02-07',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-20 22:05:46','2020-01-20 22:12:21',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-21','2020-01-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(147,1,131,1,NULL,'2020-01-21','2020-06-10','01','2020',NULL,'2020-02-10',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-20 22:40:42','2020-01-20 22:44:45',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-21','2020-01-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(148,1,132,1,NULL,'2020-01-21','2020-06-10','01','2020',NULL,'2020-02-10',1,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-21 02:24:42','2020-01-21 02:30:02',NULL,'disbursed',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-21','2020-01-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(149,1,133,1,NULL,'2020-01-21','2020-06-08','01','2020',NULL,'2020-02-08',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-21 04:34:46','2020-01-21 04:37:28',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-21','2020-01-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(150,1,134,1,NULL,'2020-01-22','2020-06-09','01','2020',NULL,'2020-02-09',1,2500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-22 02:16:02','2020-01-22 02:22:48',NULL,'disbursed',2500.0000,2500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-22','2020-01-22',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(151,1,116,1,NULL,'2020-01-22','2020-06-14','01','2020',NULL,'2020-02-14',1,4500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-22 03:52:41','2020-01-22 03:57:59',NULL,'disbursed',4500.0000,4500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-22','2020-01-22',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(152,1,135,1,NULL,'2020-01-28','2020-06-05','01','2020',NULL,'2020-02-05',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-27 22:59:48','2020-01-27 23:12:29',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-28','2020-01-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(153,1,23,1,NULL,'2020-01-28','2020-06-09','01','2020',NULL,'2020-02-09',1,6000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-27 23:26:41','2020-01-27 23:31:29',NULL,'disbursed',6000.0000,6000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-28','2020-01-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(154,1,136,1,NULL,'2020-01-28','2020-06-02','01','2020',NULL,'2020-02-02',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-27 23:50:02','2020-01-27 23:53:03',NULL,'disbursed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-28','2020-01-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(155,1,137,1,NULL,'2020-01-28','2020-06-10','01','2020',NULL,'2020-02-10',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-28 03:11:30','2020-01-28 03:26:38',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-28','2020-01-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(156,1,86,1,NULL,'2020-01-29','2020-06-15','01','2020',NULL,'2020-02-15',1,3200.0000,'interest_only',2.5000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-29 02:49:08','2020-01-29 02:58:39',NULL,'disbursed',3200.0000,3200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-29','2020-01-29',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,2.5000),(157,1,5,1,NULL,'2020-01-30','2020-06-08','01','2020',NULL,'2020-02-08',1,750.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-30 02:37:27','2020-01-30 02:42:03',NULL,'disbursed',750.0000,750.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-30','2020-01-30',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(158,1,138,1,NULL,'2020-01-31','2020-06-12','01','2020',NULL,'2020-02-12',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-31 02:00:13','2020-01-31 02:05:07',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-01-31','2020-01-31',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(159,1,25,1,NULL,'2020-02-01','2020-07-01','02','2020',NULL,'2020-03-01',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-31 20:30:23','2020-01-31 20:33:39',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-01','2020-02-01',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(160,1,139,1,NULL,'2020-02-01','2020-07-01','02','2020',NULL,'2020-03-01',1,4100.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-31 21:48:04','2020-03-01 20:42:58',NULL,'rescheduled',4100.0000,4100.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-01','2020-02-01',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(161,1,140,1,NULL,'2020-02-01','2020-07-01','02','2020',NULL,'2020-03-01',1,7000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-01-31 23:04:32','2020-01-31 23:14:59',NULL,'disbursed',7000.0000,7000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-01','2020-02-01',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(162,1,35,1,NULL,'2020-02-01','2020-07-01','02','2020',NULL,'2020-03-01',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-01 00:09:48','2020-02-01 00:12:53',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-01','2020-02-01',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(163,1,141,1,NULL,'2020-02-03','2020-07-03','02','2020',NULL,'2020-03-03',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-02 20:26:58','2020-03-02 02:58:45',NULL,'rescheduled',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-03','2020-02-03',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(164,1,100,1,NULL,'2020-02-03','2020-07-03','02','2020',NULL,'2020-03-03',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-02 20:40:46','2020-03-01 22:19:18',NULL,'rescheduled',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-03','2020-02-03',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(165,1,142,1,NULL,'2020-02-03','2020-07-03','02','2020',NULL,'2020-03-03',1,200.0000,'interest_only',1.5000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-02 20:58:06','2020-02-25 20:26:25',NULL,'rescheduled',200.0000,200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-03','2020-02-03',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,1.5000),(166,1,93,1,NULL,'2020-02-03','2020-07-03','02','2020',NULL,'2020-03-03',1,1700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-03 02:20:36','2020-02-03 02:29:10',NULL,'disbursed',1700.0000,1700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-03','2020-02-03',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(167,1,143,1,NULL,'2020-02-04','2020-07-04','02','2020',NULL,'2020-03-04',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-03 21:33:32','2020-02-03 21:40:09',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-04','2020-02-04',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(168,1,144,1,NULL,'2020-02-04','2020-07-04','02','2020',NULL,'2020-03-04',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-03 22:16:37','2020-02-03 22:20:06',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-04','2020-02-04',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(169,1,145,1,NULL,'2020-02-04','2020-07-04','02','2020',NULL,'2020-03-04',1,1100.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-03 23:21:39','2020-02-03 23:26:18',NULL,'disbursed',1100.0000,1100.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-04','2020-02-04',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(170,1,70,1,NULL,'2020-02-04','2020-07-04','02','2020',NULL,'2020-03-04',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-04 01:48:13','2020-02-04 01:54:28',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-04','2020-02-04',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(171,1,146,1,NULL,'2020-02-04','2020-07-04','02','2020',NULL,'2020-03-04',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-04 04:02:35','2020-02-04 04:05:18',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-04','2020-02-04',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(172,1,147,1,NULL,'2020-02-05','2020-07-05','02','2020',NULL,'2020-03-05',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-04 20:23:43','2020-02-04 20:32:42',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-05','2020-02-05',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(173,1,148,1,NULL,'2019-10-19','2020-03-05','10','2019',NULL,'2019-11-05',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-04 21:02:21','2020-02-05 02:29:01',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-05','2019-10-19',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(174,1,148,1,NULL,'2020-02-05','2020-07-05','02','2020',NULL,'2020-03-05',1,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-04 21:08:02','2020-02-04 21:19:41',NULL,'disbursed',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-05','2020-02-05',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(175,1,89,1,NULL,'2020-02-05','2020-07-05','02','2020',NULL,'2020-03-05',1,80.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-04 22:59:44','2020-02-04 23:09:48',NULL,'disbursed',80.0000,80.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-05','2020-02-05',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(176,1,101,1,NULL,'2020-02-05','2020-07-05','02','2020',NULL,'2020-03-05',1,850.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-05 02:17:55','2020-02-05 02:27:03',NULL,'disbursed',850.0000,850.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-05','2020-02-05',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(177,1,78,1,NULL,'2020-02-05','2020-07-05','02','2020',NULL,'2020-03-05',1,5000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-05 04:32:28','2020-02-05 04:38:43',NULL,'disbursed',5000.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-05','2020-02-05',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(178,1,148,1,NULL,'2020-02-06','2020-07-06','02','2020',NULL,'2020-03-06',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-05 21:44:05','2020-02-05 22:15:08','2020-02-05 22:15:08','pending',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-06','2020-02-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(179,1,149,1,NULL,'2020-02-06','2020-07-06','02','2020',NULL,'2020-03-06',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-06 02:39:38','2020-02-06 02:48:51',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-06','2020-02-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(180,1,150,1,NULL,'2020-02-06','2020-07-06','02','2020',NULL,'2020-03-06',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-06 04:25:15','2020-02-06 04:32:46',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-06','2020-02-06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(181,1,4,1,NULL,'2020-02-07','2021-01-07','02','2020',NULL,'2020-03-07',1,1000.0000,'flat_rate',3.0000,'month',0,0.0000,10,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-07 01:54:05','2020-02-07 01:57:51',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-07','2020-02-07',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(182,1,151,1,NULL,'2020-02-08','2020-07-08','02','2020',NULL,'2020-03-08',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-07 22:39:23','2020-02-07 22:41:55',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-08','2020-02-08',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(183,1,43,1,NULL,'2020-02-08','2020-07-08','02','2020',NULL,'2020-03-08',1,1800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-07 23:32:46','2020-02-07 23:45:28',NULL,'disbursed',1800.0000,1800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-08','2020-02-08',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(184,1,24,1,NULL,'2020-02-10','2020-07-10','02','2020',NULL,'2020-03-10',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-09 21:00:14','2020-02-09 21:10:32',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10','2020-02-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(185,1,28,1,NULL,'2020-02-10','2020-07-10','02','2020',NULL,'2020-03-10',1,4000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-09 21:48:21','2020-02-09 21:56:48',NULL,'disbursed',4000.0000,4000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10','2020-02-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(186,1,152,1,NULL,'2020-02-10','2020-07-10','02','2020',NULL,'2020-03-10',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-09 23:03:40','2020-02-09 23:15:38',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10','2020-02-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(187,1,98,1,NULL,'2020-02-10','2020-07-10','02','2020',NULL,'2020-03-10',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-09 23:52:40','2020-02-09 23:55:31',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10','2020-02-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(188,1,153,1,NULL,'2020-02-10','2020-07-10','02','2020',NULL,'2020-03-10',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 03:14:04','2020-02-10 03:24:39',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10','2020-02-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(189,1,27,1,NULL,'2020-02-10','2020-07-10','02','2020',NULL,'2020-03-10',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 03:40:20','2020-02-10 03:47:37',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10','2020-02-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(190,1,88,1,NULL,'2020-02-10','2020-07-10','02','2020',NULL,'2020-03-10',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 03:57:17','2020-02-10 03:59:45',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10','2020-02-10',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(191,1,24,1,NULL,'2020-02-10','2020-03-10','02','2020',NULL,'2020-01-10',NULL,300.0000,'interest_only',3.0000,'month',0,0.0000,2,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 04:12:39','2020-02-10 04:25:09','2020-02-10 04:25:09','disbursed',300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(192,1,24,1,NULL,'2019-10-18','2020-03-10','10','2019',NULL,'2019-11-10',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 04:27:53','2020-02-10 04:30:33',NULL,'rescheduled',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10','2019-10-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(193,1,24,1,NULL,'2020-02-10','2020-03-10','02','2020',NULL,'2020-01-10',NULL,700.0000,'interest_only',3.0000,'month',0,0.0000,2,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 04:30:33','2020-02-10 04:32:10',NULL,'rescheduled',700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(194,1,24,1,NULL,'2020-02-10','2020-03-10','02','2020',NULL,'2020-02-10',NULL,500.0000,'interest_only',3.0000,'month',0,0.0000,1,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 04:32:10','2020-02-10 04:33:06',NULL,'closed',500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-10',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(195,1,154,1,NULL,'2020-02-11','2020-07-11','02','2020',NULL,'2020-03-11',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 21:39:40','2020-02-10 21:42:24',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-11','2020-02-11',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(196,1,155,1,NULL,'2020-02-11','2020-07-11','02','2020',NULL,'2020-03-11',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 22:07:24','2020-02-10 22:11:29',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-11','2020-02-11',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(197,1,7,1,NULL,'2020-02-11','2020-07-11','02','2020',NULL,'2020-03-11',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-10 22:43:19','2020-02-10 22:52:40',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-11','2020-02-11',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(198,1,157,1,NULL,'2020-02-11','2020-07-11','02','2020',NULL,'2020-03-11',1,5000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-11 02:08:19','2020-02-11 02:20:54',NULL,'disbursed',5000.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-11','2020-02-11',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(199,1,158,1,NULL,'2020-02-12','2020-07-12','02','2020',NULL,'2020-03-12',1,200.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-11 21:45:04','2020-03-02 03:47:52',NULL,'closed',200.0000,200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-12','2020-02-12',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(200,1,159,1,NULL,'2020-02-13','2020-07-13','02','2020',NULL,'2020-03-13',1,200.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-12 22:04:47','2020-02-12 22:22:41',NULL,'disbursed',200.0000,200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-13','2020-02-13',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(201,1,160,1,NULL,'2020-02-13','2020-07-13','02','2020',NULL,'2020-03-13',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-13 01:51:00','2020-02-13 02:02:48',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-13','2020-02-13',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(202,1,161,1,NULL,'2020-02-13','2020-07-13','02','2020',NULL,'2020-03-13',1,5000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-13 02:38:21','2020-02-13 02:44:28',NULL,'disbursed',5000.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-13','2020-02-13',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(203,1,162,1,NULL,'2020-02-13','2020-07-13','02','2020',NULL,'2020-03-13',1,7000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-13 03:10:56','2020-02-13 03:29:46',NULL,'disbursed',7000.0000,7000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-13','2020-02-13',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(204,1,163,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-13 21:24:04','2020-02-13 21:40:12',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(205,1,73,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,25000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-13 22:59:54','2020-02-13 23:09:58',NULL,'disbursed',25000.0000,25000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,9,9,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(206,1,8,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,1300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-13 23:33:05','2020-02-13 23:44:25',NULL,'disbursed',1300.0000,1300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(207,1,91,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,610.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-13 23:49:49','2020-02-13 23:54:27',NULL,'disbursed',610.0000,610.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(208,1,164,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,200.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 02:21:56','2020-02-14 02:30:36',NULL,'disbursed',200.0000,200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(209,1,165,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,2000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 02:35:17','2020-02-14 02:38:08',NULL,'disbursed',2000.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(210,1,17,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 02:40:51','2020-02-14 02:55:01',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(211,1,102,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 02:56:51','2020-02-14 02:59:46',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(212,1,85,1,NULL,'2020-02-14','2020-07-14','02','2020',NULL,'2020-03-14',1,15000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 04:25:04','2020-02-14 04:28:40',NULL,'disbursed',15000.0000,15000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-14','2020-02-14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(213,1,90,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 20:19:51','2020-02-20 20:42:48',NULL,'closed',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(214,1,90,1,NULL,'2020-02-15','2020-03-15','02','2020',NULL,'2019-12-15',NULL,450.0000,'interest_only',3.0000,'month',0,0.0000,3,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 20:19:58','2020-02-14 20:21:21',NULL,'rescheduled',450.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(215,1,90,1,NULL,'2020-02-15','2020-03-15','02','2020',NULL,'2020-01-15',NULL,400.0000,'interest_only',3.0000,'month',0,0.0000,2,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 20:21:21','2020-02-14 20:24:59',NULL,'rescheduled',400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(216,1,90,1,NULL,'2020-02-15','2020-03-15','02','2020',NULL,'2020-02-15',NULL,350.0000,'interest_only',3.0000,'month',0,0.0000,1,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 20:24:59','2020-02-14 20:25:55',NULL,'closed',350.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(217,1,166,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 21:11:26','2020-02-14 21:16:21',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(218,1,16,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 21:48:26','2020-02-14 21:54:35',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(219,1,71,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 21:57:49','2020-02-14 22:02:35',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(220,1,95,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 22:04:03','2020-02-14 22:07:51',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(221,1,83,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,3000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 22:58:27','2020-02-14 23:03:20',NULL,'disbursed',3000.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(222,1,75,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 23:13:31','2020-02-14 23:17:06',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(223,1,87,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 23:23:43','2020-02-14 23:39:05',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(224,1,97,1,NULL,'2020-02-15','2020-07-15','02','2020',NULL,'2020-03-15',1,5500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-14 23:48:29','2020-02-14 23:56:22',NULL,'disbursed',5500.0000,5500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-15','2020-02-15',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(225,1,167,1,NULL,'2020-02-17','2020-07-15','02','2020',NULL,'2020-03-15',1,4000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-16 21:01:45','2020-02-16 21:03:32',NULL,'disbursed',4000.0000,4000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-17','2020-02-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(226,1,168,1,NULL,'2020-02-17','2020-07-09','02','2020',NULL,'2020-03-09',1,200.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-16 21:37:26','2020-02-16 21:44:22',NULL,'disbursed',200.0000,200.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-17','2020-02-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(227,1,20,1,NULL,'2020-02-17','2020-07-15','02','2020',NULL,'2020-03-15',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-16 22:08:44','2020-02-16 22:11:24',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-17','2020-02-17',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(228,1,169,1,NULL,'2020-02-18','2020-07-06','02','2020',NULL,'2020-03-06',1,800.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-17 20:29:12','2020-02-17 20:32:27',NULL,'disbursed',800.0000,800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-18','2020-02-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(229,1,170,1,NULL,'2020-02-18','2020-07-15','02','2020',NULL,'2020-03-15',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-17 22:31:18','2020-02-17 22:34:58',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-18','2020-02-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(230,1,171,1,NULL,'2020-02-18','2021-06-25','02','2020',NULL,'2020-03-25',1,1500.0000,'interest_only',1.5000,'month',0,0.0000,15,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-18 04:09:32','2020-02-18 04:16:17',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-18','2020-02-18',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,1.5000),(231,1,172,1,NULL,'2020-02-19','2020-07-13','02','2020',NULL,'2020-03-13',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-18 20:56:06','2020-02-18 20:58:13',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-19','2020-02-19',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(232,1,173,1,NULL,'2020-02-20','2020-07-12','02','2020',NULL,'2020-03-12',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-19 23:00:23','2020-02-19 23:03:40',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-20','2020-02-20',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(233,1,174,1,NULL,'2020-02-20','2020-07-11','02','2020',NULL,'2020-03-11',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-20 04:16:39','2020-02-20 04:19:47',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-20','2020-02-20',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(234,1,90,1,NULL,'2020-02-21','2020-07-15','02','2020',NULL,'2020-03-15',1,500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-20 20:52:28','2020-02-20 21:00:27',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-21','2020-02-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(235,1,175,1,NULL,'2020-02-21','2020-07-05','02','2020',NULL,'2020-03-05',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-20 22:49:50','2020-02-20 22:56:09',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-21','2020-02-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(236,1,135,1,NULL,'2020-02-21','2020-07-05','02','2020',NULL,'2020-03-05',1,1100.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-21 02:10:26','2020-02-21 02:28:39',NULL,'disbursed',1100.0000,1100.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-21','2020-02-21',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(237,1,176,1,NULL,'2020-02-22','2020-07-06','02','2020',NULL,'2020-03-06',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-21 21:04:12','2020-02-21 21:09:06',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-22','2020-02-22',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(238,1,177,1,NULL,'2020-02-24','2020-07-12','02','2020',NULL,'2020-03-12',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-23 22:53:35','2020-02-23 23:01:03',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-24','2020-02-24',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(239,1,178,1,NULL,'2020-02-24','2020-07-05','02','2020',NULL,'2020-03-05',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-24 02:52:09','2020-02-24 02:55:18',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-24','2020-02-24',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(240,1,179,1,NULL,'2020-02-24','2020-07-11','02','2020',NULL,'2020-03-11',1,2000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-24 04:12:10','2020-02-24 04:15:19',NULL,'disbursed',2000.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-24','2020-02-24',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(241,1,180,1,NULL,'2020-02-25','2020-07-15','02','2020',NULL,'2020-03-15',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-25 02:24:57','2020-02-25 02:28:27',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-25','2020-02-25',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(242,1,181,1,NULL,'2020-02-25','2020-07-02','02','2020',NULL,'2020-03-02',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-25 03:29:43','2020-02-25 03:42:44',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-25','2020-02-25',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(243,1,142,1,NULL,'2020-02-26','2020-07-03','02','2020',NULL,'2020-04-03',NULL,150.0000,'interest_only',1.5000,'month',0,0.0000,3,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-25 20:26:25','2020-02-25 20:26:25',NULL,'disbursed',150.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-26',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1.5000),(244,1,182,1,NULL,'2020-02-26','2020-07-03','02','2020',NULL,'2020-03-03',1,400.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-25 21:48:59','2020-02-25 21:53:15',NULL,'disbursed',400.0000,400.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-26','2020-02-26',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(245,1,93,1,NULL,'2020-02-27','2020-07-02','02','2020',NULL,'2020-03-02',1,1500.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-26 20:04:06','2020-02-26 20:07:16',NULL,'disbursed',1500.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-27','2020-02-27',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(246,1,183,1,NULL,'2020-02-27','2020-07-03','02','2020',NULL,'2020-03-03',1,600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-27 03:36:54','2020-02-27 03:45:49',NULL,'disbursed',600.0000,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-27','2020-02-27',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(247,1,184,1,NULL,'2020-02-28','2020-07-10','02','2020',NULL,'2020-03-10',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-27 21:30:30','2020-02-27 21:33:45',NULL,'disbursed',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-28','2020-02-28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(248,1,47,1,NULL,'2020-02-29','2020-05-05','02','2020',NULL,'2020-04-05',NULL,500.0000,'interest_only',3.0000,'month',0,0.0000,1,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-02-28 21:48:47','2020-03-01 20:57:14','2020-03-01 20:57:14','disbursed',500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-02-29',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(249,1,109,1,NULL,'2020-03-02','2020-08-02','03','2020',NULL,'2020-04-02',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-01 20:08:15','2022-08-31 12:17:56',NULL,'rescheduled',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02','2020-03-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(250,1,139,1,NULL,'2020-03-02','2020-07-01','03','2020',NULL,'2020-04-01',NULL,4000.0000,'interest_only',3.0000,'month',0,0.0000,3,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-01 20:42:58','2020-03-01 20:42:58',NULL,'disbursed',4000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(251,1,47,1,NULL,'2019-12-23','2020-05-05','12','2019',NULL,'2020-01-05',1,700.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-01 21:04:33','2020-03-01 21:06:46',NULL,'rescheduled',700.0000,700.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02','2019-12-23',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(252,1,47,1,NULL,'2020-03-02','2020-05-05','03','2020',NULL,'2020-04-05',NULL,500.0000,'interest_only',3.0000,'month',0,0.0000,1,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-01 21:06:46','2020-03-01 21:06:46',NULL,'disbursed',500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(253,1,185,1,NULL,'2020-03-02','2020-08-02','03','2020',NULL,'2020-04-02',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-01 22:14:13','2020-03-01 22:18:25',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02','2020-03-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(254,1,100,1,NULL,'2020-03-02','2020-07-03','03','2020',NULL,'2020-04-03',NULL,300.0000,'interest_only',3.0000,'month',0,0.0000,3,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-01 22:19:18','2020-03-01 22:19:18',NULL,'disbursed',300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(255,1,186,1,NULL,'2020-03-02','2020-08-02','03','2020',NULL,'2020-04-02',1,2600.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-01 23:32:33','2020-03-01 23:38:19',NULL,'disbursed',2600.0000,2600.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02','2020-03-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(256,1,187,1,NULL,'2020-03-02','2020-12-02','03','2020',NULL,'2020-04-02',1,500.0000,'interest_only',1.5000,'month',0,0.0000,8,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-02 02:19:28','2020-03-02 02:24:52',NULL,'disbursed',500.0000,500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02','2020-03-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,1.5000),(257,1,96,1,NULL,'2020-03-02','2020-08-02','03','2020',NULL,'2020-04-02',1,300.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-02 02:42:51','2020-03-02 02:45:56',NULL,'disbursed',300.0000,300.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02','2020-03-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(258,1,188,1,NULL,'2020-03-02','2020-08-02','03','2020',NULL,'2020-04-02',1,4000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-02 02:48:56','2020-03-02 02:52:38',NULL,'disbursed',4000.0000,4000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02','2020-03-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,11,3.0000),(259,1,141,1,NULL,'2020-03-02','2020-07-03','03','2020',NULL,'2020-04-03',NULL,2800.0000,'interest_only',3.0000,'month',0,0.0000,3,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-02 02:58:45','2020-03-02 02:58:45',NULL,'disbursed',2800.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000),(260,1,189,1,NULL,'2020-03-02','2020-08-02','03','2020',NULL,'2020-04-02',1,1000.0000,'interest_only',3.0000,'month',0,0.0000,4,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-02 03:37:01','2020-03-02 03:40:56',NULL,'disbursed',1000.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02','2020-03-02',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,10,3.0000),(261,1,109,1,NULL,'2020-03-02','2020-08-02','03','2020',NULL,'2020-05-02',NULL,500.0000,'interest_only',3.0000,'month',0,0.0000,3,'month','monthly','round_off_to_two_decimal',NULL,'distribute_fees_evenly',0,NULL,'a:0:{}',NULL,'open',NULL,0,'2020-03-02 11:19:19','2020-03-02 11:19:19',NULL,'disbursed',500.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-03-02',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3.0000);

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `message_id` int unsigned DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `attach_file` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `to_id` int NOT NULL,
  `from_id` int NOT NULL,
  `read` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `messages`
--


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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_07_02_230147_migration_cartalyst_sentinel',1),(2,'2016_07_23_173157_create_messages_table',1),(3,'2016_07_23_173226_create_sms_table',1),(4,'2016_07_23_173242_create_settings_table',1),(5,'2016_11_05_062734_create_permissions_table',1),(6,'2017_02_23_000640_create_borrowers_table',1),(7,'2017_02_23_002300_create_custom_fields_table',1),(8,'2017_02_23_003720_create_custom_fields_meta_table',1),(9,'2017_03_05_131103_create_loans_table',1),(10,'2017_03_05_132848_create_loans_products_table',1),(11,'2017_03_05_145851_create_loan_disbursed_by_table',1),(12,'2017_03_05_150107_create_loan_repayment_methods_table',1),(13,'2017_03_05_151538_create_loan_status_table',1),(14,'2017_03_08_182936_create_loan_schedules_table',1),(15,'2017_03_19_080840_create_loan_repayments_table',1),(16,'2017_04_02_142753_create_loan_comments_table',1),(17,'2017_04_11_091435_create_payroll_templates_table',1),(18,'2017_04_11_094729_create_payroll_template_meta_table',1),(19,'2017_04_12_004631_create_payroll_table',1),(20,'2017_04_12_004829_create_payroll_meta_table',1),(21,'2017_04_14_083438_create_expenses_table',1),(22,'2017_04_14_083535_create_expense_types_table',1),(23,'2017_04_16_084016_create_other_income_table',1),(24,'2017_04_16_084118_create_other_income_types_table',1),(25,'2017_04_16_094025_create_collateral_types_table',1),(26,'2017_04_16_094131_create_collateral_table',1),(27,'2017_04_18_083800_create_emails_table',1),(28,'2017_04_23_072100_create_loan_fees_table',1),(29,'2017_04_23_073118_create_loan_fees_meta_table',1),(30,'2017_05_04_103559_create_countries_table',1),(31,'2017_07_17_123811_add_login_fields_to_borrowers_table',1),(32,'2017_07_17_124138_add_month_year_to_borrowers_table',1),(33,'2017_07_17_124357_add_fields_to_borrowers_table',1),(34,'2017_07_17_130228_add_v1_1_settings_table',1),(35,'2017_07_23_061641_create_loan_applications_table',1),(36,'2017_07_23_064420_create_audit_trail_table',1),(37,'2017_07_23_120222_add_payment_to_v1_1_settings_table',1),(38,'2017_07_24_063824_create_savings_product_table',1),(39,'2017_07_24_070639_create_savings_table',1),(40,'2017_07_24_071756_create_savings_transactions_table',1),(41,'2017_07_24_073802_create_savings_fees_table',1),(42,'2017_07_27_071556_create_asset_types_table',1),(43,'2017_07_27_071814_create_assets_table',1),(44,'2017_07_27_074421_create_asset_valuations_table',1),(45,'2017_07_27_174045_create_capital_table',1),(46,'2017_08_01_064016_add_status_to_loans_table',1),(47,'2017_08_01_081424_create_guarantor_table',1),(48,'2017_08_07_083717_update_from_v1_0_to_1_1',1),(49,'2017_08_23_205719_add_blacklist_to_borrowers_table',1),(50,'2017_09_02_092303_create_borrower_groups',1),(51,'2017_09_02_092551_create_branches',1),(52,'2017_09_02_094025_add_branches_to_all_tables',1),(53,'2017_09_02_154128_create_borrower_group_members_table',1),(54,'2017_09_02_171328_update_from_v1_1_to_1_2',1),(55,'2017_09_05_075257_add_v12_settings',1),(56,'2017_09_05_082513_add_v12_permissions',1),(57,'2017_09_20_093729_add_client_background_settings',1),(58,'2017_09_20_094221_change_update_url',1),(59,'2017_09_23_133042_create_provision_rates_table',1),(60,'2017_09_23_133535_insert_data_to_provision_rates_table',1),(61,'2017_09_24_091220_create_bank_accounts_table',1),(62,'2017_09_24_091340_add_bank_accounts_to_capital_table',1),(63,'2017_10_13_113742_create_branch_users_table',1),(64,'2017_10_13_121839_add_application_fee_to_loans_table',1),(65,'2017_10_13_161720_add_default_branch',1),(66,'2017_10_13_161930_create_default_branch_and_assign_user',1),(67,'2017_10_13_173431_add_branch_to_schedules',1),(68,'2017_10_13_184930_set_default_branch_for_current_loans',1),(69,'2017_10_14_062601_add_v_1_3_permissions',1),(70,'2017_10_14_063504_update_v_1_3_update_url',1),(71,'2017_10_14_074553_update_to_v_1_3',1),(72,'2017_10_21_203340_create_product_categories_meta_table',1),(73,'2017_11_03_102928_add_type_to_capital_table',1),(74,'2017_11_03_105326_create_sms_gateways_table',1),(75,'2017_11_03_163022_add_name_to_guarantors_table',1),(76,'2017_11_03_164012_add_country_id_to_borrowers_table',1),(77,'2017_11_03_164336_add_currencies_table',1),(78,'2017_11_03_165413_add_ver_1_4_settings_table',1),(79,'2017_11_03_203227_add_loan_guarantors_table',1),(80,'2017_11_04_085909_update_to_ver_1_4_table',1),(81,'2017_11_05_232841_create_products_table',1),(82,'2017_11_05_233251_create_product_categories_table',1),(83,'2017_11_06_072921_create_products_check_in_table',1),(84,'2017_11_06_073248_create_products_check_out_table',1),(85,'2017_11_06_073316_create_products_warehouse_table',1),(86,'2017_11_06_082547_create_purchase_orders_table',1),(87,'2017_11_06_100343_create_suppliers_table',1),(88,'2017_11_06_164523_create_brands_table',1),(89,'2017_11_06_210217_create_products_check_out_items_table',1),(90,'2017_11_06_210317_create_products_payments_table',1),(91,'2017_11_06_210706_create_products_check_in_items_table',1),(92,'2017_11_07_035537_create_purchase_order_items_table',1),(93,'2017_11_07_090146_add_checkout_to_loan_table_table',1),(94,'2017_11_07_091944_add_warehouses_table',1),(95,'2017_11_08_151744_add_overdraw_settings',1),(96,'2017_11_11_071409_create_chart_of_accounts_table',1),(97,'2017_11_11_080928_add_accounting_to_loan_products_table',1),(98,'2017_11_11_094902_create_loan_overdue_penalties_table',1),(99,'2017_11_11_095510_add_accounting_to_savings_products',1),(100,'2017_11_11_100235_add_accounting_to_expenses_table',1),(101,'2017_11_11_100255_add_accounting_to_income_table',1),(102,'2017_11_11_100318_add_accounting_to_payroll_table',1),(103,'2017_11_11_131440_add_v_1_5_permissions',1),(104,'2017_11_11_174146_add_accounting_to_settings_table',1),(105,'2017_11_11_225159_create_journal_entries_table',1),(106,'2017_11_14_082223_add_account_to_expense_and_income_categories',1),(107,'2017_11_18_172024_add_current_theme_to_settings_table',1),(108,'2017_12_02_095438_add_receipt_tp_payments_table',1),(109,'2017_12_03_094335_add_loan_officer_to_loans_table',1),(110,'2017_12_03_185018_add_debit_and_credit_to_capital_table',1),(111,'2017_12_10_161628_add_index_to_all_tables',1),(112,'2017_12_12_144725_create_loan_transactions_table',1),(113,'2017_12_16_202252_create_charges_table',1),(114,'2017_12_16_214117_create_loan_charges_table',1),(115,'2017_12_16_214117_create_savings_charges_table',1),(116,'2017_12_16_214236_create_loan_products_charges_table',1),(117,'2017_12_27_101540_update_journal_entries_table',1),(118,'2018_01_10_104604_add_waive_to_loan_schedules_table',1),(119,'2018_01_14_215823_create_savings_products_charge_table',1),(120,'2018_01_15_000219_add_status_to_savings_table',1),(121,'2018_01_15_083204_add_debit_credit_to_savings_transactions_table',1),(122,'2018_01_26_193838_add_transfer_type_to_saving_transactions',1),(123,'2018_02_01_145506_add_mpesa_to_settings_table',1),(124,'2018_02_01_194418_add_2_0_settings',1),(125,'2018_02_01_201034_increase_decimal_length',1),(126,'2018_02_02_002812_update_system_to_version_2_0',1),(128,'2018_12_23_175846_add_other_income_id_to_journal_entry_table',2),(130,'2018_12_25_101910_add_penalty_column_to_loan_product_charges_table',3),(131,'2019_09_19_150323_add_id_card_number_to_borrowers_table',4),(132,'2019_09_19_155120_add_place_of_birth_to_borrowers_table',4),(133,'2019_09_19_162851_add_color_to_collateral_table',4),(134,'2019_09_19_172814_add_id_card_number_to_guarantor_table',4),(135,'2019_09_20_155640_add_pay_off_interest_rate_table',4),(136,'2019_10_02_153818_add_pay_off_to_loan_schedules_table',4),(137,'2019_10_16_195119_add_owner_date_to_collateral_table',5),(138,'2019_10_23_151522_create_collateral_vehicles_table',5),(139,'2019_11_18_151019_add_max_approval_to_users_table',6),(140,'2014_10_12_100000_create_password_resets_table',7),(141,'2019_12_14_000001_create_personal_access_tokens_table',7);

--
-- Table structure for table `other_income`
--

CREATE TABLE `other_income` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `other_income_type_id` int unsigned DEFAULT NULL,
  `amount` decimal(65,4) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `files` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  `chart_id` int DEFAULT NULL,
  `account_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `other_income_id_index` (`id`),
  KEY `other_income_year_index` (`year`),
  KEY `other_income_month_index` (`month`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `other_income`
--


--
-- Table structure for table `other_income_types`
--

CREATE TABLE `other_income_types` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `account_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `other_income_types`
--

INSERT INTO `other_income_types` VALUES (1,'Penalty',9);

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

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `payroll`
--

CREATE TABLE `payroll` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `payroll_template_id` int unsigned DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `employee_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `business_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `payment_method` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `account_number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `comments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `paid_amount` decimal(65,4) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recurring` tinyint NOT NULL DEFAULT '0',
  `recur_frequency` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '31',
  `recur_start_date` date DEFAULT NULL,
  `recur_end_date` date DEFAULT NULL,
  `recur_next_date` date DEFAULT NULL,
  `recur_type` enum('day','week','month','year') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'month',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  `chart_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payroll_id_index` (`id`),
  KEY `payroll_user_id_index` (`user_id`),
  KEY `payroll_year_index` (`year`),
  KEY `payroll_month_index` (`month`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `payroll`
--


--
-- Table structure for table `payroll_meta`
--

CREATE TABLE `payroll_meta` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `payroll_id` int unsigned NOT NULL,
  `payroll_template_meta_id` int unsigned DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `position` enum('top_left','top_right','bottom_left','bottom_right') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'bottom_left',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `payroll_meta`
--


--
-- Table structure for table `payroll_template_meta`
--

CREATE TABLE `payroll_template_meta` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `payroll_template_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `position` enum('top_left','top_right','bottom_left','bottom_right') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'bottom_left',
  `is_default` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `payroll_template_meta`
--


--
-- Table structure for table `payroll_templates`
--

CREATE TABLE `payroll_templates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `picture` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `payroll_templates`
--

INSERT INTO `payroll_templates` VALUES (1,'Default','Default Payroll Template','default_payroll_template');

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

CREATE TABLE `permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `permissions` VALUES (1,0,'Borrowers','borrowers','Access Borrowers Module'),(2,1,'View borrowers','borrowers.view','View borrowers'),(3,1,'Update borrowers','borrowers.update','Update Borrowers'),(4,1,'Delete borrowers','borrowers.delete','Delete borrowers'),(5,1,'Create borrowers','borrowers.create','Add new borrower'),(6,0,'Loans','loans','Access Loans Module'),(7,6,'Create Loans','loans.create','Create Loans'),(9,6,'Update Loans','loans.update','Update Loans'),(10,6,'Delete Loans','loans.delete','Delete Loans'),(11,6,'View Loans','loans.view','View Loans'),(12,6,'Loan Products','loans.products','Manage Loan Products'),(13,6,'Loan Fees','loans.fees','Manage Loan Fees'),(14,6,'Loan Schedule','loans.schedule','Manage loan schedule, including sending loan schedule emails'),(15,0,'Repayments','repayments','View Repayments Module'),(16,15,'View Repayments','repayments.view','View All repayments'),(17,15,'Create Repayments','repayments.create','Add Repayments'),(18,15,'Delete Repayments','repayments.delete','Delete Repayments'),(19,15,'Update Repayments','repayments.update','Update Repayments'),(20,0,'Payroll','payroll','Access Payroll Module'),(21,20,'View Payroll','payroll.view','View Payroll'),(22,20,'Update Payroll','payroll.update','Update Payroll'),(23,20,'Delete Payroll','payroll.delete','Delete Payroll'),(24,20,'Create Payroll','payroll.create','Create Payroll'),(25,0,'Expenses','expenses','Access Expenses Module'),(26,25,'View Expenses','expenses.view','View Expenses'),(27,25,'Create Expenses','expenses.create','Create Expenses'),(28,25,'Update Expenses','expenses.update','Update Expenses'),(29,25,'Delete Expenses','expenses.delete','Delete Expenses'),(30,0,'Other Income','other_income','Access Other Income Module'),(31,30,'View Other Income','other_income.view','View Other income'),(32,30,'Create Other Income','other_income.create','Create other income'),(33,30,'Update Other Income','other_income.update','Update Other Incom'),(34,30,'Delete Other Income','other_income.delete','Delete other income'),(35,0,'Collateral','collateral','Access Collateral Module'),(36,35,'View collateral','collateral.view','View Collateral'),(37,35,'Update Collateral','collateral.update','Update Collateral'),(38,35,'Create Collateral','collateral.create','Create Collateral'),(39,35,'Delete Collateral','collateral.delete','Delete Collateral'),(40,0,'Reports','reports','Access Reports Module'),(41,0,'Communication','communication','Access Communication Module'),(42,41,'Create Communication','communication.create','Send Emails & SMS'),(43,41,'Delete Communication','communication.delete','Delete Communication'),(44,0,'Custom Fields','custom_fields','Access Custom Fields Module'),(45,44,'View Custom Fields','custom_fields.view','View Custom fields'),(46,44,'Create Custom Fields','custom_fields.create','Create Custom Fields'),(47,44,'Custom Fields','custom_fields.update','Update Custom Fields'),(48,44,'Delete Custom Fields','custom_fields.delete','Delete Custom Fields'),(49,0,'Users','users','Access Users Module'),(50,49,'View Users','users.view','View Users '),(51,49,'Create Users','users.create','Create users'),(52,49,'Update Users','users.update','Update Users'),(53,49,'Delete Users','users.delete','Delete Users'),(54,49,'Manage Roles','users.roles','Manage user roles'),(55,0,'Settings','settings','Manage Settings'),(56,0,'Audit Trail','audit_trail','Access Audit Trail'),(57,0,'Savings','savings','Access Savings Menu'),(58,57,'Create Savings','savings.create',''),(59,57,'Update Savings','savings.update',''),(60,57,'Delete Savings','savings.delete',''),(61,57,'Create Savings Transaction','savings.transactions.create',''),(62,57,'Update Savings Transaction','savings.transactions.update',''),(63,57,'Delete Savings Transaction','savings.transactions.delete',''),(64,57,'View Savings','savings.view',''),(65,57,'View Savings Transaction','savings.transactions.view',''),(66,57,'Manage Savings Products','savings.products','Manage Savings Products'),(67,57,'Manage Savings Fees','savings.fees',''),(68,6,'Approve Loans','loans.approve','Approve Loans'),(69,6,'Disburse Loans','loans.disburse','Disburse Loans'),(70,1,'Approve Borrowers','borrowers.approve','Approve Borrowers'),(71,6,'Withdraw Loans','loans.withdraw','Withdraw Loans'),(72,6,'Write Off Loans','loans.writeoff','Write off Loans'),(73,6,'Reschedule Loans','loans.reschedule','Reschedule Loans'),(74,0,'Dashboard','dashboard','Access Dashboard'),(75,74,'Loans Released Monthly Graph','dashboard.loans_released_monthly_graph','Access Loans Released Monthly Graph'),(76,74,'Loans Collected Monthly Graph','dashboard.loans_collected_monthly_graph','Access Loans Collected Monthly Graph'),(77,74,'Registered Borrowers','dashboard.registered_borrowers','Access Registered Borrowers Statistics'),(78,74,'Total Loans Released','dashboard.total_loans_released','Access Total Loans Released'),(79,74,'Total Collections','dashboard.total_collections','Access Total Collections Statistics'),(80,74,'Total Disbursed Loans','dashboard.loans_disbursed','Access Total Disbursed Loans Statistics'),(81,74,'Total Loans Pending','dashboard.loans_pending',''),(82,74,'Loans Approved','dashboard.loans_approved',''),(83,74,'Loans Declined','dashboard.loans_declined',''),(84,74,'Loans Closed','dashboard.loans_closed',''),(85,74,'Loans Withdrawn','dashboard.loans_withdrawn',''),(86,74,'Loans Written Off','dashboard.loans_written_off',''),(87,74,'Loans Rescheduled','dashboard.loans_rescheduled',''),(88,6,'Create Guarantor','loans.guarantor.create',''),(89,6,'Update Guarantor','loans.guarantor.update',''),(90,6,'Delete Guarantor','loans.guarantor.delete',''),(91,6,'Guarantor Savings','loans.guarantor.savings',''),(92,0,'Capital','capital','Access Capital'),(93,92,'View  Capital','capital.view',''),(94,92,'Create Capital','capital.create',''),(95,92,'Update Capital','capital.update',''),(96,92,'Delete Capital','capital.delete',''),(97,0,'Assets','assets','Access Assets Menu'),(98,97,'Create Assets','assets.create',''),(99,97,'View Assets','assets.view',''),(100,97,'Update Assets','assets.update',''),(101,97,'Delete Assets','assets.delete','');

--
-- Table structure for table `persistences`
--

CREATE TABLE `persistences` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `persistences_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=261 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `persistences`
--

INSERT INTO `persistences` VALUES (73,10,'EBKoiwF1QFLeFlxTfettVqviYDSyyR3z','2019-11-13 22:07:11','2019-11-13 22:07:11'),(217,1,'FhGPPyxvnyF4xHmjdcT7EeqaPkh2fb3l','2020-02-10 21:28:03','2020-02-10 21:28:03'),(218,1,'8ga0gghhvOMhMGZXKyBzkAO9gScTdid9','2020-02-10 21:29:00','2020-02-10 21:29:00'),(219,1,'vUMKgQc7ay65IqKYvhN6y6yIkfSPEoC5','2020-02-11 02:23:28','2020-02-11 02:23:28'),(220,1,'yMVeDRMAk2LYRFFthSqo1qt7g8tVqf0R','2020-02-11 02:29:05','2020-02-11 02:29:05'),(221,1,'EQnNSNlG3ikGm8n2dkgpn8qxcUZ70Tox','2020-02-12 22:33:04','2020-02-12 22:33:04'),(222,1,'x8Zys5YlvZVNoE7sTAU97ADhTt5qiFM5','2020-02-13 21:25:37','2020-02-13 21:25:37'),(225,6,'Qo7mwgsAHlOa2VyZjmmBWbhNd0TMirc5','2020-02-13 23:53:59','2020-02-13 23:53:59'),(226,1,'G9TD0iYUF6EiQUQ5jdrhkyqltMBsVW9k','2020-02-15 11:07:56','2020-02-15 11:07:56'),(227,1,'nAiac1ppzJ50AzJnViXoLmOFST3S2i4N','2020-02-16 20:04:49','2020-02-16 20:04:49'),(228,1,'ZKWiWS1jWtj1VKc1PU2kOW2EAwq7oxg2','2020-02-16 20:53:37','2020-02-16 20:53:37'),(229,1,'FkCQ9AUSmO6PTCqvURFskxvrAIqWpaDA','2020-02-16 21:06:29','2020-02-16 21:06:29'),(230,1,'KU3rmbwIugcJohMkUaJFnauQRDJYoocB','2020-02-18 20:09:22','2020-02-18 20:09:22'),(231,1,'01bFaAlDZsxPCmTrcXYQMKJzR69HBTHG','2020-02-19 20:05:27','2020-02-19 20:05:27'),(232,1,'rYKvNsNAl42WgIyH7326nFF0ANk62NL1','2020-02-19 22:48:00','2020-02-19 22:48:00'),(233,1,'DcqdmA69Gn68BP0ZNpm5XLG7suzydqX0','2020-02-20 20:41:18','2020-02-20 20:41:18'),(234,1,'R7Q8dIGCeUOhuoQbAG69YtJVXPWthhkA','2020-02-21 20:54:03','2020-02-21 20:54:03'),(235,1,'6QfZ8YkQzElDpTzEdERau66tmOFnwD7K','2020-02-23 20:15:09','2020-02-23 20:15:09'),(236,1,'9gcIOwRvT1ri3NShyOrUxGSNnTzKUfMr','2020-02-23 20:15:59','2020-02-23 20:15:59'),(237,1,'Oxf0MZqh0hlBBNe1eKS8oG9gkajN2mDU','2020-02-24 19:53:11','2020-02-24 19:53:11'),(238,1,'P1on4HhnyISE3TmA3NzA5SKEcKhAwqx3','2020-02-24 19:53:29','2020-02-24 19:53:29'),(239,1,'UzwixugmMFsCXlGASbbGvz4FKJKAtzCG','2020-02-24 19:53:48','2020-02-24 19:53:48'),(240,1,'pkdRr1o6s0SBw2CTTN7XKUA4EkRCLIqV','2020-02-25 22:39:33','2020-02-25 22:39:33'),(241,1,'u9aB8ilhfBKc7A40uJDMs3v1vKuOJJGm','2020-02-26 19:48:08','2020-02-26 19:48:08'),(242,1,'kxwtsxkt8Sbfpg775uQxOhNcwykcrdji','2020-02-26 19:52:07','2020-02-26 19:52:07'),(243,1,'MaXvuq4e8GWBd7QVIYM6EdgnEvXPDNSz','2020-02-28 20:56:45','2020-02-28 20:56:45'),(244,1,'ozw8L9gDvF9EOHRbxau9zB3oWibreMy9','2020-03-01 19:54:31','2020-03-01 19:54:31'),(245,1,'qI7MXVnnCibXEY67T1ZQJTm9ripW9aqU','2020-03-01 19:55:13','2020-03-01 19:55:13'),(246,1,'b98Cp16Fd26lbfBZezXM1gLkF99CAUXh','2020-03-01 20:27:51','2020-03-01 20:27:51'),(247,1,'4PMYVLxb2tCTil8PknazfDOj3HbA94Nr','2020-03-02 10:05:18','2020-03-02 10:05:18'),(248,1,'EKlJXCuR1UQ64JiZtjhOnxFEz0MKX7SY','2020-03-03 09:49:09','2020-03-03 09:49:09'),(249,1,'Yv4DINqTcfCssEIT6TPfBiK4PfPXHiva','2020-03-10 04:52:23','2020-03-10 04:52:23'),(250,1,'mvXE7hhMup0h9wJLfNNJa9lkuXntWOLI','2020-03-12 22:25:23','2020-03-12 22:25:23'),(251,1,'etQkG7XdOR2QTa8dnmSdbn9INYSXvnlt','2020-05-15 23:27:18','2020-05-15 23:27:18'),(252,1,'ucAhWIfFeXC8nH8QqSHSJxfb2lzublIJ','2020-05-15 23:35:14','2020-05-15 23:35:14'),(253,1,'XQ2zSReqV0cYcJotkv2944oLYsem9cdq','2022-08-31 10:26:13','2022-08-31 10:26:13'),(254,1,'cNpJZokyxLD5IMu7TzH2qYmaIAmLwYzC','2022-08-31 10:32:21','2022-08-31 10:32:21'),(255,1,'BmSjXVLbzwEa0LRzZlkrZ5hSw11n4tZk','2022-08-31 10:39:28','2022-08-31 10:39:28'),(256,1,'ywxyGWMS52zoqPjUT2yedknSKX8dt6OG','2022-08-31 10:44:11','2022-08-31 10:44:11'),(257,1,'w4upmErHQw4NkDxONbpqstFy0dJJyL9D','2022-08-31 10:44:53','2022-08-31 10:44:53'),(258,1,'EnkMODBXev3APYSiWc17ZRDEDHYwbJVh','2022-08-31 10:45:07','2022-08-31 10:45:07'),(259,1,'c0i13J4cvlBRIBuc6LeIgL38rOgNbM9l','2022-08-31 10:45:19','2022-08-31 10:45:19'),(260,1,'Mu3GK8XEWKFRCNvBnn9hj1NeTpjF0jZM','2022-08-31 10:48:57','2022-08-31 10:48:57');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `parent_id` int unsigned NOT NULL DEFAULT '0',
  `name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `slug` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `active` tinyint NOT NULL DEFAULT '1',
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_categories`
--


--
-- Table structure for table `product_categories_meta`
--

CREATE TABLE `product_categories_meta` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `product_category_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_categories_meta`
--


--
-- Table structure for table `product_check_in_items`
--

CREATE TABLE `product_check_in_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_check_in_id` int unsigned DEFAULT NULL,
  `product_id` int unsigned DEFAULT NULL,
  `tax_rate` decimal(65,2) NOT NULL DEFAULT '0.00',
  `qty` decimal(65,2) NOT NULL DEFAULT '0.00',
  `unit_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `tax_total` decimal(65,2) NOT NULL DEFAULT '0.00',
  `total_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_check_in_items_id_index` (`id`),
  KEY `product_check_in_items_product_check_in_id_index` (`product_check_in_id`),
  KEY `product_check_in_items_product_id_index` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_check_in_items`
--


--
-- Table structure for table `product_check_ins`
--

CREATE TABLE `product_check_ins` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `supplier_id` int DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  `warehouse_id` int DEFAULT NULL,
  `amount` decimal(65,2) NOT NULL DEFAULT '0.00',
  `unit_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `qty` decimal(65,2) NOT NULL DEFAULT '0.00',
  `total_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `tax_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `date` date DEFAULT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_check_ins_id_index` (`id`),
  KEY `product_check_ins_supplier_id_index` (`supplier_id`),
  KEY `product_check_ins_warehouse_id_index` (`warehouse_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_check_ins`
--


--
-- Table structure for table `product_check_out_items`
--

CREATE TABLE `product_check_out_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned DEFAULT NULL,
  `product_check_out_id` int unsigned DEFAULT NULL,
  `tax_rate` decimal(65,2) NOT NULL DEFAULT '0.00',
  `qty` decimal(65,2) NOT NULL DEFAULT '0.00',
  `unit_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `tax_total` decimal(65,2) NOT NULL DEFAULT '0.00',
  `total_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_check_out_items_id_index` (`id`),
  KEY `product_check_out_items_product_check_out_id_index` (`product_check_out_id`),
  KEY `product_check_out_items_product_id_index` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_check_out_items`
--


--
-- Table structure for table `product_check_outs`
--

CREATE TABLE `product_check_outs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('cash','loan') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'cash',
  `loan_id` int unsigned DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `borrower_id` int DEFAULT NULL,
  `warehouse_id` int DEFAULT NULL,
  `unit_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(65,2) NOT NULL DEFAULT '0.00',
  `qty` decimal(65,2) NOT NULL DEFAULT '0.00',
  `total_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `tax_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `date` date DEFAULT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_check_outs_id_index` (`id`),
  KEY `product_check_outs_loan_id_index` (`loan_id`),
  KEY `product_check_outs_borrower_id_index` (`borrower_id`),
  KEY `product_check_outs_year_index` (`year`),
  KEY `product_check_outs_month_index` (`month`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_check_outs`
--


--
-- Table structure for table `product_payments`
--

CREATE TABLE `product_payments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `bank_id` int unsigned DEFAULT NULL,
  `product_check_in_id` int unsigned DEFAULT NULL,
  `product_check_out_id` int unsigned DEFAULT NULL,
  `type` enum('debit','credit') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'credit',
  `payment_method_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `receipt` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `payment_slip` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `amount` decimal(65,2) NOT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `date` date NOT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_payments_id_index` (`id`),
  KEY `product_payments_year_index` (`year`),
  KEY `product_payments_month_index` (`month`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_payments`
--


--
-- Table structure for table `product_warehouses`
--

CREATE TABLE `product_warehouses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_warehouses`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `brand_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `code` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `cost_price` decimal(65,2) DEFAULT NULL,
  `selling_price` decimal(65,2) DEFAULT NULL,
  `qty` int unsigned NOT NULL DEFAULT '0',
  `alert_qty` int unsigned NOT NULL DEFAULT '0',
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `picture` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `slug` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `active` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_id_index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `provision_rates`
--

CREATE TABLE `provision_rates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `days` int DEFAULT NULL,
  `rate` double(10,2) NOT NULL DEFAULT '0.00',
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `provision_rates`
--

INSERT INTO `provision_rates` VALUES (1,'Current',0,0.00,NULL),(2,'Especially Mentioned',31,5.00,NULL),(3,'Substandard',61,10.00,NULL),(4,'Doubtful',91,50.00,NULL),(5,'Loss',181,100.00,NULL);

--
-- Table structure for table `purchase_order_items`
--

CREATE TABLE `purchase_order_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int unsigned DEFAULT NULL,
  `product_id` int unsigned DEFAULT NULL,
  `tax_rate` decimal(65,2) NOT NULL DEFAULT '0.00',
  `qty` decimal(65,2) NOT NULL DEFAULT '0.00',
  `qty_received` decimal(65,2) NOT NULL DEFAULT '0.00',
  `unit_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `tax_total` decimal(65,2) NOT NULL DEFAULT '0.00',
  `total_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `purchase_order_items`
--


--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `supplier_id` int DEFAULT NULL,
  `warehouse_id` int DEFAULT NULL,
  `amount` decimal(65,2) NOT NULL DEFAULT '0.00',
  `unit_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `qty` decimal(65,2) NOT NULL DEFAULT '0.00',
  `total_cost` decimal(65,2) NOT NULL DEFAULT '0.00',
  `tax_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `delivery_date` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `purchase_orders`
--


--
-- Table structure for table `reminders`
--

CREATE TABLE `reminders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `reminders`
--

INSERT INTO `reminders` VALUES (1,1,'zuc6V5v7cqGgpU0ZNNSk3AIXNi8xuXHh',0,NULL,'2022-08-31 09:50:50','2022-08-31 09:50:50'),(2,1,'owYA2CQm3EH6IbIzCFs3MYEdCYGpmxMd',0,NULL,'2022-08-31 10:14:22','2022-08-31 10:14:22'),(3,1,'rZRFo3Jh7QiuyqGgS4FsyY5MzNsBL3Vm',0,NULL,'2022-08-31 10:14:29','2022-08-31 10:14:29'),(4,1,'JxgOV2btRHM5DKvENTnWN1ztYDldQ4Zp',0,NULL,'2022-08-31 10:15:12','2022-08-31 10:15:12'),(5,1,'lr3QHAnM276Am6s4PExkBM0lRD9ztjW9',0,NULL,'2022-08-31 10:16:00','2022-08-31 10:16:00'),(6,1,'gqBuzrF8bPZGMss82IrLNzW4cGwaDkqI',0,NULL,'2022-08-31 10:16:09','2022-08-31 10:16:09'),(7,1,'H3txgeLDmpXLxcXGGuIjRgBpL6EgAtW5',0,NULL,'2022-08-31 10:16:46','2022-08-31 10:16:46'),(8,1,'F3cVFLOx8KAUZVgjO1JGAi4uzBknMATl',0,NULL,'2022-08-31 10:16:55','2022-08-31 10:16:55'),(9,1,'JWpCTC8HVkTvbF2ps6SGvhNrPxgD9CRS',0,NULL,'2022-08-31 10:16:59','2022-08-31 10:16:59'),(10,1,'nOXuptHpCvS0NFLpdr7OXZHOb07mra88',0,NULL,'2022-08-31 10:17:14','2022-08-31 10:17:14'),(11,1,'DzDLN601KZInvM61AoJY0UyDz9xVWuYa',0,NULL,'2022-08-31 10:17:20','2022-08-31 10:17:20'),(12,1,'nUXIcWqFT7tYv7mJe3mGKn71ZDir7NAK',0,NULL,'2022-08-31 10:17:26','2022-08-31 10:17:26'),(13,1,'JuLF4jzIE5zc5puGcRaN6ot763uJX6Au',0,NULL,'2022-08-31 10:19:03','2022-08-31 10:19:03'),(14,1,'zOvogWQOSrZgEbMQcnKvxYcwfYn22JBD',0,NULL,'2022-08-31 10:19:13','2022-08-31 10:19:13'),(15,1,'R7plwBcBkkbWiUvDc4U9so44krC4AFr6',0,NULL,'2022-08-31 10:19:32','2022-08-31 10:19:32'),(16,1,'YJoXG4FWzvPqwqYzDWHviqdWNRygRogz',0,NULL,'2022-08-31 10:20:00','2022-08-31 10:20:00'),(17,1,'JjYXYkDREW1CkQ56GRczAk69L6D4I07D',0,NULL,'2022-08-31 10:21:00','2022-08-31 10:21:00'),(18,1,'RRKDTSg0PTGIZ45Adrr0E7VGP7hFQQ9Q',1,'2022-08-31 10:25:07','2022-08-31 10:21:16','2022-08-31 10:25:07'),(19,1,'9AffgiRm750dsPKHZxyRYbobHMMalFHq',1,'2022-08-31 10:26:01','2022-08-31 10:25:33','2022-08-31 10:26:01');

--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `user_id` int unsigned NOT NULL,
  `role_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `role_users`
--

INSERT INTO `role_users` VALUES (1,1,'2018-12-11 04:03:55','2018-12-11 04:03:55'),(6,1,'2019-11-06 23:20:39','2019-11-06 23:20:39'),(7,1,'2019-11-13 21:46:55','2019-11-13 21:46:55'),(8,1,'2019-11-13 21:49:38','2019-11-13 21:49:38'),(9,1,'2019-11-13 21:52:47','2019-11-13 21:52:47'),(10,2,'2019-11-13 21:54:37','2019-11-13 21:54:37'),(11,2,'2019-11-13 21:55:34','2019-11-13 21:55:34');

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

CREATE TABLE `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `permissions` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'admin','Admin','{\"borrowers\":true,\"borrowers.view\":true,\"borrowers.update\":true,\"borrowers.delete\":true,\"borrowers.create\":true,\"borrowers.approve\":true,\"loans\":true,\"loans.create\":true,\"loans.update\":true,\"loans.delete\":true,\"loans.view\":true,\"loans.products\":true,\"loans.fees\":true,\"loans.schedule\":true,\"loans.approve\":true,\"loans.disburse\":true,\"loans.withdraw\":true,\"loans.writeoff\":true,\"loans.reschedule\":true,\"loans.guarantor.create\":true,\"loans.guarantor.update\":true,\"loans.guarantor.delete\":true,\"loans.guarantor.savings\":true,\"repayments\":true,\"repayments.view\":true,\"repayments.create\":true,\"repayments.delete\":true,\"repayments.update\":true,\"payroll\":true,\"payroll.view\":true,\"payroll.update\":true,\"payroll.delete\":true,\"payroll.create\":true,\"expenses\":true,\"expenses.view\":true,\"expenses.create\":true,\"expenses.update\":true,\"expenses.delete\":true,\"other_income\":true,\"other_income.view\":true,\"other_income.create\":true,\"other_income.update\":true,\"other_income.delete\":true,\"collateral\":true,\"collateral.view\":true,\"collateral.update\":true,\"collateral.create\":true,\"collateral.delete\":true,\"reports\":true,\"communication\":true,\"communication.create\":true,\"communication.delete\":true,\"custom_fields\":true,\"custom_fields.view\":true,\"custom_fields.create\":true,\"custom_fields.update\":true,\"custom_fields.delete\":true,\"users\":true,\"users.view\":true,\"users.create\":true,\"users.update\":true,\"users.delete\":true,\"users.roles\":true,\"settings\":true,\"audit_trail\":true,\"savings\":true,\"savings.create\":true,\"savings.update\":true,\"savings.delete\":true,\"savings.transactions.create\":true,\"savings.transactions.update\":true,\"savings.transactions.delete\":true,\"savings.view\":true,\"savings.transactions.view\":true,\"savings.products\":true,\"savings.fees\":true,\"dashboard\":true,\"dashboard.loans_released_monthly_graph\":true,\"dashboard.loans_collected_monthly_graph\":true,\"dashboard.registered_borrowers\":true,\"dashboard.total_loans_released\":true,\"dashboard.total_collections\":true,\"dashboard.loans_disbursed\":true,\"dashboard.loans_pending\":true,\"dashboard.loans_approved\":true,\"dashboard.loans_declined\":true,\"dashboard.loans_closed\":true,\"dashboard.loans_withdrawn\":true,\"dashboard.loans_written_off\":true,\"dashboard.loans_rescheduled\":true,\"capital\":true,\"capital.view\":true,\"capital.create\":true,\"capital.update\":true,\"capital.delete\":true,\"assets\":true,\"assets.create\":true,\"assets.view\":true,\"assets.update\":true,\"assets.delete\":true}',NULL,'2020-01-03 02:38:26'),(2,'co','CO','{\"borrowers.view\":true,\"loans.view\":true,\"loans.schedule\":true,\"repayments.view\":true}','2019-11-06 23:15:08','2019-11-06 23:16:55'),(3,'sub_admin','Sub Admin','{\"borrowers\":true,\"borrowers.view\":true,\"borrowers.update\":true,\"borrowers.delete\":true,\"borrowers.create\":true,\"borrowers.approve\":true,\"loans\":true,\"loans.create\":true,\"loans.update\":true,\"loans.delete\":true,\"loans.view\":true,\"loans.products\":true,\"loans.fees\":true,\"loans.schedule\":true,\"loans.approve\":true,\"loans.disburse\":true,\"loans.withdraw\":true,\"loans.writeoff\":true,\"loans.reschedule\":true,\"loans.guarantor.create\":true,\"loans.guarantor.update\":true,\"loans.guarantor.delete\":true,\"loans.guarantor.savings\":true,\"repayments\":true,\"repayments.view\":true,\"repayments.create\":true,\"repayments.delete\":true,\"repayments.update\":true,\"payroll\":true,\"payroll.view\":true,\"payroll.update\":true,\"payroll.delete\":true,\"payroll.create\":true,\"expenses\":true,\"expenses.view\":true,\"expenses.create\":true,\"expenses.update\":true,\"expenses.delete\":true,\"other_income\":true,\"other_income.view\":true,\"other_income.create\":true,\"other_income.update\":true,\"other_income.delete\":true,\"collateral\":true,\"collateral.view\":true,\"collateral.update\":true,\"collateral.create\":true,\"collateral.delete\":true,\"reports\":true,\"communication\":true,\"communication.create\":true,\"communication.delete\":true,\"custom_fields\":true,\"custom_fields.view\":true,\"custom_fields.create\":true,\"custom_fields.update\":true,\"custom_fields.delete\":true,\"users\":true,\"users.view\":true,\"users.create\":true,\"users.update\":true,\"users.delete\":true,\"users.roles\":true,\"settings\":true,\"audit_trail\":true,\"savings\":true,\"savings.create\":true,\"savings.update\":true,\"savings.delete\":true,\"savings.transactions.create\":true,\"savings.transactions.update\":true,\"savings.transactions.delete\":true,\"savings.view\":true,\"savings.transactions.view\":true,\"savings.products\":true,\"savings.fees\":true,\"dashboard\":true,\"dashboard.loans_released_monthly_graph\":true,\"dashboard.loans_collected_monthly_graph\":true,\"dashboard.registered_borrowers\":true,\"dashboard.total_loans_released\":true,\"dashboard.total_collections\":true,\"dashboard.loans_disbursed\":true,\"dashboard.loans_pending\":true,\"dashboard.loans_approved\":true,\"dashboard.loans_declined\":true,\"dashboard.loans_closed\":true,\"dashboard.loans_withdrawn\":true,\"dashboard.loans_written_off\":true,\"dashboard.loans_rescheduled\":true,\"capital\":true,\"capital.view\":true,\"capital.create\":true,\"capital.update\":true,\"capital.delete\":true,\"assets\":true,\"assets.create\":true,\"assets.view\":true,\"assets.update\":true,\"assets.delete\":true}','2019-11-13 21:39:34','2019-11-13 21:39:35');

--
-- Table structure for table `savings`
--

CREATE TABLE `savings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `borrower_id` int unsigned DEFAULT NULL,
  `savings_product_id` int unsigned DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  `status` enum('active','closed','pending','declined','withdrawn') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'pending',
  `loan_officer_id` int DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `overdraft_limit` decimal(65,4) DEFAULT NULL,
  `approved_date` date DEFAULT NULL,
  `declined_date` date DEFAULT NULL,
  `closed_date` date DEFAULT NULL,
  `approved_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `declined_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `closed_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `savings_id_index` (`id`),
  KEY `savings_borrower_id_index` (`borrower_id`),
  KEY `savings_savings_product_id_index` (`savings_product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `savings`
--


--
-- Table structure for table `savings_charges`
--

CREATE TABLE `savings_charges` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `charge_id` int DEFAULT NULL,
  `savings_id` int DEFAULT NULL,
  `amount` decimal(65,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `savings_charges`
--


--
-- Table structure for table `savings_fees`
--

CREATE TABLE `savings_fees` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `savings_products` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `amount` decimal(10,2) DEFAULT '0.00',
  `fees_posting` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fees_adding` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `new_fee_type` enum('full','pro_rata') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'full',
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `savings_fees`
--


--
-- Table structure for table `savings_product_charges`
--

CREATE TABLE `savings_product_charges` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `charge_id` int DEFAULT NULL,
  `savings_product_id` int DEFAULT NULL,
  `amount` decimal(65,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `grace_period` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `savings_product_charges`
--


--
-- Table structure for table `savings_products`
--

CREATE TABLE `savings_products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `allow_overdraw` tinyint NOT NULL DEFAULT '0',
  `interest_rate` decimal(10,2) DEFAULT NULL,
  `minimum_balance` int DEFAULT '0',
  `interest_posting` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `interest_adding` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `accounting_rule` enum('none','cash_based') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'none',
  `chart_reference_id` int DEFAULT NULL,
  `chart_overdraft_portfolio_id` int DEFAULT NULL,
  `chart_savings_control_id` int DEFAULT NULL,
  `chart_income_interest_id` int DEFAULT NULL,
  `chart_income_fee_id` int DEFAULT NULL,
  `chart_income_penalty_id` int DEFAULT NULL,
  `chart_payable_interest_id` int DEFAULT NULL,
  `chart_receivable_fee_id` int DEFAULT NULL,
  `chart_receivable_penalty_id` int DEFAULT NULL,
  `chart_expense_interest_id` int DEFAULT NULL,
  `chart_expense_written_off_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `savings_products`
--


--
-- Table structure for table `savings_transactions`
--

CREATE TABLE `savings_transactions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `borrower_id` int unsigned DEFAULT NULL,
  `savings_id` int unsigned DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT '0.00',
  `type` enum('deposit','withdrawal','bank_fees','interest','dividend','guarantee','guarantee_restored','fees_payment','transfer_loan','transfer_savings') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `system_interest` tinyint NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `month` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  `receipt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `payment_method_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `debit` decimal(65,4) DEFAULT NULL,
  `credit` decimal(65,4) DEFAULT NULL,
  `balance` decimal(65,4) DEFAULT NULL,
  `reversible` tinyint NOT NULL DEFAULT '0',
  `reversed` tinyint NOT NULL DEFAULT '0',
  `reversal_type` enum('system','user','none') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'none',
  `reference` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `savings_transactions_id_index` (`id`),
  KEY `savings_transactions_borrower_id_index` (`borrower_id`),
  KEY `savings_transactions_savings_id_index` (`savings_id`),
  KEY `savings_transactions_date_index` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `savings_transactions`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `setting_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_setting_key_unique` (`setting_key`)
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'allow_self_registration','0'),(2,'allow_client_login','0'),(3,'welcome_note','Welcome to our company. You can login with your username and password'),(4,'allow_client_apply','0'),(5,'enable_online_payment','0'),(6,'paynow_key',NULL),(7,'paynow_id',NULL),(8,'paypal_enabled','0'),(9,'paynow_enabled','0'),(10,'client_registration_required_fields',''),(11,'client_auto_activate_account','0'),(12,'client_request_guarantor','0'),(13,'auto_post_savings_interest','0'),(14,'update_url','http://webstudio.co.zw/ulm/update'),(15,'client_login_background',''),(16,'stripe_secret_key',NULL),(17,'stripe_publishable_key',NULL),(18,'stripe_enabled','0'),(19,'allow_bank_overdraw','0'),(20,'expenses_chart_id',''),(21,'income_chart_id',''),(22,'payroll_chart_id','11'),(23,'active_theme','limitless'),(24,'mpesa_consumer_key',NULL),(25,'mpesa_consumer_secret',NULL),(26,'mpesa_shortcode',NULL),(27,'mpesa_endpoint','https://sandbox.safaricom.co.ke'),(28,'mpesa_initiator',NULL),(29,'mpesa_enabled','0'),(30,'default_online_payment_method',''),(31,'timezone','Africa/Blantyre'),(32,'auto_download_update','0'),(33,'update_notification',''),(34,'update_last_checked',''),(35,'header_javascript',''),(36,'footer_javascript',''),(37,'company_name','Fast Money Exchange'),(38,'company_address','Poipet'),(39,'company_currency','USD'),(40,'company_website','http://www.fastmoneyexchange.com'),(41,'company_country','36'),(42,'system_version','1.0'),(43,'sms_enabled','0'),(44,'active_sms',NULL),(45,'portal_address','http://www.'),(46,'company_email','fastmoneyexchange@gmail.com'),(47,'currency_symbol','$'),(48,'currency_position','left'),(49,'company_logo','logo.jpg'),(50,'twilio_sid',''),(51,'twilio_token',''),(52,'twilio_phone_number',''),(53,'routesms_host',''),(54,'routesms_username',''),(55,'routesms_password',''),(56,'routesms_port',''),(57,'sms_sender',''),(58,'clickatell_username',''),(59,'clickatell_password',''),(60,'clickatell_api_id',''),(61,'paypal_email',NULL),(62,'currency','USD'),(63,'password_reset_subject','Password reset instructions'),(64,'password_reset_template','Password reset instructions'),(65,'payment_received_sms_template','Dear {borrowerFirstName}, we have received your payment of ${paymentAmount} for loan {loanNumber}. New loan balance:${loanBalance}. Thank you'),(66,'payment_received_email_template','<p>Dear {borrowerFirstName}, we have received your payment of ${paymentAmount} for loan {loanNumber}. New loan balance:${loanBalance}. Thank you</p>'),(67,'payment_received_email_subject','Payment Received'),(68,'payment_email_subject','Payment Receipt'),(69,'payment_email_template','<p>Dear {borrowerFirstName}, find attached receipt of your payment of ${paymentAmount} for loan {loanNumber} on {paymentDate}. New loan balance:${loanBalance}. Thank you</p>'),(70,'borrower_statement_email_subject','Client Statement'),(71,'borrower_statement_email_template','<p>Dear {borrowerFirstName}, find attached statement of your loans with us. Thank you</p>'),(72,'loan_statement_email_subject','Loan Statement'),(73,'loan_statement_email_template','<p>Dear {borrowerFirstName}, find attached loan statement for loan {loanNumber}. Thank you</p>'),(74,'loan_schedule_email_subject','Loan Schedule'),(75,'loan_schedule_email_template','<p>Dear {borrowerFirstName}, find attached loan schedule for loan {loanNumber}. Thank you</p>'),(76,'cron_last_run','2022-08-31 19:27:59'),(77,'auto_apply_penalty','1'),(78,'auto_payment_receipt_sms','0'),(79,'auto_payment_receipt_email','0'),(80,'auto_repayment_sms_reminder','0'),(81,'auto_repayment_email_reminder','0'),(82,'auto_repayment_days','4'),(83,'auto_overdue_repayment_sms_reminder','0'),(84,'auto_overdue_repayment_email_reminder','0'),(85,'auto_overdue_repayment_days','2'),(86,'auto_overdue_loan_sms_reminder','0'),(87,'auto_overdue_loan_email_reminder','0'),(88,'auto_overdue_loan_days','2'),(89,'loan_overdue_email_subject','Loan Overdue'),(90,'loan_overdue_email_template','<p>Dear {borrowerFirstName}, Your loan {loanNumber} is overdue. Please make your payment. Thank you</p>'),(91,'loan_overdue_sms_template','Dear {borrowerFirstName}, Your loan {loanNumber} is overdue. Please make your payment. Thank you'),(92,'loan_payment_reminder_subject','Upcoming Payment Reminder'),(93,'loan_payment_reminder_email_template','<p>Dear {borrowerFirstName},You have an upcoming payment of {paymentAmount} due on {paymentDate} for loan {loanNumber}. Please make your payment. Thank you</p>'),(94,'loan_payment_reminder_sms_template','Dear {borrowerFirstName},You have an upcoming payment of {paymentAmount} due on {paymentDate} for loan {loanNumber}. Please make your payment. Thank you'),(95,'missed_payment_email_subject','Missed Payment'),(96,'missed_payment_email_template','<p>Dear {borrowerFirstName},You missed payment of {paymentAmount} which was due on {paymentDate} for loan {loanNumber}. Please make your payment. Thank you</p>'),(97,'missed_payment_sms_template','Dear {borrowerFirstName},You missed  payment of {paymentAmount} which was due on {paymentDate} for loan {loanNumber}. Please make your payment. Thank you'),(98,'enable_cron','1'),(99,'infobip_username',''),(100,'infobip_password',''),(101,'company_phone','098 690 333 / 097 915 8888');

--
-- Table structure for table `sms`
--

CREATE TABLE `sms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `recipients` int unsigned NOT NULL,
  `send_to` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `gateway` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sms_id_index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sms`
--


--
-- Table structure for table `sms_gateways`
--

CREATE TABLE `sms_gateways` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `from_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `to_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `url` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `msg_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sms_gateways`
--


--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `mobile_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `work_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `suppliers`
--


--
-- Table structure for table `throttle`
--

CREATE TABLE `throttle` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `throttle_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `throttle`
--

INSERT INTO `throttle` VALUES (1,NULL,'global',NULL,'2018-12-18 08:20:04','2018-12-18 08:20:04'),(2,NULL,'ip','::1','2018-12-18 08:20:04','2018-12-18 08:20:04'),(3,1,'user',NULL,'2018-12-18 08:20:04','2018-12-18 08:20:04'),(4,NULL,'global',NULL,'2018-12-19 01:34:51','2018-12-19 01:34:51'),(5,NULL,'ip','::1','2018-12-19 01:34:51','2018-12-19 01:34:51'),(6,1,'user',NULL,'2018-12-19 01:34:51','2018-12-19 01:34:51'),(7,NULL,'global',NULL,'2018-12-20 23:42:49','2018-12-20 23:42:49'),(8,NULL,'ip','::1','2018-12-20 23:42:49','2018-12-20 23:42:49'),(9,1,'user',NULL,'2018-12-20 23:42:49','2018-12-20 23:42:49'),(10,NULL,'global',NULL,'2019-01-01 22:21:57','2019-01-01 22:21:57'),(11,NULL,'ip','::1','2019-01-01 22:21:57','2019-01-01 22:21:57'),(12,1,'user',NULL,'2019-01-01 22:21:57','2019-01-01 22:21:57'),(13,NULL,'global',NULL,'2019-01-01 22:23:45','2019-01-01 22:23:45'),(14,NULL,'ip','::1','2019-01-01 22:23:45','2019-01-01 22:23:45'),(15,1,'user',NULL,'2019-01-01 22:23:45','2019-01-01 22:23:45'),(16,NULL,'global',NULL,'2019-08-30 21:07:40','2019-08-30 21:07:40'),(17,NULL,'ip','::1','2019-08-30 21:07:40','2019-08-30 21:07:40'),(18,1,'user',NULL,'2019-08-30 21:07:40','2019-08-30 21:07:40'),(19,NULL,'global',NULL,'2019-09-11 06:08:25','2019-09-11 06:08:25'),(20,NULL,'ip','::1','2019-09-11 06:08:25','2019-09-11 06:08:25'),(21,1,'user',NULL,'2019-09-11 06:08:25','2019-09-11 06:08:25'),(22,NULL,'global',NULL,'2019-09-11 06:08:33','2019-09-11 06:08:33'),(23,NULL,'ip','::1','2019-09-11 06:08:33','2019-09-11 06:08:33'),(24,1,'user',NULL,'2019-09-11 06:08:33','2019-09-11 06:08:33'),(25,NULL,'global',NULL,'2019-09-11 06:08:42','2019-09-11 06:08:42'),(26,NULL,'ip','::1','2019-09-11 06:08:42','2019-09-11 06:08:42'),(27,NULL,'global',NULL,'2019-09-11 06:08:48','2019-09-11 06:08:48'),(28,NULL,'ip','::1','2019-09-11 06:08:48','2019-09-11 06:08:48'),(29,NULL,'global',NULL,'2019-09-11 06:09:41','2019-09-11 06:09:41'),(30,NULL,'ip','::1','2019-09-11 06:09:41','2019-09-11 06:09:41'),(31,1,'user',NULL,'2019-09-11 06:09:41','2019-09-11 06:09:41'),(32,NULL,'global',NULL,'2019-09-11 06:09:46','2019-09-11 06:09:46'),(33,NULL,'ip','::1','2019-09-11 06:09:46','2019-09-11 06:09:46'),(34,1,'user',NULL,'2019-09-11 06:09:46','2019-09-11 06:09:46'),(35,NULL,'global',NULL,'2019-09-20 10:55:33','2019-09-20 10:55:33'),(36,NULL,'ip','::1','2019-09-20 10:55:33','2019-09-20 10:55:33'),(37,1,'user',NULL,'2019-09-20 10:55:33','2019-09-20 10:55:33'),(38,NULL,'global',NULL,'2019-10-12 00:18:20','2019-10-12 00:18:20'),(39,NULL,'ip','::1','2019-10-12 00:18:20','2019-10-12 00:18:20'),(40,1,'user',NULL,'2019-10-12 00:18:20','2019-10-12 00:18:20'),(41,NULL,'global',NULL,'2019-10-20 02:51:47','2019-10-20 02:51:47'),(42,NULL,'ip','::1','2019-10-20 02:51:47','2019-10-20 02:51:47'),(43,1,'user',NULL,'2019-10-20 02:51:48','2019-10-20 02:51:48'),(44,NULL,'global',NULL,'2019-10-26 23:37:56','2019-10-26 23:37:56'),(45,NULL,'ip','::1','2019-10-26 23:37:56','2019-10-26 23:37:56'),(46,1,'user',NULL,'2019-10-26 23:37:56','2019-10-26 23:37:56'),(47,NULL,'global',NULL,'2019-10-31 11:10:55','2019-10-31 11:10:55'),(48,NULL,'ip','::1','2019-10-31 11:10:55','2019-10-31 11:10:55'),(49,1,'user',NULL,'2019-10-31 11:10:55','2019-10-31 11:10:55'),(50,NULL,'global',NULL,'2019-10-31 11:11:04','2019-10-31 11:11:04'),(51,NULL,'ip','::1','2019-10-31 11:11:04','2019-10-31 11:11:04'),(52,1,'user',NULL,'2019-10-31 11:11:04','2019-10-31 11:11:04'),(53,NULL,'global',NULL,'2019-11-04 09:25:30','2019-11-04 09:25:30'),(54,NULL,'ip','::1','2019-11-04 09:25:30','2019-11-04 09:25:30'),(55,1,'user',NULL,'2019-11-04 09:25:30','2019-11-04 09:25:30'),(56,NULL,'global',NULL,'2019-11-04 09:26:53','2019-11-04 09:26:53'),(57,NULL,'ip','::1','2019-11-04 09:26:53','2019-11-04 09:26:53'),(58,1,'user',NULL,'2019-11-04 09:26:53','2019-11-04 09:26:53'),(59,NULL,'global',NULL,'2019-11-04 09:27:01','2019-11-04 09:27:01'),(60,NULL,'ip','::1','2019-11-04 09:27:01','2019-11-04 09:27:01'),(61,1,'user',NULL,'2019-11-04 09:27:01','2019-11-04 09:27:01'),(62,NULL,'global',NULL,'2019-11-05 23:15:55','2019-11-05 23:15:55'),(63,NULL,'ip','::1','2019-11-05 23:15:55','2019-11-05 23:15:55'),(64,1,'user',NULL,'2019-11-05 23:15:55','2019-11-05 23:15:55'),(65,NULL,'global',NULL,'2019-11-06 22:41:34','2019-11-06 22:41:34'),(66,NULL,'ip','192.168.0.20','2019-11-06 22:41:34','2019-11-06 22:41:34'),(67,1,'user',NULL,'2019-11-06 22:41:34','2019-11-06 22:41:34'),(68,NULL,'global',NULL,'2019-11-07 04:08:37','2019-11-07 04:08:37'),(69,NULL,'ip','192.168.0.105','2019-11-07 04:08:37','2019-11-07 04:08:37'),(70,1,'user',NULL,'2019-11-07 04:08:37','2019-11-07 04:08:37'),(71,NULL,'global',NULL,'2019-11-07 04:48:03','2019-11-07 04:48:03'),(72,NULL,'ip','192.168.1.24','2019-11-07 04:48:03','2019-11-07 04:48:03'),(73,1,'user',NULL,'2019-11-07 04:48:03','2019-11-07 04:48:03'),(74,NULL,'global',NULL,'2019-11-07 04:51:48','2019-11-07 04:51:48'),(75,NULL,'ip','192.168.1.27','2019-11-07 04:51:48','2019-11-07 04:51:48'),(76,NULL,'global',NULL,'2019-11-07 04:51:57','2019-11-07 04:51:57'),(77,NULL,'ip','192.168.1.27','2019-11-07 04:51:57','2019-11-07 04:51:57'),(78,NULL,'global',NULL,'2019-11-07 05:00:14','2019-11-07 05:00:14'),(79,NULL,'ip','192.168.1.27','2019-11-07 05:00:14','2019-11-07 05:00:14'),(80,1,'user',NULL,'2019-11-07 05:00:14','2019-11-07 05:00:14'),(81,NULL,'global',NULL,'2019-11-07 05:00:21','2019-11-07 05:00:21'),(82,NULL,'ip','192.168.1.27','2019-11-07 05:00:21','2019-11-07 05:00:21'),(83,1,'user',NULL,'2019-11-07 05:00:21','2019-11-07 05:00:21'),(84,NULL,'global',NULL,'2019-11-07 05:00:48','2019-11-07 05:00:48'),(85,NULL,'ip','192.168.1.27','2019-11-07 05:00:48','2019-11-07 05:00:48'),(86,NULL,'global',NULL,'2019-11-07 05:00:59','2019-11-07 05:00:59'),(87,NULL,'ip','192.168.1.27','2019-11-07 05:00:59','2019-11-07 05:00:59'),(88,NULL,'global',NULL,'2019-11-07 22:11:01','2019-11-07 22:11:01'),(89,NULL,'ip','192.168.1.40','2019-11-07 22:11:01','2019-11-07 22:11:01'),(90,1,'user',NULL,'2019-11-07 22:11:01','2019-11-07 22:11:01'),(91,NULL,'global',NULL,'2019-11-07 22:11:10','2019-11-07 22:11:10'),(92,NULL,'ip','192.168.1.40','2019-11-07 22:11:10','2019-11-07 22:11:10'),(93,1,'user',NULL,'2019-11-07 22:11:10','2019-11-07 22:11:10'),(94,NULL,'global',NULL,'2019-11-07 22:24:30','2019-11-07 22:24:30'),(95,NULL,'ip','192.168.1.115','2019-11-07 22:24:30','2019-11-07 22:24:30'),(96,1,'user',NULL,'2019-11-07 22:24:30','2019-11-07 22:24:30'),(97,NULL,'global',NULL,'2019-11-07 22:24:36','2019-11-07 22:24:36'),(98,NULL,'ip','192.168.1.115','2019-11-07 22:24:36','2019-11-07 22:24:36'),(99,1,'user',NULL,'2019-11-07 22:24:36','2019-11-07 22:24:36'),(100,NULL,'global',NULL,'2019-11-07 22:24:56','2019-11-07 22:24:56'),(101,NULL,'ip','192.168.1.115','2019-11-07 22:24:56','2019-11-07 22:24:56'),(102,1,'user',NULL,'2019-11-07 22:24:56','2019-11-07 22:24:56'),(103,NULL,'global',NULL,'2019-11-13 20:45:12','2019-11-13 20:45:12'),(104,NULL,'ip','192.168.1.53','2019-11-13 20:45:12','2019-11-13 20:45:12'),(105,NULL,'global',NULL,'2019-11-13 21:57:53','2019-11-13 21:57:53'),(106,NULL,'ip','192.168.1.40','2019-11-13 21:57:53','2019-11-13 21:57:53'),(107,NULL,'global',NULL,'2019-11-20 20:58:55','2019-11-20 20:58:55'),(108,NULL,'ip','192.168.2.87','2019-11-20 20:58:55','2019-11-20 20:58:55'),(109,NULL,'global',NULL,'2019-11-28 23:04:08','2019-11-28 23:04:08'),(110,NULL,'ip','192.168.1.53','2019-11-28 23:04:08','2019-11-28 23:04:08'),(111,NULL,'global',NULL,'2019-11-28 23:04:19','2019-11-28 23:04:19'),(112,NULL,'ip','192.168.1.53','2019-11-28 23:04:19','2019-11-28 23:04:19'),(113,NULL,'global',NULL,'2019-12-02 21:42:02','2019-12-02 21:42:02'),(114,NULL,'ip','192.168.1.53','2019-12-02 21:42:02','2019-12-02 21:42:02'),(115,NULL,'global',NULL,'2019-12-02 21:44:04','2019-12-02 21:44:04'),(116,NULL,'ip','192.168.1.53','2019-12-02 21:44:04','2019-12-02 21:44:04'),(117,NULL,'global',NULL,'2019-12-12 09:46:02','2019-12-12 09:46:02'),(118,NULL,'ip','192.168.1.20','2019-12-12 09:46:02','2019-12-12 09:46:02'),(119,1,'user',NULL,'2019-12-12 09:46:02','2019-12-12 09:46:02'),(120,NULL,'global',NULL,'2019-12-13 11:58:01','2019-12-13 11:58:01'),(121,NULL,'ip','192.168.1.20','2019-12-13 11:58:01','2019-12-13 11:58:01'),(122,1,'user',NULL,'2019-12-13 11:58:01','2019-12-13 11:58:01'),(123,NULL,'global',NULL,'2020-01-02 10:51:19','2020-01-02 10:51:19'),(124,NULL,'ip','192.168.1.20','2020-01-02 10:51:19','2020-01-02 10:51:19'),(125,1,'user',NULL,'2020-01-02 10:51:19','2020-01-02 10:51:19'),(126,NULL,'global',NULL,'2020-01-03 02:41:56','2020-01-03 02:41:56'),(127,NULL,'ip','192.168.1.115','2020-01-03 02:41:56','2020-01-03 02:41:56'),(128,1,'user',NULL,'2020-01-03 02:41:56','2020-01-03 02:41:56'),(129,NULL,'global',NULL,'2020-01-07 22:50:33','2020-01-07 22:50:33'),(130,NULL,'ip','192.168.2.94','2020-01-07 22:50:34','2020-01-07 22:50:34'),(131,1,'user',NULL,'2020-01-07 22:50:34','2020-01-07 22:50:34'),(132,NULL,'global',NULL,'2020-01-09 22:43:20','2020-01-09 22:43:20'),(133,NULL,'ip','192.168.1.28','2020-01-09 22:43:20','2020-01-09 22:43:20'),(134,1,'user',NULL,'2020-01-09 22:43:20','2020-01-09 22:43:20'),(135,NULL,'global',NULL,'2020-01-14 02:16:42','2020-01-14 02:16:42'),(136,NULL,'ip','192.168.1.28','2020-01-14 02:16:42','2020-01-14 02:16:42'),(137,1,'user',NULL,'2020-01-14 02:16:42','2020-01-14 02:16:42'),(138,NULL,'global',NULL,'2020-01-15 05:30:49','2020-01-15 05:30:49'),(139,NULL,'ip','192.168.1.20','2020-01-15 05:30:49','2020-01-15 05:30:49'),(140,1,'user',NULL,'2020-01-15 05:30:49','2020-01-15 05:30:49'),(141,NULL,'global',NULL,'2020-01-15 22:40:08','2020-01-15 22:40:08'),(142,NULL,'ip','192.168.1.28','2020-01-15 22:40:08','2020-01-15 22:40:08'),(143,1,'user',NULL,'2020-01-15 22:40:08','2020-01-15 22:40:08'),(144,NULL,'global',NULL,'2020-01-19 21:49:11','2020-01-19 21:49:11'),(145,NULL,'ip','192.168.1.28','2020-01-19 21:49:11','2020-01-19 21:49:11'),(146,1,'user',NULL,'2020-01-19 21:49:11','2020-01-19 21:49:11'),(147,NULL,'global',NULL,'2020-01-19 21:49:23','2020-01-19 21:49:23'),(148,NULL,'ip','192.168.1.28','2020-01-19 21:49:23','2020-01-19 21:49:23'),(149,1,'user',NULL,'2020-01-19 21:49:23','2020-01-19 21:49:23'),(150,NULL,'global',NULL,'2020-01-19 21:49:40','2020-01-19 21:49:40'),(151,NULL,'ip','192.168.1.28','2020-01-19 21:49:40','2020-01-19 21:49:40'),(152,1,'user',NULL,'2020-01-19 21:49:40','2020-01-19 21:49:40'),(153,NULL,'global',NULL,'2020-01-27 23:04:57','2020-01-27 23:04:57'),(154,NULL,'ip','192.168.1.28','2020-01-27 23:04:57','2020-01-27 23:04:57'),(155,1,'user',NULL,'2020-01-27 23:04:57','2020-01-27 23:04:57'),(156,NULL,'global',NULL,'2020-01-27 23:32:48','2020-01-27 23:32:48'),(157,NULL,'ip','192.168.1.28','2020-01-27 23:32:48','2020-01-27 23:32:48'),(158,1,'user',NULL,'2020-01-27 23:32:48','2020-01-27 23:32:48'),(159,NULL,'global',NULL,'2020-02-07 21:40:40','2020-02-07 21:40:40'),(160,NULL,'ip','192.168.1.20','2020-02-07 21:40:40','2020-02-07 21:40:40'),(161,6,'user',NULL,'2020-02-07 21:40:40','2020-02-07 21:40:40'),(162,NULL,'global',NULL,'2020-02-09 21:08:57','2020-02-09 21:08:57'),(163,NULL,'ip','192.168.1.28','2020-02-09 21:08:57','2020-02-09 21:08:57'),(164,1,'user',NULL,'2020-02-09 21:08:58','2020-02-09 21:08:58'),(165,NULL,'global',NULL,'2020-02-09 21:09:13','2020-02-09 21:09:13'),(166,NULL,'ip','192.168.1.28','2020-02-09 21:09:13','2020-02-09 21:09:13'),(167,1,'user',NULL,'2020-02-09 21:09:13','2020-02-09 21:09:13'),(168,NULL,'global',NULL,'2020-02-12 22:32:46','2020-02-12 22:32:46'),(169,NULL,'ip','192.168.1.28','2020-02-12 22:32:46','2020-02-12 22:32:46'),(170,1,'user',NULL,'2020-02-12 22:32:46','2020-02-12 22:32:46'),(171,NULL,'global',NULL,'2020-02-13 21:25:28','2020-02-13 21:25:28'),(172,NULL,'ip','192.168.1.28','2020-02-13 21:25:28','2020-02-13 21:25:28'),(173,1,'user',NULL,'2020-02-13 21:25:28','2020-02-13 21:25:28'),(174,NULL,'global',NULL,'2020-02-21 20:53:35','2020-02-21 20:53:35'),(175,NULL,'ip','192.168.1.28','2020-02-21 20:53:35','2020-02-21 20:53:35'),(176,1,'user',NULL,'2020-02-21 20:53:35','2020-02-21 20:53:35'),(177,NULL,'global',NULL,'2020-03-10 04:52:09','2020-03-10 04:52:09'),(178,NULL,'ip','127.0.0.1','2020-03-10 04:52:09','2020-03-10 04:52:09'),(179,NULL,'global',NULL,'2020-03-10 04:52:18','2020-03-10 04:52:18'),(180,NULL,'ip','127.0.0.1','2020-03-10 04:52:18','2020-03-10 04:52:18'),(181,1,'user',NULL,'2020-03-10 04:52:18','2020-03-10 04:52:18'),(182,NULL,'global',NULL,'2020-05-15 22:18:39','2020-05-15 22:18:39'),(183,NULL,'ip','127.0.0.1','2020-05-15 22:18:39','2020-05-15 22:18:39'),(184,NULL,'global',NULL,'2020-05-15 22:18:44','2020-05-15 22:18:44'),(185,NULL,'ip','127.0.0.1','2020-05-15 22:18:44','2020-05-15 22:18:44'),(186,NULL,'global',NULL,'2020-05-15 22:20:46','2020-05-15 22:20:46'),(187,NULL,'ip','127.0.0.1','2020-05-15 22:20:46','2020-05-15 22:20:46'),(188,NULL,'global',NULL,'2020-05-15 22:20:54','2020-05-15 22:20:54'),(189,NULL,'ip','127.0.0.1','2020-05-15 22:20:54','2020-05-15 22:20:54'),(190,NULL,'global',NULL,'2020-05-15 22:21:01','2020-05-15 22:21:01'),(191,NULL,'ip','127.0.0.1','2020-05-15 22:21:01','2020-05-15 22:21:01'),(192,NULL,'global',NULL,'2020-05-15 22:26:52','2020-05-15 22:26:52'),(193,NULL,'ip','127.0.0.1','2020-05-15 22:26:52','2020-05-15 22:26:52'),(194,NULL,'global',NULL,'2020-05-15 22:37:57','2020-05-15 22:37:57'),(195,NULL,'ip','127.0.0.1','2020-05-15 22:37:57','2020-05-15 22:37:57'),(196,NULL,'global',NULL,'2020-05-15 22:38:01','2020-05-15 22:38:01'),(197,NULL,'ip','127.0.0.1','2020-05-15 22:38:01','2020-05-15 22:38:01'),(198,NULL,'global',NULL,'2020-05-15 22:38:05','2020-05-15 22:38:05'),(199,NULL,'ip','127.0.0.1','2020-05-15 22:38:05','2020-05-15 22:38:05'),(200,NULL,'global',NULL,'2020-05-15 22:38:24','2020-05-15 22:38:24'),(201,NULL,'ip','127.0.0.1','2020-05-15 22:38:24','2020-05-15 22:38:24'),(202,NULL,'global',NULL,'2020-05-15 22:39:31','2020-05-15 22:39:31'),(203,NULL,'ip','127.0.0.1','2020-05-15 22:39:31','2020-05-15 22:39:31'),(204,1,'user',NULL,'2020-05-15 22:39:31','2020-05-15 22:39:31'),(205,NULL,'global',NULL,'2022-08-31 09:39:25','2022-08-31 09:39:25'),(206,NULL,'ip','127.0.0.1','2022-08-31 09:39:25','2022-08-31 09:39:25'),(207,NULL,'global',NULL,'2022-08-31 09:40:18','2022-08-31 09:40:18'),(208,NULL,'ip','127.0.0.1','2022-08-31 09:40:18','2022-08-31 09:40:18'),(209,NULL,'global',NULL,'2022-08-31 09:40:25','2022-08-31 09:40:25'),(210,NULL,'ip','127.0.0.1','2022-08-31 09:40:25','2022-08-31 09:40:25'),(211,NULL,'global',NULL,'2022-08-31 09:41:55','2022-08-31 09:41:55'),(212,NULL,'ip','127.0.0.1','2022-08-31 09:41:55','2022-08-31 09:41:55'),(213,NULL,'global',NULL,'2022-08-31 09:43:50','2022-08-31 09:43:50'),(214,NULL,'ip','127.0.0.1','2022-08-31 09:43:50','2022-08-31 09:43:50'),(215,NULL,'global',NULL,'2022-08-31 09:54:33','2022-08-31 09:54:33'),(216,NULL,'ip','127.0.0.1','2022-08-31 09:54:33','2022-08-31 09:54:33'),(217,NULL,'global',NULL,'2022-08-31 09:55:25','2022-08-31 09:55:25'),(218,NULL,'ip','127.0.0.1','2022-08-31 09:55:25','2022-08-31 09:55:25'),(219,NULL,'global',NULL,'2022-08-31 09:55:30','2022-08-31 09:55:30'),(220,NULL,'ip','127.0.0.1','2022-08-31 09:55:30','2022-08-31 09:55:30'),(221,NULL,'global',NULL,'2022-08-31 09:57:13','2022-08-31 09:57:13'),(222,NULL,'ip','127.0.0.1','2022-08-31 09:57:13','2022-08-31 09:57:13'),(223,NULL,'global',NULL,'2022-08-31 09:59:21','2022-08-31 09:59:21'),(224,NULL,'ip','127.0.0.1','2022-08-31 09:59:21','2022-08-31 09:59:21'),(225,NULL,'global',NULL,'2022-08-31 10:32:17','2022-08-31 10:32:17'),(226,NULL,'ip','127.0.0.1','2022-08-31 10:32:17','2022-08-31 10:32:17'),(227,1,'user',NULL,'2022-08-31 10:32:17','2022-08-31 10:32:17');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `permissions` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `last_login` timestamp NULL DEFAULT NULL,
  `first_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `max_approval` decimal(10,4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'admin@gmail.com','$2y$10$I7UoUj34NIJM3zTjjGlbGOSVK94pqrNUBHWsXSbLC7O3DhAtf05X2',NULL,'2022-08-31 10:48:57','Admin','Admin',NULL,NULL,NULL,'Male',NULL,'2018-12-11 04:03:55','2022-08-31 10:48:57',30000.0000),(6,'chanty@gmail.com','$2y$10$9cMMg8daAdbp75RgY2DL0ut.9uFQUN5gyXFXkIvpFzM0n/3y2rEmu',NULL,'2020-02-13 23:53:59','Ouk','Chanty',NULL,'0979158888',NULL,'Male',NULL,'2019-11-06 23:20:39','2020-02-13 23:53:59',5000.0000),(7,'savet@gmail.com','$2y$10$Se971oFDt8eX3/cYMYohpel/BvDDIVPXvuViGPHRPbm0zMrmJMAyO',NULL,'2019-11-13 21:47:21','Savet','MORM',NULL,'017635566',NULL,'Male',NULL,'2019-11-13 21:46:55','2019-11-13 21:47:21',NULL),(8,'sorphorn@gmail.com','$2y$10$Ccq0sPSa5ZuDDUwGymvpCuZSe2PYnDKCCTxZctSKMTbvvwGllcKEe',NULL,'2019-11-15 21:50:12','Sorphorn','Ly',NULL,NULL,NULL,'Female',NULL,'2019-11-13 21:49:38','2019-11-28 23:13:24',5000.0000),(9,'huypheng@gmail.com','$2y$10$cIlzqnwKKk.fbNyZKCCwdOhCDQ7NEM77VIUVnzXaEVer6WVHQxhLG',NULL,'2020-02-13 23:08:39','Tea','Huypheng',NULL,NULL,NULL,'Male',NULL,'2019-11-13 21:52:47','2020-02-13 23:08:39',30000.0000),(10,'kimphun@gmail.com','$2y$10$S.YXOPb5pOdk/MFXf.7ztOFJm175obt55g2cxNv/pi9Jc7WAFnvD.',NULL,'2019-11-13 22:07:11','Nhao','Kimphun',NULL,NULL,NULL,'Male',NULL,'2019-11-13 21:54:37','2019-11-13 22:07:11',NULL),(11,'sokkhuoch@gmail.com','$2y$10$MNCWazW2MBEyFCwp.3HQiO0CcN61z.nTAdRiuVf8otyvRfJNxe2xa',NULL,'2019-11-13 22:02:12','San','Sokkhuoch',NULL,NULL,NULL,'Male',NULL,'2019-11-13 21:55:34','2019-11-13 22:02:12',NULL);

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `warehouses`
--



