-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 29, 2026 at 12:59 AM -- Server version: 11.8.8-MariaDB -- PHP Version: 8.2.12 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: `ah_pos` -- -- -------------------------------------------------------- -- -- Table structure for table `account_chart` -- CREATE TABLE `account_chart` ( `AccCode` int(11) NOT NULL, `Type` varchar(20) DEFAULT NULL, `Category` varchar(50) DEFAULT NULL, `Sub_Category` varchar(150) DEFAULT NULL, `Grp` varchar(150) DEFAULT NULL, `AccName` varchar(50) DEFAULT NULL, `Referance` varchar(50) DEFAULT NULL, `Address` text DEFAULT NULL, `Contact_person` varchar(50) DEFAULT NULL, `Designation` varchar(50) DEFAULT NULL, `Phone_No` varchar(50) DEFAULT NULL, `cus_serial` int(11) DEFAULT NULL, `custype` varchar(50) DEFAULT NULL, `Fax_No` varchar(50) DEFAULT NULL, `Mobile_No` varchar(50) DEFAULT NULL, `Email_add` varchar(50) DEFAULT NULL, `employee_wise` varchar(3) DEFAULT NULL, `bank` varchar(150) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `account_chart` -- INSERT INTO `account_chart` (`AccCode`, `Type`, `Category`, `Sub_Category`, `Grp`, `AccName`, `Referance`, `Address`, `Contact_person`, `Designation`, `Phone_No`, `cus_serial`, `custype`, `Fax_No`, `Mobile_No`, `Email_add`, `employee_wise`, `bank`) VALUES (40, 'Liabilities', ' Capital Employed', 'Long Tarm Liabilities', 'Tax Payable', 'Value Added Tax', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (41, 'Expenses', ' Administrative Cost', 'Indirect Expenses', 'Advance and Deposits', 'Inventory', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (42, 'Income', ' Revenue', 'Indirect Income', 'Income', 'Service', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (43, NULL, NULL, NULL, 'CandS', 'Md.Alamin Mollah', NULL, 'Dhaka', NULL, NULL, NULL, NULL, 'Supplier', NULL, '01990439132', NULL, NULL, NULL), (44, NULL, NULL, NULL, 'CandS', 'Md. Abdul Halim', NULL, 'Dhaka', NULL, NULL, NULL, NULL, 'Supplier', NULL, '01990439133', NULL, NULL, NULL), (101, NULL, NULL, NULL, 'CandS', 'Rahim Store', NULL, 'Dhaka', NULL, NULL, NULL, NULL, 'Supplier', NULL, '01711000001', NULL, NULL, NULL), (102, NULL, NULL, NULL, 'CandS', 'Karim Enterprise', NULL, 'Gazipur', NULL, NULL, NULL, NULL, 'Supplier', NULL, '01711000002', NULL, NULL, NULL), (103, NULL, NULL, NULL, 'CandS', 'Bismillah Traders', NULL, 'Narayanganj', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000003', NULL, NULL, NULL), (104, NULL, NULL, NULL, 'CandS', 'Al Amin Store', NULL, 'Cumilla', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000004', NULL, NULL, NULL), (105, NULL, NULL, NULL, 'CandS', 'New Brothers', NULL, 'Chattogram', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000005', NULL, NULL, NULL), (106, NULL, NULL, NULL, 'CandS', 'Sumi Fashion', NULL, 'Khulna', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000006', NULL, NULL, NULL), (107, NULL, NULL, NULL, 'CandS', 'Mim Enterprise', NULL, 'Rajshahi', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000007', NULL, NULL, NULL), (108, NULL, NULL, NULL, 'CandS', 'Sakib Traders', NULL, 'Sylhet', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000008', NULL, NULL, NULL), (109, NULL, NULL, NULL, 'CandS', 'Hasan Store', NULL, 'Barishal', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000009', NULL, NULL, NULL), (110, NULL, NULL, NULL, 'CandS', 'Noman Telecom', NULL, 'Rangpur', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000010', NULL, NULL, NULL), (111, NULL, NULL, NULL, 'CandS', 'Akash Traders', NULL, 'Dhaka', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000011', NULL, NULL, NULL), (112, NULL, NULL, NULL, 'CandS', 'Rifat Store', NULL, 'Gazipur', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000012', NULL, NULL, NULL), (113, NULL, NULL, NULL, 'CandS', 'Jannat Enterprise', NULL, 'Cumilla', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000013', NULL, NULL, NULL), (114, NULL, NULL, NULL, 'CandS', 'Tanmoy Traders', NULL, 'Narsingdi', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000014', NULL, NULL, NULL), (115, NULL, NULL, NULL, 'CandS', 'Sabbir Store', NULL, 'Mymensingh', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000015', NULL, NULL, NULL), (116, NULL, NULL, NULL, 'CandS', 'Shuvo Electronics', NULL, 'Bogura', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000016', NULL, NULL, NULL), (117, NULL, NULL, NULL, 'CandS', 'Asha Fashion', NULL, 'Jessore', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000017', NULL, NULL, NULL), (118, NULL, NULL, NULL, 'CandS', 'Moon Traders', NULL, 'Noakhali', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000018', NULL, NULL, NULL), (119, NULL, NULL, NULL, 'CandS', 'Star Enterprise', NULL, 'Feni', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000019', NULL, NULL, NULL), (120, NULL, NULL, NULL, 'CandS', 'Golden Store', NULL, 'Tangail', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000020', NULL, NULL, NULL), (121, NULL, NULL, NULL, 'CandS', 'Royal Traders', NULL, 'Kushtia', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000021', NULL, NULL, NULL), (122, NULL, NULL, NULL, 'CandS', 'Modern Fashion', NULL, 'Pabna', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000022', NULL, NULL, NULL), (123, NULL, NULL, NULL, 'CandS', 'Nabila Enterprise', NULL, 'Sirajganj', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000023', NULL, NULL, NULL), (124, NULL, NULL, NULL, 'CandS', 'Dream Store', NULL, 'Faridpur', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000024', NULL, NULL, NULL), (125, NULL, NULL, NULL, 'CandS', 'Smart Traders', NULL, 'Dhaka', NULL, NULL, NULL, NULL, 'customer', NULL, '01711000025', NULL, NULL, NULL), (126, NULL, NULL, NULL, 'CandS', 'Md. Masuduzzman Khan', NULL, 'Savar, Dhaka', NULL, NULL, NULL, NULL, 'customer', NULL, '01715431267', NULL, NULL, NULL), (127, NULL, NULL, NULL, 'CandS', 'Md. Imamul Haque', NULL, 'Dhak', NULL, NULL, NULL, NULL, 'customer', NULL, '01775828699', NULL, NULL, NULL), (128, 'Assets', ' Current Assets', 'Cash and Bank', 'Cash in Hand', 'Cash', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (129, 'Assets', ' Current Assets', 'Cash and Bank', 'Cash at Bank', 'Bank', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (130, 'Assets', ' Current Assets', 'Cash and Bank', 'Cash at MobileBank', 'MbileBank', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `account_types` -- CREATE TABLE `account_types` ( `id` int(11) NOT NULL, `type_name` varchar(50) NOT NULL, `code_range_start` int(11) NOT NULL, `code_range_end` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `audit_logs` -- CREATE TABLE `audit_logs` ( `id` bigint(20) NOT NULL, `user_id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `action_type` varchar(50) NOT NULL, `table_name` varchar(100) NOT NULL, `record_id` bigint(20) NOT NULL, `description` text DEFAULT NULL, `details` text DEFAULT NULL, `old_data` longtext DEFAULT NULL, `new_data` longtext DEFAULT NULL, `changed_fields` text DEFAULT NULL, `ip_address` varchar(100) DEFAULT NULL, `user_agent` text DEFAULT NULL, `session_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `audit_logs` -- INSERT INTO `audit_logs` (`id`, `user_id`, `username`, `action_type`, `table_name`, `record_id`, `description`, `details`, `old_data`, `new_data`, `changed_fields`, `ip_address`, `user_agent`, `session_id`, `created_at`) VALUES (1, 7, 'Md. Liton Chowdhury', 'UPDATE', 'quotations', 2, NULL, 'Quotation Updated', NULL, NULL, NULL, '2401:1900:18b:fce2:d125:5343:c529:2886', NULL, NULL, '2026-05-21 02:13:40'), (2, 7, 'Khan', 'CREATE', 'quotations', 0, NULL, 'Quotation Created', NULL, NULL, NULL, '2401:1900:18b:fce2:598b:d1de:bba9:31f0', NULL, NULL, '2026-05-22 19:02:10'), (3, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 10:23:13'), (4, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 13:54:41'), (5, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:01:54'), (6, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:05:59'), (7, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created Successfully', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:08:38'), (8, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:10:47'), (9, 7, 'Khan', 'CREATE', 'quotations', 4, NULL, 'Quotation Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:18:43'), (10, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:36:10'), (11, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:37:31'), (12, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:42:37'), (13, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:46:22'), (14, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:58:08'), (15, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 16:02:54'), (16, 7, 'Khan', 'CREATE', 'quotations', 6, NULL, 'Quotation Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 16:15:33'), (17, 7, 'Khan', 'CREATE', 'quotations', 7, NULL, 'Quotation Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 16:20:44'), (18, 7, 'Khan', 'CREATE', 'quotations', 8, NULL, 'Quotation Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 16:31:24'), (19, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '2401:1900:18b:fce2:612d:d7b3:acb1:d381', NULL, NULL, '2026-05-24 18:30:28'), (20, 7, 'Khan', 'CREATE', 'purchases', 10, NULL, 'Purchase Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-26 07:21:10'), (21, 7, 'Khan', 'CREATE', 'purchases', 11, NULL, 'Purchase Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-26 08:59:39'); -- -------------------------------------------------------- -- -- Table structure for table `banks` -- CREATE TABLE `banks` ( `id` int(10) UNSIGNED NOT NULL, `bank_name` varchar(150) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `bank_accounts` -- CREATE TABLE `bank_accounts` ( `id` int(10) UNSIGNED NOT NULL, `account_chart_code` int(11) NOT NULL, `account_name` varchar(150) NOT NULL, `account_no` varchar(100) NOT NULL, `bank_name` varchar(150) NOT NULL, `swift_code` varchar(50) DEFAULT NULL, `branch_name` varchar(150) DEFAULT NULL, `account_type` varchar(50) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bank_accounts` -- INSERT INTO `bank_accounts` (`id`, `account_chart_code`, `account_name`, `account_no`, `bank_name`, `swift_code`, `branch_name`, `account_type`, `status`, `created_at`) VALUES (1, 129, 'Khan Engineering Corporation', '123456', 'Dutch Bangla Bank PLC', NULL, 'Dhaka', 'Current', 1, '2026-08-28 19:21:12'), (2, 129, 'Khan Engineering Corporation', '1452366', 'Brac Bank PLC', '25362', 'Dhaka Dakshin', 'Current', 1, '2026-08-28 19:28:04'); -- -------------------------------------------------------- -- -- Table structure for table `bill_ledger` -- CREATE TABLE `bill_ledger` ( `id` int(11) NOT NULL, `date` date DEFAULT NULL, `bill_no` varchar(50) NOT NULL, `voucher_no` varchar(100) DEFAULT NULL, `account_code` int(11) DEFAULT NULL, `account_name` varchar(255) DEFAULT NULL, `debit` decimal(18,2) DEFAULT 0.00, `credit` decimal(18,2) DEFAULT 0.00, `narration` text DEFAULT NULL, `reference_table` varchar(100) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bill_ledger` -- INSERT INTO `bill_ledger` (`id`, `date`, `bill_no`, `voucher_no`, `account_code`, `account_name`, `debit`, `credit`, `narration`, `reference_table`, `reference_id`, `created_by`, `created_at`) VALUES (1, '2026-08-28', 'PUR-2', 'PUR-2', 102, 'Karim Enterprise', 0.00, 70.00, 'Purchase Invoice #2 | Kararibog Rice x 1', 'purchases', 2, 101, '2026-08-28 18:23:06'); -- -------------------------------------------------------- -- -- Table structure for table `chart_of_accounts` -- CREATE TABLE `chart_of_accounts` ( `id` int(11) NOT NULL, `account_code` varchar(20) NOT NULL, `account_name` varchar(100) NOT NULL, `account_type_id` int(11) NOT NULL, `parent_id` int(11) DEFAULT NULL, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `company` -- CREATE TABLE `company` ( `ID` int(11) NOT NULL, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL, `full_name` varchar(100) NOT NULL, `short_name` varchar(50) NOT NULL, `Address` text NOT NULL, `contact_number` varchar(50) DEFAULT NULL, `pad_header` text DEFAULT NULL, `pad_footer` text DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `company` -- INSERT INTO `company` (`ID`, `first_name`, `last_name`, `full_name`, `short_name`, `Address`, `contact_number`, `pad_header`, `pad_footer`) VALUES (1, 'Khan Engineering', 'Corporation', 'Khan Engineering Corporation', 'KEC', '196 Ashrafabad, Kamrangir Char, Dhaka-1211', '+8801990439132', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `general_ledger` -- CREATE TABLE `general_ledger` ( `id` int(11) NOT NULL, `date` date DEFAULT NULL, `voucher_no` varchar(100) DEFAULT NULL, `account_code` int(11) DEFAULT NULL, `account_name` varchar(255) DEFAULT NULL, `mode_reference` varchar(50) DEFAULT NULL, `mode_id` int(10) UNSIGNED DEFAULT NULL, `debit` decimal(18,2) DEFAULT 0.00, `credit` decimal(18,2) DEFAULT 0.00, `narration` text DEFAULT NULL, `reference_table` varchar(100) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `general_ledger` -- INSERT INTO `general_ledger` (`id`, `date`, `voucher_no`, `account_code`, `account_name`, `mode_reference`, `mode_id`, `debit`, `credit`, `narration`, `reference_table`, `reference_id`, `created_by`, `created_at`) VALUES (1, '2026-08-28', 'PUR-1', 41, 'Inventory', NULL, NULL, 45.00, 0.00, 'Purchase Invoice #1 | Chocolate x 1', 'purchases', 1, 101, '2026-08-28 15:52:22'), (2, '2026-08-28', 'PUR-1', 128, 'Cash', NULL, NULL, 0.00, 45.00, 'Purchase Invoice #1 | Chocolate x 1', 'purchases', 1, 101, '2026-08-28 15:52:22'), (5, '2026-08-28', 'SAL-1', 41, 'Inventory', NULL, NULL, 0.00, 50.00, 'Sales Invoice #1 | Chocolate x 1', 'sales', 1, 101, '2026-08-28 15:54:05'), (6, '2026-08-28', 'SAL-1', 40, 'Value Added Tax', NULL, NULL, 0.00, 2.50, 'Sales Invoice #1 | Chocolate x 1', 'sales', 1, 101, '2026-08-28 15:54:05'), (7, '2026-08-28', 'SAL-1', 128, 'Cash', NULL, NULL, 52.50, 0.00, 'Sales Invoice #1 | Chocolate x 1', 'sales', 1, 101, '2026-08-28 15:54:05'), (8, '2026-08-28', 'PUR-2', 41, 'Inventory', NULL, NULL, 70.00, 0.00, 'Purchase Invoice #2 | Kararibog Rice x 1', 'purchases', 2, 101, '2026-08-28 18:23:06'), (9, '2026-08-28', 'PUR-2', 102, 'Karim Enterprise', NULL, NULL, 0.00, 70.00, 'Purchase Invoice #2 | Kararibog Rice x 1', 'purchases', 2, 101, '2026-08-28 18:23:06'), (10, '2026-08-28', 'SAL-2', 41, 'Inventory', NULL, NULL, 0.00, 75.00, 'Sales Invoice #2 | Kararibog Rice x 1', 'sales', 2, 101, '2026-08-28 18:23:18'), (11, '2026-08-28', 'SAL-2', 104, 'Al Amin Store', NULL, NULL, 75.00, 0.00, 'Sales Invoice #2 | Kararibog Rice x 1', 'sales', 2, 101, '2026-08-28 18:23:18'), (12, '2026-08-28', 'PAY-1', 102, 'Karim Enterprise', 'cash', NULL, 500.00, 0.00, 'Payment | dfsd', 'payment', 12, 1, '2026-08-28 21:22:41'), (13, '2026-08-28', 'PAY-1', 128, 'Cash', 'cash', NULL, 0.00, 500.00, 'Payment | dfsd', 'payment', 12, 1, '2026-08-28 21:22:41'), (14, '2026-08-28', 'PAY-2', 102, 'Karim Enterprise', 'cash', NULL, 500.00, 0.00, 'Payment', 'payment', 14, 0, '2026-08-28 21:35:44'), (15, '2026-08-28', 'PAY-2', 128, 'Cash', 'cash', NULL, 0.00, 500.00, 'Payment', 'payment', 14, 0, '2026-08-28 21:35:44'), (16, '2026-08-28', 'DV-0001', 111, 'Akash Traders', 'cash', NULL, 500.00, 0.00, 'Payment', 'payment', 16, 0, '2026-08-28 21:43:18'), (17, '2026-08-28', 'DV-0001', 128, 'Cash', 'cash', NULL, 0.00, 500.00, 'Payment', 'payment', 16, 0, '2026-08-28 21:43:18'), (18, '2026-08-28', 'DV-0002', 104, 'Al Amin Store', 'bank_accounts', 2, 500.00, 0.00, 'Payment', 'payment', 18, 0, '2026-08-28 21:43:40'), (19, '2026-08-28', 'DV-0002', 129, 'Bank - 1452366', 'bank_accounts', 2, 0.00, 500.00, 'Payment', 'payment', 18, 0, '2026-08-28 21:43:40'), (20, '2026-08-29', 'DV-0003', 104, 'Al Amin Store', 'bank_accounts', 2, 200.00, 0.00, 'Payment', 'payment', 20, 1, '2026-08-28 22:26:07'), (21, '2026-08-29', 'DV-0003', 129, 'Bank - 1452366', 'bank_accounts', 2, 0.00, 200.00, 'Payment', 'payment', 20, 1, '2026-08-28 22:26:07'); -- -------------------------------------------------------- -- -- Table structure for table `journal_entries` -- CREATE TABLE `journal_entries` ( `id` int(11) NOT NULL, `entry_date` date NOT NULL, `reference_no` varchar(50) DEFAULT NULL, `narration` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `journal_items` -- CREATE TABLE `journal_items` ( `id` int(11) NOT NULL, `journal_entry_id` int(11) NOT NULL, `account_id` int(11) NOT NULL, `party_id` int(11) DEFAULT NULL, `debit` decimal(15,2) DEFAULT 0.00, `credit` decimal(15,2) DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `main_chart` -- CREATE TABLE `main_chart` ( `ID` int(11) NOT NULL, `date` varchar(20) NOT NULL, `country` varchar(50) NOT NULL, `state` varchar(50) NOT NULL, `city` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `main_chart` -- INSERT INTO `main_chart` (`ID`, `date`, `country`, `state`, `city`) VALUES (1, '22-07-2015', 'Assets', 'Fixed Assets', 'Tangible Fixed Assets'), (2, '22-07-2015', 'Assets', 'Fixed Assets', 'Intangible Fixed Assets'), (3, '22-07-2015', 'Assets', 'Non Current Assets', 'Investment'), (4, '22-07-2015', 'Assets', 'Current Assets', 'Cash and Bank '), (7, '22-07-2015', 'Assets', 'Current Assets', 'Other Current Assets'), (8, '22-07-2015', 'Liabilities', 'Current Liabilities', 'Bank Loan'), (9, '22-07-2015', 'Liabilities', 'Current Liabilities', 'Provision for Expenses'), (10, '22-07-2015', 'Liabilities', 'Current Liabilities', 'Current Liabilities'), (11, '22-07-2015', 'Liabilities', 'Current Liabilities', 'Sundry Creditors'), (12, '22-07-2015', 'Liabilities', 'Current Liabilities', 'Capital '), (13, '22-07-2015', 'Liabilities', 'Current Liabilities', 'Deductions'), (14, '22-07-2015', 'Liabilities', 'Accumulated Depreciation', 'Accumulated Depreciation Last'), (15, '22-07-2015', 'Liabilities', 'Accumulated Depreciation ', 'Accumulated Depreciation Current'), (16, '22-07-2015', 'Liabilities', 'Capital Employed', 'Long Tarm Liabilities'), (17, '22-07-2015', 'Liabilities', 'Equity of Share Holder', 'Balance of Profit Loss A/C'), (18, '22-07-2015', 'Income', 'Revenue', 'Direct Income'), (19, '22-07-2015', 'Income', 'Revenue', 'Indirect Income'), (20, '22-07-2015', 'Expenses', 'Cost of Revenue', 'Wages and Salary'), (21, '22-07-2015', 'Expenses', 'Administrative Cost', 'Salary & Allowance'), (22, '22-07-2015', 'Expenses', 'Cost of Revenue', 'Direct Expenses'), (23, '22-07-2015', 'Expenses', 'Administrative Cost', 'Directors Remuneration'), (24, '22-07-2015', 'Expenses', 'Administrative Cost', 'Indirect Expenses'); -- -------------------------------------------------------- -- -- Table structure for table `mobile_banking_accounts` -- CREATE TABLE `mobile_banking_accounts` ( `id` int(10) UNSIGNED NOT NULL, `account_chart_code` int(11) NOT NULL, `account_name` varchar(255) NOT NULL, `mobile_number` varchar(30) NOT NULL, `mobile_banking_type` varchar(50) NOT NULL, `account_type` varchar(50) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `mobile_banking_accounts` -- INSERT INTO `mobile_banking_accounts` (`id`, `account_chart_code`, `account_name`, `mobile_number`, `mobile_banking_type`, `account_type`, `status`, `created_at`, `updated_at`) VALUES (1, 130, 'Khan Engineering Corporation', '01990439132', 'bKash', 'Personal', 1, '2026-08-28 20:03:16', '2026-08-28 20:16:38'); -- -------------------------------------------------------- -- -- Table structure for table `module` -- CREATE TABLE `module` ( `mod_modulegroupcode` varchar(25) NOT NULL, `mod_modulegroupname` varchar(50) NOT NULL, `mod_modulecode` varchar(25) NOT NULL, `mod_modulename` varchar(50) NOT NULL, `mod_modulegrouporder` int(11) NOT NULL, `mod_moduleorder` int(11) NOT NULL, `mod_modulepagename` varchar(255) NOT NULL, `mod_moduleicon` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `module` -- INSERT INTO `module` (`mod_modulegroupcode`, `mod_modulegroupname`, `mod_modulecode`, `mod_modulename`, `mod_modulegrouporder`, `mod_moduleorder`, `mod_modulepagename`, `mod_moduleicon`) VALUES ('CHECKOUT', 'Checkout', 'ACCOUNT MANAGEMENT', 'Accounts', 1, 1, 'Accounts/info.php', 'accounts.png'), ('CHECKOUT', 'Checkout', 'EMPLOYEE', 'HR & Admin', 2, 2, 'HR-Admin/employee.php', 'hr.png'), ('CHECKOUT', 'Checkout', 'INVENTORY', 'Inventory ', 2, 1, 'Inventory/inventory.php', 'inventory.png'), ('CHECKOUT', 'Checkout', 'OFFER', 'Offer', 3, 3, 'offer/index.php', 'offer.png'), ('CHECKOUT', 'Checkout', 'REPORT', 'Challan', 3, 3, 'report.php', 'challan.png'), ('CHECKOUT', 'Checkout', 'REPORTS', 'Invoice', 3, 1, 'reports.php', 'invoice.png'), ('CHECKOUT', 'Checkout', 'SYSTEM', 'System Setup', 3, 3, 'System.php', 'system.png'); -- -------------------------------------------------------- -- -- Table structure for table `parties` -- CREATE TABLE `parties` ( `id` int(11) NOT NULL, `party_name` varchar(150) NOT NULL, `email` varchar(100) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `is_customer` tinyint(1) DEFAULT 0, `is_supplier` tinyint(1) DEFAULT 0, `receivable_account_id` int(11) DEFAULT NULL, `payable_account_id` int(11) DEFAULT NULL, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_vouchers` -- CREATE TABLE `payment_vouchers` ( `id` int(10) UNSIGNED NOT NULL, `payment_date` date NOT NULL, `voucher_no` varchar(50) NOT NULL, `account_code` int(11) NOT NULL, `account_name` varchar(255) DEFAULT NULL, `amount` decimal(18,2) NOT NULL DEFAULT 0.00, `payment_mode` varchar(30) NOT NULL, `bank_id` int(11) DEFAULT NULL, `bank_account_id` int(11) DEFAULT NULL, `mobile_id` int(11) DEFAULT NULL, `mode_reference` varchar(255) DEFAULT NULL, `mode_id` int(11) DEFAULT NULL, `instrument_number` varchar(100) DEFAULT NULL, `instrument_date` date DEFAULT NULL, `mobile_provider` varchar(50) DEFAULT NULL, `mobile_account` varchar(50) DEFAULT NULL, `payment_by` int(11) DEFAULT NULL, `description` text DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_voucher_items` -- CREATE TABLE `payment_voucher_items` ( `id` int(10) UNSIGNED NOT NULL, `payment_id` int(10) UNSIGNED NOT NULL, `bill_ledger_id` int(10) UNSIGNED NOT NULL, `bill_no` varchar(100) NOT NULL, `amount` decimal(18,2) NOT NULL DEFAULT 0.00, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `id` int(11) NOT NULL, `Brand_Name` varchar(255) DEFAULT NULL, `Barcode` varchar(100) DEFAULT NULL, `company_barcode` varchar(255) DEFAULT NULL, `Product_Name` varchar(255) DEFAULT NULL, `Part_Number` varchar(150) DEFAULT NULL, `sale_price` decimal(12,2) DEFAULT NULL, `Unit` varchar(30) DEFAULT NULL, `product_has` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `product` -- INSERT INTO `product` (`id`, `Brand_Name`, `Barcode`, `company_barcode`, `Product_Name`, `Part_Number`, `sale_price`, `Unit`, `product_has`) VALUES (1, 'Netsle', '89012345000001', '8941100294833', 'Magi-4pac-Nodles', 'N-01', 95.00, 'Pcs', NULL), (2, 'Netsle', '89012345000002', '8941100294840', 'Magi-8pac-Nodles', 'N-02', 180.00, 'Pcs', NULL), (3, 'Netsle', '89012345000003', NULL, 'Nescafe Classic 0.9 gram', 'N-03', 5.00, 'Pcs', NULL), (4, 'Netsle', '89012345000004', '8941100295670', 'Maggi sad a magik', 'N-04', 5.00, 'Pcs', NULL), (5, 'Netsle', '89012345000005', '8941100296516', 'Nescafe 3 in 1 Original', 'N-05', 15.00, 'Pcs', NULL), (6, 'Netsle', '89012345000006', NULL, 'Lactogen-1', 'N-06', 350.00, 'Pcs', NULL), (7, 'Netsle', '89012345000007', NULL, 'Lactogen-02', 'N-07', 350.00, 'Pcs', NULL), (8, 'Netsle', '89012345000008', '8941100296295', 'Lactogen-03', 'N-08', 340.00, 'Pcs', NULL), (9, 'Netsle', '89012345000009', '8941100296325', 'Lactogen-04', 'N-09', 340.00, 'Pcs', NULL), (10, 'Netsle', '89012345000010', '8901058001617', 'Nescafe Classic 24g', 'N-10', 195.00, 'Pcs', NULL), (11, 'Netsle', '89012345000011', '8901058006377', 'Nescafe Classic 45g', 'N-11', 275.00, 'Pcs', NULL), (13, 'Pran', '89012345000013', '841165147502', 'Potata 50g', 'P-01', 20.00, 'Pcs', NULL), (14, 'Pran', '89012345000014', '846656019665', 'Fit 60g', 'P-02', 20.00, 'Pcs', NULL), (15, 'Pran', '89012345000015', '840205730650', 'Soya sos 200ml', 'P-03', 60.00, 'Pcs', NULL), (16, 'Pran', '89012345000016', '841165107537', 'Soya sos 285ml', 'P-04', 90.00, 'Pcs', NULL), (17, 'Pran', '89012345000017', '841165123087', 'Red Chili sos 240g', 'P-05', 150.00, 'Pcs', NULL), (18, 'Pran', '89012345000018', '846656001790', 'Hot Tometo sos 200g', 'P-06', 90.00, 'Pcs', NULL), (19, 'Pran', '89012345000019', '831730001766', 'Misty Boray acar 350g', 'P-07', 180.00, 'Pcs', NULL), (20, 'Pran', '89012345000020', '840205747450', 'Kalojira rosun acar 200g', 'P-08', 165.00, 'Pcs', NULL), (21, 'Pran', '89012345000021', '831730001636', 'Amer acar 400g', 'P-09', 200.00, 'Pcs', NULL), (22, 'Pran', '89012345000022', '831730001711', 'Jolpy acar 400g', 'P-10', 200.00, 'Pcs', NULL), (23, 'Pran', '89012345000023', '831730001926', 'Mixt acar 400g', 'P-11', 200.00, 'Pcs', NULL), (24, 'Pran', '89012345000024', '831730002541', 'Apple Jelly 350g', 'P-12', 165.00, 'Pcs', NULL), (25, 'Pran', '89012345000025', '841165150595', 'Hot Tometo sos 160g', 'P-13', 70.00, 'Pcs', NULL), (26, 'Pran', '89012345000026', '846656005088', 'Hor tometo sos 250g', 'P-14', 100.00, 'Pcs', NULL), (27, 'Pran', '89012345000027', '841165150601', 'Hot tometo sos 320g', 'P-15', 120.00, 'Pcs', NULL), (28, 'Pran', '89012345000028', '841165163489', 'Hot tometo sos 500g', 'P-16', 160.00, 'Pcs', NULL), (29, 'Pran', '89012345000029', '841165118335', 'M.cup 40g', 'P-17', 35.00, 'Pcs', NULL), (30, 'Pran', '89012345000030', '841165155750', 'Sipco 500g', 'P-18', 330.00, 'Pcs', NULL), (31, 'Pran', '89012345000031', '841165155385', 'Sipco 200g', 'P-19', 100.00, 'Pcs', NULL), (32, 'Pran', '89012345000032', '840205793303', 'Boom Chocolale', 'P-20', 5.00, 'Pcs', NULL), (33, 'Pran', '89012345000033', '840205720118', 'Frutfan 80ml', 'P-21', 10.00, 'Pcs', NULL), (34, 'Pran', '89012345000034', '841165115235', 'Ziroos 14g', 'P-22', 10.00, 'Pcs', NULL), (35, 'Pran', '89012345000035', '831730009335', 'Mr.noodles stick 120g', 'P-23', 20.00, 'Pcs', NULL), (36, 'Pran', '89012345000036', '846656004029', 'Mr. Noodlse Magic Masala 248g', 'P-24', 90.00, 'Pcs', NULL), (37, 'Pran', '89012345000037', '840205714407', 'Mr. Noodlse korean 4 pcs 248g', 'P-25', 110.00, 'Pcs', NULL), (38, 'Pran', '89012345000038', '841165110315', 'Mr. Noodlse Magic Masala 16 pcs 992g', 'P-26', 335.00, 'Pcs', NULL), (39, 'Pran', '89012345000039', '840205715183', 'Mr. Noodlse koriean 8 pcs 496g', 'P-27', 210.00, 'Pcs', NULL), (40, 'Pran', '89012345000040', '846656003411', 'Mr. Noodlse Magic Masala 8 pcs 496g', 'P-28', 175.00, 'Pcs', NULL), (41, 'Pran', '89012345000041', '8941154030418', 'Potata 12g', 'P-29', 5.00, 'Pcs', NULL), (42, 'Pran', '89012345000042', '840205725380', 'Mafin cak 16g', 'P-30', 10.00, 'Pcs', NULL), (43, 'Pran', '89012345000043', '840205744824', 'Mr. Noodles 30g', 'P-31', 10.00, 'Pcs', NULL), (44, 'Pran', '89012345000044', '840205744312', 'Mr.Ramen noodles carbonara 85g', 'P-32', 50.00, 'Pcs', NULL), (45, 'Pran', '89012345000045', '831730006907', 'Spcal Tost 250g', 'P-33', 60.00, 'Pcs', NULL), (46, 'Pran', '89012345000046', '840205796878', 'Sweet tost 180g', 'P-34', 50.00, 'Pcs', NULL), (47, 'Pran', '89012345000047', '840205754397', 'Potata spicy 192g', 'P-35', 100.00, 'Pcs', NULL), (48, 'Pran', '89012345000048', '840205791743', 'Kasmery tee 15g', 'P-36', 10.00, 'Pcs', NULL), (49, 'Pran', '89012345000049', '841165118991', 'Tee milk instant 15g', 'P-37', 10.00, 'Pcs', NULL), (50, 'Pran', '89012345000050', '840205735785', 'Kofi hous 3in 1 14g', 'P-38', 10.00, 'Pcs', NULL), (51, 'Pran', '89012345000051', '831730009472', 'Hot tometo sos 8g', 'P-39', 3.00, 'Pcs', NULL), (52, 'Pran', '89012345000052', '846656008003', 'Poteto stic chips 12g', 'P-40', 10.00, 'Pcs', NULL), (53, 'Pran', '89012345000053', '840205710959', 'Treat Milk Chocolate Bar 55g', 'P-41', 50.00, 'Pcs', NULL), (54, 'Pran', '89012345000054', '841165154920', 'MIsty Boroy', 'P-42', 5.00, 'Pcs', NULL), (55, 'Pran', '89012345000055', '840205744329', 'Mr. Noodles Ramen Cheese 58g', 'P-43', 50.00, 'Pcs', NULL), (56, 'Pran', '89012345000056', '840205744091', 'Mr. Noodle Ramen Hot Chicken 2X 85g', 'P-44', 50.00, 'Pcs', NULL), (57, 'Pran', '89012345000057', '841165145232', 'Sixers Choocolate bar 14g', 'P-45', 10.00, 'Pcs', NULL), (58, 'Pran', '89012345000058', '840205716708', 'Milk Bar Choocolate 11g', 'P-46', 10.00, 'Pcs', NULL), (59, 'Pran', '89012345000059', '841165135974', 'Belgio Milk Bar 25g', 'P-47', 30.00, 'Pcs', NULL), (60, 'Pran', '89012345000060', '840205794324', 'Belgio Strawberry Milk 25g', 'P-48', 30.00, 'Pcs', NULL), (61, 'Pran', '89012345000061', '840205794300', 'Belgio Coffee Choocolate', 'P-49', 30.00, 'Pcs', NULL), (62, 'Pran', '89012345000062', '840205788033', 'Premio Choco Card 25g', 'P-50', 20.00, 'Pcs', NULL), (63, 'Pran', '89012345000063', '840205731428', 'Mama Choocolate Wafer', 'P-51', 10.00, 'Pcs', NULL), (64, 'Pran', '89012345000064', '841165159109', 'Coco Choco', 'P-52', 10.00, 'Pcs', NULL), (65, 'Pran', '89012345000065', '840547600512', 'Premio Choco Bueno 20g', 'P-53', 20.00, 'Pcs', NULL), (66, 'Pran', '89012345000066', '846656012178', 'Buddy Center Filled Wafer 12g', 'P-54', 5.00, 'Pcs', NULL), (67, 'Pran', '89012345000067', '840205714216', 'Mama Rollo Wafer 8g', 'P-55', 5.00, 'Pcs', NULL), (68, 'Pran', '89012345000068', '840205711017', 'Treat Almond Choocolate 4g', 'P-56', 5.00, 'Pcs', NULL), (69, 'Pran', '89012345000069', '840205717088', 'Hurry My Loave Chocolate Wafer 20g', 'P-57', 20.00, 'Pcs', NULL), (70, 'Pran', '89012345000070', '840205738236', 'Joyful Orange 100g', 'P58', 50.00, 'Pcs', NULL), (71, 'Pran', '89012345000071', '840205738229', 'Joyful Strawberry 10g', 'P59', 50.00, 'Pcs', NULL), (72, 'Pran', '89012345000072', '840205738212', 'Joyful Chocolate 100g', 'P-60', 50.00, 'Pcs', NULL), (73, 'Pran', '89012345000073', '840205740116', 'Bubble Gum Orange 14g', 'P-61', 20.00, 'Pcs', NULL), (74, 'Pran', '89012345000074', '840205729432', 'Bubble Gum Banana 14g', 'P-62', 20.00, 'Pcs', NULL), (75, 'Pran', '89012345000075', '840205740123', 'Bubble Gum Strawberry 14g', 'P-63', 20.00, 'Pcs', NULL), (76, 'Pran', '89012345000076', '841165160037', 'Hurray Gems', 'P-64', 10.00, 'Pcs', NULL), (77, 'Pran', '89012345000077', '840205710201', 'Crimaon Choxolate Coon', 'P-65', 20.00, 'Pcs', NULL), (78, 'Pran', '89012345000078', '841165146079', 'Wonder Kids 8g', 'P-66', 15.00, 'Pcs', NULL), (79, 'Pran', '89012345000079', '841165107940', 'Fried Peas 10g', 'P-67', 5.00, 'Pcs', NULL), (80, 'Pran', '89012345000080', '831730003623', 'Pran Dal 10g', 'P-68', 50.00, 'Pcs', NULL), (81, 'Pran', '89012345000081', '840205729968', 'Mma Strawberry Wafer 13g', 'P-69', 5.00, 'Pcs', NULL), (82, 'Pran', '89012345000082', '831730008260', 'Chco beam Gems 7g', 'P-70', 5.00, 'Pcs', NULL), (83, 'Pran', '89012345000083', '840205712175', 'Mango Bar 14g', 'P-71', 10.00, 'Pcs', NULL), (84, 'unileber', '89012345000084', '8906189772719', 'Wheel 2in 1 Clean & Fresh 1000g', 'U-1', 145.00, 'Pcs', NULL), (85, 'unileber', '89012345000085', '8906189772702', 'Wheel 2in 1 Clean & Fresh 500g', 'U-2', 80.00, 'Pcs', NULL), (86, 'unileber', '89012345000086', '8941100657478', 'Wheel 2in 1 Clean & Fresh 250g', 'U-3', 30.00, 'Pcs', NULL), (87, 'unileber', '89012345000087', '8941102314447', 'Wheel 125g', 'U-4', 35.00, 'Pcs', NULL), (88, 'unileber', '89012345000088', '8906189772795', 'Rin Advanced 1000g', 'U-5', 195.00, 'Pcs', NULL), (89, 'unileber', '89012345000089', '8906189772788', 'Rin Advanced', 'U-6', 100.00, 'Pcs', NULL), (90, 'unileber', '89012345000090', '8906189772788', 'Rin Advanced 500g', 'U-7', 100.00, 'Pcs', NULL), (91, 'unileber', '89012345000091', '8906189772764', 'Rin Advanced 200g', 'U-8', 40.00, 'Pcs', NULL), (92, 'unileber', '89012345000092', '8906189773860', 'Surf excel 450', 'U-9', 120.00, 'Pcs', NULL), (93, 'unileber', '89012345000093', '8906189774324', 'Lux Bouncy & Bright 125g', 'U-10', 100.00, 'Pcs', NULL), (94, 'unileber', '89012345000094', '8906189774331', 'Lux Smooth & Radiant 125g', 'U-11', 100.00, 'Pcs', NULL), (95, 'unileber', '89012345000095', '8941102467303', 'Lux Bright Glow 150g', 'U-12', 90.00, 'Pcs', NULL), (96, 'unileber', '89012345000096', '8941102467266', 'Lux Flaw-less Glow 150g', 'U-13', 90.00, 'Pcs', NULL), (97, 'unileber', '89012345000097', '8941102467280', 'Lux Bright Glow 100g', 'U-14', 60.00, 'Pcs', NULL), (98, 'Nestle', '89012345000098', '0', 'Maggi healthe soups thai 35g', 'N-12', 60.00, 'Pcs', NULL), (99, 'Nestle', '89012345000099', '0', 'Maggi healthe soups corn with chicken flavor 20g', 'N-13', 60.00, 'Pcs', NULL), (100, 'unileber', '89012345000100', '8906189771323', 'Lux Flaw-less Glow 90g', 'U-15', 90.00, 'Pcs', NULL), (101, 'unileber', '89012345000101', '8906189775031', 'Lux Bright Glow 90g', 'U-16', 60.00, 'Pcs', NULL), (102, 'unileber', '89012345000102', '8941102467280', 'Lux bright Glow 100g', 'U-17', 60.00, 'Pcs', NULL), (103, 'unileber', '89012345000103', '8906189771736', 'Lifebuoy Lemon fresh 90g', 'U-18', 60.00, 'Pcs', NULL), (104, 'unileber', '89012345000104', '8906189771729', 'Lifebuoy Skin protect+ 90g', 'U-19', 60.00, 'Pcs', NULL), (105, 'unileber', '89012345000105', '8906189771712', 'Lifebuoy Total 10 90g', 'U-20', 60.00, 'Pcs', NULL), (106, 'unileber', '89012345000106', '8906189774461', 'Lifebuoy Total 10 90g', 'U-21', 55.00, 'Pcs', NULL), (107, 'unileber', '89012345000107', '8906189774485', 'Lifebuoy Lemon fresh 90g', 'U-22', 55.00, 'Pcs', NULL), (108, 'unileber', '89012345000108', '8906189771422', 'Lifebuoy Lemon fresh 90g', 'U-23', 55.00, 'Pcs', NULL), (109, 'unileber India', '89012345000109', '8901030824968', 'Dove Serum bar 125g', 'U-24', 220.00, 'Pcs', NULL), (110, 'unileber Indian', '89012345000110', '8901030712999', 'Dove Serum bar 50g', 'U-25', 110.00, 'Pcs', NULL), (111, 'unileber', '89012345000111', '8941102461431', 'Vim 300g', 'U-26', 40.00, 'Pcs', NULL), (112, 'unileber', '89012345000112', '8941102460304', 'Vim 300g', 'U-27', 40.00, 'Pcs', NULL), (113, 'unileber', '89012345000113', '8941102460328', 'Vim 75g', 'U-28', 10.00, 'Pcs', NULL), (114, 'unileber', '89012345000114', '8906189772429', 'Vim 200g', 'U-29', 50.00, 'Pcs', NULL), (115, 'unileber', '89012345000115', '8906189773211', 'Vim 475g', 'U-30', 130.00, 'Pcs', NULL), (116, 'unileber', '89012345000116', '8941102467907', 'Lifebuoy mild care hdndwash 200g', 'U-31', 115.00, 'Pcs', NULL), (117, 'unileber', '89012345000117', '8941102467884', 'Lifebuoy mild care handwash 170g', 'U-32', 85.00, 'Pcs', NULL), (118, 'unileber', '89012345000118', '8906189773532', 'Lifebuoy lemon fresh handwash 170g', 'U-33', 90.00, 'Pcs', NULL), (119, 'unileber', '89012345000119', '8941102467914', 'Lifebuoy lemon fresh handwash 170g', 'U-34', 115.00, 'Pcs', NULL), (120, 'unileber', '89012345000120', '8941100619612', 'Pond,s moisturising body lotiom 200g', 'U-35', 260.00, 'Pcs', NULL), (121, 'unileber', '89012345000121', '8941100656020', 'Pond,s moisturising body lotiom 100g', 'U-36', 160.00, 'Pcs', NULL), (122, 'unileber', '89012345000122', '8941102467891', 'Lifebuoy Total 10 Handwash 200g', 'U-37', 115.00, 'Pcs', NULL), (123, 'unileber', '89012345000123', '8906189772054', 'Pond,s moisturising body lotiom 200g', 'U-39', 50.00, 'Pcs', NULL), (124, 'unileber', '89012345000124', '8906189772030', 'Closeup menthol fresh 85g', 'U-40', 105.00, 'Pcs', NULL), (125, 'unileber', '89012345000125', '8906189772023', 'Closeup menthol fresh 145g', 'U-41', 155.00, 'Pcs', NULL), (126, 'unileber', '89012345000126', '8906189771316', 'Pepsodent Germicheck + 40g', 'U-42', 50.00, 'Pcs', NULL), (127, 'unileber', '89012345000127', '8941102464135', 'Pepsodent Germicheck + 85g', 'U-43', 95.00, 'Pcs', NULL), (128, 'unileber', '89012345000128', '8941102460724', 'Pepsodent Germicheck + 190g', 'U-44', 170.00, 'Pcs', NULL), (129, 'unileber', '89012345000129', '8906189773914', 'Pepsodent Germicheck + 190+20g', 'U-45', 170.00, 'Pcs', NULL), (130, 'unileber', '89012345000130', '8941102468294', 'Pepsodent Germicheck + 95g', 'U-46', 60.00, 'Pcs', NULL), (131, 'unileber Indian', '89012345000131', '8909106047105', 'Pond,s bright beauty creme 35g', 'U-47', 280.00, 'Pcs', NULL), (132, 'unileber Indian', '89012345000132', '8909106047129', 'Pond,s bright beauty creme 50g', 'U-48', 475.00, 'Pcs', NULL), (133, 'unileber', '89012345000133', '8941102466252', 'Pond,s bright beauty creme 35g', 'U-49', 180.00, 'Pcs', NULL), (134, 'unileber', '89012345000134', '8941102463480', 'Pond,s bright beauty creme 23g', 'U-50', 130.00, 'Pcs', NULL), (135, 'unileber', '89012345000135', '8906189773150', 'Glow & Lovely Re- New Bright creme 47g', 'U-51', 165.00, 'Pcs', NULL), (136, 'unileber', '89012345000136', '8906189773167', 'Glow & Lovely Re- New Bright creme 25g', 'U-52', 95.00, 'Pcs', NULL), (137, 'unileber', '89012345000137', '8909106049680', 'Glow & Lovely Re- New Bright creme 50g', 'U-53', 350.00, 'Pcs', NULL), (138, 'unileber Indian', '89012345000138', '8909106049697', 'Glow & Lovely Re- New Bright creme 80g', 'U-54', 450.00, 'Pcs', NULL), (139, 'unileber', '89012345000139', '8906189772177', 'Mini Lux 25g', 'U-55', 15.00, 'Pcs', NULL), (140, 'unileber', '89012345000140', '8906189770555', 'Mini Lifebuoy 27g', 'U-56', 15.00, 'Pcs', NULL), (141, 'unileber', '89012345000141', '0', 'Mini Lifebuoy lemon fresh 27g', 'U-57', 15.00, 'Pcs', NULL), (142, 'unileber', '89012345000142', '8941102462452', 'Glow & Lovely Facewash 100g', 'U-58', 170.00, 'Pcs', NULL), (143, 'unileber Indian', '89012345000143', '8901030989865', 'Pond,s bright beauty facewash 100g', 'U-59', 380.00, 'Pcs', NULL), (144, 'unileber Indian', '89012345000144', '8901030989827', 'Pond,s Bright beauty facewash 50g', 'U-60', 220.00, 'Pcs', NULL), (145, 'unileber', '89012345000145', '8906189771613', 'Dove Shampoo 80g', 'U-61', 120.00, 'Pcs', NULL), (146, 'unileber', '89012345000146', '8941102319268', 'Dove Shampoo 330g', 'U-62', 470.00, 'Pcs', NULL), (147, 'unileber', '89012345000147', '8941102462155', 'Clear Shampoo', 'U-63', 240.00, 'Pcs', NULL), (148, 'unileber', '89012345000148', '8906189772474', 'Sunsilk Black shampoo 170g', 'U-64', 180.00, 'Pcs', NULL), (149, 'unileber', '89012345000149', '8906189770111', 'Sunsilk Golapi shampoo 340g', 'U-65', 350.00, 'Pcs', NULL), (150, 'unileber', '89012345000150', '8906189771958', 'Surf Excel 35g', 'U-66', 10.00, 'Pcs', NULL), (151, 'unileber', '89012345000151', '8906189771972', 'Surf Excel 18g', 'U-67', 5.00, 'Pcs', NULL), (152, 'unileber', '89012345000152', '8941102464913', 'Vaseline intensive care 100g', 'U-68', 180.00, 'Pcs', NULL), (153, 'unileber', '89012345000153', '0', 'Vaseline peroliam jelly 9g', 'U-69', 15.00, 'Pcs', NULL), (154, 'unileber', '89012345000154', '8901030869112', 'Pond,s Sandal Powder 100g', 'U-70', 175.00, 'Pcs', NULL), (155, 'Saad', '89012345000155', '8940110045374', 'Baking Powder 100g', 'S-01', 50.00, 'Pcs', NULL), (156, 'Saad', '89012345000156', '8941158069186', 'Custard Powder 100g', 'S-02', 45.00, 'Pcs', NULL), (157, 'Saad', '89012345000157', '9010002453705', 'Corn Flour 100g', 'S-03', 45.00, 'Pcs', NULL), (158, 'Saad', '89012345000158', '3020050548595', 'Agar Agar 20g', 's-04', 125.00, 'Pcs', NULL), (159, 'Saad', '89012345000159', '8941158069513', 'Tasty Bit Salt 100g', 'S-05', 30.00, 'Pcs', NULL), (160, 'Saad', '89012345000160', '6000100453700', 'Bit Salt 100g', 'S-06', 50.00, 'Pcs', NULL), (161, 'Saad', '89012345000161', '6000050245370', 'Cocoa powder 50g', 'S-07', 100.00, 'Pcs', NULL), (162, 'Saad', '89012345000162', '8941158069070', 'Tasting Salt 18g', 'S-08', 10.00, 'Pcs', NULL), (163, 'Saad', '89012345000163', '8941158069087', 'Tasting Salt 18g', 'S-09', 20.00, 'Pcs', NULL), (164, 'Saad', '89012345000164', '8941158069094', 'Tasting Salt 100g', 'S-10', 50.00, 'Pcs', NULL), (165, 'Saad', '89012345000165', '8941158069797', 'Vinegar 300m', 'S-11', 55.00, 'Pcs', NULL), (166, 'Saad', '89012345000166', '8941158069308', 'Vinegar 550m', 'S-12', 70.00, 'Pcs', NULL), (167, 'Al-Shahi', '89012345000167', '8019885002261', 'Ist', 'A-01', 65.00, 'Pcs', NULL), (168, 'Squar', '89012345000168', '8941100500132', 'Magic tuth powder 100g', 'Sq-01', 58.00, 'Pcs', NULL), (169, 'Squar', '89012345000169', '8941100500033', 'Magic tuth powder 50g', 'Sq-02', 35.00, 'Pcs', NULL), (170, 'Squar', '89012345000170', '8941100501221', 'Chamak 50g', 'Sq-03', 25.00, 'Pcs', NULL), (171, 'Squar', '89012345000171', '8941100501238', 'Chamak 100g', 'Sq-04', 40.00, 'Pcs', NULL), (172, 'Squar', '89012345000172', '8941100514320', 'Hot tomata sos 350g', 'Sq-05', 125.00, 'Pcs', NULL), (173, 'Squar', '89012345000173', '8941100514313', 'Tomato Ketchup 350g', 'Sq-06', 125.00, 'Pcs', NULL), (174, 'Squar', '89012345000174', '8941100512661', 'Sorishar Oil 1L', 'Sq-07', 380.00, 'Pcs', NULL), (175, 'Squar', '89012345000175', '8941100512654', 'Sorishar Oil 500m', 'Sq-08', 200.00, 'Pcs', NULL), (176, 'Squar', '89012345000176', '8941100512647', 'Sorishar Oil 250ml', 'Sq-09', 105.00, 'Pcs', NULL), (177, 'Squar', '89012345000177', '8941100512630', 'Sorishar Oil 80ml', 'Sq-10', 38.00, 'Pcs', NULL), (178, 'Squar', '89012345000178', '8941100500316', 'Revive Lotion 200ml', 'Sq-11', 260.00, 'Pcs', NULL), (179, 'Squar', '89012345000179', '8941100500309', 'Revive Lotion 100ml', 'Sq-12', 160.00, 'Pcs', NULL), (180, 'Squar', '89012345000180', '8941100503591', 'Glisarin 60g', 'Sq-13', 65.00, 'Pcs', NULL), (181, 'Squar', '89012345000181', '8941100500873', 'Meril Petroliam jelly 50ml', 'Sq-14', 65.00, 'Pcs', NULL), (182, 'Squar', '89012345000182', '8941100502730', 'Chaka white Ball soap 125g', 'Sq-15', 26.00, 'Pcs', NULL), (183, 'Squar', '89012345000183', '8941100500231', 'Meril Baby Lotion 100ml', 'Sq-16', 220.00, 'Pcs', NULL), (184, 'Squar', '89012345000184', '8941100500507', 'Jui Natural pure coconut oil 200ml', 'Sq-17', 200.00, 'Pcs', NULL), (185, 'Squar', '89012345000185', '8941100500514', 'Jui Natural pure coconut oil 350ml', 'Sq-18', 340.00, 'Pcs', NULL), (186, 'Squar', '89012345000186', '8941100511763', 'Radhuni kasundi 285ml', 'Sq-19', 65.00, 'Pcs', NULL), (187, 'Squar', '89012345000187', '8941100501290', 'Meril milk soap 100g', 'Sq-20', 65.00, 'Pcs', NULL), (188, 'Squar', '89012345000188', '8941100500187', 'Meril milk & Kiwi soap 100g', 'Sq-21', 60.00, 'Pcs', NULL), (189, 'Squar', '89012345000189', '8941100501726', 'Meril Pure milk soap 100g', 'Sq-22', 60.00, 'Pcs', NULL), (190, 'Squar', '89012345000190', '8941100512104', 'Chashi sugandhi chinigura chal 1kg', 'Sq-23', 230.00, 'Pcs', NULL), (191, 'Squar', '89012345000191', '8941100513828', 'Ruchi muri 400g', 'Sq-24', 65.00, 'Pcs', NULL), (192, 'Squar', '89012345000192', '8941100513811', 'Ruchi muri 200g', 'Sq-25', 35.00, 'Pcs', NULL), (193, 'Squar', '89012345000193', '8941100513163', 'Ruchi Jal Chanacur 150g', 'Sq-26', 50.00, 'Pcs', NULL), (194, 'Squar', '89012345000194', '8941100513224', 'Ruchi Jal Chanacur 300g', 'Sq-27', 100.00, 'Pcs', NULL), (195, 'Squar', '89012345000195', '8941100513194', 'Ruchi Bar-B-Q Chanacur 150g', 'Sq-28', 50.00, 'Pcs', NULL), (196, 'Squar', '89012345000196', '8941100513217', 'Ruchi Bar-B-Q Chanacur 300g', 'Sq-29', 100.00, 'Pcs', NULL), (197, 'Squar', '89012345000197', '8941102467266', 'Radhuni Ready mix biryani masala 40g', 'Sq-30', 60.00, 'Pcs', NULL), (198, 'Squar', '89012345000198', '8941100511206', 'Radhuni Ready mix Rost masala 35g', 'Sq-31', 65.00, 'Pcs', NULL), (199, 'Squar', '89012345000199', '8941100511398', 'Radhuni Readymix Kachchi biryani masala 40g', 'Sq-32', 70.00, 'Pcs', NULL), (200, 'Squar', '89012345000200', '8941100511916', 'Radhuni Readymix Bar-B-Q masala 50g', 'Sq-33', 80.00, 'Pcs', NULL), (201, 'Squar', '89012345000201', '8941100511053', 'Radhuni Readymix Cotpoti masala 50g', 'Sq-34', 50.00, 'Pcs', NULL), (202, 'Squar', '89012345000202', '8941100511428', 'Radhuni Readymix Kala vuna masala 80g', 'Sq-35', 100.00, 'Pcs', NULL), (203, 'Squar', '89012345000203', '8941100511329', 'Radhuni Readymix Gorur Mangser masala 100g', 'Sq-36', 90.00, 'Pcs', NULL), (204, 'Squar', '89012345000204', '8941100511282', 'Radhuni Readymix Murgir Mangser masala 100g', 'Sq-37', 95.00, 'Pcs', NULL), (205, 'Squar', '89012345000205', '8941100511725', 'Radhuni Hamil mix masala 200g', 'Sq-38', 80.00, 'Pcs', NULL), (206, 'Squar', '89012345000206', '8941100511404', 'Radhuni Readymix Tehari masala 40g', 'Sq-39', 55.00, 'Pcs', NULL), (207, 'Squar', '89012345000207', '8941100510179', 'Radhuni Doniyar gora 50g', 'Sq-40', 32.00, 'Pcs', NULL), (208, 'Squar', '89012345000208', '8941100510186', 'Radhuni Doniyar gora 100g', 'Sq-41', 60.00, 'Pcs', NULL), (209, 'Squar', '89012345000209', '8941100510254', 'Radhuni Jirar gora 50g', 'Sq-42', 85.00, 'Pcs', NULL), (210, 'Squar', '89012345000210', '8941100510247', 'Radhuni Jirar gora 15g', 'Sq-43', 28.00, 'Pcs', NULL), (211, 'Squar', '89012345000211', '8941100511022', 'Radhuni Gorom masalar gora 40g', 'Sq-44', 95.00, 'Pcs', NULL), (212, 'Squar', '89012345000212', '8941100511015', 'Radhuni Gorom masalar gora 15g', 'Sq-46', 40.00, 'Pcs', NULL), (213, 'Squar', '89012345000213', '8941100510162', 'Radhuni Doniyar gora 15g', 'Sq-45', 10.00, 'Pcs', NULL), (214, 'Squar', '89012345000214', '8941100510995', 'Radhuni pacforun 50g', 'Sq-47', 30.00, 'Pcs', NULL), (215, 'Squar', '89012345000215', '8941100510100', 'Radhuni Doniyar gora 100g', 'Sq-48', 75.00, 'Pcs', NULL), (216, 'Squar', '89012345000216', '8941100510094', 'Radhuni Moricer gora 50g', 'Sq-49', 38.00, 'Pcs', NULL), (217, 'Squar', '89012345000217', '8941100510025', 'Radhuni Holuder gora 100g', 'Sq-50', 75.00, 'Pcs', NULL), (218, 'Squar', '89012345000218', '8941100510018', 'Radhuni Holuder gora 50g', 'Sq-51', 40.00, 'Pcs', NULL), (219, 'Squar', '89012345000219', '8941100511138', 'Radhuni Mangser Masla 20g', 'Sq-52', 20.00, 'Pcs', NULL), (220, 'Squar', '89012345000220', '8941100511305', 'Radhuni Readymix Gorur mangser masala 25g', 'Sq-53', 25.00, 'Pcs', NULL), (221, 'Squar', '89012345000221', '8941100511275', 'Radhuni Readymix Murgir mangser masala 25g', 'Sq-54', 20.00, 'Pcs', NULL), (222, 'Squar', '89012345000222', '8941100511169', 'Radhuni Readymix Maser masala 20g', 'Sq-55', 18.00, 'Pcs', NULL), (223, 'Squar', '89012345000223', '8941100512845', 'Radhuni Khicuri masla 20g', 'Sq-56', 15.00, 'Pcs', NULL), (224, 'Squar', '89012345000224', '8941100513552', 'Ruchi Jal Chanacur 22g', 'Sq-57', 10.00, 'Pcs', NULL), (225, 'Squar', '89012345000225', '8941100513569', 'Ruchi Bar-B-Q Chanacur 22g', 'Sq-58', 10.00, 'Pcs', NULL), (226, 'Squar', '89012345000226', '8941100514221', 'Ruchi Peanut Bar 15g', 'Sq-59', 10.00, 'Pcs', NULL), (227, 'Vini Cosmetics pvt.ltd', '89012345000227', '8908001158381', 'White Tone Face Cream 25g', 'V-01', 185.00, 'Pcs', NULL), (228, 'Vini Cosmetics pvt.ltd', '89012345000228', '8908001158077', 'White one Face Powder 30g', 'V-02', 200.00, 'Pcs', NULL), (229, 'Garnier', '89012345000229', '8901526005208', 'Garnier bright complete vitamin-c face wash 100g', 'G-01', 450.00, 'Pcs', NULL), (230, 'Garnier', '89012345000230', '8901526658657', 'Garnier bright complete vitamin-c face wash 100g', 'G-02', 235.00, 'Pcs', NULL), (231, 'Kohinoor', '89012345000231', '8513690304454', 'Tibet Prickly Heat Skin Powder 100g', 'k-01', 65.00, 'Pcs', NULL), (232, 'Kohinoor', '89012345000232', '8513690604509', 'Ice cool pricly heat skin powder 100g', 'k-02', 65.00, 'Pcs', NULL), (233, 'Kohinoor', '89012345000233', '8513690404406', 'Tibet Luxury talcum powder 100g', 'k-03', 60.00, 'Pcs', NULL), (234, 'Kohinoor', '89012345000234', '8513690401252', 'Tibet Luxury talcum powder 50g', 'k-04', 35.00, 'Pcs', NULL), (235, 'Kohinoor', '89012345000235', '8513690101503', 'Tibet snow 50g', 'k-05', 70.00, 'Pcs', NULL), (236, 'Kohinoor', '89012345000236', '8513690193140', 'Tibet 570 laundry soap 125g', 'k-06', 28.00, 'Pcs', NULL), (237, 'Kohinoor', '89012345000237', '8513690310172', 'Tabet ball soap', 'k-07', 26.00, 'Pcs', NULL), (238, 'Kohinoor', '89012345000238', '8513691414008', 'Fast Wash synthetic detergent powder 200g', 'k-08', 40.00, 'Pcs', NULL), (239, 'Kohinoor', '89012345000239', '8513691412905', 'Fast Wash synthetic detergent powder 500g', 'k-09', 95.00, 'Pcs', NULL), (240, 'Kohinoor', '89012345000240', '8513695121209', 'Clean Master liquid toilet cleaner 500ml', 'k-10', 120.00, 'Pcs', NULL), (241, 'Uniliver', '89012345000241', '4800888158932', 'Rexonapowder dry + brightening 45ml', 'U-71', 290.00, 'Pcs', NULL), (242, 'Uniliver', '89012345000242', '4800888143402', 'Rexona Quantum dry anti-stain 45ml', 'U-72', 290.00, 'Pcs', NULL), (243, 'Uniliver', '89012345000243', '8906105101524', 'Junior Horlicks stage 2 500g', 'U-73', 550.00, 'Pcs', NULL), (244, 'Uniliver', '89012345000244', '8906105101500', 'Horlicks 500g', 'U-74', 500.00, 'Pcs', NULL), (245, 'Uniliver', '89012345000245', '8906105101326', 'Junior Horlicks stage 1 500g', 'U-75', 500.00, 'Pcs', NULL), (246, 'Unilivet', '89012345000246', '8906105101494', 'Horlicks 250g', 'U-76', 280.00, 'Pcs', NULL), (247, 'Uniliver', '89012345000247', '8906105101470', 'Horlicks 18g', 'U-77', 20.00, 'Pcs', NULL), (248, 'Uniliver', '89012345000248', '8906105101418', 'Glumax D 18g', 'U-78', 10.00, 'Pcs', NULL), (249, 'Reckitt', '89012345000249', '8901396601784', 'Veet pure hair removal cream 25g', 'r-01', 110.00, 'Pcs', NULL), (250, 'Himalaya', '89012345000250', '8908008142000', 'Himalaya Neem face wash 100ml', 'h-01', 230.00, 'Pcs', NULL), (251, 'Himalaya', '89012345000251', '8908008142017', 'Himalaya Neem face wash 50ml', 'h-02', 130.00, 'Pcs', NULL), (252, 'Himalaya', '89012345000252', '8901138711962', 'Himalaya Neem face wash 100ml', 'h-03', 50.00, 'Pcs', NULL), (253, 'Havoc', '89012345000253', '3700082500364', 'Havoc Gole 200ml', 'ha-01', 495.00, 'Pcs', NULL), (254, 'Vini Cosmetics pvt.ltd', '89012345000254', '8908001158244', 'Gogg bodu spray 120ml', 'v-03', 345.00, 'Pcs', NULL), (255, 'Rimark', '89012345000255', '8941153902099', 'Lily milk bath beauty soap 100g', 'Ri-01', 55.00, 'Pcs', NULL), (256, 'Rimark', '89012345000256', '8941153902037', 'Lily beli pearls beauty soap 100g', 'Ri-02', 55.00, 'Pcs', NULL), (257, 'ACI', '89012345000257', '8941196243104', 'Savlon mild soap 100g', 'aci-01', 70.00, 'Pcs', NULL), (258, 'ACI', '89012345000258', '8941196243135', 'Savlon Fresh soap 100g', 'aci-02', 70.00, 'Pcs', NULL), (259, 'ACI', '89012345000259', '813903000035', 'Aci aerosol insect spray 475ml', 'aci-3', 415.00, 'Pcs', NULL), (260, 'ACI', '89012345000260', '813903000127', 'Aci aerosol insect spray 250ml', 'aci-04', 250.00, 'Pcs', NULL), (261, 'ACI', '89012345000261', '813903000028', 'Aci aerosol insect spray 350ml', 'aci-05', 340.00, 'Pcs', NULL), (262, 'ACI', '89012345000262', '8139003000846', 'Angelic fresh citrus burst 300ml', 'aci-06', 340.00, 'Pcs', NULL), (263, 'ACI', '89012345000263', '8139003000853', 'Angelic fresh orchid breege 300ml', 'aci-07', 340.00, 'Pcs', NULL), (264, 'ACI', '89012345000264', '8139003000860', 'Angelic fresh csparfrfing orange 300ml', 'aci-08', 340.00, 'Pcs', NULL), (265, 'Reckitt', '89012345000265', '8941100283516', 'Dettol Aloe vera 120g', 'r-3', 95.00, 'Pcs', NULL), (266, 'Reckitt', '89012345000266', '8941102833962', 'Dettol original 70g', 'r-04', 65.00, 'Pcs', NULL), (267, 'Reckitt', '89012345000267', '8941102833177', 'Dettol neem 75', 'r-05', 65.00, 'Pcs', NULL), (268, 'Reckitt', '89012345000268', '8941100775356', 'Dettole Skincare 70g', 'r-06', 65.00, 'Pcs', NULL), (269, 'Reckitt', '89012345000269', '8941100775363', 'Dettole Skincare 70g', 'r-07', 95.00, 'Pcs', NULL), (270, 'Himalaya', '89012345000270', '8908008142628', 'HimalayaPrickly heat baby powder 100g', 'h-04', 180.00, 'Pcs', NULL), (271, 'Lucy oliva', '89012345000271', '8420701109321', 'Olive oil 150g', 'l-01', 515.00, 'Pcs', NULL), (272, 'Lucy oliva', '89012345000272', '420701471350', 'Olive oil 100ml', 'l-02', 340.00, 'Pcs', NULL), (273, 'Olive oil', '89012345000273', '0', 'Olive oil 100ml (bangla)', 'o-01', 220.00, 'Pcs', NULL), (274, 'Johnson\'s', '89012345000274', '8901012116647', 'Johnson\'s wiyh milk,turmeric & shea butter baby soap 75g', 'j-01', 175.00, 'Pcs', NULL), (275, 'Johnson\'s', '89012345000275', '901012116630', 'Johnson\'s wiyh milk,turmeric & shea butter baby soap 75g', 'j-02', 115.00, 'Pcs', NULL), (276, 'Johnson\'s', '89012345000276', '901012116845', 'Johnson\'s baby lotion with aloe & vitamin B5 100ml', 'j-03', 265.00, 'Pcs', NULL), (277, 'Johnson\'s', '89012345000277', '9556006012093', 'Johnson\'s top-to-toe hair & body bath 200ml', 'j-04', 465.00, 'Pcs', NULL), (278, 'Johnson\'s', '89012345000278', '9556006012086', 'Johnson\'s top-to-toe hair & body bath 200ml', 'j-05', 295.00, 'Pcs', NULL), (279, 'Johnson\'s', '89012345000279', '9556006014547', 'Johnson\'s baby shampoo 100ml', 'j-06', 275.00, 'Pcs', NULL), (280, 'Johnson\'s', '89012345000280', '8991111101255', 'Johnson\'s baby shampoo 100ml', 'j-07', 165.00, 'Pcs', NULL), (281, 'Johnson\'s', '89012345000281', '8901012116715', 'Johnson\'s baby oil 100ml', 'j-08', 335.00, 'Pcs', NULL), (282, 'Johnson\'s', '89012345000282', '8901012100561', 'Johnson\'s baby powder 100g', 'j-09', 315.00, 'Pcs', NULL), (283, 'Johnson\'s', '89012345000283', '8901012100554', 'Johnson\'s baby powder 50g', 'j-10', 175.00, 'Pcs', NULL), (284, 'Johnson\'s', '89012345000284', '8901012117002', 'Johnson\'s milk + rice cream 50g', 'j-11', 220.00, 'Pcs', NULL), (285, 'Johnson\'s', '89012345000285', '8901012116999', 'Johnson\'s milk + rice cream 30g', 'j-12', 165.00, 'Pcs', NULL), (286, 'Marico', '89012345000286', '0', 'Parachute 300ml', 'm-01', 350.00, 'Pcs', NULL), (287, 'Marico', '89012345000287', '0', 'Parachute 175ml', 'm-02', 220.00, 'Pcs', NULL), (288, 'Marico', '89012345000288', '0', 'Parachute 95ml', 'm-03', 120.00, 'Pcs', NULL), (289, 'Marico', '89012345000289', '0', 'Parachute 33ml', 'm-04', 45.00, 'Pcs', NULL), (290, 'Marico', '89012345000290', '8941174010148', 'Parachute Extra care 300ml', 'm-05', 380.00, 'Pcs', NULL), (291, 'Marico', '89012345000291', '8941174010971', 'Parachute Belyfull 300ml', 'm-06', 310.00, 'Pcs', NULL), (292, 'Marico', '89012345000292', '8941174010964', 'Parachute Belyfull 200ml', 'm-07', 220.00, 'Pcs', NULL), (293, 'Marico', '89012345000293', '8941174010957', 'Parachute Belyfull 100ml', 'm-08', 130.00, 'Pcs', NULL), (294, 'Marico', '89012345000294', '0', 'Parachute Belyfull 35ml', 'm-09', 30.00, 'Pcs', NULL), (295, 'Kohinoor', '89012345000295', '8513697106907', 'Tibet Glycerin 125g', 'k-11', 115.00, 'Pcs', NULL), (296, 'Kohinoor', '89012345000296', '8513697119501', 'Tibet Glycerin 60g', 'k-12', 65.00, 'Pcs', NULL), (297, 'Kohinoor', '89012345000297', '8513690351809', 'Pumpkin hair oil 200ml', 'k-13', 240.00, 'Pcs', NULL), (298, 'Kohinoor', '89012345000298', '8513690301002', 'Pumpkin hair oil 100ml', 'k-14', 125.00, 'Pcs', NULL), (299, 'Kohinoor', '89012345000299', '8513690304607', 'Pumpkin hair oil 50ml', 'k-15', 75.00, 'Pcs', NULL), (300, 'Hemas Manufacturing', '89012345000300', '4791111106861', 'Kumarika hear oil 300ml', 'hm-01', 320.00, 'Pcs', NULL), (301, 'Hemas Manufacturing', '89012345000301', '4791111106892', 'Kumarika hear oil 400ml', 'hm-02', 420.00, 'Pcs', NULL), (302, 'Hemas Manufacturing', '89012345000302', '8941160237269', 'Kumarika hear oil 200ml', 'hm-03', 250.00, 'Pcs', NULL), (303, 'Hemas Manufacturing', '89012345000303', '8941160237511', 'Kumarika hear oil 100ml', 'hm-04', 130.00, 'Pcs', NULL), (304, 'Hemas Manufacturing', '89012345000304', '8941160237238', 'Kumarika hear oil 50ml', 'hm-05', 65.00, 'Pcs', NULL), (305, 'Hemas Manufacturing', '89012345000305', '8941160237153', 'Eva by kumarika 200ml', 'hm-06', 220.00, 'Pcs', NULL), (306, 'Emami', '89012345000306', '8901248104036', 'Navratna oil Ayurvedic cool 100ml', 'e-01', 150.00, 'Pcs', NULL), (307, 'Emami', '89012345000307', '8901248104029', 'Navratna oil Ayurvedic cool 100ml', 'e-02', 90.00, 'Pcs', NULL), (308, 'Emami indian', '89012345000308', '8901248104159', 'Navratna oil Ayurvedic cool 100ml', 'e-03', 220.00, 'Pcs', NULL), (309, 'Mousumi industries l.', '89012345000309', '0', 'Cute perfumed coconut hair oil 330ml', 'mi-01', 275.00, 'Pcs', NULL), (310, 'Mousumi industries l.', '89012345000310', '0', 'Cute cold cream 50', 'mi-02', 70.00, 'Pcs', NULL), (311, 'Mousumi industries l.', '89012345000311', '0', 'Cute cold cream 100g', 'mi-03', 120.00, 'Pcs', NULL), (312, 'Dabur', '89012345000312', '8901207019005', 'Dabur Amla hair oil 180ml', 'd-01', 250.00, 'Pcs', NULL), (313, 'Danish', '89012345000313', '8941152000017', 'Condensed filled milk 400g', 'd2-01', 105.00, 'Pcs', NULL), (314, 'Danish', '89012345000314', '8941152011709', 'Simla tee bag 100g', 'd2-02', 95.00, 'Pcs', NULL), (315, 'Sajeeb group', '89012345000315', '8941170014959', 'Kolson Macaroni Assorted Pack 500g', 'sg-01', 120.00, 'Pcs', NULL), (316, 'Sajeeb group', '89012345000316', '8941170014942', 'Kolson Macaroni Assorted Pack 400g', 'sg-02', 85.00, 'Pcs', NULL), (317, 'Sajeeb group', '89012345000317', '8941170014935', 'Kolson Macaroni Assorted Pack 200g', 'sg-03', 45.00, 'Pcs', NULL), (318, 'Sajeeb group', '89012345000318', '571866149801', 'Kolson Special Lascha Semai 180g', 'sg-04', 50.00, 'Pcs', NULL), (319, 'Zafran', '89012345000319', '8944000555769', 'Vermicelli Shemai 200g', 'z-01', 45.00, 'Pcs', NULL), (320, 'Zafran', '89012345000320', '8944000555929', 'Dairy milk chocolate 12g', 'z-02', 10.00, 'Pcs', NULL), (321, 'Zafran', '89012345000321', '8944000555912', 'Dairy milk chocolate 6g', 'z-03', 5.00, 'Pcs', NULL), (322, 'Keya Cosmetics ltd.', '89012345000322', '8941124000953', 'keya white plus detergent powder 500g', 'kc-01', 90.00, 'Pcs', NULL), (323, 'Keya Cosmetics ltd.', '89012345000323', '8941124000489', 'Keya super beauty soap pink 100g', 'kc-02', 60.00, 'Pcs', NULL), (324, 'Keya Cosmetics ltd.', '89012345000324', '8941124000090', 'Keya super beauty soap green 100g', 'kc-03', 60.00, 'Pcs', NULL), (325, 'Kohinoor', '89012345000325', '8513692165404', 'Sandalina sandal & moisturiser Soap 125g', 'k-16', 75.00, 'Pcs', NULL), (326, 'Kohinoor', '89012345000326', '8513692165329', 'Sandalina sandal & moisturiser Soap 100g', 'k-17', 60.00, 'Pcs', NULL), (327, 'Kohinoor', '89012345000327', '8513690101251', 'Sandalina sandal & moisturiser Soap 75g', 'k-18', 50.00, 'Pcs', NULL), (328, 'Anfords', '89012345000328', '859875003032', 'Mediplus DS 140g', 'a2-01', 135.00, 'Pcs', NULL), (329, 'Anfords Mediplus DS 140g', '89012345000329', '859875003049', 'Mediplus DS 90g', 'a2-02', 90.00, 'Pcs', NULL), (330, 'Anfords', '89012345000330', '859875003056', 'Mediplus DS 40g', 'a2-03', 48.00, 'Pcs', NULL), (331, 'Squar', '89012345000331', '8941100504864', 'Family pack magic herbal toothpaste 200g', 'sq-60', 175.00, 'Pcs', NULL), (332, 'Squar', '89012345000332', '8941100506332', 'Magic Fresh natural gel toothpaste 90g', 'sq-61', 100.00, 'Pcs', NULL), (333, 'ACI', '89012345000333', '8139003005643', 'Savlon ocean blu 200g', 'aci-09', 110.00, 'Pcs', NULL), (334, 'ACI', '89012345000334', '8139003005636', 'Savlon aloe vera 200g', 'aci-10', 110.00, 'Pcs', NULL), (335, 'ACI', '89012345000335', '8139003005650', 'Savlon lemon burst 200g', 'aci-12', 110.00, 'Pcs', NULL), (336, 'Quasem indusries', '89012345000336', '6933298817019', 'Sunlite heavy duty bettry', 'Q-01', 30.00, 'Pcs', NULL), (337, 'Quasem indusries', '89012345000337', '0', 'Sunlite Liter', 'Q-02', 20.00, 'Pcs', NULL), (338, 'Quasem indusries', '89012345000338', '8941160000313', 'Sun chips 20g', 'Q-03', 20.00, 'Pcs', NULL), (339, 'Quasem indusries', '89012345000339', '8941160000306', 'Sun chips tamato tango 20g', 'Q-04', 20.00, 'Pcs', NULL), (340, 'Fonterra ltd.', '89012345000340', '9415007843542', 'Diploma instant full cream milk powder 200g', 'f-01', 205.00, 'Pcs', NULL), (341, 'Fonterra ltd.', '89012345000341', '9415007828419', 'Diploma instant full cream milk powder 50g', 'f-02', 60.00, 'Pcs', NULL), (342, 'Fonterra ltd.', '89012345000342', '9415007013402', 'Diploma instant full cream milk powder 500g', 'f-03', 480.00, 'Pcs', NULL), (343, 'Fonterra ltd.', '89012345000343', '9415007972662', 'Diploma instant full cream milk powder 100g', 'f-04', 110.00, 'Pcs', NULL), (344, 'Fonterra ltd.', '89012345000344', '8941160032741', 'Poppers corn-coconaut puffs 11g', 'f-05', 10.00, 'Pcs', NULL), (345, 'Fonterra ltd.', '89012345000345', '9415007976486', 'Poppers corn-coconaut puffs 25g', 'f-06', 20.00, 'Pcs', NULL), (346, 'Fonterra ltd.', '89012345000346', '8941160031324', 'Chef\'s choice turmeric poder 50', 'f-07', 40.00, 'Pcs', NULL), (347, 'Mgi', '89012345000347', '8941161147543', 'Fresh Instant noodels 8 packt 496g', 'mgi-01', 175.00, 'Pcs', NULL), (348, 'Mgi', '89012345000348', '8941161180014', 'Fresh korean hot & spicy instant noodels 8 packt 496g', 'mgi-02', 210.00, 'Pcs', NULL), (349, 'Mgi', '89012345000349', '8941161147567', 'Fresh Instant noodels 30g', 'mgi', 10.00, 'Pcs', NULL), (350, 'Ispahani', '89012345000350', '8941193314036', 'Mirzapore tea bags 100g', 'i-01', 105.00, 'Pcs', NULL), (351, 'Ispahani', '89012345000351', '8941193314531', 'Mirzapore tea bags 100g', 'i-02', 64.00, 'Pcs', NULL), (352, 'Ispahani', '89012345000352', '8941193314524', 'Mirzapore tea bags 50g', 'i-03', 34.00, 'Pcs', NULL), (353, 'Ispahani', '89012345000353', '8941193310519', 'Mighty chips 14g', 'i-04', 10.00, 'Pcs', NULL), (354, 'Ispahani', '89012345000354', '8941193311172', 'bakery fresh sweet toast biscuit 180g', 'i-05', 50.00, 'Pcs', NULL), (355, 'Ispahani', '89012345000355', '8941193311769', 'Butterful biscuit', 'i-07', 20.00, 'Pcs', NULL), (356, 'Ispahani', '89012345000356', '8941193311776', 'Milk Marie 200g', 'i-06', 60.00, 'Pcs', NULL), (357, 'Pran', '89012345000357', '841165102730', 'Rusk', 'P-79', 70.00, 'Pcs', NULL), (358, 'Pran', '89012345000358', '831730007287', 'MIlk full cream liqud milk 500ml', 'p-80', 60.00, 'Pcs', NULL), (359, 'Pran', '89012345000359', '831730007300', 'MIlk full cream liqud milk 500ml', 'P-81', 30.00, 'Pcs', NULL), (360, 'Olympic', '89012345000360', '745114131317', 'Biscotti Cookies Biscuits 60g', 'ol-01', 20.00, 'Pcs', NULL), (361, 'Olympic', '89012345000361', '745114130716', 'Nutty Biscuits 50g', 'ol-02', 15.00, 'Pcs', NULL), (362, 'Olympic', '89012345000362', '745114130723', 'Nutty Biscuits 175g', 'ol-03', 50.00, 'Pcs', NULL), (363, 'Olympic', '89012345000363', '745114130617', 'Premium Toast Biscuits 185g', 'ol-04', 60.00, 'Pcs', NULL), (364, 'Olympic', '89012345000364', '745114130471', 'Energy Plus Biscuits 185g', 'ol-05', 50.00, 'Pcs', NULL), (365, 'Olympic', '89012345000365', '745114130495', 'Energy Plus Biscuits 40g', 'pl-06', 10.00, 'Pcs', NULL), (366, 'Olympic', '89012345000366', '745114130501', 'Energy Plus Biscuits 16g', 'ol-07', 5.00, 'Pcs', NULL), (367, 'Olympic', '89012345000367', '745114130037', 'LEXUS Biscuits', 'ol-08', 100.00, 'Pcs', NULL), (368, 'Olympic', '89012345000368', '745114130624', 'TIP crispy salted biscuits 60g', 'ol-09', 15.00, 'Pcs', NULL), (369, 'Olympic', '89012345000369', '745114130006', 'Knock Wafer Biscuits & chocolate 25g', 'ol-10', 15.00, 'Pcs', NULL), (370, 'Olympic', '89012345000370', '745114130013', 'Knock chocolate coated wafer biscuit with milk cream 25g', 'ol-11', 15.00, 'Pcs', NULL), (371, 'Olympic', '89012345000371', '745114131324', 'Nice Biscuits40g', 'ol-12', 10.00, 'Pcs', NULL), (372, 'Olympic', '89012345000372', '745114136343', 'Orange bite biscuits 40g', 'ol-13', 10.00, 'Pcs', NULL), (373, 'Mgi', '89012345000373', '8941161101521', 'Fresh Chilli powder 50g', 'mgi-03', 38.00, 'Pcs', NULL), (374, 'Mgi', '89012345000374', '8941161101606', 'Fresh Turmeric powder 50g', 'mgi-04', 40.00, 'Pcs', NULL), (375, 'Dekko', '89012345000375', '8946565147007', 'Horlicks Cookies biscuit 250g', 'd1-01', 70.00, 'Pcs', NULL), (376, 'Dekko', '89012345000376', '8946565138357', 'Sooper Dooper Biscuits 40g', 'd1-02', 10.00, 'Pcs', NULL), (377, 'Haque', '89012345000377', '8941194003656', 'Bourbon Chocolate cream sandwich biscuit 180g', 'hf-01', 50.00, 'Pcs', NULL), (378, 'Haque', '89012345000378', '8941194002550', 'Mr.Cookie butter coconut biscuit 35g', 'hf-02', 10.00, 'Pcs', NULL), (379, 'Haque', '89012345000379', '8941194005919', 'Nick Neck Chocolate 16g', 'hf-03', 10.00, 'Pcs', NULL), (380, 'Fulkoli', '89012345000380', '8949219643061', 'Coconut Biscuit 90g', 'fs-01', 25.00, 'Pcs', NULL), (381, 'Fulkoli', '89012345000381', '0', 'Ghee Toast 250g', 'fs-02', 75.00, 'Pcs', NULL), (382, 'Fulkoli', '89012345000382', '0', 'Badami Biscuits 200g', 'fs-03', 70.00, 'Pcs', NULL), (383, 'Fulkoli', '89012345000383', '0', 'Butter Toast 300g', 'fs-04', 80.00, 'Pcs', NULL), (384, 'Fulkoli', '89012345000384', '0', 'Special Chanachur 280g', 'fs-05', 90.00, 'Pcs', NULL), (385, 'Fulkoli', '89012345000385', '0', 'Tea-Time cookies biscuit 600g', 'fs-06', 160.00, 'Pcs', NULL), (386, 'Zafran', '89012345000386', '8944000555226', 'Litchi drinks 125g', 'z-04', 10.00, 'Pcs', NULL), (387, 'Zafran', '89012345000387', '8944000555004', 'Tiffin cake 11g', 'z-05', 5.00, 'Pcs', NULL), (388, 'Bombay', '89012345000388', '8941154031408', 'Bombay Sweets Chanachur 500g', 'b-01', 150.00, 'Pcs', NULL), (389, 'Bombay', '89012345000389', '8941154031996', 'Bombay Sweets Chanachur 300g', 'b-02', 100.00, 'Pcs', NULL), (390, 'Bombay', '89012345000390', '8941154031385', 'Bombay Sweets Chanachur 150g', 'b-03', 50.00, 'Pcs', NULL), (391, 'Bombay', '89012345000391', '8941154033211', 'Bombay Sweets Chanachur 150g', 'b-04', 30.00, 'Pcs', NULL), (392, 'Bombay', '89012345000392', '8941154031378', 'Bombay Sweets Chanachur 45g', 'b-05', 20.00, 'Pcs', NULL), (393, 'Bombay', '89012345000393', '8941154031361', 'Bombay Sweets Chanachur 18g', 'b-06', 10.00, 'Pcs', NULL), (394, 'Bombay', '89012345000394', '8941154030210', 'Mr.Twist Potato Snacks crisdy chips 15g', 'b-07', 20.00, 'Pcs', NULL), (395, 'Bombay', '89012345000395', '8941154030135', 'Alooz Tomato flavour chips 18g', 'b-08', 20.00, 'Pcs', NULL), (396, 'Bombay', '89012345000396', '8941154030418', 'Potato Crackers tomato Flavour chips 10g', 'b-09', 10.00, 'Pcs', NULL), (397, 'Arlafoods', '89012345000397', '5711953039423', 'Dano Daily pusti milk 200g', 'ar-01', 180.00, 'Pcs', NULL), (398, 'Arlafoods', '89012345000398', '0', 'Dano Daily pusti milk 10g', 'ar', 10.00, 'Pcs', NULL), (399, 'Pran', '89012345000399', '840205718917', 'Jhal Muri 20g', 'p-72', 10.00, 'Pcs', NULL), (400, 'Pran', '89012345000400', '831730006501', 'Badam Bhaja 16g', 'p-73', 10.00, 'Pcs', NULL), (401, 'Akij', '89012345000401', '8941189604431', 'Farm Fresh Toned milk 500ml', 'ak-01', 50.00, 'Pcs', NULL), (402, 'Akij', '89012345000402', '8941189604479', 'Farm Fresh Chocolate milk 200ml', 'ak-02', 30.00, 'Pcs', NULL), (403, 'Akij', '89012345000403', '8941189604462', 'Farm Fresh Mango milk 200ml', 'ak-03', 30.00, 'Pcs', NULL), (404, 'Akij', '89012345000404', '8941189604448', 'Farm Fresh UHT Chocolate milk 250ml', 'ak-04', 40.00, 'Pcs', NULL), (405, 'Akij', '89012345000405', '8941189604356', 'Farm Fresh UHT Mango milk 200ml', 'ak-05', 40.00, 'Pcs', NULL), (406, 'Akij', '89012345000406', '8941189600044', 'Mojo 250ml', 'ak-06', 20.00, 'Pcs', NULL), (407, 'Akij', '89012345000407', '8941189600068', 'Mojo 500ml', 'ak-07', 40.00, 'Pcs', NULL), (408, 'Akij', '89012345000408', '8941189600082', 'Mojo 2l', 'ak-08', 120.00, 'Pcs', NULL), (409, 'Akij', '89012345000409', '8941189600266', 'Speed 250ml', 'ak-09', 30.00, 'Pcs', NULL), (410, 'Akij', '89012345000410', '8941189600273', 'Speed ken 250ml', 'ak-10', 50.00, 'Pcs', NULL), (411, 'Akij', '89012345000411', '8941189600914', 'Cheese Puffs 14g', 'ak-11', 10.00, 'Pcs', NULL), (412, 'Akij', '89012345000412', '8941189601423', 'Krancho Potato Crackers chips 15g', 'ak-12', 10.00, 'Pcs', NULL), (413, 'Akij', '89012345000413', '8941153056938', 'Elano Dipstik Chocolate 33g', 'ak-13', 30.00, 'Pcs', NULL), (414, 'Akij', '89012345000414', '8941153056662', 'Fondala milk chocolate bar 20g', 'ak-14', 20.00, 'Pcs', NULL), (415, 'Akij', '89012345000415', '8941153056686', 'Fondala milk chocolate bar 10g', 'ak-15', 10.00, 'Pcs', NULL), (416, 'Akij', '89012345000416', '8941153057027', 'Elano Tempt Chocolate 55g', 'ak-16', 120.00, 'Pcs', NULL), (417, 'Akij', '89012345000417', '8941153056273', 'Fast milk Bread 600g', 'ak-17', 100.00, 'Pcs', NULL), (418, 'Akij', '89012345000418', '8941153056099', 'Fast milk Bread 300g', 'ak-18', 50.00, 'Pcs', NULL), (419, 'Akij', '89012345000419', '8941153056235', 'Fast milk Butter Bread 115g', 'ak-19', 20.00, 'Pcs', NULL), (420, 'Akij', '89012345000420', '8941153056259', 'Fast White Bread 70g', 'ak-20', 10.00, 'Pcs', NULL), (421, 'Akij', '89012345000421', '8941153055412', 'Fast Mixed Fruit Cake 210g', 'ak-21', 120.00, 'Pcs', NULL), (422, 'AKIJ', '89012345000422', '8941153055184', 'Fast mixed fruits cup cake 18g', 'ak-22', 10.00, 'Pcs', NULL), (423, 'Akij', '89012345000423', '8941153055658', 'Fast soft cake vanilla 40g', 'ak-23', 20.00, 'Pcs', NULL), (424, 'Akij', '89012345000424', '8941153055269', 'Fast lauer cake chocolate 17g', 'ak-24', 10.00, 'Pcs', NULL), (425, 'Akij', '89012345000425', '8941153056044', 'Fast Butter bun Bread 38g', 'ak-25', 10.00, 'Pcs', NULL), (426, 'Akij', '89012345000426', '8941153056051', 'Fast chocolate bun bread 38g', 'ak-26', 10.00, 'Pcs', NULL), (427, 'Akij', '89012345000427', '8941153054118', 'Pillow chocolate filled wafer biscuits 19g', 'ak-27', 10.00, 'Pcs', NULL), (428, 'Akij', '89012345000428', '8941153056846', 'Rong buzz rockzz 13g', 'ak-28', 10.00, 'Pcs', NULL), (429, 'Akij', '89012345000429', '8941153055160', 'Fast Vanilla pound cake 67g', 'ak-29', 30.00, 'Pcs', NULL), (430, 'Akij', '89012345000430', '8941153055153', 'Fast Chocolate pound cake 37g', 'ak-30', 35.00, 'Pcs', NULL), (431, 'Akij', '89012345000431', '8941153400595', 'Mum mum baby pant diaper 4 pcs XL', 'ak-31', 140.00, 'Pcs', NULL), (432, 'Akij', '89012345000432', '8941153400571', 'Mum mum baby pant diaper 5 pcs L', 'ak-32', 140.00, 'Pcs', NULL), (433, 'SMC', '89012345000433', '8941193100028', 'Joya Sanitary napkin belt regular flow 8 pads b', 'smc-01', 60.00, 'Pcs', NULL), (434, 'SMC', '89012345000434', '8941193100035', 'Joya Sanitary napkin wings regular flow 8 pads b', 'smc-02', 80.00, 'Pcs', NULL), (435, 'SMC', '89012345000435', '8941193105320', 'Smc Plus Electrolyte Drinks 200ml', 'smc-03', 35.00, 'Pcs', NULL), (436, 'SMC', '89012345000436', '8941193105337', 'Smc Plus Electrolyte Lemon Drinks 200ml', 'smc-04', 35.00, 'Pcs', NULL), (437, 'SMC', '89012345000437', '0', 'Orsaline', 'smc-05', 6.00, 'Pcs', NULL), (438, 'SMC', '89012345000438', '8941193105214', 'Taste me orange flavored 16g', 'smc-06', 10.00, 'Pcs', NULL), (439, 'SMC', '89012345000439', '8941193105221', 'Taste me mango flavored 16g', 'smc-07', 10.00, 'Pcs', NULL), (440, 'Mgi', '89012345000440', '8941161007557', 'Fresh hand towel 150 pce', 'mgi-05', 50.00, 'Pcs', NULL), (441, 'Bashundhara', '89012345000441', '8941193073148', 'Bashundhara Facial Tissue 200pce', 'bp-01', 75.00, 'Pcs', NULL), (442, 'Bashundhara', '89012345000442', '8941193041116', 'Bashundhara Restaurant napkin Tissue 100pce', 'bp-02', 65.00, 'Pcs', NULL), (443, 'Bashundhara', '89012345000443', '8941193067024', 'Bashundhara Toilet Tissue 76g', 'bp-03', 28.00, 'Pcs', NULL), (444, 'Bashundhara', '89012345000444', '8941193067017', 'Bashundhara Gold Toilet Tissue 76g', 'bp-04', 38.00, 'Pcs', NULL), (445, 'Bashundhara', '89012345000445', '8941193071618', 'Bashundhara pocket Tissue Wallet 20pce', 'bp-05', 10.00, 'Pcs', NULL), (446, 'Mgi', '89012345000446', '8941161004969', 'Fresh toilet tissue gold 120g', 'mgi-06', 38.00, 'Pcs', NULL), (447, 'Mgi', '89012345000447', '8941161004914', 'Fresh toilet tissue white 80g', 'mgi-07', 28.00, 'Pcs', NULL), (448, 'Shova Consumer Care', '89012345000448', '0', 'Masranga Silver king koyel', 'sh-01', 100.00, 'Pcs', NULL), (449, 'Ahmed Enterprise', '89012345000449', '8941105203496', 'Euro FAI-Ming coil', 'ah', 100.00, 'Pcs', NULL), (450, 'NZ Corporation', '89012345000450', '0', 'Signal + coil', 'nz-01', 100.00, 'Pcs', NULL), (451, 'Thai', '89012345000451', '8944220152182', 'Thai Baby Pants diaper S 5pce', 't-01', 140.00, 'Pcs', NULL), (452, 'Thai', '89012345000452', '8944220152199', 'Thai Baby Pants diaper M 5pce', 't-02', 140.00, 'Pcs', NULL), (453, 'Thai', '89012345000453', '8944220152205', 'Thai Baby Pants diaper L 5pce', 't-03', 140.00, 'Pcs', NULL), (454, 'Thai', '89012345000454', '8944220152212', 'Thai Baby Pants diaper XL 4pce', 't-04', 4.00, 'Pcs', NULL), (455, 'Thai', '89012345000455', '8944220152229', 'Thai Baby Pants diaper XXL 4pce', 't-05', 140.00, 'Pcs', NULL), (456, 'Thai', '89012345000456', '8944220152175', 'Thai Baby Pants diaper New Born 5pce', 't-06', 140.00, 'Pcs', NULL), (457, 'Thai', '89012345000457', '0', 'Feeding Bottle Taper 250ml/80z', 't-08', 110.00, 'Pcs', NULL), (458, 'Thai', '89012345000458', '0', 'Feeding Bottle Taper 60ml/20z', 't-07', 95.00, 'Pcs', NULL), (459, 'Thai', '89012345000459', '0', 'Thai Silicone Nipple S (0-4) month', 't-09', 30.00, 'Pcs', NULL), (460, '', '89012345000460', '0', 'Thai Silicone Nipple M (4-8) month', 't-10', 30.00, 'Pcs', NULL), (461, 'Thai', '89012345000461', '8944220152137', 'Thai Baby Pants diaper L 34pce', 't-11', 885.00, 'Pcs', NULL), (462, 'Thai', '89012345000462', '8944220152120', 'Thai Baby Pants diaper M 40pce', 't-12', 885.00, 'Pcs', NULL), (463, 'Thai', '89012345000463', '8944220152113', 'Thai Baby Pants diaper S 42pce', 't-13', 885.00, 'Pcs', NULL), (464, 'Coca Cola', '89012345000464', '8907525000213', 'Coca Cola 1.75L', 'c-01', 150.00, 'Pcs', NULL), (465, 'Super oil Rifainary', '89012345000465', '8941153500073', 'Pusti 5L', 'so-01', 1000.00, 'Pcs', NULL), (466, 'Super oil Rifainary', '89012345000466', '8941153500066', 'Pusti 3L', 'so-02', 620.00, 'Pcs', NULL); INSERT INTO `product` (`id`, `Brand_Name`, `Barcode`, `company_barcode`, `Product_Name`, `Part_Number`, `sale_price`, `Unit`, `product_has`) VALUES (467, 'Super oil Rifainary', '89012345000467', '3885522502006', 'Pusti 2L', 'so-03', 420.00, 'Pcs', NULL), (468, 'Super oil Rifainary', '89012345000468', '8941153500226', 'Pusti 1L', 'so-04', 210.00, 'Pcs', NULL), (469, 'Shawon consumer Products', '89012345000469', '0', 'Icon Soyabean Oil 1L', 'sc', 220.00, 'Pcs', NULL), (470, 'Shawon consumer Products', '89012345000470', '0', 'Icon Soyabean Oil 500ml', 'sc-02', 110.00, 'Pcs', NULL), (471, 'Mgi', '89012345000471', '8941161113050', 'Fresh Packajed Driking Water 2L', 'mgi-08', 40.00, 'Pcs', NULL), (472, 'Mgi', '89012345000472', '8941161113036', 'Fresh Packajed Driking Water 1L', 'mgi-09', 30.00, 'Pcs', NULL), (473, 'Mgi', '89012345000473', '8941161113029', 'Fresh Packajed Driking Water 500ml', 'mgi-10', 20.00, 'Pcs', NULL), (474, 'Mgi', '89012345000474', '8941161110059', 'Gear 250ml', 'mgi-11', 25.00, 'Pcs', NULL), (475, 'Mgi', '89012345000475', '8941161110011', 'Fresh UP 250ml', 'mgi-12', 20.00, 'Pcs', NULL), (476, 'Mgi', '89012345000476', '8941161110028', 'Fresh Googly 250ml', 'mgi-13', 20.00, 'Pcs', NULL), (477, 'Mgi', '89012345000477', '8941161110073', 'Fresh Googly 500ml', 'mgi-14', 40.00, 'Pcs', NULL), (478, 'Pran', '89012345000478', '831730009755', 'Frooto mango fruit Drink 1L', 'p-74', 80.00, 'Pcs', NULL), (479, 'Pran', '89012345000479', '831730009489', 'Frooto mango fruit Drink 500ml', 'p-75', 45.00, 'Pcs', NULL), (480, 'Pran', '89012345000480', '846656010945', 'Frooto mango fruit Drink 200ml', 'p-76', 20.00, 'Pcs', NULL), (481, 'Akij', '89012345000481', '8941189609252', 'Fizzo apple flavored 250ml', 'ak-33', 30.00, 'Pcs', NULL), (482, 'Transcom beverages L.', '89012345000482', '8941100313824', '7 up 1.75L', 'tb-01', 140.00, 'Pcs', NULL), (483, 'Transcom beverages L.', '89012345000483', '8941100318461', '7 up 1L', 'tb-02', 90.00, 'Pcs', NULL), (484, 'Transcom beverages L.', '89012345000484', '8941100318416', '7 up 200ml', 'tb-03', 25.00, 'Pcs', NULL), (485, 'Transcom beverages L.', '89012345000485', '8941100314418', 'Mirinda 200ml', 'tb-04', 25.00, 'Pcs', NULL), (486, 'Transcom beverages L.', '89012345000486', '8941100315408', 'Mounten Dew 200ml', 'tb-05', 25.00, 'Pcs', NULL), (487, 'Pran', '89012345000487', '841165104581', 'Oscar malt beverage 330ml', 'p-77', 40.00, 'Pcs', NULL), (488, 'Pran', '89012345000488', '846656019733', 'Oscar malt beverage 250ml', 'p-78', 30.00, 'Pcs', NULL); -- -------------------------------------------------------- -- -- Table structure for table `product_company_barcode` -- CREATE TABLE `product_company_barcode` ( `id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `company_barcode` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; -- -- Dumping data for table `product_company_barcode` -- INSERT INTO `product_company_barcode` (`id`, `product_id`, `company_barcode`, `created_at`) VALUES (4, 1, '8941100294833', '2026-08-28 22:56:01'), (5, 2, '8941100294840', '2026-08-28 22:56:01'), (6, 4, '8941100295670', '2026-08-28 22:56:01'), (7, 5, '8941100296516', '2026-08-28 22:56:01'), (8, 8, '8941100296295', '2026-08-28 22:56:01'), (9, 9, '8941100296325', '2026-08-28 22:56:01'), (10, 10, '8901058001617', '2026-08-28 22:56:01'), (11, 11, '8901058006377', '2026-08-28 22:56:01'), (12, 13, '841165147502', '2026-08-28 22:56:01'), (13, 14, '846656019665', '2026-08-28 22:56:01'), (14, 15, '840205730650', '2026-08-28 22:56:01'), (15, 16, '841165107537', '2026-08-28 22:56:01'), (16, 17, '841165123087', '2026-08-28 22:56:01'), (17, 18, '846656001790', '2026-08-28 22:56:01'), (18, 19, '831730001766', '2026-08-28 22:56:01'), (19, 20, '840205747450', '2026-08-28 22:56:01'), (20, 21, '831730001636', '2026-08-28 22:56:01'), (21, 22, '831730001711', '2026-08-28 22:56:01'), (22, 23, '831730001926', '2026-08-28 22:56:01'), (23, 24, '831730002541', '2026-08-28 22:56:01'), (24, 25, '841165150595', '2026-08-28 22:56:01'), (25, 26, '846656005088', '2026-08-28 22:56:01'), (26, 27, '841165150601', '2026-08-28 22:56:01'), (27, 28, '841165163489', '2026-08-28 22:56:01'), (28, 29, '841165118335', '2026-08-28 22:56:01'), (29, 30, '841165155750', '2026-08-28 22:56:01'), (30, 31, '841165155385', '2026-08-28 22:56:01'), (31, 32, '840205793303', '2026-08-28 22:56:01'), (32, 33, '840205720118', '2026-08-28 22:56:01'), (33, 34, '841165115235', '2026-08-28 22:56:01'), (34, 35, '831730009335', '2026-08-28 22:56:01'), (35, 36, '846656004029', '2026-08-28 22:56:01'), (36, 37, '840205714407', '2026-08-28 22:56:01'), (37, 38, '841165110315', '2026-08-28 22:56:01'), (38, 39, '840205715183', '2026-08-28 22:56:01'), (39, 40, '846656003411', '2026-08-28 22:56:01'), (40, 41, '8941154030418', '2026-08-28 22:56:01'), (41, 42, '840205725380', '2026-08-28 22:56:01'), (42, 43, '840205744824', '2026-08-28 22:56:01'), (43, 44, '840205744312', '2026-08-28 22:56:01'), (44, 45, '831730006907', '2026-08-28 22:56:01'), (45, 46, '840205796878', '2026-08-28 22:56:01'), (46, 47, '840205754397', '2026-08-28 22:56:01'), (47, 48, '840205791743', '2026-08-28 22:56:01'), (48, 49, '841165118991', '2026-08-28 22:56:01'), (49, 50, '840205735785', '2026-08-28 22:56:01'), (50, 51, '831730009472', '2026-08-28 22:56:01'), (51, 52, '846656008003', '2026-08-28 22:56:01'), (52, 53, '840205710959', '2026-08-28 22:56:01'), (53, 54, '841165154920', '2026-08-28 22:56:01'), (54, 55, '840205744329', '2026-08-28 22:56:01'), (55, 56, '840205744091', '2026-08-28 22:56:01'), (56, 57, '841165145232', '2026-08-28 22:56:01'), (57, 58, '840205716708', '2026-08-28 22:56:01'), (58, 59, '841165135974', '2026-08-28 22:56:01'), (59, 60, '840205794324', '2026-08-28 22:56:01'), (60, 61, '840205794300', '2026-08-28 22:56:01'), (61, 62, '840205788033', '2026-08-28 22:56:01'), (62, 63, '840205731428', '2026-08-28 22:56:01'), (63, 64, '841165159109', '2026-08-28 22:56:01'), (64, 65, '840547600512', '2026-08-28 22:56:01'), (65, 66, '846656012178', '2026-08-28 22:56:01'), (66, 67, '840205714216', '2026-08-28 22:56:01'), (67, 68, '840205711017', '2026-08-28 22:56:01'), (68, 69, '840205717088', '2026-08-28 22:56:01'), (69, 70, '840205738236', '2026-08-28 22:56:01'), (70, 71, '840205738229', '2026-08-28 22:56:01'), (71, 72, '840205738212', '2026-08-28 22:56:01'), (72, 73, '840205740116', '2026-08-28 22:56:01'), (73, 74, '840205729432', '2026-08-28 22:56:01'), (74, 75, '840205740123', '2026-08-28 22:56:01'), (75, 76, '841165160037', '2026-08-28 22:56:01'), (76, 77, '840205710201', '2026-08-28 22:56:01'), (77, 78, '841165146079', '2026-08-28 22:56:01'), (78, 79, '841165107940', '2026-08-28 22:56:01'), (79, 80, '831730003623', '2026-08-28 22:56:01'), (80, 81, '840205729968', '2026-08-28 22:56:01'), (81, 82, '831730008260', '2026-08-28 22:56:01'), (82, 83, '840205712175', '2026-08-28 22:56:01'), (83, 84, '8906189772719', '2026-08-28 22:56:01'), (84, 85, '8906189772702', '2026-08-28 22:56:01'), (85, 86, '8941100657478', '2026-08-28 22:56:01'), (86, 87, '8941102314447', '2026-08-28 22:56:01'), (87, 88, '8906189772795', '2026-08-28 22:56:01'), (88, 89, '8906189772788', '2026-08-28 22:56:01'), (89, 90, '8906189772788', '2026-08-28 22:56:01'), (90, 91, '8906189772764', '2026-08-28 22:56:01'), (91, 92, '8906189773860', '2026-08-28 22:56:01'), (92, 93, '8906189774324', '2026-08-28 22:56:01'), (93, 94, '8906189774331', '2026-08-28 22:56:01'), (94, 95, '8941102467303', '2026-08-28 22:56:01'), (95, 96, '8941102467266', '2026-08-28 22:56:01'), (96, 97, '8941102467280', '2026-08-28 22:56:01'), (97, 98, '0', '2026-08-28 22:56:01'), (98, 99, '0', '2026-08-28 22:56:01'), (99, 100, '8906189771323', '2026-08-28 22:56:01'), (100, 101, '8906189775031', '2026-08-28 22:56:01'), (101, 102, '8941102467280', '2026-08-28 22:56:01'), (102, 103, '8906189771736', '2026-08-28 22:56:01'), (103, 104, '8906189771729', '2026-08-28 22:56:01'), (104, 105, '8906189771712', '2026-08-28 22:56:01'), (105, 106, '8906189774461', '2026-08-28 22:56:01'), (106, 107, '8906189774485', '2026-08-28 22:56:01'), (107, 108, '8906189771422', '2026-08-28 22:56:01'), (108, 109, '8901030824968', '2026-08-28 22:56:01'), (109, 110, '8901030712999', '2026-08-28 22:56:01'), (110, 111, '8941102461431', '2026-08-28 22:56:01'), (111, 112, '8941102460304', '2026-08-28 22:56:01'), (112, 113, '8941102460328', '2026-08-28 22:56:01'), (113, 114, '8906189772429', '2026-08-28 22:56:01'), (114, 115, '8906189773211', '2026-08-28 22:56:01'), (115, 116, '8941102467907', '2026-08-28 22:56:01'), (116, 117, '8941102467884', '2026-08-28 22:56:01'), (117, 118, '8906189773532', '2026-08-28 22:56:01'), (118, 119, '8941102467914', '2026-08-28 22:56:01'), (119, 120, '8941100619612', '2026-08-28 22:56:01'), (120, 121, '8941100656020', '2026-08-28 22:56:01'), (121, 122, '8941102467891', '2026-08-28 22:56:01'), (122, 123, '8906189772054', '2026-08-28 22:56:01'), (123, 124, '8906189772030', '2026-08-28 22:56:01'), (124, 125, '8906189772023', '2026-08-28 22:56:01'), (125, 126, '8906189771316', '2026-08-28 22:56:01'), (126, 127, '8941102464135', '2026-08-28 22:56:01'), (127, 128, '8941102460724', '2026-08-28 22:56:01'), (128, 129, '8906189773914', '2026-08-28 22:56:01'), (129, 130, '8941102468294', '2026-08-28 22:56:01'), (130, 131, '8909106047105', '2026-08-28 22:56:01'), (131, 132, '8909106047129', '2026-08-28 22:56:01'), (132, 133, '8941102466252', '2026-08-28 22:56:01'), (133, 134, '8941102463480', '2026-08-28 22:56:01'), (134, 135, '8906189773150', '2026-08-28 22:56:01'), (135, 136, '8906189773167', '2026-08-28 22:56:01'), (136, 137, '8909106049680', '2026-08-28 22:56:01'), (137, 138, '8909106049697', '2026-08-28 22:56:01'), (138, 139, '8906189772177', '2026-08-28 22:56:01'), (139, 140, '8906189770555', '2026-08-28 22:56:01'), (140, 141, '0', '2026-08-28 22:56:01'), (141, 142, '8941102462452', '2026-08-28 22:56:01'), (142, 143, '8901030989865', '2026-08-28 22:56:01'), (143, 144, '8901030989827', '2026-08-28 22:56:01'), (144, 145, '8906189771613', '2026-08-28 22:56:01'), (145, 146, '8941102319268', '2026-08-28 22:56:01'), (146, 147, '8941102462155', '2026-08-28 22:56:01'), (147, 148, '8906189772474', '2026-08-28 22:56:01'), (148, 149, '8906189770111', '2026-08-28 22:56:01'), (149, 150, '8906189771958', '2026-08-28 22:56:01'), (150, 151, '8906189771972', '2026-08-28 22:56:01'), (151, 152, '8941102464913', '2026-08-28 22:56:01'), (152, 153, '0', '2026-08-28 22:56:01'), (153, 154, '8901030869112', '2026-08-28 22:56:01'), (154, 155, '8940110045374', '2026-08-28 22:56:01'), (155, 156, '8941158069186', '2026-08-28 22:56:01'), (156, 157, '9010002453705', '2026-08-28 22:56:01'), (157, 158, '3020050548595', '2026-08-28 22:56:01'), (158, 159, '8941158069513', '2026-08-28 22:56:01'), (159, 160, '6000100453700', '2026-08-28 22:56:01'), (160, 161, '6000050245370', '2026-08-28 22:56:01'), (161, 162, '8941158069070', '2026-08-28 22:56:01'), (162, 163, '8941158069087', '2026-08-28 22:56:01'), (163, 164, '8941158069094', '2026-08-28 22:56:01'), (164, 165, '8941158069797', '2026-08-28 22:56:01'), (165, 166, '8941158069308', '2026-08-28 22:56:01'), (166, 167, '8019885002261', '2026-08-28 22:56:01'), (167, 168, '8941100500132', '2026-08-28 22:56:01'), (168, 169, '8941100500033', '2026-08-28 22:56:01'), (169, 170, '8941100501221', '2026-08-28 22:56:01'), (170, 171, '8941100501238', '2026-08-28 22:56:01'), (171, 172, '8941100514320', '2026-08-28 22:56:01'), (172, 173, '8941100514313', '2026-08-28 22:56:01'), (173, 174, '8941100512661', '2026-08-28 22:56:01'), (174, 175, '8941100512654', '2026-08-28 22:56:01'), (175, 176, '8941100512647', '2026-08-28 22:56:01'), (176, 177, '8941100512630', '2026-08-28 22:56:01'), (177, 178, '8941100500316', '2026-08-28 22:56:01'), (178, 179, '8941100500309', '2026-08-28 22:56:01'), (179, 180, '8941100503591', '2026-08-28 22:56:01'), (180, 181, '8941100500873', '2026-08-28 22:56:01'), (181, 182, '8941100502730', '2026-08-28 22:56:01'), (182, 183, '8941100500231', '2026-08-28 22:56:01'), (183, 184, '8941100500507', '2026-08-28 22:56:01'), (184, 185, '8941100500514', '2026-08-28 22:56:01'), (185, 186, '8941100511763', '2026-08-28 22:56:01'), (186, 187, '8941100501290', '2026-08-28 22:56:01'), (187, 188, '8941100500187', '2026-08-28 22:56:01'), (188, 189, '8941100501726', '2026-08-28 22:56:01'), (189, 190, '8941100512104', '2026-08-28 22:56:01'), (190, 191, '8941100513828', '2026-08-28 22:56:01'), (191, 192, '8941100513811', '2026-08-28 22:56:01'), (192, 193, '8941100513163', '2026-08-28 22:56:01'), (193, 194, '8941100513224', '2026-08-28 22:56:01'), (194, 195, '8941100513194', '2026-08-28 22:56:01'), (195, 196, '8941100513217', '2026-08-28 22:56:01'), (196, 197, '8941102467266', '2026-08-28 22:56:01'), (197, 198, '8941100511206', '2026-08-28 22:56:01'), (198, 199, '8941100511398', '2026-08-28 22:56:01'), (199, 200, '8941100511916', '2026-08-28 22:56:01'), (200, 201, '8941100511053', '2026-08-28 22:56:01'), (201, 202, '8941100511428', '2026-08-28 22:56:01'), (202, 203, '8941100511329', '2026-08-28 22:56:01'), (203, 204, '8941100511282', '2026-08-28 22:56:01'), (204, 205, '8941100511725', '2026-08-28 22:56:01'), (205, 206, '8941100511404', '2026-08-28 22:56:01'), (206, 207, '8941100510179', '2026-08-28 22:56:01'), (207, 208, '8941100510186', '2026-08-28 22:56:01'), (208, 209, '8941100510254', '2026-08-28 22:56:01'), (209, 210, '8941100510247', '2026-08-28 22:56:01'), (210, 211, '8941100511022', '2026-08-28 22:56:01'), (211, 212, '8941100511015', '2026-08-28 22:56:01'), (212, 213, '8941100510162', '2026-08-28 22:56:01'), (213, 214, '8941100510995', '2026-08-28 22:56:01'), (214, 215, '8941100510100', '2026-08-28 22:56:01'), (215, 216, '8941100510094', '2026-08-28 22:56:01'), (216, 217, '8941100510025', '2026-08-28 22:56:01'), (217, 218, '8941100510018', '2026-08-28 22:56:01'), (218, 219, '8941100511138', '2026-08-28 22:56:01'), (219, 220, '8941100511305', '2026-08-28 22:56:01'), (220, 221, '8941100511275', '2026-08-28 22:56:01'), (221, 222, '8941100511169', '2026-08-28 22:56:01'), (222, 223, '8941100512845', '2026-08-28 22:56:01'), (223, 224, '8941100513552', '2026-08-28 22:56:01'), (224, 225, '8941100513569', '2026-08-28 22:56:01'), (225, 226, '8941100514221', '2026-08-28 22:56:01'), (226, 227, '8908001158381', '2026-08-28 22:56:01'), (227, 228, '8908001158077', '2026-08-28 22:56:01'), (228, 229, '8901526005208', '2026-08-28 22:56:01'), (229, 230, '8901526658657', '2026-08-28 22:56:01'), (230, 231, '8513690304454', '2026-08-28 22:56:01'), (231, 232, '8513690604509', '2026-08-28 22:56:01'), (232, 233, '8513690404406', '2026-08-28 22:56:01'), (233, 234, '8513690401252', '2026-08-28 22:56:01'), (234, 235, '8513690101503', '2026-08-28 22:56:01'), (235, 236, '8513690193140', '2026-08-28 22:56:01'), (236, 237, '8513690310172', '2026-08-28 22:56:01'), (237, 238, '8513691414008', '2026-08-28 22:56:01'), (238, 239, '8513691412905', '2026-08-28 22:56:01'), (239, 240, '8513695121209', '2026-08-28 22:56:01'), (240, 241, '4800888158932', '2026-08-28 22:56:01'), (241, 242, '4800888143402', '2026-08-28 22:56:01'), (242, 243, '8906105101524', '2026-08-28 22:56:01'), (243, 244, '8906105101500', '2026-08-28 22:56:01'), (244, 245, '8906105101326', '2026-08-28 22:56:01'), (245, 246, '8906105101494', '2026-08-28 22:56:01'), (246, 247, '8906105101470', '2026-08-28 22:56:01'), (247, 248, '8906105101418', '2026-08-28 22:56:01'), (248, 249, '8901396601784', '2026-08-28 22:56:01'), (249, 250, '8908008142000', '2026-08-28 22:56:01'), (250, 251, '8908008142017', '2026-08-28 22:56:01'), (251, 252, '8901138711962', '2026-08-28 22:56:01'), (252, 253, '3700082500364', '2026-08-28 22:56:01'), (253, 254, '8908001158244', '2026-08-28 22:56:01'), (254, 255, '8941153902099', '2026-08-28 22:56:01'), (255, 256, '8941153902037', '2026-08-28 22:56:01'), (256, 257, '8941196243104', '2026-08-28 22:56:01'), (257, 258, '8941196243135', '2026-08-28 22:56:01'), (258, 259, '813903000035', '2026-08-28 22:56:01'), (259, 260, '813903000127', '2026-08-28 22:56:01'), (260, 261, '813903000028', '2026-08-28 22:56:01'), (261, 262, '8139003000846', '2026-08-28 22:56:01'), (262, 263, '8139003000853', '2026-08-28 22:56:01'), (263, 264, '8139003000860', '2026-08-28 22:56:01'), (264, 265, '8941100283516', '2026-08-28 22:56:01'), (265, 266, '8941102833962', '2026-08-28 22:56:01'), (266, 267, '8941102833177', '2026-08-28 22:56:01'), (267, 268, '8941100775356', '2026-08-28 22:56:01'), (268, 269, '8941100775363', '2026-08-28 22:56:01'), (269, 270, '8908008142628', '2026-08-28 22:56:01'), (270, 271, '8420701109321', '2026-08-28 22:56:01'), (271, 272, '420701471350', '2026-08-28 22:56:01'), (272, 273, '0', '2026-08-28 22:56:01'), (273, 274, '8901012116647', '2026-08-28 22:56:01'), (274, 275, '901012116630', '2026-08-28 22:56:01'), (275, 276, '901012116845', '2026-08-28 22:56:01'), (276, 277, '9556006012093', '2026-08-28 22:56:01'), (277, 278, '9556006012086', '2026-08-28 22:56:01'), (278, 279, '9556006014547', '2026-08-28 22:56:01'), (279, 280, '8991111101255', '2026-08-28 22:56:01'), (280, 281, '8901012116715', '2026-08-28 22:56:01'), (281, 282, '8901012100561', '2026-08-28 22:56:01'), (282, 283, '8901012100554', '2026-08-28 22:56:01'), (283, 284, '8901012117002', '2026-08-28 22:56:01'), (284, 285, '8901012116999', '2026-08-28 22:56:01'), (285, 286, '0', '2026-08-28 22:56:01'), (286, 287, '0', '2026-08-28 22:56:01'), (287, 288, '0', '2026-08-28 22:56:01'), (288, 289, '0', '2026-08-28 22:56:01'), (289, 290, '8941174010148', '2026-08-28 22:56:01'), (290, 291, '8941174010971', '2026-08-28 22:56:01'), (291, 292, '8941174010964', '2026-08-28 22:56:01'), (292, 293, '8941174010957', '2026-08-28 22:56:01'), (293, 294, '0', '2026-08-28 22:56:01'), (294, 295, '8513697106907', '2026-08-28 22:56:01'), (295, 296, '8513697119501', '2026-08-28 22:56:01'), (296, 297, '8513690351809', '2026-08-28 22:56:01'), (297, 298, '8513690301002', '2026-08-28 22:56:01'), (298, 299, '8513690304607', '2026-08-28 22:56:01'), (299, 300, '4791111106861', '2026-08-28 22:56:01'), (300, 301, '4791111106892', '2026-08-28 22:56:01'), (301, 302, '8941160237269', '2026-08-28 22:56:01'), (302, 303, '8941160237511', '2026-08-28 22:56:01'), (303, 304, '8941160237238', '2026-08-28 22:56:01'), (304, 305, '8941160237153', '2026-08-28 22:56:01'), (305, 306, '8901248104036', '2026-08-28 22:56:01'), (306, 307, '8901248104029', '2026-08-28 22:56:01'), (307, 308, '8901248104159', '2026-08-28 22:56:01'), (308, 309, '0', '2026-08-28 22:56:01'), (309, 310, '0', '2026-08-28 22:56:01'), (310, 311, '0', '2026-08-28 22:56:01'), (311, 312, '8901207019005', '2026-08-28 22:56:01'), (312, 313, '8941152000017', '2026-08-28 22:56:01'), (313, 314, '8941152011709', '2026-08-28 22:56:01'), (314, 315, '8941170014959', '2026-08-28 22:56:01'), (315, 316, '8941170014942', '2026-08-28 22:56:01'), (316, 317, '8941170014935', '2026-08-28 22:56:01'), (317, 318, '571866149801', '2026-08-28 22:56:01'), (318, 319, '8944000555769', '2026-08-28 22:56:01'), (319, 320, '8944000555929', '2026-08-28 22:56:01'), (320, 321, '8944000555912', '2026-08-28 22:56:01'), (321, 322, '8941124000953', '2026-08-28 22:56:01'), (322, 323, '8941124000489', '2026-08-28 22:56:01'), (323, 324, '8941124000090', '2026-08-28 22:56:01'), (324, 325, '8513692165404', '2026-08-28 22:56:01'), (325, 326, '8513692165329', '2026-08-28 22:56:01'), (326, 327, '8513690101251', '2026-08-28 22:56:01'), (327, 328, '859875003032', '2026-08-28 22:56:01'), (328, 329, '859875003049', '2026-08-28 22:56:01'), (329, 330, '859875003056', '2026-08-28 22:56:01'), (330, 331, '8941100504864', '2026-08-28 22:56:01'), (331, 332, '8941100506332', '2026-08-28 22:56:01'), (332, 333, '8139003005643', '2026-08-28 22:56:01'), (333, 334, '8139003005636', '2026-08-28 22:56:01'), (334, 335, '8139003005650', '2026-08-28 22:56:01'), (335, 336, '6933298817019', '2026-08-28 22:56:01'), (336, 337, '0', '2026-08-28 22:56:01'), (337, 338, '8941160000313', '2026-08-28 22:56:01'), (338, 339, '8941160000306', '2026-08-28 22:56:01'), (339, 340, '9415007843542', '2026-08-28 22:56:01'), (340, 341, '9415007828419', '2026-08-28 22:56:01'), (341, 342, '9415007013402', '2026-08-28 22:56:01'), (342, 343, '9415007972662', '2026-08-28 22:56:01'), (343, 344, '8941160032741', '2026-08-28 22:56:01'), (344, 345, '9415007976486', '2026-08-28 22:56:01'), (345, 346, '8941160031324', '2026-08-28 22:56:01'), (346, 347, '8941161147543', '2026-08-28 22:56:01'), (347, 348, '8941161180014', '2026-08-28 22:56:01'), (348, 349, '8941161147567', '2026-08-28 22:56:01'), (349, 350, '8941193314036', '2026-08-28 22:56:01'), (350, 351, '8941193314531', '2026-08-28 22:56:01'), (351, 352, '8941193314524', '2026-08-28 22:56:01'), (352, 353, '8941193310519', '2026-08-28 22:56:01'), (353, 354, '8941193311172', '2026-08-28 22:56:01'), (354, 355, '8941193311769', '2026-08-28 22:56:01'), (355, 356, '8941193311776', '2026-08-28 22:56:01'), (356, 357, '841165102730', '2026-08-28 22:56:01'), (357, 358, '831730007287', '2026-08-28 22:56:01'), (358, 359, '831730007300', '2026-08-28 22:56:01'), (359, 360, '745114131317', '2026-08-28 22:56:01'), (360, 361, '745114130716', '2026-08-28 22:56:01'), (361, 362, '745114130723', '2026-08-28 22:56:01'), (362, 363, '745114130617', '2026-08-28 22:56:01'), (363, 364, '745114130471', '2026-08-28 22:56:01'), (364, 365, '745114130495', '2026-08-28 22:56:01'), (365, 366, '745114130501', '2026-08-28 22:56:01'), (366, 367, '745114130037', '2026-08-28 22:56:01'), (367, 368, '745114130624', '2026-08-28 22:56:01'), (368, 369, '745114130006', '2026-08-28 22:56:01'), (369, 370, '745114130013', '2026-08-28 22:56:01'), (370, 371, '745114131324', '2026-08-28 22:56:01'), (371, 372, '745114136343', '2026-08-28 22:56:01'), (372, 373, '8941161101521', '2026-08-28 22:56:01'), (373, 374, '8941161101606', '2026-08-28 22:56:01'), (374, 375, '8946565147007', '2026-08-28 22:56:01'), (375, 376, '8946565138357', '2026-08-28 22:56:01'), (376, 377, '8941194003656', '2026-08-28 22:56:01'), (377, 378, '8941194002550', '2026-08-28 22:56:01'), (378, 379, '8941194005919', '2026-08-28 22:56:01'), (379, 380, '8949219643061', '2026-08-28 22:56:01'), (380, 381, '0', '2026-08-28 22:56:01'), (381, 382, '0', '2026-08-28 22:56:01'), (382, 383, '0', '2026-08-28 22:56:01'), (383, 384, '0', '2026-08-28 22:56:01'), (384, 385, '0', '2026-08-28 22:56:01'), (385, 386, '8944000555226', '2026-08-28 22:56:01'), (386, 387, '8944000555004', '2026-08-28 22:56:01'), (387, 388, '8941154031408', '2026-08-28 22:56:01'), (388, 389, '8941154031996', '2026-08-28 22:56:01'), (389, 390, '8941154031385', '2026-08-28 22:56:01'), (390, 391, '8941154033211', '2026-08-28 22:56:01'), (391, 392, '8941154031378', '2026-08-28 22:56:01'), (392, 393, '8941154031361', '2026-08-28 22:56:01'), (393, 394, '8941154030210', '2026-08-28 22:56:01'), (394, 395, '8941154030135', '2026-08-28 22:56:01'), (395, 396, '8941154030418', '2026-08-28 22:56:01'), (396, 397, '5711953039423', '2026-08-28 22:56:01'), (397, 398, '0', '2026-08-28 22:56:01'), (398, 399, '840205718917', '2026-08-28 22:56:01'), (399, 400, '831730006501', '2026-08-28 22:56:01'), (400, 401, '8941189604431', '2026-08-28 22:56:01'), (401, 402, '8941189604479', '2026-08-28 22:56:01'), (402, 403, '8941189604462', '2026-08-28 22:56:01'), (403, 404, '8941189604448', '2026-08-28 22:56:01'), (404, 405, '8941189604356', '2026-08-28 22:56:01'), (405, 406, '8941189600044', '2026-08-28 22:56:01'), (406, 407, '8941189600068', '2026-08-28 22:56:01'), (407, 408, '8941189600082', '2026-08-28 22:56:01'), (408, 409, '8941189600266', '2026-08-28 22:56:01'), (409, 410, '8941189600273', '2026-08-28 22:56:01'), (410, 411, '8941189600914', '2026-08-28 22:56:01'), (411, 412, '8941189601423', '2026-08-28 22:56:01'), (412, 413, '8941153056938', '2026-08-28 22:56:01'), (413, 414, '8941153056662', '2026-08-28 22:56:01'), (414, 415, '8941153056686', '2026-08-28 22:56:01'), (415, 416, '8941153057027', '2026-08-28 22:56:01'), (416, 417, '8941153056273', '2026-08-28 22:56:01'), (417, 418, '8941153056099', '2026-08-28 22:56:01'), (418, 419, '8941153056235', '2026-08-28 22:56:01'), (419, 420, '8941153056259', '2026-08-28 22:56:01'), (420, 421, '8941153055412', '2026-08-28 22:56:01'), (421, 422, '8941153055184', '2026-08-28 22:56:01'), (422, 423, '8941153055658', '2026-08-28 22:56:01'), (423, 424, '8941153055269', '2026-08-28 22:56:01'), (424, 425, '8941153056044', '2026-08-28 22:56:01'), (425, 426, '8941153056051', '2026-08-28 22:56:01'), (426, 427, '8941153054118', '2026-08-28 22:56:01'), (427, 428, '8941153056846', '2026-08-28 22:56:01'), (428, 429, '8941153055160', '2026-08-28 22:56:01'), (429, 430, '8941153055153', '2026-08-28 22:56:01'), (430, 431, '8941153400595', '2026-08-28 22:56:01'), (431, 432, '8941153400571', '2026-08-28 22:56:01'), (432, 433, '8941193100028', '2026-08-28 22:56:01'), (433, 434, '8941193100035', '2026-08-28 22:56:01'), (434, 435, '8941193105320', '2026-08-28 22:56:01'), (435, 436, '8941193105337', '2026-08-28 22:56:01'), (436, 437, '0', '2026-08-28 22:56:01'), (437, 438, '8941193105214', '2026-08-28 22:56:01'), (438, 439, '8941193105221', '2026-08-28 22:56:01'), (439, 440, '8941161007557', '2026-08-28 22:56:01'), (440, 441, '8941193073148', '2026-08-28 22:56:01'), (441, 442, '8941193041116', '2026-08-28 22:56:01'), (442, 443, '8941193067024', '2026-08-28 22:56:01'), (443, 444, '8941193067017', '2026-08-28 22:56:01'), (444, 445, '8941193071618', '2026-08-28 22:56:01'), (445, 446, '8941161004969', '2026-08-28 22:56:01'), (446, 447, '8941161004914', '2026-08-28 22:56:01'), (447, 448, '0', '2026-08-28 22:56:01'), (448, 449, '8941105203496', '2026-08-28 22:56:01'), (449, 450, '0', '2026-08-28 22:56:01'), (450, 451, '8944220152182', '2026-08-28 22:56:01'), (451, 452, '8944220152199', '2026-08-28 22:56:01'), (452, 453, '8944220152205', '2026-08-28 22:56:01'), (453, 454, '8944220152212', '2026-08-28 22:56:01'), (454, 455, '8944220152229', '2026-08-28 22:56:01'), (455, 456, '8944220152175', '2026-08-28 22:56:01'), (456, 457, '0', '2026-08-28 22:56:01'), (457, 458, '0', '2026-08-28 22:56:01'), (458, 459, '0', '2026-08-28 22:56:01'), (459, 460, '0', '2026-08-28 22:56:01'), (460, 461, '8944220152137', '2026-08-28 22:56:01'), (461, 462, '8944220152120', '2026-08-28 22:56:01'), (462, 463, '8944220152113', '2026-08-28 22:56:01'), (463, 464, '8907525000213', '2026-08-28 22:56:01'), (464, 465, '8941153500073', '2026-08-28 22:56:01'), (465, 466, '8941153500066', '2026-08-28 22:56:01'), (466, 467, '3885522502006', '2026-08-28 22:56:01'), (467, 468, '8941153500226', '2026-08-28 22:56:01'), (468, 469, '0', '2026-08-28 22:56:01'), (469, 470, '0', '2026-08-28 22:56:01'), (470, 471, '8941161113050', '2026-08-28 22:56:01'), (471, 472, '8941161113036', '2026-08-28 22:56:01'), (472, 473, '8941161113029', '2026-08-28 22:56:01'), (473, 474, '8941161110059', '2026-08-28 22:56:01'), (474, 475, '8941161110011', '2026-08-28 22:56:01'), (475, 476, '8941161110028', '2026-08-28 22:56:01'), (476, 477, '8941161110073', '2026-08-28 22:56:01'), (477, 478, '831730009755', '2026-08-28 22:56:01'), (478, 479, '831730009489', '2026-08-28 22:56:01'), (479, 480, '846656010945', '2026-08-28 22:56:01'), (480, 481, '8941189609252', '2026-08-28 22:56:01'), (481, 482, '8941100313824', '2026-08-28 22:56:01'), (482, 483, '8941100318461', '2026-08-28 22:56:01'), (483, 484, '8941100318416', '2026-08-28 22:56:01'), (484, 485, '8941100314418', '2026-08-28 22:56:01'), (485, 486, '8941100315408', '2026-08-28 22:56:01'), (486, 487, '841165104581', '2026-08-28 22:56:01'), (487, 488, '846656019733', '2026-08-28 22:56:01'); -- -------------------------------------------------------- -- -- Table structure for table `product_settings` -- CREATE TABLE `product_settings` ( `id` int(11) NOT NULL, `company_id` int(11) NOT NULL, `unique_product_by` enum('product_name','part_number') NOT NULL DEFAULT 'product_name', `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; -- -- Dumping data for table `product_settings` -- INSERT INTO `product_settings` (`id`, `company_id`, `unique_product_by`, `created_at`, `updated_at`) VALUES (1, 1, 'product_name', '2026-08-24 09:12:35', '2026-08-24 09:12:35'); -- -------------------------------------------------------- -- -- Table structure for table `profile` -- CREATE TABLE `profile` ( `E_ID` int(11) NOT NULL, `Staff_Id` varchar(20) DEFAULT NULL, `Name` varchar(30) DEFAULT NULL, `Father_Name` varchar(30) DEFAULT NULL, `Mother_Name` varchar(30) DEFAULT NULL, `Brith_Date` varchar(12) DEFAULT NULL, `Gender` varchar(20) DEFAULT NULL, `Emargency_Contact` varchar(30) DEFAULT NULL, `Mobile_No` varchar(15) DEFAULT NULL, `Email_Address` varchar(30) DEFAULT NULL, `Freedom_Fighter` varchar(30) DEFAULT NULL, `Marital_Status` varchar(12) DEFAULT NULL, `Spouse_Name` varchar(30) DEFAULT NULL, `Nationality` varchar(15) DEFAULT NULL, `National_IDNO` varchar(100) DEFAULT NULL, `Permanant_Address` varchar(100) DEFAULT NULL, `Present_Address` varchar(50) DEFAULT NULL, `Exam_SSC` varchar(15) DEFAULT NULL, `Institute_Board_SSC` varchar(150) DEFAULT NULL, `Board_ssc` varchar(255) DEFAULT NULL, `Group_SSC` varchar(15) DEFAULT NULL, `Result_SSC` varchar(15) DEFAULT NULL, `Passing_Year_SSC` varchar(5) DEFAULT NULL, `Result_type` varchar(12) DEFAULT NULL, `Exam_HSC` varchar(15) DEFAULT NULL, `Institue_Board_HSC` varchar(150) DEFAULT NULL, `Board_hsc` varchar(255) DEFAULT NULL, `Group_HSC` varchar(15) DEFAULT NULL, `Result_HSC` varchar(15) DEFAULT NULL, `Passing_Year_HSC` varchar(5) DEFAULT NULL, `Result_type_HSC` varchar(12) DEFAULT NULL, `Exam_Hons` varchar(15) DEFAULT NULL, `Institute_Board_Hons` varchar(150) DEFAULT NULL, `Board_hons` varchar(255) DEFAULT NULL, `Degree_Hons` varchar(15) DEFAULT NULL, `Result_Hons` varchar(15) DEFAULT NULL, `Pussing_Year_Hons` varchar(5) DEFAULT NULL, `Result_type_Hons` varchar(12) DEFAULT NULL, `Exam_Mas` varchar(15) DEFAULT NULL, `Institute_Board_Mas` varchar(150) DEFAULT NULL, `Board_mas` varchar(255) DEFAULT NULL, `Subject_Mas` varchar(15) DEFAULT NULL, `Result_Mas` varchar(15) DEFAULT NULL, `Passing_Year_Mas` varchar(5) DEFAULT NULL, `Result_type_Mas` varchar(12) DEFAULT NULL, `Training_Name` varchar(30) DEFAULT NULL, `Training_Topic` varchar(30) DEFAULT NULL, `Training_Instute` varchar(30) DEFAULT NULL, `Training_Year` varchar(15) DEFAULT NULL, `Training_Duration` varchar(20) DEFAULT NULL, `Signature` varchar(50) DEFAULT NULL, `Picture` varchar(50) DEFAULT NULL, `Religion` varchar(11) DEFAULT NULL, `Joining_Date` varchar(20) DEFAULT NULL, `Department` varchar(50) DEFAULT NULL, `Designation` varchar(50) DEFAULT NULL, `monthly_salary` int(11) DEFAULT NULL, `Mobile_Bill` int(11) DEFAULT NULL, `Salary_Status` varchar(255) DEFAULT NULL, `Attend_Status` varchar(50) DEFAULT NULL, `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `purchases` -- CREATE TABLE `purchases` ( `id` int(11) NOT NULL, `date` date NOT NULL, `purchase_no` int(11) DEFAULT NULL, `sup_id` int(11) DEFAULT NULL, `bill_ref` varchar(100) DEFAULT NULL, `product_subtotal` decimal(10,2) DEFAULT 0.00, `product_discount` decimal(10,2) DEFAULT 0.00, `product_vat_percent` decimal(10,2) DEFAULT 0.00, `product_total` decimal(10,2) DEFAULT 0.00, `service_subtotal` decimal(10,2) DEFAULT 0.00, `service_discount` decimal(10,2) DEFAULT 0.00, `service_vat_percent` decimal(10,2) DEFAULT 0.00, `service_total` decimal(10,2) DEFAULT 0.00, `product_vat` decimal(10,2) DEFAULT 0.00, `service_vat` decimal(10,2) DEFAULT 0.00, `grand_total` decimal(10,2) DEFAULT 0.00, `paid` decimal(10,2) NOT NULL DEFAULT 0.00, `due` decimal(10,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `purchases` -- INSERT INTO `purchases` (`id`, `date`, `purchase_no`, `sup_id`, `bill_ref`, `product_subtotal`, `product_discount`, `product_vat_percent`, `product_total`, `service_subtotal`, `service_discount`, `service_vat_percent`, `service_total`, `product_vat`, `service_vat`, `grand_total`, `paid`, `due`, `created_at`) VALUES (1, '2026-08-28', 1, 102, '', 45.00, 0.00, 0.00, 45.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 45.00, 45.00, 0.00, '2026-08-28 15:52:22'), (2, '2026-08-28', 2, 102, '', 70.00, 0.00, 0.00, 70.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 70.00, 0.00, 70.00, '2026-08-28 18:23:06'); -- -------------------------------------------------------- -- -- Table structure for table `purchase_items` -- CREATE TABLE `purchase_items` ( `id` int(11) NOT NULL, `purchase_id` int(11) DEFAULT NULL, `item_type` varchar(50) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `item_name` text DEFAULT NULL, `qty` decimal(12,2) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `cost_price` decimal(12,2) DEFAULT NULL, `total` decimal(12,2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `purchase_items` -- INSERT INTO `purchase_items` (`id`, `purchase_id`, `item_type`, `product_id`, `item_name`, `qty`, `unit`, `cost_price`, `total`) VALUES (1, 1, 'product', 16, NULL, 1.00, 'Pcs', 45.00, 45.00), (2, 2, 'product', 17, NULL, 1.00, 'Kg', 70.00, 70.00); -- -------------------------------------------------------- -- -- Table structure for table `purchase_returns` -- CREATE TABLE `purchase_returns` ( `id` int(11) NOT NULL, `return_no` int(11) NOT NULL, `return_date` date NOT NULL, `purchase_id` int(11) NOT NULL, `supplier_id` int(11) NOT NULL, `total_amount` decimal(18,2) DEFAULT 0.00, `remarks` text DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `purchase_returns` -- INSERT INTO `purchase_returns` (`id`, `return_no`, `return_date`, `purchase_id`, `supplier_id`, `total_amount`, `remarks`, `created_by`, `created_at`) VALUES (8, 1, '2026-07-12', 1, 11, 4600.00, '', NULL, '2026-07-12 10:01:42'); -- -------------------------------------------------------- -- -- Table structure for table `purchase_return_items` -- CREATE TABLE `purchase_return_items` ( `id` int(11) NOT NULL, `return_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `qty` decimal(12,2) DEFAULT 0.00, `unit` varchar(50) DEFAULT NULL, `rate` decimal(12,2) DEFAULT 0.00, `total` decimal(18,2) DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `purchase_return_items` -- INSERT INTO `purchase_return_items` (`id`, `return_id`, `product_id`, `qty`, `unit`, `rate`, `total`) VALUES (30, 8, 1, 2.00, 'Pcs', 500.00, 1000.00), (31, 8, 2, 3.00, 'Pcs', 1200.00, 3600.00); -- -------------------------------------------------------- -- -- Table structure for table `quotations` -- CREATE TABLE `quotations` ( `id` int(11) NOT NULL, `date` date NOT NULL, `quotation_no` varchar(50) DEFAULT NULL, `cus_serial` int(11) DEFAULT NULL, `customer_name` varchar(100) DEFAULT NULL, `customer_referance` varchar(50) DEFAULT NULL, `customer_phone` varchar(50) DEFAULT NULL, `customer_address` text DEFAULT NULL, `address_to` varchar(100) DEFAULT NULL, `attention_to` varchar(100) DEFAULT NULL, `attention_desig` varchar(50) DEFAULT NULL, `subject` text DEFAULT NULL, `message` text DEFAULT NULL, `subtotal` decimal(10,2) DEFAULT 0.00, `grand_total` decimal(10,2) DEFAULT 0.00, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `product_subtotal` decimal(10,2) DEFAULT 0.00, `product_discount` decimal(10,2) DEFAULT 0.00, `product_vat_percent` decimal(10,2) DEFAULT 0.00, `product_total` decimal(10,2) DEFAULT 0.00, `service_subtotal` decimal(10,2) DEFAULT 0.00, `service_discount` decimal(10,2) DEFAULT 0.00, `service_vat_percent` decimal(10,2) DEFAULT 0.00, `service_total` decimal(10,2) DEFAULT 0.00, `product_vat` decimal(10,2) DEFAULT 0.00, `service_vat` decimal(10,2) DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `quotations` -- INSERT INTO `quotations` (`id`, `date`, `quotation_no`, `cus_serial`, `customer_name`, `customer_referance`, `customer_phone`, `customer_address`, `address_to`, `attention_to`, `attention_desig`, `subject`, `message`, `subtotal`, `grand_total`, `created_at`, `product_subtotal`, `product_discount`, `product_vat_percent`, `product_total`, `service_subtotal`, `service_discount`, `service_vat_percent`, `service_total`, `product_vat`, `service_vat`) VALUES (1, '2026-05-20', 'QTN-1', 11, ' Popular Pharmaceutical Ltd. ', 'PPL', '', '17 Shukrabad, West Panthopath, Dhaka - 1207, Bangladesh', 'Managing Director', 'Mr. Kamal Uddin', 'Area Manager', 'Final Test for Quotation', 'Dear Sir,\r\nWe would like to express our sincere gratitude for giving us an opportunity to quote for the mentioned as per your requirement & are pleased to submit herewith our Technical Proposal for the same for your kind perusal. Prices are quoted in BDT and are subject to change without prior notice unless confirmed', 8581.08, 8581.08, '2026-05-20 02:16:28', 6564.00, 62.00, 10.00, 7152.20, 1417.50, 175.00, 15.00, 1428.88, 650.20, 186.38), (2, '2026-05-21', 'QTN-2', 21, 'Apical Industrial Solution & Technology', 'AIST', '', 'House# 01 (4th Floor), Flat # 5B, Road# 07 (Avenue 05), Block# F, Banasree, Dhaka 1219', 'Managing Director', 'Mr. Kamal', 'Dpt. Manager', 'Test', 'Dear Sir,\r\nWe would like to express our sincere gratitude for giving us an opportunity to quote for the mentioned as per your requirement & are pleased to submit herewith our Technical Proposal for the same for your kind perusal. Prices are quoted in BDT and are subject to change without prior notice unless confirmed', 12531.75, 12531.75, '2026-05-21 00:04:08', 11392.50, 0.00, 10.00, 12531.75, 0.00, 0.00, 0.00, 0.00, 1139.25, 0.00), (3, '2026-05-21', 'QTN-3', 16, 'C.P. Bangladesh Co., Ltd. (Food Savar)', 'CPBL', '', 'Rishipara, Hemayetpur, Savar, Bangladesh.', 'Managing Director', 'Mr. Kamal Uddin', 'Dpt. Manager', 'Automation Spare Parts', 'Dear Sir,\r\nWe would like to express our sincere gratitude for giving us an opportunity to quote for the mentioned as per your requirement & are pleased to submit herewith our Technical Proposal for the same for your kind perusal. Prices are quoted in BDT and are subject to change without prior notice unless confirmed', 23100.00, 23100.00, '2026-05-21 11:12:22', 21000.00, 0.00, 10.00, 23100.00, 0.00, 0.00, 0.00, 0.00, 2100.00, 0.00), (4, '2026-05-24', 'QTN-20260524141843568', 0, '', NULL, '', NULL, 'Managing Director', 'Mr. Kamal', 'Dpt. Manager', '', 'Dear Sir,\r\nWe would like to express our sincere gratitude for giving us an opportunity to quote for the mentioned as per your requirement & are pleased to submit herewith our Technical Proposal for the same for your kind perusal. Prices are quoted in BDT and are subject to change without prior notice unless confirmed', 0.00, 1050.00, '2026-05-24 14:18:43', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00), (5, '2026-05-24', 'QTN-20260524141843569', 11, ' Popular Pharmaceutical Ltd. ', 'PPL', '', '17 Shukrabad, West Panthopath, Dhaka - 1207, Bangladesh', 'Managing Director', 'Mr. Kamal', 'Dpt. Manager', '', 'Dear Sir,\r\nWe would like to express our sincere gratitude for giving us an opportunity to quote for the mentioned as per your requirement & are pleased to submit herewith our Technical Proposal for the same for your kind perusal. Prices are quoted in BDT and are subject to change without prior notice unless confirmed', 5248.95, 5248.95, '2026-05-24 16:14:04', 4772.25, 0.00, 0.00, 4772.25, 476.70, 0.00, 0.00, 476.70, 0.00, 0.00), (6, '2026-05-24', 'QTN-20260524161533819', 0, '', NULL, '', NULL, 'Managing Director', 'Mr. Kamal', 'Dpt. Manager', '', 'Dear Sir,\r\nWe would like to express our sincere gratitude for giving us an opportunity to quote for the mentioned as per your requirement & are pleased to submit herewith our Technical Proposal for the same for your kind perusal. Prices are quoted in BDT and are subject to change without prior notice unless confirmed', 0.00, 1048.95, '2026-05-24 16:15:33', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00), (7, '2026-05-24', 'QTN-20260524162044949', 0, '', NULL, '', NULL, '', '', '', '', 'Dear Sir,\r\nWe would like to express our sincere gratitude for giving us an opportunity to quote for the mentioned as per your requirement & are pleased to submit herewith our Technical Proposal for the same for your kind perusal. Prices are quoted in BDT and are subject to change without prior notice unless confirmed', 0.00, 515.00, '2026-05-24 16:20:44', 0.00, 10.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00), (8, '2026-05-24', 'QTN-20260524163124548', 0, '', NULL, '', NULL, '', '', '', '', 'Dear Sir,\r\nWe would like to express our sincere gratitude for giving us an opportunity to quote for the mentioned as per your requirement & are pleased to submit herewith our Technical Proposal for the same for your kind perusal. Prices are quoted in BDT and are subject to change without prior notice unless confirmed', 0.00, 525.00, '2026-05-24 16:31:24', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00); -- -------------------------------------------------------- -- -- Table structure for table `quotation_items` -- CREATE TABLE `quotation_items` ( `id` int(11) NOT NULL, `quotation_id` int(11) DEFAULT NULL, `item_type` varchar(20) DEFAULT NULL, `item_name` text DEFAULT NULL, `qty` decimal(10,2) DEFAULT NULL, `unit` varchar(20) DEFAULT NULL, `prate` decimal(10,2) DEFAULT NULL, `ait` decimal(10,2) DEFAULT NULL, `price` decimal(10,2) DEFAULT 0.00, `total` decimal(10,2) DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `quotation_items` -- INSERT INTO `quotation_items` (`id`, `quotation_id`, `item_type`, `item_name`, `qty`, `unit`, `prate`, `ait`, `price`, `total`) VALUES (23, 2, 'product', 'Product', 7.00, 'Pcs', 1550.00, 5.00, 1627.50, 11392.50), (44, 1, 'product', 'Product 1', 2.00, 'Pcs', 500.00, 5.00, 525.00, 1050.00), (45, 1, 'product', 'Product 2', 1.00, 'Pcs', 3000.00, 5.00, 3150.00, 3150.00), (46, 1, 'product', 'Product 3', 3.00, 'Pcs', 750.00, 5.00, 788.00, 2364.00), (47, 1, 'service', 'Service', 1.00, 'Job', 1350.00, 5.00, 1417.50, 1417.50), (54, 3, 'product', 'Delta HMI\r\nModel: DOP 107BV\r\nBrand: Delta\r\nMade in China', 2.00, 'Pcs', 10000.00, 5.00, 10500.00, 21000.00), (55, 4, 'product', 'dfsdf', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00), (56, 4, 'product', 'dsfsdfsdf', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00), (57, 5, 'product', 'dsfsdf', 1.00, 'Pcs', 4545.00, 5.00, 4772.25, 4772.25), (58, 5, 'service', 'sdfsdf', 1.00, 'Job', 454.00, 5.00, 476.70, 476.70), (59, 6, 'product', 'df', 1.00, 'Pcs', 545.00, 5.00, 572.25, 572.25), (60, 6, 'service', 'dfd', 1.00, 'Job', 454.00, 5.00, 476.70, 476.70), (61, 7, 'product', 'dsfsd', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00), (62, 8, 'product', 'dsfsd', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00), (63, 9, 'product', '', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00); -- -------------------------------------------------------- -- -- Table structure for table `quotation_terms` -- CREATE TABLE `quotation_terms` ( `id` int(11) NOT NULL, `quotation_id` int(11) DEFAULT NULL, `item_type` varchar(50) NOT NULL DEFAULT 'terms', `item_terms` varchar(20) DEFAULT NULL, `item_name` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `quotation_terms` -- INSERT INTO `quotation_terms` (`id`, `quotation_id`, `item_type`, `item_terms`, `item_name`) VALUES (51, 1, 'terms', 'Price & VAT', 'Quoted price is in local currency (VAT & TAX excluded)'), (52, 1, 'terms', 'Payment', '70% advance with work order rest of 30% after successfully delivery goods.'), (53, 1, 'terms', 'Delivery', '06 day working days from date of work order'), (54, 1, 'terms', 'Offer time ', '15 days from the date of this offer.'), (55, 1, 'terms', 'Warranty', '12 Months warranty except burn and physical broken issues'), (86, 3, 'terms', 'Price & VAT', 'Quoted price is in local currency (VAT & TAX included)'), (87, 3, 'terms', 'Payment', '70% advance with work order rest of 30% after successfully delivery goods.'), (88, 3, 'terms', 'Delivery', '01 day working days from date of work order'), (89, 3, 'terms', 'Offer time ', '15 days from the date of this offer.'), (90, 5, 'terms', 'Price & VAT', 'Quoted price is in local currency (VAT & TAX excluded)'), (91, 5, 'terms', 'Payment', '70% advance with work order rest of 30% after successfully delivery goods.'), (92, 5, 'terms', 'Delivery', '06 day working days from date of work order'), (93, 5, 'terms', 'Offer time ', '15 days from the date of this offer.'), (94, 5, 'terms', 'Warranty', '12 Months warranty except burn and physical broken issues'), (95, 9, 'terms', 'Price & VAT', 'Quoted price is in local currency (VAT & TAX excluded)'), (96, 9, 'terms', 'Payment', '70% advance with work order rest of 30% after successfully delivery goods.'), (97, 9, 'terms', 'Delivery', '06 day working days from date of work order'), (98, 9, 'terms', 'Offer time ', '15 days from the date of this offer.'), (99, 9, 'terms', 'Warranty', '12 Months warranty except burn and physical broken issues'); -- -------------------------------------------------------- -- -- Table structure for table `role` -- CREATE TABLE `role` ( `role_rolecode` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `role` -- INSERT INTO `role` (`role_rolecode`) VALUES ('Accounts'), ('admin'), ('Dealer / Customer'), ('Manager'), ('super admin'); -- -------------------------------------------------------- -- -- Table structure for table `role_rights` -- CREATE TABLE `role_rights` ( `rr_rolecode` varchar(50) NOT NULL, `rr_modulecode` varchar(25) NOT NULL, `receive` enum('yes','no') NOT NULL DEFAULT 'no', `payment` enum('yes','no') NOT NULL DEFAULT 'no', `journal` enum('yes','no') NOT NULL DEFAULT 'no', `dbook` enum('yes','no') NOT NULL DEFAULT 'no', `cashbank` enum('yes','no') NOT NULL DEFAULT 'no', `allladger` enum('yes','no') NOT NULL DEFAULT 'no', `tl` enum('yes','no') NOT NULL DEFAULT 'no', `pl` enum('yes','no') NOT NULL DEFAULT 'no', `bl` enum('yes','no') NOT NULL DEFAULT 'no', `preceive` enum('yes','no') NOT NULL DEFAULT 'no', `pissue` enum('yes','no') NOT NULL DEFAULT 'no', `requisition` enum('yes','no') NOT NULL DEFAULT 'no', `ssumary` enum('yes','no') NOT NULL DEFAULT 'no', `gsumary` enum('yes','no') NOT NULL DEFAULT 'no', `iv` enum('yes','no') NOT NULL DEFAULT 'no', `salaryst` enum('yes','no') NOT NULL DEFAULT 'no', `pladger` enum('yes','no') NOT NULL DEFAULT 'no', `spayable` enum('yes','no') NOT NULL DEFAULT 'no', `asalary` enum('yes','no') NOT NULL DEFAULT 'no', `rsalary` enum('yes','no') NOT NULL DEFAULT 'no', `others` enum('yes','no') NOT NULL DEFAULT 'no', `cu` enum('yes','no') NOT NULL DEFAULT 'no', `ca` enum('yes','no') NOT NULL DEFAULT 'no', `ce` enum('yes','no') NOT NULL DEFAULT 'no', `rr_edit` enum('yes','no') NOT NULL DEFAULT 'no', `rr_delete` enum('yes','no') NOT NULL DEFAULT 'no', `rr_view` enum('yes','no') NOT NULL DEFAULT 'no', `Dealer` enum('yes','no') NOT NULL DEFAULT 'no' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `sales` -- CREATE TABLE `sales` ( `id` int(11) NOT NULL, `date` date NOT NULL, `sale_no` int(11) NOT NULL, `company_id` int(11) NOT NULL DEFAULT 1, `branch_id` int(11) NOT NULL DEFAULT 1, `customer_id` int(11) NOT NULL, `product_subtotal` decimal(12,2) DEFAULT NULL, `product_discount` decimal(18,2) NOT NULL DEFAULT 0.00, `product_vat_percent` decimal(10,2) NOT NULL DEFAULT 0.00, `product_vat` decimal(18,2) NOT NULL DEFAULT 0.00, `grand_total` decimal(18,2) NOT NULL DEFAULT 0.00, `paid` decimal(18,2) NOT NULL DEFAULT 0.00, `due` decimal(18,2) NOT NULL DEFAULT 0.00, `change_amount` decimal(18,2) NOT NULL DEFAULT 0.00, `invoice_status` enum('Due','Paid','Cancelled') NOT NULL DEFAULT 'Due', `remarks` text DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `sales` -- INSERT INTO `sales` (`id`, `date`, `sale_no`, `company_id`, `branch_id`, `customer_id`, `product_subtotal`, `product_discount`, `product_vat_percent`, `product_vat`, `grand_total`, `paid`, `due`, `change_amount`, `invoice_status`, `remarks`, `created_by`, `created_at`) VALUES (1, '2026-08-28', 1, 1, 1, 0, 50.00, 0.00, 5.00, 2.50, 52.50, 52.50, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-28 15:53:09'), (2, '2026-08-28', 2, 1, 1, 104, 75.00, 0.00, 0.00, 0.00, 75.00, 0.00, 75.00, 0.00, 'Due', NULL, 101, '2026-08-28 18:23:18'); -- -------------------------------------------------------- -- -- Table structure for table `sales_invoices` -- CREATE TABLE `sales_invoices` ( `id` int(11) NOT NULL, `invoice_no` int(11) NOT NULL, `invoice_date` date NOT NULL, `company_id` int(11) DEFAULT NULL, `branch_id` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `product_subtotal` decimal(18,2) NOT NULL DEFAULT 0.00, `product_discount` decimal(18,2) NOT NULL DEFAULT 0.00, `product_vat_percent` decimal(10,2) NOT NULL DEFAULT 0.00, `product_vat` decimal(18,2) NOT NULL DEFAULT 0.00, `product_total` decimal(18,2) NOT NULL DEFAULT 0.00, `service_subtotal` decimal(18,2) NOT NULL DEFAULT 0.00, `service_discount` decimal(18,2) NOT NULL DEFAULT 0.00, `service_vat_percent` decimal(10,2) NOT NULL DEFAULT 0.00, `service_vat` decimal(18,2) NOT NULL DEFAULT 0.00, `service_total` decimal(18,2) NOT NULL DEFAULT 0.00, `grand_total` decimal(18,2) NOT NULL DEFAULT 0.00, `remarks` text DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sales_invoices` -- INSERT INTO `sales_invoices` (`id`, `invoice_no`, `invoice_date`, `company_id`, `branch_id`, `customer_id`, `product_subtotal`, `product_discount`, `product_vat_percent`, `product_vat`, `product_total`, `service_subtotal`, `service_discount`, `service_vat_percent`, `service_vat`, `service_total`, `grand_total`, `remarks`, `created_by`, `created_at`) VALUES (1, 1, '2026-07-28', 1, 1, 11, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 05:24:21'), (2, 2, '2026-07-28', 1, 1, 1, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 07:59:23'), (3, 3, '2026-07-28', 1, 1, 2, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 08:01:22'), (4, 4, '2026-07-28', 1, 1, 1, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 08:19:33'), (5, 5, '2026-07-28', 1, 1, 31, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 08:23:50'), (6, 6, '2026-07-28', 1, 1, 21, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 08:36:33'); -- -------------------------------------------------------- -- -- Table structure for table `sales_invoice_items` -- CREATE TABLE `sales_invoice_items` ( `id` int(11) NOT NULL, `invoice_id` int(11) NOT NULL, `sale_id` int(11) NOT NULL, `item_type` enum('product','service') NOT NULL, `product_id` int(11) DEFAULT NULL, `item_name` text DEFAULT NULL, `qty` decimal(12,2) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `rate` decimal(12,2) DEFAULT NULL, `amount` decimal(18,2) DEFAULT NULL, `cost_rate` decimal(12,2) NOT NULL DEFAULT 0.00, `cost_amount` decimal(18,2) NOT NULL DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sales_items` -- CREATE TABLE `sales_items` ( `id` int(11) NOT NULL, `sale_id` int(11) DEFAULT NULL, `item_type` enum('product','service') NOT NULL, `product_id` int(11) DEFAULT NULL, `item_name` text DEFAULT NULL, `qty` decimal(12,2) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `rate` decimal(12,2) DEFAULT NULL, `amount` decimal(18,2) DEFAULT NULL, `cost_rate` decimal(12,2) NOT NULL DEFAULT 0.00, `cost_amount` decimal(18,2) NOT NULL DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sales_items` -- INSERT INTO `sales_items` (`id`, `sale_id`, `item_type`, `product_id`, `item_name`, `qty`, `unit`, `rate`, `amount`, `cost_rate`, `cost_amount`) VALUES (1, 1, 'product', 16, 'Chocolate', 1.00, 'Pcs', 50.00, 50.00, 0.00, 0.00), (2, 2, 'product', 17, 'Kararibog Rice', 1.00, 'Kg', 75.00, 75.00, 0.00, 0.00); -- -------------------------------------------------------- -- -- Table structure for table `stock_ledger` -- CREATE TABLE `stock_ledger` ( `id` bigint(20) NOT NULL, `company_id` int(11) DEFAULT NULL, `branch_id` int(11) DEFAULT NULL, `date` date NOT NULL, `transaction_type` varchar(50) NOT NULL, `reference_table` varchar(50) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `voucher_no` varchar(50) DEFAULT NULL, `warehouse_id` int(11) DEFAULT NULL, `product_id` int(11) NOT NULL, `stock_in` decimal(12,2) DEFAULT 0.00, `stock_out` decimal(12,2) DEFAULT 0.00, `balance_qty` decimal(12,2) DEFAULT 0.00, `unit_cost` decimal(12,2) DEFAULT 0.00, `total_cost` decimal(12,2) DEFAULT 0.00, `avg_cost` decimal(12,2) DEFAULT NULL, `sale_price` decimal(12,2) DEFAULT NULL, `remarks` varchar(255) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `sequence_no` bigint(20) DEFAULT NULL, `ref_uid` varchar(50) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `is_reversal` tinyint(4) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `stock_ledger` -- INSERT INTO `stock_ledger` (`id`, `company_id`, `branch_id`, `date`, `transaction_type`, `reference_table`, `reference_id`, `voucher_no`, `warehouse_id`, `product_id`, `stock_in`, `stock_out`, `balance_qty`, `unit_cost`, `total_cost`, `avg_cost`, `sale_price`, `remarks`, `created_by`, `created_at`, `sequence_no`, `ref_uid`, `parent_id`, `is_reversal`) VALUES (1, 1, 1, '2026-08-28', 'PURCHASE', 'purchases', 1, '1', 1, 16, 1.00, 0.00, 1.00, 45.00, 45.00, 45.00, NULL, 'Purchase Stock In', 101, '2026-08-28 15:52:22', NULL, NULL, NULL, 0), (2, 1, 1, '2026-08-28', 'ISSUE', 'sales', 1, '1', 1, 16, 0.00, 1.00, 0.00, 45.00, 45.00, 45.00, 50.00, 'Sales Issue', 101, '2026-08-28 15:53:09', NULL, NULL, NULL, 0), (3, 1, 1, '2026-08-28', 'PURCHASE', 'purchases', 2, '2', 1, 17, 1.00, 0.00, 1.00, 70.00, 70.00, 70.00, NULL, 'Purchase Stock In', 101, '2026-08-28 18:23:06', NULL, NULL, NULL, 0), (4, 1, 1, '2026-08-28', 'ISSUE', 'sales', 2, '2', 1, 17, 0.00, 1.00, 0.00, 70.00, 70.00, 70.00, 75.00, 'Sales Issue', 101, '2026-08-28 18:23:18', NULL, NULL, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `suppliers` -- CREATE TABLE `suppliers` ( `id` int(11) NOT NULL, `supplier_name` varchar(255) NOT NULL, `mobile` varchar(50) DEFAULT NULL, `address` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `suppliers` -- INSERT INTO `suppliers` (`id`, `supplier_name`, `mobile`, `address`) VALUES (1, 'Supplier Enterprise', '01990439132', 'Dhaka, Bangladesh'), (2, 'Supplier Link', '01971211258', 'Chattrogram, Bangladesh'); -- -------------------------------------------------------- -- -- Table structure for table `system_users` -- CREATE TABLE `system_users` ( `u_userid` int(11) NOT NULL, `u_username` varchar(100) NOT NULL, `u_password` varchar(255) NOT NULL, `User_Name` varchar(50) NOT NULL, `Designation` varchar(50) NOT NULL, `Employee_ID` varchar(50) NOT NULL, `Email` varchar(50) NOT NULL, `u_rolecode` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `system_users` -- INSERT INTO `system_users` (`u_userid`, `u_username`, `u_password`, `User_Name`, `Designation`, `Employee_ID`, `Email`, `u_rolecode`) VALUES (1, 'superuser', '$2y$10$qYs5SDSAqT5f0kteIHQfOOCT7PpCLjTTpMA/8N1ELDqIy6ISRk9uW', '', '', '101', '', 'admin'), (7, 'khan', '$2y$10$qYs5SDSAqT5f0kteIHQfOOCT7PpCLjTTpMA/8N1ELDqIy6ISRk9uW', 'Khan', 'Founder and CEO', '1', 'khan@yourmail.com', 'admin'); -- -- Indexes for dumped tables -- -- -- Indexes for table `account_chart` -- ALTER TABLE `account_chart` ADD PRIMARY KEY (`AccCode`); -- -- Indexes for table `account_types` -- ALTER TABLE `account_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `audit_logs` -- ALTER TABLE `audit_logs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banks` -- ALTER TABLE `banks` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_bank_name` (`bank_name`); -- -- Indexes for table `bank_accounts` -- ALTER TABLE `bank_accounts` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uk_account_no` (`account_no`), ADD KEY `idx_account_chart_code` (`account_chart_code`), ADD KEY `idx_status` (`status`); -- -- Indexes for table `bill_ledger` -- ALTER TABLE `bill_ledger` ADD PRIMARY KEY (`id`); -- -- Indexes for table `chart_of_accounts` -- ALTER TABLE `chart_of_accounts` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `account_code` (`account_code`), ADD KEY `account_type_id` (`account_type_id`), ADD KEY `parent_id` (`parent_id`), ADD KEY `account_code_2` (`account_code`); -- -- Indexes for table `company` -- ALTER TABLE `company` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `general_ledger` -- ALTER TABLE `general_ledger` ADD PRIMARY KEY (`id`); -- -- Indexes for table `journal_entries` -- ALTER TABLE `journal_entries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `journal_items` -- ALTER TABLE `journal_items` ADD PRIMARY KEY (`id`), ADD KEY `journal_entry_id` (`journal_entry_id`), ADD KEY `party_id` (`party_id`), ADD KEY `account_id` (`account_id`,`party_id`); -- -- Indexes for table `main_chart` -- ALTER TABLE `main_chart` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `mobile_banking_accounts` -- ALTER TABLE `mobile_banking_accounts` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uk_mobile_number` (`mobile_number`), ADD KEY `idx_account_chart_code` (`account_chart_code`), ADD KEY `idx_mobile_banking_type` (`mobile_banking_type`), ADD KEY `idx_status` (`status`); -- -- Indexes for table `module` -- ALTER TABLE `module` ADD PRIMARY KEY (`mod_modulegroupcode`,`mod_modulecode`), ADD UNIQUE KEY `mod_modulecode` (`mod_modulecode`); -- -- Indexes for table `parties` -- ALTER TABLE `parties` ADD PRIMARY KEY (`id`), ADD KEY `receivable_account_id` (`receivable_account_id`), ADD KEY `payable_account_id` (`payable_account_id`); -- -- Indexes for table `payment_vouchers` -- ALTER TABLE `payment_vouchers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_payment_voucher_no` (`voucher_no`), ADD KEY `idx_payment_account` (`account_code`), ADD KEY `idx_payment_date` (`payment_date`); -- -- Indexes for table `payment_voucher_items` -- ALTER TABLE `payment_voucher_items` ADD PRIMARY KEY (`id`), ADD KEY `idx_payment_id` (`payment_id`), ADD KEY `idx_bill_id` (`bill_ledger_id`); -- -- Indexes for table `product_company_barcode` -- ALTER TABLE `product_company_barcode` ADD PRIMARY KEY (`id`), ADD KEY `product_id` (`product_id`), ADD KEY `company_barcode` (`company_barcode`); -- -- Indexes for table `product_settings` -- ALTER TABLE `product_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `profile` -- ALTER TABLE `profile` ADD PRIMARY KEY (`E_ID`); -- -- Indexes for table `purchases` -- ALTER TABLE `purchases` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `purchase_no` (`purchase_no`); -- -- Indexes for table `purchase_items` -- ALTER TABLE `purchase_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchase_returns` -- ALTER TABLE `purchase_returns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchase_return_items` -- ALTER TABLE `purchase_return_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `quotations` -- ALTER TABLE `quotations` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `quotation_no` (`quotation_no`); -- -- Indexes for table `quotation_items` -- ALTER TABLE `quotation_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `quotation_terms` -- ALTER TABLE `quotation_terms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `role` -- ALTER TABLE `role` ADD PRIMARY KEY (`role_rolecode`); -- -- Indexes for table `role_rights` -- ALTER TABLE `role_rights` ADD PRIMARY KEY (`rr_rolecode`,`rr_modulecode`), ADD KEY `rr_modulecode` (`rr_modulecode`); -- -- Indexes for table `sales` -- ALTER TABLE `sales` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `sale_no_2` (`sale_no`), ADD KEY `sale_no` (`customer_id`), ADD KEY `idx_date` (`date`), ADD KEY `idx_invoice_status` (`invoice_status`); -- -- Indexes for table `sales_invoices` -- ALTER TABLE `sales_invoices` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `invoice_no` (`invoice_no`), ADD KEY `customer_id` (`customer_id`); -- -- Indexes for table `sales_invoice_items` -- ALTER TABLE `sales_invoice_items` ADD PRIMARY KEY (`id`), ADD KEY `invoice_id` (`invoice_id`), ADD KEY `sale_id` (`sale_id`), ADD KEY `product_id` (`product_id`); -- -- Indexes for table `sales_items` -- ALTER TABLE `sales_items` ADD PRIMARY KEY (`id`), ADD KEY `sale_id` (`sale_id`), ADD KEY `product_id` (`product_id`); -- -- Indexes for table `stock_ledger` -- ALTER TABLE `stock_ledger` ADD PRIMARY KEY (`id`); -- -- Indexes for table `suppliers` -- ALTER TABLE `suppliers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `system_users` -- ALTER TABLE `system_users` ADD PRIMARY KEY (`u_userid`), ADD KEY `u_rolecode` (`u_rolecode`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `account_chart` -- ALTER TABLE `account_chart` MODIFY `AccCode` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131; -- -- AUTO_INCREMENT for table `account_types` -- ALTER TABLE `account_types` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `audit_logs` -- ALTER TABLE `audit_logs` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `banks` -- ALTER TABLE `banks` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bank_accounts` -- ALTER TABLE `bank_accounts` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `bill_ledger` -- ALTER TABLE `bill_ledger` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `chart_of_accounts` -- ALTER TABLE `chart_of_accounts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `company` -- ALTER TABLE `company` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `general_ledger` -- ALTER TABLE `general_ledger` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `journal_entries` -- ALTER TABLE `journal_entries` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `journal_items` -- ALTER TABLE `journal_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `mobile_banking_accounts` -- ALTER TABLE `mobile_banking_accounts` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `parties` -- ALTER TABLE `parties` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payment_vouchers` -- ALTER TABLE `payment_vouchers` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `payment_voucher_items` -- ALTER TABLE `payment_voucher_items` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_company_barcode` -- ALTER TABLE `product_company_barcode` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=515; -- -- AUTO_INCREMENT for table `product_settings` -- ALTER TABLE `product_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `purchases` -- ALTER TABLE `purchases` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `purchase_items` -- ALTER TABLE `purchase_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `purchase_returns` -- ALTER TABLE `purchase_returns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `purchase_return_items` -- ALTER TABLE `purchase_return_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; -- -- AUTO_INCREMENT for table `quotations` -- ALTER TABLE `quotations` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `quotation_items` -- ALTER TABLE `quotation_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64; -- -- AUTO_INCREMENT for table `quotation_terms` -- ALTER TABLE `quotation_terms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100; -- -- AUTO_INCREMENT for table `sales` -- ALTER TABLE `sales` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `sales_invoices` -- ALTER TABLE `sales_invoices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `sales_invoice_items` -- ALTER TABLE `sales_invoice_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `sales_items` -- ALTER TABLE `sales_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `stock_ledger` -- ALTER TABLE `stock_ledger` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `suppliers` -- ALTER TABLE `suppliers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `system_users` -- ALTER TABLE `system_users` MODIFY `u_userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- Constraints for dumped tables -- -- -- Constraints for table `chart_of_accounts` -- ALTER TABLE `chart_of_accounts` ADD CONSTRAINT `chart_of_accounts_ibfk_1` FOREIGN KEY (`account_type_id`) REFERENCES `account_types` (`id`), ADD CONSTRAINT `chart_of_accounts_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `chart_of_accounts` (`id`) ON DELETE SET NULL; -- -- Constraints for table `journal_items` -- ALTER TABLE `journal_items` ADD CONSTRAINT `journal_items_ibfk_1` FOREIGN KEY (`journal_entry_id`) REFERENCES `journal_entries` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `journal_items_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `chart_of_accounts` (`id`), ADD CONSTRAINT `journal_items_ibfk_3` FOREIGN KEY (`party_id`) REFERENCES `parties` (`id`); -- -- Constraints for table `parties` -- ALTER TABLE `parties` ADD CONSTRAINT `parties_ibfk_1` FOREIGN KEY (`receivable_account_id`) REFERENCES `chart_of_accounts` (`id`), ADD CONSTRAINT `parties_ibfk_2` FOREIGN KEY (`payable_account_id`) REFERENCES `chart_of_accounts` (`id`); -- -- Constraints for table `payment_voucher_items` -- ALTER TABLE `payment_voucher_items` ADD CONSTRAINT `fk_payment_item_payment` FOREIGN KEY (`payment_id`) REFERENCES `payment_vouchers` (`id`) ON DELETE CASCADE; -- -- Constraints for table `sales_invoice_items` -- ALTER TABLE `sales_invoice_items` ADD CONSTRAINT `fk_sales_invoice_items_invoice` FOREIGN KEY (`invoice_id`) REFERENCES `sales_invoices` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_sales_invoice_items_sale` FOREIGN KEY (`sale_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE; -- -- Constraints for table `sales_items` -- ALTER TABLE `sales_items` ADD CONSTRAINT `fk_sales_items_sale` FOREIGN KEY (`sale_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_sales_items_sale_01` FOREIGN KEY (`sale_id`) REFERENCES `sales` (`id`) ON DELETE 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 */;