One Hat Cyber Team
Your IP :
216.73.216.84
Server IP :
50.6.229.107
Server :
Linux server.hostburly.com 5.14.0-611.38.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 10 17:21:28 EDT 2026 x86_64
Server Software :
Apache
PHP Version :
8.2.30
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
andjemzt
/
www
/
letters
/
Edit File:
nigcomsa_nigcomsatmcs.sql
-- phpMyAdmin SQL Dump -- version 4.9.4 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 04, 2021 at 12:36 PM -- Server version: 5.6.41-84.1 -- PHP Version: 7.3.6 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `nigcomsa_nigcomsatmcs` -- -- -------------------------------------------------------- -- -- Table structure for table `actions` -- CREATE TABLE `actions` ( `id` bigint(20) UNSIGNED NOT NULL, `actions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `process` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL, `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `actions` -- INSERT INTO `actions` (`id`, `actions`, `process`, `created_by`, `created_at`, `updated_at`) VALUES (1, 'View', 'Admin Dashboard Statistics', '1', '2020-06-10 16:20:59', '2020-06-10 16:20:59'), (2, 'Create', 'Admin Dashboard Statistics', '1', '2020-06-10 16:20:59', '2020-06-10 16:20:59'), (3, 'Edit', 'Admin Dashboard Statistics', '1', '2020-06-10 16:20:59', '2020-06-10 16:20:59'), (4, 'Delete', 'Admin Dashboard Statistics', '1', '2020-06-10 16:20:59', '2020-06-10 16:20:59'), (5, 'View', 'Upload Payments', '1', '2020-06-10 16:21:28', '2020-06-10 16:21:28'), (6, 'Create', 'Upload Payments', '1', '2020-06-10 16:21:28', '2020-06-10 16:21:28'), (7, 'Edit', 'Upload Payments', '1', '2020-06-10 16:21:28', '2020-06-10 16:21:28'), (8, 'Delete', 'Upload Payments', '1', '2020-06-10 16:21:28', '2020-06-10 16:21:28'), (9, 'View', 'Loan Request', '1', '2020-06-10 16:22:08', '2020-06-10 16:22:08'), (10, 'Create', 'Loan Request', '1', '2020-06-10 16:22:08', '2020-06-10 16:22:08'), (11, 'Edit', 'Loan Request', '1', '2020-06-10 16:22:08', '2020-06-10 16:22:08'), (12, 'Delete', 'Loan Request', '1', '2020-06-10 16:22:08', '2020-06-10 16:22:08'), (13, 'View', 'Cooperative Payments', '1', '2020-06-10 16:22:45', '2020-06-10 16:22:45'), (14, 'Create', 'Cooperative Payments', '1', '2020-06-10 16:22:45', '2020-06-10 16:22:45'), (15, 'Edit', 'Cooperative Payments', '1', '2020-06-10 16:22:45', '2020-06-10 16:22:45'), (16, 'Delete', 'Cooperative Payments', '1', '2020-06-10 16:22:45', '2020-06-10 16:22:45'), (17, 'View', 'Loan Repayments', '1', '2020-06-10 16:22:57', '2020-06-10 16:22:57'), (18, 'Create', 'Loan Repayments', '1', '2020-06-10 16:22:57', '2020-06-10 16:22:57'), (19, 'Edit', 'Loan Repayments', '1', '2020-06-10 16:22:57', '2020-06-10 16:22:57'), (20, 'Delete', 'Loan Repayments', '1', '2020-06-10 16:22:57', '2020-06-10 16:22:57'), (21, 'View', 'Shop Loan Repayments', '1', '2020-06-10 16:23:19', '2020-06-10 16:23:19'), (22, 'Create', 'Shop Loan Repayments', '1', '2020-06-10 16:23:19', '2020-06-10 16:23:19'), (23, 'Edit', 'Shop Loan Repayments', '1', '2020-06-10 16:23:19', '2020-06-10 16:23:19'), (24, 'Delete', 'Shop Loan Repayments', '1', '2020-06-10 16:23:19', '2020-06-10 16:23:19'), (25, 'View', 'Cooperative Savings', '1', '2020-06-10 16:23:58', '2020-06-10 16:23:58'), (26, 'Create', 'Cooperative Savings', '1', '2020-06-10 16:23:58', '2020-06-10 16:23:58'), (27, 'Edit', 'Cooperative Savings', '1', '2020-06-10 16:23:58', '2020-06-10 16:23:58'), (28, 'Delete', 'Cooperative Savings', '1', '2020-06-10 16:23:58', '2020-06-10 16:23:58'), (29, 'View', 'Loan Reports', '1', '2020-06-10 16:24:10', '2020-06-10 16:24:10'), (30, 'Create', 'Loan Reports', '1', '2020-06-10 16:24:10', '2020-06-10 16:24:10'), (31, 'Edit', 'Loan Reports', '1', '2020-06-10 16:24:10', '2020-06-10 16:24:10'), (32, 'Delete', 'Loan Reports', '1', '2020-06-10 16:24:10', '2020-06-10 16:24:10'), (33, 'View', 'Product Reports', '1', '2020-06-10 16:24:49', '2020-06-10 16:24:49'), (34, 'Create', 'Product Reports', '1', '2020-06-10 16:24:49', '2020-06-10 16:24:49'), (35, 'Edit', 'Product Reports', '1', '2020-06-10 16:24:49', '2020-06-10 16:24:49'), (36, 'Delete', 'Product Reports', '1', '2020-06-10 16:24:49', '2020-06-10 16:24:49'), (37, 'View', 'Manage Users', '1', '2020-06-10 16:25:27', '2020-06-10 16:25:27'), (38, 'Create', 'Manage Users', '1', '2020-06-10 16:25:27', '2020-06-10 16:25:27'), (39, 'Edit', 'Manage Users', '1', '2020-06-10 16:25:27', '2020-06-10 16:25:27'), (40, 'Delete', 'Manage Users', '1', '2020-06-10 16:25:27', '2020-06-10 16:25:27'), (41, 'View', 'Define Loan Types', '1', '2020-06-10 16:25:39', '2020-06-10 16:25:39'), (42, 'Create', 'Define Loan Types', '1', '2020-06-10 16:25:39', '2020-06-10 16:25:39'), (43, 'Edit', 'Define Loan Types', '1', '2020-06-10 16:25:39', '2020-06-10 16:25:39'), (44, 'Delete', 'Define Loan Types', '1', '2020-06-10 16:25:39', '2020-06-10 16:25:39'), (45, 'View', 'Non-Cooperative Account', '1', '2020-06-10 16:25:54', '2020-06-10 16:25:54'), (46, 'Create', 'Non-Cooperative Account', '1', '2020-06-10 16:25:54', '2020-06-10 16:25:54'), (47, 'Edit', 'Non-Cooperative Account', '1', '2020-06-10 16:25:54', '2020-06-10 16:25:54'), (48, 'Delete', 'Non-Cooperative Account', '1', '2020-06-10 16:25:54', '2020-06-10 16:25:54'), (49, 'View', 'Manage Roles', '1', '2020-06-10 16:26:16', '2020-06-10 16:26:16'), (50, 'Create', 'Manage Roles', '1', '2020-06-10 16:26:16', '2020-06-10 16:26:16'), (51, 'Edit', 'Manage Roles', '1', '2020-06-10 16:26:16', '2020-06-10 16:26:16'), (52, 'Delete', 'Manage Roles', '1', '2020-06-10 16:26:16', '2020-06-10 16:26:16'), (53, 'View', 'Manage Actions', '1', '2020-06-10 16:26:35', '2020-06-10 16:26:35'), (54, 'Create', 'Manage Actions', '1', '2020-06-10 16:26:35', '2020-06-10 16:26:35'), (55, 'Edit', 'Manage Actions', '1', '2020-06-10 16:26:35', '2020-06-10 16:26:35'), (56, 'Delete', 'Manage Actions', '1', '2020-06-10 16:26:35', '2020-06-10 16:26:35'), (57, 'View', 'Manage Privileges', '1', '2020-06-10 16:27:33', '2020-06-10 16:27:33'), (58, 'Create', 'Manage Privileges', '1', '2020-06-10 16:27:33', '2020-06-10 16:27:33'), (59, 'Edit', 'Manage Privileges', '1', '2020-06-10 16:27:33', '2020-06-10 16:27:33'), (60, 'Delete', 'Manage Privileges', '1', '2020-06-10 16:27:33', '2020-06-10 16:27:33'), (61, 'View', 'Product Category', '1', '2020-06-10 16:27:48', '2020-06-10 16:27:48'), (62, 'Create', 'Product Category', '1', '2020-06-10 16:27:49', '2020-06-10 16:27:49'), (63, 'Edit', 'Product Category', '1', '2020-06-10 16:27:49', '2020-06-10 16:27:49'), (64, 'Delete', 'Product Category', '1', '2020-06-10 16:27:49', '2020-06-10 16:27:49'), (65, 'View', 'New Stock', '1', '2020-06-10 16:28:00', '2020-06-10 16:28:00'), (66, 'Create', 'New Stock', '1', '2020-06-10 16:28:00', '2020-06-10 16:28:00'), (67, 'Edit', 'New Stock', '1', '2020-06-10 16:28:00', '2020-06-10 16:28:00'), (68, 'Delete', 'New Stock', '1', '2020-06-10 16:28:00', '2020-06-10 16:28:00'), (69, 'View', 'Products', '1', '2020-06-10 16:28:14', '2020-06-10 16:28:14'), (70, 'Create', 'Products', '1', '2020-06-10 16:28:14', '2020-06-10 16:28:14'), (71, 'Edit', 'Products', '1', '2020-06-10 16:28:14', '2020-06-10 16:28:14'), (72, 'Delete', 'Products', '1', '2020-06-10 16:28:14', '2020-06-10 16:28:14'), (73, 'View', 'Shop Sales', '1', '2020-06-10 16:28:25', '2020-06-10 16:28:25'), (74, 'Create', 'Shop Sales', '1', '2020-06-10 16:28:25', '2020-06-10 16:28:25'), (75, 'Edit', 'Shop Sales', '1', '2020-06-10 16:28:25', '2020-06-10 16:28:25'), (76, 'Delete', 'Shop Sales', '1', '2020-06-10 16:28:25', '2020-06-10 16:28:25'), (77, 'View', 'Credit Request', '1', '2020-06-10 16:28:39', '2020-06-10 16:28:39'), (78, 'Create', 'Credit Request', '1', '2020-06-10 16:28:39', '2020-06-10 16:28:39'), (79, 'Edit', 'Credit Request', '1', '2020-06-10 16:28:39', '2020-06-10 16:28:39'), (80, 'Delete', 'Credit Request', '1', '2020-06-10 16:28:39', '2020-06-10 16:28:39'), (81, 'View', 'Admin Cooperative Payments', '1', '2020-06-11 02:10:16', '2020-06-11 02:10:16'), (82, 'Create', 'Admin Cooperative Payments', '1', '2020-06-11 02:10:16', '2020-06-11 02:10:16'), (83, 'Edit', 'Admin Cooperative Payments', '1', '2020-06-11 02:10:16', '2020-06-11 02:10:16'), (84, 'Delete', 'Admin Cooperative Payments', '1', '2020-06-11 02:10:16', '2020-06-11 02:10:16'), (85, 'View', 'Admin Loan Repayments', '1', '2020-06-11 02:10:39', '2020-06-11 02:10:39'), (86, 'Create', 'Admin Loan Repayments', '1', '2020-06-11 02:10:39', '2020-06-11 02:10:39'), (87, 'Edit', 'Admin Loan Repayments', '1', '2020-06-11 02:10:39', '2020-06-11 02:10:39'), (88, 'Delete', 'Admin Loan Repayments', '1', '2020-06-11 02:10:40', '2020-06-11 02:10:40'), (89, 'View', 'Admin Shop Loan Repayments', '1', '2020-06-11 02:11:02', '2020-06-11 02:11:02'), (90, 'Create', 'Admin Shop Loan Repayments', '1', '2020-06-11 02:11:02', '2020-06-11 02:11:02'), (91, 'Edit', 'Admin Shop Loan Repayments', '1', '2020-06-11 02:11:02', '2020-06-11 02:11:02'), (92, 'Delete', 'Admin Shop Loan Repayments', '1', '2020-06-11 02:11:02', '2020-06-11 02:11:02'), (93, 'View', 'Admin Cooperative Savings', '1', '2020-06-11 02:11:30', '2020-06-11 02:11:30'), (94, 'Create', 'Admin Cooperative Savings', '1', '2020-06-11 02:11:30', '2020-06-11 02:11:30'), (95, 'Edit', 'Admin Cooperative Savings', '1', '2020-06-11 02:11:30', '2020-06-11 02:11:30'), (96, 'Delete', 'Admin Cooperative Savings', '1', '2020-06-11 02:11:30', '2020-06-11 02:11:30'), (97, 'View', 'Admin Loan Reports', '1', '2020-06-11 02:12:04', '2020-06-11 02:12:04'), (98, 'Create', 'Admin Loan Reports', '1', '2020-06-11 02:12:04', '2020-06-11 02:12:04'), (99, 'Edit', 'Admin Loan Reports', '1', '2020-06-11 02:12:04', '2020-06-11 02:12:04'), (100, 'Delete', 'Admin Loan Reports', '1', '2020-06-11 02:12:04', '2020-06-11 02:12:04'), (101, 'View', 'Admin Product Request', '1', '2020-06-11 02:12:22', '2020-06-11 02:12:22'), (102, 'Create', 'Admin Product Request', '1', '2020-06-11 02:12:22', '2020-06-11 02:12:22'), (103, 'Edit', 'Admin Product Request', '1', '2020-06-11 02:12:22', '2020-06-11 02:12:22'), (104, 'Delete', 'Admin Product Request', '1', '2020-06-11 02:12:22', '2020-06-11 02:12:22'), (105, 'View', 'Business Loan Repayments', '1', '2020-07-03 03:47:35', '2020-07-03 03:47:35'), (106, 'Create', 'Business Loan Repayments', '1', '2020-07-03 03:47:35', '2020-07-03 03:47:35'), (107, 'Edit', 'Business Loan Repayments', '1', '2020-07-03 03:47:35', '2020-07-03 03:47:35'), (108, 'Delete', 'Business Loan Repayments', '1', '2020-07-03 03:47:35', '2020-07-03 03:47:35'), (109, 'View', 'Admin Business Loan Repayments', '1', '2020-07-03 03:48:20', '2020-07-03 03:48:20'), (110, 'Create', 'Admin Business Loan Repayments', '1', '2020-07-03 03:48:20', '2020-07-03 03:48:20'), (111, 'Edit', 'Admin Business Loan Repayments', '1', '2020-07-03 03:48:20', '2020-07-03 03:48:20'), (112, 'Delete', 'Admin Business Loan Repayments', '1', '2020-07-03 03:48:20', '2020-07-03 03:48:20'), (113, 'View', 'Business Finance Reports', '1', '2020-07-03 03:48:40', '2020-07-03 03:48:40'), (114, 'Create', 'Business Finance Reports', '1', '2020-07-03 03:48:40', '2020-07-03 03:48:40'), (115, 'Edit', 'Business Finance Reports', '1', '2020-07-03 03:48:40', '2020-07-03 03:48:40'), (116, 'Delete', 'Business Finance Reports', '1', '2020-07-03 03:48:40', '2020-07-03 03:48:40'), (117, 'View', 'Admin Business Finance Report', '1', '2020-07-03 03:49:06', '2020-07-03 03:49:06'), (118, 'Create', 'Admin Business Finance Report', '1', '2020-07-03 03:49:06', '2020-07-03 03:49:06'), (119, 'Edit', 'Admin Business Finance Report', '1', '2020-07-03 03:49:06', '2020-07-03 03:49:06'), (120, 'Delete', 'Admin Business Finance Report', '1', '2020-07-03 03:49:06', '2020-07-03 03:49:06'), (121, 'View', 'Generate Variation', '1', '2020-07-03 03:49:59', '2020-07-03 03:49:59'), (122, 'Create', 'Generate Variation', '1', '2020-07-03 03:49:59', '2020-07-03 03:49:59'), (123, 'Edit', 'Generate Variation', '1', '2020-07-03 03:49:59', '2020-07-03 03:49:59'), (124, 'Delete', 'Generate Variation', '1', '2020-07-03 03:49:59', '2020-07-03 03:49:59'), (125, 'View', 'Variation Report', '1', '2020-07-03 03:50:18', '2020-07-03 03:50:18'), (126, 'Create', 'Variation Report', '1', '2020-07-03 03:50:18', '2020-07-03 03:50:18'), (127, 'Edit', 'Variation Report', '1', '2020-07-03 03:50:18', '2020-07-03 03:50:18'), (128, 'Delete', 'Variation Report', '1', '2020-07-03 03:50:18', '2020-07-03 03:50:18'), (129, 'View', 'Savings Withdrawal Report', '1', '2020-07-12 23:44:10', '2020-07-12 23:44:10'), (130, 'Create', 'Savings Withdrawal Report', '1', '2020-07-12 23:44:10', '2020-07-12 23:44:10'), (131, 'Edit', 'Savings Withdrawal Report', '1', '2020-07-12 23:44:10', '2020-07-12 23:44:10'), (132, 'Delete', 'Savings Withdrawal Report', '1', '2020-07-12 23:44:10', '2020-07-12 23:44:10'), (133, 'View', 'Admin Savings Withdrawal Report', '1', '2020-07-12 23:44:46', '2020-07-12 23:44:46'), (134, 'Create', 'Admin Savings Withdrawal Report', '1', '2020-07-12 23:44:46', '2020-07-12 23:44:46'), (135, 'Edit', 'Admin Savings Withdrawal Report', '1', '2020-07-12 23:44:46', '2020-07-12 23:44:46'), (136, 'Delete', 'Admin Savings Withdrawal Report', '1', '2020-07-12 23:44:46', '2020-07-12 23:44:46'), (137, 'View', 'Savings Withdrawal Request', '1', '2020-07-12 23:45:33', '2020-07-12 23:45:33'), (138, 'Create', 'Savings Withdrawal Request', '1', '2020-07-12 23:45:33', '2020-07-12 23:45:33'), (139, 'Edit', 'Savings Withdrawal Request', '1', '2020-07-12 23:45:33', '2020-07-12 23:45:33'), (140, 'Delete', 'Savings Withdrawal Request', '1', '2020-07-12 23:45:33', '2020-07-12 23:45:33'), (141, 'View', 'Manage Withdrawal', '1', '2020-07-12 23:46:40', '2020-07-12 23:46:40'), (142, 'Create', 'Manage Withdrawal', '1', '2020-07-12 23:46:40', '2020-07-12 23:46:40'), (143, 'Edit', 'Manage Withdrawal', '1', '2020-07-12 23:46:40', '2020-07-12 23:46:40'), (144, 'Delete', 'Manage Withdrawal', '1', '2020-07-12 23:46:40', '2020-07-12 23:46:40'); -- -------------------------------------------------------- -- -- Table structure for table `businessrepayment` -- CREATE TABLE `businessrepayment` ( `id` bigint(20) UNSIGNED NOT NULL, `businessid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(11,2) NOT NULL, `month` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `paymentstatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `businessrequest` -- CREATE TABLE `businessrequest` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `business` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL, `requestedamount` decimal(11,2) NOT NULL, `duration` int(11) NOT NULL, `adminpercent` int(11) NOT NULL, `adminfee` decimal(11,2) NOT NULL, `repaymentmethod` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `recipientname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `bankname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accountname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accountnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `otherloans` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `otherloantype` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `principalamount` decimal(11,2) DEFAULT NULL, `monthlyrepayment` decimal(11,2) DEFAULT NULL, `notindebted` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `creditcheckpermit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `loanguideline` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `applicantdeclaration` varchar(5000) COLLATE utf8mb4_unicode_ci NOT NULL, `gurantorname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `guarantorid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payslip1` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payslip2` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payslip3` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comment` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `monthlyamount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `totalrepay` decimal(8,2) NOT NULL, `monthscompleted` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `businessrequest` -- INSERT INTO `businessrequest` (`id`, `name`, `ippisnumber`, `business`, `requestedamount`, `duration`, `adminpercent`, `adminfee`, `repaymentmethod`, `recipientname`, `bankname`, `accountname`, `accountnumber`, `otherloans`, `otherloantype`, `principalamount`, `monthlyrepayment`, `notindebted`, `creditcheckpermit`, `loanguideline`, `applicantdeclaration`, `gurantorname`, `guarantorid`, `payslip1`, `payslip2`, `payslip3`, `status`, `comment`, `monthlyamount`, `totalrepay`, `monthscompleted`, `created_at`, `updated_at`, `updated_by`) VALUES (1, 'IBRAHIM, Mr. MUHAMMED', '20366', 'Legacy Data', 33000.00, 4, 0, 0.00, 'Deduct from Source', 'IBRAHIM, Mr. MUHAMMED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '8250', 8250.00, 1, '2020-08-13 22:38:17', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `cooperativesavings` -- CREATE TABLE `cooperativesavings` ( `id` int(11) NOT NULL, `ippisnumber` varchar(225) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(225) COLLATE utf8_unicode_ci NOT NULL, `amount` decimal(11,2) NOT NULL, `month` varchar(225) COLLATE utf8_unicode_ci NOT NULL, `paymentstatus` varchar(225) COLLATE utf8_unicode_ci NOT NULL, `comment` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, `updated_by` varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cooperativesavings` -- INSERT INTO `cooperativesavings` (`id`, `ippisnumber`, `name`, `amount`, `month`, `paymentstatus`, `comment`, `created_at`, `updated_at`, `updated_by`) VALUES (1, '227075', 'ABDUL-RAHEEM KAZEEM', 200000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (2, '15477', 'ABIOYE, Mr. WAHAB OLUFEMI', 725917.45, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (3, '99513', 'ABODUNRIN, Mr. OLUFUNMILAYO SAMSON', 834485.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (4, '32152', 'ABUBAKAR, Mr. GWANI MUHAMMAD', 583944.36, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (5, '119812', 'ABUBAKAR OKOROGO', 328900.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (6, '15906', 'ADEDUGBE, Mr. ADELOLU ADESANMI', 529820.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (7, '14572', 'Adegoke, Mrs. Oluwafunmilayo Lucia', 1560000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (8, '99573', 'ADEPOJU, Mrs. FALILAT', 234468.40, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (9, '12379', 'ADESHINA ADEGBENGA', 635000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (10, '99474', 'ADIGUN, Mr. OLALEKAN ABIMBOLA', 1000000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (11, '13440', 'AGBADUA, Mr. GODSEND ESHIOFUEZEMHE', 681800.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (12, '15379', 'Agbator, Mr. O Sylvester', 395796.26, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (13, '17439', 'AGBOOLA, Mr. AKINTAYO OLUWATOYIN', 1180620.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (14, '99538', 'AGUN, Mr. AYODELE MICHAEL', 502617.88, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (15, '20116', 'AGYOH, Mr. IORTIM EMMANUEL', 550115.28, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (16, '114031', 'AHMED ADAMS', 80000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (17, '16381', 'AHMED ALHASSAN', 474918.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (18, '13246', 'AJAKAIYE, Mr. BABATUNDE FOLORUNS', 952000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (19, '99509', 'AJALA, Mrs. IBIRONKE', 719500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (20, '134977', 'AKEREDOLU OLUWAFUNKE', 95600.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (21, '99569', 'AKINOLA, Mr. PETER MORAKINYO', 645000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (22, '20028', 'AKINTAYO, Mr. MOSHOOD SHINA', 421325.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (23, '120287', 'ALABELEWE SOLA ABDULRAUF', 185000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (24, '16075', 'ALALE, Ms. ABIMBOLA', 3691320.01, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (25, '14566', 'Alika, Mr. Donald Egiliwe', 916000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (26, '235421', 'ANENIH ABRAHAM', 0.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (27, '153677', 'ANIYE OLABISI BUKOLA', 640000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (28, '12877', 'ASUQUO, Mr. BASSEY NDIFREKE', 150000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (29, '134975', 'AZINI PEACE', 137500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (30, '99478', 'BABALOLA, Mr. SUNDAY KAYODE', 559750.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (31, '16839', 'Babalola, Mrs. Abidemi Onikepo', 1630000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (32, '15620', 'BABATUNDE, Mr. OPE-OLUWA MATTHEW', 765000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (33, '14374', 'BADAMASI, Mr. AMINU', 564000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (34, '17169', 'Bantam, Ms. Ibrahim Aisha', 1749255.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (35, '16078', 'CHEGBEYI, Mr. LUKA', 1210000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (36, '14579', 'DADA CLETUS OTARU', 87500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (37, '15286', 'Daniel, Ms. Avosuahi Deborah', 438304.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (38, '119763', 'DARANIJO BABATUNDE AYODEJI', 342525.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (39, '32135', 'EDUOK NSIKAK EDIDIONG', 690000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (40, '13849', 'Eludiwura, Mr. Benedict Olayemi', 258700.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (41, '17934', 'ELVIS-MADUAGWU UGWUEZI GRACE', 745800.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (42, '16319', 'Emele, Mrs. Nkechi Esther', 1036000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (43, '16005', 'FRANCIS JONATHAN', 307500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (44, '99511', 'GORDON, Ms. ONYEKA UVIE', 2710600.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (45, '20366', 'IBRAHIM, Mr. MUHAMMED', 190626.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (46, '15897', 'IDRIS, Mr. UMAR ADAMU', 1361600.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (47, '12143', 'IKERAVE, Mr. DAVID YANGE-KAR', 125000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (48, '120240', 'JARUMAI PWAACHINO CHRISTINA', 0.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (49, '120269', 'JIMOH NUHU ONUSAGBA', 602820.75, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (50, '31630', 'KAMAL AHMED FOLORUNSHO', 559000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (51, '14922', 'KAREEM, Mr. IDOWU MOSHOOD', 1107480.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (52, '194036', 'KISUMEN NAPAN-DAWURANG', 72500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (53, '14605', 'Kupoluyi, Ms. Olaitan Olukemi', 440000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (54, '13545', 'Kwande, Mr. Danjuma Stephen', 638000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (55, '99483', 'LAWAL, Mr. SALAMI LASISI', 315000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (56, '15082', 'Melaye, Mrs. Amelia Tokunbo', 145000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (57, '101381', 'MEMBERR, IBIYE', 871260.42, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (58, '99482', 'MOHAMMED, Mr. MAZANKWARAI ABDULLAHI', 276470.98, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (59, '15561', 'MOLOGE WARIEBI WILFRED', 685000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (60, '17354', 'MONKOM PEJU UKODUM', 260000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (61, '235323', 'MUSA AISHAT BOLANLE', 412125.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (62, '22737', 'Mustapha, Ms. Hannatu', 445400.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (63, '99579', 'NA\'UZO GALI', 347500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (64, '99681', 'NDIHGIHDAH, Mr. IBRAHIM DANJUMA', 1681202.40, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (65, '16248', 'NGOZI PEACE AGBAEZE', 347500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (66, '15418', 'NZEKWE, Mrs. MAUREEN IFEOMA', 2923550.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (67, '99549', 'OBADARE, Mr. TEMITOPE OLUFEMI', 787500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (68, '27580', 'OBAMILA, Mr. EKUNDAYO JOHNSON', 1103500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (69, '20275', 'Obande, Mr. Jack Sunny', 227600.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (70, '99523', 'OBEKPA MERCY', 340000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (71, '16296', 'OBI-NWAJEI, Ms. PATIENCE FUNMILAYO', 451528.89, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (72, '12082', 'Ode, Mr. Ganiyu', 340197.90, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (73, '13727', 'ODEYEMI, Mr. OLUGBENGA ISAAC', 1635164.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (74, '235071', 'ODOGWU TOCHUKWU REGINALD', 78000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (75, '14670', 'OGODO, Mr. OJO STEPHEN', 910000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (76, '123593', 'OJINIKA CHINYERE SCHOLASTICA', 262821.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (77, '99441', 'OJOH, Mr. THOMPSON CHRISTIAN', 67500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (78, '15978', 'ojo, Mrs. grace oluwabukola', 1086206.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (79, '31777', 'Okogbe, Mr. Ojo Nathaniel', 445000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (80, '31694', 'OKOLI, Ms. SCHOLASTICA UCHECHUKWU', 1072500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (81, '15247', 'OLASEHINDE, Mr. OLADAPO ISAAC', 149300.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (82, '16130', 'OLOPIN, Mr. STEPHEN OLAOLUWA', 680000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (83, '19392', 'OLUFUNKE FAGBEJA', 358645.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (84, '119813', 'OLUWATOYIN ESEBILE OBAJA', 884450.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (85, '15312', 'Onoja Ekpo Lawrence', 87500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (86, '123597', 'OMOLORI FARUK', 317500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (87, '17035', 'OMOTOSHO, Mrs. AJOKE OLUWAYOMI', 650000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (88, '119760', 'ORILOYE OLAYEMI ADETAYO', 318787.50, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (89, '99506', 'OSINUGA, Mrs. DEE-DEE ALHERI', 284000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (90, '15598', 'SALIHU, Mr. BAJEH NUHU', 0.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (91, '224955', 'SALIU MARIAM', 673662.50, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (92, '132765', 'SAMUEL AUDU MICHAEL', 834040.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (93, '99537', 'SANI Mr. BALA UMAR', 90000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (94, '235419', 'SHAIBU ENEUMA SAKA', 325000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (95, '196808', 'SHEHU OTHMAN YAHAYA', 817500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (96, '16288', 'Suleiman, Mr. Adeiza Nurudeen', 598200.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (97, '99508', 'TANIMU, Mr. GIDADO AMINU', 6700000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (98, '25841', 'TSADO, Mr. MAMMAN VICTOR', 240000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (99, '14211', 'UDEVBURE, Mr. UNUIGBE KINGSLEY', 726500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (100, '15281', 'Udoyen, Ms. Ekaete Alma', 1275000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (101, '25676', 'Ugochukwu, Mr. Barry Uchedili', 513776.88, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (102, '13536', 'Ugwuibe, Mrs. Ifeoma Regina', 300831.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (103, '99565', 'UMEH, Mrs. PAMELA NKEM', 3180000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (104, '13418', 'UMOREN, Mr. ETIM MFONISO', 578243.75, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (105, '15318', 'Yakubu, Mr. Nasiru', 60000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (106, '14505', 'YISA MNGUNENGEN MARTHA', 850000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (107, '99510', 'YOOSUF, Mr. OLANIPEKUN TEMITOPE', 1814000.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'), (108, '194022', 'YUSUFU SHEM DAUDU', 413500.00, '2020-06', 'Confirmed', 'Opening Balance as at June, 2020', '2020-08-09 12:15:23', '2020-08-09 12:15:23', '1'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `loanrepayment` -- CREATE TABLE `loanrepayment` ( `id` bigint(20) UNSIGNED NOT NULL, `loanid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(11,2) NOT NULL, `month` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `loantype` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL, `paymentstatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `loanrequest` -- CREATE TABLE `loanrequest` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `loantype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `requestedamount` decimal(11,2) NOT NULL, `duration` int(11) DEFAULT NULL, `adminfee` decimal(11,2) DEFAULT NULL, `repaymentmethod` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `recipientname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bankname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accountname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accountnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `otherloans` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `otherloantype` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `principalamount` decimal(11,2) DEFAULT NULL, `monthlyrepayment` decimal(11,2) DEFAULT NULL, `notindebted` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `creditcheckpermit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `loanguideline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `applicantdeclaration` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gurantorname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `guarantorid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payslip1` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payslip2` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payslip3` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comment` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `monthlyamount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `totalrepay` decimal(8,2) DEFAULT NULL, `monthscompleted` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `loanrequest` -- INSERT INTO `loanrequest` (`id`, `name`, `ippisnumber`, `loantype`, `requestedamount`, `duration`, `adminfee`, `repaymentmethod`, `recipientname`, `bankname`, `accountname`, `accountnumber`, `otherloans`, `otherloantype`, `principalamount`, `monthlyrepayment`, `notindebted`, `creditcheckpermit`, `loanguideline`, `applicantdeclaration`, `gurantorname`, `guarantorid`, `payslip1`, `payslip2`, `payslip3`, `status`, `comment`, `monthlyamount`, `totalrepay`, `monthscompleted`, `created_at`, `updated_at`, `updated_by`) VALUES (1, 'ABIOYE, Mr. WAHAB OLUFEMI', '15477', '2', 1000000.00, 18, 0.00, 'Deduct from Source', 'ABIOYE, Mr. WAHAB OLUFEMI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '55556', 55556.00, 1, '2020-08-13 22:38:17', NULL, NULL), (2, 'ABODUNRIN, Mr. OLUFUNMILAYO SAMSON', '99513', '2', 1050000.00, 10, 0.00, 'Deduct from Source', 'ABODUNRIN, Mr. OLUFUNMILAYO SAMSON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '105000', 630000.00, 6, '2020-08-13 22:38:17', NULL, NULL), (3, 'ABUBAKAR, Mr. GWANI MUHAMMAD', '32152', '2', 500000.00, 10, 0.00, 'Deduct from Source', 'ABUBAKAR, Mr. GWANI MUHAMMAD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '50000', 300000.00, 6, '2020-08-13 22:38:17', NULL, NULL), (4, 'ABUBAKAR OKOROGO', '119812', '2', 450000.00, 10, 0.00, 'Deduct from Source', 'ABUBAKAR OKOROGO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '45000', 315000.00, 7, '2020-08-13 22:38:17', NULL, NULL), (5, 'ABUBAKAR OKOROGO', '119812', '1', 150000.00, 3, 0.00, 'Deduct from Source', 'ABUBAKAR OKOROGO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '50000', 50000.00, 1, '2020-08-13 22:38:17', NULL, NULL), (6, 'ADEPOJU, Mrs. FALILAT', '99573', '2', 150000.00, 10, 0.00, 'Deduct from Source', 'ADEPOJU, Mrs. FALILAT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '15000', 45000.00, 3, '2020-08-13 22:38:17', NULL, NULL), (7, 'ADESHINA ADEGBENGA', '12379', '2', 500000.00, 10, 0.00, 'Deduct from Source', 'ADESHINA ADEGBENGA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '50000', 200000.00, 4, '2020-08-13 22:38:17', NULL, NULL), (8, 'ADIGUN, Mr. OLALEKAN ABIMBOLA', '99474', '2', 1000000.00, 15, 0.00, 'Deduct from Source', 'ADIGUN, Mr. OLALEKAN ABIMBOLA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '66667', 266668.00, 4, '2020-08-13 22:38:17', NULL, NULL), (9, 'AGBADUA, Mr. GODSEND ESHIOFUEZEMHE', '13440', '2', 550000.00, 15, 0.00, 'Deduct from Source', 'AGBADUA, Mr. GODSEND ESHIOFUEZEMHE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '36667', 146668.00, 4, '2020-08-13 22:38:17', NULL, NULL), (10, 'AGBOOLA, Mr. AKINTAYO OLUWATOYIN', '17439', '2', 2000000.00, 10, 0.00, 'Deduct from Source', 'AGBOOLA, Mr. AKINTAYO OLUWATOYIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '200000', 999999.99, 5, '2020-08-13 22:38:17', NULL, NULL), (11, 'AHMED ALHASSAN', '16381', '2', 350000.00, 12, 0.00, 'Deduct from Source', 'AHMED ALHASSAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '29167', 145835.00, 5, '2020-08-13 22:38:17', NULL, NULL), (12, 'AJAKAIYE, Mr. BABATUNDE FOLORUNS', '13246', '2', 1100000.00, 10, 0.00, 'Deduct from Source', 'AJAKAIYE, Mr. BABATUNDE FOLORUNS', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '100000', 500000.00, 5, '2020-08-13 22:38:17', NULL, NULL), (13, 'AJAKAIYE, Mr. BABATUNDE FOLORUNS', '13246', '1', 300000.00, 4, 0.00, 'Deduct from Source', 'AJAKAIYE, Mr. BABATUNDE FOLORUNS', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '75000', 75000.00, 1, '2020-08-13 22:38:17', NULL, NULL), (14, 'AKEREDOLU OLUWAFUNKE', '134977', '2', 350000.00, 15, 0.00, 'Deduct from Source', 'AKEREDOLU OLUWAFUNKE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '23334', 93336.00, 4, '2020-08-13 22:38:17', NULL, NULL), (15, 'ALABELEWE SOLA ABDULRAUF', '120287', '2', 267100.00, 10, 0.00, 'Deduct from Source', 'ALABELEWE SOLA ABDULRAUF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '26710', 133550.00, 5, '2020-08-13 22:38:17', NULL, NULL), (16, 'ALALE, Ms. ABIMBOLA', '16075', '2', 5000000.00, 34, 0.00, 'Deduct from Source', 'ALALE, Ms. ABIMBOLA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '150000', 999999.99, 13, '2020-08-13 22:38:17', NULL, NULL), (17, 'ASUQUO, Mr. BASSEY NDIFREKE', '12877', '1', 20000.00, 1, 0.00, 'Deduct from Source', 'ASUQUO, Mr. BASSEY NDIFREKE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repaid Completely', 'Legacy Data', '20000', 20000.00, 1, '2020-08-13 22:38:17', NULL, NULL), (18, 'AZINI PEACE', '134975', '2', 200000.00, 15, 0.00, 'Deduct from Source', 'AZINI PEACE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '13334', 13334.00, 1, '2020-08-13 22:38:17', NULL, NULL), (19, 'BABALOLA, Mr. SUNDAY KAYODE', '99478', '2', 1500000.00, 18, 0.00, 'Deduct from Source', 'BABALOLA, Mr. SUNDAY KAYODE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '87353', 436765.00, 5, '2020-08-13 22:38:17', NULL, NULL), (20, 'Babalola, Mrs. Abidemi Onikepo', '16839', '2', 1300000.00, 10, 0.00, 'Deduct from Source', 'Babalola, Mrs. Abidemi Onikepo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '130000', 780000.00, 6, '2020-08-13 22:38:17', NULL, NULL), (21, 'BADAMASI, Mr. AMINU', '14374', '2', 450000.00, 18, 0.00, 'Deduct from Source', 'BADAMASI, Mr. AMINU', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '25000', 125000.00, 5, '2020-08-13 22:38:17', NULL, NULL), (22, 'CHEGBEYI, Mr. LUKA', '16078', '2', 1000000.00, 17, 0.00, 'Deduct from Source', 'CHEGBEYI, Mr. LUKA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '60000', 780000.00, 13, '2020-08-13 22:38:17', NULL, NULL), (23, 'DADA CLETUS OTARU', '14579', '2', 200000.00, 10, 0.00, 'Deduct from Source', 'DADA CLETUS OTARU', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '20000', 100000.00, 5, '2020-08-13 22:38:17', NULL, NULL), (24, 'Daniel, Ms. Avosuahi Deborah', '15286', '2', 1000000.00, 15, 0.00, 'Deduct from Source', 'Daniel, Ms. Avosuahi Deborah', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '66667', 266668.00, 4, '2020-08-13 22:38:17', NULL, NULL), (25, 'DARANIJO BABATUNDE AYODEJI', '119763', '2', 500000.00, 12, 0.00, 'Deduct from Source', 'DARANIJO BABATUNDE AYODEJI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '41667', 250002.00, 6, '2020-08-13 22:38:17', NULL, NULL), (26, 'ELVIS-MADUAGWU UGWUEZI GRACE', '17934', '2', 1000000.00, 15, 0.00, 'Deduct from Source', 'ELVIS-MADUAGWU UGWUEZI GRACE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '66667', 200001.00, 3, '2020-08-13 22:38:17', NULL, NULL), (27, 'Emele, Mrs. Nkechi Esther', '16319', '2', 1900000.00, 19, 0.00, 'Deduct from Source', 'Emele, Mrs. Nkechi Esther', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '100000', 900000.00, 9, '2020-08-13 22:38:17', NULL, NULL), (28, 'IBRAHIM, Mr. MUHAMMED', '20366', '2', 220000.00, 12, 0.00, 'Deduct from Source', 'IBRAHIM, Mr. MUHAMMED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '18334', 146672.00, 8, '2020-08-13 22:38:17', NULL, NULL), (29, 'JIMOH NUHU ONUSAGBA', '120269', '2', 1500000.00, 15, 0.00, 'Deduct from Source', 'JIMOH NUHU ONUSAGBA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '100000', 200000.00, 2, '2020-08-13 22:38:17', NULL, NULL), (30, 'KAMAL AHMED FOLORUNSHO', '31630', '2', 960000.00, 12, 0.00, 'Deduct from Source', 'KAMAL AHMED FOLORUNSHO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '80000', 640000.00, 8, '2020-08-13 22:38:17', NULL, NULL), (31, 'KAMAL AHMED FOLORUNSHO', '31630', '1', 200000.00, 3, 0.00, 'Deduct from Source', 'KAMAL AHMED FOLORUNSHO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '66667', 66667.00, 1, '2020-08-13 22:38:17', NULL, NULL), (32, 'KAREEM, Mr. IDOWU MOSHOOD', '14922', '2', 1120000.00, 10, 0.00, 'Deduct from Source', 'KAREEM, Mr. IDOWU MOSHOOD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '112000', 672000.00, 6, '2020-08-13 22:38:17', NULL, NULL), (33, 'KISUMEN NAPAN-DAWURANG', '194036', '2', 220000.00, 18, 0.00, 'Deduct from Source', 'KISUMEN NAPAN-DAWURANG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '12223', 36669.00, 3, '2020-08-13 22:38:17', NULL, NULL), (34, 'KISUMEN NAPAN-DAWURANG', '194036', '1', 140250.00, 5, 0.00, 'Deduct from Source', 'KISUMEN NAPAN-DAWURANG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '28050', 28050.00, 1, '2020-08-13 22:38:17', NULL, NULL), (35, 'MEMBERR, IBIYE', '101381', '2', 1481000.00, 10, 0.00, 'Deduct from Source', 'MEMBERR, IBIYE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '148100', 740500.00, 5, '2020-08-13 22:38:18', NULL, NULL), (36, 'MUSA AISHAT BOLANLE', '235323', '2', 500000.00, 18, 0.00, 'Deduct from Source', 'MUSA AISHAT BOLANLE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '27778', 27778.00, 1, '2020-08-13 22:38:18', NULL, NULL), (37, 'Mustapha, Ms. Hannatu', '22737', '2', 2880000.00, 18, 0.00, 'Deduct from Source', 'Mustapha, Ms. Hannatu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '160000', 320000.00, 2, '2020-08-13 22:38:18', NULL, NULL), (38, 'NDIHGIHDAH, Mr. IBRAHIM DANJUMA', '99681', '2', 1000000.00, 10, 0.00, 'Deduct from Source', 'NDIHGIHDAH, Mr. IBRAHIM DANJUMA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '100000', 500000.00, 5, '2020-08-13 22:38:18', NULL, NULL), (39, 'NGOZI PEACE AGBAEZE', '16248', '2', 600000.00, 18, 0.00, 'Deduct from Source', 'NGOZI PEACE AGBAEZE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '33334', 33334.00, 1, '2020-08-13 22:38:18', NULL, NULL), (40, 'NZEKWE, Mrs. MAUREEN IFEOMA', '15418', '2', 1200000.00, 12, 0.00, 'Deduct from Source', 'NZEKWE, Mrs. MAUREEN IFEOMA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '100000', 700000.00, 7, '2020-08-13 22:38:18', NULL, NULL), (41, 'OBAMILA, Mr. EKUNDAYO JOHNSON', '27580', '2', 1400000.00, 20, 0.00, 'Deduct from Source', 'OBAMILA, Mr. EKUNDAYO JOHNSON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '70000', 700000.00, 10, '2020-08-13 22:38:18', NULL, NULL), (42, 'Obande, Mr. Jack Sunny', '20275', '2', 100000.00, 5, 0.00, 'Deduct from Source', 'Obande, Mr. Jack Sunny', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '20000', 20000.00, 1, '2020-08-13 22:38:18', NULL, NULL), (43, 'Ode, Mr. Ganiyu', '12082', '2', 1020156.50, 11, 0.00, 'Deduct from Source', 'Ode, Mr. Ganiyu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '92648.76', 371615.20, 4, '2020-08-13 22:38:18', NULL, NULL), (44, 'ODEYEMI, Mr. OLUGBENGA ISAAC', '13727', '2', 1260000.00, 18, 0.00, 'Deduct from Source', 'ODEYEMI, Mr. OLUGBENGA ISAAC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '70000', 280000.00, 4, '2020-08-13 22:38:18', NULL, NULL), (45, 'OGODO, Mr. OJO STEPHEN', '14670', '2', 700000.00, 10, 0.00, 'Deduct from Source', 'OGODO, Mr. OJO STEPHEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '70000', 490000.00, 7, '2020-08-13 22:38:18', NULL, NULL), (46, 'OJINIKA CHINYERE SCHOLASTICA', '123593', '2', 120000.00, 10, 0.00, 'Deduct from Source', 'OJINIKA CHINYERE SCHOLASTICA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '12000', 72000.00, 6, '2020-08-13 22:38:18', NULL, NULL), (47, 'ojo, Mrs. grace oluwabukola', '15978', '2', 120000.00, 1, 0.00, 'Deduct from Source', 'ojo, Mrs. grace oluwabukola', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repaid Completely', 'Legacy Data', '120000', 120000.00, 1, '2020-08-13 22:38:18', NULL, NULL), (48, 'Okogbe, Mr. Ojo Nathaniel', '31777', '2', 1898380.00, 20, 0.00, 'Deduct from Source', 'Okogbe, Mr. Ojo Nathaniel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repaid Completely', 'Legacy Data', '94919', 999999.99, 20, '2020-08-13 22:38:18', NULL, NULL), (49, 'Okogbe, Mr. Ojo Nathaniel', '31777', '1', 300000.00, 6, 0.00, 'Deduct from Source', 'Okogbe, Mr. Ojo Nathaniel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repaid Completely', 'Legacy Data', '50000', 300000.00, 6, '2020-08-13 22:38:18', NULL, NULL), (50, 'OSINUGA, Mrs. DEE-DEE ALHERI', '99506', '2', 1500000.00, 10, 0.00, 'Deduct from Source', 'OSINUGA, Mrs. DEE-DEE ALHERI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '150000', 900000.00, 6, '2020-08-13 22:38:18', NULL, NULL), (51, 'SAMUEL AUDU MICHAEL', '132765', '2', 1800000.00, 18, 0.00, 'Deduct from Source', 'SAMUEL AUDU MICHAEL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '100000', 100000.00, 1, '2020-08-13 22:38:18', NULL, NULL), (52, 'SANI Mr. BALA UMAR', '99537', '2', 120000.00, 15, 0.00, 'Deduct from Source', 'SANI Mr. BALA UMAR', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '8000', 16000.00, 2, '2020-08-13 22:38:18', NULL, NULL), (53, 'SHAIBU ENEUMA SAKA', '235419', '2', 500000.00, 10, 0.00, 'Deduct from Source', 'SHAIBU ENEUMA SAKA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '50000', 250000.00, 5, '2020-08-13 22:38:18', NULL, NULL); INSERT INTO `loanrequest` (`id`, `name`, `ippisnumber`, `loantype`, `requestedamount`, `duration`, `adminfee`, `repaymentmethod`, `recipientname`, `bankname`, `accountname`, `accountnumber`, `otherloans`, `otherloantype`, `principalamount`, `monthlyrepayment`, `notindebted`, `creditcheckpermit`, `loanguideline`, `applicantdeclaration`, `gurantorname`, `guarantorid`, `payslip1`, `payslip2`, `payslip3`, `status`, `comment`, `monthlyamount`, `totalrepay`, `monthscompleted`, `created_at`, `updated_at`, `updated_by`) VALUES (54, 'SHEHU OTHMAN YAHAYA', '196808', '2', 750000.00, 10, 0.00, 'Deduct from Source', 'SHEHU OTHMAN YAHAYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '75000', 450000.00, 6, '2020-08-13 22:38:18', NULL, NULL), (55, 'UDEVBURE, Mr. UNUIGBE KINGSLEY', '14211', '2', 642500.00, 10, 0.00, 'Deduct from Source', 'UDEVBURE, Mr. UNUIGBE KINGSLEY', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '64250', 385500.00, 6, '2020-08-13 22:38:18', NULL, NULL), (56, 'UMOREN, Mr. ETIM MFONISO', '13418', '2', 1100000.00, 12, 0.00, 'Deduct from Source', 'UMOREN, Mr. ETIM MFONISO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '91667', 366668.00, 4, '2020-08-13 22:38:18', NULL, NULL), (57, 'Yakubu, Mr. Nasiru', '15318', '2', 80000.00, 10, 0.00, 'Deduct from Source', 'Yakubu, Mr. Nasiru', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '10000', 60000.00, 6, '2020-08-13 22:38:18', NULL, NULL), (58, 'YOOSUF, Mr. OLANIPEKUN TEMITOPE', '99510', '2', 525000.00, 10, 0.00, 'Deduct from Source', 'YOOSUF, Mr. OLANIPEKUN TEMITOPE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I am not indebted to any bank, co-operative society or loan agency, either as a borrower or guarantor, except as stated above', 'I agree to permit the co-operative to carry out a credit check on myself if ther deem it necessary', 'I have read and understood the guidline required for this loan application', 'I declare that the information I have given on this form is to the best of knowledge and belief, accurate and full information. I understand that the provision of false information is fraud and the co-operative society may take appropriate action if I am found to have deliberately provided false or misleading information', NULL, NULL, NULL, NULL, NULL, 'Repayment in Progress', 'Legacy Data', '52500', 315000.00, 6, '2020-08-13 22:38:18', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `loantypes` -- CREATE TABLE `loantypes` ( `id` bigint(20) UNSIGNED NOT NULL, `loantype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `adminfee_per` int(11) DEFAULT NULL, `maximumallowed_per` int(11) DEFAULT NULL, `maximumduration_months` int(11) DEFAULT NULL, `managed_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `loantypes` -- INSERT INTO `loantypes` (`id`, `loantype`, `adminfee_per`, `maximumallowed_per`, `maximumduration_months`, `managed_by`, `created_at`, `updated_at`) VALUES (1, 'Soft Loan', 5, 50, 12, '1', '2020-06-05 15:25:57', NULL), (2, 'Normal Loan', 9, 50, 24, '1', '2020-05-31 12:17:38', NULL); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2020_04_20_192356_loanrequest', 1), (5, '2020_04_20_192846_cooperativesavings', 1), (6, '2020_04_20_193042_loanrepayment', 1), (7, '2020_04_21_123131_loantypes', 1), (8, '2020_04_21_125006_savingsdefined', 1), (9, '2020_04_21_203608_savingswithdrawal', 1), (10, '2020_04_21_213029_productcategory', 1), (11, '2020_04_21_213809_shopproducts', 1), (12, '2020_04_21_213952_newstock', 1), (13, '2020_04_21_214201_shopsales', 1), (14, '2020_04_21_214449_productloanrequest', 1), (15, '2020_04_21_214658_productloanrepay', 1), (16, '2020_04_21_215306_roles', 1), (17, '2020_04_21_215708_roles_actions', 1), (18, '2020_05_17_033604_actions', 1), (19, '2020_05_18_105627_refrees', 1), (20, '2020_05_31_014745_states', 1), (21, '2020_06_03_034621_productrequest', 2); -- -------------------------------------------------------- -- -- Table structure for table `newstock` -- CREATE TABLE `newstock` ( `id` bigint(20) UNSIGNED NOT NULL, `productid` int(11) NOT NULL, `productname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `brand` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `packaging` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `size` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quantity` int(11) NOT NULL, `cashprice` decimal(11,2) NOT NULL, `creditprice` decimal(11,2) NOT NULL, `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `productcategory` -- CREATE TABLE `productcategory` ( `id` bigint(20) UNSIGNED NOT NULL, `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `numberofproducts` int(11) NOT NULL, `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `productloanrepay` -- CREATE TABLE `productloanrepay` ( `id` bigint(20) UNSIGNED NOT NULL, `productloanid` int(11) NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(11,2) NOT NULL, `month` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `paymentstatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `accounttype` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `productloanrequest` -- CREATE TABLE `productloanrequest` ( `id` bigint(20) UNSIGNED NOT NULL, `loanid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `productids` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `productnames` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `quantities` int(11) NOT NULL, `unitprices` decimal(11,2) NOT NULL, `totalprices` decimal(11,2) NOT NULL, `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `productrequest` -- CREATE TABLE `productrequest` ( `id` bigint(20) UNSIGNED NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL, `accounttype` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL, `numberofitems` int(11) NOT NULL, `loanamount` double(11,2) NOT NULL, `nonmemberfee` decimal(11,2) NOT NULL, `payableamount` decimal(11,2) NOT NULL, `duration` int(11) NOT NULL, `monthlyamount` decimal(11,2) NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comments` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `totalrepay` double(11,2) NOT NULL, `monthscompleted` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `productrequest` -- INSERT INTO `productrequest` (`id`, `ippisnumber`, `name`, `accounttype`, `numberofitems`, `loanamount`, `nonmemberfee`, `payableamount`, `duration`, `monthlyamount`, `status`, `comments`, `totalrepay`, `monthscompleted`, `created_at`, `updated_at`) VALUES (1, '119812', 'ABUBAKAR OKOROGO', 'Cooperative Member', 0, 43088.00, 0.00, 43088.00, 2, 21544.00, 'Repayment in Progress', 'Legacy Data', 21544.00, 1, '2020-08-13 22:38:17', NULL), (2, '12379', 'ADESHINA ADEGBENGA', 'Cooperative Member', 0, 6205.00, 0.00, 6205.00, 1, 6205.00, 'Repaid Completely', 'Legacy Data', 6205.00, 1, '2020-08-13 22:38:17', NULL), (3, '134977', 'AKEREDOLU OLUWAFUNKE', 'Cooperative Member', 0, 130560.00, 0.00, 130560.00, 6, 21760.00, 'Repayment in Progress', 'Legacy Data', 43520.00, 2, '2020-08-13 22:38:17', NULL), (4, '16839', 'Babalola, Mrs. Abidemi Onikepo', 'Cooperative Member', 0, 21280.00, 0.00, 21280.00, 1, 21280.00, 'Repaid Completely', 'Legacy Data', 21280.00, 1, '2020-08-13 22:38:17', NULL), (5, '15620', 'BABATUNDE, Mr. OPE-OLUWA MATTHEW', 'Cooperative Member', 0, 34145.00, 0.00, 34145.00, 1, 34145.00, 'Repaid Completely', 'Legacy Data', 34145.00, 1, '2020-08-13 22:38:17', NULL), (6, '16319', 'Emele, Mrs. Nkechi Esther', 'Cooperative Member', 0, 55995.00, 0.00, 55995.00, 1, 55995.00, 'Repaid Completely', 'Legacy Data', 55995.00, 1, '2020-08-13 22:38:17', NULL), (7, '20366', 'IBRAHIM, Mr. MUHAMMED', 'Cooperative Member', 0, 28522.00, 0.00, 28522.00, 2, 14261.00, 'Repayment in Progress', 'Legacy Data', 14261.00, 1, '2020-08-13 22:38:17', NULL), (8, '15897', 'IDRIS, Mr. UMAR ADAMU', 'Cooperative Member', 0, 60040.00, 0.00, 60040.00, 1, 60040.00, 'Repaid Completely', 'Legacy Data', 60040.00, 1, '2020-08-13 22:38:17', NULL), (9, '120269', 'JIMOH NUHU ONUSAGBA', 'Cooperative Member', 0, 50300.00, 0.00, 50300.00, 2, 25150.00, 'Repayment in Progress', 'Legacy Data', 25150.00, 1, '2020-08-13 22:38:17', NULL), (10, '31630', 'KAMAL AHMED FOLORUNSHO', 'Cooperative Member', 0, 8600.00, 0.00, 8600.00, 1, 8600.00, 'Repaid Completely', 'Legacy Data', 8600.00, 1, '2020-08-13 22:38:17', NULL), (11, '194036', 'KISUMEN NAPAN-DAWURANG', 'Cooperative Member', 0, 10332.00, 0.00, 10332.00, 1, 10332.00, 'Repaid Completely', 'Legacy Data', 10332.00, 1, '2020-08-13 22:38:18', NULL), (12, '16248', 'NGOZI PEACE AGBAEZE', 'Cooperative Member', 0, 5985.00, 0.00, 5985.00, 1, 5985.00, 'Repaid Completely', 'Legacy Data', 5985.00, 1, '2020-08-13 22:38:18', NULL), (13, '15418', 'NZEKWE, Mrs. MAUREEN IFEOMA', 'Cooperative Member', 0, 35495.00, 0.00, 35495.00, 1, 35495.00, 'Repaid Completely', 'Legacy Data', 35495.00, 1, '2020-08-13 22:38:18', NULL), (14, '31777', 'Okogbe, Mr. Ojo Nathaniel', 'Cooperative Member', 0, 14610.00, 0.00, 14610.00, 1, 14610.00, 'Repaid Completely', 'Legacy Data', 14610.00, 1, '2020-08-13 22:38:18', NULL), (15, '99537', 'SANI Mr. BALA UMAR', 'Cooperative Member', 0, 5300.00, 0.00, 5300.00, 1, 5300.00, 'Repaid Completely', 'Legacy Data', 5300.00, 1, '2020-08-13 22:38:18', NULL), (16, '14211', 'UDEVBURE, Mr. UNUIGBE KINGSLEY', 'Cooperative Member', 0, 24870.00, 0.00, 24870.00, 2, 12435.00, 'Repayment in Progress', 'Legacy Data', 12435.00, 1, '2020-08-13 22:38:18', NULL), (17, '15318', 'Yakubu, Mr. Nasiru', 'Cooperative Member', 0, 34632.00, 0.00, 34632.00, 3, 11544.00, 'Repayment in Progress', 'Legacy Data', 11544.00, 1, '2020-08-13 22:38:18', NULL); -- -------------------------------------------------------- -- -- Table structure for table `referees` -- CREATE TABLE `referees` ( `id` bigint(20) UNSIGNED NOT NULL, `membernumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `membername` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refereenumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refereename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refereeaddress` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refereeattestation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `role`, `created_by`, `created_at`, `updated_at`) VALUES (1, 'Super Admin', '1', '2020-06-10 05:03:02', '2020-06-10 05:03:02'), (2, 'Cooperative Member', '1', '2020-06-11 03:18:57', '2020-06-11 03:18:57'), (5, 'Treasurer', '5', '2020-06-16 18:01:37', '2020-06-16 18:01:37'), (6, 'President', '5', '2020-06-16 18:06:20', '2020-06-16 18:06:20'), (7, 'Secretary general', '5', '2020-07-07 00:34:12', '2020-07-07 00:34:12'), (8, 'Secretary general', '5', '2020-07-07 00:35:24', '2020-07-07 00:35:24'), (9, 'Welfare Secretary', '1', '2020-08-08 21:15:14', '2020-08-08 21:15:14'); -- -------------------------------------------------------- -- -- Table structure for table `roles_actions` -- CREATE TABLE `roles_actions` ( `id` bigint(20) UNSIGNED NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles_actions` -- INSERT INTO `roles_actions` (`id`, `role`, `action`, `created_by`, `created_at`, `updated_at`) VALUES (102, '4', '9', '1', '2020-06-10 19:16:28', NULL), (103, '4', '10', '1', '2020-06-10 19:16:28', NULL), (104, '4', '11', '1', '2020-06-10 19:16:28', NULL), (105, '4', '13', '1', '2020-06-10 19:16:28', NULL), (106, '4', '17', '1', '2020-06-10 19:16:28', NULL), (107, '4', '21', '1', '2020-06-10 19:16:28', NULL), (108, '4', '25', '1', '2020-06-10 19:16:28', NULL), (109, '4', '29', '1', '2020-06-10 19:16:28', NULL), (110, '4', '33', '1', '2020-06-10 19:16:28', NULL), (111, '4', '37', '1', '2020-06-10 19:16:28', NULL), (482, '5', '81', '5', '2020-06-16 18:03:41', NULL), (483, '5', '82', '5', '2020-06-16 18:03:41', NULL), (484, '5', '83', '5', '2020-06-16 18:03:41', NULL), (485, '5', '84', '5', '2020-06-16 18:03:41', NULL), (486, '5', '93', '5', '2020-06-16 18:03:41', NULL), (487, '5', '94', '5', '2020-06-16 18:03:41', NULL), (488, '5', '95', '5', '2020-06-16 18:03:41', NULL), (489, '5', '96', '5', '2020-06-16 18:03:41', NULL), (490, '5', '1', '5', '2020-06-16 18:03:41', NULL), (491, '5', '2', '5', '2020-06-16 18:03:41', NULL), (492, '5', '3', '5', '2020-06-16 18:03:41', NULL), (493, '5', '4', '5', '2020-06-16 18:03:41', NULL), (494, '5', '85', '5', '2020-06-16 18:03:41', NULL), (495, '5', '86', '5', '2020-06-16 18:03:41', NULL), (496, '5', '87', '5', '2020-06-16 18:03:41', NULL), (497, '5', '88', '5', '2020-06-16 18:03:41', NULL), (498, '5', '97', '5', '2020-06-16 18:03:41', NULL), (499, '5', '98', '5', '2020-06-16 18:03:41', NULL), (500, '5', '99', '5', '2020-06-16 18:03:41', NULL), (501, '5', '100', '5', '2020-06-16 18:03:41', NULL), (502, '5', '101', '5', '2020-06-16 18:03:41', NULL), (503, '5', '102', '5', '2020-06-16 18:03:41', NULL), (504, '5', '103', '5', '2020-06-16 18:03:41', NULL), (505, '5', '104', '5', '2020-06-16 18:03:41', NULL), (506, '5', '89', '5', '2020-06-16 18:03:41', NULL), (507, '5', '90', '5', '2020-06-16 18:03:41', NULL), (508, '5', '91', '5', '2020-06-16 18:03:41', NULL), (509, '5', '92', '5', '2020-06-16 18:03:41', NULL), (510, '5', '13', '5', '2020-06-16 18:03:41', NULL), (511, '5', '14', '5', '2020-06-16 18:03:41', NULL), (512, '5', '15', '5', '2020-06-16 18:03:41', NULL), (513, '5', '16', '5', '2020-06-16 18:03:41', NULL), (514, '5', '25', '5', '2020-06-16 18:03:41', NULL), (515, '5', '26', '5', '2020-06-16 18:03:41', NULL), (516, '5', '27', '5', '2020-06-16 18:03:41', NULL), (517, '5', '28', '5', '2020-06-16 18:03:41', NULL), (518, '5', '77', '5', '2020-06-16 18:03:41', NULL), (519, '5', '78', '5', '2020-06-16 18:03:41', NULL), (520, '5', '79', '5', '2020-06-16 18:03:41', NULL), (521, '5', '80', '5', '2020-06-16 18:03:41', NULL), (522, '5', '41', '5', '2020-06-16 18:03:41', NULL), (523, '5', '42', '5', '2020-06-16 18:03:41', NULL), (524, '5', '43', '5', '2020-06-16 18:03:41', NULL), (525, '5', '44', '5', '2020-06-16 18:03:41', NULL), (526, '5', '17', '5', '2020-06-16 18:03:41', NULL), (527, '5', '18', '5', '2020-06-16 18:03:41', NULL), (528, '5', '19', '5', '2020-06-16 18:03:41', NULL), (529, '5', '20', '5', '2020-06-16 18:03:41', NULL), (530, '5', '9', '5', '2020-06-16 18:03:41', NULL), (531, '5', '10', '5', '2020-06-16 18:03:41', NULL), (532, '5', '11', '5', '2020-06-16 18:03:41', NULL), (533, '5', '12', '5', '2020-06-16 18:03:41', NULL), (534, '5', '29', '5', '2020-06-16 18:03:42', NULL), (535, '5', '30', '5', '2020-06-16 18:03:42', NULL), (536, '5', '31', '5', '2020-06-16 18:03:42', NULL), (537, '5', '32', '5', '2020-06-16 18:03:42', NULL), (538, '5', '53', '5', '2020-06-16 18:03:42', NULL), (539, '5', '54', '5', '2020-06-16 18:03:42', NULL), (540, '5', '55', '5', '2020-06-16 18:03:42', NULL), (541, '5', '56', '5', '2020-06-16 18:03:42', NULL), (542, '5', '57', '5', '2020-06-16 18:03:42', NULL), (543, '5', '58', '5', '2020-06-16 18:03:42', NULL), (544, '5', '59', '5', '2020-06-16 18:03:42', NULL), (545, '5', '60', '5', '2020-06-16 18:03:42', NULL), (546, '5', '49', '5', '2020-06-16 18:03:42', NULL), (547, '5', '50', '5', '2020-06-16 18:03:42', NULL), (548, '5', '51', '5', '2020-06-16 18:03:42', NULL), (549, '5', '52', '5', '2020-06-16 18:03:42', NULL), (550, '5', '37', '5', '2020-06-16 18:03:42', NULL), (551, '5', '38', '5', '2020-06-16 18:03:42', NULL), (552, '5', '39', '5', '2020-06-16 18:03:42', NULL), (553, '5', '40', '5', '2020-06-16 18:03:42', NULL), (554, '5', '65', '5', '2020-06-16 18:03:42', NULL), (555, '5', '66', '5', '2020-06-16 18:03:42', NULL), (556, '5', '67', '5', '2020-06-16 18:03:42', NULL), (557, '5', '68', '5', '2020-06-16 18:03:42', NULL), (558, '5', '45', '5', '2020-06-16 18:03:42', NULL), (559, '5', '46', '5', '2020-06-16 18:03:42', NULL), (560, '5', '47', '5', '2020-06-16 18:03:42', NULL), (561, '5', '48', '5', '2020-06-16 18:03:42', NULL), (562, '5', '61', '5', '2020-06-16 18:03:42', NULL), (563, '5', '62', '5', '2020-06-16 18:03:42', NULL), (564, '5', '63', '5', '2020-06-16 18:03:42', NULL), (565, '5', '64', '5', '2020-06-16 18:03:42', NULL), (566, '5', '33', '5', '2020-06-16 18:03:42', NULL), (567, '5', '34', '5', '2020-06-16 18:03:42', NULL), (568, '5', '35', '5', '2020-06-16 18:03:42', NULL), (569, '5', '36', '5', '2020-06-16 18:03:42', NULL), (570, '5', '69', '5', '2020-06-16 18:03:42', NULL), (571, '5', '70', '5', '2020-06-16 18:03:42', NULL), (572, '5', '71', '5', '2020-06-16 18:03:42', NULL), (573, '5', '72', '5', '2020-06-16 18:03:42', NULL), (574, '5', '21', '5', '2020-06-16 18:03:42', NULL), (575, '5', '22', '5', '2020-06-16 18:03:42', NULL), (576, '5', '23', '5', '2020-06-16 18:03:42', NULL), (577, '5', '24', '5', '2020-06-16 18:03:42', NULL), (578, '5', '73', '5', '2020-06-16 18:03:42', NULL), (579, '5', '74', '5', '2020-06-16 18:03:42', NULL), (580, '5', '75', '5', '2020-06-16 18:03:42', NULL), (581, '5', '76', '5', '2020-06-16 18:03:42', NULL), (582, '5', '5', '5', '2020-06-16 18:03:42', NULL), (583, '5', '6', '5', '2020-06-16 18:03:42', NULL), (584, '5', '7', '5', '2020-06-16 18:03:42', NULL), (585, '5', '8', '5', '2020-06-16 18:03:42', NULL), (586, '6', '81', '5', '2020-06-16 18:07:09', NULL), (587, '6', '82', '5', '2020-06-16 18:07:09', NULL), (588, '6', '83', '5', '2020-06-16 18:07:09', NULL), (589, '6', '84', '5', '2020-06-16 18:07:09', NULL), (590, '6', '93', '5', '2020-06-16 18:07:09', NULL), (591, '6', '94', '5', '2020-06-16 18:07:09', NULL), (592, '6', '95', '5', '2020-06-16 18:07:09', NULL), (593, '6', '96', '5', '2020-06-16 18:07:09', NULL), (594, '6', '1', '5', '2020-06-16 18:07:09', NULL), (595, '6', '2', '5', '2020-06-16 18:07:09', NULL), (596, '6', '3', '5', '2020-06-16 18:07:09', NULL), (597, '6', '4', '5', '2020-06-16 18:07:09', NULL), (598, '6', '85', '5', '2020-06-16 18:07:09', NULL), (599, '6', '86', '5', '2020-06-16 18:07:09', NULL), (600, '6', '87', '5', '2020-06-16 18:07:09', NULL), (601, '6', '88', '5', '2020-06-16 18:07:09', NULL), (602, '6', '97', '5', '2020-06-16 18:07:09', NULL), (603, '6', '98', '5', '2020-06-16 18:07:09', NULL), (604, '6', '99', '5', '2020-06-16 18:07:09', NULL), (605, '6', '100', '5', '2020-06-16 18:07:09', NULL), (606, '6', '101', '5', '2020-06-16 18:07:09', NULL), (607, '6', '102', '5', '2020-06-16 18:07:09', NULL), (608, '6', '103', '5', '2020-06-16 18:07:09', NULL), (609, '6', '104', '5', '2020-06-16 18:07:09', NULL), (610, '6', '89', '5', '2020-06-16 18:07:09', NULL), (611, '6', '90', '5', '2020-06-16 18:07:09', NULL), (612, '6', '91', '5', '2020-06-16 18:07:09', NULL), (613, '6', '92', '5', '2020-06-16 18:07:09', NULL), (614, '6', '13', '5', '2020-06-16 18:07:09', NULL), (615, '6', '14', '5', '2020-06-16 18:07:09', NULL), (616, '6', '15', '5', '2020-06-16 18:07:09', NULL), (617, '6', '16', '5', '2020-06-16 18:07:09', NULL), (618, '6', '25', '5', '2020-06-16 18:07:09', NULL), (619, '6', '26', '5', '2020-06-16 18:07:09', NULL), (620, '6', '27', '5', '2020-06-16 18:07:09', NULL), (621, '6', '28', '5', '2020-06-16 18:07:09', NULL), (622, '6', '77', '5', '2020-06-16 18:07:09', NULL), (623, '6', '78', '5', '2020-06-16 18:07:09', NULL), (624, '6', '79', '5', '2020-06-16 18:07:09', NULL), (625, '6', '80', '5', '2020-06-16 18:07:09', NULL), (626, '6', '41', '5', '2020-06-16 18:07:09', NULL), (627, '6', '42', '5', '2020-06-16 18:07:09', NULL), (628, '6', '43', '5', '2020-06-16 18:07:09', NULL), (629, '6', '44', '5', '2020-06-16 18:07:09', NULL), (630, '6', '17', '5', '2020-06-16 18:07:09', NULL), (631, '6', '18', '5', '2020-06-16 18:07:09', NULL), (632, '6', '19', '5', '2020-06-16 18:07:09', NULL), (633, '6', '20', '5', '2020-06-16 18:07:09', NULL), (634, '6', '9', '5', '2020-06-16 18:07:09', NULL), (635, '6', '10', '5', '2020-06-16 18:07:09', NULL), (636, '6', '11', '5', '2020-06-16 18:07:09', NULL), (637, '6', '12', '5', '2020-06-16 18:07:09', NULL), (638, '6', '29', '5', '2020-06-16 18:07:09', NULL), (639, '6', '30', '5', '2020-06-16 18:07:09', NULL), (640, '6', '31', '5', '2020-06-16 18:07:09', NULL), (641, '6', '32', '5', '2020-06-16 18:07:09', NULL), (642, '6', '53', '5', '2020-06-16 18:07:09', NULL), (643, '6', '54', '5', '2020-06-16 18:07:09', NULL), (644, '6', '55', '5', '2020-06-16 18:07:09', NULL), (645, '6', '56', '5', '2020-06-16 18:07:09', NULL), (646, '6', '57', '5', '2020-06-16 18:07:09', NULL), (647, '6', '58', '5', '2020-06-16 18:07:09', NULL), (648, '6', '59', '5', '2020-06-16 18:07:09', NULL), (649, '6', '60', '5', '2020-06-16 18:07:09', NULL), (650, '6', '49', '5', '2020-06-16 18:07:09', NULL), (651, '6', '50', '5', '2020-06-16 18:07:09', NULL), (652, '6', '51', '5', '2020-06-16 18:07:09', NULL), (653, '6', '52', '5', '2020-06-16 18:07:09', NULL), (654, '6', '37', '5', '2020-06-16 18:07:09', NULL), (655, '6', '38', '5', '2020-06-16 18:07:09', NULL), (656, '6', '39', '5', '2020-06-16 18:07:09', NULL), (657, '6', '40', '5', '2020-06-16 18:07:09', NULL), (658, '6', '65', '5', '2020-06-16 18:07:09', NULL), (659, '6', '66', '5', '2020-06-16 18:07:09', NULL), (660, '6', '67', '5', '2020-06-16 18:07:09', NULL), (661, '6', '68', '5', '2020-06-16 18:07:09', NULL), (662, '6', '45', '5', '2020-06-16 18:07:09', NULL), (663, '6', '46', '5', '2020-06-16 18:07:09', NULL), (664, '6', '47', '5', '2020-06-16 18:07:09', NULL), (665, '6', '48', '5', '2020-06-16 18:07:09', NULL), (666, '6', '61', '5', '2020-06-16 18:07:09', NULL), (667, '6', '62', '5', '2020-06-16 18:07:09', NULL), (668, '6', '63', '5', '2020-06-16 18:07:09', NULL), (669, '6', '64', '5', '2020-06-16 18:07:09', NULL), (670, '6', '33', '5', '2020-06-16 18:07:09', NULL), (671, '6', '34', '5', '2020-06-16 18:07:09', NULL), (672, '6', '35', '5', '2020-06-16 18:07:09', NULL), (673, '6', '36', '5', '2020-06-16 18:07:09', NULL), (674, '6', '69', '5', '2020-06-16 18:07:09', NULL), (675, '6', '70', '5', '2020-06-16 18:07:09', NULL), (676, '6', '71', '5', '2020-06-16 18:07:09', NULL), (677, '6', '72', '5', '2020-06-16 18:07:09', NULL), (678, '6', '21', '5', '2020-06-16 18:07:09', NULL), (679, '6', '22', '5', '2020-06-16 18:07:09', NULL), (680, '6', '23', '5', '2020-06-16 18:07:09', NULL), (681, '6', '24', '5', '2020-06-16 18:07:09', NULL), (682, '6', '73', '5', '2020-06-16 18:07:09', NULL), (683, '6', '74', '5', '2020-06-16 18:07:09', NULL), (684, '6', '75', '5', '2020-06-16 18:07:09', NULL), (685, '6', '76', '5', '2020-06-16 18:07:09', NULL), (686, '6', '5', '5', '2020-06-16 18:07:09', NULL), (687, '6', '6', '5', '2020-06-16 18:07:09', NULL), (688, '6', '7', '5', '2020-06-16 18:07:09', NULL), (689, '6', '8', '5', '2020-06-16 18:07:09', NULL), (922, '7', '117', '5', '2020-07-07 00:41:07', NULL), (923, '7', '118', '5', '2020-07-07 00:41:07', NULL), (924, '7', '119', '5', '2020-07-07 00:41:07', NULL), (925, '7', '120', '5', '2020-07-07 00:41:07', NULL), (926, '7', '109', '5', '2020-07-07 00:41:07', NULL), (927, '7', '110', '5', '2020-07-07 00:41:07', NULL), (928, '7', '111', '5', '2020-07-07 00:41:07', NULL), (929, '7', '112', '5', '2020-07-07 00:41:07', NULL), (930, '7', '81', '5', '2020-07-07 00:41:07', NULL), (931, '7', '82', '5', '2020-07-07 00:41:07', NULL), (932, '7', '83', '5', '2020-07-07 00:41:07', NULL), (933, '7', '84', '5', '2020-07-07 00:41:07', NULL), (934, '7', '93', '5', '2020-07-07 00:41:07', NULL), (935, '7', '94', '5', '2020-07-07 00:41:07', NULL), (936, '7', '95', '5', '2020-07-07 00:41:07', NULL), (937, '7', '96', '5', '2020-07-07 00:41:07', NULL), (938, '7', '1', '5', '2020-07-07 00:41:07', NULL), (939, '7', '2', '5', '2020-07-07 00:41:07', NULL), (940, '7', '3', '5', '2020-07-07 00:41:07', NULL), (941, '7', '4', '5', '2020-07-07 00:41:07', NULL), (942, '7', '85', '5', '2020-07-07 00:41:07', NULL), (943, '7', '86', '5', '2020-07-07 00:41:07', NULL), (944, '7', '87', '5', '2020-07-07 00:41:07', NULL), (945, '7', '88', '5', '2020-07-07 00:41:07', NULL), (946, '7', '97', '5', '2020-07-07 00:41:07', NULL), (947, '7', '98', '5', '2020-07-07 00:41:07', NULL), (948, '7', '99', '5', '2020-07-07 00:41:07', NULL), (949, '7', '100', '5', '2020-07-07 00:41:07', NULL), (950, '7', '101', '5', '2020-07-07 00:41:07', NULL), (951, '7', '102', '5', '2020-07-07 00:41:07', NULL), (952, '7', '103', '5', '2020-07-07 00:41:07', NULL), (953, '7', '104', '5', '2020-07-07 00:41:07', NULL), (954, '7', '89', '5', '2020-07-07 00:41:07', NULL), (955, '7', '90', '5', '2020-07-07 00:41:07', NULL), (956, '7', '91', '5', '2020-07-07 00:41:07', NULL), (957, '7', '92', '5', '2020-07-07 00:41:07', NULL), (958, '7', '113', '5', '2020-07-07 00:41:07', NULL), (959, '7', '114', '5', '2020-07-07 00:41:07', NULL), (960, '7', '115', '5', '2020-07-07 00:41:07', NULL), (961, '7', '116', '5', '2020-07-07 00:41:07', NULL), (962, '7', '105', '5', '2020-07-07 00:41:07', NULL), (963, '7', '106', '5', '2020-07-07 00:41:07', NULL), (964, '7', '107', '5', '2020-07-07 00:41:07', NULL), (965, '7', '108', '5', '2020-07-07 00:41:07', NULL), (966, '7', '13', '5', '2020-07-07 00:41:07', NULL), (967, '7', '14', '5', '2020-07-07 00:41:07', NULL), (968, '7', '15', '5', '2020-07-07 00:41:07', NULL), (969, '7', '16', '5', '2020-07-07 00:41:07', NULL), (970, '7', '25', '5', '2020-07-07 00:41:07', NULL), (971, '7', '26', '5', '2020-07-07 00:41:07', NULL), (972, '7', '27', '5', '2020-07-07 00:41:07', NULL), (973, '7', '28', '5', '2020-07-07 00:41:07', NULL), (974, '7', '77', '5', '2020-07-07 00:41:07', NULL), (975, '7', '78', '5', '2020-07-07 00:41:07', NULL), (976, '7', '79', '5', '2020-07-07 00:41:07', NULL), (977, '7', '80', '5', '2020-07-07 00:41:07', NULL), (978, '7', '41', '5', '2020-07-07 00:41:07', NULL), (979, '7', '42', '5', '2020-07-07 00:41:07', NULL), (980, '7', '43', '5', '2020-07-07 00:41:07', NULL), (981, '7', '44', '5', '2020-07-07 00:41:07', NULL), (982, '7', '121', '5', '2020-07-07 00:41:07', NULL), (983, '7', '122', '5', '2020-07-07 00:41:07', NULL), (984, '7', '123', '5', '2020-07-07 00:41:07', NULL), (985, '7', '124', '5', '2020-07-07 00:41:07', NULL), (986, '7', '17', '5', '2020-07-07 00:41:07', NULL), (987, '7', '18', '5', '2020-07-07 00:41:07', NULL), (988, '7', '19', '5', '2020-07-07 00:41:07', NULL), (989, '7', '20', '5', '2020-07-07 00:41:07', NULL), (990, '7', '29', '5', '2020-07-07 00:41:07', NULL), (991, '7', '30', '5', '2020-07-07 00:41:07', NULL), (992, '7', '31', '5', '2020-07-07 00:41:07', NULL), (993, '7', '32', '5', '2020-07-07 00:41:07', NULL), (994, '7', '9', '5', '2020-07-07 00:41:07', NULL), (995, '7', '10', '5', '2020-07-07 00:41:07', NULL), (996, '7', '11', '5', '2020-07-07 00:41:07', NULL), (997, '7', '12', '5', '2020-07-07 00:41:07', NULL), (998, '7', '53', '5', '2020-07-07 00:41:07', NULL), (999, '7', '54', '5', '2020-07-07 00:41:07', NULL), (1000, '7', '55', '5', '2020-07-07 00:41:07', NULL), (1001, '7', '56', '5', '2020-07-07 00:41:07', NULL), (1002, '7', '57', '5', '2020-07-07 00:41:07', NULL), (1003, '7', '58', '5', '2020-07-07 00:41:07', NULL), (1004, '7', '59', '5', '2020-07-07 00:41:07', NULL), (1005, '7', '60', '5', '2020-07-07 00:41:07', NULL), (1006, '7', '49', '5', '2020-07-07 00:41:07', NULL), (1007, '7', '50', '5', '2020-07-07 00:41:07', NULL), (1008, '7', '51', '5', '2020-07-07 00:41:07', NULL), (1009, '7', '52', '5', '2020-07-07 00:41:07', NULL), (1010, '7', '37', '5', '2020-07-07 00:41:07', NULL), (1011, '7', '38', '5', '2020-07-07 00:41:07', NULL), (1012, '7', '39', '5', '2020-07-07 00:41:07', NULL), (1013, '7', '40', '5', '2020-07-07 00:41:07', NULL), (1014, '7', '65', '5', '2020-07-07 00:41:07', NULL), (1015, '7', '66', '5', '2020-07-07 00:41:07', NULL), (1016, '7', '67', '5', '2020-07-07 00:41:07', NULL), (1017, '7', '68', '5', '2020-07-07 00:41:07', NULL), (1018, '7', '45', '5', '2020-07-07 00:41:07', NULL), (1019, '7', '46', '5', '2020-07-07 00:41:07', NULL), (1020, '7', '47', '5', '2020-07-07 00:41:07', NULL), (1021, '7', '48', '5', '2020-07-07 00:41:07', NULL), (1022, '7', '61', '5', '2020-07-07 00:41:07', NULL), (1023, '7', '62', '5', '2020-07-07 00:41:07', NULL), (1024, '7', '63', '5', '2020-07-07 00:41:07', NULL), (1025, '7', '64', '5', '2020-07-07 00:41:07', NULL), (1026, '7', '33', '5', '2020-07-07 00:41:07', NULL), (1027, '7', '34', '5', '2020-07-07 00:41:07', NULL), (1028, '7', '35', '5', '2020-07-07 00:41:07', NULL), (1029, '7', '36', '5', '2020-07-07 00:41:07', NULL), (1030, '7', '69', '5', '2020-07-07 00:41:07', NULL), (1031, '7', '70', '5', '2020-07-07 00:41:07', NULL), (1032, '7', '71', '5', '2020-07-07 00:41:07', NULL), (1033, '7', '72', '5', '2020-07-07 00:41:07', NULL), (1034, '7', '21', '5', '2020-07-07 00:41:07', NULL), (1035, '7', '22', '5', '2020-07-07 00:41:07', NULL), (1036, '7', '23', '5', '2020-07-07 00:41:07', NULL), (1037, '7', '24', '5', '2020-07-07 00:41:07', NULL), (1038, '7', '73', '5', '2020-07-07 00:41:07', NULL), (1039, '7', '74', '5', '2020-07-07 00:41:07', NULL), (1040, '7', '75', '5', '2020-07-07 00:41:07', NULL), (1041, '7', '76', '5', '2020-07-07 00:41:07', NULL), (1042, '7', '5', '5', '2020-07-07 00:41:07', NULL), (1043, '7', '6', '5', '2020-07-07 00:41:07', NULL), (1044, '7', '7', '5', '2020-07-07 00:41:07', NULL), (1045, '7', '8', '5', '2020-07-07 00:41:07', NULL), (1046, '7', '125', '5', '2020-07-07 00:41:07', NULL), (1047, '7', '126', '5', '2020-07-07 00:41:07', NULL), (1048, '7', '127', '5', '2020-07-07 00:41:07', NULL), (1049, '7', '128', '5', '2020-07-07 00:41:07', NULL), (1050, '1', '117', '1', '2020-07-12 23:48:47', NULL), (1051, '1', '118', '1', '2020-07-12 23:48:47', NULL), (1052, '1', '119', '1', '2020-07-12 23:48:47', NULL), (1053, '1', '120', '1', '2020-07-12 23:48:47', NULL), (1054, '1', '109', '1', '2020-07-12 23:48:47', NULL), (1055, '1', '110', '1', '2020-07-12 23:48:47', NULL), (1056, '1', '111', '1', '2020-07-12 23:48:47', NULL), (1057, '1', '112', '1', '2020-07-12 23:48:47', NULL), (1058, '1', '81', '1', '2020-07-12 23:48:47', NULL), (1059, '1', '82', '1', '2020-07-12 23:48:47', NULL), (1060, '1', '83', '1', '2020-07-12 23:48:47', NULL), (1061, '1', '84', '1', '2020-07-12 23:48:47', NULL), (1062, '1', '93', '1', '2020-07-12 23:48:47', NULL), (1063, '1', '94', '1', '2020-07-12 23:48:47', NULL), (1064, '1', '95', '1', '2020-07-12 23:48:47', NULL), (1065, '1', '96', '1', '2020-07-12 23:48:47', NULL), (1066, '1', '1', '1', '2020-07-12 23:48:47', NULL), (1067, '1', '2', '1', '2020-07-12 23:48:47', NULL), (1068, '1', '3', '1', '2020-07-12 23:48:47', NULL), (1069, '1', '4', '1', '2020-07-12 23:48:47', NULL), (1070, '1', '85', '1', '2020-07-12 23:48:47', NULL), (1071, '1', '86', '1', '2020-07-12 23:48:47', NULL), (1072, '1', '87', '1', '2020-07-12 23:48:47', NULL), (1073, '1', '88', '1', '2020-07-12 23:48:47', NULL), (1074, '1', '97', '1', '2020-07-12 23:48:47', NULL), (1075, '1', '98', '1', '2020-07-12 23:48:47', NULL), (1076, '1', '99', '1', '2020-07-12 23:48:47', NULL), (1077, '1', '100', '1', '2020-07-12 23:48:47', NULL), (1078, '1', '101', '1', '2020-07-12 23:48:47', NULL), (1079, '1', '102', '1', '2020-07-12 23:48:47', NULL), (1080, '1', '103', '1', '2020-07-12 23:48:47', NULL), (1081, '1', '104', '1', '2020-07-12 23:48:47', NULL), (1082, '1', '133', '1', '2020-07-12 23:48:47', NULL), (1083, '1', '134', '1', '2020-07-12 23:48:47', NULL), (1084, '1', '135', '1', '2020-07-12 23:48:47', NULL), (1085, '1', '136', '1', '2020-07-12 23:48:48', NULL), (1086, '1', '89', '1', '2020-07-12 23:48:48', NULL), (1087, '1', '90', '1', '2020-07-12 23:48:48', NULL), (1088, '1', '91', '1', '2020-07-12 23:48:48', NULL), (1089, '1', '92', '1', '2020-07-12 23:48:48', NULL), (1090, '1', '113', '1', '2020-07-12 23:48:48', NULL), (1091, '1', '114', '1', '2020-07-12 23:48:48', NULL), (1092, '1', '115', '1', '2020-07-12 23:48:48', NULL), (1093, '1', '116', '1', '2020-07-12 23:48:48', NULL), (1094, '1', '105', '1', '2020-07-12 23:48:48', NULL), (1095, '1', '106', '1', '2020-07-12 23:48:48', NULL), (1096, '1', '107', '1', '2020-07-12 23:48:48', NULL), (1097, '1', '108', '1', '2020-07-12 23:48:48', NULL), (1098, '1', '13', '1', '2020-07-12 23:48:48', NULL), (1099, '1', '14', '1', '2020-07-12 23:48:48', NULL), (1100, '1', '15', '1', '2020-07-12 23:48:48', NULL), (1101, '1', '16', '1', '2020-07-12 23:48:48', NULL), (1102, '1', '25', '1', '2020-07-12 23:48:48', NULL), (1103, '1', '26', '1', '2020-07-12 23:48:48', NULL), (1104, '1', '27', '1', '2020-07-12 23:48:48', NULL), (1105, '1', '28', '1', '2020-07-12 23:48:48', NULL), (1106, '1', '77', '1', '2020-07-12 23:48:48', NULL), (1107, '1', '78', '1', '2020-07-12 23:48:48', NULL), (1108, '1', '79', '1', '2020-07-12 23:48:48', NULL), (1109, '1', '80', '1', '2020-07-12 23:48:48', NULL), (1110, '1', '41', '1', '2020-07-12 23:48:48', NULL), (1111, '1', '42', '1', '2020-07-12 23:48:48', NULL), (1112, '1', '43', '1', '2020-07-12 23:48:48', NULL), (1113, '1', '44', '1', '2020-07-12 23:48:48', NULL), (1114, '1', '121', '1', '2020-07-12 23:48:48', NULL), (1115, '1', '122', '1', '2020-07-12 23:48:48', NULL), (1116, '1', '123', '1', '2020-07-12 23:48:48', NULL), (1117, '1', '124', '1', '2020-07-12 23:48:48', NULL), (1118, '1', '17', '1', '2020-07-12 23:48:48', NULL), (1119, '1', '18', '1', '2020-07-12 23:48:48', NULL), (1120, '1', '19', '1', '2020-07-12 23:48:48', NULL), (1121, '1', '20', '1', '2020-07-12 23:48:48', NULL), (1122, '1', '29', '1', '2020-07-12 23:48:48', NULL), (1123, '1', '30', '1', '2020-07-12 23:48:48', NULL), (1124, '1', '31', '1', '2020-07-12 23:48:48', NULL), (1125, '1', '32', '1', '2020-07-12 23:48:48', NULL), (1126, '1', '9', '1', '2020-07-12 23:48:48', NULL), (1127, '1', '10', '1', '2020-07-12 23:48:48', NULL), (1128, '1', '11', '1', '2020-07-12 23:48:48', NULL), (1129, '1', '12', '1', '2020-07-12 23:48:48', NULL), (1130, '1', '53', '1', '2020-07-12 23:48:48', NULL), (1131, '1', '54', '1', '2020-07-12 23:48:48', NULL), (1132, '1', '55', '1', '2020-07-12 23:48:48', NULL), (1133, '1', '56', '1', '2020-07-12 23:48:48', NULL), (1134, '1', '57', '1', '2020-07-12 23:48:48', NULL), (1135, '1', '58', '1', '2020-07-12 23:48:48', NULL), (1136, '1', '59', '1', '2020-07-12 23:48:48', NULL), (1137, '1', '60', '1', '2020-07-12 23:48:48', NULL), (1138, '1', '49', '1', '2020-07-12 23:48:48', NULL), (1139, '1', '50', '1', '2020-07-12 23:48:48', NULL), (1140, '1', '51', '1', '2020-07-12 23:48:48', NULL), (1141, '1', '52', '1', '2020-07-12 23:48:48', NULL), (1142, '1', '37', '1', '2020-07-12 23:48:48', NULL), (1143, '1', '38', '1', '2020-07-12 23:48:48', NULL), (1144, '1', '39', '1', '2020-07-12 23:48:48', NULL), (1145, '1', '40', '1', '2020-07-12 23:48:48', NULL), (1146, '1', '141', '1', '2020-07-12 23:48:48', NULL), (1147, '1', '142', '1', '2020-07-12 23:48:48', NULL), (1148, '1', '143', '1', '2020-07-12 23:48:48', NULL), (1149, '1', '144', '1', '2020-07-12 23:48:48', NULL), (1150, '1', '65', '1', '2020-07-12 23:48:48', NULL), (1151, '1', '66', '1', '2020-07-12 23:48:48', NULL), (1152, '1', '67', '1', '2020-07-12 23:48:48', NULL), (1153, '1', '68', '1', '2020-07-12 23:48:48', NULL), (1154, '1', '45', '1', '2020-07-12 23:48:48', NULL), (1155, '1', '46', '1', '2020-07-12 23:48:48', NULL), (1156, '1', '47', '1', '2020-07-12 23:48:48', NULL), (1157, '1', '48', '1', '2020-07-12 23:48:48', NULL), (1158, '1', '61', '1', '2020-07-12 23:48:48', NULL), (1159, '1', '62', '1', '2020-07-12 23:48:48', NULL), (1160, '1', '63', '1', '2020-07-12 23:48:48', NULL), (1161, '1', '64', '1', '2020-07-12 23:48:48', NULL), (1162, '1', '33', '1', '2020-07-12 23:48:48', NULL), (1163, '1', '34', '1', '2020-07-12 23:48:48', NULL), (1164, '1', '35', '1', '2020-07-12 23:48:48', NULL), (1165, '1', '36', '1', '2020-07-12 23:48:48', NULL), (1166, '1', '69', '1', '2020-07-12 23:48:48', NULL), (1167, '1', '70', '1', '2020-07-12 23:48:48', NULL), (1168, '1', '71', '1', '2020-07-12 23:48:48', NULL), (1169, '1', '72', '1', '2020-07-12 23:48:48', NULL), (1170, '1', '129', '1', '2020-07-12 23:48:48', NULL), (1171, '1', '130', '1', '2020-07-12 23:48:48', NULL), (1172, '1', '131', '1', '2020-07-12 23:48:48', NULL), (1173, '1', '132', '1', '2020-07-12 23:48:48', NULL), (1174, '1', '137', '1', '2020-07-12 23:48:48', NULL), (1175, '1', '138', '1', '2020-07-12 23:48:48', NULL), (1176, '1', '139', '1', '2020-07-12 23:48:48', NULL), (1177, '1', '140', '1', '2020-07-12 23:48:48', NULL), (1178, '1', '21', '1', '2020-07-12 23:48:48', NULL), (1179, '1', '22', '1', '2020-07-12 23:48:48', NULL), (1180, '1', '23', '1', '2020-07-12 23:48:48', NULL), (1181, '1', '24', '1', '2020-07-12 23:48:48', NULL), (1182, '1', '73', '1', '2020-07-12 23:48:48', NULL), (1183, '1', '74', '1', '2020-07-12 23:48:48', NULL), (1184, '1', '75', '1', '2020-07-12 23:48:48', NULL), (1185, '1', '76', '1', '2020-07-12 23:48:48', NULL), (1186, '1', '5', '1', '2020-07-12 23:48:48', NULL), (1187, '1', '6', '1', '2020-07-12 23:48:48', NULL), (1188, '1', '7', '1', '2020-07-12 23:48:48', NULL), (1189, '1', '8', '1', '2020-07-12 23:48:48', NULL), (1190, '1', '125', '1', '2020-07-12 23:48:48', NULL), (1191, '1', '126', '1', '2020-07-12 23:48:48', NULL), (1192, '1', '127', '1', '2020-07-12 23:48:48', NULL), (1193, '1', '128', '1', '2020-07-12 23:48:48', NULL), (1221, '9', '65', '1', '2020-08-08 21:17:22', NULL), (1222, '9', '66', '1', '2020-08-08 21:17:22', NULL), (1223, '9', '67', '1', '2020-08-08 21:17:22', NULL), (1224, '9', '68', '1', '2020-08-08 21:17:22', NULL), (1225, '9', '61', '1', '2020-08-08 21:17:22', NULL), (1226, '9', '62', '1', '2020-08-08 21:17:22', NULL), (1227, '9', '63', '1', '2020-08-08 21:17:22', NULL), (1228, '9', '64', '1', '2020-08-08 21:17:22', NULL), (1229, '9', '33', '1', '2020-08-08 21:17:22', NULL), (1230, '9', '34', '1', '2020-08-08 21:17:22', NULL), (1231, '9', '35', '1', '2020-08-08 21:17:22', NULL), (1232, '9', '36', '1', '2020-08-08 21:17:22', NULL), (1233, '9', '69', '1', '2020-08-08 21:17:22', NULL), (1234, '9', '70', '1', '2020-08-08 21:17:22', NULL), (1235, '9', '71', '1', '2020-08-08 21:17:22', NULL), (1236, '9', '72', '1', '2020-08-08 21:17:22', NULL), (1237, '9', '21', '1', '2020-08-08 21:17:22', NULL), (1238, '9', '22', '1', '2020-08-08 21:17:22', NULL), (1239, '9', '23', '1', '2020-08-08 21:17:22', NULL), (1240, '9', '24', '1', '2020-08-08 21:17:22', NULL), (1241, '9', '73', '1', '2020-08-08 21:17:22', NULL), (1242, '9', '74', '1', '2020-08-08 21:17:22', NULL), (1243, '9', '75', '1', '2020-08-08 21:17:22', NULL), (1244, '9', '76', '1', '2020-08-08 21:17:22', NULL); -- -------------------------------------------------------- -- -- Table structure for table `savingsdefined` -- CREATE TABLE `savingsdefined` ( `id` bigint(20) UNSIGNED NOT NULL, `memberid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `monthlysavings` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `totalsaved` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `monthssaved` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `savingswithdrawal` -- CREATE TABLE `savingswithdrawal` ( `id` bigint(20) UNSIGNED NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL, `totalsaved` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `monthssaved` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `withdrawamount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `withdrawstatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `shopproducts` -- CREATE TABLE `shopproducts` ( `id` bigint(20) UNSIGNED NOT NULL, `productname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `brand` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `packaging` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `size` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quantity` int(11) NOT NULL, `cashprice` decimal(11,2) NOT NULL, `creditprice` decimal(11,2) NOT NULL, `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `shopsales` -- CREATE TABLE `shopsales` ( `id` bigint(20) UNSIGNED NOT NULL, `productid` int(11) NOT NULL, `productname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `brandname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `size` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `quantity` int(11) NOT NULL, `unitprice` decimal(11,2) NOT NULL, `totalprice` decimal(11,2) NOT NULL, `discount` decimal(11,2) DEFAULT NULL, `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amountpaid` decimal(11,2) NOT NULL, `paymentstatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `paymentmethod` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `states` -- CREATE TABLE `states` ( `id` bigint(20) UNSIGNED NOT NULL, `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nationality` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `residentialaddress` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phonenumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `homephone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cooperativeamount` decimal(11,2) DEFAULT NULL, `commencementdate` date DEFAULT NULL, `additionalincome` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `passport` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `maritalstatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `spousename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `spousephone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `spouseemail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `kinname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `kinrelationship` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `kinphonenumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `kinaddress` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `kinpassport` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attestation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bankname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accountname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accountnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refereename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refereenumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `validid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `authorizationform` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accounttype` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `userrole` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accountstatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updatedby` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `ippisnumber`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `nationality`, `dob`, `residentialaddress`, `location`, `phonenumber`, `homephone`, `cooperativeamount`, `commencementdate`, `additionalincome`, `gender`, `passport`, `maritalstatus`, `spousename`, `spousephone`, `spouseemail`, `kinname`, `kinrelationship`, `kinphonenumber`, `kinaddress`, `kinpassport`, `attestation`, `bankname`, `accountname`, `accountnumber`, `refereename`, `refereenumber`, `validid`, `authorizationform`, `accounttype`, `userrole`, `accountstatus`, `updatedby`, `created_at`, `updated_at`) VALUES (1, '123456', 'James Nweke', 'jemznweke@gmail.com', NULL, '$2y$10$FA6/QLxcZw6Y7hPKf8Z47ehuyEO7uq1l/oJY1ZF9TndCsBf5w.JE6', 'O4oQxxYv2Uvei662GqLGu05F9510n9ttXLHn26QoBxwvntgcbN5WIvRL8jwH', 'Nigerian', '1992-04-02', 'Garki 2', 'FCT', '08065246633', '08065215555', 5000.00, '2020-05-21', 'Yes', 'Male', 'assets/attachments/LAmvI58PrxoOleWwIAR4nK87ATDaldeJByXNy4Sw.jpeg', 'Married', 'Amina Usman', '08065324515', 'aminausman@mail.com', 'Amina Usman', 'Spouse', '08065324515', 'Garki 2', 'assets/attachments/qMrZ5uZxWJqbiTaCAZU5xtkf2S7wr12UgCkup0fH.jpeg', 'on', 'UBA', 'James Nweke', '0027893877', 'Haruna Gambo', 'NSCMS/0006', 'assets/attachments/iX3vwIdu5GGrFqxWFV7QYD6lTbbLPF9W87YS15Uc.jpeg', 'assets/attachments/1fSikZkm5R9tRRwKWC7FD24AjbXfYvs7WGJoNjb6.jpeg', 'Cooperative Member', '1', 'Active', 1, '2020-05-31 05:59:43', '2020-08-05 15:51:11'), (2, NULL, 'Tester Tester', 'tester@mail.com', NULL, '$2y$10$N6LndEKr98ny0b7wzKvAVe8ScCrZSWUEsoT9PwU0hPHKQtJocJIp2', NULL, NULL, NULL, NULL, NULL, '08035162355', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Non-Cooperative Member', 'Shop Attendant', 'Active', 1, '2020-06-10 06:52:10', '2020-06-10 06:52:10'), (4, '563735', 'Amina Saidu', 'aminasaidu@gmail.com', NULL, '$2y$10$2pSXgUqWqpUlrD/vgNnfZO6C0RXJHbJIIK45sghlrjB3mMU.lkM5S', NULL, 'Nigeria', '1989-02-09', 'No. 6 Ogidi Street Garki 2', 'FCT', '08056347865', NULL, 10000.00, '2020-06-19', 'No', 'Female', 'assets/attachments/4NUgikktUIkbyw4JeKMbIbOXgt9EPBsW3ZUFJ1Uq.jpeg', 'Married', 'Haruna Saidu', '08056738723', 'harunasaidu@gmail.com', 'Usman Aminu', 'Brother', '08067567343', 'No. 6 Ogidi Street Garki 2', 'assets/attachments/agP2MvBZaCjmpDwFJ0JjMSzDJex8llGzvYBRl13O.jpeg', 'Accepted', 'Access Bank', 'Hafsat Musa', '0045687637', 'Haruna Mohammed', '234123', 'assets/attachments/lAtCSkKqCHxbCTJbi1Ljx8coVfAn8rw7zA8xludI.jpeg', 'assets/attachments/PIPgKvUzxZQtlPKJTpDQNFSGZjx7EPJL2PoRzCrI.jpeg', 'Cooperative Member', '2', 'Active', 1, '2020-06-11 07:53:52', '2020-06-11 07:53:52'), (5, '194022', 'Shem Daudu Yusufu', 'dukanshemoo@yahoo.com', NULL, '$2y$10$Xk2V2rx0qrzMwVXE5CgNIOMVW/F3N5lKo/44uWLx/cMyuchPT8IYe', NULL, 'Nigerian', '1979-01-16', 'Adjacent Abedini hotel, NUT road, ACO estate Lugbe Abuja', 'FCT', '08028604836', '08033192893', 5000.00, '2013-06-04', 'Yes', 'Male', 'assets/attachments/wXp5lSeD5mV82d9L9U6uo579qd2hfgj3uVnT3GOA.jpeg', 'Married', 'Sarah Disa Shem', '08098222211', 'saydisa@yahoo.com', 'Sarah Disa Shem', 'Spouse', '08098222211', 'Adjacent Abedini hotel, NUT road, ACO estate Lugbe Abuja', 'assets/attachments/naWan5G1MR3Z8GnPipWaJbK22ivd8o2fa8602MMe.jpeg', 'Accepted', 'Guaranty trust bank', 'Yusufu Shem Daudu', '0046318278', 'Kisumen Napan-Dawurang', '194036', 'assets/attachments/aKounmx7vv2UyO4p5WG55eXjpJiplxjGhmEiVfh3.jpeg', NULL, 'Cooperative Member', '1', 'Active', 1, '2020-06-13 02:02:45', '2020-06-13 02:02:45'), (6, '17035', 'Oluwayomi Omotosho', 'yomiolaleye2002@yahoo.com', NULL, '$2y$10$8Du50ZHah9Oci2.VdkNzsu6eliI8zT3pctAx7cGdRyNJEZwdKUdoe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Select Gender', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'Active', 5, '2020-06-16 17:53:03', '2020-06-16 17:53:03'), (7, '15620', 'babatunde Matthew opeoluwa', 'babaolo@yahoo.com', NULL, '$2y$10$jMH5OxLjTklSHVP6m87phO1xMT3aV/omqmUCuJBIq.OUPpetWNwT.', 'ExQH1JVnloyJdddX9tCnYtzapBSwnwTOaLP7VmwNkCc0lSxxi3QUrRAliCDh', '+2348028193522', '1969-02-27', 'House 30, Taproot Estate, Sabo-Lugbe, Abuja', 'FCT', '08028193522', '09059830385', 5000.00, '2009-03-01', 'No', 'Male', 'assets/attachments/KPGmkmOHcexTdLfZjdHxL4XidHqTgMeHB9ugKSJb.jpeg', 'Married', 'Regina Babatunde', '08087067494', 'regbabs101@gmail.com', 'Regina Babatunde', 'Spouse', '08087067494', 'House 30 Taproot Estate, Sabo-Lugbe, Abuja', 'assets/attachments/vKAENN08L38BrZBIFhaCXFNKd9veawKve2ifwL7u.jpeg', 'Accepted', 'FCMB', 'Abodunrin Olufunmilayo Samson', '0545098019', 'Abodunrin Olufunmilayo Samson', '99513', 'assets/attachments/Z6CADdtuC1VbyswmTraWrsQWoVQiI9SQiG8cC6Fe.jpeg', NULL, NULL, '6', 'Active', 5, '2020-06-16 17:55:14', '2020-08-05 23:03:09'), (9, '99506', 'Alheri Dee-Dee Osinuga', 'deedeeng2000@yahoo.com', NULL, '$2y$10$q8sIQcGnuF7//D2tqlo3OeUY26Z39XrKg15PECPybcdAMkMYfcBGO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Select Gender', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7', 'Active', 5, '2020-07-07 00:24:25', '2020-07-07 00:24:25'), (10, '14566', 'ALIKA EGILIWE DONALD', 'ealika@nigcomsat.gov.ng', NULL, '$2y$10$qt.Q6qsYt1fjar3FUDk2H.SdHKPlcYaKsXfQd4IeIJvqb8zN3Z2yq', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Select Gender', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'Active', 5, '2020-08-04 21:25:58', '2020-08-04 21:25:58'), (11, '16319', 'Emele Nkechi Esther', 'oparanky@yahoo.com', NULL, '$2y$10$43Mn9TQFNv2A6VqTE9B6bek3lS5SUXcEwkxOxrr1j2R0uFZMt2LgO', NULL, '08035826313', '1978-04-14', 'Flat 3 H- Close 23 Crescent Efab Estate Mbora', 'FCT', '08035826313', '08179099880', 10000.00, '2009-07-01', 'No', 'Female', 'assets/attachments/aFC3FXC3utumhgBp3uKR7E2p34XEf3atxWwVD0s2.jpeg', 'Married', 'Udo Udo Emele', '08033160778', 'emeleudy2@yahoo.com', 'Udo Udo Emele', 'Spouse', '08033160778', 'same as above', 'assets/attachments/h2y7FkZYemaaK8nqGRr85VAOiKgLM6bXWj3yjjTt.jpeg', 'Accepted', 'Zenith bank', 'Emele Nkechi Esther', '2003693685', 'Hannatu Mustapha', '22737', 'assets/attachments/jZYTx7wfr8XP3VuLwLlPZbcGV46VGKtdmKXsRYWT.jpeg', NULL, NULL, '9', 'Active', 5, '2020-08-05 01:15:18', '2020-08-05 01:15:18'), (12, '12082', 'Ganiyu Ode', 'ganiyuode@gmail.com', NULL, '$2y$10$PbdBDRD23s50kBXx4k8FcOU8YS1WMR36sDAleiWENkPJGfg4ptIuy', NULL, 'Nigerian', '1978-09-25', 'G20 Engr. Ebele Okeke Estate, Lugbe, Abuja', 'FCT', '08033563757', NULL, 5000.00, '2009-03-01', 'Yes', 'Male', 'assets/attachments/ErgTy9VxMRThKX3ppKZ5al0VYpM6xM43Ozt4xmm2.jpeg', 'Married', 'Agnes Bukola Ode', '08068098959', 'agnesbukola44@gmail.com', 'Agnes Bukola Ode', 'Spouse', '08068098959', 'G20 Engr. Ebele Okeke Estate, Lugbe, Abuja', 'assets/attachments/DpXqKc3fVQv7O7FrSeoaifFrst3nLRjpZqgFyDWa.jpeg', 'Accepted', 'Standard Chartered Bank', 'Ganiyu Ode', '0002767598', 'Ogodo Stephen Ojo', '12082', 'assets/attachments/0N6rH391RcAEy7VTLP7zHtMMlcFHBQZNG6nPw3xb.pdf', NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 01:51:55', '2020-08-05 01:51:55'), (13, '99573', 'Adepoju Falilat', 'omayozarekiya@yahoo.com', NULL, '$2y$10$.JyDPWC5/SMcU0SLIJb58.nv.ZE.yh2te/lSXFZyGtkgULt1TCgXq', NULL, '08031898226', '1986-06-26', 'No 2 kolapo close off Jeff Gold way river park estate', 'FCT', '08031898226', '08031898226', 5000.00, '2011-08-05', 'No', 'Female', 'assets/attachments/wKCIRA0NxTT6OxTPgzH4MtweH6dangCSpzjd4XUR.jpeg', 'Married', 'Adepoju Ojo James', '08033065999', 'Jamesadepoju@ymail.com', 'Adepoju Ojo James', 'Spouse', '08033065999', 'Same as above', 'assets/attachments/ZadsiBG1u6TYxmxyd3LkebFMIycClRgiMNdTBAdU.jpeg', 'Accepted', 'Gtbank', 'Adepoju Falilat', '0024931510', 'Oluwatosin Akeredolu', '134977', 'assets/attachments/b9GDSSoPHdUOsQn0SHhtT6jtb1zjBiMLIii4DNG4.jpeg', NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 02:01:47', '2020-08-05 02:01:47'), (14, '14605', 'Olukemi Oyelami', 'kemikupie@yahoo.com', NULL, '$2y$10$iOav2ZanHNELGP/xuoEUAe.qqQWmfC8pkSN53QceAygb6pqBMESxG', NULL, 'Nigerian', '1983-03-30', 'No 48 Nnamdi Azikwe Street, Trademore Estate, Lugbe', 'FCT', '08060688718', '08060688718', 5000.00, '2010-11-01', 'No', 'Female', 'assets/attachments/1zrklxNsg1SJNlZwl6V931TNWuU0aR3d0klQtUED.jpeg', 'Married', 'Opeyemi Oyelami', '08109711539', 'opeyemi_oyelami@yahoo.com', 'Opeyemi Oyelami', 'Spouse', '08109711539', 'No 48 Nnamdi Azikwe Street, Trademore Estate, Lugbe', 'assets/attachments/USkrgMsSt2OJHrqg5JbDgOEqcZi3PdIlr5uypvP7.jpeg', 'Accepted', 'GTB', 'Oyelami Olukemi Olaitan', '0043087438', 'Obamila Ekundayo Johnson', '00000', 'assets/attachments/ReXVv6avnOoCwf0TGnRF19qciuBr0c1JEfnaJzzS.jpeg', NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 02:08:01', '2020-08-05 02:08:01'), (15, '120269', 'Nuhu Onusagba Jimoh', 'memuraha@yahoo.com', NULL, '$2y$10$YkLniWqqVEO8J5MlVmi82umslT.PH2AHVT1UPaqVave2NWD46UuKy', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 02:12:57', '2020-08-05 02:12:57'), (16, '16381', 'Alhassan Ahmed', 'alhas.ahmed81@gmail.com', NULL, '$2y$10$52wtIkw8/qOBcxOpY.VE7e85rkenGllI0F40kbMGLGsyrftnC2Qyy', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 02:21:26', '2020-08-05 02:21:26'), (17, '17169', 'Aishatu Ibrahim Bantam', 'ayibantam@gmail.com', NULL, '$2y$10$hR.h1dXBKAMw1vL0ox17Zu77esJ9IZoV0dHBriLOVMhk3M.56PHMu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 02:37:37', '2020-08-05 02:37:37'), (18, '12143', 'Yange Ikerave', 'arkmanny2001@yahoo.com', NULL, '$2y$10$.84wxIz0WNIXVWWalcV3cOQmJmp2LQGVptyGHEEIuDpMsclSLgjVG', NULL, 'Nigerian', '1980-12-15', 'FLAT 28 1K CRESCENT', 'FCT', '07031063983', '07031063983', 10000.00, '2020-08-04', 'No', 'Male', 'assets/attachments/ABGJC6vGfvVxaIT5rimMIZx5yZL5WXwoLf6ha5kJ.jpeg', 'Married', 'Carolyn Ngodoo Ikerave', '07033194412', 'ctyovenda@gmail.com', 'Carolyn Ngodoo Ikerave', 'Spouse', '07033194412', 'FLAT 28 1K CRESCENT', 'assets/attachments/mgiQEeplIy9NfXJAturWkwfrDTbZokKAdUOIxfXJ.jpeg', 'Accepted', 'GTBANK', 'IKERAVE YANGE-KAR DAVID', '0023289111', 'Yange', '12143', 'assets/attachments/zJDpoNs1QqZazH0U6VdQeqDebNdKWuJG0Dk6kAXU.jpeg', NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 02:41:40', '2020-08-05 02:41:40'), (19, '119763', 'DARANIJO AYODEJI BABATUNDE', 'ayodeji719@yahoo.com', NULL, '$2y$10$ZRizwP8.RkWQC3sBO1dBxeNHxZeLyaFWyllJ150wTyr/isFiKrPku', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 03:11:43', '2020-08-05 03:11:43'), (20, '235323', 'Musa Aishat Bolanle', 'aishatb4you@yahoo.com', NULL, '$2y$10$puemXt48uvI/wCCd4iM2Q.y2mAjNaWJECig5kla0cdS//aG9hct7m', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 03:25:24', '2020-08-05 03:25:24'), (21, '14670', 'Stephen O. Ogodo', 'peculiarstephen@gmail.com', NULL, '$2y$10$VbzDKYLwSGZ8D/p/ISjFTu3kcdyW3CV1FLAXkkK5IIRrTCAqxniqK', NULL, 'Nigeria', '1978-03-16', 'E3, Liberty estate, Behind AMAC Market', 'FCT', '08066602597', NULL, 10000.00, '2009-05-01', 'No', 'Male', 'assets/attachments/XI8B16Rfn4FAOFFnpkeZXwQ71Z4RRYH3igllPxIA.jpeg', 'Married', 'Funke Stephen Ogodo', '35920028724', 'funkeogodo@gmail.com', 'Funke Stephen Ogodo', 'Spouse', '35920028724', 'E3, Liberty estate, Behind AMAC Market', 'assets/attachments/crnfUqKX1cP30PmPqdRT6iPNr344cRa5gzM4IFzV.jpeg', 'Accepted', 'Access Bank', 'Ogodo Stephen Ojo', '0053407911', 'Yemi Eludiwura Benedict', '44556', 'assets/attachments/FDDbXAR2mUakZRocYn88oog8fBXraPuWsTkHfkAO.jpeg', NULL, NULL, '2', 'Active', 5, '2020-08-05 03:34:48', '2020-08-05 03:34:48'), (22, '99482', 'MOHAMMED ABDULLAHI MAZANKWARAI', 'mazankwarai81@gmail.com', NULL, '$2y$10$93k00CioQwLKsE.dYRsjSeAqZo31L6SeKJpytBY5IbRtz0RZt3HA6', 'ngHXzApZ3uv4PpAOE0iA9zdvORX5de2GzDqpwwn9DnC48lhiTXQKVBly3gb4', '+234', '2020-04-13', 'Plot 227 opposite MFM aco lugbe', 'FCT', '08036409298', '08054666871', 5000.00, '2011-07-11', 'No', 'Male', 'assets/attachments/dJ2iFWtMbqPg69D8EwpfSCviCVBkFONt7snqh51a.jpeg', 'Married', 'Hajia Mohammed SURURAT A', '08139624079', 'surumama@gmail.com', 'Ibrahim Mohammed Mazankwarai', 'Son', '09025801556', '184- 186 FHA oloje ilorin kwara state', 'assets/attachments/9wzCmk0joe2jnhzet8xhQeE4OVWIBpDVo7tq8eHC.jpeg', 'Accepted', 'Guarantee Trust Bank', 'Mohammed Abdullahi Mazankwarai', '0027548113', 'Alheri Deedee Osinowo', '071825', 'assets/attachments/tWyg9FaWJd0FONiMTqX4c6Tgckd6qdsaRTIZnKrr.jpeg', NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 04:08:01', '2020-08-06 06:53:06'), (23, '235071', 'Reginald Odogwu', 'reg_od@yahoo.com', NULL, '$2y$10$OWx77.wgJecFDopfFTzZyOMqnySSRdM0hhyLrs4Emjs7lpr7uXHXq', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 04:45:02', '2020-08-05 04:45:02'), (24, '15247', 'ISAAC OLADAPO OLASEHINDE', 'isaakolasehinde@gmail.com', NULL, '$2y$10$JD/zRx4yNVhe8eNBweELGu.o5TGl3ds68JbhyUu.qfj4qpWmRNJse', NULL, 'NIGERIAN', '1968-01-07', 'HOUSE 1 ROAD B1 PENTVILLE ESTATE LOKOGOMA ABUJA', 'FCT', '08087756403', '07039007225', 300000.00, '2009-03-30', 'Yes', 'Male', 'assets/attachments/JDqxYTyEhHIT1JxBmKp8D8Zo3zg0oml81SmqRWJp.jpeg', 'Married', 'FATIMOH OMOTOLA OLASEHINDE', '08033207345', 'olafaty@gmail.com', 'BUSAYO OLASEHINDE', 'Daugther', '08091106740', 'HOUSE 1 ROAD B1 PENTVILLE ESTATE LOKOGOMA ABUJA', 'assets/attachments/t1038slCF8yUK6WFs9Jzf7NtxuepRYU6aFlTy3Hm.jpeg', 'Accepted', 'GTB', 'ISAAC OLADAPO OLASEHINDE', '0022563337', 'FUNMILAYO OBI-NWAJEI', '16296', 'assets/attachments/WL7MSrSE9ph4tg9r4WarA19eg9ZjN78IqnbecPd8.jpeg', NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 11:12:35', '2020-08-05 11:12:35'), (25, '99513', 'Samson Olufunmilayo Abodunrin', 'funmielect@yahoo.com', NULL, '$2y$10$vGxxNxc6w.aER10/0Ic5JOzMkKTPfdsrUBAO6FMrANYaDG6rIkxjm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 12:11:25', '2020-08-05 12:11:25'), (26, '14922', 'Dr. Kareem Moshood Idowu', 'mko@presidency.com', NULL, '$2y$10$l0mTt9i4SKqJdjJTGXquBOedVFrIbj8awyrYIII8lqHgjxpjqeEdW', NULL, 'Nigerian', '1980-02-15', '3, Remkom Street, Behind NNPC Station, Arab Road, Kubwa-Abuja', 'FCT', '08062689718', NULL, 5000.00, '2009-05-05', 'No', 'Male', 'assets/attachments/wKv6tggvmHLe23INZe2LanH46Uw4A5eW3kweP5ak.jpeg', 'Married', 'Kareem R.B', '08060523908', 'moshood@gmail.com', 'AbdulKareem Mubarak Olawale', 'Son', '08033854502', '3, Remkom Street, Behind NNPC Station, Arab Road, Kubwa-Abuja', 'assets/attachments/jDLEVtLU8Pvapidzpz72wt9Kwp2D6BdtASKcgnsU.jpeg', 'Accepted', 'Ecobank', 'KAREEM MOSHOOD', '2522008833', 'Zubairu Dokko Muhammad', '99571', 'assets/attachments/WKLM4hHEHpVXsrAfIFIVTKjNvTuMxE6QixLuNiOS.bmp', NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 12:22:06', '2020-08-05 12:22:06'), (27, '15906', 'Adedugbe Adelolu', 'loluade24@gmail.com', NULL, '$2y$10$R8izpT9wB3.sgkETxYAWvusOAo2dNe9OptXIgi/5.DzZOrl/nYQVK', NULL, 'Nigerian', '1979-02-27', 'Plot 8, mambilla street, Aldenco estate, Galadimawa, Abuja', 'FCT', '08033734002', NULL, 10000.00, '2020-08-05', 'No', 'Male', 'assets/attachments/l3K4sQMUpuRmX0cjsXDmYzdE0M4uJZPmo2mFNqdR.jpeg', 'Married', 'Mariam Adedugbe', '08061525373', 'mariamidankpo@gmail.com', 'Adedugbe Adewole', 'Son', '08037002448', 'Plot 8, mambilla street, Aldenco estate, Galadimawa, Abuja', 'assets/attachments/cg3epqfcEFLmFcLhzg2f9cVpHRSlVlhllpg21Zw0.jpeg', 'Accepted', 'Guaranty trust bank', 'Adedugbe Adelolu', '0148186346', 'Bassey Asuquo', '161', 'assets/attachments/ubo184O2OPbWcuyEO5lqTD3Hue0zG8hKXA13maaS.jpeg', NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 12:27:04', '2020-08-05 12:27:04'), (28, '13246', 'Samuel Ajakaiye', 'advantiumx@gmail.com', NULL, '$2y$10$GXGHPUI8l7OFe5fYSxFk4eNinZCpI2tgA1G/.4J4qYIQf6nEOOZoK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 12:29:58', '2020-08-05 12:29:58'), (29, '14579', 'Dada Cletus Otaru', 'dassoyo@yahoo.com', NULL, '$2y$10$qOx702iT/xD9t347hh0k8eVKibRnzzn/Y0MVqZLambn7Ygf43R1QC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 13:31:54', '2020-08-05 13:31:54'), (30, '99478', 'BABALOLA KAYODE SUNDAY', 'kayodemi2003@yahoo.com', NULL, '$2y$10$KB3wFYPRsHzR2Ab7m.oR9Oh79vm6nqkKxnXl.G4CnzWugAtWB01Qe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 13:39:30', '2020-08-05 13:39:30'), (31, '20116', 'Emmanuel I Agyoh', 'eagyoh@Nigcomsat.gov.ng', NULL, '$2y$10$tQYqwwzqFhHTsSp.arCsuOxCrv3Rk0cDFwHCB04mZFnD9dn6HzNQi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 14:56:38', '2020-08-05 14:56:38'), (32, '27580', 'OBAMILA EKUNDAYO JOHNSON', 'johnsond12001@gmail.com', NULL, '$2y$10$7DnLmCfbHMYKZd5D9TCnmeyxD95/X.FXgnJ1Fj0036LNKYUp/w9Q6', 'crHXyQ8RLBnR3Yu93pYXDrpYkmZGbNcQQX0vbfKgIXQbKEqEi76LnWtUtB0N', 'Nigerian', '1981-08-06', 'PLOT 686, STREET A1, PHASE 2, AMAC/ACO ESTATE, AIRPORT ROAD, ABUJA', 'FCT', '08064931566', NULL, 5000.00, '2011-01-01', 'No', 'Male', 'assets/attachments/KHv05LZRxfi5OTGPIM6Plak36mqbmNHou8RQT43O.jpeg', 'Married', 'OBAMILA OMOLARA', '08052285717', 'omolara.oyelami@yahoo.com', 'OBAMILA OMOLARA', 'Spouse', '08052285717', 'PLOT 686, STREET A1, PHASE 2, AMAC/ACO ESTATE, AIRPORT ROAD, ABUJA', 'assets/attachments/obLG3XiWRuIcenqxmXSvTKJ6iLMKViMbb37qeisM.jpeg', 'Accepted', 'STANBIC IBTC', 'OBAMILA EKUNDAYO JOHNSON', '9202092818', 'AGBADUA ESHI GODSENT', '13440', 'assets/attachments/Y1DSPx57GlobQWkWGr8s91Z8d5E0LJJe3o5TLkod.jpeg', NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 15:01:05', '2020-08-24 18:26:07'), (33, '132765', 'Samuel Audu Michael', 'samuelmichael@gmail.com', NULL, '$2y$10$oSrJPof24wCJ2TIYFfD3ROzT.ZQ5poGizjKdLnLFf1RuwW2DjyTGO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 15:24:56', '2020-08-05 15:24:56'), (34, '31630', 'Ahmad Folorunsho Kamal', 'afkamal@gmail.com', NULL, '$2y$10$v5DCeWl6nG8kHzvs4WYYE.6E2s3l638nJIpRkjVATjc7sYm7W8R5e', NULL, 'Nigerian', '2020-10-31', '1 yaba close area 7 garki', 'FCT', '08033516344', NULL, 5000.00, '2020-08-05', 'No', 'Male', 'assets/attachments/2qK8hMyrJp1QHx6kn4KTQI3J1wPtnOXqvRSVphZZ.jpeg', 'Married', 'Sidikat Jumoke Kamal', '08032275566', 'sidi862@yahoo.com', 'Sidikat Jumoke Kamal', 'Spouse', '08032275566', '1 yaba close area 7 garki', 'assets/attachments/Zyzki5Mhpg2fmhK4rtnDJuaibwKhKjRXpBgV0zAm.jpeg', 'Accepted', 'First Bank', 'Ahmad Kamal', '2026669508', 'Abioye Femi', '31000', 'assets/attachments/upNwgxoWLSQr7McNN2GfYiQOoeSilx36QBBy2cDv.jpeg', NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 16:09:57', '2020-08-05 16:09:57'), (35, '17354', 'Peju Ukodum Monkom', 'pejumonkom@yahoo.com', NULL, '$2y$10$AOa9cAZI.29Rj6a8C99v1us8n0.jFas29Rkw/rC6VwuLSUp55jpam', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 16:37:48', '2020-08-05 16:37:48'), (36, '132765', 'Samuel Audu.Michael', 'Samuelmichael35@gmail.com', NULL, '$2y$10$mVCD/BZTX.bnB9XQ6MmvROYqvvRjQEZWCWMD93VYpE9TTvdpH0s8y', NULL, 'NIGERIA', '2012-08-01', 'Sector F.Opposite Hill Top Hotel FHA Lugbe Abuja', 'FCT', '08037756591', '08037756591', 10000.00, '2012-08-01', 'No', 'Male', 'assets/attachments/vzpEc05Xt7UEDLttFH8xYDrzBJS3XBHlUFQP7Ecn.jpeg', 'Married', 'Rose line Michael', '08161723784', 'roselinefunmitoluhi@gmail.com', 'Rose line Michael', 'Spouse', '08161723784', '08037756591', 'assets/attachments/enesmoHMLMY8mdW9Z9srK4CZxLGgrmQQ09KC1GNt.jpeg', 'Accepted', 'First Bank', 'Samuel Audu.Michael', '2010680782', 'Waziri Tukur', '132654', 'assets/attachments/XbH4EFLKg1xUBWnv62JSYoZFT84vv3o7O4kYpl5s.jpeg', NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 17:39:38', '2020-08-05 17:39:38'), (37, '17439', 'AGBOOLA OLUWATOYIN AKINTAYO', 'agboola.akintayo@gmail.com', NULL, '$2y$10$2WL1CKfBrHxuw/lYp9TUYu7Hi6xGc3ukbLzAYKCAlk1B58CnjFg.a', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 17:52:56', '2020-08-05 17:52:56'), (38, '16839', 'ONIKEPO BABALOLA', 'nikepo@gmail.com', NULL, '$2y$10$N4dVdg19vw8lggJoHs7Xkufjy1aQsmV0m/G/JdUHRt5ZtghsGAv2q', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 19:29:02', '2020-08-05 19:29:02'), (39, '17934', 'ELVIS- MADUAGWU GRACE UGWUEZI', 'chigrace200@yahoo.com', NULL, '$2y$10$yV6/clbNh3la/Hz4VTwhGeNUI1B3EQC3sMyo8bkcpLDNqsK3K2vZC', NULL, '08030958730', '1974-02-18', 'No. 131 Kenneth Ojo Crescent, Lingo Estate, Logokoma', 'FCT', '08030958730', '08030958730', 5000.00, '2011-04-04', 'No', 'Female', 'assets/attachments/SN0KaG8vhctfYZfYpngpBXRqRyNQOaOhdnqoj1kP.jpeg', 'Married', 'CHRIS ELVIS MADUAGWU', '08033311850', 'ambcec@yahoo.com', 'CHRIS ELVIS MADUAGWU', 'Spouse', '08033311850', 'No. 131 Kenneth Ojo Crescent, Lingo Estate, Logokoma. 08033311850', 'assets/attachments/4uwTR2gNW7IbCHWRcHppLvO0TVKFhSaDkeEOQoCa.jpeg', 'Accepted', 'STANDARD CHARTERED BANK', 'GRACE UGWUEZI ELVIS-MADUAGWU', '0002448451', 'UCHEDILI BARRY UGOCHKWU', '25676', 'assets/attachments/pc6ASbjQchDLCld6Emjv0SlNbvtVIEmb4SApb8Mu.jpeg', NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 19:35:45', '2020-08-05 19:35:45'), (40, '13440', 'Agbadua Eshiofuezemhe Godsend', 'eshi4u@yahoo.com', NULL, '$2y$10$.Z3JmG4/r7zN5M46ZAdyoeGsbggkqciJr9aq.hhzSStp/7EYsd6he', NULL, 'NIGERIAN', '1985-06-11', 'A65 LIAS ESTATE, LIFE CAMP', 'FCT', '07039250349', '07039250349', 5000.00, '2011-01-01', 'No', 'Male', 'assets/attachments/TKOH3qWKY2Rm29RspEIn2xrIlv4UJ3kKU9IjVdye.jpeg', 'Married', 'AGBADUA JEMMY', '08055408872', 'jemmyagbadua@gmail.com', 'AGBADUA JEMMY', 'Spouse', '08055408872', 'A65 LIAS ESTATE, LIFE CAMP', 'assets/attachments/k3vaOlPxWCNyPzFQ9lhfJBojbZsjZbjiruLtaHm1.jpeg', 'Accepted', 'GTB', 'AGBADUA ESHI GODSEND', '0033086386', 'OBAMILA EKUNDAYO', '27580', 'assets/attachments/ffM6vplGOxQOCgIxx8wF62s1UPGMyfhCXlBONvbZ.png', NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-05 19:53:41', '2020-08-05 19:53:41'), (41, '134975', 'Peace Azini', 'Peacesokari@yahoo.com', NULL, '$2y$10$ThjThQ983P12dNfGd844DO5aN107TeXUhOkkeyCTJHH8UsD8pVTey', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-05 22:03:00', '2020-08-05 22:03:00'), (42, '16248', 'NGOZI PEACE AGBAEZE', 'antifidex@yahoo.com', NULL, '$2y$10$heITq/34Dd7cOYrfnymA8ODR/mxluPJH8nxS24NwIyKeGxWey12BO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 1, '2020-08-06 00:27:16', '2020-08-06 00:27:16'), (43, '16078', 'Chegbeyi Luka', 'chegbeyi@gmail.com', NULL, '$2y$10$jlwtGoRIl2.KkEswb9MCoOLet27c1UnyMEo91rG.Ze.EfycVr9XT.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-06 23:17:17', '2020-08-06 23:17:17'), (44, '153677', 'Bukola Aniye', 'bukola.bb@gmail.com', NULL, '$2y$10$eo30Q9k0Fu26rQifCGc5XOb81uIvJ/D9IkSTTP7A5iBnWF3GawQwG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Select Gender', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'Active', 5, '2020-08-07 17:43:33', '2020-08-07 17:43:33'), (45, '120287', 'ALABELEWE SOLA ABDULRAUF', 'alabelewesola@yahoo.com', NULL, '$2y$10$uHyrnGTiugJpQG5VzGGW5O.45AEjnajWlnyCAkkrCvif6bf0Jfefi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-10 15:26:53', '2020-08-10 15:26:53'), (46, '12379', 'Adegbenga Niran Adeshina', 'wallacegbenga24@gmail.com', NULL, '$2y$10$HPddSuNqc79XpnNgVM6aWOytIedPIItWq8LpT/969YGKRRcGuegu6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-10 18:38:34', '2020-08-10 18:38:34'), (47, '14211', 'udevbure kingsley', 'udevbure@rocketmail.com', NULL, '$2y$10$UTKbUT8lyOzjn.ZllPsha.s7rjg0ZftHOxuapGm1Aw8R1L3z5YfJW', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-10 19:34:20', '2020-08-10 19:34:20'), (48, '15477', 'Abioye Olufemi Wahab', 'woabioye@gmail.com', NULL, '$2y$10$ool/4zs1u.OHz0/ygk9jpeSBqflYmMCUZe0cvhwuU4lOv4tXT8/dW', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-10 22:40:11', '2020-08-10 22:40:11'), (49, '99510', 'Temitope Yoosuf', 'toyz1us@yahoo.com', NULL, '$2y$10$klGN4m2fL8PJ0fMSE8XKBeszlLzn1RRb/vCwqdB8e8CND3c/LV2MW', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-11 04:27:52', '2020-08-11 04:27:52'), (50, '123593', 'OJINIKA CHINYERE SCHOLASTICA', 'chygal2005@yahoo.com', NULL, '$2y$10$UKkUQnYYu1er0LMIWyhCbexRZ3sO.mPln7vMy4EZBTGc/HgQlnMa6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Cooperative Member', '2', 'Active', 5, '2020-08-24 17:30:42', '2020-08-24 17:30:42'); -- -------------------------------------------------------- -- -- Table structure for table `variation` -- CREATE TABLE `variation` ( `id` bigint(20) UNSIGNED NOT NULL, `ippisnumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `savings` decimal(11,2) DEFAULT NULL, `normalloan` decimal(11,2) DEFAULT NULL, `softloan` decimal(11,2) DEFAULT NULL, `shop` decimal(11,2) DEFAULT NULL, `business` decimal(11,2) DEFAULT NULL, `total` decimal(11,2) DEFAULT NULL, `month` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `actions` -- ALTER TABLE `actions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `businessrepayment` -- ALTER TABLE `businessrepayment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `businessrequest` -- ALTER TABLE `businessrequest` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cooperativesavings` -- ALTER TABLE `cooperativesavings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `loanrepayment` -- ALTER TABLE `loanrepayment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `loanrequest` -- ALTER TABLE `loanrequest` ADD PRIMARY KEY (`id`); -- -- Indexes for table `loantypes` -- ALTER TABLE `loantypes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `newstock` -- ALTER TABLE `newstock` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `productcategory` -- ALTER TABLE `productcategory` ADD PRIMARY KEY (`id`); -- -- Indexes for table `productloanrepay` -- ALTER TABLE `productloanrepay` ADD PRIMARY KEY (`id`); -- -- Indexes for table `productloanrequest` -- ALTER TABLE `productloanrequest` ADD PRIMARY KEY (`id`); -- -- Indexes for table `productrequest` -- ALTER TABLE `productrequest` ADD PRIMARY KEY (`id`); -- -- Indexes for table `referees` -- ALTER TABLE `referees` ADD PRIMARY KEY (`id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `roles_actions` -- ALTER TABLE `roles_actions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `savingsdefined` -- ALTER TABLE `savingsdefined` ADD PRIMARY KEY (`id`); -- -- Indexes for table `savingswithdrawal` -- ALTER TABLE `savingswithdrawal` ADD PRIMARY KEY (`id`); -- -- Indexes for table `shopproducts` -- ALTER TABLE `shopproducts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `shopsales` -- ALTER TABLE `shopsales` ADD PRIMARY KEY (`id`); -- -- Indexes for table `states` -- ALTER TABLE `states` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `variation` -- ALTER TABLE `variation` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `actions` -- ALTER TABLE `actions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145; -- -- AUTO_INCREMENT for table `businessrepayment` -- ALTER TABLE `businessrepayment` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `businessrequest` -- ALTER TABLE `businessrequest` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `cooperativesavings` -- ALTER TABLE `cooperativesavings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `loanrepayment` -- ALTER TABLE `loanrepayment` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `loanrequest` -- ALTER TABLE `loanrequest` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59; -- -- AUTO_INCREMENT for table `loantypes` -- ALTER TABLE `loantypes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `newstock` -- ALTER TABLE `newstock` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `productcategory` -- ALTER TABLE `productcategory` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `productloanrepay` -- ALTER TABLE `productloanrepay` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `productloanrequest` -- ALTER TABLE `productloanrequest` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `productrequest` -- ALTER TABLE `productrequest` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `referees` -- ALTER TABLE `referees` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `roles_actions` -- ALTER TABLE `roles_actions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1245; -- -- AUTO_INCREMENT for table `savingsdefined` -- ALTER TABLE `savingsdefined` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `savingswithdrawal` -- ALTER TABLE `savingswithdrawal` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `shopproducts` -- ALTER TABLE `shopproducts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `shopsales` -- ALTER TABLE `shopsales` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `states` -- ALTER TABLE `states` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51; -- -- AUTO_INCREMENT for table `variation` -- ALTER TABLE `variation` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Simpan