-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Jan 07, 2026 at 10:12 AM -- Server version: 8.0.31 -- PHP Version: 8.0.26 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `savingloandb` -- CREATE DATABASE IF NOT EXISTS `savingloandb` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; USE `savingloandb`; -- -------------------------------------------------------- -- -- Table structure for table `clients` -- DROP TABLE IF EXISTS `clients`; CREATE TABLE IF NOT EXISTS `clients` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title` enum('Mr','Mrs','Miss','Dr','Prof') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `surname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `other_names` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` enum('Male','Female') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` date DEFAULT NULL, `place_of_birth` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gps_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ghana_card_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `branch` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type_of_account_1` enum('Savings_and_Susu_Account','Kids_and_Student_Account','Salary_Account','Group_Account','Xmas_Account','Business_Account','Shares_Account','Fixed_Deposits_Account','Investment_Portfolio_Account','Retirement_Account') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `initial_deposit_1` decimal(12,2) DEFAULT NULL, `type_of_account_2` enum('Savings_and_Susu_Account','Kids_and_Student_Account','Salary_Account','Group_Account','Xmas_Account','Business_Account','Shares_Account','Fixed_Deposits_Account','Investment_Portfolio_Account','Retirement_Account') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `initial_deposit_2` decimal(12,2) DEFAULT NULL, `type_of_account_3` enum('Savings_and_Susu_Account','Kids_and_Student_Account','Salary_Account','Group_Account','Xmas_Account','Business_Account','Shares_Account','Fixed_Deposits_Account','Investment_Portfolio_Account','Retirement_Account') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `initial_deposit_3` decimal(12,2) DEFAULT NULL, `beneficiary1_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `beneficiary1_relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `beneficiary1_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `beneficiary2_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `beneficiary2_relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `beneficiary2_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ghana_card_copy` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `offer_letter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=195 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `clients` -- INSERT INTO `clients` (`id`, `account_number`, `title`, `surname`, `first_name`, `other_names`, `gender`, `dob`, `place_of_birth`, `nationality`, `phone`, `email`, `gps_address`, `ghana_card_no`, `bank_name`, `branch`, `bank_account_number`, `type_of_account_1`, `initial_deposit_1`, `type_of_account_2`, `initial_deposit_2`, `type_of_account_3`, `initial_deposit_3`, `beneficiary1_name`, `beneficiary1_relationship`, `beneficiary1_phone`, `beneficiary2_name`, `beneficiary2_relationship`, `beneficiary2_phone`, `photo`, `ghana_card_copy`, `offer_letter`, `created_at`, `updated_at`) VALUES (1, 'OBGCCU00001', 'Mr', 'Hagan', 'Samuel', 'Kwabena', 'Male', '1997-01-07', NULL, 'Ghanaian', '0547264474', 'GSAMMYHAGAN@gmail.com', 'ES-0009-3132', 'GHA-721427866-7', 'GCB', 'New Town', '1181120004452', 'Savings_and_Susu_Account', '0.00', '', '0.00', '', '0.00', 'Nicholas Hagan', NULL, '0545176909', 'Nicholina Hagan', NULL, '0556634730', '', '', '', '2025-07-09 00:00:00', '2026-01-02 10:03:03'), (2, 'OBGCCU00002', '', 'Klutse', 'Joana', '', 'Female', '1998-10-23', '', 'Ghanaian', '0548174733', 'klutsejoana@gmail.com', 'ES-0002-7228', 'GHA-721665647-2', 'Momo', 'Koforidua', '0548174733', '', '0.00', '', '0.00', '', '0.00', 'Georgina Amekudzi', '', '0248215988', 'Jerry Klutse', '', '0546997613', '', '', '', '2025-07-09 00:00:00', '0000-00-00 00:00:00'), (3, 'OBGCCU00003', '', 'Kweikie', 'Grace', '', 'Female', '1993-12-07', '', 'Ghanaian', '0247449692', 'gracenartey014@gmail.com', '', '', 'momo', 'suhum', '0531929079', '', '0.00', '', '0.00', '', '0.00', 'Samuel Quayson', '', '0247449692', 'Rachel Quayson', '', '0247449692', '', '', '', '2025-07-21 00:00:00', '0000-00-00 00:00:00'), (4, 'OBGCCU00004', '', 'Coffie', 'Mavis', '', 'Female', '1986-05-30', '', 'Ghanaian', '0245476802', '', 'ES-0010-8790', 'GHA-001331880-0', 'momo', 'suhum', '0245476802', '', '0.00', '', '0.00', '', '0.00', 'Justice Botwe', '', '0549969944', 'Botwe Nhyira', '', '0549969944', '', '', '', '2025-07-22 00:00:00', '0000-00-00 00:00:00'), (5, 'OBGCCU00005', '', 'Osieku', 'Eunice', '', 'Female', '1994-06-15', '', 'Ghanaian', '0546000803', '', 'ES-0010-8790', 'GHA-000176857-2', 'momo', 'suhum', '0546000803', '', '0.00', '', '0.00', '', '0.00', 'Emmanuel Madjitey', '', '0546000803', 'Dede Blessing', '', '0546000803', '', '', '', '2025-07-22 00:00:00', '0000-00-00 00:00:00'), (6, 'OBGCCU00006', '', 'Dede', 'Matilda', '', 'Female', '1996-01-01', '', 'Ghanaian', '0556875403', '', 'ES-0010-9204', 'GHA-721651747-6', 'momo', 'suhum', '055687503', '', '0.00', '', '0.00', '', '0.00', 'Nimo Flex', '', '0556875403', '', '', '', '', '', '', '2025-07-22 00:00:00', '0000-00-00 00:00:00'), (7, 'OBGCCU00007', '', 'Nyarko', 'Christiana', 'Ashong', 'Female', '1969-04-06', '', 'Ghanaian', '0536290811', '', 'ES-0030-4263', 'GHA-72218951-4', 'momo', 'suhum', '0536290811', '', '0.00', '', '0.00', '', '0.00', 'Francis Obeng', '', '0249483991', 'Richeal Ashong', '', '0592128918', '', '', '', '2025-07-22 00:00:00', '0000-00-00 00:00:00'), (8, 'OBGCCU00008', '', 'Somuah', 'Florence', '', 'Female', '1992-12-14', '', 'Ghanaian', '0530644398', 'somuahflorence@gmail.com', 'ES-0030-3745', 'GHA-00434062-7', 'momo', 'suhum', '0530644398', '', '0.00', '', '0.00', '', '0.00', 'Samuel Somuah', '', '0245910647', 'Mandy Adom', '', '0245910647', '', '', '', '2025-07-22 00:00:00', '0000-00-00 00:00:00'), (9, 'OBGCCU00009', '', 'Boateng', 'Isaac', '', 'Male', '1988-02-12', '', 'Ghanaian', '0249581873', 'isaacboateng1873@gmail.com', 'ES-0088-6302', 'GHA-721208135-5', 'momo', 'suhum', '0249581873', '', '0.00', '', '0.00', '', '0.00', 'Atiemo Emmanuel', '', '0544664959', 'Jennifer Boateng', '', '0548382774', '', '', '', '2025-07-23 00:00:00', '0000-00-00 00:00:00'), (10, 'OBGCCU00010', '', 'Amissah', 'Gifty', 'Bondziwaa', 'Female', '1991-01-04', '', 'Ghanaian', '0240090519', '', 'ES-0010-0990', 'GHA-721948562-4', 'momo', 'suhum', '0240090519', '', '0.00', '', '0.00', '', '0.00', 'Rev. Jacob Agyakum', '', '0249133067', 'Gladys Agyakum', '', '0249133057', '', '', '', '2025-07-23 00:00:00', '0000-00-00 00:00:00'), (11, 'OBGCCU00011', '', 'Dziwono', 'Lydia', '', 'Female', '1992-03-23', '', 'Ghanaian', '0541450662', '', 'ES-0010-8790', 'GHA-722988241-7', 'momo', 'suhum', '0541450662', '', '0.00', '', '0.00', '', '0.00', 'MadjiteyJones', '', '0541450662', 'Jonathan Tetteh', '', '0541450662', '', '', '', '2025-07-30 00:00:00', '0000-00-00 00:00:00'), (12, 'OBGCCU00012', '', 'Madjtey', 'David', '', 'Male', '1989-10-12', '', 'Ghanaian', '0247928154', '', 'ES-0010-8790', 'GHA-722995036-5', 'momo', 'suhum', '0247928154', '', '0.00', '', '0.00', '', '0.00', 'Blessing Dede', '', '0247928154', 'Afidi Emmanuel', '', '0247928154', '', '', '', '2025-07-28 00:00:00', '0000-00-00 00:00:00'), (13, 'OBGCCU00013', '', 'Maku', 'Gladys', '', 'Female', '1970-02-28', '', 'Ghanaian', '0531401565', '', 'ES-0010-8790', 'GHA-729089584-0', 'momo', 'suhum', '0531401565', '', '0.00', '', '0.00', '', '0.00', 'Madjitey David', '', '0247928154', 'Eric Laweh', '', '0247928154', '', '', '', '2025-07-28 00:00:00', '0000-00-00 00:00:00'), (14, 'OBGCCU00014', '', 'Teye', 'Patience', '', 'Female', '1974-03-05', '', 'Ghanaian', '0557312676', '', '', 'GHA-722411039-5', 'momo', 'suhum', '0557312676', '', '0.00', '', '0.00', '', '0.00', 'Florence Dzibodzi', '', '0530549513', 'Eric Dzibodzi', '', '0595376492', '', '', '', '2025-07-30 00:00:00', '0000-00-00 00:00:00'), (15, 'OBGCCU00015', '', 'Amponsah', 'Ruth', '', 'Female', '1994-02-23', '', 'Ghanaian', '0245472183', '', 'ES-0010-8790', 'GHA-721584935-8', 'momo', 'Suhum', '0245472183', '', '0.00', '', '0.00', '', '0.00', 'George Asirifi', '', '0246236599', 'Bernard Nyarko', '', '0245472183', '', '', '', '2025-07-31 00:00:00', '0000-00-00 00:00:00'), (16, 'OBGCCU00016', '', 'Gbogbogah', 'Francis', '', 'Male', '2003-07-04', '', 'Ghanaian', '0530677449', '', 'ES-0033-5749', 'GHA-721905464-0', 'momo', 'Suhum', '0530677449', '', '0.00', '', '0.00', '', '0.00', 'Gbogbogah Richard', '', '0599031486', 'Gbogbogah wisdom', '', '0556546616', '', '', '', '2025-07-31 00:00:00', '0000-00-00 00:00:00'), (17, 'OBGCCU00017', '', 'Christiana', 'Tetteh', '', 'Female', '1987-06-10', '', 'Ghanaian', '0540429573', '', 'ES-0010-0893', 'GHA-722878763-4', 'momo', 'suhum', '0540429573', '', '0.00', '', '0.00', '', '0.00', 'Blessing Adubea', '', '054557414', 'Felix Boakye', '', '0545574714', '', '', '', '2025-07-22 00:00:00', '0000-00-00 00:00:00'), (18, 'OBGCCU00018', '', 'Tetedzi', 'Agatha', '', 'Female', '2000-02-03', '', 'Ghanaian', '0554569860', 'maametete1234@gmail:com', 'GA-393-2892', 'GHA-000260774-0', 'momo', 'Suhum', '0554569860', '', '0.00', '', '0.00', '', '0.00', 'Augustina Tetedze', '', '0574755989', 'Deborah Tetedze', '', '0549428807', '', '', '', '2025-08-01 00:00:00', '0000-00-00 00:00:00'), (19, 'OBGCCU00019', '', 'Aboagye', 'Richard', 'Kwesi', 'Male', '1972-07-23', '', 'Ghanaian', '0542786808', 'kwesiaboagyerichard44@gmail.com', 'GA-002-0774', 'GHA-002404968-5', 'momo', 'Silver star', '1441002620471', '', '0.00', '', '0.00', '', '0.00', 'Fidel Kwesi Aboagye', '', '0533645253', 'Tyra Yaa Aboagye', '', '0247279726', '', '', '', '2025-08-06 00:00:00', '0000-00-00 00:00:00'), (20, 'OBGCCU00020', '', 'Torho', 'Bless', 'Kumako', 'Female', '2000-12-17', '', 'Ghanaian', '0549313448', 'blessmako@gmail.com', '', 'GHA-001389471-5', 'GCB', 'suhum', '0549313448', '', '0.00', '', '0.00', '', '0.00', 'Courage Kofi Kumako', '', '0537631148', 'Richwell Agyei okyere', '', '0544009477', '', '', '', '2025-07-16 00:00:00', '0000-00-00 00:00:00'), (21, 'OBGCCU00021', '', 'Narteh', 'louis', 'Tcherbi', 'Male', '1980-03-12', '', 'Ghanaian', '0247808655', 'louistcherbinarteh@23gmail.com', 'ES-0090-2574', 'GHA-721662685-1', 'momo', 'Suhum', '0247808655', '', '0.00', '', '0.00', '', '0.00', 'Hellen Tcherbi', '', '0243523767', '', '', '', '', '', '', '2025-04-08 00:00:00', '0000-00-00 00:00:00'), (22, 'OBGCCU00022', '', 'Torglah', 'Angela', '', 'Female', '2006-02-18', '', 'Ghanaian', '', '', '', '', 'momo', 'Suhum', '0247810380', '', '0.00', '', '0.00', '', '0.00', 'Nartey Haggar', '', '0550389315', '', '', '', '', '', '', '2025-08-01 00:00:00', '0000-00-00 00:00:00'), (23, 'OBGCCU00024', '', 'Kodua', 'Spebby', 'Agyepong', 'Male', '1991-07-03', '', 'Ghanaian', '0244121205', 'CitizenOwuraku1@gmail.com', '', 'GHA-000896312-1', 'momo', 'Suhum', '0244121205', '', '0.00', '', '0.00', '', '0.00', 'Vivian Agyepong', '', '0242310055', 'Jason Obrempong', '', '0556809859', '', '', '', '2025-07-08 00:00:00', '0000-00-00 00:00:00'), (24, 'OBGCCU00025', '', 'Odame', 'Benjamine', '', 'Male', '1988-05-10', '', 'Ghanaian', '0542403842', '', 'ES-0041-4124', 'GHA-722528097-0', 'momo', 'Suhum', '0542403842', '', '0.00', '', '0.00', '', '0.00', 'Samuel Odame', '', '0547591306', 'Albert Tekyi', '', '0594071191', '', '', '', '2025-07-08 00:00:00', '0000-00-00 00:00:00'), (25, 'OBGCCU00026', '', 'Ayisi', 'Daniel', '', 'Male', '2005-03-29', '', 'Ghanaian', '0535255687', 'Asarelinda@gmail.com', '', '', 'momo', 'Suhum', '053255687', '', '0.00', '', '0.00', '', '0.00', 'Kwanpong Jonathan', '', '0535255687', '', '', '', '', '', '', '2025-08-08 00:00:00', '0000-00-00 00:00:00'), (26, 'OBGCCU00027', '', 'Odoi', 'Bright', '', 'Male', '1989-09-07', '', 'Ghanaian', '0277198510', '', '', '', 'momo', 'Suhum', '0277198510', '', '0.00', '', '0.00', '', '0.00', 'Patrick Odoi', '', '0241806063', 'Emmanuel Adjatey', '', '0249227842', '', '', '', '2025-08-06 00:00:00', '0000-00-00 00:00:00'), (27, 'OBGCCU00028', '', 'Tordzro', 'Abigail', 'Novinyo', 'Female', '1996-09-26', '', 'Ghanaian', '0541225767', 'tordzroabigail@gmail.com', 'GA-0318-415', 'GHA-713660220-7', 'momo', 'Adaklu Anfoe', '0541225767', '', '0.00', '', '0.00', '', '0.00', 'Tordzro Kelvin', '', '0246914408', 'Irene Atepreh', '', '0592414575', '', '', '', '2025-08-08 00:00:00', '0000-00-00 00:00:00'), (28, 'OBGCCU00030', '', 'Otwey', 'Constance', '', 'Female', '1976-11-25', '', 'Ghanaian', '0555487634', 'constanceotwey@gmail\'com', 'ES-0064-4928', 'GHA-005238778-6', 'momo', 'Suhum', '0555487634', '', '0.00', '', '0.00', '', '0.00', 'Esther Koomson', '', '0558384002', 'Frank Otwey', '', '05921242132', '', '', '', '2025-08-13 00:00:00', '0000-00-00 00:00:00'), (29, 'OBGCCU00031', '', 'Teye', 'Alex', '', 'Male', '1985-05-08', '', 'Ghanaian', '0553408777', '', 'ES-0064-4928', 'GHA-713477140-0', 'momo', 'Suhum', '0553408777', '', '0.00', '', '0.00', '', '0.00', 'Samuel Adepa Teye', '', '0553408777', 'Deborah Teye', '', '0553408777', '', '', '', '2025-08-13 00:00:00', '0000-00-00 00:00:00'), (30, 'OBGCCU00032', '', 'Kpodo', 'Elorm', '', 'Male', '2000-11-08', '', 'Ghanaian', '0544222914', 'elorm62@gmail.com', 'ES-0006-4553', 'GHA-721980682-7', 'momo', 'Suhum', '0544222914', '', '0.00', '', '0.00', '', '0.00', 'Joel Kpodo', '', '0544222914', 'Jerome Kpodo', '', '0544222914', '', '', '', '2025-08-13 00:00:00', '0000-00-00 00:00:00'), (31, 'OBGCCU00033', '', 'Asomani', 'William', 'Diabene', 'Male', '0000-00-00', '', 'Ghanaian', '0557966766', '', '', '', 'MOmo', 'Suhum', '0557966766', '', '0.00', '', '0.00', '', '0.00', 'Richard Asomani', '', '0540500380', 'Mary Sackey', '', '', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (32, 'OBGCCU00034', '', 'Philip', 'Oteng', 'yaw', 'Male', '1995-02-02', '', 'Ghanaian', '0557352095', 'otplilipq@gmail.com', 'ES-0010-5366', 'GHA-723182501-3', 'momo', 'Suhum', '0240870563', '', '0.00', '', '0.00', '', '0.00', 'Samuel Adu', '', '0500558357', 'Kumah Carolina', '', '0557352095', '', '', '', '2025-08-14 00:00:00', '0000-00-00 00:00:00'), (33, 'OBGCCU00035', '', 'Aduba', 'Rebecca', '', 'Female', '2002-06-17', '', 'Ghanaian', '0597729811', '', '', 'GHA-723006111-9', 'momo', 'Suhum', '0597729811', '', '0.00', '', '0.00', '', '0.00', 'Sandra Dunyo', '', '0241768215', 'Augustina Awuku', '', '0546326834', '', '', '', '2025-08-19 00:00:00', '0000-00-00 00:00:00'), (34, 'OBGCCU00036', '', 'Alormene', 'Justice', 'Kwabla', 'Male', '1996-09-17', '', 'Ghanaian', '0543024918', 'AJUSTICE0543@gmail.com', 'ES-0097-1690', 'GH-713624242-7', 'ADB', 'Suhum', '2022000164193001', '', '0.00', '', '0.00', '', '0.00', 'Daniella Alormene', '', '0555045626', 'Godsway Alormene', '', '0538270133', '', '', '', '2025-08-19 00:00:00', '0000-00-00 00:00:00'), (35, 'OBGCCU00037', '', 'Asamaniwaa', 'Agnes', '', 'Female', '1996-08-26', '', 'Ghanaian', '0556043663', '', 'ES-0057-0129', 'GHA-721693646-4', 'momo', 'Suhum', '0556043663', '', '0.00', '', '0.00', '', '0.00', 'Agyei Charlotte Iris Narkie', '', '0556043663', '', '', '', '', '', '', '2025-08-26 00:00:00', '0000-00-00 00:00:00'), (36, 'OBGCCU00038', '', 'Debrah', 'Isaac', '', 'Male', '1998-09-23', '', 'Ghanaian', '0545371157', 'DebrahIsaac@gmail.com', '', '', 'momo', 'Suhum', '0545371157', '', '0.00', '', '0.00', '', '0.00', 'Tei Benisom', '', '0545371157', 'Debrah Melody', '', '0545371157', '', '', '', '2025-08-18 00:00:00', '0000-00-00 00:00:00'), (37, 'OBGCCU00039', '', 'Atta', 'Benjamine', '', 'Male', '1959-01-01', '', 'Ghanaian', '0248602610', '', 'ES-0030-8402', 'GHA-722419605-8', 'momo', 'Suhum', '0248602610', '', '0.00', '', '0.00', '', '0.00', 'Juliana Dankwa', '', '0249151440', 'Comfort Asabea', '', '0247337125', '', '', '', '2025-08-19 00:00:00', '0000-00-00 00:00:00'), (38, 'OBGCCU00040', '', 'Owusu', 'Richmond', '', 'Male', '2002-07-02', '', 'Ghanaian', '0597991267', '', '', 'GHA-722239067-6', 'momo', 'Suhum', '0597991267', '', '0.00', '', '0.00', '', '0.00', 'Christine Darko', '', '0209600328', 'Theresa Aboagye', '', '0551824613', '', '', '', '2025-08-18 00:00:00', '0000-00-00 00:00:00'), (39, 'OBGCCU00041', '', 'Okley', 'Abena', '', 'Female', '1979-03-18', '', 'Ghanaian', '0540043898', '', 'ES-0033-5749', 'GHA-712428805-1', 'momo', 'Suhum', '0540043898', '', '0.00', '', '0.00', '', '0.00', 'lorencia Odoi', '', '0500424988', 'Matey Odoi', '', '0540043898', '', '', '', '2025-08-25 00:00:00', '0000-00-00 00:00:00'), (40, 'OBGCCU00042', '', 'Amanor', 'Florence', '', 'Female', '1991-10-10', '', 'Ghanaian', '0543656248', '', '', 'GHA-727676460-9', 'MOmo', 'SUhum', '0543656248', '', '0.00', '', '0.00', '', '0.00', 'Mavis Amanor', '', '0547617135', 'Emmanuel Osabutey', '', '0596882193', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (41, 'OBGCCU00043', '', 'Seidu', 'Zinatu', '', 'Female', '1987-07-06', '', 'Ghanaian', '0249463191', '', 'ES-0008-0832', 'GHA-722324194-8', 'momo', 'Suhum', '0249463191', '', '0.00', '', '0.00', '', '0.00', 'Amdiatu Seidu', '', '0543595885', 'Senatu Seidu', '', '0249463191', '', '', '', '2025-08-28 00:00:00', '0000-00-00 00:00:00'), (42, 'OBGCCU00044', '', 'Issah', 'Rarbi', '', 'Female', '1985-07-01', '', 'Ghanaian', '0547127671', '', 'ES-0008-0832', 'GHA-722174731-8', 'momo', 'Suhum', '0547127671', '', '0.00', '', '0.00', '', '0.00', 'Mahammed Issah', '', '0538140111', 'Salamatu Issah', '', '0538140111', '', '', '', '2025-08-28 00:00:00', '0000-00-00 00:00:00'), (43, 'OBGCCU00046', '', 'Ayertey', 'Charity', '', 'Female', '1958-09-24', '', 'Ghanaian', '0241856533', '', 'ES-0021-2412', 'GHA-721412952-5', 'momo', 'Suhum', '0241856533', '', '0.00', '', '0.00', '', '0.00', 'Martin Ayertey', '', '0241856533', '', '', '', '', '', '', '2025-08-28 00:00:00', '0000-00-00 00:00:00'), (44, 'OBGCCU00047', '', 'Osafo', 'Gideon', '', 'Male', '1992-02-12', '', 'Ghanaian', '0542535726', 'Osafogideon45@gmail.com', 'ES-0068-8533', 'GHA-721308689-6', 'momo', 'Suhum', '0203606141', '', '0.00', '', '0.00', '', '0.00', 'Jacqueline Gyamfi', '', '0247586304', 'Lydia Serwaa', '', '0241563336', '', '', '', '2025-01-09 00:00:00', '0000-00-00 00:00:00'), (45, 'OBGCCU00048', '', 'Abban', 'Samuel', '', 'Male', '1988-03-06', '', 'Ghanaian', '0244553540', '', 'ES-0010-8790', 'GHA-722653448-5', 'momo', 'Suhum', '0244553540', '', '0.00', '', '0.00', '', '0.00', 'Richard Darko', '', '0244553540', 'Nora Addo', '', '0595841663', '', '', '', '2025-02-09 00:00:00', '0000-00-00 00:00:00'), (46, 'OBGCCU00049', '', 'Amue', 'David', '', 'Male', '1986-03-03', '', 'Ghanaian', '0240534983', '', 'ES-0010-8790', 'GHA-723111023-0', 'momo', 'Suhum', '0240534983', '', '0.00', '', '0.00', '', '0.00', 'Jude Ademan', '', '0240534983', 'Jonathan Aseman', '', '0547904543', '', '', '', '2025-02-09 00:00:00', '0000-00-00 00:00:00'), (47, 'OBGCCU00050', '', 'Asamoah', 'Godwin', 'Kotoku', 'Male', '1992-05-05', '', 'Ghanaian', '0546422893', '', '', 'GHA-722186975-1', 'momo', 'Suhum', '0546422893', '', '0.00', '', '0.00', '', '0.00', 'Benedicta Kotoku', '', '0552901541', 'Rubby Kotoku', '', '0546422893', '', '', '', '2025-02-09 00:00:00', '0000-00-00 00:00:00'), (48, 'OBGCCU00051', '', 'Ansah', 'Derrick', '', 'Male', '2004-04-04', '', 'Ghanaian', '0503285641', '', '', 'GHA-727772520-3', 'momo', 'Suhum', '0503285641', '', '0.00', '', '0.00', '', '0.00', '', '', '', '', '', '', '', '', '', '2025-02-09 00:00:00', '0000-00-00 00:00:00'), (49, 'OBGCCU00052', '', 'Djaba', 'Beatrice', 'Korkor', 'Female', '2001-01-19', '', 'Ghanaian', '0537543231', '', 'ES-0008-7390', 'GHA-722547422-5', 'momo', 'Suhum', '0537543231', '', '0.00', '', '0.00', '', '0.00', 'Gebriel Djaba', '', '0552986529', 'Sara Narki', '', '0531366257', '', '', '', '2025-03-09 00:00:00', '0000-00-00 00:00:00'), (50, 'OBGCCU00053', '', 'Charnor', 'Collins', 'Nagertey', 'Male', '1989-03-28', '', 'Ghanaian', '0546979822', '', '', 'GHA-721879644-6', 'momo', 'Suhum', '0546979822', '', '0.00', '', '0.00', '', '0.00', 'Beatrice Danso', '', '0546979822', 'Isaac Nagertey', '', '0244892105', '', '', '', '2025-03-09 00:00:00', '0000-00-00 00:00:00'), (51, 'OBGCCU00054', '', 'Gbogbogah', 'Richard', '', 'Male', '1995-05-18', '', 'Ghanaian', '0599031486', 'gbogbogahrichard200@gmail.com', 'ES-0033-5749', 'GHA-721903570-2', 'momo', 'Suhum', '0599031486', '', '0.00', '', '0.00', '', '0.00', 'Gbogbogah Francis', '', '0530677449', 'Gbogbogah Wisdom', '', '0556546616', '', '', '', '2025-03-09 00:00:00', '0000-00-00 00:00:00'), (52, 'OBGCCU00055', '', 'Danso', 'George', '', 'Male', '1972-04-25', '', 'Ghanaian', '0596787049', '', 'ES-0008-6807', 'GHA-721316257-4', 'momo', 'Suhum', '0596787049', '', '0.00', '', '0.00', '', '0.00', 'Derrick Asare', '', '0548741523', 'Kwesi Baah', '', '0596787049', '', '', '', '2025-03-09 00:00:00', '0000-00-00 00:00:00'), (53, 'OBGCCU00056', '', 'Barima', 'Sandra', '', 'Female', '1998-09-08', '', 'Ghanaian', '0248110284', '', 'ES-0033-5749', 'GHA-722670053-0', 'MOmo', 'Suhum', '0248110284', '', '0.00', '', '0.00', '', '0.00', 'kendy Agyei Boatey', '', '0241683520', 'Doctor Agyei Boatey', '', '0241683520', '', '', '', '2025-04-08 00:00:00', '0000-00-00 00:00:00'), (54, 'OBGCCU00057', '', 'Agyei', 'Boatey', '', 'Male', '1991-06-07', '', 'Ghanaian', '0241683520', '', 'ES-0033-5749', 'GHA-0022622767', 'MOmo', 'Suhum', '0241683520', '', '0.00', '', '0.00', '', '0.00', 'Kendy Agyei Boatey', '', '0241683520', 'Doctor Agyei Boatey', '', '0241683520', '', '', '', '2025-03-09 00:00:00', '0000-00-00 00:00:00'), (55, 'OBGCCU00058', '', 'Addo', 'Justina', '', 'Female', '1989-08-03', '', 'Ghanaian', '0552511774', '', 'ES-0033-5449', 'GHA-727442471-0', 'momo', 'Suhum', '0552511774', '', '0.00', '', '0.00', '', '0.00', 'Richard Addo', '', '0242372870', 'Addo Marin', '', '0544168974', '', '', '', '2025-03-09 00:00:00', '0000-00-00 00:00:00'), (56, 'OBGCCU00059', '', 'Sagba', 'Regina', '', 'Female', '1979-09-19', '', 'Ghanaian', '0556546616', '', 'ES-0033-5749', 'GHA-722265007-5', 'momo', 'Suhum', '0556546616', '', '0.00', '', '0.00', '', '0.00', 'Romed Annane', '', '0556546616', 'Richard Gbogbogah', '', '0549719923', '', '', '', '2025-03-09 00:00:00', '0000-00-00 00:00:00'), (57, 'OBGCCU00060', '', 'Tetteh', 'Ismeal', '', 'Male', '1998-06-01', '', 'Ghanaian', '0533586968', '', 'ES-0008-7390', 'GHA-722595947-8', 'MOmo', 'Suhum', '0533586968', '', '0.00', '', '0.00', '', '0.00', 'Nancy Tetteh', '', '0542831542', 'Sarah Tetteh', '', '0534472812', '', '', '', '2025-05-09 00:00:00', '0000-00-00 00:00:00'), (58, 'OBGCCU00061', '', 'Adiku', 'Esther', '', 'Female', '1975-04-15', '', 'Ghanaian', '0244652948', '', 'ES-0000-9174', 'GHA-712519139-6', 'MOmo', 'Suhum', '0244652948', '', '0.00', '', '0.00', '', '0.00', 'Richmond Siaw', '', '0240746698', 'Janet Azamadi', '', '0531809931', '', '', '', '2025-05-09 00:00:00', '0000-00-00 00:00:00'), (59, 'OBGCCU00062', '', 'Donkor', 'Ruth', '', 'Female', '1994-03-23', '', 'Ghanaian', '0241491272', '', 'ES-0008-6807', 'GHA-721952797-7', 'MOmo', 'Suhum', '0241491272', '', '0.00', '', '0.00', '', '0.00', 'Derrick Asare', '', '0548741523', 'Kwesi Baah', '', '0241491272', '', '', '', '2025-05-09 00:00:00', '0000-00-00 00:00:00'), (60, 'OBGCCU00063', '', 'lartey', 'Comfort', '', 'Female', '1978-03-07', '', 'Ghanaian', '0544718435', '', 'ES-0030-0187', 'GHA-721518559-7', 'MOmo', 'Suhum', '0544718435', '', '0.00', '', '0.00', '', '0.00', 'Ismeal Addo', '', '0240390573', 'Nyarkowaa Mary', '', '0531333770', '', '', '', '2025-05-09 00:00:00', '0000-00-00 00:00:00'), (61, 'OBGCCU00064', '', 'Adjei', 'Nana', 'Emmanuel', 'Male', '1967-03-16', '', 'Ghanaian', '0206969882', '', 'ES-0030-0187', 'GHA-722918782-6', 'MOmo', 'Suhum', '0206969882', '', '0.00', '', '0.00', '', '0.00', 'Richmond Adjei', '', '0535611310', 'Dorine Adjei', '', '0206969882', '', '', '', '2025-04-09 00:00:00', '0000-00-00 00:00:00'), (62, 'OBGCCU00065', '', 'Oforiwaa', 'Susana', '', 'Female', '1974-09-07', '', 'Ghanaian', '0558778037', '', 'ES-0029-4638', 'GHA-722298659-6', 'MOmo', 'Suhum', '0558778037', '', '0.00', '', '0.00', '', '0.00', 'Jason Ela', '', '0558778037', 'Deborah Nique', '', '0245069440', '', '', '', '2025-04-09 00:00:00', '0000-00-00 00:00:00'), (63, 'OBGCCU00066', '', 'Akweley', 'Mary', '', 'Female', '1985-07-04', '', 'Ghanaian', ';0246905836', '', 'ES-0030-0187', 'GHA-722180153-9', 'MOmo', 'Suhum', '0246905836', '', '0.00', '', '0.00', '', '0.00', 'Asamoah Mark', '', '0531382115', 'Asamoah Mary', '', '0246905836', '', '', '', '2025-05-09 00:00:00', '0000-00-00 00:00:00'), (64, 'OBGCCU00067', '', 'larbi', 'Jason', 'Ela', 'Male', '2003-04-09', '', 'Ghanaian', '0204064991', '', 'ES-0029-4638', 'GHA-0047875447-6', 'MOmo', 'Suhum', '0204064991', '', '0.00', '', '0.00', '', '0.00', 'Deborah Nique', '', '0245069440', 'Cindy Sakyie', '', '0536370661', '', '', '', '2025-05-09 00:00:00', '0000-00-00 00:00:00'), (65, 'OBGCCU00068', '', 'Odama', 'Jonas', 'Yirenkyi', 'Male', '1974-06-05', '', 'Ghanaian', '', '', 'EO-1320-3637', 'GHA-002329836-9', 'MOmo', 'Suhum', '0244903179', '', '0.00', '', '0.00', '', '0.00', 'Gloria Agyire', '', '0244903179', '', '', '', '', '', '', '2025-05-09 00:00:00', '0000-00-00 00:00:00'), (66, 'OBGCCU00069', '', 'Agyiri', 'Gloria', '', 'Female', '1982-01-25', '', 'Ghanaian', '0242180530', 'Gloriaagyiri82@gmail.com', 'EO-1320-3637', 'GHA-000420768-9', 'MOmo', 'Suhum', '0242180530', '', '0.00', '', '0.00', '', '0.00', 'Awurama Ayisi', '', '0242180530', 'Nana Akua Ayisi', '', '0242180530', '', '', '', '2025-05-09 00:00:00', '0000-00-00 00:00:00'), (67, 'OBGCCU00070', '', 'Karl', 'Jessica', '', 'Female', '1976-07-01', '', 'Ghanaian', '024413264', '', 'TN-11', 'GHA-721805509-9', 'Momo', 'SUhum', '024413264', '', '0.00', '', '0.00', '', '0.00', 'Pastaline Selasie', '', '0552425261', 'Amoako Vincent', '', '0552109101', '', '', '', '2025-09-17 00:00:00', '0000-00-00 00:00:00'), (68, 'OBGCCU00071', '', 'Nartey', 'Naomi', '', 'Female', '1984-06-08', '', 'Ghanaian', '0244749211', '', 'TN-11', 'GHA-721805659-7', 'MOmo', 'SUhum', '0244749211', '', '0.00', '', '0.00', '', '0.00', 'Larbi Raphal', '', '0244740308', 'larbi Lawrencia', '', '0536763154', '', '', '', '2025-09-17 00:00:00', '0000-00-00 00:00:00'), (69, 'OBGCCU00072', '', 'Gyimah', 'Comfort', '', 'Female', '1978-08-15', '', 'Ghanaian', '0544564318', '', 'AB2', 'GHA-722865737-7', 'MOmo', 'SUhum', '0544564318', '', '0.00', '', '0.00', '', '0.00', 'Charles Tetteh', '', '0241496269', 'Samuel Ofosu', '', '0544707394', '', '', '', '2025-09-17 00:00:00', '0000-00-00 00:00:00'), (70, 'OBGCCU00073', '', 'Kwamena', 'Stephen', '', 'Male', '0000-00-00', '', 'Ghanaian', '0547683075', '', 'AY9', 'GHA-722435088-3', 'MOmo', 'SUhum', '0547683075', '', '0.00', '', '0.00', '', '0.00', 'Philomina Fosua', '', '0532973013', 'Benedicta Nitiwa', '', '0502429182', '', '', '', '2025-09-17 00:00:00', '0000-00-00 00:00:00'), (71, 'OBGCCU00074', '', 'Dzraku', 'Charlotte', '', 'Female', '1971-10-20', '', 'Ghanaian', '0537009207', '', '', 'GHA-000241698-2', 'MOmo', 'SUhum', '0537009207', '', '0.00', '', '0.00', '', '0.00', 'Regina Ktsebe', '', '0536681805', 'John Ketor', '', '0535396114', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (72, 'OBGCCU00075', '', 'Atiemo', 'Eric', 'Ofori', 'Male', '1975-06-25', '', 'Ghanaian', '0555247970', '', 'ES-0525-0515', 'GHA-722028230-6', 'MOmo', 'SUhum', '0555247970', '', '0.00', '', '0.00', '', '0.00', 'patrick Ofori', '', '0279512444', 'lydia Ofori', '', '0599969612', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (73, 'OBGCCU00076', '', 'lavor', 'Lydia', '', 'Female', '1982-04-04', '', 'Ghanaian', '0552431167', '', 'ES-0010-8790', 'GHA-722861212-7', 'MOmo', 'SUhum', '0552431167', '', '0.00', '', '0.00', '', '0.00', 'Selina Bedi Kese', '', '0535027459', 'Lois Ashong', '', '0592677013', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (74, 'OBGCCU00077', '', 'Ashiatey', 'Daniel', 'Yaw', 'Male', '1988-03-17', '', 'Ghanaian', '0248847676', '', 'ES-0010-8790', 'GHA-721337762-4', 'MOmo', 'Suhum', '0248847676', '', '0.00', '', '0.00', '', '0.00', 'Nene Ashiatey', '', '0248847676', 'Grace Latibea', '', '0595235004', '', '', '', '2025-08-09 00:00:00', '0000-00-00 00:00:00'), (75, 'OBGCCU00078', '', 'Aziadomey', 'Doris', '', 'Female', '2002-11-21', '', 'Ghanaian', '05369801431', '', 'ES-0470-3674', 'GHA-723085389-9', 'MOmo', 'Suhum', '0536980431', '', '0.00', '', '0.00', '', '0.00', 'Godwin Akoto', '', '0541846915', 'Edwin Akoto', '', '053980431', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (76, 'OBGCCU00079', '', 'Suso', 'Mercy', '', 'Female', '1995-05-10', '', 'Ghanaian', '0553390281', '', 'ES-0470-3674', 'GHA-721912217-0', 'MOmo', 'Suhum', '0553390281', '', '0.00', '', '0.00', '', '0.00', 'Abigail Sosu', '', '0538845925', 'Okwan Blessings', '', '0553390281', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (77, 'OBGCCU00080', '', 'Tetebea', 'Patience', '', 'Female', '1996-01-07', '', 'Ghanaian', '0557387053', '', 'ES-0470-3674', 'GHA-728273473-5', 'MOmo', 'Suhum', '0557387053', '', '0.00', '', '0.00', '', '0.00', 'Micheal Gbede', '', '0534082761', 'Janet Opare', '', '0557387053', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (78, 'OBGCCU00081', '', 'Asantewaa', 'Mary', '', 'Female', '1996-07-07', '', 'Ghanaian', '0552952913', '', 'ES-0470-3674', 'GHA-722326725-0', 'MOmo', 'Suhum', '0552952913', '', '0.00', '', '0.00', '', '0.00', 'Ernest Obiri', '', '0551080055', 'Darko Isaac', '', '0505897867', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (79, 'OBGCCU00082', '', 'Konadu', 'Abena', '', 'Female', '1977-06-25', '', 'Ghanaian', '0550885039', '', '', 'GHA-003786825-5', 'Momo', '', '0550885039', '', '0.00', '', '0.00', '', '0.00', '', '', '', '', '', '', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (80, 'OBGCCU00083', '', 'Ansah', 'selina', '', 'Female', '0000-00-00', '', 'Ghanaian', '', '', '', '', '', '', '', '', '0.00', '', '0.00', '', '0.00', 'Ibrahim Zainab', '', '0535761076', '', '', '', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (81, 'OBGCCU00084', '', 'Odei', 'Comfort', '', 'Female', '1954-09-24', '', 'Ghanaian', '055800090', '', '', 'GHA-721696123-7', 'Momo', 'Akorabo', '', '', '0.00', '', '0.00', '', '0.00', 'Hagar Asim', '', '', 'Justina Cared', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (82, 'OBGCCU00085', '', 'Ibrahim', 'Zainab', '', 'Female', '1991-03-20', '', 'Ghanaian', '0535761096', '', '', 'GHA-722701391-2', 'Momo', 'Akorabo', '0535761096', '', '0.00', '', '0.00', '', '0.00', 'Ramatu Suleman', '', '0535761096', 'Mary Odame', '', '0535761096', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (83, 'OBGCCU00086', '', 'Akotowaa', 'Portia', '', 'Female', '2004-02-04', '', 'Ghanaian', '0549650664', '', '', 'GHA-721696561-9', 'Momo', 'Akorabo', '0549650664', '', '0.00', '', '0.00', '', '0.00', 'Bright Oppong', '', '0549650664', 'Esther Obenewaa', '', '0549650664', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (84, 'OBGCCU00087', '', 'Ohenewaa', 'Esther', '', 'Female', '0000-00-00', '', 'Ghanaian', '0556566760', '', '', '', 'Momo', 'Akorabo', '0556566760', '', '0.00', '', '0.00', '', '0.00', 'Kwadwo Okyere', '', '', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (85, 'OBGCCU00088', '', 'Okyere', 'Kwadwo', '', 'Male', '0000-00-00', '', 'Ghanaian', '0548681957', '', '', '', 'Momo', 'Akorabo', '0548681957', '', '0.00', '', '0.00', '', '0.00', 'Micheal Okyere', '', '0548681957', 'Linda Sekyerewaa', '', '0548681957', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (86, 'OBGCCU00089', '', 'Oklu', 'Patricia', '', 'Female', '0000-00-00', '', 'Ghanaian', '0245974352', '', '', '', '', '', '', '', '0.00', '', '0.00', '', '0.00', 'Richmond Oklu', '', '0245974352', 'Linda Oklu', '', '0245974354', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (87, 'OBGCCU00090', '', 'Boakye', 'Doris', '', 'Female', '0000-00-00', '', 'Ghanaian', '0543367938', '', '', '', 'Momo', 'Akorabo', '0543367938', '', '0.00', '', '0.00', '', '0.00', 'Vida Ofori', '', '0595513497', 'Yaw Nyinaku', '', '0543367938', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (88, 'OBGCCU00091', '', 'Ofori', 'Vida', '', 'Female', '0000-00-00', '', 'Ghanaian', '0595513497', '', '', '', 'Momo', 'Akorabo', '0595513497', '', '0.00', '', '0.00', '', '0.00', 'Benedicta Bruce', '', '\'0595513497', 'Bright Bruce', '', '0595513497', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (89, 'OBGCCU00092', '', 'Ntiriwa', 'Mercy', '', 'Female', '0000-00-00', '', 'Ghanaian', '0537051571', '', '', 'GHA-722020386-0', 'Momo', 'Akorabo', '0537051571', '', '0.00', '', '0.00', '', '0.00', 'Kelvin Adu', '', '', 'Helina Adu', '', '', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (90, 'OBGCCU00093', '', 'Addo', 'Esther', '', 'Female', '0000-00-00', '', 'Ghanaian', '0257033275', '', '', 'GHA-722448231-7', 'Momo', 'Suhum', '0257033275', '', '0.00', '', '0.00', '', '0.00', 'Blessing Amabea', '', '', 'Derrick Agyei', '', '', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (91, 'OBGCCU00094', '', 'Abrahma', 'Mamuna', '', 'Male', '1982-02-04', '', 'Ghanaian', '0535326648', '', '', 'GHA-722572339-0', 'Momo', 'Suhum', '0535326648', '', '0.00', '', '0.00', '', '0.00', 'Falina Abrahim', '', '0535326648', 'Hawa Abrahim', '', '0535326648', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (92, 'OBGCCU00095', '', 'Emma', 'Obenewa', '', 'Female', '0000-00-00', '', 'Ghanaian', '0552215226', '', '', '', '', '', '', '', '0.00', '', '0.00', '', '0.00', 'lorencia Oforiwaa', '', '', 'Agyei Jones', '', '0245111396', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (93, 'OBGCCU00097', '', 'Apenteng', 'Christiana', '', 'Female', '1962-05-10', '', 'Ghanaian', '0591679258', '', '', 'GHA-721853975', 'Momo', 'Akorabo', '0591679258', '', '0.00', '', '0.00', '', '0.00', 'Jennifa Boateng', '', '0548382774', 'Yaa Mavis', '', '0552276299', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (94, 'OBGCCU00098', '', 'Amoakoa', 'Doris', '', 'Female', '0000-00-00', '', 'Ghanaian', '0209019581', '', '', 'GHA-722390526-6', 'Momo', 'Akorabo', '0209019581', '', '0.00', '', '0.00', '', '0.00', 'Patricia Atwea', '', '02090191581', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (95, 'OBGCCU00099', '', 'Aboagyewaa', 'Regina', '', 'Female', '1984-07-01', '', 'Ghanaian', '0201103168', '', '', 'GHA-721808427-5', 'Momo', 'suhum', '0201103168', '', '0.00', '', '0.00', '', '0.00', 'Issifu Abrahim', '', '0530554659', 'Grace Asamoah', '', '0530554659', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (96, 'OBGCCU00100', '', 'Kwabea', 'Rita', '', 'Female', '1983-12-17', '', 'Ghanaian', '0552023226', '', '', 'GHA-722417843-0', 'Momo', 'Akorabo', '0552023226', '', '0.00', '', '0.00', '', '0.00', 'Prince larbi', '', '0552023226', 'Belinda Asabea', '', '0552023226', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (97, 'OBGCCU00101', '', 'Obenewaa', 'Janet', '', 'Female', '1958-11-05', '', 'Ghanaian', '0273279124', '', '', 'GHA-722021955-5', 'Momo', 'Akorabo', '0273279124', '', '0.00', '', '0.00', '', '0.00', 'Fuastina Jakitey', '', '0273279124', 'Rosina Jakitay', '', '0273279124', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (98, 'OBGCCU00102', '', 'Oparebea', 'Augstina', '', 'Female', '1973-05-05', '', 'Ghanaian', '0555505813', '', '', 'GHA-722417135-2', 'MOmo', 'Akorabo', '0555505813', '', '0.00', '', '0.00', '', '0.00', 'James Kwapong', '', '0555505813', 'Esther Mantbea', '', '0555505813', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (99, 'OBGCCU00103', '', 'Asantewaa', 'Mary', '', 'Female', '1969-07-01', '', 'Ghanaian', '0552952913', '', '', 'GHA-722728434-1', 'Momo', 'Akorabo', '', '', '0.00', '', '0.00', '', '0.00', 'Francis Asante', '', '', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (100, 'OBGCCU00104', '', 'Gyeketey', 'Lydia', '', 'Female', '1988-01-10', '', 'Ghanaian', '0201048140', '', '', 'GHA-001984200-8', 'MOmo', 'Akorabo', '0201048140', '', '0.00', '', '0.00', '', '0.00', 'Gifty Akpabri', '', '0201048140', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (101, 'OBGCCU00105', '', 'Adu', 'Joyce', '', 'Female', '1994-09-22', '', 'Ghanaian', '0594756412', '', '', 'GHA-721756273-4', 'MOmo', 'Akorabo', '0594756412', '', '0.00', '', '0.00', '', '0.00', 'Sadat Imbrahim', '', '0594756412', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (102, 'OBGCCU00106', '', 'Mamar', 'Rubabetu', '', 'Female', '1981-04-01', '', 'Ghanaian', '0597763527', '', '', 'GHA-721822026-6', 'MOmo', 'Akorabo', '0597763527', '', '0.00', '', '0.00', '', '0.00', 'Aseidu Midri', '', '0597763527', 'Abass Ibrahim', '', '0541493754', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (103, 'OBGCCU00107', '', 'Odeibea', 'Esther', '', 'Female', '0000-00-00', '', 'Ghanaian', '', '', '', '', 'MOmo', 'Akorabo', '0596311918', '', '0.00', '', '0.00', '', '0.00', 'Ofei Florence', '', '0558707582', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (104, 'OBGCCU00108', '', 'Amusu', 'Mohammed', '', 'Male', '1980-09-08', '', 'Ghanaian', '0543320013', '', '', 'GHA-722126960-9', 'MOmo', 'SUhum', '0543320013', '', '0.00', '', '0.00', '', '0.00', 'Oluman Seidu', '', '0274094197', 'Rabi Seidu', '', '0242649970', '', '', '', '2025-11-09 00:00:00', '0000-00-00 00:00:00'), (105, 'OBGCCU00109', '', 'Fenyi', 'Douglas', '', 'Male', '1974-09-14', '', 'Ghanaian', '0245508283', '', '', 'GHA-721916675-2', 'MOmo', 'Akorabo', '0245508283', '', '0.00', '', '0.00', '', '0.00', 'Emmanuel Fenyi', '', '0594462445', 'Samuel Fenyi', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (106, 'OBGCCU00110', '', 'Asabea', 'Linda', '', 'Female', '1988-12-15', '', 'Ghanaian', '02547595096', '', '', 'GHA-721698401-4', 'MOmo', 'Akorabo', '0547595096', '', '0.00', '', '0.00', '', '0.00', 'Abigail Asabea', '', '0547595096', '', '', '', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (107, 'OBGCCU00111', '', 'Ahor', 'Eunice', '', 'Female', '0000-00-00', '', 'Ghanaian', '0544162613', '', '', '', 'momo', 'Akorabo', '0544162613', '', '0.00', '', '0.00', '', '0.00', 'Isabella Fenan', '', '', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (108, 'OBGCCU00112', '', 'Boateng', 'Diana', '', 'Female', '1961-07-01', '', 'Ghanaian', '0207989716', '', '', 'GHA-721911191-6', 'MOmo', 'Akorabo', '0207989716', '', '0.00', '', '0.00', '', '0.00', 'Paricia Adjaley', '', '0593004166', 'Harison Adjatey', '', '0544514788', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (109, 'OBGCCU00113', '', 'Oforiwaa', 'Eunice', '', 'Female', '1980-01-01', '', 'Ghanaian', '0504824545', '', '', 'GHA-722225023-5', 'MOmo', 'Akorabo', '0504824545', '', '0.00', '', '0.00', '', '0.00', 'Theresa Akrofi', '', '0549366340', 'Denis Akrofi', '', '0592527652', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (110, 'OBGCCU00114', '', 'Adu', 'Janet', '', 'Female', '1970-07-01', '', 'Ghanaian', '0245829864', '', '', 'GHA-722020648-9', 'MOmo', 'Akorabo', '0245829864', '', '0.00', '', '0.00', '', '0.00', 'Joyce Addo', '', '0245829864', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (111, 'OBGCCU00115', '', 'Nartey', 'Cecilia', '', 'Female', '0000-00-00', '', 'Ghanaian', '0537220948', '', '', '', 'MOmo', 'Akorabo', '0537220948', '', '0.00', '', '0.00', '', '0.00', 'Olivia Nartey', '', '0537220948', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (112, 'OBGCCU00116', '', 'Ohene', 'Ebenezer', '', 'Male', '0000-00-00', '', 'Ghanaian', '0596311890', '', '', '', 'MOmo', 'Akorabo', '0596311890', '', '0.00', '', '0.00', '', '0.00', 'David Ohene', '', '0538062392', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (113, 'OBGCCU00117', '', 'Ohenewaa', 'Grace', '', 'Female', '0000-00-00', '', 'Ghanaian', '0535124043', '', '', '', 'momo', 'Akorabo', '0535124043', '', '0.00', '', '0.00', '', '0.00', 'Emmanuel Ohene', '', '', 'Rose Asabea', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (114, 'OBGCCU00118', '', 'Akwei', 'Janet', '', 'Female', '1998-08-06', '', 'Ghanaian', '0553199976', '', '', 'GHA-723057772-2', 'momo', 'Akorabo', '0553199976', '', '0.00', '', '0.00', '', '0.00', 'Addobea Helina', '', '0547693207', 'Akwei Selina', '', '0249529696', '', '', '', '2025-09-26 00:00:00', '0000-00-00 00:00:00'), (115, 'OBGCCU00119', '', 'Asiedu', 'Samuel', '', 'Female', '1970-09-19', '', 'Ghanaian', '0247314952', '', '', 'GHA-721904897-9', 'MOmo', 'Akorabo', '0247314952', '', '0.00', '', '0.00', '', '0.00', 'Dennis Asiedu', '', '0592627652', 'Theresa Akrofi', '', '0549366340', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (116, 'OBGCCU00120', '', 'Dankwa', 'Mercy', '', 'Female', '1980-01-01', '', 'Ghanaian', '0547166529', '', '', 'GHA-721916646-6', 'momo', 'Akorabo', '0547166959', '', '0.00', '', '0.00', '', '0.00', 'Abigail Adubea', '', '0248325320', 'Ansah Emmanuel', '', '0554955604', '', '', '', '2025-09-26 00:00:00', '0000-00-00 00:00:00'), (117, 'OBGCCU00121', '', 'Avoi', 'Margaret', '', 'Female', '1983-03-03', '', 'Ghanaian', '0598002673', '', '', 'GHA-722381130-9', 'MOmo', 'Akorabo', '0598002673', '', '0.00', '', '0.00', '', '0.00', 'Addo Bright', '', '0598002673', 'Mariama Issuf', '', '0598002673', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (118, 'OBGCCU00121', '', 'Avoi', 'Margaret', '', 'Female', '1983-03-03', '', 'Ghanaian', '0598002673', '', '', 'GHA-722381130-9', 'MOmo', 'Akorabo', '0598002673', '', '0.00', '', '0.00', '', '0.00', 'Addo Bright', '', '0598002673', 'Miariam Issif', '', '0598002673', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (119, 'OBGCCU00122', '', 'Asamoah', 'Mary', '', 'Female', '1986-10-13', '', 'Ghanaian', '0500394272', '', '', 'GHA-722015355-4', 'MOmo', 'Akorabo', '0500394272', '', '0.00', '', '0.00', '', '0.00', 'Fataw Bashiru', '', '0500394272', 'Mustapha Bashiru', '', '0500394272', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (120, 'OBGCCU00123', '', 'Ofei', 'Florence', '', 'Female', '0000-00-00', '', 'Ghanaian', '0558707582', '', '', '', 'MOmo', 'Akorabo', '0558707582', '', '0.00', '', '0.00', '', '0.00', 'Melcom Boakye Kena', '', '0249114702', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (121, 'OBGCCU00124', '', 'lartey', 'Vivian', '', 'Female', '2000-01-18', '', 'Ghanaian', '0553734166', '', '', 'GHA-726538039-7', 'MOmo', 'suhum', '0553734166', '', '0.00', '', '0.00', '', '0.00', 'Ivan Nana Sarpong', '', '0553734166', 'Francis K. Azizti', '', '0249129113', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (122, 'OBGCCU00125', '', 'Abankwah', 'Janet', '', 'Female', '1987-01-10', '', 'Ghanaian', '0547654808', '', '', 'GHA-722319293-8', 'MOmo', 'suhum', '0547654808', '', '0.00', '', '0.00', '', '0.00', 'Desmond Ayetey', '', '0242512264', 'Regina Offebea', '', '0541511904', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (123, 'OBGCCU00126', '', 'Seke', 'Dora', '', 'Female', '1988-12-05', '', 'Ghanaian', '0548995422', '', '', 'GHA-722656120-9', 'Momo', 'suhum', '0548995422', '', '0.00', '', '0.00', '', '0.00', 'Felix Ayenyah', '', '0247657573', 'Seke Vida', '', '0557364879', '', '', '', '2025-09-15 00:00:00', '0000-00-00 00:00:00'), (124, 'OBGCCU00127', '', 'Awale', 'lukaya', '', 'Female', '1988-05-31', '', 'Ghanaian', '0543559384', '', '', 'GHA-722129149-7', 'Momo', 'suhum', '0543559384', '', '0.00', '', '0.00', '', '0.00', 'Brighet Owusuaa', '', '0534693860', 'Safoa Princess', '', '0554988345', '', '', '', '2025-09-15 00:00:00', '0000-00-00 00:00:00'), (125, 'OBGCCU00128', '', 'Mantey', 'Abigail', '', 'Female', '1998-07-25', '', 'Ghanaian', '0240882346', '', '', 'GHA-729218231-7', 'MOmo', 'suhum', '0240882346', '', '0.00', '', '0.00', '', '0.00', 'Miariam Ayotey', '', '0240882346', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (126, 'OBGCCU00129', '', 'oyortey', 'Frank', '', 'Male', '1977-01-09', '', 'Ghanaian', '0556121155', '', '', 'GHA-001415813-3', 'MOmo', 'Akorabo', '0556121155', '', '0.00', '', '0.00', '', '0.00', 'Obed Adanitey', '', '0556121155', '', '', '', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (127, 'OBGCCU00131', '', 'Aboagye', 'Richmong', '', 'Male', '2004-04-12', '', 'Ghanaian', '0535484972', '', 'GA-002-0774', 'GHA-724124885-3', 'MOmo', 'Accra', '0535484972', '', '0.00', '', '0.00', '', '0.00', 'Benedicta O mensah', '', '0536091120', '', '', '', '', '', '', '2025-09-24 00:00:00', '0000-00-00 00:00:00'), (128, 'OBGCCU00132', '', 'Nkansah', 'Edina', 'Mercy', 'Female', '1997-11-13', '', 'Ghanaian', '0248491871', '', 'ES-0002-7228', 'GHA-7131109637-1', 'Republic', 'SUhum', '0278854273017', '', '0.00', '', '0.00', '', '0.00', 'Lawson Tanoh', '', '0595752071', 'Thomas Tawiah', '', '0555099695', '', '', '', '2025-09-24 00:00:00', '0000-00-00 00:00:00'), (129, 'OBGCCU00133', '', 'Agyei', 'Doris', '', 'Female', '1993-02-03', '', 'Ghanaian', '0592957145', '', '', 'GHA-721209943-3', 'MOmo', 'SUhum', '0592957145', '', '0.00', '', '0.00', '', '0.00', 'Isaac Boadu', '', '0241470135', 'Mercy Agyei', '', '0592957145', '', '', '', '2025-09-19 00:00:00', '0000-00-00 00:00:00'), (130, 'OBGCCU00135', '', 'Agyeiwaa', 'Comfort', '', 'Female', '1983-03-06', '', 'Ghanaian', '0544597401', '', 'ES-0021-8208', 'GHA-721738937-1', 'Momo', 'SUhum', '0544597401', '', '0.00', '', '0.00', '', '0.00', 'Oparebea Felicia', '', '0257584281', 'Stephanie Darkoa', '', '054459740', '', '', '', '2025-09-24 00:00:00', '0000-00-00 00:00:00'), (131, 'OBGCCU00136', '', 'Amoah', 'Rosemond', '', 'Female', '1975-04-27', '', 'Ghanaian', '0247566865', '', '', 'GHA-722723015-9', 'Momo', 'SUhum', '0247566865', '', '0.00', '', '0.00', '', '0.00', 'Samuel Antwi', '', '', 'Ashia Konadu', '', '', '', '', '', '2025-09-24 00:00:00', '0000-00-00 00:00:00'), (132, 'OBGCCU00137', '', 'Asare', 'Joyce', '', 'Female', '1978-07-01', '', 'Ghanaian', '0547154525', '', '', 'GHA-725721148-3', 'Momo', '', '', '', '0.00', '', '0.00', '', '0.00', 'Felicia Kwabea', '', '0539565712', 'Gyamfua Abena', '', '0532579879', '', '', '', '2025-09-24 00:00:00', '0000-00-00 00:00:00'), (133, 'OBGCCU00138', '', 'Afari', 'Hannah', '', 'Female', '1977-12-16', '', 'Ghanaian', '0243969914', '', '', 'GHA-721520961-9', 'momo', '', '', '', '0.00', '', '0.00', '', '0.00', 'Atwnurse Afari', '', '024396991', 'Isaac Boateng', '', '0249581873', '', '', '', '2025-09-24 00:00:00', '0000-00-00 00:00:00'), (134, 'OBGCCU00139', '', 'Ntiriwaa', 'Rita', '', 'Female', '1990-07-26', '', 'Ghanaian', '0535738573', '', '', 'GHA-725947949-4', 'Momo', 'SUhum', '0535738573', '', '0.00', '', '0.00', '', '0.00', 'Nadia Sasu', '', '055399663', 'Frimpongma Agyeiwaa', '', '0535738573', '', '', '', '2025-09-24 00:00:00', '0000-00-00 00:00:00'), (135, 'OBGCCU00140', '', 'Okyere', 'Frank', '', 'Male', '1974-06-02', '', 'Ghanaian', '0531923828', '', '', 'GHA-720395582-5', 'momo', 'Suhum', '0531923828', '', '0.00', '', '0.00', '', '0.00', 'Dora Okyere', '', '0531163181', 'Pricilla Okyere', '', '0531923828', '', '', '', '2025-09-25 00:00:00', '0000-00-00 00:00:00'), (136, 'OBGCCU00141', '', 'Adzanyo', 'Victoria', '', 'Female', '0000-00-00', '', 'Ghanaian', '0549827366', '', '', 'GHA-722068752-1', 'momo', 'Akorabo', '0549827366', '', '0.00', '', '0.00', '', '0.00', 'Dzagbe Gadafi', '', '0592789436', 'Gladys Kudome', '', '0244740539', '', '', '', '2025-09-25 00:00:00', '0000-00-00 00:00:00'), (137, 'OBGCCU00142', '', 'Popolampo', 'Divine', '', 'Male', '1992-10-16', '', 'Ghanaian', '0549499028', '', 'ES-0030-1166', 'GHA-721310641-1', 'momo', 'suhum', '0549499028', '', '0.00', '', '0.00', '', '0.00', 'Dickson Tetteh', '', '0549499028', 'Akosua Gethrude', '', '0549499028', '', '', '', '2025-09-26 00:00:00', '0000-00-00 00:00:00'), (138, 'OBGCCU00143', '', 'Azamadi', 'Janet', '', 'Female', '1978-10-24', '', 'Ghanaian', '0531809931', '', 'ES-0009-9174', 'GHA-729215007-9', 'momo', 'suhum', '0531809931', '', '0.00', '', '0.00', '', '0.00', 'Derrick nana Aboakye', '', '0538276322', 'Vannessa Sadinam', '', '0531809931', '', '', '', '2025-09-29 00:00:00', '0000-00-00 00:00:00'), (139, 'OBGCCU00144', '', 'Akoto', 'Osei', 'Steward', 'Male', '2009-12-07', '', 'Ghanaian', '0530288426', 'oseisophia71@gmail.com', 'ES-0036-6059', '', 'momo', 'Suhum', '0530288426', '', '0.00', '', '0.00', '', '0.00', 'Owusu Korkor', '', '0244064716', 'Nana yaa kobe', '', '0244064716', '', '', '', '2025-08-22 00:00:00', '0000-00-00 00:00:00'), (140, 'OBGCCU00145', '', 'Adams', 'Rahim', '', 'Male', '1997-08-15', '', 'Ghanaian', '0533368708', '', 'ES-0012-9077', '', 'momo', 'suhum', '0533368708', '', '0.00', '', '0.00', '', '0.00', 'Saeed Nabil', '', '0555506376', 'Razak Ibrahim', '', '05333975964', '', '', '', '2025-09-29 00:00:00', '0000-00-00 00:00:00'), (141, 'OBGCCU00146', '', 'Boateng', 'Sandra', '', 'Female', '1990-09-05', '', 'Ghanaian', '0552042330', '', 'ES-0058-1844', 'GHA-726034256-1', 'momo', 'suhum', '0552042330', '', '0.00', '', '0.00', '', '0.00', 'Ramie lartey', '', '0552042330', 'Kwabena Ansah', '', '0552042330', '', '', '', '2025-01-10 00:00:00', '0000-00-00 00:00:00'), (142, 'OBGCCU00147', '', 'Tetteh', 'Gladys', '', 'Female', '1994-12-21', '', 'Ghanaian', '0240551546', '', 'ES-0058-1844', 'GHA-000949639-0', 'momo', 'suhum', '0240551546', '', '0.00', '', '0.00', '', '0.00', 'Teye Abraham', '', '0240551546', 'Teye Maxwell', '', '0240551546', '', '', '', '2025-01-10 00:00:00', '0000-00-00 00:00:00'), (143, 'OBGCCU00148', '', 'Adu', 'Joshua', '', 'Male', '0000-00-00', '', 'Ghanaian', '0537051571', '', '', '', 'momo', 'Ampedwae', '0537051571', '', '0.00', '', '0.00', '', '0.00', 'Kelvin Adu', '', '05333874984', 'Bright Adu', '', '0555757767', '', '', '', '2025-03-10 00:00:00', '0000-00-00 00:00:00'), (144, 'OBGCCU00149', '', 'Bekoe', 'Frank', '', 'Male', '1998-02-06', '', 'Ghanaian', '0595270940', '', '', 'GHA-722285656-3', 'momo', 'Koko junction', '0595270940', '', '0.00', '', '0.00', '', '0.00', 'Florence Ofei', '', '0558707582', 'Asante Patience', '', '0593451827', '', '', '', '2025-03-10 00:00:00', '0000-00-00 00:00:00'), (145, 'OBGCCU00150', '', 'Odurowaa', 'Diana', '', 'Female', '0000-00-00', '', 'Ghanaian', '0539092305', '', 'N144', 'GHA-721924993-6', 'MOmo', 'Nankese', '0539092305', '', '0.00', '', '0.00', '', '0.00', 'Stephanie Danso', '', '0539092305', 'Adelaide Debrah', '', '0539092305', '', '', '', '2025-03-10 00:00:00', '0000-00-00 00:00:00'), (146, 'OBGCCU00151', '', 'Ampofoa', 'Cynthia', '', 'Female', '0000-00-00', '', 'Ghanaian', '0249476544', '', 'N96A', 'GHA-721921100-1', 'MOmo', 'Nankese', '0249476544', '', '0.00', '', '0.00', '', '0.00', 'Danso Aboakye Angelo', '', '0249476544', 'Adango Farida', '', '0249476544', '', '', '', '2025-03-10 00:00:00', '0000-00-00 00:00:00'), (147, 'OBGCCU00152', '', 'Odoi', 'Lawrencia', '', 'Female', '2002-05-05', '', 'Ghanaian', '0500424988', '', '', '', 'momo', 'suhum', '0500424988', '', '0.00', '', '0.00', '', '0.00', 'Believer Odoi', '', '0257251330', 'Biantey Alex', '', '0552658646', '', '', '', '2025-07-10 00:00:00', '0000-00-00 00:00:00'), (148, 'OBGCCU00153', '', 'Adubea', 'Princella', '', 'Female', '1996-06-29', '', 'Ghanaian', '', '', '', 'GHA-721790718-0', 'momo', 'suhum', '', '', '0.00', '', '0.00', '', '0.00', '', '', '', '', '', '', '', '', '', '2025-09-10 00:00:00', '0000-00-00 00:00:00'), (149, 'OBGCCU00154', '', 'Tetteh', 'Sarah', '', 'Female', '1989-07-16', '', 'Ghanaian', '0592249450', '', '', 'GHA-727612983-3', 'momo', 'suhum', '0592249450', '', '0.00', '', '0.00', '', '0.00', 'Larweh Victor', '', '0592249450', 'Attah Victoria', '', '0592249450', '', '', '', '2025-09-10 00:00:00', '0000-00-00 00:00:00'), (150, 'OBGCCU00155', '', 'Tetteh', 'Felix', '', 'Male', '1992-05-04', '', 'Ghanaian', '0552584604', '', 'ES-0097-1546', 'GHA-722493791-8', 'momo', 'suhum', '0552584604', '', '0.00', '', '0.00', '', '0.00', 'Elizabeth Tetteh', '', '0241423962', 'Appiah Catherine', '', '0535656616', '', '', '', '2025-09-10 00:00:00', '0000-00-00 00:00:00'), (151, 'OBGCCU00156', '', 'Nuetey', 'Bomper', '', 'Female', '1993-03-06', '', 'Ghanaian', '0240104086', '', '', 'GHA-721847719-4', 'MOmo', 'Akorabo', '0244278394', '', '0.00', '', '0.00', '', '0.00', 'Charles Nuetey', '', '0241482935', 'Douglas Tetteh', '', '054194340', '', '', '', '2025-10-10 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `clients` (`id`, `account_number`, `title`, `surname`, `first_name`, `other_names`, `gender`, `dob`, `place_of_birth`, `nationality`, `phone`, `email`, `gps_address`, `ghana_card_no`, `bank_name`, `branch`, `bank_account_number`, `type_of_account_1`, `initial_deposit_1`, `type_of_account_2`, `initial_deposit_2`, `type_of_account_3`, `initial_deposit_3`, `beneficiary1_name`, `beneficiary1_relationship`, `beneficiary1_phone`, `beneficiary2_name`, `beneficiary2_relationship`, `beneficiary2_phone`, `photo`, `ghana_card_copy`, `offer_letter`, `created_at`, `updated_at`) VALUES (152, 'OBGCCU00157', '', 'Kpabitey', 'Ronald', '', 'Male', '1981-06-16', '', 'Ghanaian', '0547818989', '', '', 'GHA-721907501-1', 'MOmo', 'Akorabo', '0547818989', '', '0.00', '', '0.00', '', '0.00', 'Kelvin Kpabitey', '', '0244924221', 'Gardon lartey Tetteh', '', '0547818989', '', '', '', '2025-10-10 00:00:00', '0000-00-00 00:00:00'), (153, 'OBGCCU00158', '', 'Charnor', 'Emmanuel', '', 'Male', '1994-01-01', '', 'Ghanaian', '0545261099', '', '', 'GHA-721845763-3', 'MOmo', 'Akorabo', '0545261099', '', '0.00', '', '0.00', '', '0.00', 'Richlove Nargetey', '', '0545261099', 'Joel Nargetey', '', '0545261099', '', '', '', '2025-10-10 00:00:00', '0000-00-00 00:00:00'), (154, 'OBGCCU00159', '', 'Afedi', 'Isaac', '', 'Male', '1997-06-04', '', 'Ghanaian', '0556797874', '', '', 'GHA-722617322-2', 'MOmo', 'Akorabo', '0556797874', '', '0.00', '', '0.00', '', '0.00', 'Afedi Godson', '', '0547004686', 'Afedi Eunice', '', '0550048271', '', '', '', '2025-10-10 00:00:00', '0000-00-00 00:00:00'), (155, 'OBGCCU00160', '', 'Tetteh', 'Seth', '', 'Male', '0000-00-00', '', 'Ghanaian', '0536693503', '', '', '', '', '', '', '', '0.00', '', '0.00', '', '0.00', '', '', '', '', '', '', '', '', '', '2025-10-10 00:00:00', '0000-00-00 00:00:00'), (156, 'OBGCCU00161', '', 'Awatey', 'Patricia', '', 'Female', '0000-00-00', '', 'Ghanaian', '0549728096', '', '', '', 'MOmo', 'Akorabo', '0549728096', '', '0.00', '', '0.00', '', '0.00', 'Theresa Tetteh', '', '0549728096', 'Blessing Teeteh', '', '', '', '', '', '2025-10-10 00:00:00', '0000-00-00 00:00:00'), (157, 'OBGCCU00162', '', 'Afram', 'Emmanuel', '', 'Male', '1998-10-30', '', 'Ghanaian', '0554302164', '', 'ES-002-7228', 'GHA-722137790-4', 'momo', 'suhum', '0554302164', '', '0.00', '', '0.00', '', '0.00', 'Akotowa Patience', '', '0554264842', 'Afram Joseph', '', '0533407613', '', '', '', '2025-10-13 00:00:00', '0000-00-00 00:00:00'), (158, 'OBGCCU00163', '', 'Akrofie', 'Gloria', '', 'Female', '0000-00-00', '', 'Ghanaian', '0545406715', '', 'ES-0053-0087', 'GHA-722494131-1', 'momo', 'suhum', '0545406715', '', '0.00', '', '0.00', '', '0.00', 'Debrah Akrofie', '', '0553561732', 'Lily Akrofie', '', '0545406715', '', '', '', '2025-10-17 00:00:00', '0000-00-00 00:00:00'), (159, 'OBGCCU00164', '', 'Mohammed', 'Mariama', '', 'Female', '0000-00-00', '', 'Ghanaian', '0543535762', '', '', 'GHA-722043448-6', 'MOmo', 'SUhum', '0543535762', '', '0.00', '', '0.00', '', '0.00', 'Toby Yinsaha', '', '0543535762', '', '', '', '', '', '', '2025-10-17 00:00:00', '0000-00-00 00:00:00'), (160, 'OBGCCU00165', '', 'Baah', 'Joseph', '', 'Male', '2004-05-04', '', 'Ghanaian', '0598183257', '', 'ES-0065-1874', 'GHA-721811871-2', 'MOmo', 'SUhum', '0598183257', '', '0.00', '', '0.00', '', '0.00', 'Owning Aglago', '', '0598183257', 'Rasford Nyumutui', '', '0598183257', '', '', '', '2025-10-20 00:00:00', '0000-00-00 00:00:00'), (161, 'OBGCCU00166', '', 'Amoah', 'Godfred', '', 'Male', '0000-00-00', '', 'Ghanaian', '0594746800', '', 'AH\\10', '', 'MOmo', 'SUhum', '0594746800', '', '0.00', '', '0.00', '', '0.00', 'Oparebea Francisca', '', '0598017379', 'Obuo Eunice', '', '0545865986', '', '', '', '2025-10-21 00:00:00', '0000-00-00 00:00:00'), (162, 'OBGCCU00167', '', 'Osei', 'Isaac', '', 'Male', '1996-05-11', '', 'Ghanaian', '0541939160', '', 'GJ\\4', '', 'MOmo', 'SUhum', '0541939160', '', '0.00', '', '0.00', '', '0.00', 'Dennies Osei', '', '0541939160', 'Maccleana Agyeiwaa', '', '0558169659', '', '', '', '2025-10-21 00:00:00', '0000-00-00 00:00:00'), (163, 'OBGCCU00168', '', 'Akrofie', 'Deborah', '', 'Female', '0000-00-00', '', 'Ghanaian', '0553561732', '', 'ES-0053-0087', 'GHA-713158561-7', 'MOmo', 'SUhum', '0553561732', '', '0.00', '', '0.00', '', '0.00', 'Obed Emmanuel Akrofi', '', '0553561732', 'Gloria Akrofi', '', '0545406715', '', '', '', '2025-10-22 00:00:00', '0000-00-00 00:00:00'), (164, 'OBGCCU00169', '', 'Owusu Danso', 'Eugene kwesi', '', 'Male', '2002-06-10', '', 'Ghanaian', '0552373827', '', 'ES-0097-1690', 'GHA-721401971-2', 'MOmo', 'SUhum', '0552373827', '', '0.00', '', '0.00', '', '0.00', 'Aaron Anaaba', '', '0504563949', 'Bernice Mawunyo', '', '0240934765', '', '', '', '2025-10-29 00:00:00', '0000-00-00 00:00:00'), (165, 'OBGCCU00170', '', 'Odamea', 'Christiana', '', 'Female', '1972-04-05', '', 'Ghanaian', '0247873348', '', '', 'GHA-721488012-3', 'MOmo', 'Ampedwua', '0247873348', '', '0.00', '', '0.00', '', '0.00', 'Edward Nyarkotey', '', '0247539147', 'Evenly Ako', '', '0247706821', '', '', '', '2025-10-29 00:00:00', '0000-00-00 00:00:00'), (166, 'OBGCCU00171', '', 'Hodor', 'Juliet', 'Abla', 'Female', '1985-10-10', '', 'Ghanaian', '0539890840', '', 'ES-0055-6828', 'NO GH CARD', 'MOmo', 'Suhum', '0539890840', '', '0.00', '', '0.00', '', '0.00', 'Parret Ahiabo', '', '0539890840', 'Vida Madeku', '', '0597775202', '', '', '', '2025-03-11 00:00:00', '0000-00-00 00:00:00'), (167, 'OBGCCU00172', '', 'Afiyoo', 'Joyce', '', 'Female', '1984-10-19', '', 'Ghanaian', '0549873707', '', 'ES-0055-6828', 'GHA-723116542-5', 'MOmo', 'SUhum', '0549873707', '', '0.00', '', '0.00', '', '0.00', 'Osanyumbor Ruth', '', '0532994541', 'Osanyumbor Micheal', '', '0551078927', '', '', '', '2025-03-11 00:00:00', '0000-00-00 00:00:00'), (168, 'OBGCCU00173', '', 'Odamea', 'Margaret', '', 'Female', '1982-02-05', '', 'Ghanaian', '0594167054', '', 'ES-0055-6828', 'GHA-727715980-6', 'MOmo', 'SUhum', '0594167054', '', '0.00', '', '0.00', '', '0.00', 'Janet Oye', '', '0594167054', 'David Appiah', '', '0594167054', '', '', '', '2025-03-11 00:00:00', '0000-00-00 00:00:00'), (169, 'OBGCCU00174', '', 'Adobea', 'Helina', '', 'Female', '1990-11-11', '', 'Ghanaian', '0594167054', '', '', 'GHA-722312927-1', 'MOmo', 'Akorabo', '0547693207', '', '0.00', '', '0.00', '', '0.00', 'Sandra Akwei', '', '', 'Isaac Baah', '', '0246865664', '', '', '', '2025-01-10 00:00:00', '0000-00-00 00:00:00'), (170, 'OBGCCU00175', '', 'Nartey', 'Rapheal', '', 'Male', '2001-07-01', '', 'Ghanaian', '0533111074', '', 'ES-0055-6828', 'NO GH CARD', 'MOmo', 'Suhum', '0598123978', '', '0.00', '', '0.00', '', '0.00', 'Patrick Opare', '', '0545488460', 'Ophelia Opare', '', '0545800452', '', '', '', '2025-04-11 00:00:00', '0000-00-00 00:00:00'), (171, 'OBGCCU00176', '', 'Opare', 'Shadrack', '', 'Male', '2004-06-02', '', 'Ghanaian', '0598123978', '', '', '', '', '', '', '', '0.00', '', '0.00', '', '0.00', '', '', '', '', '', '', '', '', '', '2025-04-11 00:00:00', '0000-00-00 00:00:00'), (172, 'OBGCCU00177', '', 'Addo', 'Prince', '', 'Male', '1986-05-01', '', 'Ghanaian', '0242535522', '', 'ES-0010-2875', 'GHA-727689752-3', 'Momo', 'Suhum', '0242535522', '', '0.00', '', '0.00', '', '0.00', 'Enerst Addo', '', '0242535522', 'Agnes Addobea', '', '0544242010', '', '', '', '2025-06-11 00:00:00', '0000-00-00 00:00:00'), (173, 'OBGCCU00178', '', 'Akubia', 'Genesis', '', 'Male', '0000-00-00', '', 'Ghanaian', '0537707590', '', '', 'GHA-00125493-3', 'MOmo', 'Suhum', '0537707590', '', '0.00', '', '0.00', '', '0.00', 'Akubia Margeret', '', '0551794470', '', '', '', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (174, 'OBGCCU00179', '', 'Nartey', 'Francis', '', 'Male', '0000-00-00', '', 'Ghanaian', '0249382053', '', 'ES-0030-8098', 'GHA-721717889-8', 'Momo', 'Suhum', '0249382053', '', '0.00', '', '0.00', '', '0.00', 'lord Nartey', '', '0249382053', 'Bernice Tieko', '', '0598063195', '', '', '', '2025-06-11 00:00:00', '0000-00-00 00:00:00'), (175, 'OBGCCU00180', '', 'Kotoh', 'Benedicta', '', 'Female', '1992-10-11', '', 'Ghanaian', '0552901541', '', '', 'GHA-722179937-1', 'Momo', 'Suhum', '0552901541', '', '0.00', '', '0.00', '', '0.00', 'Mary Hart', '', '0552901541', 'Isreal Kotoku', '', '0552901541', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (176, 'OBGCCU00181', '', 'Osei', 'Daniel', '', 'Male', '1980-09-01', '', 'Ghanaian', '0242574882', '', 'ES-00235321', 'GHA-721822160-1', 'Momo', '', '', '', '0.00', '', '0.00', '', '0.00', '', '', '', '', '', '', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (177, 'OBGCCU00182', '', 'Assoah', 'Hannah', '', 'Female', '0000-00-00', '', 'Ghanaian', '0240256219', '', 'ES-00235321', 'GHA-721908739-2', 'Momo', 'SUhum', '0240256219', '', '0.00', '', '0.00', '', '0.00', 'Osei Yeboah Lawrence', '', '0240256219', 'Assoah Paul', '', '0240256219', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (178, 'OBGCCU00183', '', 'Adu', 'Micheal', '', 'Male', '0000-00-00', '', 'Ghanaian', '0242740213', '', 'ES-0088-4066', 'GHA-721923245-7', 'MOmo', 'Suhum', '0242740213', '', '0.00', '', '0.00', '', '0.00', 'Venassa Adu', '', '0599306736', 'Wilfred Adu Nto', '', '0242740213', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (179, 'OBGCCU00184', '', 'Darko', 'Freda', '', 'Female', '0000-00-00', '', 'Ghanaian', '0599306736', '', 'ES-0088-4066', 'GHA-001025154-2', 'MOmo', 'Suhum', '0599306736', '', '0.00', '', '0.00', '', '0.00', 'Vannesa Adu', '', '0599306730', 'wilfred Adu Nto', '', '0599306736', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (180, 'OBGCCU00185', '', 'Boadu', 'Isaac', '', 'Male', '1991-09-11', '', 'Ghanaian', '0241470135', '', '', 'GHA-722183099-3', 'MOmo', 'Suhum', '0241470135', '', '0.00', '', '0.00', '', '0.00', 'Keoni Boadu', '', '0241470135', 'Phiona Boadu', '', '0592957145', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (181, 'OBGCCU00186', '', 'Agbah', 'Lord', '', 'Male', '0000-00-00', '', 'Ghanaian', '0557934897', '', 'ES-00114353', 'GHA-730615780-9', 'MOmo', 'Suhum', '0557934897', '', '0.00', '', '0.00', '', '0.00', 'Otu Nataniel', '', '0557934897', 'Vivian Addey', '', '0557934897', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (182, 'OBGCCU00187', '', 'Ofosua', 'Sandra', '', 'Female', '1997-07-05', '', 'Ghanaian', '0532863308', '', 'ES-0011-4353', 'GHA-722741392-3', 'MOmo', 'Suhum', '0532863308', '', '0.00', '', '0.00', '', '0.00', 'Agba Lord', '', '0557934897', 'George Dadzie', '', '0557934897', '', '', '', '2025-11-11 00:00:00', '0000-00-00 00:00:00'), (183, 'OBGCCU00188', '', 'Adomako', 'Mary', '', 'Female', '1981-01-07', '', 'Ghanaian', '0535065983', '', 'ES-0018-0601', 'GHA-722701669-4', 'MOmo', 'SUhum', '0535065983', '', '0.00', '', '0.00', '', '0.00', 'Elizabeth Gjan', '', '0535065983', 'Richard Koranteng', '', '0593371258', '', '', '', '2025-12-11 00:00:00', '0000-00-00 00:00:00'), (184, 'OBGCCU00189', '', 'Larbi', 'Ernest', '', 'Male', '1989-04-11', '', 'Ghanaian', '0257247236', '', 'ES-0030-2670', 'GHA-722599610-5', 'MOmo', 'SUhum', '0257247236', '', '0.00', '', '0.00', '', '0.00', 'Etel Opokua', '', '0248779313', 'Faustina Darkowaa', '', '0534066253', '', '', '', '2025-12-11 00:00:00', '0000-00-00 00:00:00'), (185, 'OBGCCU00190', '', 'Kwatia', 'Micheal', '', 'Male', '1992-04-12', '', 'Ghanaian', '0548923030', '', '', 'GHA-722733644-4', 'MOmo', 'SUhum', '0548923030', '', '0.00', '', '0.00', '', '0.00', 'Darko Edward', '', '0548923030', 'Solomon Kwatia', '', '0548923030', '', '', '', '2025-11-13 00:00:00', '0000-00-00 00:00:00'), (186, 'OBGCCU00191', '', 'Tetteh', 'Isaac', '', 'Male', '0000-00-00', '', 'Ghanaian', '0530851068', '', '', 'GHA-721576461-1', 'MOmo', 'SUhum', '0530851068', '', '0.00', '', '0.00', '', '0.00', 'Chartey Benedict', '', '0530851068', 'Chartey Richlove', '', '0530851068', '', '', '', '2025-11-13 00:00:00', '0000-00-00 00:00:00'), (187, 'OBGCCU00192', '', 'Larweh', 'Prince', '', 'Male', '0000-00-00', '', 'Ghanaian', '0537457960', '', '', 'GHA-721387345-6', 'MOmo', 'SUhum', '0537457960', '', '0.00', '', '0.00', '', '0.00', 'Oforiwaa Perpetual', '', '0537457960', 'Obenewaa Pricilla', '', '0537457960', '', '', '', '2025-11-13 00:00:00', '0000-00-00 00:00:00'), (188, 'OBGCCU00193', '', 'Tei', 'Sampson', '', 'Male', '0000-00-00', '', 'Ghanaian', '0245793434', '', 'ES-0012-9077', 'NO GH CARD', 'MOmo', 'SUhum', '0245793434', '', '0.00', '', '0.00', '', '0.00', 'Abigail Tei', '', '0594747191', 'Happy Tei', '', '0544440337', '', '', '', '2025-11-13 00:00:00', '0000-00-00 00:00:00'), (189, 'OBGCCU00194', '', 'Yakubu', 'Adwoa', '', 'Female', '0000-00-00', '', 'Ghanaian', '0531317382', '', '', 'GHA-722223799-1', 'MOmo', 'SUhum', '0531317382', '', '0.00', '', '0.00', '', '0.00', 'Latif Jelilu', '', '0531317382', 'Sharifa Jelilu', '', '0531317382', '', '', '', '2025-11-14 00:00:00', '0000-00-00 00:00:00'), (190, 'OBGCCU00195', '', 'Nartey', 'Emmanuel', '', 'Male', '1965-02-02', '', 'Ghanaian', '0247162642', '', '', 'GHA-723085558-5', 'MOmo', 'Suhum', '0542535726', '', '0.00', '', '0.00', '', '0.00', 'Bismark Nartey', '', '0240745325', 'Stephen Nartey', '', '0594578433', '', '', '', '2025-10-09 00:00:00', '0000-00-00 00:00:00'), (191, 'OBGCCU00196', '', 'Afedi', 'Evans', 'Kwadjo', 'Male', '1997-10-25', 'Accra', 'Ghanaian', '0597151696', 'evansafedi4@gmail.com', 'GHA-727880709-9', 'GHA-727880709-9', 'Obrapa Group Credit', 'Suhum', '123456', '', '130000.00', NULL, NULL, NULL, NULL, 'Mary Nartey', 'Mother', '0245256078', NULL, NULL, NULL, 'clients/photos/vusYq1I0QeRJ27G7ikf7VyZZfZNEU1Zb8EvyOsfm.jpg', 'clients/ghana_cards/qhSfP55jKb0AjlP11E4HbsXjwQZhjXfiCt51HH3j.jpg', NULL, '2025-12-10 14:49:40', '2025-12-10 14:49:40'), (192, 'OBGCCU00197', NULL, 'Snow', 'james', NULL, 'Male', '1984-12-16', 'Tema', 'Ghanaian', '0244234015', 'sdadzie5@gmail.com', 'Tema community 9', 'GHA-00099-4', 'SGSSB', 'Accra', '123456', 'Savings_and_Susu_Account', '5000.00', NULL, NULL, NULL, NULL, 'Ebo', 'son', '0244234015', NULL, NULL, NULL, 'clients/photos/cwYLV3qmjghBJxS9aBQ6MOWIrjWKYrkrGTTVEQHL.jpg', 'clients/ghana_cards/7LHrqAB7fOpalXK0zdbM5tbAz8svZwxExBGNtFFv.jpg', NULL, '2025-12-24 12:12:16', '2026-01-02 08:58:33'), (193, 'OBGCCU00198', 'Miss', 'Gabon', 'Lawson', 'Kofi', 'Male', '1993-10-14', 'Nsawam', 'Ghanaian', '0244123123', 'gabonlawsom@gmail.com', 'es-0007-4321', 'GHA-727880709-9', 'Momo', 'Suhum', '0244123123', 'Savings_and_Susu_Account', '400.00', 'Fixed_Deposits_Account', '6000.00', NULL, NULL, 'Sam Gabon', 'Son', '023345765', 'GLoria Gabon', 'Daughter', '0552373867', 'clients/photos/7n1FJ21uTitwKRXc3XOjQVHpvXKQk42KRucuedcN.jpg', 'clients/ghana_cards/rw00gbRJ9JLRCfZ9UX5Vs3PW6L9RPKGbPCUpSpDp.jpg', NULL, '2025-12-26 10:23:02', '2026-01-05 14:57:40'), (194, 'OBGCCU00199', 'Mrs', 'Dadzie', 'Naa', 'Dromo', 'Female', '2019-01-30', 'Tema', 'Ghanaian', '0244234015', 'sdadzie5@gmail.com', 'Tema community 9', 'GHA-727880709-9', 'SGSSB', 'Suhum', '123456', 'Savings_and_Susu_Account', '1500.00', 'Salary_Account', '1000.00', 'Fixed_Deposits_Account', '10000.00', 'Nicholas Hagan', 'Mother', '0244234015', 'GLoria Gabon', 'Daughter', '0244234015', 'clients/photos/I2YxEUKUYeRwEGgdX6iaMAHdSoXQZmeDdyw5Czn7.jpg', 'clients/ghana_cards/E9gNyB0egRZVKQCj8EA7grw7LTmPj1dw5JqmhCq5.jpg', NULL, '2026-01-02 12:11:09', '2026-01-05 14:36:34'); -- -------------------------------------------------------- -- -- Table structure for table `client_accounts` -- DROP TABLE IF EXISTS `client_accounts`; CREATE TABLE IF NOT EXISTS `client_accounts` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` bigint UNSIGNED NOT NULL, `account_type` enum('Savings_and_Susu_Account','Kids_and_Student_Account','Salary_Account','Group_Account','Xmas_Account','Business_Account','Shares_Account','Fixed_Deposits_Account','Investment_Portfolio_Account','Retirement_Account') COLLATE utf8mb4_unicode_ci NOT NULL, `initial_deposit` decimal(15,2) DEFAULT '0.00', `balance` decimal(15,2) NOT NULL DEFAULT '0.00', `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `client_accounts_client_id_account_type_unique` (`client_id`,`account_type`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `client_accounts` -- INSERT INTO `client_accounts` (`id`, `client_id`, `account_type`, `initial_deposit`, `balance`, `is_active`, `created_at`, `updated_at`) VALUES (9, 194, 'Savings_and_Susu_Account', '0.00', '3400.04', 1, '2026-01-02 22:50:30', '2026-01-06 17:37:17'), (10, 194, 'Salary_Account', '0.00', '0.00', 1, '2026-01-05 14:36:34', '2026-01-05 14:36:34'), (11, 194, 'Fixed_Deposits_Account', '0.00', '1000.00', 1, '2026-01-05 14:36:34', '2026-01-05 18:34:19'), (12, 193, 'Savings_and_Susu_Account', '0.00', '2400.03', 1, '2026-01-05 14:57:40', '2026-01-06 12:41:25'), (13, 193, 'Fixed_Deposits_Account', '0.00', '8000.00', 1, '2026-01-05 14:57:40', '2026-01-05 15:24:22'); -- -------------------------------------------------------- -- -- Table structure for table `deposits` -- DROP TABLE IF EXISTS `deposits`; CREATE TABLE IF NOT EXISTS `deposits` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` bigint UNSIGNED NOT NULL, `client_account_id` bigint UNSIGNED DEFAULT NULL, `amount` decimal(15,2) NOT NULL, `payment_method` enum('cash','transfer','cheque') COLLATE utf8mb4_unicode_ci NOT NULL, `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `teller_id` bigint UNSIGNED DEFAULT NULL, `teller_drawer_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `deposits_reference_no_unique` (`reference_no`), KEY `deposits_client_id_foreign` (`client_id`), KEY `deposits_teller_id_foreign` (`teller_id`), KEY `deposits_client_account_id_foreign` (`client_account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `deposits` -- INSERT INTO `deposits` (`id`, `client_id`, `client_account_id`, `amount`, `payment_method`, `reference_no`, `teller_id`, `teller_drawer_id`, `created_at`, `updated_at`) VALUES (2, 5, NULL, '780.00', 'cash', 'DEP-YHYPGJYDR', 1, NULL, '2025-12-10 09:47:31', '2025-12-10 09:47:31'), (3, 6, NULL, '190.00', 'cash', 'DEP-Q0MGCEH5Y', 1, NULL, '2025-12-10 09:49:10', '2025-12-10 09:49:10'), (4, 22, NULL, '940.00', 'cash', 'DEP-12ARMPNRK', 1, NULL, '2025-12-10 09:58:28', '2025-12-10 09:58:28'), (5, 20, NULL, '600.00', 'cash', 'DEP-XYUWAIPAP', 1, NULL, '2025-12-10 10:03:53', '2025-12-10 10:03:53'), (6, 26, NULL, '1230.00', 'cash', 'DEP-55P8UAFDO', 1, NULL, '2025-12-10 10:04:42', '2025-12-10 10:04:42'), (7, 191, NULL, '130000.00', 'cash', 'DEP-W659XH8ZV', 1, NULL, '2025-10-01 14:51:58', '2025-10-01 14:51:58'), (8, 5, NULL, '800.00', 'cash', 'DEP-G9XVJ2EY1', 1, NULL, '2025-12-11 18:47:45', '2025-12-11 18:47:45'), (9, 122, NULL, '1000.00', 'cash', 'DEP-M8YCU1SKI', 1, NULL, '2025-12-12 14:24:18', '2025-12-12 14:24:18'), (10, 191, NULL, '1000.00', 'cash', 'DEP-WHHHBIF3B', 1, NULL, '2025-12-12 15:16:52', '2025-12-12 15:16:52'), (28, 193, 12, '2000.00', 'cash', 'DEP-PCF8FR942', 1, NULL, '2026-01-05 15:23:29', '2026-01-05 15:23:29'), (22, 194, 9, '0.00', 'cash', 'DEP-9W0YKAVVQ', 1, NULL, '2026-01-02 22:51:22', '2026-01-02 22:51:22'), (23, 194, 9, '1000.00', 'cash', 'DEP-ZUZEHX7H9', 1, NULL, '2026-01-02 22:52:09', '2026-01-02 22:52:09'), (24, 194, 9, '500.00', 'cash', 'DEP-9S20S3GDP', 1, NULL, '2026-01-02 23:27:02', '2026-01-02 23:27:02'), (25, 194, 9, '500.00', 'cash', 'DEP-KDMGY5U9H', 1, NULL, '2026-01-02 23:37:40', '2026-01-02 23:37:40'), (26, 194, 9, '500.00', 'cash', 'DEP-CVMZHVO9O', 1, NULL, '2026-01-05 07:58:18', '2026-01-05 07:58:18'), (27, 193, 12, '400.00', 'cash', 'DEP-JCNX2EYK6', 1, NULL, '2026-01-05 14:59:35', '2026-01-05 14:59:57'), (29, 193, 13, '6000.00', 'cash', 'DEP-5S7YPCEX3', 1, NULL, '2026-01-05 15:23:59', '2026-01-05 15:23:59'), (30, 193, 13, '2000.00', 'cash', 'DEP-3XHQMSEKC', 1, NULL, '2026-01-05 15:24:22', '2026-01-05 15:24:22'), (31, 194, 11, '1000.00', 'cash', 'DEP-WHPD2CBP8', 1, NULL, '2026-01-05 18:34:19', '2026-01-05 18:34:19'), (32, 194, 9, '500.00', 'cash', 'DEP-4OJ9UBH87', 1, NULL, '2026-01-06 17:37:17', '2026-01-06 17:37:17'); -- -------------------------------------------------------- -- -- Table structure for table `deposit_reversals` -- DROP TABLE IF EXISTS `deposit_reversals`; CREATE TABLE IF NOT EXISTS `deposit_reversals` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `deposit_id` bigint UNSIGNED NOT NULL, `client_account_id` bigint UNSIGNED NOT NULL, `amount` decimal(15,2) NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci NOT NULL, `reversed_by` bigint UNSIGNED NOT NULL, `reversed_at` timestamp NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `deposit_reversals_deposit_id_foreign` (`deposit_id`), KEY `deposit_reversals_client_account_id_foreign` (`client_account_id`), KEY `deposit_reversals_reversed_by_foreign` (`reversed_by`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `interest_histories` -- DROP TABLE IF EXISTS `interest_histories`; CREATE TABLE IF NOT EXISTS `interest_histories` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `savings_account_id` bigint UNSIGNED NOT NULL, `old_balance` decimal(15,2) NOT NULL, `interest_amount` decimal(15,2) NOT NULL, `new_balance` decimal(15,2) NOT NULL, `rate` decimal(8,4) NOT NULL, `frequency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `calculated_on` date NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `interest_histories` -- INSERT INTO `interest_histories` (`id`, `savings_account_id`, `old_balance`, `interest_amount`, `new_balance`, `rate`, `frequency`, `calculated_on`, `created_at`, `updated_at`) VALUES (1, 1, '3000.00', '0.04', '3000.04', '0.5000', 'daily', '2026-01-06', '2026-01-06 12:41:25', '2026-01-06 12:41:25'), (2, 2, '2400.00', '0.03', '2400.03', '0.5000', 'daily', '2026-01-06', '2026-01-06 12:41:25', '2026-01-06 12:41:25'); -- -------------------------------------------------------- -- -- Table structure for table `interest_rates` -- DROP TABLE IF EXISTS `interest_rates`; CREATE TABLE IF NOT EXISTS `interest_rates` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `plan_type` enum('savings','loan') COLLATE utf8mb4_unicode_ci NOT NULL, `rate` decimal(5,2) NOT NULL, `effective_date` date NOT NULL, `created_by` bigint UNSIGNED NOT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `interest_rates_created_by_foreign` (`created_by`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `loans` -- DROP TABLE IF EXISTS `loans`; CREATE TABLE IF NOT EXISTS `loans` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` bigint UNSIGNED NOT NULL, `created_by` int DEFAULT NULL, `loan_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` decimal(15,2) NOT NULL DEFAULT '0.00', `outstanding_principal` decimal(12,2) NOT NULL DEFAULT '0.00', `interest_rate` decimal(5,2) NOT NULL, `monthly_repayment_amount` decimal(15,2) NOT NULL DEFAULT '0.00', `total_repayable_amount` decimal(15,2) NOT NULL DEFAULT '0.00', `tenor_months` int NOT NULL, `repayment_start` date NOT NULL, `repayment_end` date NOT NULL, `status` enum('pending','approved','disbursed','completed','defaulted') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `approval_status` enum('pending','approved','rejected') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `approved_by` bigint UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `loans_loan_number_unique` (`loan_number`), KEY `loans_client_id_foreign` (`client_id`), KEY `loans_approved_by_foreign` (`approved_by`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `loans` -- INSERT INTO `loans` (`id`, `client_id`, `created_by`, `loan_number`, `amount`, `outstanding_principal`, `interest_rate`, `monthly_repayment_amount`, `total_repayable_amount`, `tenor_months`, `repayment_start`, `repayment_end`, `status`, `approval_status`, `approved_by`, `created_at`, `updated_at`) VALUES (1, 5, NULL, 'LN-2025-0001', '500.00', '0.00', '0.60', '0.00', '0.00', 3, '2025-12-12', '2026-03-12', 'completed', 'approved', 2, '2025-12-12 09:40:57', '2025-12-30 14:14:05'), (2, 45, NULL, 'LN-2025-0002', '1000.00', '106.65', '6.00', '0.00', '0.00', 6, '2025-12-24', '2026-06-24', 'completed', 'approved', 2, '2025-12-24 16:45:53', '2025-12-30 14:16:15'), (3, 193, 1, 'LN-2025-0003', '1000.00', '400.00', '6.00', '0.00', '0.00', 4, '2025-12-26', '2026-04-26', 'completed', 'approved', 2, '2025-12-26 19:27:02', '2025-12-30 14:23:48'), (4, 45, 1, 'LN-2025-0004', '6000.00', '2240.00', '6.00', '0.00', '0.00', 5, '2025-12-26', '2026-05-26', 'completed', 'approved', 2, '2025-12-26 22:31:40', '2025-12-30 14:24:09'), (5, 1, 1, 'LN-2025-0005', '5000.00', '0.00', '6.00', '0.00', '0.00', 5, '2025-12-30', '2026-05-30', 'completed', 'approved', 2, '2025-12-30 15:28:16', '2025-12-30 16:48:17'), (6, 122, 1, 'LN-2025-0006', '5000.00', '0.00', '6.00', '0.00', '0.00', 5, '2025-12-30', '2026-05-30', 'completed', 'approved', 2, '2025-12-30 17:01:54', '2025-12-30 17:20:57'), (7, 19, 1, 'LN-2025-0007', '5000.00', '0.00', '6.00', '1300.00', '6500.00', 5, '2025-12-30', '2026-05-30', 'completed', 'approved', 2, '2025-12-30 18:11:57', '2025-12-31 12:42:25'), (8, 127, 1, 'LN-2025-0008', '5000.00', '0.00', '6.00', '1300.00', '6500.00', 5, '2025-12-31', '2026-05-31', 'completed', 'approved', 2, '2025-12-31 12:49:20', '2025-12-31 12:52:16'), (9, 90, 1, 'LN-2025-0009', '5000.00', '0.00', '6.00', '1300.00', '6500.00', 5, '2025-12-31', '2026-05-31', 'completed', 'approved', 2, '2025-12-31 13:10:01', '2025-12-31 20:12:36'), (10, 169, 1, 'LN-2025-0010', '5000.00', '0.00', '6.00', '1300.00', '6500.00', 5, '2025-12-31', '2026-05-31', 'completed', 'approved', 2, '2025-12-31 20:14:22', '2025-12-31 20:35:04'); -- -------------------------------------------------------- -- -- Table structure for table `loan_payments` -- DROP TABLE IF EXISTS `loan_payments`; CREATE TABLE IF NOT EXISTS `loan_payments` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `loan_id` bigint UNSIGNED NOT NULL, `client_id` bigint UNSIGNED NOT NULL, `amount` decimal(15,2) NOT NULL, `payment_date` date NOT NULL, `payment_method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cash', `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teller_id` bigint UNSIGNED NOT NULL, `status` enum('posted','reversed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'posted', `reversal_reason` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `loan_payments_client_id_foreign` (`client_id`), KEY `loan_payments_teller_id_foreign` (`teller_id`), KEY `loan_payments_loan_id_payment_date_index` (`loan_id`,`payment_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `loan_repayments` -- DROP TABLE IF EXISTS `loan_repayments`; CREATE TABLE IF NOT EXISTS `loan_repayments` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `loan_id` bigint UNSIGNED NOT NULL, `installment_number` int NOT NULL, `repayment_date` date NOT NULL, `principal` decimal(15,2) NOT NULL, `interest` decimal(15,2) NOT NULL, `total_payment` decimal(15,2) NOT NULL, `remaining_principal` decimal(15,2) NOT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `amount_paid` decimal(15,2) DEFAULT '0.00', `outstanding` decimal(12,2) NOT NULL DEFAULT '0.00', `payment_date` date DEFAULT NULL, `teller_id` bigint UNSIGNED DEFAULT NULL, `receipt_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paid_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `loan_repayments_loan_id_foreign` (`loan_id`), KEY `loan_repayments_teller_id_foreign` (`teller_id`) ) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `loan_repayments` -- INSERT INTO `loan_repayments` (`id`, `loan_id`, `installment_number`, `repayment_date`, `principal`, `interest`, `total_payment`, `remaining_principal`, `status`, `amount_paid`, `outstanding`, `payment_date`, `teller_id`, `receipt_no`, `paid_at`, `created_at`, `updated_at`) VALUES (1, 1, 1, '2025-12-12', '166.67', '3.00', '169.67', '333.33', 'paid', '169.67', '0.00', '2025-12-30', 1, NULL, NULL, '2025-12-12 09:40:57', '2025-12-30 12:19:55'), (2, 1, 2, '2026-01-12', '83.33', '1.00', '84.33', '83.33', 'paid', '84.33', '0.00', '2025-12-30', 1, NULL, NULL, '2025-12-12 09:40:57', '2025-12-30 12:22:19'), (3, 1, 3, '2026-02-12', '166.67', '1.00', '167.67', '0.00', 'paid', '167.67', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-12 09:40:57', '2025-12-30 13:46:42'), (4, 2, 1, '2025-12-24', '166.67', '60.00', '226.67', '833.33', 'paid', NULL, '0.00', '2025-12-26', 4, NULL, NULL, '2025-12-24 16:45:53', '2025-12-26 11:18:09'), (5, 2, 2, '2026-01-24', '166.67', '60.00', '226.67', '666.67', 'paid', NULL, '0.00', '2025-12-26', 4, NULL, NULL, '2025-12-24 16:45:53', '2025-12-26 11:18:44'), (6, 2, 3, '2026-02-24', '166.67', '60.00', '226.67', '500.00', 'paid', NULL, '0.00', '2025-12-26', 4, NULL, NULL, '2025-12-24 16:45:53', '2025-12-26 11:18:48'), (7, 2, 4, '2026-03-24', '166.67', '60.00', '226.67', '333.33', 'paid', '226.67', '0.00', '2025-12-29', 1, NULL, NULL, '2025-12-24 16:45:53', '2025-12-29 18:18:12'), (8, 2, 5, '2026-04-24', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-24 16:45:53', '2025-12-30 14:16:15'), (9, 2, 6, '2026-05-24', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-24 16:45:53', '2025-12-30 14:16:15'), (10, 3, 1, '2025-12-26', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-26 19:27:02', '2025-12-30 14:23:48'), (11, 3, 2, '2026-01-26', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-26 19:27:02', '2025-12-30 14:23:48'), (12, 3, 3, '2026-02-26', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-26 19:27:02', '2025-12-30 14:23:48'), (13, 3, 4, '2026-03-26', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-26 19:27:02', '2025-12-30 14:23:48'), (14, 4, 1, '2025-12-26', '1200.00', '360.00', '1560.00', '4800.00', 'paid', NULL, '0.00', '2025-12-27', 1, NULL, NULL, '2025-12-26 22:31:40', '2025-12-27 00:38:21'), (15, 4, 2, '2026-01-26', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-26 22:31:40', '2025-12-30 14:24:09'), (16, 4, 3, '2026-02-26', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-26 22:31:40', '2025-12-30 14:24:09'), (17, 4, 4, '2026-03-26', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-26 22:31:40', '2025-12-30 14:24:09'), (18, 4, 5, '2026-04-26', '0.00', '0.00', '0.00', '0.00', 'paid', '0.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000002', NULL, '2025-12-26 22:31:40', '2025-12-30 14:24:09'), (19, 5, 1, '2025-12-30', '1000.00', '300.00', '1300.00', '4000.00', 'paid', '1300.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000003', NULL, '2025-12-30 15:28:16', '2025-12-30 16:40:58'), (20, 5, 2, '2026-01-30', '1000.00', '240.00', '1240.00', '3000.00', 'paid', '1240.00', '0.00', '2025-12-30', 2, 'RCPT-2025-000004', NULL, '2025-12-30 15:28:16', '2025-12-30 16:43:07'), (21, 5, 3, '2026-03-02', '1000.00', '180.00', '1180.00', '2000.00', 'paid', '1180.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000005', NULL, '2025-12-30 15:28:16', '2025-12-30 16:44:17'), (22, 5, 4, '2026-03-30', '1000.00', '120.00', '1120.00', '1000.00', 'paid', '1120.00', '0.00', '2025-12-30', 2, 'RCPT-2025-000006', NULL, '2025-12-30 15:28:16', '2025-12-30 16:46:46'), (23, 5, 5, '2026-04-30', '1000.00', '60.00', '1060.00', '0.00', 'paid', '1060.00', '0.00', '2025-12-30', 2, 'RCPT-2025-000007', NULL, '2025-12-30 15:28:16', '2025-12-30 16:48:17'), (24, 6, 1, '2025-12-30', '1000.00', '300.00', '1300.00', '4000.00', 'paid', '1300.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000008', NULL, '2025-12-30 17:01:54', '2025-12-30 17:20:57'), (25, 6, 2, '2026-01-30', '-300.00', '300.00', '0.00', '3000.00', 'pending', NULL, '0.00', NULL, NULL, NULL, NULL, '2025-12-30 17:01:54', '2025-12-30 17:20:57'), (26, 6, 3, '2026-03-02', '-300.00', '300.00', '0.00', '2000.00', 'pending', NULL, '0.00', NULL, NULL, NULL, NULL, '2025-12-30 17:01:54', '2025-12-30 17:20:57'), (27, 6, 4, '2026-03-30', '-300.00', '300.00', '0.00', '1000.00', 'pending', NULL, '0.00', NULL, NULL, NULL, NULL, '2025-12-30 17:01:54', '2025-12-30 17:20:57'), (28, 6, 5, '2026-04-30', '-300.00', '300.00', '0.00', '0.00', 'pending', NULL, '0.00', NULL, NULL, NULL, NULL, '2025-12-30 17:01:54', '2025-12-30 17:20:57'), (29, 7, 1, '2025-12-30', '1000.00', '300.00', '1300.00', '4000.00', 'paid', '1300.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000009', NULL, '2025-12-30 18:11:57', '2025-12-30 18:33:30'), (30, 7, 2, '2026-01-30', '1000.00', '300.00', '1300.00', '3000.00', 'paid', '1300.00', '0.00', '2025-12-30', 1, 'RCPT-2025-000010', NULL, '2025-12-30 18:11:57', '2025-12-30 18:34:10'), (31, 7, 3, '2026-03-02', '966.67', '300.00', '1266.67', '2000.00', 'paid', '1266.67', '0.00', '2025-12-30', 1, 'RCPT-2025-000011', NULL, '2025-12-30 18:11:57', '2025-12-30 18:34:42'), (32, 7, 4, '2026-03-30', '966.67', '300.00', '1266.67', '1000.00', 'paid', '1266.67', '0.00', '2025-12-30', 1, 'RCPT-2025-000012', NULL, '2025-12-30 18:11:57', '2025-12-30 18:35:07'), (33, 7, 5, '2026-04-30', '933.34', '300.00', '1233.34', '0.00', 'paid', '1233.34', '0.00', '2025-12-31', 1, 'RCPT-2025-000014', NULL, '2025-12-30 18:11:57', '2025-12-31 12:42:25'), (34, 8, 1, '2025-12-31', '1000.00', '300.00', '1300.00', '4000.00', 'paid', '1300.00', '0.00', '2025-12-31', 2, 'RCPT-2025-000015', NULL, '2025-12-31 12:49:20', '2025-12-31 12:50:31'), (35, 8, 2, '2026-01-31', '1000.00', '300.00', '1300.00', '3000.00', 'paid', '1300.00', '0.00', '2025-12-31', 2, 'RCPT-2025-000016', NULL, '2025-12-31 12:49:20', '2025-12-31 12:51:00'), (36, 8, 3, '2026-03-03', '1000.00', '300.00', '1300.00', '2000.00', 'paid', '1300.00', '0.00', '2025-12-31', 2, 'RCPT-2025-000017', NULL, '2025-12-31 12:49:20', '2025-12-31 12:51:25'), (37, 8, 4, '2026-03-31', '950.00', '300.00', '1250.00', '1000.00', 'paid', '1250.00', '0.00', '2025-12-31', 2, 'RCPT-2025-000018', NULL, '2025-12-31 12:49:20', '2025-12-31 12:51:56'), (38, 8, 5, '2026-05-01', '950.00', '300.00', '1250.00', '0.00', 'paid', '1250.00', '0.00', '2025-12-31', 2, 'RCPT-2025-000019', NULL, '2025-12-31 12:49:20', '2025-12-31 12:52:16'), (39, 9, 1, '2025-12-31', '1000.00', '300.00', '1300.00', '4000.00', 'paid', '1300.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000024', NULL, '2025-12-31 13:10:01', '2025-12-31 20:12:36'), (40, 9, 2, '2026-01-31', '1000.00', '300.00', '1300.00', '3000.00', 'paid', '1300.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000024', NULL, '2025-12-31 13:10:01', '2025-12-31 20:12:36'), (41, 9, 3, '2026-03-03', '1000.00', '300.00', '1300.00', '2000.00', 'paid', '1300.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000024', NULL, '2025-12-31 13:10:01', '2025-12-31 20:12:36'), (42, 9, 4, '2026-03-31', '950.00', '300.00', '1250.00', '1000.00', 'paid', '1250.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000024', NULL, '2025-12-31 13:10:01', '2025-12-31 20:12:36'), (43, 9, 5, '2026-05-01', '950.00', '300.00', '1250.00', '0.00', 'paid', '1250.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000024', NULL, '2025-12-31 13:10:01', '2025-12-31 20:12:36'), (44, 10, 1, '2025-12-31', '1000.00', '300.00', '1300.00', '4000.00', 'paid', '3800.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000029', NULL, '2025-12-31 20:14:22', '2025-12-31 20:35:04'), (45, 10, 2, '2026-01-31', '1000.00', '300.00', '1300.00', '3000.00', 'paid', '3800.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000029', NULL, '2025-12-31 20:14:22', '2025-12-31 20:35:04'), (46, 10, 3, '2026-03-03', '1000.00', '300.00', '1300.00', '2000.00', 'paid', '3800.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000029', NULL, '2025-12-31 20:14:22', '2025-12-31 20:35:04'), (47, 10, 4, '2026-03-31', '1000.00', '300.00', '1300.00', '1000.00', 'paid', '2600.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000029', NULL, '2025-12-31 20:14:22', '2025-12-31 20:35:04'), (48, 10, 5, '2026-05-01', '1000.00', '300.00', '1300.00', '0.00', 'paid', '1300.00', '0.00', '2025-12-31', 1, 'RCPT-2025-000029', NULL, '2025-12-31 20:14:22', '2025-12-31 20:35:04'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; CREATE TABLE IF NOT EXISTS `migrations` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (29, '2019_12_14_000001_create_personal_access_tokens_table', 1), (30, '2025_11_06_175226_create_deposits_table', 1), (31, '2025_11_06_175550_create_savings_accounts_table', 1), (32, '2025_11_06_175704_create_loans_table', 1), (33, '2025_11_06_181011_create_transactions_table', 1), (34, '2025_11_06_181225_create_interest_rates_table', 1), (35, '2025_11_06_181309_create_settings_table', 1), (36, '2025_11_06_184209_create_users_table', 1), (37, '2025_11_11_162918_create_clients_table', 1), (38, '2025_11_18_172504_create_savings_interests_table', 1), (39, '2025_11_18_182026_create_interest_histories_table', 1), (40, '2025_11_26_181913_create_loan_repayments_table', 1), (41, '2025_11_28_174043_create_roles_table', 1), (42, '2025_11_28_180923_create_role_user_table', 1), (45, '2025_12_12_152625_create_teller_drawers_table', 2), (46, '2025_12_12_153437_create_teller_transactions_table', 2), (47, '2025_12_24_162812_add_approval_fields_to_transactions_table', 3), (48, '2025_12_24_181140_add_created_by_fields_to_loans_table', 4), (49, '2025_12_27_000242_create_loan_payments_table', 5), (50, '2025_12_30_172934_add_repayment_fields_to_loans_table', 6), (51, '2026_01_02_092809_create_client_accounts_table', 7), (52, '2026_01_02_184123_add_client_account_id_to_deposits_table', 8), (53, '2026_01_03_205714_create_deposit_reversals_table', 9), (54, '2026_01_05_135835_add_status_to_client_accounts_table', 10), (55, '2026_01_06_182216_add_closed_at_to_teller_drawers_table', 11); -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; CREATE TABLE IF NOT EXISTS `permissions` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; CREATE TABLE IF NOT EXISTS `roles` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_unique` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `role_user` -- DROP TABLE IF EXISTS `role_user`; CREATE TABLE IF NOT EXISTS `role_user` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint UNSIGNED NOT NULL, `role_id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `role_user_user_id_foreign` (`user_id`), KEY `role_user_role_id_foreign` (`role_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `savings_accounts` -- DROP TABLE IF EXISTS `savings_accounts`; CREATE TABLE IF NOT EXISTS `savings_accounts` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` bigint UNSIGNED NOT NULL, `client_account_id` bigint UNSIGNED NOT NULL, `account_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `balance` decimal(15,2) NOT NULL DEFAULT '0.00', `interest_rate` decimal(5,2) NOT NULL DEFAULT '0.00', `plan_type` enum('daily','weekly','fixed') COLLATE utf8mb4_unicode_ci NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `status` enum('active','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `savings_accounts_account_number_unique` (`account_number`), KEY `savings_accounts_client_id_foreign` (`client_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `savings_accounts` -- INSERT INTO `savings_accounts` (`id`, `client_id`, `client_account_id`, `account_number`, `balance`, `interest_rate`, `plan_type`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`) VALUES (1, 194, 9, 'OBGCCU00199', '0.00', '0.50', 'daily', '2026-01-05', NULL, 'active', '2026-01-05 22:24:51', '2026-01-05 22:24:51'), (2, 193, 12, 'OBGCCU00198', '0.00', '0.50', 'daily', '2026-01-05', NULL, 'active', '2026-01-05 22:26:50', '2026-01-05 22:26:50'); -- -------------------------------------------------------- -- -- Table structure for table `savings_interests` -- DROP TABLE IF EXISTS `savings_interests`; CREATE TABLE IF NOT EXISTS `savings_interests` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `savings_account_id` bigint UNSIGNED NOT NULL, `frequency` enum('daily','weekly','monthly') COLLATE utf8mb4_unicode_ci NOT NULL, `interest_rate` decimal(8,4) NOT NULL, `last_balance` decimal(20,2) NOT NULL DEFAULT '0.00', `last_calculated_at` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `savings_interests_savings_account_id_foreign` (`savings_account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `savings_interests` -- INSERT INTO `savings_interests` (`id`, `savings_account_id`, `frequency`, `interest_rate`, `last_balance`, `last_calculated_at`, `created_at`, `updated_at`) VALUES (1, 1, 'daily', '0.5000', '3000.00', '2026-01-06', '2026-01-06 12:00:41', '2026-01-06 12:41:25'), (2, 2, 'daily', '0.5000', '2400.00', '2026-01-06', '2026-01-06 12:01:38', '2026-01-06 12:41:25'); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; CREATE TABLE IF NOT EXISTS `settings` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_key_unique` (`key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `teller_drawers` -- DROP TABLE IF EXISTS `teller_drawers`; CREATE TABLE IF NOT EXISTS `teller_drawers` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint UNSIGNED NOT NULL, `opening_balance` decimal(12,2) NOT NULL DEFAULT '0.00', `closing_balance` decimal(12,2) NOT NULL DEFAULT '0.00', `total_deposits` decimal(12,2) NOT NULL DEFAULT '0.00', `total_withdrawals` decimal(12,2) NOT NULL DEFAULT '0.00', `date` date DEFAULT NULL, `teller_drawer_id` int DEFAULT NULL, `variance` decimal(12,2) NOT NULL DEFAULT '0.00', `status` enum('open','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `closed_at` timestamp NULL DEFAULT NULL, `closed_by` bigint UNSIGNED DEFAULT NULL, `forced_close` tinyint(1) NOT NULL DEFAULT '0', `force_close_reason` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `teller_drawers_user_id_foreign` (`user_id`), KEY `teller_drawers_closed_by_foreign` (`closed_by`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `teller_drawers` -- INSERT INTO `teller_drawers` (`id`, `user_id`, `opening_balance`, `closing_balance`, `total_deposits`, `total_withdrawals`, `date`, `teller_drawer_id`, `variance`, `status`, `created_at`, `updated_at`, `closed_at`, `closed_by`, `forced_close`, `force_close_reason`) VALUES (7, 1, '10000.00', '0.00', '0.00', '0.00', '2026-01-06', NULL, '0.00', 'open', '2026-01-06 13:15:57', '2026-01-06 13:15:57', NULL, NULL, 0, NULL), (8, 5, '50000.00', '0.00', '0.00', '0.00', NULL, NULL, '0.00', 'open', '2026-01-07 09:43:11', '2026-01-07 09:43:11', NULL, NULL, 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `teller_transactions` -- DROP TABLE IF EXISTS `teller_transactions`; CREATE TABLE IF NOT EXISTS `teller_transactions` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `drawer_id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `client_id` bigint UNSIGNED DEFAULT NULL, `type` enum('deposit','withdrawal','transfer_in','transfer_out') COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(12,2) NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `teller_transactions_drawer_id_foreign` (`drawer_id`), KEY `teller_transactions_user_id_foreign` (`user_id`), KEY `teller_transactions_client_id_foreign` (`client_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- DROP TABLE IF EXISTS `transactions`; CREATE TABLE IF NOT EXISTS `transactions` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` bigint UNSIGNED NOT NULL, `type` enum('deposit','withdrawal','loan_disbursement','loan_repayment','interest_credit') COLLATE utf8mb4_unicode_ci NOT NULL, `approval_status` enum('pending','approved','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `amount` decimal(15,2) NOT NULL, `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `balance_after` decimal(15,2) NOT NULL DEFAULT '0.00', `teller_drawer_id` int DEFAULT NULL, `remarks` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `approved_by` bigint UNSIGNED DEFAULT NULL, `approved_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `transactions_client_id_foreign` (`client_id`), KEY `transactions_approved_by_foreign` (`approved_by`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `client_id`, `type`, `approval_status`, `amount`, `reference`, `balance_after`, `teller_drawer_id`, `remarks`, `created_at`, `updated_at`, `approved_by`, `approved_at`) VALUES (5, 194, 'withdrawal', 'pending', '100.00', 'WD-1767705393', '2900.04', NULL, 'To pay fees', '2026-01-06 13:16:33', '2026-01-06 13:16:33', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `role` enum('admin','teller','client','manager','loan_officer') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin', `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role_id` bigint UNSIGNED DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), KEY `users_role_id_foreign` (`role_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone`, `address`, `status`, `remember_token`, `deleted_at`, `created_at`, `updated_at`, `role_id`, `is_active`) VALUES (1, 'Admin', 'admin@gmail.com', '2025-12-02 16:21:56', '$2y$10$r0d1HOj.V1keaeDnUzyvR.xJemLBDC8iEdwh0pVrhFg0g.dUA.yru', 'admin', NULL, NULL, 'active', 't7TznsE4zJ0wgtDAfJG84OWvnKJRYHZgzr6T6jgHV3xEwUzaC9EWEOWzRb50', NULL, '2025-12-02 16:21:56', '2025-12-24 14:50:11', NULL, 1), (2, 'Sam Hagan', 'sam@gmail.com', NULL, '$2y$10$YsmW3sbxlpEooRffaS/yNeHvuL2pSXLdcko8tTj2vJ7exmP6baEAa', 'manager', NULL, NULL, 'active', NULL, NULL, '2025-12-24 16:17:10', '2025-12-24 17:20:08', NULL, 1), (3, 'OWusu-Danso Eugene', 'eugene@gmail.com', NULL, '$2y$10$86efzB5F/Z7YKHvzXerd1OcQPJ9yNmFqzfJ7OECsE/S.FGGIC2phu', 'teller', NULL, NULL, 'active', NULL, NULL, '2025-12-26 10:13:20', '2025-12-26 10:13:20', NULL, 1), (4, 'Gbogbogah Richard', 'richard@gmail.com', NULL, '$2y$10$GHoJ1H92nzHOIqtI4N4DlOWUld54jCH9mWzp7vvqh3jShTR3y9RtG', 'loan_officer', NULL, NULL, 'active', NULL, NULL, '2025-12-26 10:14:31', '2025-12-26 10:14:31', NULL, 1), (5, 'sera', 'sera@gmail.com', NULL, '$2y$10$geRz0rrq2RLiEeNp5iMLJeASFo7S6LY3BP9ufT6nEHtQrlssbM6t6', 'teller', NULL, NULL, 'active', NULL, NULL, '2025-12-29 15:59:09', '2025-12-29 15:59:09', NULL, 1); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;