-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Mar 22, 2025 at 11:26 AM
-- Server version: 8.0.30
-- PHP Version: 8.3.2

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


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

--
-- Database: `erp_sohel`
--

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

--
-- Table structure for table `action_log`
--

CREATE TABLE `action_log` (
  `id` int NOT NULL,
  `log_key` tinytext COLLATE utf8mb4_general_ci,
  `time` int DEFAULT NULL,
  `details` text COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `action_log`
--

INSERT INTO `action_log` (`id`, `log_key`, `time`, `details`) VALUES
(944, 'customer_id1045_newCustomerAdd', 1742527355, '{\"data\":{\"data\":\"{\\\"invoice_print_type\\\":\\\"with_tp\\\",\\\"total_customer\\\":1}\"}}');

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

--
-- Table structure for table `additional_expense`
--

CREATE TABLE `additional_expense` (
  `id` int NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `createdOn` int DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `additional_expense`
--

INSERT INTO `additional_expense` (`id`, `title`, `createdOn`, `createdBy`, `modifiedOn`, `modifiedBy`, `isActive`) VALUES
(1, 'Laber cost', 1741932008, 46, 1741932019, 46, 1),
(2, 'Currting Bill', 1742310629, 46, 1742310629, 46, 1),
(3, 'bosta cutting', 1742310643, 46, 1742310643, 46, 1),
(4, 'dust cutting', 1742310649, 46, 1742310649, 46, 1);

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

--
-- Table structure for table `a_auto_head`
--

CREATE TABLE `a_auto_head` (
  `id` int NOT NULL,
  `auto_head_chart_id` int NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `a_auto_head`
--

INSERT INTO `a_auto_head` (`id`, `auto_head_chart_id`, `title`) VALUES
(1, 2, 'Cash Account'),
(2, 1, 'Capital'),
(3, 1, 'Purchase'),
(4, 3, ' Sale'),
(5, 1, 'Contra transaction charge'),
(9, 1, 'Sale Return'),
(11, 1, 'Employee Salary'),
(13, 3, 'Purchase Return'),
(14, 3, 'Product reject'),
(15, 1, 'Product reject process'),
(17, 1, 'Vat sale'),
(18, 3, 'Supplier Bonus'),
(19, 1, 'Balance Tranfer'),
(20, 1, 'Sale return process'),
(21, 1, 'Sale return process good'),
(22, 1, 'Sale return process expiry'),
(23, 1, 'Sale return process damage'),
(25, 9, 'Taqwa Account'),
(28, 9, 'Taqwa Expense'),
(30, 5, 'Company'),
(31, 1, 'Customer collection discount'),
(32, 1, 'Customer yearly discount'),
(33, 1, 'Vat purchase'),
(34, 1, 'Ait Purchase'),
(35, 1, 'Recoverable collection'),
(36, 1, 'Balance Transfer'),
(37, 1, 'Bad-Debt');

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

--
-- Table structure for table `a_auto_head_chart`
--

CREATE TABLE `a_auto_head_chart` (
  `id` int NOT NULL,
  `master_account_id` int NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `column_type` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `a_auto_head_chart`
--

INSERT INTO `a_auto_head_chart` (`id`, `master_account_id`, `title`, `column_type`) VALUES
(1, 5, 'Expense', 1),
(2, 1, 'Cash Account', 1),
(3, 7, 'Income', 2),
(4, 1, 'Bank Account', 1),
(5, 5, 'Commission', 1),
(6, 10, 'Agent', 1),
(7, 1, 'Payable', 1),
(8, 1, 'Recevable', 1),
(9, 11, 'Adjustment', 1);

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

--
-- Table structure for table `a_bank_info`
--

CREATE TABLE `a_bank_info` (
  `biID` int NOT NULL,
  `bID` int DEFAULT NULL,
  `hID` int NOT NULL DEFAULT '0',
  `biBank` tinytext COLLATE utf8mb4_general_ci NOT NULL,
  `biAcocunt` tinytext COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `a_bank_withdraw`
--

CREATE TABLE `a_bank_withdraw` (
  `bwID` int NOT NULL,
  `biID` int NOT NULL,
  `bID` int NOT NULL,
  `bwAmount` decimal(10,2) NOT NULL,
  `bwChqNo` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `bwChqDate` int NOT NULL,
  `bwPayTo` tinytext COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `a_charts_accounts`
--

CREATE TABLE `a_charts_accounts` (
  `id` int NOT NULL,
  `master_account_id` int NOT NULL,
  `title` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `system_chart` int NOT NULL DEFAULT '0',
  `createdBy` int NOT NULL DEFAULT '0',
  `createdOn` int NOT NULL DEFAULT '0',
  `modifiedBy` int NOT NULL DEFAULT '0',
  `modifiedOn` int NOT NULL DEFAULT '0',
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `a_charts_accounts`
--

INSERT INTO `a_charts_accounts` (`id`, `master_account_id`, `title`, `code`, `system_chart`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(3, 1, 'Advance', '5300', 2, 0, 0, 221, 1740671136, 1),
(10, 1, 'Sales Receivable', '5200', 7, 0, 0, 241, 1729076101, 1),
(11, 12, 'Administrative', '2200', 1, 0, 0, 241, 1729075902, 1),
(12, 1, 'Cash & Cash Equivalent', '5100', 3, 0, 0, 241, 1729076062, 1),
(13, 1, 'Director Loans', '5400', 0, 241, 1729076232, 241, 1729076232, 1),
(14, 1, 'Advance to Suppliers', '5500', 0, 241, 1729076249, 241, 1729076249, 1),
(15, 12, 'Purchase', '2100', 0, 241, 1729076287, 241, 1729076287, 1),
(16, 12, 'Sales and Marketing', '2300', 0, 241, 1729076313, 241, 1729076313, 1),
(17, 12, 'Distribution', '2400', 0, 241, 1729076330, 241, 1729076330, 1),
(18, 12, 'Factory', '2500', 0, 241, 1729076348, 241, 1729076348, 1),
(19, 12, 'Financial', '2600', 0, 241, 1729076372, 241, 1729076372, 1),
(20, 5, 'Property, Plant & Equipment', '6100', 0, 241, 1729076567, 241, 1729076567, 1),
(21, 5, 'Factory Construction & Renovat', '6200', 0, 241, 1729076588, 241, 1729076588, 1),
(22, 7, 'Revenue', '1001', 0, 241, 1729578337, 241, 1729578904, 1),
(23, 2, 'Accounts Payable', '7100', 0, 241, 1729580416, 241, 1729580416, 1),
(24, 2, 'Current Liabilities', '7000', 0, 241, 1729580733, 241, 1729580733, 1),
(25, 2, 'Non-Current Liabilities', '8000', 0, 241, 1729580938, 241, 1729580938, 1),
(26, 3, 'Equity', '10000', 0, 241, 1729581045, 241, 1729581045, 1),
(27, 11, 'Adjustment', '', 9, 0, 0, 0, 0, 1);

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

--
-- Table structure for table `a_employee_salary`
--

CREATE TABLE `a_employee_salary` (
  `esID` int NOT NULL,
  `eID` int NOT NULL,
  `esYear` int NOT NULL,
  `esMonth` tinyint NOT NULL,
  `esSalary` int NOT NULL,
  `esDeduction` int NOT NULL DEFAULT '0',
  `esPay` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `a_heads`
--

CREATE TABLE `a_heads` (
  `id` int NOT NULL,
  `charts_accounts_id` int NOT NULL,
  `title` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `system_head` int NOT NULL DEFAULT '0',
  `type` tinyint NOT NULL DEFAULT '0',
  `reference_id` int NOT NULL DEFAULT '0',
  `for_income` tinyint NOT NULL DEFAULT '0',
  `for_expense` tinyint NOT NULL DEFAULT '0',
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `a_heads`
--

INSERT INTO `a_heads` (`id`, `charts_accounts_id`, `title`, `code`, `system_head`, `type`, `reference_id`, `for_income`, `for_expense`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(1388, 10, 'Feed mill 1', 'SP-21', 1, 2, 21, 0, 0, 46, 1741944355, 46, 1741944355, 1),
(1389, 11, 'Capital', 'auto-1980889', 1, 5, 2, 0, 0, 46, 1741944355, 46, 1741944355, 1),
(1390, 11, 'Purchase', 'auto-4505668', 1, 5, 3, 0, 0, 46, 1741947440, 46, 1741947440, 1),
(1391, 10, 'customer 1', 'CUS1045', 1, 12, 1045, 0, 0, 46, 1742527355, 46, 1742527355, 1),
(1392, 12, ' Sale', 'auto-6358977', 1, 5, 4, 0, 0, 46, 1742571739, 46, 1742571739, 1),
(1393, 3, 'Cash Account', 'auto-693320', 1, 5, 1, 0, 0, 46, 1742571739, 46, 1742571739, 1);

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

--
-- Table structure for table `a_head_entry`
--

CREATE TABLE `a_head_entry` (
  `id` int NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `voucher_id` int NOT NULL,
  `head_id` int NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `base_id` int NOT NULL DEFAULT '0',
  `debit` double(18,6) NOT NULL,
  `credit` double(18,6) NOT NULL,
  `note` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` int NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `a_head_entry`
--

INSERT INTO `a_head_entry` (`id`, `code`, `voucher_id`, `head_id`, `user_id`, `base_id`, `debit`, `credit`, `note`, `time`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`) VALUES
(30485, NULL, 15249, 1388, 0, 0, 100.000000, 0.000000, 'Opening', 1719684000, 46, 1741944355, 46, 1741944355),
(30486, NULL, 15249, 1389, 0, 0, 0.000000, 100.000000, 'Opening', 1719684000, 46, 1741944355, 46, 1741944355),
(30487, NULL, 15250, 1390, 46, 0, 10000.000000, 0.000000, 'Purchase from Feed mill 1 1', 1741947440, 46, 1741947440, 46, 1741947440),
(30488, NULL, 15250, 1388, 46, 0, 0.000000, 10000.000000, 'Purchase from Feed mill 1 1', 1741947440, 46, 1741947440, 46, 1741947440),
(30489, NULL, 15251, 1390, 46, 0, 1100.000000, 0.000000, 'Purchase from Feed mill 1 11', 1742396521, 46, 1742396521, 46, 1742396521),
(30490, NULL, 15251, 1388, 46, 0, 0.000000, 1100.000000, 'Purchase from Feed mill 1 11', 1742396521, 46, 1742396521, 46, 1742396521),
(30491, NULL, 15252, 1390, 46, 0, 120000.000000, 0.000000, 'Purchase from Feed mill 1 22', 1742526775, 46, 1742526775, 46, 1742526775),
(30492, NULL, 15252, 1388, 46, 0, 0.000000, 120000.000000, 'Purchase from Feed mill 1 22', 1742526775, 46, 1742526775, 46, 1742526775),
(30493, NULL, 15253, 1391, 0, 0, 9000.000000, 0.000000, 'Sale customer 1 B1-2714', 1742571739, 46, 1742571739, 46, 1742571739),
(30494, NULL, 15253, 1392, 0, 0, 0.000000, 9000.000000, 'Sale customer 1 B1-2714', 1742571739, 46, 1742571739, 46, 1742571739),
(30495, NULL, 15254, 1391, 0, 0, 9000.000000, 0.000000, 'Sale customer 1 B1-2715', 1742571784, 46, 1742571784, 46, 1742571784),
(30496, NULL, 15254, 1392, 0, 0, 0.000000, 9000.000000, 'Sale customer 1 B1-2715', 1742571784, 46, 1742571784, 46, 1742571784),
(30497, NULL, 15255, 1391, 0, 0, 9900.000000, 0.000000, 'Sale customer 1 B1-2717', 1742617880, 46, 1742617880, 46, 1742617880),
(30498, NULL, 15255, 1392, 0, 0, 0.000000, 9900.000000, 'Sale customer 1 B1-2717', 1742617880, 46, 1742617880, 46, 1742617880);

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

--
-- Table structure for table `a_master_account`
--

CREATE TABLE `a_master_account` (
  `id` int NOT NULL,
  `title` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `type` tinyint NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `a_master_account`
--

INSERT INTO `a_master_account` (`id`, `title`, `code`, `type`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(1, 'Current Assets', '5000', 2, 18, 1418528531, 241, 1729075724, 1),
(2, 'Liabilities', '7000', 2, 18, 1418528563, 241, 1729580683, 1),
(3, 'Equity', '10000', 2, 18, 1418528602, 241, 1729581029, 1),
(4, 'Revenue', '', 2, 18, 1418528641, 18, 1418528641, 1),
(5, 'Non-Current Asset', '6000', 2, 1, 1419741900, 241, 1729076509, 1),
(6, 'Fixed Assets', '', 1, 1, 1419741936, 1, 1419741936, 1),
(7, 'Income', '1000', 2, 1, 1419741988, 221, 1729012146, 1),
(10, 'Nill', '0.0', 2, 1, 1419840347, 241, 1729580920, 1),
(11, 'Adjustment', '', 2, 1, 1419840347, 1, 1419840347, 1),
(12, 'Expenses', '2000', 1, 221, 1729012198, 241, 1729076448, 1);

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

--
-- Table structure for table `a_voucher_entry`
--

CREATE TABLE `a_voucher_entry` (
  `id` int NOT NULL,
  `user_id` int DEFAULT '0',
  `base_id` int NOT NULL DEFAULT '0',
  `code` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `type` tinyint NOT NULL,
  `reference` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `time` int NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `a_voucher_entry`
--

INSERT INTO `a_voucher_entry` (`id`, `user_id`, `base_id`, `code`, `type`, `reference`, `time`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`) VALUES
(15249, 0, 0, 'OP15249', 1, '1_21', 1719684000, 46, 1741944355, 46, 1741944355),
(15250, 46, 0, '', 2, '345', 1741947440, 46, 1741947440, 46, 1741947440),
(15251, 46, 0, '', 2, '348', 1742396521, 46, 1742396521, 46, 1742396521),
(15252, 46, 0, '', 2, '349', 1742526775, 46, 1742526775, 46, 1742526775),
(15253, 0, 0, 'SCC15253', 65, '2714', 1742571739, 46, 1742571739, 46, 1742571739),
(15254, 0, 0, 'SCC15254', 65, '2715', 1742571784, 46, 1742571784, 46, 1742571784),
(15255, 0, 0, 'SCC15255', 65, '2717', 1742617880, 46, 1742617880, 46, 1742617880);

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

--
-- Table structure for table `bank`
--

CREATE TABLE `bank` (
  `id` int NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `head_id` int NOT NULL DEFAULT '0',
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bank`
--

INSERT INTO `bank` (`id`, `name`, `head_id`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `status`) VALUES
(1, 'Dhaka Bank Ltd PLC', 1124, 221, 1726717603, 221, 1737007356, 1),
(2, 'bKash', 1125, 221, 1726717616, 221, 1726717616, 1),
(3, 'Rocket', 1126, 221, 1726717626, 221, 1726717626, 1),
(4, 'Nagad', 1127, 221, 1726717636, 221, 1726717636, 1),
(5, 'DBBL Agent Bank', 1128, 221, 1726717651, 221, 1726717651, 1),
(6, 'Bank Asia Agent Bank', 1129, 221, 1726717668, 221, 1726717668, 1),
(7, 'IBBL Agent Bank', 1130, 221, 1726717684, 221, 1726717684, 1),
(8, 'Union Bank PLC', 1131, 221, 1726718027, 241, 1737088136, 1),
(9, 'Agrani Bank PLC', 1158, 221, 1735030081, 241, 1737088065, 1);

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

--
-- Table structure for table `base`
--

CREATE TABLE `base` (
  `id` int NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(5) COLLATE utf8mb4_general_ci NOT NULL,
  `mpo_id` int NOT NULL,
  `area` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `district` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `data` text COLLATE utf8mb4_general_ci,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `base`
--

INSERT INTO `base` (`id`, `title`, `code`, `mpo_id`, `area`, `district`, `data`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `status`) VALUES
(22, 'Base 1', 'B1', 0, 'Dhaka', 'Dhaka', '{\"invoice_print_type\":\"with_tp\",\"total_customer\":1}', 46, 1742526937, 46, 1742527018, 1);

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

--
-- Table structure for table `bazar`
--

CREATE TABLE `bazar` (
  `id` int NOT NULL,
  `base_id` int NOT NULL,
  `title` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bazar_visit`
--

CREATE TABLE `bazar_visit` (
  `id` int NOT NULL,
  `bazar_id` int NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_general_ci,
  `entry_time` int NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` int NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `data` text COLLATE utf8mb4_general_ci,
  `createdBy` int DEFAULT NULL,
  `createdOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`id`, `title`, `data`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(1, 'SouthLine', '{\"user_product_production\":1,\"customer_default_credit_limit\":\"10000\",\"customer_default_due_date\":\"30\",\"use_product_production\":1,\"use_product_category\":0,\"for_voucher_entry_ledgers\":{\"93\":93,\"1126\":1126,\"1127\":1127,\"1128\":1128,\"1124\":1124,\"327\":327,\"318\":318,\"944\":944,\"346\":346,\"213\":213,\"320\":320,\"180\":180,\"329\":329,\"1093\":1093,\"1131\":1131,\"1125\":1125,\"1158\":1158,\"946\":946},\"chart_of_account\":{\"factory-overhead\":18,\"administrative-expenses\":0,\"selling-and-marketing-exp\":16,\"distribution-expenses\":17,\"cost-of-Production\":15,\"administrative-overhead\":11,\"employees-advance\":3,\"cash-and-cash-equivalent\":12,\"sales-receivable\":22,\"accounts-payable\":23,\"factory-construction-and-Renovation\":21,\"property-Plant-and-equipment\":20,\"financial-expenses\":19,\"advance-to-suppliers\":14,\"non-current-liabilities\":24}}', 46, 1518949266, 46, 1582959102, 1);

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

--
-- Table structure for table `contra_voucher`
--

CREATE TABLE `contra_voucher` (
  `id` int NOT NULL,
  `base_id` int NOT NULL DEFAULT '0',
  `debit` int NOT NULL,
  `credit` int NOT NULL,
  `amount` decimal(18,6) NOT NULL DEFAULT '0.000000',
  `reference` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `transaction_charge` decimal(18,6) NOT NULL DEFAULT '0.000000',
  `time` int NOT NULL,
  `note` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `countries` (
  `contID` int NOT NULL,
  `contCode` varchar(2) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `contName` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `countries` (`contID`, `contCode`, `contName`, `isActive`) VALUES
(1, 'AF', 'Afghanistan', 1),
(2, 'AL', 'Albania', 1),
(3, 'DZ', 'Algeria', 1),
(4, 'DS', 'American Samoa', 1),
(5, 'AD', 'Andorra', 1),
(6, 'AO', 'Angola', 1),
(7, 'AI', 'Anguilla', 1),
(8, 'AQ', 'Antarctica', 1),
(9, 'AG', 'Antigua and Barbuda', 1),
(10, 'AR', 'Argentina', 1),
(11, 'AM', 'Armenia', 1),
(12, 'AW', 'Aruba', 1),
(13, 'AU', 'Australia', 1),
(14, 'AT', 'Austria', 1),
(15, 'AZ', 'Azerbaijan', 1),
(16, 'BS', 'Bahamas', 1),
(17, 'BH', 'Bahrain', 1),
(18, 'BD', 'Bangladesh', 1),
(19, 'BB', 'Barbados', 1),
(20, 'BY', 'Belarus', 1),
(21, 'BE', 'Belgium', 1),
(22, 'BZ', 'Belize', 1),
(23, 'BJ', 'Benin', 1),
(24, 'BM', 'Bermuda', 1),
(25, 'BT', 'Bhutan', 1),
(26, 'BO', 'Bolivia', 1),
(27, 'BA', 'Bosnia and Herzegovina', 1),
(28, 'BW', 'Botswana', 1),
(29, 'BV', 'Bouvet Island', 1),
(30, 'BR', 'Brazil', 1),
(31, 'IO', 'British Indian Ocean Territory', 1),
(32, 'BN', 'Brunei Darussalam', 1),
(33, 'BG', 'Bulgaria', 1),
(34, 'BF', 'Burkina Faso', 1),
(35, 'BI', 'Burundi', 1),
(36, 'KH', 'Cambodia', 1),
(37, 'CM', 'Cameroon', 1),
(38, 'CA', 'Canada', 1),
(39, 'CV', 'Cape Verde', 1),
(40, 'KY', 'Cayman Islands', 1),
(41, 'CF', 'Central African Republic', 1),
(42, 'TD', 'Chad', 1),
(43, 'CL', 'Chile', 1),
(44, 'CN', 'China', 1),
(45, 'CX', 'Christmas Island', 1),
(46, 'CC', 'Cocos (Keeling) Islands', 1),
(47, 'CO', 'Colombia', 1),
(48, 'KM', 'Comoros', 1),
(49, 'CG', 'Congo', 1),
(50, 'CK', 'Cook Islands', 1),
(51, 'CR', 'Costa Rica', 1),
(52, 'HR', 'Croatia (Hrvatska)', 1),
(53, 'CU', 'Cuba', 1),
(54, 'CY', 'Cyprus', 1),
(55, 'CZ', 'Czech Republic', 1),
(56, 'DK', 'Denmark', 1),
(57, 'DJ', 'Djibouti', 1),
(58, 'DM', 'Dominica', 1),
(59, 'DO', 'Dominican Republic', 1),
(60, 'TP', 'East Timor', 1),
(61, 'EC', 'Ecuador', 1),
(62, 'EG', 'Egypt', 1),
(63, 'SV', 'El Salvador', 1),
(64, 'GQ', 'Equatorial Guinea', 1),
(65, 'ER', 'Eritrea', 1),
(66, 'EE', 'Estonia', 1),
(67, 'ET', 'Ethiopia', 1),
(68, 'FK', 'Falkland Islands (Malvinas)', 1),
(69, 'FO', 'Faroe Islands', 1),
(70, 'FJ', 'Fiji', 1),
(71, 'FI', 'Finland', 1),
(72, 'FR', 'France', 1),
(73, 'FX', 'France, Metropolitan', 1),
(74, 'GF', 'French Guiana', 1),
(75, 'PF', 'French Polynesia', 1),
(76, 'TF', 'French Southern Territories', 1),
(77, 'GA', 'Gabon', 1),
(78, 'GM', 'Gambia', 1),
(79, 'GE', 'Georgia', 1),
(80, 'DE', 'Germany', 1),
(81, 'GH', 'Ghana', 1),
(82, 'GI', 'Gibraltar', 1),
(83, 'GK', 'Guernsey', 1),
(84, 'GR', 'Greece', 1),
(85, 'GL', 'Greenland', 1),
(86, 'GD', 'Grenada', 1),
(87, 'GP', 'Guadeloupe', 1),
(88, 'GU', 'Guam', 1),
(89, 'GT', 'Guatemala', 1),
(90, 'GN', 'Guinea', 1),
(91, 'GW', 'Guinea-Bissau', 1),
(92, 'GY', 'Guyana', 1),
(93, 'HT', 'Haiti', 1),
(94, 'HM', 'Heard and Mc Donald Islands', 1),
(95, 'HN', 'Honduras', 1),
(96, 'HK', 'Hong Kong', 1),
(97, 'HU', 'Hungary', 1),
(98, 'IS', 'Iceland', 1),
(99, 'IN', 'India', 1),
(100, 'IM', 'Isle of Man', 1),
(101, 'ID', 'Indonesia', 1),
(102, 'IR', 'Iran (Islamic Republic of)', 1),
(103, 'IQ', 'Iraq', 1),
(104, 'IE', 'Ireland', 1),
(105, 'IL', 'Israel', 1),
(106, 'IT', 'Italy', 1),
(107, 'CI', 'Ivory Coast', 1),
(108, 'JE', 'Jersey', 1),
(109, 'JM', 'Jamaica', 1),
(110, 'JP', 'Japan', 1),
(111, 'JO', 'Jordan', 1),
(112, 'KZ', 'Kazakhstan', 1),
(113, 'KE', 'Kenya', 1),
(114, 'KI', 'Kiribati', 1),
(115, 'KP', 'Korea, Democratic People\'s Republic of', 1),
(116, 'KR', 'Korea, Republic of', 1),
(117, 'XK', 'Kosovo', 1),
(118, 'KW', 'Kuwait', 1),
(119, 'KG', 'Kyrgyzstan', 1),
(120, 'LA', 'Lao People\'s Democratic Republic', 1),
(121, 'LV', 'Latvia', 1),
(122, 'LB', 'Lebanon', 1),
(123, 'LS', 'Lesotho', 1),
(124, 'LR', 'Liberia', 1),
(125, 'LY', 'Libyan Arab Jamahiriya', 1),
(126, 'LI', 'Liechtenstein', 1),
(127, 'LT', 'Lithuania', 1),
(128, 'LU', 'Luxembourg', 1),
(129, 'MO', 'Macau', 1),
(130, 'MK', 'Macedonia', 1),
(131, 'MG', 'Madagascar', 1),
(132, 'MW', 'Malawi', 1),
(133, 'MY', 'Malaysia', 1),
(134, 'MV', 'Maldives', 1),
(135, 'ML', 'Mali', 1),
(136, 'MT', 'Malta', 1),
(137, 'MH', 'Marshall Islands', 1),
(138, 'MQ', 'Martinique', 1),
(139, 'MR', 'Mauritania', 1),
(140, 'MU', 'Mauritius', 1),
(141, 'TY', 'Mayotte', 1),
(142, 'MX', 'Mexico', 1),
(143, 'FM', 'Micronesia, Federated States of', 1),
(144, 'MD', 'Moldova, Republic of', 1),
(145, 'MC', 'Monaco', 1),
(146, 'MN', 'Mongolia', 1),
(147, 'ME', 'Montenegro', 1),
(148, 'MS', 'Montserrat', 1),
(149, 'MA', 'Morocco', 1),
(150, 'MZ', 'Mozambique', 1),
(151, 'MM', 'Myanmar', 1),
(152, 'NA', 'Namibia', 1),
(153, 'NR', 'Nauru', 1),
(154, 'NP', 'Nepal', 1),
(155, 'NL', 'Netherlands', 1),
(156, 'AN', 'Netherlands Antilles', 1),
(157, 'NC', 'New Caledonia', 1),
(158, 'NZ', 'New Zealand', 1),
(159, 'NI', 'Nicaragua', 1),
(160, 'NE', 'Niger', 1),
(161, 'NG', 'Nigeria', 1),
(162, 'NU', 'Niue', 1),
(163, 'NF', 'Norfolk Island', 1),
(164, 'MP', 'Northern Mariana Islands', 1),
(165, 'NO', 'Norway', 1),
(166, 'OM', 'Oman', 1),
(167, 'PK', 'Pakistan', 1),
(168, 'PW', 'Palau', 1),
(169, 'PS', 'Palestine', 1),
(170, 'PA', 'Panama', 1),
(171, 'PG', 'Papua New Guinea', 1),
(172, 'PY', 'Paraguay', 1),
(173, 'PE', 'Peru', 1),
(174, 'PH', 'Philippines', 1),
(175, 'PN', 'Pitcairn', 1),
(176, 'PL', 'Poland', 1),
(177, 'PT', 'Portugal', 1),
(178, 'PR', 'Puerto Rico', 1),
(179, 'QA', 'Qatar', 1),
(180, 'RE', 'Reunion', 1),
(181, 'RO', 'Romania', 1),
(182, 'RU', 'Russian Federation', 1),
(183, 'RW', 'Rwanda', 1),
(184, 'KN', 'Saint Kitts and Nevis', 1),
(185, 'LC', 'Saint Lucia', 1),
(186, 'VC', 'Saint Vincent and the Grenadines', 1),
(187, 'WS', 'Samoa', 1),
(188, 'SM', 'San Marino', 1),
(189, 'ST', 'Sao Tome and Principe', 1),
(190, 'SA', 'Saudi Arabia', 1),
(191, 'SN', 'Senegal', 1),
(192, 'RS', 'Serbia', 1),
(193, 'SC', 'Seychelles', 1),
(194, 'SL', 'Sierra Leone', 1),
(195, 'SG', 'Singapore', 1),
(196, 'SK', 'Slovakia', 1),
(197, 'SI', 'Slovenia', 1),
(198, 'SB', 'Solomon Islands', 1),
(199, 'SO', 'Somalia', 1),
(200, 'ZA', 'South Africa', 1),
(201, 'GS', 'South Georgia South Sandwich Islands', 1),
(202, 'ES', 'Spain', 1),
(203, 'LK', 'Sri Lanka', 1),
(204, 'SH', 'St. Helena', 1),
(205, 'PM', 'St. Pierre and Miquelon', 1),
(206, 'SD', 'Sudan', 1),
(207, 'SR', 'Suriname', 1),
(208, 'SJ', 'Svalbard and Jan Mayen Islands', 1),
(209, 'SZ', 'Swaziland', 1),
(210, 'SE', 'Sweden', 1),
(211, 'CH', 'Switzerland', 1),
(212, 'SY', 'Syrian Arab Republic', 1),
(213, 'TW', 'Taiwan', 1),
(214, 'TJ', 'Tajikistan', 1),
(215, 'TZ', 'Tanzania, United Republic of', 1),
(216, 'TH', 'Thailand', 1),
(217, 'TG', 'Togo', 1),
(218, 'TK', 'Tokelau', 1),
(219, 'TO', 'Tonga', 1),
(220, 'TT', 'Trinidad and Tobago', 1),
(221, 'TN', 'Tunisia', 1),
(222, 'TR', 'Turkey', 1),
(223, 'TM', 'Turkmenistan', 1),
(224, 'TC', 'Turks and Caicos Islands', 1),
(225, 'TV', 'Tuvalu', 1),
(226, 'UG', 'Uganda', 1),
(227, 'UA', 'Ukraine', 1),
(228, 'AE', 'United Arab Emirates', 1),
(229, 'GB', 'United Kingdom', 1),
(230, 'US', 'United States', 1),
(231, 'UM', 'United States minor outlying islands', 1),
(232, 'UY', 'Uruguay', 1),
(233, 'UZ', 'Uzbekistan', 1),
(234, 'VU', 'Vanuatu', 1),
(235, 'VA', 'Vatican City State', 1),
(236, 'VE', 'Venezuela', 1),
(237, 'VN', 'Vietnam', 1),
(238, 'VG', 'Virgin Islands (British)', 1),
(239, 'VI', 'Virgin Islands (U.S.)', 1),
(240, 'WF', 'Wallis and Futuna Islands', 1),
(241, 'EH', 'Western Sahara', 1),
(242, 'YE', 'Yemen', 1),
(243, 'ZR', 'Zaire', 1),
(244, 'ZM', 'Zambia', 1),
(245, 'ZW', 'Zimbabwe', 1);

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

--
-- Table structure for table `crone_run_log`
--

CREATE TABLE `crone_run_log` (
  `crlID` int NOT NULL,
  `crlTime` int NOT NULL,
  `crlTimeText` varchar(50) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id` int NOT NULL,
  `base_id` int NOT NULL,
  `bazar_id` int NOT NULL DEFAULT '0',
  `customer_category_id` int NOT NULL DEFAULT '0',
  `code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `head_id` int NOT NULL DEFAULT '0',
  `due_day` int DEFAULT '0',
  `mobile` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `owner_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gender` tinyint DEFAULT '0',
  `DOB` int DEFAULT NULL,
  `address` tinytext COLLATE utf8mb4_general_ci,
  `email` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pass_salt` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bazar` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `data` longtext COLLATE utf8mb4_general_ci,
  `createdBy` int DEFAULT NULL,
  `createdOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`id`, `base_id`, `bazar_id`, `customer_category_id`, `code`, `head_id`, `due_day`, `mobile`, `name`, `owner_name`, `gender`, `DOB`, `address`, `email`, `password`, `pass_salt`, `bazar`, `data`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(1045, 22, 0, 1, 'B1-0001', 1391, 0, '0154', 'customer 1', 'salam', 0, NULL, '11', '', NULL, NULL, NULL, '{\"credit_limit\":null,\"district\":\"11\",\"police_station\":\"11\"}', 46, 1742527355, 46, 1742528920, 1);

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

--
-- Table structure for table `customer_amount_receive`
--

CREATE TABLE `customer_amount_receive` (
  `id` int NOT NULL,
  `customer_id` int NOT NULL,
  `mpo_id` int NOT NULL,
  `voucher_id` int NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `time` int NOT NULL,
  `note` varchar(300) COLLATE utf8mb4_general_ci NOT NULL,
  `confirm_by` int NOT NULL DEFAULT '0',
  `confirm_time` int NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `customer_category`
--

CREATE TABLE `customer_category` (
  `id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer_category`
--

INSERT INTO `customer_category` (`id`, `title`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(1, 'Reguler', 221, 1737454870, 221, 1737454870, 1),
(2, 'Defaulter', 221, 1737454885, 221, 1737454885, 1),
(3, 'No Business', 221, 1737454922, 221, 1737454922, 1),
(4, 'Transfer', 221, 1737454937, 221, 1737454937, 1);

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

--
-- Table structure for table `customer_visit`
--

CREATE TABLE `customer_visit` (
  `id` int NOT NULL,
  `customer_id` int NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_general_ci,
  `entry_time` int NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `customer_visit_finished_product`
--

CREATE TABLE `customer_visit_finished_product` (
  `id` int NOT NULL,
  `customer_visit_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quaintity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `customer_visit_gift_product`
--

CREATE TABLE `customer_visit_gift_product` (
  `id` int NOT NULL,
  `customer_visit_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quaintity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `deposit_request`
--

CREATE TABLE `deposit_request` (
  `id` int NOT NULL,
  `bank_id` int NOT NULL,
  `time` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL DEFAULT '0',
  `amount` decimal(16,4) NOT NULL DEFAULT '0.0000',
  `note` text COLLATE utf8mb4_general_ci,
  `status` tinyint NOT NULL DEFAULT '1',
  `action_by` int NOT NULL DEFAULT '0',
  `action_time` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `districts` (
  `distID` int NOT NULL,
  `contID` int NOT NULL DEFAULT '18',
  `distTitle` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `distData` text COLLATE utf8mb4_general_ci,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `districts` (`distID`, `contID`, `distTitle`, `distData`, `isActive`) VALUES
(1, 18, 'Dhaka', NULL, 1),
(2, 18, 'Faridpur', NULL, 1),
(3, 18, 'Natore', '{\"lang\":[]}', 1),
(4, 18, 'Rajshahi', NULL, 1),
(5, 18, 'Alfadanga', NULL, 1),
(6, 18, 'Nowpara', '{\"lang\":[]}', 1),
(7, 18, 'Nagarkanda', '{\"lang\":[]}', 1),
(8, 18, 'Kashiani', '[]', 1),
(9, 18, 'Alangkhali', '{\"lang\":[]}', 1),
(10, 18, 'Vatiapara', '[]', 1),
(11, 18, 'Kathalbari Ghat', '[]', 1),
(12, 18, 'Sosrail', '{\"lang\":[]}', 1),
(13, 18, 'Shibgati', '[]', 1),
(14, 18, 'Muksudpur', '[]', 1),
(15, 18, 'Madhukhali', '[]', 1),
(16, 18, 'Shator', '[]', 1),
(17, 18, 'Boalmari', '[]', 1),
(18, 18, 'Moyendia', '{\"lang\":[]}', 1),
(19, 18, 'Sonapur', '[]', 1),
(20, 18, 'Shaltha', '[]', 1),
(21, 99, 'Sealdah', '[]', 1),
(22, 99, 'Maniktala', '[]', 1),
(23, 99, 'Ultatadanga', '[]', 1),
(24, 99, 'Baguihati', '[]', 1),
(25, 99, 'Holdiram', '[]', 1),
(26, 99, 'Airport 01 No.', '[]', 1),
(27, 99, 'Maddhamgram', '[]', 1),
(28, 99, 'Barasat', '[]', 1),
(29, 99, 'Habra', '[]', 1),
(30, 99, 'Petrapole', '[]', 1),
(31, 99, 'Petrapole', '{\"lang\":[]}', 1),
(32, 18, 'Benapole', '[]', 1);

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

--
-- Table structure for table `doctor`
--

CREATE TABLE `doctor` (
  `id` int NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `base_id` int NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `address` varchar(200) COLLATE utf8mb4_general_ci DEFAULT '',
  `category` tinyint NOT NULL,
  `type` tinyint NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `doctor_products`
--

CREATE TABLE `doctor_products` (
  `id` int NOT NULL,
  `doctor_id` int NOT NULL,
  `product_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `doctor_visit`
--

CREATE TABLE `doctor_visit` (
  `id` int NOT NULL,
  `doctor_id` int NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `prescription` int NOT NULL,
  `note` text COLLATE utf8mb4_general_ci,
  `entry_time` int NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `doctor_visit_finished_product`
--

CREATE TABLE `doctor_visit_finished_product` (
  `id` int NOT NULL,
  `doctor_visit_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quaintity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `doctor_visit_gift_product`
--

CREATE TABLE `doctor_visit_gift_product` (
  `id` int NOT NULL,
  `doctor_visit_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quaintity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` int NOT NULL,
  `designation_id` int NOT NULL,
  `department_id` int NOT NULL,
  `supID` int NOT NULL DEFAULT '0',
  `name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `head_id` int NOT NULL DEFAULT '0',
  `father` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `mother` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `date_of_birth` int NOT NULL DEFAULT '0',
  `date_of_join` int NOT NULL DEFAULT '0',
  `last_salary_date` int NOT NULL DEFAULT '0',
  `salary` int NOT NULL DEFAULT '0',
  `NID` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `present_address` varchar(200) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `parmanent_address` varchar(200) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `email` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `employee_department`
--

CREATE TABLE `employee_department` (
  `id` int NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_department`
--

INSERT INTO `employee_department` (`id`, `title`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(1, 'Sales and Marketing', 221, 1739461725, 221, 1739461725, 1),
(2, 'Accounts', 221, 1739461733, 221, 1739461733, 1),
(3, 'QC & Production', 221, 1739461764, 221, 1739461764, 1),
(4, 'HR & Admin', 221, 1739461776, 221, 1739461776, 1),
(5, 'Distribution', 221, 1739461786, 221, 1739461786, 1),
(6, 'Supply Chain Management', 221, 1739461799, 221, 1739461820, 1),
(7, 'Production', 221, 1741189596, 221, 1741189596, 1);

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

--
-- Table structure for table `employee_designation`
--

CREATE TABLE `employee_designation` (
  `id` int NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_designation`
--

INSERT INTO `employee_designation` (`id`, `title`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(1, 'Manager', 46, 1577977776, 46, 1577977776, 1),
(2, 'MPO', 46, 1577988538, 46, 1598630191, 1),
(3, 'Office Assistant', 46, 1578118323, 46, 1578118323, 1),
(14, 'Distribution Officer', 221, 1725557715, 221, 1725557715, 1),
(15, 'Jr. Officer', 221, 1725557742, 221, 1741189732, 1),
(16, 'QC Officer', 221, 1725557759, 221, 1725557759, 1),
(17, 'Asstt. Field Manager', 221, 1725557783, 221, 1725557783, 1),
(18, 'Operator Assistant', 221, 1725557810, 221, 1725557810, 1),
(19, 'Distribution Assistant', 221, 1725557826, 221, 1725557826, 1),
(20, 'Security Guard', 221, 1725557861, 221, 1725557861, 1),
(21, 'Managing Director', 221, 1731639450, 221, 1731639450, 1),
(22, 'Sales Co-Ordinator', 221, 1741189772, 221, 1741189772, 1),
(23, 'Director', 221, 1741190127, 221, 1741190127, 1);

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

--
-- Table structure for table `employee_salary`
--

CREATE TABLE `employee_salary` (
  `id` int NOT NULL,
  `employee_id` int DEFAULT NULL,
  `salary_date` int DEFAULT NULL,
  `pay_date` int DEFAULT NULL,
  `salary` decimal(16,4) DEFAULT NULL,
  `allowance` decimal(16,4) DEFAULT NULL,
  `total` decimal(16,4) DEFAULT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `employee_salary_allowance`
--

CREATE TABLE `employee_salary_allowance` (
  `id` int NOT NULL,
  `salary_id` int NOT NULL,
  `salary_allowance_id` int NOT NULL,
  `salary_period` int NOT NULL,
  `amount` decimal(16,4) NOT NULL DEFAULT '0.0000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `gift_distribute`
--

CREATE TABLE `gift_distribute` (
  `id` int NOT NULL,
  `code` varchar(15) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `user_id` int NOT NULL,
  `base_id` int NOT NULL DEFAULT '0',
  `date` int NOT NULL,
  `note` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `gift_distribute_product`
--

CREATE TABLE `gift_distribute_product` (
  `id` int NOT NULL,
  `gift_distribute_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `tp` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `honorarium_evaluation`
--

CREATE TABLE `honorarium_evaluation` (
  `id` int NOT NULL,
  `base_id` int NOT NULL,
  `doctor_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `contribute` tinyint NOT NULL DEFAULT '0',
  `start_date` int DEFAULT NULL,
  `end_date` int DEFAULT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `module`
--

CREATE TABLE `module` (
  `id` int NOT NULL,
  `parent` int DEFAULT '0',
  `title` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `slug` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `folder` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `page_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sequence` int DEFAULT NULL,
  `for_home` int NOT NULL DEFAULT '0',
  `color` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `text_color` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `icon` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `module`
--

INSERT INTO `module` (`id`, `parent`, `title`, `slug`, `folder`, `page_name`, `sequence`, `for_home`, `color`, `text_color`, `icon`, `isActive`) VALUES
(1, 3, 'Module', 'module', 'common', 'modul.php', 11, 0, '', '', '', 1),
(2, 0, 'Accounts', 'n', 'common', 'n', 7, 0, '', '', '', 1),
(3, 0, 'Information', 'n', 'common', 'n', 8, 0, '', '', '', 1),
(4, 0, 'Users', 'users', 'common', 'users.php', 9, 0, '', '', '', 1),
(5, 3, 'Site Settings', 'site_settings', 'common', 'settings.php', 8, 0, '', '', '', 1),
(6, 95, 'Purchase', 'purchase', 'operation', 'purchase/purchase.php', 1, 0, '', '', '', 1),
(7, 102, 'Products', 'products', 'info', 'products.php', 1, 0, 'FF1D09', '000000', '', 1),
(8, 2, 'Supplier', 'supplyer', 'info', 'supplyer.php', 13, 0, 'FF1D09', '000000', '', 1),
(9, 95, 'Purchase List', 'purchase_list', 'list', 'purchase_list.php', 2, 0, 'FF1D09', '000000', '', 1),
(10, 3, 'Employee Designation', 'employee-designation', 'info', 'employee_designation.php', 9, 0, '', '', '', 1),
(11, 3, 'Employee', 'employee', 'info', 'employee.php', 2, 0, '', '', '', 1),
(12, 0, 'Sale', 'n', '', '', 2, 0, 'FF1D09', '000000', '', 1),
(13, 12, 'Transaction with customer', 'customer_transaction', 'account', 'customer_transaction.php', 5, 0, 'FF1D09', '000000', '', 1),
(14, 2, 'Cash flow', 'cash_flow', 'account', 'cash_flow.php', 1, 0, 'FF1D09', '000000', '', 1),
(15, 12, 'Gift distribute', 'gift_distribute', 'operation', 'sale/gift_distribute.php', 3, 0, 'FF1D09', '000000', '', 0),
(16, 2, 'Transaction with supplier', 'supTransaction', 'account', 'supTransaction.php', 11, 0, 'FF1D09', '000000', '', 1),
(17, 2, 'Customer collection confirm', 'customer-collection-confirm', 'account', 'customer-collection-confirm.php', 1, 0, 'FF1D09', '000000', '', 1),
(19, 96, 'Ledger statement', 'ledgerStatement', 'account', 'headStatement.php', 9, 0, 'FF1D09', '000000', '', 1),
(20, 96, 'Supplyer Statment', 'dlSupStatment', 'reports/supplier', 'dlSupStatment.php', 11, 0, '', '', '', 1),
(21, 0, 'Production', 'n', 'n', 'n', 1, 0, NULL, NULL, NULL, 0),
(22, 21, 'Manufacture', 'manufacture', 'operation/production', 'manufacture.php', 1, 0, 'FF1D09', '000000', '', 0),
(23, 96, 'Product Statement', 'productStatement', 'reports', 'productStatement.php', 7, 0, 'FF1D09', '000000', '', 1),
(24, 101, ' Return, Damage & Expiry Repor', 'return_damage_expiry_repor', 'reports', 'return_damage_expiry_repor.php', 1, 0, 'FF1D09', 'EDFF2F', '', 0),
(25, 2, 'Income', 'income', 'account', 'income.php', 2, 0, 'FF1D09', '000000', '', 1),
(26, 2, 'Expense', 'expense', 'account', 'expense.php', 3, 0, 'FF1D09', '000000', '', 1),
(27, 3, 'Base', 'base', 'info', 'base.php', 6, 0, 'FF1D09', '000000', '', 1),
(28, 12, 'Supplier Summery', 'supplierSummery', 'account', 'supplierSummery.php', 13, 0, '', '', '', 1),
(29, 21, 'Manufacture List', 'manufacture-list', 'list', 'manufacture-list.php', 3, 0, 'FF1D09', '000000', '', 0),
(30, 2, 'User to User Cash', 'userToUserCash', 'account', 'userToUserCash.php', 12, 0, '', '', '', 1),
(31, 101, 'Closing Report', 'closingReport', 'reports', 'closingReport.php', 8, 0, 'FF1D09', '000000', '', 1),
(32, 21, 'Packaging', 'packaging', 'operation/production', 'packaging.php', 2, 0, 'FF1D09', '000000', '', 0),
(33, 101, 'Protibedon', 'protibedon', 'reports', 'protibedon.php', 9, 0, 'FF1D09', '000000', '', 0),
(34, 21, 'Packaging List', 'packaging-list', 'list', 'packaging-list.php', 4, 0, 'FF1D09', '000000', '', 0),
(35, 101, 'Product Report', 'product-report', 'reports', 'product_report.php', 1, 0, 'FF1D09', 'EDFF2F', '', 1),
(36, 101, 'Item wise sales', 'item_wise_sales', 'reports', 'item_wise_sales.php', 1, 0, 'FF1D09', 'EDFF2F', '', 1),
(37, 102, 'Stock', 'productReport', 'reports', 'productReport.php', 2, 0, 'FF1D09', '000000', '', 1),
(38, 12, 'Sale List', 'sale_list', 'list', 'sale_list.php', 2, 0, 'FF1D09', '000000', '', 1),
(39, 101, 'Sales Report', 'sales-report', 'reports', 'sales_report.php', 1, 0, 'FF1D09', 'EDFF2F', '', 1),
(40, 12, 'Sale Draft List', 'saleDraftList', 'operation', 'saleDraftList.php', 10, 0, '', '', '', 0),
(41, 101, ' Sales discount & Avg Sales Value (SP)', 'sales-discount-and-avg-sales-value-sp', 'reports', 'sales_discount_avg_value_sp.php', 1, 0, 'FF1D09', 'EDFF2F', '', 0),
(42, 101, 'Credit Note Report', 'credit-note-report', 'reports', 'credit_note_report.php', 1, 0, 'FF1D09', 'EDFF2F', '', 1),
(43, 2, 'Employee Salary Report', 'empSalaryReport', 'reports', 'empSalaryReport.php', 14, 0, '', '', '', 0),
(44, 96, 'User Statement', 'user-statement', 'reports', 'user_statement.php', 11, 0, '', '', '', 1),
(45, 101, 'User Balance', 'user-balance', 'reports', 'user_balance.php', 12, 0, '8533FF', '000000', '', 1),
(46, 12, 'Sale Return List', 'sale-return-list', 'list', 'sale_return_list.php', 9, 0, 'FF1D09', '000000', '', 0),
(47, 12, 'Employee Due Report', 'empDueReport', 'reports', 'empDueReport.php', 15, 0, '', '', '', 0),
(48, 101, 'Customer visit', 'customer-visit-list', 'reports', 'customer_visit_list.php', 12, 0, '8533FF', '000000', '', 0),
(49, 101, 'Bazar visit', 'bazar-visit-list', 'reports', 'bazar_visit_list.php', 12, 0, '8533FF', '000000', '', 0),
(50, 101, 'Doctor visit', 'doctor-visit-list', 'reports', 'doctor_visit_list.php', 12, 0, '8533FF', '000000', '', 0),
(51, 2, 'Main account', 'main-account', 'account', 'main-account.php', 8, 0, 'FF1D09', '000000', '', 1),
(52, 2, 'Chart of Accounts', 'charts_accounts', 'info', 'charts_of_accounts.php', 7, 0, 'FF1D09', '000000', '', 1),
(53, 2, 'Ledger', 'ledger', 'account', 'heads.php', 6, 0, 'FF1D09', '000000', '', 1),
(54, 102, 'Reject entry', 'reject-entry', 'operation', 'inventory/reject-entry.php', 1, 0, 'FF1D09', '000000', '', 1),
(55, 102, 'Reject list', 'reject-list', 'list', 'reject-list.php', 1, 0, 'FF1D09', '000000', '', 1),
(56, 2, 'Voucher entry', 'voucher-entry', 'account', 'voucher_entry.php', 1, 0, 'FF1D09', '000000', '', 1),
(57, 2, 'Voucher list', 'voucher-list', 'account', 'voucher_list.php', 1, 0, 'FF1D09', '000000', '', 1),
(58, 2, 'Bank', 'bank', 'info', 'bank.php', 16, 0, '', '', '', 1),
(59, 2, 'MPO deposit request', 'mpo-deposit-request', 'account', 'mpo_deposit_request.php', 4, 0, 'FF1D09', '000000', '', 0),
(60, 2, 'Recoverable collection', 'recoverable-collection', 'account', 'recoverable_collection.php', 5, 0, 'FF1D09', '000000', '', 1),
(61, 3, 'Products category', 'productCategory', 'info', 'productCategory.php', 4, 0, 'FF1D10', '000000', '', 1),
(62, 2, 'Transaction with person', 'transactionWithPreson', 'account', 'transactionWithPreson.php', 10, 0, '', '', '', 1),
(63, 101, 'Protibedon', 'somitiProtibedon', 'reports', 'somitiProtibedon.php', 1, 0, 'FF1D09', 'EDFF2F', '', 0),
(64, 101, 'Produc In Out Report', 'productInOutReport', 'reports', 'productInOutReport.php', 11, 0, '57FF57', '000000', '', 1),
(65, 95, 'Purchase Draft List', 'purchaseDraftList', 'list', 'purchaseDraftList.php', 6, 0, '', '', '', 0),
(67, 2, 'Profit withdrawal', 'profitWithdrawal', 'account', 'profitWithdrawal.php', 15, 0, 'FF1D09', '000000', '', 0),
(68, 95, 'Purchase return', 'products-purchase-return', 'operation', 'purchase/return.php', 5, 0, 'FF1D10', '000000', '', 0),
(69, 12, 'Sale Update', 'sale-update', 'operation/sale', 'update.php', 7, 0, 'FF1D09', '000000', '', 1),
(70, 12, 'Pending orders', 'productsSaleDraftList', 'operation', 'productsSaleDraftList.php', 6, 0, 'FF1D09', '000000', '', 0),
(71, 95, 'Supplier Wise Purchase Report', 'supplierWisePurchaseReport', 'reports', 'supplierWisePurchaseReport.php', 8, 0, 'FF1D09', '000000', '', 1),
(72, 95, 'User Wise Purchase Report', 'userPurchaseReport', 'reports', 'userPurchaseReport.php', 7, 0, 'FF1D09', '000000', '', 1),
(73, 12, 'Sale', 'sale', 'operation', 'sale/sale.php', 1, 0, 'FF1D09', '000000', '', 1),
(74, 2, 'Bank Deposit', 'bankDeposit', 'account', 'bankDeposit.php', 17, 0, '', '', '', 1),
(75, 3, 'Persons', 'persons', 'info', 'persons.php', 3, 0, '', '', '', 1),
(76, 101, 'Doctor List', 'doctor-list', 'reports', 'doctor_list.php', NULL, 0, NULL, NULL, NULL, 0),
(77, 101, 'Customer zero balance', 'customer-zero-balance', 'reports', 'customer_zero_balance.php', 1, 0, 'FF1D09', 'EDFF2F', '', 1),
(78, 101, 'Prescription Survey Report', 'prescription_survey_report', 'reports', 'prescription_survey_report.php', NULL, 0, NULL, NULL, NULL, 0),
(79, 96, 'Trial Balance', 'trial-balance', 'reports', 'trial-balance.php', 2, 0, '', '', '', 1),
(80, 3, 'Employer department', 'employer-department', 'info', 'employer-department.php', NULL, 0, NULL, NULL, NULL, 1),
(81, 3, 'Salary Allowance', 'salary_allowance', 'info', 'salary_allowance.php', NULL, 0, NULL, NULL, NULL, 1),
(82, 96, 'General Ledger Summary', 'general-ledger-summary', 'reports', 'general-ledger-summary.php', 2, 0, '', '', '', 1),
(83, 4, 'Admin Group', 'admin_group', 'common', 'admin_group.php', 1, 0, '', '', '', 1),
(84, 4, 'Privilege', 'privilege', 'common', 'privilege.php', 2, 0, '', '', '', 1),
(85, 4, 'Permission', 'permission', 'common', 'permission.php', 3, 0, '', '', '', 1),
(86, 3, 'Profile', 'profile', 'common', 'profile.php', 8, 0, 'FF1D09', '000000', '', 1),
(87, 12, 'Sale return', 'products-sale-return', 'operation', 'sale/return.php', 8, 0, 'FF1D10', '000000', '', 0),
(88, 3, 'Unit', 'unit', 'info', 'unit.php', 10, 0, '', '', '', 1),
(89, 2, 'Balance Transfer', 'balance_transfer', 'account', 'balance_transfer.php', 21, 0, '', '', '', 1),
(90, 3, 'Bank Info', 'banks', 'account', 'banks.php', 5, 0, '', '', '', 0),
(91, 2, 'Employee Salary', 'empSalary', 'account', 'employeeSalary.php', 19, 0, 'FF1356', '2CFF92', '', 0),
(92, 2, 'Head Wise Transaction', 'HeadWiseTransaction', 'account', 'HeadWiseTransaction.php', 18, 0, '', '', '', 1),
(93, 2, 'Head and date wise expense Rep', 'hNdwExpReport', 'reports', 'hNdwExpReport.php', 20, 0, '', '', '', 1),
(94, 3, 'District', 'district', 'bus_settings', 'district.php', 6, 0, '', '', '', 1),
(95, 0, 'Purchase', 'n', 'n', 'n', 3, 0, '', '', '', 1),
(96, 0, 'Statement', 'n', 'n', 'n', 5, 0, 'FF1D09', '000000', '', 1),
(97, 12, 'Customers', 'customers', 'info', 'customers.php', 14, 0, 'FF1D09', '000000', '', 1),
(98, 96, 'Customer Statment', 'customer-statement ', 'reports', 'customer_statement.php', 2, 0, '', '', '', 1),
(99, 95, 'Purchase Return List', 'purchaseReturnList', 'list', 'purchaseReturnList.php', 12, 0, '8533FF', '000000', '', 1),
(100, 96, 'Persons Statment', 'personsStatment', 'reports', 'personsStatment.php', 2, 0, '', '', '', 1),
(101, 0, 'Reports', 'n', 'n', 'n', 4, 0, NULL, NULL, NULL, 1),
(102, 0, 'Inventory', 'n', 'n', 'n', 6, 0, NULL, NULL, NULL, 1),
(103, 3, 'Product cost set', 'productCostSet', 'info', 'productCostSet.php', 1, 0, '', '', '', 1),
(104, 12, 'Gift distribute List', 'gift_distribute_list', 'reports', 'gift_distribute_list.php', 4, 0, 'FF1D09', '000000', '', 0),
(105, 95, 'Purchase requisition', 'purchase_requisition', 'operation', 'purchase_requisition.php', 3, 0, '', '', '', 0),
(106, 95, 'Purchase order', 'purchase-order', 'operation', 'purchase/order.php', 4, 0, '', '', '', 0),
(107, 102, 'Honorarium evaluation', 'honorarium-evaluation', 'info', 'honorarium_evaluation.php', 1, 0, 'FF1D09', '000000', '', 0),
(108, 102, 'Bazar', 'bazar', 'info', 'bazar.php', 1, 0, 'FF1D09', '000000', '', 0),
(109, 101, 'Pharmacy wise doctors contribution', 'pharmacy-wise-doctors-contribution', 'reports', 'pharmacy_wise_doctors_contribution.php', 1, 0, 'FF1D09', 'EDFF2F', '', 0),
(110, 3, 'Monthly target', 'monthly-target', 'info', 'monthly_target.php', 1, 0, '', '', '', 0),
(111, 101, 'Doctors wise contribution', 'doctors_wise_contribution', 'reports', 'doctors_wise_contribution.php', 1, 0, NULL, NULL, NULL, 0),
(112, 4, 'User manage', 'user_manage', 'common', 'user_manage.php', NULL, 0, NULL, NULL, NULL, 1),
(113, 2, 'Contra voucher', 'contra-voucher', 'account', 'contra_voucher.php', 1, 0, 'FF1D09', '000000', '', 1),
(114, 101, 'Doctor visit report', 'doctor-visit-report', 'reports', 'doctor_visit_report.php', 12, 0, '8533FF', '000000', '', 0),
(115, 12, 'Liquid product sale', 'liquid-product-sale', 'operation', 'sale/liquid_product_sale.php', 1, 0, 'FF1D09', '000000', '', 0),
(116, 12, 'Customer category', 'customer-category', 'info', 'customer_category.php', 14, 0, 'FF1D09', '000000', '', 1),
(117, 2, 'Chart of Accounts Setup', 'chart-of-accounts-setup', 'account', 'chart_of_accounts_setup.php', 1, 0, 'FF1D09', '000000', '', 1),
(118, 96, 'Income Statement', 'income-statement', 'reports', 'income-statement.php', 2, 0, '', '', '', 1),
(119, 2, 'Employee Salary', 'employee_salary', 'account', 'employee_salary.php', NULL, 0, NULL, NULL, NULL, 1),
(120, 3, 'Truk', 'truk', 'info', 'truk.php', 10, 0, '', '', '', 1),
(121, 2, 'Transaction with employee', 'transaction_with_employee', 'account', 'transaction_with_employee.php', NULL, 0, NULL, NULL, NULL, 1),
(122, 101, 'Paid & Unpaid Invoice Report', 'paid-and-unpaid-invoice-report', 'reports', 'paid-and-unpaid-invoice-report.php', 1, 0, 'FF1D09', 'EDFF2F', '', 1),
(123, 96, 'Employee Statment', 'employeeStatment', 'reports', 'employeeStatment.php', NULL, 0, NULL, NULL, NULL, 1),
(124, 101, 'Salary Payment Report', 'salary-payment-report', 'reports', 'salary_payment_report.php', NULL, 0, NULL, NULL, NULL, 1),
(125, 3, 'Additional expense manager', 'additional_expense_manager', 'info', 'additional_expense_manager.php', 10, 0, '', '', '', 1);

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

--
-- Table structure for table `module_permission`
--

CREATE TABLE `module_permission` (
  `group_id` int NOT NULL,
  `module_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `module_permission`
--

INSERT INTO `module_permission` (`group_id`, `module_id`) VALUES
(7, 6),
(7, 4),
(7, 84),
(7, 86),
(7, 27),
(7, 73),
(7, 38),
(7, 13),
(7, 28),
(7, 69),
(7, 97),
(7, 116),
(7, 95),
(7, 9),
(7, 101),
(7, 35),
(7, 39),
(7, 122),
(7, 96),
(7, 123),
(7, 98),
(7, 100),
(7, 23),
(7, 19),
(7, 20),
(7, 102),
(7, 7),
(7, 37),
(7, 2),
(7, 14),
(7, 117),
(7, 25),
(7, 26),
(7, 60),
(7, 53),
(7, 52),
(7, 51),
(7, 62),
(7, 16),
(7, 8),
(7, 58),
(7, 74),
(7, 92),
(7, 3),
(7, 80),
(7, 103),
(7, 11),
(7, 75),
(7, 88),
(7, 120),
(7, 125),
(7, 83);

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

--
-- Table structure for table `monthly_target`
--

CREATE TABLE `monthly_target` (
  `id` int NOT NULL,
  `base_id` int NOT NULL,
  `user_id` int NOT NULL,
  `date` int NOT NULL,
  `sale_target` int NOT NULL,
  `collection_target` int NOT NULL,
  `createdOn` int NOT NULL,
  `createdBy` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `person`
--

CREATE TABLE `person` (
  `id` int NOT NULL,
  `head_id` int NOT NULL DEFAULT '0',
  `mobile` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `data` longtext COLLATE utf8mb4_general_ci,
  `createdBy` int DEFAULT NULL,
  `createdOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `production_product`
--

CREATE TABLE `production_product` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `manufacture_product_id` int NOT NULL DEFAULT '0',
  `manufacture_product_quantity` int NOT NULL DEFAULT '0',
  `date` int NOT NULL,
  `type` int NOT NULL DEFAULT '0',
  `batch_no` varchar(20) COLLATE utf8mb4_general_ci DEFAULT '',
  `pmo_no` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '',
  `quantity` int NOT NULL,
  `yield` int NOT NULL,
  `retention_sample` int NOT NULL,
  `product_cost` decimal(10,2) NOT NULL,
  `extra_cost` decimal(10,2) NOT NULL,
  `total_cost` decimal(10,2) NOT NULL,
  `note` text COLLATE utf8mb4_general_ci,
  `createdOn` int DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `production_product_source`
--

CREATE TABLE `production_product_source` (
  `id` int NOT NULL,
  `production_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `unit_cost` decimal(16,4) NOT NULL,
  `extra_cost` decimal(16,4) DEFAULT NULL,
  `total_cost` decimal(16,4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `unit_id` int NOT NULL,
  `box_unit_id` int NOT NULL DEFAULT '0',
  `category_id` int NOT NULL DEFAULT '0',
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `sale_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `stock` decimal(10,2) NOT NULL DEFAULT '0.00',
  `unit_cost` decimal(10,2) NOT NULL DEFAULT '0.00',
  `VAT` decimal(10,2) NOT NULL DEFAULT '0.00',
  `type` tinyint NOT NULL DEFAULT '0',
  `data` longtext COLLATE utf8mb4_general_ci,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `code`, `unit_id`, `box_unit_id`, `category_id`, `title`, `sale_price`, `stock`, `unit_cost`, `VAT`, `type`, `data`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(316, 'V', 2, 0, 0, 'Vutta', 100.00, 1311.00, 100.00, 0.00, 0, NULL, 46, 1741941689, 46, 1741942153, 1);

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

--
-- Table structure for table `product_category`
--

CREATE TABLE `product_category` (
  `id` int NOT NULL,
  `parent` int NOT NULL DEFAULT '0',
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `product_closing_stock`
--

CREATE TABLE `product_closing_stock` (
  `pcsID` int NOT NULL,
  `supID` int NOT NULL,
  `scID` int NOT NULL,
  `pID` int NOT NULL,
  `stockType` tinyint NOT NULL,
  `pStock` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pStockAmount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `createdOn` int NOT NULL,
  `actionDate` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `product_opening_stock`
--

CREATE TABLE `product_opening_stock` (
  `posID` int NOT NULL,
  `pID` int NOT NULL,
  `quantity` int NOT NULL,
  `inStock` int NOT NULL,
  `unitPrice` double(10,2) NOT NULL,
  `posType` tinyint NOT NULL COMMENT '1=good,2=damage'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `product_price_log`
--

CREATE TABLE `product_price_log` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `time` int NOT NULL,
  `sale_price` decimal(12,2) NOT NULL,
  `unit_cost` decimal(12,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_price_log`
--

INSERT INTO `product_price_log` (`id`, `product_id`, `time`, `sale_price`, `unit_cost`) VALUES
(354, 316, 0, 100.00, 0.00),
(355, 316, 1741947440, 100.00, 100.00);

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

--
-- Table structure for table `product_stock_log`
--

CREATE TABLE `product_stock_log` (
  `id` int NOT NULL,
  `product_id` int DEFAULT NULL,
  `change_type` tinyint DEFAULT NULL,
  `reference_id` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `action_time` int DEFAULT NULL,
  `entry_time` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `product_stock_log`
--

INSERT INTO `product_stock_log` (`id`, `product_id`, `change_type`, `reference_id`, `quantity`, `action_time`, `entry_time`) VALUES
(15817, 316, 1, 806, 100, 1741947440, 1741947440),
(15820, 316, 1, 809, 11, 1742396521, 1742396521),
(15821, 316, 1, 810, 1200, 1742526775, 1742526775),
(15822, 316, 2, 6574, 0, 1742571739, 1742571739),
(15823, 316, 2, 6575, 0, 1742571784, 1742571784),
(15825, 316, 2, 6577, 0, 1742617880, 1742617880);

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

--
-- Table structure for table `purchase`
--

CREATE TABLE `purchase` (
  `id` int NOT NULL,
  `invoice_no` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `supplier_id` int NOT NULL,
  `supplier_invoice_no` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `date` int NOT NULL,
  `challan_no` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `challan_date` int NOT NULL,
  `po_no` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mrr_code` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mrr_no` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `mrr_date` int NOT NULL DEFAULT '0',
  `type` tinyint NOT NULL DEFAULT '0' COMMENT '0=Normal, 2=Damage,3=Adjust',
  `sub_total` double(18,4) NOT NULL,
  `discount` double(18,4) NOT NULL DEFAULT '0.0000',
  `VAT` double(10,2) NOT NULL DEFAULT '0.00',
  `AIT` double(10,2) NOT NULL DEFAULT '0.00',
  `total` double(18,4) NOT NULL,
  `remarks` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `purchase`
--

INSERT INTO `purchase` (`id`, `invoice_no`, `supplier_id`, `supplier_invoice_no`, `date`, `challan_no`, `challan_date`, `po_no`, `mrr_code`, `mrr_no`, `mrr_date`, `type`, `sub_total`, `discount`, `VAT`, `AIT`, `total`, `remarks`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`) VALUES
(345, 'PI0345', 21, '1', 1741947440, '1', 1741947440, '1', '1', 'MRR0345', 1741947440, 0, 10000.0000, 0.0000, 0.00, 0.00, 10000.0000, '', 46, 1741947440, 46, 1741947440),
(348, 'PI0348', 21, '11', 1742396521, '11', 1742396521, '11', NULL, 'MRR0348', 0, 0, 1100.0000, 0.0000, 0.00, 0.00, 1100.0000, '', 46, 1742396521, 46, 1742396521),
(349, 'PI0349', 21, '22', 1742526775, '22', 1742526775, '22', NULL, 'MRR0349', 0, 0, 120000.0000, 0.0000, 0.00, 0.00, 120000.0000, '', 46, 1742526775, 46, 1742526775);

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

--
-- Table structure for table `purchase_additional_cost`
--

CREATE TABLE `purchase_additional_cost` (
  `id` int NOT NULL,
  `purchase_id` int NOT NULL,
  `truk_id` int NOT NULL,
  `additional_expense_id` int NOT NULL,
  `pay_by` tinyint NOT NULL DEFAULT '1',
  `amount` double(18,2) NOT NULL,
  `time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `purchase_additional_cost`
--

INSERT INTO `purchase_additional_cost` (`id`, `purchase_id`, `truk_id`, `additional_expense_id`, `pay_by`, `amount`, `time`) VALUES
(1, 348, 1, 2, 1, 11.00, 1742396521),
(2, 349, 1, 1, 1, 1200.00, 1742526775),
(3, 349, 2, 1, 2, 1200.00, 1742526775);

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

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

CREATE TABLE `purchase_details` (
  `id` int NOT NULL,
  `purchase_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int DEFAULT NULL,
  `type` tinyint NOT NULL DEFAULT '1' COMMENT '1=good,2=bad',
  `unit_price` double(18,2) DEFAULT NULL,
  `time` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `purchase_details`
--

INSERT INTO `purchase_details` (`id`, `purchase_id`, `product_id`, `quantity`, `type`, `unit_price`, `time`) VALUES
(806, 345, 316, 100, 1, 100.00, 1741947440),
(809, 348, 316, 11, 1, 100.00, 1742396521),
(810, 349, 316, 1200, 1, 100.00, 1742526775);

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

--
-- Table structure for table `purchase_draft`
--

CREATE TABLE `purchase_draft` (
  `purID` int NOT NULL,
  `supID` int NOT NULL,
  `sData` text COLLATE utf8mb4_general_ci,
  `createdBy` int DEFAULT NULL,
  `createdOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `purchase_order`
--

CREATE TABLE `purchase_order` (
  `id` int NOT NULL,
  `date` int NOT NULL,
  `note` text COLLATE utf8mb4_general_ci,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `purchase_order_details`
--

CREATE TABLE `purchase_order_details` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `purchase_order_id` int NOT NULL,
  `quantity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `purchase_requisition`
--

CREATE TABLE `purchase_requisition` (
  `id` int NOT NULL,
  `code` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` int NOT NULL,
  `note` text COLLATE utf8mb4_general_ci,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `purchase_requisition_details`
--

CREATE TABLE `purchase_requisition_details` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `purchase_requisition_id` int NOT NULL,
  `quantity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `purchase_return`
--

CREATE TABLE `purchase_return` (
  `id` int NOT NULL,
  `supplier_id` int NOT NULL,
  `date` int NOT NULL,
  `sub_total` decimal(12,2) NOT NULL,
  `discount` decimal(12,2) NOT NULL,
  `return_amount` decimal(12,2) NOT NULL,
  `note` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `purchase_return_details`
--

CREATE TABLE `purchase_return_details` (
  `id` int NOT NULL,
  `purchase_return_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `unit_price` decimal(12,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `purchase_truk`
--

CREATE TABLE `purchase_truk` (
  `id` int NOT NULL,
  `purchase_id` int NOT NULL,
  `truk_id` int NOT NULL,
  `pay_by` tinyint NOT NULL,
  `rent` double(18,2) NOT NULL,
  `time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `purchase_truk`
--

INSERT INTO `purchase_truk` (`id`, `purchase_id`, `truk_id`, `pay_by`, `rent`, `time`) VALUES
(2, 348, 1, 1, 11.00, 1742396521),
(3, 349, 1, 2, 1000.00, 1742526775),
(4, 349, 2, 2, 1200.00, 1742526775);

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

--
-- Table structure for table `queue_sms`
--

CREATE TABLE `queue_sms` (
  `id` int NOT NULL,
  `data` text COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `add_time` int NOT NULL,
  `send_time` int NOT NULL DEFAULT '0',
  `total_try` tinyint NOT NULL DEFAULT '0',
  `is_pic` tinyint NOT NULL DEFAULT '0',
  `response` mediumtext COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `queue_sms`
--

INSERT INTO `queue_sms` (`id`, `data`, `mobile`, `add_time`, `send_time`, `total_try`, `is_pic`, `response`) VALUES
(2752, '{\"text\":\"Dear Valued Customer, Your Invoice with Tk 9000 ready for delivery. You will get soon. Thanks Panacea Agrovet Ltd 01313444291\"}', '0154', 1742571739, 1742571784, 1, 0, '{\"EL#221_somiti\":[\"21-03-2025 09:43:04 PM\"],\"EL#248_somiti\":[\"{\\\"status\\\":0,\\\"LN_11_send-single-message\\\":{\\\"api_key\\\":\\\"f8dc50194a1a50bd1df095c9f10ab243\\\",\\\"mobile\\\":\\\"0154\\\",\\\"text\\\":\\\"Dear Valued Customer, Your Invoice with Tk 9000 ready for delivery. You will get soon. Thanks Panacea Agrovet Ltd 01313444291\\\"},\\\"m\\\":[[\\\"e\\\",\\\"Valid bangladeshi mobile number required..\\\"]]}\"]}'),
(2753, '{\"text\":\"Dear Valued Customer, Your Invoice with Tk 9000 ready for delivery. You will get soon. Thanks Panacea Agrovet Ltd 01313444291\"}', '0154', 1742571784, 1742571799, 1, 0, '{\"EL#221_somiti\":[\"21-03-2025 09:43:19 PM\"],\"EL#248_somiti\":[\"{\\\"status\\\":0,\\\"LN_11_send-single-message\\\":{\\\"api_key\\\":\\\"f8dc50194a1a50bd1df095c9f10ab243\\\",\\\"mobile\\\":\\\"0154\\\",\\\"text\\\":\\\"Dear Valued Customer, Your Invoice with Tk 9000 ready for delivery. You will get soon. Thanks Panacea Agrovet Ltd 01313444291\\\"},\\\"m\\\":[[\\\"e\\\",\\\"Valid bangladeshi mobile number required..\\\"]]}\"]}'),
(2754, '{\"text\":\"Dear Valued Customer, Your Invoice with Tk 9900 ready for delivery. You will get soon. Thanks Panacea Agrovet Ltd 01313444291\"}', '0154', 1742617880, 1742618799, 1, 0, '{\"EL#221_somiti\":[\"22-03-2025 10:46:39 AM\"],\"EL#248_somiti\":[\"{\\\"status\\\":0,\\\"LN_11_send-single-message\\\":{\\\"api_key\\\":\\\"f8dc50194a1a50bd1df095c9f10ab243\\\",\\\"mobile\\\":\\\"0154\\\",\\\"text\\\":\\\"Dear Valued Customer, Your Invoice with Tk 9900 ready for delivery. You will get soon. Thanks Panacea Agrovet Ltd 01313444291\\\"},\\\"m\\\":[[\\\"e\\\",\\\"Valid bangladeshi mobile number required..\\\"]]}\"]}');

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

--
-- Table structure for table `reject_products`
--

CREATE TABLE `reject_products` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `code` varchar(15) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `quantity` int NOT NULL,
  `date` int NOT NULL,
  `unit_cost` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `note` varchar(300) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `report_cach`
--

CREATE TABLE `report_cach` (
  `id` int NOT NULL,
  `cash_key` mediumtext COLLATE utf8mb4_general_ci,
  `validity` int DEFAULT NULL,
  `value` longtext COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `salary_allowance`
--

CREATE TABLE `salary_allowance` (
  `id` int NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `salary_allowance`
--

INSERT INTO `salary_allowance` (`id`, `title`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(1, 'aaa', 221, 1739461841, 221, 1740368433, 1),
(2, 'TA/DA', 221, 1739461854, 221, 1739461854, 1),
(3, 'Incentive', 221, 1739461865, 221, 1739461865, 1),
(4, 'Bike Allowance', 221, 1739461884, 221, 1739461884, 1);

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

--
-- Table structure for table `sale`
--

CREATE TABLE `sale` (
  `id` int NOT NULL,
  `invoice_no` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `customer_id` int DEFAULT NULL,
  `product_type` tinyint NOT NULL DEFAULT '0',
  `pay_type` tinyint NOT NULL DEFAULT '1',
  `date` int NOT NULL,
  `sub_total` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `extra_discount` decimal(10,2) NOT NULL,
  `VAT` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `cost` decimal(10,2) NOT NULL,
  `data` text COLLATE utf8mb4_general_ci,
  `note` varchar(1000) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `collection_date` int DEFAULT NULL,
  `base_id` int DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `createdOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sale`
--

INSERT INTO `sale` (`id`, `invoice_no`, `customer_id`, `product_type`, `pay_type`, `date`, `sub_total`, `discount`, `extra_discount`, `VAT`, `total`, `cost`, `data`, `note`, `collection_date`, `base_id`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`) VALUES
(2714, 'B1-2714', 1045, 0, 1, 1742571739, 10000.00, 0.00, 1000.00, 0.00, 9000.00, 10000.00, '{\"customer_closing_balance\":0,\"customer_due_invoice\":[]}', '', 1742571739, 22, 46, 1742571739, 46, 1742571739),
(2715, 'B1-2715', 1045, 0, 1, 1742571784, 10000.00, 0.00, 1000.00, 0.00, 9000.00, 10000.00, '{\"customer_closing_balance\":9000,\"customer_due_invoice\":[{\"date\":\"1742571739\",\"pay_type\":\"Credit\",\"aging\":0,\"due\":9000,\"invoice_no\":\"B1-2714\"}]}', '', 1742571784, 22, 46, 1742571784, 46, 1742571784),
(2717, 'B1-2717', 1045, 0, 1, 1742617880, 10000.00, 0.00, 100.00, 0.00, 9900.00, 10000.00, '{\"customer_closing_balance\":18000,\"customer_due_invoice\":[{\"date\":\"1742571784\",\"pay_type\":\"Credit\",\"aging\":0,\"due\":\"9000.00\",\"invoice_no\":\"B1-2715\"},{\"date\":\"1742571739\",\"pay_type\":\"Credit\",\"aging\":0,\"due\":9000,\"invoice_no\":\"B1-2714\"}]}', '', 1745209880, 22, 46, 1742617880, 46, 1742617880);

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

--
-- Table structure for table `sale_additional_cost`
--

CREATE TABLE `sale_additional_cost` (
  `id` int NOT NULL,
  `sale_id` int NOT NULL,
  `truk_id` int NOT NULL,
  `additional_expense_id` int NOT NULL,
  `pay_by` tinyint NOT NULL DEFAULT '1',
  `amount` double(18,2) NOT NULL,
  `time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sale_additional_cost`
--

INSERT INTO `sale_additional_cost` (`id`, `sale_id`, `truk_id`, `additional_expense_id`, `pay_by`, `amount`, `time`) VALUES
(1, 2717, 1, 1, 2, 2000.00, 1742617880),
(2, 2717, 2, 1, 2, 2000.00, 1742617880);

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

--
-- Table structure for table `sale_draft`
--

CREATE TABLE `sale_draft` (
  `id` int NOT NULL,
  `customer_id` int NOT NULL DEFAULT '0',
  `due_day` int DEFAULT NULL,
  `base_id` int DEFAULT NULL,
  `date` int DEFAULT NULL,
  `data` text COLLATE utf8mb4_general_ci,
  `note` varchar(1000) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `createdBy` int DEFAULT NULL,
  `createdOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sale_products`
--

CREATE TABLE `sale_products` (
  `id` int NOT NULL,
  `sale_id` int NOT NULL,
  `product_id` int NOT NULL,
  `sale_qty` int NOT NULL,
  `free_qty` int NOT NULL,
  `total_qty` int NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `sub_total` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `VAT` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total` decimal(10,2) NOT NULL,
  `unit_cost` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sale_products`
--

INSERT INTO `sale_products` (`id`, `sale_id`, `product_id`, `sale_qty`, `free_qty`, `total_qty`, `unit_price`, `sub_total`, `discount`, `VAT`, `total`, `unit_cost`) VALUES
(6574, 2714, 316, 100, 0, 0, 100.00, 10000.00, 0.00, 0.00, 10000.00, 100.00),
(6575, 2715, 316, 100, 0, 0, 100.00, 10000.00, 0.00, 0.00, 10000.00, 100.00),
(6577, 2717, 316, 100, 0, 0, 100.00, 10000.00, 0.00, 0.00, 10000.00, 100.00);

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

--
-- Table structure for table `sale_product_scource`
--

CREATE TABLE `sale_product_scource` (
  `spsID` int NOT NULL,
  `sID` int NOT NULL DEFAULT '0',
  `pID` int NOT NULL,
  `spsType` tinyint NOT NULL,
  `spsRefID` int NOT NULL,
  `qty` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sale_return`
--

CREATE TABLE `sale_return` (
  `id` int NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `customer_id` int NOT NULL,
  `pay_type` tinyint NOT NULL,
  `invoice_date` int NOT NULL,
  `approved_date` int NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `sub_total` decimal(10,2) NOT NULL,
  `base_id` int NOT NULL,
  `note` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `return_amount` decimal(10,2) NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sale_return_details`
--

CREATE TABLE `sale_return_details` (
  `id` int NOT NULL,
  `sale_return_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `unit_price` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sale_return_process_data`
--

CREATE TABLE `sale_return_process_data` (
  `id` int NOT NULL,
  `sale_return_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `base_id` int NOT NULL,
  `product_id` int NOT NULL,
  `date` int NOT NULL,
  `type` tinyint NOT NULL,
  `quantity` int NOT NULL,
  `unit_price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `createdOn` int NOT NULL,
  `createdBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `modifiedBy` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sale_truk`
--

CREATE TABLE `sale_truk` (
  `id` int NOT NULL,
  `sale_id` int NOT NULL,
  `truk_id` int NOT NULL,
  `pay_by` tinyint NOT NULL,
  `rent` double(18,2) NOT NULL,
  `time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sale_truk`
--

INSERT INTO `sale_truk` (`id`, `sale_id`, `truk_id`, `pay_by`, `rent`, `time`) VALUES
(1, 2717, 1, 2, 1500.00, 1742617880),
(2, 2717, 2, 2, 1000.00, 1742617880);

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

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

CREATE TABLE `suppliers` (
  `id` int NOT NULL,
  `head_id` int NOT NULL DEFAULT '0',
  `name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `contact_person` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `address` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `data` text COLLATE utf8mb4_general_ci,
  `createdOn` int NOT NULL,
  `createdBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `head_id`, `name`, `contact_person`, `mobile`, `address`, `data`, `createdOn`, `createdBy`, `modifiedOn`, `modifiedBy`, `isActive`) VALUES
(21, 1388, 'Feed mill 1', '01', '011', '0111', NULL, 1741944355, 46, 1741944534, 46, 1);

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

--
-- Table structure for table `truk`
--

CREATE TABLE `truk` (
  `id` int NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `createdOn` int DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `truk`
--

INSERT INTO `truk` (`id`, `title`, `createdOn`, `createdBy`, `modifiedOn`, `modifiedBy`, `isActive`) VALUES
(1, 'DM-T-22345', 1741930033, 46, 1741930205, 46, 1),
(2, 'DM-T-99887', 1741951966, 46, 1741951966, 46, 1),
(3, 'KR-T-985264', 1741951976, 46, 1741951976, 46, 1);

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

--
-- Table structure for table `unit`
--

CREATE TABLE `unit` (
  `id` int NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `createdOn` int DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `unit`
--

INSERT INTO `unit` (`id`, `title`, `createdOn`, `createdBy`, `modifiedOn`, `modifiedBy`, `isActive`) VALUES
(2, 'Kg', 1722141895, 221, 1722141895, 221, 1),
(5, 'Pcs', 1723045687, 221, 1723045687, 221, 1),
(6, 'gm', 1724602814, 221, 1730092372, 221, 1),
(7, 'Feet', 1724905938, 221, 1724905938, 221, 1);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `base_id` int NOT NULL DEFAULT '0',
  `group_id` int DEFAULT NULL,
  `employee_id` int NOT NULL DEFAULT '0',
  `head_id` int NOT NULL DEFAULT '0',
  `name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(300) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` tinyint NOT NULL DEFAULT '0',
  `username` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password_salt` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `data` text COLLATE utf8mb4_general_ci,
  `isActive` tinyint DEFAULT '1',
  `createdBy` int DEFAULT NULL,
  `createdOn` int DEFAULT NULL,
  `modifiedBy` int DEFAULT NULL,
  `modifiedOn` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `base_id`, `group_id`, `employee_id`, `head_id`, `name`, `mobile`, `email`, `address`, `type`, `username`, `password`, `password_salt`, `data`, `isActive`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`) VALUES
(46, 0, 4, 0, 1354, 'Developer', NULL, NULL, NULL, 0, 'abdusr', 'a0b322019def939d54780715d993d2e9', '888b33cd72a823e35d3bf8803c4d720f', NULL, 1, 45, 1505446861, 46, 1533975774),
(254, 0, 7, 0, 0, 'Rijon', '', NULL, NULL, 0, 'rijon', 'bcf868697928e63f3de98c825b60ebee', '74e40db76132c0b77a11f8b30259224f', '[]', 1, 46, 1742484175, 46, 1742484175);

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

--
-- Table structure for table `user_group`
--

CREATE TABLE `user_group` (
  `id` int NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL,
  `createdOn` int NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedOn` int NOT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_group`
--

INSERT INTO `user_group` (`id`, `title`, `createdBy`, `createdOn`, `modifiedBy`, `modifiedOn`, `isActive`) VALUES
(4, 'Developer', 0, 0, 0, 0, 1),
(7, 'Admin', 46, 1519022197, 46, 1588330462, 1),
(8, 'Office Assistant', 46, 1604509427, 46, 1604509427, 1),
(9, 'Deputi Admin', 46, 1613747036, 46, 1613747036, 1),
(14, 'HR & Admin', 221, 1725300571, 221, 1725300571, 1),
(15, 'Accounts', 221, 1725300591, 221, 1725300591, 1);

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

--
-- Table structure for table `user_login_session`
--

CREATE TABLE `user_login_session` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `start` int DEFAULT NULL,
  `validity` int DEFAULT NULL,
  `ip` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `end` int DEFAULT NULL,
  `login_string` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isActive` tinyint DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_login_session`
--

INSERT INTO `user_login_session` (`id`, `user_id`, `start`, `validity`, `ip`, `end`, `login_string`, `isActive`) VALUES
(8848, 46, 1741928421, 1742000421, '127.0.0.1', NULL, '55fa88ad6c226e4c57c12b682c1882aa', 1),
(8849, 46, 1741941388, 1742013388, '127.0.0.1', NULL, '1e693c529bf93436399d1eb488f121e4', 1),
(8850, 46, 1742053373, 1742125373, '127.0.0.1', NULL, '34f22d1695422de27733f988ab2aff24', 1),
(8851, 46, 1742216285, 1742288285, '127.0.0.1', NULL, '47f62d25ef4161dab61f4b6d5e78afec', 1),
(8852, 46, 1742274287, 1742346287, '127.0.0.1', NULL, 'cc3fe1d9c598a3dd0585ba93d2d3bfc6', 1),
(8853, 46, 1742296775, 1742368775, '127.0.0.1', NULL, '5fd0101b9b9d3b0c681f9a43f7b207d0', 1),
(8854, 46, 1742388844, 1742460844, '127.0.0.1', NULL, '50e6d494da998756dcaf0f44a2afb560', 1),
(8855, 46, 1742483853, 1742555853, '127.0.0.1', NULL, '2a57aa0683693bf8f79c17a9b221765f', 1),
(8856, 46, 1742526641, 1742598641, '127.0.0.1', NULL, '1632c87b8b1766eef9cd6b031cbccda1', 1),
(8857, 46, 1742545167, 1742617167, '127.0.0.1', NULL, '3fd0564ad950bd6f41072366f4264c85', 1),
(8858, 46, 1742611847, 1742683847, '127.0.0.1', NULL, '92fb64c09308fbeac1d63193eca17e85', 1);

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

--
-- Table structure for table `user_manager`
--

CREATE TABLE `user_manager` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `assing_user_id` int NOT NULL,
  `assing_time` int NOT NULL,
  `assing_by` int NOT NULL,
  `release_time` int DEFAULT NULL,
  `release_by` int DEFAULT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `user_permissions`
--

CREATE TABLE `user_permissions` (
  `id` int NOT NULL,
  `module_id` int DEFAULT NULL,
  `description` tinytext COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_permissions`
--

INSERT INTO `user_permissions` (`id`, `module_id`, `description`) VALUES
(1, 22, 'Can show price'),
(2, 85, 'Change Permission'),
(3, 32, 'Can show price'),
(4, 6, 'Purchase Save'),
(5, 29, 'Can show price'),
(6, 34, 'Can show price'),
(7, 22, 'Delete manufacture'),
(8, 32, 'Delete packaging'),
(25, 83, 'Add Admin Group'),
(26, 83, 'Edit Admin Group'),
(35, 11, 'Add Employee'),
(36, 11, 'Edit Employee'),
(37, 10, 'Add Employee Designa'),
(38, 10, 'Edit Employee Design'),
(64, 4, 'User Add'),
(65, 4, 'User Edit'),
(82, 11, 'Delete Employe'),
(83, 7, 'Product Add'),
(84, 7, 'Product Edit'),
(90, 25, 'Remove Transaction'),
(98, 25, 'Approve'),
(99, 25, 'Checked'),
(100, 25, 'Voucher Print');

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

--
-- Table structure for table `user_permission_assign`
--

CREATE TABLE `user_permission_assign` (
  `group_id` int DEFAULT NULL,
  `permission_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_permission_assign`
--

INSERT INTO `user_permission_assign` (`group_id`, `permission_id`) VALUES
(7, 35),
(7, 36),
(7, 82),
(8, 83),
(8, 84),
(9, 64),
(9, 65),
(9, 90),
(9, 100),
(9, 35),
(9, 82),
(9, 36),
(9, 37),
(9, 38),
(7, 4),
(7, 83),
(7, 84),
(7, 64),
(7, 65),
(7, 2),
(7, 25),
(7, 26),
(7, 90),
(7, 98),
(7, 99),
(7, 100),
(7, 37),
(7, 38),
(15, 1),
(15, 7),
(15, 3),
(15, 8),
(15, 5),
(15, 6),
(15, 4),
(15, 83),
(15, 84),
(15, 90),
(15, 98),
(15, 99),
(15, 100),
(15, 35),
(15, 36),
(15, 82),
(15, 37),
(15, 38),
(14, 4),
(14, 83),
(14, 84);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `action_log`
--
ALTER TABLE `action_log`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

--
-- Indexes for table `a_auto_head`
--
ALTER TABLE `a_auto_head`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `a_auto_head_chart`
--
ALTER TABLE `a_auto_head_chart`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `a_bank_info`
--
ALTER TABLE `a_bank_info`
  ADD PRIMARY KEY (`biID`),
  ADD KEY `FK_a_bank_info_brands` (`bID`);

--
-- Indexes for table `a_bank_withdraw`
--
ALTER TABLE `a_bank_withdraw`
  ADD PRIMARY KEY (`bwID`),
  ADD KEY `FK_a_bank_withdraw_a_bank_info` (`biID`);

--
-- Indexes for table `a_charts_accounts`
--
ALTER TABLE `a_charts_accounts`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `a_employee_salary`
--
ALTER TABLE `a_employee_salary`
  ADD PRIMARY KEY (`esID`),
  ADD KEY `FK_a_employee_salary_employees` (`eID`);

--
-- Indexes for table `a_heads`
--
ALTER TABLE `a_heads`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `a_head_entry`
--
ALTER TABLE `a_head_entry`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `a_master_account`
--
ALTER TABLE `a_master_account`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `a_voucher_entry`
--
ALTER TABLE `a_voucher_entry`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

--
-- Indexes for table `base`
--
ALTER TABLE `base`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

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

--
-- Indexes for table `company`
--
ALTER TABLE `company`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `contra_voucher`
--
ALTER TABLE `contra_voucher`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

--
-- Indexes for table `crone_run_log`
--
ALTER TABLE `crone_run_log`
  ADD PRIMARY KEY (`crlID`);

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `customer_amount_receive`
--
ALTER TABLE `customer_amount_receive`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `employee_department`
--
ALTER TABLE `employee_department`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

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

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

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

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

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

--
-- Indexes for table `module`
--
ALTER TABLE `module`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `module_permission`
--
ALTER TABLE `module_permission`
  ADD KEY `FK_module_permission_user_group` (`group_id`),
  ADD KEY `FK_module_permission_module` (`module_id`);

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

--
-- Indexes for table `person`
--
ALTER TABLE `person`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `production_product`
--
ALTER TABLE `production_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_production_product_products` (`product_id`);

--
-- Indexes for table `production_product_source`
--
ALTER TABLE `production_product_source`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_production_product_source_production_product` (`production_id`),
  ADD KEY `FK_production_product_source_products` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

--
-- Indexes for table `product_closing_stock`
--
ALTER TABLE `product_closing_stock`
  ADD PRIMARY KEY (`pcsID`),
  ADD KEY `FK_products_suppliers` (`supID`),
  ADD KEY `FK_products_unit` (`pID`),
  ADD KEY `actionDate` (`actionDate`);

--
-- Indexes for table `product_opening_stock`
--
ALTER TABLE `product_opening_stock`
  ADD PRIMARY KEY (`posID`),
  ADD KEY `pID` (`pID`);

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

--
-- Indexes for table `product_stock_log`
--
ALTER TABLE `product_stock_log`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `purchase`
--
ALTER TABLE `purchase`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `purchase_additional_cost`
--
ALTER TABLE `purchase_additional_cost`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_purchase_additional_cost_purchase` (`purchase_id`),
  ADD KEY `FK_purchase_additional_cost_truk` (`truk_id`),
  ADD KEY `FK_purchase_additional_cost_additional_expense` (`additional_expense_id`);

--
-- Indexes for table `purchase_details`
--
ALTER TABLE `purchase_details`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `FK_purchase_details_purchase` (`purchase_id`),
  ADD KEY `FK_purchase_details_products` (`product_id`);

--
-- Indexes for table `purchase_draft`
--
ALTER TABLE `purchase_draft`
  ADD PRIMARY KEY (`purID`) USING BTREE,
  ADD KEY `FK_purchase_draft_suppliers` (`supID`) USING BTREE;

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

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

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

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

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

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

--
-- Indexes for table `purchase_truk`
--
ALTER TABLE `purchase_truk`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_purchase_truk_purchase` (`purchase_id`),
  ADD KEY `FK_purchase_truk_truk` (`truk_id`);

--
-- Indexes for table `queue_sms`
--
ALTER TABLE `queue_sms`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `reject_products`
--
ALTER TABLE `reject_products`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

--
-- Indexes for table `salary_allowance`
--
ALTER TABLE `salary_allowance`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `sale`
--
ALTER TABLE `sale`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `FK_sale_customer` (`customer_id`) USING BTREE;

--
-- Indexes for table `sale_additional_cost`
--
ALTER TABLE `sale_additional_cost`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_sale_additional_cost_sale` (`sale_id`),
  ADD KEY `FK_sale_additional_cost_truk` (`truk_id`),
  ADD KEY `FK_sale_additional_cost_additional_expense` (`additional_expense_id`);

--
-- Indexes for table `sale_draft`
--
ALTER TABLE `sale_draft`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `sale_products`
--
ALTER TABLE `sale_products`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `FK_sale_products_products` (`product_id`) USING BTREE,
  ADD KEY `FK_sale_products_sale` (`sale_id`) USING BTREE;

--
-- Indexes for table `sale_product_scource`
--
ALTER TABLE `sale_product_scource`
  ADD PRIMARY KEY (`spsID`),
  ADD KEY `FK_sale_product_scource_sale` (`sID`),
  ADD KEY `FK_sale_product_scource_products` (`pID`);

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

--
-- Indexes for table `sale_return_details`
--
ALTER TABLE `sale_return_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_sale_return_details_sale_return` (`sale_return_id`),
  ADD KEY `FK_sale_return_details_sale_products` (`product_id`);

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

--
-- Indexes for table `sale_truk`
--
ALTER TABLE `sale_truk`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_sale_truk_sale` (`sale_id`),
  ADD KEY `FK_sale_truk_truk` (`truk_id`);

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

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

--
-- Indexes for table `unit`
--
ALTER TABLE `unit`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `FK_users_user_group` (`group_id`);

--
-- Indexes for table `user_group`
--
ALTER TABLE `user_group`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `user_login_session`
--
ALTER TABLE `user_login_session`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `FK_user_login_session_users` (`user_id`);

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

--
-- Indexes for table `user_permissions`
--
ALTER TABLE `user_permissions`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `FK_user_permissions_module` (`module_id`);

--
-- Indexes for table `user_permission_assign`
--
ALTER TABLE `user_permission_assign`
  ADD KEY `FK_user_permission_assign_user_group` (`group_id`),
  ADD KEY `FK_user_permission_assign_user_permissions` (`permission_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `action_log`
--
ALTER TABLE `action_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=945;

--
-- AUTO_INCREMENT for table `additional_expense`
--
ALTER TABLE `additional_expense`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `a_auto_head`
--
ALTER TABLE `a_auto_head`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `a_auto_head_chart`
--
ALTER TABLE `a_auto_head_chart`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `a_bank_info`
--
ALTER TABLE `a_bank_info`
  MODIFY `biID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `a_bank_withdraw`
--
ALTER TABLE `a_bank_withdraw`
  MODIFY `bwID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `a_charts_accounts`
--
ALTER TABLE `a_charts_accounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `a_employee_salary`
--
ALTER TABLE `a_employee_salary`
  MODIFY `esID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `a_heads`
--
ALTER TABLE `a_heads`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1394;

--
-- AUTO_INCREMENT for table `a_head_entry`
--
ALTER TABLE `a_head_entry`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30499;

--
-- AUTO_INCREMENT for table `a_master_account`
--
ALTER TABLE `a_master_account`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `a_voucher_entry`
--
ALTER TABLE `a_voucher_entry`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15256;

--
-- AUTO_INCREMENT for table `bank`
--
ALTER TABLE `bank`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `base`
--
ALTER TABLE `base`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `bazar`
--
ALTER TABLE `bazar`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=323;

--
-- AUTO_INCREMENT for table `bazar_visit`
--
ALTER TABLE `bazar_visit`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `company`
--
ALTER TABLE `company`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contra_voucher`
--
ALTER TABLE `contra_voucher`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `contID` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=246;

--
-- AUTO_INCREMENT for table `crone_run_log`
--
ALTER TABLE `crone_run_log`
  MODIFY `crlID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1046;

--
-- AUTO_INCREMENT for table `customer_amount_receive`
--
ALTER TABLE `customer_amount_receive`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2956;

--
-- AUTO_INCREMENT for table `customer_category`
--
ALTER TABLE `customer_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `customer_visit`
--
ALTER TABLE `customer_visit`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5468;

--
-- AUTO_INCREMENT for table `customer_visit_finished_product`
--
ALTER TABLE `customer_visit_finished_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT for table `customer_visit_gift_product`
--
ALTER TABLE `customer_visit_gift_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `deposit_request`
--
ALTER TABLE `deposit_request`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=989;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `distID` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `doctor`
--
ALTER TABLE `doctor`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=322;

--
-- AUTO_INCREMENT for table `doctor_products`
--
ALTER TABLE `doctor_products`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=286;

--
-- AUTO_INCREMENT for table `doctor_visit`
--
ALTER TABLE `doctor_visit`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3099;

--
-- AUTO_INCREMENT for table `doctor_visit_finished_product`
--
ALTER TABLE `doctor_visit_finished_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=405;

--
-- AUTO_INCREMENT for table `doctor_visit_gift_product`
--
ALTER TABLE `doctor_visit_gift_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;

--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `employee_department`
--
ALTER TABLE `employee_department`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `employee_designation`
--
ALTER TABLE `employee_designation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `employee_salary`
--
ALTER TABLE `employee_salary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `employee_salary_allowance`
--
ALTER TABLE `employee_salary_allowance`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `gift_distribute`
--
ALTER TABLE `gift_distribute`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=542;

--
-- AUTO_INCREMENT for table `gift_distribute_product`
--
ALTER TABLE `gift_distribute_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1568;

--
-- AUTO_INCREMENT for table `honorarium_evaluation`
--
ALTER TABLE `honorarium_evaluation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `module`
--
ALTER TABLE `module`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126;

--
-- AUTO_INCREMENT for table `monthly_target`
--
ALTER TABLE `monthly_target`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `person`
--
ALTER TABLE `person`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `production_product`
--
ALTER TABLE `production_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=726;

--
-- AUTO_INCREMENT for table `production_product_source`
--
ALTER TABLE `production_product_source`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4707;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=317;

--
-- AUTO_INCREMENT for table `product_category`
--
ALTER TABLE `product_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `product_closing_stock`
--
ALTER TABLE `product_closing_stock`
  MODIFY `pcsID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_opening_stock`
--
ALTER TABLE `product_opening_stock`
  MODIFY `posID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_price_log`
--
ALTER TABLE `product_price_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=356;

--
-- AUTO_INCREMENT for table `product_stock_log`
--
ALTER TABLE `product_stock_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15826;

--
-- AUTO_INCREMENT for table `purchase`
--
ALTER TABLE `purchase`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=350;

--
-- AUTO_INCREMENT for table `purchase_additional_cost`
--
ALTER TABLE `purchase_additional_cost`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `purchase_details`
--
ALTER TABLE `purchase_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=811;

--
-- AUTO_INCREMENT for table `purchase_draft`
--
ALTER TABLE `purchase_draft`
  MODIFY `purID` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `purchase_order`
--
ALTER TABLE `purchase_order`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_order_details`
--
ALTER TABLE `purchase_order_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_requisition`
--
ALTER TABLE `purchase_requisition`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `purchase_requisition_details`
--
ALTER TABLE `purchase_requisition_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `purchase_return`
--
ALTER TABLE `purchase_return`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_return_details`
--
ALTER TABLE `purchase_return_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_truk`
--
ALTER TABLE `purchase_truk`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `queue_sms`
--
ALTER TABLE `queue_sms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2755;

--
-- AUTO_INCREMENT for table `reject_products`
--
ALTER TABLE `reject_products`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=391;

--
-- AUTO_INCREMENT for table `report_cach`
--
ALTER TABLE `report_cach`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `salary_allowance`
--
ALTER TABLE `salary_allowance`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sale`
--
ALTER TABLE `sale`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2718;

--
-- AUTO_INCREMENT for table `sale_additional_cost`
--
ALTER TABLE `sale_additional_cost`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sale_draft`
--
ALTER TABLE `sale_draft`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `sale_products`
--
ALTER TABLE `sale_products`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6578;

--
-- AUTO_INCREMENT for table `sale_product_scource`
--
ALTER TABLE `sale_product_scource`
  MODIFY `spsID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sale_return`
--
ALTER TABLE `sale_return`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=246;

--
-- AUTO_INCREMENT for table `sale_return_details`
--
ALTER TABLE `sale_return_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=569;

--
-- AUTO_INCREMENT for table `sale_return_process_data`
--
ALTER TABLE `sale_return_process_data`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=555;

--
-- AUTO_INCREMENT for table `sale_truk`
--
ALTER TABLE `sale_truk`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `truk`
--
ALTER TABLE `truk`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=255;

--
-- AUTO_INCREMENT for table `user_group`
--
ALTER TABLE `user_group`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `user_login_session`
--
ALTER TABLE `user_login_session`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8859;

--
-- AUTO_INCREMENT for table `user_manager`
--
ALTER TABLE `user_manager`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `user_permissions`
--
ALTER TABLE `user_permissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `a_bank_withdraw`
--
ALTER TABLE `a_bank_withdraw`
  ADD CONSTRAINT `FK_a_bank_withdraw_a_bank_info` FOREIGN KEY (`biID`) REFERENCES `a_bank_info` (`biID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `a_employee_salary`
--
ALTER TABLE `a_employee_salary`
  ADD CONSTRAINT `FK_a_employee_salary_employees` FOREIGN KEY (`eID`) REFERENCES `employees` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `module_permission`
--
ALTER TABLE `module_permission`
  ADD CONSTRAINT `FK_module_permission_module` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_module_permission_user_group` FOREIGN KEY (`group_id`) REFERENCES `user_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `production_product`
--
ALTER TABLE `production_product`
  ADD CONSTRAINT `FK_production_product_products` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `production_product_source`
--
ALTER TABLE `production_product_source`
  ADD CONSTRAINT `FK_production_product_source_production_product` FOREIGN KEY (`production_id`) REFERENCES `production_product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_production_product_source_products` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_closing_stock`
--
ALTER TABLE `product_closing_stock`
  ADD CONSTRAINT `FK_product_closing_stock_products` FOREIGN KEY (`pID`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_product_closing_stock_suppliers` FOREIGN KEY (`supID`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `purchase_additional_cost`
--
ALTER TABLE `purchase_additional_cost`
  ADD CONSTRAINT `FK_purchase_additional_cost_additional_expense` FOREIGN KEY (`additional_expense_id`) REFERENCES `additional_expense` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_purchase_additional_cost_purchase` FOREIGN KEY (`purchase_id`) REFERENCES `purchase` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_purchase_additional_cost_truk` FOREIGN KEY (`truk_id`) REFERENCES `truk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `purchase_details`
--
ALTER TABLE `purchase_details`
  ADD CONSTRAINT `FK_purchase_details_products` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_purchase_details_purchase` FOREIGN KEY (`purchase_id`) REFERENCES `purchase` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `purchase_draft`
--
ALTER TABLE `purchase_draft`
  ADD CONSTRAINT `FK_purchase_draft_suppliers` FOREIGN KEY (`supID`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `purchase_truk`
--
ALTER TABLE `purchase_truk`
  ADD CONSTRAINT `FK_purchase_truk_purchase` FOREIGN KEY (`purchase_id`) REFERENCES `purchase` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_purchase_truk_truk` FOREIGN KEY (`truk_id`) REFERENCES `truk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sale`
--
ALTER TABLE `sale`
  ADD CONSTRAINT `FK_sale_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sale_additional_cost`
--
ALTER TABLE `sale_additional_cost`
  ADD CONSTRAINT `FK_sale_additional_cost_additional_expense` FOREIGN KEY (`additional_expense_id`) REFERENCES `additional_expense` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_sale_additional_cost_sale` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_sale_additional_cost_truk` FOREIGN KEY (`truk_id`) REFERENCES `truk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sale_products`
--
ALTER TABLE `sale_products`
  ADD CONSTRAINT `FK_sale_products_products` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_sale_products_sale` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sale_product_scource`
--
ALTER TABLE `sale_product_scource`
  ADD CONSTRAINT `FK_sale_product_scource_products` FOREIGN KEY (`pID`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_sale_product_scource_sale` FOREIGN KEY (`sID`) REFERENCES `sale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sale_truk`
--
ALTER TABLE `sale_truk`
  ADD CONSTRAINT `FK_sale_truk_sale` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_sale_truk_truk` FOREIGN KEY (`truk_id`) REFERENCES `truk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `FK_users_user_group` FOREIGN KEY (`group_id`) REFERENCES `user_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_login_session`
--
ALTER TABLE `user_login_session`
  ADD CONSTRAINT `FK_user_login_session_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_permissions`
--
ALTER TABLE `user_permissions`
  ADD CONSTRAINT `FK_user_permissions_module` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_permission_assign`
--
ALTER TABLE `user_permission_assign`
  ADD CONSTRAINT `FK_user_permission_assign_user_group` FOREIGN KEY (`group_id`) REFERENCES `user_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_user_permission_assign_user_permissions` FOREIGN KEY (`permission_id`) REFERENCES `user_permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

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