API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 25th, 2019
333
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 157.58 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 25, 2019 at 08:37 AM
  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 `admins`
  21. --
  22.  
  23. CREATE TABLE `admins` (
  24. `admin_id` int(11) NOT NULL,
  25. `name` varchar(225) NOT NULL,
  26. `email` varchar(100) NOT NULL,
  27. `password` varchar(100) NOT NULL,
  28. `avr` varchar(11) DEFAULT NULL,
  29. `created_at` datetime NOT NULL,
  30. `updated_at` datetime NOT NULL
  31. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  32.  
  33. --
  34. -- Dumping data for table `admins`
  35. --
  36.  
  37. INSERT INTO `admins` (`admin_id`, `name`, `email`, `password`, `avr`, `created_at`, `updated_at`) VALUES
  38. (1, 'Yomi Mathew', 'drdre4life2001@yahoo.com', '$2y$10$LyNomVE349k9TrMOxBSGr.ROzWKZpB5Gwo3wpBLwnuY8RSeHGw6gy', NULL, '2019-03-18 13:19:35', '2019-03-18 13:19:35'),
  39. (2, 'Admin Admin', 'hello@credpal.com', '$2y$10$jHu5Pqk7JEkTxpGeYzSfRuWlsm21DDhH86ZqlZaq3vNqR3Bo9ABKa', NULL, '2019-03-19 11:44:27', '2019-03-19 11:44:27');
  40.  
  41. -- --------------------------------------------------------
  42.  
  43. --
  44. -- Table structure for table `bank`
  45. --
  46.  
  47. CREATE TABLE `bank` (
  48. `id` int(11) NOT NULL,
  49. `bank_name` varchar(255) NOT NULL,
  50. `bank_id` varchar(255) NOT NULL,
  51. `bank_code` varchar(20) DEFAULT NULL
  52. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  53.  
  54. --
  55. -- Dumping data for table `bank`
  56. --
  57.  
  58. INSERT INTO `bank` (`id`, `bank_name`, `bank_id`, `bank_code`) VALUES
  59. (1, 'Sterling Bank', '1', 'sterling'),
  60. (2, 'Polaris Bank', '2', 'polaris'),
  61. (3, 'Access Bank', '6', 'access'),
  62. (4, 'Heritage Bank', '7', 'heritage'),
  63. (5, 'Diamond Bank', '8', 'diamond'),
  64. (6, 'Union Bank', '11', 'union'),
  65. (7, 'UBA', '14', 'uba'),
  66. (8, 'Fidelity Bank', '15', 'fidelity'),
  67. (9, 'GTB', '13', 'gtb'),
  68. (10, 'First City Monument Bank PLC', '', 'fcmb'),
  69. (11, 'First Bank of Nigeria Limited', '', 'firstbank'),
  70. (12, 'Zenith Bank Plc', '', 'zenith'),
  71. (13, 'Citi Bank Nigeria Limited', '', 'citi'),
  72. (14, 'Ecobank Nigeria Plc', '', 'ecobank'),
  73. (15, 'Keystone Bank Limited', '', 'keystone'),
  74. (16, 'Stanbic IBTC Bank Plc', '', 'stanbic'),
  75. (17, 'Standard Chartered', '', 'sc'),
  76. (18, 'Unity Bank Plc', '', 'unity'),
  77. (19, 'Wema Bank Plc', '', 'wema'),
  78. (20, 'SunTrust Bank Nigeria Limited', '', 'suntrust'),
  79. (21, 'Jaiz Bank Plc', '', 'jaiz');
  80.  
  81. -- --------------------------------------------------------
  82.  
  83. --
  84. -- Table structure for table `card`
  85. --
  86.  
  87. CREATE TABLE `card` (
  88. `card_id` int(11) NOT NULL,
  89. `card_customer_id` int(11) NOT NULL,
  90. `card_user_id` int(11) NOT NULL,
  91. `card_last4` int(11) NOT NULL,
  92. `card_exp_month` int(11) NOT NULL,
  93. `card_exp_year` int(11) NOT NULL,
  94. `card_authorization_code` varchar(100) NOT NULL,
  95. `card_created` int(11) NOT NULL,
  96. `card_type` varchar(100) NOT NULL,
  97. `card_country_code` varchar(100) NOT NULL,
  98. `card_reusable` int(11) NOT NULL,
  99. `card_bank` varchar(100) NOT NULL
  100. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  101.  
  102. --
  103. -- Dumping data for table `card`
  104. --
  105.  
  106. 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
  107. (3, 3, 2, 4081, 12, 2020, 'AUTH_pw825q0z6o', 1552766580, 'visa DEBIT', 'NG', 1, 'Test Bank');
  108.  
  109. -- --------------------------------------------------------
  110.  
  111. --
  112. -- Table structure for table `creditreport`
  113. --
  114.  
  115. CREATE TABLE `creditreport` (
  116. `c_id` int(11) NOT NULL,
  117. `c_DataTicket` varchar(1000) DEFAULT NULL,
  118. `c_bvn` varchar(20) NOT NULL,
  119. `c_EnquiryReason` varchar(100) DEFAULT NULL,
  120. `c_ConsumerName` varchar(200) DEFAULT NULL,
  121. `c_DateOfBirth` varchar(100) DEFAULT NULL,
  122. `c_Identification` varchar(100) DEFAULT NULL,
  123. `c_AccountNumber` varchar(20) DEFAULT NULL,
  124. `c_ProductID` int(11) DEFAULT NULL,
  125. `c_ConsumerID` int(11) DEFAULT NULL,
  126. `c_FirstName` varchar(100) DEFAULT NULL,
  127. `c_Surname` varchar(100) DEFAULT NULL,
  128. `c_OtherNames` varchar(100) DEFAULT NULL,
  129. `c_Address` varchar(100) DEFAULT NULL,
  130. `c_BirthDate` varchar(100) DEFAULT NULL,
  131. `c_AccountNo` varchar(100) DEFAULT NULL,
  132. `c_DriversLicenseNo` varchar(100) DEFAULT NULL,
  133. `c_VoterID` varchar(100) DEFAULT NULL,
  134. `c_user_id` int(11) DEFAULT NULL,
  135. `c_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  136. `c_status` int(11) DEFAULT NULL,
  137. `c_bureau` int(11) DEFAULT NULL,
  138. `c_EnquiryEngineID` int(11) DEFAULT NULL,
  139. `c_enquiryID` int(11) DEFAULT NULL,
  140. `c_consumerMergeList` varchar(200) DEFAULT NULL,
  141. `c_MatchingEngineID` varchar(20) DEFAULT NULL,
  142. `c_Reference` varchar(100) DEFAULT NULL,
  143. `c_MatchingRate` int(11) DEFAULT NULL
  144. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  145.  
  146. --
  147. -- Dumping data for table `creditreport`
  148. --
  149.  
  150. 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
  151. (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),
  152. (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),
  153. (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),
  154. (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),
  155. (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),
  156. (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),
  157. (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),
  158. (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),
  159. (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),
  160. (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),
  161. (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),
  162. (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),
  163. (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),
  164. (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),
  165. (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),
  166. (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),
  167. (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),
  168. (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),
  169. (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),
  170. (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),
  171. (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),
  172. (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),
  173. (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),
  174. (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),
  175. (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),
  176. (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),
  177. (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),
  178. (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),
  179. (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),
  180. (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),
  181. (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),
  182. (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),
  183. (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),
  184. (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),
  185. (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),
  186. (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),
  187. (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),
  188. (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),
  189. (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),
  190. (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),
  191. (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),
  192. (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),
  193. (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),
  194. (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),
  195. (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),
  196. (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),
  197. (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),
  198. (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),
  199. (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),
  200. (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),
  201. (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),
  202. (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),
  203. (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),
  204. (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),
  205. (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),
  206. (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),
  207. (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),
  208. (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),
  209. (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),
  210. (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),
  211. (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),
  212. (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),
  213. (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),
  214. (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),
  215. (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),
  216. (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),
  217. (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),
  218. (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),
  219. (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),
  220. (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),
  221. (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),
  222. (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),
  223. (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),
  224. (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),
  225. (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),
  226. (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),
  227. (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),
  228. (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),
  229. (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),
  230. (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),
  231. (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),
  232. (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),
  233. (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),
  234. (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),
  235. (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),
  236. (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),
  237. (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);
  238. 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
  239. (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),
  240. (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),
  241. (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),
  242. (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),
  243. (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),
  244. (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),
  245. (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),
  246. (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),
  247. (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),
  248. (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),
  249. (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),
  250. (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),
  251. (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),
  252. (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),
  253. (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),
  254. (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),
  255. (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),
  256. (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),
  257. (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),
  258. (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),
  259. (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),
  260. (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),
  261. (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),
  262. (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),
  263. (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),
  264. (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),
  265. (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),
  266. (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),
  267. (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),
  268. (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),
  269. (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),
  270. (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),
  271. (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),
  272. (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),
  273. (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),
  274. (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),
  275. (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),
  276. (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),
  277. (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),
  278. (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),
  279. (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),
  280. (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),
  281. (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),
  282. (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),
  283. (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),
  284. (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),
  285. (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),
  286. (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),
  287. (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),
  288. (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),
  289. (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),
  290. (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),
  291. (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),
  292. (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),
  293. (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),
  294. (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),
  295. (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),
  296. (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),
  297. (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),
  298. (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),
  299. (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),
  300. (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),
  301. (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);
  302.  
  303. -- --------------------------------------------------------
  304.  
  305. --
  306. -- Table structure for table `customer`
  307. --
  308.  
  309. CREATE TABLE `customer` (
  310. `customer_id` int(11) NOT NULL,
  311. `customer_user_id` int(11) NOT NULL,
  312. `customer_code` varchar(100) NOT NULL,
  313. `customer_first_name` varchar(100) DEFAULT NULL,
  314. `customer_last_name` varchar(100) DEFAULT NULL,
  315. `customer_email` varchar(100) NOT NULL,
  316. `customer_created` int(11) NOT NULL
  317. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  318.  
  319. --
  320. -- Dumping data for table `customer`
  321. --
  322.  
  323. INSERT INTO `customer` (`customer_id`, `customer_user_id`, `customer_code`, `customer_first_name`, `customer_last_name`, `customer_email`, `customer_created`) VALUES
  324. (1, 2, 'CUS_umqbq74xopfp7da', NULL, NULL, 'akhmadharuna@gmail.com', 1552766580),
  325. (2, 2, 'CUS_umqbq74xopfp7da', NULL, NULL, 'akhmadharuna@gmail.com', 1552766580),
  326. (3, 2, 'CUS_umqbq74xopfp7da', NULL, NULL, 'akhmadharuna@gmail.com', 1552766580);
  327.  
  328. -- --------------------------------------------------------
  329.  
  330. --
  331. -- Table structure for table `employment_type`
  332. --
  333.  
  334. CREATE TABLE `employment_type` (
  335. `employment_type_id` int(11) NOT NULL,
  336. `employment_type_name` varchar(100) NOT NULL
  337. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  338.  
  339. --
  340. -- Dumping data for table `employment_type`
  341. --
  342.  
  343. INSERT INTO `employment_type` (`employment_type_id`, `employment_type_name`) VALUES
  344. (1, 'Permanent'),
  345. (2, 'Contract');
  346.  
  347. -- --------------------------------------------------------
  348.  
  349. --
  350. -- Table structure for table `files`
  351. --
  352.  
  353. CREATE TABLE `files` (
  354. `file_id` int(11) NOT NULL,
  355. `file_name` varchar(100) NOT NULL,
  356. `file_path` varchar(300) NOT NULL,
  357. `file_user_id` int(11) NOT NULL,
  358. `file_created` int(11) NOT NULL,
  359. `file_type` int(11) DEFAULT NULL,
  360. `file_size` int(11) DEFAULT NULL
  361. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  362.  
  363. --
  364. -- Dumping data for table `files`
  365. --
  366.  
  367. INSERT INTO `files` (`file_id`, `file_name`, `file_path`, `file_user_id`, `file_created`, `file_type`, `file_size`) VALUES
  368. (1, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  369. (2, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  370. (3, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  371. (4, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  372. (5, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  373. (6, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  374. (7, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  375. (8, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  376. (9, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  377. (10, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597),
  378. (11, '1550935922pdf-test.pdf', 'http://127.0.0.1/uploads/1550935922pdf-test.pdf', 2, 1550935922, 1, 20597);
  379.  
  380. -- --------------------------------------------------------
  381.  
  382. --
  383. -- Table structure for table `loans`
  384. --
  385.  
  386. CREATE TABLE `loans` (
  387. `id` int(11) NOT NULL,
  388. `user_id` varchar(45) NOT NULL,
  389. `loan_amount` double DEFAULT NULL,
  390. `interest_rate` int(11) DEFAULT NULL,
  391. `created_at` datetime DEFAULT NULL,
  392. `updated_at` datetime DEFAULT NULL
  393. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  394.  
  395. -- --------------------------------------------------------
  396.  
  397. --
  398. -- Table structure for table `loan_repayment`
  399. --
  400.  
  401. CREATE TABLE `loan_repayment` (
  402. `id` int(11) NOT NULL,
  403. `loan_id` int(11) NOT NULL,
  404. `amount` decimal(15,2) NOT NULL,
  405. `due_date` datetime NOT NULL,
  406. `created_at` datetime DEFAULT NULL,
  407. `updated_at` datetime DEFAULT NULL
  408. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  409.  
  410. -- --------------------------------------------------------
  411.  
  412. --
  413. -- Table structure for table `merchants`
  414. --
  415.  
  416. CREATE TABLE `merchants` (
  417. `id` int(10) UNSIGNED NOT NULL,
  418. `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  419. `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  420. `email_verified_at` timestamp NULL DEFAULT NULL,
  421. `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  422. `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  423. `created_at` timestamp NULL DEFAULT NULL,
  424. `updated_at` timestamp NULL DEFAULT NULL,
  425. `mlogo` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  426. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  427.  
  428. --
  429. -- Dumping data for table `merchants`
  430. --
  431.  
  432. INSERT INTO `merchants` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `mlogo`) VALUES
  433. (1, 'credpal admin', 'riskitall2014@gmail.com', NULL, '$2y$10$oA0j2czQj08JnrsVERcU9.4qrOKQCrvuCsHnbW2/dGd.nreWn4WsW', NULL, '2019-03-18 18:40:01', '2019-03-18 18:40:01', '');
  434.  
  435. -- --------------------------------------------------------
  436.  
  437. --
  438. -- Table structure for table `migrations`
  439. --
  440.  
  441. CREATE TABLE `migrations` (
  442. `id` int(10) UNSIGNED NOT NULL,
  443. `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  444. `batch` int(11) NOT NULL
  445. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  446.  
  447. -- --------------------------------------------------------
  448.  
  449. --
  450. -- Table structure for table `oauth_access_tokens`
  451. --
  452.  
  453. CREATE TABLE `oauth_access_tokens` (
  454. `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  455. `user_id` int(11) DEFAULT NULL,
  456. `client_id` int(10) UNSIGNED NOT NULL,
  457. `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  458. `scopes` text COLLATE utf8mb4_unicode_ci,
  459. `revoked` tinyint(1) NOT NULL,
  460. `created_at` timestamp NULL DEFAULT NULL,
  461. `updated_at` timestamp NULL DEFAULT NULL,
  462. `expires_at` datetime DEFAULT NULL
  463. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  464.  
  465. --
  466. -- Dumping data for table `oauth_access_tokens`
  467. --
  468.  
  469. INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
  470. ('5ffff3b9d9c4a63ea516fa7b07d415b5f7e9ab6de2d2a2fd283c1b66349fe1caabd16f9413d4680b', 1, 1, NULL, '[]', 0, '2019-03-18 18:41:39', '2019-03-18 18:41:39', '2020-03-18 19:41:39');
  471.  
  472. -- --------------------------------------------------------
  473.  
  474. --
  475. -- Table structure for table `oauth_auth_codes`
  476. --
  477.  
  478. CREATE TABLE `oauth_auth_codes` (
  479. `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  480. `user_id` int(11) NOT NULL,
  481. `client_id` int(10) UNSIGNED NOT NULL,
  482. `scopes` text COLLATE utf8mb4_unicode_ci,
  483. `revoked` tinyint(1) NOT NULL,
  484. `expires_at` datetime DEFAULT NULL
  485. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  486.  
  487. -- --------------------------------------------------------
  488.  
  489. --
  490. -- Table structure for table `oauth_clients`
  491. --
  492.  
  493. CREATE TABLE `oauth_clients` (
  494. `id` int(10) UNSIGNED NOT NULL,
  495. `user_id` int(11) DEFAULT NULL,
  496. `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  497. `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  498. `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  499. `personal_access_client` tinyint(1) NOT NULL,
  500. `password_client` tinyint(1) NOT NULL,
  501. `revoked` tinyint(1) NOT NULL,
  502. `created_at` timestamp NULL DEFAULT NULL,
  503. `updated_at` timestamp NULL DEFAULT NULL
  504. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  505.  
  506. --
  507. -- Dumping data for table `oauth_clients`
  508. --
  509.  
  510. INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
  511. (1, 1, 'credpal', 'CP_Dl5lfXZET1UW7fbGDh5lPRbvBOuWtc_1', 'https://credpal.com/callback', 0, 1, 0, '2019-03-18 18:40:01', '2019-03-18 18:40:01');
  512.  
  513. -- --------------------------------------------------------
  514.  
  515. --
  516. -- Table structure for table `oauth_personal_access_clients`
  517. --
  518.  
  519. CREATE TABLE `oauth_personal_access_clients` (
  520. `id` int(10) UNSIGNED NOT NULL,
  521. `client_id` int(10) UNSIGNED NOT NULL,
  522. `created_at` timestamp NULL DEFAULT NULL,
  523. `updated_at` timestamp NULL DEFAULT NULL
  524. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  525.  
  526. -- --------------------------------------------------------
  527.  
  528. --
  529. -- Table structure for table `oauth_refresh_tokens`
  530. --
  531.  
  532. CREATE TABLE `oauth_refresh_tokens` (
  533. `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  534. `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  535. `revoked` tinyint(1) NOT NULL,
  536. `expires_at` datetime DEFAULT NULL
  537. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  538.  
  539. --
  540. -- Dumping data for table `oauth_refresh_tokens`
  541. --
  542.  
  543. INSERT INTO `oauth_refresh_tokens` (`id`, `access_token_id`, `revoked`, `expires_at`) VALUES
  544. ('bfdf38ed7d65e9e334fed1f4137911ee27a02698a0bffb403112bd6002fdb0033c2803e3e8864a29', '5ffff3b9d9c4a63ea516fa7b07d415b5f7e9ab6de2d2a2fd283c1b66349fe1caabd16f9413d4680b', 0, '2020-03-18 19:41:39');
  545.  
  546. -- --------------------------------------------------------
  547.  
  548. --
  549. -- Table structure for table `password_resets`
  550. --
  551.  
  552. CREATE TABLE `password_resets` (
  553. `email` varchar(255) NOT NULL,
  554. `token` varchar(255) NOT NULL,
  555. `created_at` timestamp NULL DEFAULT NULL
  556. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  557.  
  558. -- --------------------------------------------------------
  559.  
  560. --
  561. -- Table structure for table `repayment`
  562. --
  563.  
  564. CREATE TABLE `repayment` (
  565. `repayment_id` int(11) NOT NULL,
  566. `repayment_order_id` int(11) NOT NULL,
  567. `repayment_date` int(11) NOT NULL,
  568. `repayment_amount` int(11) NOT NULL,
  569. `repayment_method` int(11) NOT NULL,
  570. `repayment_status` int(11) NOT NULL DEFAULT '0',
  571. `repayment_transaction_id` int(11) DEFAULT NULL,
  572. `repayment_equity` int(11) NOT NULL DEFAULT '0'
  573. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  574.  
  575. -- --------------------------------------------------------
  576.  
  577. --
  578. -- Table structure for table `repayment_log`
  579. --
  580.  
  581. CREATE TABLE `repayment_log` (
  582. `rl_id` int(11) NOT NULL,
  583. `rl_rs_id` int(11) DEFAULT NULL,
  584. `rl_order_id` int(11) DEFAULT NULL,
  585. `rl_title` varchar(100) NOT NULL,
  586. `rl_amount` int(11) NOT NULL,
  587. `rl_status` int(11) NOT NULL DEFAULT '0',
  588. `rl_due_date` date DEFAULT NULL,
  589. `rl_payment_date` int(11) DEFAULT NULL,
  590. `rl_userid` int(11) NOT NULL DEFAULT '0',
  591. `rl_cron` varchar(255) DEFAULT NULL
  592. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  593.  
  594. -- --------------------------------------------------------
  595.  
  596. --
  597. -- Table structure for table `retailers`
  598. --
  599.  
  600. CREATE TABLE `retailers` (
  601. `ret_id` int(11) NOT NULL,
  602. `ret_fname` varchar(100) NOT NULL,
  603. `ret_lname` varchar(100) NOT NULL,
  604. `ret_email` varchar(100) NOT NULL,
  605. `ret_company` varchar(225) NOT NULL,
  606. `ret_phone` varchar(100) NOT NULL,
  607. `ret_website` varchar(100) NOT NULL,
  608. `ret_order` varchar(225) NOT NULL,
  609. `ret_sale` varchar(225) NOT NULL,
  610. `ret_platform` varchar(225) NOT NULL,
  611. `ret_created` datetime NOT NULL,
  612. `ret_logo` varchar(225) DEFAULT NULL,
  613. `ret_updated` datetime NOT NULL,
  614. `ret_status` int(11) NOT NULL DEFAULT '0',
  615. `ret_user_id` int(11) DEFAULT NULL
  616. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  617.  
  618. --
  619. -- Dumping data for table `retailers`
  620. --
  621.  
  622. INSERT INTO `retailers` (`ret_id`, `ret_fname`, `ret_lname`, `ret_email`, `ret_company`, `ret_phone`, `ret_website`, `ret_order`, `ret_sale`, `ret_platform`, `ret_created`, `ret_logo`, `ret_updated`, `ret_status`, `ret_user_id`) VALUES
  623. (1, 'credpal', 'admin', 'riskitall2014@gmail.com', 'credpal', '9077889967', 'https://credpal.com', '5k-25k', '1M-10M', 'wordpress', '2019-03-18 19:39:24', NULL, '2019-03-20 14:22:49', 1, 1);
  624.  
  625. -- --------------------------------------------------------
  626.  
  627. --
  628. -- Table structure for table `transaction`
  629. --
  630.  
  631. CREATE TABLE `transaction` (
  632. `transaction_id` int(11) NOT NULL,
  633. `transaction_amount` float(11,2) NOT NULL,
  634. `transaction_ref` varchar(20) DEFAULT NULL,
  635. `transaction_user_id` int(11) NOT NULL,
  636. `transaction_time` int(11) NOT NULL,
  637. `transactionid` varchar(100) NOT NULL,
  638. `transaction_reference` varchar(100) DEFAULT NULL,
  639. `transaction_mobile` varchar(100) DEFAULT NULL,
  640. `transaction_authorization_code` varchar(100) DEFAULT NULL,
  641. `transaction_card_type` varchar(100) DEFAULT NULL,
  642. `transaction_last4` varchar(100) DEFAULT NULL,
  643. `transaction_exp_month` varchar(100) DEFAULT NULL,
  644. `transaction_exp_year` varchar(100) DEFAULT NULL,
  645. `transaction_reusable` varchar(100) DEFAULT NULL,
  646. `transaction_country_code` varchar(100) DEFAULT NULL,
  647. `transaction_ip_address` varchar(100) DEFAULT NULL,
  648. `transaction_customer_id` varchar(100) DEFAULT NULL,
  649. `transaction_customer_code` varchar(100) DEFAULT NULL,
  650. `transaction_first_name` varchar(100) DEFAULT NULL,
  651. `transaction_last_name` varchar(100) DEFAULT NULL,
  652. `transaction_email` varchar(100) DEFAULT NULL,
  653. `transaction_bank` varchar(100) NOT NULL
  654. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  655.  
  656. --
  657. -- Dumping data for table `transaction`
  658. --
  659.  
  660. 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
  661. (1, 1000.00, 'Success', 2, 1552766580, 'T210990888657478', 'T210990888657478', '0', 'AUTH_pw825q0z6o', 'visa DEBIT', '4081', '12', '2020', '1', 'NG', '129.56.87.130', '4512761', 'CUS_umqbq74xopfp7da', NULL, NULL, 'akhmadharuna@gmail.com', 'Test Bank'),
  662. (2, 1000.00, 'Success', 2, 1552766580, 'T210990888657478', 'T210990888657478', '0', 'AUTH_pw825q0z6o', 'visa DEBIT', '4081', '12', '2020', '1', 'NG', '129.56.87.130', '4512761', 'CUS_umqbq74xopfp7da', NULL, NULL, 'akhmadharuna@gmail.com', 'Test Bank'),
  663. (3, 1000.00, 'Success', 2, 1552766580, 'T210990888657478', 'T210990888657478', '0', 'AUTH_pw825q0z6o', 'visa DEBIT', '4081', '12', '2020', '1', 'NG', '129.56.87.130', '4512761', 'CUS_umqbq74xopfp7da', NULL, NULL, 'akhmadharuna@gmail.com', 'Test Bank');
  664.  
  665. -- --------------------------------------------------------
  666.  
  667. --
  668. -- Table structure for table `users`
  669. --
  670.  
  671. CREATE TABLE `users` (
  672. `id` int(10) UNSIGNED NOT NULL,
  673. `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  674. `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  675. `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  676. `password` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  677. `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  678. `created_at` date DEFAULT NULL,
  679. `updated_at` date DEFAULT NULL,
  680. `user_form_status` int(1) NOT NULL DEFAULT '0',
  681. `verification_option` int(11) DEFAULT NULL,
  682. `otp` int(6) NOT NULL,
  683. `bvn` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  684. `destination` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  685. `wantcard` int(11) NOT NULL DEFAULT '0',
  686. `uniquehash` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  687. `activeloan` int(11) DEFAULT '0',
  688. `avr` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  689. `paid` int(11) NOT NULL DEFAULT '0',
  690. `hostmerchantid` int(11) NOT NULL DEFAULT '0'
  691. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  692.  
  693. --
  694. -- Dumping data for table `users`
  695. --
  696.  
  697. INSERT INTO `users` (`id`, `name`, `email`, `phone`, `password`, `remember_token`, `created_at`, `updated_at`, `user_form_status`, `verification_option`, `otp`, `bvn`, `destination`, `wantcard`, `uniquehash`, `activeloan`, `avr`, `paid`, `hostmerchantid`) VALUES
  698. (2, 'John Same', 'akhmadharuna@gmail.com', '9077889967', '$2y$10$4e3ztXBCrDCVfnUXbBFXqeEx4/UGiCXYMcFgk3ydBJBs4IWa/q01W', '85Mk0G3EH0BFxHFotloz9X8W9aRwFERnc4mEPINEKvslYaxfBy0lWOshxtwr', '2019-02-22', '2019-02-22', 5, 1, 3297, '22168191802', 'web', 1, '5c87f47d8c099-1', 0, 'CpKQ7ctTo3jyYcwv.jpg', 1, 0),
  699. (3, 'Haruna Ahmadu', 'dharuna@gmail.com', '7034776388', '$2y$10$lfX/vJWcyXuVXKa4mWzCl.PZrS2Id4M6wSwtASBvA5evNWR66xfT2', NULL, '2019-02-25', '2019-02-25', 1, NULL, 8997, NULL, 'web', 0, '', 0, NULL, 0, 0),
  700. (4, 'Haruna Ahmadu', 'akhmruna@gmail.com', '7034776388', '$2y$10$kcFfiMNhMK4Xm.RGlIzzoutpm8bnj9/WhhE3W1/KfUn.cXQZbpPp6', NULL, '2019-02-25', '2019-02-25', 0, NULL, 5004, NULL, 'card', 1, '', 0, NULL, 0, 0),
  701. (5, 'Haruna Ahmadu', 'daruna@gmail.com', '7034776388', '$2y$10$vhyCfEMH4.n4DV/VqlsnDO3WsIsfyoeplbaN0cjayT8r8fjLE.Ul2', NULL, '2019-02-25', '2019-02-25', 1, NULL, 9556, NULL, 'web', 0, '', 0, NULL, 0, 0),
  702. (6, 'Admin', 'admin@credpal.com', '090999393939', '$2y$10$OyJKV9XIvwWQPW6Q0gBhTunGhXcfeICiyjlyiKY7wzlmmodJlWp8C', NULL, '2019-03-15', '2019-03-15', 0, NULL, 8888, NULL, 'checkout', 0, 'jrjiji3ji3j', 0, NULL, 0, 0);
  703.  
  704. -- --------------------------------------------------------
  705.  
  706. --
  707. -- Table structure for table `user_profile`
  708. --
  709.  
  710. CREATE TABLE `user_profile` (
  711. `user_profile_id` int(11) NOT NULL,
  712. `up_user_id` int(11) NOT NULL,
  713. `up_employment_status` int(11) DEFAULT NULL,
  714. `up_gender` varchar(5) NOT NULL,
  715. `up_address` varchar(300) NOT NULL,
  716. `up_home_status` int(11) DEFAULT NULL,
  717. `up_city` int(11) DEFAULT NULL,
  718. `up_lga` int(11) NOT NULL,
  719. `up_location` int(11) DEFAULT NULL,
  720. `up_salary` varchar(225) DEFAULT NULL,
  721. `up_occupation` varchar(100) DEFAULT NULL,
  722. `up_current_job` int(11) DEFAULT NULL,
  723. `up_employment_date` int(225) DEFAULT NULL,
  724. `up_loans` int(11) DEFAULT NULL,
  725. `up_dob` date DEFAULT NULL,
  726. `up_bvn` varchar(50) DEFAULT NULL,
  727. `up_created` int(11) DEFAULT NULL,
  728. `up_status` int(11) NOT NULL DEFAULT '0',
  729. `up_credit` decimal(10,2) DEFAULT NULL,
  730. `created_at` datetime DEFAULT NULL,
  731. `updated_at` datetime DEFAULT NULL,
  732. `up_employment_address` varchar(200) DEFAULT NULL
  733. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  734.  
  735. --
  736. -- Dumping data for table `user_profile`
  737. --
  738.  
  739. 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
  740. (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, '89000.00', '2019-02-22 22:34:51', '2019-02-22 22:34:51', 'plot 12, taiwo olugbenga crecent');
  741.  
  742. -- --------------------------------------------------------
  743.  
  744. --
  745. -- Table structure for table `xds_credit`
  746. --
  747.  
  748. CREATE TABLE `xds_credit` (
  749. `xc_id` int(11) NOT NULL,
  750. `xc_x_id` int(11) NOT NULL,
  751. `xc_user_id` int(11) NOT NULL,
  752. `DateAccountOpened` varchar(100) NOT NULL,
  753. `SubscriberName` varchar(100) NOT NULL,
  754. `AccountNo` varchar(100) NOT NULL,
  755. `SubAccountNo` varchar(100) NOT NULL,
  756. `IndicatorDescription` varchar(100) NOT NULL,
  757. `OpeningBalanceAmt` varchar(100) NOT NULL,
  758. `Currency` varchar(100) NOT NULL,
  759. `CurrentBalanceAmt` varchar(100) NOT NULL,
  760. `InstalmentAmount` varchar(100) NOT NULL,
  761. `ClosedDate` varchar(100) NOT NULL,
  762. `LoanDuration` varchar(100) NOT NULL,
  763. `RepaymentFrequency` varchar(100) NOT NULL,
  764. `LastUpdatedDate` varchar(100) NOT NULL,
  765. `PerformanceStatus` varchar(100) NOT NULL,
  766. `AccountStatus` varchar(100) NOT NULL,
  767. `xc_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  768. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  769.  
  770. --
  771. -- Dumping data for table `xds_credit`
  772. --
  773.  
  774. 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
  775. (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'),
  776. (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'),
  777. (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'),
  778. (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'),
  779. (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'),
  780. (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'),
  781. (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'),
  782. (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'),
  783. (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'),
  784. (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'),
  785. (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'),
  786. (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'),
  787. (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'),
  788. (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'),
  789. (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'),
  790. (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'),
  791. (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'),
  792. (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'),
  793. (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'),
  794. (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'),
  795. (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'),
  796. (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'),
  797. (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'),
  798. (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'),
  799. (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'),
  800. (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'),
  801. (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'),
  802. (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'),
  803. (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'),
  804. (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'),
  805. (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'),
  806. (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'),
  807. (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'),
  808. (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'),
  809. (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'),
  810. (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'),
  811. (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'),
  812. (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'),
  813. (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'),
  814. (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'),
  815. (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'),
  816. (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'),
  817. (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'),
  818. (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'),
  819. (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'),
  820. (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'),
  821. (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'),
  822. (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'),
  823. (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'),
  824. (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'),
  825. (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'),
  826. (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'),
  827. (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'),
  828. (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'),
  829. (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'),
  830. (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'),
  831. (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'),
  832. (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'),
  833. (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'),
  834. (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'),
  835. (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'),
  836. (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'),
  837. (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'),
  838. (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'),
  839. (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'),
  840. (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'),
  841. (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'),
  842. (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'),
  843. (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'),
  844. (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'),
  845. (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'),
  846. (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'),
  847. (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'),
  848. (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'),
  849. (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'),
  850. (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'),
  851. (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'),
  852. (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'),
  853. (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'),
  854. (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'),
  855. (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'),
  856. (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'),
  857. (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'),
  858. (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'),
  859. (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'),
  860. (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'),
  861. (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'),
  862. (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'),
  863. (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'),
  864. (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'),
  865. (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'),
  866. (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'),
  867. (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'),
  868. (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'),
  869. (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'),
  870. (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'),
  871. (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'),
  872. (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'),
  873. (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'),
  874. (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'),
  875. (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'),
  876. (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'),
  877. (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'),
  878. (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'),
  879. (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'),
  880. (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'),
  881. (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'),
  882. (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'),
  883. (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'),
  884. (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'),
  885. (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'),
  886. (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'),
  887. (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'),
  888. (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'),
  889. (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'),
  890. (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'),
  891. (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'),
  892. (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'),
  893. (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'),
  894. (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'),
  895. (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'),
  896. (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'),
  897. (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'),
  898. (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'),
  899. (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'),
  900. (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'),
  901. (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'),
  902. (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'),
  903. (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'),
  904. (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'),
  905. (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'),
  906. (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'),
  907. (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'),
  908. (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'),
  909. (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');
  910.  
  911. -- --------------------------------------------------------
  912.  
  913. --
  914. -- Table structure for table `xds_fullreport`
  915. --
  916.  
  917. CREATE TABLE `xds_fullreport` (
  918. `x_id` int(11) NOT NULL,
  919. `x_user_id` int(11) NOT NULL,
  920. `x_c_id` int(11) NOT NULL,
  921. `ConsumerID` int(11) NOT NULL,
  922. `SearchOutput` varchar(100) NOT NULL,
  923. `Reference` varchar(100) NOT NULL,
  924. `Header` varchar(100) NOT NULL,
  925. `ReferenceNo` varchar(100) NOT NULL,
  926. `Nationality` varchar(100) NOT NULL,
  927. `NationalIDNo` varchar(100) NOT NULL,
  928. `BankVerificationNo` varchar(100) NOT NULL,
  929. `PencomIDNo` varchar(100) NOT NULL,
  930. `otheridNo` varchar(100) NOT NULL,
  931. `BirthDate` varchar(100) NOT NULL,
  932. `Dependants` int(11) NOT NULL,
  933. `Gender` varchar(10) NOT NULL,
  934. `ResidentialAddress1` varchar(400) NOT NULL,
  935. `ResidentialAddress2` varchar(200) NOT NULL,
  936. `ResidentialAddress3` varchar(200) NOT NULL,
  937. `ResidentialAddress4` varchar(200) NOT NULL,
  938. `CellularNo` varchar(30) NOT NULL,
  939. `EmailAddress` varchar(50) NOT NULL,
  940. `PropertyOwnedType` varchar(50) NOT NULL,
  941. `Surname` varchar(100) NOT NULL,
  942. `FirstName` varchar(100) NOT NULL,
  943. `TotalMonthlyInstalment` varchar(100) NOT NULL,
  944. `TotalOutstandingdebt` varchar(100) NOT NULL,
  945. `TotalAccountarrear` int(11) NOT NULL,
  946. `Amountarrear` varchar(100) NOT NULL,
  947. `TotalAccounts` int(11) NOT NULL,
  948. `TotalAccounts1` int(11) NOT NULL,
  949. `TotalaccountinGodcondition` int(11) NOT NULL,
  950. `TotalNumberofJudgement` int(11) NOT NULL,
  951. `TotalJudgementAmount` int(11) NOT NULL,
  952. `LastJudgementDate` varchar(100) NOT NULL,
  953. `TotalNumberofDishonoured` int(11) NOT NULL,
  954. `TotalDishonouredAmount` varchar(100) NOT NULL,
  955. `TotalMonthlyInstalment1` varchar(100) NOT NULL,
  956. `TotalOutstandingdebt1` varchar(100) NOT NULL,
  957. `TotalAccountarrear1` int(11) NOT NULL,
  958. `Amountarrear1` varchar(100) NOT NULL,
  959. `TotalaccountinGodcondition1` int(11) NOT NULL,
  960. `TotalNumberofJudgement1` int(11) NOT NULL,
  961. `TotalJudgementAmount1` int(11) NOT NULL,
  962. `LastJudgementDate1` varchar(100) NOT NULL,
  963. `TotalNumberofDishonoured1` int(11) NOT NULL,
  964. `TotalDishonouredAmount1` varchar(100) NOT NULL,
  965. `Rating` int(11) NOT NULL,
  966. `NoOfHomeLoanAccountsGood` int(11) NOT NULL,
  967. `NoOfHomeLoanAccountsBad` int(11) NOT NULL,
  968. `NoOfAutoLoanccountsGood` int(11) NOT NULL,
  969. `NoOfAutoLoanAccountsBad` int(11) NOT NULL,
  970. `NoOfStudyLoanAccountsGood` int(11) NOT NULL,
  971. `NoOfStudyLoanAccountsBad` int(11) NOT NULL,
  972. `NoOfPersonalLoanAccountsGood` int(11) NOT NULL,
  973. `NoOfPersonalLoanAccountsBad` int(11) NOT NULL,
  974. `NoOfCreditCardAccountsGood` int(11) NOT NULL,
  975. `NoOfCreditCardAccountsBad` int(11) NOT NULL,
  976. `NoOfRetailAccountsGood` int(11) NOT NULL,
  977. `NoOfRetailAccountsBad` int(11) NOT NULL,
  978. `NoOfJointLoanAccountsGood` int(11) NOT NULL,
  979. `NoOfJointLoanAccountsBad` int(11) NOT NULL,
  980. `NoOfTelecomAccountsGood` int(11) NOT NULL,
  981. `NoOfTelecomAccountsBad` int(11) NOT NULL,
  982. `NoOfOtherAccountsGood` int(11) NOT NULL,
  983. `NoOfOtherAccountsBad` int(11) NOT NULL,
  984. `x_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  985. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  986.  
  987. --
  988. -- Dumping data for table `xds_fullreport`
  989. --
  990.  
  991. 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
  992. (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'),
  993. (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'),
  994. (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'),
  995. (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'),
  996. (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'),
  997. (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'),
  998. (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'),
  999. (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'),
  1000. (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'),
  1001. (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'),
  1002. (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'),
  1003. (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'),
  1004. (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'),
  1005. (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'),
  1006. (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');
  1007.  
  1008. --
  1009. -- Indexes for dumped tables
  1010. --
  1011.  
  1012. --
  1013. -- Indexes for table `admins`
  1014. --
  1015. ALTER TABLE `admins`
  1016. ADD PRIMARY KEY (`admin_id`);
  1017.  
  1018. --
  1019. -- Indexes for table `bank`
  1020. --
  1021. ALTER TABLE `bank`
  1022. ADD PRIMARY KEY (`id`);
  1023.  
  1024. --
  1025. -- Indexes for table `card`
  1026. --
  1027. ALTER TABLE `card`
  1028. ADD PRIMARY KEY (`card_id`);
  1029.  
  1030. --
  1031. -- Indexes for table `creditreport`
  1032. --
  1033. ALTER TABLE `creditreport`
  1034. ADD PRIMARY KEY (`c_id`);
  1035.  
  1036. --
  1037. -- Indexes for table `customer`
  1038. --
  1039. ALTER TABLE `customer`
  1040. ADD PRIMARY KEY (`customer_id`);
  1041.  
  1042. --
  1043. -- Indexes for table `employment_type`
  1044. --
  1045. ALTER TABLE `employment_type`
  1046. ADD PRIMARY KEY (`employment_type_id`);
  1047.  
  1048. --
  1049. -- Indexes for table `files`
  1050. --
  1051. ALTER TABLE `files`
  1052. ADD PRIMARY KEY (`file_id`);
  1053.  
  1054. --
  1055. -- Indexes for table `loans`
  1056. --
  1057. ALTER TABLE `loans`
  1058. ADD PRIMARY KEY (`id`);
  1059.  
  1060. --
  1061. -- Indexes for table `loan_repayment`
  1062. --
  1063. ALTER TABLE `loan_repayment`
  1064. ADD PRIMARY KEY (`id`,`loan_id`);
  1065.  
  1066. --
  1067. -- Indexes for table `merchants`
  1068. --
  1069. ALTER TABLE `merchants`
  1070. ADD PRIMARY KEY (`id`),
  1071. ADD UNIQUE KEY `users_email_unique` (`email`);
  1072.  
  1073. --
  1074. -- Indexes for table `migrations`
  1075. --
  1076. ALTER TABLE `migrations`
  1077. ADD PRIMARY KEY (`id`);
  1078.  
  1079. --
  1080. -- Indexes for table `oauth_access_tokens`
  1081. --
  1082. ALTER TABLE `oauth_access_tokens`
  1083. ADD PRIMARY KEY (`id`),
  1084. ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);
  1085.  
  1086. --
  1087. -- Indexes for table `oauth_auth_codes`
  1088. --
  1089. ALTER TABLE `oauth_auth_codes`
  1090. ADD PRIMARY KEY (`id`);
  1091.  
  1092. --
  1093. -- Indexes for table `oauth_clients`
  1094. --
  1095. ALTER TABLE `oauth_clients`
  1096. ADD PRIMARY KEY (`id`),
  1097. ADD KEY `oauth_clients_user_id_index` (`user_id`);
  1098.  
  1099. --
  1100. -- Indexes for table `oauth_personal_access_clients`
  1101. --
  1102. ALTER TABLE `oauth_personal_access_clients`
  1103. ADD PRIMARY KEY (`id`),
  1104. ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);
  1105.  
  1106. --
  1107. -- Indexes for table `oauth_refresh_tokens`
  1108. --
  1109. ALTER TABLE `oauth_refresh_tokens`
  1110. ADD PRIMARY KEY (`id`),
  1111. ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);
  1112.  
  1113. --
  1114. -- Indexes for table `repayment`
  1115. --
  1116. ALTER TABLE `repayment`
  1117. ADD PRIMARY KEY (`repayment_id`);
  1118.  
  1119. --
  1120. -- Indexes for table `repayment_log`
  1121. --
  1122. ALTER TABLE `repayment_log`
  1123. ADD PRIMARY KEY (`rl_id`);
  1124.  
  1125. --
  1126. -- Indexes for table `retailers`
  1127. --
  1128. ALTER TABLE `retailers`
  1129. ADD PRIMARY KEY (`ret_id`);
  1130.  
  1131. --
  1132. -- Indexes for table `transaction`
  1133. --
  1134. ALTER TABLE `transaction`
  1135. ADD PRIMARY KEY (`transaction_id`);
  1136.  
  1137. --
  1138. -- Indexes for table `users`
  1139. --
  1140. ALTER TABLE `users`
  1141. ADD PRIMARY KEY (`id`),
  1142. ADD UNIQUE KEY `email_UNIQUE` (`email`);
  1143.  
  1144. --
  1145. -- Indexes for table `user_profile`
  1146. --
  1147. ALTER TABLE `user_profile`
  1148. ADD PRIMARY KEY (`user_profile_id`),
  1149. ADD UNIQUE KEY `up_user_id` (`up_user_id`);
  1150.  
  1151. --
  1152. -- Indexes for table `xds_credit`
  1153. --
  1154. ALTER TABLE `xds_credit`
  1155. ADD PRIMARY KEY (`xc_id`);
  1156.  
  1157. --
  1158. -- Indexes for table `xds_fullreport`
  1159. --
  1160. ALTER TABLE `xds_fullreport`
  1161. ADD PRIMARY KEY (`x_id`);
  1162.  
  1163. --
  1164. -- AUTO_INCREMENT for dumped tables
  1165. --
  1166.  
  1167. --
  1168. -- AUTO_INCREMENT for table `admins`
  1169. --
  1170. ALTER TABLE `admins`
  1171. MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1172.  
  1173. --
  1174. -- AUTO_INCREMENT for table `bank`
  1175. --
  1176. ALTER TABLE `bank`
  1177. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
  1178.  
  1179. --
  1180. -- AUTO_INCREMENT for table `card`
  1181. --
  1182. ALTER TABLE `card`
  1183. MODIFY `card_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  1184.  
  1185. --
  1186. -- AUTO_INCREMENT for table `creditreport`
  1187. --
  1188. ALTER TABLE `creditreport`
  1189. MODIFY `c_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;
  1190.  
  1191. --
  1192. -- AUTO_INCREMENT for table `customer`
  1193. --
  1194. ALTER TABLE `customer`
  1195. MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  1196.  
  1197. --
  1198. -- AUTO_INCREMENT for table `files`
  1199. --
  1200. ALTER TABLE `files`
  1201. MODIFY `file_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  1202.  
  1203. --
  1204. -- AUTO_INCREMENT for table `loans`
  1205. --
  1206. ALTER TABLE `loans`
  1207. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1208.  
  1209. --
  1210. -- AUTO_INCREMENT for table `loan_repayment`
  1211. --
  1212. ALTER TABLE `loan_repayment`
  1213. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1214.  
  1215. --
  1216. -- AUTO_INCREMENT for table `merchants`
  1217. --
  1218. ALTER TABLE `merchants`
  1219. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1220.  
  1221. --
  1222. -- AUTO_INCREMENT for table `migrations`
  1223. --
  1224. ALTER TABLE `migrations`
  1225. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  1226.  
  1227. --
  1228. -- AUTO_INCREMENT for table `oauth_clients`
  1229. --
  1230. ALTER TABLE `oauth_clients`
  1231. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1232.  
  1233. --
  1234. -- AUTO_INCREMENT for table `oauth_personal_access_clients`
  1235. --
  1236. ALTER TABLE `oauth_personal_access_clients`
  1237. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  1238.  
  1239. --
  1240. -- AUTO_INCREMENT for table `repayment`
  1241. --
  1242. ALTER TABLE `repayment`
  1243. MODIFY `repayment_id` int(11) NOT NULL AUTO_INCREMENT;
  1244.  
  1245. --
  1246. -- AUTO_INCREMENT for table `repayment_log`
  1247. --
  1248. ALTER TABLE `repayment_log`
  1249. MODIFY `rl_id` int(11) NOT NULL AUTO_INCREMENT;
  1250.  
  1251. --
  1252. -- AUTO_INCREMENT for table `retailers`
  1253. --
  1254. ALTER TABLE `retailers`
  1255. MODIFY `ret_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1256.  
  1257. --
  1258. -- AUTO_INCREMENT for table `transaction`
  1259. --
  1260. ALTER TABLE `transaction`
  1261. MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  1262.  
  1263. --
  1264. -- AUTO_INCREMENT for table `users`
  1265. --
  1266. ALTER TABLE `users`
  1267. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  1268.  
  1269. --
  1270. -- AUTO_INCREMENT for table `user_profile`
  1271. --
  1272. ALTER TABLE `user_profile`
  1273. MODIFY `user_profile_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1274.  
  1275. --
  1276. -- AUTO_INCREMENT for table `xds_credit`
  1277. --
  1278. ALTER TABLE `xds_credit`
  1279. MODIFY `xc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;
  1280.  
  1281. --
  1282. -- AUTO_INCREMENT for table `xds_fullreport`
  1283. --
  1284. ALTER TABLE `xds_fullreport`
  1285. 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!