-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `savingloandb`
--
CREATE DATABASE IF NOT EXISTS `savingloandb` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
USE `savingloandb`;

-- --------------------------------------------------------

--
-- Table structure for table `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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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 `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`
--

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`
--

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`
--

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 `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`
--

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`
--

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);
COMMIT;

