API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 1st, 2019
69,657
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 158.30 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.8.3
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost:3306
  6. -- Generation Time: Mar 01, 2019 at 01:57 PM
  7. -- Server version: 5.7.23
  8. -- PHP Version: 7.2.10
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `cred`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `bank`
  21. --
  22.  
  23. CREATE TABLE `bank` (
  24. `id` int(11) NOT NULL,
  25. `bank_name` varchar(255) NOT NULL,
  26. `bank_id` varchar(255) NOT NULL,
  27. `bank_code` varchar(20) DEFAULT NULL
  28. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  29.  
  30. --
  31. -- Dumping data for table `bank`
  32. --
  33.  
  34. INSERT INTO `bank` (`id`, `bank_name`, `bank_id`, `bank_code`) VALUES
  35. (1, 'Sterling Bank', '1', 'sterling'),
  36. (2, 'Polaris Bank', '2', 'polaris'),
  37. (3, 'Access Bank', '6', 'access'),
  38. (4, 'Heritage Bank', '7', 'heritage'),
  39. (5, 'Diamond Bank', '8', 'diamond'),
  40. (6, 'Union Bank', '11', 'union'),
  41. (7, 'UBA', '14', 'uba'),
  42. (8, 'Fidelity Bank', '15', 'fidelity'),
  43. (9, 'GTB', '13', 'gtb'),
  44. (10, 'First City Monument Bank PLC', '', 'fcmb'),
  45. (11, 'First Bank of Nigeria Limited', '', 'firstbank'),
  46. (12, 'Zenith Bank Plc', '', 'zenith'),
  47. (13, 'Citi Bank Nigeria Limited', '', 'citi'),
  48. (14, 'Ecobank Nigeria Plc', '', 'ecobank'),
  49. (15, 'Keystone Bank Limited', '', 'keystone'),
  50. (16, 'Stanbic IBTC Bank Plc', '', 'stanbic'),
  51. (17, 'Standard Chartered', '', 'sc'),
  52. (18, 'Unity Bank Plc', '', 'unity'),
  53. (19, 'Wema Bank Plc', '', 'wema'),
  54. (20, 'SunTrust Bank Nigeria Limited', '', 'suntrust'),
  55. (21, 'Jaiz Bank Plc', '', 'jaiz');
  56.  
  57. -- --------------------------------------------------------
  58.  
  59. --
  60. -- Table structure for table `card`
  61. --
  62.  
  63. CREATE TABLE `card` (
  64. `card_id` int(11) NOT NULL,
  65. `card_customer_id` int(11) NOT NULL,
  66. `card_user_id` int(11) NOT NULL,
  67. `card_last4` int(11) NOT NULL,
  68. `card_exp_month` int(11) NOT NULL,
  69. `card_exp_year` int(11) NOT NULL,
  70. `card_authorization_code` varchar(100) NOT NULL,
  71. `card_created` int(11) NOT NULL,
  72. `card_type` varchar(100) NOT NULL,
  73. `card_country_code` varchar(100) NOT NULL,
  74. `card_reusable` int(11) NOT NULL,
  75. `card_bank` varchar(100) NOT NULL
  76. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  77.  
  78. --
  79. -- Dumping data for table `card`
  80. --
  81.  
  82. INSERT INTO `card` (`card_id`, `card_customer_id`, `card_user_id`, `card_last4`, `card_exp_month`, `card_exp_year`, `card_authorization_code`, `card_created`, `card_type`, `card_country_code`, `card_reusable`, `card_bank`) VALUES
  83. (1, 1, 2, 4081, 12, 2020, 'AUTH_j0jiomie9d', 1550935910, 'visa DEBIT', 'NG', 1, 'Test Bank'),
  84. (2, 2, 2, 4081, 12, 2020, 'AUTH_glwwxdq8ji', 1550975889, 'visa DEBIT', 'NG', 1, 'Test Bank');
  85.  
  86. -- --------------------------------------------------------
  87.  
  88. --
  89. -- Table structure for table `creditreport`
  90. --
  91.  
  92. CREATE TABLE `creditreport` (
  93. `c_id` int(11) NOT NULL,
  94. `c_DataTicket` varchar(1000) DEFAULT NULL,
  95. `c_bvn` varchar(20) NOT NULL,
  96. `c_EnquiryReason` varchar(100) DEFAULT NULL,
  97. `c_ConsumerName` varchar(200) DEFAULT NULL,
  98. `c_DateOfBirth` varchar(100) DEFAULT NULL,
  99. `c_Identification` varchar(100) DEFAULT NULL,
  100. `c_AccountNumber` varchar(20) DEFAULT NULL,
  101. `c_ProductID` int(11) DEFAULT NULL,
  102. `c_ConsumerID` int(11) DEFAULT NULL,
  103. `c_FirstName` varchar(100) DEFAULT NULL,
  104. `c_Surname` varchar(100) DEFAULT NULL,
  105. `c_OtherNames` varchar(100) DEFAULT NULL,
  106. `c_Address` varchar(100) DEFAULT NULL,
  107. `c_BirthDate` varchar(100) DEFAULT NULL,
  108. `c_AccountNo` varchar(100) DEFAULT NULL,
  109. `c_DriversLicenseNo` varchar(100) DEFAULT NULL,
  110. `c_VoterID` varchar(100) DEFAULT NULL,
  111. `c_user_id` int(11) DEFAULT NULL,
  112. `c_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  113. `c_status` int(11) DEFAULT NULL,
  114. `c_bureau` int(11) DEFAULT NULL,
  115. `c_EnquiryEngineID` int(11) DEFAULT NULL,
  116. `c_enquiryID` int(11) DEFAULT NULL,
  117. `c_consumerMergeList` varchar(200) DEFAULT NULL,
  118. `c_MatchingEngineID` varchar(20) DEFAULT NULL,
  119. `c_Reference` varchar(100) DEFAULT NULL,
  120. `c_MatchingRate` int(11) DEFAULT NULL
  121. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  122.  
  123. --
  124. -- Dumping data for table `creditreport`
  125. --
  126.  
  127. INSERT INTO `creditreport` (`c_id`, `c_DataTicket`, `c_bvn`, `c_EnquiryReason`, `c_ConsumerName`, `c_DateOfBirth`, `c_Identification`, `c_AccountNumber`, `c_ProductID`, `c_ConsumerID`, `c_FirstName`, `c_Surname`, `c_OtherNames`, `c_Address`, `c_BirthDate`, `c_AccountNo`, `c_DriversLicenseNo`, `c_VoterID`, `c_user_id`, `c_created`, `c_status`, `c_bureau`, `c_EnquiryEngineID`, `c_enquiryID`, `c_consumerMergeList`, `c_MatchingEngineID`, `c_Reference`, `c_MatchingRate`) VALUES
  128. (1, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147529', 'C5835484-9928562', 90),
  129. (2, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147465', 'C5835484-9928562', 90),
  130. (3, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147464', 'C5835484-9928562', 90),
  131. (4, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147494', 'C5835484-9928562', 90),
  132. (5, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147506', 'C5835484-9928562', 90),
  133. (6, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147536', 'C5835484-9928562', 90),
  134. (7, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147518', 'C5835484-9928562', 90),
  135. (8, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147470', 'C5835484-9928562', 90),
  136. (9, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147482', 'C5835484-9928562', 90),
  137. (10, '97C00D5CD080BCBD1717DFFEB9DAE9057923E132A3457161D1EC939ECD250EA1987DF1D33F3C8028EA09209EFDE06BE503544D1EE4296B19521E648C6245E9DB768A1322D3CED4D49E18E165912B9B258344F2A412F7084479D835C8BEB9C52BEFE9B62A404789574119451956819DB8CD54CB3CB71A1150B1F3708A1D70131D4A2D7D5D8A64ADE0F8F979660E49B60E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-22 23:46:55', 1, 1, 0, 5835484, '', '3760147530', 'C5835484-9928562', 90),
  138. (11, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147564', 'C5835490-9928562', 90),
  139. (12, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147605', 'C5835490-9928562', 90),
  140. (13, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147629', 'C5835490-9928562', 90),
  141. (14, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147569', 'C5835490-9928562', 90),
  142. (15, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147563', 'C5835490-9928562', 90),
  143. (16, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147635', 'C5835490-9928562', 90),
  144. (17, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147628', 'C5835490-9928562', 90),
  145. (18, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147581', 'C5835490-9928562', 90),
  146. (19, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147617', 'C5835490-9928562', 90),
  147. (20, 'D624ABE0FEA009273040804CD953CB6A5A526DB66DB2586DE971226E5A253F5BAA2CFFAF913C1266DA95AEAF35C85C951236CE4698DA196ECF0537A344461274CF349F5579B7086F1331B0391DCCD438E41CC5EE80AD3399FFFE0C282FCD990B291C4A69CDC304AF0FD32D45C859DC32C533991C11388ABD529F6AA83E76BDD86485562827378C6BC172D52BACF8A127', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-22 23:47:01', 1, 1, 0, 5835490, '', '3760147593', 'C5835490-9928562', 90),
  148. (21, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184462', 'C5838699-9928562', 90),
  149. (22, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184414', 'C5838699-9928562', 90),
  150. (23, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184461', 'C5838699-9928562', 90),
  151. (24, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184402', 'C5838699-9928562', 90),
  152. (25, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184397', 'C5838699-9928562', 90),
  153. (26, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184468', 'C5838699-9928562', 90),
  154. (27, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184450', 'C5838699-9928562', 90),
  155. (28, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184438', 'C5838699-9928562', 90),
  156. (29, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184396', 'C5838699-9928562', 90),
  157. (30, 'ADFF640E0C23E559B35624D9084466FEB87E533C72AF252BD43B7FB6F6F713B398FBA75B7DE127310AC2820AB6E61CC461C20D48A7276A4FDF27DC4817DDF2681EEDC5238F418C4CE588376DCB9A82CB645753A4B6CD14E75FAFF74CD9D7AA9DC3CF6428E6FBEF76643074DC8505C765D9723CA099D5A0FDAC1E6C329F1B20E5C86FB8402073DAEB5F5A5A48A229AB8C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 01:07:06', 1, 1, 0, 5838699, '', '3760184426', 'C5838699-9928562', 90),
  158. (31, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184694', 'C5838771-9928562', 90),
  159. (32, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184699', 'C5838771-9928562', 90),
  160. (33, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184765', 'C5838771-9928562', 90),
  161. (34, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184723', 'C5838771-9928562', 90),
  162. (35, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184735', 'C5838771-9928562', 90),
  163. (36, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184711', 'C5838771-9928562', 90),
  164. (37, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184758', 'C5838771-9928562', 90),
  165. (38, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184759', 'C5838771-9928562', 90),
  166. (39, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184693', 'C5838771-9928562', 90),
  167. (40, '0F8D5E2A52DD73E9ACAED29AB5302F7D84AC2F87C5AC5970E2976C07F873029124FC9E715D3E0A39AC3EFC68378BDB331A961A820633376214BBF966B2E037155CA77FFA0EA73F1CE71619EBEC5C242A75D7D94F3CF70AFF5AFE619F3E53298DC7700A9E05C752CB14F34491BEC260D610433B83622DA852308A4DD9C5467F0362547432ACF0E052C49E018B4A30B999', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 01:08:51', 1, 1, 0, 5838771, '', '3760184747', 'C5838771-9928562', 90),
  168. (41, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185145', 'C5838882-9928562', 90),
  169. (42, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185204', 'C5838882-9928562', 90),
  170. (43, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185157', 'C5838882-9928562', 90),
  171. (44, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185181', 'C5838882-9928562', 90),
  172. (45, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185211', 'C5838882-9928562', 90),
  173. (46, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185193', 'C5838882-9928562', 90),
  174. (47, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185139', 'C5838882-9928562', 90),
  175. (48, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185169', 'C5838882-9928562', 90),
  176. (49, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185140', 'C5838882-9928562', 90),
  177. (50, 'E7873580652CE92B3795B4B737ED05FF5F04A9F1F3B82412DDF25C0EBA85D499593F3C5D5A4DE818CFC4048E83D55EF447831BC22752478C7254B8E9526261A00F7936F290325F91B5C49614E502E4AA747D9E86B336256B86A9155A0DD41DE587F793999749138D46894A268429AD0450716A1B94B58823BD845A304B3CE67E729BF061DBC8970C33622899969CBEF1', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 01:11:27', 1, 1, 0, 5838882, '', '3760185205', 'C5838882-9928562', 90),
  178. (51, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261285', 'C5852580-9928562', 90),
  179. (52, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261326', 'C5852580-9928562', 90),
  180. (53, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261356', 'C5852580-9928562', 90),
  181. (54, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261349', 'C5852580-9928562', 90),
  182. (55, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261314', 'C5852580-9928562', 90),
  183. (56, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261290', 'C5852580-9928562', 90),
  184. (57, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261338', 'C5852580-9928562', 90),
  185. (58, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261350', 'C5852580-9928562', 90),
  186. (59, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261284', 'C5852580-9928562', 90),
  187. (60, 'EEE3C2BA17963ECC1BE12DD915BA6FA01245C90CDFA7DD553ACB4B10093542620E11863FD29BBE31390C106A5918A06FDDAED84906F4D10AAC410EE94F6F261332964FCC596E7BB25FA9A099B6004D5B483BFD5A9879EC5971457D1144E11141B9DBBB212FB6BD94E67F5F48A4268B5AD6BC495F6E1E3F68B5BA33EB5C0E5F7F33FA104426F480A0FDF8D136621EB12A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 06:48:49', 1, 1, 0, 5852580, '', '3760261302', 'C5852580-9928562', 90),
  188. (61, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841231', 'C5864549-9928562', 90),
  189. (62, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841184', 'C5864549-9928562', 90),
  190. (63, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841167', 'C5864549-9928562', 90),
  191. (64, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841238', 'C5864549-9928562', 90),
  192. (65, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841166', 'C5864549-9928562', 90),
  193. (66, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841232', 'C5864549-9928562', 90),
  194. (67, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841208', 'C5864549-9928562', 90),
  195. (68, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841220', 'C5864549-9928562', 90),
  196. (69, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841172', 'C5864549-9928562', 90),
  197. (70, '45DF5D41BC4952FA493972FD2E03AB48C15039F40319040A3BEE1539D928787F43317B7D2AE6C5AFA044E2DB4F8FF78C23F9B1F16D2E1686A727365DDF738555CE716C791759FBB8FFDFD8DD2ADFE0F32AEFBF459F37BD533FC4E831FF5DA5FCAFB02F590DF7C454922C330E53C3D55FAA5B87D82FF1C1DD6827456355456066478B1A0E25983A26404BCE39BF9B4C1F', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 11:49:56', 1, 1, 0, 5864549, '', '3760841196', 'C5864549-9928562', 90),
  198. (71, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841583', 'C5864632-9928562', 90),
  199. (72, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841589', 'C5864632-9928562', 90),
  200. (73, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841518', 'C5864632-9928562', 90),
  201. (74, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841582', 'C5864632-9928562', 90),
  202. (75, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841559', 'C5864632-9928562', 90),
  203. (76, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841523', 'C5864632-9928562', 90),
  204. (77, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841571', 'C5864632-9928562', 90),
  205. (78, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841547', 'C5864632-9928562', 90),
  206. (79, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841517', 'C5864632-9928562', 90),
  207. (80, '5EF072DAE81567113C7AD01D2B8313EBDE5F0A3FEA1DFE215B4497699B96F6046C02AFF8AD0D7FAA6A17D2D2E6FCAE360B3DA9F4DC2B2391C4BC2B16842A7B1FCBA7E0F7B2B0B2F66347FC9B2C0FCF0098CD8DC544187231705C6E617F2382ADA34C112E592220A9C7DF97EF5700637560720FA690ED782498490B9B7B09E656D75D3C4D2C343AB7C0AE49FF7C09B51C', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 11:52:00', 1, 1, 0, 5864632, '', '3760841535', 'C5864632-9928562', 90),
  208. (81, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841855', 'C5864712-9928562', 90),
  209. (82, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841920', 'C5864712-9928562', 90),
  210. (83, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841908', 'C5864712-9928562', 90),
  211. (84, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841854', 'C5864712-9928562', 90),
  212. (85, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841860', 'C5864712-9928562', 90),
  213. (86, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841884', 'C5864712-9928562', 90),
  214. (87, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841872', 'C5864712-9928562', 90);
  215. INSERT INTO `creditreport` (`c_id`, `c_DataTicket`, `c_bvn`, `c_EnquiryReason`, `c_ConsumerName`, `c_DateOfBirth`, `c_Identification`, `c_AccountNumber`, `c_ProductID`, `c_ConsumerID`, `c_FirstName`, `c_Surname`, `c_OtherNames`, `c_Address`, `c_BirthDate`, `c_AccountNo`, `c_DriversLicenseNo`, `c_VoterID`, `c_user_id`, `c_created`, `c_status`, `c_bureau`, `c_EnquiryEngineID`, `c_enquiryID`, `c_consumerMergeList`, `c_MatchingEngineID`, `c_Reference`, `c_MatchingRate`) VALUES
  216. (88, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841919', 'C5864712-9928562', 90),
  217. (89, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841896', 'C5864712-9928562', 90),
  218. (90, 'A0BB4D37AB16C11D746F5CC25F8E835407B7C2A843267FC763B1B149FCABD61AA739F7F20462B0BCE1E3781B607BA1E8FD1D7F91708EDA20959464BD01E40516D8B54788A6DBF4C8F212E5C54EEB468FB34992B4FF0882F7B535B21A320E85A9BCAD5836B010F6B3C9675E62449D68179C92F621A5868E98B422670B4D06F4E6A32D285F662B39E9A41153F0EF6BD63E', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 11:54:03', 1, 1, 0, 5864712, '', '3760841926', 'C5864712-9928562', 90),
  219. (91, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842185', 'C5864778-9928562', 90),
  220. (92, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842197', 'C5864778-9928562', 90),
  221. (93, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842131', 'C5864778-9928562', 90),
  222. (94, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842173', 'C5864778-9928562', 90),
  223. (95, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842196', 'C5864778-9928562', 90),
  224. (96, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842137', 'C5864778-9928562', 90),
  225. (97, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842149', 'C5864778-9928562', 90),
  226. (98, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842161', 'C5864778-9928562', 90),
  227. (99, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842132', 'C5864778-9928562', 90),
  228. (100, '9A8E00E37A0948D479D2914EC790F79B31350B96533B2FADDF527953AF7F086699B88FDD365E43FE888BB5BED7A7C98E9E869D900665C459C2D734006C35162EB5C9B7990293401B284F6CB8C6ACBB580009BD8FE1E6C9A4FAB8B9DAEE127EFB5C96BE11326777AFECE2015C6240841C5A93DBAF24DF59536190BEBF052B165B2E008540A1EFE97CAFC0B6FA7FB08CBF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 11:55:51', 1, 1, 0, 5864778, '', '3760842203', 'C5864778-9928562', 90),
  229. (101, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 12:00:37', 1, 1, 0, 5864958, '', '3760843111', 'C5864958-9928562', 90),
  230. (102, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843183', 'C5864958-9928562', 90),
  231. (103, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843165', 'C5864958-9928562', 90),
  232. (104, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843141', 'C5864958-9928562', 90),
  233. (105, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843117', 'C5864958-9928562', 90),
  234. (106, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843153', 'C5864958-9928562', 90),
  235. (107, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843129', 'C5864958-9928562', 90),
  236. (108, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843177', 'C5864958-9928562', 90),
  237. (109, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843176', 'C5864958-9928562', 90),
  238. (110, 'A07336B9A871AEC39E894432045FE9BD5FD89518D0A62946453F86CF70FEFEC0A191EE3343CE3833461D695160241C2D4FFB199A30E44109262D7B4250BE469D1DB274BA483B098AF5F8AF9D83834FF90DC6874313F4FF44BDC1670EDA8AFBC321BC2945D2146A9B0CB00724A2381BFEE5C20A8735C073D86DE1BCAA1C40ED2C71ADCEED5066556A25F2DF159989E195', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 12:00:38', 1, 1, 0, 5864958, '', '3760843112', 'C5864958-9928562', 90),
  239. (111, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853814', 'C5865347-9928562', 90),
  240. (112, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853749', 'C5865347-9928562', 90),
  241. (113, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853748', 'C5865347-9928562', 90),
  242. (114, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853754', 'C5865347-9928562', 90),
  243. (115, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853766', 'C5865347-9928562', 90),
  244. (116, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853820', 'C5865347-9928562', 90),
  245. (117, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853778', 'C5865347-9928562', 90),
  246. (118, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853813', 'C5865347-9928562', 90),
  247. (119, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853790', 'C5865347-9928562', 90),
  248. (120, '3C44220032C1D8DE002BCBFC730B74E5AE09810E346D58DB4D6D1550AE65616AE1752E95495896BD01880D335302CA2852B08DAFCD09C749586BF634B7C2031E11F7FCEBFB833CC859E02298FC3741270CBE34B8BBD4BDAAE33C4010B4EA5E487D2496B610F36139B9BCF2B6FEA6C48F3EC61046B505C75E22D5D10DD92EC4E72E80287C71CC53E15D82409EC3C73E9A', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 12:10:08', 1, 1, 0, 5865347, '', '3760853802', 'C5865347-9928562', 90),
  249. (121, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853882', 'C5865365-9928562', 90),
  250. (122, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853935', 'C5865365-9928562', 90),
  251. (123, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853953', 'C5865365-9928562', 90),
  252. (124, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853887', 'C5865365-9928562', 90),
  253. (125, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853899', 'C5865365-9928562', 90),
  254. (126, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853911', 'C5865365-9928562', 90),
  255. (127, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853923', 'C5865365-9928562', 90),
  256. (128, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853947', 'C5865365-9928562', 90),
  257. (129, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853881', 'C5865365-9928562', 90),
  258. (130, '2AFA8DAF68E32F29678E9B09FF8CFA8AD9D85E42010218566FB8356D156A7F9EF07991B096A36CDF80EA933D192C38C674D8899AE3A00F58B01BBA41AF027B058DBC1A5F81E26C602C5610D59F0E46EA0764148563B4BE574A654D3E502D4EC3728E836070F6508DE181CF3B9519ECEA4A3265F06E1BDC1AF8B98B5542DBBD36B345A854C218F24DDBEBE9A20D5F188D', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 12:10:34', 1, 1, 0, 5865365, '', '3760853946', 'C5865365-9928562', 90),
  259. (131, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312750', 'C5872647-9928562', 90),
  260. (132, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312749', 'C5872647-9928562', 90),
  261. (133, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312767', 'C5872647-9928562', 90),
  262. (134, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312755', 'C5872647-9928562', 90),
  263. (135, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312803', 'C5872647-9928562', 90),
  264. (136, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312815', 'C5872647-9928562', 90),
  265. (137, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312779', 'C5872647-9928562', 90),
  266. (138, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312821', 'C5872647-9928562', 90),
  267. (139, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312814', 'C5872647-9928562', 90),
  268. (140, 'BFB80E4F435B1EDD50A45FF60C0B7D1DADF5A56B1D4C4E44BA20B768547AEB3871D13C00DA7273187C39A62A8324B58100D84B7532A4F5B733FE3940F0302088ADD7306C3DDFBF9AFB9FD02293A3E48B8FEC7CB4B9E339477BDB697B117092C009C532298003D3702BD00DFC25970B20BE180676A274C82A5FE08D21109ACDAEA1B5E2A3DFFD3804703C3DB96C3805BF', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-23 15:12:59', 1, 1, 0, 5872647, '', '3761312791', 'C5872647-9928562', 90),
  269. (141, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302623307672', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888079', 'C5892158-9928562', 90),
  270. (142, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302055066', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888043', 'C5892158-9928562', 90),
  271. (143, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104452330010001000', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888014', 'C5892158-9928562', 90),
  272. (144, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301961606594', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888019', 'C5892158-9928562', 90),
  273. (145, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302190470', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888055', 'C5892158-9928562', 90),
  274. (146, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '049104441410010001000', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888013', 'C5892158-9928562', 90),
  275. (147, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302249149', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888067', 'C5892158-9928562', 90),
  276. (148, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '301965377', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888031', 'C5892158-9928562', 90),
  277. (149, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302905402', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888085', 'C5892158-9928562', 90),
  278. (150, '098FAF3C521DB615A8B3AFD94EFE22FF989BD161D1658726FC136B05758AAB8BD291ED0DA547BDCDA2ED74FCB1EB6DE27E7D5A684E6D3ED8E60EBFC353BC65B9EC9535E49F7F0B5373314C2CD7AF739DC4E9E454E1857F5F0A0AE6A46668F063E6FBB2C9FCC29B6C3E87C7D3F3118879898BC85983C5B0BE3EA6EB9A95DB3A8465DACA39DB65F8D1A0E6BEFA0CE945E2', '22168191802', 'Test', '', '', '22168191802', '', 45, 9928562, 'MOFEHINTOLU', 'OLAOGUN', 'FUNSO', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '1985-11-19', '302389214', '', '', 2, '2019-02-24 02:12:52', 1, 1, 0, 5892158, '', '3761888078', 'C5892158-9928562', 90);
  279.  
  280. -- --------------------------------------------------------
  281.  
  282. --
  283. -- Table structure for table `customer`
  284. --
  285.  
  286. CREATE TABLE `customer` (
  287. `customer_id` int(11) NOT NULL,
  288. `customer_user_id` int(11) NOT NULL,
  289. `customer_code` varchar(100) NOT NULL,
  290. `customer_first_name` varchar(100) DEFAULT NULL,
  291. `customer_last_name` varchar(100) DEFAULT NULL,
  292. `customer_email` varchar(100) NOT NULL,
  293. `customer_created` int(11) NOT NULL
  294. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  295.  
  296. --
  297. -- Dumping data for table `customer`
  298. --
  299.  
  300. INSERT INTO `customer` (`customer_id`, `customer_user_id`, `customer_code`, `customer_first_name`, `customer_last_name`, `customer_email`, `customer_created`) VALUES
  301. (1, 2, 'CUS_vgzbzm4ndw4d03m', '', '', 'akhmadharuna@gmail.com', 1550935910),
  302. (2, 2, 'CUS_vgzbzm4ndw4d03m', '', '', 'akhmadharuna@gmail.com', 1550975889);
  303.  
  304. -- --------------------------------------------------------
  305.  
  306. --
  307. -- Table structure for table `employment_type`
  308. --
  309.  
  310. CREATE TABLE `employment_type` (
  311. `employment_type_id` int(11) NOT NULL,
  312. `employment_type_name` varchar(100) NOT NULL
  313. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  314.  
  315. --
  316. -- Dumping data for table `employment_type`
  317. --
  318.  
  319. INSERT INTO `employment_type` (`employment_type_id`, `employment_type_name`) VALUES
  320. (1, 'Permanent'),
  321. (2, 'Contract');
  322.  
  323. -- --------------------------------------------------------
  324.  
  325. --
  326. -- Table structure for table `files`
  327. --
  328.  
  329. CREATE TABLE `files` (
  330. `file_id` int(11) NOT NULL,
  331. `file_name` varchar(100) NOT NULL,
  332. `file_path` varchar(300) NOT NULL,
  333. `file_user_id` int(11) NOT NULL,
  334. `file_created` int(11) NOT NULL,
  335. `file_type` int(11) DEFAULT NULL,
  336. `file_size` int(11) DEFAULT NULL
  337. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  338.  
  339. --
  340. -- Dumping data for table `files`
  341. --
  342.  
  343. INSERT INTO `files` (`file_id`, `file_name`, `file_path`, `file_user_id`, `file_created`, `file_type`, `file_size`) VALUES
  344. (1, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  345. (2, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  346. (3, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  347. (4, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  348. (5, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  349. (6, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  350. (7, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  351. (8, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  352. (9, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  353. (10, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  354. (11, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597);
  355.  
  356. -- --------------------------------------------------------
  357.  
  358. --
  359. -- Table structure for table `loans`
  360. --
  361.  
  362. CREATE TABLE `loans` (
  363. `id` int(11) NOT NULL,
  364. `user_id` varchar(45) NOT NULL,
  365. `loan_amount` double DEFAULT NULL,
  366. `interest_rate` int(11) DEFAULT NULL,
  367. `created_at` datetime DEFAULT NULL,
  368. `updated_at` datetime DEFAULT NULL
  369. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  370.  
  371. -- --------------------------------------------------------
  372.  
  373. --
  374. -- Table structure for table `loan_repayment`
  375. --
  376.  
  377. CREATE TABLE `loan_repayment` (
  378. `id` int(11) NOT NULL,
  379. `loan_id` int(11) NOT NULL,
  380. `amount` decimal(15,2) NOT NULL,
  381. `due_date` datetime NOT NULL,
  382. `created_at` datetime DEFAULT NULL,
  383. `updated_at` datetime DEFAULT NULL
  384. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  385.  
  386. -- --------------------------------------------------------
  387.  
  388. --
  389. -- Table structure for table `merchants`
  390. --
  391.  
  392. CREATE TABLE `merchants` (
  393. `id` int(10) UNSIGNED NOT NULL,
  394. `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  395. `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  396. `email_verified_at` timestamp NULL DEFAULT NULL,
  397. `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  398. `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  399. `created_at` timestamp NULL DEFAULT NULL,
  400. `updated_at` timestamp NULL DEFAULT NULL
  401. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  402.  
  403. -- --------------------------------------------------------
  404.  
  405. --
  406. -- Table structure for table `migrations`
  407. --
  408.  
  409. CREATE TABLE `migrations` (
  410. `id` int(10) UNSIGNED NOT NULL,
  411. `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  412. `batch` int(11) NOT NULL
  413. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  414.  
  415. -- --------------------------------------------------------
  416.  
  417. --
  418. -- Table structure for table `oauth_access_tokens`
  419. --
  420.  
  421. CREATE TABLE `oauth_access_tokens` (
  422. `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  423. `user_id` int(11) DEFAULT NULL,
  424. `client_id` int(10) UNSIGNED NOT NULL,
  425. `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  426. `scopes` text COLLATE utf8mb4_unicode_ci,
  427. `revoked` tinyint(1) NOT NULL,
  428. `created_at` timestamp NULL DEFAULT NULL,
  429. `updated_at` timestamp NULL DEFAULT NULL,
  430. `expires_at` datetime DEFAULT NULL
  431. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  432.  
  433. --
  434. -- Dumping data for table `oauth_access_tokens`
  435. --
  436.  
  437. INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
  438. ('2a1f2a69405ad48600cbab9d6ea174b7617327a0c551e674cd025556ed6641995102273bd909a7b4', 1, 2, NULL, '[]', 0, '2019-02-16 21:04:42', '2019-02-16 21:04:42', '2020-02-16 22:04:42'),
  439. ('3703b4a7b056a25f9b8d40f93d7a4e68a9a4e78cbe83339a64e1018d0515bb3ab7207942ae0504ec', 1, 2, NULL, '[]', 0, '2019-02-16 21:34:46', '2019-02-16 21:34:46', '2020-02-16 22:34:46'),
  440. ('4c799d65967394eab60cec6834f816288a481a7e14f65ba201949c3274f132831c82c062e2c3bd40', 1, 2, NULL, '[]', 0, '2019-02-16 21:04:11', '2019-02-16 21:04:11', '2020-02-16 22:04:11'),
  441. ('55ccbd87b702f4033eac4fbaaed7e2dd3fc12e29941c7c1edbe09e294baaa3e0e9c53e6fe7cb6f8b', 1, 2, NULL, '[]', 0, '2019-01-18 09:56:25', '2019-01-18 09:56:25', '2020-01-18 10:56:25'),
  442. ('600aed471d17342ccb4ea0613f4e2332bdb2185eb1a7d9788f86494cdbc9e98e53749b515ec79099', 1, 2, NULL, '[]', 0, '2019-02-13 14:24:58', '2019-02-13 14:24:58', '2020-02-13 15:24:58'),
  443. ('8495322abb587af275fb6a35b048a8138687d9d862ee6462018bc683182d3e3e3120a5faa6696368', 1, 2, NULL, '[]', 0, '2019-01-18 12:46:06', '2019-01-18 12:46:06', '2020-01-18 13:46:06'),
  444. ('a5808fb307ba51ff299d36e3a4166bc58c4e0377e1d6f08630389cd025b8ac0e1238194f54ce7575', 1, 1, 'MyApp', '[]', 0, '2019-01-18 09:37:30', '2019-01-18 09:37:30', '2020-01-18 10:37:30'),
  445. ('b7a872010610ccf4a3043d84cbd8aa06b6c65957c11e63bc4e1152229380745f3a6c9dbad5310c0c', 1, 2, NULL, '[]', 0, '2019-01-18 11:24:34', '2019-01-18 11:24:34', '2020-01-18 12:24:34');
  446.  
  447. -- --------------------------------------------------------
  448.  
  449. --
  450. -- Table structure for table `oauth_auth_codes`
  451. --
  452.  
  453. CREATE TABLE `oauth_auth_codes` (
  454. `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  455. `user_id` int(11) NOT NULL,
  456. `client_id` int(10) UNSIGNED NOT NULL,
  457. `scopes` text COLLATE utf8mb4_unicode_ci,
  458. `revoked` tinyint(1) NOT NULL,
  459. `expires_at` datetime DEFAULT NULL
  460. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  461.  
  462. -- --------------------------------------------------------
  463.  
  464. --
  465. -- Table structure for table `oauth_clients`
  466. --
  467.  
  468. CREATE TABLE `oauth_clients` (
  469. `id` int(10) UNSIGNED NOT NULL,
  470. `user_id` int(11) DEFAULT NULL,
  471. `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  472. `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  473. `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  474. `personal_access_client` tinyint(1) NOT NULL,
  475. `password_client` tinyint(1) NOT NULL,
  476. `revoked` tinyint(1) NOT NULL,
  477. `created_at` timestamp NULL DEFAULT NULL,
  478. `updated_at` timestamp NULL DEFAULT NULL
  479. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  480.  
  481. --
  482. -- Dumping data for table `oauth_clients`
  483. --
  484.  
  485. INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
  486. (1, NULL, 'Laravel Personal Access Client', 'l9GG8i1DgBkXZ4NVeECufEqYo56pxQvLJemzE8n4', 'http://localhost', 1, 0, 0, '2019-01-18 08:45:23', '2019-01-18 08:45:23'),
  487. (2, NULL, 'Laravel Password Grant Client', 'nUDByv10tmMjuKCeVL0DqMPJbPIGE41Rmt7dfqIt', 'http://localhost', 0, 1, 0, '2019-01-18 08:45:24', '2019-01-18 08:45:24'),
  488. (3, NULL, 'Laravel Personal Access Client', 'HX1XEJdFKhE9tnpNwYuwLUZhpE3UbzpNTn2ot9t4', 'http://localhost', 1, 0, 0, '2019-02-16 21:03:51', '2019-02-16 21:03:51'),
  489. (4, NULL, 'Laravel Password Grant Client', 'ZypKOzbyO6AowtVwKNoyXR4o2dcqcSMMnDngA1MG', 'http://localhost', 0, 1, 0, '2019-02-16 21:03:51', '2019-02-16 21:03:51');
  490.  
  491. -- --------------------------------------------------------
  492.  
  493. --
  494. -- Table structure for table `oauth_personal_access_clients`
  495. --
  496.  
  497. CREATE TABLE `oauth_personal_access_clients` (
  498. `id` int(10) UNSIGNED NOT NULL,
  499. `client_id` int(10) UNSIGNED NOT NULL,
  500. `created_at` timestamp NULL DEFAULT NULL,
  501. `updated_at` timestamp NULL DEFAULT NULL
  502. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  503.  
  504. --
  505. -- Dumping data for table `oauth_personal_access_clients`
  506. --
  507.  
  508. INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
  509. (1, 1, '2019-01-18 08:45:24', '2019-01-18 08:45:24'),
  510. (2, 3, '2019-02-16 21:03:51', '2019-02-16 21:03:51');
  511.  
  512. -- --------------------------------------------------------
  513.  
  514. --
  515. -- Table structure for table `oauth_refresh_tokens`
  516. --
  517.  
  518. CREATE TABLE `oauth_refresh_tokens` (
  519. `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  520. `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  521. `revoked` tinyint(1) NOT NULL,
  522. `expires_at` datetime DEFAULT NULL
  523. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  524.  
  525. --
  526. -- Dumping data for table `oauth_refresh_tokens`
  527. --
  528.  
  529. INSERT INTO `oauth_refresh_tokens` (`id`, `access_token_id`, `revoked`, `expires_at`) VALUES
  530. ('0837f44defe78c5b4ec80380fe2131f9af3ee9c27e786ee97a25a3d6eecaa1f428990ea48cdd86bb', '55ccbd87b702f4033eac4fbaaed7e2dd3fc12e29941c7c1edbe09e294baaa3e0e9c53e6fe7cb6f8b', 0, '2020-01-18 10:56:25'),
  531. ('1227de138e4d6186896231b2cdfe5bd4d51cf4bd53058fb7229b3825de70e60fd62a32766179970d', '600aed471d17342ccb4ea0613f4e2332bdb2185eb1a7d9788f86494cdbc9e98e53749b515ec79099', 0, '2020-02-13 15:24:58'),
  532. ('1d03a5d5b7673bfef19a25fda1b644f021b957d3e442c2f1d13a20bb47fd19d43eb56b144fc2663f', '8495322abb587af275fb6a35b048a8138687d9d862ee6462018bc683182d3e3e3120a5faa6696368', 0, '2020-01-18 13:46:06'),
  533. ('545901a7f467de90ada1d37091ff3d35d3110f82420152e02da1d502d7803ac670fed35645832342', '4c799d65967394eab60cec6834f816288a481a7e14f65ba201949c3274f132831c82c062e2c3bd40', 0, '2020-02-16 22:04:11'),
  534. ('69809554d4c5fb7ab79becd020124355478ead47a8d7b2f6156ce88a5e247d8402298bcb6bd2469c', 'b7a872010610ccf4a3043d84cbd8aa06b6c65957c11e63bc4e1152229380745f3a6c9dbad5310c0c', 0, '2020-01-18 12:24:34'),
  535. ('7202604fd994a6fe8eb0898cadedcd491b8c6f8dab9ebc34ad904e44df9899e499eefc77553a9f99', '3703b4a7b056a25f9b8d40f93d7a4e68a9a4e78cbe83339a64e1018d0515bb3ab7207942ae0504ec', 0, '2020-02-16 22:34:46'),
  536. ('f09f30089fae4a06ba08d9d04288b66fbf2b591ebed9e35e878d1a4f7f3d20648e5712d9150c8f4d', '2a1f2a69405ad48600cbab9d6ea174b7617327a0c551e674cd025556ed6641995102273bd909a7b4', 0, '2020-02-16 22:04:42');
  537.  
  538. -- --------------------------------------------------------
  539.  
  540. --
  541. -- Table structure for table `password_resets`
  542. --
  543.  
  544. CREATE TABLE `password_resets` (
  545. `email` varchar(255) NOT NULL,
  546. `token` varchar(255) NOT NULL,
  547. `created_at` timestamp NULL DEFAULT NULL
  548. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  549.  
  550. -- --------------------------------------------------------
  551.  
  552. --
  553. -- Table structure for table `repayment`
  554. --
  555.  
  556. CREATE TABLE `repayment` (
  557. `repayment_id` int(11) NOT NULL,
  558. `repayment_order_id` int(11) NOT NULL,
  559. `repayment_date` int(11) NOT NULL,
  560. `repayment_amount` int(11) NOT NULL,
  561. `repayment_method` int(11) NOT NULL,
  562. `repayment_status` int(11) NOT NULL DEFAULT '0',
  563. `repayment_transaction_id` int(11) DEFAULT NULL,
  564. `repayment_equity` int(11) NOT NULL DEFAULT '0'
  565. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  566.  
  567. -- --------------------------------------------------------
  568.  
  569. --
  570. -- Table structure for table `repayment_log`
  571. --
  572.  
  573. CREATE TABLE `repayment_log` (
  574. `rl_id` int(11) NOT NULL,
  575. `rl_rs_id` int(11) DEFAULT NULL,
  576. `rl_order_id` int(11) DEFAULT NULL,
  577. `rl_title` varchar(100) NOT NULL,
  578. `rl_amount` int(11) NOT NULL,
  579. `rl_status` int(11) NOT NULL DEFAULT '0',
  580. `rl_due_date` date DEFAULT NULL,
  581. `rl_payment_date` int(11) DEFAULT NULL,
  582. `rl_userid` int(11) NOT NULL DEFAULT '0',
  583. `rl_cron` varchar(255) DEFAULT NULL
  584. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  585.  
  586. -- --------------------------------------------------------
  587.  
  588. --
  589. -- Table structure for table `retailers`
  590. --
  591.  
  592. CREATE TABLE `retailers` (
  593. `ret_id` int(11) NOT NULL,
  594. `ret_fname` varchar(100) NOT NULL,
  595. `ret_lname` varchar(100) NOT NULL,
  596. `ret_email` varchar(100) NOT NULL,
  597. `ret_phone` varchar(100) NOT NULL,
  598. `ret_website` varchar(100) NOT NULL,
  599. `ret_order` varchar(225) NOT NULL,
  600. `ret_sale` varchar(225) NOT NULL,
  601. `ret_platform` varchar(225) NOT NULL,
  602. `ret_created` datetime NOT NULL,
  603. `ret_updated` datetime NOT NULL,
  604. `ret_status` int(11) NOT NULL
  605. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  606.  
  607. -- --------------------------------------------------------
  608.  
  609. --
  610. -- Table structure for table `transaction`
  611. --
  612.  
  613. CREATE TABLE `transaction` (
  614. `transaction_id` int(11) NOT NULL,
  615. `transaction_amount` float(11,2) NOT NULL,
  616. `transaction_ref` varchar(20) DEFAULT NULL,
  617. `transaction_user_id` int(11) NOT NULL,
  618. `transaction_time` int(11) NOT NULL,
  619. `transactionid` varchar(100) NOT NULL,
  620. `transaction_reference` varchar(100) DEFAULT NULL,
  621. `transaction_mobile` varchar(100) DEFAULT NULL,
  622. `transaction_authorization_code` varchar(100) DEFAULT NULL,
  623. `transaction_card_type` varchar(100) DEFAULT NULL,
  624. `transaction_last4` varchar(100) DEFAULT NULL,
  625. `transaction_exp_month` varchar(100) DEFAULT NULL,
  626. `transaction_exp_year` varchar(100) DEFAULT NULL,
  627. `transaction_reusable` varchar(100) DEFAULT NULL,
  628. `transaction_country_code` varchar(100) DEFAULT NULL,
  629. `transaction_ip_address` varchar(100) DEFAULT NULL,
  630. `transaction_customer_id` varchar(100) DEFAULT NULL,
  631. `transaction_customer_code` varchar(100) DEFAULT NULL,
  632. `transaction_first_name` varchar(100) DEFAULT NULL,
  633. `transaction_last_name` varchar(100) DEFAULT NULL,
  634. `transaction_email` varchar(100) DEFAULT NULL,
  635. `transaction_bank` varchar(100) NOT NULL
  636. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  637.  
  638. --
  639. -- Dumping data for table `transaction`
  640. --
  641.  
  642. INSERT INTO `transaction` (`transaction_id`, `transaction_amount`, `transaction_ref`, `transaction_user_id`, `transaction_time`, `transactionid`, `transaction_reference`, `transaction_mobile`, `transaction_authorization_code`, `transaction_card_type`, `transaction_last4`, `transaction_exp_month`, `transaction_exp_year`, `transaction_reusable`, `transaction_country_code`, `transaction_ip_address`, `transaction_customer_id`, `transaction_customer_code`, `transaction_first_name`, `transaction_last_name`, `transaction_email`, `transaction_bank`) VALUES
  643. (1, 100.00, 'Success', 2, 1550935910, 'T972009722089349', 'T972009722089349', '0', 'AUTH_j0jiomie9d', 'visa DEBIT', '4081', '12', '2020', '1', 'NG', '129.56.85.62', '6414658', 'CUS_vgzbzm4ndw4d03m', '', '', 'akhmadharuna@gmail.com', 'Test Bank'),
  644. (2, 100.00, 'Success', 2, 1550975889, 'T804668138387713', 'T804668138387713', '0', 'AUTH_glwwxdq8ji', 'visa DEBIT', '4081', '12', '2020', '1', 'NG', '129.56.51.17', '6414658', 'CUS_vgzbzm4ndw4d03m', '', '', 'akhmadharuna@gmail.com', 'Test Bank');
  645.  
  646. -- --------------------------------------------------------
  647.  
  648. --
  649. -- Table structure for table `users`
  650. --
  651.  
  652. CREATE TABLE `users` (
  653. `id` int(10) UNSIGNED NOT NULL,
  654. `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  655. `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  656. `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  657. `password` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  658. `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  659. `created_at` date DEFAULT NULL,
  660. `updated_at` date DEFAULT NULL,
  661. `user_form_status` int(1) NOT NULL DEFAULT '0',
  662. `user_status` int(1) NOT NULL DEFAULT '0',
  663. `verification_option` int(11) DEFAULT NULL,
  664. `otp` int(6) NOT NULL,
  665. `order_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  666. `paystack_token` int(11) DEFAULT NULL,
  667. `cron` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  668. `bvn` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  669. `ref_code` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  670. `destination` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  671. `bank_status` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  672. `reset_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  673. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  674.  
  675. --
  676. -- Dumping data for table `users`
  677. --
  678.  
  679. INSERT INTO `users` (`id`, `name`, `email`, `phone`, `password`, `remember_token`, `created_at`, `updated_at`, `user_form_status`, `user_status`, `verification_option`, `otp`, `order_token`, `paystack_token`, `cron`, `bvn`, `ref_code`, `destination`, `bank_status`, `reset_token`) VALUES
  680. (2, 'Haruna Ahmadu', 'akhmadharuna@gmail.com', '7034776388', '$2y$10$4e3ztXBCrDCVfnUXbBFXqeEx4/UGiCXYMcFgk3ydBJBs4IWa/q01W', 'MeYuYeu4PsXHZBXM9UkGrAsj0r1h8aT1VEiLGsWnlo9XWHv8XkgYIHMcdNw9', '2019-02-22', '2019-02-22', 3, 0, 1, 3297, NULL, NULL, NULL, NULL, NULL, 'web', NULL, NULL),
  681. (3, 'Haruna Ahmadu', 'dharuna@gmail.com', '7034776388', '$2y$10$lfX/vJWcyXuVXKa4mWzCl.PZrS2Id4M6wSwtASBvA5evNWR66xfT2', NULL, '2019-02-25', '2019-02-25', 1, 0, NULL, 8997, NULL, NULL, NULL, NULL, NULL, 'web', NULL, NULL),
  682. (4, 'Haruna Ahmadu', 'akhmruna@gmail.com', '7034776388', '$2y$10$kcFfiMNhMK4Xm.RGlIzzoutpm8bnj9/WhhE3W1/KfUn.cXQZbpPp6', NULL, '2019-02-25', '2019-02-25', 0, 0, NULL, 5004, NULL, NULL, NULL, NULL, NULL, 'card', NULL, NULL),
  683. (5, 'Haruna Ahmadu', 'daruna@gmail.com', '7034776388', '$2y$10$vhyCfEMH4.n4DV/VqlsnDO3WsIsfyoeplbaN0cjayT8r8fjLE.Ul2', NULL, '2019-02-25', '2019-02-25', 1, 0, NULL, 9556, NULL, NULL, NULL, NULL, NULL, 'web', NULL, NULL);
  684.  
  685. -- --------------------------------------------------------
  686.  
  687. --
  688. -- Table structure for table `user_profile`
  689. --
  690.  
  691. CREATE TABLE `user_profile` (
  692. `user_profile_id` int(11) NOT NULL,
  693. `up_user_id` int(11) NOT NULL,
  694. `up_employment_status` int(11) DEFAULT NULL,
  695. `up_gender` varchar(5) NOT NULL,
  696. `up_address` varchar(300) NOT NULL,
  697. `up_home_status` int(11) DEFAULT NULL,
  698. `up_city` int(11) DEFAULT NULL,
  699. `up_lga` int(11) NOT NULL,
  700. `up_location` int(11) DEFAULT NULL,
  701. `up_salary` varchar(225) DEFAULT NULL,
  702. `up_occupation` varchar(100) DEFAULT NULL,
  703. `up_current_job` int(11) DEFAULT NULL,
  704. `up_employment_date` int(225) DEFAULT NULL,
  705. `up_loans` int(11) DEFAULT NULL,
  706. `up_dob` date DEFAULT NULL,
  707. `up_bvn` varchar(50) DEFAULT NULL,
  708. `up_created` int(11) DEFAULT NULL,
  709. `up_status` int(11) NOT NULL DEFAULT '0',
  710. `up_credit` decimal(10,2) DEFAULT NULL,
  711. `created_at` datetime DEFAULT NULL,
  712. `updated_at` datetime DEFAULT NULL,
  713. `up_employment_address` varchar(200) DEFAULT NULL
  714. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  715.  
  716. --
  717. -- Dumping data for table `user_profile`
  718. --
  719.  
  720. INSERT INTO `user_profile` (`user_profile_id`, `up_user_id`, `up_employment_status`, `up_gender`, `up_address`, `up_home_status`, `up_city`, `up_lga`, `up_location`, `up_salary`, `up_occupation`, `up_current_job`, `up_employment_date`, `up_loans`, `up_dob`, `up_bvn`, `up_created`, `up_status`, `up_credit`, `created_at`, `updated_at`, `up_employment_address`) VALUES
  721. (2, 2, 1, 'M', 'plot 12, taiwo olugbenga crecent', 1, 1, 2, 2, '900000.00', 'Developer', NULL, 7, NULL, '2019-02-23', '22168191802', NULL, 0, '176400.00', '2019-02-22 22:34:51', '2019-02-22 22:34:51', 'plot 12, taiwo olugbenga crecent');
  722.  
  723. -- --------------------------------------------------------
  724.  
  725. --
  726. -- Table structure for table `xds_credit`
  727. --
  728.  
  729. CREATE TABLE `xds_credit` (
  730. `xc_id` int(11) NOT NULL,
  731. `xc_x_id` int(11) NOT NULL,
  732. `xc_user_id` int(11) NOT NULL,
  733. `DateAccountOpened` varchar(100) NOT NULL,
  734. `SubscriberName` varchar(100) NOT NULL,
  735. `AccountNo` varchar(100) NOT NULL,
  736. `SubAccountNo` varchar(100) NOT NULL,
  737. `IndicatorDescription` varchar(100) NOT NULL,
  738. `OpeningBalanceAmt` varchar(100) NOT NULL,
  739. `Currency` varchar(100) NOT NULL,
  740. `CurrentBalanceAmt` varchar(100) NOT NULL,
  741. `InstalmentAmount` varchar(100) NOT NULL,
  742. `ClosedDate` varchar(100) NOT NULL,
  743. `LoanDuration` varchar(100) NOT NULL,
  744. `RepaymentFrequency` varchar(100) NOT NULL,
  745. `LastUpdatedDate` varchar(100) NOT NULL,
  746. `PerformanceStatus` varchar(100) NOT NULL,
  747. `AccountStatus` varchar(100) NOT NULL,
  748. `xc_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  749. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  750.  
  751. --
  752. -- Dumping data for table `xds_credit`
  753. --
  754.  
  755. INSERT INTO `xds_credit` (`xc_id`, `xc_x_id`, `xc_user_id`, `DateAccountOpened`, `SubscriberName`, `AccountNo`, `SubAccountNo`, `IndicatorDescription`, `OpeningBalanceAmt`, `Currency`, `CurrentBalanceAmt`, `InstalmentAmount`, `ClosedDate`, `LoanDuration`, `RepaymentFrequency`, `LastUpdatedDate`, `PerformanceStatus`, `AccountStatus`, `xc_created`) VALUES
  756. (1, 1, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-22 23:47:00'),
  757. (2, 1, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:00'),
  758. (3, 1, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:00'),
  759. (4, 1, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:00'),
  760. (5, 1, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:00'),
  761. (6, 1, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:00'),
  762. (7, 1, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:00'),
  763. (8, 1, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:00'),
  764. (9, 1, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:00'),
  765. (10, 2, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-22 23:47:05'),
  766. (11, 2, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:05'),
  767. (12, 2, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:05'),
  768. (13, 2, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:05'),
  769. (14, 2, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:05'),
  770. (15, 2, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:05'),
  771. (16, 2, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:05'),
  772. (17, 2, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:05'),
  773. (18, 2, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-22 23:47:05'),
  774. (19, 3, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 01:07:10'),
  775. (20, 3, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:07:10'),
  776. (21, 3, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:07:10'),
  777. (22, 3, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:07:10'),
  778. (23, 3, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:07:10'),
  779. (24, 3, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:07:10'),
  780. (25, 3, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:07:10'),
  781. (26, 3, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:07:10'),
  782. (27, 3, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:07:10'),
  783. (28, 4, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 01:08:54'),
  784. (29, 4, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:08:54'),
  785. (30, 4, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:08:54'),
  786. (31, 4, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:08:54'),
  787. (32, 4, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:08:54'),
  788. (33, 4, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:08:54'),
  789. (34, 4, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:08:54'),
  790. (35, 4, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:08:54'),
  791. (36, 4, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:08:54'),
  792. (37, 5, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 01:11:31'),
  793. (38, 5, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:11:31'),
  794. (39, 5, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:11:31'),
  795. (40, 5, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:11:31'),
  796. (41, 5, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:11:31'),
  797. (42, 5, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:11:31'),
  798. (43, 5, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:11:31'),
  799. (44, 5, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:11:31'),
  800. (45, 5, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 01:11:31'),
  801. (46, 6, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 06:48:54'),
  802. (47, 6, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 06:48:54'),
  803. (48, 6, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 06:48:54'),
  804. (49, 6, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 06:48:54'),
  805. (50, 6, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 06:48:54'),
  806. (51, 6, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 06:48:54'),
  807. (52, 6, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 06:48:54'),
  808. (53, 6, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 06:48:54'),
  809. (54, 6, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 06:48:54'),
  810. (55, 7, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 11:50:01'),
  811. (56, 7, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:50:01'),
  812. (57, 7, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:50:01'),
  813. (58, 7, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:50:01'),
  814. (59, 7, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:50:01'),
  815. (60, 7, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:50:01'),
  816. (61, 7, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:50:01'),
  817. (62, 7, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:50:01'),
  818. (63, 7, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:50:01'),
  819. (64, 8, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 11:52:04'),
  820. (65, 8, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:52:04'),
  821. (66, 8, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:52:04'),
  822. (67, 8, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:52:04'),
  823. (68, 8, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:52:04'),
  824. (69, 8, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:52:04'),
  825. (70, 8, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:52:04'),
  826. (71, 8, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:52:04'),
  827. (72, 8, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:52:04'),
  828. (73, 9, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 11:54:07'),
  829. (74, 9, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:54:07'),
  830. (75, 9, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:54:07'),
  831. (76, 9, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:54:07'),
  832. (77, 9, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:54:07'),
  833. (78, 9, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:54:07'),
  834. (79, 9, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:54:07'),
  835. (80, 9, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:54:07'),
  836. (81, 9, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:54:07'),
  837. (82, 10, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 11:55:55'),
  838. (83, 10, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:55:55'),
  839. (84, 10, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:55:55'),
  840. (85, 10, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:55:55'),
  841. (86, 10, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:55:55'),
  842. (87, 10, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:55:55'),
  843. (88, 10, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:55:55'),
  844. (89, 10, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:55:55'),
  845. (90, 10, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 11:55:55'),
  846. (91, 11, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 12:00:43'),
  847. (92, 11, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:00:43'),
  848. (93, 11, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:00:43'),
  849. (94, 11, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:00:43'),
  850. (95, 11, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:00:43'),
  851. (96, 11, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:00:43'),
  852. (97, 11, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:00:43'),
  853. (98, 11, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:00:43'),
  854. (99, 11, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:00:43'),
  855. (100, 12, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 12:10:13'),
  856. (101, 12, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:13'),
  857. (102, 12, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:13'),
  858. (103, 12, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:13'),
  859. (104, 12, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:13'),
  860. (105, 12, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:13'),
  861. (106, 12, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:13'),
  862. (107, 12, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:13'),
  863. (108, 12, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:13'),
  864. (109, 13, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 12:10:38'),
  865. (110, 13, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:38'),
  866. (111, 13, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:38'),
  867. (112, 13, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:38'),
  868. (113, 13, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:38'),
  869. (114, 13, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:38'),
  870. (115, 13, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:38'),
  871. (116, 13, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:38'),
  872. (117, 13, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 12:10:38'),
  873. (118, 14, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-23 15:13:03'),
  874. (119, 14, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 15:13:03'),
  875. (120, 14, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 15:13:03'),
  876. (121, 14, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 15:13:03'),
  877. (122, 14, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 15:13:03'),
  878. (123, 14, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 15:13:03'),
  879. (124, 14, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 15:13:03'),
  880. (125, 14, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 15:13:03'),
  881. (126, 14, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-23 15:13:03'),
  882. (127, 15, 2, '30/10/2018', 'Guaranty Trust Bank Plc', '049104441410010001000', '', 'Personal Overdraft', '0.00', 'NGN', '695.00', '2,000.00', '29/10/2018', '1', 'Monthly', '16/01/2019', 'Performing', 'Open', '2019-02-24 02:12:59'),
  883. (128, 15, 2, '26/06/2018', 'One Finance & Investment Ltd', '301961606594', '', 'Installment account', '49,000.00', 'NGN', '0.00', '29,400.00', '26/08/2018', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-24 02:12:59'),
  884. (129, 15, 2, '05/07/2017', 'One Finance & Investment Ltd', '301965377', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '20/07/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-24 02:12:59'),
  885. (130, 15, 2, '25/08/2017', 'One Finance & Investment Ltd', '302055066', '', 'Installment account', '10,000.00', 'NGN', '0.00', '11,500.00', '11/09/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-24 02:12:59'),
  886. (131, 15, 2, '06/10/2017', 'One Finance & Investment Ltd', '302190470', '', 'Installment account', '16,000.00', 'NGN', '0.00', '18,400.00', '23/10/2017', '1', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-24 02:12:59'),
  887. (132, 15, 2, '20/10/2017', 'One Finance & Investment Ltd', '302249149', '', 'Installment account', '28,000.00', 'NGN', '0.00', '16,800.00', '19/12/2017', '2', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-24 02:12:59'),
  888. (133, 15, 2, '20/11/2017', 'One Finance & Investment Ltd', '302389214', '', 'Installment account', '49,000.00', 'NGN', '0.00', '20,008.33', '20/02/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-24 02:12:59'),
  889. (134, 15, 2, '22/10/2018', 'One Finance & Investment Ltd', '302623307672', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '21/01/2019', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-24 02:12:59'),
  890. (135, 15, 2, '11/03/2018', 'One Finance & Investment Ltd', '302905402', '', 'Installment account', '47,000.00', 'NGN', '0.00', '19,191.67', '10/06/2018', '3', 'Monthly', '14/12/2018', 'Performing', 'Closed', '2019-02-24 02:12:59');
  891.  
  892. -- --------------------------------------------------------
  893.  
  894. --
  895. -- Table structure for table `xds_fullreport`
  896. --
  897.  
  898. CREATE TABLE `xds_fullreport` (
  899. `x_id` int(11) NOT NULL,
  900. `x_user_id` int(11) NOT NULL,
  901. `x_c_id` int(11) NOT NULL,
  902. `ConsumerID` int(11) NOT NULL,
  903. `SearchOutput` varchar(100) NOT NULL,
  904. `Reference` varchar(100) NOT NULL,
  905. `Header` varchar(100) NOT NULL,
  906. `ReferenceNo` varchar(100) NOT NULL,
  907. `Nationality` varchar(100) NOT NULL,
  908. `NationalIDNo` varchar(100) NOT NULL,
  909. `BankVerificationNo` varchar(100) NOT NULL,
  910. `PencomIDNo` varchar(100) NOT NULL,
  911. `otheridNo` varchar(100) NOT NULL,
  912. `BirthDate` varchar(100) NOT NULL,
  913. `Dependants` int(11) NOT NULL,
  914. `Gender` varchar(10) NOT NULL,
  915. `ResidentialAddress1` varchar(400) NOT NULL,
  916. `ResidentialAddress2` varchar(200) NOT NULL,
  917. `ResidentialAddress3` varchar(200) NOT NULL,
  918. `ResidentialAddress4` varchar(200) NOT NULL,
  919. `CellularNo` varchar(30) NOT NULL,
  920. `EmailAddress` varchar(50) NOT NULL,
  921. `PropertyOwnedType` varchar(50) NOT NULL,
  922. `Surname` varchar(100) NOT NULL,
  923. `FirstName` varchar(100) NOT NULL,
  924. `TotalMonthlyInstalment` varchar(100) NOT NULL,
  925. `TotalOutstandingdebt` varchar(100) NOT NULL,
  926. `TotalAccountarrear` int(11) NOT NULL,
  927. `Amountarrear` varchar(100) NOT NULL,
  928. `TotalAccounts` int(11) NOT NULL,
  929. `TotalAccounts1` int(11) NOT NULL,
  930. `TotalaccountinGodcondition` int(11) NOT NULL,
  931. `TotalNumberofJudgement` int(11) NOT NULL,
  932. `TotalJudgementAmount` int(11) NOT NULL,
  933. `LastJudgementDate` varchar(100) NOT NULL,
  934. `TotalNumberofDishonoured` int(11) NOT NULL,
  935. `TotalDishonouredAmount` varchar(100) NOT NULL,
  936. `TotalMonthlyInstalment1` varchar(100) NOT NULL,
  937. `TotalOutstandingdebt1` varchar(100) NOT NULL,
  938. `TotalAccountarrear1` int(11) NOT NULL,
  939. `Amountarrear1` varchar(100) NOT NULL,
  940. `TotalaccountinGodcondition1` int(11) NOT NULL,
  941. `TotalNumberofJudgement1` int(11) NOT NULL,
  942. `TotalJudgementAmount1` int(11) NOT NULL,
  943. `LastJudgementDate1` varchar(100) NOT NULL,
  944. `TotalNumberofDishonoured1` int(11) NOT NULL,
  945. `TotalDishonouredAmount1` varchar(100) NOT NULL,
  946. `Rating` int(11) NOT NULL,
  947. `NoOfHomeLoanAccountsGood` int(11) NOT NULL,
  948. `NoOfHomeLoanAccountsBad` int(11) NOT NULL,
  949. `NoOfAutoLoanccountsGood` int(11) NOT NULL,
  950. `NoOfAutoLoanAccountsBad` int(11) NOT NULL,
  951. `NoOfStudyLoanAccountsGood` int(11) NOT NULL,
  952. `NoOfStudyLoanAccountsBad` int(11) NOT NULL,
  953. `NoOfPersonalLoanAccountsGood` int(11) NOT NULL,
  954. `NoOfPersonalLoanAccountsBad` int(11) NOT NULL,
  955. `NoOfCreditCardAccountsGood` int(11) NOT NULL,
  956. `NoOfCreditCardAccountsBad` int(11) NOT NULL,
  957. `NoOfRetailAccountsGood` int(11) NOT NULL,
  958. `NoOfRetailAccountsBad` int(11) NOT NULL,
  959. `NoOfJointLoanAccountsGood` int(11) NOT NULL,
  960. `NoOfJointLoanAccountsBad` int(11) NOT NULL,
  961. `NoOfTelecomAccountsGood` int(11) NOT NULL,
  962. `NoOfTelecomAccountsBad` int(11) NOT NULL,
  963. `NoOfOtherAccountsGood` int(11) NOT NULL,
  964. `NoOfOtherAccountsBad` int(11) NOT NULL,
  965. `x_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  966. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  967.  
  968. --
  969. -- Dumping data for table `xds_fullreport`
  970. --
  971.  
  972. INSERT INTO `xds_fullreport` (`x_id`, `x_user_id`, `x_c_id`, `ConsumerID`, `SearchOutput`, `Reference`, `Header`, `ReferenceNo`, `Nationality`, `NationalIDNo`, `BankVerificationNo`, `PencomIDNo`, `otheridNo`, `BirthDate`, `Dependants`, `Gender`, `ResidentialAddress1`, `ResidentialAddress2`, `ResidentialAddress3`, `ResidentialAddress4`, `CellularNo`, `EmailAddress`, `PropertyOwnedType`, `Surname`, `FirstName`, `TotalMonthlyInstalment`, `TotalOutstandingdebt`, `TotalAccountarrear`, `Amountarrear`, `TotalAccounts`, `TotalAccounts1`, `TotalaccountinGodcondition`, `TotalNumberofJudgement`, `TotalJudgementAmount`, `LastJudgementDate`, `TotalNumberofDishonoured`, `TotalDishonouredAmount`, `TotalMonthlyInstalment1`, `TotalOutstandingdebt1`, `TotalAccountarrear1`, `Amountarrear1`, `TotalaccountinGodcondition1`, `TotalNumberofJudgement1`, `TotalJudgementAmount1`, `LastJudgementDate1`, `TotalNumberofDishonoured1`, `TotalDishonouredAmount1`, `Rating`, `NoOfHomeLoanAccountsGood`, `NoOfHomeLoanAccountsBad`, `NoOfAutoLoanccountsGood`, `NoOfAutoLoanAccountsBad`, `NoOfStudyLoanAccountsGood`, `NoOfStudyLoanAccountsBad`, `NoOfPersonalLoanAccountsGood`, `NoOfPersonalLoanAccountsBad`, `NoOfCreditCardAccountsGood`, `NoOfCreditCardAccountsBad`, `NoOfRetailAccountsGood`, `NoOfRetailAccountsBad`, `NoOfJointLoanAccountsGood`, `NoOfJointLoanAccountsBad`, `NoOfTelecomAccountsGood`, `NoOfTelecomAccountsBad`, `NoOfOtherAccountsGood`, `NoOfOtherAccountsBad`, `x_created`) VALUES
  973. (1, 2, 10, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', 'N002773255', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-22 23:47:00'),
  974. (2, 2, 20, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-22 23:47:05'),
  975. (3, 2, 30, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 01:07:10'),
  976. (4, 2, 40, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 01:08:54'),
  977. (5, 2, 50, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 01:11:31'),
  978. (6, 2, 60, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 06:48:54'),
  979. (7, 2, 70, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 11:50:01'),
  980. (8, 2, 80, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 11:52:04'),
  981. (9, 2, 90, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 11:54:07'),
  982. (10, 2, 100, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 11:55:55'),
  983. (11, 2, 110, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 12:00:43'),
  984. (12, 2, 120, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 12:10:13'),
  985. (13, 2, 130, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', '', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 12:10:38'),
  986. (14, 2, 140, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', 'N002819627', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-23 15:13:03'),
  987. (15, 2, 150, 9928562, 'OLAOGUN, MOFEHINTOLU, FUNSO, 114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '9928562', 'PERSONAL DETAILS SUMMARY: OLAOGUN MOFEHINTOLU FUNSO', 'N002819841', 'Nigeria', '', '22168191802', '', '', '19/11/1985', 0, 'Male', '114 ONIRU RESETTLEMENT ESTATE LEKKI LAGOS', '', '', ' ', '08056512029', '', '', 'OLAOGUN', 'MOFEHINTOLU', '147,992.00', '695.00', 1, '695.00', 9, 0, 0, 0, 0, '-', 0, '0.00', '0.00', '0.00', 0, '0.00', 0, 0, 0, '-', 0, '0.00', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, '2019-02-24 02:12:59');
  988.  
  989. --
  990. -- Indexes for dumped tables
  991. --
  992.  
  993. --
  994. -- Indexes for table `bank`
  995. --
  996. ALTER TABLE `bank`
  997. ADD PRIMARY KEY (`id`);
  998.  
  999. --
  1000. -- Indexes for table `card`
  1001. --
  1002. ALTER TABLE `card`
  1003. ADD PRIMARY KEY (`card_id`);
  1004.  
  1005. --
  1006. -- Indexes for table `creditreport`
  1007. --
  1008. ALTER TABLE `creditreport`
  1009. ADD PRIMARY KEY (`c_id`);
  1010.  
  1011. --
  1012. -- Indexes for table `customer`
  1013. --
  1014. ALTER TABLE `customer`
  1015. ADD PRIMARY KEY (`customer_id`);
  1016.  
  1017. --
  1018. -- Indexes for table `employment_type`
  1019. --
  1020. ALTER TABLE `employment_type`
  1021. ADD PRIMARY KEY (`employment_type_id`);
  1022.  
  1023. --
  1024. -- Indexes for table `files`
  1025. --
  1026. ALTER TABLE `files`
  1027. ADD PRIMARY KEY (`file_id`);
  1028.  
  1029. --
  1030. -- Indexes for table `loans`
  1031. --
  1032. ALTER TABLE `loans`
  1033. ADD PRIMARY KEY (`id`);
  1034.  
  1035. --
  1036. -- Indexes for table `loan_repayment`
  1037. --
  1038. ALTER TABLE `loan_repayment`
  1039. ADD PRIMARY KEY (`id`,`loan_id`);
  1040.  
  1041. --
  1042. -- Indexes for table `merchants`
  1043. --
  1044. ALTER TABLE `merchants`
  1045. ADD PRIMARY KEY (`id`),
  1046. ADD UNIQUE KEY `users_email_unique` (`email`);
  1047.  
  1048. --
  1049. -- Indexes for table `migrations`
  1050. --
  1051. ALTER TABLE `migrations`
  1052. ADD PRIMARY KEY (`id`);
  1053.  
  1054. --
  1055. -- Indexes for table `oauth_access_tokens`
  1056. --
  1057. ALTER TABLE `oauth_access_tokens`
  1058. ADD PRIMARY KEY (`id`),
  1059. ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);
  1060.  
  1061. --
  1062. -- Indexes for table `oauth_auth_codes`
  1063. --
  1064. ALTER TABLE `oauth_auth_codes`
  1065. ADD PRIMARY KEY (`id`);
  1066.  
  1067. --
  1068. -- Indexes for table `oauth_clients`
  1069. --
  1070. ALTER TABLE `oauth_clients`
  1071. ADD PRIMARY KEY (`id`),
  1072. ADD KEY `oauth_clients_user_id_index` (`user_id`);
  1073.  
  1074. --
  1075. -- Indexes for table `oauth_personal_access_clients`
  1076. --
  1077. ALTER TABLE `oauth_personal_access_clients`
  1078. ADD PRIMARY KEY (`id`),
  1079. ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);
  1080.  
  1081. --
  1082. -- Indexes for table `oauth_refresh_tokens`
  1083. --
  1084. ALTER TABLE `oauth_refresh_tokens`
  1085. ADD PRIMARY KEY (`id`),
  1086. ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);
  1087.  
  1088. --
  1089. -- Indexes for table `repayment`
  1090. --
  1091. ALTER TABLE `repayment`
  1092. ADD PRIMARY KEY (`repayment_id`);
  1093.  
  1094. --
  1095. -- Indexes for table `repayment_log`
  1096. --
  1097. ALTER TABLE `repayment_log`
  1098. ADD PRIMARY KEY (`rl_id`);
  1099.  
  1100. --
  1101. -- Indexes for table `retailers`
  1102. --
  1103. ALTER TABLE `retailers`
  1104. ADD PRIMARY KEY (`ret_id`);
  1105.  
  1106. --
  1107. -- Indexes for table `transaction`
  1108. --
  1109. ALTER TABLE `transaction`
  1110. ADD PRIMARY KEY (`transaction_id`);
  1111.  
  1112. --
  1113. -- Indexes for table `users`
  1114. --
  1115. ALTER TABLE `users`
  1116. ADD PRIMARY KEY (`id`),
  1117. ADD UNIQUE KEY `email_UNIQUE` (`email`);
  1118.  
  1119. --
  1120. -- Indexes for table `user_profile`
  1121. --
  1122. ALTER TABLE `user_profile`
  1123. ADD PRIMARY KEY (`user_profile_id`),
  1124. ADD UNIQUE KEY `up_user_id` (`up_user_id`);
  1125.  
  1126. --
  1127. -- Indexes for table `xds_credit`
  1128. --
  1129. ALTER TABLE `xds_credit`
  1130. ADD PRIMARY KEY (`xc_id`);
  1131.  
  1132. --
  1133. -- Indexes for table `xds_fullreport`
  1134. --
  1135. ALTER TABLE `xds_fullreport`
  1136. ADD PRIMARY KEY (`x_id`);
  1137.  
  1138. --
  1139. -- AUTO_INCREMENT for dumped tables
  1140. --
  1141.  
  1142. --
  1143. -- AUTO_INCREMENT for table `bank`
  1144. --
  1145. ALTER TABLE `bank`
  1146. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
  1147.  
  1148. --
  1149. -- AUTO_INCREMENT for table `card`
  1150. --
  1151. ALTER TABLE `card`
  1152. MODIFY `card_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1153.  
  1154. --
  1155. -- AUTO_INCREMENT for table `creditreport`
  1156. --
  1157. ALTER TABLE `creditreport`
  1158. MODIFY `c_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;
  1159.  
  1160. --
  1161. -- AUTO_INCREMENT for table `customer`
  1162. --
  1163. ALTER TABLE `customer`
  1164. MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1165.  
  1166. --
  1167. -- AUTO_INCREMENT for table `files`
  1168. --
  1169. ALTER TABLE `files`
  1170. MODIFY `file_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  1171.  
  1172. --
  1173. -- AUTO_INCREMENT for table `loans`
  1174. --
  1175. ALTER TABLE `loans`
  1176. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1177.  
  1178. --
  1179. -- AUTO_INCREMENT for table `loan_repayment`
  1180. --
  1181. ALTER TABLE `loan_repayment`
  1182. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1183.  
  1184. --
  1185. -- AUTO_INCREMENT for table `merchants`
  1186. --
  1187. ALTER TABLE `merchants`
  1188. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  1189.  
  1190. --
  1191. -- AUTO_INCREMENT for table `migrations`
  1192. --
  1193. ALTER TABLE `migrations`
  1194. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  1195.  
  1196. --
  1197. -- AUTO_INCREMENT for table `oauth_clients`
  1198. --
  1199. ALTER TABLE `oauth_clients`
  1200. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  1201.  
  1202. --
  1203. -- AUTO_INCREMENT for table `oauth_personal_access_clients`
  1204. --
  1205. ALTER TABLE `oauth_personal_access_clients`
  1206. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1207.  
  1208. --
  1209. -- AUTO_INCREMENT for table `repayment`
  1210. --
  1211. ALTER TABLE `repayment`
  1212. MODIFY `repayment_id` int(11) NOT NULL AUTO_INCREMENT;
  1213.  
  1214. --
  1215. -- AUTO_INCREMENT for table `repayment_log`
  1216. --
  1217. ALTER TABLE `repayment_log`
  1218. MODIFY `rl_id` int(11) NOT NULL AUTO_INCREMENT;
  1219.  
  1220. --
  1221. -- AUTO_INCREMENT for table `retailers`
  1222. --
  1223. ALTER TABLE `retailers`
  1224. MODIFY `ret_id` int(11) NOT NULL AUTO_INCREMENT;
  1225.  
  1226. --
  1227. -- AUTO_INCREMENT for table `transaction`
  1228. --
  1229. ALTER TABLE `transaction`
  1230. MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1231.  
  1232. --
  1233. -- AUTO_INCREMENT for table `users`
  1234. --
  1235. ALTER TABLE `users`
  1236. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  1237.  
  1238. --
  1239. -- AUTO_INCREMENT for table `user_profile`
  1240. --
  1241. ALTER TABLE `user_profile`
  1242. MODIFY `user_profile_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1243.  
  1244. --
  1245. -- AUTO_INCREMENT for table `xds_credit`
  1246. --
  1247. ALTER TABLE `xds_credit`
  1248. MODIFY `xc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;
  1249.  
  1250. --
  1251. -- AUTO_INCREMENT for table `xds_fullreport`
  1252. --
  1253. ALTER TABLE `xds_fullreport`
  1254. MODIFY `x_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!