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

START TRANSACTION;



--
-- Database: `gemsglo1_hrdb`
--

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

--
-- Table structure for table `activities_relations`
--

CREATE TABLE `activities_relations` (
  `relation_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `activity_start` datetime DEFAULT NULL,
  `activity_end` datetime DEFAULT NULL,
  `activity_status` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `activity_timeline`
--

CREATE TABLE `activity_timeline` (
  `span_id` int(11) NOT NULL,
  `activity_id` int(11) NOT NULL,
  `date_started` date NOT NULL,
  `date_completed` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `activity_timeline`
--

INSERT INTO `activity_timeline` (`span_id`, `activity_id`, `date_started`, `date_completed`) VALUES
(1, 1, '2020-08-15', '2020-08-15'),
(2, 2, '2020-08-15', NULL);

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

--
-- Table structure for table `bank_account`
--

CREATE TABLE `bank_account` (
  `wallet_id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `account_name` varchar(100) NOT NULL,
  `account_type` varchar(50) NOT NULL DEFAULT 'Savings',
  `account_number` int(11) DEFAULT NULL,
  `account_balance` double NOT NULL DEFAULT '0',
  `account_holder_id` int(11) NOT NULL,
  `account_holder_type` varchar(50) NOT NULL DEFAULT 'Business',
  `opening_balance` double NOT NULL DEFAULT '0',
  `closing_balance` double NOT NULL DEFAULT '0',
  `opening_date` date DEFAULT NULL,
  `closing_date` date DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Active'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bank_account`
--

INSERT INTO `bank_account` (`wallet_id`, `company_id`, `branch_id`, `account_name`, `account_type`, `account_number`, `account_balance`, `account_holder_id`, `account_holder_type`, `opening_balance`, `closing_balance`, `opening_date`, `closing_date`, `status`) VALUES
(1, 1, 1, 'Main Company Account', 'Business', NULL, 0, 1, 'Business', 0, 0, NULL, NULL, 'Active'),
(2, 1, 1, 'Company Investment Account', 'Investment', NULL, 0, 1, 'Business', 0, 0, NULL, NULL, 'Active'),
(3, 1, 1, 'Administrator', 'User', NULL, 0, 1, 'Business', 0, 0, NULL, NULL, 'Active'),
(4, 1, 1, 'CEO', 'User', NULL, 0, 2, 'Business', 0, 0, NULL, NULL, 'Active'),
(5, 1, 1, 'Default Branch Manager', 'User', NULL, 0, 3, 'Business', 0, 0, NULL, NULL, 'Active'),
(6, 1, 1, 'Default General Manager', 'User', NULL, 0, 4, 'Business', 0, 0, NULL, NULL, 'Active'),
(7, 1, 1, 'Default Manager', 'User', NULL, 0, 5, 'Business', 0, 0, NULL, NULL, 'Active'),
(8, 1, 1, 'Default Cashier', 'User', NULL, 0, 6, 'Business', 0, 0, NULL, NULL, 'Active'),
(9, 1, 1, 'Default Accountant', 'User', NULL, 0, 7, 'Business', 0, 0, NULL, NULL, 'Active'),
(10, 1, 1, 'Default Store Keeper', 'User', NULL, 0, 8, 'Business', 0, 0, NULL, NULL, 'Active'),
(11, 1, 1, 'Default Supplier', 'User', NULL, 228000, 9, 'Business', 0, 0, NULL, NULL, 'Active'),
(12, 1, 1, 'Default Staff', 'User', NULL, 0, 10, 'Business', 0, 0, NULL, NULL, 'Active'),
(13, 1, 1, 'Default Customer', 'User', NULL, 0, 11, 'Business', 0, 0, NULL, NULL, 'Active'),
(14, 1, 1, 'Default Investor', 'User', NULL, 0, 12, 'Business', 0, 0, NULL, NULL, 'Active'),
(15, 1, 1, 'Default Courier', 'User', NULL, 0, 13, 'Business', 0, 0, NULL, NULL, 'Active'),
(16, 1, 1, 'productionManager', 'User', NULL, -40751.3, 14, 'Business', 0, 0, NULL, NULL, 'Active'),
(17, 1, 1, 'salesManager', 'User', NULL, 0, 15, 'Business', 0, 0, NULL, NULL, 'Active');

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

--
-- Table structure for table `company_groups`
--

CREATE TABLE `company_groups` (
  `group_id` int(11) NOT NULL,
  `groupName` varchar(50) NOT NULL,
  `groupPolicy` varchar(100) NOT NULL,
  `policyDescription` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `company_groups`
--

INSERT INTO `company_groups` (`group_id`, `groupName`, `groupPolicy`, `policyDescription`) VALUES
(1, 'Manufacturers', 'buys matterials & Sales products', 'This group is for company which buys row matterial to produce products for sale'),
(2, 'Service Agents', 'buys service and sales', 'This group is for companies which buy servuces from service providers and sales it for profits'),
(3, 'Traders', 'buys product and sales product', 'This group is for company which buy product and sales it for profit'),
(4, 'Service Providers', 'Only Sales Services', 'This group focuses on only saling services to clients.'),
(5, 'Idea Sallers', 'sales idea and knowledges', 'This Group comprises on companies whose business to sale intellectual properties');

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

--
-- Table structure for table `elitegrants`
--

CREATE TABLE `elitegrants` (
  `elite_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `span` int(11) NOT NULL,
  `session` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `keygen` varchar(50) NOT NULL,
  `appcode` int(11) NOT NULL,
  `ullc` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `elitegrants`
--

INSERT INTO `elitegrants` (`elite_id`, `title`, `span`, `session`, `type`, `keygen`, `appcode`, `ullc`) VALUES
(1, 'For gemsPOS 2020 v1', 1, '2020_2021', 'Year', 'gemsPOS', 1, 3),
(2, 'For gemsPOS 2020 v1', 1, '2020_2021', 'Year', 'gemsPOS', 1, 2),
(3, 'License for version 2 gemsPOS2020', 6, '2020_2021', 'Month', 'gemsPOS2020V1', 1, 1);

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `expensesNo` bigint(20) NOT NULL,
  `exp_category_id` int(11) NOT NULL,
  `beneficiaryName` varchar(150) NOT NULL,
  `amount` double NOT NULL,
  `purpose` varchar(250) NOT NULL,
  `expenseDate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `expenses_category`
--

CREATE TABLE `expenses_category` (
  `exp_category_id` int(11) NOT NULL,
  `categoryName` varchar(70) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `expenses_category`
--

INSERT INTO `expenses_category` (`exp_category_id`, `categoryName`) VALUES
(1, 'fuels'),
(2, 'Transportation');

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

--
-- Table structure for table `investmenthis`
--

CREATE TABLE `investmenthis` (
  `investment_id` int(11) NOT NULL,
  `description` varchar(150) NOT NULL,
  `value` double NOT NULL,
  `comment` varchar(100) NOT NULL,
  `investment_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `local_governments`
--

CREATE TABLE `local_governments` (
  `id` int(11) NOT NULL,
  `state_id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf32 COMMENT='Local governments in Nigeria.';

--
-- Dumping data for table `local_governments`
--

INSERT INTO `local_governments` (`id`, `state_id`, `name`) VALUES
(1, 1, 'Aba North'),
(2, 1, 'Aba South'),
(3, 1, 'Arochukwu'),
(4, 1, 'Bende'),
(5, 1, 'Ikwuano'),
(6, 1, 'Isiala Ngwa North'),
(7, 1, 'Isiala Ngwa South'),
(8, 1, 'Isuikwuato'),
(9, 1, 'Obi Ngwa'),
(10, 1, 'Ohafia'),
(11, 1, 'Osisioma'),
(12, 1, 'Ugwunagbo'),
(13, 1, 'Ukwa East'),
(14, 1, 'Ukwa West'),
(15, 1, 'Umuahia North'),
(16, 1, 'Umuahia South'),
(17, 1, 'Umu Nneochi'),
(18, 2, 'Demsa'),
(19, 2, 'Fufure'),
(20, 2, 'Ganye'),
(21, 2, 'Gayuk'),
(22, 2, 'Gombi'),
(23, 2, 'Grie'),
(24, 2, 'Hong'),
(25, 2, 'Jada'),
(26, 2, 'Larmurde'),
(27, 2, 'Madagali'),
(28, 2, 'Maiha'),
(29, 2, 'Mayo Belwa'),
(30, 2, 'Michika'),
(31, 2, 'Mubi North'),
(32, 2, 'Mubi South'),
(33, 2, 'Numan'),
(34, 2, 'Shelleng'),
(35, 2, 'Song'),
(36, 2, 'Toungo'),
(37, 2, 'Yola North'),
(38, 2, 'Yola South'),
(39, 3, 'Abak'),
(40, 3, 'Eastern Obolo'),
(41, 3, 'Eket'),
(42, 3, 'Esit Eket'),
(43, 3, 'Essien Udim'),
(44, 3, 'Etim Ekpo'),
(45, 3, 'Etinan'),
(46, 3, 'Ibeno'),
(47, 3, 'Ibesikpo Asutan'),
(48, 3, 'Ibiono-Ibom'),
(49, 3, 'Ika'),
(50, 3, 'Ikono'),
(51, 3, 'Ikot Abasi'),
(52, 3, 'Ikot Ekpene'),
(53, 3, 'Ini'),
(54, 3, 'Itu'),
(55, 3, 'Mbo'),
(56, 3, 'Mkpat-Enin'),
(57, 3, 'Nsit-Atai'),
(58, 3, 'Nsit-Ibom'),
(59, 3, 'Nsit-Ubium'),
(60, 3, 'Obot Akara'),
(61, 3, 'Okobo'),
(62, 3, 'Onna'),
(63, 3, 'Oron'),
(64, 3, 'Oruk Anam'),
(65, 3, 'Udung-Uko'),
(66, 3, 'Ukanafun'),
(67, 3, 'Uruan'),
(68, 3, 'Urue-Offong/Oruko'),
(69, 3, 'Uyo'),
(70, 4, 'Aguata'),
(71, 4, 'Anambra East'),
(72, 4, 'Anambra West'),
(73, 4, 'Anaocha'),
(74, 4, 'Awka North'),
(75, 4, 'Awka South'),
(76, 4, 'Ayamelum'),
(77, 4, 'Dunukofia'),
(78, 4, 'Ekwusigo'),
(79, 4, 'Idemili North'),
(80, 4, 'Idemili South'),
(81, 4, 'Ihiala'),
(82, 4, 'Njikoka'),
(83, 4, 'Nnewi North'),
(84, 4, 'Nnewi South'),
(85, 4, 'Ogbaru'),
(86, 4, 'Onitsha North'),
(87, 4, 'Onitsha South'),
(88, 4, 'Orumba North'),
(89, 4, 'Orumba South'),
(90, 4, 'Oyi'),
(91, 5, 'Alkaleri'),
(92, 5, 'Bauchi'),
(93, 5, 'Bogoro'),
(94, 5, 'Damban'),
(95, 5, 'Darazo'),
(96, 5, 'Dass'),
(97, 5, 'Gamawa'),
(98, 5, 'Ganjuwa'),
(99, 5, 'Giade'),
(100, 5, 'Itas/Gadau'),
(101, 5, 'Jama\'are'),
(102, 5, 'Katagum'),
(103, 5, 'Kirfi'),
(104, 5, 'Misau'),
(105, 5, 'Ningi'),
(106, 5, 'Shira'),
(107, 5, 'Tafawa Balewa'),
(108, 5, 'Toro'),
(109, 5, 'Warji'),
(110, 5, 'Zaki'),
(111, 6, 'Brass'),
(112, 6, 'Ekeremor'),
(113, 6, 'Kolokuma/Opokuma'),
(114, 6, 'Nembe'),
(115, 6, 'Ogbia'),
(116, 6, 'Sagbama'),
(117, 6, 'Southern Ijaw'),
(118, 6, 'Yenagoa'),
(119, 7, 'Agatu'),
(120, 7, 'Apa'),
(121, 7, 'Ado'),
(122, 7, 'Buruku'),
(123, 7, 'Gboko'),
(124, 7, 'Guma'),
(125, 7, 'Gwer East'),
(126, 7, 'Gwer West'),
(127, 7, 'Katsina-Ala'),
(128, 7, 'Konshisha'),
(129, 7, 'Kwande'),
(130, 7, 'Logo'),
(131, 7, 'Makurdi'),
(132, 7, 'Obi'),
(133, 7, 'Ogbadibo'),
(134, 7, 'Ohimini'),
(135, 7, 'Oju'),
(136, 7, 'Okpokwu'),
(137, 7, 'Oturkpo'),
(138, 7, 'Tarka'),
(139, 7, 'Ukum'),
(140, 7, 'Ushongo'),
(141, 7, 'Vandeikya'),
(142, 8, 'Abadam'),
(143, 8, 'Askira/Uba'),
(144, 8, 'Bama'),
(145, 8, 'Bayo'),
(146, 8, 'Biu'),
(147, 8, 'Chibok'),
(148, 8, 'Damboa'),
(149, 8, 'Dikwa'),
(150, 8, 'Gubio'),
(151, 8, 'Guzamala'),
(152, 8, 'Gwoza'),
(153, 8, 'Hawul'),
(154, 8, 'Jere'),
(155, 8, 'Kaga'),
(156, 8, 'Kala/Balge'),
(157, 8, 'Konduga'),
(158, 8, 'Kukawa'),
(159, 8, 'Kwaya Kusar'),
(160, 8, 'Mafa'),
(161, 8, 'Magumeri'),
(162, 8, 'Maiduguri'),
(163, 8, 'Marte'),
(164, 8, 'Mobbar'),
(165, 8, 'Monguno'),
(166, 8, 'Ngala'),
(167, 8, 'Nganzai'),
(168, 8, 'Shani'),
(169, 9, 'Abi'),
(170, 9, 'Akamkpa'),
(171, 9, 'Akpabuyo'),
(172, 9, 'Bakassi'),
(173, 9, 'Bekwarra'),
(174, 9, 'Biase'),
(175, 9, 'Boki'),
(176, 9, 'Calabar Municipal'),
(177, 9, 'Calabar South'),
(178, 9, 'Etung'),
(179, 9, 'Ikom'),
(180, 9, 'Obanliku'),
(181, 9, 'Obubra'),
(182, 9, 'Obudu'),
(183, 9, 'Odukpani'),
(184, 9, 'Ogoja'),
(185, 9, 'Yakuur'),
(186, 9, 'Yala'),
(187, 10, 'Aniocha North'),
(188, 10, 'Aniocha South'),
(189, 10, 'Bomadi'),
(190, 10, 'Burutu'),
(191, 10, 'Ethiope East'),
(192, 10, 'Ethiope West'),
(193, 10, 'Ika North East'),
(194, 10, 'Ika South'),
(195, 10, 'Isoko North'),
(196, 10, 'Isoko South'),
(197, 10, 'Ndokwa East'),
(198, 10, 'Ndokwa West'),
(199, 10, 'Okpe'),
(200, 10, 'Oshimili North'),
(201, 10, 'Oshimili South'),
(202, 10, 'Patani'),
(203, 10, 'Sapele, Delta'),
(204, 10, 'Udu'),
(205, 10, 'Ughelli North'),
(206, 10, 'Ughelli South'),
(207, 10, 'Ukwuani'),
(208, 10, 'Uvwie'),
(209, 10, 'Warri North'),
(210, 10, 'Warri South'),
(211, 10, 'Warri South West'),
(212, 11, 'Abakaliki'),
(213, 11, 'Afikpo North'),
(214, 11, 'Afikpo South'),
(215, 11, 'Ebonyi'),
(216, 11, 'Ezza North'),
(217, 11, 'Ezza South'),
(218, 11, 'Ikwo'),
(219, 11, 'Ishielu'),
(220, 11, 'Ivo'),
(221, 11, 'Izzi'),
(222, 11, 'Ohaozara'),
(223, 11, 'Ohaukwu'),
(224, 11, 'Onicha'),
(225, 12, 'Akoko-Edo'),
(226, 12, 'Egor'),
(227, 12, 'Esan Central'),
(228, 12, 'Esan North-East'),
(229, 12, 'Esan South-East'),
(230, 12, 'Esan West'),
(231, 12, 'Etsako Central'),
(232, 12, 'Etsako East'),
(233, 12, 'Etsako West'),
(234, 12, 'Igueben'),
(235, 12, 'Ikpoba Okha'),
(236, 12, 'Orhionmwon'),
(237, 12, 'Oredo'),
(238, 12, 'Ovia North-East'),
(239, 12, 'Ovia South-West'),
(240, 12, 'Owan East'),
(241, 12, 'Owan West'),
(242, 12, 'Uhunmwonde'),
(243, 13, 'Ado Ekiti'),
(244, 13, 'Efon'),
(245, 13, 'Ekiti East'),
(246, 13, 'Ekiti South-West'),
(247, 13, 'Ekiti West'),
(248, 13, 'Emure'),
(249, 13, 'Gbonyin'),
(250, 13, 'Ido Osi'),
(251, 13, 'Ijero'),
(252, 13, 'Ikere'),
(253, 13, 'Ikole'),
(254, 13, 'Ilejemeje'),
(255, 13, 'Irepodun/Ifelodun'),
(256, 13, 'Ise/Orun'),
(257, 13, 'Moba'),
(258, 13, 'Oye'),
(259, 14, 'Aninri'),
(260, 14, 'Awgu'),
(261, 14, 'Enugu East'),
(262, 14, 'Enugu North'),
(263, 14, 'Enugu South'),
(264, 14, 'Ezeagu'),
(265, 14, 'Igbo Etiti'),
(266, 14, 'Igbo Eze North'),
(267, 14, 'Igbo Eze South'),
(268, 14, 'Isi Uzo'),
(269, 14, 'Nkanu East'),
(270, 14, 'Nkanu West'),
(271, 14, 'Nsukka'),
(272, 14, 'Oji River'),
(273, 14, 'Udenu'),
(274, 14, 'Udi'),
(275, 14, 'Uzo Uwani'),
(276, 15, 'Abaji'),
(277, 15, 'Bwari'),
(278, 15, 'Gwagwalada'),
(279, 15, 'Kuje'),
(280, 15, 'Kwali'),
(281, 15, 'Municipal Area Council'),
(282, 16, 'Akko'),
(283, 16, 'Balanga'),
(284, 16, 'Billiri'),
(285, 16, 'Dukku'),
(286, 16, 'Funakaye'),
(287, 16, 'Gombe'),
(288, 16, 'Kaltungo'),
(289, 16, 'Kwami'),
(290, 16, 'Nafada'),
(291, 16, 'Shongom'),
(292, 16, 'Yamaltu/Deba'),
(293, 17, 'Aboh Mbaise'),
(294, 17, 'Ahiazu Mbaise'),
(295, 17, 'Ehime Mbano'),
(296, 17, 'Ezinihitte'),
(297, 17, 'Ideato North'),
(298, 17, 'Ideato South'),
(299, 17, 'Ihitte/Uboma'),
(300, 17, 'Ikeduru'),
(301, 17, 'Isiala Mbano'),
(302, 17, 'Isu'),
(303, 17, 'Mbaitoli'),
(304, 17, 'Ngor Okpala'),
(305, 17, 'Njaba'),
(306, 17, 'Nkwerre'),
(307, 17, 'Nwangele'),
(308, 17, 'Obowo'),
(309, 17, 'Oguta'),
(310, 17, 'Ohaji/Egbema'),
(311, 17, 'Okigwe'),
(312, 17, 'Orlu'),
(313, 17, 'Orsu'),
(314, 17, 'Oru East'),
(315, 17, 'Oru West'),
(316, 17, 'Owerri Municipal'),
(317, 17, 'Owerri North'),
(318, 17, 'Owerri West'),
(319, 17, 'Unuimo'),
(320, 18, 'Auyo'),
(321, 18, 'Babura'),
(322, 18, 'Biriniwa'),
(323, 18, 'Birnin Kudu'),
(324, 18, 'Buji'),
(325, 18, 'Dutse'),
(326, 18, 'Gagarawa'),
(327, 18, 'Garki'),
(328, 18, 'Gumel'),
(329, 18, 'Guri'),
(330, 18, 'Gwaram'),
(331, 18, 'Gwiwa'),
(332, 18, 'Hadejia'),
(333, 18, 'Jahun'),
(334, 18, 'Kafin Hausa'),
(335, 18, 'Kazaure'),
(336, 18, 'Kiri Kasama'),
(337, 18, 'Kiyawa'),
(338, 18, 'Kaugama'),
(339, 18, 'Maigatari'),
(340, 18, 'Malam Madori'),
(341, 18, 'Miga'),
(342, 18, 'Ringim'),
(343, 18, 'Roni'),
(344, 18, 'Sule Tankarkar'),
(345, 18, 'Taura'),
(346, 18, 'Yankwashi'),
(347, 19, 'Birnin Gwari'),
(348, 19, 'Chikun'),
(349, 19, 'Giwa'),
(350, 19, 'Igabi'),
(351, 19, 'Ikara'),
(352, 19, 'Jaba'),
(353, 19, 'Jema\'a'),
(354, 19, 'Kachia'),
(355, 19, 'Kaduna North'),
(356, 19, 'Kaduna South'),
(357, 19, 'Kagarko'),
(358, 19, 'Kajuru'),
(359, 19, 'Kaura'),
(360, 19, 'Kauru'),
(361, 19, 'Kubau'),
(362, 19, 'Kudan'),
(363, 19, 'Lere'),
(364, 19, 'Makarfi'),
(365, 19, 'Sabon Gari'),
(366, 19, 'Sanga'),
(367, 19, 'Soba'),
(368, 19, 'Zangon Kataf'),
(369, 19, 'Zaria'),
(370, 20, 'Ajingi'),
(371, 20, 'Albasu'),
(372, 20, 'Bagwai'),
(373, 20, 'Bebeji'),
(374, 20, 'Bichi'),
(375, 20, 'Bunkure'),
(376, 20, 'Dala'),
(377, 20, 'Dambatta'),
(378, 20, 'Dawakin Kudu'),
(379, 20, 'Dawakin Tofa'),
(380, 20, 'Doguwa'),
(381, 20, 'Fagge'),
(382, 20, 'Gabasawa'),
(383, 20, 'Garko'),
(384, 20, 'Garun Mallam'),
(385, 20, 'Gaya'),
(386, 20, 'Gezawa'),
(387, 20, 'Gwale'),
(388, 20, 'Gwarzo'),
(389, 20, 'Kabo'),
(390, 20, 'Kano Municipal'),
(391, 20, 'Karaye'),
(392, 20, 'Kibiya'),
(393, 20, 'Kiru'),
(394, 20, 'Kumbotso'),
(395, 20, 'Kunchi'),
(396, 20, 'Kura'),
(397, 20, 'Madobi'),
(398, 20, 'Makoda'),
(399, 20, 'Minjibir'),
(400, 20, 'Nasarawa'),
(401, 20, 'Rano'),
(402, 20, 'Rimin Gado'),
(403, 20, 'Rogo'),
(404, 20, 'Shanono'),
(405, 20, 'Sumaila'),
(406, 20, 'Takai'),
(407, 20, 'Tarauni'),
(408, 20, 'Tofa'),
(409, 20, 'Tsanyawa'),
(410, 20, 'Tudun Wada'),
(411, 20, 'Ungogo'),
(412, 20, 'Warawa'),
(413, 20, 'Wudil'),
(414, 21, 'Bakori'),
(415, 21, 'Batagarawa'),
(416, 21, 'Batsari'),
(417, 21, 'Baure'),
(418, 21, 'Bindawa'),
(419, 21, 'Charanchi'),
(420, 21, 'Dandume'),
(421, 21, 'Danja'),
(422, 21, 'Dan Musa'),
(423, 21, 'Daura'),
(424, 21, 'Dutsi'),
(425, 21, 'Dutsin Ma'),
(426, 21, 'Faskari'),
(427, 21, 'Funtua'),
(428, 21, 'Ingawa'),
(429, 21, 'Jibia'),
(430, 21, 'Kafur'),
(431, 21, 'Kaita'),
(432, 21, 'Kankara'),
(433, 21, 'Kankia'),
(434, 21, 'Katsina'),
(435, 21, 'Kurfi'),
(436, 21, 'Kusada'),
(437, 21, 'Mai\'Adua'),
(438, 21, 'Malumfashi'),
(439, 21, 'Mani'),
(440, 21, 'Mashi'),
(441, 21, 'Matazu'),
(442, 21, 'Musawa'),
(443, 21, 'Rimi'),
(444, 21, 'Sabuwa'),
(445, 21, 'Safana'),
(446, 21, 'Sandamu'),
(447, 21, 'Zango'),
(448, 22, 'Aleiro'),
(449, 22, 'Arewa Dandi'),
(450, 22, 'Argungu'),
(451, 22, 'Augie'),
(452, 22, 'Bagudo'),
(453, 22, 'Birnin Kebbi'),
(454, 22, 'Bunza'),
(455, 22, 'Dandi'),
(456, 22, 'Fakai'),
(457, 22, 'Gwandu'),
(458, 22, 'Jega'),
(459, 22, 'Kalgo'),
(460, 22, 'Koko/Besse'),
(461, 22, 'Maiyama'),
(462, 22, 'Ngaski'),
(463, 22, 'Sakaba'),
(464, 22, 'Shanga'),
(465, 22, 'Suru'),
(466, 22, 'Wasagu/Danko'),
(467, 22, 'Yauri'),
(468, 22, 'Zuru'),
(469, 23, 'Adavi'),
(470, 23, 'Ajaokuta'),
(471, 23, 'Ankpa'),
(472, 23, 'Bassa'),
(473, 23, 'Dekina'),
(474, 23, 'Ibaji'),
(475, 23, 'Idah'),
(476, 23, 'Igalamela Odolu'),
(477, 23, 'Ijumu'),
(478, 23, 'Kabba/Bunu'),
(479, 23, 'Kogi'),
(480, 23, 'Lokoja'),
(481, 23, 'Mopa Muro'),
(482, 23, 'Ofu'),
(483, 23, 'Ogori/Magongo'),
(484, 23, 'Okehi'),
(485, 23, 'Okene'),
(486, 23, 'Olamaboro'),
(487, 23, 'Omala'),
(488, 23, 'Yagba East'),
(489, 23, 'Yagba West'),
(490, 24, 'Asa'),
(491, 24, 'Baruten'),
(492, 24, 'Edu'),
(493, 24, 'Ekiti, Kwara State'),
(494, 24, 'Ifelodun'),
(495, 24, 'Ilorin East'),
(496, 24, 'Ilorin South'),
(497, 24, 'Ilorin West'),
(498, 24, 'Irepodun'),
(499, 24, 'Isin'),
(500, 24, 'Kaiama'),
(501, 24, 'Moro'),
(502, 24, 'Offa'),
(503, 24, 'Oke Ero'),
(504, 24, 'Oyun'),
(505, 24, 'Pategi'),
(506, 25, 'Agege'),
(507, 25, 'Ajeromi-Ifelodun'),
(508, 25, 'Alimosho'),
(509, 25, 'Amuwo-Odofin'),
(510, 25, 'Apapa'),
(511, 25, 'Badagry'),
(512, 25, 'Epe'),
(513, 25, 'Eti Osa'),
(514, 25, 'Ibeju-Lekki'),
(515, 25, 'Ifako-Ijaiye'),
(516, 25, 'Ikeja'),
(517, 25, 'Ikorodu'),
(518, 25, 'Kosofe'),
(519, 25, 'Lagos Island'),
(520, 25, 'Lagos Mainland'),
(521, 25, 'Mushin'),
(522, 25, 'Ojo'),
(523, 25, 'Oshodi-Isolo'),
(524, 25, 'Shomolu'),
(525, 25, 'Surulere, Lagos State'),
(526, 26, 'Akwanga'),
(527, 26, 'Awe'),
(528, 26, 'Doma'),
(529, 26, 'Karu'),
(530, 26, 'Keana'),
(531, 26, 'Keffi'),
(532, 26, 'Kokona'),
(533, 26, 'Lafia'),
(534, 26, 'Nasarawa'),
(535, 26, 'Nasarawa Egon'),
(536, 26, 'Obi'),
(537, 26, 'Toto'),
(538, 26, 'Wamba'),
(539, 27, 'Agaie'),
(540, 27, 'Agwara'),
(541, 27, 'Bida'),
(542, 27, 'Borgu'),
(543, 27, 'Bosso'),
(544, 27, 'Chanchaga'),
(545, 27, 'Edati'),
(546, 27, 'Gbako'),
(547, 27, 'Gurara'),
(548, 27, 'Katcha'),
(549, 27, 'Kontagora'),
(550, 27, 'Lapai'),
(551, 27, 'Lavun'),
(552, 27, 'Magama'),
(553, 27, 'Mariga'),
(554, 27, 'Mashegu'),
(555, 27, 'Mokwa'),
(556, 27, 'Moya'),
(557, 27, 'Paikoro'),
(558, 27, 'Rafi'),
(559, 27, 'Rijau'),
(560, 27, 'Shiroro'),
(561, 27, 'Suleja'),
(562, 27, 'Tafa'),
(563, 27, 'Wushishi'),
(564, 28, 'Abeokuta North'),
(565, 28, 'Abeokuta South'),
(566, 28, 'Ado-Odo/Ota'),
(567, 28, 'Egbado North'),
(568, 28, 'Egbado South'),
(569, 28, 'Ewekoro'),
(570, 28, 'Ifo'),
(571, 28, 'Ijebu East'),
(572, 28, 'Ijebu North'),
(573, 28, 'Ijebu North East'),
(574, 28, 'Ijebu Ode'),
(575, 28, 'Ikenne'),
(576, 28, 'Imeko Afon'),
(577, 28, 'Ipokia'),
(578, 28, 'Obafemi Owode'),
(579, 28, 'Odeda'),
(580, 28, 'Odogbolu'),
(581, 28, 'Ogun Waterside'),
(582, 28, 'Remo North'),
(583, 28, 'Shagamu'),
(584, 29, 'Akoko North-East'),
(585, 29, 'Akoko North-West'),
(586, 29, 'Akoko South-West'),
(587, 29, 'Akoko South-East'),
(588, 29, 'Akure North'),
(589, 29, 'Akure South'),
(590, 29, 'Ese Odo'),
(591, 29, 'Idanre'),
(592, 29, 'Ifedore'),
(593, 29, 'Ilaje'),
(594, 29, 'Ile Oluji/Okeigbo'),
(595, 29, 'Irele'),
(596, 29, 'Odigbo'),
(597, 29, 'Okitipupa'),
(598, 29, 'Ondo East'),
(599, 29, 'Ondo West'),
(600, 29, 'Ose'),
(601, 29, 'Owo'),
(602, 30, 'Atakunmosa East'),
(603, 30, 'Atakunmosa West'),
(604, 30, 'Aiyedaade'),
(605, 30, 'Aiyedire'),
(606, 30, 'Boluwaduro'),
(607, 30, 'Boripe'),
(608, 30, 'Ede North'),
(609, 30, 'Ede South'),
(610, 30, 'Ife Central'),
(611, 30, 'Ife East'),
(612, 30, 'Ife North'),
(613, 30, 'Ife South'),
(614, 30, 'Egbedore'),
(615, 30, 'Ejigbo'),
(616, 30, 'Ifedayo'),
(617, 30, 'Ifelodun'),
(618, 30, 'Ila'),
(619, 30, 'Ilesa East'),
(620, 30, 'Ilesa West'),
(621, 30, 'Irepodun'),
(622, 30, 'Irewole'),
(623, 30, 'Isokan'),
(624, 30, 'Iwo'),
(625, 30, 'Obokun'),
(626, 30, 'Odo Otin'),
(627, 30, 'Ola Oluwa'),
(628, 30, 'Olorunda'),
(629, 30, 'Oriade'),
(630, 30, 'Orolu'),
(631, 30, 'Osogbo'),
(632, 31, 'Afijio'),
(633, 31, 'Akinyele'),
(634, 31, 'Atiba'),
(635, 31, 'Atisbo'),
(636, 31, 'Egbeda'),
(637, 31, 'Ibadan North'),
(638, 31, 'Ibadan North-East'),
(639, 31, 'Ibadan North-West'),
(640, 31, 'Ibadan South-East'),
(641, 31, 'Ibadan South-West'),
(642, 31, 'Ibarapa Central'),
(643, 31, 'Ibarapa East'),
(644, 31, 'Ibarapa North'),
(645, 31, 'Ido'),
(646, 31, 'Irepo'),
(647, 31, 'Iseyin'),
(648, 31, 'Itesiwaju'),
(649, 31, 'Iwajowa'),
(650, 31, 'Kajola'),
(651, 31, 'Lagelu'),
(652, 31, 'Ogbomosho North'),
(653, 31, 'Ogbomosho South'),
(654, 31, 'Ogo Oluwa'),
(655, 31, 'Olorunsogo'),
(656, 31, 'Oluyole'),
(657, 31, 'Ona Ara'),
(658, 31, 'Orelope'),
(659, 31, 'Ori Ire'),
(660, 31, 'Oyo'),
(661, 31, 'Oyo East'),
(662, 31, 'Saki East'),
(663, 31, 'Saki West'),
(664, 31, 'Surulere, Oyo State'),
(665, 32, 'Bokkos'),
(666, 32, 'Barkin Ladi'),
(667, 32, 'Bassa'),
(668, 32, 'Jos East'),
(669, 32, 'Jos North'),
(670, 32, 'Jos South'),
(671, 32, 'Kanam'),
(672, 32, 'Kanke'),
(673, 32, 'Langtang South'),
(674, 32, 'Langtang North'),
(675, 32, 'Mangu'),
(676, 32, 'Mikang'),
(677, 32, 'Pankshin'),
(678, 32, 'Qua\'an Pan'),
(679, 32, 'Riyom'),
(680, 32, 'Shendam'),
(681, 32, 'Wase'),
(682, 33, 'Abua/Odual'),
(683, 33, 'Ahoada East'),
(684, 33, 'Ahoada West'),
(685, 33, 'Akuku-Toru'),
(686, 33, 'Andoni'),
(687, 33, 'Asari-Toru'),
(688, 33, 'Bonny'),
(689, 33, 'Degema'),
(690, 33, 'Eleme'),
(691, 33, 'Emuoha'),
(692, 33, 'Etche'),
(693, 33, 'Gokana'),
(694, 33, 'Ikwerre'),
(695, 33, 'Khana'),
(696, 33, 'Obio/Akpor'),
(697, 33, 'Ogba/Egbema/Ndoni'),
(698, 33, 'Ogu/Bolo'),
(699, 33, 'Okrika'),
(700, 33, 'Omuma'),
(701, 33, 'Opobo/Nkoro'),
(702, 33, 'Oyigbo'),
(703, 33, 'Port Harcourt'),
(704, 33, 'Tai'),
(705, 34, 'Binji'),
(706, 34, 'Bodinga'),
(707, 34, 'Dange Shuni'),
(708, 34, 'Gada'),
(709, 34, 'Goronyo'),
(710, 34, 'Gudu'),
(711, 34, 'Gwadabawa'),
(712, 34, 'Illela'),
(713, 34, 'Isa'),
(714, 34, 'Kebbe'),
(715, 34, 'Kware'),
(716, 34, 'Rabah'),
(717, 34, 'Sabon Birni'),
(718, 34, 'Shagari'),
(719, 34, 'Silame'),
(720, 34, 'Sokoto North'),
(721, 34, 'Sokoto South'),
(722, 34, 'Tambuwal'),
(723, 34, 'Tangaza'),
(724, 34, 'Tureta'),
(725, 34, 'Wamako'),
(726, 34, 'Wurno'),
(727, 34, 'Yabo'),
(728, 35, 'Ardo Kola'),
(729, 35, 'Bali'),
(730, 35, 'Donga'),
(731, 35, 'Gashaka'),
(732, 35, 'Gassol'),
(733, 35, 'Ibi'),
(734, 35, 'Jalingo'),
(735, 35, 'Karim Lamido'),
(736, 35, 'Kumi'),
(737, 35, 'Lau'),
(738, 35, 'Sardauna'),
(739, 35, 'Takum'),
(740, 35, 'Ussa'),
(741, 35, 'Wukari'),
(742, 35, 'Yorro'),
(743, 35, 'Zing'),
(744, 36, 'Bade'),
(745, 36, 'Bursari'),
(746, 36, 'Damaturu'),
(747, 36, 'Fika'),
(748, 36, 'Fune'),
(749, 36, 'Geidam'),
(750, 36, 'Gujba'),
(751, 36, 'Gulani'),
(752, 36, 'Jakusko'),
(753, 36, 'Karasuwa'),
(754, 36, 'Machina'),
(755, 36, 'Nangere'),
(756, 36, 'Nguru'),
(757, 36, 'Potiskum'),
(758, 36, 'Tarmuwa'),
(759, 36, 'Yunusari'),
(760, 36, 'Yusufari'),
(761, 37, 'Anka'),
(762, 37, 'Bakura'),
(763, 37, 'Birnin Magaji/Kiyaw'),
(764, 37, 'Bukkuyum'),
(765, 37, 'Bungudu'),
(766, 37, 'Gummi'),
(767, 37, 'Gusau'),
(768, 37, 'Kaura Namoda'),
(769, 37, 'Maradun'),
(770, 37, 'Maru'),
(771, 37, 'Shinkafi'),
(772, 37, 'Talata Mafara'),
(773, 37, 'Chafe'),
(774, 37, 'Zurmi');

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

--
-- Table structure for table `logindetails`
--

CREATE TABLE `logindetails` (
  `loginno` bigint(20) NOT NULL,
  `userno` int(11) NOT NULL,
  `signintime` time NOT NULL,
  `signouttime` time NOT NULL,
  `logindate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `logindetails`
--

INSERT INTO `logindetails` (`loginno`, `userno`, `signintime`, `signouttime`, `logindate`) VALUES
(1, 1, '05:14:36', '00:00:00', '2020-02-24'),
(2, 1, '05:15:12', '12:46:36', '2020-02-24'),
(3, 6, '12:46:49', '11:00:43', '2020-02-26'),
(4, 2, '11:08:14', '00:00:00', '2020-02-27'),
(5, 2, '11:08:14', '00:00:00', '2020-02-27'),
(6, 1, '04:44:40', '00:00:00', '2020-02-27'),
(7, 2, '02:40:28', '00:00:00', '2020-02-28'),
(8, 2, '02:40:28', '00:00:00', '2020-02-28'),
(9, 1, '02:44:17', '00:00:00', '2020-02-28'),
(10, 2, '05:48:36', '00:00:00', '2020-02-28'),
(11, 2, '05:48:36', '06:53:11', '2020-02-28'),
(12, 2, '03:35:05', '00:00:00', '2020-06-11'),
(13, 2, '03:35:05', '00:00:00', '2020-06-11'),
(14, 2, '05:11:54', '00:00:00', '2020-06-11'),
(15, 2, '05:11:54', '00:00:00', '2020-06-11'),
(16, 1, '05:13:10', '00:00:00', '2020-06-11'),
(17, 2, '09:31:09', '00:00:00', '2020-06-13'),
(18, 2, '09:31:10', '00:00:00', '2020-06-13'),
(19, 2, '09:34:55', '00:00:00', '2020-06-13'),
(20, 2, '09:34:55', '00:00:00', '2020-06-13'),
(21, 1, '09:41:04', '00:00:00', '2020-06-13'),
(22, 1, '09:43:00', '00:00:00', '2020-06-13'),
(23, 2, '09:43:46', '00:00:00', '2020-06-13'),
(24, 2, '09:43:46', '00:00:00', '2020-06-13'),
(25, 2, '09:44:03', '00:00:00', '2020-06-13'),
(26, 2, '09:44:03', '00:00:00', '2020-06-13'),
(27, 1, '09:48:02', '00:00:00', '2020-06-13'),
(28, 1, '09:49:35', '00:00:00', '2020-06-13'),
(29, 1, '11:24:32', '00:00:00', '2020-06-13'),
(30, 10, '01:33:36', '00:00:00', '2020-06-14'),
(31, 10, '01:35:25', '00:00:00', '2020-06-14'),
(32, 1, '02:28:55', '00:00:00', '2020-06-14'),
(33, 1, '02:40:31', '00:00:00', '2020-06-14'),
(34, 1, '03:26:42', '00:00:00', '2020-06-14'),
(35, 1, '09:09:26', '00:00:00', '2020-06-14'),
(36, 1, '09:14:21', '00:00:00', '2020-06-14'),
(37, 1, '10:03:56', '00:00:00', '2020-06-14'),
(38, 1, '10:05:18', '00:00:00', '2020-06-14'),
(39, 1, '10:29:25', '00:00:00', '2020-06-14'),
(40, 10, '11:40:09', '00:00:00', '2020-06-14'),
(41, 1, '12:14:31', '00:00:00', '2020-06-14'),
(42, 1, '12:35:15', '00:00:00', '2020-06-14'),
(43, 10, '12:35:41', '00:00:00', '2020-06-14'),
(44, 1, '01:28:41', '00:00:00', '2020-06-14'),
(45, 10, '01:32:35', '00:00:00', '2020-06-14'),
(46, 10, '01:38:04', '00:00:00', '2020-06-14'),
(47, 10, '02:46:26', '00:00:00', '2020-06-14'),
(48, 1, '02:49:02', '00:00:00', '2020-06-14'),
(49, 1, '05:11:20', '00:00:00', '2020-06-14'),
(50, 2, '05:18:34', '00:00:00', '2020-06-14'),
(51, 2, '05:18:34', '00:00:00', '2020-06-14'),
(52, 10, '05:52:41', '00:00:00', '2020-06-14'),
(53, 1, '07:38:43', '00:00:00', '2020-06-14'),
(54, 1, '07:43:39', '00:00:00', '2020-06-14'),
(55, 1, '07:44:24', '00:00:00', '2020-06-14'),
(56, 1, '07:55:00', '00:00:00', '2020-06-14'),
(57, 10, '12:25:26', '00:00:00', '2020-06-15'),
(58, 10, '03:07:31', '00:00:00', '2020-06-15'),
(59, 1, '03:14:26', '00:00:00', '2020-06-15'),
(60, 10, '08:36:49', '00:00:00', '2020-06-16'),
(61, 1, '04:46:23', '00:00:00', '2020-06-17'),
(62, 2, '09:22:59', '00:00:00', '2020-06-17'),
(63, 2, '09:22:59', '00:00:00', '2020-06-17'),
(64, 2, '09:28:22', '00:00:00', '2020-06-17'),
(65, 2, '09:28:22', '00:00:00', '2020-06-17'),
(66, 2, '09:30:28', '00:00:00', '2020-06-17'),
(67, 2, '09:30:28', '00:00:00', '2020-06-17'),
(68, 1, '09:50:40', '00:00:00', '2020-06-17'),
(69, 2, '10:11:42', '00:00:00', '2020-06-17'),
(70, 2, '10:11:42', '00:00:00', '2020-06-17'),
(71, 1, '10:20:05', '00:00:00', '2020-06-17'),
(72, 1, '10:29:34', '00:00:00', '2020-06-17'),
(73, 2, '10:38:34', '00:00:00', '2020-06-17'),
(74, 2, '10:38:34', '00:00:00', '2020-06-17'),
(75, 2, '11:10:12', '00:00:00', '2020-06-17'),
(76, 2, '11:10:12', '00:00:00', '2020-06-17'),
(77, 1, '11:18:40', '00:00:00', '2020-06-17'),
(78, 1, '01:45:28', '00:00:00', '2020-06-17'),
(79, 1, '02:23:58', '00:00:00', '2020-06-17'),
(80, 1, '02:30:41', '00:00:00', '2020-06-17'),
(81, 2, '02:53:14', '00:00:00', '2020-06-17'),
(82, 2, '02:53:14', '00:00:00', '2020-06-17'),
(83, 1, '05:36:03', '00:00:00', '2020-06-17'),
(84, 1, '05:39:21', '00:00:00', '2020-06-17'),
(85, 2, '10:11:24', '00:00:00', '2020-06-18'),
(86, 2, '10:11:24', '00:00:00', '2020-06-18'),
(87, 2, '05:34:09', '00:00:00', '2020-06-18'),
(88, 2, '05:34:09', '00:00:00', '2020-06-18'),
(89, 2, '05:34:42', '00:00:00', '2020-06-18'),
(90, 2, '05:34:42', '00:00:00', '2020-06-18'),
(91, 2, '05:50:31', '00:00:00', '2020-06-18'),
(92, 2, '05:50:31', '00:00:00', '2020-06-18'),
(93, 2, '05:50:52', '00:00:00', '2020-06-18'),
(94, 2, '05:50:52', '00:00:00', '2020-06-18'),
(95, 2, '06:40:11', '00:00:00', '2020-06-19'),
(96, 2, '06:40:12', '00:00:00', '2020-06-19'),
(97, 2, '02:29:15', '00:00:00', '2020-06-20'),
(98, 2, '02:29:16', '00:00:00', '2020-06-20'),
(99, 2, '08:55:48', '00:00:00', '2020-06-20'),
(100, 2, '08:55:48', '00:00:00', '2020-06-20'),
(101, 2, '10:57:23', '00:00:00', '2020-06-20'),
(102, 2, '10:57:23', '00:00:00', '2020-06-20'),
(103, 2, '02:25:32', '00:00:00', '2020-06-21'),
(104, 2, '02:25:33', '00:00:00', '2020-06-21'),
(105, 1, '02:27:28', '00:00:00', '2020-06-21'),
(106, 2, '10:50:30', '00:00:00', '2020-06-21'),
(107, 2, '10:50:30', '00:00:00', '2020-06-21'),
(108, 1, '10:50:49', '00:00:00', '2020-06-21'),
(109, 2, '06:54:02', '00:00:00', '2020-06-21'),
(110, 2, '06:54:02', '00:00:00', '2020-06-21'),
(111, 1, '05:20:27', '00:00:00', '2020-06-23'),
(112, 1, '05:20:43', '00:00:00', '2020-06-23'),
(113, 10, '12:47:17', '00:00:00', '2020-06-27'),
(114, 2, '07:48:10', '00:00:00', '2020-06-27'),
(115, 2, '07:48:10', '00:00:00', '2020-06-27'),
(116, 1, '06:55:36', '00:00:00', '2020-06-30'),
(117, 1, '02:26:09', '00:00:00', '2020-07-02'),
(118, 1, '02:26:10', '00:00:00', '2020-07-02'),
(119, 2, '03:48:12', '00:00:00', '2020-07-02'),
(120, 2, '03:48:12', '00:00:00', '2020-07-02'),
(121, 1, '03:52:20', '00:00:00', '2020-07-02'),
(122, 2, '11:14:09', '00:00:00', '2020-07-06'),
(123, 2, '11:14:09', '00:00:00', '2020-07-06'),
(124, 10, '10:24:02', '00:00:00', '2020-07-09'),
(125, 10, '01:49:35', '00:00:00', '2020-07-09'),
(126, 2, '11:34:21', '00:00:00', '2020-07-13'),
(127, 2, '11:34:23', '00:00:00', '2020-07-13'),
(128, 1, '08:32:45', '00:00:00', '2020-07-15'),
(129, 1, '12:52:44', '00:00:00', '2020-07-15'),
(130, 2, '07:15:49', '00:00:00', '2020-07-18'),
(131, 2, '07:15:50', '00:00:00', '2020-07-18'),
(132, 1, '08:52:05', '00:00:00', '2020-07-19'),
(133, 2, '11:22:45', '00:00:00', '2020-07-21'),
(134, 2, '11:22:45', '00:00:00', '2020-07-21'),
(135, 1, '11:26:50', '00:00:00', '2020-07-21'),
(136, 1, '09:44:09', '00:00:00', '2020-07-22'),
(137, 1, '09:44:09', '00:00:00', '2020-07-22'),
(138, 7, '09:02:12', '00:00:00', '2020-07-23'),
(139, 1, '02:18:46', '00:00:00', '2020-07-27'),
(140, 1, '06:17:11', '00:00:00', '2020-07-29'),
(141, 2, '06:29:23', '00:00:00', '2020-07-29'),
(142, 2, '06:29:23', '00:00:00', '2020-07-29'),
(143, 7, '07:40:30', '00:00:00', '2020-07-29'),
(144, 2, '02:27:37', '00:00:00', '2020-07-29'),
(145, 2, '02:27:37', '00:00:00', '2020-07-29'),
(146, 1, '02:56:03', '00:00:00', '2020-07-29'),
(147, 1, '07:38:24', '00:00:00', '2020-07-29'),
(148, 1, '08:22:16', '00:00:00', '2020-07-29'),
(149, 1, '08:26:11', '00:00:00', '2020-07-29'),
(150, 1, '07:47:53', '00:00:00', '2020-07-30'),
(151, 1, '07:49:32', '00:00:00', '2020-07-30'),
(152, 2, '11:55:41', '00:00:00', '2020-07-30'),
(153, 2, '11:55:41', '00:00:00', '2020-07-30'),
(154, 10, '01:47:52', '00:00:00', '2020-08-06'),
(155, 1, '01:48:33', '00:00:00', '2020-08-06'),
(156, 1, '01:48:40', '00:00:00', '2020-08-06'),
(157, 1, '01:49:28', '00:00:00', '2020-08-06'),
(158, 1, '01:49:43', '00:00:00', '2020-08-06'),
(159, 1, '01:50:12', '00:00:00', '2020-08-06'),
(160, 1, '01:50:53', '00:00:00', '2020-08-06'),
(161, 1, '01:52:57', '00:00:00', '2020-08-06'),
(162, 10, '01:53:07', '00:00:00', '2020-08-06'),
(163, 10, '01:57:14', '00:00:00', '2020-08-06'),
(164, 10, '08:17:58', '00:00:00', '2020-08-06'),
(165, 1, '08:02:16', '00:00:00', '2020-08-07'),
(166, 1, '08:09:49', '00:00:00', '2020-08-09'),
(167, 1, '09:18:26', '00:00:00', '2020-08-09'),
(168, 1, '09:41:16', '00:00:00', '2020-08-09'),
(169, 1, '09:32:09', '00:00:00', '2020-08-10'),
(170, 1, '09:32:34', '00:00:00', '2020-08-10'),
(171, 1, '07:36:27', '00:00:00', '2020-08-11'),
(172, 1, '03:22:20', '00:00:00', '2020-08-11'),
(173, 4, '06:54:14', '00:00:00', '2020-08-12'),
(174, 4, '06:58:14', '00:00:00', '2020-08-12'),
(175, 4, '07:05:40', '00:00:00', '2020-08-12'),
(176, 1, '07:18:30', '00:00:00', '2020-08-12'),
(177, 4, '08:46:46', '00:00:00', '2020-08-12'),
(178, 1, '08:53:30', '00:00:00', '2020-08-12'),
(179, 4, '10:00:08', '00:00:00', '2020-08-12'),
(180, 4, '09:37:47', '00:00:00', '2020-08-12'),
(181, 4, '09:41:10', '00:00:00', '2020-08-12'),
(182, 4, '09:48:40', '00:00:00', '2020-08-12'),
(183, 4, '09:57:41', '00:00:00', '2020-08-12'),
(184, 4, '09:59:20', '00:00:00', '2020-08-12'),
(185, 4, '10:11:43', '00:00:00', '2020-08-12'),
(186, 1, '10:12:25', '00:00:00', '2020-08-12'),
(187, 4, '10:21:42', '00:00:00', '2020-08-12'),
(188, 1, '05:08:22', '00:00:00', '2020-08-13'),
(189, 4, '12:03:49', '00:00:00', '2020-08-14'),
(190, 4, '02:46:32', '00:00:00', '2020-08-14'),
(191, 4, '10:17:54', '00:00:00', '2020-08-14'),
(192, 1, '04:49:20', '00:00:00', '2020-08-15'),
(193, 1, '05:26:22', '00:00:00', '2020-08-15'),
(194, 4, '06:04:43', '00:00:00', '2020-08-15'),
(195, 1, '06:05:36', '00:00:00', '2020-08-15'),
(196, 4, '10:21:49', '00:00:00', '2020-08-15'),
(197, 18, '10:22:18', '00:00:00', '2020-08-15'),
(198, 1, '01:38:41', '00:00:00', '2020-08-15'),
(199, 19, '01:43:17', '00:00:00', '2020-08-15'),
(200, 1, '01:43:44', '00:00:00', '2020-08-15'),
(201, 1, '01:53:07', '00:00:00', '2020-08-15'),
(202, 1, '07:04:50', '00:00:00', '2020-08-15'),
(203, 1, '07:28:10', '00:00:00', '2020-08-23'),
(204, 1, '01:58:02', '00:00:00', '2020-09-01'),
(205, 1, '11:37:11', '00:00:00', '2020-09-02'),
(206, 1, '09:42:54', '00:00:00', '2020-09-02');

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

--
-- Table structure for table `my_messages`
--

CREATE TABLE `my_messages` (
  `message_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `subject_name` varchar(100) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `date_sent` datetime NOT NULL,
  `date_received` datetime DEFAULT NULL,
  `message_heading` varchar(100) DEFAULT NULL,
  `message_body` text NOT NULL,
  `message_attach_link` varchar(100) DEFAULT NULL,
  `sender_reaction` varchar(100) DEFAULT NULL,
  `receiver_reaction` varchar(100) DEFAULT NULL,
  `message_status` varchar(50) NOT NULL DEFAULT 'Sent'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `my_messages`
--

INSERT INTO `my_messages` (`message_id`, `sender_id`, `receiver_id`, `subject_name`, `subject_id`, `date_sent`, `date_received`, `message_heading`, `message_body`, `message_attach_link`, `sender_reaction`, `receiver_reaction`, `message_status`) VALUES
(1, 18, 1, 'Activity', 1, '2020-08-15 10:37:42', NULL, 'Request For Clearification', ' Are we going to include financial management in the ongoing design or not.', NULL, NULL, NULL, 'Sent'),
(2, 18, 1, 'Activity', 1, '2020-08-15 10:52:10', NULL, 'Phase One Completion', ' We have finished all about system analysis and design ... Kind submit the next activity.\r\nThanks for your quick response.', NULL, NULL, NULL, 'Sent');

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

--
-- Table structure for table `my_tasks`
--

CREATE TABLE `my_tasks` (
  `task_id` int(11) NOT NULL,
  `task_name` varchar(100) NOT NULL,
  `task_description` text NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Active'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `my_tasks`
--

INSERT INTO `my_tasks` (`task_id`, `task_name`, `task_description`, `status`) VALUES
(1, 'Developing Task Management System', 'A system that facilitate process of managing tasks and subs-tasks assigned to a staff in a particular organization ', 'Active'),
(2, 'Data Analysis', 'For SSG Project', 'Active'),
(3, 'Track Design & Dev', 'For Farinwata Clearance', 'Active'),
(4, 'Creating CMS', 'Managing Our Customers', 'Active');

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf32 COMMENT='States in Nigeria.';

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `name`) VALUES
(1, 'Abia'),
(2, 'Adamawa'),
(3, 'Akwa Ibom'),
(4, 'Anambra'),
(5, 'Bauchi'),
(6, 'Bayelsa'),
(7, 'Benue'),
(8, 'Borno'),
(9, 'Cross River'),
(10, 'Delta'),
(11, 'Ebonyi'),
(12, 'Edo'),
(13, 'Ekiti'),
(14, 'Enugu'),
(15, 'FCT'),
(16, 'Gombe'),
(17, 'Imo'),
(18, 'Jigawa'),
(19, 'Kaduna'),
(20, 'Kano'),
(21, 'Katsina'),
(22, 'Kebbi'),
(23, 'Kogi'),
(24, 'Kwara'),
(25, 'Lagos'),
(26, 'Nasarawa'),
(27, 'Niger'),
(28, 'Ogun'),
(29, 'Ondo'),
(30, 'Osun'),
(31, 'Oyo'),
(32, 'Plateau'),
(33, 'Rivers'),
(34, 'Sokoto'),
(35, 'Taraba'),
(36, 'Yobe'),
(37, 'Zamfara');

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

--
-- Table structure for table `tasks_relations`
--

CREATE TABLE `tasks_relations` (
  `relation_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `task_code` varchar(50) DEFAULT NULL,
  `supervisor_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `issue_date` date NOT NULL,
  `due_date` date NOT NULL,
  `task_status` varchar(50) NOT NULL DEFAULT 'uncommenced'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tasks_relations`
--

INSERT INTO `tasks_relations` (`relation_id`, `staff_id`, `task_id`, `task_code`, `supervisor_id`, `group_id`, `issue_date`, `due_date`, `task_status`) VALUES
(1, 18, 1, NULL, NULL, NULL, '2020-08-15', '2020-08-21', 'uncommenced');

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

--
-- Table structure for table `task_activities`
--

CREATE TABLE `task_activities` (
  `activity_id` int(11) NOT NULL,
  `activity_name` varchar(100) NOT NULL,
  `activity_description` text NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `task_id` int(11) NOT NULL,
  `activity_status` varchar(50) NOT NULL DEFAULT 'Queuing'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `task_activities`
--

INSERT INTO `task_activities` (`activity_id`, `activity_name`, `activity_description`, `start_date`, `end_date`, `task_id`, `activity_status`) VALUES
(1, 'Phase One', 'System Analysis And Design', '2020-08-15', '2020-08-17', 1, 'Completed'),
(2, 'Back-end design and system modelling ', 'Server side and front end logic implementation', '2020-08-18', '2020-08-22', 1, 'Infeasible');

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

--
-- Table structure for table `transaction_history`
--

CREATE TABLE `transaction_history` (
  `transaction_id` bigint(20) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `wallet_id` int(11) NOT NULL,
  `transaction_purpose_id` int(11) DEFAULT NULL,
  `transaction_purpose` varchar(100) DEFAULT 'Sales',
  `amount` double NOT NULL,
  `transaction_mode` varchar(100) NOT NULL DEFAULT 'Cash',
  `transaction_type` varchar(50) DEFAULT 'credict',
  `transaction_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `transaction_status` varchar(50) NOT NULL DEFAULT 'Request'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transaction_history`
--

INSERT INTO `transaction_history` (`transaction_id`, `company_id`, `branch_id`, `wallet_id`, `transaction_purpose_id`, `transaction_purpose`, `amount`, `transaction_mode`, `transaction_type`, `transaction_date`, `transaction_status`) VALUES
(1, 1, 1, 11, 1, 'Supply', 100, 'Cash', 'credict', '2020-07-26 14:41:48', 'Request'),
(2, 1, 1, 11, 2, 'Supply', 95, 'Cash', 'credict', '2020-07-26 14:43:41', 'Request'),
(3, 1, 1, 11, 3, 'Supply', 1100, 'Cash', 'credict', '2020-07-26 14:50:48', 'Request'),
(4, 1, 1, 11, 4, 'Supply', 100, 'Cash', 'credict', '2020-07-26 14:53:35', 'Request'),
(5, 1, 1, 11, 5, 'Supply', 850, 'Cash', 'credict', '2020-07-26 14:55:29', 'Request'),
(6, 1, 1, 11, 6, 'Supply', 4500, 'Cash', 'credict', '2020-07-26 17:30:38', 'Request'),
(7, 1, 1, 16, 12, 'Production_transfer', 47.5, 'Cash', 'credict', '2020-07-28 07:03:30', 'Request'),
(8, 1, 1, 16, 13, 'Production_transfer', 55, 'Cash', 'credict', '2020-07-28 07:05:14', 'Request'),
(9, 1, 1, 16, 14, 'Production_transfer', 33.333333333333, 'Cash', 'credict', '2020-07-28 07:05:14', 'Request'),
(10, 1, 1, 16, 15, 'Production_transfer', 55, 'Cash', 'credict', '2020-07-28 07:06:59', 'Request'),
(11, 1, 1, 11, 1, 'Supply', 10000, 'Cash', 'credict', '2020-07-28 07:35:45', 'Request'),
(12, 1, 1, 16, 1, 'Production_transfer', 1000, 'Cash', 'credict', '2020-07-28 07:53:29', 'Request'),
(13, 1, 1, 11, 2, 'Supply', 100000, 'Cash', 'credict', '2020-07-31 14:56:19', 'Request'),
(14, 1, 1, 11, 3, 'Supply', 9000, 'Cash', 'credict', '2020-08-01 06:16:37', 'Request'),
(15, 1, 1, 11, 4, 'Supply', 100000, 'Cash', 'credict', '2020-08-01 06:40:14', 'Request'),
(16, 1, 1, 16, 29, 'Production_transfer', 10000, 'Cash', 'credict', '2020-08-01 07:41:33', 'Request'),
(17, 1, 1, 16, 30, 'Production_transfer', 20, 'Cash', 'credict', '2020-08-02 07:50:35', 'Request'),
(18, 1, 1, 16, 32, 'Production_transfer', 20000, 'Cash', 'credict', '2020-08-02 11:16:53', 'Request'),
(19, 1, 1, 16, 33, 'Production_transfer', 4050, 'Cash', 'credict', '2020-08-02 11:16:53', 'Request'),
(20, 1, 1, 16, 34, 'Production_transfer', 2600, 'Cash', 'credict', '2020-08-02 11:16:53', 'Request'),
(21, 1, 1, 16, 47, 'Production_transfer', 10, 'Cash', 'credict', '2020-08-03 09:08:13', 'Request'),
(22, 1, 1, 16, 48, 'Production_transfer', 10, 'Cash', 'credict', '2020-08-03 09:10:39', 'Request'),
(23, 1, 1, 16, 49, 'Production_transfer', 10, 'Cash', 'credict', '2020-08-03 09:17:10', 'Request'),
(24, 1, 1, 16, 50, 'Production_transfer', 10, 'Cash', 'credict', '2020-08-03 09:18:16', 'Request'),
(25, 1, 1, 16, 51, 'Production_transfer', 10, 'Cash', 'credict', '2020-08-03 09:18:42', 'Request'),
(26, 1, 1, 16, 52, 'Production_transfer', 1000, 'Cash', 'credict', '2020-08-03 09:18:42', 'Request'),
(27, 1, 1, 16, 53, 'Production_transfer', 10, 'Cash', 'credict', '2020-08-03 09:20:11', 'Request'),
(28, 1, 1, 16, 54, 'Production_transfer', 1000, 'Cash', 'credict', '2020-08-03 09:20:11', 'Request'),
(29, 1, 1, 16, 55, 'Production_transfer', 0.45, 'Cash', 'credict', '2020-08-03 09:20:12', 'Request'),
(30, 1, 1, 16, 56, 'Production_transfer', 10, 'Cash', 'credict', '2020-08-03 09:20:12', 'Request'),
(31, 1, 1, 16, 57, 'Production_transfer', 0.2, 'Cash', 'credict', '2020-08-03 09:22:06', 'Request'),
(32, 1, 1, 16, 58, 'Production_transfer', 1000, 'Cash', 'credict', '2020-08-03 09:22:06', 'Request'),
(33, 1, 1, 16, 59, 'Production_transfer', 0.45, 'Cash', 'credict', '2020-08-03 09:22:06', 'Request'),
(34, 1, 1, 16, 60, 'Production_transfer', 0.2, 'Cash', 'credict', '2020-08-03 09:22:06', 'Request'),
(35, 1, 1, 16, 61, 'Production_transfer', 10, 'Cash', 'credict', '2020-08-03 09:23:33', 'Request'),
(36, 1, 1, 11, 5, 'Supply', 9000, 'Cash', 'credict', '2020-08-04 14:37:09', 'Request');

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

--
-- Table structure for table `users_group`
--

CREATE TABLE `users_group` (
  `group_id` int(11) NOT NULL,
  `group_name` varchar(100) NOT NULL,
  `group_description` text NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Active'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_group`
--

INSERT INTO `users_group` (`group_id`, `group_name`, `group_description`, `status`) VALUES
(1, 'Managers', 'My Managers Group', 'Active'),
(2, 'Staff', 'My Common Staff', 'Active'),
(3, 'Drivers', 'My Drivers', 'Active'),
(4, 'Cleaners', 'My Cleaners', 'Active'),
(5, 'Administrators', 'My Admin Officers', 'Active'),
(6, 'Regional Manager', 'Who Manage region activity', 'Active'),
(7, 'First Class', 'sssss', 'Active');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_timeline`
--
ALTER TABLE `activity_timeline`
  ADD PRIMARY KEY (`span_id`);

--
-- Indexes for table `bank_account`
--
ALTER TABLE `bank_account`
  ADD PRIMARY KEY (`wallet_id`);

--
-- Indexes for table `company_groups`
--
ALTER TABLE `company_groups`
  ADD PRIMARY KEY (`group_id`);

--
-- Indexes for table `elitegrants`
--
ALTER TABLE `elitegrants`
  ADD PRIMARY KEY (`elite_id`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`expensesNo`);

--
-- Indexes for table `expenses_category`
--
ALTER TABLE `expenses_category`
  ADD PRIMARY KEY (`exp_category_id`);

--
-- Indexes for table `investmenthis`
--
ALTER TABLE `investmenthis`
  ADD PRIMARY KEY (`investment_id`);

--
-- Indexes for table `local_governments`
--
ALTER TABLE `local_governments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state_id` (`state_id`);

--
-- Indexes for table `logindetails`
--
ALTER TABLE `logindetails`
  ADD PRIMARY KEY (`loginno`);

--
-- Indexes for table `my_messages`
--
ALTER TABLE `my_messages`
  ADD PRIMARY KEY (`message_id`);

--
-- Indexes for table `my_tasks`
--
ALTER TABLE `my_tasks`
  ADD PRIMARY KEY (`task_id`);

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

--
-- Indexes for table `tasks_relations`
--
ALTER TABLE `tasks_relations`
  ADD PRIMARY KEY (`relation_id`);

--
-- Indexes for table `task_activities`
--
ALTER TABLE `task_activities`
  ADD PRIMARY KEY (`activity_id`);

--
-- Indexes for table `transaction_history`
--
ALTER TABLE `transaction_history`
  ADD PRIMARY KEY (`transaction_id`);

--
-- Indexes for table `users_group`
--
ALTER TABLE `users_group`
  ADD PRIMARY KEY (`group_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_timeline`
--
ALTER TABLE `activity_timeline`
  MODIFY `span_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `bank_account`
--
ALTER TABLE `bank_account`
  MODIFY `wallet_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

--
-- AUTO_INCREMENT for table `elitegrants`
--
ALTER TABLE `elitegrants`
  MODIFY `elite_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `expensesNo` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses_category`
--
ALTER TABLE `expenses_category`
  MODIFY `exp_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `investmenthis`
--
ALTER TABLE `investmenthis`
  MODIFY `investment_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `logindetails`
--
ALTER TABLE `logindetails`
  MODIFY `loginno` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=207;

--
-- AUTO_INCREMENT for table `my_messages`
--
ALTER TABLE `my_messages`
  MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `tasks_relations`
--
ALTER TABLE `tasks_relations`
  MODIFY `relation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `task_activities`
--
ALTER TABLE `task_activities`
  MODIFY `activity_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `transaction_history`
--
ALTER TABLE `transaction_history`
  MODIFY `transaction_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `users_group`
--
ALTER TABLE `users_group`
  MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

