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

START TRANSACTION;



--
-- Database: `leftexty_pos_1`
--

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

--
-- Table structure for table `account_details`
--

CREATE TABLE `account_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ad_id` bigint(20) DEFAULT NULL,
  `ad_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_code_manual` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'manual code input by user which connected other software',
  `parent_id` int(11) DEFAULT NULL,
  `ad_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_al2_id` bigint(20) DEFAULT NULL,
  `ad_code_id` bigint(20) DEFAULT NULL,
  `ad_flag` bigint(20) DEFAULT NULL,
  `is_receive_account` bigint(20) NOT NULL DEFAULT 0 COMMENT 'not receveable =0,receveable=1',
  `ad_mem_flg` bigint(20) DEFAULT NULL,
  `ad_ref_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_ref_cell_no` bigint(20) DEFAULT NULL,
  `ad_delivery_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_credit_limit` bigint(20) DEFAULT NULL,
  `ad_cust_type` bigint(20) NOT NULL DEFAULT 0 COMMENT 'credit=0,cash=1,cash/credit=2',
  `ad_td_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_mm_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_cust_code` bigint(20) DEFAULT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `ad_target_qty` bigint(20) DEFAULT NULL,
  `ad_bin_nid_no` bigint(20) DEFAULT NULL,
  `ad_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_nbr_list_type` int(11) NOT NULL DEFAULT 1 COMMENT 'type check by nbr list 1=register,2=non-register,3=listed',
  `ad_eff_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'created action by an user',
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'updated action by an user',
  `permited_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'permited user id ',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'status 1 for active 0 for inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_details`
--

