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

START TRANSACTION;



--
-- Database: `loba_desk`
--

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

--
-- Table structure for table `address`
--

CREATE TABLE `address` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `company` varchar(32) COLLATE utf8_bin NOT NULL,
  `firstname` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lastname` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `address_1` varchar(128) COLLATE utf8_bin NOT NULL,
  `address_2` varchar(128) COLLATE utf8_bin NOT NULL,
  `postcode` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `city` varchar(128) COLLATE utf8_bin NOT NULL,
  `country_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `application_links`
--

CREATE TABLE `application_links` (
  `id` int(8) NOT NULL,
  `company_id` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `link` varchar(100) DEFAULT NULL,
  `homepage` int(1) DEFAULT '0',
  `status` int(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `app_list`
--

CREATE TABLE `app_list` (
  `id` int(8) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `order_id` int(8) DEFAULT NULL,
  `deleted` int(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bonuses`
--

CREATE TABLE `bonuses` (
  `id` int(12) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` int(12) NOT NULL,
  `code` varchar(50) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `target` varchar(100) DEFAULT NULL,
  `expenditure_target` varchar(255) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `deleted` int(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `branch_criterias`
--

CREATE TABLE `branch_criterias` (
  `id` int(11) NOT NULL,
  `branch_id` int(5) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `creteria` text,
  `deleted` int(1) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_contact_sources`
--

CREATE TABLE `call_centre_contact_sources` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_log_call_category`
--

CREATE TABLE `call_centre_log_call_category` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_log_call_type`
--

CREATE TABLE `call_centre_log_call_type` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_log_comments`
--

CREATE TABLE `call_centre_log_comments` (
  `id` int(11) NOT NULL,
  `commentor_usergroup_id` int(5) DEFAULT NULL,
  `commentor_id` int(5) DEFAULT NULL,
  `comment` text,
  `company_id` int(11) DEFAULT NULL,
  `call_log_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_log_products`
--

CREATE TABLE `call_centre_log_products` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_log_services`
--

CREATE TABLE `call_centre_log_services` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_log_turn_around_time`
--

CREATE TABLE `call_centre_log_turn_around_time` (
  `id` int(11) NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `from` int(5) DEFAULT NULL,
  `to` int(5) DEFAULT NULL,
  `company_id` varchar(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_questionnaire`
--

CREATE TABLE `call_centre_questionnaire` (
  `id` int(11) NOT NULL,
  `question` text,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `call_centre_security_questions`
--

CREATE TABLE `call_centre_security_questions` (
  `id` int(11) NOT NULL,
  `question` text,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cash_requests`
--

CREATE TABLE `cash_requests` (
  `id` int(11) NOT NULL,
  `department` int(5) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `purpose` text,
  `company_id` int(5) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `process_flow_code` varchar(50) DEFAULT NULL,
  `order` int(3) DEFAULT '1',
  `supervisor_id` int(11) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `request_type` int(5) DEFAULT NULL,
  `cash_retire` int(1) DEFAULT '0',
  `status` int(1) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cash_request_comments`
--

CREATE TABLE `cash_request_comments` (
  `id` int(11) NOT NULL,
  `petty_request_id` int(11) DEFAULT NULL,
  `commentor_usergroup_id` int(5) DEFAULT NULL,
  `commentor_id` int(5) DEFAULT NULL,
  `comment` text,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cash_request_types`
--

CREATE TABLE `cash_request_types` (
  `id` int(5) NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cash_retirements`
--

CREATE TABLE `cash_retirements` (
  `id` int(11) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `cash_request_id` int(11) DEFAULT NULL,
  `allocated_budget` float DEFAULT NULL,
  `total_expenditure` float DEFAULT NULL,
  `balance` float DEFAULT NULL,
  `receipt_no` varchar(255) DEFAULT NULL,
  `comment` text,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `supervisor_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `colors`
--

CREATE TABLE `colors` (
  `id` int(11) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `color_dominant` varchar(12) DEFAULT NULL,
  `supporting_color` varchar(12) DEFAULT NULL,
  `menu_text_color` varchar(12) DEFAULT NULL,
  `text_color` varchar(12) DEFAULT NULL,
  `link_color` varchar(12) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `position` int(8) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `colors`
--

INSERT INTO `colors` (`id`, `company_id`, `color_dominant`, `supporting_color`, `menu_text_color`, `text_color`, `link_color`, `status`, `position`) VALUES
(1, 23, '#000000', '#ffc231', '#ffffff', '#333333', '#000000', 1, 0),
(2, 23, '#000000', '#222222', '#000000', '#000000', '#000000', 0, 0),
(3, 23, '#31318f', '#333333', '#333333', '#FFFFFF', '#FFFFFF', 0, 0),
(4, 41, '#FF3352 ', '#AF8389 ', '#AF8389 ', '#AF8389 ', '#AF8389 ', 1, 0);

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

--
-- Table structure for table `commerce`
--

CREATE TABLE `commerce` (
  `id` int(12) NOT NULL,
  `no` varchar(50) DEFAULT NULL,
  `lpo_no` varchar(50) DEFAULT NULL,
  `customer_id` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `payment_mode` varchar(100) DEFAULT NULL,
  `status` int(2) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_received` varchar(50) DEFAULT NULL,
  `creator` int(12) DEFAULT NULL,
  `payment_received_by` int(8) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `commerce_items`
--

CREATE TABLE `commerce_items` (
  `id` int(12) NOT NULL,
  `item` varchar(255) DEFAULT NULL,
  `price` varchar(50) DEFAULT NULL,
  `quantity` varchar(50) DEFAULT NULL,
  `amount` varchar(50) DEFAULT NULL,
  `commerce_id` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `creator` int(12) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `commerce_status`
--

CREATE TABLE `commerce_status` (
  `id` int(12) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `company_events`
--

CREATE TABLE `company_events` (
  `id` int(11) NOT NULL,
  `short_title` varchar(255) DEFAULT NULL,
  `long_title` varchar(255) DEFAULT NULL,
  `summary` text,
  `description` text,
  `image_caption` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `event_date` varchar(50) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `author` varchar(255) DEFAULT NULL,
  `headline` varchar(255) DEFAULT NULL,
  `highlight` int(1) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `sub_cat_id` int(8) DEFAULT NULL,
  `status` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `company_handbooks`
--

CREATE TABLE `company_handbooks` (
  `id` int(11) NOT NULL,
  `short_title` varchar(255) DEFAULT NULL,
  `long_title` varchar(255) DEFAULT NULL,
  `summary` text,
  `description` longtext,
  `image_caption` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `author` varchar(255) DEFAULT NULL,
  `headline` varchar(255) DEFAULT NULL,
  `highlight` int(1) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `sub_cat_id` int(8) DEFAULT NULL,
  `status` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `company_news`
--

CREATE TABLE `company_news` (
  `id` int(11) NOT NULL,
  `short_title` varchar(255) DEFAULT NULL,
  `long_title` varchar(255) DEFAULT NULL,
  `summary` text,
  `description` text,
  `image_caption` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `author` varchar(255) DEFAULT NULL,
  `headline` varchar(255) DEFAULT NULL,
  `highlight` int(1) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `sub_cat_id` int(8) DEFAULT NULL,
  `status` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company_news`
--

INSERT INTO `company_news` (`id`, `short_title`, `long_title`, `summary`, `description`, `image_caption`, `image`, `date`, `author`, `headline`, `highlight`, `source`, `company_id`, `cat_id`, `sub_cat_id`, `status`) VALUES
(41, NULL, 'What Has Changed? - Kwamena Duncan Quizzes Mahama', 'Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.', '<p>Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.Central Regional Minister, Kwamena Duncan has questioned why former President John Mahama changed his stand regarding the non-interference in the work of the Electoral Commission.</p>\r\n', NULL, 'pictures/5ee3/229c/5ee3229c8b284eebb9114fdec0b934b8.jpeg', '2020-06-12 06:37:16', NULL, NULL, NULL, NULL, 41, NULL, NULL, 1),
(42, NULL, 'Zongo Chiefs Offer Land To Zongo Ministry For The Construction Of Secondary School', 'The Greater Accra Regional Council of Zongo Chiefs led by its acting Chairman, Chief Siddique Gimala has applauded the establishment of the Zongo Development Fund(ZoDF) for the tailor-made development of the Zongo communities across the country.', '<p>The Greater Accra Regional Council of Zongo Chiefs led by its acting Chairman, Chief Siddique Gimala has applauded the establishment of the Zongo Development Fund(ZoDF) for the tailor-made development of the Zongo communities across the country.</p>\r\n\r\n<p>Chief Siddique Gimala gave this applaud when he led a council of Zongo chiefs to call on the Hon. Minister for Inner -City and Zongo Development, Dr. Mustapha Abdul-Hamid at his office in Accra.</p>\r\n\r\n<p>The Council applauded the Ministry and the Zongo Development Fund for the developmental projects in Zongo communities across the country.&nbsp;</p>\r\n\r\n<p>According to Chief Alhaji Morro Baba Issah, Public Relations Officer for the eminent Zongo Chiefs, the Council supports the Ministry&#39;s focus on educational projects.</p>\r\n\r\n<p>In view of that, they want to offer a parcel of land for the construction of a Senior High School at the precinct of the Central Mosque, Abbosey Okai, a suburb in Accra.</p>\r\n\r\n<p>They further proposed school be named after the National Chief Imam, Sheikh Dr. Osman Nuhu Sharubutu.</p>\r\n\r\n<p>The chiefs presented Dr. Abdul-Hamid with a document containing the architectural designs of the proposed project and the site plan of the land.&nbsp;</p>\r\n\r\n<p>The Hon. Minister on his part, thanked the Council for the visit and assured them of the Ministry&#39;s continuous support for their activities. To show his commitment to the construction of the proposed &quot;Dr Osman Nuhu Sharubutu Senior High School&quot;, the Hon. Minister told them that he will visit the site with a technical team from the Ministry.&nbsp;</p>\r\n\r\n<p>Dr. Abdul-Hamid appealed to them to continuously support for the work of the Ministry and the Zongo Development Fund.</p>\r\n\r\n<p>Source:checkoutghana.com</p>\r\n', NULL, 'pictures/5ee3/2e0d/5ee32e0dc3844c529cdd41aac0b934b8.jpeg', '2020-06-12 07:26:05', NULL, NULL, NULL, NULL, 43, NULL, NULL, 1),
(43, NULL, 'Zongo Development Fund: Impacting Lives, Transforming Communities', 'It was precisely to advance human dignity and bring prosperity to the Ghanaian people, that President Akufo-Addo, as candidate of the New Patriotic Party (NPP) in 2016, promised to put in place programmes that will ensure equal opportunity for all Ghanaians irrespective of their creed, place of birth or social circumstance. ', '<p>&ldquo;Politics is about advancing human dignity and prosperity&rdquo;- Karl Rove.&nbsp;</p>\r\n\r\n<p>It was precisely to advance human dignity and bring prosperity to the Ghanaian people, that President Akufo-Addo, as candidate of the New Patriotic Party (NPP) in 2016, promised to put in place programmes that will ensure equal opportunity for all Ghanaians irrespective of their creed, place of birth or social circumstance.&nbsp;</p>\r\n\r\n<p>A key part of the promise to establish a society of opportunity for all, was to establish a Zongo Development Fund, to be superintended by a Zongo and Inner-City Development Minister.</p>\r\n\r\n<p>&nbsp;In presenting his Coordinated Programme of Economic and Social Development Policies, 2017-2024, the President did indeed make good his promise to establish a Zongo Development Fund for the purposes of addressing the development deficit that has been the bane of Zongo communities since independence.</p>\r\n\r\n<p>Page 116 of the President&rsquo;s Coordinated Programme of Economic and Social Development Policies, 2017-2024, states</p>\r\n\r\n<p>As part of the efforts to develop Zongo communities, government will set up a Zongo Development Fund (ZODF) with seed funding of GH&Euml;219.5 million.&nbsp;</p>\r\n\r\n<p>The Fund will support the provision of critical infrastructure in education and training, health and sanitation, local businesses and centres of culture, as well as improve security in Zongo communities.</p>\r\n\r\n<p>&nbsp;The ZODF is expected to leverage its seed fund to attract additional funding from international partners, private sector institutions, civil society organisations and other non-governmental organisations.</p>\r\n\r\n<p>There are over 3,000 Zongo communities scattered across the country, with an estimated population of about five million.</p>\r\n\r\n<p>&nbsp;If indeed, the country is to achieve the millennium development goals, key among which is the creation of sustainable communities, then the Zongo development agenda becomes even more imperative.</p>\r\n\r\n<p>&nbsp;Ever since the establishment of the Ministry and the Fund therefore, they have been pursuing an aggressive agenda of social and economic development in Zongo communities, with a view to bringing up development in these communities to the standard that is comparable to other communities across the country.</p>\r\n\r\n<p>As its mandate as outlined on page 116 of the Economic and Social Development Policy document states, projects that have been carried out by the Zongo Development Fund under the direction of the Ministry, seek to address the educational, health, security, recreation and economic needs of the people in the Zongo communities.</p>\r\n\r\n<p>Even though the mandate of the fund has been outlined for it by the Economic and Social Development Policy document, the fund still engages in wide consultative processes to arrive a decision on which project to situate in which community.</p>\r\n\r\n<p>Chiefs, political, religious and youth leaders often make their requests for projects to either the Ministry or to the fund. A technical team is then sent to the areas where these requests have come from, to validate the projects. The Governing Board of the Fund then reviews and approves or the projects for execution.</p>\r\n\r\n<p>This far, projects that are being executed by the ZODF include the construction and furnishing of classroom blocks, provision of Information and Communication Technology (ICT) laboratories, construction of astro turfs, provision of water and health facilities, construction of public and household toilets. Besides, the sector engages in social and economic empowerment programmes. Many of the projects have started, others are near completion while many more are completed.</p>\r\n\r\n<p>It is the expectation that the Zongo Development Ministry would be allowed to stay into the foreseeable future in order to guarantee the long-term development of the communities that come under the ambit of the Ministry.</p>\r\n\r\n<p>Indeed, development is a journey and as the Chinese have stated, &ldquo;a journey of a thousand miles begins with a step.&rdquo; It is expected that within a generation, this initiative can dramatically transform the lives of the five million people who live in these communities.&nbsp; &nbsp;</p>\r\n\r\n<p>Educational projects</p>\r\n\r\n<p>Education is key to the development of Zongo communities and so the MICZD and the ZoDF are keen in ensuring the provision of the necessary infrastructure to facilitate teaching and learning.</p>\r\n\r\n<p>In the area of school blocks and furnishing, work is ongoing at 31 locations across the country. Each of the projects is a six-unit classroom block, and some of the school blocks will be furnished. Some of the projects are about 90 per cent complete. The projects are sited at places including the Manso Zongo in the Amenfi Central District of the Western Region (about 80 per cent complete), Agogo Zongo in the Asante Akim South District of the Ashanti Region (about 95 per cent complete), and in Nsuaem in the Bosome Freho District in the Ashanti Region (about 35 per cent complete), and Tolon in the Tolon District of the Northern Region (about 40 per cent complete).</p>\r\n\r\n<p>Besides, the construction of a community library is ongoing at Adoagyiri in the Nsawam Municipal Assembly of the Eastern Region.</p>\r\n\r\n<p>The fund has also supplied 300 dual desk furniture to two schools school at Ahamasu in the Kadjebi District of the Oti Region.</p>\r\n\r\n<p>ICT labs</p>\r\n\r\n<p>Another major initiative of the MICZD is the provision of ICT laboratories in some schools across the country. It involves the provision of computers and furniture.</p>\r\n\r\n<p>Some of the beneficiary schools are Huriya E/A School in Wa and Falahiya Islamic School in Tumu, both in the Upper West Region; Basin KG/Primary/JHS in Navrongo and Umaria E/A JHS, both in the Upper West Region, and Nuriyya Islamic School Complex in Ho and Aswaj English and Arabic Basic School in Hohoe, both in the Volta Region.</p>\r\n\r\n<p>Water systems</p>\r\n\r\n<p>Water is life and the MICZD and ZoDF have given credence to this adage by constructing mechanised boreholes in some Zongo communities. Fifteen of the mechanised water systems have been completed. Some of the beneficiary communities of these water systems are the Bibiani Zongo in the Bibiani/Anhwiaso/Bekwai District and Dwenase Zongo in the Sefwi Wiaso District, both of the Western-North District; Opeikuma Zongo in the Awutu Senya East District of the Central Region, and Dambai Zongo in the Krachi East District of the Oti Region. Contractors have completed all works and are awaiting final inspection and commissioning.</p>\r\n\r\n<p>Contractors are also on-site for the construction of 23 more mechanised water systems in other Zongo communities across the country.</p>\r\n\r\n<p>Public toilets/Household toilets</p>\r\n\r\n<p>The ZoDF is also taking aggressive action in ensuring the provision of public and household toilets in Zongo communities and inner cities.</p>\r\n\r\n<p>Work is far advanced in the construction of nine toilet facilities in some parts of the country.</p>\r\n\r\n<p>Construction of a 10-seater institutional toilet at Bodwesango in the Adansi Asokwa District of the Ashanti Region is about 95 per cent complete, while that of Nkawie in the Atwima Nwabiagya South District in the Ashanti Region is also about 95 per cent complete. That of Salaga in the Salaga Municipal Assembly is about 80 per cent complete.</p>\r\n\r\n<p>A total of 252 households in inner cities have benefited from the household toilets. The beneficiary areas include Korle Gonno, Mamprobi, Agbogbloshie, Bukom, Adabraka, Chorkor and Kokompe, all in Accra.</p>\r\n\r\n<p>Street lights</p>\r\n\r\n<p>The Fund has completed the supply and installation of street lights in six communities in some Zongo communities.</p>\r\n\r\n<p>The project has improved visibility and security in the beneficiary communities.</p>\r\n\r\n<p>The beneficiary areas include Danfa Zongo and Madina Washington, both in the La Nkwantanang Madina District; Darul Salam Zongo and Ngleshie Amanfrom, all in the Greater Accra Region; Jema in the Bono-East Region, and Opeikuma in the Central Region.</p>\r\n\r\n<p>Astro turfs</p>\r\n\r\n<p>Another area of interest for the Ministry and the ZoDF is the creation of avenues for recreation and physical exercise for the people in Zongo communities. This has culminated in the construction of astro turfs in some communities.</p>\r\n\r\n<p>The beneficiary communities include Walewale in the North-East Region, Kyebi in the Eastern Region, Madina in the Greater Accra Region, Asawase in the Ashanti Region and Fadama in the Greater Accra Region.</p>\r\n\r\n<p>Work has commenced to convert five Green Parks in Bolgatanga, Salaga, Yeji, Tafo and Oda into Astro Turfs.</p>\r\n\r\n<p>Drainage/Road/Health</p>\r\n\r\n<p>A 994 metres drains have been completed. One of the drains (497 metres) was constructed at Madina Zongo in Accra. Construction of a drain and a retaining wall is about 70 per cent complete at Asem in Subin in the Kumasi Metropolis.</p>\r\n\r\n<p>The sector is also undertaking the rehabilitation of a health facility at Kpando in the Kpando District of the Volta Region.</p>\r\n\r\n<p>Special projects</p>\r\n\r\n<p>Construction of a school gatehouse for the Accra Girls&rsquo; Senior High School at Maamobi in the Ayawaso North District of the Greater Accra Region is near completion, while work has started for the construction of an elevator for the Neo-natal Intensive Care Unit (NICU) of the Maamobi General Hospital. Both projects are sponsored by the ZoDF.</p>\r\n\r\n<p>Empowerment programmes</p>\r\n\r\n<p>Under the leadership of the MICZD, ICT training programmes are on-going to equip the youth with ICT skills and make them employable.&nbsp;</p>\r\n\r\n<p>The projects include Zongo StarHub Project (software training), Zongo Coders Programme and the Females in Tech Initiative.</p>\r\n\r\n<p>The ZoDF has engaged technical consultants to empower youth with entrepreneurial skills under the Zongo Youth Entrepreneurship Training Programme.</p>\r\n\r\n<p>It is instructive to note that many projects are at the procurement stage, which means that the projects have been validated, approved by the Board and are going through the processes for the award of the contracts.</p>\r\n\r\n<p>COVID-19 support packages</p>\r\n\r\n<p>With the onset of Covid-19, the ZoDF took proactive steps to create awareness about the pandemic in Zongo communities and distribute hygiene items to prevent and mitigate its spread in those areas.</p>\r\n\r\n<p>&nbsp;A team of health professionals were contracted to engage in media campaign on the preventive protocols in Hausa, Dagbani, Twi, Ga and other local languages.&nbsp;</p>\r\n\r\n<p>The Fund has also distributed liquid soap, hand sanitizer and face masks to chiefs and households in Accra, Kasoa, Kumasi, Ejura and other areas.&nbsp;</p>\r\n\r\n<p>The plan is to distribute 200,000 pieces of liquid soap and hand sanitizer and one million pieces of face masks to 40,000 households within the Zongo communities.</p>\r\n\r\n<p>Stakeholder collaboration</p>\r\n\r\n<p>Development is a process and the key aspect of that process is the identification of the problem.&nbsp;</p>\r\n\r\n<p>The next step is taking the necessary steps to bring about the needed change. This is indeed the story of the creation of the MICZD and the ZoDF.</p>\r\n\r\n<p>If the current trend of development projects being executed by the MICZD and the ZoDF in Zongo communities and inner cities is sustained in the next few years, those areas will witness improvement in infrastructure and living standards of the people.</p>\r\n\r\n<p>Therefore, stakeholders in Zongo communities, such as chiefs, political, religious and youth leaders are required to collaborate with the Ministry and the ZoDF to push the agenda of accelerating the development in Zongo communities and inner cities.</p>\r\n\r\n<p>Source: Musah Yahaya Jafaru</p>\r\n', NULL, 'pictures/5ee3/2edd/5ee32edd7ea0406ca1c6443cc0b934b8.jpeg', '2020-06-12 07:29:33', NULL, NULL, NULL, NULL, 43, NULL, NULL, 1);

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

--
-- Table structure for table `complain_comments`
--

CREATE TABLE `complain_comments` (
  `id` int(11) NOT NULL,
  `commentor_usergroup_id` int(5) DEFAULT NULL,
  `commentor_id` int(5) DEFAULT NULL,
  `comment` text,
  `company_id` int(11) DEFAULT NULL,
  `complain_log_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `constituencies`
--

CREATE TABLE `constituencies` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `region_id` int(5) NOT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `constituencies`
--

INSERT INTO `constituencies` (`id`, `name`, `region_id`, `abbr`, `created`) VALUES
(1, 'Asunafo North', 1, NULL, '2020-06-24 08:43:44'),
(2, 'Asunafo South', 1, NULL, '2020-06-24 08:43:44'),
(3, 'Asutifi North', 1, NULL, '2020-06-24 08:43:44'),
(4, 'Asutifi South', 1, NULL, '2020-06-24 08:43:44'),
(5, 'Tano North', 1, NULL, '2020-06-24 08:43:44'),
(6, 'Tano South', 1, NULL, '2020-06-24 08:43:44'),
(7, 'Adansi-Asokwa', 2, NULL, '2020-06-24 08:43:44'),
(8, 'Fomena (Adansi North)', 2, NULL, '2020-06-24 08:43:44'),
(9, 'New Edubease', 2, NULL, '2020-06-24 08:43:44'),
(10, 'Afigya Kwabre North', 2, NULL, '2020-06-24 08:43:44'),
(11, 'Kwabre West (Afigya Kwabre South)', 2, NULL, '2020-06-24 08:43:44'),
(12, 'Ahafo Ano North', 2, NULL, '2020-06-24 08:43:44'),
(13, 'Ahafo Ano South East', 2, NULL, '2020-06-24 08:43:44'),
(14, 'Ahafo Ano South West', 2, NULL, '2020-06-24 08:43:44'),
(15, 'Akrofuom', 2, NULL, '2020-06-24 08:43:44'),
(16, 'Odotobri', 2, NULL, '2020-06-24 08:43:44'),
(17, 'Manso Nkwanta', 2, NULL, '2020-06-24 08:43:44'),
(18, 'Manso Edubia', 2, NULL, '2020-06-24 08:43:44'),
(19, 'Asante-Akim Central', 2, NULL, '2020-06-24 08:43:44'),
(20, 'Asante-Akim North', 2, NULL, '2020-06-24 08:43:44'),
(21, 'Asante-Akim South', 2, NULL, '2020-06-24 08:43:44'),
(22, 'Asawase', 2, NULL, '2020-06-24 08:43:44'),
(23, 'Atwima-Kwanwoma', 2, NULL, '2020-06-24 08:43:44'),
(24, 'Atwima-Mponua', 2, NULL, '2020-06-24 08:43:44'),
(25, 'Atwima-Nwabiagya North', 2, NULL, '2020-06-24 08:43:44'),
(26, 'Atwima-Nwabiagya South', 2, NULL, '2020-06-24 08:43:44'),
(27, 'Bekwai', 2, NULL, '2020-06-24 08:43:44'),
(28, 'Bosome-Freho', 2, NULL, '2020-06-24 08:43:44'),
(29, 'Bosomtwe', 2, NULL, '2020-06-24 08:43:44'),
(30, 'Ejisu', 2, NULL, '2020-06-24 08:43:44'),
(31, 'Ejura', 2, NULL, '2020-06-24 08:43:44'),
(32, 'Juaben', 2, NULL, '2020-06-24 08:43:44'),
(33, 'Asokwa', 2, NULL, '2020-06-24 08:43:44'),
(34, 'Bantama', 2, NULL, '2020-06-24 08:43:44'),
(35, 'Kwadaso', 2, NULL, '2020-06-24 08:43:44'),
(36, 'Manhyia North', 2, NULL, '2020-06-24 08:43:44'),
(37, 'Manhyia South', 2, NULL, '2020-06-24 08:43:44'),
(38, 'Nhyiaeso', 2, NULL, '2020-06-24 08:43:44'),
(39, 'Subin', 2, NULL, '2020-06-24 08:43:44'),
(40, 'Kwabre East', 2, NULL, '2020-06-24 08:43:44'),
(41, 'Mampong', 2, NULL, '2020-06-24 08:43:44'),
(42, 'Obuasi East', 2, NULL, '2020-06-24 08:43:44'),
(43, 'Obuasi West', 2, NULL, '2020-06-24 08:43:44'),
(44, 'Offinso North', 2, NULL, '2020-06-24 08:43:44'),
(45, 'Offinso South', 2, NULL, '2020-06-24 08:43:44'),
(46, 'Oforikrom', 2, NULL, '2020-06-24 08:43:44'),
(47, 'Old Tafo', 2, NULL, '2020-06-24 08:43:44'),
(48, 'Sekyere Afram plains', 2, NULL, '2020-06-24 08:43:44'),
(49, 'Kumawu', 2, NULL, '2020-06-24 08:43:44'),
(50, 'Nsuta-Kwamang-Beposo', 2, NULL, '2020-06-24 08:43:44'),
(51, 'Afigya Sekyere West', 2, NULL, '2020-06-24 08:43:44'),
(52, 'Effiduase-Asokore', 2, NULL, '2020-06-24 08:43:44'),
(53, 'Afigya Sekyere East', 2, NULL, '2020-06-24 08:43:44'),
(54, 'Suame', 2, NULL, '2020-06-24 08:43:44'),
(55, 'Banda Ahenkro', 3, NULL, '2020-06-24 08:43:44'),
(56, 'Berekum East', 3, NULL, '2020-06-24 08:43:44'),
(57, 'Berekum West', 3, NULL, '2020-06-24 08:43:44'),
(58, 'Dormaa Central', 3, NULL, '2020-06-24 08:43:44'),
(59, 'Dormaa East', 3, NULL, '2020-06-24 08:43:44'),
(60, 'Dormaa West', 3, NULL, '2020-06-24 08:43:44'),
(61, 'Jaman North', 3, NULL, '2020-06-24 08:43:44'),
(62, 'Jaman South', 3, NULL, '2020-06-24 08:43:44'),
(63, 'Sunyani East', 3, NULL, '2020-06-24 08:43:44'),
(64, 'Sunyani West', 3, NULL, '2020-06-24 08:43:44'),
(65, 'Tain', 3, NULL, '2020-06-24 08:43:44'),
(66, 'Wenchi', 3, NULL, '2020-06-24 08:43:44'),
(67, 'Atebubu-Amantin', 4, NULL, '2020-06-24 08:43:44'),
(68, 'Kintampo North', 4, NULL, '2020-06-24 08:43:44'),
(69, 'Kintampo South', 4, NULL, '2020-06-24 08:43:44'),
(70, 'Nkoranza North', 4, NULL, '2020-06-24 08:43:44'),
(71, 'Nkoranza South', 4, NULL, '2020-06-24 08:43:44'),
(72, 'Pru East', 4, NULL, '2020-06-24 08:43:44'),
(73, 'Pru West', 4, NULL, '2020-06-24 08:43:44'),
(74, 'Sene East', 4, NULL, '2020-06-24 08:43:44'),
(75, 'Sene West', 4, NULL, '2020-06-24 08:43:44'),
(76, 'Techiman North', 4, NULL, '2020-06-24 08:43:44'),
(77, 'Techiman South', 4, NULL, '2020-06-24 08:43:44'),
(78, 'Abura-Asebu-Kwamankese', 5, NULL, '2020-06-24 08:43:44'),
(79, 'Agona East', 5, NULL, '2020-06-24 08:43:44'),
(80, 'Agona West', 5, NULL, '2020-06-24 08:43:44'),
(81, 'Ajumako-Enyan-Essiam', 5, NULL, '2020-06-24 08:43:44'),
(82, 'Asikuma-Odoben-Brakwa', 5, NULL, '2020-06-24 08:43:44'),
(83, 'Assin Central', 5, NULL, '2020-06-24 08:43:44'),
(84, 'Assin North', 5, NULL, '2020-06-24 08:43:44'),
(85, 'Assin South', 5, NULL, '2020-06-24 08:43:44'),
(86, 'Awutu-Senya East', 5, NULL, '2020-06-24 08:43:44'),
(87, 'Awutu-Senya West', 5, NULL, '2020-06-24 08:43:44'),
(88, 'Cape Coast North', 5, NULL, '2020-06-24 08:43:44'),
(89, 'Cape Coast South', 5, NULL, '2020-06-24 08:43:44'),
(90, 'Effutu', 5, NULL, '2020-06-24 08:43:44'),
(91, 'Ekumfi', 5, NULL, '2020-06-24 08:43:44'),
(92, 'Gomoa Central', 5, NULL, '2020-06-24 08:43:44'),
(93, 'Gomoa East', 5, NULL, '2020-06-24 08:43:44'),
(94, 'Gomoa West', 5, NULL, '2020-06-24 08:43:44'),
(95, 'Komenda-Edina-Eguafo-Abirem', 5, NULL, '2020-06-24 08:43:44'),
(96, 'Mfantseman', 5, NULL, '2020-06-24 08:43:44'),
(97, 'Twifo-Atii Morkwaa', 5, NULL, '2020-06-24 08:43:44'),
(98, 'Hemang Lower Denkyira', 5, NULL, '2020-06-24 08:43:44'),
(99, 'Upper Denkyira East', 5, NULL, '2020-06-24 08:43:44'),
(100, 'Upper Denkyira West', 5, NULL, '2020-06-24 08:43:44'),
(101, 'Abuakwa North', 6, NULL, '2020-06-24 08:43:44'),
(102, 'Abuakwa South', 6, NULL, '2020-06-24 08:43:44'),
(103, 'Afram Plains North', 6, NULL, '2020-06-24 08:43:44'),
(104, 'Afram Plains South', 6, NULL, '2020-06-24 08:43:44'),
(105, 'Akropong', 6, NULL, '2020-06-24 08:43:44'),
(106, 'Akuapem North', 6, NULL, '2020-06-24 08:43:44'),
(107, 'Akwapim South', 6, NULL, '2020-06-24 08:43:44'),
(108, 'Ofoase-Ayirebi', 6, NULL, '2020-06-24 08:43:44'),
(109, 'Asene Akroso-Manso', 6, NULL, '2020-06-24 08:43:44'),
(110, 'Asuogyaman', 6, NULL, '2020-06-24 08:43:44'),
(111, 'Atiwa East', 6, NULL, '2020-06-24 08:43:44'),
(112, 'Atiwa West', 6, NULL, '2020-06-24 08:43:44'),
(113, 'Ayensuano', 6, NULL, '2020-06-24 08:43:44'),
(114, 'Akim Oda', 6, NULL, '2020-06-24 08:43:44'),
(115, 'Abirem', 6, NULL, '2020-06-24 08:43:44'),
(116, 'Akim Swedru', 6, NULL, '2020-06-24 08:43:44'),
(117, 'Achiase', 6, NULL, '2020-06-24 08:43:44'),
(118, 'Akwatia', 6, NULL, '2020-06-24 08:43:44'),
(119, 'Fanteakwa North', 6, NULL, '2020-06-24 08:43:44'),
(120, 'Fanteakwa South', 6, NULL, '2020-06-24 08:43:44'),
(121, 'Kade', 6, NULL, '2020-06-24 08:43:44'),
(122, 'Abetifi', 6, NULL, '2020-06-24 08:43:44'),
(123, 'Mpraeso', 6, NULL, '2020-06-24 08:43:44'),
(124, 'Nkawkaw', 6, NULL, '2020-06-24 08:43:44'),
(125, 'Lower Manya', 6, NULL, '2020-06-24 08:43:44'),
(126, 'New Juaben North', 6, NULL, '2020-06-24 08:43:44'),
(127, 'New Juaben South', 6, NULL, '2020-06-24 08:43:44'),
(128, 'Nsawam Adoagyiri', 6, NULL, '2020-06-24 08:43:44'),
(129, 'Okere', 6, NULL, '2020-06-24 08:43:44'),
(130, 'Suhum', 6, NULL, '2020-06-24 08:43:44'),
(131, 'Upper Manya', 6, NULL, '2020-06-24 08:43:44'),
(132, 'Upper West Akim', 6, NULL, '2020-06-24 08:43:44'),
(133, 'Lower West Akim', 6, NULL, '2020-06-24 08:43:44'),
(134, 'Yilo Krobo', 6, NULL, '2020-06-24 08:43:44'),
(135, 'Ablekuma North', 7, NULL, '2020-06-24 08:43:44'),
(136, 'Ablekuma West', 7, NULL, '2020-06-24 08:43:44'),
(137, 'Ablekuma Central', 7, NULL, '2020-06-24 08:43:44'),
(138, 'Ablekuma South', 7, NULL, '2020-06-24 08:43:44'),
(139, 'Domeabra-Obom', 7, NULL, '2020-06-24 08:43:44'),
(140, 'Korle Klottey', 7, NULL, '2020-06-24 08:43:44'),
(141, 'Odododiodoo', 7, NULL, '2020-06-24 08:43:44'),
(142, 'Okaikwei North', 7, NULL, '2020-06-24 08:43:44'),
(143, 'Okaikwei Central', 7, NULL, '2020-06-24 08:43:44'),
(144, 'Okaikwei South', 7, NULL, '2020-06-24 08:43:44'),
(145, 'Ada', 7, NULL, '2020-06-24 08:43:44'),
(146, 'Sege', 7, NULL, '2020-06-24 08:43:44'),
(147, 'Adenta', 7, NULL, '2020-06-24 08:43:44'),
(148, 'Ashaiman', 7, NULL, '2020-06-24 08:43:44'),
(149, 'Ayawaso Central', 7, NULL, '2020-06-24 08:43:44'),
(150, 'Ayawaso East', 7, NULL, '2020-06-24 08:43:44'),
(151, 'Ayawaso North', 7, NULL, '2020-06-24 08:43:44'),
(152, 'Ayawaso West Wuogon', 7, NULL, '2020-06-24 08:43:44'),
(153, 'Dome-Kwabenya', 7, NULL, '2020-06-24 08:43:44'),
(154, 'Anyaa-Sowutuom', 7, NULL, '2020-06-24 08:43:44'),
(155, 'Trobu', 7, NULL, '2020-06-24 08:43:44'),
(156, 'Domeabra-Obom', 7, NULL, '2020-06-24 08:43:44'),
(157, 'Ngleshie Amanfrom', 7, NULL, '2020-06-24 08:43:44'),
(158, 'Weija-Gbawe', 7, NULL, '2020-06-24 08:43:44'),
(159, 'Amasaman', 7, NULL, '2020-06-24 08:43:44'),
(160, 'Kpone-Katamanso', 7, NULL, '2020-06-24 08:43:44'),
(161, 'Krowor', 7, NULL, '2020-06-24 08:43:44'),
(162, 'Dade Kotopon', 7, NULL, '2020-06-24 08:43:44'),
(163, 'Abokobi-Madina', 7, NULL, '2020-06-24 08:43:44'),
(164, 'Ledzokuku', 7, NULL, '2020-06-24 08:43:44'),
(165, 'Ningo-Prampram', 7, NULL, '2020-06-24 08:43:44'),
(166, 'Shai-Osudoku', 7, NULL, '2020-06-24 08:43:44'),
(167, 'Tema East', 7, NULL, '2020-06-24 08:43:44'),
(168, 'Tema Central', 7, NULL, '2020-06-24 08:43:44'),
(169, 'Tema West', 7, NULL, '2020-06-24 08:43:44'),
(170, 'Bunkpurugu', 8, NULL, '2020-06-24 08:43:44'),
(171, 'Chereponi', 8, NULL, '2020-06-24 08:43:44'),
(172, 'Nalerigu Gambaga', 8, NULL, '2020-06-24 08:43:44'),
(173, 'Yagaba-Kubori (Walewale West)', 8, NULL, '2020-06-24 08:43:44'),
(174, 'Walewale', 8, NULL, '2020-06-24 08:43:44'),
(175, 'Yunyoo', 8, NULL, '2020-06-24 08:43:44'),
(176, 'Gushegu', 9, NULL, '2020-06-24 08:43:44'),
(177, 'Karaga', 9, NULL, '2020-06-24 08:43:44'),
(178, 'Kpandai', 9, NULL, '2020-06-24 08:43:44'),
(179, 'Kumbungu', 9, NULL, '2020-06-24 08:43:44'),
(180, 'Mion', 9, NULL, '2020-06-24 08:43:44'),
(181, 'Nanton', 9, NULL, '2020-06-24 08:43:44'),
(182, 'Bimbilla', 9, NULL, '2020-06-24 08:43:44'),
(183, 'Wulensi', 9, NULL, '2020-06-24 08:43:44'),
(184, 'Saboba', 9, NULL, '2020-06-24 08:43:44'),
(185, 'Sagnarigu', 9, NULL, '2020-06-24 08:43:44'),
(186, 'Savelugu', 9, NULL, '2020-06-24 08:43:44'),
(187, 'Tamale Central', 9, NULL, '2020-06-24 08:43:44'),
(188, 'Tamale North', 9, NULL, '2020-06-24 08:43:44'),
(189, 'Tamale South', 9, NULL, '2020-06-24 08:43:44'),
(190, 'Tatale-Sanguli', 9, NULL, '2020-06-24 08:43:44'),
(191, 'Tolon', 9, NULL, '2020-06-24 08:43:44'),
(192, 'Kumbungu', 9, NULL, '2020-06-24 08:43:44'),
(193, 'Yendi', 9, NULL, '2020-06-24 08:43:44'),
(194, 'Zabzugu', 9, NULL, '2020-06-24 08:43:44'),
(195, 'Biakoye', 10, NULL, '2020-06-24 08:43:44'),
(196, 'Buem', 10, NULL, '2020-06-24 08:43:44'),
(197, 'Akan', 10, NULL, '2020-06-24 08:43:44'),
(198, 'Krachi East', 10, NULL, '2020-06-24 08:43:44'),
(199, 'Krachi Nchumuru', 10, NULL, '2020-06-24 08:43:44'),
(200, 'Krachi West', 10, NULL, '2020-06-24 08:43:44'),
(201, 'Nkwanta North', 10, NULL, '2020-06-24 08:43:44'),
(202, 'Nkwanta South', 10, NULL, '2020-06-24 08:43:44'),
(203, 'Bole Bamboi', 11, NULL, '2020-06-24 08:43:44'),
(204, 'Yapei-Kusawgu', 11, NULL, '2020-06-24 08:43:44'),
(205, 'Salaga South', 11, NULL, '2020-06-24 08:43:44'),
(206, 'Salaga North', 11, NULL, '2020-06-24 08:43:44'),
(207, 'Daboya-Mankarigu', 11, NULL, '2020-06-24 08:43:44'),
(208, 'Sawla-Tuna-Kalba', 11, NULL, '2020-06-24 08:43:44'),
(209, 'Damango', 11, NULL, '2020-06-24 08:43:44'),
(210, 'Bawku Central', 12, NULL, '2020-06-24 08:43:44'),
(211, 'Zebilla', 12, NULL, '2020-06-24 08:43:44'),
(212, 'Binduri', 12, NULL, '2020-06-24 08:43:44'),
(213, 'Bolgatanga East', 12, NULL, '2020-06-24 08:43:44'),
(214, 'Bolgatanga Central', 12, NULL, '2020-06-24 08:43:44'),
(215, 'Bongo', 12, NULL, '2020-06-24 08:43:44'),
(216, 'Builsa North', 12, NULL, '2020-06-24 08:43:44'),
(217, 'Builsa South', 12, NULL, '2020-06-24 08:43:44'),
(218, 'Garu', 12, NULL, '2020-06-24 08:43:44'),
(219, 'Nabdam', 12, NULL, '2020-06-24 08:43:44'),
(220, 'Pusiga', 12, NULL, '2020-06-24 08:43:44'),
(221, 'Tempane', 12, NULL, '2020-06-24 08:43:44'),
(222, 'Navrongo Central', 12, NULL, '2020-06-24 08:43:44'),
(223, 'Chiana-Paga', 12, NULL, '2020-06-24 08:43:44'),
(224, 'Talensi', 12, NULL, '2020-06-24 08:43:44'),
(225, 'Daffiama Bussie Issa', 13, NULL, '2020-06-24 08:43:44'),
(226, 'Jirapa', 13, NULL, '2020-06-24 08:43:44'),
(227, 'Lambussie', 13, NULL, '2020-06-24 08:43:44'),
(228, 'Lawra', 13, NULL, '2020-06-24 08:43:44'),
(229, 'Nadowli Kaleo', 13, NULL, '2020-06-24 08:43:44'),
(230, 'Nandom', 13, NULL, '2020-06-24 08:43:44'),
(231, 'Sissala East', 13, NULL, '2020-06-24 08:43:44'),
(232, 'Sissala West', 13, NULL, '2020-06-24 08:43:44'),
(233, 'Wa East', 13, NULL, '2020-06-24 08:43:44'),
(234, 'Wa Central', 13, NULL, '2020-06-24 08:43:44'),
(235, 'Wa West', 13, NULL, '2020-06-24 08:43:44'),
(236, 'Adaklu', 14, NULL, '2020-06-24 08:43:44'),
(237, 'Afadjato South', 14, NULL, '2020-06-24 08:43:44'),
(238, 'Agotime-Ziope', 14, NULL, '2020-06-24 08:43:44'),
(239, 'Akatsi North', 14, NULL, '2020-06-24 08:43:44'),
(240, 'Akatsi South', 14, NULL, '2020-06-24 08:43:44'),
(241, 'Central Tongu', 14, NULL, '2020-06-24 08:43:44'),
(242, 'Ho Central', 14, NULL, '2020-06-24 08:43:44'),
(243, 'Ho West', 14, NULL, '2020-06-24 08:43:44'),
(244, 'Hohoe', 14, NULL, '2020-06-24 08:43:44'),
(245, 'Anlo', 14, NULL, '2020-06-24 08:43:44'),
(246, 'Keta', 14, NULL, '2020-06-24 08:43:44'),
(247, 'Ketu North', 14, NULL, '2020-06-24 08:43:44'),
(248, 'Ketu South', 14, NULL, '2020-06-24 08:43:44'),
(249, 'Kpando', 14, NULL, '2020-06-24 08:43:44'),
(250, 'North Tongu', 14, NULL, '2020-06-24 08:43:44'),
(251, 'North Dayi', 14, NULL, '2020-06-24 08:43:44'),
(252, 'South Dayi', 14, NULL, '2020-06-24 08:43:44'),
(253, 'South Tongu', 14, NULL, '2020-06-24 08:43:44'),
(254, 'Amenfi East', 15, NULL, '2020-06-24 08:43:44'),
(255, 'Amenfi Central', 15, NULL, '2020-06-24 08:43:44'),
(256, 'Ahanta West', 15, NULL, '2020-06-24 08:43:44'),
(257, 'Effia', 15, NULL, '2020-06-24 08:43:44'),
(258, 'Kwesimintsim', 15, NULL, '2020-06-24 08:43:44'),
(259, 'Ellembelle', 15, NULL, '2020-06-24 08:43:44'),
(260, 'Jomoro', 15, NULL, '2020-06-24 08:43:44'),
(261, 'Mpohor', 15, NULL, '2020-06-24 08:43:44'),
(262, 'Wassa East', 15, NULL, '2020-06-24 08:43:44'),
(263, 'Evalue-Gwira', 15, NULL, '2020-06-24 08:43:44'),
(264, 'Prestea-Huni Valley', 15, NULL, '2020-06-24 08:43:44'),
(265, 'Essikado-Ketan ', 15, NULL, '2020-06-24 08:43:44'),
(266, 'Sekondi', 15, NULL, '2020-06-24 08:43:44'),
(267, 'Takoradi', 15, NULL, '2020-06-24 08:43:44'),
(268, 'Shama', 15, NULL, '2020-06-24 08:43:44'),
(269, 'Tarkwa-Nsuaem', 15, NULL, '2020-06-24 08:43:44'),
(270, 'Wassa East', 15, NULL, '2020-06-24 08:43:44'),
(271, 'Aowin', 16, NULL, '2020-06-24 08:43:44'),
(272, 'Bia East', 16, NULL, '2020-06-24 08:43:44'),
(273, 'Bia West', 16, NULL, '2020-06-24 08:43:44'),
(274, 'Bibiani-Anhwiaso-Bekwai', 16, NULL, '2020-06-24 08:43:44'),
(275, 'Bodi', 16, NULL, '2020-06-24 08:43:44'),
(276, 'Juabeso', 16, NULL, '2020-06-24 08:43:44'),
(277, 'Sefwi-Akontombra', 16, NULL, '2020-06-24 08:43:44'),
(278, 'Sefwi Wiawso', 16, NULL, '2020-06-24 08:43:44'),
(279, 'Suaman', 16, NULL, '2020-06-24 08:43:44');

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

--
-- Table structure for table `contract_types`
--

CREATE TABLE `contract_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) VALUES
(1, 'AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 93),
(2, 'AL', 'ALBANIA', 'Albania', 'ALB', 8, 355),
(3, 'DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 213),
(4, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 1684),
(5, 'AD', 'ANDORRA', 'Andorra', 'AND', 20, 376),
(6, 'AO', 'ANGOLA', 'Angola', 'AGO', 24, 244),
(7, 'AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 1264),
(8, 'AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL, 0),
(9, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28, 1268),
(10, 'AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 54),
(11, 'AM', 'ARMENIA', 'Armenia', 'ARM', 51, 374),
(12, 'AW', 'ARUBA', 'Aruba', 'ABW', 533, 297),
(13, 'AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 61),
(14, 'AT', 'AUSTRIA', 'Austria', 'AUT', 40, 43),
(15, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 994),
(16, 'BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 1242),
(17, 'BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 973),
(18, 'BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 880),
(19, 'BB', 'BARBADOS', 'Barbados', 'BRB', 52, 1246),
(20, 'BY', 'BELARUS', 'Belarus', 'BLR', 112, 375),
(21, 'BE', 'BELGIUM', 'Belgium', 'BEL', 56, 32),
(22, 'BZ', 'BELIZE', 'Belize', 'BLZ', 84, 501),
(23, 'BJ', 'BENIN', 'Benin', 'BEN', 204, 229),
(24, 'BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 1441),
(25, 'BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 975),
(26, 'BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 591),
(27, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70, 387),
(28, 'BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 267),
(29, 'BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, 0),
(30, 'BR', 'BRAZIL', 'Brazil', 'BRA', 76, 55),
(31, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL, 246),
(32, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 673),
(33, 'BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 359),
(34, 'BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 226),
(35, 'BI', 'BURUNDI', 'Burundi', 'BDI', 108, 257),
(36, 'KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 855),
(37, 'CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 237),
(38, 'CA', 'CANADA', 'Canada', 'CAN', 124, 1),
(39, 'CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 238),
(40, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 1345),
(41, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 236),
(42, 'TD', 'CHAD', 'Chad', 'TCD', 148, 235),
(43, 'CL', 'CHILE', 'Chile', 'CHL', 152, 56),
(44, 'CN', 'CHINA', 'China', 'CHN', 156, 86),
(45, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, 61),
(46, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, 672),
(47, 'CO', 'COLOMBIA', 'Colombia', 'COL', 170, 57),
(48, 'KM', 'COMOROS', 'Comoros', 'COM', 174, 269),
(49, 'CG', 'CONGO', 'Congo', 'COG', 178, 242),
(50, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180, 242),
(51, 'CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 682),
(52, 'CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 506),
(53, 'CI', 'COTE D\'IVOIRE', 'Cote D\'Ivoire', 'CIV', 384, 225),
(54, 'HR', 'CROATIA', 'Croatia', 'HRV', 191, 385),
(55, 'CU', 'CUBA', 'Cuba', 'CUB', 192, 53),
(56, 'CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 357),
(57, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 420),
(58, 'DK', 'DENMARK', 'Denmark', 'DNK', 208, 45),
(59, 'DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 253),
(60, 'DM', 'DOMINICA', 'Dominica', 'DMA', 212, 1767),
(61, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 1809),
(62, 'EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 593),
(63, 'EG', 'EGYPT', 'Egypt', 'EGY', 818, 20),
(64, 'SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 503),
(65, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 240),
(66, 'ER', 'ERITREA', 'Eritrea', 'ERI', 232, 291),
(67, 'EE', 'ESTONIA', 'Estonia', 'EST', 233, 372),
(68, 'ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 251),
(69, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 500),
(70, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 298),
(71, 'FJ', 'FIJI', 'Fiji', 'FJI', 242, 679),
(72, 'FI', 'FINLAND', 'Finland', 'FIN', 246, 358),
(73, 'FR', 'FRANCE', 'France', 'FRA', 250, 33),
(74, 'GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 594),
(75, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 689),
(76, 'TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, 0),
(77, 'GA', 'GABON', 'Gabon', 'GAB', 266, 241),
(78, 'GM', 'GAMBIA', 'Gambia', 'GMB', 270, 220),
(79, 'GE', 'GEORGIA', 'Georgia', 'GEO', 268, 995),
(80, 'DE', 'GERMANY', 'Germany', 'DEU', 276, 49),
(81, 'GH', 'GHANA', 'Ghana', 'GHA', 288, 233),
(82, 'GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 350),
(83, 'GR', 'GREECE', 'Greece', 'GRC', 300, 30),
(84, 'GL', 'GREENLAND', 'Greenland', 'GRL', 304, 299),
(85, 'GD', 'GRENADA', 'Grenada', 'GRD', 308, 1473),
(86, 'GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 590),
(87, 'GU', 'GUAM', 'Guam', 'GUM', 316, 1671),
(88, 'GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 502),
(89, 'GN', 'GUINEA', 'Guinea', 'GIN', 324, 224),
(90, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 245),
(91, 'GY', 'GUYANA', 'Guyana', 'GUY', 328, 592),
(92, 'HT', 'HAITI', 'Haiti', 'HTI', 332, 509),
(93, 'HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL, 0),
(94, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 39),
(95, 'HN', 'HONDURAS', 'Honduras', 'HND', 340, 504),
(96, 'HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 852),
(97, 'HU', 'HUNGARY', 'Hungary', 'HUN', 348, 36),
(98, 'IS', 'ICELAND', 'Iceland', 'ISL', 352, 354),
(99, 'IN', 'INDIA', 'India', 'IND', 356, 91),
(100, 'ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 62),
(101, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364, 98),
(102, 'IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 964),
(103, 'IE', 'IRELAND', 'Ireland', 'IRL', 372, 353),
(104, 'IL', 'ISRAEL', 'Israel', 'ISR', 376, 972),
(105, 'IT', 'ITALY', 'Italy', 'ITA', 380, 39),
(106, 'JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 1876),
(107, 'JP', 'JAPAN', 'Japan', 'JPN', 392, 81),
(108, 'JO', 'JORDAN', 'Jordan', 'JOR', 400, 962),
(109, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 7),
(110, 'KE', 'KENYA', 'Kenya', 'KEN', 404, 254),
(111, 'KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 686),
(112, 'KP', 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 'Korea, Democratic People\'s Republic of', 'PRK', 408, 850),
(113, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410, 82),
(114, 'KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 965),
(115, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 996),
(116, 'LA', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 'Lao People\'s Democratic Republic', 'LAO', 418, 856),
(117, 'LV', 'LATVIA', 'Latvia', 'LVA', 428, 371),
(118, 'LB', 'LEBANON', 'Lebanon', 'LBN', 422, 961),
(119, 'LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 266),
(120, 'LR', 'LIBERIA', 'Liberia', 'LBR', 430, 231),
(121, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 218),
(122, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 423),
(123, 'LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 370),
(124, 'LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 352),
(125, 'MO', 'MACAO', 'Macao', 'MAC', 446, 853),
(126, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807, 389),
(127, 'MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 261),
(128, 'MW', 'MALAWI', 'Malawi', 'MWI', 454, 265),
(129, 'MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 60),
(130, 'MV', 'MALDIVES', 'Maldives', 'MDV', 462, 960),
(131, 'ML', 'MALI', 'Mali', 'MLI', 466, 223),
(132, 'MT', 'MALTA', 'Malta', 'MLT', 470, 356),
(133, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 692),
(134, 'MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 596),
(135, 'MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 222),
(136, 'MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 230),
(137, 'YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 269),
(138, 'MX', 'MEXICO', 'Mexico', 'MEX', 484, 52),
(139, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583, 691),
(140, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498, 373),
(141, 'MC', 'MONACO', 'Monaco', 'MCO', 492, 377),
(142, 'MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 976),
(143, 'MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 1664),
(144, 'MA', 'MOROCCO', 'Morocco', 'MAR', 504, 212),
(145, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 258),
(146, 'MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 95),
(147, 'NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 264),
(148, 'NR', 'NAURU', 'Nauru', 'NRU', 520, 674),
(149, 'NP', 'NEPAL', 'Nepal', 'NPL', 524, 977),
(150, 'NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 31),
(151, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 599),
(152, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 687),
(153, 'NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 64),
(154, 'NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 505),
(155, 'NE', 'NIGER', 'Niger', 'NER', 562, 227),
(156, 'NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 234),
(157, 'NU', 'NIUE', 'Niue', 'NIU', 570, 683),
(158, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 672),
(159, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 1670),
(160, 'NO', 'NORWAY', 'Norway', 'NOR', 578, 47),
(161, 'OM', 'OMAN', 'Oman', 'OMN', 512, 968),
(162, 'PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 92),
(163, 'PW', 'PALAU', 'Palau', 'PLW', 585, 680),
(164, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, 970),
(165, 'PA', 'PANAMA', 'Panama', 'PAN', 591, 507),
(166, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 675),
(167, 'PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 595),
(168, 'PE', 'PERU', 'Peru', 'PER', 604, 51),
(169, 'PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 63),
(170, 'PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612, 0),
(171, 'PL', 'POLAND', 'Poland', 'POL', 616, 48),
(172, 'PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 351),
(173, 'PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 1787),
(174, 'QA', 'QATAR', 'Qatar', 'QAT', 634, 974),
(175, 'RE', 'REUNION', 'Reunion', 'REU', 638, 262),
(176, 'RO', 'ROMANIA', 'Romania', 'ROM', 642, 40),
(177, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 70),
(178, 'RW', 'RWANDA', 'Rwanda', 'RWA', 646, 250),
(179, 'SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 290),
(180, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659, 1869),
(181, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 1758),
(182, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666, 508),
(183, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670, 1784),
(184, 'WS', 'SAMOA', 'Samoa', 'WSM', 882, 684),
(185, 'SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 378),
(186, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678, 239),
(187, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 966),
(188, 'SN', 'SENEGAL', 'Senegal', 'SEN', 686, 221),
(189, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, 381),
(190, 'SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 248),
(191, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 232),
(192, 'SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 65),
(193, 'SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 421),
(194, 'SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 386),
(195, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 677),
(196, 'SO', 'SOMALIA', 'Somalia', 'SOM', 706, 252),
(197, 'ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 27),
(198, 'GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL, 0),
(199, 'ES', 'SPAIN', 'Spain', 'ESP', 724, 34),
(200, 'LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 94),
(201, 'SD', 'SUDAN', 'Sudan', 'SDN', 736, 249),
(202, 'SR', 'SURINAME', 'Suriname', 'SUR', 740, 597),
(203, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744, 47),
(204, 'SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 268),
(205, 'SE', 'SWEDEN', 'Sweden', 'SWE', 752, 46),
(206, 'CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 41),
(207, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 963),
(208, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158, 886),
(209, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 992),
(210, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834, 255),
(211, 'TH', 'THAILAND', 'Thailand', 'THA', 764, 66),
(212, 'TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 670),
(213, 'TG', 'TOGO', 'Togo', 'TGO', 768, 228),
(214, 'TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 690),
(215, 'TO', 'TONGA', 'Tonga', 'TON', 776, 676),
(216, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780, 1868),
(217, 'TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 216),
(218, 'TR', 'TURKEY', 'Turkey', 'TUR', 792, 90),
(219, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 7370),
(220, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796, 1649),
(221, 'TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 688),
(222, 'UG', 'UGANDA', 'Uganda', 'UGA', 800, 256),
(223, 'UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 380),
(224, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 971),
(225, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 44),
(226, 'US', 'UNITED STATES', 'United States', 'USA', 840, 1),
(227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, 1),
(228, 'UY', 'URUGUAY', 'Uruguay', 'URY', 858, 598),
(229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 998),
(230, 'VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 678),
(231, 'VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 58),
(232, 'VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 84),
(233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92, 1284),
(234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850, 1340),
(235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876, 681),
(236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 212),
(237, 'YE', 'YEMEN', 'Yemen', 'YEM', 887, 967),
(238, 'ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 260),
(239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 263);

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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(8) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `symbol` varchar(30) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `buying` varchar(8) DEFAULT NULL,
  `selling` varchar(8) DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `default_currency` int(1) DEFAULT NULL,
  `date_modified` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `currency_archive`
--

CREATE TABLE `currency_archive` (
  `id` int(8) NOT NULL,
  `company_id` varchar(255) DEFAULT NULL,
  `date_modified` varchar(255) DEFAULT NULL,
  `currencies_updated` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `customer_group`
--

CREATE TABLE `customer_group` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_bin NOT NULL,
  `company_id` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `customer_reminders`
--

CREATE TABLE `customer_reminders` (
  `id` int(12) NOT NULL,
  `customer_id` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `from` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `message` text,
  `to` varchar(255) DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `date_created` varchar(255) NOT NULL,
  `notification_date` varchar(255) DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `attempt_run` varchar(30) DEFAULT NULL,
  `date_pushed` varchar(30) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `customer_source`
--

CREATE TABLE `customer_source` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `code` varchar(255) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `customer_updates`
--

CREATE TABLE `customer_updates` (
  `id` int(12) NOT NULL,
  `customer_id` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `moc_id` int(12) DEFAULT NULL,
  `poc_id` int(12) DEFAULT NULL,
  `soc_id` int(12) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `comment` text,
  `added_by` int(11) DEFAULT NULL,
  `date_added` varchar(255) NOT NULL,
  `time_added` varchar(100) DEFAULT NULL,
  `date_modified` varchar(255) DEFAULT NULL,
  `time_modified` varchar(100) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int(12) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `department_criterias`
--

CREATE TABLE `department_criterias` (
  `id` int(11) NOT NULL,
  `department_id` int(5) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `creteria` text,
  `deleted` int(1) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `region_id` int(5) NOT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` (`id`, `name`, `region_id`, `abbr`, `created`) VALUES
(1, 'Asunafo North Municipal', 1, 'ANM', '2020-05-23 20:53:08'),
(2, 'Asunafo South', 1, 'AS', '2020-05-23 20:53:08'),
(3, 'Asutifi North', 1, 'AN', '2020-05-23 20:53:08'),
(4, 'Asutifi South', 1, 'AFS', '2020-05-23 20:53:08'),
(5, 'Tano North Municipal', 1, 'TNM', '2020-05-23 20:53:08'),
(6, 'Tano South Municipal', 1, 'TSM', '2020-05-23 20:53:08'),
(7, 'Adansi Asokwa', 2, 'ADS', '2020-05-23 20:53:08'),
(8, 'Adansi North', 2, 'ADN', '2020-05-23 20:53:08'),
(9, 'Adansi South', 2, 'AST', '2020-05-23 20:53:08'),
(10, 'Afigya Kwabre South', 2, 'AKS', '2020-05-23 20:53:08'),
(11, 'Afigya Kwabre North', 2, 'AKN', '2020-05-23 20:53:08'),
(12, 'Ahafo Ano North Municipal', 2, 'ANM', '2020-05-23 20:53:08'),
(13, 'Ahafo Ano South West', 2, 'ASW', '2020-05-23 20:53:08'),
(14, 'Ahafo Ano South East', 2, 'ASE', '2020-05-23 20:53:08'),
(15, 'Akrofuom District', 2, 'AFD', '2020-05-23 20:53:08'),
(16, 'Amansie Central', 2, 'AMC', '2020-05-23 20:53:08'),
(17, 'Amansie South', 2, 'AMS', '2020-05-23 20:53:08'),
(18, 'Amansie West', 2, 'AMW', '2020-05-23 20:53:08'),
(19, 'Asante Akim Central Municipal', 2, 'AACM', '2020-05-23 20:53:08'),
(20, 'Asante Akim North', 2, 'AAN', '2020-05-23 20:53:08'),
(21, 'Asante Akim South Municipal', 2, 'AASM', '2020-05-23 20:53:08'),
(22, 'Asokore Mampong Municipal', 2, 'AMM', '2020-05-23 20:53:08'),
(23, 'Asokwa Municipal', 2, 'ASM', '2020-05-23 20:53:08'),
(24, 'Atwima Kwanwoma', 2, 'ATK', '2020-05-23 20:53:08'),
(25, 'Atwima Mponua', 2, 'ATM', '2020-05-23 20:53:08'),
(26, 'Atwima Nwabiagya North Municipal', 2, 'ANNM', '2020-05-23 20:53:08'),
(27, 'Atwima Nwabiagya South', 2, 'ANS', '2020-05-23 20:53:08'),
(28, 'Bekwai Municipal', 2, 'BKM', '2020-05-23 20:53:08'),
(29, 'Bosome Freho', 2, 'BSF', '2020-05-23 20:53:08'),
(30, 'Bosomtwe', 2, 'BST', '2020-05-23 20:53:08'),
(31, 'Ejisu Municipal', 2, 'EJM', '2020-05-23 20:53:08'),
(32, 'Ejura-Sekyedumase', 2, 'ESD', '2020-05-23 20:53:08'),
(33, 'Juaben Municipal', 2, 'JBM', '2020-05-23 20:53:08'),
(34, 'Kumasi Metropolitan', 2, 'KSM', '2020-05-23 20:53:08'),
(35, 'Kwadaso Municipal', 2, 'KDM', '2020-05-23 20:53:08'),
(36, 'Kwabre East Municipal', 2, 'KEM', '2020-05-23 20:53:08'),
(37, 'Mampong Municipal', 2, 'MPM', '2020-05-23 20:53:08'),
(38, 'Obuasi East', 2, 'OBE', '2020-05-23 20:53:08'),
(39, 'Obuasi Municipal', 2, 'OBM', '2020-05-23 20:53:08'),
(40, 'Offinso North', 2, 'OFN', '2020-05-23 20:53:08'),
(41, 'Offinso South Municipal', 2, 'OFSM', '2020-05-23 20:53:08'),
(42, 'Oforikrom Municipal', 2, 'OFM', '2020-05-23 20:53:08'),
(43, 'Old Tafo Municipal', 2, 'OTM', '2020-05-23 20:53:08'),
(44, 'Sekyere Afram Plains', 2, 'SAP', '2020-05-23 20:53:08'),
(45, 'Sekyere Central', 2, 'SYC', '2020-05-23 20:53:08'),
(46, 'Sekyere East', 2, 'SYE', '2020-05-23 20:53:08'),
(47, 'Sekyere Kumawu', 2, 'SYK', '2020-05-23 20:53:08'),
(48, 'Sekyere South', 2, 'SYS', '2020-05-23 20:53:08'),
(49, 'Suame Municipal', 2, 'SUM', '2020-05-23 20:53:08'),
(50, 'Banda', 3, 'BDA', '2020-05-23 20:53:08'),
(51, 'Berekum East Municipal', 3, 'BEM', '2020-05-23 20:53:08'),
(52, 'Berekum West', 3, 'BEW', '2020-05-23 20:53:08'),
(53, 'Dormaa Central Municipal', 3, 'DCM', '2020-05-23 20:53:08'),
(54, 'Dormaa East', 3, 'DME', '2020-05-23 20:53:08'),
(55, 'Dormaa West', 3, 'DMW', '2020-05-23 20:53:08'),
(56, 'Jaman North', 3, 'JAN', '2020-05-23 20:53:08'),
(57, 'Jaman South Municipal', 3, 'JAM', '2020-05-23 20:53:08'),
(58, 'Sunyani Municipal', 3, 'SYM', '2020-05-23 20:53:08'),
(59, 'Sunyani West', 3, 'SYW', '2020-05-23 20:53:08'),
(60, 'Tain', 3, 'TAI', '2020-05-23 20:53:08'),
(61, 'Wenchi Municipal', 3, 'WCM', '2020-05-23 20:53:08'),
(62, 'Atebubu-Amantin Municipal', 4, 'AAM', '2020-05-23 20:53:08'),
(63, 'Kintampo North Municipal', 4, 'KNM', '2020-05-23 20:53:08'),
(64, 'Kintampo South', 4, 'KTS', '2020-05-23 20:53:08'),
(65, 'Nkoranza North', 4, 'NKN', '2020-05-23 20:53:08'),
(66, 'Nkoranza South', 4, 'NKS', '2020-05-23 20:53:08'),
(67, 'Pru West', 4, 'PRW', '2020-05-23 20:53:08'),
(68, 'Pru East', 4, 'PRE', '2020-05-23 20:53:08'),
(69, 'Sene East', 4, 'SNE', '2020-05-23 20:53:08'),
(70, 'Sene West', 4, 'SNW', '2020-05-23 20:53:08'),
(71, 'Techiman Municipal', 4, 'THM', '2020-05-23 20:53:08'),
(72, 'Techiman North', 4, 'THN', '2020-05-23 20:53:08'),
(73, 'Abura-Asebu-Kwamankese', 5, 'AAK', '2020-05-23 20:53:08'),
(74, 'Agona East', 5, 'AGE', '2020-05-23 20:53:08'),
(75, 'Agona West Municipal', 5, 'AGWM', '2020-05-23 20:53:08'),
(76, 'Ajumako-Enyan-Essiam', 5, 'AEE', '2020-05-23 20:53:08'),
(77, 'Asikuma-Odoben-Brakwa', 5, 'AOB', '2020-05-23 20:53:08'),
(78, 'Assin Central Municipal', 5, 'ACM', '2020-05-23 20:53:08'),
(79, 'Assin North', 5, 'ASN', '2020-05-23 20:53:08'),
(80, 'Assin South', 5, 'ASS', '2020-05-23 20:53:08'),
(81, 'Awutu Senya East', 5, 'ASE', '2020-05-23 20:53:08'),
(82, 'Awutu Senya West', 5, 'ASW', '2020-05-23 20:53:08'),
(83, 'Cape Coast Metropolitan', 5, 'CCM', '2020-05-23 20:53:08'),
(84, 'Effutu Municipal', 5, 'EFM', '2020-05-23 20:53:08'),
(85, 'Ekumfi', 5, 'EFU', '2020-05-23 20:53:08'),
(86, 'Gomoa East', 5, 'GME', '2020-05-23 20:53:08'),
(87, 'Gomoa West', 5, 'GMW', '2020-05-23 20:53:08'),
(88, 'Komenda-Edina-Eguafo-Abirem Municipal', 5, 'KEAM', '2020-05-23 20:53:08'),
(89, 'Mfantseman Municipal', 5, 'MFM', '2020-05-23 20:53:08'),
(90, 'Twifo Atti Morkwa', 5, 'TAM', '2020-05-23 20:53:08'),
(91, 'Twifo Hemang Lower Denkyira', 5, 'THLD', '2020-05-23 20:53:08'),
(92, 'Upper Denkyira East Municipal', 5, 'UDEM', '2020-05-23 20:53:08'),
(93, 'Upper Denkyira West', 5, 'UDW', '2020-05-23 20:53:08'),
(94, 'Abuakwa North Municipal', 6, 'ANM', '2020-05-23 20:53:08'),
(95, 'Abuakwa South Municipal', 6, 'ASM', '2020-05-23 20:53:08'),
(96, 'Achiase District', 6, 'ACD', '2020-05-23 20:53:08'),
(97, 'Akuapim North Municipal', 6, 'ANM', '2020-05-23 20:53:08'),
(98, 'Akuapim South', 6, 'AKS', '2020-05-23 20:53:08'),
(99, 'Akyemansa', 6, 'AKY', '2020-05-23 20:53:08'),
(100, 'Asene Manso Akroso', 6, 'AMA', '2020-05-23 20:53:08'),
(101, 'Asuogyaman', 6, 'ASM', '2020-05-23 20:53:08'),
(102, 'Atiwa West', 6, 'ATW', '2020-05-23 20:53:08'),
(103, 'Atiwa East', 6, 'ATE', '2020-05-23 20:53:08'),
(104, 'Ayensuano', 6, 'AYS', '2020-05-23 20:53:08'),
(105, 'Birim Central Municipal', 6, 'BCM', '2020-05-23 20:53:08'),
(106, 'Birim North', 6, 'BIN', '2020-05-23 20:53:08'),
(107, 'Birim South', 6, 'BIS', '2020-05-23 20:53:08'),
(108, 'Denkyembour', 6, 'DKB', '2020-05-23 20:53:08'),
(109, 'Fanteakwa North', 6, 'FTN', '2020-05-23 20:53:08'),
(110, 'Fanteakwa South', 6, 'FTS', '2020-05-23 20:53:08'),
(111, 'Kwaebibirem Municipal', 6, 'KBM', '2020-05-23 20:53:08'),
(112, 'Kwahu Afram Plains North', 6, 'KAPN', '2020-05-23 20:53:08'),
(113, 'Kwahu Afram Plains South ', 6, 'KAPS', '2020-05-23 20:53:08'),
(114, 'Kwahu East', 6, 'KWE', '2020-05-23 20:53:08'),
(115, 'Kwahu South', 6, 'KWS', '2020-05-23 20:53:08'),
(116, 'Kwahu West Municipal', 6, 'KWM', '2020-05-23 20:53:08'),
(117, 'Lower Manya Krobo', 6, 'LMK', '2020-05-23 20:53:08'),
(118, 'New Juaben South Municipal', 6, 'NJSM', '2020-05-23 20:53:08'),
(119, 'New Juaben North Municipal', 6, 'NJNM', '2020-05-23 20:53:08'),
(120, 'Nsawam Adoagyiri Municipal', 6, 'NAM', '2020-05-23 20:53:08'),
(121, 'Okere', 6, 'OKE', '2020-05-23 20:53:08'),
(122, 'Suhum', 6, 'SUH', '2020-05-23 20:53:08'),
(123, 'Upper Manya Krobo', 6, 'UMK', '2020-05-23 20:53:08'),
(124, 'Upper West Akim', 6, 'UWA', '2020-05-23 20:53:08'),
(125, 'West Akim Municipal', 6, 'WAM', '2020-05-23 20:53:08'),
(126, 'Yilo Krobo Municipal', 6, 'YKM', '2020-05-23 20:53:08'),
(127, 'Ablekuma Central Municipal', 7, 'ACM', '2020-05-23 20:53:08'),
(128, 'Ablekuma North Municipal', 7, 'ANM', '2020-05-23 20:53:08'),
(129, 'Ablekuma West Municipal', 7, 'AWM', '2020-05-23 20:53:08'),
(130, 'Accra Metropolitan', 7, 'ACM', '2020-05-23 20:53:08'),
(131, 'Ada East', 7, 'ADE', '2020-05-23 20:53:08'),
(132, 'Ada West', 7, 'ADW', '2020-05-23 20:53:08'),
(133, 'Adentan Municipal', 7, 'ADM', '2020-05-23 20:53:08'),
(134, 'Ashaiman Municipal', 7, 'ASH', '2020-05-23 20:53:08'),
(135, 'Ayawaso Central Municipal District', 7, 'ACMD', '2020-05-23 20:53:08'),
(136, 'Ayawaso East Municipal', 7, 'AEM', '2020-05-23 20:53:08'),
(137, 'Ayawaso North Municipal', 7, 'ANM', '2020-05-23 20:53:08'),
(138, 'Ayawaso West Municipal', 7, 'AWM', '2020-05-23 20:53:08'),
(139, 'Ga East Municipal', 7, 'GAM', '2020-05-23 20:53:08'),
(140, 'Ga Central', 7, 'GAC', '2020-05-23 20:53:08'),
(141, 'Ga North Municipal', 7, 'GAN', '2020-05-23 20:53:08'),
(142, 'Ga South Municipal', 7, 'GAS', '2020-05-23 20:53:08'),
(143, 'Ga West Municipal', 7, 'GAW', '2020-05-23 20:53:08'),
(144, 'Korle Klottey Municipal District', 7, 'KKMD', '2020-05-23 20:53:08'),
(145, 'Kpone Katamanso Municipal', 7, 'KKM', '2020-05-23 20:53:08'),
(146, 'Krowor Municipal', 7, 'KRM', '2020-05-23 20:53:08'),
(147, 'La-Dade-Kotopon Municipal', 7, 'LADK', '2020-05-23 20:53:08'),
(148, 'La-Nkwantanang-Madina', 7, 'LANM', '2020-05-23 20:53:08'),
(149, 'Ledzokuku Municipal', 7, 'LEDM', '2020-05-23 20:53:08'),
(150, 'Ningo-Prampram', 7, 'NIP', '2020-05-23 20:53:08'),
(151, 'Okaikwei North Municipal', 7, 'OKNM', '2020-05-23 20:53:08'),
(152, 'Shai-Osudoku District  ', 7, 'SHOD', '2020-05-23 20:53:08'),
(153, 'Tema Metropolitan', 7, 'TEMA', '2020-05-23 20:53:08'),
(154, 'Tema West Municipal', 7, 'TMAW', '2020-05-23 20:53:08'),
(155, 'Weija Gbawe Municipal', 7, 'WGM', '2020-05-23 20:53:08'),
(156, 'Bunkpurugu Nakpanduri', 8, 'BUN', '2020-05-23 20:53:08'),
(157, 'Chereponi', 8, 'CHP', '2020-05-23 20:53:08'),
(158, 'East Mamprusi Municipal', 8, 'EMM', '2020-05-23 20:53:08'),
(159, 'Mamprugo Moagduri', 8, 'MAGO', '2020-05-23 20:53:08'),
(160, 'West Mamprusi Municipal', 8, 'WMM', '2020-05-23 20:53:08'),
(161, 'Yendi Municipal', 8, 'YDM', '2020-05-23 20:53:08'),
(162, 'Yunyoo-Nasuan', 8, 'YUN', '2020-05-23 20:53:08'),
(163, 'Gushegu Municipal', 9, 'GUM', '2020-05-23 20:53:08'),
(164, 'Karaga', 9, 'KGA', '2020-05-23 20:53:08'),
(165, 'Kpandai', 9, 'KPA', '2020-05-23 20:53:08'),
(166, 'Kumbungu', 9, 'KUM', '2020-05-23 20:53:08'),
(167, 'Mion', 9, 'MION', '2020-05-23 20:53:08'),
(168, 'Nanton', 9, 'NAN', '2020-05-23 20:53:08'),
(169, 'Nanumba North Municipal', 9, 'NNM', '2020-05-23 20:53:08'),
(170, 'Nanumba South', 9, 'NNS', '2020-05-23 20:53:08'),
(171, 'Saboba', 9, 'SABO', '2020-05-23 20:53:08'),
(172, 'Sagnarigu Municipal', 9, 'SAM', '2020-05-23 20:53:08'),
(173, 'Savelugu Municipal', 9, 'SAVE', '2020-05-23 20:53:08'),
(174, 'Tamale Metropolitan', 9, 'TAM', '2020-05-23 20:53:08'),
(175, 'Tatale-Sangule', 9, 'TAS', '2020-05-23 20:53:08'),
(176, 'Tolon', 9, 'TOL', '2020-05-23 20:53:08'),
(177, 'Yendi Municipal', 9, 'YENM', '2020-05-23 20:53:08'),
(178, 'Zabzugu', 9, 'ZAB', '2020-05-23 20:53:08'),
(179, 'Biakoye', 10, 'BIA', '2020-05-23 20:53:08'),
(180, 'Jasikan', 10, 'JAS', '2020-05-23 20:53:08'),
(181, 'Kadjebi', 10, 'KAD', '2020-05-23 20:53:08'),
(182, 'Krachi East Municipal', 10, 'KEM', '2020-05-23 20:53:08'),
(183, 'Krachi Nchumuru ', 10, 'KRN', '2020-05-23 20:53:08'),
(184, 'Krachi West', 10, 'KRW', '2020-05-23 20:53:08'),
(185, 'Nkwanta North', 10, 'NKN', '2020-05-23 20:53:08'),
(186, 'Nkwanta South Municipal', 10, 'NSM', '2020-05-23 20:53:08'),
(187, 'Bole', 11, 'BOLE', '2020-05-23 20:53:08'),
(188, 'Central Gonja', 11, 'CTG', '2020-05-23 20:53:08'),
(189, 'East Gonja Municipal', 11, 'EGM', '2020-05-23 20:53:08'),
(190, 'North East Gonja', 11, 'NEG', '2020-05-23 20:53:08'),
(191, 'North Gonja', 11, 'NOG', '2020-05-23 20:53:08'),
(192, 'Sawla-Tuna-Kalba', 11, 'STK', '2020-05-23 20:53:08'),
(193, 'West Gonja', 11, 'WTG', '2020-05-23 20:53:08'),
(194, 'Bawku Municipal', 12, 'BAM', '2020-05-23 20:53:08'),
(195, 'Bawku West', 12, 'BAW', '2020-05-23 20:53:08'),
(196, 'Binduri', 12, 'BIN', '2020-05-23 20:53:08'),
(197, 'Bolgatanga East', 12, 'BGAE', '2020-05-23 20:53:08'),
(198, 'Bolgatanga Municipal', 12, 'BGAM', '2020-05-23 20:53:08'),
(199, 'Bongo', 12, 'BON', '2020-05-23 20:53:08'),
(200, 'Builsa North', 12, 'BUN', '2020-05-23 20:53:08'),
(201, 'Builsa South', 12, 'BUS', '2020-05-23 20:53:08'),
(202, 'Garu', 12, 'GAR', '2020-05-23 20:53:08'),
(203, 'Kassena Nankana East', 12, 'KNE', '2020-05-23 20:53:08'),
(204, 'Kassena Nankana West', 12, 'KNW', '2020-05-23 20:53:08'),
(205, 'Nabdam', 12, 'NAB', '2020-05-23 20:53:08'),
(206, 'Pusiga', 12, 'PUG', '2020-05-23 20:53:08'),
(207, 'Talensi', 12, 'TAL', '2020-05-23 20:53:08'),
(208, 'Tempane', 12, 'TEM', '2020-05-23 20:53:08'),
(209, 'Daffiama Bussie Issa', 13, 'DBI', '2020-05-23 20:53:08'),
(210, 'Jirapa Municipal', 13, 'JPM', '2020-05-23 20:53:08'),
(211, 'Lambussie Karni', 13, 'LAK', '2020-05-23 20:53:08'),
(212, 'Lawra Municipal', 13, 'LAM', '2020-05-23 20:53:08'),
(213, 'Nadowli-Kaleo', 13, 'NAK', '2020-05-23 20:53:08'),
(214, 'Nandom', 13, 'NAN', '2020-05-23 20:53:08'),
(215, 'Sissala East Municipal', 13, 'SIM', '2020-05-23 20:53:08'),
(216, 'Sissala West', 13, 'SIW', '2020-05-23 20:53:08'),
(217, 'Wa East', 13, 'WAE', '2020-05-23 20:53:08'),
(218, 'Wa Municipal', 13, 'WAM', '2020-05-23 20:53:08'),
(219, 'Wa West', 13, 'WAW', '2020-05-23 20:53:08'),
(220, 'Adaklu', 14, 'ADA', '2020-05-23 20:53:08'),
(221, 'Afadzato South', 14, 'AFS', '2020-05-23 20:53:08'),
(222, 'Agotime Ziope', 14, 'AGZ', '2020-05-23 20:53:08'),
(223, 'Akatsi South', 14, 'AKS', '2020-05-23 20:53:08'),
(224, 'Akatsi North', 14, 'AKN', '2020-05-23 20:53:08'),
(225, 'Anloga', 14, 'ANLO', '2020-05-23 20:53:08'),
(226, 'Central Tongu', 14, 'CENT', '2020-05-23 20:53:08'),
(227, 'Ho Municipal', 14, 'HOM', '2020-05-23 20:53:08'),
(228, 'Ho West', 14, 'HOW', '2020-05-23 20:53:08'),
(229, 'Hohoe Municipal', 14, 'HOEM', '2020-05-23 20:53:08'),
(230, 'Keta Municipal', 14, 'KTM', '2020-05-23 20:53:08'),
(231, 'Ketu North Municipal', 14, 'KNM', '2020-05-23 20:53:08'),
(232, 'Ketu South Municipal', 14, 'KSM', '2020-05-23 20:53:08'),
(233, 'Kpando Municipal', 14, 'KPM', '2020-05-23 20:53:08'),
(234, 'North Dayi', 14, 'NOD', '2020-05-23 20:53:08'),
(235, 'North Tongu', 14, 'NOT', '2020-05-23 20:53:08'),
(236, 'South Dayi', 14, 'SOD', '2020-05-23 20:53:08'),
(237, 'South Tongu', 14, 'SOT', '2020-05-23 20:53:08'),
(238, 'Ahanta West Municipal', 15, 'AWM', '2020-05-23 20:53:08'),
(239, 'Effia Kwesimintsim Municipal', 15, 'EKM', '2020-05-23 20:53:08'),
(240, 'Ellembele', 15, 'ELLEM', '2020-05-23 20:53:08'),
(241, 'Jomoro Municipal', 15, 'JOM', '2020-05-23 20:53:08'),
(242, 'Mpohor ', 15, 'MPO', '2020-05-23 20:53:08'),
(243, 'Nzema East Municipal', 15, 'NEM', '2020-05-23 20:53:08'),
(244, 'Prestea-Huni Valley Municipal', 15, 'PHVM', '2020-05-23 20:53:08'),
(245, 'Sekondi Takoradi Metropolitan', 15, 'STM', '2020-05-23 20:53:08'),
(246, 'Shama', 15, 'SHA', '2020-05-23 20:53:08'),
(247, 'Tarkwa Nsuaem Municipal', 15, 'TNM', '2020-05-23 20:53:08'),
(248, 'Wassa Amenfi Central', 15, 'WAC', '2020-05-23 20:53:08'),
(249, 'Wassa Amenfi East Municipal', 15, 'WAEM', '2020-05-23 20:53:08'),
(250, 'Wassa Amenfi West Municipal', 15, 'WAWM', '2020-05-23 20:53:08'),
(251, 'Wassa East', 15, 'WASE', '2020-05-23 20:53:08'),
(252, 'Aowin Municipal', 16, 'AOM', '2020-05-23 20:53:08'),
(253, 'Bia East', 16, 'BIE', '2020-05-23 20:53:08'),
(254, 'Bia West', 16, 'BIW', '2020-05-23 20:53:08'),
(255, 'Bibiani-Anhwiaso-Bekwai Municipal', 16, 'BABM', '2020-05-23 20:53:08'),
(256, 'Bodi', 16, 'BODI', '2020-05-23 20:53:08'),
(257, 'Juaboso', 16, 'JUB', '2020-05-23 20:53:08'),
(258, 'Sefwi Akontombra', 16, 'SFA', '2020-05-23 20:53:08'),
(259, 'Sefwi Wiawso', 16, 'SFW', '2020-05-23 20:53:08'),
(260, 'Suaman', 16, NULL, '2020-05-23 20:53:08');

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

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `permissions` text COLLATE utf8_unicode_ci,
  `user_id` int(11) DEFAULT NULL,
  `doc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `doc_size` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `doc_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `deleted` int(1) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `document_categories`
--

CREATE TABLE `document_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(11) NOT NULL,
  `module` int(11) DEFAULT NULL,
  `module_cat` int(11) DEFAULT NULL,
  `question` text,
  `answer` text,
  `counter` int(11) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fleets`
--

CREATE TABLE `fleets` (
  `id` int(11) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `year_of_make` year(4) DEFAULT NULL,
  `year_of_purchase` year(4) DEFAULT NULL,
  `seats` int(2) DEFAULT NULL,
  `reg_number` varchar(100) DEFAULT NULL,
  `branch_assign` int(11) DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `company_id` int(10) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `road_worthy` varchar(50) DEFAULT NULL,
  `insurance` varchar(50) DEFAULT NULL,
  `licence_expiry_date` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fleet_comments`
--

CREATE TABLE `fleet_comments` (
  `id` int(11) NOT NULL,
  `request_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fleet_drivers`
--

CREATE TABLE `fleet_drivers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `driver_licence` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fleet_requests`
--

CREATE TABLE `fleet_requests` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `fleet_type` varchar(255) DEFAULT NULL,
  `fleet_model` varchar(255) DEFAULT NULL,
  `fleet_driver` int(11) DEFAULT NULL,
  `pickup_date` date DEFAULT NULL,
  `pickup_time` time DEFAULT NULL,
  `dropoff_date` date DEFAULT NULL,
  `dropoff_time` time DEFAULT NULL,
  `no_passengers` int(2) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `branch_id` int(11) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `supervisor_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `form_requisition_limits`
--

CREATE TABLE `form_requisition_limits` (
  `id` int(2) NOT NULL,
  `code` varchar(50) DEFAULT NULL,
  `limit` double DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `frontdesk`
--

CREATE TABLE `frontdesk` (
  `id` int(11) NOT NULL,
  `visitor_name` varchar(255) DEFAULT NULL,
  `customer` varchar(10) DEFAULT NULL,
  `appointment` varchar(10) DEFAULT NULL,
  `staff` int(11) DEFAULT NULL,
  `department` int(11) DEFAULT NULL,
  `checkin_time` time DEFAULT NULL,
  `time_attended` time DEFAULT NULL,
  `waiting_period` time DEFAULT NULL,
  `staff_attended` varchar(10) DEFAULT NULL,
  `new_appointment_date` date DEFAULT NULL,
  `new_appointment_time` time DEFAULT NULL,
  `tag_no` varchar(255) DEFAULT NULL,
  `tag_returned` varchar(10) DEFAULT NULL,
  `visitor_accompanied` varchar(10) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `reason_for_staff_absent` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gallery_categories`
--

CREATE TABLE `gallery_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `content` text,
  `image` varchar(255) DEFAULT NULL,
  `image_caption` varchar(50) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `dept_id` int(11) DEFAULT NULL,
  `related_project` int(11) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_modified` varchar(20) DEFAULT NULL,
  `status` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gallery_listings`
--

CREATE TABLE `gallery_listings` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `image_caption` varchar(50) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dept_id` int(11) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `tags` text,
  `company_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `header_banners`
--

CREATE TABLE `header_banners` (
  `id` int(11) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image_description` text,
  `image_thumbnail` varchar(80) NOT NULL,
  `thumbnail_description` varchar(100) DEFAULT NULL,
  `image_caption` varchar(50) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) DEFAULT '0',
  `position` int(8) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `header_banners`
--

INSERT INTO `header_banners` (`id`, `company_id`, `link`, `image`, `image_description`, `image_thumbnail`, `thumbnail_description`, `image_caption`, `date`, `status`, `position`) VALUES
(7, 42, NULL, 'headers/5ee3/202f/5ee3202f4750407f8d1741d4c0b934b8.jpeg', NULL, 'headers/5ee3/202f/5ee3202f4750407f8d1741d4c0b934b8_thumbnail.jpeg', NULL, '', '2020-06-12 06:26:55', 1, 0),
(6, 43, NULL, 'headers/5ee0/cabc/5ee0cabc188c4c4f8792ca59c0b934b8.jpg', NULL, 'headers/5ee0/cabc/5ee0cabc188c4c4f8792ca59c0b934b8_thumbnail.jpg', NULL, '', '2020-06-10 11:57:48', 1, 0);

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

--
-- Table structure for table `helpdesk_actionlog`
--

CREATE TABLE `helpdesk_actionlog` (
  `act_id` int(11) NOT NULL,
  `act_action` text COLLATE latin1_general_ci,
  `act_date` date DEFAULT NULL,
  `act_time` time DEFAULT NULL,
  `act_user` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `comapny_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Logs all important actions' ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `helpdesk_comments`
--

CREATE TABLE `helpdesk_comments` (
  `id` int(12) NOT NULL,
  `job_id` int(12) DEFAULT NULL,
  `job_serial` int(12) DEFAULT NULL,
  `description` text,
  `name` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `picture` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `com_email` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `helpdesk_jobpriority`
--

CREATE TABLE `helpdesk_jobpriority` (
  `pri_id` int(11) NOT NULL,
  `pri_name` varchar(50) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Job priorities/importance' ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `helpdesk_jobs`
--

CREATE TABLE `helpdesk_jobs` (
  `job_id` int(11) NOT NULL,
  `job_serial` varchar(7) DEFAULT NULL,
  `job_branch` int(11) NOT NULL DEFAULT '0',
  `department` int(8) DEFAULT NULL,
  `job_type` int(11) DEFAULT '0',
  `time_limit` varchar(100) DEFAULT NULL,
  `job_priority` int(11) DEFAULT '0',
  `job_loggedby_id` int(11) DEFAULT NULL,
  `job_loggedby` varchar(50) DEFAULT NULL,
  `job_logdate` varchar(20) DEFAULT NULL,
  `job_logtime` time DEFAULT NULL,
  `job_brief` varchar(255) DEFAULT NULL,
  `job_description` longtext,
  `job_error` text,
  `job_otherinfo` text,
  `job_resolution` text,
  `job_verifiedby` int(11) DEFAULT '0',
  `job_dateverified` varchar(20) DEFAULT NULL,
  `job_zone` int(11) DEFAULT '0',
  `job_dateassigned` varchar(20) DEFAULT NULL,
  `job_resolvedby` varchar(255) DEFAULT '0',
  `job_dateresolved` varchar(20) DEFAULT NULL,
  `job_closedby` int(11) DEFAULT '0',
  `job_dateclosed` varchar(20) DEFAULT NULL,
  `job_loggerpc` varchar(50) DEFAULT NULL,
  `job_loggerphone` varchar(50) DEFAULT NULL,
  `job_loggeremail` varchar(100) DEFAULT NULL,
  `completion_date` varchar(255) DEFAULT NULL,
  `created_resolved_duration` varchar(255) DEFAULT NULL,
  `resolved_closed_duration` varchar(255) DEFAULT NULL,
  `created_closed_duration` varchar(255) DEFAULT NULL,
  `job_status` int(11) DEFAULT '1',
  `file` varchar(255) DEFAULT NULL,
  `document` varchar(255) DEFAULT NULL,
  `ip_address` varchar(150) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  `no_resend` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Logged jobs' ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `helpdesk_jobstatus`
--

CREATE TABLE `helpdesk_jobstatus` (
  `sta_id` int(11) NOT NULL,
  `sta_name` varchar(50) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Job status/progress' ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `helpdesk_jobtype`
--

CREATE TABLE `helpdesk_jobtype` (
  `typ_id` int(11) NOT NULL,
  `responsible_person` int(8) DEFAULT NULL,
  `typ_name` varchar(50) DEFAULT NULL,
  `typ_department` tinyint(4) NOT NULL DEFAULT '0',
  `group_id` int(11) DEFAULT '0',
  `company_id` int(11) DEFAULT NULL,
  `time_limit` time DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Types of jobs' ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `helpdesk_resolutions`
--

CREATE TABLE `helpdesk_resolutions` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `resolution` text,
  `user_id` int(11) DEFAULT NULL,
  `commentor_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `helpdesk_units`
--

CREATE TABLE `helpdesk_units` (
  `uni_id` int(11) NOT NULL,
  `uni_name` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `uni_jobtype` int(11) NOT NULL DEFAULT '0',
  `company_id` int(11) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `helpdesk_zones`
--

CREATE TABLE `helpdesk_zones` (
  `zon_id` int(11) NOT NULL,
  `zon_name` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `hrms_allowances_deductions`
--

CREATE TABLE `hrms_allowances_deductions` (
  `id` int(8) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `code` varchar(8) DEFAULT NULL,
  `staff_id` varchar(50) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `momo_number` varchar(20) DEFAULT NULL,
  `amount` int(8) DEFAULT NULL,
  `date_initiated` varchar(50) DEFAULT NULL,
  `date_paid` varchar(50) DEFAULT NULL,
  `institution_id` int(8) DEFAULT NULL,
  `district_id` int(4) DEFAULT NULL,
  `region_id` int(3) DEFAULT NULL,
  `line_manager` int(8) DEFAULT NULL,
  `status` int(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hrms_allowances_deductions`
--

INSERT INTO `hrms_allowances_deductions` (`id`, `company_id`, `code`, `staff_id`, `fullname`, `momo_number`, `amount`, `date_initiated`, `date_paid`, `institution_id`, `district_id`, `region_id`, `line_manager`, `status`) VALUES
(1, 42, '012020', 'AHANM3727', 'Karl  Forson', '233209283286', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(2, 42, '012020', 'AHANM3728', 'Henry Amo Mensah', '233244762430', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(3, 42, '012020', 'AHANM3729', 'Caleb  Brown', '2332082782828', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(4, 42, '012020', 'AHANM3730', 'Seth  Aryee', '233244827388', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(5, 42, '012020', 'AHANM3731', 'Mabel  Yawson', '233289182919', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(6, 42, '012020', 'VTADA44732', 'Moud  Yeboah', '233277372829', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(7, 42, '012020', 'VTADA44733', 'Rebecca  Asare', '23354492829', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(8, 42, '012020', 'VTADA44734', 'Joanita  Adum', '233268278118', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(9, 42, '012020', 'WNAOM56721', 'Nii  Ankrah', '233209283288', 450, '2020-06-18', NULL, 44, 260, 16, NULL, 0),
(10, 42, '022020', 'AHANM3727', 'Karl  Forson', '233209283286', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(11, 42, '022020', 'AHANM3728', 'Henry Amo Mensah', '233244762430', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(12, 42, '022020', 'AHANM3729', 'Caleb  Brown', '2332082782828', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(13, 42, '022020', 'AHANM3730', 'Seth  Aryee', '233244827388', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(14, 42, '022020', 'AHANM3731', 'Mabel  Yawson', '233289182919', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(15, 42, '022020', 'VTADA44732', 'Moud  Yeboah', '233277372829', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(16, 42, '022020', 'VTADA44733', 'Rebecca  Asare', '23354492829', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(17, 42, '022020', 'VTADA44734', 'Joanita  Adum', '233268278118', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(18, 42, '022020', 'WNAOM56721', 'Nii  Ankrah', '233209283288', 450, '2020-06-18', NULL, 44, 260, 16, NULL, 0),
(19, 42, '032020', 'AHANM3727', 'Karl  Forson', '233209283286', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(20, 42, '032020', 'AHANM3728', 'Henry Amo Mensah', '233244762430', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(21, 42, '032020', 'AHANM3729', 'Caleb  Brown', '2332082782828', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(22, 42, '032020', 'AHANM3730', 'Seth  Aryee', '233244827388', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(23, 42, '032020', 'AHANM3731', 'Mabel  Yawson', '233289182919', 450, '2020-06-18', NULL, 3, 1, 1, NULL, 0),
(24, 42, '032020', 'VTADA44732', 'Moud  Yeboah', '233277372829', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(25, 42, '032020', 'VTADA44733', 'Rebecca  Asare', '23354492829', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(26, 42, '032020', 'VTADA44734', 'Joanita  Adum', '233268278118', 450, '2020-06-18', NULL, 44, 220, 14, NULL, 0),
(27, 42, '032020', 'WNAOM56721', 'Nii  Ankrah', '233209283288', 450, '2020-06-18', NULL, 44, 260, 16, NULL, 0),
(39, 42, '042020', 'AHANM3727', 'Karl  Forson', '233209283286', 450, '2020-06-19', NULL, 3, 1, 1, NULL, 0),
(40, 42, '042020', 'AHANM3728', 'Henry Amo Mensah', '233244762430', 450, '2020-06-19', NULL, 3, 1, 1, NULL, 0),
(41, 42, '042020', 'AHANM3729', 'Caleb  Brown', '2332082782828', 450, '2020-06-19', NULL, 3, 1, 1, NULL, 0),
(42, 42, '042020', 'AHANM3730', 'Seth  Aryee', '233244827388', 450, '2020-06-19', NULL, 3, 1, 1, NULL, 0),
(43, 42, '042020', 'VTADA55736', 'Ahmid  Adams', '23328328877', 450, '2020-06-19', NULL, 55, 140, 7, NULL, 0),
(44, 42, '042020', 'VTADA44735', 'Ahmid  Adams', '23328328877', 450, '2020-06-19', NULL, 44, 140, 7, NULL, 0),
(45, 42, '042020', 'AHANM3731', 'Mabel  Yawson', '233289182919', 450, '2020-06-19', NULL, 3, 1, 1, NULL, 0),
(46, 42, '042020', 'VTADA44732', 'Moud  Yeboah', '233277372829', 450, '2020-06-19', NULL, 44, 220, 14, NULL, 0),
(47, 42, '042020', 'VTADA44733', 'Rebecca  Asare', '23354492829', 450, '2020-06-19', NULL, 44, 220, 14, NULL, 0),
(48, 42, '042020', 'VTADA44734', 'Joanita  Adum', '233268278118', 450, '2020-06-19', NULL, 44, 220, 14, NULL, 0),
(49, 42, '042020', 'WNAOM56721', 'Nii  Ankrah', '233209283288', 450, '2020-06-19', NULL, 44, 260, 16, NULL, 0);

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

--
-- Table structure for table `hrms_monthly_payroll`
--

CREATE TABLE `hrms_monthly_payroll` (
  `id` int(8) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `code` varchar(6) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `payment_date` varchar(30) DEFAULT NULL,
  `date_initiated` varchar(30) DEFAULT NULL,
  `initiated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hrms_monthly_payroll`
--

INSERT INTO `hrms_monthly_payroll` (`id`, `company_id`, `code`, `title`, `payment_date`, `date_initiated`, `initiated_by`) VALUES
(1, 42, '012020', 'January 2020 Salary Payment', '27-01-2020', '2020-06-18', '725'),
(2, 42, '022020', 'February 2020 Salary Payment', '27-02-2020', '2020-06-18', '725'),
(3, 42, '032020', 'March 2020 Salary Payment', '27-03-2020', '2020-06-18', '725'),
(5, 42, '042020', 'April Salary 2020', '27-04-2020', '2020-06-19', '725');

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

--
-- Table structure for table `ics_survey_configs`
--

CREATE TABLE `ics_survey_configs` (
  `id` int(11) NOT NULL,
  `branch_rate` int(1) DEFAULT '0',
  `department_rate` int(1) DEFAULT '0',
  `branch_rate_another` int(1) DEFAULT '0',
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ics_survey_data`
--

CREATE TABLE `ics_survey_data` (
  `id` int(8) NOT NULL,
  `com_pick_calls` int(2) DEFAULT '0',
  `com_listen_eff` int(2) DEFAULT '0',
  `com_com_eff` int(2) DEFAULT '0',
  `prod_handles_req_eff` int(2) DEFAULT '0',
  `prod_team_work` int(2) DEFAULT '0',
  `prod_attend_issue` int(2) DEFAULT '0',
  `prod_team_organized` int(2) DEFAULT '0',
  `res_ref_promptly` int(2) DEFAULT '0',
  `res_full_responsibility` int(2) DEFAULT '0',
  `res_seek_clarification` int(2) DEFAULT '0',
  `cs_courteous_polite` int(2) DEFAULT '0',
  `cs_feel_valued` int(2) DEFAULT '0',
  `cs_me_expectation` int(2) DEFAULT '0',
  `cs_good_under_cs` int(2) DEFAULT '0',
  `user_id` int(8) DEFAULT NULL,
  `usergroup_id` int(8) DEFAULT NULL,
  `dept_id` int(8) DEFAULT NULL,
  `branch_id` int(8) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `rated_dept_id` int(8) DEFAULT NULL,
  `rated_branch_id` int(8) DEFAULT NULL,
  `branch_comment` text,
  `dept_comment` text,
  `type_id` int(8) DEFAULT NULL,
  `depts_comment` text,
  `company_id` int(8) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ics_survey_instructions`
--

CREATE TABLE `ics_survey_instructions` (
  `id` int(8) NOT NULL,
  `instructions` text,
  `company_id` int(8) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `institutions`
--

CREATE TABLE `institutions` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `region_id` int(11) DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `town` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `community` varchar(255) DEFAULT NULL,
  `number_of_staff` int(5) DEFAULT NULL,
  `number_of_students` int(5) DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modifed` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `institutions`
--

INSERT INTO `institutions` (`id`, `name`, `region_id`, `district_id`, `town`, `street`, `community`, `number_of_staff`, `number_of_students`, `company_id`, `created`, `modifed`) VALUES
(2, 'Zenith University ', 7, 130, 'La', 'labadi', 'Cado', 20, 100, 41, '2020-05-24 13:17:29', NULL),
(3, 'Nima 1 & 2', 7, 135, 'Nima', 'Street', 'Nima', 24, 100, 42, '2020-05-31 14:36:49', NULL),
(4, 'Kotoka basic shool', 7, 147, 'La', 'Te', 'Burma camp', 20, 300, 36, '2020-05-31 19:55:31', NULL),
(5, 'Falahiya Islamic School', 13, 215, 'Tumu', 'Tumu', 'Tumu', 20, 20, 43, '2020-06-02 04:28:39', NULL),
(6, 'Basins KG/Primary/JHS', 12, 203, 'Navrongo', 'Navrongo', 'Navrongo', 20, 20, 43, '2020-06-02 04:33:09', NULL),
(7, 'Huriya E/A School', 13, 219, 'Wa', 'Wa', 'Wa', 20, 20, 43, '2020-06-02 04:35:07', NULL),
(8, 'Awalia E/A JHS', 8, 158, 'Gambaga', 'Gambaga', 'Gambaga', 20, 20, 43, '2020-06-02 04:37:33', NULL),
(9, 'Saeediya E/A Primary/JHS', 12, 194, 'Bawku', 'Bawku', 'Bawku', 20, 20, 43, '2020-06-02 04:43:52', NULL),
(10, 'Umaria E/A JHS', 12, 198, 'Bolga', 'Bolga', 'Bolga', 20, 20, 43, '2020-06-02 04:46:19', NULL),
(11, 'Yagaba R/C JHS', 12, 159, 'Yagaba', 'Yagaba', 'Yagaba', 20, 20, 43, '2020-06-02 04:49:32', NULL),
(12, 'Malja Al-Ansuar E/A Basic', 9, 173, 'Savelugu', 'Savelugu', 'Savelugu', 20, 20, 43, '2020-06-02 04:52:54', NULL),
(13, 'Fathul-Mubeen Islamic School', 9, 174, 'Tamale', 'Tamale', 'Tamale', 20, 20, 43, '2020-06-02 04:55:55', NULL),
(14, 'Nuria Islamic School', 9, 174, 'Tamale', 'Tamale', 'Tamale', 20, 20, 43, '2020-06-02 08:05:55', NULL),
(15, 'Amriya E/A School', 9, 174, 'Tamale', 'Tamale', 'Tamale', 20, 20, 43, '2020-06-02 08:06:54', NULL),
(16, 'School Saulihiya Islamic JHS', 9, 161, 'Yendi', 'Yendi', 'Yendi', 20, 20, 43, '2020-06-02 08:08:52', NULL),
(17, 'Salaga D/A Primary School', 11, 189, 'Salaga', 'Salaga', 'Salaga', 20, 20, 43, '2020-06-02 08:11:41', NULL),
(18, 'Al-Manara Islamic School', 11, 193, 'Damongo', 'Damongo', 'Damongo', 20, 20, 43, '2020-06-02 08:14:25', NULL),
(19, 'St. Kizito JHS A', 11, 187, 'Bole', 'Bole', 'Bole', 20, 20, 43, '2020-06-02 08:15:59', NULL),
(20, 'New Dormaa Islamic Basic School', 3, 58, 'Sunyani', 'Sunyani', 'Sunyani', 20, 20, 43, '2020-06-02 08:17:45', NULL),
(21, 'Ibrahimia Islamic A and B ', 3, 186, 'Dua Nkwanta', 'Dua Nkwanta', 'Dua Nkwanta', 20, 20, 43, '2020-06-02 08:20:15', NULL),
(22, 'Nkoranza Islamic KG, Primary and JHS', 3, 65, 'Nkoranza', 'Nkoranza', 'Nkoranza', 20, 20, 43, '2020-06-02 08:23:35', NULL),
(23, 'ASWAQ Cluster of Schools, A,B and C', 3, 61, 'Wenchi', 'Wenchi', 'Wenchi', 20, 20, 43, '2020-06-02 08:25:31', NULL),
(24, 'Techiman Islamic Basic School', 4, 71, 'Techiman', 'Techiman', 'Techiman', 20, 20, 43, '2020-06-02 08:26:57', NULL),
(25, 'Atebubu English and Arabic School', 4, 62, 'Atebubu', 'Atebubu', 'Atebubu', 20, 20, 43, '2020-06-02 08:32:45', NULL),
(26, 'Goaso Islamic Basic School ', 1, 1, 'Goaso', 'Goaso', 'Goaso', 20, 20, 43, '2020-06-02 08:36:01', NULL),
(27, 'Islamic School', 1, 4, 'Hwidiem', 'Hwidiem', 'Hwidiem', 20, 20, 43, '2020-06-02 08:38:30', NULL),
(28, 'Benevolent School', 2, 47, 'Kumawu', 'Kumawu', 'Kumawu', 20, 20, 43, '2020-06-02 08:40:39', NULL),
(29, 'Saquafia Islamic Basic School', 2, 39, 'Obuasi', 'Obuasi', 'Obuasi', 20, 20, 43, '2020-06-02 08:42:11', NULL),
(30, 'Ibrahimiyya English-Arabic School', 2, 12, 'Tepa', 'Tepa', 'Tepa', 20, 20, 43, '2020-06-02 08:44:58', NULL),
(31, 'Community Centre', 2, 32, 'Ejura', 'Ejura', 'Ejura', 20, 20, 43, '2020-06-02 08:46:21', NULL),
(32, 'Watania Islamic School', 2, 34, 'Asawase', 'Asawase', 'Asawase', 20, 20, 43, '2020-06-02 08:48:43', NULL),
(33, 'Falahiya Islamic School', 5, 83, 'Cape Coast', 'Cape Coast', 'Cape Coast', 20, 20, 43, '2020-06-02 08:50:21', NULL),
(34, 'Sheriff Islamic School', 5, 88, 'Elmina', 'Elmina', 'Elmina', 20, 20, 43, '2020-06-02 08:53:16', NULL),
(35, 'Fosu Al-Huda Islamic School', 5, 79, 'Assin Fosu', 'Assin Fosu', 'Assin Fosu', 20, 20, 43, '2020-06-02 08:55:44', NULL),
(36, 'Ahlesunna Islamic Basic School', 15, 243, 'Axim', 'Axim', 'Axim', 20, 20, 43, '2020-06-02 12:21:39', NULL),
(37, 'Ntankoful Presby', 15, 240, 'Ntankoful', 'Ntankoful', 'Ntankoful', 20, 20, 43, '2020-06-02 12:30:38', NULL),
(38, 'Asawinso English/Arabic School', 16, 259, 'Sefwi Wiaso', 'Sefwi Wiaso', 'Sefwi Wiaso', 20, 20, 43, '2020-06-02 12:33:55', NULL),
(39, 'Bibiani Old Town Prim/JHS', 16, 255, 'Bibiani', 'Bibiani', 'Bibiani', 20, 20, 43, '2020-06-02 12:35:32', NULL),
(40, 'Ho Nuriya Islamic School Complex', 14, 227, 'Ho', 'Ho', 'Ho', 20, 20, 43, '2020-06-02 12:37:26', NULL),
(41, 'ASWAJ English & Arabic Basic Complex', 10, 229, 'Hohoe', 'Hohoe', 'Hohoe', 20, 20, 43, '2020-06-02 12:41:50', NULL),
(42, 'Dodi Mempeasem L/A Islamic School', 10, 181, 'Kadjebi', 'Kadjebi', 'Kadjebi', 20, 20, 43, '2020-06-02 12:45:31', NULL),
(43, 'Effiakuma M/A Prim/JHS', 15, 245, 'Effia kuma Zongo', 'Effia kuma Zongo', 'Effia kuma Zongo', 20, 20, 43, '2020-06-02 16:33:33', NULL),
(44, 'Huriya E/A School', 13, 209, 'Wa', 'Wa', 'Wa', 20, 20, 42, '2020-06-08 08:46:07', NULL),
(45, 'Falahiya Islamic School', 13, 209, 'Tumu', 'Tumu', 'Tumu', 20, 20, 42, '2020-06-08 08:47:12', NULL),
(46, 'Basins KG/Primary/JHS', 12, 194, 'Navrongo', 'Navrongo', 'Navrongo', 20, 20, 42, '2020-06-08 08:47:54', NULL),
(47, 'Saeediya E/A Primary/JHS', 12, 194, 'Bawku', 'Bawku', 'Bawku', 20, 20, 42, '2020-06-08 08:48:54', NULL),
(48, 'Umaria E/A JHS', 12, 194, 'Bolga', 'Bolga', 'Bolga', 20, 20, 42, '2020-06-08 08:49:39', NULL),
(49, 'Yagaba R/C JHS', 8, 156, 'Yagaba', 'Yagaba', 'Yagaba', 20, 20, 42, '2020-06-08 08:50:23', NULL),
(50, 'Awalia E/A JHS', 8, 156, 'Gambaga', 'Gambaga', 'Gambaga', 20, 20, 42, '2020-06-08 08:51:53', NULL),
(51, 'Malja Al-Ansuar E/A Basic', 9, 163, 'Savelugu', 'Savelugu', 'Savelugu', 20, 20, 42, '2020-06-08 08:53:36', NULL),
(52, 'Fathul-Mubeen Islamic School', 9, 163, 'Tamale', 'Tamale', 'Tamale', 20, 20, 42, '2020-06-08 08:54:23', NULL),
(53, 'Nuria Islamic School', 9, 163, 'Tamale', 'Tamale', 'Tamale', 20, 20, 42, '2020-06-08 08:54:48', NULL),
(54, 'Amriya E/A School', 9, 163, 'Tamale', 'Tamale', 'Tamale', 20, 20, 42, '2020-06-08 08:55:40', NULL),
(55, 'School Saulihiya Islamic JHS', 9, 163, 'Yendi', 'Yendi', 'Yendi', 20, 20, 42, '2020-06-08 08:57:12', NULL),
(56, 'Salaga D/A Primary School', 11, 187, 'Salaga', 'Salaga', 'Salaga', 20, 20, 42, '2020-06-08 08:58:31', NULL),
(57, 'Al-Manara Islamic School', 11, 187, 'Damongo', 'Damongo', 'Damongo', 20, 20, 42, '2020-06-08 08:59:48', NULL),
(58, 'St. Kizito JHS A', 11, 187, 'Bole', 'Bole', 'Bole', 20, 20, 42, '2020-06-08 09:00:26', NULL),
(59, 'New Dormaa Islamic Basic School', 3, 50, 'Sunyani', 'Sunyani', 'Sunyani', 20, 20, 42, '2020-06-08 09:01:26', NULL),
(60, 'Ibrahimia Islamic A and B ', 3, 50, 'Dua Nkwanta', 'Dua Nkwanta', 'Dua Nkwanta', 20, 20, 42, '2020-06-08 09:02:33', NULL),
(61, 'Nkoranza Islamic KG, Primary and JHS', 3, 65, 'Nkoranza', 'Nkoranza', 'Nkoranza', 20, 20, 42, '2020-06-08 09:05:23', NULL),
(62, 'ASWAQ Cluster of Schools A,B and C', 3, 50, 'Wenchi', 'Wenchi', 'Wenchi', 20, 20, 42, '2020-06-08 09:09:54', NULL),
(63, 'Techiman Islamic Basic School', 4, 62, 'Techiman', 'Techiman', 'Techiman', 20, 20, 42, '2020-06-08 09:11:15', NULL),
(64, 'Atebubu English and Arabic School', 4, 62, 'Atebubu', 'Atebubu', 'Atebubu', 20, 20, 42, '2020-06-08 09:12:19', NULL),
(65, 'Goaso Islamic Basic School ', 1, 1, 'Goaso', 'Goaso', 'Goaso', 20, 20, 42, '2020-06-08 09:13:17', NULL),
(66, 'Islamic School', 1, 1, 'Hwidiem', 'Hwidiem', 'Hwidiem', 20, 20, 42, '2020-06-08 09:14:00', NULL),
(67, 'Benevolent School', 2, 7, 'Kumawu', 'Kumawu', 'Kumawu', 20, 20, 42, '2020-06-08 09:14:51', NULL),
(68, 'Saquafia Islamic Basic School', 1, 1, 'Obuasi', 'Obuasi', 'Obuasi', 20, 20, 42, '2020-06-08 09:15:25', NULL),
(69, 'Ibrahimiyya English-Arabic School', 2, 7, 'Tepa', 'Tepa', 'Tepa', 20, 20, 42, '2020-06-08 09:16:39', NULL),
(70, 'Community Centre', 2, 7, 'Ejura', 'Ejura', 'Ejura', 20, 20, 42, '2020-06-08 09:17:32', NULL),
(71, 'Watania Islamic School', 2, 7, 'Asawase', 'Asawase', 'Asawase', 20, 20, 42, '2020-06-08 09:18:12', NULL);

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

--
-- Table structure for table `instruments`
--

CREATE TABLE `instruments` (
  `id` int(8) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` tinytext,
  `rate` varchar(8) DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `date_modified` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `instruments_archive`
--

CREATE TABLE `instruments_archive` (
  `id` int(8) NOT NULL DEFAULT '0',
  `company_id` varchar(255) DEFAULT NULL,
  `date_modified` varchar(255) DEFAULT NULL,
  `instruments_updated` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `item_code` varchar(255) DEFAULT NULL,
  `max_level` int(11) DEFAULT NULL,
  `min_level` int(11) DEFAULT NULL,
  `reorder_level` int(1) DEFAULT '1',
  `qty` int(11) DEFAULT NULL,
  `default_price` double DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_categories`
--

CREATE TABLE `item_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_received`
--

CREATE TABLE `item_received` (
  `id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `item_stocked`
--

CREATE TABLE `item_stocked` (
  `id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `balance` int(11) DEFAULT NULL,
  `description` text,
  `company_id` int(11) DEFAULT NULL,
  `unit_price` float DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_supplier_approved`
--

CREATE TABLE `item_supplier_approved` (
  `id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `unit_price` double DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `item_units`
--

CREATE TABLE `item_units` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` int(11) NOT NULL,
  `last_run` varchar(50) DEFAULT NULL,
  `deleted` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `leaves_holidays`
--

CREATE TABLE `leaves_holidays` (
  `id` int(12) NOT NULL,
  `holiday` varchar(255) NOT NULL,
  `h_date` varchar(100) NOT NULL,
  `deleted` int(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `leaves_messages`
--

CREATE TABLE `leaves_messages` (
  `id` int(11) NOT NULL,
  `short_title` varchar(255) DEFAULT NULL,
  `long_title` varchar(255) DEFAULT NULL,
  `summary` text,
  `description` text,
  `image_caption` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `author` varchar(255) DEFAULT NULL,
  `headline` varchar(255) DEFAULT NULL,
  `highlight` int(1) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `sub_cat_id` int(8) DEFAULT NULL,
  `status` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `leaves_settings`
--

CREATE TABLE `leaves_settings` (
  `id` int(12) NOT NULL,
  `leave_type` varchar(150) DEFAULT NULL,
  `leave_days` int(5) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `approver` int(12) NOT NULL DEFAULT '0',
  `coordinator_fullname` varchar(255) NOT NULL,
  `coordinator_email` varchar(255) NOT NULL,
  `coordinator_phone` varchar(255) NOT NULL,
  `copy_addresses` varchar(255) NOT NULL,
  `default` int(1) DEFAULT '0',
  `deleted` int(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `leaves_smleaves`
--

CREATE TABLE `leaves_smleaves` (
  `id` int(12) NOT NULL,
  `emp_id` int(12) NOT NULL,
  `days` int(12) NOT NULL,
  `start_date` varchar(50) NOT NULL,
  `end_date` varchar(50) NOT NULL,
  `leave_type` varchar(255) NOT NULL,
  `bmhod` int(12) NOT NULL,
  `sig_bmhod_date` varchar(50) DEFAULT NULL,
  `doctor` int(2) NOT NULL,
  `req_date` varchar(50) NOT NULL,
  `company_id` int(12) DEFAULT NULL,
  `branch_id` int(12) DEFAULT NULL,
  `department_id` int(12) DEFAULT NULL,
  `year` varchar(50) NOT NULL,
  `status` int(2) NOT NULL,
  `deleted` int(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `leave_requests`
--

CREATE TABLE `leave_requests` (
  `id` int(12) NOT NULL,
  `emp_id` int(12) NOT NULL,
  `req_date` varchar(50) NOT NULL,
  `lea_days` int(50) NOT NULL,
  `duration_unix` text,
  `emp_branch` int(12) NOT NULL,
  `lea_from` varchar(50) NOT NULL,
  `lea_to` varchar(50) NOT NULL,
  `leave_type` int(11) DEFAULT NULL,
  `reliever` varchar(255) NOT NULL,
  `sig_bmhod` int(12) NOT NULL,
  `sig_bmhod_date` varchar(50) NOT NULL,
  `company_id` int(12) DEFAULT NULL,
  `branch_id` int(12) DEFAULT NULL,
  `department_id` int(12) DEFAULT NULL,
  `comment` text NOT NULL,
  `reject_reason` text,
  `year` int(12) NOT NULL,
  `status` int(12) NOT NULL,
  `deleted` int(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loans`
--

CREATE TABLE `loans` (
  `id` int(12) NOT NULL,
  `applicant_id` int(12) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `date_engaged` varchar(50) DEFAULT NULL,
  `job_title` varchar(255) DEFAULT NULL,
  `res_add` varchar(255) DEFAULT NULL,
  `spouse_name` varchar(255) DEFAULT NULL,
  `spouse_add` varchar(255) DEFAULT NULL,
  `spouse_phone` varchar(100) DEFAULT NULL,
  `spouse_emp` varchar(255) DEFAULT NULL,
  `spouse_emp_add` varchar(255) DEFAULT NULL,
  `amount` varchar(100) DEFAULT NULL,
  `loan_approved` varchar(10) DEFAULT NULL,
  `loan_granted` varchar(100) DEFAULT NULL,
  `tenor` varchar(100) DEFAULT NULL,
  `deduction` varchar(100) DEFAULT NULL,
  `status` int(12) DEFAULT NULL,
  `sig_hr` int(12) DEFAULT NULL,
  `sig_hr_date` varchar(50) DEFAULT NULL,
  `sig_direc` int(12) DEFAULT NULL,
  `sig_direc_date` varchar(50) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` int(12) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_statuses`
--

CREATE TABLE `loan_statuses` (
  `id` int(12) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loyalty_ladder`
--

CREATE TABLE `loyalty_ladder` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `color_dorminate` varchar(255) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `lpos`
--

CREATE TABLE `lpos` (
  `id` int(12) NOT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `supplier_id` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `lpono` varchar(50) DEFAULT NULL,
  `intro` text,
  `delivery_date` varchar(50) DEFAULT NULL,
  `payment` text,
  `onbehalf_of` varchar(255) DEFAULT NULL,
  `creator` int(12) DEFAULT NULL,
  `to_be_approved_by` int(12) DEFAULT NULL,
  `approved_by` int(12) DEFAULT NULL,
  `status` int(12) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `lpo_items`
--

CREATE TABLE `lpo_items` (
  `id` int(12) NOT NULL,
  `item` varchar(255) DEFAULT NULL,
  `price` varchar(50) DEFAULT NULL,
  `quantity` varchar(50) DEFAULT NULL,
  `amount` varchar(50) DEFAULT NULL,
  `lpo_id` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `creator` int(12) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `lpo_status`
--

CREATE TABLE `lpo_status` (
  `id` int(12) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `deleted` int(12) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `from` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `to` varchar(255) DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `body` text,
  `date` varchar(50) DEFAULT NULL,
  `date_pushed` varchar(50) DEFAULT NULL,
  `deleted` int(10) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mode_of_communications`
--

CREATE TABLE `mode_of_communications` (
  `id` int(12) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `deleted` int(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `mode_of_communications`
--

INSERT INTO `mode_of_communications` (`id`, `name`, `deleted`) VALUES
(1, 'Whats Up', 0),
(2, 'Email', 1),
(3, 'Phone', 0),
(4, 'Text Message', 0),
(5, 'imo 34', 1),
(6, 'Visit', 0);

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

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `module_categories`
--

CREATE TABLE `module_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `description` text,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notification_parameters`
--

CREATE TABLE `notification_parameters` (
  `id` int(12) NOT NULL,
  `from` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(2) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `office_supplies`
--

CREATE TABLE `office_supplies` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `dept_id` int(8) DEFAULT NULL,
  `branch_id` int(8) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `supervisor_id` int(11) DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `order` int(2) DEFAULT '1',
  `process_flow_code` varchar(50) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `deleted` int(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `office_supply_cart`
--

CREATE TABLE `office_supply_cart` (
  `id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `qty` int(5) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `office_supply_carts`
--

CREATE TABLE `office_supply_carts` (
  `id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `qty` int(5) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `status` int(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `office_supply_comments`
--

CREATE TABLE `office_supply_comments` (
  `id` int(11) NOT NULL,
  `office_supplies_id` int(11) DEFAULT NULL,
  `commentor_id` int(5) DEFAULT NULL,
  `comment` text,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `positions`
--

CREATE TABLE `positions` (
  `id` int(12) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `salary` double NOT NULL DEFAULT '0',
  `company_id` int(12) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `positions`
--

INSERT INTO `positions` (`id`, `name`, `salary`, `company_id`, `date`, `deleted`) VALUES
(110, 'Head of Institution', 0, 43, '2020-06-01 15:19:12', 0),
(111, 'District Head ', 0, 43, '2020-06-01 15:20:16', 0),
(112, 'Regional Head ', 0, 43, '2020-06-01 15:21:12', 0),
(114, 'Administrative Officer', 0, 43, '2020-06-02 21:33:26', 0),
(129, 'Deputy Regional Head', 0, 43, '2020-08-26 22:23:36', 0),
(128, 'Deputy District Head', 0, 43, '2020-08-26 22:23:36', 0),
(119, 'Instructor', 0, 43, '2020-06-08 16:42:43', 0),
(120, 'Project Coordinator ', 0, 43, '2020-06-09 12:07:27', 0),
(121, 'Operations Manager', 0, 43, '2020-06-09 12:08:11', 0),
(122, 'Finance Manager', 0, 43, '2020-06-09 12:08:30', 0);

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

--
-- Table structure for table `purpose_of_calls`
--

CREATE TABLE `purpose_of_calls` (
  `id` int(12) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `deleted` int(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `country_id` int(5) NOT NULL,
  `abbr` varchar(100) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `name`, `country_id`, `abbr`, `created`) VALUES
(1, 'Ahafo', 82, 'AH', '2020-05-23 20:49:02'),
(2, 'Ashanti', 82, 'AS', '2020-05-23 20:49:02'),
(3, 'Bono', 82, 'BO', '2020-05-23 20:49:02'),
(4, 'Bono East', 82, 'BE', '2020-05-23 20:49:02'),
(5, 'Central', 82, 'CT', '2020-05-23 20:49:02'),
(6, 'Eastern', 82, 'ET', '2020-05-23 20:49:02'),
(7, 'Greater Accra', 82, 'GA', '2020-05-23 20:49:02'),
(8, 'North East', 82, 'NE', '2020-05-23 20:49:02'),
(9, 'Northern', 82, 'NT', '2020-05-23 20:49:02'),
(10, 'Oti', 82, 'OT', '2020-05-23 20:49:02'),
(11, 'Savannah', 82, 'SV', '2020-05-23 20:49:02'),
(12, 'Upper East', 82, 'UE', '2020-05-23 20:49:02'),
(13, 'Upper West', 82, 'UW', '2020-05-23 20:49:02'),
(14, 'Volta', 82, 'VT', '2020-05-23 20:49:02'),
(15, 'Western', 82, 'WT', '2020-05-23 20:49:02'),
(16, 'Western North', 82, 'WN', '2020-05-23 20:49:02');

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

--
-- Table structure for table `reimbursibles`
--

CREATE TABLE `reimbursibles` (
  `id` int(11) NOT NULL,
  `full_name` varchar(150) DEFAULT NULL,
  `department` int(5) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `purpose` text,
  `supervisor` int(5) DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `file` varchar(250) DEFAULT NULL,
  `project_listings` int(11) DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `reimbursible_categories`
--

CREATE TABLE `reimbursible_categories` (
  `id` int(3) NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `reimbursible_comments`
--

CREATE TABLE `reimbursible_comments` (
  `id` int(11) NOT NULL,
  `reimbursible_id` int(11) DEFAULT NULL,
  `commentor_usergroup_id` int(5) DEFAULT NULL,
  `commentor_id` int(5) DEFAULT NULL,
  `comment` text,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `requisition_form_codes`
--

CREATE TABLE `requisition_form_codes` (
  `id` int(4) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `description` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `requisition_process_approvers`
--

CREATE TABLE `requisition_process_approvers` (
  `id` int(9) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `approver` varchar(255) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `stage_id` int(8) DEFAULT NULL,
  `order` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `requisition_process_flows`
--

CREATE TABLE `requisition_process_flows` (
  `id` int(4) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `description` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `requisition_process_flow_stages`
--

CREATE TABLE `requisition_process_flow_stages` (
  `id` int(8) NOT NULL,
  `title_of_stage` varchar(255) DEFAULT NULL,
  `order` int(5) DEFAULT '0',
  `process_flow_code` varchar(10) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL,
  `description` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sales_bonus`
--

CREATE TABLE `sales_bonus` (
  `id` int(12) NOT NULL,
  `bonus_id` int(12) DEFAULT NULL,
  `percentage` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `branch_id` int(12) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sales_exp_categories`
--

CREATE TABLE `sales_exp_categories` (
  `id` int(12) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `type_id` int(12) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sales_exp_expenditures`
--

CREATE TABLE `sales_exp_expenditures` (
  `id` int(12) NOT NULL,
  `cat_id` int(12) DEFAULT NULL,
  `amount` varchar(50) DEFAULT NULL,
  `comment` text,
  `user_id` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `branch_id` int(12) DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sales_exp_sales`
--

CREATE TABLE `sales_exp_sales` (
  `id` int(12) NOT NULL,
  `cat_id` int(12) DEFAULT NULL,
  `amount` varchar(50) DEFAULT NULL,
  `quantity` int(12) DEFAULT NULL,
  `comment` text,
  `user_id` int(12) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `branch_id` int(12) DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sales_exp_statuses`
--

CREATE TABLE `sales_exp_statuses` (
  `id` int(12) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sales_exp_types`
--

CREATE TABLE `sales_exp_types` (
  `id` int(12) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `id` int(11) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image_description` text,
  `image_thumbnail` varchar(80) NOT NULL,
  `thumbnail_description` varchar(100) DEFAULT NULL,
  `image_caption` varchar(50) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) DEFAULT '0',
  `position` int(8) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slides`
--

INSERT INTO `slides` (`id`, `company_id`, `link`, `image`, `image_description`, `image_thumbnail`, `thumbnail_description`, `image_caption`, `date`, `status`, `position`) VALUES
(136, 43, '#', 'slides/5ee3/3716/5ee33716f1004df793a04f8bc0b934b8.jpeg', NULL, 'slides/5ee3/3716/5ee33716f1004df793a04f8bc0b934b8_thumbnail.jpeg', NULL, '', '2020-06-12 08:04:38', 0, 0),
(137, 43, '#', 'slides/5ee3/3bce/5ee33bce9b044ee684424d9ac0b934b8.jpeg', NULL, 'slides/5ee3/3bce/5ee33bce9b044ee684424d9ac0b934b8_thumbnail.jpeg', NULL, '', '2020-06-12 08:24:46', 0, 0),
(134, 41, '#', 'slides/5ee3/2205/5ee3220581384969971b4088c0b934b8.jpg', NULL, 'slides/5ee3/2205/5ee3220581384969971b4088c0b934b8_thumbnail.jpg', NULL, '', '2020-06-12 06:34:45', 1, 0),
(138, 43, '#', 'slides/5ee3/3f8d/5ee33f8d54644feabf9c464cc0b934b8.jpeg', NULL, 'slides/5ee3/3f8d/5ee33f8d54644feabf9c464cc0b934b8_thumbnail.jpeg', NULL, '', '2020-06-12 08:40:45', 0, 0),
(139, 43, '#', 'slides/5ee6/9a7b/5ee69a7b2aa849bd815d4053c0b934b8.jpeg', NULL, 'slides/5ee6/9a7b/5ee69a7b2aa849bd815d4053c0b934b8_thumbnail.jpeg', NULL, '', '2020-06-14 21:45:31', 1, 0),
(140, 43, '#', 'slides/5ee6/9ab6/5ee69ab6bad84671bb864832c0b934b8.jpeg', NULL, 'slides/5ee6/9ab6/5ee69ab6bad84671bb864832c0b934b8_thumbnail.jpeg', NULL, '', '2020-06-14 21:46:30', 1, 0);

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

--
-- Table structure for table `statuses`
--

CREATE TABLE `statuses` (
  `id` int(12) NOT NULL,
  `name` varchar(255) NOT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `statuses`
--

INSERT INTO `statuses` (`id`, `name`, `deleted`) VALUES
(1, 'Pending Approval', 0),
(2, 'Approved', 0),
(3, 'Rejected', 0),
(4, 'Incomplete', 0),
(5, 'Active', 0),
(6, 'Inactive', 0);

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

--
-- Table structure for table `status_of_calls`
--

CREATE TABLE `status_of_calls` (
  `id` int(12) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `deleted` int(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int(12) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `company_id` int(12) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(8) DEFAULT NULL,
  `deleted` int(2) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `usergroups`
--

CREATE TABLE `usergroups` (
  `id` int(12) NOT NULL,
  `name` varchar(255) NOT NULL,
  `deleted` int(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usergroups`
--

INSERT INTO `usergroups` (`id`, `name`, `deleted`) VALUES
(1, 'Administrator', 0),
(2, 'Normal User', 0),
(7, 'Company Admin', 0),
(4, 'Supervisor', 0),
(5, 'HR Officer', 0),
(6, 'Head of HR', 0),
(8, 'Finance Officer ', 0),
(9, 'Finance Manager ', 0),
(10, 'District Head', 0),
(11, 'Regional Head', 0);

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

--
-- Table structure for table `users_education`
--

CREATE TABLE `users_education` (
  `id` int(8) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `from` varchar(255) DEFAULT NULL,
  `to` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `majors` varchar(255) DEFAULT NULL,
  `degree` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_family`
--

CREATE TABLE `users_family` (
  `id` int(8) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `res_address` text,
  `father` varchar(255) DEFAULT NULL,
  `mother` varchar(255) DEFAULT NULL,
  `marital_status` int(2) DEFAULT NULL,
  `spouse_name` varchar(255) DEFAULT NULL,
  `spouse_profession` varchar(255) DEFAULT NULL,
  `spouse_employer` varchar(255) DEFAULT NULL,
  `spouse_employer_address` varchar(255) DEFAULT NULL,
  `spouse_address` varchar(255) DEFAULT NULL,
  `spouse_residential_address` varchar(255) DEFAULT NULL,
  `spouse_phone` varchar(100) DEFAULT NULL,
  `num_children` int(3) DEFAULT NULL,
  `spouse_dob` varchar(100) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_language`
--

CREATE TABLE `users_language` (
  `id` int(8) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_other_training`
--

CREATE TABLE `users_other_training` (
  `id` int(8) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `from` varchar(255) DEFAULT NULL,
  `to` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_profession`
--

CREATE TABLE `users_profession` (
  `id` int(8) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `from` varchar(255) DEFAULT NULL,
  `to` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `task_responsibilities` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_reference`
--

CREATE TABLE `users_reference` (
  `id` int(8) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_social_work`
--

CREATE TABLE `users_social_work` (
  `id` int(8) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `from` varchar(255) DEFAULT NULL,
  `to` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `company_id` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `id` int(11) NOT NULL,
  `position_id` int(5) DEFAULT NULL,
  `type_id` int(5) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` (`id`, `position_id`, `type_id`, `user_id`, `status`, `company_id`, `created`, `modified`) VALUES
(1, 112, 1, 176, 1, 43, '2020-08-27 15:08:34', '2020-08-27 15:08:34'),
(2, 112, 7, 177, 1, 43, '2020-08-27 15:14:05', '2020-08-27 15:14:05'),
(3, 112, 3, 178, 1, 43, '2020-08-27 15:18:18', '2020-08-27 15:18:18'),
(4, 112, 2, 185, 1, 43, '2020-09-01 12:34:35', '2020-09-01 12:34:35'),
(5, 129, 2, 186, 1, 43, '2020-09-01 12:35:36', '2020-09-01 12:35:36'),
(6, 129, 1, 187, 1, 43, '2020-09-01 12:37:34', '2020-09-01 12:37:34'),
(7, 129, 3, 188, 1, 43, '2020-09-01 13:09:33', '2020-09-01 13:09:33'),
(8, 129, 4, 189, 1, 43, '2020-09-01 13:12:54', '2020-09-01 13:12:54'),
(9, 112, 4, 190, 1, 43, '2020-09-01 13:14:06', '2020-09-01 13:14:06'),
(10, 112, 5, 191, 1, 43, '2020-09-01 13:15:16', '2020-09-01 13:15:16'),
(11, 129, 6, 192, 1, 43, '2020-09-01 13:17:12', '2020-09-01 13:17:12'),
(12, 112, 8, 193, 1, 43, '2020-09-01 13:29:07', '2020-09-01 13:29:07'),
(13, 112, 10, 194, 1, 43, '2020-09-01 13:30:11', '2020-09-01 13:30:11'),
(14, 112, 13, 195, 1, 43, '2020-09-01 13:31:30', '2020-09-01 13:31:30'),
(15, 112, 14, 196, 1, 43, '2020-09-01 13:32:46', '2020-09-01 13:32:46'),
(16, 112, 15, 197, 1, 43, '2020-09-01 13:34:26', '2020-09-01 13:34:26'),
(17, 112, 16, 198, 1, 43, '2020-09-01 13:36:43', '2020-09-01 13:36:43'),
(18, 129, 16, 199, 1, 43, '2020-09-01 13:47:04', '2020-09-01 13:47:04'),
(19, 129, 14, 200, 1, 43, '2020-09-01 13:48:33', '2020-09-01 13:48:33'),
(20, 129, 10, 201, 1, 43, '2020-09-01 13:49:54', '2020-09-01 13:49:54'),
(21, 129, 11, 202, 1, 43, '2020-09-01 13:51:06', '2020-09-01 13:51:06'),
(22, 129, 12, 203, 1, 43, '2020-09-01 13:52:09', '2020-09-01 13:52:09'),
(23, 129, 13, 204, 1, 43, '2020-09-01 13:57:15', '2020-09-01 13:57:15'),
(24, 111, 146, 206, 1, 43, '2020-09-02 13:06:15', '2020-09-02 13:06:15'),
(25, 112, 7, 207, 1, 43, '2020-09-02 13:30:46', '2020-09-02 13:30:46'),
(26, 129, 5, 208, 1, 43, '2020-09-02 13:53:29', '2020-09-02 13:53:29'),
(27, 129, 9, 209, 1, 43, '2020-09-02 13:56:02', '2020-09-02 13:56:02'),
(28, 112, 12, 210, 1, 43, '2020-09-02 14:04:42', '2020-09-02 14:04:42'),
(29, 112, 9, 211, 1, 43, '2020-09-02 14:07:42', '2020-09-02 14:07:42'),
(30, 129, 8, 212, 1, 43, '2020-09-02 14:42:47', '2020-09-02 14:42:47'),
(31, 128, 202, 213, 1, 43, '2020-09-03 14:59:28', '2020-09-03 14:59:28'),
(32, 128, 198, 214, 1, 43, '2020-09-03 15:00:46', '2020-09-03 15:00:46'),
(33, 128, 200, 215, 1, 43, '2020-09-03 15:02:46', '2020-09-03 15:02:46'),
(34, 128, 199, 216, 1, 43, '2020-09-03 15:04:11', '2020-09-03 15:04:11'),
(35, 128, 206, 217, 1, 43, '2020-09-03 15:05:05', '2020-09-03 15:05:05'),
(36, 128, 201, 218, 1, 43, '2020-09-03 15:06:22', '2020-09-03 15:06:22'),
(37, 128, 197, 219, 1, 43, '2020-09-03 15:07:53', '2020-09-03 15:07:53'),
(38, 128, 196, 220, 1, 43, '2020-09-03 15:08:35', '2020-09-03 15:08:35'),
(39, 128, 205, 221, 1, 43, '2020-09-03 15:09:44', '2020-09-03 15:09:44'),
(40, 128, 208, 222, 1, 43, '2020-09-03 15:11:50', '2020-09-03 15:11:50'),
(41, 128, 15, 223, 1, 43, '2020-09-03 15:17:22', '2020-09-03 15:17:22'),
(42, 128, 218, 224, 1, 43, '2020-09-03 15:21:03', '2020-09-03 15:21:03'),
(43, 128, 195, 225, 1, 43, '2020-09-03 15:23:43', '2020-09-03 15:23:43'),
(44, 128, 28, 226, 1, 43, '2020-09-03 15:34:28', '2020-09-03 15:34:28'),
(45, 111, 28, 227, 1, 43, '2020-09-03 15:35:11', '2020-09-03 15:35:11'),
(46, 128, 31, 228, 1, 43, '2020-09-03 15:36:13', '2020-09-03 15:36:13'),
(47, 128, 47, 229, 1, 43, '2020-09-03 15:40:28', '2020-09-03 15:40:28'),
(48, 128, 41, 230, 1, 43, '2020-09-03 15:42:09', '2020-09-03 15:42:09'),
(49, 111, 41, 231, 1, 43, '2020-09-03 15:42:29', '2020-09-03 15:42:29'),
(50, 128, 42, 232, 1, 43, '2020-09-03 15:43:56', '2020-09-03 15:43:56'),
(51, 111, 42, 233, 1, 43, '2020-09-03 15:44:17', '2020-09-03 15:44:17'),
(52, 111, 42, 234, 1, 43, '2020-09-03 15:44:30', '2020-09-03 15:44:30'),
(53, 128, 49, 235, 1, 43, '2020-09-03 15:46:50', '2020-09-03 15:46:50'),
(54, 111, 49, 236, 1, 43, '2020-09-03 15:47:15', '2020-09-03 15:47:15'),
(55, 128, 36, 237, 1, 43, '2020-09-03 15:49:55', '2020-09-03 15:49:55'),
(56, 111, 36, 238, 1, 43, '2020-09-03 15:50:25', '2020-09-03 15:50:25'),
(57, 128, 11, 239, 1, 43, '2020-09-03 15:51:33', '2020-09-03 15:51:33'),
(58, 111, 11, 240, 1, 43, '2020-09-03 15:51:58', '2020-09-03 15:51:58'),
(59, 111, 15, 241, 1, 43, '2020-09-03 15:54:39', '2020-09-03 15:54:39'),
(60, 128, 19, 242, 1, 43, '2020-09-03 15:56:05', '2020-09-03 15:56:05'),
(61, 111, 21, 243, 1, 43, '2020-09-03 15:56:59', '2020-09-03 15:56:59'),
(62, 111, 21, 244, 1, 43, '2020-09-03 15:57:26', '2020-09-03 15:57:26'),
(63, 111, 21, 245, 1, 43, '2020-09-03 15:58:35', '2020-09-03 15:58:35'),
(64, 128, 22, 246, 1, 43, '2020-09-03 16:00:36', '2020-09-03 16:00:36'),
(65, 111, 22, 247, 1, 43, '2020-09-03 16:01:51', '2020-09-03 16:01:51'),
(66, 128, 24, 248, 1, 43, '2020-09-03 16:04:00', '2020-09-03 16:04:00'),
(67, 111, 26, 249, 1, 43, '2020-09-03 16:05:50', '2020-09-03 16:05:50'),
(68, 111, 26, 250, 1, 43, '2020-09-03 16:06:29', '2020-09-03 16:06:29'),
(69, 111, 27, 251, 1, 43, '2020-09-03 16:07:07', '2020-09-03 16:07:07'),
(70, 128, 34, 252, 1, 43, '2020-09-03 16:09:38', '2020-09-03 16:09:38'),
(71, 128, 34, 253, 1, 43, '2020-09-03 16:11:05', '2020-09-03 16:11:05'),
(72, 128, 34, 254, 1, 43, '2020-09-03 16:12:58', '2020-09-03 16:12:58'),
(73, 128, 34, 255, 1, 43, '2020-09-03 16:14:10', '2020-09-03 16:14:10'),
(74, 128, 30, 256, 1, 43, '2020-09-03 16:16:15', '2020-09-03 16:16:15'),
(75, 111, 46, 257, 1, 43, '2020-09-03 16:18:34', '2020-09-03 16:18:34'),
(76, 111, 46, 258, 1, 43, '2020-09-03 16:19:21', '2020-09-03 16:19:21'),
(77, 128, 37, 259, 1, 43, '2020-09-03 16:24:07', '2020-09-03 16:24:07'),
(78, 111, 37, 260, 1, 43, '2020-09-03 16:24:31', '2020-09-03 16:24:31'),
(79, 128, 17, 261, 1, 43, '2020-09-03 16:30:46', '2020-09-03 16:30:46'),
(80, 111, 17, 262, 1, 43, '2020-09-03 16:31:15', '2020-09-03 16:31:15'),
(81, 128, 39, 263, 1, 43, '2020-09-03 16:35:12', '2020-09-03 16:35:12'),
(82, 128, 40, 264, 1, 43, '2020-09-03 16:38:43', '2020-09-03 16:38:43'),
(83, 111, 40, 265, 1, 43, '2020-09-03 16:39:11', '2020-09-03 16:39:11'),
(84, 128, 43, 266, 1, 43, '2020-09-03 16:40:23', '2020-09-03 16:40:23'),
(85, 111, 43, 267, 1, 43, '2020-09-03 16:40:45', '2020-09-03 16:40:45'),
(86, 128, 4, 268, 1, 43, '2020-09-03 16:42:33', '2020-09-03 16:42:33'),
(87, 128, 3, 269, 1, 43, '2020-09-03 16:43:47', '2020-09-03 16:43:47'),
(88, 128, 1, 270, 1, 43, '2020-09-03 16:45:43', '2020-09-03 16:45:43'),
(89, 111, 1, 271, 1, 43, '2020-09-03 16:46:16', '2020-09-03 16:46:16'),
(90, 128, 2, 272, 1, 43, '2020-09-03 16:47:21', '2020-09-03 16:47:21'),
(91, 111, 2, 273, 1, 43, '2020-09-03 16:47:38', '2020-09-03 16:47:38'),
(92, 128, 62, 274, 1, 43, '2020-09-03 16:49:24', '2020-09-03 16:49:24'),
(93, 111, 62, 275, 1, 43, '2020-09-03 16:49:59', '2020-09-03 16:49:59'),
(94, 128, 51, 276, 1, 43, '2020-09-03 16:52:57', '2020-09-03 16:52:57'),
(95, 111, 51, 277, 1, 43, '2020-09-03 16:53:29', '2020-09-03 16:53:29'),
(96, 128, 54, 278, 1, 43, '2020-09-03 16:55:53', '2020-09-03 16:55:53'),
(97, 128, 56, 279, 1, 43, '2020-09-03 16:57:31', '2020-09-03 16:57:31'),
(98, 111, 56, 280, 1, 43, '2020-09-03 16:57:57', '2020-09-03 16:57:57'),
(99, 128, 63, 281, 1, 43, '2020-09-03 16:59:09', '2020-09-03 16:59:09'),
(100, 111, 63, 282, 1, 43, '2020-09-03 16:59:34', '2020-09-03 16:59:34'),
(101, 128, 64, 283, 1, 43, '2020-09-03 17:00:31', '2020-09-03 17:00:31'),
(102, 111, 64, 284, 1, 43, '2020-09-03 17:01:38', '2020-09-03 17:01:38'),
(103, 128, 65, 285, 1, 43, '2020-09-03 17:03:01', '2020-09-03 17:03:01'),
(104, 111, 65, 286, 1, 43, '2020-09-03 17:03:32', '2020-09-03 17:03:32'),
(105, 128, 69, 287, 1, 43, '2020-09-03 17:06:54', '2020-09-03 17:06:54'),
(106, 111, 69, 288, 1, 43, '2020-09-03 17:07:20', '2020-09-03 17:07:20'),
(107, 128, 58, 289, 1, 43, '2020-09-03 17:09:34', '2020-09-03 17:09:34'),
(108, 111, 58, 290, 1, 43, '2020-09-03 17:09:59', '2020-09-03 17:09:59'),
(109, 128, 5, 291, 1, 43, '2020-09-03 17:12:21', '2020-09-03 17:12:21'),
(110, 128, 6, 292, 1, 43, '2020-09-03 17:13:17', '2020-09-03 17:13:17'),
(111, 111, 6, 293, 1, 43, '2020-09-03 17:13:49', '2020-09-03 17:13:49'),
(112, 128, 72, 294, 1, 43, '2020-09-03 17:15:47', '2020-09-03 17:15:47'),
(113, 111, 72, 295, 1, 43, '2020-09-03 17:16:09', '2020-09-03 17:16:09'),
(114, 128, 71, 296, 1, 43, '2020-09-03 17:17:58', '2020-09-03 17:17:58'),
(115, 111, 71, 297, 1, 43, '2020-09-03 17:18:24', '2020-09-03 17:18:24'),
(116, 128, 83, 298, 1, 43, '2020-09-03 17:24:32', '2020-09-03 17:24:32'),
(117, 128, 74, 299, 1, 43, '2020-09-03 17:29:36', '2020-09-03 17:29:36'),
(118, 128, 76, 300, 1, 43, '2020-09-03 17:31:00', '2020-09-03 17:31:00'),
(119, 111, 76, 301, 1, 43, '2020-09-03 17:33:04', '2020-09-03 17:33:04'),
(120, 128, 77, 302, 1, 43, '2020-09-03 17:34:50', '2020-09-03 17:34:50'),
(121, 111, 77, 303, 1, 43, '2020-09-03 17:35:25', '2020-09-03 17:35:25'),
(122, 128, 78, 304, 1, 43, '2020-09-03 17:36:54', '2020-09-03 17:36:54'),
(123, 111, 78, 305, 1, 43, '2020-09-03 17:37:28', '2020-09-03 17:37:28'),
(124, 128, 79, 306, 1, 43, '2020-09-03 17:38:58', '2020-09-03 17:38:58'),
(125, 111, 79, 307, 1, 43, '2020-09-03 17:39:23', '2020-09-03 17:39:23'),
(126, 128, 80, 308, 1, 43, '2020-09-03 17:40:15', '2020-09-03 17:40:15'),
(127, 111, 80, 309, 1, 43, '2020-09-03 17:40:34', '2020-09-03 17:40:34'),
(128, 128, 81, 310, 1, 43, '2020-09-03 17:42:15', '2020-09-03 17:42:15'),
(129, 128, 83, 311, 1, 43, '2020-09-03 17:43:49', '2020-09-03 17:43:49'),
(130, 128, 84, 312, 1, 43, '2020-09-03 17:45:49', '2020-09-03 17:45:49'),
(131, 111, 84, 313, 1, 43, '2020-09-03 17:46:27', '2020-09-03 17:46:27'),
(132, 111, 85, 314, 1, 43, '2020-09-03 17:47:34', '2020-09-03 17:47:34'),
(133, 111, 85, 315, 1, 43, '2020-09-03 17:48:07', '2020-09-03 17:48:07'),
(134, 128, 86, 316, 1, 43, '2020-09-03 17:49:41', '2020-09-03 17:49:41'),
(135, 128, 86, 317, 1, 43, '2020-09-03 17:51:16', '2020-09-03 17:51:16'),
(136, 111, 86, 318, 1, 43, '2020-09-03 17:52:31', '2020-09-03 17:52:31'),
(137, 111, 87, 319, 1, 43, '2020-09-03 17:54:16', '2020-09-03 17:54:16'),
(138, 111, 87, 320, 1, 43, '2020-09-03 17:55:09', '2020-09-03 17:55:09'),
(139, 111, 87, 321, 1, 43, '2020-09-03 17:55:44', '2020-09-03 17:55:44'),
(140, 128, 88, 322, 1, 43, '2020-09-03 17:58:48', '2020-09-03 17:58:48'),
(141, 111, 88, 323, 1, 43, '2020-09-03 17:59:15', '2020-09-03 17:59:15'),
(142, 111, 91, 324, 1, 43, '2020-09-03 18:00:52', '2020-09-03 18:00:52'),
(143, 111, 91, 325, 1, 43, '2020-09-03 18:01:21', '2020-09-03 18:01:21'),
(144, 128, 92, 326, 1, 43, '2020-09-03 18:03:45', '2020-09-03 18:03:45'),
(145, 128, 96, 327, 1, 43, '2020-09-03 18:05:07', '2020-09-03 18:05:07'),
(146, 111, 96, 328, 1, 43, '2020-09-03 18:05:25', '2020-09-03 18:05:25'),
(147, 128, 121, 329, 1, 43, '2020-09-03 18:06:54', '2020-09-03 18:06:54'),
(148, 111, 121, 330, 1, 43, '2020-09-03 18:07:15', '2020-09-03 18:07:15'),
(149, 128, 106, 331, 1, 43, '2020-09-03 18:11:48', '2020-09-03 18:11:48'),
(150, 111, 106, 332, 1, 43, '2020-09-03 18:12:06', '2020-09-03 18:12:06'),
(151, 128, 105, 333, 1, 43, '2020-09-03 18:13:48', '2020-09-03 18:13:48'),
(152, 111, 105, 334, 1, 43, '2020-09-03 18:14:42', '2020-09-03 18:14:42'),
(153, 128, 98, 335, 1, 43, '2020-09-03 18:20:02', '2020-09-03 18:20:02'),
(154, 111, 98, 336, 1, 43, '2020-09-03 18:20:19', '2020-09-03 18:20:19'),
(155, 128, 108, 337, 1, 43, '2020-09-03 18:21:43', '2020-09-03 18:21:43'),
(156, 111, 108, 338, 1, 43, '2020-09-03 18:22:09', '2020-09-03 18:22:09'),
(157, 128, 100, 339, 1, 43, '2020-09-03 18:26:37', '2020-09-03 18:26:37'),
(158, 128, 103, 340, 1, 43, '2020-09-03 18:27:55', '2020-09-03 18:27:55'),
(159, 111, 103, 341, 1, 43, '2020-09-03 18:28:14', '2020-09-03 18:28:14'),
(160, 128, 102, 342, 1, 43, '2020-09-03 18:29:34', '2020-09-03 18:29:34'),
(161, 111, 102, 343, 1, 43, '2020-09-03 18:30:00', '2020-09-03 18:30:00'),
(162, 128, 104, 344, 1, 43, '2020-09-03 18:31:24', '2020-09-03 18:31:24'),
(163, 128, 109, 345, 1, 43, '2020-09-03 18:34:42', '2020-09-03 18:34:42'),
(164, 111, 109, 346, 1, 43, '2020-09-03 18:35:05', '2020-09-03 18:35:05'),
(165, 128, 110, 347, 1, 43, '2020-09-03 18:36:44', '2020-09-03 18:36:44'),
(166, 128, 111, 348, 1, 43, '2020-09-03 18:38:34', '2020-09-03 18:38:34'),
(167, 128, 125, 349, 1, 43, '2020-09-03 18:42:24', '2020-09-03 18:42:24'),
(168, 111, 125, 350, 1, 43, '2020-09-03 18:42:52', '2020-09-03 18:42:52'),
(169, 128, 115, 351, 1, 43, '2020-09-03 18:44:25', '2020-09-03 18:44:25'),
(170, 111, 115, 352, 1, 43, '2020-09-03 18:44:50', '2020-09-03 18:44:50'),
(171, 128, 119, 353, 1, 43, '2020-09-03 18:45:52', '2020-09-03 18:45:52'),
(172, 111, 119, 354, 1, 43, '2020-09-03 18:46:24', '2020-09-03 18:46:24'),
(173, 128, 118, 355, 1, 43, '2020-09-03 18:47:31', '2020-09-03 18:47:31'),
(174, 111, 118, 356, 1, 43, '2020-09-03 18:48:02', '2020-09-03 18:48:02'),
(175, 111, 116, 357, 1, 43, '2020-09-03 18:49:58', '2020-09-03 18:49:58'),
(176, 111, 116, 358, 1, 43, '2020-09-03 18:50:15', '2020-09-03 18:50:15'),
(177, 111, 120, 359, 1, 43, '2020-09-03 18:52:06', '2020-09-03 18:52:06'),
(178, 111, 120, 360, 1, 43, '2020-09-03 18:52:28', '2020-09-03 18:52:28'),
(179, 128, 99, 361, 1, 43, '2020-09-03 18:54:46', '2020-09-03 18:54:46'),
(180, 111, 99, 362, 1, 43, '2020-09-03 18:55:12', '2020-09-03 18:55:12'),
(181, 111, 122, 363, 1, 43, '2020-09-03 18:56:15', '2020-09-03 18:56:15'),
(182, 111, 122, 364, 1, 43, '2020-09-03 18:56:40', '2020-09-03 18:56:40'),
(183, 128, 123, 365, 1, 43, '2020-09-03 18:59:01', '2020-09-03 18:59:01'),
(184, 128, 124, 366, 1, 43, '2020-09-03 19:00:33', '2020-09-03 19:00:33'),
(185, 111, 124, 367, 1, 43, '2020-09-03 19:00:51', '2020-09-03 19:00:51'),
(186, 128, 127, 368, 1, 43, '2020-09-03 19:03:21', '2020-09-03 19:03:21'),
(187, 128, 128, 369, 1, 43, '2020-09-03 19:04:34', '2020-09-03 19:04:34'),
(188, 111, 128, 370, 1, 43, '2020-09-03 19:05:11', '2020-09-03 19:05:11'),
(189, 128, 129, 371, 1, 43, '2020-09-03 19:07:52', '2020-09-03 19:07:52'),
(190, 111, 129, 372, 1, 43, '2020-09-03 19:08:16', '2020-09-03 19:08:16'),
(191, 128, 131, 373, 1, 43, '2020-09-03 19:11:26', '2020-09-03 19:11:26'),
(192, 128, 132, 374, 1, 43, '2020-09-03 19:12:52', '2020-09-03 19:12:52'),
(193, 128, 132, 375, 1, 43, '2020-09-03 19:13:57', '2020-09-03 19:13:57'),
(194, 111, 143, 376, 1, 43, '2020-09-03 19:17:56', '2020-09-03 19:17:56'),
(195, 111, 135, 377, 1, 43, '2020-09-03 19:22:23', '2020-09-03 19:22:23'),
(196, 111, 135, 378, 1, 43, '2020-09-03 19:22:56', '2020-09-03 19:22:56'),
(197, 111, 136, 379, 1, 43, '2020-09-03 19:24:58', '2020-09-03 19:24:58'),
(198, 111, 251, 385, 1, 43, '2020-09-07 11:30:58', '2020-09-07 11:30:58'),
(199, 128, 251, 386, 1, 43, '2020-09-07 11:32:05', '2020-09-07 11:32:05'),
(200, 128, 251, 387, 1, 43, '2020-09-07 11:32:06', '2020-09-07 11:32:06'),
(201, 128, 232, 388, 1, 43, '2020-09-07 12:52:09', '2020-09-07 12:52:09'),
(202, 128, 229, 389, 1, 43, '2020-09-07 12:56:01', '2020-09-07 12:56:01'),
(203, 128, 227, 390, 1, 43, '2020-09-07 12:57:52', '2020-09-07 12:57:52'),
(204, 128, 222, 391, 1, 43, '2020-09-07 12:59:10', '2020-09-07 12:59:10'),
(205, 128, 230, 392, 1, 43, '2020-09-07 13:00:31', '2020-09-07 13:00:31'),
(206, 128, 228, 393, 1, 43, '2020-09-07 13:01:31', '2020-09-07 13:01:31'),
(207, 128, 220, 394, 1, 43, '2020-09-07 13:07:28', '2020-09-07 13:07:28'),
(208, 128, 224, 395, 1, 43, '2020-09-07 13:11:58', '2020-09-07 13:11:58'),
(209, 128, 179, 396, 1, 43, '2020-09-07 13:13:50', '2020-09-07 13:13:50'),
(210, 128, 225, 397, 1, 43, '2020-09-07 13:16:17', '2020-09-07 13:16:17'),
(211, 128, 226, 398, 1, 43, '2020-09-07 13:19:22', '2020-09-07 13:19:22'),
(212, 128, 237, 399, 1, 43, '2020-09-07 13:20:40', '2020-09-07 13:20:40'),
(213, 128, 237, 400, 1, 43, '2020-09-07 13:20:40', '2020-09-07 13:20:40'),
(214, 128, 236, 401, 1, 43, '2020-09-07 13:24:39', '2020-09-07 13:24:39'),
(215, 128, 235, 402, 1, 43, '2020-09-07 13:25:51', '2020-09-07 13:25:51'),
(216, 128, 235, 403, 1, 43, '2020-09-07 13:26:05', '2020-09-07 13:26:05'),
(217, 128, 234, 404, 1, 43, '2020-09-07 13:28:02', '2020-09-07 13:28:02'),
(218, 128, 183, 405, 1, 43, '2020-09-07 13:29:29', '2020-09-07 13:29:29'),
(219, 128, 233, 406, 1, 43, '2020-09-07 13:30:58', '2020-09-07 13:30:58'),
(220, 128, 186, 407, 1, 43, '2020-09-07 13:32:12', '2020-09-07 13:32:12'),
(221, 128, 180, 408, 1, 43, '2020-09-07 13:42:30', '2020-09-07 13:42:30'),
(222, 128, 157, 409, 1, 43, '2020-09-07 13:43:23', '2020-09-07 13:43:23'),
(223, 128, 187, 410, 1, 43, '2020-09-07 13:44:20', '2020-09-07 13:44:20'),
(224, 128, 167, 411, 1, 43, '2020-09-07 13:45:43', '2020-09-07 13:45:43'),
(225, 128, 260, 412, 1, 43, '2020-09-07 13:45:52', '2020-09-07 13:45:52'),
(226, 128, 240, 413, 1, 43, '2020-09-07 13:46:52', '2020-09-07 13:46:52'),
(227, 128, 242, 414, 1, 43, '2020-09-07 13:48:20', '2020-09-07 13:48:20'),
(228, 128, 169, 415, 1, 43, '2020-09-07 13:49:13', '2020-09-07 13:49:13'),
(229, 128, 244, 416, 1, 43, '2020-09-07 13:50:20', '2020-09-07 13:50:20'),
(230, 128, 193, 417, 1, 43, '2020-09-07 13:51:45', '2020-09-07 13:51:45'),
(231, 128, 163, 418, 1, 43, '2020-09-07 13:53:53', '2020-09-07 13:53:53'),
(232, 128, 165, 419, 1, 43, '2020-09-07 13:55:39', '2020-09-07 13:55:39'),
(233, 128, 158, 420, 1, 43, '2020-09-07 13:58:18', '2020-09-07 13:58:18'),
(234, 128, 168, 421, 1, 43, '2020-09-07 13:59:12', '2020-09-07 13:59:12'),
(235, 128, 259, 422, 1, 43, '2020-09-07 14:02:31', '2020-09-07 14:02:31'),
(236, 128, 245, 423, 1, 43, '2020-09-07 14:03:12', '2020-09-07 14:03:12'),
(237, 128, 245, 424, 1, 43, '2020-09-07 14:03:58', '2020-09-07 14:03:58'),
(238, 128, 257, 425, 1, 43, '2020-09-07 14:08:46', '2020-09-07 14:08:46'),
(239, 128, 245, 426, 1, 43, '2020-09-07 14:09:27', '2020-09-07 14:09:27'),
(240, 128, 241, 427, 1, 43, '2020-09-07 14:09:56', '2020-09-07 14:09:56'),
(241, 128, 246, 428, 1, 43, '2020-09-07 14:10:40', '2020-09-07 14:10:40'),
(242, 128, 255, 429, 1, 43, '2020-09-07 14:11:17', '2020-09-07 14:11:17'),
(243, 128, 189, 430, 1, 43, '2020-09-07 14:12:20', '2020-09-07 14:12:20'),
(244, 128, 239, 431, 1, 43, '2020-09-07 14:13:20', '2020-09-07 14:13:20'),
(245, 128, 190, 432, 1, 43, '2020-09-07 14:13:26', '2020-09-07 14:13:26'),
(246, 128, 217, 433, 1, 43, '2020-09-07 14:14:40', '2020-09-07 14:14:40'),
(247, 128, 173, 434, 1, 43, '2020-09-07 14:17:21', '2020-09-07 14:17:21'),
(248, 128, 192, 435, 1, 43, '2020-09-07 14:18:33', '2020-09-07 14:18:33'),
(249, 128, 174, 436, 1, 43, '2020-09-07 14:19:39', '2020-09-07 14:19:39'),
(250, 128, 219, 437, 1, 43, '2020-09-07 14:20:14', '2020-09-07 14:20:14'),
(251, 128, 174, 438, 1, 43, '2020-09-07 14:20:45', '2020-09-07 14:20:45'),
(252, 128, 214, 439, 1, 43, '2020-09-07 14:21:14', '2020-09-07 14:21:14'),
(253, 128, 175, 440, 1, 43, '2020-09-07 14:24:06', '2020-09-07 14:24:06'),
(254, 128, 238, 441, 1, 43, '2020-09-07 14:24:18', '2020-09-07 14:24:18'),
(255, 128, 215, 442, 1, 43, '2020-09-07 14:25:51', '2020-09-07 14:25:51'),
(256, 128, 160, 443, 1, 43, '2020-09-07 14:30:44', '2020-09-07 14:30:44'),
(257, 128, 249, 444, 1, 43, '2020-09-07 14:36:35', '2020-09-07 14:36:35'),
(258, 128, 248, 445, 1, 43, '2020-09-07 14:39:28', '2020-09-07 14:39:28'),
(259, 128, 159, 446, 1, 43, '2020-09-07 14:40:28', '2020-09-07 14:40:28'),
(260, 128, 250, 447, 1, 43, '2020-09-07 14:41:54', '2020-09-07 14:41:54'),
(261, 128, 161, 448, 1, 43, '2020-09-07 14:48:51', '2020-09-07 14:48:51'),
(262, 128, 162, 449, 1, 43, '2020-09-07 14:49:20', '2020-09-07 14:49:20'),
(263, 128, 152, 450, 1, 43, '2020-09-07 14:51:04', '2020-09-07 14:51:04'),
(264, 128, 144, 451, 1, 43, '2020-09-07 14:53:01', '2020-09-07 14:53:01'),
(265, 128, 134, 452, 1, 43, '2020-09-07 14:55:07', '2020-09-07 14:55:07'),
(266, 128, 148, 453, 1, 43, '2020-09-07 14:56:36', '2020-09-07 14:56:36'),
(267, 128, 130, 454, 1, 43, '2020-09-07 15:04:22', '2020-09-07 15:04:22'),
(268, 128, 147, 455, 1, 43, '2020-09-07 15:07:47', '2020-09-07 15:07:47'),
(269, 128, 130, 456, 1, 43, '2020-09-07 15:09:41', '2020-09-07 15:09:41'),
(270, 128, 142, 457, 1, 43, '2020-09-07 15:11:58', '2020-09-07 15:11:58'),
(271, 128, 145, 458, 1, 43, '2020-09-07 15:15:14', '2020-09-07 15:15:14'),
(272, 111, 10, 459, 1, 43, '2020-09-07 15:20:00', '2020-09-07 15:20:00'),
(273, 128, 10, 460, 1, 43, '2020-09-07 15:25:22', '2020-09-07 15:25:22'),
(274, 111, 14, 461, 1, 43, '2020-09-07 15:32:34', '2020-09-07 15:32:34'),
(275, 111, 13, 462, 1, 43, '2020-09-07 15:33:44', '2020-09-07 15:33:44'),
(276, 111, 23, 463, 1, 43, '2020-09-07 15:42:01', '2020-09-07 15:42:01'),
(277, 111, 259, 466, 1, 43, '2020-09-07 19:29:59', '2020-09-07 19:29:59'),
(278, 111, 257, 467, 1, 43, '2020-09-07 19:33:22', '2020-09-07 19:33:22'),
(279, 111, 256, 468, 1, 43, '2020-09-07 19:35:30', '2020-09-07 19:35:30'),
(280, 111, 254, 469, 1, 43, '2020-09-07 19:37:00', '2020-09-07 19:37:00'),
(281, 111, 255, 470, 1, 43, '2020-09-07 19:39:13', '2020-09-07 19:39:13'),
(282, 111, 258, 471, 1, 43, '2020-09-07 19:41:58', '2020-09-07 19:41:58'),
(283, 111, 252, 472, 1, 43, '2020-09-07 19:44:11', '2020-09-07 19:44:11'),
(284, 111, 244, 473, 1, 43, '2020-09-07 19:47:01', '2020-09-07 19:47:01'),
(285, 111, 239, 474, 1, 43, '2020-09-07 19:51:17', '2020-09-07 19:51:17'),
(286, 111, 239, 475, 1, 43, '2020-09-07 19:56:03', '2020-09-07 19:56:03'),
(287, 111, 245, 476, 1, 43, '2020-09-07 19:58:18', '2020-09-07 19:58:18'),
(288, 111, 246, 477, 1, 43, '2020-09-07 20:01:38', '2020-09-07 20:01:38'),
(289, 111, 247, 478, 1, 43, '2020-09-07 20:02:32', '2020-09-07 20:02:32'),
(290, 111, 250, 479, 1, 43, '2020-09-07 20:04:16', '2020-09-07 20:04:16'),
(291, 111, 249, 480, 1, 43, '2020-09-07 20:05:54', '2020-09-07 20:05:54'),
(292, 111, 248, 481, 1, 43, '2020-09-07 20:06:57', '2020-09-07 20:06:57'),
(293, 111, 238, 482, 1, 43, '2020-09-07 20:09:39', '2020-09-07 20:09:39'),
(294, 111, 240, 483, 1, 43, '2020-09-07 20:10:54', '2020-09-07 20:10:54'),
(295, 111, 241, 484, 1, 43, '2020-09-07 20:14:04', '2020-09-07 20:14:04'),
(296, 111, 237, 485, 1, 43, '2020-09-07 20:20:52', '2020-09-07 20:20:52'),
(297, 111, 236, 486, 1, 43, '2020-09-07 20:21:55', '2020-09-07 20:21:55'),
(298, 111, 235, 487, 1, 43, '2020-09-07 20:23:26', '2020-09-07 20:23:26'),
(299, 111, 234, 488, 1, 43, '2020-09-07 20:24:13', '2020-09-07 20:24:13'),
(300, 111, 225, 489, 1, 43, '2020-09-07 20:26:45', '2020-09-07 20:26:45'),
(301, 111, 231, 490, 1, 43, '2020-09-07 20:28:16', '2020-09-07 20:28:16'),
(302, 111, 230, 491, 1, 43, '2020-09-07 20:29:22', '2020-09-07 20:29:22'),
(303, 111, 227, 492, 1, 43, '2020-09-07 20:30:49', '2020-09-07 20:30:49'),
(304, 111, 228, 493, 1, 43, '2020-09-07 20:32:19', '2020-09-07 20:32:19'),
(305, 111, 226, 494, 1, 43, '2020-09-07 20:38:31', '2020-09-07 20:38:31'),
(306, 111, 223, 495, 1, 43, '2020-09-07 20:39:50', '2020-09-07 20:39:50'),
(307, 111, 224, 496, 1, 43, '2020-09-07 20:41:05', '2020-09-07 20:41:05'),
(308, 111, 221, 497, 1, 43, '2020-09-07 20:42:38', '2020-09-07 20:42:38'),
(309, 111, 220, 498, 1, 43, '2020-09-07 20:44:05', '2020-09-07 20:44:05'),
(310, 111, 222, 499, 1, 43, '2020-09-07 20:48:59', '2020-09-07 20:48:59'),
(311, 111, 186, 500, 1, 43, '2020-09-07 20:51:37', '2020-09-07 20:51:37'),
(312, 111, 184, 501, 1, 43, '2020-09-07 20:53:20', '2020-09-07 20:53:20'),
(313, 111, 182, 502, 1, 43, '2020-09-07 20:56:32', '2020-09-07 20:56:32'),
(314, 111, 179, 503, 1, 43, '2020-09-07 20:58:06', '2020-09-07 20:58:06'),
(315, 128, 181, 504, 1, 43, '2020-09-07 21:03:34', '2020-09-07 21:03:34'),
(316, 111, 219, 505, 1, 43, '2020-09-07 21:55:32', '2020-09-07 21:55:32'),
(317, 111, 218, 506, 1, 43, '2020-09-07 21:58:15', '2020-09-07 21:58:15'),
(318, 111, 216, 507, 1, 43, '2020-09-07 22:03:56', '2020-09-07 22:03:56'),
(319, 128, 216, 508, 1, 43, '2020-09-07 22:04:18', '2020-09-07 22:04:18'),
(320, 111, 215, 509, 1, 43, '2020-09-07 22:06:13', '2020-09-07 22:06:13'),
(321, 111, 214, 510, 1, 43, '2020-09-07 22:08:55', '2020-09-07 22:08:55'),
(322, 111, 213, 511, 1, 43, '2020-09-07 22:11:10', '2020-09-07 22:11:10'),
(323, 111, 212, 512, 1, 43, '2020-09-07 22:12:53', '2020-09-07 22:12:53'),
(324, 111, 211, 513, 1, 43, '2020-09-07 22:14:40', '2020-09-07 22:14:40'),
(325, 111, 210, 514, 1, 43, '2020-09-07 22:17:14', '2020-09-07 22:17:14'),
(326, 128, 209, 515, 1, 43, '2020-09-07 22:20:29', '2020-09-07 22:20:29'),
(327, 111, 195, 516, 1, 43, '2020-09-07 22:22:38', '2020-09-07 22:22:38'),
(328, 111, 208, 517, 1, 43, '2020-09-07 22:23:22', '2020-09-07 22:23:22'),
(329, 111, 207, 518, 1, 43, '2020-09-07 22:23:53', '2020-09-07 22:23:53'),
(330, 111, 206, 519, 1, 43, '2020-09-07 22:24:24', '2020-09-07 22:24:24'),
(331, 111, 201, 520, 1, 43, '2020-09-07 22:29:47', '2020-09-07 22:29:47'),
(332, 111, 199, 521, 1, 43, '2020-09-07 22:31:03', '2020-09-07 22:31:03'),
(333, 111, 197, 522, 1, 43, '2020-09-07 22:31:37', '2020-09-07 22:31:37'),
(334, 111, 196, 523, 1, 43, '2020-09-07 22:32:32', '2020-09-07 22:32:32'),
(335, 111, 187, 524, 1, 43, '2020-09-07 22:34:44', '2020-09-07 22:34:44'),
(336, 111, 191, 525, 1, 43, '2020-09-07 22:41:22', '2020-09-07 22:41:22'),
(337, 111, 190, 526, 1, 43, '2020-09-07 22:43:45', '2020-09-07 22:43:45'),
(338, 111, 190, 527, 1, 43, '2020-09-07 22:46:25', '2020-09-07 22:46:25'),
(339, 111, 193, 528, 1, 43, '2020-09-07 22:48:33', '2020-09-07 22:48:33'),
(340, 111, 192, 529, 1, 43, '2020-09-07 22:52:03', '2020-09-07 22:52:03'),
(341, 111, 157, 530, 1, 43, '2020-09-07 22:57:34', '2020-09-07 22:57:34'),
(342, 111, 156, 531, 1, 43, '2020-09-07 22:59:19', '2020-09-07 22:59:19'),
(343, 111, 158, 532, 1, 43, '2020-09-07 23:01:56', '2020-09-07 23:01:56'),
(344, 111, 159, 533, 1, 43, '2020-09-07 23:05:48', '2020-09-07 23:05:48'),
(345, 111, 20, 538, 1, 43, '2020-09-08 12:30:39', '2020-09-08 12:30:39'),
(346, 111, 25, 539, 1, 43, '2020-09-08 12:37:04', '2020-09-08 12:37:04'),
(347, 111, 18, 540, 1, 43, '2020-09-08 12:42:33', '2020-09-08 12:42:33'),
(348, 111, 29, 541, 1, 43, '2020-09-08 12:44:15', '2020-09-08 12:44:15'),
(349, 111, 32, 542, 1, 43, '2020-09-08 12:47:47', '2020-09-08 12:47:47'),
(350, 111, 8, 543, 1, 43, '2020-09-08 12:55:06', '2020-09-08 12:55:06'),
(351, 111, 47, 544, 1, 43, '2020-09-08 13:03:37', '2020-09-08 13:03:37'),
(352, 111, 34, 545, 1, 43, '2020-09-08 13:06:21', '2020-09-08 13:06:21'),
(353, 111, 34, 546, 1, 43, '2020-09-08 13:07:30', '2020-09-08 13:07:30'),
(354, 111, 34, 547, 1, 43, '2020-09-08 13:14:54', '2020-09-08 13:14:54'),
(355, 111, 45, 548, 1, 43, '2020-09-08 13:22:56', '2020-09-08 13:22:56'),
(356, 111, 38, 549, 1, 43, '2020-09-08 13:24:34', '2020-09-08 13:24:34'),
(357, 111, 162, 550, 1, 43, '2020-09-08 13:29:50', '2020-09-08 13:29:50'),
(358, 111, 34, 551, 1, 43, '2020-09-08 13:39:33', '2020-09-08 13:39:33'),
(359, 111, 3, 552, 1, 43, '2020-09-08 13:47:33', '2020-09-08 13:47:33'),
(360, 111, 4, 553, 1, 43, '2020-09-08 13:53:10', '2020-09-08 13:53:10'),
(361, 111, 52, 554, 1, 43, '2020-09-08 14:06:03', '2020-09-08 14:06:03'),
(362, 111, 50, 555, 1, 43, '2020-09-08 14:08:17', '2020-09-08 14:08:17'),
(363, 111, 60, 556, 1, 43, '2020-09-08 14:15:58', '2020-09-08 14:15:58'),
(364, 111, 66, 557, 1, 43, '2020-09-08 14:21:53', '2020-09-08 14:21:53'),
(365, 128, 252, 558, 1, 43, '2020-09-08 14:54:15', '2020-09-08 14:54:15'),
(366, 111, 163, 559, 1, 43, '2020-09-08 15:22:03', '2020-09-08 15:22:03'),
(367, 111, 167, 560, 1, 43, '2020-09-08 15:23:19', '2020-09-08 15:23:19'),
(368, 111, 165, 561, 1, 43, '2020-09-08 15:27:32', '2020-09-08 15:27:32'),
(369, 111, 171, 562, 1, 43, '2020-09-08 15:29:36', '2020-09-08 15:29:36'),
(370, 111, 173, 563, 1, 43, '2020-09-08 15:35:52', '2020-09-08 15:35:52'),
(371, 111, 175, 564, 1, 43, '2020-09-08 15:38:07', '2020-09-08 15:38:07'),
(372, 111, 174, 565, 1, 43, '2020-09-08 15:44:36', '2020-09-08 15:44:36'),
(373, 111, 174, 566, 1, 43, '2020-09-08 15:45:33', '2020-09-08 15:45:33'),
(374, 111, 174, 567, 1, 43, '2020-09-08 15:47:05', '2020-09-08 15:47:05'),
(375, 111, 170, 568, 1, 43, '2020-09-08 15:49:03', '2020-09-08 15:49:03'),
(376, 111, 178, 569, 1, 43, '2020-09-08 15:50:18', '2020-09-08 15:50:18'),
(377, 111, 177, 570, 1, 43, '2020-09-08 15:55:00', '2020-09-08 15:55:00'),
(378, 111, 75, 571, 1, 43, '2020-09-08 19:07:40', '2020-09-08 19:07:40'),
(379, 111, 82, 572, 1, 43, '2020-09-08 19:10:12', '2020-09-08 19:10:12'),
(380, 111, 83, 573, 1, 43, '2020-09-08 19:12:27', '2020-09-08 19:12:27'),
(381, 111, 83, 574, 1, 43, '2020-09-08 19:12:58', '2020-09-08 19:12:58'),
(382, 111, 84, 575, 1, 43, '2020-09-08 19:15:08', '2020-09-08 19:15:08'),
(383, 111, 89, 576, 1, 43, '2020-09-08 19:19:06', '2020-09-08 19:19:06'),
(384, 111, 90, 577, 1, 43, '2020-09-08 19:20:02', '2020-09-08 19:20:02'),
(385, 111, 151, 578, 1, 43, '2020-09-08 19:30:53', '2020-09-08 19:30:53'),
(386, 111, 114, 579, 1, 43, '2020-09-08 19:35:19', '2020-09-08 19:35:19'),
(387, 111, 94, 580, 1, 43, '2020-09-08 19:40:05', '2020-09-08 19:40:05'),
(388, 111, 95, 581, 1, 43, '2020-09-08 19:42:29', '2020-09-08 19:42:29'),
(389, 111, 112, 582, 1, 43, '2020-09-08 19:46:31', '2020-09-08 19:46:31'),
(390, 111, 113, 583, 1, 43, '2020-09-08 19:48:17', '2020-09-08 19:48:17'),
(391, 111, 97, 584, 1, 43, '2020-09-08 19:51:17', '2020-09-08 19:51:17'),
(392, 111, 108, 585, 1, 43, '2020-09-08 19:52:51', '2020-09-08 19:52:51'),
(393, 111, 101, 586, 1, 43, '2020-09-08 19:54:03', '2020-09-08 19:54:03'),
(394, 111, 117, 587, 1, 43, '2020-09-08 19:57:14', '2020-09-08 19:57:14'),
(395, 111, 123, 588, 1, 43, '2020-09-08 20:01:37', '2020-09-08 20:01:37'),
(396, 111, 104, 589, 1, 43, '2020-09-08 20:11:05', '2020-09-08 20:11:05'),
(397, 111, 140, 590, 1, 43, '2020-09-08 20:24:44', '2020-09-08 20:24:44'),
(398, 111, 139, 591, 1, 43, '2020-09-08 20:26:01', '2020-09-08 20:26:01'),
(399, 111, 143, 592, 1, 43, '2020-09-08 20:36:23', '2020-09-08 20:36:23'),
(400, 111, 143, 593, 1, 43, '2020-09-08 20:36:48', '2020-09-08 20:36:48'),
(401, 111, 130, 594, 1, 43, '2020-09-08 20:41:51', '2020-09-08 20:41:51'),
(402, 111, 153, 595, 1, 43, '2020-09-08 20:45:50', '2020-09-08 20:45:50'),
(403, 111, 153, 596, 1, 43, '2020-09-08 20:50:09', '2020-09-08 20:50:09'),
(404, 111, 152, 597, 1, 43, '2020-09-08 20:51:52', '2020-09-08 20:51:52'),
(405, 111, 148, 598, 1, 43, '2020-09-08 20:55:38', '2020-09-08 20:55:38'),
(406, 111, 145, 599, 1, 43, '2020-09-08 20:57:51', '2020-09-08 20:57:51'),
(407, 111, 144, 600, 1, 43, '2020-09-08 20:59:21', '2020-09-08 20:59:21'),
(408, 111, 142, 601, 1, 43, '2020-09-08 21:02:16', '2020-09-08 21:02:16'),
(409, 111, 142, 602, 1, 43, '2020-09-08 21:03:50', '2020-09-08 21:03:50'),
(410, 111, 136, 603, 1, 43, '2020-09-08 21:06:45', '2020-09-08 21:06:45'),
(411, 111, 138, 604, 1, 43, '2020-09-08 21:09:21', '2020-09-08 21:09:21'),
(412, 111, 134, 605, 1, 43, '2020-09-08 21:11:19', '2020-09-08 21:11:19'),
(413, 111, 143, 606, 1, 43, '2020-09-08 21:22:16', '2020-09-08 21:22:16'),
(414, 111, 137, 607, 1, 43, '2020-09-08 21:23:05', '2020-09-08 21:23:05'),
(415, 111, 151, 608, 1, 43, '2020-09-08 21:23:47', '2020-09-08 21:23:47'),
(416, 111, 203, 609, 1, 43, '2020-09-08 21:27:11', '2020-09-08 21:27:11'),
(417, 111, 204, 610, 1, 43, '2020-09-08 21:29:26', '2020-09-08 21:29:26'),
(418, 111, 27, 611, 1, 43, '2020-09-08 21:34:23', '2020-09-08 21:34:23'),
(419, 128, 146, 613, 1, 43, '2020-09-09 11:26:06', '2020-09-09 11:26:06'),
(420, 128, 59, 614, 1, 43, '2020-09-09 11:28:51', '2020-09-09 11:28:51'),
(421, 128, 210, 615, 1, 43, '2020-09-09 11:32:40', '2020-09-09 11:32:40'),
(422, 128, 164, 616, 1, 43, '2020-09-09 11:33:12', '2020-09-09 11:33:12'),
(423, 128, 112, 617, 1, 43, '2020-09-09 11:34:00', '2020-09-09 11:34:00'),
(424, 128, 204, 618, 1, 43, '2020-09-09 11:37:39', '2020-09-09 11:37:39'),
(425, 128, 20, 619, 1, 43, '2020-09-09 11:41:20', '2020-09-09 11:41:20'),
(426, 111, 146, 620, 1, 43, '2020-09-09 11:49:44', '2020-09-09 11:49:44'),
(427, 111, 57, 621, 1, 43, '2020-09-09 11:56:33', '2020-09-09 11:56:33'),
(428, 111, 198, 622, 1, 43, '2020-09-09 12:30:15', '2020-09-09 12:30:15'),
(429, 128, 198, 623, 1, 43, '2020-09-09 12:32:52', '2020-09-09 12:32:52'),
(430, 111, 202, 624, 1, 43, '2020-09-09 12:36:27', '2020-09-09 12:36:27'),
(431, 111, 202, 625, 1, 43, '2020-09-09 12:45:17', '2020-09-09 12:45:17'),
(432, 111, 200, 626, 1, 43, '2020-09-09 12:49:18', '2020-09-09 12:49:18'),
(433, 111, 205, 627, 1, 43, '2020-09-09 13:13:08', '2020-09-09 13:13:08'),
(434, 128, 207, 628, 1, 43, '2020-09-09 13:28:40', '2020-09-09 13:28:40'),
(435, 111, 176, 629, 1, 43, '2020-09-09 14:35:36', '2020-09-09 14:35:36'),
(436, 111, 172, 630, 1, 43, '2020-09-09 14:39:49', '2020-09-09 14:39:49'),
(437, 111, 169, 631, 1, 43, '2020-09-09 14:56:21', '2020-09-09 14:56:21'),
(438, 111, 217, 632, 1, 43, '2020-09-10 12:32:06', '2020-09-10 12:32:06'),
(439, 128, 217, 633, 1, 43, '2020-09-10 12:49:22', '2020-09-10 12:49:22'),
(440, 128, 213, 634, 1, 43, '2020-09-10 12:55:22', '2020-09-10 12:55:22'),
(441, 128, 211, 635, 1, 43, '2020-09-10 13:00:39', '2020-09-10 13:00:39'),
(442, 128, 212, 636, 1, 43, '2020-09-10 14:12:19', '2020-09-10 14:12:19'),
(443, 128, 218, 637, 1, 43, '2020-09-10 14:13:32', '2020-09-10 14:13:32'),
(444, 111, 209, 638, 1, 43, '2020-09-10 14:14:57', '2020-09-10 14:14:57'),
(445, 111, 217, 639, 1, 43, '2020-09-10 14:29:04', '2020-09-10 14:29:04'),
(446, 111, 212, 640, 1, 43, '2020-09-10 14:59:32', '2020-09-10 14:59:32'),
(447, 129, 10, 641, 1, 43, '2020-09-10 15:05:20', '2020-09-10 15:05:20'),
(448, 129, 11, 642, 1, 43, '2020-09-10 15:09:22', '2020-09-10 15:09:22'),
(449, 128, 137, 643, 1, 43, '2020-09-10 20:07:23', '2020-09-10 20:07:23');

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

--
-- Table structure for table `user_statuses`
--

CREATE TABLE `user_statuses` (
  `id` int(12) NOT NULL,
  `name` varchar(255) NOT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_statuses`
--

INSERT INTO `user_statuses` (`id`, `name`, `deleted`) VALUES
(1, 'Active', 0),
(2, 'Inactive', 0);

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

--
-- Table structure for table `vision_mission_values`
--

CREATE TABLE `vision_mission_values` (
  `id` int(11) NOT NULL,
  `company_id` int(8) DEFAULT NULL,
  `vision` text,
  `mission` text,
  `core_values` text,
  `philosophy` text,
  `status` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `whistle_categories`
--

CREATE TABLE `whistle_categories` (
  `id` int(11) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whistle_categories`
--

INSERT INTO `whistle_categories` (`id`, `category`, `company_id`, `created`, `modified`) VALUES
(5, 'Theft', 43, '2020-06-03 09:06:15', '2020-06-03 09:06:46');

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

--
-- Table structure for table `whistle_configs`
--

CREATE TABLE `whistle_configs` (
  `id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `whistle_instructions`
--

CREATE TABLE `whistle_instructions` (
  `id` int(8) NOT NULL,
  `instructions` text,
  `terms_and_conditions_msg` text,
  `company_id` int(8) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `whistle_messages`
--

CREATE TABLE `whistle_messages` (
  `id` int(11) NOT NULL,
  `activity` varchar(255) DEFAULT NULL,
  `message` text,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whistle_messages`
--

INSERT INTO `whistle_messages` (`id`, `activity`, `message`, `company_id`, `created`) VALUES
(2, 'Theft', 'A new whistle blower from anonymouse: \n Activity: Theft \n Message: Test 1111', 43, '2020-06-03 09:07:23');

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

--
-- Table structure for table `whistle_receivers`
--

CREATE TABLE `whistle_receivers` (
  `id` int(11) NOT NULL,
  `receiver_id` int(11) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whistle_receivers`
--

INSERT INTO `whistle_receivers` (`id`, `receiver_id`, `cat_id`, `company_id`, `created`, `modified`) VALUES
(11, 699, 5, 43, '2020-06-03 09:06:28', '2020-06-03 09:06:28');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `address`
--
ALTER TABLE `address`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_id` (`customer_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `helpdesk_actionlog`
--
ALTER TABLE `helpdesk_actionlog`
  ADD PRIMARY KEY (`act_id`);

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

--
-- Indexes for table `helpdesk_jobpriority`
--
ALTER TABLE `helpdesk_jobpriority`
  ADD PRIMARY KEY (`pri_id`);

--
-- Indexes for table `helpdesk_jobs`
--
ALTER TABLE `helpdesk_jobs`
  ADD PRIMARY KEY (`job_id`);

--
-- Indexes for table `helpdesk_jobstatus`
--
ALTER TABLE `helpdesk_jobstatus`
  ADD PRIMARY KEY (`sta_id`);

--
-- Indexes for table `helpdesk_jobtype`
--
ALTER TABLE `helpdesk_jobtype`
  ADD PRIMARY KEY (`typ_id`);

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

--
-- Indexes for table `helpdesk_units`
--
ALTER TABLE `helpdesk_units`
  ADD PRIMARY KEY (`uni_id`);

--
-- Indexes for table `helpdesk_zones`
--
ALTER TABLE `helpdesk_zones`
  ADD PRIMARY KEY (`zon_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `PK_jobs` (`id`);

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `PK_messages` (`id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `users_family`
--
ALTER TABLE `users_family`
  ADD PRIMARY KEY (`id`,`user_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `application_links`
--
ALTER TABLE `application_links`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `app_list`
--
ALTER TABLE `app_list`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `branch_criterias`
--
ALTER TABLE `branch_criterias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `call_centre_contact_sources`
--
ALTER TABLE `call_centre_contact_sources`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `cash_retirements`
--
ALTER TABLE `cash_retirements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `commerce`
--
ALTER TABLE `commerce`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `commerce_items`
--
ALTER TABLE `commerce_items`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `currency`
--
ALTER TABLE `currency`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT for table `currency_archive`
--
ALTER TABLE `currency_archive`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `helpdesk_actionlog`
--
ALTER TABLE `helpdesk_actionlog`
  MODIFY `act_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `helpdesk_comments`
--
ALTER TABLE `helpdesk_comments`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `helpdesk_jobpriority`
--
ALTER TABLE `helpdesk_jobpriority`
  MODIFY `pri_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `helpdesk_jobs`
--
ALTER TABLE `helpdesk_jobs`
  MODIFY `job_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10685;

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

--
-- AUTO_INCREMENT for table `helpdesk_jobtype`
--
ALTER TABLE `helpdesk_jobtype`
  MODIFY `typ_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=225;

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

--
-- AUTO_INCREMENT for table `helpdesk_units`
--
ALTER TABLE `helpdesk_units`
  MODIFY `uni_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `helpdesk_zones`
--
ALTER TABLE `helpdesk_zones`
  MODIFY `zon_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `hrms_allowances_deductions`
--
ALTER TABLE `hrms_allowances_deductions`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `hrms_monthly_payroll`
--
ALTER TABLE `hrms_monthly_payroll`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `ics_survey_data`
--
ALTER TABLE `ics_survey_data`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27579;

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

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

--
-- AUTO_INCREMENT for table `instruments`
--
ALTER TABLE `instruments`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `modules`
--
ALTER TABLE `modules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `module_categories`
--
ALTER TABLE `module_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `reimbursibles`
--
ALTER TABLE `reimbursibles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `reimbursible_comments`
--
ALTER TABLE `reimbursible_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `requisition_process_flow_stages`
--
ALTER TABLE `requisition_process_flow_stages`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `users_education`
--
ALTER TABLE `users_education`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `users_family`
--
ALTER TABLE `users_family`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `users_language`
--
ALTER TABLE `users_language`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `users_other_training`
--
ALTER TABLE `users_other_training`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `users_profession`
--
ALTER TABLE `users_profession`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `whistle_receivers`
--
ALTER TABLE `whistle_receivers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

