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

START TRANSACTION;



--
-- Database: `logistics`
--

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

--
-- Table structure for table `boda_agents_details`
--

CREATE TABLE `boda_agents_details` (
  `staffID` int(11) NOT NULL,
  `nextOfKinFullName` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nextOfKinRelationship` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nextOfKinPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `residence` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bikePlateNumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `areaOfOperation` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `registrationNumberOfOperation` int(10) DEFAULT NULL,
  `regFeeMpesaRefNo` varchar(100) DEFAULT NULL,
  `regFeeMpesaAccNo` varchar(100) DEFAULT NULL,
  `regFeeMpesaAmt` decimal(12,2) DEFAULT NULL,
  `regFeeMpesaReceiptNo` varchar(100) DEFAULT NULL,
  `regFeePaymentApproach` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeeLaterPaymentDate` datetime DEFAULT NULL,
  `regFeeLaterPaymentReason` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `commissionPaymentOption` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionMpesaNo` varchar(20) DEFAULT NULL,
  `commissionPaymentBankOptionBankName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionPaymentBankOptionBankBranch` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionPaymentBankOptionBankAccountNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `ownsBike` int(3) DEFAULT NULL,
  `bikeInsured` int(3) DEFAULT NULL,
  `bikeInsuranceCompany` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bikeOnLoan` int(3) DEFAULT NULL,
  `bikeOnHirePurchase` int(3) DEFAULT NULL,
  `bikeOnLoanAmount` decimal(12,2) DEFAULT NULL,
  `flexibleToCarryHeavyGoods` int(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `boda_agents_details`
--

INSERT INTO `boda_agents_details` (`staffID`, `nextOfKinFullName`, `nextOfKinRelationship`, `nextOfKinPhone`, `residence`, `bikePlateNumber`, `areaOfOperation`, `registrationNumberOfOperation`, `regFeeMpesaRefNo`, `regFeeMpesaAccNo`, `regFeeMpesaAmt`, `regFeeMpesaReceiptNo`, `regFeePaymentApproach`, `regFeeLaterPaymentDate`, `regFeeLaterPaymentReason`, `commissionPaymentOption`, `commissionMpesaNo`, `commissionPaymentBankOptionBankName`, `commissionPaymentBankOptionBankBranch`, `commissionPaymentBankOptionBankAccountNo`, `ownsBike`, `bikeInsured`, `bikeInsuranceCompany`, `bikeOnLoan`, `bikeOnHirePurchase`, `bikeOnLoanAmount`, `flexibleToCarryHeavyGoods`) VALUES
(38, 'Jane Kaluhi', 'wife', '0712233938', NULL, 'KMFJ 583K', 'commercial accra', 1, '0724036790', 'PBF70YREF', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '', 1, 1, 'sanlam insurance', 0, 0, NULL, NULL),
(41, 'Rahab wanjiru', 'mother', '0722818466', NULL, 'KMFJ 916W', 'Kirinyaga rd/voi rd', 5, '0727702141', 'PBF4P43084', '50.00', '005', 'Partial Payment', NULL, '', 'M-PESA', '0727702141', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(42, 'Hgfvvxv', 'Gvccvvg', '07854123658', NULL, 'KDgg334X', 'Ggff', 8542, 'TTYU5677G', 'Gjbghch vgb', '100.00', '58721', 'Partial Payment', NULL, '', 'M-PESA', '07854236521', '', '', '', 1, 1, 'Jubilee', 0, 1, NULL, NULL),
(50, 'Esther Wanjiku', 'mother', '0702243656', NULL, 'KMEN 460c', 'Guru nanak', 1, 'PBG7Q1DJD7B', 'Stephen', '5.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0705538928', '', '', '', 1, 1, 'Amaco', 0, 0, NULL, NULL),
(51, 'virginia njeri mwangi', 'wife', '0725126597', NULL, 'kmfk915f', 'marikiti', 1, 'PBF50XIA4V', 'JAMES', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '', 0, 0, '', 0, 1, NULL, NULL),
(52, 'Mofart Nhanga', 'son', '0759001022', NULL, 'KMEU 395M', 'Gurunanak', 1, 'PBG8Q2BOC8', 'Robert', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0722538969', '', '', '', 1, 1, 'Occidental', 0, 0, NULL, NULL),
(53, 'peninah waguthii njomo', 'wife', '0792789468', NULL, 'kmdj237f', 'country bus', 1, 'PBF9POT3QL', 'JOHN', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(54, 'Nancy Muthoni', 'Wife', '0717483316', NULL, 'KMFJ 428E', 'Muthurwa', 1, 'PBF6P2FEVO', 'Samuel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0746939335', '', '', '', 1, 1, 'Sanlam insurance', 0, 0, NULL, NULL),
(55, 'zulfa natalia', 'wife', '0712909066', NULL, 'kmfd660d', 'juja road', 1, 'PBG6Q5XCMI', 'JOHN', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '', 0, 1, 'monarch', 0, 0, NULL, NULL),
(56, 'zulfa natalia', 'wife', '0712909066', NULL, 'kmfd660d', 'juja road', 1, 'PBG6Q5XCMI', 'JOHN', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '', 0, 1, 'monarch', 0, 0, NULL, NULL),
(57, 'Jane njeri', 'mother', '0718344517', NULL, 'KMFB885P', 'Pangani chai rd', 1, 'PBG8Q5VYSE', 'Christom', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0705749803', '', '', '', 1, 1, 'Sanlam General', 0, 0, NULL, NULL),
(58, 'Victoria Gathoni', 'Friend ', '0714768963', NULL, 'kmxc 123y', 'juja', 2580369, 'pbf8h4298', 'sheila', '50.00', '236589', 'Partial Payment', NULL, '', 'M-PESA', '0714714319', '', '', '', 0, 0, '', 0, 0, NULL, NULL),
(71, 'miriam juma', 'wife', '0743639453', NULL, 'kmfh557e', 'ramu house Eastleigh', 1, 'PBG9Q9RU6V', 'MENLICK', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0722783708', '', '', '', 1, 1, 'sanlam', 0, 0, NULL, NULL),
(72, 'Pamela Gathoni', 'wife', '0705948376', NULL, 'KMDU376L', 'Eastleigh', 1, 'PBG6Q8PBYC', 'lawrence', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0715989593', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(73, 'petronila mwende', 'wife', '0707506349', NULL, 'KMFB 947Y', 'Gallore eastleigh', 1, 'PBG9QC020T', 'Elphas Bardot', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0727169637', '', '', '', 0, 1, 'Amaco', 0, 0, NULL, NULL),
(74, 'James Mwangi', 'brother', '0725424452', NULL, 'Kmfa 077t', 'Carissa Rd eastleigh', 1, 'PBG9QD1EXH', 'Moses', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0746586193', '', '', '', 1, 1, 'the monarch', 0, 0, NULL, NULL),
(75, 'Catherine Omia', 'wife', '0701202815', NULL, 'KMEL 969Z', '8th street', 1, 'PBG5QES0E3', 'Francis', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '', 0, 1, 'The monarch', 0, 0, NULL, NULL),
(76, 'Elizabeth Wambura', 'Mother', '0705622538', NULL, 'KMER 089N', '8th Street eastleigh', 1, 'PBG1QF0809', 'John', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0715714399', '', '', '', 1, 1, 'The monarch', 0, 0, NULL, NULL),
(77, 'Nancy Njambi', 'mother', '0724854346', NULL, 'KMEZ914C', 'Kirinyaga rd', 1, 'PBF3P6L2R', 'Simon', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0706635579', '', '', '', 1, 1, 'The Monarch', 0, 0, NULL, NULL),
(83, 'Prudence Mukami', 'Daughter', '0725548754', NULL, 'KMEL 257X', 'posts githurai', 1, 'PBH3RBKFNH', 'Charles', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0717544678', '', '', '', 0, 1, 'Amaco', 0, 0, NULL, NULL),
(84, 'Tabitha Waweru', 'Mother', '0716148752', NULL, 'KMEM 360F', 'posts githurai', 1, 'PBH9RBYBH5', 'Samuel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0716199076', '', '', '', 1, 1, 'The monarch', 0, 0, NULL, NULL),
(85, 'Catherine', 'mother', '0791634989', NULL, 'KMEL 325Y', 'posts githurai', 1, 'PBHRB1PS6', 'Ian', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0791634989', '', '', '', 1, 1, 'monarch', 0, 0, NULL, NULL),
(86, 'Wanjiku', 'mother', '0716199076', NULL, 'KMEZ910G', 'posts githurai', 1, 'PBH2RCQUT1', 'Joseph', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0796034944', '', '', '', 1, 1, 'monarch', 0, 0, NULL, NULL),
(87, 'Julia mwende', 'mother', '0796250697', NULL, 'KMEU 177D', 'posts githurai', 1, 'PBH3RDCRH7', '', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0742912205', '', '', '', 1, 1, 'Monarch', 0, 0, NULL, NULL),
(88, 'Ruth Wambui', 'wife', '0710405693', NULL, 'KMER 717M', 'posts githurai', 1, 'PBH1RBCN2B', 'Paul', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0724178069', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(89, 'Janerex Amunga', 'wife', '0725735518', NULL, 'KMEB 679G', 'Posts, githurai', 1, 'PBH9RE9BOT', 'Peter', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0720603344', '', '', '', 1, 1, 'The monarch', 0, 0, NULL, NULL),
(90, 'Mary muthoni', 'Auntie', '0725389711', NULL, 'KMFA 568B', 'posts, githurai', 1, 'PBH8REZ440', 'David', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0712667847', '', '', '', 1, 1, 'The Monarch', 0, 0, NULL, NULL),
(91, 'elijahkamau', 'father', '0723617529', NULL, 'KMEH850D', 'MBC 6th street', 1, 'PBG3R2JIWZ', 'KELVIN', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(92, 'Mercy wambui waweru', 'wife', '0700266264', NULL, 'KMED 600Z', 'posts, githurai', 1, 'PBH5RG3IOR', 'Robert', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0708227395', '', '', '', 1, 1, 'The Monarch', 0, 0, NULL, NULL),
(93, 'Pauline Wairimu', 'Wife', '0723168409', NULL, 'KMEM 827C', 'post bank, githurai', 1, 'PBH3RH9FJB', 'Thomas', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0723168409', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(94, 'charles mwangi', 'brother', '0719610772', NULL, 'KMEP 289L', 'githurai', 2018, 'PBH5REDHGN', 'daniel', '50.00', '', 'Partial Payment', NULL, '', 'Bank Account', '', 'equity', 'githurai', '0710179956385', 1, 1, 'monarch', 0, 0, NULL, NULL),
(100, 'Francisca mwendwa', 'wife', '0706150103', NULL, 'kmew629h', 'githurai round about', 20, 'PBH7RJQAB9', 'Robert mugambi', '50.00', '1', 'Partial Payment', NULL, '', 'M-PESA', '0706150094', '', '', '', 1, 1, 'monarch', 0, 0, NULL, NULL),
(108, 'kelvin kiarie', 'brother ', '0768762330', NULL, 'KMER 160H', 'githurai 45', 160, 'PBH4RMN32C', 'Felix waithera ', '50.00', '2', 'Partial Payment', NULL, '', 'M-PESA', '0713758443', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(109, 'grace waithera', 'mother', '0721738544', NULL, 'kmfb727b', 'githurai 45', 727, 'PBH8RN4X1', 'kelvinwaithera', '50.00', '2', 'Partial Payment', NULL, '', 'M-PESA', '0768762330', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(121, 'Benard Kioko', 'Dad', '0710820142', NULL, 'KMEL 578G', 'Githurai 45', 1, 'PBH6RFZ3A6', 'Daniel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0724732994', '', '', '', 0, 1, 'The Monarch', 0, 0, NULL, NULL),
(122, 'Ian kinuthia', 'son', '0768739691', NULL, 'KMEG 361S', 'Githurai', 1, 'PBH6REZXMU', 'Francis', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0728200364', '', '', '', 1, 1, 'The Monarch', 0, 0, NULL, NULL),
(123, 'Nellius wambui', 'wife', '0746792485', NULL, 'KMEV 902Z', 'Githurai', 1, 'PBH7REJJ8Z', 'Gabriel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0718266554', '', '', '', 1, 1, 'The Monarch', 0, 0, NULL, NULL),
(124, 'robert mutua', 'brother', '0726302381', NULL, 'KMDA481J', 'YOEZ', 1, 'PBH7RQ27GJ', 'FESTUS', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0708528134', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(125, 'Jane Wanjira', 'Mother', '0723381163', NULL, 'KMET 247X', 'Githurai 44', 1, 'PBI3SGBV61', 'Peter', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0799172173', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(127, 'Nancy Muthoni', 'mother', '0704922631', NULL, 'KMFJ 781L', 'Rware githurai', 1, 'PBI7SLB2W3', 'Shalom', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0758605923', '', '', '', 0, 1, 'Trident', 0, 0, NULL, NULL),
(129, 'jane Mwangi ', 'wife', '0704223504', NULL, 'KMEN 967T', 'GITHURAI 45', 1, 'PBH1RJY8PN', 'zachary ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0727518580', '', '', '', 0, 1, 'ALLYSON', 0, 0, NULL, NULL),
(130, 'james muiruri', 'brother', '0724360943', NULL, 'KMET 952Q', 'GITHURAI 45', 1, 'PBH7RKOFM3', 'ALEX', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0720671997', '', '', '', 1, 1, 'ALLYSON ', 0, 0, NULL, NULL),
(131, 'everlyne nyambura', 'sister', '0715009105', NULL, 'KMEZ462C', 'GITHURAI 45', 1, 'PBH6RCDOGE', 'MARTIN', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0716363985', '', '', '', 1, 1, 'SHAMAM', 0, 0, NULL, NULL),
(132, 'Alice Wambui', 'Wife', '0703470434', NULL, 'KMFG 833K', 'kahawa west', 1, 'PBI5SKIUQN', 'Simon Gitau', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0748925262', '', '', '', 0, 1, 'Sanlam General', 0, 1, NULL, NULL),
(133, 'Tabitha ruguru', 'wife', '0705583258', NULL, 'KMFJ497E', 'GITHURAI 45', 1, 'PBH7RK39X5', 'SAMUEL', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0782980880', '', '', '', 1, 1, 'SANLAM', 0, 0, NULL, NULL),
(134, 'Margaret Scola', 'Mother', '0723928941', NULL, 'KMFG 084D', 'Mambrose githurai', 1, 'PBH7RMP661', 'Daniel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0769969247', '', '', '', 0, 1, 'Sanlam General', 0, 0, NULL, NULL),
(135, 'francis liruu', 'father', '0706141858', NULL, 'KMFF319P', 'JUJA B ESTATE', 1, 'PBG3Q80T5P', 'richard', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0757318044', '', '', '', 1, 1, 'MONARCH', 0, 0, NULL, NULL),
(136, 'Teresia Mwihaki', 'Wife', '0791245388', NULL, 'KMFK337V', 'Third street', 1, 'PBG4QA5WMO', 'Samuel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0726042215', '', '', '', 1, 1, 'SANLAM', 0, 0, NULL, NULL),
(137, 'Pogba', 'friend', '00000', NULL, 'KMDU137Y', 'Eastleigh', 1, 'PBG3QGXTYF', 'John Nganga', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0700323779', '', '', '', 1, 1, 'N/A', 0, 0, NULL, NULL),
(138, 'Monicah Alex', 'Wife', '0702637458', NULL, 'KMDR588C', 'MJR Kinyanjui', 1, 'PBG3Q8PO3L', 'Alex ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0708885669', '', '', '', 1, 1, 'MONARCH ', 0, 0, NULL, NULL),
(139, 'Margaret Wamaitha', 'Wife', '0799297158', NULL, 'KMFM 575D', 'Thika', 1, 'PBJ1TRJ3MB', 'Antony', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0721117445', '', '', '', 1, 1, 'Sanlam General', 0, 0, NULL, NULL),
(141, 'Josephine Wangui', 'Wife', '0757438024', NULL, 'KMEG 686K', 'Siko,weteithie', 1, 'PBJ7TWTAYN', 'Simon', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0700508917', '', '', '', 1, 1, 'Monarch', 0, 0, NULL, NULL),
(142, 'Pauline Wanjeri', 'Mother', '0708286396', NULL, 'KMFK 822J', 'Weteithie stage', 1, 'PBJDUOD16U', 'Moses', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0111511273', '', '', '', 0, 1, 'Sanlam', 0, 0, NULL, NULL),
(143, 'Margaret Wainaina', 'Wife', '0798589636', NULL, 'KMEN 529N', 'Weteithie stage', 1, 'PBJ7TR2HUR', 'Stanley', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '072470319', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(144, 'Grace Wangari', 'wife', '0705678274', NULL, 'KMDG 842G', 'Weteithie stage', 1, 'PBJ5TQFY4H', 'Benard', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0795189037', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(145, 'Lucy Njeri', 'Wife', '0715117210', NULL, 'KMFC 689M', 'kwa mti,weteithie', 1, 'PBJ9TPHBY3', 'Duncan', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0727053982', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(146, 'Maureen Wambui', 'Wife', '0741901202', NULL, 'KMEC 651N', 'Siko, weteithie', 1, 'PBJ6TNNFQK', 'Brian', '100.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0713932904', '', '', '', 0, 0, '', 0, 0, NULL, NULL),
(147, 'Esther Mugure ', 'Mother', '0710316805', NULL, 'KMEW008X', 'Witeithie', 1, 'PBJ4TUEKXS', 'David ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0718885651', '', '', '', 0, 1, 'monarch ', 0, 0, NULL, NULL),
(148, 'Rachel Ngina', 'Wife', '0722443889', NULL, 'KMFG143W', 'Witeithie Soko', 1, 'PBJ3TXW8X3', 'Daniel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0714036859', '', '', '', 1, 1, 'SANLAM', 0, 0, NULL, NULL),
(149, 'Mbuvi', 'Son', '000000', NULL, 'KMEJ 969F', 'Witeithie Soko', 1, 'PBJ9TW11OH', 'Peter', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0721764247', '', '', '', 1, 0, '', 1, 0, NULL, NULL),
(150, 'Rose Waithera', 'Mother', '0717726995', NULL, 'KMFJ160M', 'Witeithie Soko', 1, 'PBJ6TOWKQA', 'Paul', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0708743626', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(151, 'Photensia Njoki', 'Wife', '0719287566', NULL, 'KMDW276L', 'witeithie stage', 1, 'PBJ1TRG42N', 'John', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0794854684', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(152, 'Margaret Wanjira', 'Wife', '0791660820', NULL, 'KMEA012S', 'GITHURAI STANMART', 1, 'PBI5SSQXE', 'Peter Muturi ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0711118145', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(153, 'Beatrice Muchoki', 'wife', '0791928338', NULL, 'KMFM 413E', 'Mlandizi,juja', 1, 'PBJ7UCPPR3', 'Joseph', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0715772786', '', '', '', 0, 1, 'The monarch', 0, 0, NULL, NULL),
(154, 'Agnes Karanja', 'wife', '0726583283', NULL, 'KMEJ 583Z', 'JKUAT,Gate B', 1, 'PBJ2UEK206', 'Kennedy', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0726307823', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(155, 'Telvin Muhia', 'son', '0707585993', NULL, 'KMCU 708D', 'JKUAT,gate b', 1, 'PBJ1UF9PY3', 'Christopher', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0718186910', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(156, 'Ritah Mbae', 'Wife', '0725732810', NULL, 'KMFA 471B', 'juja,petanns', 1, 'PBJ1UAZ32B', 'Samuel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0714062593', '', '', '', 1, 1, 'The Monarch', 0, 0, NULL, NULL),
(157, 'Linnet Nafula', 'mother', '0708784852', NULL, 'KMEL 275C', 'Petanns,Juja', 1, 'PBJ0UBOTH4', 'Isaac', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0728659937', '', '', '', 1, 1, 'Sanlam General', 0, 0, NULL, NULL),
(158, 'Jane Wanjiru', 'Wife', '0797400172', NULL, 'KMDX062G', 'Gadhima Plaza', 1, 'PBI4SMQX52', 'Fredrick Ngige', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0706430003', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(159, 'Steven Waweru', 'brother', '0720742482', NULL, 'KMFC660E', 'GITHURAI ', 1, 'PBI1SOJM8F', 'Joseph Muchiri', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0721162607', '', '', '', 1, 1, 'SANLAM', 1, 0, NULL, NULL),
(160, 'Stephen Ondiek ', 'father', '0728700918', NULL, 'KMFG259F', 'GITHURAI ', 1, 'PBI750VN8N', 'ABED ONDIEK', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0702401171', '', '', '', 1, 1, 'Sanlam', 1, 0, NULL, NULL),
(161, 'Delvin Wachera', 'Wife', '0717390875', NULL, 'KMEJ801G', 'Rurii', 1, 'PBI9SIDI03', 'DISHON', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0711526364', '', '', '', 0, 0, '', 0, 0, NULL, NULL),
(162, 'francis mwangi', 'friend', '0746806335', NULL, 'KMFE729Z', 'GITHURAI POST BANK', 1, 'PBI3SKNZFH', 'manasseh', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0705466336', '', '', '', 1, 1, 'SANLAM ', 0, 0, NULL, NULL),
(163, 'Felistas Muthoni Maina', 'mother', '0718262642', NULL, 'KMEG374P', 'GITHURAI 45', 1, '32752837', 'JOSEPH ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0716527146', '', '', '', 1, 1, 'G.A INSURANCE', 0, 0, NULL, NULL),
(164, 'Teresia Muthoni', 'Wife ', '0759307337', NULL, 'KMFD641X', 'CANNAN', 1, 'PBH4RPR7P6', 'James', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0759709054', '', '', '', 1, 1, 'KINGDOM', 0, 0, NULL, NULL),
(165, 'Joseph', 'Friend', '00000000', NULL, 'KMEK362W', 'Thika SuperHighway', 59, 'PBI95ITICJ', 'Regan', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0769838254', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(166, 'Maryann', 'Wife ', '0712265815', NULL, 'KMDN428R', 'D.O ROAD', 20, 'PBI9M605', 'gerishon', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0716293479', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(168, 'xxx', 'xxx', '000', NULL, 'KMEQ247Z', 'D.O ROAD', 1, 'PBI3SMFSJV', 'SAMUEL', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0714875958', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(169, 'Wanjiru Mwangi', 'Wife ', '0723213537', NULL, 'Kmdf331m', 'Full Gospel ', 1, 'PBHTRRSQWF', 'George ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0720722597', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(170, 'Ester Wambui', 'mother', '0725727861', NULL, 'KMFB582M', 'Mambrose', 10, 'PBH5RMZ01', 'DENNIS', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0795938649', '', '', '', 1, 1, 'OCCIDENTAL ', 0, 0, NULL, NULL),
(171, 'Jane Wanjiru ', 'Mother', '0727755715', NULL, 'KMFE310V', 'GITHURAI ', 1, 'PBH9RAQTKH', 'Erick Maina', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0790271397', '', '', '', 1, 1, 'MOGO', 1, 0, NULL, NULL),
(172, 'Gatheria Mbugua', 'father', '0726226784', NULL, 'KMDK534A', 'GITHURAI 45 STAGE', 1, 'PBH2RJ743M', 'Kevin', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0759561280', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(173, 'Damaris Muthoni ', 'sister', '0715605550', NULL, 'KMFK126L', 'GITHURAI POST BANK ', 1, 'PBH5RB4H1D', 'Robert ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0701050314', '', '', '', 1, 1, 'SANLAM', 1, 0, NULL, NULL),
(174, 'Franklin Mutuma ', 'brother ', '0710541496', NULL, 'kmer490w', 'kawangware ', 490, 'PBK1V4E6VZ', 'festusgideon', '50.00', '1', 'Partial Payment', NULL, '', 'M-PESA', '0702024160', '', '', '', 0, 0, '', 0, 0, NULL, NULL),
(175, 'Daniel Njenga', 'Father', '07', NULL, 'KMDR 800M', 'GITHURAI 45', 1, 'PBH9RDu0R7', 'Stephen ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0792077630', '', '', '', 0, 1, 'TRIDENT', 0, 0, NULL, NULL),
(176, 'Gibugi Kelvin', 'Friend', '00000', NULL, 'KMFC266N', 'Strawberry Plaza', 3, 'PBG9Q7NAZX', 'DANIEL', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0748188245', '', '', '', 0, 1, 'MONARCH', 0, 0, NULL, NULL),
(177, 'Mbogo', 'Father', '0728727469', NULL, 'KMES430Q', 'FIVE STREET', 1, 'PBG9DEYGB', 'PHILIP', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0701630439', '', '', '', 1, 1, 'MONARCH', 0, 0, NULL, NULL),
(178, 'Monica wamaitha', 'wife ', '0769096528', NULL, 'KMEF', 'GITHURAI 45', 1, 'PBH8RCV0B2', 'DAVID MUGURO', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0718492314', '', '', '', 0, 0, '', 0, 0, NULL, NULL),
(179, 'Grace Muthoni ', 'Mum', '0727935042', NULL, 'KMEU566M', 'Mlango Round About ', 1, 'PBG3Q57ILN', 'John', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0795434141', '', '', '', 1, 1, 'COMPREHENSIVE', 0, 0, NULL, NULL),
(180, 'Rose Muthoni', 'wife', '0791989813', NULL, 'KMEL250Y', 'GITHURAI 45', 1, 'PBH2RLDKW4', 'JULIUS', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0724174932', '', '', '', 0, 0, '', 0, 0, NULL, NULL),
(181, 'Eunice Muhati ', 'wife ', '0748890157', NULL, 'kmdx695s', 'kawangware ', 695, 'PBK7V5B6WZ', 'Daniel Owiti ', '50.00', '1', 'Partial Payment', NULL, '', 'M-PESA', '0726225486', '', '', '', 1, 1, 'monarch ', 0, 0, NULL, NULL),
(182, 'Esther Wambui', 'wife', '0727277218', NULL, 'KMEW396U', 'GITHURAI ROUND ABOUT', 1, 'PBH3RKNR29', 'PETER WAWERU NDIRANGU', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0711387495', '', '', '', 1, 1, 'SANLAM', 0, 0, NULL, NULL),
(183, 'winfred mwikali', 'wife', '0721135258', NULL, 'KMDW016B', '12TH Street Rafiki', 1, 'PBG0QJGC2K', 'Bernard', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0726266929', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(184, 'Abdramani', 'Son', '0000', NULL, 'KMFC723T', 'MLANGO', 1, 'PBGBQ4FIV4', 'OMARI', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0726278761', '', '', '', 1, 1, 'MONARCH', 0, 0, NULL, NULL),
(185, 'Eunice Syombua', 'Wife', '0742062038', NULL, 'KMFF392T', 'Eastleigh ', 1, 'PBG8QIJWT0', 'Stephen mwanzia', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0702673962', '', '', '', 1, 0, '', 1, 0, NULL, NULL),
(186, 'Charlie Ruguru', 'Son', '0712269164', NULL, 'KMEP227G', 'Kirinyaga Road', 1, 'PBF7P6ZTH5', 'George', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0715329604', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(187, 'Nicholas Wambua', 'Brother ', '0743191478', NULL, 'KMFF854M', 'Apex', 1, 'PBI2SMCV9U', 'Joseph', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0710226118', '', '', '', 0, 1, 'SANLAM', 0, 1, NULL, NULL),
(188, 'Rachael Wanjiru', 'wife', '0715808544', NULL, 'KMDN762S', 'Nairobi CBD', 1, 'PBF40UVY9Q', 'Ignatius', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0708747529', '', '', '', 1, 1, 'XPLICO', 0, 0, NULL, NULL),
(201, 'Josphat Omanga', 'Friend', '0757870542', NULL, 'KMFK 906W', 'Friendly five,kawangware', 1, 'PBK7VFDXC3', 'James', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0793754972', '', '', '', 1, 1, 'GA insurance', 0, 0, NULL, NULL),
(202, 'Dolphins Kwamboka', 'Wife', '0715039770', NULL, 'KMET 240W', 'shalom stage, kawangware', 1, 'PBK2VTMY3K', 'Josphat Karanja', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0794913329', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(203, 'Mary Nduta', 'wife', '0790117807', NULL, 'KMDW050T', 'sokoni kawangware', 50, 'PBK8VH5S12', 'petermwiti', '50.00', '1', 'Partial Payment', NULL, '', 'M-PESA', '0716608415', '', '', '', 1, 1, 'Trident', 0, 0, NULL, NULL),
(204, 'Ken Lumati', 'Brother', '0704510874', NULL, 'KMEW 943H', 'Bottom line,kawangware', 1, 'PBK9VBFUQB', 'Sablon', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0758790868', '', '', '', 1, 1, 'The monarch', 0, 0, NULL, NULL),
(205, 'Atnas Chege', 'brother', '0797533891', NULL, 'KMEW 256Z', 'Juja', 1, 'PBJ1TJFGT9', 'Joseph', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0729454411', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(206, 'Jane maina', 'wife', '0717574368', NULL, 'KMFC 860V', 'Juja', 1, 'PBJ5TVT80Z', 'Erick', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0741941811', '', '', '', 1, 1, 'The monarch', 0, 0, NULL, NULL),
(207, 'Mwangi maina', 'friend', '0721595666', NULL, 'KMDN 727X', 'Juja stage', 1, 'PBJ6VRF950', 'Amos', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0700529940', '', '', '', 0, 0, '', 0, 0, NULL, NULL),
(208, 'Juma Festus', 'Friend', '0726735395', NULL, 'KMFE 566A', 'Juja', 1, 'PBJ3TQ20T7', 'Elisha', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0726395735', '', '', '', 1, 1, 'Monarch', 0, 0, NULL, NULL),
(209, 'Margaret Waceke', 'wife', '0728237638', NULL, 'KMCZ 809B', 'Backyard,Juja', 1, 'PBJ5UI02T9', 'John', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0721569756', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(210, 'Stella Onyango', 'wife', '0724569797', NULL, 'KMEH 059R', 'Backyard,juja', 1, 'PBJ3064URV', 'Kelvin', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0741937287', '', '', '', 0, 1, 'Sanlam', 1, 0, NULL, NULL),
(211, 'Erick Nyakundi', 'friend', '0710149496', NULL, 'KMDA 997K', 'Junction, Emmanuel', 1, 'PBKOV274VW', 'Kennedy', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0724170798', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(212, 'Irungu', 'friend', '0710889125', NULL, 'KMEB 616F', '46, Kawangware', 1, 'PBK6V0CLSE', 'Lawrence', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0724137894', '', '', '', 0, 0, '', 0, 0, NULL, NULL),
(213, 'Moses Nyarasi', 'brother', '0702483064', NULL, 'KMEH 155J', 'Kawangware 46', 1, 'PBK4V4Q0JK', 'Elijah', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0795606125', '', '', '', 1, 1, 'SANLAM', 0, 0, NULL, NULL),
(223, 'Faith Okalo', 'Wife', '0722873178', NULL, 'KMEP 971R', 'Kenice stage,kariobangi', 1, 'PBM3XEUCRR', 'Daniel okalo', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0715739206', '', '', '', 1, 1, 'Trident insurance', 0, 0, NULL, NULL),
(224, 'Faith Osano', 'Wife', '0729030056', NULL, 'KMDE334D', 'Tajj mall', 334, 'PBM7XGYYDR', 'Adams wesonga', '50.00', '1', 'Partial Payment', NULL, '', 'Cash', '0725204597', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(225, 'Monica mugure', 'mother', '0716533699', NULL, 'KMFE 837B', 'Waiyaki way', 1, 'PBM4X1NH94', 'Peter mwangi', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0700514821', '', '', '', 0, 1, 'the monarch', 0, 0, NULL, NULL),
(226, 'Stella Amondi', 'wife', '0769397540', NULL, 'KMET 527J', 'Mathare North', 1, 'PBM8XJ97E6', 'Jectone', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0701816564', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(227, 'Alice Wangari', 'Wife', '0790240759', NULL, 'KMFH085W', 'GITHURAI 45', 1, 'PBH1REBTF', 'Kelvin Mwangi', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0746270003', '', '', '', 1, 1, 'GA INSURANCE', 1, 0, NULL, NULL),
(228, 'Eunice Kagwi', 'Friend', '0720233580', NULL, 'KMFC612W', 'Kirinyaga Road ', 1, 'PBH9RINGYL', 'Henry Njuguna', '100.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0728816492', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(229, 'Pauly Mugo', 'Wife', '0706332369', NULL, 'KMEP202G', 'GITHURAI ', 1, 'PBH1RP1XOL', 'Wambu', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0724427198', '', '', '', 1, 1, 'ELGON', 0, 0, NULL, NULL),
(230, 'Faith Kamau', 'Wife', '0719483590', NULL, 'KMER949G', 'GITHURAI ', 1, 'PBH3RFCCFR', 'Joseph', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0743762767', '', '', '', 1, 1, 'MONARCH ', 0, 0, NULL, NULL),
(231, 'Innocent Ongeri', 'cousin', '0728678260', NULL, 'KMFG861X', 'GITHURAI KWA NYANYA', 1, 'PBH5RGT3MD', 'Samwel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0722532679', '', '', '', 1, 1, 'SANLAM GENERAL INSURANCE', 0, 0, NULL, NULL),
(232, 'Harrison Njoroge', 'Brother', '0725582928', NULL, 'KMFE089A', 'Nairobi Matt', 1, 'PBH0RMV4YC', 'Jotham', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0711384640', '', '', '', 1, 1, 'BOXER ', 1, 0, NULL, NULL),
(233, 'Peter Chege', 'father', '0710589786', NULL, 'KMFC565D', 'GITHURAI MARY MOUNT ', 1, 'PBI6SOI16', 'Robert', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0702790286', '', '', '', 1, 1, 'SANLAM GENERAL INSURANCE ', 0, 0, NULL, NULL),
(234, 'susan mercy ', 'mother', '0721932194', NULL, 'KMFG957N', 'GITHURAI 45', 1, 'PBH0RF4OHC', 'Eliud Mwangi', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0708659255', '', '', '', 0, 1, 'NISHATI', 1, 0, NULL, NULL),
(235, 'Winnie Awuor', 'Spouse', '0711104660', NULL, 'KMEP019U', 'NAIROBI ', 1, 'PBG5QZGYMP', 'Paul', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0720856493', '', '', '', 1, 1, 'MONARCH', 0, 0, NULL, NULL),
(236, 'Regina Wanjiku', 'Wife', '0714738985', NULL, 'KMEQ623Z', 'MUTHURWA', 1, 'PBF5P3LDXZ', 'CHARLES ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0746196415', '', '', '', 1, 1, 'MONARCH', 0, 0, NULL, NULL),
(237, 'Kenneth Gathara ', 'cousin', '0707818011', NULL, 'KMEH884R', 'GPO', 1, 'PBF4PIFPPQ', 'MWANGI STEVE', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0711896245', '', '', '', 1, 1, 'XPLICO INSURANCE', 0, 0, NULL, NULL),
(238, 'Susan Muthoni ', 'Mother', '0723671890', NULL, 'KMEY780U', 'GITHURAI 44', 1, 'PBH0RENPLY', 'Henry Kanyi', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0704118273', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(239, 'Salome', 'Ngendo', '0726136876', NULL, 'KMEX322W', 'GITHURAI ', 1, 'PBH2RK5IUM', 'Antony', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0729872608', '', '', '', 1, 1, 'RWAMBE', 0, 0, NULL, NULL),
(240, 'Carolyne Kinyua ', 'Spouse ', '0759273365', NULL, 'KMEL523L', 'Equity 12th Street', 1, 'PBG4QHGCRG', 'Isaac Mutuku', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0796880136', '', '', '', 0, 1, 'MONARCH ', 0, 1, NULL, NULL),
(241, 'Rosered Waruguru', 'Mother', '0797368404', NULL, 'KMFL 576B', 'Soweto', 1, 'PBM2XL11K6', 'Harrison', '5.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0797675168', '', '', '', 1, 1, 'Trident', 0, 0, NULL, NULL),
(242, 'Jennifer Kavenyi', 'wife', '0726336195', NULL, 'KMEW 063X', 'Buruburu', 1, 'PBMOXKSJ3C', 'Isaac', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0715655564', '', '', '', 1, 1, 'Trident', 0, 0, NULL, NULL),
(243, 'Judy orina', 'wife', '0728278319', NULL, 'KMEK767W', 'tajj mall', 767, 'PBM2XQM8Q2', 'dennis shake', '50.00', '1', 'Partial Payment', NULL, '', 'M-PESA', '0726264558', '', '', '', 1, 1, 'Occidental', 0, 0, NULL, NULL),
(244, 'aisha', 'wife', '0748168125', NULL, 'KMFF 228A', 'tajj mall', 228, 'PBM4XRENRK', 'Ibrahim mwangala', '50.00', '1', 'Partial Payment', NULL, '', 'M-PESA', '0723894142', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(245, 'Jedidah morah ombati', 'sister', '0702616573', NULL, 'KMFJ555Z', 'tajj mall', 555, 'PBM1XU8K91', 'JEREMIAH OMBATI', '50.00', '1', 'Partial Payment', NULL, '', 'M-PESA', '0707306714', '', '', '', 1, 1, 'MUUGO', 1, 0, NULL, NULL),
(246, 'Deric mbuki', 'son', '0724381065', NULL, 'kmds 545r', 'Tajmall', 545, 'pbm5xu5cgj', 'mbuki mwengi', '50.00', '1', 'Partial Payment', NULL, '', 'M-PESA', '0724381065', '', '', '', 1, 1, 'monarch', 0, 0, NULL, NULL),
(247, 'Fred Okumu', 'Brother', '0710204609', NULL, 'KMEY 507V', 'Ngong rd', 1, 'PBN9YCIVYF', 'Erick Okumu', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0728666962', '', '', '', 1, 1, 'Xplico', 0, 0, NULL, NULL),
(248, 'Dennis Wesonga', 'Brother', '0716314831', NULL, 'KMFE 594E', 'Kawangware', 1, 'PBN8YCNJ82', 'Wesonga', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0703100538', '', '', '', 1, 1, 'Sanlam General', 0, 0, NULL, NULL),
(249, 'Franklin Manyuraga', 'Son', '0716030652', NULL, 'KMDS 973V', 'Hamsa', 1, 'PBN9YCNIMZ', 'James', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0721597216', '', '', '', 1, 1, 'Xplico insurance', 0, 0, NULL, NULL),
(250, 'James Manyuraga', 'Father', '0721597216', NULL, 'KMFF 018B', 'Kayole', 1, 'PBN4YCHZII', 'Paul Onyango', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0728666786', '', '', '', 1, 1, 'Xplico', 0, 0, NULL, NULL),
(251, 'Roselyn Wairimu ', 'wife', '0727104407', NULL, 'KMDF253K', 'Nairobi ', 1, 'PBM0XOJXU6', 'Kelvin', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0712675008', '', '', '', 1, 1, 'XPLICO', 0, 0, NULL, NULL),
(252, 'Dennis Ondeyo ', 'Brother', '0715537867', NULL, 'KMFB074x', 'NAIROBI', 1, 'PBM8XO0QZC', 'Jacksom', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0746649388', '', '', '', 1, 1, 'REIGN COURIER', 0, 0, NULL, NULL),
(253, 'Charles Marwa', 'Brother', '0748043402', NULL, 'KMFD684N', 'NAIROBI ', 1, 'PBM4XR7591', 'Samuel', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0790644284', '', '', '', 1, 1, 'SANLAM GENERAL', 0, 0, NULL, NULL),
(254, 'Rose Bella', 'friend', '0702751883', NULL, 'KMFL127Q', 'Langata', 1, 'PBH0RNDJ9E', 'MATIAS KIPROTICH ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0711549072', '', '', '', 1, 0, '', 1, 0, NULL, NULL),
(255, 'Jane Mumbi', 'friend', '0748191203', NULL, 'KMFG954W', 'Langata ', 1, 'PBJ2TVP51G', 'JOHN MWANZWII', '100.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0712367970', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(256, 'Kennedy', 'friend', '0705947519', NULL, 'KMEF216W', 'LANGATA ', 1, 'PBH8RHU7GQ', 'SULEIMAN OSIKUKU ', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0702567896', '', '', '', 1, 1, 'RWABE', 0, 0, NULL, NULL),
(257, 'gob river', 'friend', '0798490201', NULL, 'KMFF764L', 'Kilimani/Mbagathi', 1, 'PBH0RFQKBQ', 'Christopher Ochieng', '100.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0707435585', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(258, 'Benson simiyu', 'son', '0794991114', NULL, 'KMDS 938V', 'Kawangware', 1, 'PBN4YCRAZ6', 'wekesa', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0721275564', '', '', '', 1, 1, 'Xplico', 0, 0, NULL, NULL),
(259, 'Clare Muhenja', 'sister', '0724445423', NULL, 'KMEQ 786T', 'Ngong rd', 1, 'PBN9YCNCOJ', 'Joseph Kisundi', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0793072467', '', '', '', 1, 1, 'Monarch', 0, 0, NULL, NULL),
(260, 'Maureen Nekoye', 'wife', '0768732564', NULL, 'KMTE 912V', 'Lavington,ngong rd', 1, 'PBN6YD19XG', 'Mulongo', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0705146541', '', '', '', 1, 1, 'Xplico', 0, 0, NULL, NULL),
(261, 'Frank Asila', 'brother', '0705474163', NULL, 'KMFF 168A', 'Ngong Rd', 1, 'PBN7YCTCZZ', 'Michael', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0710980973', '', '', '', 1, 1, 'Sanlam General', 0, 0, NULL, NULL),
(262, 'Joshua kwanga', 'Father', '0713768455', NULL, 'KMDV 197H', 'Dagoreti corner', 1, 'PBN6YCTMR2', 'Kwanga', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0723265813', '', '', '', 1, 1, 'Xplico', 0, 0, NULL, NULL),
(263, 'Maryanne Kinywa', 'wife', '0743899951', NULL, 'KMED 500L', 'Valley Arcade', 1, 'PBK7VE6FCJ', 'Peter', '100.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0718216401', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(264, 'Margaret wafula', 'mother', '0703868254', NULL, 'KMER 289W', 'Lavington', 1, 'PBK2V3T4EG', 'Isaac', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0748988410', '', '', '', 1, 1, 'The monarch', 0, 0, NULL, NULL),
(266, 'Lonah Okiri ', 'mother', '0723237152', NULL, 'KMFC 906A', 'Ngong rd', 1, 'PBN8YCX6NK', 'Ojule', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0798718561', '', '', '', 1, 1, 'The Monarch', 0, 0, NULL, NULL),
(267, 'Franco Wesonga', 'Friend', '0110862878', NULL, 'KMEQ 645Q', 'Kilimani', 1, 'PBN4YCK91Q', 'Felix Milimu', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0794789542', '', '', '', 1, 1, 'Xplico', 0, 0, NULL, NULL),
(268, 'Chide Ameria', 'Daughter', '0721649479', NULL, 'KMFF 602E', 'Kasarani', 1, 'PBN7YDT87V', 'Alfred', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0728788313', '', '', '', 0, 1, 'Xplico', 0, 0, NULL, NULL),
(269, 'Susan Katanu', 'wife', '0741991903', NULL, 'KMEL 275Y', 'Kilimani,kileleshwa, Lavington', 1, 'PBKOV8JTSA/PBK2V8EYEQ', 'Peter', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0716010548', '', '', '', 1, 0, '', 0, 0, NULL, NULL),
(270, 'Vinny Mutali', 'Brother', '0712136740', NULL, 'KMET 268J', 'Satelitte', 1, 'PBN7YEV9LD', 'Lilian', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0728809130', '', '', '', 1, 1, 'Xplico', 0, 0, NULL, NULL),
(271, 'Risper Onyango', 'Mother', '0799123342', NULL, 'KMEN 377E', 'Umojs', 1, 'PBN9YBT9BN', 'John', '250.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0700359243', '', '', '', 1, 1, 'Xplico', 0, 0, NULL, NULL),
(272, 'Micheal Gabe', 'son', '0705146660', NULL, 'KMEE 051D', 'Lavington', 1, 'PBN2YDYCKE', 'Vinny', '50.00', '', 'Partial Payment', NULL, '', 'M-PESA', '0712136740', '', '', '', 1, 1, 'XPLICO', 0, 0, NULL, NULL);

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

--
-- Table structure for table `collection_centers`
--

CREATE TABLE `collection_centers` (
  `id` int(10) NOT NULL,
  `locationLat` decimal(9,6) NOT NULL,
  `locationLong` decimal(9,6) NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `staff_inchargeID` int(10) NOT NULL,
  `collectionCenterCategoryID` int(5) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collection_centers`
--

INSERT INTO `collection_centers` (`id`, `locationLat`, `locationLong`, `description`, `dateCreated`, `staff_inchargeID`, `collectionCenterCategoryID`) VALUES
(1, '-1.067906', '37.050593', 'Witeithie Collection Center.', '2021-01-06 12:27:21', 1, 1),
(2, '-1.105904', '37.017282', 'Juja Collection Centre', '2021-01-06 10:33:30', 2, 1),
(3, '-1.103384', '37.019290', 'Fgg cjvfAt: Kenya, Juja, , Kenya', '2021-02-15 07:57:02', 35, 0),
(4, '-1.028834', '37.066202', 'amkaAt: Kenya, Thika', '2021-02-16 20:52:18', 78, 0),
(5, '-1.036483', '37.074379', 'kimexAt: Commercial Street, Thika, , Kenya', '2021-02-18 15:30:50', 128, 2),
(6, '-0.299476', '36.087341', 'WanjiaAt: Unnamed Road, Nakuru, , Kenya', '2021-02-21 13:17:46', 216, 3),
(7, '-0.718806', '36.430851', 'Dandy At: Unnamed Road, Naivasha, , Kenya', '2021-02-21 17:23:47', 217, 2),
(8, '0.962334', '34.975926', 'twinzAt: Unnamed Road, , , KenyaAt: Unnamed Road, , , Kenya', '2021-02-21 17:37:57', 218, 2),
(9, '0.527559', '35.265929', 'WashaAt: Kitondo Street, Eldoret, , Kenya', '2021-02-21 17:41:12', 219, 2),
(10, '-3.391141', '38.573154', 'WadauAt: Unnamed Road, , , Kenya', '2021-02-21 17:45:56', 220, 2),
(11, '-4.005433', '39.713136', 'WaseliAt: Unnamed Road, Mombasa, , Kenya', '2021-02-21 17:54:42', 221, 3),
(12, '-1.147764', '36.960340', 'thirtyAt: C65, Ruiru, , Kenya', '2021-02-21 19:26:32', 222, 0);

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

--
-- Table structure for table `collection_center_categories`
--

CREATE TABLE `collection_center_categories` (
  `id` int(5) NOT NULL,
  `collectionCenterCategoryName` varchar(100) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goodssizecategory`
--

CREATE TABLE `goodssizecategory` (
  `id` int(5) NOT NULL,
  `goodsSizeCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `goodsSizeCategoryDescription` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `goodssizecategory`
--

INSERT INTO `goodssizecategory` (`id`, `goodsSizeCategoryName`, `goodsSizeCategoryDescription`) VALUES
(1, 'Small To Medium', 'Small To Medium category(Approx. 1M by 1M by 0.25M)'),
(2, 'Large category', 'Large category(Approx. 1M by 1M by 1M)'),
(3, 'Bulky category', 'Bulky category(In excess of 1M by 1M by 1M)');

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

--
-- Table structure for table `goods_type_categories`
--

CREATE TABLE `goods_type_categories` (
  `id` int(5) NOT NULL,
  `goodsTypeCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `goodsTypeCategoryDescription` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `goods_type_categories`
--

INSERT INTO `goods_type_categories` (`id`, `goodsTypeCategoryName`, `goodsTypeCategoryDescription`) VALUES
(1, 'Parcel', 'Parcel'),
(2, 'General', 'General'),
(3, 'Electronics', 'Electronics'),
(4, 'Valuables', 'Valuables');

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

--
-- Table structure for table `order_a`
--

CREATE TABLE `order_a` (
  `id` int(20) NOT NULL,
  `openForNotification` int(2) DEFAULT NULL,
  `lockedByStaffID` int(10) DEFAULT NULL,
  `userId` int(15) NOT NULL,
  `locationFromLat` decimal(9,6) NOT NULL,
  `locationFromLong` decimal(9,6) NOT NULL,
  `locationFrom` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `locationTo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `distanceCovered` double(7,2) NOT NULL,
  `recepientName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `goodsDescription` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `recipientPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `recipientLocationLat` decimal(9,6) NOT NULL,
  `recipientLocationLong` decimal(9,6) NOT NULL,
  `pickUpCentreLocationLat` decimal(9,6) NOT NULL,
  `pickUpCentreLocationLong` decimal(9,6) NOT NULL,
  `deliveryCentreLocationLat` decimal(9,6) NOT NULL,
  `deliveryCentreLocationLong` decimal(9,6) NOT NULL,
  `locationFromToPickUpCentreStaffID` int(15) NOT NULL,
  `deliveryCentreToLocationToStaffID` int(15) NOT NULL,
  `locationFromToPickUpCentreCost` decimal(15,2) NOT NULL,
  `deliveryCentreToLocationToCost` decimal(15,2) NOT NULL,
  `statusAId` int(5) NOT NULL,
  `pickUpCentreAgentStaffID` int(15) NOT NULL,
  `deliveryCentreAgentStaffID` int(15) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `payerCategoryID` int(5) NOT NULL,
  `goodsSizeCategoryID` int(5) NOT NULL,
  `goodsTypeCategoryID` int(5) NOT NULL,
  `deliveryCost` decimal(12,2) NOT NULL,
  `recipientEmail` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `trackingOption` int(2) NOT NULL,
  `serialNo` int(15) NOT NULL,
  `bagNo` int(15) NOT NULL,
  `orderPath` text,
  `centerIdToActOnOrder` int(10) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_a`
--

INSERT INTO `order_a` (`id`, `openForNotification`, `lockedByStaffID`, `userId`, `locationFromLat`, `locationFromLong`, `locationFrom`, `locationTo`, `distanceCovered`, `recepientName`, `goodsDescription`, `recipientPhone`, `recipientLocationLat`, `recipientLocationLong`, `pickUpCentreLocationLat`, `pickUpCentreLocationLong`, `deliveryCentreLocationLat`, `deliveryCentreLocationLong`, `locationFromToPickUpCentreStaffID`, `deliveryCentreToLocationToStaffID`, `locationFromToPickUpCentreCost`, `deliveryCentreToLocationToCost`, `statusAId`, `pickUpCentreAgentStaffID`, `deliveryCentreAgentStaffID`, `dateCreated`, `payerCategoryID`, `goodsSizeCategoryID`, `goodsTypeCategoryID`, `deliveryCost`, `recipientEmail`, `trackingOption`, `serialNo`, `bagNo`, `orderPath`, `centerIdToActOnOrder`) VALUES
(1, 1, 3, 1, '-1.269946', '36.807407', 'Westlands, Nairobi, , Kenya', 'Thika', 44.90, 'Samwel Masai', 'Books', '0785423586', '-1.038757', '37.083375', '-1.105904', '37.017282', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 2, 2, 1, '2021-02-12 00:00:00', 2, 2, 2, '10.00', 'eric.mwash91@gmail.com', 0, 0, 0, NULL, NULL),
(2, 1, 3, 1, '-1.269969', '36.807362', 'Westlands, Nairobi, , Kenya', 'Thika', 44.90, 'Steve Wambu', 'Bag of sugar', '0756635239', '-1.038757', '37.083375', '-1.105904', '37.017282', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 6, 2, 1, '2021-02-12 00:00:00', 1, 2, 2, '10.00', 'Stevengangawambu@gmail.com', 0, 25368, 25453, NULL, NULL),
(3, 1, 0, 1, '-1.127203', '37.012728', 'Unnamed Road, Juja, , Kenya', 'Thika', 17.75, 'Rygghhh', 'Fgdfgbb', '0785412365', '-1.038757', '37.083375', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 1, 1, 1, '2021-02-15 00:00:00', 2, 1, 3, '5.00', 'nelsonnjino@gmail.com', 0, 0, 0, NULL, NULL),
(4, 1, 0, 1, '-1.127203', '37.012728', 'Unnamed Road, Juja, , Kenya', 'Thika', 17.75, 'Dfghjjyggb', 'Gddfgjklccbn', '0785421365', '-1.038757', '37.083375', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 1, 1, 1, '2021-02-15 00:00:00', 2, 1, 2, '5.00', 'nelsonnjino@gmail.com', 0, 0, 0, NULL, NULL),
(5, 1, 0, 1, '-1.121382', '37.012792', 'Unnamed Road, Juja, , Kenya', 'Thika', 17.10, 'Dfghjjyggb', 'Gddfgjklccbn', '0785421365', '-1.038757', '37.083375', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 1, 1, 1, '2021-02-15 00:00:00', 2, 1, 2, '5.00', 'nelsonnjino@gmail.com', 0, 0, 0, NULL, NULL),
(6, 1, 0, 1, '-1.121319', '37.012976', 'Unnamed Road, Juja, , Kenya', 'Meru', 101.46, 'Dfghjjyggb', 'Gddfgjklccbn', '0785421365', '-0.538838', '37.459641', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 1, 1, 1, '2021-02-15 00:00:00', 2, 1, 2, '5.00', 'nelsonnjino@gmail.com', 0, 0, 0, NULL, NULL),
(7, 1, 0, 1, '-1.155864', '36.960603', 'Thika Road, Ruiru, , Kenya', 'thika', 24.33, 'bonnie', 'bags', '0721177035', '-1.038757', '37.083375', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 1, 1, 1, '2021-02-16 00:00:00', 2, 1, 2, '5.00', 'bonfacemutush@yahoo.com', 0, 0, 0, NULL, NULL),
(8, 1, 0, 1, '-1.269856', '36.807475', 'Nairobi, Nairobi, , Kenya', 'Thika', 44.91, 'Rcvfggvh', 'Ttyvfdgnj', '0752365471', '-1.038757', '37.083375', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 1, 1, 1, '2021-02-17 00:00:00', 2, 2, 2, '5.00', 'vfghh@fgfg.nbv', 0, 0, 0, NULL, NULL),
(9, 1, 0, 1, '-1.269990', '36.807351', 'Westlands, Nairobi, , Kenya', 'Thika', 44.90, 'Rcvfggvh', 'Ttyvfdgnj', '0752365471', '-1.038757', '37.083375', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 1, 1, 1, '2021-02-17 00:00:00', 2, 2, 2, '5.00', 'vfghh@fgfg.nbv', 0, 0, 0, NULL, NULL),
(10, 1, 167, 1, '-1.274445', '36.815238', 'Ngara West, Nairobi, , Kenya', 'Thika', 44.06, 'Rcvfggvh', 'Ttyvfdgnj', '0752365471', '-1.038757', '37.083375', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 2, 1, 1, '2021-02-17 00:00:00', 2, 2, 2, '5.00', 'vfghh@fgfg.nbv', 0, 0, 0, NULL, NULL),
(11, 1, 0, 1, '-1.318637', '36.854377', 'Road A, Nairobi, , Kenya', 'Thika', 52.09, 'Rcvfggvh', 'Ttyvfdgnj', '0752365471', '-1.038757', '37.083375', '-1.067906', '37.050593', '-1.067906', '37.050593', 0, 0, '0.00', '0.00', 1, 1, 1, '2021-02-17 00:00:00', 2, 2, 2, '5.00', 'vfghh@fgfg.nbv', 0, 0, 0, NULL, NULL);

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

--
-- Table structure for table `order_status_a`
--

CREATE TABLE `order_status_a` (
  `id` int(10) NOT NULL,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `order_status_a`
--

INSERT INTO `order_status_a` (`id`, `statusName`, `description`) VALUES
(1, 'Submitted Request.', 'Customer submitted request.'),
(2, 'Boda Agent arrived at customer location.', 'Boda Agent arrived at customer location.'),
(3, 'Customer dispatched goods to Boda agent.', 'Customer dispatched goods to Boda agent.'),
(4, 'Boda agent accepts dispatched goods from customer', 'Boda agent accepts dispatched goods from customer'),
(5, 'Boda agent arrived at Pick Up collection center.', 'Boda agent arrived at Pick Up collection center.'),
(6, 'Boda Agent dispatched goods to Pick Up  Collection Center agent.', 'Senior Supa Boda agent arrives at Pick Up Collection center.'),
(7, 'Pick Up Collection center agent accepts dispatched goods from Boda agent.', 'Pick Up Collection center agent accepts dispatched goods from Boda agent.'),
(8, 'Senior Supa Boda agent arrives at Pick Up Collection center.', 'Pick Up Collection center agent dispatched goods to Supa Boda agent.'),
(9, 'Supa Boda agent arrives at Pick Up Collection center.', 'Supa Boda agent arrives at Pick Up Collection center.'),
(10, 'Boda agent arrived at Pick Up Collection center.', 'Boda agent arrived at Pick Up Collection center.'),
(11, '\r\nPick Up Collection Center Agent dispatched goods to Senior Supa Boda', 'Pick Up Collection Center Agent dispatched goods to Senior Supa Boda'),
(12, '\r\nPick Up Collection Center Agent dispatched goods to Supa Boda', '\r\nPick Up Collection Center Agent dispatched goods to Supa Boda'),
(13, '\r\nPick Up Collection Center Agent dispatched goods to Boda Agent', '\r\nPick Up Collection Center Agent dispatched goods to Boda Agent'),
(14, 'Senior Supa Boda agent accepted goods from Pick Up Collection Center', 'Senior Supa Boda agent accepted goods from Pick Up Collection Center'),
(15, 'Supa Boda agent accepted goods from Pick Up Collection Center', 'Supa Boda agent accepted goods from Pick Up Collection Center'),
(16, 'Boda agent accepted goods from Pick Up Collection Center', 'Boda agent accepted goods from Pick Up Collection Center'),
(17, 'Senior Supa Boda agent arrived at Major Collection Center.', 'Senior Supa Boda agent arrived at Major Collection Center.'),
(18, 'Supa Boda agent arrived at Main Collection Center.', 'Supa Boda agent arrived at Main Collection Center.'),
(19, 'Boda agent arrived at Normal Collection Center.', 'Boda agent arrived at Normal Collection Center.'),
(20, 'Senior Supa Boda agent Dispatched goods to Major Collection Center agent.', 'Senior Supa Boda agent Dispatched goods to Major Collection Center agent.'),
(21, 'Supa Boda agent Dispatched goods to Main Collection Center agent.', 'Supa Boda agent Dispatched goods to Main Collection Center agent.'),
(22, 'Normal Boda agent Dispatched goods to Normal Collection Center agent.', 'Normal Boda agent Dispatched goods to Normal Collection Center agent.'),
(23, 'Major Collection  Center agent accepts goods from Senior,Supa or normal Boda agent', 'Major Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),
(24, 'Main Collection  Center agent accepts goods from Senior,Supa or normal Boda agent', 'Main Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),
(25, 'Normal Collection  Center agent accepts goods from Senior,Supa or normal Boda agent', 'Normal Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),
(26, 'Delivery  Center accepted Goods from Senior,Supa or normal Boda agent.', 'Delivery  Center accepted Goods from Senior,Supa or normal Boda agent.'),
(27, 'Senior,Supa or normal Boda agent arrived at Delivery Collection Center.', 'Senior,Supa or normal Boda agent arrived at Delivery Collection Center.'),
(28, 'Delivery Center Dispatched goods to Senior,Supa or normal Boda agent', 'Delivery Center Dispatched goods to Senior,Supa or normal Boda agent'),
(29, 'Senior,Supa or normal Boda agent accepted goods from Delivery Center', 'Senior,Supa or normal Boda agent accepted goods from Delivery Center'),
(30, 'Senior,Supa or normal Boda agent arrived at recipient location.', 'Senior,Supa or normal Boda agent arrived at recipient location.'),
(31, 'Senior,Supa or normal Boda agent Dispatched to recipient.', 'Senior,Supa or normal Boda agent Dispatched to recipient.'),
(32, 'recipient acepted goods from Senior,Supa or normal Boda agent', 'recipient acepted goods from Senior,Supa or normal Boda agent');

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

--
-- Table structure for table `order_status_b`
--

CREATE TABLE `order_status_b` (
  `int` int(10) NOT NULL,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `order_status_c`
--

CREATE TABLE `order_status_c` (
  `id` int(10) NOT NULL,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `order_status_d`
--

CREATE TABLE `order_status_d` (
  `id` int(10) NOT NULL,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `payer_categories`
--

CREATE TABLE `payer_categories` (
  `id` int(5) NOT NULL,
  `payerCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `payerCategoryDescription` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payer_categories`
--

INSERT INTO `payer_categories` (`id`, `payerCategoryName`, `payerCategoryDescription`) VALUES
(1, 'Customer Payer', 'Customer Payer'),
(2, 'Recipient Payer', 'Recipient Payer');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(5) NOT NULL,
  `settingName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `settingDescription` text COLLATE utf8_unicode_ci NOT NULL,
  `settingCost` decimal(15,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `settingName`, `settingDescription`, `settingCost`) VALUES
(2, 'Cost Per Kilometer', 'Cost Per Kilometer', '5.00');

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

--
-- Table structure for table `shop_agents_details`
--

CREATE TABLE `shop_agents_details` (
  `staffID` int(5) NOT NULL,
  `nextOfKinFullName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nextOfKinRelationship` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nextOfKinPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `alias` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `businessName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `businessType` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `businessRegNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `businessOperationPeriodMonths` int(5) DEFAULT NULL,
  `bsNoOfDailyCustomers` int(5) DEFAULT NULL,
  `bsMonthlyRent` decimal(15,2) DEFAULT NULL,
  `bsNoOfEmployees` int(5) DEFAULT NULL,
  `regFeeMpesaRefNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeeMpesaAccNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeeMpesaAmt` decimal(12,2) DEFAULT NULL,
  `regFeeMpesaReceiptNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeePaymentApproach` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `regFeeLaterPaymentDate` datetime DEFAULT NULL,
  `regFeeLaterPaymentReason` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionPaymentOption` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionPaymentBankOptionBankName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `commissionPaymentBankOptionBankBranch` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `commissionPaymentBankOptionBankAccountNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `commissionMpesaNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shop_agents_details`
--

INSERT INTO `shop_agents_details` (`staffID`, `nextOfKinFullName`, `nextOfKinRelationship`, `nextOfKinPhone`, `alias`, `businessName`, `businessType`, `businessRegNo`, `businessOperationPeriodMonths`, `bsNoOfDailyCustomers`, `bsMonthlyRent`, `bsNoOfEmployees`, `regFeeMpesaRefNo`, `regFeeMpesaAccNo`, `regFeeMpesaAmt`, `regFeeMpesaReceiptNo`, `regFeePaymentApproach`, `regFeeLaterPaymentDate`, `regFeeLaterPaymentReason`, `commissionPaymentOption`, `commissionPaymentBankOptionBankName`, `commissionPaymentBankOptionBankBranch`, `commissionPaymentBankOptionBankAccountNo`, `commissionMpesaNo`, `dateCreated`) VALUES
(35, 'Ggghvf', 'Ggghvc', '07854213952', 'Gggn', 'Fgg cjvf', 'Fgghb', 'Dfvcgbbv', 24, 24, '24000.00', 24, 'TYURRYUI', 'Gfggbb', '100.00', '45872', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '07854236521', '2021-02-15 07:57:02'),
(78, 'Victoria Gathoni ', 'friend', '0724586869', 'kira', 'amka', 'Shop', 'w9000hyvb', 24, 50, '5000.00', 25000, 'pbf34j678', 'sheila', '50.00', '253698', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '0714714319', '2021-02-16 20:52:18'),
(128, 'Author Wadaka', 'Husband', '0746532243', 'Abi', 'kimex', 'Shop ', '0001', 24, 50, '15000.00', 1, 'pbh3rcv7u4', 'aubrey', '500.00', '888', 'One Off Payment- Ksh 500.', NULL, '', 'M-PESA', '', '', '', '0714594933', '2021-02-18 15:30:50'),
(216, 'Anna', 'sister', '0752356214', 'Alvo', 'Wanjia', 'shop', '005', 21, 20, '10000.00', 1, 'pbj1hrthyu', 'Alvin', '500.00', '333', 'One Off Payment- Ksh 500.', NULL, '', 'M-PESA', '', '', '', '0745123698', '2021-02-21 13:17:46'),
(217, 'saga ', 'friend', '085236412', 'Sandy', 'Dandy ', 'shop ', '009', 36, 50, '20000.00', 1, 'phujiko3457', 'saga', '50.00', '222', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '0745123698', '2021-02-21 17:23:47'),
(218, 'swings', 'sister', '0796852314', 'sis', 'twinz', 'clothes', '889', 24, 30, '5000.00', 1, 'tuyhsn36901', 'sis', '100.00', '663', 'Partial Payment', NULL, 'lack of funds ', 'M-PESA', '', '', '', '0754236159', '2021-02-21 17:37:57'),
(219, 'June', 'Wife', '0769365214', 'Sam', 'Washa', 'welding', '222', 23, 40, '10000.00', 2, 'gaub63017', 'Wesley', '100.00', '223', 'Partial Payment', NULL, '', 'M-PESA', '', '', '', '0789562314', '2021-02-21 17:41:12'),
(220, 'Esther ', 'friend ', '0740404542', 'Moha', 'Wadau', 'Grocery ', '667', 12, 20, '2500.00', 1, 'tde57733du8', 'Ali', '500.00', '33', 'One Off Payment- Ksh 500.', NULL, '', 'M-PESA', '', '', '', '0722558863', '2021-02-21 17:45:56'),
(221, 'Sally', 'Wife', '0745458456', 'Luke', 'Waseli', 'Shop', '889', 30, 50, '10000.00', 366, 'agye84971j', 'Luke ', '500.00', '369', 'One Off Payment- Ksh 500.', NULL, '', 'M-PESA', '', '', '', '0752364125', '2021-02-21 17:54:42'),
(222, 'Dan', 'husband ', '0796365487', 'Sue', 'thirty', 'retail', '557', 23, 50, '25000.00', 2, 'ry5wevutrv', 'Sue ', '500.00', '222', 'One Off Payment- Ksh 500.', NULL, '', 'M-PESA', '', '', '', '0798653214', '2021-02-21 19:26:32');

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

--
-- Table structure for table `staffcategories`
--

CREATE TABLE `staffcategories` (
  `id` int(5) NOT NULL,
  `staffCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `staffcategories`
--

INSERT INTO `staffcategories` (`id`, `staffCategoryName`, `description`, `dateCreated`) VALUES
(1, 'Collection Center Staff.', 'This Staff Category consists of All Staff attached to a collection center.', '2021-01-06 10:38:33'),
(2, 'Boda boda Category.', 'This Staff Category consists of Collection And Delivery Agents.', '2021-01-06 10:40:33'),
(3, 'Super Boda Agent Staff.', 'Super Boda Agent Staff.', '2021-01-10 03:32:39'),
(4, 'Admin staff.', 'Admin staff.', '2021-01-11 02:27:27'),
(5, 'Senior Super Boda Agent Staff.', 'Senior Super Boda Agent Staff.', '2020-12-24 14:24:32'),
(6, 'Main Collection Center Staff.', 'Main Collection Center Staff.', '2021-01-05 10:33:33');

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

--
-- Table structure for table `transaction_type`
--

CREATE TABLE `transaction_type` (
  `id` int(2) NOT NULL,
  `txTypeName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transaction_type`
--

INSERT INTO `transaction_type` (`id`, `txTypeName`, `description`) VALUES
(1, 'Send Goods/Items To Someone.', 'Sending Goods/Items To Someone. As the initiator of this request, you will pay for all the charges involved.'),
(2, 'Request For Goods/Items From Someone.', 'Requesting For Goods/Items From Someone.As the initiator of this request, you will pay for all the charges involved.'),
(3, 'Pick Up Goods/Items ', 'Pick Up Goods/Items'),
(4, 'Buy Goods/Items', 'Buy Goods/Items');

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

--
-- Table structure for table `usercategories`
--

CREATE TABLE `usercategories` (
  `id` int(5) NOT NULL,
  `userCategoryName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `usercategories`
--

INSERT INTO `usercategories` (`id`, `userCategoryName`, `description`, `dateCreated`) VALUES
(1, 'Subscribed Users.', 'Subscribed Users.', '2021-01-11 03:33:35'),
(2, 'Unsubscribed Users.', 'Unsubscribed Users.', '2021-01-11 03:39:32');

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

--
-- Table structure for table `userlocations`
--

CREATE TABLE `userlocations` (
  `id` int(10) NOT NULL,
  `userId` int(20) NOT NULL,
  `locationLat` decimal(9,6) NOT NULL,
  `locationLong` decimal(9,6) NOT NULL,
  `description` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `collection_centers`
--
ALTER TABLE `collection_centers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `collection_center_categories`
--
ALTER TABLE `collection_center_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `goodssizecategory`
--
ALTER TABLE `goodssizecategory`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `goods_type_categories`
--
ALTER TABLE `goods_type_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_a`
--
ALTER TABLE `order_a`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_status_a`
--
ALTER TABLE `order_status_a`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_status_b`
--
ALTER TABLE `order_status_b`
  ADD PRIMARY KEY (`int`);

--
-- Indexes for table `order_status_c`
--
ALTER TABLE `order_status_c`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_status_d`
--
ALTER TABLE `order_status_d`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payer_categories`
--
ALTER TABLE `payer_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staffcategories`
--
ALTER TABLE `staffcategories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transaction_type`
--
ALTER TABLE `transaction_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `usercategories`
--
ALTER TABLE `usercategories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `userlocations`
--
ALTER TABLE `userlocations`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `collection_centers`
--
ALTER TABLE `collection_centers`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `collection_center_categories`
--
ALTER TABLE `collection_center_categories`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `goodssizecategory`
--
ALTER TABLE `goodssizecategory`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `goods_type_categories`
--
ALTER TABLE `goods_type_categories`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `order_a`
--
ALTER TABLE `order_a`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `order_status_a`
--
ALTER TABLE `order_status_a`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `order_status_b`
--
ALTER TABLE `order_status_b`
  MODIFY `int` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_status_c`
--
ALTER TABLE `order_status_c`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_status_d`
--
ALTER TABLE `order_status_d`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payer_categories`
--
ALTER TABLE `payer_categories`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `staffcategories`
--
ALTER TABLE `staffcategories`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `transaction_type`
--
ALTER TABLE `transaction_type`
  MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `usercategories`
--
ALTER TABLE `usercategories`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `userlocations`
--
ALTER TABLE `userlocations`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
COMMIT;