INSERT INTO `account_details` (`id`, `ad_id`, `ad_code`, `ad_code_manual`, `parent_id`, `ad_name`, `ad_address`, `name`, `phone`, `address`, `description`, `ad_al2_id`, `ad_code_id`, `ad_flag`, `is_receive_account`, `ad_mem_flg`, `ad_ref_name`, `ad_ref_cell_no`, `ad_delivery_address`, `ad_credit_limit`, `ad_cust_type`, `ad_td_id`, `ad_mm_id`, `ad_cust_code`, `branch_id`, `ad_target_qty`, `ad_bin_nid_no`, `ad_email`, `ad_nbr_list_type`, `ad_eff_date`, `created_by`, `updated_by`, `permited_user`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, '1001', NULL, NULL, 'Cash and cash equivalents', 'N/A', 'Cash and cash equivalents', 'N/A', 'N/A', NULL, 13, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:26:13', '2021-01-01 07:26:13'),
(2, NULL, '1002', NULL, NULL, 'Cash on hand', 'N/A', 'Cash on hand', 'N/A', 'N/A', NULL, 14, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:26:59', '2021-01-01 07:26:59'),
(3, NULL, '1003', NULL, NULL, 'Bank', 'N/A', 'Bank', 'N/A', 'N/A', NULL, 13, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:27:51', '2021-01-01 07:27:51'),
(4, NULL, '1003', NULL, NULL, 'Client trust account', 'N/A', 'Client trust account', 'N/A', 'N/A', NULL, 15, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:28:26', '2021-01-01 07:28:26'),
(5, NULL, '1004', NULL, NULL, 'Cost of Goods Sold - COS', 'N/A', 'Cost of Goods Sold - COS', 'N/A', 'N/A', NULL, 86, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:37:25', '2021-01-01 07:37:25'),
(6, NULL, '1005', NULL, NULL, 'Inventory', 'N/A', 'Inventory', 'M/A', 'N/A', NULL, 6, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:38:15', '2021-01-01 07:38:15'),
(7, NULL, '1006', NULL, NULL, 'Opening Adjustment Account', 'N/A', 'Opening Adjustment Account', 'N/A', 'N/A', NULL, 122, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:41:53', '2021-01-01 07:41:53'),
(8, NULL, '1007', NULL, NULL, 'Sales', 'N/A', 'Sales', 'N/A', 'N/A', NULL, 68, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:44:17', '2021-01-01 07:44:17'),
(9, NULL, '1008', NULL, NULL, 'Sales discount', 'N/A', 'Sales discount', 'N/A', 'N/A', NULL, 123, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:54:19', '2021-01-01 07:54:19'),
(10, NULL, '1009', NULL, NULL, 'Vat Payable', 'N/A', 'Vat Payable', 'N/A', 'N/A', NULL, 124, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:57:51', '2021-01-01 07:57:51'),
(11, NULL, '1010', NULL, NULL, 'Vat Expense', 'N/A', 'Vat Expense', 'N/A', 'N/A', NULL, 125, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:58:28', '2021-01-01 07:58:28'),
(12, NULL, '1011', NULL, NULL, 'Walking Customer', 'N/A', 'Walking Customer', 'N/A', 'N/A', NULL, 1, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 08:03:12', '2021-01-01 08:03:12'),
(13, NULL, '1012', NULL, NULL, 'Unknown Supplier', 'N/A', 'Unknown Supplier', 'N/A', 'N/A', NULL, 40, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-01 08:04:38', '2021-01-01 08:04:38'),
(14, NULL, '5001', NULL, NULL, 'Vat input Account', 'N/A', 'Vat input Account', 'N/A', 'N/A', NULL, 126, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-03 13:31:55', '2021-01-03 13:31:55'),
(15, NULL, '2001', NULL, NULL, 'Sales Return', 'N/A', 'Sales Return', 'N/A', 'N/A', NULL, 68, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-13 13:25:51', '2021-01-13 13:25:51'),
(16, NULL, '4001', NULL, NULL, 'Purchase discount', 'N/A', 'Purchase discount', 'N/A', 'N/A', NULL, 79, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, '2021-01-15 07:38:10', '2021-01-15 07:38:10');

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

--
-- Table structure for table `account_heads`
--

CREATE TABLE `account_heads` (
  `id` bigint(20) UNSIGNED NOT NULL COMMENT 'auto increment id',
  `ah_id` bigint(20) NOT NULL COMMENT 'account head id',
  `ah_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'account head short code',
  `ah_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'account head name',
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'created action by an user',
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'updated action by an user',
  `permited_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'permited user id ',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'status 1 for active 0 for inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_heads`
--

INSERT INTO `account_heads` (`id`, `ah_id`, `ah_code`, `ah_name`, `created_by`, `updated_by`, `permited_user`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, '01', 'assets', NULL, NULL, NULL, 1, NULL, NULL),
(2, 2, '02', 'liabilities', NULL, NULL, NULL, 1, NULL, NULL),
(3, 3, '03', 'income', NULL, NULL, NULL, 1, NULL, NULL),
(4, 4, '04', 'expenses', NULL, NULL, NULL, 1, NULL, NULL),
(5, 5, '05', 'capital', NULL, NULL, NULL, 1, NULL, NULL);

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

--
-- Table structure for table `account_ledgers`
--

CREATE TABLE `account_ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lg_id` bigint(20) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `lg_voucher_date` date DEFAULT NULL,
  `lg_voucher_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_particulars` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_ad_id` bigint(20) DEFAULT NULL,
  `lg_dr_amt` double(18,6) DEFAULT NULL,
  `lg_cr_amt` double(18,6) DEFAULT NULL,
  `lg_rollback_id` bigint(20) DEFAULT NULL,
  `lg_cid_id` bigint(20) DEFAULT NULL,
  `lg_data_flag` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_chq_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_chq_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_voucher_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_usr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_naration` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_bill_ref` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_proj_id` bigint(20) DEFAULT NULL,
  `lg_trans_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_vd_sm_id` bigint(20) DEFAULT NULL,
  `lg_vd_id_item_id` bigint(20) DEFAULT NULL,
  `lg_vd_sd_id` bigint(20) DEFAULT NULL,
  `lg_vd_rm_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_inv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_lc_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lg_sm_inv_type` bigint(20) DEFAULT NULL COMMENT '0=invoice, 1=sample invoice',
  `lg_mm_id` bigint(20) DEFAULT NULL,
  `lg_td_id` bigint(20) DEFAULT NULL,
  `lg_bm_id` bigint(20) DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'created action by an user',
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'updated action by an user',
  `permited_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'permited user id ',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'status 1 for active 0 for inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `account_level_ones`
--

CREATE TABLE `account_level_ones` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ah_id` bigint(20) DEFAULT NULL,
  `code_id` bigint(20) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'created action by an user',
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'updated action by an user',
  `permited_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'permited user id ',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'status 1 for active 0 for inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_level_ones`
--

INSERT INTO `account_level_ones` (`id`, `code`, `name`, `ah_id`, `code_id`, `branch_id`, `created_by`, `updated_by`, `permited_user`, `status`, `created_at`, `updated_at`) VALUES
(1, 'A-01', 'Accounts Receivable (A/R)', 1, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:54:16', '2021-01-01 05:54:16'),
(2, 'A-02', 'Current assets', 1, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:54:49', '2021-01-01 05:54:49'),
(3, 'A-03', 'Cash and cash equivalents', 1, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:55:12', '2021-01-01 05:55:12'),
(4, 'A-04', 'Fixed assets', 1, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:55:32', '2021-01-01 05:56:15'),
(5, 'A-05', 'Non-current assets', 1, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:56:38', '2021-01-01 05:56:38'),
(6, 'L-01', 'Accounts payable (A/P)', 2, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:57:15', '2021-01-01 05:57:15'),
(7, 'L-02', 'Credit Card', 2, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:58:12', '2021-01-01 05:58:12'),
(8, 'L-03', 'Current liabilities', 2, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:58:33', '2021-01-01 05:58:33'),
(9, 'L-04', 'Non-current liabilities', 2, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:58:54', '2021-01-01 05:58:54'),
(10, 'C-01', 'Owner\'s equity', 5, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:59:14', '2021-01-01 05:59:14'),
(11, 'I-01', 'Income', 3, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:59:34', '2021-01-01 05:59:34'),
(12, 'I-02', 'Other income', 3, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 05:59:51', '2021-01-01 05:59:51'),
(13, 'E-01', 'Cost of sales', 4, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:00:19', '2021-01-01 06:00:19'),
(14, 'E-02', 'Expenses', 4, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:00:43', '2021-01-01 06:00:43'),
(15, 'E-03', 'Other expense', 4, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:01:12', '2021-01-01 06:01:12');

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

--
-- Table structure for table `account_level_twos`
--

CREATE TABLE `account_level_twos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `al2_id` bigint(20) DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `al1_id` bigint(20) DEFAULT NULL,
  `code_id` bigint(20) DEFAULT NULL,
  `flag` bigint(20) DEFAULT NULL,
  `level_two_parent_id` bigint(20) DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'created action by an user',
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'updated action by an user',
  `permited_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'permited user id ',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'status 1 for active 0 for inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_level_twos`
--

INSERT INTO `account_level_twos` (`id`, `al2_id`, `code`, `name`, `al1_id`, `code_id`, `flag`, `level_two_parent_id`, `created_by`, `updated_by`, `permited_user`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'AR-01', 'Accounts Receivable (A/R)', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:02:27', '2021-01-01 06:02:27'),
(2, NULL, 'CA-01', 'Allowance for bad debts', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:03:14', '2021-01-01 06:03:14'),
(3, NULL, 'CA-02', 'Assets available for sale', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:03:36', '2021-01-01 06:03:36'),
(4, NULL, 'CA-03', 'Development costs', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:03:58', '2021-01-01 06:03:58'),
(5, NULL, 'CA-04', 'Employee cash advances', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:04:21', '2021-01-01 06:04:21'),
(6, NULL, 'CA-05', 'Inventory', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:04:39', '2021-01-01 06:04:39'),
(7, NULL, 'CA-06', 'Investments - Other', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:05:00', '2021-01-01 06:05:00'),
(8, NULL, 'CA-07', 'Loans to officers', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:05:23', '2021-01-01 06:05:23'),
(9, NULL, 'CA-08', 'Loans to others', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:05:43', '2021-01-01 06:05:43'),
(10, NULL, 'CA-09', 'Other current assets', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:06:07', '2021-01-01 06:06:07'),
(11, NULL, 'CA-10', 'Prepaid expenses', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:06:29', '2021-01-01 06:06:29'),
(12, NULL, 'CASH-01', 'Bank', 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:07:10', '2021-01-01 06:07:10'),
(13, NULL, 'CASH-02', 'Cash and Cash Equivalents', 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:07:32', '2021-01-01 06:07:32'),
(14, NULL, 'CASH-03', 'Cash on hand', 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:11:03', '2021-01-01 06:12:49'),
(15, NULL, 'CASH-04', 'Client trust accounts', 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:11:29', '2021-01-01 06:13:00'),
(16, NULL, 'CASH-05', 'Money market', 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:11:53', '2021-01-01 06:13:10'),
(17, NULL, 'CASH-06', 'Rents held in trust', 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:12:39', '2021-01-01 06:12:39'),
(18, NULL, 'CASH-07', 'Savings', 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:13:35', '2021-01-01 06:13:35'),
(19, NULL, 'FA-01', 'Accumulated depletion', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:14:15', '2021-01-01 06:14:15'),
(20, NULL, 'FA-02', 'Accumulated depreciation on property, plant and equipment', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:14:41', '2021-01-01 06:14:41'),
(21, NULL, 'FA-03', 'Buildings', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:15:01', '2021-01-01 06:15:01'),
(22, NULL, 'FA-06', 'Depletable assets', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:15:24', '2021-01-01 06:19:01'),
(23, NULL, 'FA-07', 'Furniture and fixtures', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:15:45', '2021-01-01 06:19:06'),
(24, NULL, 'FA-08', 'Land', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:16:06', '2021-01-01 06:19:14'),
(25, NULL, 'FA-04', 'Buildings', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:17:17', '2021-01-01 06:18:14'),
(26, NULL, 'FA-05', 'Machinery and equipment', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:19:52', '2021-01-01 06:19:52'),
(27, NULL, 'FA-09', 'Other fixed asset', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:20:15', '2021-01-01 06:20:15'),
(28, NULL, 'FA-10', 'Vehicles', 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:20:32', '2021-01-01 06:20:32'),
(29, NULL, 'NCA-01', 'Accumulated amortisation of non-current assets', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:21:05', '2021-01-01 06:21:05'),
(30, NULL, 'NCA-02', 'Assets held for sale', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:22:04', '2021-01-01 06:22:04'),
(31, NULL, 'NCA-03', 'Deferred tax', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:22:28', '2021-01-01 06:22:28'),
(32, NULL, 'NCA-04', 'Goodwill', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:22:46', '2021-01-01 06:22:46'),
(33, NULL, 'NCA-05', 'Intangible assets', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:23:05', '2021-01-01 06:23:05'),
(34, NULL, 'NCA-06', 'Lease buyout', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:23:23', '2021-01-01 06:23:23'),
(35, NULL, 'NCA-07', 'Licences', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:23:40', '2021-01-01 06:23:40'),
(36, NULL, 'NCA-08', 'Long-term investments', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:23:59', '2021-01-01 06:23:59'),
(37, NULL, 'NCA-09', 'Organizational costs', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:24:26', '2021-01-01 06:24:26'),
(38, NULL, 'NCA-10', 'Other non-current assets', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:24:45', '2021-01-01 06:24:45'),
(39, NULL, 'NCA-11', 'Security deposits', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:25:04', '2021-01-01 06:25:04'),
(40, NULL, 'AP-01', 'Accounts Payable (A/P)', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:25:33', '2021-01-01 06:25:33'),
(41, NULL, 'CC-01', 'Credit Card', 7, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:25:58', '2021-01-01 06:25:58'),
(42, NULL, 'CL-01', 'Accrued Liabilities', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:26:21', '2021-01-01 06:26:21'),
(43, NULL, 'CL-02', 'Client Trust accounts - liabilities', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:26:49', '2021-01-01 06:26:49'),
(44, NULL, 'CL-03', 'Current tax liability', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:27:08', '2021-01-01 06:27:08'),
(45, NULL, 'CL-04', 'Current portion of obligations under finance leases', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:27:29', '2021-01-01 06:27:29'),
(46, NULL, 'CL-05', 'Dividends payable', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:28:09', '2021-01-01 06:28:09'),
(47, NULL, 'CL-06', 'Income tax payable', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:28:28', '2021-01-01 06:28:28'),
(48, NULL, 'CL-07', 'Insurance payable', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:28:48', '2021-01-01 06:28:48'),
(49, NULL, 'CL-08', 'Line of credit', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:29:08', '2021-01-01 06:29:08'),
(50, NULL, 'CL-09', 'Loan payable', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:29:27', '2021-01-01 06:29:27'),
(51, NULL, 'CL-10', 'Other current liabilities', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:29:47', '2021-01-01 06:29:47'),
(52, NULL, 'CL-11', 'Payroll clearing', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:30:06', '2021-01-01 06:30:06'),
(53, NULL, 'CL-12', 'Payroll liabilities', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:30:28', '2021-01-01 06:30:28'),
(54, NULL, 'CL-13', 'Prepaid expenses payable', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:30:56', '2021-01-01 06:30:56'),
(55, NULL, 'CL-14', 'Rents in trust - liability', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:31:14', '2021-01-01 06:31:14'),
(56, NULL, 'CL-15', 'Sales and service tax payable', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:31:33', '2021-01-01 06:31:33'),
(57, NULL, 'NCL-01', 'Accrued holiday payable', 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:32:10', '2021-01-01 06:32:10'),
(58, NULL, 'NCL-02', 'Accrued Non-current liabilities', 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:32:30', '2021-01-01 06:32:30'),
(59, NULL, 'NCL-03', 'Liabilities related to assets held for sale', 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:32:54', '2021-01-01 06:32:54'),
(60, NULL, 'NCL-04', 'Long-term debt', 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:33:17', '2021-01-01 06:33:17'),
(61, NULL, 'NCL-05', 'Notes payable', 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:33:36', '2021-01-01 06:33:36'),
(62, NULL, 'NCL-06', 'Other non-current liabilities', 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:33:55', '2021-01-01 06:33:55'),
(63, NULL, 'NCL-07', 'Shareholder notes payable', 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:34:16', '2021-01-01 07:10:23'),
(64, NULL, 'OE-01', 'Capital', 10, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:35:07', '2021-01-01 06:35:07'),
(65, NULL, 'IN-01', 'Discounts/refunds given', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:35:42', '2021-01-01 06:35:42'),
(66, NULL, 'IN-02', 'Non-profit income', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:35:59', '2021-01-01 06:35:59'),
(67, NULL, 'IN-03', 'Other primary income', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:36:18', '2021-01-01 06:36:18'),
(68, NULL, 'IN-04', 'Revenue - General', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:36:40', '2021-01-01 06:36:40'),
(69, NULL, 'IN-05', 'Sales - retail', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:37:02', '2021-01-01 06:37:02'),
(70, NULL, 'IN-06', 'Sales - wholesale', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:37:24', '2021-01-01 06:37:24'),
(71, NULL, 'IN-07', 'Sales of product income', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:37:45', '2021-01-01 06:37:45'),
(72, NULL, 'IN-08', 'Service/fee income', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:38:02', '2021-01-01 06:38:02'),
(73, NULL, 'IN-09', 'Unapplied Cash Payment Income', 11, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:38:22', '2021-01-01 06:38:22'),
(74, NULL, 'OIN-01', 'Dividend income', 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:38:49', '2021-01-01 06:38:49'),
(75, NULL, 'OIN-02', 'Interest earned', 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:39:08', '2021-01-01 06:39:08'),
(76, NULL, 'OIN-03', 'Loss on disposal of assets', 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:39:26', '2021-01-01 06:39:26'),
(77, NULL, 'OIN-04', 'Other investment income', 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:39:46', '2021-01-01 06:39:46'),
(78, NULL, 'OIN-05', 'Other miscellaneous income', 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:40:07', '2021-01-01 06:40:07'),
(79, NULL, 'OIN-06', 'Other operating income', 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:40:26', '2021-01-01 06:40:26'),
(80, NULL, 'OIN-07', 'Tax-exempt interest', 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:40:45', '2021-01-01 06:40:45'),
(81, NULL, 'OIN-08', 'Unrealised loss on securities, net of tax', 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:41:08', '2021-01-01 06:41:08'),
(82, NULL, 'COS-01', 'Cost of labour - COS', 13, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:41:33', '2021-01-01 06:41:33'),
(83, NULL, 'COS-02', 'Equipment rental - COS', 13, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:41:54', '2021-01-01 06:41:54'),
(84, NULL, 'COS-03', 'Freight and delivery - COS', 13, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:42:17', '2021-01-01 06:42:17'),
(85, NULL, 'COS-04', 'Other costs of sales - COS', 13, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:42:37', '2021-01-01 06:42:37'),
(86, NULL, 'COS-05', 'Cost of Goods Sold - COS', 13, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:43:04', '2021-01-01 07:36:35'),
(87, NULL, 'EX-01', 'Advertising/promotional', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:43:34', '2021-01-01 06:43:34'),
(88, NULL, 'EX-02', 'Amortisation expense', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:43:51', '2021-01-01 06:43:51'),
(89, NULL, 'EX-03', 'Bad debt', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:53:12', '2021-01-01 06:53:12'),
(90, NULL, 'EX-04', 'Bank charges', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:53:32', '2021-01-01 06:53:32'),
(91, NULL, 'EX-05', 'Charitable contributions', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:53:50', '2021-01-01 06:53:50'),
(92, NULL, 'EX-06', 'Commissions and fees', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:54:10', '2021-01-01 06:54:10'),
(93, NULL, 'EX-07', 'Cost of labour', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:54:29', '2021-01-01 06:54:29'),
(94, NULL, 'EX-08', 'Dues and subscriptions', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:55:04', '2021-01-01 06:55:04'),
(95, NULL, 'EX-09', 'Equipment rental', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:55:28', '2021-01-01 06:55:28'),
(96, NULL, 'EX-10', 'Finance costs', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:55:49', '2021-01-01 06:55:49'),
(97, NULL, 'EX-11', 'Income tax expense', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:56:10', '2021-01-01 06:56:10'),
(98, NULL, 'EX-12', 'Insurance', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:56:27', '2021-01-01 06:56:27'),
(99, NULL, 'EX-13', 'Interest paid', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:56:47', '2021-01-01 06:56:47'),
(100, NULL, 'EX-14', 'Legal and professional fees', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:57:12', '2021-01-01 06:57:12'),
(101, NULL, 'EX-15', 'Loss on discontinued operations, net of tax', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:57:37', '2021-01-01 06:57:37'),
(102, NULL, 'EX-16', 'Management compensation', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:57:57', '2021-01-01 06:57:57'),
(103, NULL, 'EX-17', 'Meals and entertainment', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:58:18', '2021-01-01 06:58:18'),
(104, NULL, 'EX-18', 'Office/general administrative expenses', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:58:47', '2021-01-01 06:58:47'),
(105, NULL, 'EX-19', 'Other miscellaneous service cost', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:59:08', '2021-01-01 06:59:08'),
(106, NULL, 'EX-20', 'Other selling expenses', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:59:25', '2021-01-01 06:59:25'),
(107, NULL, 'EX-21', 'Payroll expenses', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 06:59:55', '2021-01-01 06:59:55'),
(108, NULL, 'EX-22', 'Rent or lease of buildings', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:00:14', '2021-01-01 07:00:14'),
(109, NULL, 'EX-23', 'Repair and maintenance', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:00:35', '2021-01-01 07:00:35'),
(110, NULL, 'EX-24', 'Shipping and delivery expense', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:00:54', '2021-01-01 07:00:54'),
(111, NULL, 'EX-25', 'Supplies & materials', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:01:18', '2021-01-01 07:01:18'),
(112, NULL, 'EX-26', 'Taxes Paid', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:01:39', '2021-01-01 07:01:39'),
(113, NULL, 'EX-27', 'Travel expenses - general and admin expenses', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:02:15', '2021-01-01 07:02:15'),
(114, NULL, 'EX-28', 'Travel expenses - selling expense', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:02:36', '2021-01-01 07:02:36'),
(115, NULL, 'EX-29', 'Unapplied Cash Bill Payment Expense', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:03:09', '2021-01-01 07:03:09'),
(116, NULL, 'EX-30', 'Utilities', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:03:30', '2021-01-01 07:03:30'),
(117, NULL, 'OEX-01', 'Amortisation', 15, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:04:03', '2021-01-01 07:04:03'),
(118, NULL, 'OEX-02', 'Depreciation', 15, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:04:26', '2021-01-01 07:04:26'),
(119, NULL, 'OEX-03', 'Exchange Gain or Loss', 15, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:04:46', '2021-01-01 07:04:46'),
(120, NULL, 'OEX-04', 'Other Expense', 15, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:05:05', '2021-01-01 07:05:05'),
(121, NULL, 'OEX-05', 'Penalties and settlements', 15, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:05:28', '2021-01-01 07:05:28'),
(122, NULL, 'OEX-06', 'Opening Adjustment Account', 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:41:11', '2021-01-01 07:41:11'),
(123, NULL, 'EX-31', 'Sales discount', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:53:35', '2021-01-01 07:53:35'),
(124, NULL, 'CL-16', 'Vat Payable', 8, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:56:05', '2021-01-01 07:56:05'),
(125, NULL, 'EX-32', 'Vat Expense', 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-01 07:56:51', '2021-01-01 07:56:51'),
(126, NULL, 'CA-11', 'Vat input Account', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-01-02 15:24:41', '2021-01-02 15:24:41');

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

--
-- Table structure for table `account_voucher_masters`
--

CREATE TABLE `account_voucher_masters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vm_id` bigint(20) DEFAULT NULL,
  `vm_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `vm_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vm_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vm_naration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vm_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vm_post_flag` bigint(20) DEFAULT NULL,
  `vm_bill_ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vm_bill_ref_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vm_no_id` bigint(20) DEFAULT NULL,
  `vm_cid_id` bigint(20) DEFAULT NULL,
  `vm_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vm_proj_id` bigint(20) DEFAULT NULL,
  `vm_amount` bigint(20) DEFAULT NULL,
  `vm_bm_id` bigint(20) DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'created action by an user',
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'updated action by an user',
  `permited_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'permited user id ',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'status 1 for active 0 for inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `advance_paid_accounts`
--

CREATE TABLE `advance_paid_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` int(11) NOT NULL,
  `transection_no` int(11) DEFAULT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) DEFAULT NULL,
  `credit` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `advance_paid_person_profiles`
--

CREATE TABLE `advance_paid_person_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `advance_received_person_profiles`
--

CREATE TABLE `advance_received_person_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `advance_receive_accounts`
--

CREATE TABLE `advance_receive_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` int(11) NOT NULL,
  `transection_no` int(11) DEFAULT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) DEFAULT NULL,
  `credit` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `own_account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_no` int(11) DEFAULT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) DEFAULT NULL,
  `credit` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bank_account_profiles`
--

CREATE TABLE `bank_account_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `capital_accounts`
--

CREATE TABLE `capital_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` int(11) NOT NULL,
  `transection_no` int(11) DEFAULT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) DEFAULT NULL,
  `credit` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cash_books`
--

CREATE TABLE `cash_books` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `own_account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `refeance_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) NOT NULL,
  `credit` double(10,2) NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `person_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cash_profiles`
--

CREATE TABLE `cash_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `transection_term_id` int(11) DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_profiles`
--

INSERT INTO `cash_profiles` (`id`, `name`, `category_id`, `transection_term_id`, `address`, `phone`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Main Cash Book', 1, 0, 'Dhaka,Bangladesh', '', 1, NULL, NULL, NULL);

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

--
-- Table structure for table `costof_goods_sold_accounts`
--

CREATE TABLE `costof_goods_sold_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customer_accounts`
--

CREATE TABLE `customer_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` int(11) NOT NULL,
  `transection_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) DEFAULT NULL,
  `credit` double(10,2) DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customer_categories`
--

CREATE TABLE `customer_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customer_profiles`
--

CREATE TABLE `customer_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `transection_term_id` int(11) DEFAULT NULL,
  `common_id` int(11) DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_profiles`
--

INSERT INTO `customer_profiles` (`id`, `name`, `category_id`, `transection_term_id`, `common_id`, `address`, `phone`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(0, 'Walking Customer', NULL, NULL, NULL, NULL, '123456', 1, NULL, NULL, NULL);

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

--
-- Table structure for table `employee_accounts`
--

CREATE TABLE `employee_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transection_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `employee_positions`
--

CREATE TABLE `employee_positions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expenses_accounts`
--

CREATE TABLE `expenses_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` timestamp NULL DEFAULT NULL,
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expense_accounts`
--

CREATE TABLE `expense_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` int(11) NOT NULL,
  `transection_no` int(11) DEFAULT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) DEFAULT NULL,
  `credit` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expense_profiles`
--

CREATE TABLE `expense_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `inventories`
--

CREATE TABLE `inventories` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reorder_label` double(10,2) NOT NULL DEFAULT 0.00,
  `target_label` double(10,2) NOT NULL DEFAULT 0.00,
  `min_reorder_qty` double(10,2) NOT NULL DEFAULT 0.00,
  `received` double(10,2) NOT NULL DEFAULT 0.00,
  `on_order` double(10,2) NOT NULL DEFAULT 0.00,
  `srinkage` double(10,2) NOT NULL DEFAULT 0.00,
  `shiped` double(10,2) NOT NULL DEFAULT 0.00,
  `allocated` double(10,2) NOT NULL DEFAULT 0.00,
  `initial_label` double(10,2) NOT NULL DEFAULT 0.00,
  `on_hand` double(10,2) NOT NULL DEFAULT 0.00,
  `sales_return` double(10,2) NOT NULL DEFAULT 0.00,
  `purchase_return` double(10,2) NOT NULL DEFAULT 0.00,
  `available` double(10,2) NOT NULL DEFAULT 0.00,
  `courent_label` double(10,2) NOT NULL DEFAULT 0.00,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_04_02_193005_create_translations_table', 1),
(2, '2014_05_09_054104_create_roles_table', 1),
(3, '2014_06_12_000000_create_users_table', 1),
(4, '2014_06_12_100000_create_password_resets_table', 1),
(5, '2014_07_09_055338_create_role_users_table', 1),
(6, '2018_04_06_093842_create_employee_positions_table', 1),
(7, '2018_04_06_093914_create_employee_profiles_table', 1),
(8, '2018_04_06_093956_create_customer_categories_table', 1),
(9, '2018_04_06_094416_create_transaction_terms_table', 1),
(10, '2018_04_06_094505_create_customer_profiles_table', 1),
(11, '2018_04_06_094551_create_supplier_categories_table', 1),
(12, '2018_04_06_094615_create_supplier_profiles_table', 1),
(13, '2018_04_06_094804_create_store_house_locations_table', 1),
(14, '2018_04_06_094841_create_product_store_locations_table', 1),
(15, '2018_04_06_094930_create_product_categories_table', 1),
(16, '2018_04_06_095155_create_product_sales_offers_table', 1),
(17, '2018_04_06_095221_create_product_sales_discounts_table', 1),
(18, '2018_04_06_095248_create_product_taxes_table', 1),
(19, '2018_04_06_095451_create_product_quantity_measurements_table', 1),
(20, '2018_04_06_095531_create_product_profiles_table', 1),
(21, '2018_04_06_100149_create_purchase_orders_table', 1),
(22, '2018_04_06_100608_create_product_s_p_r_types_table', 1),
(23, '2018_04_06_100643_create_cash_books_table', 1),
(24, '2018_04_06_101553_create_inventories_table', 1),
(25, '2018_04_13_121307_create_purchase_details_table', 1),
(26, '2018_04_13_121835_create_sales_orders_table', 1),
(27, '2018_04_13_122004_create_sales_details_table', 1),
(28, '2018_04_13_122405_create_product_price_lists_table', 1),
(29, '2018_04_13_171211_create_shipper_profiles_table', 1),
(30, '2018_04_21_085219_create_customer_accounts_table', 1),
(31, '2018_04_22_153326_create_supplier_accounts_table', 1),
(32, '2018_04_27_053051_create_sales_discount_accounts_table', 1),
(33, '2018_04_27_081045_create_vat_accounts_table', 1),
(34, '2018_04_27_081243_create_sales_accounts_table', 1),
(35, '2018_04_27_081441_create_purchase_accounts_table', 1),
(36, '2018_04_27_081620_create_expenses_accounts_table', 1),
(37, '2018_04_27_081756_create_costof_goods_sold_accounts_table', 1),
(38, '2018_04_27_082446_create_sales_prices_table', 1),
(39, '2018_04_29_182211_create_employee_accounts_table', 1),
(40, '2018_05_11_110251_create_modules_table', 1),
(41, '2018_05_12_101712_create_purchase_temp_tables_table', 1),
(42, '2018_05_17_214954_create_sales_temtables_table', 1),
(43, '2018_05_23_160428_create_purchase_discount_accounts_table', 1),
(44, '2018_06_01_153844_create_owner_profiles_table', 1),
(45, '2018_06_01_153926_create_capital_accounts_table', 1),
(46, '2018_06_02_133951_create_expense_profiles_table', 1),
(47, '2018_06_02_134009_create_expense_accounts_table', 1),
(48, '2018_06_09_064839_create_sales_retrun_orders_table', 1),
(49, '2018_06_29_170230_create_shops_table', 1),
(50, '2018_06_30_162716_create_purchase_vat_accounts_table', 1),
(51, '2018_07_07_210351_create_advance_received_person_profiles_table', 1),
(52, '2018_07_07_210907_create_advance_receive_accounts_table', 1),
(53, '2018_07_07_210953_create_advance_paid_person_profiles_table', 1),
(54, '2018_07_07_211013_create_advance_paid_accounts_table', 1),
(55, '2018_07_07_211147_create_bank_account_profiles_table', 1),
(56, '2018_07_07_211241_create_bank_accounts_table', 1),
(57, '2018_07_07_211527_create_mobile_bank_accounts_profiles_table', 1),
(58, '2018_07_07_211540_create_mobile_bank_accounts_table', 1),
(59, '2018_08_03_185422_create_purchase_return_orders_table', 1),
(60, '2019_07_08_215035_create_language_lines_table', 1),
(61, '2020_10_22_000006_create_vendor_profiles_table', 1),
(62, '2020_12_25_192237_create_cash_profiles_table', 1),
(63, '2020_12_29_232949_create_account_heads_table', 1),
(64, '2020_12_30_004632_create_account_ledgers_table', 1),
(65, '2020_12_30_004655_create_account_level_ones_table', 1),
(66, '2020_12_30_004717_create_account_level_twos_table', 1),
(67, '2020_12_30_012655_create_account_details_table', 1),
(68, '2021_01_01_200203_create_setting_options_table', 1),
(69, '2021_01_01_230345_create_account_voucher_masters_table', 1);

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

--
-- Table structure for table `mobile_bank_accounts`
--

CREATE TABLE `mobile_bank_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `own_account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_no` int(11) DEFAULT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) DEFAULT NULL,
  `credit` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mobile_bank_accounts_profiles`
--

CREATE TABLE `mobile_bank_accounts_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `modules` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `owner_profiles`
--

CREATE TABLE `owner_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_price_lists`
--

CREATE TABLE `product_price_lists` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `barcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost_price` double(10,2) NOT NULL DEFAULT 0.00,
  `sales_price` double(10,2) NOT NULL DEFAULT 0.00,
  `qty` double(10,2) NOT NULL DEFAULT 0.00,
  `discount_rate` double(10,2) NOT NULL DEFAULT 0.00,
  `vat_rate` double(10,2) NOT NULL DEFAULT 0.00,
  `manufacture_date` date DEFAULT NULL,
  `expired_date` date DEFAULT NULL,
  `store_house_id` int(11) DEFAULT NULL,
  `purchase_details_ref` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_profiles`
--

CREATE TABLE `product_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Product_category_id` int(11) DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mesurement_id` int(11) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manufacturedCompany` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_quantity_measurements`
--

CREATE TABLE `product_quantity_measurements` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_sales_discounts`
--

CREATE TABLE `product_sales_discounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_rate` double(8,2) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_sales_offers`
--

CREATE TABLE `product_sales_offers` (
  `id` int(10) UNSIGNED NOT NULL,
  `offer_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_store_locations`
--

CREATE TABLE `product_store_locations` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_house_id` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_s_p_r_types`
--

CREATE TABLE `product_s_p_r_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_taxes`
--

CREATE TABLE `product_taxes` (
  `id` int(10) UNSIGNED NOT NULL,
  `tax_rate` double(8,2) NOT NULL,
  `start_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_accounts`
--

CREATE TABLE `purchase_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` timestamp NULL DEFAULT NULL,
  `ref_no` int(11) DEFAULT NULL,
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_details`
--

CREATE TABLE `purchase_details` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` double(10,2) DEFAULT NULL,
  `l_gross_cost_price` double(10,2) DEFAULT NULL,
  `price` double(10,2) DEFAULT NULL,
  `vat_rate` double(10,2) DEFAULT NULL,
  `discount_rate` double(10,2) DEFAULT NULL,
  `line_total` double(10,2) DEFAULT NULL,
  `return_ref` int(11) DEFAULT NULL,
  `preorder_ref` int(11) DEFAULT NULL,
  `return_order_id` int(11) DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_discount_accounts`
--

CREATE TABLE `purchase_discount_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` timestamp NULL DEFAULT NULL,
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `supplier_Id` int(11) NOT NULL,
  `return_ref` int(11) DEFAULT NULL,
  `preorder_ref` int(11) DEFAULT NULL,
  `order_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gross_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `net_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `payment_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `initial_payment` double(10,2) NOT NULL DEFAULT 0.00,
  `gross_discount` double(10,2) NOT NULL DEFAULT 0.00,
  `transection_type` int(11) NOT NULL,
  `order_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pre_order_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_delivery_date` datetime DEFAULT NULL,
  `gross_vat_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `employee_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_return` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_retrun_orders`
--

CREATE TABLE `purchase_retrun_orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `return_order_id` int(11) DEFAULT NULL,
  `return_supplier_Id` int(11) DEFAULT NULL,
  `return_order_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_gross_amount` double(10,2) DEFAULT NULL,
  `return_return_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `return_amount_received_supplier` double(10,2) NOT NULL DEFAULT 0.00,
  `return_gross_discount` double(10,2) NOT NULL DEFAULT 0.00,
  `return_return_ref` int(11) DEFAULT NULL,
  `return_transection_type` int(11) DEFAULT NULL,
  `return_order_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_gross_vat_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `return_employee_id` int(11) DEFAULT NULL,
  `purchase_return_due` double(10,2) NOT NULL DEFAULT 0.00,
  `return_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_temp_tables`
--

CREATE TABLE `purchase_temp_tables` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL,
  `barcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` double(10,2) NOT NULL DEFAULT 0.00,
  `cost_price` double(10,2) NOT NULL DEFAULT 0.00,
  `sales_price` double(10,2) NOT NULL DEFAULT 0.00,
  `vat_rate` double(10,2) DEFAULT NULL,
  `discount_rate` double(10,2) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_vat_accounts`
--

CREATE TABLE `purchase_vat_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` timestamp NULL DEFAULT NULL,
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `slug`, `permissions`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'admin', '{\"module_view\":true,\"module_add\":true,\"module_edit\":true,\"module_menu\":true,\"role_view\":true,\"role_add\":true,\"role_edit\":true,\"role_menu\":true,\"customer-report_view\":true,\"customer-report_add\":true,\"customer-report_edit\":true,\"customer-report_menu\":true,\"cash_view\":true,\"cash_add\":true,\"cash_edit\":true,\"cash_menu\":true,\"capital_view\":true,\"capital_add\":true,\"capital_edit\":true,\"capital_menu\":true,\"expense_view\":true,\"expense_add\":true,\"expense_edit\":true,\"expense_menu\":true,\"inventory_view\":true,\"inventory_add\":true,\"inventory_edit\":true,\"inventory_menu\":true,\"product_view\":true,\"product_add\":true,\"product_edit\":true,\"product_menu\":true,\"purchase_view\":true,\"purchase_add\":true,\"purchase_edit\":true,\"purchase_menu\":true,\"sales_view\":true,\"sales_add\":true,\"sales_edit\":true,\"sales_menu\":true,\"employee_view\":true,\"employee_add\":true,\"employee_edit\":true,\"employee_menu\":true,\"supplier_view\":true,\"supplier_add\":true,\"supplier_edit\":true,\"supplier_menu\":true,\"customer_view\":true,\"customer_add\":true,\"customer_edit\":true,\"customer_menu\":true,\"report_view\":true,\"report_add\":true,\"report_edit\":true,\"report_menu\":true,\"shipper_view\":true,\"shipper_add\":true,\"shipper_edit\":true,\"shipper_menu\":true,\"shop_view\":true,\"shop_add\":true,\"shop_edit\":true,\"shop_menu\":true}', NULL, NULL);

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

--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_users`
--

INSERT INTO `role_users` (`user_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL);

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

--
-- Table structure for table `sales_accounts`
--

CREATE TABLE `sales_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `offer_id` int(11) DEFAULT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` timestamp NULL DEFAULT NULL,
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_no` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales_details`
--

CREATE TABLE `sales_details` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lot_no` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `unique_barcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` double(10,2) DEFAULT NULL,
  `sales_price` double(10,2) DEFAULT NULL,
  `vat_rate` double(10,2) NOT NULL DEFAULT 0.00,
  `discount_rate` double(10,2) NOT NULL DEFAULT 0.00,
  `line_total` double(10,2) NOT NULL DEFAULT 0.00,
  `cost_line_total` double(10,2) NOT NULL DEFAULT 0.00,
  `return_ref` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales_discount_accounts`
--

CREATE TABLE `sales_discount_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `offer_id` int(11) DEFAULT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` timestamp NULL DEFAULT NULL,
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales_orders`
--

CREATE TABLE `sales_orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_Id` int(11) DEFAULT NULL,
  `order_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gross_amount` double(10,2) DEFAULT NULL,
  `payment_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `receive_amount_from_custome` double(10,2) NOT NULL DEFAULT 0.00,
  `initial_received` double(10,2) NOT NULL DEFAULT 0.00,
  `due_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `return_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `gross_discount` double(10,2) NOT NULL DEFAULT 0.00,
  `gross_total_cost` double(10,2) NOT NULL DEFAULT 0.00,
  `return_ref` int(11) DEFAULT NULL,
  `transection_type` int(11) DEFAULT NULL,
  `order_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pre_order_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_delivery_date` datetime DEFAULT NULL,
  `gross_vat_amount` double NOT NULL DEFAULT 0,
  `employee_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_return` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales_prices`
--

CREATE TABLE `sales_prices` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `barcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double(10,2) DEFAULT NULL,
  `unique_price` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales_retrun_orders`
--

CREATE TABLE `sales_retrun_orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `return_order_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `return_customer_Id` int(11) NOT NULL,
  `return_order_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `return_gross_amount` double(10,2) NOT NULL,
  `return_return_amount` double(10,2) NOT NULL DEFAULT 0.00,
  `return_amount_paid_customer` double(10,2) NOT NULL DEFAULT 0.00,
  `return_gross_discount` double(10,2) NOT NULL DEFAULT 0.00,
  `return_return_ref` int(11) DEFAULT NULL,
  `return_transection_type` int(11) NOT NULL,
  `return_order_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_gross_vat_amount` double NOT NULL DEFAULT 0,
  `return_employee_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `return_purchase_return` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales_temtables`
--

CREATE TABLE `sales_temtables` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `barcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` double(10,2) NOT NULL DEFAULT 0.00,
  `cost_price` double(10,2) NOT NULL DEFAULT 0.00,
  `sales_price` double(10,2) NOT NULL DEFAULT 0.00,
  `vat_rate` double(10,2) DEFAULT NULL,
  `discount_rate` double(10,2) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `setting_options`
--

CREATE TABLE `setting_options` (
  `id` int(10) UNSIGNED NOT NULL,
  `s_date` int(11) NOT NULL DEFAULT 1,
  `s_vat` int(11) NOT NULL DEFAULT 1,
  `s_discount_row` int(11) NOT NULL DEFAULT 1,
  `s_discount_total` int(11) NOT NULL DEFAULT 1,
  `s_sales_ledger` int(11) NOT NULL DEFAULT 8,
  `s_amount_receive_ledger` int(11) NOT NULL DEFAULT 2,
  `s_cost_goods_ledger` int(11) NOT NULL DEFAULT 5,
  `s_inventory_ledger` int(11) NOT NULL DEFAULT 6,
  `s_invoice_due_show` int(11) NOT NULL DEFAULT 0,
  `s_default_customer` int(11) NOT NULL DEFAULT 12,
  `s_discount_ledger` int(11) NOT NULL DEFAULT 9,
  `s_vatpayable_ledger` int(11) NOT NULL DEFAULT 10,
  `s_default_cash_ledger` int(11) NOT NULL DEFAULT 2,
  `s_default_vat_input_ledger` int(11) NOT NULL DEFAULT 14,
  `s_default_sales_return` int(11) NOT NULL DEFAULT 15,
  `p_default_discount_account` int(11) NOT NULL DEFAULT 16,
  `vat_expense_account` int(11) NOT NULL DEFAULT 11,
  `opening_adjustment_ledger` int(11) NOT NULL DEFAULT 7,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setting_options`
--

INSERT INTO `setting_options` (`id`, `s_date`, `s_vat`, `s_discount_row`, `s_discount_total`, `s_sales_ledger`, `s_amount_receive_ledger`, `s_cost_goods_ledger`, `s_inventory_ledger`, `s_invoice_due_show`, `s_default_customer`, `s_discount_ledger`, `s_vatpayable_ledger`, `s_default_cash_ledger`, `s_default_vat_input_ledger`, `s_default_sales_return`, `p_default_discount_account`, `vat_expense_account`, `opening_adjustment_ledger`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 1, 8, 2, 5, 6, 0, 12, 9, 10, 2, 14, 15, 16, 11, 7, NULL, NULL);

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

--
-- Table structure for table `shops`
--

CREATE TABLE `shops` (
  `id` int(10) UNSIGNED NOT NULL,
  `shop_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_layout` int(11) NOT NULL DEFAULT 1,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shops`
--

INSERT INTO `shops` (`id`, `shop_name`, `shop_email`, `shop_phone`, `shop_address`, `invoice_layout`, `image`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL);

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

--
-- Table structure for table `store_house_locations`
--

CREATE TABLE `store_house_locations` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `supplier_accounts`
--

CREATE TABLE `supplier_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` int(11) NOT NULL,
  `transection_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` datetime DEFAULT NULL,
  `debit` double(10,2) DEFAULT NULL,
  `credit` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `supplier_categories`
--

CREATE TABLE `supplier_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `supplier_profiles`
--

CREATE TABLE `supplier_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `transection_term_id` int(11) DEFAULT NULL,
  `common_id` int(11) DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supplier_profiles`
--

INSERT INTO `supplier_profiles` (`id`, `name`, `category_id`, `transection_term_id`, `common_id`, `address`, `image`, `phone`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(0, 'Opening Stock', NULL, NULL, NULL, NULL, NULL, '123456', 1, NULL, NULL, NULL);

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

--
-- Table structure for table `transaction_terms`
--

CREATE TABLE `transaction_terms` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vat_accounts`
--

CREATE TABLE `vat_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transection_date` timestamp NULL DEFAULT NULL,
  `debit` double(10,2) NOT NULL DEFAULT 0.00,
  `credit` double(10,2) NOT NULL DEFAULT 0.00,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_profiles`
--

CREATE TABLE `vendor_profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `transection_term_id` int(11) DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`);

--
-- Indexes for table `role_users`
--
ALTER TABLE `role_users`
  ADD UNIQUE KEY `role_users_user_id_role_id_unique` (`user_id`,`role_id`),
  ADD KEY `role_users_role_id_foreign` (`role_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_details`
--
ALTER TABLE `account_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `account_heads`
--
ALTER TABLE `account_heads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment id', AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `account_level_ones`
--
ALTER TABLE `account_level_ones`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `account_level_twos`
--
ALTER TABLE `account_level_twos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=127;

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

--
-- AUTO_INCREMENT for table `advance_paid_accounts`
--
ALTER TABLE `advance_paid_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `advance_paid_person_profiles`
--
ALTER TABLE `advance_paid_person_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `advance_received_person_profiles`
--
ALTER TABLE `advance_received_person_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `advance_receive_accounts`
--
ALTER TABLE `advance_receive_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_accounts`
--
ALTER TABLE `bank_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_account_profiles`
--
ALTER TABLE `bank_account_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `capital_accounts`
--
ALTER TABLE `capital_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_books`
--
ALTER TABLE `cash_books`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_profiles`
--
ALTER TABLE `cash_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `costof_goods_sold_accounts`
--
ALTER TABLE `costof_goods_sold_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_accounts`
--
ALTER TABLE `customer_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_categories`
--
ALTER TABLE `customer_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_profiles`
--
ALTER TABLE `customer_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `employee_accounts`
--
ALTER TABLE `employee_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_positions`
--
ALTER TABLE `employee_positions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses_accounts`
--
ALTER TABLE `expenses_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense_accounts`
--
ALTER TABLE `expense_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense_profiles`
--
ALTER TABLE `expense_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventories`
--
ALTER TABLE `inventories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `mobile_bank_accounts`
--
ALTER TABLE `mobile_bank_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mobile_bank_accounts_profiles`
--
ALTER TABLE `mobile_bank_accounts_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `owner_profiles`
--
ALTER TABLE `owner_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_categories`
--
ALTER TABLE `product_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_price_lists`
--
ALTER TABLE `product_price_lists`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_profiles`
--
ALTER TABLE `product_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_quantity_measurements`
--
ALTER TABLE `product_quantity_measurements`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_sales_discounts`
--
ALTER TABLE `product_sales_discounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_sales_offers`
--
ALTER TABLE `product_sales_offers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_store_locations`
--
ALTER TABLE `product_store_locations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_s_p_r_types`
--
ALTER TABLE `product_s_p_r_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_taxes`
--
ALTER TABLE `product_taxes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_accounts`
--
ALTER TABLE `purchase_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_details`
--
ALTER TABLE `purchase_details`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_discount_accounts`
--
ALTER TABLE `purchase_discount_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_retrun_orders`
--
ALTER TABLE `purchase_retrun_orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_temp_tables`
--
ALTER TABLE `purchase_temp_tables`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_vat_accounts`
--
ALTER TABLE `purchase_vat_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sales_accounts`
--
ALTER TABLE `sales_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales_details`
--
ALTER TABLE `sales_details`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales_discount_accounts`
--
ALTER TABLE `sales_discount_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales_orders`
--
ALTER TABLE `sales_orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales_prices`
--
ALTER TABLE `sales_prices`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales_retrun_orders`
--
ALTER TABLE `sales_retrun_orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales_temtables`
--
ALTER TABLE `sales_temtables`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `setting_options`
--
ALTER TABLE `setting_options`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `shops`
--
ALTER TABLE `shops`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `store_house_locations`
--
ALTER TABLE `store_house_locations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_accounts`
--
ALTER TABLE `supplier_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_categories`
--
ALTER TABLE `supplier_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_profiles`
--
ALTER TABLE `supplier_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `transaction_terms`
--
ALTER TABLE `transaction_terms`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vat_accounts`
--
ALTER TABLE `vat_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_profiles`
--
ALTER TABLE `vendor_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `role_users`
--
ALTER TABLE `role_users`
  ADD CONSTRAINT `role_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

