-- phpMyAdmin SQL Dump
-- version 4.8.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 20, 2023 at 10:10 PM
-- Server version: 10.1.34-MariaDB
-- PHP Version: 7.2.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `eazzeyberp`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` bigint(20) NOT NULL,
  `en_account_name` varchar(500) NOT NULL,
  `account_no` varchar(300) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `accounts_group_id` bigint(20) NOT NULL,
  `en_account_desc` varchar(500) DEFAULT NULL,
  `allow_over_drafts` tinyint(1) NOT NULL,
  `account_balance` double NOT NULL,
  `accounts_class_id` bigint(20) NOT NULL,
  `is_cash_account` tinyint(1) NOT NULL,
  `is_deletable` tinyint(1) NOT NULL,
  `is_editable` tinyint(1) NOT NULL,
  `is_operational_account` tinyint(1) NOT NULL,
  `is_reconcilable` tinyint(1) NOT NULL,
  `accounts_subgroup_id` bigint(20) DEFAULT NULL,
  `narration` varchar(3000) DEFAULT NULL,
  `currency_id` bigint(20) NOT NULL,
  `created_by_id` int(11) NOT NULL,
  `code_name` varchar(500) NOT NULL,
  `is_closed` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `en_account_name`, `account_no`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `accounts_group_id`, `en_account_desc`, `allow_over_drafts`, `account_balance`, `accounts_class_id`, `is_cash_account`, `is_deletable`, `is_editable`, `is_operational_account`, `is_reconcilable`, `accounts_subgroup_id`, `narration`, `currency_id`, `created_by_id`, `code_name`, `is_closed`) VALUES
(1, 'Cash At Hand', '000001', 0, '2022-09-29 11:02:31.584992', 1, '2022-09-29 11:02:27.000000', 2, NULL, 0, 2000000, 1, 1, 0, 1, 0, 1, 1, NULL, 1, 1, 'cash', 0),
(2, 'Capital /Equity', '000002', 0, '2022-09-29 11:05:59.276951', 1, '2022-09-29 11:05:51.000000', 3, NULL, 0, 2000000, 2, 0, 0, 0, 0, 0, NULL, NULL, 1, 1, 'capital', 0),
(3, 'Motor Vehicles', '000003', 0, '2022-09-29 11:08:41.759224', 1, '2022-09-29 11:08:40.000000', 1, NULL, 0, 0, 1, 0, 0, 0, 0, 0, 5, NULL, 1, 1, 'motor_vehicles', 0),
(4, 'Purchase/Supplies', '000004', 0, '2022-09-29 11:24:45.220632', 1, '2022-09-29 11:24:44.000000', 6, NULL, 0, 0, 4, 0, 0, 1, 0, 0, NULL, NULL, 1, 1, 'purchases', 0),
(5, 'Drawings', '000005', 0, '2022-09-29 11:27:10.602300', 1, '2022-09-29 11:27:09.000000', 3, NULL, 0, 0, 2, 0, 0, 0, 0, 0, NULL, NULL, 1, 1, 'drawings', 0),
(6, 'Accounts payables', '000006', 0, '2022-09-29 11:28:21.591097', 1, '2022-09-29 11:28:20.000000', 5, NULL, 0, 0, 7, 0, 0, 0, 0, 0, 7, NULL, 1, 1, 'accounts_payable', 0),
(7, 'Electricity', '000007', 0, '2022-09-29 11:38:34.336606', 1, '2022-09-29 11:38:32.000000', 6, NULL, 0, 0, 4, 0, 0, 0, 0, 0, 10, NULL, 1, 1, 'electric', 0),
(8, 'Accounts Receivable', '000010', 0, '2022-10-22 15:33:34.020050', 1, '2022-10-22 15:33:31.000000', 2, NULL, 0, 0, 1, 0, 0, 0, 0, 0, 2, NULL, 1, 1, 'accounts_recievable', 0),
(9, 'Sales', '000011', 0, '2022-10-22 15:36:14.486844', 1, '2022-10-22 15:36:11.000000', 8, NULL, 0, 0, 3, 0, 0, 1, 0, 0, 12, NULL, 1, 1, 'sales', 0),
(10, 'Postage & Telephone', '000012', 0, '2022-10-22 15:40:09.634944', 1, '2022-10-22 15:39:55.000000', 6, 'Postage', 0, 0, 4, 0, 0, 0, 0, 0, 10, NULL, 1, 1, 'postage_and_telephone', 0),
(11, 'Stationery', '000012', 0, '2022-10-22 15:44:10.559790', 1, '2022-10-22 15:44:08.000000', 6, NULL, 0, 0, 4, 0, 0, 0, 0, 0, 10, NULL, 1, 1, 'stationery', 0),
(12, 'Salaries', '000013', 0, '2022-10-22 15:45:37.035653', 1, '2022-10-22 15:45:13.000000', 7, NULL, 0, 0, 4, 0, 0, 0, 0, 0, 10, NULL, 1, 1, 'salaries', 0),
(13, 'Taxes Payable', '000013', 0, '2022-10-22 21:50:51.161793', 1, '2022-10-22 21:50:33.000000', 5, NULL, 0, 0, 7, 0, 0, 0, 0, 0, NULL, NULL, 1, 1, 'taxes_payable', 0),
(14, 'Cost Of Goods Sold', '000014', 0, '2022-10-23 08:16:02.118900', 1, '2022-10-23 08:15:50.000000', 6, NULL, 0, 0, 4, 0, 0, 1, 0, 0, NULL, NULL, 1, 1, 'cost_of_goods_sold', 0),
(15, 'Inventory Asset', '000014', 0, '2022-10-23 11:03:28.009768', 1, '2022-10-23 11:02:46.000000', 2, NULL, 0, 0, 1, 0, 0, 1, 0, 0, 3, NULL, 1, 1, 'inventory', 0),
(17, 'Discount recieved', '000015', 0, '2022-11-01 20:56:54.405394', 1, '2022-11-01 20:56:51.000000', 9, NULL, 0, 0, 3, 0, 1, 1, 0, 0, 13, NULL, 1, 1, 'discounts_recieved', 0),
(18, 'Carriage In Inwards', '000016', 0, '2022-11-01 21:00:19.221465', 1, '2022-11-01 21:00:06.000000', 7, NULL, 0, 0, 4, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'carriage_in_wards', 0),
(19, 'Discount allowed', '000017', 0, '2022-11-01 21:02:41.800451', 0, '2022-11-01 21:02:39.000000', 6, NULL, 0, 0, 4, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'discount_allowed', 0),
(20, 'Bad Debts', '000018', 0, '2022-11-01 21:05:43.791641', 1, '2022-11-01 21:05:26.000000', 7, NULL, 0, 0, 4, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'bad_debts', 0),
(21, 'Wadges', '000019', 0, '2022-11-01 21:07:45.796289', 1, '2022-11-01 21:07:41.000000', 6, NULL, 0, 0, 4, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'wadges', 0),
(22, 'Depreciation Of Machinery', '000020', 0, '2022-11-01 21:18:04.057168', 1, '2022-11-01 21:17:51.000000', 7, NULL, 0, 0, 4, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'depreciation_of_machinery', 0),
(23, 'Accrued Rent and rates', '000021', 0, '2022-11-01 21:50:18.184030', 1, '2022-11-01 21:50:13.000000', 5, NULL, 0, 0, 7, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'accrued_rent_and_rates', 0),
(24, 'Purchase returns (Return Outwards)', '000022', 0, '2022-11-01 22:14:22.114698', 1, '2022-11-01 22:14:14.000000', 8, NULL, 0, 0, 3, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'return_outwards', 0),
(25, 'Sales returns (Return Inwards)', '000023', 0, '2022-11-01 22:16:06.039007', 1, '2022-11-01 22:15:56.000000', 6, NULL, 0, 0, 4, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'return_inwards', 0),
(26, 'Rent & Rates', '000027', 0, '2022-11-03 22:17:15.921655', 0, '2022-11-03 22:17:11.000000', 6, NULL, 0, 0, 4, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'rent_and_rates', 0),
(27, 'Prepaid Expenses', '000028', 0, '2022-11-03 22:19:19.559698', 1, '2022-11-03 22:19:07.000000', 2, NULL, 0, 0, 1, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'prepaid_expenses', 0),
(28, 'Insurance', '000029', 0, '2022-11-03 22:21:02.828175', 1, '2022-11-03 22:20:48.000000', 6, NULL, 0, 0, 4, 0, 1, 1, 0, 0, NULL, NULL, 1, 1, 'insurance', 0);

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

--
-- Table structure for table `accounts_classes`
--

CREATE TABLE `accounts_classes` (
  `id` bigint(20) NOT NULL,
  `en_class_name` varchar(500) NOT NULL,
  `code_name` varchar(300) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `accout_fomular_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts_classes`
--

INSERT INTO `accounts_classes` (`id`, `en_class_name`, `code_name`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `accout_fomular_id`) VALUES
(1, 'Assets', 'assets', 0, '2022-09-29 07:54:32.895133', 1, '2022-09-29 07:54:27.000000', 1),
(2, 'Equity (Capital)', 'equity', 0, '2022-09-29 07:55:28.881998', 1, '2022-09-29 07:55:20.000000', 2),
(3, 'Incomes/ Revenue', 'revenue', 0, '2022-09-29 07:55:50.659242', 1, '2022-09-29 07:55:49.000000', 2),
(4, 'Expenses', 'expenses', 0, '2022-09-29 07:56:22.339516', 1, '2022-09-29 07:56:21.000000', 1),
(7, 'Liabilities', 'liabilities', 0, '2022-11-01 11:31:04.746564', 1, '2022-11-01 11:31:02.000000', 2);

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

--
-- Table structure for table `accounts_fomular`
--

CREATE TABLE `accounts_fomular` (
  `id` bigint(20) NOT NULL,
  `fomular_name` varchar(500) NOT NULL,
  `code_name` varchar(300) NOT NULL,
  `increasing` varchar(500) NOT NULL,
  `decreasing` varchar(500) NOT NULL,
  `fomular_desc` varchar(3000) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts_fomular`
--

INSERT INTO `accounts_fomular` (`id`, `fomular_name`, `code_name`, `increasing`, `decreasing`, `fomular_desc`, `is_disabled`, `created`, `has_been_modified`, `last_modified`) VALUES
(1, 'ADEx (Dr)', 'ADEX', 'D', 'C', 'Assets, Dividends, and  Expenses', 0, '2022-09-29 07:48:42.184966', 1, '2022-09-29 07:48:29.000000'),
(2, 'LER (Cr)', 'LER', 'C', 'D', 'Liabilities, Capital and Revenue', 0, '2022-09-29 07:51:00.333405', 1, '2022-09-29 07:50:59.000000');

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

--
-- Table structure for table `accounts_groups`
--

