INSERT INTO `project_report_images` (`id`, `image_name`, `projectFullPath`, `projectCode`, `imageOrder`, `date_added`) VALUES
(13, 0x[encoded data, 38962 characters], 'gallery.5ff22509487987.74567243.png', 'SSP960071', '11', '2021-01-03 15:11:53');
INSERT INTO `project_report_images` (`id`, `image_name`, `projectFullPath`, `projectCode`, `imageOrder`, `date_added`) VALUES
(14, 0x[encoded data, 38998 characters], 'gallery.5ff226d3bb8889.65202833.png', 'SSP960071', '12', '2021-01-03 15:19:31');

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

--
-- Table structure for table `refund`
--

CREATE TABLE `refund` (
  `id` int(11) NOT NULL,
  `refundID` 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 `refund`
--

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

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

--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `idno` int(11) NOT NULL,
  `report_category` varchar(30) NOT NULL,
  `report_title` varchar(50) NOT NULL,
  `report_query` text NOT NULL,
  `fields_to_show` text NOT NULL,
  `date_field` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `request`
--

CREATE TABLE `request` (
  `idno` int(11) NOT NULL,
  `requestID` varchar(50) NOT NULL,
  `carttemp_sess` varchar(100) NOT NULL,
  `staffID` varchar(200) DEFAULT NULL,
  `staff_name` varchar(100) NOT NULL,
  `staff_email` varchar(100) NOT NULL,
  `request_type` varchar(50) DEFAULT NULL,
  `project_name` varchar(100) NOT NULL,
  `project_code` varchar(20) NOT NULL,
  `supCode` varchar(30) NOT NULL,
  `supplier_name` varchar(255) DEFAULT NULL,
  `sup_material` varchar(50) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `unit_price` float NOT NULL DEFAULT 0,
  `total_price` float NOT NULL DEFAULT 0,
  `worker_name` varchar(50) NOT NULL,
  `worker_code` varchar(20) NOT NULL,
  `worker_service` varchar(200) NOT NULL,
  `amount` float NOT NULL DEFAULT 0,
  `jobCode` varchar(20) NOT NULL,
  `comment` text NOT NULL,
  `response` text NOT NULL,
  `status` enum('Pending','Approved','Rejected','Recommended') NOT NULL DEFAULT 'Pending',
  `date` datetime DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `company_address` varchar(100) DEFAULT NULL,
  `contact_person` varchar(50) DEFAULT NULL,
  `contact_mobile` varchar(50) DEFAULT NULL,
  `ofc_phone` varchar(50) DEFAULT NULL,
  `cash_advance_purpose` varchar(255) DEFAULT NULL,
  `tool_name` varchar(255) DEFAULT NULL,
  `approved_by` varchar(50) DEFAULT NULL,
  `approved_on` datetime DEFAULT NULL,
  `approved_amount` float(12,2) DEFAULT NULL,
  `approved_quantity` int(11) DEFAULT NULL,
  `approved_unit_price` float(12,2) DEFAULT NULL,
  `approved_total_amount` float(12,2) DEFAULT NULL,
  `tool_machinery_type` varchar(50) DEFAULT NULL,
  `inventory_type_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `request`
--

INSERT INTO `request` (`idno`, `requestID`, `carttemp_sess`, `staffID`, `staff_name`, `staff_email`, `request_type`, `project_name`, `project_code`, `supCode`, `supplier_name`, `sup_material`, `description`, `quantity`, `unit_price`, `total_price`, `worker_name`, `worker_code`, `worker_service`, `amount`, `jobCode`, `comment`, `response`, `status`, `date`, `company`, `company_address`, `contact_person`, `contact_mobile`, `ofc_phone`, `cash_advance_purpose`, `tool_name`, `approved_by`, `approved_on`, `approved_amount`, `approved_quantity`, `approved_unit_price`, `approved_total_amount`, `tool_machinery_type`, `inventory_type_id`) VALUES
(1, 'REQCPD-B2WTDFCSWU-14102021', '', 'CLIENTKfopdNCr', 'Golden Ogbeka', 'ogbekagolden@gmail.com', 'Cash Advance - Project', 'Bode Peters ', 'CPD374831', '', '', '', '', 0, 0, 0, '', '', '', 123123, '', '', '', 'Pending', '2021-10-14 04:44:12', '', '', '', '', '', 'DD', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 0),
(2, 'REQCPD-DASR3NGJJX-14102021', '', 'CLIENTKfopdNCr', 'Golden Ogbeka', 'ogbekagolden@gmail.com', 'Material', 'Bode Peters ', 'CPD374831', 'UFQJOPRTTX', 'Awesu', '9inch blocks 2000', '', 22, 400, 8800, '', '', '', 0, '', '', '', 'Pending', '2021-10-14 04:45:17', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 0),
(3, 'REQCPD-UH6RXNAGFK-14102021', '', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 'ogbekagolden@gmail.com', 'Cash Advance - Office', 'Bode Peters ', 'CPD374831', '', '', '', 'MANN', 0, 0, 0, '', '', '', 123123, '', '', 'qweqw', 'Approved', '2021-10-14 04:49:19', '', '', '', '', '', 'DD', '', 'Golden Ogbeka', '2021-10-18 16:33:40', 0.00, NULL, NULL, NULL, '', 0),
(4, 'REQCPD-EDSWS0YVOY-18102021', '', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 'ogbekagolden@gmail.com', 'Cash Advance - Office', 'Bode Peters ', 'CPD374831', '', '', '', '', 0, 0, 0, '', '', '', 5000, '', 'I asked Aboki', '', 'Recommended', '2021-10-18 15:44:21', '', '', '', '', '', 'Shoe', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 0),
(5, 'REQCPD-XGNVQYUVYV-18102021', '', 'CLIENTnLJoiBhk', 'Golden Ogbeka', 'ogbekagolden@gmail.com', 'Tools and Machinery - Rent', 'Bode Peters ', 'CPD374831', 'OUXT0V6QDK', 'Mankind', 'Iron rod', 'BATEYE', 120, 123, 14760, '', '', '', 0, '', 'OKAY', '', 'Pending', '2021-10-18 17:17:54', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 0);

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

--
-- Table structure for table `rights`
--

CREATE TABLE `rights` (
  `idno` int(11) NOT NULL,
  `rightid` varchar(5) NOT NULL,
  `linkname` varchar(30) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(2) NOT NULL DEFAULT 'Y'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rights`
--

INSERT INTO `rights` (`idno`, `rightid`, `linkname`, `description`, `status`) VALUES
(1, '100', 'Add Worker', 'Add Worker', 'Y'),
(2, '101', 'Add Payment', 'Add Payment', 'Y'),
(55, '106', 'Add Material', 'Add Material', 'Y'),
(54, '104', 'Edit Project Info', 'Edit Project', 'Y'),
(53, '103', 'Approve Request', 'Approve Request\r\n', 'Y'),
(51, '102', 'Edit Worker Info', 'Edit Worker\r\n', 'Y'),
(50, '105', 'Edit Material Info', 'Edit Material', 'Y'),
(56, '107', 'Add Worker Job', 'Add Worker Job', 'Y'),
(57, '108', 'Edit Worker Job', 'Edit Worker Job', 'Y'),
(58, '109', 'Add Startup Cost', 'Add Startup Cost', 'Y'),
(59, '110', 'Edit Startup Cost', 'Edit Startup Cost', 'Y'),
(60, '111', 'Edit Supplier Info', 'Edit  Supplier Info', 'Y'),
(61, '112', 'Edit Request Info', 'Edit Request Info', 'Y'),
(62, '113', 'Decline Request', 'Decline Request\r\n', 'Y'),
(63, '114', 'Add Flat Details', 'Add Flat Details\r\n', 'Y'),
(64, '115', 'Add Tenant', 'Add Tenant\r\n', 'Y'),
(65, '118', 'View Tenants', 'View Tenants\r\n', 'Y'),
(66, '117', 'View Flat', 'View Flat\r\n', 'Y'),
(67, '119', 'Edit Flat Details', 'Edit Flat Details', 'Y'),
(68, '120', 'Approve Maintenance Request', 'Approve Maintenance Request', 'Y'),
(69, '121', 'Decline Maintenance Request', 'Decline Maintenance Request', 'Y'),
(70, '122', 'Confirm Maintenance Request', 'Confirm Maintenance Request', 'Y'),
(71, '123', 'Edit Request Response', 'Edit Request Response', 'Y'),
(72, '124', 'Edit Contractor Info', 'Edit Contractor Info', 'Y'),
(73, '125', 'Edit Stakeholder Info', 'Edit Stakeholder Info', 'Y'),
(74, '126', 'Add Job', 'Add Job', 'Y'),
(75, '127', 'Add Supplier Material', 'Add Supplier Material', 'Y'),
(76, '128', 'Add Tool & Machinery', 'Add Tool & Machinery', 'Y');

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

--
-- Table structure for table `salestax`
--

CREATE TABLE `salestax` (
  `id` int(11) NOT NULL,
  `salesTaxID` 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 `salestax`
--

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

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

--
-- Table structure for table `snacks`
--

CREATE TABLE `snacks` (
  `id` int(11) NOT NULL,
  `snackID` 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 `snacks`
--

INSERT INTO `snacks` (`id`, `snackID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'SNAC022', 67.00, 12.00, '2017-12-29'),
(2, 'SNAC022', 0.00, 0.00, '2017-12-29'),
(3, 'SNAC022', 0.00, 0.00, '2017-12-29'),
(4, 'SNAC022', 0.00, 0.00, '2017-12-29'),
(5, 'SNAC022', 0.00, 0.00, '2017-12-29'),
(6, 'SNAC022', 0.00, 0.00, '2017-12-29'),
(7, 'SNAC022', 0.00, 0.00, '2017-12-29'),
(8, 'SNAC022', 0.00, 0.00, '2017-12-29'),
(9, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(10, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(11, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(12, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(13, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(14, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(15, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(16, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(17, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(18, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(19, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(20, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(21, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(22, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(23, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(24, 'SNAC022', 0.00, 0.00, '2017-12-30'),
(25, 'SNAC022', 89.00, 76.00, '2017-12-30'),
(26, 'SNAC022', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `soda`
--

CREATE TABLE `soda` (
  `id` int(11) NOT NULL,
  `sodaID` 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 `soda`
--

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

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int(11) NOT NULL,
  `userid` varchar(20) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `middlename` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `stateOfOrigin` varchar(100) DEFAULT NULL,
  `lga` varchar(200) DEFAULT NULL,
  `sex` varchar(50) DEFAULT NULL,
  `marital_status` varchar(20) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `home_phone` varchar(20) DEFAULT NULL,
  `cell_phone` varchar(30) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `nextOfKin` varchar(50) DEFAULT NULL,
  `relationship` varchar(50) DEFAULT NULL,
  `addressOfNOK` varchar(200) DEFAULT NULL,
  `emailOfNOK` varchar(200) DEFAULT NULL,
  `phoneOfNOK` varchar(40) DEFAULT NULL,
  `date_employed` datetime DEFAULT NULL,
  `deptid` varchar(5) NOT NULL,
  `gradeid` varchar(5) NOT NULL,
  `branch_code` varchar(5) NOT NULL,
  `employee_status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `role` varchar(50) DEFAULT NULL,
  `staff_type` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `userid`, `firstname`, `middlename`, `lastname`, `dob`, `stateOfOrigin`, `lga`, `sex`, `marital_status`, `address`, `home_phone`, `cell_phone`, `email`, `nextOfKin`, `relationship`, `addressOfNOK`, `emailOfNOK`, `phoneOfNOK`, `date_employed`, `deptid`, `gradeid`, `branch_code`, `employee_status`, `role`, `staff_type`) VALUES
(36, 'CLIENTnLJoiBhk', 'Golden', '', 'Ogbeka', '--', 'Lagos', 'Njaba', 'Male', 'Single', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', '08169200454', 'ogbekagolden@gmail.com', 'GGqweqweqwe', 'GG', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'ogbekagolden@gmail.com', '08169200454', '2021-09-09 08:11:25', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(1, 'SSREI001', 'Adebola', 'Omolola', 'Salami', '-1980-05-05-', 'Oyo State', 'Itesiwaju', 'Female', 'Single', '9 Femi Shobowale Street Anthony Village Lagos', '08023010250', '08142687293', 'coolbolly2000@gmail.com', 'Adebola Salami', 'Brother', '9 Femi Shobowale Street Anthony Village Lagos', 'sol_sal@yahoo.com', '08033043900', '2013-12-01 00:00:00', '1', '1', 'CPD20', 'Y', 'Quantity Surveyor', 'Contractor'),
(2, 'SSREI002', 'Adesolas', 'Romeo', 'Salamis', '1978-07-28', 'Ijebus', 'Ijebu Norths', 'Female', 'Single', '8 Harmony Drive Harmony Estate, Ogba', '1267676767', '07068088069', 'yinka.taiwos@maplecredit.com', 'Taiwo Idowus', 'Wifes', '8 Harmony Drive Harmony Estate, Ogba', 'qqr', '08035794439', '2013-09-01 00:00:00', '1', '1', 'CPD20', 'Y', 'Mechanical', 'In-house'),
(3, 'SSREI003', 'Modupeola', '', 'Salami', '1983-02-24', 'Benue State', 'VANDEIKYA', 'Male', 'Married', '13-15, Solomon Street, Alapere, Ketu', '07068010081', '07034969066', 'richard.tyotule@maplecredit.com', 'Ternenge Michelle', 'Wife', '13-15, Solomon Street, Alapere, Ketu', '', '07068010081', '2013-10-01 00:00:00', '400', '200', '001', 'N', 'Quantity Surveyor', 'In-house'),
(4, 'SSREI004', 'Adewale', '', 'Iwakun', '1992-06-20', 'Ogun Stae', 'Ikenne', 'Female', 'Single', 'BLOCK 1, FLAT 1,SHOMOLU ROAD, DOLPHIN ESTATE', '07061133083', '08181620383', 'pero.akinyemi@maplecredit.com', 'Akinyemi Oluwatoyin', 'Mother', 'EBI Palace, Agbala, Iperu-Remo Ogun State', 'gbeminiyi53@yahoo.com', '08033070993', '2013-10-01 00:00:00', '200', '400', '001', 'N', 'Project Manager', 'In-house'),
(5, 'SSREI005', 'Lukman', '', 'Salami', '1981-11-01', 'Osun State', 'ILESA WEST', 'Male', 'Single', ' 2, Igbehin Adun Street, Off Ajayi Road, Ogba', '07046332136', '07046833854', 'akinwale.balogun@maplecredit.com', 'Balogun Abosede', 'Sister', ' 2, Igbehin Adun Street, Off Ajayi Road, Ogba', 'jobaly2k@yahoo.com', '08037131860', '2013-11-01 00:00:00', '200', '400', '001', 'Y', 'Quantity Surveyor', 'In-house'),
(6, 'SSREI006', 'Wale', '', 'Daisi', '1986-04-15', 'Ogun State', 'Ijebu', 'Male', 'Single', '6, Lisa Crescent, Ogba', '08012121212', '08157719110', 'isaiah.ogundipe@maplecredit.com', 'Ogundipe Femi', 'Father', '6, Lisa Crescent, Ogba', '', '08038391581', '0000-00-00 00:00:00', '200', '400', '001', 'Y', 'Project Manager', 'In-house'),
(7, 'SSREI007', 'Oluwasegun', '', 'Emoruwa', '1991-01-24', 'Ondo State', 'Ekiti Pupa ', 'Male', 'Single', '22, Ponle Street, Ponle Bus-stop, Egbeda, Alimosho, Lagos ', '08125554828', '08175008181', 'segun.emoruwa@sturdyshelter.com', 'Emoruwa Jolade Elizabeth', 'Sister', '22, Ponle Street, Ponle Bus-stop, Egbeda, Alimosho, Lagos ', '', '08121568185', '2015-06-01 00:00:00', '200', '400', '001', 'Y', 'Project Manager', 'In-house'),
(8, 'SSREI008', 'Motunrayo', 'Folasade', 'Williams', '1987-04-03', 'Oyo State', 'Kajola', 'Female', 'Single', '3, Ilupeju by pass, Olajire House', '08087481772', '08136537763', 'motunrayo.williams@sturdyshelter.com', 'Willams Folake', 'Sister', '3, Ilupeju by pass, Olajire House', 'olafreckles@gmail.com', '08038813048', '2015-06-02 00:00:00', '200', '400', '001', 'Y', 'Project Manager', 'In-house'),
(9, 'SSREI009', 'Kayode', 'Logan', 'Adebesin', '-1970-04-15-', 'Ogun State', 'Ijebu', 'Male', 'Single', '6, Lisa Crescent, Ogba', '08012121212', '08157719110', 'kayode.adebesin@sturdyshelter.com', 'Ogundipe Femi', 'Father', '6, Lisa Crescent, Ogba', 'it@compositepropertydevelopmentx.com', '08038391581', '0000-00-00 00:00:00', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(17, 'UCPD14234678', 'Remmy', 'Martins', 'Jones', '1990-07-16', 'Lagos', 'Kosofe', 'Female', 'Single', 'Tennesse Road', '5656342514', '2341324156', 'it@compositepropertydevelopment.com', 'Bim Jones', 'Sister', 'Rig Avenue', 'it@compositepropertydevelopmentx.com', '1234353678', '2020-07-30 05:17:38', '1', '1', 'CPD20', 'Y', 'Mechanical', 'In-house'),
(0, 'UCPD16549348', 'Golden', '', 'Ogbeka', '--2021 12:00 AM-10-08--', 'Lagos', 'Njaba', 'Male', 'Single', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', '08169200454', 'goldenogbeka@gmail.com', 'asdasssd', 'GGasdasdasd', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'ogbekagolden@gmail.com', '0087979123', '2021-10-15 08:11:45', '1', '1', 'CPD20', 'Y', 'Project Manager', 'Contractor'),
(0, 'UCPD19354039', 'Golden', '', 'Ogbeka', '2021 12:00 AM-10-08', 'Lagos', 'Njaba', 'Male', 'Single', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', '08169200454', 'goldenogbeka@gmail.com', 'GGsdasdasd', 'GGasdasdasd', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'ogbekagolden@gmail.com', '08169200454', '2021-10-15 08:13:46', '1', '1', 'CPD20', 'Y', 'Project Manager', 'Contractor'),
(34, 'UCPD19365171', 'Dole', 'Yarn', 'Raymond', '1980-07-27', 'Maryland', 'Bowie', 'Female', 'Single', 'Teller Road', '4545454545', '1231425142', 'it@compositepropertydevelopment.com', 'James Ree', 'Brother', 'Yale Avenue', 'it@compositepropertydevelopmentx.com', '1267678989', '2020-07-30 19:39:17', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(28, 'UCPD19767870', 'King', 'Maaye', 'Isreal', '1978-07-15', 'New York', 'Brooklyn', 'Female', 'Married', 'Tennesse Road', '6589897867', '6765432345', 'it@compositepropertydevelopment.com', 'Segun', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '56564352625', '2020-07-30 06:02:42', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(0, 'UCPD29225886', 'Golden', '', 'Ogbeka', '2021 12:00 AM-10-08', 'Lagos', 'Njaba', 'Male', 'Single', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', '08169200454', 'goldenogbeka@gmail.com', 'GGsdasdasd', 'GGasdasdasd', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'ogbekagolden@gmail.com', '08169200454', '2021-10-15 08:13:28', '1', '1', 'CPD20', 'Y', 'Project Manager', 'Contractor'),
(35, 'UCPD32483122', 'Martin', 'Newton', 'Sparkle', '1965-07-15', 'Florida', 'Eti Osa', 'Male', 'Married', 'Gowan Estate', '2314234152', '5637262534', 'it@compositepropertydevelopment.com', 'Raymond Drez', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '2314232543', '2020-08-07 04:03:16', '1', '1', 'CPD20', 'Y', 'Electrical', 'In-house'),
(31, 'UCPD40243092', 'Roger', 'Mank', 'Fraser', '1981-08-05', '', '', '', '', '', '', '', '', '', '', '', '', '', '2020-07-30 06:09:46', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(24, 'UCPD43040548', 'King', 'Maaye', 'Isreal', '1987-07-02', 'New York', 'Brooklyn', '', '', 'Tennesse Road', '6589897867', '6765432345', 'it@compositepropertydevelopment.com', 'Segun', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '56564352625', '2020-07-30 05:58:41', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(20, 'UCPD44604315', 'Mike', 'Don', 'Lemon', '1988-08-08', 'Virginia', 'Falls Church', 'Male', 'Married', '5597 Seminary Road', '2679720589', '34251625242', 'it@compositepropertydevelopment.com', 'Joy Swanee', 'Sister', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '2134256767', '2020-07-30 05:35:07', '1', '1', 'CPD20', 'Y', 'Electrical', 'In-house'),
(15, 'UCPD45800100', 'Remmy', 'Martins', 'Jones', '1990-07-16', 'Lagos', 'Kosofe', 'Female', 'Single', 'Tennesse Road', '5656342514', '2341324156', 'it@compositepropertydevelopment.com', 'Bim Jones', 'Sister', 'Rig Avenue', 'it@compositepropertydevelopmentx.com', '1234353678', '2020-07-30 05:04:38', '1', '1', 'CPD20', 'Y', 'Mechanical', 'In-house'),
(0, 'UCPD47782901', 'Golden', '', 'Ogbeka', '2021 12:00 AM-10-08', 'Lagos', 'Njaba', 'Male', 'Single', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', '08169200454', 'goldenogbeka@gmail.com', 'GGsdasdasd', 'GGasdasdasd', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'ogbekagolden@gmail.com', '08169200454', '2021-10-15 08:12:08', '1', '1', 'CPD20', 'Y', 'Project Manager', 'Contractor'),
(32, 'UCPD50795589', 'Roger', 'Mank', 'Fraser', '1980-07-09', 'Delaware', 'Middle Town', 'Male', 'Divorce', 'Tennesse Road', '5656342514', '5634253439', 'it@compositepropertydevelopment.com', 'Segun', 'Sister', 'Rig Avenue', 'it@compositepropertydevelopmentx.com', '6565787867', '2020-07-30 06:11:46', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(33, 'UCPD56209252', 'Logan', 'Bommy', 'Laurel', '1980-08-04', 'Pennsylvania', 'Media', 'Male', 'Married', 'Rossvet', '67645363738', '1234352637', 'it@compositepropertydevelopment.com', 'Tammy', 'Brother', 'Lessing Lane', 'it@compositepropertydevelopmentx.com', '6767564543', '2020-07-30 06:43:39', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(13, 'UCPD57913784', 'Remmy', 'Martins', 'Jones', '1990-07-16', 'Lagos', 'Kosofe', 'Female', 'Single', 'Tennesse Road', '5656342514', '2341324156', 'it@compositepropertydevelopment.com', 'Bim Jones', 'Sister', 'Rig Avenue', 'it@compositepropertydevelopmentx.com', '1234353678', '2020-07-30 04:59:17', '1', '1', 'CPD20', 'Y', 'Mechanical', 'In-house'),
(23, 'UCPD59056405', 'King', 'Maaye', 'Isreal', '--', 'New York', 'Brooklyn', 'Male', 'Separated', 'Tennesse Road', '6589897867', '6765432345', 'it@compositepropertydevelopment.com', 'Segun', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '56564352625', '2020-07-30 05:57:20', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(29, 'UCPD59348840', 'King', 'Maaye', 'Isreal', '1978-07-15', 'New York', 'Brooklyn', 'Female', 'Married', 'Tennesse Road', '6589897867', '6765432345', 'it@compositepropertydevelopment.com', 'Segun', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '56564352625', '2020-07-30 06:03:24', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(14, 'UCPD61781002', 'Remmy', 'Martins', 'Jones', '1990-07-16', 'Lagos', 'Kosofe', 'Female', 'Single', 'Tennesse Road', '5656342514', '2341324156', 'it@compositepropertydevelopment.com', 'Bim Jones', 'Sister', 'Rig Avenue', 'it@compositepropertydevelopmentx.com', '1234353678', '2020-07-30 05:00:28', '1', '1', 'CPD20', 'Y', 'Mechanical', 'In-house'),
(11, 'UCPD62399492', '', '', '', '--', '', '', 'Male', 'Married', '', '', '', '', '', '', '', '', '', '2020-07-30 04:46:24', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(19, 'UCPD63405573', 'Rebel', 'Grey', 'Wilson', '1992-07-31', 'Edo', 'Ora', 'Male', 'Married', '223 Melrose Drive', '2679720514', '2679720514', 'it@compositepropertydevelopment.com', 'Taiwo Idowus', 'Sister', '5597 Seminary Road', 'it@compositepropertydevelopmentX.com', '2314256579', '2020-07-30 05:25:30', '1', '1', 'CPD20', 'Y', 'Structural', 'In-house'),
(27, 'UCPD65701713', 'King', 'Maaye', 'Isreal', '1978-07-15', 'New York', 'Brooklyn', 'Female', 'Married', 'Tennesse Road', '6589897867', '6765432345', 'it@compositepropertydevelopment.com', 'Segun', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '56564352625', '2020-07-30 06:01:53', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(12, 'UCPD69320326', 'r', 't', '', '--', '', '', 'Male', 'Married', '', '', '', '', '', '', '', '', '', '2020-07-30 04:51:56', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(16, 'UCPD74459554', 'Remmy', 'Martins', 'Jones', '1990-07-16', 'Lagos', 'Kosofe', 'Female', 'Single', 'Tennesse Road', '5656342514', '2341324156', 'it@compositepropertydevelopment.com', 'Bim Jones', 'Sister', 'Rig Avenue', 'it@compositepropertydevelopmentx.com', '1234353678', '2020-07-30 05:15:27', '1', '1', 'CPD20', 'Y', 'Mechanical', 'In-house'),
(22, 'UCPD75213536', 'King', 'Maaye', 'Isreal', '1982-08-05', '', '', '', '', '', '', '', '', '', '', '', '', '', '2020-07-30 05:55:20', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(26, 'UCPD79653956', 'King', 'Maaye', 'Isreal', '1978-07-15', 'New York', 'Brooklyn', 'Female', 'Married', 'Tennesse Road', '6589897867', '6765432345', 'it@compositepropertydevelopment.com', 'Segun', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '56564352625', '2020-07-30 06:00:26', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(25, 'UCPD85317960', 'King', 'Maaye', 'Isreal', '1987-07-10', 'New York', 'Brooklyn', 'Female', 'Divorce', 'Tennesse Road', '6589897867', '6765432345', 'it@compositepropertydevelopment.com', 'Segun', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '56564352625', '2020-07-30 05:59:33', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(0, 'UCPD89603352', 'Golden', '', 'Ogbeka', '2021 12:00 AM-10-08', 'Lagos', 'Njaba', 'Male', 'Single', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', '08169200454', 'goldenogbeka@gmail.com', 'GGsdasdasd', 'GGasdasdasd', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'ogbekagolden@gmail.com', '08169200454', '2021-10-15 08:11:30', '1', '1', 'CPD20', 'Y', 'Project Manager', 'Contractor'),
(30, 'UCPD89906273', 'King', 'Maaye', 'Isreal', '1978-07-15', 'New York', 'Brooklyn', 'Female', 'Married', 'Tennesse Road', '6589897867', '6765432345', 'it@compositepropertydevelopment.com', 'Segun', 'Brother', 'Testing Avenue', 'it@compositepropertydevelopmentx.com', '56564352625', '2020-07-30 06:04:03', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(21, 'UCPD91785445', 'Makinde', 'Mind', 'Young', '1991-07-28', 'Virginia', 'Falls Church', 'Female', 'Married', '5597 Seminary Road', '234152678', '331425348', 'it@compositepropertydevelopment.com', 'Rhoda Ion', 'Sister', 'Testy road', 'it@compositepropertydevelopmentx.com', '5635364546', '2020-07-30 05:51:01', '1', '1', 'CPD20', 'Y', 'Electrical', 'In-house'),
(18, 'UCPD96176388', 'Remmy', 'Martins', 'Jones', '1991-06-30', 'Lagos', 'Kosofe', '', '', 'Tennesse Road', '5656342514', '2341324156', 'it@compositepropertydevelopment.com', 'Bim Jones', 'Sister', 'Rig Avenue', 'it@compositepropertydevelopmentx.com', '1234353678', '2020-07-30 05:19:04', '1', '1', 'CPD20', 'Y', 'Project Manager', 'In-house'),
(10, 'UCPD98936711', 'Rhodax', 'Mercyx', 'Reneex', '2020-07-15', 'Oyo Statex', 'Itesiwajux', 'Female', 'Divorce', '111 Nicole Lanex', '2341526379', '5634253439', 'it@compositepropertydevelopmentX.com', 'Joy Swaneex', 'Sisterx', 'Mercy Avenuex', 'it@compositepropertydevelopmentX.com', '2314256579', '2020-07-28 06:57:14', '1', '1', 'CPD20', 'Y', 'Architecture', 'In-house');

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

--
-- Table structure for table `staff_project`
--

CREATE TABLE `staff_project` (
  `idno` int(11) NOT NULL,
  `staff_id` varchar(50) DEFAULT NULL,
  `staff_name` varchar(100) DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `project_code` varchar(50) DEFAULT NULL,
  `role` varchar(100) DEFAULT NULL,
  `date_assigned` datetime DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff_project`
--

INSERT INTO `staff_project` (`idno`, `staff_id`, `staff_name`, `project_name`, `project_code`, `role`, `date_assigned`, `status`) VALUES
(1, 'UCPD98936711', 'Rhodax Reneex', 'Pentagon Inc', 'CPD647961', NULL, '2020-07-29 00:36:27', 'Active'),
(2, 'SSREI004', 'Adewale Iwakun', 'Jungle Reform', 'CPD662668', NULL, '2020-07-29 02:06:11', 'Active'),
(3, 'SSREI003', 'Modupeola Salami', 'Mande Shopping Complex Renovation', 'CPD322400', NULL, '2020-07-29 02:09:31', 'Active'),
(4, 'SSREI005', 'Lukman Salami', 'Pentagon Inc', 'CPD647961', NULL, '2020-07-29 02:55:07', 'Active'),
(5, 'SSREI006', 'Wale Daisi', 'Pentagon Inc', 'CPD647961', NULL, '2020-07-29 03:00:37', 'Active'),
(6, 'SSREI007', 'Oluwasegun Emoruwa', 'Pentagon Inc', 'CPD647961', NULL, '2020-07-29 03:07:13', 'Active'),
(7, 'SSREI009', 'Kayode Adebesin', 'Malibu Renovation', 'CPD668889', NULL, '2020-07-31 05:50:51', 'Active'),
(8, 'SSREI003', 'Modupeola Salami', 'Bode Peters ', 'CPD374831', NULL, '2020-08-02 19:05:52', 'Active'),
(9, 'UCPD98936711', 'Rhodax Reneex', 'High Cost Tower Renovation maybe', 'CPD195139', 'Architecture', '2020-08-07 05:09:14', 'Active'),
(10, 'UCPD63405573', 'Rebel Wilson', 'Rocket Rail Construction', 'CPD415474', '', '2020-08-07 05:39:00', 'Active'),
(11, 'UCPD14234678', 'Remmy Jones', 'Lincoln Avenue Project', 'CPD203311', 'Mechanical', '2020-08-07 05:48:40', 'Active'),
(12, 'SSREI008', 'Motunrayo Williams', 'Grange Atrium', 'CPD358009', 'Project Manager', '2020-08-09 05:51:03', 'Active'),
(13, 'UCPD75213536', 'King Isreal', 'GRA Office Renovation II', 'CPD537884', 'Project Manager', '2020-08-10 00:23:30', 'Active'),
(14, 'UCPD98936711', 'Rhodax Reneex', 'GRA Office Renovation II', 'CPD537884', 'Architecture', '2020-08-10 01:08:42', 'Active'),
(15, 'SSREI004', 'Adewale Iwakun', 'Mason Hall Renovation', 'CPD952273', 'Project Manager', '2020-08-10 05:35:23', 'Active'),
(16, 'SSREI008', 'Motunrayo Williams', 'Little River Pike Project', 'CPD652860', 'Project Manager', '2020-10-02 00:42:41', 'Active'),
(17, 'UCPD91785445', 'Makinde Young', 'jbhjbhjb', 'CPD987619', 'Electrical', '2021-09-16 15:14:42', 'Active'),
(18, 'UCPD98936711', 'Rhodax Reneex', 'hhh', 'CPD172816', 'Architecture', '2021-09-20 13:03:58', 'Active'),
(19, 'UCPD63405573', 'Rebel Wilson', 'Man', 'CPD839693', 'Structural', '2021-10-14 20:30:14', 'Active'),
(20, 'CLIENTKfopdNCr', 'Golden Ogbeka', 'ELF3 - Abake Court', 'SSP960071', 'Project Manager', '2021-10-15 07:48:29', 'Active');

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

--
-- Table structure for table `stakeholder`
--

CREATE TABLE `stakeholder` (
  `idno` int(11) NOT NULL,
  `stakeholder_code` varchar(50) DEFAULT NULL,
  `stakeholder_name` varchar(100) DEFAULT NULL,
  `stakeholder_address` varchar(200) DEFAULT NULL,
  `stakeholder_ofc_phone` varchar(20) DEFAULT NULL,
  `government_agencies` varchar(50) DEFAULT NULL,
  `non_government_agencies` varchar(50) DEFAULT NULL,
  `other_agency` varchar(255) DEFAULT NULL,
  `contact_person` varchar(100) DEFAULT NULL,
  `contact_mobile` varchar(40) DEFAULT NULL,
  `contact_home_phone` varchar(40) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stakeholder`
--

INSERT INTO `stakeholder` (`idno`, `stakeholder_code`, `stakeholder_name`, `stakeholder_address`, `stakeholder_ofc_phone`, `government_agencies`, `non_government_agencies`, `other_agency`, `contact_person`, `contact_mobile`, `contact_home_phone`, `comment`, `date_added`) VALUES
(1, 'TY6789HGN9090745', 'Walker Mann', 'Tread Mill', '7878787878', 'Town Planning', 'Area Boys', NULL, 'Maybell22', '5647839099', '3564789099', 'Testing12345876', '2020-07-31 04:44:44'),
(2, '5SSALETFTH', 'Reign More Sr', 'Tester Road 8', '2134566788', 'Town Planning', 'Area Boys', NULL, '1245367897', '5647839098', '7878645368', 'Testing 45468', '2019-10-26 22:52:38'),
(3, 'LYLXVOHTSO', 'Gains Limor', 'Ring Road', '4536789097', 'Town Planning', '', NULL, '3452314545', '5647839098', '3564789098', 'Test12', '2019-10-26 22:54:42'),
(4, 'ALEYO4RBY9', 'Ashley Dale', 'Tinton Road', '2134567878', 'Town Planning', 'Area Boys', NULL, 'Pearls', '2134567878', '2134567878', 'testing', '2020-07-10 23:09:52'),
(5, 'P3PAAR1LBR', 'Mandy Roley', '', '5656565656', 'Labca', 'Omo-onile', NULL, '', '5656565656', '5656565656', 'testinh9090', '2020-07-11 00:18:10'),
(6, 'DV7HFLW0UI', 'Manrole Atkins', '1100 Lincoln Way', '2341245678', '', '', NULL, 'Jay John', '5689878657', '2341526718', 'Testing 676767', '2020-07-20 02:44:11'),
(7, 'N4BJBEDSMM', 'Lewis Herman', 'Trump Road', '4545454545', 'Town Planning', 'Community Development Association', NULL, 'Jamie Lane', '7876765454', '6543212345', 'testing testing 565656', '2020-07-31 03:32:18'),
(8, 'DYRXDRTNLU', 'Jon Right', 'Testee Road', '5645454545', 'Lag Environmental Agencies', 'Community Vigilante Groups', NULL, 'Maybell2', '5647839097', '3564789097', 'testing testing 8989', '2020-07-31 04:11:02'),
(9, 'Z0ALHUHNM2', 'Jon Rights', 'Testee Roads', '5645454549', 'Lastma', 'Omo-onile', NULL, 'Maybell23', '5647839097', '3564789099', 'testing testing 8989 676', '2020-07-31 04:17:28'),
(10, 'GNSWLIIUMI', 'Reign Limo', 'Trill Hill', '5656453423', 'Lag Environmental Agencies', 'Area Boys', NULL, 'Maybell24', '5647839099', '3564789099', 'Testing1234587', '2020-07-31 04:28:58'),
(11, 'BZK05PO894', 'Tyre Ron', 'Trill Hill', '5454545454', 'Town Planning', 'Omo-onile', NULL, 'Maybell2', '5647839097', '3564789097', 'Testing12345879', '2020-07-31 04:34:31'),
(12, 'TAZ1CLFSJU', 'Green Land gf', 'Tesing Mountin hg', '54251276718', 'Federal Fire Service', 'Omo-onile', '', 'Dave Sa', '6765142516', '9089765426', 'testing testing 5656', '2020-08-14 21:38:25'),
(13, 'STHCPD-3WHXWKAF9S', 'Grayson  Mannor', 'Isles of Grey Road', '2314567898', 'Lagos State Fire Service', 'Area Boys', '', 'Addy Rays', '6354637890', '3456789878', 'Testing stakeholder pop up', '2020-08-23 19:55:59'),
(0, 'B25L3V8BVE', 'Contractor office Phone', 'No. 11 Alhaja Jaiyeola Street Alagbole', '08169200454', 'Federal Fire Service', 'Omo-onile', '', 'Golden Ogbeka', '08169200454', '08169200454', 'WW', '2021-09-09 07:57:33');

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

--
-- Table structure for table `stakeholderproject`
--

CREATE TABLE `stakeholderproject` (
  `stakeHolderProID` int(11) NOT NULL,
  `stakeholder_code` varchar(50) DEFAULT NULL,
  `stakeholder_project_code` varchar(50) DEFAULT NULL,
  `stakeholder_amount` float(10,2) DEFAULT NULL,
  `approved_amount` float(12,2) DEFAULT NULL,
  `other_amount` float(12,2) 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 `stakeholderproject`
--

INSERT INTO `stakeholderproject` (`stakeHolderProID`, `stakeholder_code`, `stakeholder_project_code`, `stakeholder_amount`, `approved_amount`, `other_amount`, `createdOn`, `createdBy`, `comment`, `status`) VALUES
(1, '5SSALETFTH', 'SSP960071', 150067.00, NULL, NULL, '2020-07-20 03:39:29', 'Adebola', 'Testing testing 233466', 'Approved'),
(2, '5SSALETFTH', 'SSP960071', 500000.00, NULL, NULL, '2020-07-12 18:40:52', 'Adebola', 'testing', 'Approved'),
(3, 'ALEYO4RBY9', 'SSP960071', 900000.00, NULL, NULL, '2020-07-14 05:04:18', 'Adebola', 'testing testing 909090', 'Approved'),
(4, 'P3PAAR1LBR', 'CPD403540', 600000.00, NULL, NULL, '2020-07-15 05:28:16', '2020-07-15 05:28:16', 'testing', 'Approved'),
(5, 'LYLXVOHTSO', 'CPD403540', 500000.00, NULL, NULL, '2020-07-15 05:53:55', '2020-07-15 05:53:55', 'ready to go', 'Approved'),
(6, '5SSALETFTH', 'SSP960071', 3000.00, NULL, NULL, '2020-07-15 06:11:11', '2020-07-15 06:11:11', 'relax testing', 'Approved'),
(7, 'N4BJBEDSMM', 'CPD537884', 1500000.00, NULL, 90000.00, '2020-08-14 23:56:01', 'Adebola', 'testing 45454', 'Approved'),
(8, 'STHCPD-3WHXWKAF9S', 'CPD537884', 350000.00, NULL, 100000.00, '2020-08-23 19:57:00', '2020-08-23 19:57:00', 'Testing testing', 'Approved'),
(9, 'STHCPD-3WHXWKAF9S', 'CPD203311', 50000.00, 35000.00, 7000.00, '2020-09-20 22:16:29', 'Adebola Salami', 'Testing testing 78787878', 'Approved'),
(10, 'ALEYO4RBY9', 'CPD195139', 600000.00, 40000.00, 50000.00, '2020-09-20 21:47:36', 'Adebola Salami', 'Testing testing', 'Approved'),
(11, '5SSALETFTH', 'CPD205394', 500000.00, 30000.00, 7000.00, '2020-09-20 21:52:36', 'Adebola Salami', '300,00 approved', 'Approved'),
(12, 'ALEYO4RBY9', 'CPD205394', 56000.00, 50000.00, 4000.00, '2020-09-20 22:35:15', 'Adebola Salami', 'testing12345', 'Rejected'),
(13, 'ALEYO4RBY9', 'CPD230040', 500000.00, 300000.00, 7000.00, '2020-10-02 02:03:19', 'Adebola Salami', 'testing 898989000', 'Approved'),
(14, 'TY6789HGN9090745', 'SSP960071', 1234.00, 2123.00, 1312.00, '2021-10-15 07:49:48', 'Golden Ogbeka', 'Go', 'Pending');

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

--
-- Table structure for table `startup_cost`
--

CREATE TABLE `startup_cost` (
  `idno` int(11) NOT NULL,
  `startup_code` varchar(20) DEFAULT NULL,
  `project_code` varchar(20) NOT NULL,
  `startup_desc` text DEFAULT NULL,
  `startup_type` varchar(50) DEFAULT NULL,
  `startup_cost` float(12,2) DEFAULT NULL,
  `comment` text NOT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `startup_cost`
--

INSERT INTO `startup_cost` (`idno`, `startup_code`, `project_code`, `startup_desc`, `startup_type`, `startup_cost`, `comment`, `date_added`) VALUES
(1, 'SSSC9188', 'SSP740939', 'Approval Planx', 'Landx', 800000.00, 'testing testingx', '2015-02-03 00:17:27'),
(2, 'SSSC6422', 'SSP960071', 'Cost of Land Acquisition', 'Land purchase, Agency and Legal', 90000000.00, 'Land 85000000; Legal and Agency - 5000000', '2015-02-09 06:45:12'),
(3, 'SSSC6182', 'SSP960071', 'LASG Title Doumentation', 'Governor\\\'s Consent', 3000000.00, 'Title processing at Alausa', '2015-02-09 06:51:35'),
(4, 'SSSC8856', 'SSP960071', 'Townplaning Documentation', 'Planning Approval', 2000000.00, 'Planning approval for the two blocks', '2015-02-09 07:05:17'),
(6, 'SSSC5953', 'SSP960071', 'Marketing designs', 'Brochures - CD and Paper', 150000.00, 'Printing of brochures and CD for marketing purposes', '2015-02-09 07:10:06'),
(7, 'SSSC9880', 'SSP960071', 'Initial Site Cleanup', 'Bush Clearing', 40000.00, 'Clearing of site of bushes and junks', '2015-02-09 07:12:11'),
(8, 'SSSC8121', 'SSP960071', 'Raising site level to de-water', 'Filling of site with sand', 1170000.00, '45 trips of 20ton filling sand at 26K per trip', '2015-02-09 07:14:23'),
(9, 'SSSC6292', 'SSP960071', 'Provision of water', 'Borehole Drilling', 120000.00, 'Drilling of borehole for site use', '2015-02-09 07:18:58'),
(10, 'SSSC8569', 'SSP960071', 'Provision of storage and site of space', 'Store and Site office', 200000.00, 'Site office and store construction', '2015-02-09 07:20:54'),
(11, 'SSSC6060', 'SSP627497', 'Land processing charge(s)', 'Landx', 125000.00, 'testx', '2015-03-09 05:41:06'),
(12, 'SCCPD-657257-1207202', 'SSP960071', 'Level up Payment', 'Gringe', 200000.00, 'Testing testing', '2020-07-12 22:55:22'),
(13, 'SCCPD-117908-1207202', 'SSP960071', 'Ground Breaking  Next level', 'State Paymentsxx', 210000.00, 'testing 67676767 real deal', '2020-07-15 21:24:56'),
(14, 'SCCPD-637600-1207202', 'SSP923374', 'Breaking Ground', 'Fringe', 300000.00, 'New one', '2020-07-12 23:10:01'),
(15, 'SCCPD-406333-1507202', 'CPD403540', 'Breaking Ground', 'State Payment', 150000.00, 'Ready to go', '2020-07-15 05:17:02'),
(16, 'SCCPD-827338-1507202', 'CPD403540', 'Level up Payment', 'Gringe', 30000.00, 'testing on', '2020-07-15 05:25:27'),
(17, 'SCCPD-204359-2007202', 'SSP960071', 'Payment for the testing ', 'Design & Approval Drawing', 150000.00, 'Payment for drawing', '2020-07-20 04:06:00'),
(18, 'SCCPD-435734-0208202', 'CPD374831', 'Payment to land owners', 'Land Acquisition', 60000000.00, 'There is a need to get the consent of the Ashamu family', '2020-08-02 19:17:25'),
(19, 'SCCPD-179086-0208202', 'CPD374831', 'Payment to the Ashamu family', 'Omo Onile', 5000000.00, 'For title re-confirmation', '2020-08-02 19:23:53'),
(20, 'SCCPD-129635-1510202', 'SSP960071', 'Man', 'Community Relation', 1123992.00, 'LL', '2021-10-15 07:46:55');

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

--
-- Table structure for table `stock`
--

CREATE TABLE `stock` (
  `idno` int(11) NOT NULL,
  `stock_code` varchar(10) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `quantity_left` int(11) DEFAULT NULL,
  `quantity_used` int(11) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `suggestion`
--

CREATE TABLE `suggestion` (
  `s_id` int(11) NOT NULL,
  `proCode` varchar(30) DEFAULT NULL,
  `flat_desc` varchar(100) DEFAULT NULL,
  `flat_code` varchar(30) DEFAULT NULL,
  `tenant_name` varchar(100) DEFAULT NULL,
  `tenant_code` varchar(30) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_commented` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `suggestion`
--

INSERT INTO `suggestion` (`s_id`, `proCode`, `flat_desc`, `flat_code`, `tenant_name`, `tenant_code`, `email`, `comment`, `date_commented`) VALUES
(1, 'SSP627497', '3 Bedroom Duplex', 'PFCK1EH0GHF', 'Wonuola Ajayi', 'TCQIXFIXQJMM', 'support@responsetechnologiesltd.com', 'Dear Sir/Ma\\r\\n\\r\\nI have a suggestion regarding the upkeep of the compound. I believe we can have a more beautiful edifice if you employ the services of a horticulturist in tending the flowers and grasses in the compound.\\r\\n\\r\\nkind regards\\r\\n\\r\\nWonuola Ajayi\\r\\n\\r\\n\\r\\n\\r\\ntesting testing 5678\\r\\n\\r\\nClick here  to login to the portal.\\r\\n\\r\\nKind Regards,\\r\\n', '2015-06-18 07:40:52'),
(2, 'SSP627497', 'Wing Apartment with storage', 'PFCVPVYVJUN', 'Ademide Ajodua', 'TCK9CLMJLGYS', 'it@maplecredit.com', 'Dear Sir/Ma\\r\\n\\r\\nI want to suggest that this website should include a platform of interaction between we the tenants. \\r\\n\\r\\nThanks.\\r\\n\\r\\nMrs Ademide Ajodua', '2015-06-19 06:28:38'),
(3, '', '', '', '', '', '', '', '2015-07-31 21:40:42'),
(4, '', '', '', '', '', '', '', '2015-11-04 00:59:15');

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

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `idno` int(11) NOT NULL,
  `supplier_code` varchar(20) DEFAULT NULL,
  `supplier_name` varchar(100) DEFAULT NULL,
  `supplier_address` varchar(100) DEFAULT NULL,
  `supplier_ofc_phone` varchar(20) DEFAULT NULL,
  `contact_person` varchar(100) DEFAULT NULL,
  `contact_mobile` varchar(30) DEFAULT NULL,
  `contact_home_phone` varchar(30) DEFAULT NULL,
  `comment` text NOT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` (`idno`, `supplier_code`, `supplier_name`, `supplier_address`, `supplier_ofc_phone`, `contact_person`, `contact_mobile`, `contact_home_phone`, `comment`, `date_added`) VALUES
(1, 'OUXT0V6QDK', 'Mankind Inc xxxxx', '7 Ring Roads', '2312454567', 'Maybells', '5647839098', '3564789098', 'Testing123458', '2020-07-17 06:06:16'),
(12, '0HJPBJBBML', 'Rowling Limited', 'Terrestial Road', '2345675656', 'James Loxd', '2345675656', '2345675656', 'Testing', '2020-07-10 05:05:09'),
(2, 'OFECVGDCGI', 'TAPUP CASTER', 'Tester Road', '08120180422', 'Tap up', '08037156152', '5645342345', 'Concrete casting ', '2020-07-17 06:06:50'),
(3, 'UFQJOPRTTX', 'Awesu', '', '08120953669', 'Awesu Tunde', '', '', 'Block making', '2015-02-09 07:42:16'),
(4, 'HMPHA115X5', 'Ikota Iron Sola', 'Ikota Villa Estate', '08032158107', 'Sola', '08174807055', '', 'Supplier of reinforcement materials - Iron rods', '2015-02-09 08:44:14'),
(5, 'LSSZG1K90G', 'Ikota Ola Granite', 'Ikota Villa Estate', '08023920853', 'Ola Akinloye', '', '', 'Sand and Granite Supplier', '2015-02-09 09:13:32'),
(6, 'NQLPSCJSWS', 'Sturdy In-house procurement unit', '43, Raymond Njoku street, Off Awolowo rd, Ikoyi. Lagos', '08025010233', 'Bola', '08025010233', '', 'procurement made directly by a Sturdy Personnel', '2015-02-24 08:37:02'),
(7, 'QKMLR64PQJ', 'Bamboo Seller - Toyin Arikewusola', 'Ajah', 'banboo upplier - thr', 'Mr Samuel', '08037267391', '', 'contact thrugh mr. samuel', '2015-04-06 07:41:39'),
(8, 'XA8WOW2PSM', 'wood supplier - Oladepo Mojeed thru mr. samuel', 'ikate - jakande', '08037267391', 'thru mr samuel', '08037267391', '', 'thrigh mr Samuel - supplier of wood and planks', '2015-04-06 07:43:52'),
(9, '7ORAQA9WY7', 'Abdul Wosilat - Sand, Granite and Block supplier', 'Lekki', '08023643931', 'Abdul wosilat', '08023643931', '', 'Supplies granite , sand and blocks', '2015-04-06 08:56:29'),
(10, 'GSIJV7ECKV', 'Cement Supplier Wale', 'Mainland', '08079865545', 'Wale Oguntuyi', '08023114637', '08035990549', 'Strictly Cement', '2015-04-06 09:02:23'),
(11, 'URI1ZQNLJR', 'Cedar Investments Sample ', '7, Ribadu rd, off Awolowo Rd, Ikoyi, Lagos. ', '01-5626156', 'Adewale Adedayo', '08064845123', '01-5454545', 'Supplier of ceramic tiles', '2015-06-24 09:45:56'),
(13, '4456MLH1WG', 'Rowling Stones', 'Adeline Lanes', '3434343435', 'Jane Does', '3434347875', '3434343495', 'Testing supplier new league', '2020-07-16 01:25:16'),
(14, 'GUSEI1GTD7', 'Amcus Limiteds', '56 Reed Lanes', '6767565649', 'Timmy s', '8989787869', '6767676769', 'testing testing 898769', '2020-07-31 05:05:40'),
(15, 'LEMFJVLZPE-22082020', 'Solid Foundation Inc', 'Testrale Road', '4563746475', 'Jame Luke', '346575575', '346575575', 'Railing on', '2020-08-22 21:48:09'),
(16, 'W5AF9ZLG8B-22082020', 'Solid Foundation Inc', 'Testrale Road', '4563746475', 'Jame Luke', '346575575', '346575575', 'Railing on', '2020-08-22 22:00:51'),
(17, 'QGGDLZSSOO-22082020', 'Solid Foundation Inc', 'Testrale Road', '4563746475', 'Jame Luke', '346575575', '346575575', 'Railing on', '2020-08-22 22:08:06'),
(18, 'ILZC55NDNR', 'Greenow Supplies LLC', 'Tinkler Road', '345678989', 'Ajay Ray', '8987635261', '3214536767', 'Testing 5657 ready', '2020-10-02 00:47:19');

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

--
-- Table structure for table `supplier_materials`
--

CREATE TABLE `supplier_materials` (
  `mat_id` int(11) NOT NULL,
  `mat_code` varchar(30) DEFAULT NULL,
  `supplier_code` varchar(30) DEFAULT NULL,
  `supplier_name` varchar(255) DEFAULT NULL,
  `mat_desc` varchar(100) DEFAULT NULL,
  `project_code` varchar(30) NOT NULL,
  `qty` int(11) DEFAULT NULL,
  `unit_price` float(10,2) DEFAULT NULL,
  `tot_price` float(12,2) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_materials`
--

INSERT INTO `supplier_materials` (`mat_id`, `mat_code`, `supplier_code`, `supplier_name`, `mat_desc`, `project_code`, `qty`, `unit_price`, `tot_price`, `date_added`) VALUES
(1, '5350', 'UFQJOPRTTX', 'Awesu', '9inch blocks 2000', 'SSP960071', 2000, 170.00, 340000.00, '2015-02-09 07:45:07'),
(2, '6147', 'UFQJOPRTTX', NULL, '6inch blocks', 'SSP960071', 1000, 150.00, 150000.00, '2015-02-09 07:45:56'),
(3, '6843', 'HMPHA115X5', NULL, 'Iron Rods (tons)', 'SSP960071', 1, 819000.00, 819000.00, '2015-02-09 08:54:15'),
(4, '9881', 'HMPHA115X5', NULL, 'Iron Rods (tons)', 'SSP960071', 1, 602000.00, 602000.00, '2015-02-09 08:59:12'),
(5, '2396', 'HMPHA115X5', NULL, 'Iron Rods (tons)', 'SSP960071', 1, 230000.00, 230000.00, '2015-02-09 09:03:52'),
(6, '2260', 'LSSZG1K90G', NULL, 'Granite (tons)', 'SSP960071', 3, 140000.00, 420000.00, '2015-02-09 09:23:48'),
(7, '2966', 'LSSZG1K90G', NULL, 'Sharp sand', 'SSP960071', 3, 45000.00, 135000.00, '2015-02-09 09:24:29'),
(8, '7517', 'LSSZG1K90G', NULL, 'Granite (tons)', 'SSP960071', 3, 140000.00, 420000.00, '2015-02-09 09:25:47'),
(9, '5259', 'LSSZG1K90G', NULL, 'Sharp sand', 'SSP960071', 3, 45000.00, 135000.00, '2015-02-09 09:26:37'),
(10, '5071', 'OUXT0V6QDK', NULL, 'plumbing pipes', 'SSP960071', 1, 50000.00, 50000.00, '2015-02-10 09:03:21'),
(11, '5376', 'LSSZG1K90G', NULL, 'granite - 30tons', 'SSP960071', 2, 140000.00, 280000.00, '2015-02-24 08:39:25'),
(12, '5955', 'LSSZG1K90G', NULL, 'sharp sand - 20ton ', 'SSP960071', 3, 45000.00, 135000.00, '2015-02-24 08:41:30'),
(13, '7908', 'LSSZG1K90G', NULL, 'filling sand', 'SSP960071', 3, 26000.00, 78000.00, '2015-02-24 08:42:24'),
(14, '1456', 'NQLPSCJSWS', NULL, 'Marine Boards', 'SSP960071', 100, 6000.00, 600000.00, '2015-02-24 10:00:01'),
(15, '4563', 'NQLPSCJSWS', NULL, '2by2', 'SSP960071', 280, 280.00, 78400.00, '2015-02-24 10:01:45'),
(16, '6979', 'NQLPSCJSWS', NULL, '1by12 softwood', 'SSP960071', 224, 1000.00, 224000.00, '2015-02-24 10:04:40'),
(17, '1945', 'NQLPSCJSWS', NULL, '2by3', 'SSP960071', 100, 320.00, 32000.00, '2015-02-24 10:05:25'),
(18, '5313', 'NQLPSCJSWS', NULL, 'nails', 'SSP960071', 10, 5000.00, 50000.00, '2015-02-24 10:06:26'),
(19, '3699', 'NQLPSCJSWS', NULL, 'filling sand - 20tons', 'SSP960071', 40, 26000.00, 1040000.00, '2015-02-24 10:23:59'),
(20, '6336', 'HMPHA115X5', NULL, 'iron -in tons', 'SSP960071', 6, 120000.00, 720000.00, '2015-02-24 10:35:54'),
(21, '570', 'HMPHA115X5', NULL, 'binding wire', 'SSP960071', 7, 7000.00, 49000.00, '2015-02-24 10:36:47'),
(22, '9488', 'OUXT0V6QDK', NULL, 'Dulux Paint Drum', 'SSP627497', 6, 12300.00, 73800.00, '2015-03-09 10:37:17'),
(23, '1161', 'OUXT0V6QDK', NULL, 'Iron rod', 'SSP627497', 2000, 500.00, 1000000.00, '2020-07-17 06:05:05'),
(24, '204', 'OUXT0V6QDK', NULL, 'Iron rod', 'SSP627497', 200, 4500.00, 900000.00, '2015-03-09 12:01:53'),
(25, '5327', 'NQLPSCJSWS', NULL, 'plumbing materials - sundry', 'SSP960071', 1, 115000.00, 115000.00, '2015-04-06 06:01:25'),
(26, '3178', 'LSSZG1K90G', NULL, 'granite - 30tons', 'SSP960071', 4, 140000.00, 560000.00, '2015-04-06 06:21:25'),
(27, '7643', 'LSSZG1K90G', NULL, 'sharp sand - 20ton ', 'SSP960071', 6, 45000.00, 270000.00, '2015-04-06 06:22:33'),
(28, '1760', 'HMPHA115X5', NULL, 'iron -in tons', 'SSP960071', 16, 120000.00, 1920000.00, '2015-04-06 06:32:01'),
(29, '6399', 'HMPHA115X5', NULL, 'binding wire', 'SSP960071', 8, 7000.00, 56000.00, '2015-04-06 06:35:26'),
(30, '2839', 'NQLPSCJSWS', NULL, 'Marine Boards', 'SSP960071', 100, 5500.00, 550000.00, '2015-04-06 06:37:35'),
(31, '5848', 'NQLPSCJSWS', NULL, 'packing case', 'SSP960071', 100, 1400.00, 140000.00, '2015-04-06 06:40:23'),
(32, '6515', 'NQLPSCJSWS', NULL, 'bamboo', 'SSP960071', 90, 350.00, 31500.00, '2015-04-06 06:41:40'),
(33, '6306', 'XA8WOW2PSM', NULL, 'planks and nails', 'SSP960071', 1, 272000.00, 272000.00, '2015-04-06 08:28:39'),
(34, '6492', 'XA8WOW2PSM', NULL, 'planks and nails', 'SSP960071', 1, 156200.00, 156200.00, '2015-04-06 08:29:33'),
(35, '473', 'XA8WOW2PSM', NULL, 'planks and nails', 'SSP960071', 1, 190600.00, 190600.00, '2015-04-06 08:30:35'),
(36, '287', 'QKMLR64PQJ', NULL, 'bamboo', 'SSP960071', 500, 350.00, 175000.00, '2015-04-06 08:42:37'),
(37, '5554', 'QKMLR64PQJ', NULL, 'bamboo', 'SSP960071', 200, 350.00, 70000.00, '2015-04-06 08:44:07'),
(38, '5771', '7ORAQA9WY7', NULL, '6inch blocks ', 'SSP960071', 1000, 170.00, 170000.00, '2015-04-06 08:58:28'),
(39, '6455', '7ORAQA9WY7', NULL, '9inch blocks', 'SSP960071', 2000, 180.00, 360000.00, '2015-04-06 09:00:00'),
(40, '7090', '7ORAQA9WY7', NULL, 'cement', 'SSP960071', 0, 0.00, 0.00, '2015-04-06 09:03:43'),
(41, '2165', 'GSIJV7ECKV', NULL, 'cement', 'SSP960071', 600, 1900.00, 1140000.00, '2015-04-06 09:11:32'),
(42, 'SMCPD-6819-17072020', 'OUXT0V6QDK', NULL, 'Rollers', '1', 2000, 400.00, 800000.00, '2020-07-17 04:03:12'),
(43, 'SMCPD-1382-17072020', 'OUXT0V6QDK', NULL, 'Maple Tree', '1', 7000, 500.00, 3500000.00, '2020-07-17 04:31:51'),
(44, 'SMCPD-4297-17072020', 'OUXT0V6QDK', NULL, 'Crate ', '1', 1000, 1200.00, 1200000.00, '2020-07-17 04:32:50'),
(45, 'SMCPD-3538-17072020', 'OUXT0V6QDK', NULL, 'Crate ', '1', 1000, 1200.00, 1200000.00, '2020-07-17 04:33:36'),
(46, 'SMCPD-5875-17072020', 'OUXT0V6QDK', NULL, 'Garage Door', '1', 1000, 3000.00, 3000000.00, '2020-07-17 04:45:46'),
(47, 'SMCPD-2288-17072020', 'OUXT0V6QDK', NULL, 'Locks', '1', 2000, 450.00, 900000.00, '2020-07-17 05:11:45'),
(48, 'SMCPD-5802-17072020', '', NULL, 'Iron rod', '1', 2000, 6000.00, 12000000.00, '2020-07-17 05:24:53'),
(49, 'SMCPD-7371-17072020', '', NULL, 'Iron rod', '1', 100, 6500.00, 650000.00, '2020-07-17 05:30:00'),
(50, 'SMCPD-1511-20072020', 'OUXT0V6QDK', NULL, 'Mable Brand', '1', 3000, 500.00, 1500000.00, '2020-07-20 01:02:55'),
(51, 'SMCPD-3143-31072020', 'GUSEI1GTD7', 'Amcus Limiteds', 'Checked Steel Plate 3X1200X1200mm', '1', 1000, 65.00, 65000.00, '2020-07-31 05:40:00'),
(52, 'SMCPD-3813-14092020', 'OUXT0V6QDK', NULL, 'Steel Plate', '1', 1500, 50.00, 75000.00, '2020-09-14 05:38:54'),
(53, 'SMCPD-2781-14092020', 'OUXT0V6QDK', NULL, '12mm  Concrete Reinforcement', '1', 1000, 90.00, 90000.00, '2020-09-14 05:45:03'),
(54, 'SMCPD-4134-14092020', 'OUXT0V6QDK', 'Mankind Inc xxxxx', 'Checked Steel Plate 3X1200X1200mm', '1', 70, 1200.00, 84000.00, '2020-09-14 05:45:46'),
(55, 'SMCPD-4155-16092020', 'LSSZG1K90G', 'Ikota Ola Granite', 'Checked Steel Plate 3X1200X1200mm', '1', 70, 1200.00, 84000.00, '2020-09-14 05:45:46'),
(56, 'SMCPD-7019-02102020', 'ILZC55NDNR', NULL, '16mm  Concrete Reinforcement', '1', 5, 6600.00, 33000.00, '2020-10-02 00:55:09');

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

--
-- Table structure for table `supplier_tools_machinery`
--

CREATE TABLE `supplier_tools_machinery` (
  `toolId` int(11) NOT NULL,
  `tool_code` varchar(50) DEFAULT NULL,
  `supplier_code` varchar(50) DEFAULT NULL,
  `supplier_name` varchar(255) DEFAULT NULL,
  `tool_type` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `others` varchar(255) DEFAULT NULL,
  `procurement_type` varchar(255) DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `comment` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_tools_machinery`
--

INSERT INTO `supplier_tools_machinery` (`toolId`, `tool_code`, `supplier_code`, `supplier_name`, `tool_type`, `description`, `others`, `procurement_type`, `created_by`, `created_on`, `comment`) VALUES
(1, 'STMCPD-9172-15082020', 'GSIJV7ECKV', 'Cement Supplier Wale', 'Machinery', 'Tractor', '', 'Lease', 'Adebola Salami', '2020-08-15 06:34:08', 'Testing Engine'),
(2, 'STMCPD-5190-15082020', 'GSIJV7ECKV', 'Cement Supplier Wale', 'Others', 'Tractor 5690', 'Ringers ', 'Lease', 'Adebola Salami', '2020-08-15 07:04:39', 'Testing Engine 56 8980'),
(3, 'STMCPD-3525-22082020', 'LEMFJVLZPE-22082020', 'Solid Foundation Inc', 'Tool', 'Scrapper Ladder', '', 'Sale', 'Adebola Salami', '2020-08-22 21:48:09', 'Railing on'),
(4, 'STMCPD-6970-22082020', 'W5AF9ZLG8B-22082020', 'Solid Foundation Inc', 'Tool', 'Scrapper Ladder', '', 'Sale', 'Adebola Salami', '2020-08-22 22:00:51', 'Railing on'),
(5, 'STMCPD-8637-22082020', 'QGGDLZSSOO-22082020', 'Solid Foundation Inc', 'Tool', 'Scrapper Ladder', '', 'Sale', 'Adebola Salami', '2020-08-22 22:08:06', 'Railing on'),
(6, 'STMCPD-6963-02102020', 'ILZC55NDNR', 'Greenow Supplies LLC', 'Tools', 'Plum/Leveler', '', 'Lease', 'Adebola Salami', '2020-10-02 01:31:18', 'testing testing 78780');

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

--
-- Table structure for table `tea`
--

CREATE TABLE `tea` (
  `id` int(11) NOT NULL,
  `teaID` 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 `tea`
--

INSERT INTO `tea` (`id`, `teaID`, `type`, `credit`, `debit`, `total`, `dateAdded`) VALUES
(1, 'TEAO020', NULL, 67.00, 67.00, NULL, '2017-12-29'),
(2, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(3, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(4, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(5, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(6, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(7, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(8, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(9, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(10, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(11, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(12, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(13, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(14, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(15, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-29'),
(16, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(17, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(18, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(19, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(20, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(21, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(22, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(23, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(24, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(25, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(26, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(27, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(28, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(29, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(30, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(31, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-30'),
(32, 'TEAO020', NULL, 54.00, 32.00, NULL, '2017-12-30'),
(33, 'TEAO020', NULL, 0.00, 0.00, NULL, '2017-12-31');

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

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
  `tenant_id` int(11) NOT NULL,
  `tenant_code` varchar(20) DEFAULT NULL,
  `title` varchar(10) NOT NULL,
  `fullName` varchar(100) DEFAULT NULL,
  `phone_num` varchar(30) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `project_details` varchar(200) DEFAULT NULL,
  `flat_desc` varchar(50) NOT NULL,
  `flat_code` varchar(40) DEFAULT NULL,
  `annual_rent` float(12,2) NOT NULL DEFAULT 0.00,
  `comment` text DEFAULT NULL,
  `status` enum('Y','N') DEFAULT 'Y',
  `date_added` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tenants`
--

INSERT INTO `tenants` (`tenant_id`, `tenant_code`, `title`, `fullName`, `phone_num`, `email`, `project_name`, `project_details`, `flat_desc`, `flat_code`, `annual_rent`, `comment`, `status`, `date_added`) VALUES
(1, 'TCJKRYPHVS5H', '', 'Obafemi Awobokuny', '07033243021', 'obafemiawobokuny@gmail.com', NULL, 'SSP238684', 'FLAT 1 - Ground Floor - 2-Bed Flat', 'PFCLISPJBFK', 12500.00, 'Update amount later y', 'Y', '2020-07-28 05:33:04'),
(2, 'TC7AVCHYRFDQ', 'Mr', 'Bamidele Shola', '08093680295', 'bamsholla@yahoo.com', NULL, 'SSP238684', 'FLAT 2 - Ground Floor - 2-Bed Flat', 'PFCIOAP6V04', 1200.00, 'Update amount later', 'Y', '2015-06-22 08:38:49'),
(3, 'TC4G6DC8KGVH', 'Miss', 'Toyin Awesu', '08174973125', 'toyin.awesu@gmail.com', NULL, 'SSP238684', 'FLAT 3 - First Floor - 1-Bed Flat', 'PFCH4FBXFYC', 1200.00, 'Update amount later', 'Y', '2015-06-22 08:43:22'),
(4, 'TCW7MPJKP4GD', 'Miss', 'Wunmi George-Taylor', '08064664992', 'wunmigeorgetaylor@gmail.com', NULL, 'SSP238684', 'FLAT 4 - First Floor - 1-Bed Flat with Store', 'PFCHMCMO8KL', 1200.00, 'Update amount later', 'Y', '2015-06-22 08:52:07'),
(5, 'TCXSD93FU2KG', 'Miss', 'Funke Akintemi', '07062022441', 'funke07@yahoo.co.uk', NULL, 'SSP238684', 'FLAT 5 - First Floor - 1-Bed Flat', 'PFCOPMPYJ09', 1200.00, 'Update amount later', 'Y', '2015-06-22 08:55:04'),
(6, 'TCGYFISROSSZ', 'Miss', 'Anwuli Okeke', '07053168995', 'anwuli.b.okeke@gmail.com', NULL, 'SSP238684', 'FLAT 6 - First Floor - 1-Bed Flat with Store', 'PFCIJEJUJJL', 1200.00, 'Update amount later', 'Y', '2015-06-22 09:01:17'),
(7, 'TCHXE4UIISDT', 'Miss', 'Omolara Martins', '07014617457', 'omoloaramartins@yahoo.com', NULL, 'SSP238684', 'FLAT 7 - Pent Floor - 1-Bed Flat with big terrace', 'PFCQYYVTWKT', 1200.00, 'Update amount later', 'Y', '2015-06-22 09:09:05'),
(8, 'TCBIRSOSO4RZ', 'Miss', 'Tolulope Mebude', '08069304989', 'mebudetolulope@gmail.com', NULL, 'SSP238684', 'FLAT 8 - Pent Floor - 1-Bed Flat with big terrace', 'PFCCFNFSSQF', 1200.00, 'Update amount later 08097489086', 'Y', '2015-06-22 09:15:10'),
(9, 'TCPD35590507-2020', '', 'Banke Reeds', '34245612327', 'coolbolly2000@gmail.com', NULL, 'SSP368434', 'FLAT 1 - Ground Floor - 2-Bed Flat', 'PFCLISPJBFK', 120000.00, 'test6767', 'Y', '2020-07-12 00:05:26'),
(10, 'TCPD58404207-2020', '', 'Rike Duke', '2345678989', 'coolbolly2000@gmail.com', NULL, 'SSP960071', '3 Bedroom Duplex', 'PFCK1EH0GHF', 300000.00, 'testing ', 'Y', '2020-07-12 00:14:34'),
(11, 'TCPD26801907-2020', '', 'Mope Abdul', '2345678989', 'coolbolly2000@gmail.com', NULL, 'SSP368434', 'Second Floor 3 bedroom Duplex ', 'FCPD97680307-2020', 500000.00, 'testing6767', 'Y', '2020-07-12 01:07:35'),
(12, 'TCPD43371007-2020', '', 'Green Lantern', '2341232343', 'it@compositepropertydevelopment.com', NULL, 'SSP960071', 'Studio Apartment First floor', 'FCPD33730407-2020', 1500000.00, 'testing testing', 'Y', '2020-07-28 03:53:06'),
(13, 'TCPD96726607-2020', '', 'Green Lantern', '2341232343', 'it@compositepropertydevelopment.com', NULL, 'SSP960071', 'Studio Apartment First floor', 'FCPD33730407-2020', 1500000.00, 'testing testing', 'Y', '2020-07-28 03:54:53'),
(14, 'TCPD90634507-2020', '', 'Rayon Cliffton', '5634524356', 'it@compositepropertydevelopment.com', NULL, 'SSP627497', '3 Bedroom Duplex', 'PFCK1EH0GHF', 300000.00, 'Real estate development', 'Y', '2020-07-28 04:00:28'),
(15, 'TCPD64378207-2020', '', 'Jagunmolu Oba', '6745364546', 'it@compositepropertydevelopment.com', NULL, 'SSP238684', 'FLAT 1 - Ground Floor - 2-Bed Flat', 'PFCLISPJBFK', 1500000.00, 'almost', 'Y', '2020-07-28 04:06:21'),
(16, 'TCPD57229507-2020', '', 'Jagunmolu Oba', '6745364546', 'it@compositepropertydevelopment.com', NULL, 'SSP238684', 'FLAT 1 - Ground Floor - 2-Bed Flat', 'PFCLISPJBFK', 1500000.00, 'almost', 'Y', '2020-07-28 04:06:59'),
(17, 'TCPD89847507-2020', '', 'Resse Joy', '6534253635', 'it@compositepropertydevelopment.com', NULL, 'SSP238684', '4 bedroom Pent house', 'FCPD90673107-2020', 2000000.00, 'done deal', 'Y', '2020-07-28 04:10:29'),
(18, 'TCPD84028307-2020', '', 'Joy Rays', '7645676452', 'it@compositepropertydevelopment.com', NULL, 'SSP238684', 'FLAT 1 - Ground Floor - 2-Bed Flat', 'PFCLISPJBFK', 3500000.00, 'testing on going', 'Y', '2020-07-28 04:18:44'),
(19, 'TCPD43064507-2020', '', 'Joy Rays', '7645676452', 'it@compositepropertydevelopment.com', NULL, 'SSP238684', 'FLAT 1 - Ground Floor - 2-Bed Flat', 'PFCLISPJBFK', 3500000.00, 'testing on going', 'Y', '2020-07-28 04:19:08'),
(20, 'TCPD67392607-2020', '', 'Reign Dwayne', '7856453423', 'it@compositepropertydevelopment.com', NULL, 'SSP238684', 'Second Floor 3 bedroom Duplex ', 'FCPD97680307-2020', 800000.00, 'real going ', 'Y', '2020-07-28 04:20:48'),
(21, 'TCPD55148107-2020', 'Mr', 'Yonnese Rigges', '2314252415', 'it@compositepropertydevelopment.com', 'IKOYI OFFICE RENOVATION', 'SSP368434', 'Pent House  67', 'FCPD22479007-2020', 2500000.00, 'testing testing', 'Y', '2020-07-30 21:00:12');

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

--
-- Table structure for table `tobacco`
--

CREATE TABLE `tobacco` (
  `id` int(11) NOT NULL,
  `tobaccoID` 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 `tobacco`
--

INSERT INTO `tobacco` (`id`, `tobaccoID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'TOBA024', 56.00, 78.00, '2017-12-30'),
(2, 'TOBA024', 56.00, 78.00, '2017-12-30'),
(3, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(4, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(5, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(6, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(7, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(8, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(9, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(10, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(11, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(12, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(13, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(14, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(15, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(16, 'TOBA024', 0.00, 0.00, '2017-12-30'),
(17, 'TOBA024', 78.00, 67.00, '2017-12-30'),
(18, 'TOBA024', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `tools_and_machinery`
--

CREATE TABLE `tools_and_machinery` (
  `idno` int(11) NOT NULL,
  `project_code` varchar(100) DEFAULT NULL,
  `supplier_code` varchar(100) DEFAULT NULL,
  `supplier_name` varchar(255) DEFAULT NULL,
  `item_code` varchar(100) DEFAULT 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,
  `request_type` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tools_and_machinery`
--

INSERT INTO `tools_and_machinery` (`idno`, `project_code`, `supplier_code`, `supplier_name`, `item_code`, `company`, `address`, `contact_person`, `contact_mobile`, `ofc_phone`, `description`, `quantity`, `unit_price`, `total_price`, `payment_mode`, `comment`, `date_added`, `request_type`) VALUES
(1, 'CPD502772', '0BMWOJLU4S', NULL, 'ITCPD-5894', 'Bending Iron Incs', 'Test road lanes', 'Ady Roses', '2134251673', '3214543453', 'Lane Ropes', 2500, 150, 375000.00, 'Bank', 'testing testing 12345', '2020-07-27 02:05:25', NULL),
(3, 'CPD537884', 'W5AF9ZLG8B-22082020', 'Solid Foundation Inc', 'ITCPD-221880-22082020', 'Solid Foundation Inc', 'Testrale Road', 'Jame Luke', '346575575', '4563746475', 'Scrapper Ladder', 2, 1100, 2200.00, 'Transfer', 'Railing on', '2020-08-22 22:00:51', 'Tool'),
(4, 'CPD537884', 'QGGDLZSSOO-22082020', 'Solid Foundation Inc', 'ITCPD-474863-22082020', 'Solid Foundation Inc', 'Testrale Road', 'Jame Luke', '346575575', '4563746475', 'Scrapper Ladder', 2, 1100, 2200.00, 'Transfer', 'Railing on', '2020-08-22 22:08:06', 'Tool'),
(5, 'CPD537884', 'NQLPSCJSWS', 'Sturdy', 'ITCPD-966455-22082020', '', '', '', '', '', 'bamboo', 1, 3200, 3200.00, 'Cash', 'testing rented tool', '2020-08-22 23:33:17', 'Tools and Machinery - Rent'),
(6, 'CPD374831', '7Q8968U0NE', '', 'ITCPD-922828-23082020', '', '', '', '', '', '', 5, 0, 0.00, '', 'pick from store 9', '2020-08-23 00:01:56', 'Tools and Machinery - Take From Store');

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

--
-- Table structure for table `tool_from_store`
--

CREATE TABLE `tool_from_store` (
  `idno` int(11) NOT NULL,
  `tool_from_store_code` varchar(100) DEFAULT NULL,
  `tool_name` varchar(255) DEFAULT NULL,
  `quantity` varchar(20) DEFAULT NULL,
  `picked_by` varchar(100) DEFAULT NULL,
  `picked_on` datetime DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `returned_on` datetime DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `project_code` varchar(100) DEFAULT NULL,
  `request_type` varchar(100) DEFAULT NULL,
  `comment` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tool_from_store`
--

INSERT INTO `tool_from_store` (`idno`, `tool_from_store_code`, `tool_name`, `quantity`, `picked_by`, `picked_on`, `status`, `returned_on`, `project_name`, `project_code`, `request_type`, `comment`) VALUES
(1, 'TFSCPD - IRZQRNDSMS', 'Tractor 9', '9', 'Adebola Salami', '2020-08-23 00:18:36', 'Returned', '2020-08-23 01:26:15', 'Bode Peters ', 'CPD374831', 'Tools and Machinery - Take From Store', 'Returned by John Lake'),
(2, 'TFSCPD - V72L0LMUDF', 'Welding Machine/Generator', '1', 'Adebola Salami', '2020-10-04 03:58:22', 'Returned', '2021-10-18 15:32:58', 'Graceland Kick off', 'CPD645503', 'Tools and Machinery - Take From Store', ''),
(3, 'TFSCPD - 5KYJC0M0TP', 'Welding Machine/Generator', '1', 'Adebola Salami', '2020-10-04 04:05:30', 'Returned', '2021-10-18 15:31:11', 'Graceland Kick off', 'CPD645503', 'Tools and Machinery - Take From Store', 'DD'),
(4, 'TFSCPD - SPYIDRHK3U', 'Welding Machine/Generator', '1', 'Adebola Salami', '2020-10-04 04:30:56', 'Returned', '2021-10-18 15:31:22', 'Greyland', 'CPD346846', 'Tools and Machinery - Take From Store', ''),
(5, 'TFSCPD - GVU262UVCV', 'Wheelbarrow', '2', 'Adebola Salami', '2021-09-06 18:28:55', 'Returned', '2021-10-15 08:04:17', 'ELF3 - Abake Court', 'SSP960071', 'Tools and Machinery - Take From Store', '');

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

--
-- Table structure for table `tracker`
--

CREATE TABLE `tracker` (
  `idno` int(11) NOT NULL,
  `userid` varchar(20) NOT NULL,
  `action_on` int(20) DEFAULT NULL,
  `computer_ip` varchar(200) DEFAULT NULL,
  `logdate` timestamp NULL DEFAULT current_timestamp(),
  `activity` varchar(200) DEFAULT NULL,
  `category` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `uploaded_images`
--

CREATE TABLE `uploaded_images` (
  `img_id` int(11) NOT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `project_code` varchar(100) DEFAULT NULL,
  `image_path1` varchar(255) DEFAULT NULL,
  `image_path2` varchar(255) DEFAULT NULL,
  `image_path3` varchar(255) DEFAULT NULL,
  `image_path4` varchar(255) DEFAULT NULL,
  `image_path5` varchar(255) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uploaded_images`
--

INSERT INTO `uploaded_images` (`img_id`, `project_name`, `project_code`, `image_path1`, `image_path2`, `image_path3`, `image_path4`, `image_path5`, `createdOn`, `createdBy`) VALUES
(1, 'Bode Peters ', 'CPD374831', '../../../uploads/vlcsnap-2020-03-08-20h21m08s488.png', '../../../uploads/dsds.png', '../../../uploads/vlcsnap-2019-11-07-03h47m47s262.png', '../../../uploads/vlcsnap-2019-11-04-14h06m00s258.png', '../../../uploads/vlcsnap-2019-10-24-00h31m33s210.png', '2021-02-26 11:25:45', 'Adebola&nbsp;Salami'),
(2, 'Bode Peters ', 'CPD374831', '../../../uploads/', '', '', '', '', '2021-02-26 13:00:56', 'Adebola&nbsp;Salami'),
(3, 'Bode Peters ', 'CPD374831', '../../../uploads/vlcsnap-2020-03-08-20h21m08s488.png', '../../../uploads/dsds.png', '../../../uploads/vlcsnap-2019-11-07-03h47m47s262.png', '../../../uploads/vlcsnap-2019-11-04-14h06m00s258.png', '../../../uploads/vlcsnap-2019-10-24-00h31m33s210.png', '2021-02-26 13:10:37', 'Adebola&nbsp;Salami'),
(0, 'Bode Peters ', 'CPD374831', '../../../uploads/passport2.jpg', '', '', '', '', '2021-10-15 08:06:12', 'Golden Ogbeka');

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

--
-- Table structure for table `users_description`
--

CREATE TABLE `users_description` (
  `id` int(11) NOT NULL,
  `user_type` varchar(10) DEFAULT NULL,
  `user_desc` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_description`
--

INSERT INTO `users_description` (`id`, `user_type`, `user_desc`) VALUES
(1, 'STAFF', 'Neutral access. Would be able to send requests and reports'),
(2, 'ADMIN', 'Super admin access. Can add project, approve request and perform top administrator functions'),
(3, 'CLIENT', 'Owners of projects. They can view their projects and can be added into flats'),
(4, 'SUPERVISOR', 'Task is to vet requests for admin approval');

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

--
-- Table structure for table `user_rights`
--

CREATE TABLE `user_rights` (
  `idno` int(11) NOT NULL,
  `userid` varchar(20) NOT NULL,
  `rightid` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_rights`
--

INSERT INTO `user_rights` (`idno`, `userid`, `rightid`) VALUES
(1, 'SSREI001', '100'),
(2, 'SSREI001', '101'),
(3, 'SSREI002', '101'),
(4, 'SSREI002', '100'),
(5, 'SSREI001', '105'),
(6, 'SSREI001', '102'),
(8, 'SSREI001', '103'),
(9, 'SSREI001', '104'),
(10, 'SSREI001', '106'),
(11, 'SSREI002', '105'),
(12, 'SSREI002', '102'),
(13, 'SSREI002', '103'),
(14, 'SSREI002', '104'),
(15, 'SSREI002', '106'),
(16, 'SSREI002', '107'),
(17, 'SSREI001', '107'),
(18, 'SSREI001', '108'),
(19, 'SSREI002', '108'),
(20, 'SSREI002', '109'),
(21, 'SSREI001', '109'),
(22, 'SSREI001', '110'),
(23, 'SSREI002', '110'),
(24, 'SSREI002', '111'),
(25, 'SSREI001', '111'),
(26, 'SSREI004', '100'),
(27, 'SSREI004', '106'),
(28, 'SSREI004', '107'),
(29, 'SSREI004', '108'),
(30, 'SSREI004', '102'),
(31, 'SSREI004', '101'),
(32, 'SSREI001', '112'),
(33, 'SSREI002', '112'),
(34, 'SSREI002', '113'),
(35, 'SSREI001', '113'),
(36, 'SSREI001', '114'),
(37, 'SSREI002', '114'),
(38, 'SSREI002', '115'),
(39, 'SSREI001', '115'),
(40, 'SSREI001', '116'),
(41, 'SSREI001', '117'),
(42, 'SSREI001', '118'),
(43, 'SSREI001', '119'),
(44, 'SSREI001', '120'),
(45, 'SSREI001', '121'),
(46, 'SSREI002', '121'),
(47, 'SSREI002', '120'),
(48, 'SSREI002', '119'),
(49, 'SSREI002', '118'),
(50, 'SSREI002', '117'),
(51, 'SSREI002', '116'),
(52, 'SSREI002', '122'),
(53, 'SSREI002', '123'),
(54, 'SSREI001', '122'),
(55, 'SSREI001', '123'),
(56, 'SSREI007', '118'),
(57, 'SSREI007', '117'),
(58, 'SSREI007', '114'),
(59, 'SSREI007', '115'),
(60, 'SSREI001', '124'),
(61, 'SSREI001', '125'),
(62, 'UCPD56209252', '103'),
(63, 'UCPD56209252', '112'),
(64, 'UCPD56209252', '113'),
(65, 'UCPD56209252', '126'),
(66, 'UCPD56209252', '127'),
(67, 'SSREI001', '127'),
(68, 'SSREI001', '128');

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

--
-- Table structure for table `water`
--

CREATE TABLE `water` (
  `id` int(11) NOT NULL,
  `waterID` 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 `water`
--

INSERT INTO `water` (`id`, `waterID`, `credit`, `debit`, `dateAdded`) VALUES
(1, 'WATE025', 45.00, 45.00, '2017-12-30'),
(2, 'WATE025', 0.00, 0.00, '2017-12-30'),
(3, 'WATE025', 0.00, 0.00, '2017-12-30'),
(4, 'WATE025', 0.00, 0.00, '2017-12-30'),
(5, 'WATE025', 0.00, 0.00, '2017-12-30'),
(6, 'WATE025', 0.00, 0.00, '2017-12-30'),
(7, 'WATE025', 0.00, 0.00, '2017-12-30'),
(8, 'WATE025', 0.00, 0.00, '2017-12-30'),
(9, 'WATE025', 0.00, 0.00, '2017-12-30'),
(10, 'WATE025', 0.00, 0.00, '2017-12-30'),
(11, 'WATE025', 0.00, 0.00, '2017-12-30'),
(12, 'WATE025', 0.00, 0.00, '2017-12-30'),
(13, 'WATE025', 0.00, 0.00, '2017-12-30'),
(14, 'WATE025', 0.00, 0.00, '2017-12-30'),
(15, 'WATE025', 54.00, 12.00, '2017-12-30'),
(16, 'WATE025', 0.00, 0.00, '2017-12-31');

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

--
-- Table structure for table `worker`
--

CREATE TABLE `worker` (
  `idno` int(11) NOT NULL,
  `w_code` varchar(50) NOT NULL,
  `w_name` varchar(250) DEFAULT NULL,
  `w_company` varchar(250) DEFAULT NULL,
  `w_address` varchar(250) DEFAULT NULL,
  `w_email` varchar(100) DEFAULT NULL,
  `w_mobile` varchar(20) DEFAULT NULL,
  `w_home_phone` varchar(20) NOT NULL,
  `w_ofc_phone` varchar(20) DEFAULT NULL,
  `service_type` varchar(200) NOT NULL,
  `section` varchar(100) DEFAULT NULL,
  `w_source` varchar(100) DEFAULT NULL,
  `site_management` varchar(100) DEFAULT NULL,
  `project_code` varchar(30) DEFAULT NULL,
  `w_service` varchar(100) DEFAULT NULL,
  `w_service_charge` float(12,2) DEFAULT NULL,
  `amount_paid` float NOT NULL DEFAULT 0,
  `outstanding_balance` float NOT NULL DEFAULT 0,
  `date_added` date NOT NULL,
  `date_assigned_to_project` datetime DEFAULT NULL,
  `comment` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `worker`
--

INSERT INTO `worker` (`idno`, `w_code`, `w_name`, `w_company`, `w_address`, `w_email`, `w_mobile`, `w_home_phone`, `w_ofc_phone`, `service_type`, `section`, `w_source`, `site_management`, `project_code`, `w_service`, `w_service_charge`, `amount_paid`, `outstanding_balance`, `date_added`, `date_assigned_to_project`, `comment`) VALUES
(3, 'SSW8617', 'Batholomew Hanslou', 'Batholomew Mason', 'Reign Lakewood road', 'bhs@gmail.com', '+2348183507961', '3425364736', '+22997026891', 'Mason', 'Quantity Surveing', 'In-house/Employee', 'Site/Store Keeper', '', '', 0.00, 0, 0, '2020-07-15', NULL, 'Masonry jobs new'),
(5, 'SSW2957', 'TAPUP', 'Tapup casting ltd', 'Jungle Boulevard', 'jct@gmail.com', '08120180422', '2314234345', '08037156152', 'Brick Layer', 'Architecture', 'In-house/Employee', 'Site/Store Keeper', '', '', 0.00, 0, 0, '2020-07-15', NULL, 'testing testing 6787'),
(7, 'SSW1410', 'FEMI ( LABOURSITE)', 'Jarus Limited', 'Tennesse Road', 'fl@gmail.com', '07034959108', '2345454545', '6767564534', 'Data / Video / Voice Cabling', 'Architecture', 'In-house/Employee', 'Site/Store Keeper', '', '', 0.00, 0, 0, '2020-07-31', NULL, 'testing testing'),
(8, 'SSW8281', 'Mrs DADA  08034447286', 'Lagos state material testing laboratory', 'SUITE 41/42, Sebuff plaza, km14, epe expessway, osapa london, lekki lagos', 'mdada@gmail.com', '08034447286', '4545343423', '08082961694', 'Painter', 'Architecture', 'In-house/Employee', 'Site/Store Keeper', '', '', 0.00, 0, 0, '2020-07-15', NULL, 'testing testing'),
(9, 'SSW4821', 'Folabi Eegun', 'Folabi Eegun Bricklayer', 'Ilaro', 'falabi@gmail.com', '08039364131', '08051910084', '4545454543', 'Masonry', 'Architecture', 'In-house/Employee', 'Site/Store Keeper', '', '', 0.00, 0, 0, '2020-07-14', NULL, 'testing testing 6767456'),
(10, 'SSW9017', 'In-house Buyer', 'Sturdy In-house procurement Unit', '43 Raymond Njoku Street, Off Awolowo Road, Ikoyi, Lagos.', '', '08025010233', '', '', 'Procurement', NULL, NULL, NULL, 'SSP960071', NULL, NULL, 0, 0, '2015-02-24', NULL, 'These are materials bought directly by a Sturdy shelter personnel (procurement Unit)'),
(11, 'SSW7251', 'Gbenga Iron Bender', 'Iron Bending Eegun', 'Ilaro', 'gib@gmail.com', '08069510693', '3452356789', '07054609557', 'Capental', 'Architecture', 'In-house/Employee', 'Site/Store Keeper', '', '', 0.00, 0, 0, '2020-07-15', NULL, 'Tow foundations and columns ggtg'),
(12, 'SSW9489', 'Carpenter Sunday Dansu', 'Eegun Capenter Sunday', 'Ilaro 787', 'it@compositepropertydevelopment.coms', '08039640539', '1236789099', '5436725369', 'Carpentry', NULL, NULL, NULL, 'CPD537884', '', 0.00, 0, 0, '2020-08-11', '2020-08-11 06:33:35', 'Carpentry works testing'),
(13, 'SSW3594', 'Adebola Salamix', 'Quaysoft Limitedx', '12 Eric Moore Streetx', 'coolbolly2000@gmail.com', '09089897878', '080654323129', '0129114039', 'Consulting', NULL, NULL, NULL, 'SSP135694', NULL, NULL, 120000, 0, '2015-03-03', NULL, 'testing'),
(14, 'SSW6024', 'Kiisi Salami', 'Newton Tech', 'Winger Road', 'coolbolly2000@gmail.com', '08090906833911', '012911403', '08033043900', 'Consulting', NULL, NULL, NULL, 'SSP627497', NULL, NULL, 0, 0, '2015-03-09', NULL, 'testing'),
(15, 'SSW8997', 'Plumber Sunday', 'Sunsay Plumbing', 'Sango', 'suns@gmail.com', '080553135331', '2314234545', '4545454321', 'Brick Layer', 'Architecture', 'In-house/Employee', 'Site/Store Keeper', '', '', 0.00, 0, 0, '2020-07-15', NULL, 'Plumbing piping, fixtures and repairs real deal'),
(16, 'SSW2470', 'Waheed Aloba', 'Aloba Electrical company', 'Otta, Ogun state', 'jgh@gmail.com', '07033446033', '2341234545', '08059020730', 'Electrical Installations and Fittings', 'Architecture', 'In-house/Employee', 'Site/Store Keeper', '', '', 0.00, 0, 0, '2020-07-14', NULL, 'testing going on'),
(17, 'SSW2869', 'Jason Hairston', 'Textile Limited', 'Ring Road', 'coolbolly2000@gmail.com', '2135678909', '01897867565', '2341234343', 'First Class', NULL, NULL, NULL, 'SSP774658', NULL, NULL, 0, 0, '2019-09-01', NULL, 'Test 2019 B'),
(18, 'SSW3544', 'Lessi', 'Wonderful Creation', '1000 Hatches Mill Drive', 'coolbolly2000@gmail.com', '2134567890', '2134567890', '2134567890', 'Delear', NULL, NULL, NULL, 'SSP960071', NULL, NULL, 0, 0, '2019-10-03', NULL, 'Testing'),
(19, 'SSW5214', 'Ajay Ray', 'Serma Right', 'Test 12', 'kc2000@gmail.com', '2134567890', '2134567890', '2134567890', 'Delear', 'Quantity Surveing', 'In-house/Employee', 'Site/Store Keeper', 'SSP260243', NULL, NULL, 0, 0, '2019-10-20', NULL, 'Right of way'),
(20, 'WCPD-42968-12072020', 'Seyi Tisdale', 'Mandate Joy Limited', '4 Ring Road', 'coolbolly2000@gmail.com', '2222222222', '4444444444', '5555555555', 'Delear', 'Quantity Surveing', 'In-house/Employee', 'Site/Store Keeper', 'CPD271750', '', 0.00, 0, 0, '2020-07-12', NULL, 'Test8989'),
(21, 'WCPD-64897-12072020', 'Merosa Lyle', 'Raymong Liga', '45 Trinton Derby Road', 'cooolbolly2000@gmail.com', '2345678909', '123456890', '234567887', 'Temp', 'Architecture', 'Consultant', 'Site Security', '', '', 0.00, 0, 0, '2020-07-12', NULL, 'Reading whole'),
(22, 'WCPD-50884-12072020', 'Renae Walker', 'Regning King', 'Tetimony Road', 'aligh@gmail.com', '2314132415', '2314132415', '2314132415', 'Tiling', 'Quantity Surveing', 'In-house/Employee', '', 'SSP960071', '', 0.00, 0, 0, '2020-07-12', NULL, 'Read or not'),
(23, 'WCPD-97422-12072020', 'Jeans Levis', 'Levis Limited', 'Territory Road', 'js@gmail.com', '4545454536', '2345343534', '123453353', 'Delear', 'Mechanical Engineering', 'In-house/Employee', 'Site/Store Keeper', 'CPD271750', '', 0.00, 0, 0, '2020-07-12', NULL, 'testing'),
(24, 'WCPD-55816-12072020', 'Jeans Levis', 'Levis Limited', 'Territory Road', 'js@gmail.com', '4545454536', '2345343534', '123453353', 'Delear', 'Mechanical Engineering', 'In-house/Employee', 'Site/Store Keeper', 'CPD271750', '', 0.00, 0, 0, '2020-07-12', NULL, 'testing'),
(25, 'WCPD-54308-12072020', 'Jeans Levis', 'Levis Limited', 'Territory Road', 'js@gmail.com', '4545454536', '2345343534', '123453353', 'Delear', 'Mechanical Engineering', 'In-house/Employee', 'Site/Store Keeper', 'CPD271750', '', 0.00, 0, 0, '2020-07-12', NULL, 'testing'),
(26, 'WCPD-34247-15072020', 'Renum June', 'Reignite Inc', 'Reign Avenue', 'rgt@gmail.com', '3425365434', '6765438790', '5647387453', 'Borehole', 'Architecture', 'Consultant', 'Site/Store Keeper', 'SSP260243', '', 0.00, 0, 0, '2020-07-15', NULL, 'Testing is going on'),
(27, 'WCPD-83884-15072020', 'Johnson Green', 'Tesla Testing Inc', '6767 Maybe isle', 'test@gmail.com', '5656354635', '1234237878', '8976546378', 'Brick Layer', 'Project Management', 'Consultant', 'Site Security', 'CPD403540', '', 0.00, 0, 0, '2020-07-15', NULL, 'ready to go'),
(28, 'WCPD-85589-15072020', 'Rilwan Tutu', 'Lionel Inc', '78789 Mandale Avenue', 'fgr@gmail.com', '5656345243', '2314253454', '6787243536', 'Capental', 'Electrical Engineering', 'In-house/Employee', 'Site Security', 'CPD403540', '', 0.00, 0, 0, '2020-07-15', NULL, 'testing testing 78'),
(29, 'WCPD-77782-20072020', 'Adeline Grey', 'Manner Reason', 'Testing Road Avenue', 'ghn@gmail.com', '2341526567', '2341526567', '2341526567', 'Cabinetry/Furniture', '', '', '', 'CPD403540', '', 0.00, 0, 0, '2020-07-20', NULL, 'Testing testing'),
(30, 'WCPD-17093-31072020', 'Johnson Gregory', 'Later Reign', 'Testing Avenue and 5th', 'john.greg@gmail.com', '5435362536', '2132425245', '6744637676', 'House Painting', 'Mechanical Engineering', 'Consultant', 'Site Security', 'CPD569506', '', 0.00, 0, 0, '2020-07-31', NULL, 'testing 656565'),
(31, 'WCPD-43418-11082020', 'Gamie June', 'Lolord Limited', 'Testing 565 Road', 'it@compositepropertydevelopment.com', '2134567890', '2134567890', '2354678909', 'Cleaning', NULL, NULL, NULL, 'CPD537884', '', 0.00, 0, 0, '2020-08-11', '2020-08-11 06:47:48', 'testing 676477'),
(32, 'WCPD-57765-23082020', 'Temple Reign', 'Skyline Tower', 'Falls Church', 'it@compositepropertydevelopment.com', '2344567589', '2344567589', '2344567589', 'Carpentry', NULL, NULL, NULL, 'CPD537884', NULL, NULL, 0, 0, '2020-08-23', '2020-08-23 05:07:49', 'Testing pop up'),
(33, 'WCPD-24901-23082020', 'Jogo Mann', 'CIM Community', 'Baileys Cross', 'it@compositepropertydevelopment.com', '2345768798', '2390895648', '2374598765', 'Carpentry', NULL, NULL, NULL, 'CPD537884', NULL, NULL, 0, 0, '2020-08-23', '2020-08-23 05:09:21', 'Testing pop up'),
(34, 'WCPD-88832-23082020', 'Jones Branch', 'CIM Realtor', 'Columbia Pike', 'it@compositepropertydevelopment.com', '3425656789', '4212778789', '2435678987', 'Borehole Drilling', NULL, NULL, NULL, 'SSP960071', NULL, NULL, 0, 0, '2020-08-23', '2021-10-15 07:56:08', 'Testing pop up'),
(35, 'WCPD-34609-23082020', 'Grace Hookie', 'Ampus Limited', '1110 Glen dale', 'it@compositepropertydevelopment.com', '3212345678', '3456789090', '3425678989', 'Borehole Drilling', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, '2020-08-23', '2020-08-23 18:09:14', 'Testing 676767'),
(36, 'WCPD-13266-23082020', 'Jeremiah Lakes', 'Lofty Inc', 'Riverdale Road', 'it@compositepropertydevelopment.com', '6746356545', '7878675645', '2345234525', 'Borehole Drilling', NULL, NULL, NULL, 'CPD537884', NULL, NULL, 0, 0, '2020-08-23', '2020-08-23 18:27:13', 'Testing 90'),
(37, 'WCPD-92388-23082020', 'Segun Mike', 'Jill Limited', 'Test 1010 Road', 'it@compositepropertydevelopment.com', '78787872827', '78787872827', '78787872827', 'Borehole Drilling', NULL, NULL, NULL, 'CPD537884', NULL, NULL, 0, 0, '2020-08-23', '2020-08-23 23:16:03', 'Testing pop up'),
(38, 'WCPD-32101-20092021', 'Golden Ogbeka', 'The Chicken Universe', 'No. 11 Alhaja Jaiyeola Street Alagbole', 'ogbekagolden@gmail.com', '08169200454', '08169200454', '08169200454', 'Cable TV Installation', NULL, NULL, NULL, 'CPD515886', 'WWW', 12.00, 0, 0, '2021-09-20', '2021-09-20 12:45:03', '23');

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

--
-- Table structure for table `worker_jobs`
--

CREATE TABLE `worker_jobs` (
  `idno` int(11) NOT NULL,
  `job_code` varchar(20) NOT NULL,
  `w_code` varchar(20) DEFAULT NULL,
  `project_code` varchar(20) DEFAULT NULL,
  `w_service` varchar(100) DEFAULT NULL,
  `w_service_charge` float(12,2) DEFAULT NULL,
  `amount_paid` float(12,2) DEFAULT NULL,
  `outstanding_balance` float(12,2) DEFAULT NULL,
  `comment` text NOT NULL,
  `date_added` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `worker_jobs`
--

INSERT INTO `worker_jobs` (`idno`, `job_code`, `w_code`, `project_code`, `w_service`, `w_service_charge`, `amount_paid`, `outstanding_balance`, `comment`, `date_added`) VALUES
(3, 'SJJQNIZZLTUT', 'SSW2957', 'SSP960071', 'Concrete casting', 165000.00, 40000.00, 125000.00, 'German floor blkA 55000\r\nRaft foundation blkB 110000', '2015-02-09 05:55:54'),
(4, 'AY3VP9GV91M4', 'SSW8617', 'SSP960071', 'foundation Digging and blinding', 60000.00, 60000.00, 0.00, 'Blinding and Digging for foundation A and B', '2015-02-09 09:30:18'),
(5, 'GOV43FH37PUL', 'SSW9550', 'SSP960071', 'Septic Tank digging', 120000.00, 60000.00, 60000.00, 'testting testing', '2015-02-10 14:44:11'),
(6, '6BVV0XRECCKV', 'SSW2957', 'SSP960071', 'casting of foundation', 165000.00, 165000.00, 0.00, 'german floor 55000; raft 110000 for raft B', '2015-02-24 10:56:01'),
(7, '1KKQSVDFGDVI', 'SSW4821', 'SSP960071', 'Block setting for 3000 blocks', 25000.00, 10000.00, 15000.00, 'testing 12345690', '2020-07-14 20:39:34'),
(8, 'RHOCWV4FZNMJ', 'SSW1410', 'SSP960071', 'filling of foundations A and B', 65000.00, 65000.00, 0.00, 'job completed. ', '2015-02-24 11:10:28'),
(9, 'ZLFUGTW1LXJG', 'SSW7251', 'SSP960071', 'Iron Bending', 260000.00, 260000.00, 0.00, 'Foundation A and B are added under Gbenga for ease of management', '2015-02-24 11:17:32'),
(10, 'VHAAR6PKGGRI', 'SSW2957', 'SSP960071', 'casting of columns ', 35000.00, 35000.00, 0.00, 'foundation A columns', '2015-02-24 11:20:25'),
(11, 'PNTSNGANRSIK', 'SSW9489', 'SSP960071', 'carpentry', 240000.00, 240000.00, 0.00, 'two foundations and columns', '2015-02-24 15:06:59'),
(12, 'H314IALKCGMB', 'SSW7251', 'SSP960071', 'columns and lintel for A and B', 60000.00, 50000.00, 10000.00, 'ground floor columns and lintels for blocks A and B', '2015-03-03 03:12:54'),
(13, 'I7RWX5YO6K5U', 'SSW9489', 'SSP960071', 'formwork for lintel and columns for A and B', 84000.00, 64000.00, 20000.00, 'lintel for B outstanding', '2015-03-03 03:17:27'),
(14, 'CLSB8XK7GKWS', 'SSW3594', 'SSP135694', 'Supervising', 350000.00, 150000.00, 200000.00, 'testing', '2015-03-03 09:11:32'),
(15, 'CTI2GNVMGBIK', 'SSW6024', 'SSP627497', 'Consulting', 200000.00, 50000.00, 150000.00, 'test67', '2015-03-09 10:22:29'),
(16, 'ISA94BGBESMD', 'SSW8997', 'SSP960071', 'piping for two deckings A and B', 60000.00, 30000.00, 30000.00, '30k per decking', '2015-04-06 06:02:38'),
(17, 'ILJ4NBYNPKHF', 'SSW9489', 'SSP960071', 'carpentry - formwork for decking A and B', 280000.00, 260000.00, 20000.00, 'formwork for decking A and B', '2015-04-06 07:45:40'),
(18, 'PVXENL0NGXCL', 'SSW7251', 'SSP960071', 'reinforcement for Deking firs floor A and B', 221000.00, 195000.00, 26000.00, '13k per ton for 17 tons fir floor reinforcement for A and B', '2015-04-06 08:00:31'),
(19, 'ZKUTMMWVFHKR', 'SSW2470', 'SSP960071', 'Eectrial Piping for Decking A and B elf3 first floor', 40000.00, 10000.00, 30000.00, '20K per deking', '2015-04-06 08:07:24'),
(20, 'BYBMZK8PC1FF', 'SSW1410', 'SSP960071', 'chisling and levelling', 70000.00, 150000.00, -80000.00, 'different chisling and levelling work', '2015-04-06 08:14:50'),
(21, 'WJCPD-4113-15072020', '', '', 'Capental', 12000.00, 4000.00, 8000.00, 'testing worker job', '2020-07-15 03:55:33'),
(22, 'WJCPD-2070-15072020', 'SSW7251', 'SSP960071', 'Electrician', 10000.00, 4000.00, 6000.00, 'testing 7', '2020-07-15 05:07:57'),
(23, 'WJCPD-7101-15072020', 'WCPD-83884-15072020', 'CPD403540', 'Electrician', 15000.00, 4000.00, 11000.00, 'TEST5', '2020-07-15 21:21:04'),
(24, 'WJCPD-7470-20072020', 'WCPD-77782-20072020', 'CPD403540', 'CCTV / Security Installation', 12000.00, 7000.00, 5000.00, 'Testing 78787890', '2020-07-20 04:39:45'),
(25, 'WJCPD-7463-31072020', 'WCPD-17093-31072020', 'CPD569506', 'Roofing', 12000.00, 12000.00, 0.00, 'testing', '2020-07-31 03:24:46');

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

--
-- Table structure for table `workflows`
--

CREATE TABLE `workflows` (
  `idno` int(11) NOT NULL,
  `workflow_name` varchar(30) NOT NULL,
  `approval_list` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `workflows`
--

INSERT INTO `workflows` (`idno`, `workflow_name`, `approval_list`) VALUES
(1, 'LOAN_APPROVAL', 'MCL010|MCL014|MCL002|MCL007|MCL001'),
(2, 'INVESTOR_APPROVAL', 'MCL001|MCL002|MCL009'),
(3, 'REPAYMENT', 'MCL001|MCL009'),
(4, 'PAYMENT', 'MCL001|MCL002|MCL007'),
(5, 'MEMO', 'MCL001|MCL010');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `cashadvance`
--
ALTER TABLE `cashadvance`
  ADD PRIMARY KEY (`cash_id`);

--
-- Indexes for table `contractorproject`
--
ALTER TABLE `contractorproject`
  ADD PRIMARY KEY (`contractorProID`);

--
-- Indexes for table `material`
--
ALTER TABLE `material`
  ADD PRIMARY KEY (`idno`);

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`idno`);

--
-- Indexes for table `project`
--
ALTER TABLE `project`
  ADD PRIMARY KEY (`idno`);

--
-- Indexes for table `request`
--
ALTER TABLE `request`
  ADD PRIMARY KEY (`idno`);

--
-- Indexes for table `staff`
--
ALTER TABLE `staff`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `staff_project`
--
ALTER TABLE `staff_project`
  ADD PRIMARY KEY (`idno`);

--
-- Indexes for table `stakeholderproject`
--
ALTER TABLE `stakeholderproject`
  ADD PRIMARY KEY (`stakeHolderProID`);

--
-- Indexes for table `startup_cost`
--
ALTER TABLE `startup_cost`
  ADD PRIMARY KEY (`idno`);

--
-- Indexes for table `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`idno`);

--
-- Indexes for table `supplier_materials`
--
ALTER TABLE `supplier_materials`
  ADD PRIMARY KEY (`mat_id`);

--
-- Indexes for table `tools_and_machinery`
--
ALTER TABLE `tools_and_machinery`
  ADD PRIMARY KEY (`idno`);

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

--
-- Indexes for table `worker`
--
ALTER TABLE `worker`
  ADD PRIMARY KEY (`idno`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cashadvance`
--
ALTER TABLE `cashadvance`
  MODIFY `cash_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `contractorproject`
--
ALTER TABLE `contractorproject`
  MODIFY `contractorProID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `material`
--
ALTER TABLE `material`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `project`
--
ALTER TABLE `project`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `request`
--
ALTER TABLE `request`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `staff_project`
--
ALTER TABLE `staff_project`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `stakeholderproject`
--
ALTER TABLE `stakeholderproject`
  MODIFY `stakeHolderProID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `startup_cost`
--
ALTER TABLE `startup_cost`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `supplier_materials`
--
ALTER TABLE `supplier_materials`
  MODIFY `mat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `tools_and_machinery`
--
ALTER TABLE `tools_and_machinery`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `worker`
--
ALTER TABLE `worker`
  MODIFY `idno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
COMMIT;

