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

START TRANSACTION;



--
-- Database: `compositedev_corporateportal`
--

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

--
-- Table structure for table `arorcharge`
--

CREATE TABLE `arorcharge` (
  `id` int(11) NOT NULL,
  `ARorChargeID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `arorcharge`
--

INSERT INTO `arorcharge` (`id`, `ARorChargeID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'ARCH007', 56.00, 67.00, '2017-12-29'),
(2, 'ARCH007', 78.00, 98.00, '2017-12-29'),
(3, 'ARCH007', 78.00, 98.00, '2017-12-29'),
(4, 'ARCH007', 78.00, 6.00, '2017-12-29'),
(5, 'ARCH007', 78.00, 6.00, '2017-12-29'),
(6, 'ARCH007', 78.00, 6.00, '2017-12-29'),
(7, 'ARCH007', 78.00, 6.00, '2017-12-29'),
(8, 'ARCH007', 78.00, 6.00, '2017-12-29'),
(9, 'ARCH007', 56.00, 55.00, '2017-12-29'),
(10, 'ARCH007', 56.00, 55.00, '2017-12-29'),
(11, 'ARCH007', 56.00, 55.00, '2017-12-29'),
(12, 'ARCH007', 56.00, 55.00, '2017-12-29'),
(13, 'ARCH007', 56.00, 55.00, '2017-12-29'),
(14, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(15, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(16, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(17, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(18, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(19, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(20, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(21, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(22, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(23, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(24, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(25, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(26, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(27, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(28, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(29, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(30, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(31, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(32, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(33, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(34, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(35, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(36, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(37, 'ARCH007', 0.00, 0.00, '2017-12-29'),
(38, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(39, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(40, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(41, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(42, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(43, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(44, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(45, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(46, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(47, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(48, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(49, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(50, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(51, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(52, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(53, 'ARCH007', 0.00, 0.00, '2017-12-30'),
(54, 'ARCH007', 34.00, 32.00, '2017-12-30'),
(55, 'ARCH007', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `audit_request`
--

CREATE TABLE `audit_request` (
  `audit_id` int(11) NOT NULL,
  `idno` int(11) DEFAULT NULL,
  `requestID` varchar(10) DEFAULT NULL,
  `staffID` varchar(10) DEFAULT NULL,
  `staff_name` varchar(30) DEFAULT NULL,
  `staff_email` varchar(100) DEFAULT NULL,
  `request_type` varchar(20) DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `project_code` varchar(20) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unit_price` float(10,2) DEFAULT NULL,
  `total_price` float(10,2) DEFAULT NULL,
  `worker_name` varchar(100) DEFAULT NULL,
  `worker_code` varchar(20) DEFAULT NULL,
  `worker_service` varchar(100) DEFAULT NULL,
  `amount` float(10,2) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `action` varchar(30) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `changedon` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `auto`
--

CREATE TABLE `auto` (
  `id` int(11) NOT NULL,
  `autoID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auto`
--

INSERT INTO `auto` (`id`, `autoID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'AUTO018', 45.00, 12.00, '2017-12-29'),
(2, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(3, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(4, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(5, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(6, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(7, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(8, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(9, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(10, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(11, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(12, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(13, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(14, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(15, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(16, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(17, 'AUTO018', 0.00, 0.00, '2017-12-29'),
(18, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(19, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(20, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(21, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(22, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(23, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(24, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(25, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(26, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(27, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(28, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(29, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(30, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(31, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(32, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(33, 'AUTO018', 0.00, 0.00, '2017-12-30'),
(34, 'AUTO018', 34.00, 78.00, '2017-12-30'),
(35, 'AUTO018', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `bankdeposit`
--

CREATE TABLE `bankdeposit` (
  `id` int(11) NOT NULL,
  `bankDepositID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bankdeposit`
--

INSERT INTO `bankdeposit` (`id`, `bankDepositID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'BNKD001', 12.00, 13.00, '2018-01-01'),
(2, 'LOTP002', 14.00, 15.00, '2018-01-01'),
(3, 'LOTD003', 16.00, 17.00, '2018-01-01'),
(4, 'REFD004', 18.00, 19.00, '2018-01-01'),
(5, 'PAYT005', 20.00, 21.00, '2018-01-01'),
(6, 'CTDT006', 22.00, 23.00, '2018-01-01'),
(7, 'ARCH007', 24.00, 25.00, '2018-01-01'),
(8, 'EBTF008', 26.00, 27.00, '2018-01-01'),
(9, 'SALES09', 28.00, 29.00, '2018-01-01'),
(10, 'GASO010', 30.00, 31.00, '2018-01-01'),
(11, 'CIGA011', 32.00, 33.00, '2018-01-01'),
(12, 'SODA012', 34.00, 35.00, '2018-01-01'),
(13, 'DAIR013', 36.00, 37.00, '2018-01-01'),
(14, 'COFF014', 38.00, 39.00, '2018-01-01'),
(15, 'HBAO015', 40.00, 41.00, '2018-01-01'),
(16, 'CAND016', 42.00, 43.00, '2018-01-01'),
(17, 'GROC017', 44.00, 45.00, '2018-01-01'),
(18, 'AUTO018', 46.00, 47.00, '2018-01-01'),
(19, 'ENER019', 48.00, 49.00, '2018-01-01'),
(20, 'TEAO020', 50.00, 51.00, '2018-01-01'),
(21, 'JUIC021', 52.00, 53.00, '2018-01-01'),
(22, 'SNAC022', 54.00, 55.00, '2018-01-01'),
(23, 'ICEC023', 56.00, 57.00, '2018-01-01'),
(24, 'TOBA024', 58.00, 59.00, '2018-01-01'),
(25, 'WATE025', 60.00, 61.00, '2018-01-01'),
(26, 'ICEO026', 62.00, 63.00, '2018-01-01'),
(27, 'LOTT027', 64.00, 65.00, '2018-01-01'),
(28, 'COUP028', 66.00, 67.00, '2018-01-01'),
(29, 'OVER029', 68.00, 69.00, '2018-01-01'),
(30, 'IPPO030', 70.00, 71.00, '2018-01-01'),
(31, 'NEWS031', 72.00, 73.00, '2018-01-01'),
(32, 'BNKD001', 74.00, 75.00, '2018-01-01'),
(33, 'LOTP002', 76.00, 77.00, '2018-01-01'),
(34, 'LOTD003', 78.00, 79.00, '2018-01-01'),
(35, 'REFD004', 80.00, 81.00, '2018-01-01'),
(36, 'PAYT005', 82.00, 83.00, '2018-01-01'),
(37, 'CTDT006', 84.00, 85.00, '2018-01-01'),
(38, 'ARCH007', 86.00, 87.00, '2018-01-01'),
(39, 'EBTF008', 88.00, 89.00, '2018-01-01'),
(40, 'SALES09', 90.00, 91.00, '2018-01-01'),
(41, 'GASO010', 92.00, 93.00, '2018-01-01'),
(42, 'CIGA011', 94.00, 95.00, '2018-01-01'),
(43, 'SODA012', 96.00, 97.00, '2018-01-01'),
(44, 'DAIR013', 98.00, 99.00, '2018-01-01'),
(45, 'COFF014', 100.00, 101.00, '2018-01-01'),
(46, 'HBAO015', 102.00, 103.00, '2018-01-01'),
(47, 'CAND016', 104.00, 105.00, '2018-01-01'),
(48, 'GROC017', 106.00, 107.00, '2018-01-01'),
(49, 'AUTO018', 108.00, 109.00, '2018-01-01'),
(50, 'ENER019', 110.00, 111.00, '2018-01-01'),
(51, 'TEAO020', 112.00, 113.00, '2018-01-01'),
(52, 'JUIC021', 114.00, 115.00, '2018-01-01'),
(53, 'SNAC022', 116.00, 117.00, '2018-01-01'),
(54, 'ICEC023', 118.00, 119.00, '2018-01-01'),
(55, 'TOBA024', 120.00, 121.00, '2018-01-01'),
(56, 'WATE025', 122.00, 123.00, '2018-01-01'),
(57, 'ICEO026', 124.00, 125.00, '2018-01-01'),
(58, 'LOTT027', 126.00, 127.00, '2018-01-01'),
(59, 'COUP028', 128.00, 129.00, '2018-01-01'),
(60, 'OVER029', 130.00, 131.00, '2018-01-01'),
(61, 'IPPO030', 132.00, 133.00, '2018-01-01'),
(62, 'NEWS031', 134.00, 135.00, '2018-01-01'),
(63, '', 0.00, 0.00, '2018-01-02'),
(64, '', 0.00, 0.00, '2018-01-02'),
(65, '', 0.00, 0.00, '2018-01-02'),
(66, '', 0.00, 0.00, '2018-01-02'),
(67, '', 0.00, 0.00, '2018-01-02'),
(68, '', 0.00, 0.00, '2018-01-02'),
(69, '', 0.00, 0.00, '2018-01-02'),
(70, '', 0.00, 0.00, '2018-01-02'),
(71, '', 0.00, 0.00, '2018-01-02'),
(72, '', 0.00, 0.00, '2018-01-02'),
(73, '', 0.00, 0.00, '2018-01-02'),
(74, '', 0.00, 0.00, '2018-01-02'),
(75, '', 0.00, 0.00, '2018-01-02'),
(76, '', 0.00, 0.00, '2018-01-02'),
(77, '', 0.00, 0.00, '2018-01-02'),
(78, '', 0.00, 0.00, '2018-01-02'),
(79, '', 0.00, 0.00, '2018-01-02'),
(80, '', 0.00, 0.00, '2018-01-02'),
(81, '', 0.00, 0.00, '2018-01-02'),
(82, '', 0.00, 0.00, '2018-01-02'),
(83, '', 0.00, 0.00, '2018-01-02'),
(84, '', 0.00, 0.00, '2018-01-02'),
(85, '', 0.00, 0.00, '2018-01-02'),
(86, '', 0.00, 0.00, '2018-01-02'),
(87, '', 0.00, 0.00, '2018-01-02'),
(88, '', 0.00, 0.00, '2018-01-02'),
(89, '', 0.00, 0.00, '2018-01-02'),
(90, '', 0.00, 0.00, '2018-01-02'),
(91, '', 0.00, 0.00, '2018-01-02'),
(92, '', 0.00, 0.00, '2018-01-02'),
(93, '', 0.00, 0.00, '2018-01-02'),
(94, '', 0.00, 0.00, '2018-01-02'),
(95, '', 0.00, 0.00, '2018-01-02'),
(96, '', 0.00, 0.00, '2018-01-02'),
(97, '', 0.00, 0.00, '2018-01-02'),
(98, '', 0.00, 0.00, '2018-01-02'),
(99, '', 0.00, 0.00, '2018-01-02'),
(100, '', 0.00, 0.00, '2018-01-02'),
(101, '', 0.00, 0.00, '2018-01-02'),
(102, '', 0.00, 0.00, '2018-01-02'),
(103, '', 0.00, 0.00, '2018-01-02'),
(104, '', 0.00, 0.00, '2018-01-02'),
(105, '', 0.00, 0.00, '2018-01-02'),
(106, '', 0.00, 0.00, '2018-01-02'),
(107, '', 0.00, 0.00, '2018-01-02'),
(108, '', 0.00, 0.00, '2018-01-02'),
(109, '', 0.00, 0.00, '2018-01-02'),
(110, '', 0.00, 0.00, '2018-01-02'),
(111, '', 0.00, 0.00, '2018-01-02'),
(112, '', 0.00, 0.00, '2018-01-02'),
(113, '', 0.00, 0.00, '2018-01-02'),
(114, '', 0.00, 0.00, '2018-01-02'),
(115, '', 0.00, 0.00, '2018-01-02'),
(116, '', 0.00, 0.00, '2018-01-02'),
(117, '', 0.00, 0.00, '2018-01-02'),
(118, '', 0.00, 0.00, '2018-01-02'),
(119, '', 0.00, 0.00, '2018-01-02'),
(120, '', 0.00, 0.00, '2018-01-02'),
(121, '', 0.00, 0.00, '2018-01-02'),
(122, '', 0.00, 0.00, '2018-01-02'),
(123, '', 0.00, 0.00, '2018-01-02'),
(124, '', 0.00, 0.00, '2018-01-02'),
(125, '', 0.00, 0.00, '2018-01-02'),
(126, '', 0.00, 0.00, '2018-01-02'),
(127, '', 0.00, 0.00, '2018-01-02'),
(128, '', 0.00, 0.00, '2018-01-02'),
(129, '', 0.00, 0.00, '2018-01-02'),
(130, '', 0.00, 0.00, '2018-01-02'),
(131, '', 0.00, 0.00, '2018-01-02'),
(132, '', 0.00, 0.00, '2018-01-02'),
(133, '', 0.00, 0.00, '2018-01-02'),
(134, '', 0.00, 0.00, '2018-01-02'),
(135, '', 0.00, 0.00, '2018-01-02'),
(136, '', 0.00, 0.00, '2018-01-02'),
(137, '', 0.00, 0.00, '2018-01-02'),
(138, '', 0.00, 0.00, '2018-01-02'),
(139, '', 0.00, 0.00, '2018-01-02'),
(140, '', 0.00, 0.00, '2018-01-02'),
(141, '', 0.00, 0.00, '2018-01-02'),
(142, '', 0.00, 0.00, '2018-01-02'),
(143, '', 0.00, 0.00, '2018-01-02'),
(144, '', 0.00, 0.00, '2018-01-02'),
(145, '', 0.00, 0.00, '2018-01-02'),
(146, '', 0.00, 0.00, '2018-01-02'),
(147, '', 0.00, 0.00, '2018-01-02'),
(148, '', 0.00, 0.00, '2018-01-02'),
(149, '', 0.00, 0.00, '2018-01-02'),
(150, '', 0.00, 0.00, '2018-01-02'),
(151, '', 0.00, 0.00, '2018-01-02'),
(152, '', 0.00, 0.00, '2018-01-02'),
(153, '', 0.00, 0.00, '2018-01-02'),
(154, '', 0.00, 0.00, '2018-01-02'),
(155, '', 0.00, 0.00, '2018-01-02'),
(156, '', 0.00, 0.00, '2018-01-02'),
(157, '', 0.00, 0.00, '2018-01-02'),
(158, '', 0.00, 0.00, '2018-01-02'),
(159, '', 0.00, 0.00, '2018-01-02'),
(160, '', 0.00, 0.00, '2018-01-02'),
(161, '', 0.00, 0.00, '2018-01-02'),
(162, '', 0.00, 0.00, '2018-01-02'),
(163, '', 0.00, 0.00, '2018-01-02'),
(164, '', 0.00, 0.00, '2018-01-02'),
(165, '', 0.00, 0.00, '2018-01-02'),
(166, '', 0.00, 0.00, '2018-01-02'),
(167, '', 0.00, 0.00, '2018-01-02'),
(168, '', 0.00, 0.00, '2018-01-02'),
(169, '', 0.00, 0.00, '2018-01-02'),
(170, '', 0.00, 0.00, '2018-01-02'),
(171, '', 0.00, 0.00, '2018-01-02'),
(172, '', 0.00, 0.00, '2018-01-02'),
(173, '', 0.00, 0.00, '2018-01-02'),
(174, '', 0.00, 0.00, '2018-01-02'),
(175, '', 0.00, 0.00, '2018-01-02'),
(176, '', 0.00, 0.00, '2018-01-02'),
(177, '', 0.00, 0.00, '2018-01-02'),
(178, '', 0.00, 0.00, '2018-01-02'),
(179, '', 0.00, 0.00, '2018-01-02'),
(180, '', 0.00, 0.00, '2018-01-02'),
(181, '', 0.00, 0.00, '2018-01-02'),
(182, '', 0.00, 0.00, '2018-01-02'),
(183, '', 0.00, 0.00, '2018-01-02'),
(184, '', 0.00, 0.00, '2018-01-02'),
(185, '', 0.00, 0.00, '2018-01-02'),
(186, '', 0.00, 0.00, '2018-01-02'),
(187, 'BNKD001', 34.00, 23.00, '2018-01-03'),
(188, 'LOTP002', 34.00, 56.00, '2018-01-03'),
(189, 'LOTD003', 54.00, 34.00, '2018-01-03'),
(190, 'REFD004', 8.00, 90.00, '2018-01-03'),
(191, 'PAYT005', 98.00, 78.00, '2018-01-03'),
(192, 'CTDT006', 56.00, 45.00, '2018-01-03'),
(193, 'ARCH007', 34.00, 23.00, '2018-01-03'),
(194, 'EBTF008', 12.00, 21.00, '2018-01-03'),
(195, 'SALES09', 32.00, 23.00, '2018-01-03'),
(196, 'GASO010', 45.00, 67.00, '2018-01-03'),
(197, 'CIGA011', 56.00, 89.00, '2018-01-03'),
(198, 'SODA012', 80.00, 98.00, '2018-01-03'),
(199, 'DAIR013', 76.00, 54.00, '2018-01-03'),
(200, 'COFF014', 32.00, 56.00, '2018-01-03'),
(201, 'HBAO015', 45.00, 34.00, '2018-01-03'),
(202, 'CAND016', 12.00, 78.00, '2018-01-03'),
(203, 'GROC017', 67.00, 65.00, '2018-01-03'),
(204, 'AUTO018', 78.00, 90.00, '2018-01-03'),
(205, 'ENER019', 98.00, 76.00, '2018-01-03'),
(206, 'TEAO020', 54.00, 34.00, '2018-01-03'),
(207, 'JUIC021', 23.00, 12.00, '2018-01-03'),
(208, 'SNAC022', 56.00, 56.00, '2018-01-03'),
(209, 'ICEC023', 76.00, 78.00, '2018-01-03'),
(210, 'TOBA024', 90.00, 98.00, '2018-01-03'),
(211, 'WATE025', 76.00, 54.00, '2018-01-03'),
(212, 'ICEO026', 32.00, 67.00, '2018-01-03'),
(213, 'LOTT027', 8.00, 9.00, '2018-01-03'),
(214, 'COUP028', 23.00, 23.00, '2018-01-03'),
(215, 'OVER029', 45.00, 7.00, '2018-01-03'),
(216, 'IPPO030', 68.00, 67.00, '2018-01-03'),
(217, 'NEWS031', 54.00, 32.00, '2018-01-03');

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

--
-- Table structure for table `candy`
--

CREATE TABLE `candy` (
  `id` int(11) NOT NULL,
  `candyID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `candy`
--

INSERT INTO `candy` (`id`, `candyID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'CAND016', 12.00, 45.00, '2017-12-29'),
(2, 'CAND016', 0.00, 0.00, '2017-12-29'),
(3, 'CAND016', 0.00, 0.00, '2017-12-29'),
(4, 'CAND016', 0.00, 0.00, '2017-12-29'),
(5, 'CAND016', 0.00, 0.00, '2017-12-29'),
(6, 'CAND016', 0.00, 0.00, '2017-12-29'),
(7, 'CAND016', 0.00, 0.00, '2017-12-29'),
(8, 'CAND016', 0.00, 0.00, '2017-12-29'),
(9, 'CAND016', 0.00, 0.00, '2017-12-29'),
(10, 'CAND016', 0.00, 0.00, '2017-12-29'),
(11, 'CAND016', 0.00, 0.00, '2017-12-29'),
(12, 'CAND016', 0.00, 0.00, '2017-12-29'),
(13, 'CAND016', 0.00, 0.00, '2017-12-29'),
(14, 'CAND016', 0.00, 0.00, '2017-12-29'),
(15, 'CAND016', 0.00, 0.00, '2017-12-29'),
(16, 'CAND016', 0.00, 0.00, '2017-12-29'),
(17, 'CAND016', 0.00, 0.00, '2017-12-29'),
(18, 'CAND016', 0.00, 0.00, '2017-12-29'),
(19, 'CAND016', 0.00, 0.00, '2017-12-29'),
(20, 'CAND016', 0.00, 0.00, '2017-12-30'),
(21, 'CAND016', 0.00, 0.00, '2017-12-30'),
(22, 'CAND016', 0.00, 0.00, '2017-12-30'),
(23, 'CAND016', 0.00, 0.00, '2017-12-30'),
(24, 'CAND016', 0.00, 0.00, '2017-12-30'),
(25, 'CAND016', 0.00, 0.00, '2017-12-30'),
(26, 'CAND016', 0.00, 0.00, '2017-12-30'),
(27, 'CAND016', 0.00, 0.00, '2017-12-30'),
(28, 'CAND016', 0.00, 0.00, '2017-12-30'),
(29, 'CAND016', 0.00, 0.00, '2017-12-30'),
(30, 'CAND016', 0.00, 0.00, '2017-12-30'),
(31, 'CAND016', 0.00, 0.00, '2017-12-30'),
(32, 'CAND016', 0.00, 0.00, '2017-12-30'),
(33, 'CAND016', 0.00, 0.00, '2017-12-30'),
(34, 'CAND016', 0.00, 0.00, '2017-12-30'),
(35, 'CAND016', 0.00, 0.00, '2017-12-30'),
(36, 'CAND016', 21.00, 34.00, '2017-12-30'),
(37, 'CAND016', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `carttemp`
--

CREATE TABLE `carttemp` (
  `carttemp_hidden` int(11) NOT NULL,
  `carttemp_sess` varchar(100) DEFAULT NULL,
  `carttemp_project` varchar(200) NOT NULL,
  `carttemp_projectCode` varchar(30) NOT NULL,
  `carttemp_request_type` varchar(50) DEFAULT NULL,
  `carttemp_desc` text DEFAULT NULL,
  `carttemp_qty` int(11) DEFAULT NULL,
  `carttemp_unit_price` float(8,2) DEFAULT NULL,
  `carttemp_total_price` float(12,2) DEFAULT NULL,
  `carttemp_w_name` varchar(100) DEFAULT NULL,
  `carttemp_w_code` varchar(20) NOT NULL,
  `carttemp_w_service` varchar(200) DEFAULT NULL,
  `carttemp_amount` float(8,2) DEFAULT NULL,
  `carttemp_comment` text DEFAULT NULL,
  `carttemp_supCode` varchar(30) NOT NULL,
  `carttemp_jobCode` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `carttemp`
--

INSERT INTO `carttemp` (`carttemp_hidden`, `carttemp_sess`, `carttemp_project`, `carttemp_projectCode`, `carttemp_request_type`, `carttemp_desc`, `carttemp_qty`, `carttemp_unit_price`, `carttemp_total_price`, `carttemp_w_name`, `carttemp_w_code`, `carttemp_w_service`, `carttemp_amount`, `carttemp_comment`, `carttemp_supCode`, `carttemp_jobCode`) VALUES
(7, '2okbefbh7i5u3d8qdvob212d22', 'ELF3 - Abake Court', 'SSP960071', 'Cash Advanc', NULL, NULL, NULL, NULL, NULL, '', NULL, 66700.00, 'payment to material testing lab. for raft foundation concrete test', '', ''),
(8, '267hrd6u3uqhp82urlqngf4jq7', 'ELF3 - Abake Court', 'SSP960071', 'Cash Advanc', NULL, NULL, NULL, NULL, NULL, '', NULL, 64000.00, 'Blk setting adv35000 chiselin of columns to recieve lintels3000 leveling of rubbles3000 packing of pavingstones4000 sinking of ring3000 diesel 5000 fuel 2000 loading&offloading of welding gen4000 money given to sunday5000', '', ''),
(10, 't8csiqpf53ffs3f4iqc7trcnl5', '', '', '', NULL, NULL, NULL, NULL, NULL, '', NULL, 0.00, '', '', ''),
(11, 'd64sil4audt0gtlgebdjtru0h6', 'ELF3 - Abake Court', 'SSP960071', 'Material', 'Bamboo ', 400, 350.00, 140000.00, NULL, '', NULL, NULL, '', 'NQLPSCJSWS', '');

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

--
-- Table structure for table `cashadvance`
--

CREATE TABLE `cashadvance` (
  `cash_id` int(11) NOT NULL,
  `project_code` varchar(30) DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `cash_advance_type` varchar(100) DEFAULT NULL,
  `request_code` varchar(30) DEFAULT NULL,
  `staff_id` varchar(20) NOT NULL,
  `staff_name` varchar(50) DEFAULT NULL,
  `amount_collected` float(12,2) DEFAULT NULL,
  `amount_recorded` float(12,2) DEFAULT NULL,
  `balance` float(12,2) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `date_updated` datetime DEFAULT NULL,
  `status` enum('Pending','Approved') NOT NULL DEFAULT 'Pending',
  `purpose` varchar(255) DEFAULT NULL,
  `bank_to` varchar(100) DEFAULT NULL,
  `payment_method` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cashadvance`
--

INSERT INTO `cashadvance` (`cash_id`, `project_code`, `project_name`, `cash_advance_type`, `request_code`, `staff_id`, `staff_name`, `amount_collected`, `amount_recorded`, `balance`, `date_added`, `date_updated`, `status`, `purpose`, `bank_to`, `payment_method`) VALUES
(1, 'SSP960071', 'ELF3 - Abake Court', 'Cash Advance - Project', 'REQCPD-OEU5QCELVF-19082020', 'SSREI001', 'Adebola Salami', 200000.00, 0.00, 0.00, '2020-08-21 04:15:34', '2020-08-21 04:15:34', 'Approved', 'For emergency expenses two', 'Access Bank', 'Online Transfer'),
(2, '', '', 'Cash Advance - Office', 'REQCPD-ZRH0MBM7D0-19082020', 'SSREI001', 'Adebola Salami', 50000.00, 0.00, 0.00, '2020-08-21 04:57:45', '2020-08-21 04:57:45', 'Approved', 'For daily office run Too', 'Polaris Bank Limited', 'Cash'),
(3, 'CPD271750', 'High Cost Tower Renovation', 'Cash Advance - Project', 'REQCPD-HQX9VL0RTK-02102020', 'SSREI001', 'Adebola Salami', 8000.00, 2000.00, 6000.00, '2020-10-02 22:39:34', '2020-10-02 22:39:34', 'Approved', 'For emergency expenses', 'Eco Bank', ''),
(4, 'CPD374831', 'Bode Peters ', 'Cash Advance - Office', 'REQCPD-UH6RXNAGFK-14102021', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 2123.00, 0.00, 0.00, '2021-10-18 15:56:33', '2021-10-18 15:56:33', 'Approved', 'DD', 'uba', 'Transfer'),
(5, 'CPD374831', 'Bode Peters ', 'Cash Advance - Office', 'REQCPD-UH6RXNAGFK-14102021', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 0.00, 0.00, 0.00, '2021-10-18 16:29:29', '2021-10-18 16:29:29', 'Approved', 'DD', '', ''),
(6, 'CPD374831', 'Bode Peters ', 'Cash Advance - Office', 'REQCPD-UH6RXNAGFK-14102021', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 0.00, 0.00, 0.00, '2021-10-18 16:32:01', '2021-10-18 16:32:01', 'Approved', 'DD', '', ''),
(7, 'CPD374831', 'Bode Peters ', 'Cash Advance - Office', 'REQCPD-UH6RXNAGFK-14102021', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 0.00, 0.00, 0.00, '2021-10-18 16:32:29', '2021-10-18 16:32:29', 'Approved', 'DD', '', ''),
(8, 'CPD374831', 'Bode Peters ', 'Cash Advance - Office', 'REQCPD-UH6RXNAGFK-14102021', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 0.00, 0.00, 0.00, '2021-10-18 16:33:31', '2021-10-18 16:33:31', 'Approved', 'DD', '', ''),
(9, 'CPD374831', 'Bode Peters ', 'Cash Advance - Office', 'REQCPD-UH6RXNAGFK-14102021', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 0.00, 0.00, 0.00, '2021-10-18 16:33:40', '2021-10-18 16:33:40', 'Approved', 'DD', '', '');

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

--
-- Table structure for table `cash_advance_breakdown`
--

CREATE TABLE `cash_advance_breakdown` (
  `idno` int(11) NOT NULL,
  `request_code` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `amount` float(12,2) DEFAULT NULL,
  `added_by` varchar(100) DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `comment` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cash_advance_breakdown`
--

INSERT INTO `cash_advance_breakdown` (`idno`, `request_code`, `description`, `amount`, `added_by`, `added_on`, `comment`) VALUES
(1, 'REQCPD-UWLPDBZHEM-26072020', 'Tractor Rent', 26000.00, 'Adebola Salami', '2020-08-19 01:36:42', 'testing 565656'),
(2, 'REQCPD-UWLPDBZHEM-26072020', 'PR', 1200.00, 'Adebola Salami', '2020-08-19 01:38:46', 'testing 6767'),
(3, 'REQCPD-UWLPDBZHEM-26072020', 'Transportation', 34000.00, 'Adebola Salami', '2020-08-19 02:26:07', 'testing testing'),
(4, 'REQCPD-HQX9VL0RTK-02102020', 'Wavey ones', 2000.00, 'Golden Ogbeka', '2021-10-15 08:05:16', 'Testing 676745234');

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

--
-- Table structure for table `cash_retirement`
--

CREATE TABLE `cash_retirement` (
  `idno` int(11) NOT NULL,
  `request_code` varchar(20) DEFAULT NULL,
  `staff_id` varchar(20) DEFAULT NULL,
  `staff_name` varchar(100) DEFAULT NULL,
  `project_code` varchar(20) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `amount_recorded` float(12,2) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cigarette`
--

CREATE TABLE `cigarette` (
  `id` int(11) NOT NULL,
  `cigaretteID` varchar(70) DEFAULT NULL,
  `type` enum('C','D') DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `total` float(12,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cigarette`
--

INSERT INTO `cigarette` (`id`, `cigaretteID`, `type`, `credit`, `debit`, `total`, `dateAdded`) VALUES
(1, 'CIGA011', NULL, 56.00, 34.00, NULL, '2017-12-29'),
(2, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(3, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(4, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(5, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(6, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(7, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(8, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(9, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(10, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(11, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(12, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(13, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(14, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(15, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(16, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(17, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(18, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(19, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(20, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(21, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(22, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(23, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(24, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(25, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(26, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(27, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(28, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(29, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(30, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(31, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(32, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(33, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(34, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(35, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(36, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(37, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(38, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(39, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(40, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(41, 'CIGA011', NULL, 43.00, 56.00, NULL, '2017-12-30'),
(42, 'CIGA011', NULL, 0.00, 0.00, NULL, '2017-12-31');

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

--
-- Table structure for table `client_flat`
--

CREATE TABLE `client_flat` (
  `id` int(11) NOT NULL,
  `client_id` varchar(100) NOT NULL,
  `project_id` varchar(100) NOT NULL,
  `project_code` varchar(100) NOT NULL,
  `flat_code` varchar(100) NOT NULL,
  `date` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `client_flat`
--

INSERT INTO `client_flat` (`id`, `client_id`, `project_id`, `project_code`, `flat_code`, `date`) VALUES
(0, '0', '5', 'SSP135694', 'FCPD24338907-2020', '07-09-21'),
(0, '4', '49', 'CPD374831', 'FCPD77396909-2021', '15-10-21');

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

--
-- Table structure for table `client_project`
--

CREATE TABLE `client_project` (
  `id` int(11) NOT NULL,
  `client_id` varchar(100) NOT NULL,
  `project_id` varchar(100) NOT NULL,
  `project_code` varchar(100) NOT NULL,
  `project_name` varchar(100) NOT NULL,
  `createdOn` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `client_project`
--

INSERT INTO `client_project` (`id`, `client_id`, `project_id`, `project_code`, `project_name`, `createdOn`) VALUES
(0, '0', '5', 'SSP135694', 'UNAAB Hostel', '07-09-21'),
(0, '0', '30', 'CPD346846', 'Greyland', '09-09-21'),
(0, '4', '49', 'CPD374831', 'Bode Peters ', '15-10-21');

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

--
-- Table structure for table `coffe`
--

CREATE TABLE `coffe` (
  `id` int(11) NOT NULL,
  `coffeeID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `coffe`
--

INSERT INTO `coffe` (`id`, `coffeeID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'COFF014', 56.00, 12.00, '2017-12-29'),
(2, 'COFF014', 0.00, 0.00, '2017-12-29'),
(3, 'COFF014', 0.00, 0.00, '2017-12-29'),
(4, 'COFF014', 0.00, 0.00, '2017-12-29'),
(5, 'COFF014', 0.00, 0.00, '2017-12-29'),
(6, 'COFF014', 0.00, 0.00, '2017-12-29'),
(7, 'COFF014', 0.00, 0.00, '2017-12-29'),
(8, 'COFF014', 0.00, 0.00, '2017-12-29'),
(9, 'COFF014', 0.00, 0.00, '2017-12-29'),
(10, 'COFF014', 0.00, 0.00, '2017-12-29'),
(11, 'COFF014', 0.00, 0.00, '2017-12-29'),
(12, 'COFF014', 0.00, 0.00, '2017-12-29'),
(13, 'COFF014', 0.00, 0.00, '2017-12-29'),
(14, 'COFF014', 0.00, 0.00, '2017-12-29'),
(15, 'COFF014', 0.00, 0.00, '2017-12-29'),
(16, 'COFF014', 0.00, 0.00, '2017-12-29'),
(17, 'COFF014', 0.00, 0.00, '2017-12-29'),
(18, 'COFF014', 0.00, 0.00, '2017-12-29'),
(19, 'COFF014', 0.00, 0.00, '2017-12-29'),
(20, 'COFF014', 0.00, 0.00, '2017-12-29'),
(21, 'COFF014', 0.00, 0.00, '2017-12-29'),
(22, 'COFF014', 0.00, 0.00, '2017-12-30'),
(23, 'COFF014', 0.00, 0.00, '2017-12-30'),
(24, 'COFF014', 0.00, 0.00, '2017-12-30'),
(25, 'COFF014', 0.00, 0.00, '2017-12-30'),
(26, 'COFF014', 0.00, 0.00, '2017-12-30'),
(27, 'COFF014', 0.00, 0.00, '2017-12-30'),
(28, 'COFF014', 0.00, 0.00, '2017-12-30'),
(29, 'COFF014', 0.00, 0.00, '2017-12-30'),
(30, 'COFF014', 0.00, 0.00, '2017-12-30'),
(31, 'COFF014', 0.00, 0.00, '2017-12-30'),
(32, 'COFF014', 0.00, 0.00, '2017-12-30'),
(33, 'COFF014', 0.00, 0.00, '2017-12-30'),
(34, 'COFF014', 0.00, 0.00, '2017-12-30'),
(35, 'COFF014', 0.00, 0.00, '2017-12-30'),
(36, 'COFF014', 0.00, 0.00, '2017-12-30'),
(37, 'COFF014', 0.00, 0.00, '2017-12-30'),
(38, 'COFF014', 34.00, 23.00, '2017-12-30'),
(39, 'COFF014', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `contractor`
--

CREATE TABLE `contractor` (
  `idno` int(11) NOT NULL,
  `contractor_code` varchar(100) DEFAULT NULL,
  `contractor_name` varchar(200) DEFAULT NULL,
  `contractor_service` varchar(255) DEFAULT NULL,
  `contractor_address` varchar(200) DEFAULT NULL,
  `contractor_ofc_phone` varchar(40) DEFAULT NULL,
  `contact_person` varchar(100) DEFAULT NULL,
  `contact_mobile` varchar(40) DEFAULT NULL,
  `contact_home_phone` varchar(40) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contractor`
--

INSERT INTO `contractor` (`idno`, `contractor_code`, `contractor_name`, `contractor_service`, `contractor_address`, `contractor_ofc_phone`, `contact_person`, `contact_mobile`, `contact_home_phone`, `email`, `website`, `comment`, `date_added`) VALUES
(1, 'QZQ2GWXWTQ', 'Grows TT', NULL, 'TTTT', '2787654327', 'Maybell2', '5647839097', '3564789097', NULL, NULL, 'Testing1234587', '2019-10-20 21:36:45'),
(2, '3CECN9FCBX', 'GeraldLimited', NULL, 'Testing road', '3345675645', 'Reed', '4567562341', '3434343434', NULL, NULL, 'Testing909', '2020-07-10 21:25:21'),
(3, 'AICH1Y6LWO', 'Wendy Manor', NULL, 'Rosedale Lane', '2345678989', '1234234534', '8989789090', '8978653425', NULL, NULL, 'testing 67676767', '2020-07-17 06:08:00'),
(4, 'NZJITWZSXU', 'Jerry Inc Limiteds', NULL, '4067  Testing Route 5788', '2345162438', 'Mason Anniee8', '4456789838', '5647234548', NULL, NULL, 'Test 56565698', '2020-07-20 01:40:33'),
(5, 'RNEGGDKHE4', 'Roonie Wayne', 'Man', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', 'Golden Ogbeka', '6754128987', '8987654123', 'ogbekagolden@gmail.com', 'https://www.dribbble.com/Golden-Ogbeka', 'testing testing 67', '2021-10-15 08:03:50'),
(6, '6EOLXS18DF', 'Joy Mercy4', NULL, 'Hammer Crescent4', '7867564535', 'Temi lola4', '7878675646', '6767676546', NULL, NULL, 'testing real5', '2020-07-31 04:54:12'),
(7, '8R1C4E9UM9', 'Land Scrapping', 'Land Scrapping', 'Testing Avenue uy', '4526787824', 'James Ady fg', '1234567894', '9823451674', NULL, NULL, 'testing 78787800', '2020-08-14 22:40:27'),
(8, 'SPJXBETOKI', 'Loki Limited', 'Grilling  & Laying', 'Test7890 Road', '7878746454', 'Kilmans John', '4536273644', '5647384744', 'it@compositepropertydevelopment.com', 'www.lokilimited.com', 'testing 67890', '2020-08-15 00:14:46'),
(9, 'CTCPD-BTSXRSUEFM', 'June Grailey', 'Scafolding', 'Teston Street', '7867564523', 'James Grass', '2425363736', '7878676756', 'it@compositepropertydevelopment.com', 'www.grayscafold.com', 'testing pop up', '2020-08-23 20:33:43'),
(10, 'CTCPD-RTUHSZ31YO', 'Kalm Limited', 'Furniture Making', 'Test road', '5645367483', 'Jake Ruin', '78748373837', '78748373837', 'it@compositepropertydevelopment.com', 'www.nicefurture.com', 'testing', '2020-08-23 23:18:16'),
(0, 'YTTNLVDLOQ', 'hjh', 'Man', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', 'Golden Ogbeka', '08169200454', '08169200454', 'ogbekagolden@gmail.com', 'Man', 'SSSS', '2021-09-09 07:56:22');

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

--
-- Table structure for table `contractorproject`
--

CREATE TABLE `contractorproject` (
  `contractorProID` int(11) NOT NULL,
  `contractor_code` varchar(50) DEFAULT NULL,
  `contractor_project_code` varchar(50) DEFAULT NULL,
  `contractor_amount` float(10,2) DEFAULT NULL,
  `approved_amount` float(12,2) DEFAULT NULL,
  `service` varchar(255) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` varchar(100) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contractorproject`
--

INSERT INTO `contractorproject` (`contractorProID`, `contractor_code`, `contractor_project_code`, `contractor_amount`, `approved_amount`, `service`, `createdOn`, `createdBy`, `comment`, `status`) VALUES
(1, 'QZQ2GWXWTQ', 'SSP960071', 40000.00, 25000.00, 'Grilling  & Laying', '2020-10-02 01:44:11', 'Adebola Salami', 'Am only going to approve #25,000', 'Approved'),
(2, 'QZQ2GWXWTQ', 'SSP960071', 17000.00, 10000.00, NULL, '2020-10-02 01:49:23', 'Adebola Salami', 'Approved 10,000', 'Approved'),
(3, '3CECN9FCBX', 'CPD403540', 40000.00, NULL, NULL, '2020-07-15 05:45:01', '2020-07-15 05:45:01', 'testing', 'Approved'),
(4, 'QZQ2GWXWTQ', 'SSP960071', 17000.00, NULL, NULL, '2020-07-15 06:20:26', '2020-07-15 06:20:26', 'doing great', 'Approved'),
(5, '3CECN9FCBX', 'SSP960071', 600000.00, NULL, NULL, '2020-07-15 21:30:09', 'Adebola', 'gbrt great b', 'Approved'),
(6, '3CECN9FCBX', 'SSP960071', 40000.00, NULL, NULL, '2020-07-15 06:21:42', '2020-07-15 06:21:42', 'FGRT', 'Approved'),
(7, '3CECN9FCBX', 'SSP960071', 40000.00, NULL, NULL, '2020-07-15 06:22:42', '2020-07-15 06:22:42', 'gtrd', 'Approved'),
(8, 'QZQ2GWXWTQ', 'CPD403540', 10000.00, NULL, NULL, '2020-07-20 02:18:49', 'Adebola', 'tyres', 'Approved'),
(9, 'SPJXBETOKI', 'CPD537884', 300000.00, NULL, 'Grilling  & Laying', '2020-08-15 03:12:49', 'Adebola Salami', 'Read or not here I come try me', 'Approved'),
(10, 'CTCPD-BTSXRSUEFM', 'CPD537884', 10000.00, NULL, 'Scafolding', '2020-08-23 20:36:05', 'Adebola Salami', 'Adding contractor to project', 'Approved'),
(11, 'CTCPD-RTUHSZ31YO', 'CPD537884', 30000.00, NULL, 'Furniture Making', '2020-08-23 23:20:05', 'Adebola Salami', 'testing 78  7878', 'Approved'),
(12, 'SPJXBETOKI', 'CPD271750', 40000.00, NULL, 'Grilling  & Laying', '2020-09-19 05:15:24', 'Adebola Salami', 'Testing testing', 'Approved'),
(13, 'CTCPD-RTUHSZ31YO', 'CPD195139', 30000.00, 20000.00, 'Furniture Making', '2020-09-20 22:38:04', 'Adebola Salami', 'Testing 676767', 'Rejected'),
(14, 'CTCPD-BTSXRSUEFM', 'CPD288446', 14000.00, 12000.00, 'Scafolding', '2020-09-20 21:02:55', 'Adebola Salami', 'The approved amount is #12,000', 'Approved');

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

--
-- Table structure for table `controlcenter`
--

CREATE TABLE `controlcenter` (
  `id` int(11) NOT NULL,
  `productID` varchar(70) DEFAULT NULL,
  `type` enum('C','D') DEFAULT NULL,
  `totalCreditForEachProduct` float(12,2) DEFAULT NULL,
  `totalDebitForEach` float(12,2) DEFAULT NULL,
  `sumCreditForAllProduct` float(12,2) DEFAULT NULL,
  `sumDebitForAllProduct` float(12,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int(11) NOT NULL,
  `couponsID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `couponsID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'COUP028', 45.00, 12.00, '2017-12-30'),
(2, 'COUP028', 0.00, 0.00, '2017-12-30'),
(3, 'COUP028', 0.00, 0.00, '2017-12-30'),
(4, 'COUP028', 0.00, 0.00, '2017-12-30'),
(5, 'COUP028', 0.00, 0.00, '2017-12-30'),
(6, 'COUP028', 0.00, 0.00, '2017-12-30'),
(7, 'COUP028', 0.00, 0.00, '2017-12-30'),
(8, 'COUP028', 0.00, 0.00, '2017-12-30'),
(9, 'COUP028', 0.00, 0.00, '2017-12-30'),
(10, 'COUP028', 90.00, 87.00, '2017-12-30'),
(11, 'COUP028', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `credidebitcard`
--

CREATE TABLE `credidebitcard` (
  `id` int(11) NOT NULL,
  `creditDebitCardID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `credidebitcard`
--

INSERT INTO `credidebitcard` (`id`, `creditDebitCardID`, `credit`, `debit`, `dateAdded`) VALUES
(1, '', 44.00, 34.00, '2017-12-29'),
(2, '34', 44.00, 34.00, '2017-12-29'),
(3, 'CTDT006', 56.00, 43.00, '2017-12-29'),
(4, 'CTDT006', 56.00, 89.00, '2017-12-29'),
(5, 'CTDT006', 56.00, 89.00, '2017-12-29'),
(6, 'CTDT006', 87.00, 65.00, '2017-12-29'),
(7, 'CTDT006', 87.00, 65.00, '2017-12-29'),
(8, 'CTDT006', 87.00, 65.00, '2017-12-29'),
(9, 'CTDT006', 87.00, 65.00, '2017-12-29'),
(10, 'CTDT006', 87.00, 65.00, '2017-12-29'),
(11, 'CTDT006', 9.00, 76.00, '2017-12-29'),
(12, 'CTDT006', 9.00, 76.00, '2017-12-29'),
(13, 'CTDT006', 9.00, 76.00, '2017-12-29'),
(14, 'CTDT006', 9.00, 76.00, '2017-12-29'),
(15, 'CTDT006', 9.00, 76.00, '2017-12-29'),
(16, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(17, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(18, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(19, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(20, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(21, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(22, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(23, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(24, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(25, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(26, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(27, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(28, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(29, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(30, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(31, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(32, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(33, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(34, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(35, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(36, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(37, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(38, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(39, 'CTDT006', 0.00, 0.00, '2017-12-29'),
(40, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(41, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(42, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(43, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(44, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(45, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(46, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(47, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(48, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(49, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(50, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(51, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(52, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(53, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(54, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(55, 'CTDT006', 0.00, 0.00, '2017-12-30'),
(56, 'CTDT006', 76.00, 12.00, '2017-12-30'),
(57, 'CTDT006', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `dairy`
--

CREATE TABLE `dairy` (
  `id` int(11) NOT NULL,
  `dairyID` varchar(70) DEFAULT NULL,
  `type` enum('C','D') DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `total` float(12,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dairy`
--

INSERT INTO `dairy` (`id`, `dairyID`, `type`, `credit`, `debit`, `total`, `dateAdded`) VALUES
(1, 'DAIR013', NULL, 34.00, 67.00, NULL, '2017-12-29'),
(2, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(3, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(4, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(5, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(6, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(7, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(8, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(9, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(10, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(11, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(12, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(13, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(14, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(15, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(16, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(17, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(18, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(19, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(20, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(21, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(22, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(23, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(24, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(25, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(26, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(27, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(28, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(29, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(30, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(31, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(32, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(33, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(34, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(35, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(36, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(37, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(38, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(39, 'DAIR013', NULL, 324.00, 55.00, NULL, '2017-12-30'),
(40, 'DAIR013', NULL, 0.00, 0.00, NULL, '2017-12-31');

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

--
-- Table structure for table `ebtfoodstamp`
--

CREATE TABLE `ebtfoodstamp` (
  `id` int(11) NOT NULL,
  `ebtFoodStampID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ebtfoodstamp`
--

INSERT INTO `ebtfoodstamp` (`id`, `ebtFoodStampID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'EBTF008', 67.00, 56.00, '2017-12-29'),
(2, 'EBTF008', 67.00, 56.00, '2017-12-29'),
(3, 'EBTF008', 56.00, 56.00, '2017-12-29'),
(4, 'EBTF008', 56.00, 56.00, '2017-12-29'),
(5, 'EBTF008', 56.00, 56.00, '2017-12-29'),
(6, 'EBTF008', 56.00, 56.00, '2017-12-29'),
(7, 'EBTF008', 56.00, 56.00, '2017-12-29'),
(8, 'EBTF008', 45.00, 45.00, '2017-12-29'),
(9, 'EBTF008', 45.00, 45.00, '2017-12-29'),
(10, 'EBTF008', 45.00, 45.00, '2017-12-29'),
(11, 'EBTF008', 45.00, 45.00, '2017-12-29'),
(12, 'EBTF008', 45.00, 45.00, '2017-12-29'),
(13, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(14, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(15, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(16, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(17, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(18, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(19, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(20, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(21, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(22, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(23, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(24, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(25, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(26, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(27, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(28, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(29, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(30, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(31, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(32, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(33, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(34, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(35, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(36, 'EBTF008', 0.00, 0.00, '2017-12-29'),
(37, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(38, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(39, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(40, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(41, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(42, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(43, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(44, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(45, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(46, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(47, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(48, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(49, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(50, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(51, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(52, 'EBTF008', 0.00, 0.00, '2017-12-30'),
(53, 'EBTF008', 45.00, 45.00, '2017-12-30'),
(54, 'EBTF008', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `energydrink`
--

CREATE TABLE `energydrink` (
  `id` int(11) NOT NULL,
  `energyDrinkID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `energydrink`
--

INSERT INTO `energydrink` (`id`, `energyDrinkID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'ENER019', 67.00, 76.00, '2017-12-29'),
(2, 'ENER019', 0.00, 0.00, '2017-12-29'),
(3, 'ENER019', 0.00, 0.00, '2017-12-29'),
(4, 'ENER019', 0.00, 0.00, '2017-12-29'),
(5, 'ENER019', 0.00, 0.00, '2017-12-29'),
(6, 'ENER019', 0.00, 0.00, '2017-12-29'),
(7, 'ENER019', 0.00, 0.00, '2017-12-29'),
(8, 'ENER019', 0.00, 0.00, '2017-12-29'),
(9, 'ENER019', 0.00, 0.00, '2017-12-29'),
(10, 'ENER019', 0.00, 0.00, '2017-12-29'),
(11, 'ENER019', 0.00, 0.00, '2017-12-29'),
(12, 'ENER019', 0.00, 0.00, '2017-12-29'),
(13, 'ENER019', 0.00, 0.00, '2017-12-29'),
(14, 'ENER019', 0.00, 0.00, '2017-12-29'),
(15, 'ENER019', 0.00, 0.00, '2017-12-29'),
(16, 'ENER019', 0.00, 0.00, '2017-12-29'),
(17, 'ENER019', 0.00, 0.00, '2017-12-30'),
(18, 'ENER019', 0.00, 0.00, '2017-12-30'),
(19, 'ENER019', 0.00, 0.00, '2017-12-30'),
(20, 'ENER019', 0.00, 0.00, '2017-12-30'),
(21, 'ENER019', 0.00, 0.00, '2017-12-30'),
(22, 'ENER019', 0.00, 0.00, '2017-12-30'),
(23, 'ENER019', 0.00, 0.00, '2017-12-30'),
(24, 'ENER019', 0.00, 0.00, '2017-12-30'),
(25, 'ENER019', 0.00, 0.00, '2017-12-30'),
(26, 'ENER019', 0.00, 0.00, '2017-12-30'),
(27, 'ENER019', 0.00, 0.00, '2017-12-30'),
(28, 'ENER019', 0.00, 0.00, '2017-12-30'),
(29, 'ENER019', 0.00, 0.00, '2017-12-30'),
(30, 'ENER019', 0.00, 0.00, '2017-12-30'),
(31, 'ENER019', 0.00, 0.00, '2017-12-30'),
(32, 'ENER019', 0.00, 0.00, '2017-12-30'),
(33, 'ENER019', 67.00, 56.00, '2017-12-30'),
(34, 'ENER019', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `gasoline`
--

CREATE TABLE `gasoline` (
  `id` int(11) NOT NULL,
  `gasolineID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gasoline`
--

INSERT INTO `gasoline` (`id`, `gasolineID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'GASO010', 33.00, 45.00, '2017-12-29'),
(2, 'GASO010', 0.00, 0.00, '2017-12-29'),
(3, 'GASO010', 0.00, 0.00, '2017-12-29'),
(4, 'GASO010', 0.00, 0.00, '2017-12-29'),
(5, 'GASO010', 0.00, 0.00, '2017-12-29'),
(6, 'GASO010', 0.00, 0.00, '2017-12-29'),
(7, 'GASO010', 0.00, 0.00, '2017-12-29'),
(8, 'GASO010', 0.00, 0.00, '2017-12-29'),
(9, 'GASO010', 0.00, 0.00, '2017-12-29'),
(10, 'GASO010', 0.00, 0.00, '2017-12-29'),
(11, 'GASO010', 0.00, 0.00, '2017-12-29'),
(12, 'GASO010', 0.00, 0.00, '2017-12-29'),
(13, 'GASO010', 0.00, 0.00, '2017-12-29'),
(14, 'GASO010', 0.00, 0.00, '2017-12-29'),
(15, 'GASO010', 0.00, 0.00, '2017-12-29'),
(16, 'GASO010', 0.00, 0.00, '2017-12-29'),
(17, 'GASO010', 0.00, 0.00, '2017-12-29'),
(18, 'GASO010', 0.00, 0.00, '2017-12-29'),
(19, 'GASO010', 0.00, 0.00, '2017-12-29'),
(20, 'GASO010', 0.00, 0.00, '2017-12-29'),
(21, 'GASO010', 0.00, 0.00, '2017-12-29'),
(22, 'GASO010', 0.00, 0.00, '2017-12-29'),
(23, 'GASO010', 0.00, 0.00, '2017-12-29'),
(24, 'GASO010', 0.00, 0.00, '2017-12-29'),
(25, 'GASO010', 0.00, 0.00, '2017-12-29'),
(26, 'GASO010', 0.00, 0.00, '2017-12-30'),
(27, 'GASO010', 0.00, 0.00, '2017-12-30'),
(28, 'GASO010', 0.00, 0.00, '2017-12-30'),
(29, 'GASO010', 0.00, 0.00, '2017-12-30'),
(30, 'GASO010', 0.00, 0.00, '2017-12-30'),
(31, 'GASO010', 0.00, 0.00, '2017-12-30'),
(32, 'GASO010', 0.00, 0.00, '2017-12-30'),
(33, 'GASO010', 0.00, 0.00, '2017-12-30'),
(34, 'GASO010', 0.00, 0.00, '2017-12-30'),
(35, 'GASO010', 0.00, 0.00, '2017-12-30'),
(36, 'GASO010', 0.00, 0.00, '2017-12-30'),
(37, 'GASO010', 0.00, 0.00, '2017-12-30'),
(38, 'GASO010', 0.00, 0.00, '2017-12-30'),
(39, 'GASO010', 0.00, 0.00, '2017-12-30'),
(40, 'GASO010', 0.00, 0.00, '2017-12-30'),
(41, 'GASO010', 0.00, 0.00, '2017-12-30'),
(42, 'GASO010', 76.00, 89.00, '2017-12-30'),
(43, 'GASO010', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `grocery`
--

CREATE TABLE `grocery` (
  `id` int(11) NOT NULL,
  `groceryID` varchar(70) DEFAULT NULL,
  `type` enum('C','D') DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `total` float(12,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grocery`
--

INSERT INTO `grocery` (`id`, `groceryID`, `type`, `credit`, `debit`, `total`, `dateAdded`) VALUES
(1, 'GROC017', NULL, 56.00, 23.00, NULL, '2017-12-29'),
(2, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(3, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(4, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(5, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(6, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(7, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(8, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(9, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(10, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(11, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(12, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(13, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(14, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(15, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(16, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(17, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(18, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(19, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(20, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(21, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(22, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(23, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(24, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(25, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(26, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(27, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(28, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(29, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(30, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(31, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(32, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(33, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(34, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(35, 'GROC017', NULL, 56.00, 12.00, NULL, '2017-12-30'),
(36, 'GROC017', NULL, 0.00, 0.00, NULL, '2017-12-31');

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

--
-- Table structure for table `hba`
--

CREATE TABLE `hba` (
  `id` int(11) NOT NULL,
  `hbaID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hba`
--

INSERT INTO `hba` (`id`, `hbaID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'HBAO015', 34.00, 12.00, '2017-12-29'),
(2, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(3, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(4, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(5, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(6, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(7, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(8, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(9, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(10, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(11, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(12, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(13, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(14, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(15, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(16, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(17, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(18, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(19, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(20, 'HBAO015', 0.00, 0.00, '2017-12-29'),
(21, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(22, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(23, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(24, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(25, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(26, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(27, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(28, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(29, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(30, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(31, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(32, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(33, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(34, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(35, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(36, 'HBAO015', 0.00, 0.00, '2017-12-30'),
(37, 'HBAO015', 56.00, 34.00, '2017-12-30'),
(38, 'HBAO015', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `ice`
--

CREATE TABLE `ice` (
  `id` int(11) NOT NULL,
  `iceID` varchar(70) DEFAULT NULL,
  `type` enum('C','D') DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `total` float(12,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ice`
--

INSERT INTO `ice` (`id`, `iceID`, `type`, `credit`, `debit`, `total`, `dateAdded`) VALUES
(1, '', NULL, 67.00, 98.00, NULL, '2017-12-30'),
(2, 'ICEO026', NULL, 67.00, 98.00, NULL, '2017-12-30'),
(3, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(4, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(5, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(6, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(7, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(8, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(9, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(10, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(11, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(12, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(13, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(14, 'ICEO026', NULL, 34.00, 56.00, NULL, '2017-12-30'),
(15, 'ICEO026', NULL, 0.00, 0.00, NULL, '2017-12-31');

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

--
-- Table structure for table `icecream`
--

CREATE TABLE `icecream` (
  `id` int(11) NOT NULL,
  `iceCreamID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `icecream`
--

INSERT INTO `icecream` (`id`, `iceCreamID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'ICEC023', 56.00, 12.00, '2017-12-29'),
(2, 'ICEC023', 56.00, 12.00, '2017-12-29'),
(3, 'ICEC023', 0.00, 0.00, '2017-12-29'),
(4, 'ICEC023', 0.00, 0.00, '2017-12-29'),
(5, 'ICEC023', 0.00, 0.00, '2017-12-29'),
(6, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(7, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(8, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(9, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(10, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(11, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(12, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(13, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(14, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(15, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(16, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(17, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(18, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(19, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(20, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(21, 'ICEC023', 0.00, 0.00, '2017-12-30'),
(22, 'ICEC023', 54.00, 32.00, '2017-12-30'),
(23, 'ICEC023', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
  `inventoryId` int(11) NOT NULL,
  `inventory_code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `unit_price` float(12,2) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `total_price` float(12,2) DEFAULT NULL,
  `total_quantity` int(11) DEFAULT NULL,
  `remaining_quantity` int(11) DEFAULT NULL,
  `createdBy` varchar(100) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `updatedBy` varchar(100) DEFAULT NULL,
  `updatedOn` datetime DEFAULT NULL,
  `comment` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`
--

INSERT INTO `inventory` (`inventoryId`, `inventory_code`, `name`, `type`, `unit_price`, `quantity`, `total_price`, `total_quantity`, `remaining_quantity`, `createdBy`, `createdOn`, `updatedBy`, `updatedOn`, `comment`) VALUES
(1, 'CPDINV582218', 'Shovel', 'Machinery', 400.00, 190, 76000.00, 190, 0, 'Adebola Salami', '2020-09-04 04:42:46', 'Golden Ogbeka', '2021-10-14 20:28:04', 'Testing testing'),
(2, 'CPDINV771124', 'Wheelbarrow', 'Tools', 700.00, 4, 2800.00, 4, 0, 'Adebola Salami', '2020-10-02 00:40:10', 'Adebola Salami', '2020-10-02 00:40:37', 'testing 56565656'),
(0, 'CPDINV206746', 'Plum/Leveler|2', 'Tools', 1000.00, 9, 9000.00, 9, 0, 'Adebola Salami', '2021-09-20 14:04:43', 'Golden Ogbeka', '2021-10-14 20:22:00', '50 million naira in my possesion'),
(0, 'CPDINV583280', 'Wheelbarrow|1', 'Tools', 400.00, 22, 8800.00, 0, 0, 'Golden Ogbeka', '2021-10-14 20:18:24', NULL, NULL, 'ee');

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

--
-- Table structure for table `inventory_type`
--

CREATE TABLE `inventory_type` (
  `inventory_type_id` int(11) NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unit_price` float(12,2) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory_type`
--

INSERT INTO `inventory_type` (`inventory_type_id`, `type`, `description`, `quantity`, `unit_price`, `createdOn`, `createdBy`) VALUES
(1, 'Tools', 'Wheelbarrow', 3, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(2, 'Tools', 'Plum/Leveler', 10, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(3, 'Machinery', 'Headpan', 10, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(4, 'Machinery', 'Shovel', 8, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(5, 'Machinery', 'Compactor', 9, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(6, 'Machinery', 'Concrete Vibrator', 12, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(7, 'Machinery', 'Concrete Mixer', 14, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(8, 'Machinery', 'Concrete Mixer/Pump', 7, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(9, 'Machinery', 'Welding Machine/Generator', 8, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(10, 'Machinery', 'Level Instrument', 10, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(11, 'Machinery', 'Drilling Machine', 8, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(12, 'Machinery', 'Grinding Machine', 11, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(13, 'Machinery', 'Circular Saw', 12, NULL, '2020-09-03 19:13:04', 'Adebola Salami'),
(14, 'Machinery', 'Drilling Machine/Jack Hammer', 15, NULL, '2020-09-03 19:13:04', 'Adebola Salami');

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

--
-- Table structure for table `iou_refund`
--

CREATE TABLE `iou_refund` (
  `idno` int(11) NOT NULL,
  `iou_refund_code` varchar(100) DEFAULT NULL,
  `iou_refund_type` varchar(50) DEFAULT NULL,
  `cash_advance_request_code` varchar(100) DEFAULT NULL,
  `amount` float(12,2) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `added_by` varchar(100) DEFAULT NULL,
  `user_code` varchar(50) DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `status_updated_by` varchar(50) DEFAULT NULL,
  `status_updated_on` datetime DEFAULT NULL,
  `status_comment` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `iou_refund`
--

INSERT INTO `iou_refund` (`idno`, `iou_refund_code`, `iou_refund_type`, `cash_advance_request_code`, `amount`, `description`, `added_by`, `user_code`, `added_on`, `status`, `status_updated_by`, `status_updated_on`, `status_comment`) VALUES
(0, 'IOUCPD-73842-09092021', 'Return Balance', '1', 12123.00, 'ewewEWEweqWE', ' ', NULL, '2021-09-09 08:05:04', 'Pending Approval', NULL, NULL, NULL);

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

--
-- Table structure for table `ipp`
--

CREATE TABLE `ipp` (
  `id` int(11) NOT NULL,
  `ippID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ipp`
--

INSERT INTO `ipp` (`id`, `ippID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'IPPO030', 34.00, 34.00, '2017-12-30'),
(2, 'IPPO030', 34.00, 23.00, '2017-12-30'),
(3, 'IPPO030', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `juice`
--

CREATE TABLE `juice` (
  `id` int(11) NOT NULL,
  `juiceID` varchar(70) DEFAULT NULL,
  `type` enum('C','D') DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `total` float(12,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `juice`
--

INSERT INTO `juice` (`id`, `juiceID`, `type`, `credit`, `debit`, `total`, `dateAdded`) VALUES
(1, 'JUIC021', NULL, 34.00, 0.00, NULL, '2017-12-29'),
(2, 'JUIC021', NULL, 34.00, 12.00, NULL, '2017-12-29'),
(3, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(4, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(5, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(6, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(7, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(8, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(9, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(10, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(11, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(12, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(13, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(14, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(15, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(16, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(17, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(18, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(19, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(20, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(21, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(22, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(23, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(24, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(25, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(26, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(27, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(28, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(29, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(30, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(31, 'JUIC021', NULL, 89.00, 76.00, NULL, '2017-12-30'),
(32, 'JUIC021', NULL, 0.00, 0.00, NULL, '2017-12-31');

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

--
-- Table structure for table `lottery`
--

CREATE TABLE `lottery` (
  `id` int(11) NOT NULL,
  `lotteryID` varchar(70) DEFAULT NULL,
  `type` enum('C','D') DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `total` float(12,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lottery`
--

INSERT INTO `lottery` (`id`, `lotteryID`, `type`, `credit`, `debit`, `total`, `dateAdded`) VALUES
(1, 'LOTT027', NULL, 54.00, 34.00, NULL, '2017-12-30'),
(2, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(3, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(4, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(5, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(6, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(7, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(8, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(9, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(10, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(11, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(12, 'LOTT027', NULL, 78.00, 90.00, NULL, '2017-12-30'),
(13, 'LOTT027', NULL, 0.00, 0.00, NULL, '2017-12-31');

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

--
-- Table structure for table `lotterydeposit`
--

CREATE TABLE `lotterydeposit` (
  `id` int(11) NOT NULL,
  `lotteryDepositID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lotterydeposit`
--

INSERT INTO `lotterydeposit` (`id`, `lotteryDepositID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'LOTD003', 45.00, 67.00, '2017-12-28'),
(2, 'LOTD003', 23.00, 45.00, '2017-12-28'),
(3, 'LOTD003', 45.00, 66.00, '2017-12-28'),
(4, 'LOTD003', 45.00, 66.00, '2017-12-28'),
(5, 'LOTD003', 78.00, 65.00, '2017-12-28'),
(6, 'LOTD003', 76.00, 56.00, '2017-12-29'),
(7, 'LOTD003', 76.00, 56.00, '2017-12-29'),
(8, 'LOTD003', 78.00, 65.00, '2017-12-29'),
(9, 'LOTD003', 67.00, 54.00, '2017-12-29'),
(10, 'LOTD003', 67.00, 54.00, '2017-12-29'),
(11, 'LOTD003', 45.00, 34.00, '2017-12-29'),
(12, 'LOTD003', 45.00, 34.00, '2017-12-29'),
(13, 'LOTD003', 45.00, 34.00, '2017-12-29'),
(14, 'LOTD003', 45.00, 34.00, '2017-12-29'),
(15, 'LOTD003', 45.00, 34.00, '2017-12-29'),
(16, 'LOTD003', 34.00, 34.00, '2017-12-29'),
(17, 'LOTD003', 34.00, 34.00, '2017-12-29'),
(18, 'LOTD003', 34.00, 34.00, '2017-12-29'),
(19, 'LOTD003', 34.00, 34.00, '2017-12-29'),
(20, 'LOTD003', 34.00, 34.00, '2017-12-29'),
(21, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(22, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(23, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(24, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(25, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(26, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(27, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(28, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(29, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(30, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(31, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(32, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(33, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(34, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(35, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(36, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(37, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(38, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(39, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(40, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(41, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(42, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(43, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(44, 'LOTD003', 0.00, 0.00, '2017-12-29'),
(45, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(46, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(47, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(48, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(49, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(50, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(51, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(52, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(53, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(54, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(55, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(56, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(57, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(58, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(59, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(60, 'LOTD003', 0.00, 0.00, '2017-12-30'),
(61, 'LOTD003', 34.00, 34.00, '2017-12-30'),
(62, 'LOTD003', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `lotterypayout`
--

CREATE TABLE `lotterypayout` (
  `id` int(11) NOT NULL,
  `lotteryPayoutID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lotterypayout`
--

INSERT INTO `lotterypayout` (`id`, `lotteryPayoutID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'LOTP002', 78.00, 78.00, '2017-12-28'),
(2, 'LOTP002', 67.00, 89.00, '2017-12-28'),
(3, 'LOTP002', 67.00, 89.00, '2017-12-28'),
(4, 'LOTP002', 67.00, 89.00, '2017-12-28'),
(5, 'LOTP002', 67.00, 89.00, '2017-12-28'),
(6, 'LOTP002', 67.00, 65.00, '2017-12-28'),
(7, 'LOTP002', 45.00, 34.00, '2017-12-28'),
(8, 'LOTP002', 56.00, 45.00, '2017-12-28'),
(9, 'LOTP002', 56.00, 45.00, '2017-12-28'),
(10, 'LOTP002', 45.00, 32.00, '2017-12-28'),
(11, 'LOTP002', 78.00, 90.00, '2017-12-29'),
(12, 'LOTP002', 78.00, 90.00, '2017-12-29'),
(13, 'LOTP002', 57.00, 89.00, '2017-12-29'),
(14, 'LOTP002', 56.00, 45.00, '2017-12-29'),
(15, 'LOTP002', 56.00, 45.00, '2017-12-29'),
(16, 'LOTP002', 45.00, 76.00, '2017-12-29'),
(17, 'LOTP002', 45.00, 76.00, '2017-12-29'),
(18, 'LOTP002', 45.00, 76.00, '2017-12-29'),
(19, 'LOTP002', 45.00, 76.00, '2017-12-29'),
(20, 'LOTP002', 45.00, 76.00, '2017-12-29'),
(21, 'LOTP002', 34.00, 34.00, '2017-12-29'),
(22, 'LOTP002', 34.00, 34.00, '2017-12-29'),
(23, 'LOTP002', 34.00, 34.00, '2017-12-29'),
(24, 'LOTP002', 34.00, 34.00, '2017-12-29'),
(25, 'LOTP002', 34.00, 34.00, '2017-12-29'),
(26, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(27, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(28, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(29, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(30, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(31, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(32, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(33, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(34, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(35, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(36, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(37, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(38, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(39, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(40, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(41, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(42, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(43, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(44, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(45, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(46, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(47, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(48, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(49, 'LOTP002', 0.00, 0.00, '2017-12-29'),
(50, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(51, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(52, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(53, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(54, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(55, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(56, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(57, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(58, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(59, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(60, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(61, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(62, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(63, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(64, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(65, 'LOTP002', 0.00, 0.00, '2017-12-30'),
(66, 'LOTP002', 56.00, 45.00, '2017-12-30'),
(67, 'LOTP002', 34.00, 34.00, '2017-12-31');

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

--
-- Table structure for table `maintenance_request`
--

CREATE TABLE `maintenance_request` (
  `m_id` int(11) NOT NULL,
  `proCode` varchar(30) DEFAULT NULL,
  `flat_desc` varchar(50) DEFAULT NULL,
  `flat_code` varchar(30) DEFAULT NULL,
  `tenant_name` varchar(100) DEFAULT NULL,
  `tenant_code` varchar(30) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `request` text DEFAULT NULL,
  `response` text DEFAULT NULL,
  `date_requested` datetime DEFAULT NULL,
  `date_responded` datetime DEFAULT NULL,
  `status` enum('Y','N','C','R') DEFAULT 'N'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `maintenance_request`
--

INSERT INTO `maintenance_request` (`m_id`, `proCode`, `flat_desc`, `flat_code`, `tenant_name`, `tenant_code`, `email`, `request`, `response`, `date_requested`, `date_responded`, `status`) VALUES
(1, 'SSP238684', 'FLAT 8 - Pent Floor - 1-Bed Flat with big terrace', 'PFCCFNFSSQF', 'Tolulope Mebude', 'TCBIRSOSO4RZ', 'mebudetolulope@gmail.com', 'Flat issues: bathroom water heater isn\\\\\\\'t working, living room A/c isn\\\\\\\'t working, balcony & living room tiles need to be replastered. Insects find their way through the gaps. The balcony door needs a rubber beneath it too. Rain comes in through there. \\r\\n\\r\\nGeneral problems; Electricity...we hardly ever have light when there\\\\\\\'s general supply in the estate. The electrician hasn\\\\\\\'t completed his job under the stairway after a whole year. \\r\\nThe cctv installed never worked, so I\\\\\\\'d suggest a hole be drilled to the pedestrian gate to enable the security guy peep first before opening the gate especially at night. \\r\\nThere are no light fixtures on the fence outside. \\r\\nWould be glad if all is really looked into. \\r\\nThank you \\r\\nKind regards,', NULL, '2015-07-02 10:00:39', NULL, 'N'),
(2, '', '', '', '', '', '', '', NULL, '2015-07-31 21:40:44', NULL, 'N'),
(3, 'SSP238684', 'FLAT 6 - First Floor - 1-Bed Flat with Store', 'PFCIJEJUJJL', 'Anwuli Okeke', 'TCGYFISROSSZ', 'anwuli.b.okeke@gmail.com', 'My kitchen sink tap is broken , I always have to turn it off from the main source and once the main source is turned off, my washing machine cannot function because it needs the water .\\r\\n\\r\\nBedroom bulbs and pantry bulbs are not working\\r\\n\\r\\nAir conditioner in the living room have not been working for a few months now.\\r\\n\\r\\nI\\\\\\\'ll appreciate if my requests are taken care of.\\r\\n\\r\\nRegards\\r\\nAnwuli', NULL, '2015-08-05 03:04:47', NULL, 'N'),
(4, '', '', '', '', '', '', '', NULL, '2015-11-04 00:59:17', NULL, 'N');

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

--
-- Table structure for table `material`
--

CREATE TABLE `material` (
  `idno` int(11) NOT NULL,
  `project_code` varchar(30) NOT NULL,
  `supplier_code` varchar(30) NOT NULL,
  `supplier_name` varchar(255) DEFAULT NULL,
  `material_code` varchar(10) NOT NULL,
  `company` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `contact_person` varchar(50) NOT NULL,
  `contact_mobile` varchar(30) NOT NULL,
  `ofc_phone` varchar(30) NOT NULL,
  `description` text DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unit_price` float DEFAULT NULL,
  `total_price` float(12,2) DEFAULT NULL,
  `payment_mode` varchar(50) NOT NULL,
  `comment` text NOT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `material`
--

INSERT INTO `material` (`idno`, `project_code`, `supplier_code`, `supplier_name`, `material_code`, `company`, `address`, `contact_person`, `contact_mobile`, `ofc_phone`, `description`, `quantity`, `unit_price`, `total_price`, `payment_mode`, `comment`, `date_added`) VALUES
(5, 'SSP960071', 'UFQJOPRTTX', NULL, '5350', '', '', '', '', '', '9inch blocks 2000', 2000, 170, 340000.00, 'Online Transfer', 'block made on site', '2015-02-09 07:45:07'),
(6, 'SSP960071', 'UFQJOPRTTX', NULL, '6147', '', '', '', '', '', '6inch blocks', 1000, 150, 150000.00, 'Online Transfer', 'made on site', '2015-02-09 07:45:56'),
(7, 'SSP960071', 'HMPHA115X5', NULL, '6843', '', '', '', '', '', 'Iron Rods (tons)', 1, 819000, 819000.00, 'Online Transfer', '10mm - 2tons; 12mm -2; 16mm - 2; 20mm - 1, BW - 2', '2015-02-09 08:54:15'),
(8, 'SSP960071', 'HMPHA115X5', NULL, '9881', '', '', '', '', '', 'Iron Rods (tons)', 1, 602000, 602000.00, 'Online Transfer', '5tons = 10mm - 2; 12mm - 1; 16mm - 1; 20mm - 1; BW - 1', '2015-02-09 08:59:12'),
(9, 'SSP960071', 'HMPHA115X5', NULL, '2396', '', '', '', '', '', 'Iron Rods (tons)', 1, 230000, 230000.00, 'Online Transfer', '12mm - 2; BW - 1', '2015-02-09 09:03:52'),
(10, 'SSP960071', 'LSSZG1K90G', NULL, '2260', '', '', '', '', '', 'Granite (tons)', 3, 140000, 420000.00, 'Online Transfer', 'Casting of Raft foundation A', '2015-02-09 09:23:48'),
(11, 'SSP960071', 'OFECVGDCGI', NULL, '2966', '', '', '', '', '', 'Sharp sand', 5, 45000, 225000.00, 'Paid at the Bank', 'Casting of raft foundation another', '2020-07-15 22:59:20'),
(12, 'SSP960071', 'LSSZG1K90G', NULL, '7517', '', '', '', '', '', 'Granite (tons)', 3, 140000, 420000.00, 'Online Transfer', 'Casting of slab A and raft B', '2015-02-09 09:25:47'),
(13, 'SSP960071', 'LSSZG1K90G', NULL, '5259', '', '', '', '', '', 'Sharp sand', 3, 45000, 135000.00, 'Online Transfer', 'cast of slab A and raft B', '2015-02-09 09:26:37'),
(14, 'SSP960071', 'OUXT0V6QDK', NULL, '5071', '', '', '', '', '', 'plumbing pipes', 1, 50000, 50000.00, 'Online Transfer', 'for raft A and B', '2015-02-10 09:03:21'),
(16, 'SSP960071', 'LSSZG1K90G', NULL, '5376', '', '', '', '', '', 'granite - 30tons', 2, 140000, 280000.00, 'Online Transfer', 'two trailer loads of granite for casting', '2015-02-24 08:39:25'),
(17, 'SSP960071', 'LSSZG1K90G', NULL, '5955', '', '', '', '', '', 'sharp sand - 20ton ', 3, 45000, 135000.00, 'Online Transfer', '3 trips of 20ton tippers', '2015-02-24 08:41:30'),
(18, 'SSP960071', 'LSSZG1K90G', NULL, '7908', '', '', '', '', '', 'filling sand', 3, 26000, 78000.00, 'Online Transfer', '3 loads of 20ton filling sand', '2015-02-24 08:42:24'),
(19, 'SSP960071', 'NQLPSCJSWS', NULL, '1456', '', '', '', '', '', 'Marine Boards', 100, 6000, 600000.00, 'Online Transfer', 'Procured directly from Amu', '2015-02-24 10:00:01'),
(20, 'SSP960071', 'NQLPSCJSWS', NULL, '4563', '', '', '', '', '', '2by2', 280, 280, 78400.00, 'Online Transfer', 'for raft formwork bought directly from Agungi', '2015-02-24 10:01:45'),
(21, 'SSP960071', 'NQLPSCJSWS', NULL, '6979', '', '', '', '', '', '1by12 softwood', 224, 1000, 224000.00, 'Online Transfer', 'foundation works', '2015-02-24 10:04:40'),
(22, 'SSP960071', 'NQLPSCJSWS', NULL, '1945', '', '', '', '', '', '2by3', 100, 320, 32000.00, 'Online Transfer', 'plank for raft', '2015-02-24 10:05:25'),
(23, 'SSP960071', 'NQLPSCJSWS', NULL, '5313', '', '', '', '', '', 'nails', 10, 5000, 50000.00, 'Online Transfer', 'nails from foundation to current level', '2015-02-24 10:06:26'),
(24, 'SSP960071', 'NQLPSCJSWS', NULL, '3699', '', '', '', '', '', 'filling sand - 20tons', 40, 26000, 1040000.00, 'Online Transfer', 'for raft foundation', '2015-02-24 10:23:59'),
(25, 'SSP960071', 'HMPHA115X5', NULL, '6336', '', '', '', '', '', 'iron -in tons', 6, 120000, 720000.00, 'Online Transfer', 'iron for foundation and columns', '2015-02-24 10:35:54'),
(26, 'SSP960071', 'HMPHA115X5', NULL, '570', '', '', '', '', '', 'binding wire', 7, 7000, 49000.00, 'Online Transfer', 'all binding wire used so far', '2015-02-24 10:36:47'),
(29, 'SSP627497', 'OUXT0V6QDK', NULL, '9488', '', '', '', '', '', 'Dulux Paint Drum', 6, 12300, 73800.00, '', 'I have reduced your request from 7drums to 6 drums. The money will be transfered into your account shortly. Please acknowledge when you get this', '2015-03-09 10:37:17'),
(30, 'SSP627497', 'OUXT0V6QDK', NULL, '1161', '', '', '', '', '', 'Iron rod', 200, 4500, 900000.00, '', 'try it 12', '2015-03-09 11:20:05'),
(31, 'SSP627497', 'OUXT0V6QDK', NULL, '204', '', '', '', '', '', 'Iron rod', 200, 4500, 900000.00, '', 'TESTING 6754', '2015-03-09 12:01:53'),
(32, 'SSP960071', 'NQLPSCJSWS', NULL, '5327', '', '', '', '', '', 'plumbing materials - sundry', 1, 115000, 115000.00, 'Online Transfer', 'money transferred directly t plumber. materials for decking of A and B', '2015-04-06 06:01:25'),
(33, 'SSP960071', 'LSSZG1K90G', NULL, '3178', '', '', '', '', '', 'granite - 30tons', 4, 140000, 560000.00, 'Online Transfer', '4 30ton granite for deckings A and B', '2015-04-06 06:21:25'),
(34, 'SSP960071', 'LSSZG1K90G', NULL, '7643', '', '', '', '', '', 'sharp sand - 20ton ', 6, 45000, 270000.00, 'Online Transfer', '6 20ton sharp sand for decking A and B', '2015-04-06 06:22:33'),
(35, 'SSP960071', 'HMPHA115X5', NULL, '1760', '', '', '', '', '', 'iron -in tons', 16, 120000, 1920000.00, 'Online Transfer', 'average pricing per ton for two decking A and B', '2015-04-06 06:32:01'),
(36, 'SSP960071', 'HMPHA115X5', NULL, '6399', '', '', '', '', '', 'binding wire', 8, 7000, 56000.00, 'Online Transfer', 'binding wire for decking A and B', '2015-04-06 06:35:26'),
(37, 'SSP960071', 'NQLPSCJSWS', NULL, '2839', '', '', '', '', '', 'Marine Boards', 100, 5500, 550000.00, 'Online Transfer', '100 additional boards for decking added to the ones removed from foundation', '2015-04-06 06:37:35'),
(38, 'SSP960071', 'NQLPSCJSWS', NULL, '5848', '', '', '', '', '', 'packing case', 100, 1400, 140000.00, 'Online Transfer', 'wood plus transport plus slicing', '2015-04-06 06:40:23'),
(39, 'SSP960071', 'NQLPSCJSWS', NULL, '6515', '', '', '', '', '', 'bamboo', 90, 350, 31500.00, 'Cash', 'plus transport', '2015-04-06 06:41:40'),
(40, 'SSP960071', 'XA8WOW2PSM', NULL, '6306', '', '', '', '', '', 'planks and nails', 1, 272000, 272000.00, 'Online Transfer', 'planks and nails for decking first floor. 12th march supply1', '2015-04-06 08:28:39'),
(41, 'SSP960071', 'XA8WOW2PSM', NULL, '6492', '', '', '', '', '', 'planks and nails', 1, 156200, 156200.00, 'Online Transfer', 'planks and nails for decking first floor. 17th march supply2', '2015-04-06 08:29:33'),
(42, 'SSP960071', 'XA8WOW2PSM', NULL, '473', '', '', '', '', '', 'planks and nails', 1, 190600, 190600.00, 'Online Transfer', 'planks and nails for decking first floor. 23rd march supply3', '2015-04-06 08:30:35'),
(43, 'SSP960071', 'QKMLR64PQJ', NULL, '287', '', '', '', '', '', 'bamboo', 500, 350, 175000.00, 'Online Transfer', '177K paid on 12th march decking first floor1', '2015-04-06 08:42:37'),
(44, 'SSP960071', 'QKMLR64PQJ', NULL, '5554', '', '', '', '', '', 'bamboo', 200, 350, 70000.00, 'Online Transfer', '79K paid on 23rd march decking first floor2', '2015-04-06 08:44:07'),
(45, 'SSP960071', '7ORAQA9WY7', NULL, '5771', '', '', '', '', '', '6inch blocks ', 1000, 170, 170000.00, 'Online Transfer', 'for A and B elf3', '2015-04-06 08:58:28'),
(46, 'SSP960071', '7ORAQA9WY7', NULL, '6455', '', '', '', '', '', '9inch blocks', 2000, 180, 360000.00, 'Online Transfer', 'for A and B elf3', '2015-04-06 09:00:00'),
(47, 'SSP960071', '7ORAQA9WY7', NULL, '7090', '', '', '', '', '', 'cement', 0, 0, 0.00, 'Online Transfer', '600 bags supplied toward decking and continuation of project work', '2015-04-06 09:03:43'),
(48, 'SSP960071', 'GSIJV7ECKV', NULL, '2165', '', '', '', '', '', 'cement', 600, 1900, 1140000.00, 'Online Transfer', 'cement for decking and continuation of project work', '2015-04-06 09:11:32'),
(49, 'SSP774658', 'HMPHA115X5', NULL, '6660', '', '', '', '', '', 'Iron Rod', 200, 100, 20000.00, 'Cash', 'Testing 2019', '2019-09-01 22:17:35'),
(50, 'SSP960071', 'UFQJOPRTTX', NULL, '109', '', '', '', '', '', 'Test1212', 22, 300, 6600.00, 'Online Transfer', 'Testing testing', '2019-10-03 20:47:14'),
(51, 'SSP960071', '0HJPBJBBML', NULL, '7961', '', '', '', '', '', 'Tinker Tiles', 40, 70, 2800.00, 'Online Transfer', 'testing', '2020-07-11 19:33:16'),
(52, '', 'UFQJOPRTTX', NULL, 'MCPD-53514', '', '', '', '', '', 'Terrace Roof Lintel', 200, 70, 0.00, '', 'Testing909090', '2020-07-12 03:45:09'),
(53, '', 'HMPHA115X5', NULL, 'MCPD-26814', '', '', '', '', '', 'Tables for apt 4', 7, 3000, 21000.00, 'Online Transfer', 'ready now', '2020-07-12 04:03:50'),
(54, '', 'LSSZG1K90G', NULL, 'MCPD-43686', '', '', '', '', '', 'Sofa', 7, 4900, 34300.00, 'Online Transfer', 'Testing testing 8989', '2020-07-12 04:05:32'),
(55, 'SSP960071', 'URI1ZQNLJR', NULL, 'MCPD-23634', '', '', '', '', '', 'Tables for apt 4', 7, 3000, 21000.00, 'Cash', 'test on', '2020-07-13 01:42:36'),
(56, 'CPD403540', 'UFQJOPRTTX', NULL, 'MCPD-85175', '', '', '', '', '', 'Tiles', 1000, 70, 70000.00, 'Cash', 'testing testing', '2020-07-15 05:14:16'),
(57, 'CPD403540', '0HJPBJBBML', NULL, 'MCPD-85042', '', '', '', '', '', 'Tiles', 200, 1000, 200000.00, 'Cash', 'testing 8989', '2020-07-15 06:38:45'),
(58, 'SSP960071', 'NQLPSCJSWS', NULL, 'MCPD-15303', '', '', '', '', '', 'Maybe 11111', 40, 200, 8000.00, '', 'Testing 89', '2020-07-26 21:48:40'),
(59, 'SSP960071', 'NQLPSCJSWS', NULL, 'MCPD-52439', '', '', '', '', '', 'Maybe 111112', 40, 200, 8000.00, 'Transfer', 'Testing 89', '2020-07-26 21:49:43'),
(60, 'SSP135694', 'HMPHA115X5', NULL, 'MCPD-20694', '', '', '', '', '', 'binding wire', 500, 1500, 750000.00, 'Transfer', 'testing5656', '2020-07-31 03:06:56'),
(61, 'CPD141906', 'GUSEI1GTD7', NULL, 'MCPD-15221', '', '', '', '', '', 'Test tube', 1000, 150, 150000.00, 'Bank', 'testing testing 787878', '2020-07-31 06:46:27'),
(62, 'CPD537884', 'UFQJOPRTTX', 'Awesu', 'MCPD-85432', '', '', '', '', '', '9inch blocks 2000', 100, 150, 15000.00, 'Bank', 'testing testing 3454', '2020-08-21 05:29:37'),
(63, 'CPD537884', 'UFQJOPRTTX', 'Awesu', 'MCPD-58623', '', '', '', '', '', '9inch blocks 2000', 100, 150, 15000.00, 'Bank', 'testing testing 3454', '2020-08-21 05:29:50'),
(64, 'CPD537884', 'UFQJOPRTTX', 'Awesu', 'MCPD-72872', '', '', '', '', '', '9inch blocks 2000', 100, 150, 15000.00, 'Bank', 'testing testing 3454', '2020-08-21 05:34:14'),
(65, 'CPD374831', 'OUXT0V6QDK', 'Mankind Inc xxxxx', 'MCPD-77657', '', '', '', '', '', 'Checked Steel Plate 3X1200X1200mm', 3, 60, 180.00, 'Transfer', 'testing 5656', '2020-10-02 21:27:30'),
(66, 'CPD374831', 'OUXT0V6QDK', NULL, 'MCPD-16921', '', '', '', '', '', 'Iron Rods (tons)', 8, 0, 0.00, 'Online Transfer', 'HJHJ', '2021-09-20 14:19:42'),
(67, 'CPD374831', 'OUXT0V6QDK', NULL, 'MCPD-50091', '', '', '', '', '', 'Dulux Paint Drum', 22, 400, 8800.00, 'Online Transfer', 'OK', '2021-10-15 07:57:07');

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

--
-- Table structure for table `material_subtype`
--

CREATE TABLE `material_subtype` (
  `subTypeId` int(11) NOT NULL,
  `subTypeDesc` varchar(255) DEFAULT NULL,
  `materialTypeId` int(11) NOT NULL,
  `dimention` varchar(50) DEFAULT NULL,
  `subtype_catergory` varchar(50) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `material_subtype`
--

INSERT INTO `material_subtype` (`subTypeId`, `subTypeDesc`, `materialTypeId`, `dimention`, `subtype_catergory`, `createdOn`, `createdBy`) VALUES
(1, 'Hard Wood', 1, '2X2 Inches', '', '2020-09-02 21:13:46', 'Adebola'),
(2, 'Hard Wood', 1, '2X3 Inches', '', '2020-09-02 21:13:46', 'Adebola'),
(3, 'Hard Word', 1, '2X4 Inches', '', '2020-09-02 21:16:07', 'Adebola'),
(4, 'Hard Wood', 1, '2X6 Inches', '', '2020-09-02 21:16:07', 'Adebola'),
(5, 'Hard Wood', 1, '3X4 Inches', '', '2020-09-02 21:16:07', 'Adebola'),
(6, 'Hard Wood', 1, '1X12 Inches', '', '2020-09-02 21:16:07', 'Adebola'),
(7, 'Concrete Reinforcement', 2, '6mm', '', '2020-09-02 21:23:01', 'Adebola'),
(8, 'Concrete Reinforcement', 2, '8mm', '', '2020-09-02 21:23:01', 'Adebola'),
(9, 'Concrete Reinforcement', 2, '10mm', '', '2020-09-02 21:23:01', 'Adebola'),
(10, 'Concrete Reinforcement', 2, '12mm', '', '2020-09-02 21:23:01', 'Adebola'),
(11, 'Concrete Reinforcement', 2, '16mm', '', '2020-09-02 21:23:01', 'Adebola'),
(12, 'Concrete Reinforcement', 2, '20mm', '', '2020-09-02 21:23:01', 'Adebola'),
(13, 'Concrete Reinforcement', 2, '25mm', '', '2020-09-02 21:23:01', 'Adebola'),
(14, 'Square Rod', 2, '8mm', '', '2020-09-02 21:26:46', 'Adebola'),
(15, 'Square Rod', 2, '10mm', '', '2020-09-02 21:26:46', 'Adebola'),
(16, 'Square Rod', 2, '12mm', '', '2020-09-02 21:26:46', 'Adebola'),
(17, 'Square Rod', 2, '16mm', '', '2020-09-02 21:26:46', 'Adebola'),
(18, 'Square Rod', 2, '18mm', '', '2020-09-02 21:26:46', 'Adebola'),
(19, 'Round Rod', 2, '6mm', '', '2020-09-02 21:27:46', 'Adebola'),
(20, 'Round Rod', 2, '8mm', '', '2020-09-02 21:27:46', 'Adebola'),
(21, 'Round Rod', 2, '10mm', '', '2020-09-02 21:27:46', 'Adebola'),
(22, 'Round Rod', 2, '12mm', '', '2020-09-02 21:27:46', 'Adebola'),
(23, 'Flat Bars', 2, '2X25mm', '', '2020-09-02 21:33:09', 'Adebola'),
(24, 'Flat Bars', 2, '2X40mm', '', '2020-09-02 21:33:09', 'Adebola'),
(25, 'Flat Bars', 2, '2X50mm', '', '2020-09-02 21:33:09', 'Adebola'),
(26, 'Flat Bars', 2, '2X60mm', '', '2020-09-02 21:33:09', 'Adebola'),
(27, 'Flat Bars', 2, '2X75mm', '', '2020-09-02 21:33:09', 'Adebola'),
(28, 'Flat Bars', 2, '2X100mm', '', '2020-09-02 21:33:09', 'Adebola'),
(29, 'Flat Bars', 2, '3X25mm', '', '2020-09-02 21:33:09', 'Adebola'),
(30, 'Flat Bars', 2, '3X40mm', '', '2020-09-02 21:33:09', 'Adebola'),
(31, 'Flat Bars', 2, '3X50mm', '', '2020-09-02 21:33:09', 'Adebola'),
(32, 'Flat Bars', 2, '3X60mm', '', '2020-09-02 21:33:09', 'Adebola'),
(33, 'Flat Bars', 2, '3X75mm', '', '2020-09-02 21:33:09', 'Adebola'),
(34, 'Flat Bars', 2, '3X100mm', '', '2020-09-02 21:33:09', 'Adebola'),
(35, 'Flat Bars', 2, '4X25mm', '', '2020-09-02 21:39:34', 'Adebola'),
(36, 'Flat Bars', 2, '4X40mm', '', '2020-09-02 21:39:34', 'Adebola'),
(37, 'Flat Bars', 2, '4X50mm', '', '2020-09-02 21:39:34', 'Adebola'),
(38, 'Flat Bars', 2, '4X60mm', '', '2020-09-02 21:39:34', 'Adebola'),
(39, 'Flat Bars', 2, '4X75mm', '', '2020-09-02 21:39:34', 'Adebola'),
(40, 'Flat Bars', 2, '4X100mm', '', '2020-09-02 21:39:34', 'Adebola'),
(41, 'Flat Bars', 2, '5X25mm', '', '2020-09-02 21:39:34', 'Adebola'),
(42, 'Flat Bars', 2, '5X40mm', '', '2020-09-02 21:39:34', 'Adebola'),
(43, 'Flat Bars', 2, '5X50mm', '', '2020-09-02 21:39:34', 'Adebola'),
(44, 'Flat Bars', 2, '5X60mm', '', '2020-09-02 21:39:34', 'Adebola'),
(45, 'Flat Bars', 2, '5X75mm', '', '2020-09-02 21:39:34', 'Adebola'),
(46, 'Flat Bars', 2, '5X100mm', '', '2020-09-02 21:39:34', 'Adebola'),
(47, 'Flat Bars', 2, '6X25mm', '', '2020-09-02 21:39:34', 'Adebola'),
(48, 'Flat Bars', 2, '6X40mm', '', '2020-09-02 21:39:34', 'Adebola'),
(49, 'Flat Bars', 2, '6X50mm', '', '2020-09-02 21:39:34', 'Adebola'),
(50, 'Flat Bars', 2, '6X60mm', '', '2020-09-02 21:39:35', 'Adebola'),
(51, 'Flat Bars', 2, '6X75mm', '', '2020-09-02 21:39:35', 'Adebola'),
(52, 'Flat Bars', 2, '6X100mm', '', '2020-09-02 21:39:35', 'Adebola'),
(53, 'Semi-hard Wood', 1, '2X2 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(54, 'Semi-hard Wood', 1, '2X3 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(55, 'Semi-hard Wood', 1, '2X4 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(56, 'Semi-hard Wood', 1, '2X6 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(57, 'Semi-hard Wood', 1, '3X4 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(58, 'Semi-hard Wood', 1, '1X12 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(59, 'Soft Wood', 1, '2X2 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(60, 'Soft Wood', 1, '2X3 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(61, 'Soft Wood', 1, '2X4 Inches', '', '2020-09-02 21:46:40', 'Adebola'),
(62, 'Soft Wood', 1, '2X6 Inches', '', '2020-09-02 21:46:41', 'Adebola'),
(63, 'Soft Wood', 1, '3X4 Inches', '', '2020-09-02 21:46:41', 'Adebola'),
(64, 'Soft Wood', 1, '1X12 Inches', '', '2020-09-02 21:46:41', 'Adebola'),
(65, 'Steel Plate', 2, '1X1200X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(66, 'Steel Plate', 2, '1X600X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(67, 'Steel Plate', 2, '1X1200X1200mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(68, 'Steel Plate', 2, '1X1200X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(69, 'Steel Plate', 2, '1X600X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(70, 'Steel Plate', 2, '1X1200X1200mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(71, 'Steel Plate', 2, '2X1200X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(72, 'Steel Plate', 2, '2X600X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(73, 'Steel Plate', 2, '2X1200X1200mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(74, 'Steel Plate', 2, '2X1200X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(75, 'Steel Plate', 2, '2X600X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(76, 'Steel Plate', 2, '2X1200X1200mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(77, 'Steel Plate', 2, '3X1200X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(78, 'Steel Plate', 2, '3X600X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(79, 'Steel Plate', 2, '3X1200X1200mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(80, 'Steel Plate', 2, '3X1200X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(81, 'Steel Plate', 2, '3X600X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(82, 'Steel Plate', 2, '3X1200X1200mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(83, 'Steel Plate', 2, '4X1200X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(84, 'Steel Plate', 2, '4X600X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(85, 'Steel Plate', 2, '4X1200X1200mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(86, 'Steel Plate', 2, '4X1200X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(87, 'Steel Plate', 2, '4X600X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(88, 'Steel Plate', 2, '4X1200X1200mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(89, 'Steel Plate', 2, '0.5X1200X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(90, 'Steel Plate', 2, '0.5X600X2400mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(91, 'Steel Plate', 2, '0.5X1200X1200mm', 'Checked', '2020-09-02 21:57:54', 'Adebola'),
(92, 'Steel Plate', 2, '0.5X1200X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(93, 'Steel Plate', 2, '0.5X600X2400mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(94, 'Steel Plate', 2, '0.5X1200X1200mm', 'Smooth', '2020-09-02 21:57:54', 'Adebola'),
(95, 'Nails', 8, '1 Inch', 'Aluminium', '2020-09-02 22:08:09', 'Adebola'),
(96, 'Nails', 8, '2 Inches', 'Aluminium', '2020-09-02 22:08:09', 'Adebola'),
(97, 'Nails', 8, '2.5 Inches', 'Aluminium', '2020-09-02 22:08:09', 'Adebola'),
(98, 'Nails', 8, '3 Inches', 'Aluminium', '2020-09-02 22:08:09', 'Adebola'),
(99, 'Nails', 8, '4 Inches', 'Aluminium', '2020-09-02 22:08:09', 'Adebola'),
(100, 'Nails', 8, '5 Inches', 'Aluminium', '2020-09-02 22:08:09', 'Adebola'),
(101, 'Nails', 8, '1 Inch', 'Tornado', '2020-09-02 22:08:09', 'Adebola'),
(102, 'Nails', 8, '2 Inches', 'Tornado', '2020-09-02 22:08:09', 'Adebola'),
(103, 'Nails', 8, '2.5 Inches', 'Tornado', '2020-09-02 22:08:09', 'Adebola'),
(104, 'Nails', 8, '3 Inches', 'Tornado', '2020-09-02 22:08:09', 'Adebola'),
(105, 'Nails', 8, '4 Inches', 'Tornado', '2020-09-02 22:08:09', 'Adebola'),
(106, 'Nails', 8, '5 Inches', 'Tornado', '2020-09-02 22:08:09', 'Adebola'),
(107, 'Binding Wire', 5, '5Kg', '', '2020-09-02 22:16:22', 'Adebola'),
(108, 'Binding Wire', 5, '10Kg', '', '2020-09-02 22:16:23', 'Adebola'),
(109, 'Binding Wire', 5, '20Kg', '', '2020-09-02 22:16:23', 'Adebola'),
(110, 'Steel Pipe', 2, '0.5X25X25mm', '', '2020-09-02 22:28:06', 'Adebola'),
(111, 'Steel Pipe', 2, '0.5X25X50mm', '', '2020-09-02 22:28:06', 'Adebola'),
(112, 'Steel Pipe', 2, '0.5X25X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(113, 'Steel Pipe', 2, '0.5X37.5X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(114, 'Steel Pipe', 2, '0.5X50X100mm', '', '2020-09-02 22:28:06', 'Adebola'),
(115, 'Steel Pipe', 2, '1X25X25mm', '', '2020-09-02 22:28:06', 'Adebola'),
(116, 'Steel Pipe', 2, '1X25X50mm', '', '2020-09-02 22:28:06', 'Adebola'),
(117, 'Steel Pipe', 2, '1X25X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(118, 'Steel Pipe', 2, '1X37.5X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(119, 'Steel Pipe', 2, '1X50X100mm', '', '2020-09-02 22:28:06', 'Adebola'),
(120, 'Steel Pipe', 2, '2X25X25mm', '', '2020-09-02 22:28:06', 'Adebola'),
(121, 'Steel Pipe', 2, '2X25X50mm', '', '2020-09-02 22:28:06', 'Adebola'),
(122, 'Steel Pipe', 2, '2X25X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(123, 'Steel Pipe', 2, '2X37.5X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(124, 'Steel Pipe', 2, '2X50X100mm', '', '2020-09-02 22:28:06', 'Adebola'),
(125, 'Steel Pipe', 2, '3X25X25mm', '', '2020-09-02 22:28:06', 'Adebola'),
(126, 'Steel Pipe', 2, '3X25X50mm', '', '2020-09-02 22:28:06', 'Adebola'),
(127, 'Steel Pipe', 2, '3X25X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(128, 'Steel Pipe', 2, '3X37.5X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(129, 'Steel Pipe', 2, '3X50X100mm', '', '2020-09-02 22:28:06', 'Adebola'),
(130, 'Steel Pipe', 2, '4X25X25mm', '', '2020-09-02 22:28:06', 'Adebola'),
(131, 'Steel Pipe', 2, '4X25X50mm', '', '2020-09-02 22:28:06', 'Adebola'),
(132, 'Steel Pipe', 2, '4X25X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(133, 'Steel Pipe', 2, '4X37.5X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(134, 'Steel Pipe', 2, '4X50X100mm', '', '2020-09-02 22:28:06', 'Adebola'),
(135, 'Steel Pipe', 2, '5X25X25mm', '', '2020-09-02 22:28:06', 'Adebola'),
(136, 'Steel Pipe', 2, '5X25X50mm', '', '2020-09-02 22:28:06', 'Adebola'),
(137, 'Steel Pipe', 2, '5X25X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(138, 'Steel Pipe', 2, '5X37.5X75mm', '', '2020-09-02 22:28:06', 'Adebola'),
(139, 'Steel Pipe', 2, '5X50X100mm', '', '2020-09-02 22:28:06', 'Adebola'),
(140, 'Round Pipe', 2, '0.5X12.5mm', '', '2020-09-02 22:32:23', 'Adebola'),
(141, 'Round Pipe', 2, '0.5X18.7mm', '', '2020-09-02 22:32:24', 'Adebola'),
(142, 'Round Pipe', 2, '0.5X25mm', '', '2020-09-02 22:32:24', 'Adebola'),
(143, 'Round Pipe', 2, '0.5X37.5mm', '', '2020-09-02 22:32:24', 'Adebola'),
(144, 'Round Pipe', 2, '0.5X50mm', '', '2020-09-02 22:32:24', 'Adebola'),
(145, 'Round Pipe', 2, '0.5X75mm', '', '2020-09-02 22:32:24', 'Adebola'),
(146, 'Round Pipe', 2, '0.5X100mm', '', '2020-09-02 22:32:24', 'Adebola'),
(147, 'Round Pipe', 2, '0.5X125mm', '', '2020-09-02 22:32:24', 'Adebola'),
(148, 'Round Pipe', 2, '0.5X150mm', '', '2020-09-02 22:32:24', 'Adebola'),
(149, 'Round Pipe', 2, '1X12.5mm', '', '2020-09-02 22:34:04', 'Adebola'),
(150, 'Round Pipe', 2, '1X18.7mm', '', '2020-09-02 22:34:04', 'Adebola'),
(151, 'Round Pipe', 2, '1X25mm', '', '2020-09-02 22:34:04', 'Adebola'),
(152, 'Round Pipe', 2, '1X37.5mm', '', '2020-09-02 22:34:04', 'Adebola'),
(153, 'Round Pipe', 2, '1X50mm', '', '2020-09-02 22:34:04', 'Adebola'),
(154, 'Round Pipe', 2, '1X75mm', '', '2020-09-02 22:34:04', 'Adebola'),
(155, 'Round Pipe', 2, '1X100mm', '', '2020-09-02 22:34:04', 'Adebola'),
(156, 'Round Pipe', 2, '1X125mm', '', '2020-09-02 22:34:04', 'Adebola'),
(157, 'Round Pipe', 2, '1X150mm', '', '2020-09-02 22:34:04', 'Adebola'),
(158, 'Round Pipe', 2, '2X12.5mm', '', '2020-09-02 22:36:00', 'Adebola'),
(159, 'Round Pipe', 2, '2X18.7mm', '', '2020-09-02 22:36:00', 'Adebola'),
(160, 'Round Pipe', 2, '2X25mm', '', '2020-09-02 22:36:00', 'Adebola'),
(161, 'Round Pipe', 2, '2X37.5mm', '', '2020-09-02 22:36:00', 'Adebola'),
(162, 'Round Pipe', 2, '2X50mm', '', '2020-09-02 22:36:00', 'Adebola'),
(163, 'Round Pipe', 2, '2X75mm', '', '2020-09-02 22:36:00', 'Adebola'),
(164, 'Round Pipe', 2, '2X100mm', '', '2020-09-02 22:36:00', 'Adebola'),
(165, 'Round Pipe', 2, '2X125mm', '', '2020-09-02 22:36:00', 'Adebola'),
(166, 'Round Pipe', 2, '2X150mm', '', '2020-09-02 22:36:00', 'Adebola'),
(167, 'Round Pipe', 2, '3X12.5mm', '', '2020-09-02 22:40:17', 'Adebola'),
(168, 'Round Pipe', 2, '3X18.7mm', '', '2020-09-02 22:40:17', 'Adebola'),
(169, 'Round Pipe', 2, '3X25mm', '', '2020-09-02 22:40:17', 'Adebola'),
(170, 'Round Pipe', 2, '3X37.5mm', '', '2020-09-02 22:40:17', 'Adebola'),
(171, 'Round Pipe', 2, '3X50mm', '', '2020-09-02 22:40:17', 'Adebola'),
(172, 'Round Pipe', 2, '3X75mm', '', '2020-09-02 22:40:17', 'Adebola'),
(173, 'Round Pipe', 2, '3X100mm', '', '2020-09-02 22:40:17', 'Adebola'),
(174, 'Round Pipe', 2, '3X125mm', '', '2020-09-02 22:40:17', 'Adebola'),
(175, 'Round Pipe', 2, '3X150mm', '', '2020-09-02 22:40:17', 'Adebola'),
(176, 'Round Pipe', 2, '4X12.5mm', '', '2020-09-02 22:42:56', 'Adebola'),
(177, 'Round Pipe', 2, '4X18.7mm', '', '2020-09-02 22:42:56', 'Adebola'),
(178, 'Round Pipe', 2, '4X25mm', '', '2020-09-02 22:42:56', 'Adebola'),
(179, 'Round Pipe', 2, '4X37.5mm', '', '2020-09-02 22:42:56', 'Adebola'),
(180, 'Round Pipe', 2, '4X50mm', '', '2020-09-02 22:42:57', 'Adebola'),
(181, 'Round Pipe', 2, '4X75mm', '', '2020-09-02 22:42:57', 'Adebola'),
(182, 'Round Pipe', 2, '4X100mm', '', '2020-09-02 22:42:57', 'Adebola'),
(183, 'Round Pipe', 2, '4X125mm', '', '2020-09-02 22:42:57', 'Adebola'),
(184, 'Round Pipe', 2, '4X150mm', '', '2020-09-02 22:42:57', 'Adebola'),
(185, 'Round Pipe', 2, '5X12.5mm', '', '2020-09-02 22:45:08', 'Adebola'),
(186, 'Round Pipe', 2, '5X18.7mm', '', '2020-09-02 22:45:08', 'Adebola'),
(187, 'Round Pipe', 2, '5X25mm', '', '2020-09-02 22:45:08', 'Adebola'),
(188, 'Round Pipe', 2, '5X37.5mm', '', '2020-09-02 22:45:08', 'Adebola'),
(189, 'Round Pipe', 2, '5X50mm', '', '2020-09-02 22:45:08', 'Adebola'),
(190, 'Round Pipe', 2, '5X75mm', '', '2020-09-02 22:45:08', 'Adebola'),
(191, 'Round Pipe', 2, '5X100mm', '', '2020-09-02 22:45:09', 'Adebola'),
(192, 'Round Pipe', 2, '5X125mm', '', '2020-09-02 22:45:09', 'Adebola'),
(193, 'Round Pipe', 2, '5X150mm', '', '2020-09-02 22:45:09', 'Adebola');

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

--
-- Table structure for table `material_type`
--

CREATE TABLE `material_type` (
  `materialTypeId` int(11) NOT NULL,
  `materialTypeDesc` varchar(255) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `material_type`
--

INSERT INTO `material_type` (`materialTypeId`, `materialTypeDesc`, `createdOn`, `createdBy`) VALUES
(1, 'Wood', '2020-09-02 21:10:17', 'Adebola Salami'),
(2, 'Steel Material', '2020-09-02 21:10:17', 'Adebola Salami'),
(3, 'Galvanized Steel', '2020-09-02 21:10:17', 'Adebola Salami'),
(4, 'PVC', '2020-09-02 21:10:17', 'Adebola Salami'),
(5, 'Binding Wire', '2020-09-02 21:10:17', 'Adebola Salami'),
(6, 'Bambo', '2020-09-02 21:10:17', 'Adebola Salami'),
(7, 'Cement', '2020-09-02 21:10:17', 'Adebola Salami'),
(8, 'Nails', '2020-09-02 21:10:17', 'Adebola Salami'),
(9, 'Others', '2020-09-02 21:10:17', 'Adebola Salami');

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `menu_id` int(11) NOT NULL,
  `menu_name` varchar(100) DEFAULT NULL,
  `menu_url` varchar(200) DEFAULT NULL,
  `menu_icon` varchar(30) DEFAULT NULL,
  `active` enum('Y','N') DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



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

--
-- Table structure for table `newspapers`
--

CREATE TABLE `newspapers` (
  `id` int(11) NOT NULL,
  `newsPapersID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `newspapers`
--

INSERT INTO `newspapers` (`id`, `newsPapersID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'NEWS031', 45.00, 45.00, '2017-12-30'),
(2, 'NEWS031', 12.00, 23.00, '2017-12-30'),
(3, 'NEWS031', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `idno` int(11) NOT NULL,
  `logdate` timestamp NULL DEFAULT current_timestamp(),
  `userid` varchar(20) NOT NULL,
  `action_on` varchar(200) DEFAULT NULL,
  `note` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `overshort`
--

CREATE TABLE `overshort` (
  `id` int(11) NOT NULL,
  `overShortID` varchar(70) DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `overshort`
--

INSERT INTO `overshort` (`id`, `overShortID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'OVER029', 45.00, 23.00, '2017-12-30'),
(2, 'OVER029', 45.00, 23.00, '2017-12-30'),
(3, 'OVER029', 0.00, 0.00, '2017-12-30'),
(4, 'OVER029', 65.00, 45.00, '2017-12-30'),
(5, 'OVER029', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `idno` int(11) NOT NULL,
  `job_code` varchar(20) NOT NULL,
  `w_code` varchar(20) DEFAULT NULL,
  `project_code` varchar(20) NOT NULL,
  `amount_paid` float(12,2) DEFAULT NULL,
  `date_paid` date DEFAULT NULL,
  `bankTo` varchar(100) DEFAULT NULL,
  `payment_mode` varchar(20) DEFAULT NULL,
  `status` varchar(2) DEFAULT 'N',
  `date_inserted` datetime DEFAULT NULL,
  `comment` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`idno`, `job_code`, `w_code`, `project_code`, `amount_paid`, `date_paid`, `bankTo`, `payment_mode`, `status`, `date_inserted`, `comment`) VALUES
(4, 'AY3VP9GV91M4', 'SSW8617', 'SSP960071', 60000.00, '2015-02-02', '', 'Online Transfer', 'N', '2015-02-09 09:32:31', 'job completed and full payment made'),
(3, '6BVV0XRECCKV', 'SSW2957', 'SSP960071', 80000.00, '2015-02-09', '', 'Online Transfer', 'N', '2015-02-09 06:04:42', 'Casting to be done tomorrow tenth'),
(5, '', 'SSW9550', 'SSP960071', 60000.00, '2015-02-10', '', 'Cash', 'N', '2015-02-10 14:45:30', 'testing'),
(6, '6BVV0XRECCKV', 'SSW2957', 'SSP960071', 85000.00, '2015-02-23', '', 'Online Transfer', 'N', '2015-02-24 10:57:35', 'all outstanding on foundation paid'),
(7, '1KKQSVDFGDVI', 'SSW4821', 'SSP960071', 30000.00, '2015-02-23', '', 'Cash', 'N', '2015-02-24 11:08:57', '30k advance paid.'),
(8, 'RHOCWV4FZNMJ', 'SSW1410', 'SSP960071', 65000.00, '2015-02-19', '', 'Cash', 'N', '2015-02-24 11:11:19', 'all payments completed on this job.'),
(9, 'ZLFUGTW1LXJG', 'SSW7251', 'SSP960071', 260000.00, '2015-02-23', '', 'Cash', 'N', '2015-02-24 11:18:22', 'payments for the two foundations added under Gbenga'),
(10, 'VHAAR6PKGGRI', 'SSW2957', 'SSP960071', 35000.00, '2015-02-21', '', 'Cash', 'N', '2015-02-24 11:21:33', 'columns for foundation A. fully paid.'),
(11, 'PNTSNGANRSIK', 'SSW9489', 'SSP960071', 240000.00, '2015-02-23', '', 'Online Transfer', 'N', '2015-02-24 15:08:14', 'two foundations A and B. Columns. paid fully'),
(13, 'H314IALKCGMB', 'SSW7251', 'SSP960071', 50000.00, '2015-02-27', '', 'Online Transfer', 'N', '2015-03-03 03:14:43', 'a balance of 10k when lintel is completed for B'),
(14, 'I7RWX5YO6K5U', 'SSW9489', 'SSP960071', 64000.00, '2015-02-27', '', 'Online Transfer', 'N', '2015-03-03 03:18:48', 'balance to be paid on completion of lintel for B'),
(15, 'CLSB8XK7GKWS', 'SSW3594', 'SSP135694', 120000.00, '2014-03-04', '', 'Online Transfer', 'N', '2015-03-03 09:12:14', 'testing'),
(16, 'CTI2GNVMGBIK', 'SSW6024', 'SSP627497', 50000.00, '2015-03-03', '', 'Paid at the Bank', 'N', '2015-03-09 10:23:10', 'test89'),
(17, 'ISA94BGBESMD', 'SSW8997', 'SSP960071', 15000.00, '2012-03-28', '', 'Online Transfer', 'N', '2015-04-06 06:04:20', 'first installment'),
(18, 'ISA94BGBESMD', 'SSW8997', 'SSP960071', 15000.00, '2015-04-04', '', 'Cash', 'N', '2015-04-06 06:05:13', '2nd installment'),
(19, 'ILJ4NBYNPKHF', 'SSW9489', 'SSP960071', 260000.00, '2015-04-01', '', 'Online Transfer', 'N', '2015-04-06 07:47:08', 'payment to date on the two deckings of first floor'),
(20, 'PVXENL0NGXCL', 'SSW7251', 'SSP960071', 195000.00, '2015-04-01', '', 'Online Transfer', 'N', '2015-04-06 08:02:32', 'as at today. Job 90% completed.'),
(21, 'ZKUTMMWVFHKR', 'SSW2470', 'SSP960071', 10000.00, '2015-03-02', '', 'Cash', 'N', '2015-04-06 08:08:13', '10k paid'),
(22, 'BYBMZK8PC1FF', 'SSW1410', 'SSP960071', 70000.00, '2015-04-01', '', 'Cash', 'N', '2015-04-06 08:15:26', 'payment to date'),
(23, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Transfer', 'Y', '2020-07-27 05:32:28', 'Renewal testing'),
(24, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Transfer', 'Y', '2020-07-27 05:36:24', 'Renewal testing'),
(25, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Transfer', 'Y', '2020-07-27 05:38:24', 'Renewal testing'),
(26, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Transfer', 'Y', '2020-07-27 05:44:13', 'Renewal testing'),
(27, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Bank', 'Y', '2020-07-27 05:45:29', 'Renewal testing'),
(28, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Bank', 'Y', '2020-07-27 05:48:10', 'Renewal testing'),
(29, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Bank', 'Y', '2020-07-27 05:50:29', 'Renewal testing'),
(30, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Bank', 'Y', '2020-07-27 05:52:40', 'Renewal testing'),
(31, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 10000.00, '2020-07-27', 'Polaris Bank Limited', 'Bank', 'Y', '2020-07-27 05:55:14', 'Renewal testing'),
(32, 'BYBMZK8PC1FF', 'SSW1410', 'CPD537884', 40000.00, '2020-08-21', 'Zenith Bank', 'Cheque', 'Y', '2020-08-21 06:19:38', 'The agreed service charge was 40,000. Am going to approve 40,000'),
(33, 'BYBMZK8PC1FF', 'SSW1410', 'CPD537884', 40000.00, '2020-08-21', 'Zenith Bank', 'Cheque', 'Y', '2020-08-21 06:20:01', 'The agreed service charge was 40,000. Am going to approve 40,000');

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

--
-- Table structure for table `payout`
--

CREATE TABLE `payout` (
  `id` int(11) NOT NULL,
  `payoutID` varchar(70) DEFAULT NULL,
  `type` enum('C','D') DEFAULT NULL,
  `credit` float(10,2) DEFAULT NULL,
  `debit` float(10,2) DEFAULT NULL,
  `total` float(12,2) DEFAULT NULL,
  `dateAdded` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payout`
--

INSERT INTO `payout` (`id`, `payoutID`, `type`, `credit`, `debit`, `total`, `dateAdded`) VALUES
(1, 'PAYT005', NULL, 56.00, 56.00, NULL, '2017-12-28'),
(2, 'PAYT005', NULL, 45.00, 65.00, NULL, '2017-12-29'),
(3, 'PAYT005', NULL, 45.00, 65.00, NULL, '2017-12-29'),
(4, 'PAYT005', NULL, 54.00, 67.00, NULL, '2017-12-29'),
(5, 'PAYT005', NULL, 56.00, 56.00, NULL, '2017-12-29'),
(6, 'PAYT005', NULL, 56.00, 56.00, NULL, '2017-12-29'),
(7, 'PAYT005', NULL, 89.00, 90.00, NULL, '2017-12-29'),
(8, 'PAYT005', NULL, 89.00, 90.00, NULL, '2017-12-29'),
(9, 'PAYT005', NULL, 89.00, 90.00, NULL, '2017-12-29'),
(10, 'PAYT005', NULL, 89.00, 90.00, NULL, '2017-12-29'),
(11, 'PAYT005', NULL, 89.00, 90.00, NULL, '2017-12-29'),
(12, 'PAYT005', NULL, 78.00, 98.00, NULL, '2017-12-29'),
(13, 'PAYT005', NULL, 78.00, 98.00, NULL, '2017-12-29'),
(14, 'PAYT005', NULL, 78.00, 98.00, NULL, '2017-12-29'),
(15, 'PAYT005', NULL, 78.00, 98.00, NULL, '2017-12-29'),
(16, 'PAYT005', NULL, 78.00, 98.00, NULL, '2017-12-29'),
(17, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(18, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(19, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(20, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(21, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(22, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(23, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(24, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(25, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(26, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(27, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(28, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(29, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(30, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(31, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(32, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(33, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(34, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(35, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(36, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(37, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(38, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(39, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(40, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(41, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(42, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(43, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(44, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(45, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(46, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(47, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(48, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(49, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(50, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(51, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(52, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(53, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(54, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(55, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(56, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(57, 'PAYT005', NULL, 76.00, 98.00, NULL, '2017-12-30'),
(58, 'PAYT005', NULL, 0.00, 0.00, NULL, '2017-12-31');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `productId` varchar(10) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `dateAdded` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `productId`, `name`, `dateAdded`) VALUES
(1, 'BNKD001', 'Bank Deposit', '0000-00-00 00:00:00'),
(2, 'LOTP002', 'Lottery Payout', '2017-12-27 18:30:51'),
(3, 'LOTD003', 'Lottery Deposit', '2017-12-27 18:49:28'),
(4, 'REFD004', 'Refund', '2017-12-27 18:49:28'),
(5, 'PAYT005', 'Payout', '2017-12-27 18:49:28'),
(6, 'CTDT006', 'Credit/Debit Card', '2017-12-27 18:49:28'),
(7, 'ARCH007', 'AR or Charge', '2017-12-27 18:49:28'),
(8, 'EBTF008', 'EBT - Food Stamp', '2017-12-27 18:49:28'),
(9, 'SALES09', 'Sales Tax', '2017-12-27 18:49:28'),
(10, 'GASO010', 'Gasoline', '2017-12-27 18:49:28'),
(11, 'CIGA011', 'Cigarette', '2017-12-27 18:49:28'),
(12, 'SODA012', 'Soda', '2017-12-27 18:49:28'),
(13, 'DAIR013', 'Dairy', '2017-12-27 18:49:29'),
(14, 'COFF014', 'Coffee', '2017-12-27 18:49:29'),
(15, 'HBAO015', 'HBA', '2017-12-27 18:49:29'),
(16, 'CAND016', 'Candy', '2017-12-27 18:49:29'),
(17, 'GROC017', 'Grocery', '2017-12-27 19:07:08'),
(18, 'AUTO018', 'Auto', '2017-12-27 19:07:08'),
(19, 'ENER019', 'Energy Drink', '2017-12-27 19:07:08'),
(20, 'TEAO020', 'Tea', '2017-12-27 19:07:08'),
(21, 'JUIC021', 'Juice', '2017-12-27 19:07:08'),
(22, 'SNAC022', 'Snacks', '2017-12-27 19:07:08'),
(23, 'ICEC023', 'Ice Cream', '2017-12-27 19:07:08'),
(24, 'TOBA024', 'Tobacco', '2017-12-27 19:07:08'),
(25, 'WATE025', 'Water', '2017-12-27 19:07:08'),
(26, 'ICEO026', 'Ice', '2017-12-27 19:07:08'),
(27, 'LOTT027', 'Lottery', '2017-12-27 19:07:08'),
(28, 'COUP028', 'Coupons', '2017-12-27 19:07:08'),
(29, 'OVER029', 'Over/Short', '2017-12-27 19:07:08'),
(30, 'IPPO030', 'IPP', '2017-12-27 19:07:08'),
(31, 'NEWS031', 'Newspapers', '2017-12-27 19:07:08');

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

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `idno` int(11) NOT NULL,
  `project_name` varchar(250) DEFAULT NULL,
  `project_description` text DEFAULT NULL,
  `project_code` varchar(20) NOT NULL,
  `project_location` varchar(250) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `lga` varchar(255) DEFAULT NULL,
  `project_duration` varchar(10) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `project_supervisor` varchar(100) DEFAULT NULL,
  `supervisor_id` varchar(20) DEFAULT NULL,
  `createdBy` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project`
--

INSERT INTO `project` (`idno`, `project_name`, `project_description`, `project_code`, `project_location`, `address`, `city`, `state`, `lga`, `project_duration`, `start_date`, `end_date`, `comment`, `status`, `date_added`, `project_supervisor`, `supervisor_id`, `createdBy`) VALUES
(2, 'ELF3 - Abake Court', 'Testing testing yes', 'SSP960071', 'null', 'Lakeside River Road', 'Menphis', 'Ohio', 'ABJ', '10 Months', '2020-01-01', '2020-11-30', 'Two blocks of 8 fllats each.', 'Ongoing', '2021-10-15 07:45:22', '', '', ''),
(3, 'ELF1', 'High rise, apartment building', 'SSP238684', '5,Olakunle Olawuyi Street, Lekki 1, Lekki Lagos', 'Banana island', 'Lagos', 'Lagos State', 'Ikoyi', '10 Months', '2020-01-01', '2020-11-30', 'Two blocks of 8 fllats each.', 'Ongoing', '2015-02-14 13:56:21', NULL, NULL, ''),
(4, 'IKOYI OFFICE RENOVATION', NULL, 'SSP368434', '43 RAYMOND NJOKU STR, SW IKOYI, LAGOS', NULL, NULL, NULL, NULL, '', NULL, NULL, '', 'Ongoing', '2015-02-15 14:02:34', NULL, NULL, ''),
(5, 'UNAAB Hostel', NULL, 'SSP135694', 'Abeokuta', NULL, NULL, NULL, NULL, '12 months', NULL, NULL, 'This is an on-going project', 'Ongoing', '2015-03-03 09:09:10', NULL, NULL, ''),
(6, 'Testing 12345', NULL, 'SSP627497', 'Ajah new', NULL, NULL, NULL, NULL, '2months', NULL, NULL, 'on- going projectx', 'Ongoing', '2015-03-09 05:40:25', NULL, NULL, ''),
(7, 'ELF 6', NULL, 'SSP923374', '22, BOLUWATIFE STREET, S/W IKOYI, LAGOS', NULL, NULL, NULL, NULL, '12MONTHS', NULL, NULL, 'A TWIN DUPLEX', 'Ongoing', '2015-06-22 07:20:13', NULL, NULL, ''),
(8, 'Skyline Tower', NULL, 'SSP774658', 'Virginia', NULL, NULL, NULL, NULL, '18 Months', NULL, NULL, 'Testing', 'Ongoing', '2019-09-01 22:13:53', NULL, NULL, ''),
(17, 'RXD 1232 Apapa', NULL, 'SSP635392', 'Apapa Lagos', NULL, NULL, NULL, NULL, '24months', NULL, NULL, 'Testing 1212', 'Ongoing', '2019-10-02 10:18:12', NULL, NULL, ''),
(18, '', NULL, '', '', NULL, NULL, NULL, NULL, '', NULL, NULL, '', 'Ongoing', '2019-10-02 10:25:41', NULL, NULL, ''),
(19, '', NULL, '', '', NULL, NULL, NULL, NULL, '', NULL, NULL, '', 'Ongoing', '2019-10-02 10:41:07', NULL, NULL, ''),
(20, 'RXD 1245632 Text', NULL, 'SSP536363', 'Apapa Lagos', NULL, NULL, NULL, NULL, '36 Months', NULL, NULL, 'Testinh90', 'Ongoing', '2019-10-03 19:32:21', NULL, NULL, ''),
(21, 'Skyline', 'Testing testing 676', 'SSP767438', 'Falls Church', NULL, NULL, NULL, NULL, '24months', NULL, NULL, 'testing 89', '', '2019-10-19 21:45:09', NULL, NULL, ''),
(22, 'Skyline', 'Testing testing 676', 'SSP573440', 'Falls Church', NULL, NULL, NULL, NULL, '24months', NULL, NULL, 'testing 89', '', '2019-10-19 21:53:49', NULL, NULL, ''),
(23, 'Skyline Tower 21', 'Baileys High rise 21', 'SSP260243', 'Baileys Cross 21', NULL, NULL, NULL, NULL, '36 Months', NULL, NULL, 'Testing 8989 51', 'Completed', '2019-10-19 21:57:31', NULL, NULL, ''),
(24, 'Skyline Studio', 'Testing', 'SSP587729', 'Falls Church', NULL, NULL, NULL, NULL, '36 Months', NULL, NULL, 'Testing', 'Ongoing', '2019-10-20 22:05:13', NULL, NULL, ''),
(25, 'Skyline Tower 2', 'test67', 'CPD288446', 'Baileys Cross 2', NULL, NULL, NULL, NULL, '12 Months', '0000-00-00', '0000-00-00', 'test3', '', '2020-07-09 07:47:06', NULL, NULL, ''),
(26, 'Skyline Tower 2', 'test67', 'CPD730011', 'Baileys Cross 2', NULL, NULL, NULL, NULL, '12 Months', '0000-00-00', '0000-00-00', 'test3', '', '2020-07-09 07:48:44', NULL, NULL, ''),
(27, 'Skyline Tower 2', 'test67', 'CPD633732', 'Baileys Cross 2', NULL, NULL, NULL, NULL, '12 Months', '0000-00-00', '0000-00-00', 'test3', '', '2020-07-09 07:49:15', NULL, NULL, ''),
(28, 'GRA Office Renovation', 'Test34', 'CPD652083', 'GRA Ikeja', NULL, NULL, NULL, NULL, '36months', '0000-00-00', '0000-00-00', 'Test34342', '', '2020-07-09 07:51:50', NULL, NULL, ''),
(29, 'Louder T', 'TEST 89', 'CPD381552', 'Springhill T', NULL, NULL, NULL, NULL, '36months', '2020-08-08', '2020-03-12', 'READY', '', '2020-07-09 08:20:59', NULL, NULL, ''),
(30, 'Greyland', 'testing90', 'CPD346846', 'Manasseh', NULL, NULL, NULL, NULL, '12 Months', '2020-09-07', '2020-09-12', 'testing90', 'On-going', '2020-07-09 08:27:10', NULL, NULL, ''),
(31, 'High Cost Tower Renovation', 'testing 67', 'CPD271750', 'Bowie', NULL, NULL, NULL, NULL, '12 Months', '2020-08-01', '2020-12-31', 'testing 67', 'On-going', '2020-07-09 08:41:31', NULL, NULL, ''),
(32, 'Lekki Project 1', 'Testing 89', 'CPD569506', 'Lekki', NULL, NULL, NULL, NULL, '6 Months', '2020-08-07', '2021-01-31', 'testing 8989', 'On-going', '2020-07-09 18:57:41', NULL, NULL, ''),
(33, 'Graceland Kick off', 'testing6', 'CPD645503', 'GRA Ikeja', NULL, NULL, NULL, NULL, '6 Months', '2020-08-08', '2021-02-28', 'testing 7', 'On-going', '2020-07-09 18:59:47', NULL, NULL, ''),
(34, 'Lagoon Front Prject', 'testing 67', 'CPD852880', 'Victoria Island', NULL, NULL, NULL, NULL, '6 Months', '2020-08-07', '2020-11-30', 'testing 67', 'On-going', '2020-07-09 19:15:11', NULL, NULL, ''),
(35, 'Jingles Rerun', 'testing', 'CPD338590', 'Lestale', NULL, NULL, NULL, NULL, '6 Months', '2020-08-08', '2020-09-02', 'testing 5656', 'On-going', '2020-07-10 01:30:08', NULL, NULL, ''),
(36, 'High Cost Tower Renovation xx yes', 'testing 677 yes', 'CPD141906', 'Bowie Maryland yes', NULL, NULL, NULL, NULL, '9 Months', '2020-01-01', '2020-09-30', 'testing 677 yes', 'On-going', '2020-07-13 19:53:59', NULL, NULL, ''),
(37, 'High Cost Tower Renovation xx', 'testing 677', 'CPD205394', 'Bowie Maryland', NULL, NULL, NULL, NULL, '6 Months', '0000-00-00', '0000-00-00', 'testing 677', 'Completed', '2020-07-13 05:26:01', NULL, NULL, ''),
(38, 'High Cost Tower Renovation xx', 'testing 677', 'CPD667482', 'Bowie Maryland', NULL, NULL, NULL, NULL, '6 Months', '0000-00-00', '0000-00-00', 'testing 677', 'Completed', '2020-07-13 05:28:01', NULL, NULL, ''),
(39, 'High Cost Tower Renovation maybe', 'testing 679', 'CPD195139', 'Bowiex', NULL, NULL, NULL, NULL, '12 Months', '2020-01-05', '2020-12-31', 'testing 679', 'Completed', '2020-08-07 05:11:43', '', '', ''),
(40, 'High Cost Tower Renovation maybebe', 'testing 6798', 'CPD502772', 'Bowiexx', NULL, NULL, NULL, NULL, '6 Months', '0000-00-00', '0000-00-00', 'testing 6798', 'Completed', '2020-07-13 05:36:45', NULL, NULL, ''),
(41, 'ELF3 - Abake Court', 'testing 677', 'CPD830214', '9,Olakunle Olawuyi Street, Lekki 1, Lekki Lagos.', NULL, NULL, NULL, NULL, '12 months', '0000-00-00', '0000-00-00', 'Two blocks of 8 fllats each.', 'Ongoing', '2020-07-13 18:40:09', NULL, NULL, ''),
(42, 'High Cost Tower Renovation xxx', 'testing 67790', 'CPD954678', 'Bowie Marylandxx', NULL, NULL, NULL, NULL, '6 Months', '0000-00-00', '0000-00-00', 'testing 67790', 'Completed', '2020-07-13 19:16:50', NULL, NULL, ''),
(43, 'Maryland County Courtyard', 'Play yard', 'CPD403540', 'Riverdale', NULL, NULL, NULL, NULL, '12 Months', '2020-01-01', '2020-12-31', 'mentor ground', 'On-going', '2020-07-15 07:02:10', NULL, NULL, ''),
(44, 'Pentagon Inc', 'test6767', 'CPD647961', 'Virginia', NULL, NULL, NULL, NULL, '6 Months', '2020-03-01', '2020-11-30', 'testing 12345', 'On-going', '2020-07-29 00:36:27', 'Rhodax Reneex', 'UCPD98936711', ''),
(45, 'Jungle Reform', 'test 2341', 'CPD662668', 'Lekki', NULL, NULL, NULL, NULL, '12 Months', '2020-07-01', '2021-07-31', '76543e', 'On-going', '2020-07-29 02:06:11', 'Adewale Iwakun', 'SSREI004', ''),
(46, 'Mande Shopping Complex Renovation', 'testing testing', 'CPD230040', 'Ikeja', NULL, NULL, NULL, NULL, '12 Months', '2020-07-01', '2021-02-28', 'testing testing', 'On-going', '2020-07-29 02:08:44', 'Modupeola Salami', 'SSREI003', ''),
(47, 'Mande Shopping Complex Renovation', 'testing testing', 'CPD322400', 'Ikeja', NULL, NULL, NULL, NULL, '12 Months', '2020-07-01', '2021-02-28', 'testing testing', 'On-going', '2020-07-29 02:09:31', 'Modupeola Salami', 'SSREI003', ''),
(48, 'Malibu Renovation', 'Time is of the essence', 'CPD668889', 'Califonia', NULL, NULL, NULL, NULL, '12 Months', '2019-12-01', '2021-01-31', 'testing 676767', 'On-going', '2020-07-31 05:50:51', 'Kayode Adebesin', 'SSREI009', ''),
(49, 'Bode Peters ', 'Testing testing 454545', 'CPD374831', 'null', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'Alagbole', 'Lagos', 'Njaba', '6 Months', '2020-02-01', '2020-08-02', '1234567', 'On-going', '2021-10-15 07:57:35', 'Modupeola Salami', '', ''),
(50, 'Rocket Rail Construction', 'testing ', 'CPD415474', 'Baileys Cross 2', NULL, NULL, NULL, NULL, '17 Months', '2020-04-26', '2021-09-02', '12345 testing', 'On-going', '2020-08-07 05:45:08', '', '', ''),
(51, 'Lincoln Avenue Project', 'testing 5', 'CPD203311', 'Rogger Rode', NULL, NULL, NULL, NULL, '13 Months', '2020-09-01', '2021-10-05', 'testing 6', 'Finishing Stage', '2020-08-07 05:48:40', 'Remmy Jones', 'UCPD14234678', ''),
(52, 'Grange Atrium', 'Testing 34234', 'CPD358009', '', 'Danish Lane', 'Media', 'Virginia', 'Falls Church', '13 Months', '2020-08-20', '2021-09-01', 'Maybe later testing', 'On-going', '2020-08-09 05:51:03', 'Motunrayo Williams', 'SSREI008', ''),
(53, 'GRA Office Renovation II', 'Composite  head office renovation and furnishing', 'CPD537884', '', '18B Oladipo Bateye Street ', 'GRA Ikeja', 'Lagos', 'Ikeja', '4 Months', '2020-08-02', '2020-12-31', 'This project shall be completed in phases ', 'Site Prep', '2020-08-10 00:25:23', '', '', ''),
(54, 'Mason Hall Renovation xx', 'Testing phase 12', 'CPD952273', '', 'Teston Riner Road xx', 'Gilbert town ss', 'Maryland xx', 'Bowie xx', '11 Months', '2020-06-02', '2021-05-06', 'Real deal 23', 'On-going', '2020-08-10 05:36:37', '', '', ''),
(55, 'Little River Pike ', 'Testing 232', 'CPD652860', '', 'Teslar Road B', 'Falls Chaurch', 'Abeokuta', 'Eti Osa', '8 Months', '2020-10-01', '2021-06-01', 'testing2323', 'Site Prep', '2020-10-02 00:43:26', '', '', ''),
(56, 'maxwell', 'dsd', 'CPD632640', 'null', 'dsd', 'ds', 'dsd', 'ds', '0 Months', '2021-03-18', '2021-03-24', 'dsf', 'Site Prep', '2021-03-10 11:22:06', 'Rebel Wilson', 'UCPD63405573', ''),
(57, 'cook', 'dsdsd', 'CPD803069', 'null', 'dsdsd', 'dssd', 'dssds', 'dsdsd', '1 Months', '2021-03-11', '2021-04-30', 'dsdssd', 'Finishing Stage', '2021-03-10 18:00:16', 'Rebel Wilson', 'UCPD63405573', 'Adebola Salami'),
(58, 'Abuja', 'good', 'CPD515886', 'null', 'Abuj', 'abuj', 'abuj', 'abuja', '1 Months', '2021-03-12', '2021-04-13', 'good', 'On-going', '2021-03-12 14:38:59', 'Wale Daisi', 'SSREI006', 'Adebola Salami'),
(59, 'jbhjbhjb', 'hbhjbjhb', 'CPD987619', 'null', 'hbvghv', 'ghvgvgh', 'ghvghv', 'ghvghv', '0 Months', '2021-09-16', '2021-09-24', 'bhjbhjb', 'Site Prep', '2021-09-16 15:14:42', 'Makinde Young', 'UCPD91785445', 'Adebola Salami'),
(60, 'hhh', 'dsds', 'CPD172816', 'null', 'dsds', 'dsds', 'dsds', 'sds', '0 Months', '2021-09-20', '2021-09-30', 'dsds', 'Site Prep', '2021-09-20 13:05:33', 'Rhodax Reneex', '', 'Adebola Salami'),
(61, 'Man', 'Golden OGbeka', 'CPD839693', 'null', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'Alagbole', 'Select one', 'Njaba', '0 Months', '0000-00-00', '0000-00-00', 'LK', 'Site Prep', '2021-10-14 20:30:14', 'Rebel Wilson', 'UCPD63405573', 'Golden Ogbeka');

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

--
-- Table structure for table `project_comment`
--

CREATE TABLE `project_comment` (
  `comment_id` int(100) NOT NULL,
  `client_id` varchar(100) NOT NULL,
  `project_code` varchar(100) NOT NULL,
  `comment_code` varchar(100) NOT NULL,
  `sender_name` varchar(100) NOT NULL,
  `project_id` varchar(100) NOT NULL,
  `comment_title` varchar(100) NOT NULL,
  `comment` varchar(1000) NOT NULL,
  `status` varchar(100) CHARACTER SET utf8mb4 NOT NULL,
  `createdOn` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `project_comment_interactions`
--

CREATE TABLE `project_comment_interactions` (
  `interaction_id` int(100) NOT NULL,
  `comment_code` varchar(100) NOT NULL,
  `sender_name` varchar(100) NOT NULL,
  `sender_type` varchar(100) NOT NULL,
  `comment` varchar(1000) NOT NULL,
  `createdOn` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `project_no_of_flats`
--

CREATE TABLE `project_no_of_flats` (
  `flat_id` int(11) NOT NULL,
  `flat_code` varchar(20) DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `project_code` varchar(20) DEFAULT NULL,
  `flat_desc` varchar(100) DEFAULT NULL,
  `comment` text NOT NULL,
  `status` enum('Vacant','Occupied') NOT NULL DEFAULT 'Vacant',
  `date_add` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_no_of_flats`
--

INSERT INTO `project_no_of_flats` (`flat_id`, `flat_code`, `project_name`, `project_code`, `flat_desc`, `comment`, `status`, `date_add`) VALUES
(3, 'PFCLISPJBFK', 'ELF1', 'SSP238684', 'FLAT 1 - Ground Floor - 2-Bed Flat you', 'Ground Floor yous', 'Occupied', '2021-09-09 08:07:55'),
(4, 'PFCIOAP6V04', NULL, 'SSP238684', 'FLAT 2 - Ground Floor - 2-Bed Flat', 'Ground Floor Back', 'Occupied', '2015-06-11 07:59:45'),
(5, 'PFCH4FBXFYC', NULL, 'SSP238684', 'FLAT 3 - First Floor - 1-Bed Flat', 'First Floor', 'Occupied', '2015-06-11 08:00:29'),
(6, 'PFCOPMPYJ09', NULL, 'SSP238684', 'FLAT 5 - First Floor - 1-Bed Flat', 'First Floor Back', 'Occupied', '2015-06-11 08:01:13'),
(7, 'PFCHMCMO8KL', NULL, 'SSP238684', 'FLAT 4 - First Floor - 1-Bed Flat with Store', 'First Floor', 'Occupied', '2015-06-11 08:02:06'),
(8, 'PFCIJEJUJJL', NULL, 'SSP238684', 'FLAT 6 - First Floor - 1-Bed Flat with Store', 'First Floor', 'Occupied', '2015-06-11 08:02:47'),
(9, 'PFCQYYVTWKT', NULL, 'SSP238684', 'FLAT 7 - Pent Floor - 1-Bed Flat with big terrace', 'Penthouse', 'Occupied', '2015-06-11 08:03:55'),
(10, 'PFCCFNFSSQF', NULL, 'SSP238684', 'FLAT 8 - Pent Floor - 1-Bed Flat with big terrace', 'Penthouse', 'Occupied', '2015-06-11 08:04:40'),
(11, 'PFCK1EH0GHF', NULL, 'SSP627497', '3 Bedroom Duplex', 'testing', 'Occupied', '2015-06-16 05:20:56'),
(12, 'PFCYRGCXAUM', NULL, 'SSP627497', '2-Bed First Floor with store', 'testing testin', 'Occupied', '2015-06-16 06:48:11'),
(13, 'PFCOV3GR4VN', NULL, 'SSP627497', 'Pent House with Store', 'testing testing', 'Occupied', '2015-06-18 04:26:34'),
(14, 'PFCVPVYVJUN', NULL, 'SSP627497', 'Wing Apartment with storage', 'testing testing', 'Occupied', '2015-06-19 05:08:41'),
(15, 'FCPD97680307-2020', NULL, 'SSP238684', 'Second Floor 3 bedroom Duplex ', 'testing909090', 'Vacant', '2020-07-12 00:52:06'),
(16, 'FCPD90673107-2020', NULL, 'SSP238684', '4 bedroom Pent house', 'Newly renovated', 'Occupied', '2020-07-12 01:09:44'),
(17, 'FCPD33730407-2020', NULL, 'SSP960071', 'Studio Apartment First floor', 'This apartment is standalone at the back in the company', 'Occupied', '2020-07-27 17:45:54'),
(18, 'FCPD22479007-2020', 'IKOYI OFFICE RENOVATION', 'SSP368434', 'Pent House  67', 'Buyout or lease for 3 years minimum 78', 'Occupied', '2020-07-30 20:08:41'),
(19, 'FCPD24338907-2020', 'UNAAB Hostel', 'SSP135694', 'Ground floor front flat 2 bed', 'Testing continues', 'Occupied', '2020-07-30 20:03:33'),
(0, 'FCPD77396909-2021', 'Bode Peters ', 'CPD374831', 'GGLJKM', 'AA', 'Occupied', '2021-10-15 07:58:15');

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

--
-- Table structure for table `project_report`
--

CREATE TABLE `project_report` (
  `idno` int(11) NOT NULL,
  `report_code` varchar(50) DEFAULT NULL,
  `report_type` varchar(10) DEFAULT NULL,
  `created_for` varchar(50) DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `project_code` varchar(50) DEFAULT NULL,
  `project_supervisor` varchar(50) DEFAULT NULL,
  `report_summary` varchar(100) DEFAULT NULL,
  `challenges` text DEFAULT NULL,
  `solutions` text DEFAULT NULL,
  `recommendation` text DEFAULT NULL,
  `weekly_projection` text DEFAULT NULL,
  `materials_required_for_projection` text DEFAULT NULL,
  `materials_on_site` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `submitted_by` varchar(50) DEFAULT NULL,
  `submitted_on` datetime DEFAULT NULL,
  `visitor` text DEFAULT NULL,
  `weather` text DEFAULT NULL,
  `photograph` longblob DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_report`
--

INSERT INTO `project_report` (`idno`, `report_code`, `report_type`, `created_for`, `project_name`, `project_code`, `project_supervisor`, `report_summary`, `challenges`, `solutions`, `recommendation`, `weekly_projection`, `materials_required_for_projection`, `materials_on_site`, `status`, `submitted_by`, `submitted_on`, `visitor`, `weather`, `photograph`, `image_path`) VALUES
(1, 'RCPD119548', 'Weekly', 'Modupeola Salami', 'Bode Peters ', 'CPD374831', 'Modupeola Salami', 'hhh', 'hhh', 'hhh', 'hhh', 'hhh', 'hhh', 'hhh', 'hhh', 'Adebola&nbsp;Salami', '2021-02-26 11:25:45', 'hhh', 'hhh', 0x626c616e6b, 'blank'),
(2, 'RCPD370962', 'Weekly', 'Modupeola Salami', 'Bode Peters ', 'CPD374831', 'Modupeola Salami', 'man', 'man', 'man', 'man', 'man', 'man', 'man', 'man', 'Adebola&nbsp;Salami', '2021-02-26 13:00:56', 'vman', 'man', 0x626c616e6b, 'blank'),
(3, 'RCPD413077', 'Weekly', 'Modupeola Salami', 'Bode Peters ', 'CPD374831', 'Modupeola Salami', 'cvcv', 'cvcv', 'cvc', 'vcv', 'vcvc', 'vcv', 'vcv', 'vccv', 'Adebola&nbsp;Salami', '2021-02-26 13:10:37', 'vcvc', 'cvc', 0x626c616e6b, 'blank'),
(0, 'RCPD234498', 'Weekly', 'Modupeola Salami', 'Bode Peters ', 'CPD374831', 'Modupeola Salami', 'LKsaddGolden Ogbeka', 'DGolden Ogbeka', 'AGolden Ogbeka', 'Golden Ogbeka', 'Golden Ogbeka', 'Golden Ogbeka', 'Golden Ogbeka', 'Golden Ogbeka', 'Adebola Salami', '2021-10-15 08:06:19', 'Golden Ogbeka', 'DDGolden Ogbeka', 0x626c616e6b, 'blank');

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

--
-- Table structure for table `project_report_images`
--

CREATE TABLE `project_report_images` (
  `id` int(11) NOT NULL,
  `image_name` blob DEFAULT NULL,
  `projectFullPath` varchar(255) DEFAULT NULL,
  `projectCode` varchar(255) DEFAULT NULL,
  `imageOrder` varchar(200) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_report_images`
--

INSERT INTO `project_report_images` (`id`, `image_name`, `projectFullPath`, `projectCode`, `imageOrder`, `date_added`) VALUES
(2, 0x[encoded data, 38156 characters], NULL, NULL, NULL, '2021-01-02 18:20:49');
INSERT INTO `project_report_images` (`id`, `image_name`, `projectFullPath`, `projectCode`, `imageOrder`, `date_added`) VALUES
(3, 0x[encoded data, 38644 characters], NULL, NULL, NULL, '2021-01-02 18:22:27');
INSERT INTO `project_report_images` (`id`, `image_name`, `projectFullPath`, `projectCode`, `imageOrder`, `date_added`) VALUES
(5, 0x[encoded data, 39834 characters], NULL, NULL, NULL, '2021-01-02 19:20:00'),
(6, NULL, 'sunday-pic.5ff215dad178c2.35885209.png', 'SSP960071', '4', '2021-01-03 14:07:06'),
(7, NULL, 'mq-2.png.5ff217a4860793.26016729.png', 'SSP960071', '5', '2021-01-03 14:14:44'),
(8, NULL, 'logo_new.png.5ff21b880bf780.35883013.png', 'SSP960071', '6', '2021-01-03 14:31:20'),
(9, NULL, 'gallery.5ff21c351c0d05.02524584.png', 'SSP960071', '7', '2021-01-03 14:34:13'),
(10, NULL, 'gallery.5ff220047f0ed8.42494959.png', 'SSP960071', '8', '2021-01-03 14:50:28');
INSERT INTO `project_report_images` (`id`, `image_name`, `projectFullPath`, `projectCode`, `imageOrder`, `date_added`) VALUES
(11, 0x[encoded data, 40710 characters], 'gallery.5ff223d94fffa4.70086756.png', 'SSP960071', '9', '2021-01-03 15:06:49');
INSERT INTO `project_report_images` (`id`, `image_name`, `projectFullPath`, `projectCode`, `imageOrder`, `date_added`) VALUES
(12, 0x[encoded data, 131070 characters], 'gallery.5ff224c4d51123.19050642.png', 'SSP960071', '10', '2021-01-03 15:10:44');