CREATE TABLE `accounts_groups` (
  `id` bigint(20) NOT NULL,
  `en_group_name` varchar(500) NOT NULL,
  `code_name` varchar(300) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `accounts_class_id` bigint(20) NOT NULL,
  `en_class_desc` varchar(3000) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL,
  `sort_value` int(11) NOT NULL,
  `created_by_id` int(11) NOT NULL,
  `is_deletable` tinyint(1) NOT NULL,
  `is_editable` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts_groups`
--

INSERT INTO `accounts_groups` (`id`, `en_group_name`, `code_name`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `accounts_class_id`, `en_class_desc`, `is_default`, `sort_value`, `created_by_id`, `is_deletable`, `is_editable`) VALUES
(1, 'Fixed Assets', 'fixed_assets', 0, '2022-09-29 07:59:53.813705', 1, '2022-09-29 07:59:38.000000', 1, NULL, 0, 2, 1, 1, 1),
(2, 'Current Assets', 'current_assets', 0, '2022-09-29 08:00:25.775588', 1, '2022-09-29 08:00:24.000000', 1, NULL, 0, 1, 1, 1, 1),
(3, 'Capital (Equity)', 'capital', 0, '2022-09-29 08:02:34.645300', 1, '2022-09-29 08:02:28.000000', 2, NULL, 0, 3, 1, 1, 1),
(4, 'Long Term Liabilities', 'long_term_liabilities', 0, '2022-09-29 08:03:13.753217', 1, '2022-09-29 08:03:12.000000', 7, NULL, 0, 4, 1, 1, 1),
(5, 'Current Liabilities', 'current_liabilities', 0, '2022-09-29 08:03:44.992145', 1, '2022-09-29 08:03:41.000000', 7, NULL, 0, 5, 1, 1, 1),
(6, 'Direct Expenses', 'direct_expenses', 0, '2022-09-29 08:05:18.311863', 1, '2022-09-29 08:05:17.000000', 4, NULL, 0, 6, 1, 1, 1),
(7, 'Indirect Expenses', 'indirect_expenses', 0, '2022-09-29 08:05:46.738943', 1, '2022-09-29 08:05:41.000000', 4, NULL, 0, 7, 1, 1, 1),
(8, 'Direct Incomes', 'direct_incomes', 0, '2022-09-29 08:06:29.644357', 1, '2022-09-29 08:06:28.000000', 3, NULL, 0, 8, 1, 1, 1),
(9, 'Indirect Incomes', 'indirect_incomes', 0, '2022-09-29 08:07:30.808673', 1, '2022-09-29 08:07:29.000000', 3, NULL, 0, 9, 1, 1, 1),
(10, 'Cost Of Goods Sold', 'cost_of_goods_sold', 0, '2022-09-29 08:11:46.010296', 1, '2022-09-29 08:11:40.000000', 4, NULL, 0, 10, 1, 0, 0),
(11, 'Stock', 'stock', 0, '2022-11-01 08:25:55.961114', 1, '2022-11-01 08:24:16.000000', 1, NULL, 0, 11, 1, 0, 0),
(12, 'Taxes Out', 'taxes_out', 0, '2022-11-01 08:27:13.600181', 1, '2022-11-01 08:27:06.000000', 2, NULL, 0, 12, 1, 1, 1),
(13, 'Taxes In', 'taxes_in', 0, '2022-11-01 08:27:38.024047', 1, '2022-11-01 08:27:36.000000', 1, NULL, 0, 13, 1, 1, 1);

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

--
-- Table structure for table `accounts_ledger_entries`
--

CREATE TABLE `accounts_ledger_entries` (
  `id` bigint(20) NOT NULL,
  `ledger_no` varchar(200) DEFAULT NULL,
  `entry_type` varchar(1) NOT NULL,
  `amount` double NOT NULL,
  `narration` varchar(5000) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `is_deleted` tinyint(1) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `account_id_id` bigint(20) NOT NULL,
  `created_by_id` int(11) NOT NULL,
  `financial_year_id` bigint(20) NOT NULL,
  `is_adjusting_entry` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `accounts_settings`
--

CREATE TABLE `accounts_settings` (
  `id` bigint(20) NOT NULL,
  `en_account_setting_name` varchar(500) NOT NULL,
  `account_setting_codename` varchar(300) NOT NULL,
  `is_deletable` tinyint(1) NOT NULL,
  `let_me_choose` tinyint(1) NOT NULL,
  `is_editable` tinyint(1) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `account_id` bigint(20) NOT NULL,
  `sys_dpt_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts_settings`
--

INSERT INTO `accounts_settings` (`id`, `en_account_setting_name`, `account_setting_codename`, `is_deletable`, `let_me_choose`, `is_editable`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `account_id`, `sys_dpt_id`) VALUES
(2, 'Daily POS Sales', 'daily_pos_sales', 0, 0, 0, 0, '2022-10-07 19:56:21.258803', 1, '2022-10-07 19:54:36.000000', 2, 3),
(3, 'Inventory purchases', 'inventory_purchase', 0, 0, 0, 0, '2022-10-07 19:59:20.987399', 1, '2022-10-07 19:59:19.000000', 7, 6),
(4, 'Sales Daily VAT', 'sales_daily_vat', 0, 0, 0, 0, '2022-10-07 20:00:26.032869', 1, '2022-10-07 20:00:25.000000', 21, 3),
(5, 'Salary', 'salary', 0, 0, 0, 0, '2022-10-07 20:20:12.723247', 1, '2022-10-07 20:20:11.000000', 17, 5),
(6, 'Salary Advances', 'salary_advances', 0, 0, 0, 0, '2022-10-07 20:20:53.849613', 1, '2022-10-07 20:20:52.000000', 16, 5),
(7, 'Salary Allowances', 'salary_allowances', 0, 0, 0, 0, '2022-10-07 20:21:30.944958', 1, '2022-10-07 20:21:29.000000', 22, 5),
(8, 'Employer NSSF', 'employer_nssf', 0, 0, 0, 0, '2022-10-07 20:24:58.643956', 1, '2022-10-07 20:24:54.000000', 5, 5),
(9, 'Employee NSSF', 'employee_nssf', 0, 0, 0, 0, '2022-10-07 20:29:18.520496', 1, '2022-10-07 20:26:02.000000', 23, 5),
(10, 'Sales Discounts', 'sales_discounts', 0, 0, 0, 0, '2022-10-07 21:46:58.316795', 1, '2022-10-07 21:46:46.000000', 25, 3),
(11, 'Purchase Discounts', 'purchase_discounts', 0, 0, 0, 0, '2022-10-07 21:47:35.786951', 1, '2022-10-07 21:47:31.000000', 26, 6);

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

--
-- Table structure for table `accounts_subgroups`
--

CREATE TABLE `accounts_subgroups` (
  `id` bigint(20) NOT NULL,
  `en_group_name` varchar(500) NOT NULL,
  `sort_value` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `is_default` tinyint(1) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `accounts_group_id` bigint(20) NOT NULL,
  `accounts_class_id` bigint(20) NOT NULL,
  `account_group_no` varchar(300) NOT NULL,
  `is_deletable` tinyint(1) NOT NULL,
  `is_editable` tinyint(1) NOT NULL,
  `narration` varchar(3000) DEFAULT NULL,
  `created_by_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts_subgroups`
--

INSERT INTO `accounts_subgroups` (`id`, `en_group_name`, `sort_value`, `is_disabled`, `created`, `is_default`, `has_been_modified`, `last_modified`, `accounts_group_id`, `accounts_class_id`, `account_group_no`, `is_deletable`, `is_editable`, `narration`, `created_by_id`) VALUES
(1, 'Bank/Cash Accounts', 1, 0, '2022-09-29 08:31:21.496427', 0, 1, '2022-09-29 08:30:27.000000', 2, 1, '000001', 0, 0, NULL, 1),
(2, 'Accounts Receivables', 2, 0, '2022-09-29 08:33:39.370897', 0, 1, '2022-09-29 08:33:22.000000', 2, 1, '000002', 0, 0, NULL, 1),
(3, 'Stock', 3, 0, '2022-09-29 08:34:41.176657', 0, 1, '2022-09-29 08:34:40.000000', 2, 1, '000003', 0, 0, NULL, 1),
(4, 'Petty cash', 4, 0, '2022-09-29 08:35:37.173872', 0, 1, '2022-09-29 08:35:23.000000', 2, 1, '000004', 0, 0, NULL, 1),
(5, 'Tangible Assets', 5, 0, '2022-09-29 08:37:51.810447', 0, 1, '2022-09-29 08:37:06.000000', 1, 1, '000005', 0, 0, NULL, 1),
(6, 'Accumulated Depreciation', 6, 0, '2022-09-29 08:41:25.193334', 0, 1, '2022-09-29 08:38:14.000000', 1, 1, '000006', 0, 0, NULL, 1),
(7, 'Accounts Payable', 7, 0, '2022-09-29 08:48:36.464978', 0, 1, '2022-09-29 08:44:32.000000', 5, 2, '000007', 0, 0, NULL, 1),
(8, 'Asset Depreciation', 8, 0, '2022-09-29 08:51:19.835937', 0, 1, '2022-09-29 08:51:07.000000', 7, 4, '000008', 0, 0, NULL, 1),
(9, 'Intangible Assets', 9, 0, '2022-09-29 08:53:19.653307', 0, 1, '2022-09-29 08:53:18.000000', 1, 1, '000009', 0, 0, NULL, 1),
(10, 'Administrative Expenses', 10, 0, '2022-09-29 08:56:55.793472', 0, 1, '2022-09-29 08:56:51.000000', 6, 4, '000010', 0, 0, NULL, 1),
(11, 'Prepaid expenses', 11, 0, '2022-09-29 08:58:19.481450', 0, 1, '2022-09-29 08:58:18.000000', 2, 1, '000011', 0, 0, NULL, 1),
(12, 'Sales Revenue', 12, 0, '2022-09-29 08:59:09.732591', 0, 1, '2022-09-29 08:59:09.000000', 8, 3, '000012', 0, 0, NULL, 1),
(13, 'Other Revenues', 13, 0, '2022-09-29 09:00:21.963522', 0, 1, '2022-09-29 09:00:20.000000', 9, 3, '000013', 0, 0, NULL, 1);

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

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` int(11) NOT NULL,
  `asset_type_id` int(11) NOT NULL,
  `asset_name` varchar(255) DEFAULT NULL,
  `purchase_date` date NOT NULL,
  `purchase_price` float NOT NULL,
  `replacement_value` float DEFAULT NULL,
  `serial_number` varchar(255) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `description` varchar(5000) NOT NULL,
  `invoice_receipt` varchar(255) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `assets_categories`
--

CREATE TABLE `assets_categories` (
  `id` int(11) NOT NULL,
  `en_cat_name` varchar(300) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `assets_categories`
--

INSERT INTO `assets_categories` (`id`, `en_cat_name`, `code_name`, `is_disabled`, `created`) VALUES
(1, 'Current Assets', 'current_assets', 0, '2022-12-22 16:37:15'),
(2, 'Investments', 'investments', 0, '2022-12-22 16:37:15'),
(3, 'Fixed Assets', 'fixed_assets', 0, '2022-12-22 16:37:15'),
(4, 'Intangible Assets', 'intangible_assets', 0, '2022-12-22 16:37:15'),
(5, 'Other Assets', 'other_assets', 0, '2022-12-22 16:37:15');

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

--
-- Table structure for table `assets_types`
--

CREATE TABLE `assets_types` (
  `id` int(11) NOT NULL,
  `en_asset_type_name` varchar(355) NOT NULL,
  `asset_cat_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `assets_types`
--

INSERT INTO `assets_types` (`id`, `en_asset_type_name`, `asset_cat_id`, `is_disabled`, `created`) VALUES
(1, 'Equipments', 3, 0, '2022-12-29 11:14:33'),
(2, 'Furniture', 3, 0, '2022-12-29 11:14:33'),
(3, 'Land', 3, 0, '2022-12-29 11:14:33'),
(4, 'Machinery', 3, 0, '2022-12-29 11:14:33'),
(5, 'Receivables', 1, 0, '2022-12-29 11:14:33'),
(6, 'Building', 3, 0, '2022-12-29 11:14:33'),
(7, 'Cash', 1, 0, '2022-12-29 11:14:33'),
(8, 'Copyright', 4, 0, '2022-12-29 11:14:33'),
(9, 'Patents', 4, 0, '2022-12-29 11:14:33'),
(10, 'Trademark', 4, 0, '2022-12-29 11:14:33'),
(11, 'Bank Balance', 1, 0, '2022-12-29 11:14:33'),
(12, 'Brand', 4, 0, '2022-12-29 11:18:05');

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

--
-- Table structure for table `athousand_separators`
--

CREATE TABLE `athousand_separators` (
  `id` int(11) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `athousand_separators`
--

INSERT INTO `athousand_separators` (`id`, `display_name`, `code_name`, `is_disabled`, `created`) VALUES
(1, 'Comma(,)', ',', 0, '2022-12-08 20:15:21'),
(2, 'Dot(.)', '.', 1, '2022-12-08 20:15:21');

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

--
-- Table structure for table `cash_accounts_settings`
--

CREATE TABLE `cash_accounts_settings` (
  `id` bigint(20) NOT NULL,
  `en_account_setting_name` varchar(500) NOT NULL,
  `account_setting_codename` varchar(300) NOT NULL,
  `let_me_choose` tinyint(1) NOT NULL,
  `is_deletable` tinyint(1) NOT NULL,
  `is_editable` tinyint(1) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `account_id` bigint(20) NOT NULL,
  `payment_type_id` bigint(20) NOT NULL,
  `sys_dpt_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cash_accounts_settings`
--

INSERT INTO `cash_accounts_settings` (`id`, `en_account_setting_name`, `account_setting_codename`, `let_me_choose`, `is_deletable`, `is_editable`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `account_id`, `payment_type_id`, `sys_dpt_id`) VALUES
(2, 'Cash At Hand', 'cash_at_hand', 0, 0, 0, 0, '2022-10-07 19:07:54.674921', 1, '2022-10-07 19:05:42.000000', 8, 1, 4),
(3, 'Equity Bank', 'bank_account', 0, 0, 0, 0, '2022-10-07 19:08:49.481948', 1, '2022-10-07 19:08:46.000000', 6, 1, 4),
(4, 'MTN Mobile Money', 'mtn_mobile_money', 0, 0, 0, 0, '2022-10-07 19:10:47.315565', 1, '2022-10-07 19:10:42.000000', 9, 5, 4),
(5, 'Airtel Money', 'airtel_money', 0, 0, 0, 0, '2022-10-07 19:11:51.741921', 1, '2022-10-07 19:11:49.000000', 10, 4, 4);

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `client_name` varchar(300) NOT NULL,
  `contact_person_names` varchar(255) DEFAULT NULL,
  `contact_person_email` varchar(255) DEFAULT NULL,
  `contact_person_address` varchar(255) DEFAULT NULL,
  `client_phone_no` varchar(255) NOT NULL,
  `client_email` varchar(255) NOT NULL,
  `client_street_address` varchar(255) NOT NULL,
  `client_website` varchar(255) NOT NULL,
  `city` varchar(300) DEFAULT NULL,
  `state` varchar(300) DEFAULT NULL,
  `zip_code` varchar(300) DEFAULT NULL,
  `debt_limit` float DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `clock_actions`
--

CREATE TABLE `clock_actions` (
  `id` bigint(20) NOT NULL,
  `en_clock_action_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `clock_in_clock_out_history`
--

CREATE TABLE `clock_in_clock_out_history` (
  `id` bigint(20) NOT NULL,
  `clockin_time` time(6) DEFAULT NULL,
  `clockout_time` time(6) DEFAULT NULL,
  `has_clockin` tinyint(1) NOT NULL,
  `has_clockout` tinyint(1) NOT NULL,
  `clockedout_by` int(11) DEFAULT NULL,
  `clock_date` date NOT NULL,
  `created` datetime(6) NOT NULL,
  `clock_mode_id` bigint(20) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `clockout_date` date DEFAULT NULL,
  `is_cancelled` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clock_in_clock_out_history`
--

INSERT INTO `clock_in_clock_out_history` (`id`, `clockin_time`, `clockout_time`, `has_clockin`, `has_clockout`, `clockedout_by`, `clock_date`, `created`, `clock_mode_id`, `staff_id`, `clockout_date`, `is_cancelled`) VALUES
(4, '19:31:56.000000', '21:39:56.000000', 1, 1, 17, '2022-11-05', '2022-11-05 16:31:56.562703', 1, 17, '2022-11-06', 0),
(5, '10:30:03.000000', '16:33:15.000000', 1, 1, 17, '2022-11-06', '2022-11-06 07:30:03.436765', 1, 17, '2022-11-06', 0);

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

--
-- Table structure for table `clock_modes`
--

CREATE TABLE `clock_modes` (
  `id` bigint(20) NOT NULL,
  `en_mode_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clock_modes`
--

INSERT INTO `clock_modes` (`id`, `en_mode_name`, `is_disabled`, `code_name`, `created`, `has_been_modified`, `last_modified`) VALUES
(1, 'Pin code', 0, 'pin_code', '2022-10-07 12:35:51.755223', 1, '2022-10-07 12:35:38.000000'),
(2, 'Finger print', 0, 'finger_print', '2022-10-07 12:44:01.272499', 1, '2022-10-07 12:44:00.000000'),
(3, 'Swipe card', 0, 'swipe_card', '2022-10-07 12:44:25.618503', 1, '2022-10-07 12:44:24.000000'),
(4, 'Barcode', 0, 'barcode', '2022-10-07 12:44:56.856982', 1, '2022-10-07 12:44:55.000000');

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

--
-- Table structure for table `clock_time_settings`
--

CREATE TABLE `clock_time_settings` (
  `id` bigint(20) NOT NULL,
  `clockin_time` time(6) DEFAULT NULL,
  `clockout_time` time(6) DEFAULT NULL,
  `created` datetime(6) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `end_amplitude` varchar(255) NOT NULL,
  `start_amplitude` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clock_time_settings`
--

INSERT INTO `clock_time_settings` (`id`, `clockin_time`, `clockout_time`, `created`, `staff_id`, `end_amplitude`, `start_amplitude`) VALUES
(2, '08:30:00.000000', '05:00:00.000000', '2022-10-07 12:58:45.370190', 17, 'AM', 'PM'),
(3, '08:30:00.000000', '05:00:00.000000', '2022-11-02 21:01:18.649774', 1, 'AM', 'PM');

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

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` bigint(20) NOT NULL,
  `company_name` varchar(200) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contacts` varchar(255) DEFAULT NULL,
  `street_address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `slogan` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `api_key` varchar(500) NOT NULL,
  `lic_key` varchar(500) DEFAULT NULL,
  `lic_file` varchar(500) DEFAULT NULL,
  `created` datetime(6) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `country_id` bigint(20) DEFAULT NULL,
  `currency_id` bigint(20) NOT NULL,
  `language_id` int(11) NOT NULL,
  `date_format_id` int(11) NOT NULL,
  `decimal_separator_id` int(11) NOT NULL,
  `athousand_separator_id` int(11) NOT NULL,
  `tin` varchar(300) DEFAULT NULL,
  `working_modes_id` bigint(20) NOT NULL,
  `table_prefix` varchar(255) NOT NULL,
  `auth_user_id` int(11) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `has_been_shutdown` tinyint(1) NOT NULL,
  `collects_taxes` tinyint(1) NOT NULL,
  `instance_limit` int(11) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `company_branches`
--

CREATE TABLE `company_branches` (
  `id` bigint(20) NOT NULL,
  `branch_name` varchar(200) NOT NULL,
  `email` varchar(255) NOT NULL,
  `contacts` varchar(255) NOT NULL,
  `street_address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL,
  `table_prefix` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `company_id` bigint(20) NOT NULL,
  `collects_taxes` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `company_settings`
--

CREATE TABLE `company_settings` (
  `id` bigint(20) NOT NULL,
  `en_entry_name` varchar(500) NOT NULL,
  `entry_code_name` varchar(255) NOT NULL,
  `has_entry_value` tinyint(1) NOT NULL,
  `entry_value` varchar(500) DEFAULT NULL,
  `is_required` tinyint(1) NOT NULL,
  `is_default` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `is_modifiable` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `company_id` bigint(20) NOT NULL,
  `en_entry_description` varchar(500) DEFAULT NULL,
  `en_entry_help_text` varchar(500) DEFAULT NULL,
  `en_entry_label` varchar(500) DEFAULT NULL,
  `is_boolean` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) NOT NULL,
  `currency_locale` varchar(255) NOT NULL,
  `currency_code` varchar(255) NOT NULL,
  `currency_symbol` varchar(255) NOT NULL,
  `exchange_rate` double NOT NULL,
  `is_indented` tinyint(1) NOT NULL,
  `is_infront` tinyint(1) NOT NULL,
  `athousand_separator_id` int(11) NOT NULL,
  `decimal_separator_id` int(11) NOT NULL,
  `is_default` tinyint(1) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `country_id` bigint(20) DEFAULT NULL,
  `decimal_points` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `currency_locale`, `currency_code`, `currency_symbol`, `exchange_rate`, `is_indented`, `is_infront`, `athousand_separator_id`, `decimal_separator_id`, `is_default`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `country_id`, `decimal_points`) VALUES
(1, 'Ugandan shilling', 'UGX', 'UGX', 1, 0, 0, 1, 1, 1, 0, '2022-04-28 12:06:14.580281', 1, '2022-04-28 12:06:03.000000', 1, 0),
(2, 'Kenyan shillings', 'KSH', 'KSh', 32.02, 1, 0, 1, 1, 0, 0, '2022-04-28 12:17:36.108742', 1, '2022-04-28 12:08:55.000000', 2, 2),
(3, 'Tanzanian shilling', 'TZS', 'Tsh', 1.61, 1, 1, 1, 1, 0, 0, '2022-04-28 12:25:29.937307', 1, '2022-04-28 12:25:17.000000', 3, 2),
(4, 'United states dollars', 'USD', '$', 3787.47, 0, 0, 1, 1, 0, 0, '2022-06-06 11:46:36.941316', 1, '2022-06-06 11:45:53.000000', NULL, 2);

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

--
-- Table structure for table `date_formats`
--

CREATE TABLE `date_formats` (
  `id` int(11) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `date_formart` varchar(300) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `date_formats`
--

INSERT INTO `date_formats` (`id`, `display_name`, `is_default`, `date_formart`, `is_disabled`, `created`) VALUES
(1, 'dd/mm/yyyy', 1, 'dd/mm/yyyy', 0, '2022-12-08 20:01:51'),
(2, 'yyy/dd/mm', 0, 'yyy/dd/mm', 0, '2022-12-08 20:01:51'),
(3, 'dd/mm/yyyy', 0, 'dd/mm/yyyy', 0, '2022-12-10 15:32:58');

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

--
-- Table structure for table `day_offs`
--

CREATE TABLE `day_offs` (
  `id` int(11) NOT NULL,
  `en_display_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `day_offs`
--

INSERT INTO `day_offs` (`id`, `en_display_name`, `code_name`, `is_default`, `is_disabled`, `created`) VALUES
(1, 'Monday', 'monday', 0, 0, '2023-01-13 20:39:36'),
(2, 'Tuesday', 'tuesday', 0, 0, '2023-01-13 20:39:36'),
(3, 'Wednesday', 'wednesday', 0, 0, '2023-01-13 20:39:36'),
(4, 'Thursday', 'thursday', 0, 0, '2023-01-13 20:39:36'),
(5, 'Friday', 'friday', 0, 0, '2023-01-13 20:39:36'),
(6, 'Saturday', 'saturday', 1, 0, '2023-01-13 20:39:36'),
(7, 'Sunday', 'sunday', 1, 0, '2023-01-13 20:39:36');

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

--
-- Table structure for table `decimal_separators`
--

CREATE TABLE `decimal_separators` (
  `id` int(11) NOT NULL,
  `diplay_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `decimal_separators`
--

INSERT INTO `decimal_separators` (`id`, `diplay_name`, `code_name`, `is_disabled`, `created`) VALUES
(1, 'Dot(.)', '.', 0, '2022-12-08 20:08:44'),
(2, 'Comma(,)', ',', 0, '2022-12-08 20:08:44');

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

--
-- Table structure for table `fiscal_year`
--

CREATE TABLE `fiscal_year` (
  `id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_closed` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `genders`
--

CREATE TABLE `genders` (
  `id` int(11) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `genders`
--

INSERT INTO `genders` (`id`, `display_name`, `code_name`, `created`) VALUES
(1, 'Male', 'male', '2022-12-29 14:57:04'),
(2, 'Female', 'female', '2022-12-29 14:57:04');

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

--
-- Table structure for table `grouped_permissions`
--

CREATE TABLE `grouped_permissions` (
  `id` bigint(20) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `group_id` bigint(20) NOT NULL,
  `permission_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grouped_permissions`
--

INSERT INTO `grouped_permissions` (`id`, `created`, `has_been_modified`, `last_modified`, `group_id`, `permission_id`) VALUES
(2, '2022-08-06 17:38:38.664645', 1, '2022-08-06 20:38:38.664645', 3, 15),
(3, '2022-08-06 17:38:39.106508', 1, '2022-08-06 20:38:39.106508', 3, 14),
(4, '2022-08-06 17:38:39.325318', 1, '2022-08-06 20:38:39.325318', 3, 13);

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `invoice_no` varchar(255) NOT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `due_date` date NOT NULL,
  `invoice_date` date NOT NULL,
  `invoice_template_id` int(11) NOT NULL,
  `applies_to_account` int(11) DEFAULT NULL,
  `item_count` int(11) NOT NULL,
  `exchange_rate` float NOT NULL DEFAULT '1',
  `amount_to_be_paid` float NOT NULL DEFAULT '0',
  `invoice_discount` float NOT NULL DEFAULT '0',
  `total_discount` float NOT NULL DEFAULT '0',
  `net_amout` float NOT NULL DEFAULT '0',
  `tax_amout` float NOT NULL DEFAULT '0',
  `gross_amount` float NOT NULL DEFAULT '0',
  `is_reprinted` tinyint(1) NOT NULL DEFAULT '0',
  `is_paid` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `processed_by` int(11) DEFAULT NULL,
  `voided_by` int(11) DEFAULT NULL,
  `void_remarks` varchar(5000) DEFAULT NULL,
  `void_date` date DEFAULT NULL,
  `terms` varchar(6000) NOT NULL,
  `foote_note` varchar(255) DEFAULT NULL,
  `add_authorised_signatory` tinyint(1) NOT NULL DEFAULT '0',
  `invoice_status_id` int(11) NOT NULL,
  `tax_category_id` int(11) NOT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_extra_entries`
--

CREATE TABLE `invoice_extra_entries` (
  `id` int(11) NOT NULL,
  `entry_title` varchar(255) NOT NULL,
  `entry_code_name` varchar(255) NOT NULL,
  `has_entry_value` tinyint(1) NOT NULL DEFAULT '1',
  `entry_value` varchar(5000) NOT NULL,
  `is_required` tinyint(1) NOT NULL DEFAULT '1',
  `is_modifiable` tinyint(1) NOT NULL DEFAULT '1',
  `entry_label` varchar(255) DEFAULT NULL,
  `applies_to_all_invoices` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `item_qty` float NOT NULL DEFAULT '1',
  `unit_cost_price` float NOT NULL DEFAULT '0',
  `unit_price` float NOT NULL DEFAULT '0',
  `total_price` float NOT NULL DEFAULT '0',
  `net_amount` float NOT NULL DEFAULT '0',
  `tax_amout` float NOT NULL DEFAULT '0',
  `discount` float NOT NULL DEFAULT '0',
  `gross_amount` float NOT NULL DEFAULT '0',
  `is_voided` tinyint(1) NOT NULL DEFAULT '0',
  `item_cost_id` int(11) DEFAULT NULL,
  `item_stock_id` int(11) DEFAULT NULL,
  `sort_value` int(11) NOT NULL DEFAULT '0',
  `voided_by` int(11) DEFAULT NULL,
  `void_remarks` varchar(5000) NOT NULL,
  `void_date` date DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_item_taxes`
--

CREATE TABLE `invoice_item_taxes` (
  `id` int(11) NOT NULL,
  `invoice_item_id` int(11) NOT NULL,
  `tax_location_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_payments`
--

CREATE TABLE `invoice_payments` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `payment_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `payment_type_id` int(11) NOT NULL,
  `applies_to_account_id` int(11) NOT NULL,
  `recieved_by` int(11) NOT NULL,
  `proccessed_by` int(11) DEFAULT NULL,
  `cancelled_by` int(11) DEFAULT NULL,
  `is_canceled` int(11) NOT NULL,
  `applied_on_invoice_item` tinyint(1) NOT NULL DEFAULT '0',
  `invoice_item_id` int(11) DEFAULT NULL,
  `amount` double NOT NULL,
  `currency_id` int(11) NOT NULL,
  `payment_status_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_payment_methods`
--

CREATE TABLE `invoice_payment_methods` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `payment_type_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_payment_statuses`
--

CREATE TABLE `invoice_payment_statuses` (
  `id` int(11) NOT NULL,
  `en_status_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice_payment_statuses`
--

INSERT INTO `invoice_payment_statuses` (`id`, `en_status_name`, `code_name`, `is_disabled`, `is_default`, `created`) VALUES
(1, 'Pending', 'pending', 0, 1, '2022-12-22 14:30:51'),
(2, 'Approved', 'approved', 0, 0, '2022-12-22 14:30:51'),
(3, 'Denied', 'denied', 0, 0, '2022-12-22 14:31:35'),
(4, 'Voided', 'voided', 0, 0, '2022-12-22 14:31:35');

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

--
-- Table structure for table `invoice_payment_terms`
--

CREATE TABLE `invoice_payment_terms` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `decription` varchar(5000) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_statuses`
--

CREATE TABLE `invoice_statuses` (
  `id` int(11) NOT NULL,
  `en_status_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice_statuses`
--

INSERT INTO `invoice_statuses` (`id`, `en_status_name`, `code_name`, `is_disabled`, `is_default`, `created`) VALUES
(1, 'Pending', 'pending', 0, 1, '2022-12-22 14:30:51'),
(2, 'Approved', 'approved', 0, 0, '2022-12-22 14:30:51'),
(3, 'Denied', 'denied', 0, 0, '2022-12-22 14:31:35'),
(4, 'Voided', 'voided', 0, 0, '2022-12-22 14:31:35');

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

--
-- Table structure for table `invoice_taxes`
--

CREATE TABLE `invoice_taxes` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `tax_location_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_templates`
--

CREATE TABLE `invoice_templates` (
  `id` int(11) NOT NULL,
  `template_name` varchar(255) NOT NULL,
  `template_path` varchar(300) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `applies_to_all_invoices` tinyint(1) NOT NULL DEFAULT '0',
  `template_type` varchar(255) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `items` (
  `id` int(11) NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `item_code` varchar(255) NOT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `item_unit_id` int(11) DEFAULT NULL,
  `item_type_id` int(11) DEFAULT NULL,
  `item_group_id` int(11) DEFAULT NULL,
  `item_dpt_id` int(11) NOT NULL,
  `item_cat_id` int(11) DEFAULT NULL,
  `has_sizes` tinyint(1) NOT NULL DEFAULT '0',
  `parent_item_id` int(11) DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `expires` datetime DEFAULT NULL,
  `item_desc` varchar(3000) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `item_categories` (
  `id` int(11) NOT NULL,
  `cat_name` varchar(300) NOT NULL,
  `cat_code` varchar(255) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_cost`
--

CREATE TABLE `item_cost` (
  `id` int(11) NOT NULL,
  `cost_price` float NOT NULL,
  `selling_price` float NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '1',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_departments`
--

CREATE TABLE `item_departments` (
  `id` int(11) NOT NULL,
  `dpt_name` varchar(255) NOT NULL,
  `dpt_code` varchar(255) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_groups`
--

CREATE TABLE `item_groups` (
  `id` int(11) NOT NULL,
  `group_name` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_stock`
--

CREATE TABLE `item_stock` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `qty` float NOT NULL,
  `purchase_order_id` int(11) DEFAULT NULL,
  `purchase_order_no` varchar(255) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '1',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_taxes`
--

CREATE TABLE `item_taxes` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `tax_location_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_tax_calculations`
--

CREATE TABLE `item_tax_calculations` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `tax_cal_type_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_types`
--

CREATE TABLE `item_types` (
  `id` int(11) NOT NULL,
  `en_type_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `item_types`
--

INSERT INTO `item_types` (`id`, `en_type_name`, `code_name`, `is_disabled`, `created`) VALUES
(1, 'Inventory', 'inventory', 0, '2022-12-13 23:25:39'),
(2, 'Non-Inventory', 'non_inventory', 0, '2022-12-13 23:25:39'),
(3, 'Services', 'services', 0, '2022-12-13 23:25:39');

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

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

CREATE TABLE `item_units` (
  `id` int(11) NOT NULL,
  `unit_name` varchar(255) NOT NULL,
  `unit_abbrev` varchar(255) NOT NULL,
  `add_custom_plural_abbrev` tinyint(1) NOT NULL DEFAULT '0',
  `unit_plural_abbrev` varchar(255) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `item_units`
--

INSERT INTO `item_units` (`id`, `unit_name`, `unit_abbrev`, `add_custom_plural_abbrev`, `unit_plural_abbrev`, `is_disabled`, `created`) VALUES
(1, 'package', 'package', 1, 'packages', 0, '2022-12-13 23:05:55'),
(2, 'year', 'year', 1, 'years', 0, '2022-12-13 23:05:55'),
(3, 'month', 'month', 1, NULL, 0, '2022-12-13 23:05:55');

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

--
-- Table structure for table `leave_applications`
--

CREATE TABLE `leave_applications` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `leave_type_id` int(11) NOT NULL,
  `starting_date` date NOT NULL,
  `ending_date` date NOT NULL,
  `application_date` date NOT NULL,
  `no_of_days` int(11) NOT NULL,
  `leave_purpose` varchar(5000) NOT NULL,
  `leave_application_status_id` int(11) NOT NULL,
  `created_by_id` int(11) NOT NULL,
  `approved_by_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `leave_application_statuses`
--

CREATE TABLE `leave_application_statuses` (
  `id` int(11) NOT NULL,
  `en_status_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `leave_application_statuses`
--

INSERT INTO `leave_application_statuses` (`id`, `en_status_name`, `code_name`, `is_disabled`, `is_default`, `created`) VALUES
(1, 'Pending', 'pending', 0, 1, '2022-12-22 14:30:51'),
(2, 'Approved', 'approved', 0, 0, '2022-12-22 14:30:51'),
(3, 'Denied', 'denied', 0, 0, '2022-12-22 14:31:35');

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

--
-- Table structure for table `leave_details`
--

CREATE TABLE `leave_details` (
  `id` int(11) NOT NULL,
  `leave_type_id` int(11) NOT NULL,
  `used_leaves` int(11) NOT NULL,
  `remaining_leaves` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `leave_application_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `leave_types`
--

CREATE TABLE `leave_types` (
  `id` int(11) NOT NULL,
  `leave_types_name` varchar(255) NOT NULL,
  `code_name` varchar(255) DEFAULT NULL,
  `leave_typesw_desg` varchar(255) NOT NULL,
  `no_of_leaves_per_year` int(11) NOT NULL DEFAULT '0',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `modules` (
  `id` bigint(20) NOT NULL,
  `en_module_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `route_name` varchar(255) NOT NULL,
  `is_a_sub_module` tinyint(1) NOT NULL,
  `main_module_id` int(11) DEFAULT NULL,
  `depth` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `sort_value` int(11) NOT NULL,
  `has_children` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `en_module_name`, `code_name`, `route_name`, `is_a_sub_module`, `main_module_id`, `depth`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `sort_value`, `has_children`) VALUES
(23, 'Point of Sale', 'point_of_sale', '/sales/dashboard', 0, NULL, 0, 0, '2022-04-28 20:24:11.949900', 1, '2022-04-28 20:24:09.000000', 1, 1),
(24, 'New sale', 'new-sale', '/sales/new-sale', 1, 23, 1, 0, '2022-04-28 20:26:12.216831', 1, '2022-04-28 20:25:59.000000', 2, 0),
(25, 'Sales History', 'sales_history', '/sales/history', 1, 23, 1, 0, '2022-04-28 20:28:53.745643', 0, '2022-04-28 20:28:45.000000', 3, 0),
(26, 'Pending receipts', 'pending_receipts', '/sales/receipts/pending', 1, 23, 1, 0, '2022-04-28 20:33:56.242077', 1, '2022-04-28 20:33:02.000000', 4, 0),
(27, 'Order List', 'orders', '/sales/orders', 1, 23, 1, 0, '2022-04-28 20:37:26.876148', 1, '2022-04-28 20:37:25.000000', 5, 0),
(28, 'End Of day', 'end_of_day', '/sales/end-of-day', 1, 23, 1, 0, '2022-04-28 20:40:19.076860', 1, '2022-04-28 20:38:48.000000', 6, 0),
(29, 'Promo Manager', 'promo_manager', '/sales/promo/manager', 1, 23, 1, 0, '2022-04-28 20:41:34.827648', 1, '2022-04-28 20:41:33.000000', 7, 0),
(31, 'Add Customer', 'new_customer', '/customers/2', 1, 30, 2, 0, '2022-04-28 20:47:15.083137', 1, '2022-04-28 20:46:34.000000', 9, 0),
(32, 'Customer List', 'customer_list', '/customers/1', 1, 30, 2, 0, '2022-04-28 20:48:27.276041', 1, '2022-04-28 20:48:21.000000', 10, 0),
(33, 'Customer Orders', 'customer_orders', '/customers/orders/1', 1, 30, 2, 0, '2022-04-28 20:52:08.080280', 1, '2022-04-28 20:52:06.000000', 11, 0),
(35, 'Return Receipt', 'return_receipt', '/sales/receipts/return', 1, 23, 1, 0, '2022-04-28 21:09:08.348641', 1, '2022-04-28 21:09:07.000000', 13, 0),
(37, 'Add Item', 'add_item', '/item/2', 1, 36, 1, 0, '2022-04-28 21:16:20.411905', 1, '2022-04-28 21:16:19.000000', 15, 0),
(38, 'Add Department', 'add_department', '/item/departments/2', 1, 36, 1, 0, '2022-04-28 21:18:36.014544', 1, '2022-04-28 21:18:34.000000', 16, 0),
(39, 'Items List', 'inventory_items', '/inventory/1', 1, 36, 1, 0, '2022-04-28 21:23:53.333706', 1, '2022-04-28 21:23:35.000000', 17, 0),
(40, 'Departments', 'inventory_departments', '/inventory/departments/1', 1, 36, 1, 0, '2022-04-28 21:33:43.151554', 1, '2022-04-28 21:26:25.000000', 18, 0),
(41, 'Quantity Adjustment', 'quantity_adjustment', '/inventory/adjustments/quantity', 1, 36, 1, 0, '2022-04-28 21:36:56.837459', 1, '2022-04-28 21:36:52.000000', 19, 0),
(42, 'Cost Adjustment', 'cost_adjustment', '/inventory/adjustments/costs', 1, 36, 1, 0, '2022-04-28 21:41:49.597371', 1, '2022-04-28 21:41:44.000000', 20, 0),
(43, 'Quantity Adjustment History', 'quantity_adjustment_history', '/item/adjustment/quantity/history', 1, 36, 1, 0, '2022-04-28 21:50:45.794914', 1, '2022-04-28 21:50:32.000000', 21, 0),
(44, 'Cost Adjustment History', 'cost_adjustment_history', '/item/adjustment/cost/history', 1, 36, 1, 0, '2022-04-28 21:59:02.093514', 1, '2022-04-28 21:58:44.000000', 22, 0),
(46, 'Purchase orders', 'purchase_orders', '/purchasing/1', 1, 45, 1, 0, '2022-04-29 10:33:26.431245', 1, '2022-04-29 10:32:35.000000', 24, 0),
(47, 'Receiving Items', 'receiving_items', '/purchasing/vouchers/receiving', 1, 45, 1, 0, '2022-04-29 10:34:56.740010', 1, '2022-04-29 10:33:51.000000', 25, 0),
(48, 'Supplier List', 'supplier_list', '/purchasing/vendors/1', 1, 45, 1, 0, '2022-04-29 10:47:22.921132', 1, '2022-04-29 10:36:53.000000', 26, 0),
(49, 'Add Supplier', 'create_suppliers', '/purchasing/vendors/2', 1, 45, 1, 0, '2022-04-29 10:52:51.755774', 1, '2022-04-29 10:52:49.000000', 27, 0),
(50, 'Return voucher', 'return_voucher', '/purchasing/vouchers/return', 1, 45, 1, 0, '2022-04-29 10:57:08.651403', 1, '2022-04-29 10:56:24.000000', 28, 0),
(51, 'Receiving History', 'receiving_history', '/purchasing/vouchers/receiving/history', 1, 45, 1, 0, '2022-04-29 10:59:37.161304', 1, '2022-04-29 10:58:42.000000', 29, 0),
(52, 'Pending vouchers', 'pending_vouchers', '/purchasing/vouchers/pending', 1, 45, 1, 0, '2022-04-29 11:05:38.150435', 1, '2022-04-29 11:04:40.000000', 30, 0),
(53, 'Purchase Requistions', 'purchase_requistions', '/purchasing/requisition', 1, 45, 1, 0, '2022-04-29 11:15:17.561595', 1, '2022-04-29 11:14:41.000000', 31, 0),
(54, 'Store Requisitions', 'store_requisitions', '/stores/requisition/1', 1, 73, 1, 1, '2022-04-29 11:16:41.896385', 1, '2022-04-29 11:16:25.000000', 3, 0),
(55, 'Employees', 'employees', '/employees/1', 0, NULL, 0, 0, '2022-04-29 11:28:21.383728', 1, '2022-04-29 11:28:13.000000', 33, 1),
(56, 'Employee List', 'employee_list', '/employees/1', 1, 55, 1, 0, '2022-04-29 11:36:23.184282', 1, '2022-04-29 11:35:53.000000', 35, 0),
(57, 'Clock In/Out', 'clock_in_out', '/employees/attendance/clock-in-out', 1, 55, 1, 0, '2022-04-29 11:37:05.981822', 1, '2022-04-29 11:36:58.000000', 38, 0),
(58, 'Manage Time Clock', 'manage_time_clock', '/employees/attendance/manage-time-clock', 1, 55, 1, 0, '2022-04-29 11:38:54.498404', 1, '2022-04-29 11:37:48.000000', 36, 0),
(59, 'Time Clock History', 'time_clock_history', '/employees/attendance/time-clock-history', 1, 55, 1, 0, '2022-04-29 11:41:11.927598', 1, '2022-04-29 11:41:03.000000', 37, 0),
(60, 'Add Employee', 'add_employee', '/employees/2', 1, 55, 1, 0, '2022-04-29 11:43:57.853395', 1, '2022-04-29 11:43:53.000000', 34, 0),
(61, 'Security', 'security', '/employees/security', 1, 55, 1, 0, '2022-04-29 11:48:43.938611', 1, '2022-04-29 11:47:28.000000', 39, 0),
(62, 'Operations', 'operations', 'operations/1', 0, NULL, 1, 0, '2022-04-29 11:53:49.221932', 1, '2022-04-29 11:53:42.000000', 40, 1),
(64, 'Financial Center', 'accounting', '/operations/accounting', 1, 62, 1, 0, '2022-04-29 12:28:32.131892', 1, '2022-04-29 12:27:44.000000', 42, 0),
(65, 'General Settings', 'general_settings', '/operations/settings', 1, 62, 1, 0, '2022-04-29 12:30:12.645760', 1, '2022-04-29 12:30:05.000000', 43, 0),
(66, 'Get Support', 'get_support', 'https://eazzeypos.binarique.com/help/', 1, 62, 1, 0, '2022-04-29 12:33:57.703982', 1, '2022-04-29 12:33:55.000000', 43, 0),
(67, 'Sales Reports', 'sales_reports', '/operations/reports', 1, 80, 1, 0, '2022-05-23 09:17:09.588037', 0, '2022-05-23 09:14:26.000000', 1, 0),
(68, 'Items / Inventory Reports', 'items_report', '/operations/reports', 1, 80, 1, 0, '2022-05-23 09:19:12.526886', 0, '2022-05-23 09:19:06.000000', 2, 1),
(69, 'Purchasing Reports', 'purchasing_reports', '/operations/reports', 1, 80, 1, 0, '2022-05-23 09:21:06.337303', 0, '2022-05-23 09:20:44.000000', 3, 0),
(70, 'Customers Reports', 'customer_reports', '/operations/reports', 1, 80, 1, 0, '2022-05-23 09:23:07.237311', 0, '2022-05-23 09:22:55.000000', 4, 0),
(71, 'Employees Reports', 'employee_reports', '/operations/reports', 1, 80, 1, 0, '2022-05-23 09:24:19.397252', 0, '2022-05-23 09:24:18.000000', 5, 0),
(72, 'Item Summary Report', 'item_summary_report', '/operations/reports/viewer/1', 1, 68, 2, 0, '2022-05-23 09:52:56.491062', 0, '2022-05-23 09:52:48.000000', 1, 0),
(73, 'Stores', 'Stores', '/stores/1', 0, NULL, 0, 0, '2022-05-23 15:32:33.333055', 0, '2022-05-23 15:32:16.000000', 6, 1),
(74, 'Items List', 'store_item_list', '/item/1', 0, 73, 1, 0, '2022-05-23 15:36:54.324195', 0, '2022-05-23 15:36:04.000000', 1, 0),
(75, 'add Store Item', 'add_store_item', '/stores/2', 0, 73, 1, 0, '2022-05-23 15:38:15.214561', 0, '2022-05-23 15:38:14.000000', 2, 0),
(76, 'Item Settings', 'item_settings', '/item/settings/', 1, 36, 1, 0, '2022-06-20 07:56:24.764967', 1, '2022-06-20 07:56:22.000000', 23, 0),
(77, 'Regional Taxing', 'regional-taxing', 'regional-taxing', 0, NULL, 0, 0, '2022-07-25 10:40:43.969268', 1, '2022-07-25 09:10:07.000000', 44, 1),
(78, 'EFRIS', 'efris', 'efris', 1, 77, 1, 0, '2022-07-25 10:55:07.626136', 1, '2022-07-25 10:55:06.000000', 1, 0),
(79, 'Link devices', 'link-devices', 'linkdevices/', 0, NULL, 1, 0, '2022-07-25 13:07:14.622070', 1, '2022-07-25 13:07:13.000000', 45, 0),
(80, 'Reports', 'reports', 'reports/1', 1, 62, 1, 0, '2022-09-17 09:38:02.316944', 1, '2022-09-17 09:37:56.000000', 41, 1);

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

--
-- Table structure for table `modules_dashboard_menu`
--

CREATE TABLE `modules_dashboard_menu` (
  `id` bigint(20) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `module_id` bigint(20) NOT NULL,
  `sort_value` int(11) NOT NULL,
  `group_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modules_dashboard_menu`
--

INSERT INTO `modules_dashboard_menu` (`id`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `module_id`, `sort_value`, `group_id`) VALUES
(1, 0, '2022-04-29 22:17:08.757560', 1, '2022-04-29 22:17:01.000000', 24, 1, 1),
(2, 0, '2022-04-29 22:17:53.289833', 1, '2022-04-29 22:17:52.000000', 25, 2, 1),
(3, 0, '2022-05-01 13:31:43.320858', 1, '2022-05-01 13:27:51.000000', 29, 3, 1),
(4, 0, '2022-05-01 13:32:50.402194', 1, '2022-05-01 13:32:48.000000', 26, 4, 1),
(5, 0, '2022-05-01 13:37:32.246580', 1, '2022-05-01 13:37:27.000000', 28, 5, 1),
(6, 0, '2022-05-01 14:18:43.642865', 1, '2022-05-01 14:18:23.000000', 27, 6, 1),
(7, 0, '2022-05-01 14:29:49.754266', 1, '2022-05-01 14:23:27.000000', 33, 7, 1),
(8, 0, '2022-05-01 14:48:33.928969', 1, '2022-05-01 14:48:29.000000', 39, 8, 5),
(9, 0, '2022-05-01 14:50:03.829449', 1, '2022-05-01 14:49:52.000000', 40, 9, 5),
(10, 0, '2022-05-01 14:50:48.804045', 1, '2022-05-01 14:50:45.000000', 37, 10, 5),
(11, 0, '2022-05-01 14:51:25.753076', 1, '2022-05-01 14:50:58.000000', 38, 11, 5),
(12, 0, '2022-05-01 14:56:45.059193', 1, '2022-05-01 14:56:39.000000', 48, 12, 2),
(13, 0, '2022-05-01 14:59:11.946173', 1, '2022-05-01 14:59:07.000000', 49, 13, 2),
(14, 0, '2022-05-01 15:01:29.620472', 1, '2022-05-01 15:01:24.000000', 46, 14, 2),
(15, 0, '2022-05-01 15:02:08.698200', 1, '2022-05-01 15:02:06.000000', 47, 15, 2),
(16, 0, '2022-05-01 15:14:08.389003', 1, '2022-05-01 15:13:53.000000', 60, 16, 3),
(17, 0, '2022-05-01 15:16:57.206285', 1, '2022-05-01 15:16:33.000000', 56, 17, 3),
(18, 0, '2022-05-01 15:19:10.016451', 1, '2022-05-01 15:19:09.000000', 65, 18, 4),
(19, 0, '2022-05-01 15:19:53.646522', 1, '2022-05-01 15:19:34.000000', 66, 19, 4),
(20, 0, '2022-05-28 21:19:13.091526', 1, '2022-05-28 21:19:04.000000', 35, 8, 1),
(21, 0, '2022-07-25 13:08:23.136570', 1, '2022-07-25 13:08:21.000000', 79, 20, 4);

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

--
-- Table structure for table `modules_side_menu`
--

CREATE TABLE `modules_side_menu` (
  `id` bigint(20) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `module_id` bigint(20) NOT NULL,
  `sort_value` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modules_side_menu`
--

INSERT INTO `modules_side_menu` (`id`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `module_id`, `sort_value`) VALUES
(1, 0, '2022-04-29 22:05:41.214170', 1, '2022-04-29 22:05:39.000000', 24, 1),
(2, 0, '2022-04-29 22:07:23.790005', 1, '2022-04-29 22:07:18.000000', 39, 2),
(3, 0, '2022-04-29 22:08:06.170131', 1, '2022-04-29 22:08:02.000000', 40, 3),
(5, 0, '2022-04-29 22:10:56.894856', 1, '2022-04-29 22:10:56.000000', 38, 5),
(6, 0, '2022-04-29 22:12:26.499243', 1, '2022-04-29 22:12:22.000000', 55, 6),
(7, 0, '2022-04-29 22:13:27.926874', 1, '2022-04-29 22:13:27.000000', 65, 11),
(8, 0, '2022-04-29 22:14:30.823397', 1, '2022-04-29 22:14:30.000000', 28, 10),
(9, 0, '2022-04-29 22:14:58.545300', 1, '2022-04-29 22:14:57.000000', 66, 8),
(10, 0, '2022-05-11 22:28:37.547284', 1, '2022-05-11 22:28:34.000000', 64, 9),
(11, 0, '2022-05-23 14:35:21.607900', 0, '2022-05-23 14:35:15.000000', 47, 4),
(12, 0, '2022-05-23 20:23:56.108325', 0, '2022-05-23 20:22:05.000000', 37, 7),
(13, 0, '2022-07-25 13:10:18.389671', 1, '2022-07-25 13:10:17.000000', 79, 12);

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

--
-- Table structure for table `module_groups`
--

CREATE TABLE `module_groups` (
  `id` bigint(20) NOT NULL,
  `en_module_group_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `sort_value` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `module_groups`
--

INSERT INTO `module_groups` (`id`, `en_module_group_name`, `code_name`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `sort_value`) VALUES
(1, 'Point Of Sale', 'point_of_sale', 0, '2022-04-26 20:30:16.838112', 1, '2022-04-26 20:30:15.000000', 1),
(2, 'Purchasing', 'Purchasing', 0, '2022-04-26 20:30:46.967469', 1, '2022-04-26 20:30:44.000000', 2),
(3, 'Employees', 'employees', 0, '2022-04-26 20:31:09.910846', 1, '2022-04-26 20:31:07.000000', 3),
(4, 'Operations', 'operations', 0, '2022-04-28 14:10:40.652475', 1, '2022-04-28 14:10:38.000000', 4),
(5, 'Inventory', 'inventory', 0, '2022-04-28 16:46:41.963225', 1, '2022-04-28 16:46:39.000000', 5);

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

--
-- Table structure for table `payment_types`
--

CREATE TABLE `payment_types` (
  `id` int(11) NOT NULL,
  `transaction_type_id` int(11) NOT NULL,
  `en_payment_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `sort_value` int(11) NOT NULL DEFAULT '0',
  `has_standarded_charge` tinyint(1) NOT NULL DEFAULT '0',
  `payment_charge` float NOT NULL DEFAULT '0',
  `charge_in_percentage` tinyint(1) NOT NULL DEFAULT '1',
  `charge_fees_on_customer` tinyint(1) NOT NULL DEFAULT '1',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_types`
--

INSERT INTO `payment_types` (`id`, `transaction_type_id`, `en_payment_name`, `code_name`, `sort_value`, `has_standarded_charge`, `payment_charge`, `charge_in_percentage`, `charge_fees_on_customer`, `is_default`, `is_disabled`, `created`) VALUES
(1, 1, 'Cash', 'cash', 0, 0, 0, 1, 1, 0, 0, '2022-12-21 03:03:42'),
(2, 1, 'Bank', 'bank', 0, 0, 0, 1, 1, 0, 0, '2022-12-21 03:04:26'),
(3, 1, 'Cheque', 'cheque', 0, 0, 0, 1, 1, 0, 0, '2022-12-21 03:04:56'),
(4, 1, 'Visa & Mastercard (cards)', 'cards', 0, 0, 0, 1, 1, 0, 0, '2022-12-21 03:06:07'),
(5, 1, 'Mobile Money', 'momo', 0, 0, 0, 1, 1, 0, 0, '2022-12-21 03:06:29'),
(6, 2, 'Credit', 'credit', 0, 0, 0, 1, 1, 0, 0, '2022-12-21 03:07:19');

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

--
-- Table structure for table `permission_groups`
--

CREATE TABLE `permission_groups` (
  `id` bigint(20) NOT NULL,
  `en_group_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `purchase_invoices`
--

CREATE TABLE `purchase_invoices` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `invoice_no` varchar(255) NOT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `due_date` date NOT NULL,
  `invoice_date` date NOT NULL,
  `invoice_document` varchar(255) NOT NULL,
  `applies_to_account` int(11) DEFAULT NULL,
  `item_count` int(11) NOT NULL,
  `exchange_rate` float NOT NULL DEFAULT '1',
  `amount_to_be_paid` float NOT NULL DEFAULT '0',
  `invoice_discount` float NOT NULL DEFAULT '0',
  `total_discount` float NOT NULL DEFAULT '0',
  `net_amout` float NOT NULL DEFAULT '0',
  `tax_amout` float NOT NULL DEFAULT '0',
  `gross_amount` float NOT NULL DEFAULT '0',
  `is_reprinted` tinyint(1) NOT NULL DEFAULT '0',
  `is_paid` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `processed_by` int(11) DEFAULT NULL,
  `voided_by` int(11) DEFAULT NULL,
  `void_remarks` varchar(5000) DEFAULT NULL,
  `void_date` date DEFAULT NULL,
  `terms` varchar(6000) NOT NULL,
  `foote_note` varchar(255) DEFAULT NULL,
  `add_authorised_signatory` tinyint(1) NOT NULL DEFAULT '0',
  `invoice_status_id` int(11) NOT NULL,
  `tax_category_id` int(11) NOT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `reports_to_id` int(11) DEFAULT NULL,
  `en_role_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `salary_affectors`
--

CREATE TABLE `salary_affectors` (
  `id` bigint(20) NOT NULL,
  `affector_name` varchar(255) NOT NULL,
  `affector_amount` double NOT NULL,
  `narration` varchar(3000) DEFAULT NULL,
  `is_recurring` tinyint(1) NOT NULL,
  `is_an_increase` tinyint(1) NOT NULL,
  `date_given` date NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `salary_duties`
--

CREATE TABLE `salary_duties` (
  `id` bigint(20) NOT NULL,
  `en_tax_location_name` varchar(200) NOT NULL,
  `en_tax_print_mark` varchar(200) NOT NULL,
  `code_name` varchar(200) NOT NULL,
  `has_ranges` tinyint(1) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `country_id` bigint(20) NOT NULL,
  `has_company_rate` tinyint(1) NOT NULL,
  `is_percentage_tax` tinyint(1) NOT NULL,
  `sort_value` int(11) NOT NULL,
  `exempt_monthly_period_of` varchar(3000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salary_duties`
--

INSERT INTO `salary_duties` (`id`, `en_tax_location_name`, `en_tax_print_mark`, `code_name`, `has_ranges`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `country_id`, `has_company_rate`, `is_percentage_tax`, `sort_value`, `exempt_monthly_period_of`) VALUES
(1, 'Local Service Tax', 'LST', 'lst', 1, 0, '2022-10-05 09:53:26.154538', 1, '2022-10-05 09:53:24.000000', 1, 0, 0, 1, NULL),
(2, 'Pay As You Earn', 'PAYE', 'paye', 1, 0, '2022-10-05 09:54:21.270263', 1, '2022-10-05 09:54:04.000000', 1, 0, 1, 2, NULL),
(3, 'National Social Security Fund', 'NSSF', 'nssf', 0, 0, '2022-10-05 10:44:08.526594', 1, '2022-10-05 10:43:31.000000', 1, 1, 1, 3, NULL);

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

--
-- Table structure for table `salary_duty_periods`
--

CREATE TABLE `salary_duty_periods` (
  `id` bigint(20) NOT NULL,
  `en_tax_period_name` varchar(200) NOT NULL,
  `code_name` varchar(200) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salary_duty_periods`
--

INSERT INTO `salary_duty_periods` (`id`, `en_tax_period_name`, `code_name`, `is_disabled`, `created`, `has_been_modified`, `last_modified`) VALUES
(1, 'Annually', 'annually', 0, '2022-10-05 08:35:38.205012', 1, '2022-10-05 08:35:36.000000'),
(2, 'Monthly', 'monthly', 0, '2022-10-05 08:35:53.882159', 1, '2022-10-05 08:35:53.000000'),
(3, 'Not Applicable', 'not_applicable', 0, '2022-10-05 08:36:32.946479', 1, '2022-10-05 08:36:28.000000');

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

--
-- Table structure for table `salary_group_allowances`
--

CREATE TABLE `salary_group_allowances` (
  `id` bigint(20) NOT NULL,
  `allowance_name` varchar(255) NOT NULL,
  `allowance_amount` double NOT NULL,
  `narration` varchar(3000) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `role_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `salary_payment_periods`
--

CREATE TABLE `salary_payment_periods` (
  `id` bigint(20) NOT NULL,
  `en_payment_period_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `rate` double DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salary_payment_periods`
--

INSERT INTO `salary_payment_periods` (`id`, `en_payment_period_name`, `code_name`, `rate`, `is_default`, `is_disabled`, `created`) VALUES
(1, 'per hour', 'per_hour', 0, 0, 0, '2022-10-05 10:52:14.088164'),
(2, 'per day', 'per_day', 0, 0, 0, '2022-10-05 10:53:03.439754'),
(3, 'per month', 'per_month', 0, 0, 0, '2022-10-05 10:53:25.877803');

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

--
-- Table structure for table `salary_staff_role_rates`
--

CREATE TABLE `salary_staff_role_rates` (
  `id` bigint(20) NOT NULL,
  `rate` double NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `salary_payment_period_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `salary_tax_ratings`
--

CREATE TABLE `salary_tax_ratings` (
  `id` bigint(20) NOT NULL,
  `tax_rate` double DEFAULT NULL,
  `company_rate` double DEFAULT NULL,
  `from_amount` double DEFAULT NULL,
  `to_amount` double DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `salary_duty_id` bigint(20) NOT NULL,
  `staff_dinomination_id` bigint(20) DEFAULT NULL,
  `salary_duty_period_id` bigint(20) DEFAULT NULL,
  `staff_category_id` bigint(20) DEFAULT NULL,
  `and_value_above` tinyint(1) NOT NULL,
  `has_percentage` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salary_tax_ratings`
--

INSERT INTO `salary_tax_ratings` (`id`, `tax_rate`, `company_rate`, `from_amount`, `to_amount`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `salary_duty_id`, `staff_dinomination_id`, `salary_duty_period_id`, `staff_category_id`, `and_value_above`, `has_percentage`) VALUES
(1, 5, 10, 0, 0, 0, '2022-10-07 13:38:42.687458', 1, '2022-10-07 13:38:24.000000', 3, 3, 3, 3, 0, 1),
(2, 0, 0, 0, 235000, 0, '2022-10-07 22:13:09.839614', 1, '2022-10-07 22:13:03.000000', 2, 1, 2, 2, 0, 1),
(3, 10, 0, 235001, 335000, 0, '2022-10-07 22:16:45.247513', 1, '2022-10-07 22:16:01.000000', 2, 1, 2, 2, 0, 1),
(4, 20, 0, 335001, 410000, 0, '2022-10-07 22:18:29.214068', 1, '2022-10-07 22:18:27.000000', 2, 1, 2, 2, 0, 1),
(5, 30, 0, 410001, 10000000, 0, '2022-10-07 22:19:46.344842', 1, '2022-10-07 22:19:43.000000', 2, 1, 2, 2, 0, 1),
(6, 40, 0, 10000000, 0, 0, '2022-10-07 22:22:14.676687', 1, '2022-10-07 22:22:13.000000', 2, 1, 2, 2, 1, 1),
(7, 0, 0, 0, 100000, 0, '2022-10-07 22:24:15.596265', 1, '2022-10-07 22:23:56.000000', 1, 1, 2, 2, 0, 0),
(8, 5000, 0, 100001, 200000, 0, '2022-10-07 22:25:39.373122', 1, '2022-10-07 22:25:28.000000', 1, 1, 2, 2, 0, 0),
(9, 10000, 0, 200001, 300000, 0, '2022-10-07 22:28:10.392621', 1, '2022-10-07 22:28:09.000000', 1, 1, 2, 2, 0, 0),
(10, 20000, 0, 300001, 400000, 0, '2022-10-07 22:28:56.549641', 1, '2022-10-07 22:28:55.000000', 1, 1, 2, 2, 0, 0),
(11, 30000, 0, 400001, 500000, 0, '2022-10-07 22:29:33.049398', 1, '2022-10-07 22:29:31.000000', 1, 1, 2, 2, 0, 0),
(12, 40000, 0, 500001, 600000, 0, '2022-10-07 22:30:18.548853', 1, '2022-10-07 22:30:16.000000', 1, 1, 2, 2, 0, 0),
(13, 60000, 0, 600001, 700000, 0, '2022-10-07 22:31:05.350655', 1, '2022-10-07 22:30:59.000000', 1, 1, 2, 2, 0, 0),
(14, 70000, 0, 700001, 800000, 0, '2022-10-07 22:32:35.154613', 1, '2022-10-07 22:31:50.000000', 1, 1, 2, 2, 0, 0),
(15, 80000, 0, 800001, 900000, 0, '2022-10-07 22:33:18.961777', 1, '2022-10-07 22:33:14.000000', 1, 1, 2, 2, 0, 0),
(16, 90000, 0, 900001, 1000000, 0, '2022-10-07 22:34:01.342916', 1, '2022-10-07 22:34:00.000000', 1, 1, 2, 2, 0, 0),
(17, 100000, 0, 1000000, 0, 0, '2022-10-07 22:34:36.369485', 1, '2022-10-07 22:34:32.000000', 1, 1, 2, 2, 1, 0);

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

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

CREATE TABLE `staff` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `last_login` datetime NOT NULL,
  `initials` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `is_superuser` tinyint(1) NOT NULL DEFAULT '0',
  `is_staff` tinyint(1) NOT NULL DEFAULT '1',
  `is_a_citizen` tinyint(1) NOT NULL DEFAULT '1',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `address` varchar(255) DEFAULT NULL,
  `gender_id` int(11) DEFAULT NULL,
  `phoneno` varchar(255) DEFAULT NULL,
  `bio` varchar(3000) DEFAULT NULL,
  `nationality` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `province_state` varchar(255) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `landline_phone` varchar(255) DEFAULT NULL,
  `title_id` int(11) NOT NULL,
  `id_no` varchar(255) DEFAULT NULL,
  `profile_picture` varchar(255) DEFAULT NULL,
  `is_deletable` tinyint(1) DEFAULT '1',
  `staff_type_id` int(11) NOT NULL,
  `staff_category_id` int(11) NOT NULL,
  `staff_dominion_id` int(11) NOT NULL,
  `sys_dpt_id` int(11) DEFAULT NULL,
  `apply_hourly_rate_on_salary` tinyint(1) NOT NULL DEFAULT '0',
  `is_full_time` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_categories`
--

CREATE TABLE `staff_categories` (
  `id` int(11) NOT NULL,
  `en_cat_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff_categories`
--

INSERT INTO `staff_categories` (`id`, `en_cat_name`, `code_name`, `is_disabled`, `created`) VALUES
(1, 'Employer', 'employer', 0, '2023-01-13 10:20:03'),
(2, 'Employee', 'employee', 0, '2023-01-13 10:20:03'),
(3, 'Not Applicable', 'not_applicable', 0, '2023-01-13 10:20:03');

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

--
-- Table structure for table `staff_day_offs`
--

CREATE TABLE `staff_day_offs` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `day_off_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_documents`
--

CREATE TABLE `staff_documents` (
  `id` int(11) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `staff_id` int(11) NOT NULL,
  `doc_mime_type` int(11) NOT NULL,
  `document_file` varchar(255) DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_dominions`
--

CREATE TABLE `staff_dominions` (
  `id` int(11) NOT NULL,
  `en_dominion_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff_dominions`
--

INSERT INTO `staff_dominions` (`id`, `en_dominion_name`, `code_name`, `is_disabled`, `created`) VALUES
(1, 'Resident', 'resident', 0, '2023-01-13 10:31:48'),
(2, 'None-resident', 'none_resident', 0, '2023-01-13 10:31:48'),
(3, 'Not Applicable', 'not_applicable', 0, '2023-01-13 10:31:48');

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

--
-- Table structure for table `staff_permissions`
--

CREATE TABLE `staff_permissions` (
  `id` bigint(20) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `permission_id` bigint(20) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `has_permission` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff_permissions`
--

INSERT INTO `staff_permissions` (`id`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `permission_id`, `staff_id`, `has_permission`) VALUES
(1, 0, '2022-10-03 19:41:18.899881', 1, '2022-10-03 19:41:15.000000', 17, 1, 1),
(2, 0, '2022-10-03 19:41:37.828691', 1, '2022-10-03 19:41:36.000000', 18, 1, 1),
(3, 0, '2022-10-03 19:41:49.349593', 1, '2022-10-03 19:41:47.000000', 19, 1, 1),
(4, 0, '2022-10-03 19:42:38.449742', 1, '2022-10-03 19:42:36.000000', 20, 1, 1),
(5, 0, '2022-10-03 19:43:48.458364', 1, '2022-10-03 19:43:46.000000', 21, 1, 1),
(6, 0, '2022-10-03 19:44:06.138357', 1, '2022-10-03 19:44:04.000000', 22, 1, 1),
(7, 0, '2022-10-03 19:44:22.457256', 1, '2022-10-03 19:44:21.000000', 23, 1, 1),
(8, 0, '2022-10-03 19:44:40.964725', 1, '2022-10-03 19:44:39.000000', 24, 1, 1),
(9, 0, '2022-10-03 19:44:51.769592', 1, '2022-10-03 19:44:50.000000', 25, 1, 1),
(10, 0, '2022-10-03 19:46:01.355809', 1, '2022-10-03 19:45:59.000000', 26, 1, 1),
(11, 0, '2022-10-03 19:47:58.896392', 1, '2022-10-03 19:47:30.000000', 27, 1, 1),
(12, 0, '2022-10-03 19:48:38.326545', 1, '2022-10-03 19:48:34.000000', 28, 1, 1),
(13, 0, '2022-10-03 19:50:31.455982', 1, '2022-10-03 19:48:55.000000', 30, 1, 1),
(14, 0, '2022-10-03 20:04:55.111578', 1, '2022-10-03 20:04:54.000000', 18, 17, 1),
(15, 0, '2022-10-03 20:07:00.291092', 1, '2022-10-03 20:06:48.000000', 19, 17, 1),
(16, 0, '2022-10-03 20:10:05.365183', 1, '2022-10-03 20:10:04.000000', 20, 17, 1),
(17, 0, '2022-10-03 20:10:34.172013', 1, '2022-10-03 20:10:32.000000', 21, 17, 1),
(18, 0, '2022-10-03 20:10:58.119297', 1, '2022-10-03 20:10:57.000000', 22, 17, 1),
(19, 0, '2022-10-03 20:11:20.882554', 1, '2022-10-03 20:11:19.000000', 24, 17, 1),
(20, 0, '2022-10-03 20:11:46.205992', 1, '2022-10-03 20:11:44.000000', 25, 17, 1),
(21, 0, '2022-10-03 20:12:28.040367', 1, '2022-10-03 20:12:27.000000', 26, 17, 1),
(22, 0, '2022-10-03 20:12:53.016977', 1, '2022-10-03 20:12:51.000000', 27, 17, 1),
(23, 0, '2022-10-03 21:50:18.745210', 1, '2022-10-03 21:50:17.000000', 66, 17, 1),
(24, 0, '2022-10-03 21:51:40.971526', 1, '2022-10-03 21:51:39.000000', 30, 17, 1),
(25, 0, '2022-10-03 21:52:12.451561', 1, '2022-10-03 21:52:10.000000', 31, 17, 1);

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

--
-- Table structure for table `staff_roles`
--

CREATE TABLE `staff_roles` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `craeted` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_salaries`
--

CREATE TABLE `staff_salaries` (
  `id` bigint(20) NOT NULL,
  `amount` double NOT NULL,
  `is_hourly_rate` tinyint(1) NOT NULL,
  `apply_taxes` tinyint(1) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `salary_payment_period_id` bigint(20) NOT NULL,
  `staff_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_salary_affectors`
--

CREATE TABLE `staff_salary_affectors` (
  `id` bigint(20) NOT NULL,
  `narration` varchar(3000) DEFAULT NULL,
  `affector_date` date NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `accounting_posting` tinyint(1) NOT NULL,
  `salary_affector_id` bigint(20) NOT NULL,
  `staff_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_salary_allowances`
--

CREATE TABLE `staff_salary_allowances` (
  `id` bigint(20) NOT NULL,
  `narration` varchar(3000) DEFAULT NULL,
  `allowance_date` date NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `accounting_posting` tinyint(1) NOT NULL,
  `salary_allowance_id` bigint(20) NOT NULL,
  `staff_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_salary_duties`
--

CREATE TABLE `staff_salary_duties` (
  `id` bigint(20) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `salary_duty_id` bigint(20) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `payment_date` date NOT NULL,
  `sort_value` int(11) NOT NULL,
  `payment_month` int(11) NOT NULL,
  `payment_time` time(6) NOT NULL,
  `payment_year` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_salary_duty_settings`
--

CREATE TABLE `staff_salary_duty_settings` (
  `id` bigint(20) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `salary_duty_id` bigint(20) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `sort_value` int(11) NOT NULL,
  `exempt_monthly_period_of` varchar(3000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff_salary_duty_settings`
--

INSERT INTO `staff_salary_duty_settings` (`id`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `salary_duty_id`, `staff_id`, `sort_value`, `exempt_monthly_period_of`) VALUES
(2, 0, '2022-10-07 13:48:55.631004', 1, '2022-10-07 13:48:55.631004', 1, 1, 1, NULL),
(3, 0, '2022-10-07 13:49:08.697225', 1, '2022-10-07 13:49:08.697225', 2, 1, 2, NULL),
(4, 0, '2022-10-07 13:49:26.069590', 1, '2022-10-07 13:49:26.069590', 3, 1, 3, NULL),
(5, 0, '2022-10-07 13:49:39.041644', 1, '2022-10-07 13:49:39.041644', 1, 17, 1, NULL),
(6, 0, '2022-10-07 13:49:46.825330', 1, '2022-10-07 13:49:46.825330', 2, 17, 2, NULL),
(7, 0, '2022-10-07 13:49:55.271461', 1, '2022-10-07 13:49:55.271461', 3, 17, 3, NULL);

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

--
-- Table structure for table `staff_salary_payments`
--

CREATE TABLE `staff_salary_payments` (
  `id` bigint(20) NOT NULL,
  `amount` double NOT NULL,
  `narration` varchar(3000) DEFAULT NULL,
  `payment_date` date NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `is_voided` tinyint(1) NOT NULL,
  `voided_by` int(11) DEFAULT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `accounting_posting` tinyint(1) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `payment_month` int(11) NOT NULL,
  `payment_time` time(6) NOT NULL,
  `payment_year` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `staff_salary_taxsettings`
--

CREATE TABLE `staff_salary_taxsettings` (
  `id` bigint(20) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `salary_duty_id` bigint(20) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `sort_value` int(11) NOT NULL,
  `exempt_monthly_period_of` varchar(3000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff_salary_taxsettings`
--

INSERT INTO `staff_salary_taxsettings` (`id`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `salary_duty_id`, `staff_id`, `sort_value`, `exempt_monthly_period_of`) VALUES
(2, 0, '2022-10-07 13:48:55.631004', 1, '2022-10-07 13:48:55.631004', 1, 1, 1, NULL),
(3, 0, '2022-10-07 13:49:08.697225', 1, '2022-10-07 13:49:08.697225', 2, 1, 2, NULL),
(4, 0, '2022-10-07 13:49:26.069590', 1, '2022-10-07 13:49:26.069590', 3, 1, 3, NULL),
(5, 0, '2022-10-07 13:49:39.041644', 1, '2022-10-07 13:49:39.041644', 1, 17, 1, NULL),
(6, 0, '2022-10-07 13:49:46.825330', 1, '2022-10-07 13:49:46.825330', 2, 17, 2, NULL),
(7, 0, '2022-10-07 13:49:55.271461', 1, '2022-10-07 13:49:55.271461', 3, 17, 3, NULL);

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

--
-- Table structure for table `staff_types`
--

CREATE TABLE `staff_types` (
  `id` int(11) NOT NULL,
  `en_staff_type_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff_types`
--

INSERT INTO `staff_types` (`id`, `en_staff_type_name`, `code_name`, `is_disabled`, `is_default`, `created`) VALUES
(1, 'Full-time', 'full_time', 0, 1, '2022-12-22 14:39:16'),
(2, 'Part-time', 'part_time', 0, 0, '2022-12-22 14:39:16'),
(3, 'Temporary', 'temporary', 0, 0, '2022-12-22 14:39:16'),
(4, 'Seasonal', 'seasonal', 0, 0, '2022-12-22 14:39:16');

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

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

CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL,
  `company_name` varchar(300) NOT NULL,
  `contact_person_names` varchar(255) DEFAULT NULL,
  `contact_person_email` varchar(255) DEFAULT NULL,
  `contact_person_address` varchar(255) DEFAULT NULL,
  `company_phone_no` varchar(255) NOT NULL,
  `company_email` varchar(255) NOT NULL,
  `company_street_address` varchar(255) NOT NULL,
  `company_website` varchar(255) NOT NULL,
  `city` varchar(300) DEFAULT NULL,
  `state` varchar(300) DEFAULT NULL,
  `zip_code` varchar(300) DEFAULT NULL,
  `credit_limit` float DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `supported_countries`
--

CREATE TABLE `supported_countries` (
  `id` bigint(20) NOT NULL,
  `en_coutry_name` varchar(255) NOT NULL,
  `coutry_flag` varchar(255) NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `is_default` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supported_countries`
--

INSERT INTO `supported_countries` (`id`, `en_coutry_name`, `coutry_flag`, `country_code`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `is_default`) VALUES
(1, 'Uganda', 'ug.png', 'ug', 0, '2022-04-28 11:23:29.598485', 1, '2022-04-28 11:23:20.000000', 1),
(2, 'Kenya', 'ke.png', 'ke', 0, '2022-04-28 11:24:01.692533', 1, '2022-04-28 11:23:53.000000', 0),
(3, 'Tanzania', 'tz.png', 'tz', 0, '2022-04-28 11:24:31.289045', 1, '2022-04-28 11:24:29.000000', 0),
(4, 'South Sudan', 'ss.png', 'ss', 0, '2022-06-06 11:15:28.753720', 1, '2022-06-06 11:15:26.000000', 0),
(5, 'Rwanda', 'rwa.png', 'rwa', 0, '2022-06-06 11:17:00.521692', 1, '2022-06-06 11:16:58.000000', 0),
(6, 'Burundi', 'bdi.png', 'bdi', 0, '2022-06-06 11:18:07.488917', 1, '2022-06-06 11:18:04.000000', 0),
(7, 'DR Congo', 'cod.png', 'cod', 0, '2022-06-06 11:19:05.458137', 1, '2022-06-06 11:19:04.000000', 0);

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

--
-- Table structure for table `supported_languages`
--

CREATE TABLE `supported_languages` (
  `id` bigint(20) NOT NULL,
  `en_lang_name` varchar(255) NOT NULL,
  `lang_iso_code` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `is_default` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supported_languages`
--

INSERT INTO `supported_languages` (`id`, `en_lang_name`, `lang_iso_code`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `is_default`) VALUES
(1, 'English', 'en', 0, '2022-06-06 11:12:10.236336', 1, '2022-06-10 15:48:28.976398', 1),
(2, 'Luganda', 'lug', 1, '2022-06-06 11:12:25.570397', 1, '2022-06-06 11:12:22.000000', 0),
(3, 'Swahili', 'sw', 1, '2022-06-06 11:12:47.410395', 1, '2022-06-06 11:12:45.000000', 0),
(4, 'Spanish', 'es', 0, '2022-06-06 11:13:11.584573', 1, '2022-06-06 11:13:09.000000', 0),
(5, 'French', 'fr', 0, '2022-06-06 11:13:35.936371', 1, '2022-06-06 11:13:34.000000', 0),
(6, 'Portuguese', 'pt', 0, '2022-06-06 11:14:40.845394', 1, '2022-06-06 11:14:39.000000', 0);

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

--
-- Table structure for table `system_departments`
--

CREATE TABLE `system_departments` (
  `id` bigint(20) NOT NULL,
  `en_sys_dpt_name` varchar(500) NOT NULL,
  `sys_dpt_code` varchar(500) NOT NULL,
  `code_name` varchar(300) NOT NULL,
  `has_transactions` tinyint(1) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `is_default` tinyint(1) NOT NULL,
  `is_deletable` tinyint(1) NOT NULL,
  `is_editable` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `system_departments`
--

INSERT INTO `system_departments` (`id`, `en_sys_dpt_name`, `sys_dpt_code`, `code_name`, `has_transactions`, `is_disabled`, `created`, `has_been_modified`, `last_modified`, `is_default`, `is_deletable`, `is_editable`) VALUES
(2, 'IT Department', 'IT', 'it', 0, 0, '2022-10-07 19:42:07.408183', 1, '2022-10-07 19:41:18.000000', 0, 1, 1),
(3, 'Marketing Department', 'MD', 'marketing', 1, 0, '2022-10-07 19:43:00.859156', 1, '2022-10-07 19:42:58.000000', 0, 1, 1),
(4, 'Accounts', 'ACC', 'accounts', 1, 0, '2022-10-07 19:43:24.231402', 1, '2022-10-07 19:43:22.000000', 0, 1, 1),
(5, 'Human resource', 'HR', 'human_resource', 1, 0, '2022-10-07 19:45:09.304479', 1, '2022-10-07 19:45:07.000000', 0, 1, 1),
(6, 'Relations Management', 'RM', 'relations', 1, 0, '2022-10-07 19:53:06.210595', 1, '2022-10-07 19:53:03.000000', 0, 1, 1);

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

--
-- Table structure for table `tax_calculation_types`
--

CREATE TABLE `tax_calculation_types` (
  `id` int(11) NOT NULL,
  `en_tax_calculation_type_name` varchar(300) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tax_calculation_types`
--

INSERT INTO `tax_calculation_types` (`id`, `en_tax_calculation_type_name`, `code_name`, `is_default`, `is_disabled`, `created`) VALUES
(1, 'Not Applicable', 'none', 1, 0, '2022-12-15 12:16:26'),
(2, 'Normal', 'normal', 0, 0, '2022-12-15 12:16:26'),
(3, 'Cumulative', 'cumulative', 0, 0, '2022-12-15 12:16:26');

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

--
-- Table structure for table `tax_categories`
--

CREATE TABLE `tax_categories` (
  `id` int(11) NOT NULL,
  `en_tax_cat_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tax_categories`
--

INSERT INTO `tax_categories` (`id`, `en_tax_cat_name`, `code_name`, `is_default`, `is_disabled`, `created`) VALUES
(1, 'Not Applicable', 'none', 1, 0, '2022-12-15 12:38:35'),
(2, 'Exclusive', 'exclusive', 0, 0, '2022-12-15 12:38:35'),
(3, 'Inclusive', 'inclusive', 0, 0, '2022-12-15 12:38:35');

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

--
-- Table structure for table `tax_locations`
--

CREATE TABLE `tax_locations` (
  `id` int(11) NOT NULL,
  `tax_location_name` varchar(300) DEFAULT NULL,
  `tax_print_mark` varchar(255) DEFAULT NULL,
  `tax_code` varchar(50) DEFAULT NULL,
  `code_name` varchar(255) DEFAULT NULL,
  `has_fixed_rate` tinyint(1) NOT NULL DEFAULT '0',
  `has_ranges` tinyint(1) NOT NULL DEFAULT '0',
  `default_tax_rate` float NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `sort_by` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tax_locations`
--

INSERT INTO `tax_locations` (`id`, `tax_location_name`, `tax_print_mark`, `tax_code`, `code_name`, `has_fixed_rate`, `has_ranges`, `default_tax_rate`, `is_default`, `is_disabled`, `sort_by`, `created`) VALUES
(1, 'No Tax', 'NONE', '', 'none', 0, 0, 0, 1, 0, 1, '2022-12-15 12:06:12'),
(2, 'Exempted', 'EXP', '', 'exempted', 0, 0, 0, 0, 0, 2, '2022-12-15 12:06:12'),
(3, 'Local Exercise Duty', 'LED', '', 'led', 0, 0, 12, 0, 0, 3, '2022-12-15 12:06:12'),
(4, 'Value added tax', 'VAT', '', 'vat', 0, 0, 18, 0, 0, 4, '2022-12-15 12:06:12');

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

--
-- Table structure for table `tax_location_ranges`
--

CREATE TABLE `tax_location_ranges` (
  `id` int(11) NOT NULL,
  `tax_location_id` int(11) NOT NULL,
  `from_amount` float NOT NULL,
  `to_amount` float NOT NULL,
  `tax_rate` float NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `timezones`
--

CREATE TABLE `timezones` (
  `id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  `display_name` varchar(300) NOT NULL,
  `code_name` varchar(300) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `timezones`
--

INSERT INTO `timezones` (`id`, `country_id`, `display_name`, `code_name`, `is_default`, `is_disabled`, `created`) VALUES
(1, 1, 'Africa/Kampala', 'africa_kampala', 1, 0, '2022-12-09 19:30:53'),
(2, 2, 'Africa/Nairobi', 'africa_nairobi', 0, 0, '2022-12-09 19:30:53'),
(3, 3, 'Africa/Dar_es_Salaam', 'africa_dar_es_Salaam', 0, 0, '2022-12-09 19:30:53'),
(4, 4, 'Africa/Juba', 'africa_juba', 0, 0, '2022-12-09 19:30:53'),
(5, 5, 'Africa/Kigali', 'africa_kigali', 0, 0, '2022-12-09 19:30:53'),
(6, 6, 'Africa/Bujumbura', 'africa_bujumbura', 0, 0, '2022-12-09 19:30:53'),
(7, 7, 'Africa/Kinshasa', 'africa_kinshasa', 0, 0, '2022-12-09 19:30:53'),
(8, 7, 'Africa/Lubumbashi', 'africa_lubumbashi', 0, 0, '2022-12-09 19:30:53');

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

--
-- Table structure for table `titles`
--

CREATE TABLE `titles` (
  `id` int(11) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `titles`
--

INSERT INTO `titles` (`id`, `display_name`, `code_name`, `is_disabled`, `created`) VALUES
(1, 'Mr.', 'Mr.', 0, '2022-12-29 15:09:55'),
(2, 'Mrs.', 'Mrs.', 0, '2022-12-29 15:09:55'),
(3, 'Miss', 'Miss', 0, '2022-12-29 15:09:55'),
(4, 'Ms.', 'Ms.', 0, '2022-12-29 15:09:55'),
(5, 'Dr.', 'Dr.', 0, '2022-12-29 15:09:55'),
(6, 'Prof.', 'Prof.', 0, '2022-12-29 15:09:55'),
(7, 'Rev.', 'Rev.', 0, '2022-12-29 15:09:55');

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

--
-- Table structure for table `transaction_types`
--

CREATE TABLE `transaction_types` (
  `id` int(11) NOT NULL,
  `en_transaction_name` varchar(300) NOT NULL,
  `code_name` varchar(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaction_types`
--

INSERT INTO `transaction_types` (`id`, `en_transaction_name`, `code_name`, `created`) VALUES
(1, 'Cash', 'cash', '2022-12-21 03:00:51'),
(2, 'Credit', 'credit', '2022-12-21 03:00:51');

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

--
-- Table structure for table `workingmodes`
--

CREATE TABLE `workingmodes` (
  `id` bigint(20) NOT NULL,
  `en_mode_name` varchar(200) NOT NULL,
  `code_name` varchar(200) NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime(6) NOT NULL,
  `has_been_modified` tinyint(1) NOT NULL,
  `last_modified` datetime(6) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `workingmodes`
--

INSERT INTO `workingmodes` (`id`, `en_mode_name`, `code_name`, `is_disabled`, `created_at`, `has_been_modified`, `last_modified`, `is_default`) VALUES
(1, 'Single User', 'single_user', 0, '2022-04-26 21:46:26.479728', 1, '2022-04-26 21:46:09.000000', 1),
(2, 'Multi User', 'multi_user', 0, '2022-04-26 21:46:44.912474', 1, '2022-04-26 21:46:43.000000', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `accounts_accounts_group_id_0e566256_fk_accountssgroup_id` (`accounts_group_id`),
  ADD KEY `accounts_accounts_subgroup_id_d3813b6c_fk_api_accou` (`accounts_subgroup_id`),
  ADD KEY `accounts_accounts_class_id_53e6c193_fk_accountssclass_id` (`accounts_class_id`),
  ADD KEY `accounts_currency_id_47ca3452_fk_api_currencies_id` (`currency_id`),
  ADD KEY `accounts_created_by_id_746dc900_fk_auth_user_id` (`created_by_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `invoice_templates`
--
ALTER TABLE `invoice_templates`
  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_cost`
--
ALTER TABLE `item_cost`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `accounts_classes`
--
ALTER TABLE `accounts_classes`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `accounts_fomular`
--
ALTER TABLE `accounts_fomular`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `accounts_groups`
--
ALTER TABLE `accounts_groups`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `accounts_ledger_entries`
--
ALTER TABLE `accounts_ledger_entries`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `accounts_subgroups`
--
ALTER TABLE `accounts_subgroups`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

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

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

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

--
-- AUTO_INCREMENT for table `cash_accounts_settings`
--
ALTER TABLE `cash_accounts_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `clock_actions`
--
ALTER TABLE `clock_actions`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `clock_in_clock_out_history`
--
ALTER TABLE `clock_in_clock_out_history`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `clock_modes`
--
ALTER TABLE `clock_modes`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `clock_time_settings`
--
ALTER TABLE `clock_time_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `company_branches`
--
ALTER TABLE `company_branches`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `company_settings`
--
ALTER TABLE `company_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `grouped_permissions`
--
ALTER TABLE `grouped_permissions`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `modules`
--
ALTER TABLE `modules`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `modules_dashboard_menu`
--
ALTER TABLE `modules_dashboard_menu`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `modules_side_menu`
--
ALTER TABLE `modules_side_menu`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `module_groups`
--
ALTER TABLE `module_groups`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `permission_groups`
--
ALTER TABLE `permission_groups`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `salary_affectors`
--
ALTER TABLE `salary_affectors`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `salary_duties`
--
ALTER TABLE `salary_duties`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `salary_duty_periods`
--
ALTER TABLE `salary_duty_periods`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `salary_group_allowances`
--
ALTER TABLE `salary_group_allowances`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `salary_payment_periods`
--
ALTER TABLE `salary_payment_periods`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `salary_staff_role_rates`
--
ALTER TABLE `salary_staff_role_rates`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `salary_tax_ratings`
--
ALTER TABLE `salary_tax_ratings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

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

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

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

--
-- AUTO_INCREMENT for table `staff_permissions`
--
ALTER TABLE `staff_permissions`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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

--
-- AUTO_INCREMENT for table `staff_salaries`
--
ALTER TABLE `staff_salaries`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_salary_affectors`
--
ALTER TABLE `staff_salary_affectors`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_salary_allowances`
--
ALTER TABLE `staff_salary_allowances`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_salary_duties`
--
ALTER TABLE `staff_salary_duties`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_salary_duty_settings`
--
ALTER TABLE `staff_salary_duty_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `staff_salary_payments`
--
ALTER TABLE `staff_salary_payments`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_salary_taxsettings`
--
ALTER TABLE `staff_salary_taxsettings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

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

--
-- AUTO_INCREMENT for table `supported_countries`
--
ALTER TABLE `supported_countries`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `supported_languages`
--
ALTER TABLE `supported_languages`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `system_departments`
--
ALTER TABLE `system_departments`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `workingmodes`
--
ALTER TABLE `workingmodes`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
