/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.23-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: cd_adilmobi_4305ab
-- ------------------------------------------------------
-- Server version	10.11.10-MariaDB-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ac_aa`
--

DROP TABLE IF EXISTS `ac_aa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_aa` (
  `catmid` int(11) NOT NULL AUTO_INCREMENT,
  `catm_name` varchar(30) NOT NULL,
  PRIMARY KEY (`catmid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_aa`
--

LOCK TABLES `ac_aa` WRITE;
/*!40000 ALTER TABLE `ac_aa` DISABLE KEYS */;
INSERT INTO `ac_aa` VALUES (1,'Assets'),(2,'Liabilities'),(3,'Income'),(4,'Expenses'),(5,'Profit & Loss'),(6,'Difference');
/*!40000 ALTER TABLE `ac_aa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_cat`
--

DROP TABLE IF EXISTS `ac_cat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_cat` (
  `catid` int(11) NOT NULL AUTO_INCREMENT,
  `catmid` int(3) NOT NULL,
  `catg_name` varchar(100) NOT NULL,
  `catg_unicode` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `parent` int(11) DEFAULT 0,
  `c_group` varchar(100) NOT NULL,
  `fixed` int(11) NOT NULL DEFAULT 0,
  `c_permission` longtext NOT NULL,
  `form_type` varchar(50) NOT NULL,
  `c_status` varchar(10) NOT NULL,
  PRIMARY KEY (`catid`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_cat`
--

LOCK TABLES `ac_cat` WRITE;
/*!40000 ALTER TABLE `ac_cat` DISABLE KEYS */;
INSERT INTO `ac_cat` VALUES (1,1,'Fixed Assets','স্থায়ী সম্পদ',0,'',1,'','Default','Yes'),(2,1,'Current Assets','চলতি সম্পদ',0,'',1,'','Default','Yes'),(3,1,'Other Assets','অন্যান্য সম্পত্তি',0,'',1,'','Default','Yes'),(4,0,'0','',0,'',0,'','Default','Yes'),(5,0,'0','',0,'',0,'','Default','Yes'),(6,5,'Profit & Loss','লাভ & ক্ষতি',0,'',1,'','Default','Yes'),(7,2,'Capital Account','মূলধন হিসাব',0,'',1,'','Default','Yes'),(8,2,'Reserve & Surplus','রিজার্ভ এবং উদ্বৃত্ত',0,'',1,'','Default','Yes'),(9,2,'Secured Loans ','নিরাপদ ঋণ',0,'',1,'','Default','Yes'),(10,2,'Unsecured Loans ','অনিরাপদ ঋণ',0,'',1,'','Default','Yes'),(11,2,'Bank OD','ব্যাংক ওডি',0,'',1,'','Default','Yes'),(12,2,'Bank OCC Account','ব্যাংক ওসিসি অ্যাকাউন্ট',0,'',1,'','Default','Yes'),(13,2,'Provision','বিধান',0,'',1,'','Default','Yes'),(14,2,'Duties & Taxes','কর্তব্য এবং খাজনা',0,'',1,'','Default','Yes'),(15,2,'Current Liabilities','বর্তমান দায়',0,'',1,'','Default','Yes'),(16,2,'Other Liabilities','অন্যান্য দায়',0,'',1,'','Default','Yes'),(17,0,'','',0,'',0,'','Default','Yes'),(18,0,'','',0,'',0,'','Default','Yes'),(19,3,'Sales','বিক্রয়',0,'',1,'','Default','Yes'),(20,3,'Direct Income','সরাসরি আয়',0,'',1,'','Default','Yes'),(21,3,'Indirect Income','পরোক্ষ আয়',0,'',1,'','Default','Yes'),(22,3,'Other Operating Income','অন্যান্য অপারেটিং আয়',0,'',1,'','Default','Yes'),(23,0,'','',0,'',0,'','Default','Yes'),(24,4,'Purchase','ক্রয়',0,'',1,'','Default','Yes'),(25,4,'Direct Expenses','সরাসরি খরচ/ব্যয়',0,'',1,'','Default','Yes'),(26,4,'Indirect Expenses','পরোক্ষ খরচ/ব্যয়',0,'',1,'','Default','Yes'),(27,4,'Other Expenses','অন্যান্য খরচ/ব্যয়',0,'',1,'','Default','Yes'),(28,0,'','',0,'',0,'','Default','Yes'),(29,6,'Difference In Opening','খোলার মধ্যে পার্থক্য',0,'',1,'','Default','Yes'),(30,0,'0','',0,'',0,'','Default','Yes'),(31,1,'Land','জমি',1,'',0,'','Depreciation','Yes'),(32,1,'Buildings','ভবন',1,'',0,'','Depreciation','Yes'),(33,1,'Machinery','যন্ত্রপাতি',1,'',0,'','Depreciation','Yes'),(34,1,'Vehicles','যানবাহন',1,'',0,'','Depreciation','Yes'),(35,1,'Furniture and Fixtures','আসবাবপত্র এবং ফিক্সচার',1,'',0,'','Depreciation','Yes'),(36,1,'Computer Equipment','কম্পিউটার এর যন্ত্রাদি',1,'',0,'','Depreciation','Yes'),(37,1,'Cash in Hand','নগদ ক্যাশ',2,'',1,'','Cash','Yes'),(38,1,'Cash at Bank','নগদ ব্যাংক',2,'',1,'','Bank','Yes'),(39,1,'Accounts Receivable & Debtors','গ্রাহক হিসাব এবং দেনাদার পরিচালনা',2,'',0,'','Default','Yes'),(40,1,'Inventory (Raw Mater., Work in Pro.)','ইনভেন্টরি (কাঁচা মাল, কাজ চলছে)',2,'',0,'','Default','Yes'),(41,1,'Short-term Investments','স্বল্প মেয়াদী বিনিয়োগের',2,'',0,'','Default','Yes'),(42,1,'Long-term Investments','দীর্ঘ মেয়াদী বিনিয়োগের',3,'',0,'','Default','Yes'),(43,1,'Intangible Assets (Patents, Trademarks)','অস্পষ্ট সম্পদ (পেটেন্ট, ট্রেডমার্ক)',3,'',0,'','Default','Yes'),(44,1,'Prepaid Expenses','প্রিপেইড খরচ',3,'',0,'','Default','Yes'),(45,1,'Advances to Suppliers','সরবরাহকারীদের অগ্রিম',3,'',0,'','Default','Yes'),(46,1,'Advances Other','অগ্রিম অন্যান্য',3,'',0,'','Default','Yes'),(47,2,'Shareholder\'s','শেয়ারহোল্ডার',7,'',0,'','Share','Yes'),(48,2,'Equity','ইক্যুইটি',7,'',0,'','Default','Yes'),(49,2,'Owner\'s Equity','মালিকানা সম্পদ',7,'',0,'','Default','Yes'),(50,2,'Share Capital','শেয়ার ভাগ করা',8,'',0,'','Default','Yes'),(51,2,'Retained Earnings','ধরে রাখা উপার্জন',8,'',0,'','Default','Yes'),(52,2,'Reserves','রিজার্ভ',8,'',0,'','Default','Yes'),(53,2,'Mortgage Loans','বন্ধকী ঋণ',9,'',0,'','Default','Yes'),(54,2,'Secured Bonds','সুরক্ষিত বন্ড',9,'',0,'','Default','Yes'),(55,2,'Debentures','ডিবেঞ্চার',10,'',0,'','Default','Yes'),(56,2,'Unsecured Bonds','অনিরাপদ বন্ড',10,'',0,'','Default','Yes'),(57,2,'Overdraft Facility','ত্তভারড্রাফট সুবিধা',11,'',0,'','Default','Yes'),(58,2,'Bank Overdraft','ব্যাংক জমাতিরিক্ত',12,'',0,'','Default','Yes'),(59,2,'Provision for Income Tax','আয়করের বিধান',13,'',0,'','Default','Yes'),(60,2,'Provision for Bad Debts','খারাপ ঋণের বিধান',13,'',0,'','Default','Yes'),(61,2,'Sales Tax Payable','বিক্রয় কর পরিশোধ',14,'',1,'','vat_tax','Yes'),(62,2,'Income Tax Payable','আয়কর পরিশোধ',14,'',1,'','vat_tax','Yes'),(63,2,'GST Payable','জিএসটি পরিশোধ',14,'',1,'','vat_tax','Yes'),(64,2,'Accounts Payable (creditor)','সরবরাহকারীর হিসাব (পরিশোধযোগ্য পাওনাদার)',15,'',1,'','Supplier','Yes'),(65,2,'Short-term Loans Payable','স্বল্পমেয়াদী ঋণ পরিশোধযোগ্য',15,'',0,'','Default','Yes'),(66,2,'Payroll/Employee Payables','বেতন/কর্মচারী প্রদেয়',15,'',1,'','Employee','Yes'),(67,2,'Deferred Revenue','বিলম্বিত রাজস্ব',16,'',0,'','Default','Yes'),(68,2,'Customer Deposits','গ্রাহক আমানত',16,'',0,'','Default','Yes'),(69,2,'Lease Obligations','ইজারা বাধ্যবাধকতা',16,'',0,'','Default','Yes'),(70,3,'Sales Revenue','বিক্রয় রাজস্ব',19,'',1,'','Default','Yes'),(71,3,'Sales Returns','বিক্রয় রিটার্ন',19,'',1,'','Default','Yes'),(72,3,'Direct Income','সরাসরি আয়',20,'',0,'','Default','Yes'),(73,3,'Interest Income','মুনাফা লাভ',20,'',0,'','Default','Yes'),(74,3,'Dividend Income','লভ্যাংশ আয়',20,'',0,'','Default','Yes'),(75,3,'Rental Income','ভাড়ার আয়',21,'',0,'','Default','Yes'),(76,3,'Commission Income','কমিশন আয়',21,'',0,'','Default','Yes'),(77,3,'Other Income','অন্যান্য আয়',21,'',0,'','Default','Yes'),(78,3,'Miscellaneous Income','বিবিধ আয়',22,'',0,'','Default','Yes'),(79,3,'Gain on Sale of Assets','সম্পদ বিক্রির উপর লাভ',22,'',0,'','Default','Yes'),(80,4,'Cost of Goods Sold','বিক্রি সামগ্রীর খরচ',24,'',0,'','Default','Yes'),(81,4,'Inventory Purchases','ইনভেন্টরি (পণ্য সামগ্রী) ক্রয়',24,'',1,'','Default','Yes'),(82,4,'Office Expenses','অফিস খরচ',25,'',0,'','Default','Yes'),(83,4,'Direct Labor','সরাসরি শ্রমজীবী খরচ',25,'',0,'','Default','Yes'),(84,4,'Direct Materials','সরাসরি উপকরণ খরচ',25,'',0,'','Default','Yes'),(85,4,'Manufacturing Expenses','উৎপাদন খরচ',25,'',0,'','Default','Yes'),(86,4,'Rent Expense','ভাড়া ব্যয়',26,'',0,'','Default','Yes'),(87,4,'Utilities','ইউটিলিটিস',26,'',0,'','Default','Yes'),(88,4,'Salary & Wages','বেতন ও মজুরি',26,'',0,'','Default','Yes'),(89,4,'Advertising and Promotion','বিজ্ঞাপন ও প্রচার',26,'',0,'','Default','Yes'),(90,4,'Depreciation Expenses','অতিরিক্ত খরচ',26,'',0,'','Default','Yes'),(91,4,'Repairs and Maintenance','মেরামত এবং রক্ষণাবেক্ষন',26,'',0,'','Default','Yes'),(92,1,'Retail','খুচরা গ্রাহক',39,'',0,'','Customer','Yes'),(93,1,'Credit','পাইকারি ও বাকি গ্রাহক',39,'',0,'','Customer','Yes'),(94,1,'Installment','কিস্তি গ্রাহক',39,'',0,'','Installment','Yes'),(95,1,'Corporate','কর্পোরেট গ্রাহক',39,'',0,'','Customer','Yes'),(96,2,'Sundry Creditor (Supplier)','বিভিন্ন পাওনাদার (সরবরাহকারী/সাপ্লায়ার)',64,'',1,'','Supplier','Yes'),(97,2,'Chairman/Owner','চেয়ারম্যান/মালিক',66,'',0,'','Employee','Yes');
/*!40000 ALTER TABLE `ac_cat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_client`
--

DROP TABLE IF EXISTS `ac_client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_client` (
  `acid` bigint(30) NOT NULL AUTO_INCREMENT,
  `bid` int(11) NOT NULL,
  `catid` int(2) NOT NULL,
  `ac_type` varchar(50) NOT NULL,
  `ac_outid` varchar(50) NOT NULL,
  `ac_name` varchar(50) NOT NULL,
  `ac_disname` varchar(50) NOT NULL,
  `ac_number` varchar(15) NOT NULL,
  `ac_email` varchar(150) NOT NULL,
  `ac_details` varchar(100) NOT NULL,
  `ac_branch` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_ms_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_ms_number` varchar(50) NOT NULL,
  `ac_f_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_m_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_nid` varchar(100) NOT NULL,
  `ac_g_info` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_b_group` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_ps_address` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_pr_address` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_currency` varchar(20) NOT NULL,
  `ac_bl_type` varchar(50) NOT NULL,
  `ac_bl_limit` varchar(30) NOT NULL,
  `ac_bl_sub` varchar(30) NOT NULL,
  `ac_balance` varchar(50) NOT NULL,
  `ac_depreciation` varchar(50) NOT NULL,
  `ac_username` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_permission` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ac_notify` varchar(20) NOT NULL,
  `ac_label` int(11) NOT NULL,
  `ac_em_id` int(30) NOT NULL,
  `ac_userid` varchar(5) NOT NULL,
  `ac_area_id` int(10) NOT NULL,
  `ac_starting` date NOT NULL,
  `ac_reminder` date NOT NULL,
  `ac_opening` date NOT NULL,
  `ac_closing` date NOT NULL,
  `ac_time` time NOT NULL,
  `ac_picture1` mediumblob NOT NULL,
  `ac_picture2` mediumblob NOT NULL,
  `ac_picture3` mediumblob NOT NULL,
  `ac_status` int(1) NOT NULL,
  PRIMARY KEY (`acid`),
  KEY `bid` (`bid`),
  KEY `catid` (`catid`),
  KEY `ac_name` (`ac_name`),
  KEY `ac_disname` (`ac_disname`),
  KEY `ac_number` (`ac_number`),
  KEY `ac_ms_name` (`ac_ms_name`),
  KEY `ac_ms_number` (`ac_ms_number`),
  KEY `ac_f_name` (`ac_f_name`),
  KEY `ac_nid` (`ac_nid`),
  KEY `ac_status` (`ac_status`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_client`
--

LOCK TABLES `ac_client` WRITE;
/*!40000 ALTER TABLE `ac_client` DISABLE KEYS */;
INSERT INTO `ac_client` VALUES (1,1,6,'Default','001','Profit & Loss','Primary','01','','','','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(2,1,29,'Default','002','Difference In Opening','D&O','02','','','','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(3,1,37,'Cash','003','Cash in Hand','Primary','03','','','','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(4,1,38,'Bank','004','Bank Ac','Primary','04','','','','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(5,1,97,'Employee','005','Default Employee','D&E','05','','','','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(6,2,6,'Default','006','Profit & Loss','Primary','01','','','Profit','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(7,2,29,'Default','007','Difference In Opening','D&O','02','','','D&O','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(8,2,37,'Cash','008','Cash in Hand','Primary','03','','','Cash','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(9,2,38,'Bank','009','Bank Ac','Primary','04','','','Bank','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(10,2,97,'Employee','0010','Default Employee','D&E','05','','','Emp','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(11,2,81,'Default','0011','Purchase-Ac','Primary','06','','','Purchase','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(12,2,70,'Default','0012','Sale-Ac','Primary','07','','','Sales','','','','','','','','','','','','','','0.000','','','','','',0,0,'',0,'0000-00-00','2025-10-31','2025-10-31','0000-00-00','00:00:00','','','',1),(13,2,92,'Customer','1235','Retail','Adil Mobile Gallery','01912999220','','','','','','','','','','','','','','','0','','','','','','Sales1,','',0,0,'',0,'0000-00-00','0000-00-00','2025-10-31','0000-00-00','00:00:00','','','',1),(14,2,94,'Installment','1235','','','','','','','','','','','','','','','','','','','','','','','','Sales1,','',0,0,'',0,'0000-00-00','0000-00-00','2025-11-03','0000-00-00','00:00:00','','','',1),(15,2,96,'Supplier','','Opening Stock','','1','','','','','','','','','','','','','','','','','','','','','Purchase1,','',0,0,'',0,'0000-00-00','0000-00-00','2025-11-03','0000-00-00','00:00:00','','','',1);
/*!40000 ALTER TABLE `ac_client` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_default_id`
--

DROP TABLE IF EXISTS `ac_default_id`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_default_id` (
  `df_id` int(100) NOT NULL AUTO_INCREMENT,
  `df_bid` int(10) NOT NULL,
  `df_name` varchar(200) NOT NULL,
  `df_gid` int(10) NOT NULL,
  `df_acid` int(10) NOT NULL,
  `df_status` varchar(20) NOT NULL,
  PRIMARY KEY (`df_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_default_id`
--

LOCK TABLES `ac_default_id` WRITE;
/*!40000 ALTER TABLE `ac_default_id` DISABLE KEYS */;
INSERT INTO `ac_default_id` VALUES (1,1,'D&O',0,2,'1'),(2,1,'Cash',0,3,'1'),(3,1,'Bank',0,4,'1'),(4,2,'Profit',0,6,'1'),(5,2,'D&O',0,7,'1'),(6,2,'Cash',0,8,'1'),(7,2,'Bank',0,9,'1'),(8,2,'Emp',0,10,'1'),(9,2,'Purchase',0,11,'1'),(10,2,'Sales',0,12,'1'),(11,2,'Retail_Sale_Ac',0,13,'1');
/*!40000 ALTER TABLE `ac_default_id` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_installment`
--

DROP TABLE IF EXISTS `ac_installment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_installment` (
  `ins_id` bigint(255) NOT NULL AUTO_INCREMENT,
  `ins_bid` int(30) NOT NULL,
  `ins_number` varchar(50) NOT NULL,
  `ins_invoice` varchar(100) NOT NULL,
  `ins_acid` varchar(50) NOT NULL,
  `ins_type` varchar(50) NOT NULL,
  `ins_sale_balance` varchar(30) NOT NULL,
  `ins_dp_balance` varchar(30) NOT NULL,
  `ins_ext_balance` varchar(30) NOT NULL,
  `ins_ser_percent` varchar(50) NOT NULL,
  `ins_ser_balance` varchar(30) NOT NULL,
  `ins_loan_balance` varchar(30) NOT NULL,
  `ins_qty` varchar(10) NOT NULL,
  `ins_ins_per` varchar(30) NOT NULL,
  `ins_fee_percent` varchar(10) NOT NULL,
  `ins_late_fee` varchar(30) NOT NULL,
  `ins_last_recived` varchar(30) NOT NULL,
  `ins_outstanding` varchar(30) NOT NULL,
  `ins_start_date` date NOT NULL,
  `ins_last_re_date` date NOT NULL,
  `ins_first_date` date NOT NULL,
  `ins_date_next` date DEFAULT NULL,
  `ins_date_sub` date NOT NULL,
  `ins_last_date` date DEFAULT NULL,
  `ins_close_date` date DEFAULT NULL,
  `ins_remark` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ins_note` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `ins_em_id` varchar(50) NOT NULL,
  `ins_status` int(1) NOT NULL,
  PRIMARY KEY (`ins_id`),
  KEY `ins_number` (`ins_number`),
  KEY `ins_acid` (`ins_acid`),
  KEY `ins_type` (`ins_type`),
  KEY `ins_start_date` (`ins_start_date`),
  KEY `ins_last_re_date` (`ins_last_re_date`),
  KEY `ins_date_next` (`ins_date_next`),
  KEY `ins_date_sub` (`ins_date_sub`),
  KEY `ins_last_date` (`ins_last_date`),
  KEY `ins_close_date` (`ins_close_date`),
  KEY `ins_remark` (`ins_remark`),
  KEY `ins_em_id` (`ins_em_id`),
  KEY `ins_status` (`ins_status`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_installment`
--

LOCK TABLES `ac_installment` WRITE;
/*!40000 ALTER TABLE `ac_installment` DISABLE KEYS */;
INSERT INTO `ac_installment` VALUES (1,2,'2025110328661','','14','Monthly','0','0','','0','0','0','1','0','0','','','0','2025-11-03','0000-00-00','0000-00-00','2025-12-03','2025-12-03','2025-11-03',NULL,'','','',1);
/*!40000 ALTER TABLE `ac_installment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_location`
--

DROP TABLE IF EXISTS `ac_location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_location` (
  `ar_id` int(11) NOT NULL AUTO_INCREMENT,
  `ar_bid` int(11) NOT NULL,
  `ar_name` varchar(300) NOT NULL,
  `ar_parent` int(11) NOT NULL,
  `ar_group` varchar(30) NOT NULL,
  `ar_status` enum('active','inactive','pending') NOT NULL,
  `ar_active` varchar(10) NOT NULL,
  PRIMARY KEY (`ar_id`),
  KEY `ar_name` (`ar_name`(100)),
  KEY `ar_parent` (`ar_parent`),
  KEY `ar_group` (`ar_group`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_location`
--

LOCK TABLES `ac_location` WRITE;
/*!40000 ALTER TABLE `ac_location` DISABLE KEYS */;
INSERT INTO `ac_location` VALUES (1,1,'Default_Area',0,'Yes','','yes'),(2,1,'Default',1,'No','','yes'),(3,2,'Default_Area',0,'Yes','','yes'),(4,2,'Default',3,'No','','yes');
/*!40000 ALTER TABLE `ac_location` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_pay_cheque`
--

DROP TABLE IF EXISTS `ac_pay_cheque`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_pay_cheque` (
  `c_pid` bigint(20) NOT NULL AUTO_INCREMENT,
  `c_bid` int(11) NOT NULL,
  `c_acid` varchar(50) NOT NULL,
  `c_acid1` varchar(50) NOT NULL,
  `c_invoice` varchar(50) NOT NULL,
  `c_bank_name` varchar(200) NOT NULL,
  `c_branch` varchar(200) NOT NULL,
  `c_account` varchar(200) NOT NULL,
  `c_number` varchar(200) NOT NULL,
  `c_payment` decimal(15,2) NOT NULL,
  `c_details` varchar(100) NOT NULL,
  `c_type` varchar(50) NOT NULL,
  `c_arv_id_1` int(11) NOT NULL,
  `c_arv_id_2` int(11) NOT NULL,
  `c_arv_id_3` int(11) NOT NULL,
  `c_userid` int(11) NOT NULL,
  `c_ptime` time NOT NULL,
  `c_date` date NOT NULL,
  `c_next_date` date NOT NULL,
  `c_crdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `c_scanfile` blob NOT NULL,
  `c_status` tinyint(1) NOT NULL,
  PRIMARY KEY (`c_pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_pay_cheque`
--

LOCK TABLES `ac_pay_cheque` WRITE;
/*!40000 ALTER TABLE `ac_pay_cheque` DISABLE KEYS */;
/*!40000 ALTER TABLE `ac_pay_cheque` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_payment`
--

DROP TABLE IF EXISTS `ac_payment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_payment` (
  `pid` bigint(255) NOT NULL AUTO_INCREMENT,
  `bid` int(30) NOT NULL,
  `acid` int(40) NOT NULL,
  `plus` varchar(1) NOT NULL,
  `acid1` int(40) NOT NULL,
  `plus1` varchar(1) NOT NULL,
  `acid2` int(40) NOT NULL,
  `ins_id` varchar(50) NOT NULL,
  `invoice` varchar(50) NOT NULL,
  `invoice1` varchar(100) NOT NULL,
  `type1` varchar(10) NOT NULL,
  `type2` varchar(10) NOT NULL,
  `type3` varchar(10) NOT NULL,
  `ext_note` varchar(50) NOT NULL,
  `details` varchar(100) NOT NULL,
  `details1` varchar(200) NOT NULL,
  `details2` varchar(200) NOT NULL,
  `vat_per` varchar(30) NOT NULL,
  `shipping` varchar(30) NOT NULL,
  `discount` varchar(30) NOT NULL,
  `pbalance` varchar(50) NOT NULL,
  `payment` varchar(50) NOT NULL,
  `scanfile` blob NOT NULL,
  `projectID` varchar(100) NOT NULL,
  `quaryID` varchar(100) NOT NULL,
  `latitude` varchar(50) NOT NULL,
  `longitude` varchar(50) NOT NULL,
  `entry_ip` varchar(50) NOT NULL,
  `approve` int(1) NOT NULL,
  `permission` longtext NOT NULL,
  `em_id` int(30) NOT NULL,
  `userid` int(30) NOT NULL,
  `ptime` time NOT NULL,
  `date` date NOT NULL,
  `date1` date NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `active` varchar(10) NOT NULL,
  PRIMARY KEY (`pid`),
  KEY `date` (`date`),
  KEY `bid` (`bid`),
  KEY `acid` (`acid`),
  KEY `acid1` (`acid1`),
  KEY `acid2` (`acid2`),
  KEY `invoice` (`invoice`),
  KEY `plus` (`plus`),
  KEY `userid` (`userid`),
  KEY `em_id` (`em_id`),
  KEY `active` (`active`),
  KEY `plus1` (`plus1`),
  KEY `type1` (`type1`),
  KEY `type1_2` (`type1`),
  KEY `type2` (`type2`),
  KEY `type3` (`type3`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_payment`
--

LOCK TABLES `ac_payment` WRITE;
/*!40000 ALTER TABLE `ac_payment` DISABLE KEYS */;
INSERT INTO `ac_payment` VALUES (1,2,15,'-',11,'+',0,'','EPU-20251103-151633-1530','','37','','','','','','','','','0','0.000','40','','0','','','','103.25.248.128',0,'',10,2,'15:16:30','2025-11-03','2025-11-03','2025-11-03 09:16:30','1'),(2,2,13,'+',12,'-',0,'','SAL-20251103-152036-2933','','42','','','','','pl','','','','0','0.000','20','','0','','','','103.25.248.128',0,'',10,2,'15:20:33','2025-11-03','2025-11-03','2025-11-03 09:20:33','1');
/*!40000 ALTER TABLE `ac_payment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_retail`
--

DROP TABLE IF EXISTS `ac_retail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_retail` (
  `rt_id` int(11) NOT NULL AUTO_INCREMENT,
  `rt_bid` int(10) NOT NULL,
  `rt_invoice` varchar(50) NOT NULL,
  `rt_acid` int(20) NOT NULL,
  `rt_mid` varchar(50) NOT NULL,
  `rt_name` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `rt_age` varchar(50) NOT NULL,
  `rt_type` varchar(50) NOT NULL,
  `rt_phone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `rt_address` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `rt_note` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `rt_drid` varchar(100) NOT NULL,
  `rt_balance` varchar(50) NOT NULL,
  `rt_status` int(10) NOT NULL,
  PRIMARY KEY (`rt_id`),
  KEY `rt_bid` (`rt_bid`),
  KEY `rt_invoice` (`rt_invoice`),
  KEY `rt_acid` (`rt_acid`),
  KEY `rt_mid` (`rt_mid`),
  KEY `rt_name` (`rt_name`),
  KEY `rt_age` (`rt_age`),
  KEY `rt_type` (`rt_type`),
  KEY `rt_phone` (`rt_phone`),
  KEY `rt_note` (`rt_note`),
  KEY `rt_balance` (`rt_balance`),
  KEY `rt_status` (`rt_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_retail`
--

LOCK TABLES `ac_retail` WRITE;
/*!40000 ALTER TABLE `ac_retail` DISABLE KEYS */;
/*!40000 ALTER TABLE `ac_retail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_v_transfer`
--

DROP TABLE IF EXISTS `ac_v_transfer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_v_transfer` (
  `tr_vid` int(100) NOT NULL AUTO_INCREMENT,
  `tr_bid` int(10) NOT NULL,
  `tr_tbid` int(10) NOT NULL,
  `tr_invoice` varchar(100) NOT NULL,
  `tr_t_user` int(20) NOT NULL,
  `tr_t_date` date NOT NULL,
  `tr_t_acid` int(20) NOT NULL,
  `tr_r_user` int(20) NOT NULL,
  `tr_r_date` date NOT NULL,
  `tr_amount` varchar(50) NOT NULL,
  `tr_status` varchar(50) NOT NULL,
  PRIMARY KEY (`tr_vid`),
  KEY `tr_invoice` (`tr_invoice`),
  KEY `tr_t_date` (`tr_t_date`),
  KEY `tr_r_date` (`tr_r_date`),
  KEY `tr_t_acid` (`tr_t_acid`)
) ENGINE=InnoDB AUTO_INCREMENT=593 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_v_transfer`
--

LOCK TABLES `ac_v_transfer` WRITE;
/*!40000 ALTER TABLE `ac_v_transfer` DISABLE KEYS */;
/*!40000 ALTER TABLE `ac_v_transfer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ac_voucher`
--

DROP TABLE IF EXISTS `ac_voucher`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ac_voucher` (
  `v_id` int(11) NOT NULL AUTO_INCREMENT,
  `v_type` varchar(200) NOT NULL,
  `v_name` varchar(200) NOT NULL,
  `v_unicode` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `v_parent` varchar(20) NOT NULL,
  `v_group` varchar(20) NOT NULL,
  `v_drcr` varchar(20) NOT NULL,
  `v_status` varchar(20) NOT NULL,
  `v_permission` longtext NOT NULL,
  `v_permission1` varchar(100) NOT NULL,
  `v_permission2` varchar(100) NOT NULL,
  `v_permission3` varchar(100) NOT NULL,
  `v_active` varchar(20) NOT NULL,
  PRIMARY KEY (`v_id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ac_voucher`
--

LOCK TABLES `ac_voucher` WRITE;
/*!40000 ALTER TABLE `ac_voucher` DISABLE KEYS */;
INSERT INTO `ac_voucher` VALUES (1,'0','Attendance','হাজিরা','0','Yes','','1','','','','','0'),(2,'0','Contra','কন্ট্রা','0','Yes','Credit','2','','','','','Yes'),(3,'0','Credit Note','ক্রেডিট নোট','0','Yes','Credit','3','','','','','Yes'),(4,'0','Debit Note','ডেবিট নোট','0','Yes','Debit','4','','','','','Yes'),(5,'0','Delivery Note','চালান পত্র','0','Yes','','5','','','','','0'),(6,'0','Job Work In Order','কাজের কাজ ক্রমানুসারে','0','Yes','','6','','','','','0'),(7,'0','Job Work Out Order','কাজের ওয়ার্ক অর্ডার','0','Yes','','7','','','','','0'),(8,'0','Journal','জার্নাল','0','Yes','Debit/Credit','8','','','','','Yes'),(9,'0','Material In','উপাদান ইন','0','Yes','','9','','','','','0'),(10,'0','Material Out','উপাদান আউট','0','Yes','','10','','','','','0'),(11,'0','Memorandum','স্মারকলিপি','0','Yes','','11','','','','','0'),(12,'0','Payment','পেমেন্ট','0','Yes','Credit','12','','','','','Yes'),(13,'0','Payroll','বেতন','0','Yes','','13','','','','','Yes'),(14,'0','Physical Stock','শারীরিক স্টক','0','Yes','','14','','','','','Yes'),(15,'0','Purchase','ক্রয়','0','Yes','Credit','15','','','','','Yes'),(16,'0','Purchase Order','ক্রয় অর্ডার','0','Yes','','16','','','','','Yes'),(17,'0','Receipt','রিসিভ','0','Yes','Debit','17','','','','','Yes'),(18,'0','Receipt Note','রিসিভ নোট','0','Yes','Debit','18','','','','','0'),(19,'0','Rejections In','প্রত্যাখ্যান ইন','0','Yes','','19','','','','','0'),(20,'0','Rejections Out','প্রত্যাখ্যান আউট','0','Yes','','20','','','','','0'),(21,'0','Reversing Journal','রিভার্সিং জার্নাল','0','Yes','','21','','','','','0'),(22,'0','Sales','বিক্রয়','0','Yes','','22','','','','','Yes'),(23,'0','Sale Draft/Approval','বিক্রয় খসড়া/অনুমোদন','0','Yes','','23','','','','','Yes'),(24,'0','Stock Journal','স্টক জার্নাল','0','Yes','','24','','','','','0'),(25,'0','Opening','ওপেনিং','0','Yes','Debit/Credit','25','','','','','Yes'),(26,'v','Contra','কন্ট্রা ভাউচার','2','No','Debit','2','lm2265k','63hyatx','','','Yes'),(27,'v','Credit Note','ক্রেডিট নোট','3','No','Credit','3','lm2265k','63hyatx','','','Yes'),(28,'v','Debit Note','ডেবিট নোট','4','No','Debit','4','lm2265k','63hyatx','','','Yes'),(29,'v','Journal','জার্নাল ভাউচার','8','No','Debit/Credit','8','t23k63xa','2s0p9oc2','','','Yes'),(30,'v','Payment','পেমেন্ট ভাউচার','12','No','Credit','12','lm2265k','63hyatx','','','Yes'),(31,'v','Memo Payment','মেমো পেমেন্ট','12','No','Credit','12','lm2265k','63hyatx','','','Yes'),(32,'v','Payroll','বেতন','13','No','','13','lm2265k','63hyatx','','','Yes'),(33,'v','Receipt','রিসিভ ভাউচার','17','No','Debit','17','lm2265k','63hyatx','','','Yes'),(34,'v','Memo Receipt','মেমো রসিদ','17','No','Debit','17','lm2265k','63hyatx','','','Yes'),(35,'v','Installment Receipt','কিস্তি রিসিভ','17','No','Debit','17','sqz2s1a3','63hyatx','','','Yes'),(36,'v','Opening','ওপেনিং ভাউচার','25','No','Debit/Credit','25','lm2265k','63hyatx','','','Yes'),(37,'p','New Purchase','নতুন ক্রয় মেমো','15','No','Credit','15','k5pagdk0','4pu4oen2','uz5nl2xu','1x5qsyk2','Yes'),(38,'p','Chalan','ক্রয় চালান','15','No','Credit','15','','','','','Yes'),(39,'p','Stock Received','স্টক রিসিভ','15','No','Credit','15','84bw80nh','4bx83lnh','','1x5qsyk2','Yes'),(40,'p','Purchase Return','ক্রয় রিটার্ন','15','No','Credit','15','k5pagdk0','4pu4oen2','0okzx75w','1x5qsyk2','Yes'),(41,'p','Purchase Order','ক্রয় অর্ডার','16','No','','16','','','','','Yes'),(42,'s','Sale Invoice','নতুন বিক্রয় মেমো','22','No','Debit','22','4rxncyg0','jl70und9','0okzx75w','wihme8of','Yes'),(43,'s','Counter Sale','কাউন্টার বিক্রয়','22','No','','22','jzwew3fx','vs9ub6g0','','wihme8of','Yes'),(44,'s','Sales Return','বিক্রয় রিটার্ন','22','No','','22','4rxncyg0','jl70und9','0okzx75w','wihme8of','Yes'),(45,'s','Sale Draft','বিক্রয় খসড়া','23','No','','23','7ej7eni0','','','','Yes'),(46,'s','Order Approval','অর্ডার অনুমোদন','23','No','','23','d8ha5368','','','','Yes'),(47,'s','Order Pending','অর্ডার পেন্ডিং','16','No','','16','','','','','Yes'),(48,'','Stock List','মজুত তালিকা/স্টক লিস্ট','14','No','','14','','','','','Yes'),(49,'','Unit Setting','ইউনিট সেটিং','14','No','','14','','','','','Yes'),(50,'','Store Setting','স্টোর/গুদামঘর সেটিং','14','No','','14','','','','','Yes'),(51,'','Model Setting','মডেল সেটিং','14','No','','14','','','','','Yes'),(52,'','Batch Setting','ব্যাচ সেটিং','14','No','','14','','','','','Yes'),(53,'','Group/Category Setting','গ্রুপ/বিভাগ সেটিং','14','Yes','','14','','','','','Yes'),(54,'0','Accounting Reports','অ্যাকাউন্টিং রিপোর্ট','0','Yes','Debit/Credit','54','','','','','Yes'),(55,'0','Inventory Reports','ইনভেন্টরি রিপোর্ট','0','Yes','Debit/Credit','55','','','','','Yes'),(56,'0','Exception Reports','ব্যতিক্রম রিপোর্ট','0','Yes','Debit/Credit','56','','','','','Yes'),(57,'','Trial Balance','ট্রায়াল ব্যালেন্স','54','No','Debit/Credit','54','egx7gd8','','','','Yes'),(58,'','Day Book','ডে বুক','54','No','Debit/Credit','54','bp29gntj','','','','Yes'),(59,'','Cash Flow','ক্যাশ ফ্লো','54','No','Debit/Credit','54','vws4fobk','','','','Yes'),(60,'','Fund Flow','ফান্ড/তহবিল ফ্লো','54','No','Debit/Credit','54','rj29idzg','','','','No'),(61,'','Cash & Bank Book','নগদ ও ব্যাংক বুক','54','No','Debit/Credit','54','4n89p3pt','','','','Yes'),(62,'','Ledger','একক লেজার/খাতা','54','No','Debit/Credit','54','7jgvlkdh','','','','Yes'),(63,'','Group Ledger','গ্রুপ লেজার','54','No','Debit/Credit','54','cgye6zn4','','','','Yes'),(64,'','Group Vouecher','গ্রুপ ভাউচার','54','No','Debit/Credit','54','9wczircj','','','','Yes'),(65,'','Receipt & Payment Register','রিসিভ & পেমেন্ট রেজিস্টার','54','No','Debit/Credit','54','9wczircj','','','','Yes'),(66,'','Sale & Purchase Register','বিক্রয় এবং ক্রয় রেজিস্টার','54','No','Debit/Credit','54','2mecrcvm','','','','Yes'),(67,'','Receivables','প্রাপ্য ব্যালেন্স','54','No','Debit','54','x8qc2fvk','','','','Yes'),(68,'','Payables','পরিশোধযোগ্য ব্যালেন্স','54','No','Debit/Credit','54','x8qc2fvk','','','','Yes'),(69,'','Stock Item','স্টক আইটেম','55','No','Debit/Credit','55','3nqf3jr','','','','Yes'),(70,'','Store/Location','দোকানের অবস্থান','55','No','Debit/Credit','55','h74a7v9s','','','','Yes'),(71,'','Single Stock Summary','একক স্টক সারাংশ','55','No','Debit/Credit','55','','','','','Yes'),(72,'','Stock Category Summary','স্টক বিভাগ সারাংশ','55','No','Debit/Credit','55','pm17g3g4','','','','Yes'),(73,'','Stock Group Summary','স্টক গ্রুপ সারাংশ','55','No','Debit/Credit','55','vhnj2dg5','','','','Yes'),(74,'','Stock Transfer Reg','স্টক ট্রান্সফার রেজি','55','No','Debit/Credit','55','','','','','Yes'),(75,'','Stock Match','স্টক ম্যাচ','55','No','Debit/Credit','55','','','','','Yes'),(76,'','Overdue Receivable','ওভারডি রিসিভেবল','54','No','Debit/Credit','54','','','','','Yes'),(77,'','Overdue Payable','অতিরিক্ত পরিশোধযোগ্য','54','No','Debit/Credit','54','','','','','Yes'),(78,'','Account Book','হিসাব বই','54','No','Debit/Credit','54','2mtgn2w5','','','','Yes'),(79,'0','Business Reports','ব্যবসা রিপোর্ট','0','Yes','Debit/Credit','79','','','','','Yes'),(80,'','Balance Sheet','ব্যালেন্স শীট','79','No','Debit/Credit','79','h9z5vfvp','','','','Yes'),(81,'','Profit & Loss','লাভ & ক্ষতি','79','No','Debit/Credit','79','1zszf10k','','','','Yes'),(82,'','Ratio Analysis','অনুপাত বিশ্লেষণ','79','No','Debit/Credit','79','','','','','Yes'),(83,'','Audit Voucher','অডিট ভাউচার','56','No','Debit/Credit','56','','','','','Yes'),(84,'','Block Voucher','ব্লক ভাউচার','56','No','Debit/Credit','56','','','','','Yes'),(85,'','Pending Voucher','মুলতুবি ভাউচার','56','No','Debit/Credit','56','','','','','Yes'),(86,'','Cancel Voucher','বাতিল ভাউচার','56','No','Debit/Credit','56','','','','','Yes'),(87,'','Negative Stock','নেতিবাচক স্টক','56','No','Debit/Credit','56','','','','','Yes'),(88,'','Negative Ledger','ঋণাত্মক লেজার','56','No','Debit/Credit','56','','','','','Yes'),(89,'','Cancel Account','বাতিল অ্যাকাউন্ট','56','No','Debit/Credit','56','lex2tcn8','','','','Yes'),(90,'','Block Account','ব্লক অ্যাকাউন্ট','56','No','Debit/Credit','56','','','','','Yes'),(91,'','Cheque Receipt','চেক রিসিভ','17','No','Debit','17','etqyltqs','','','','Yes'),(92,'','Cheque Payment','চেক পেমেন্ট','12','No','Credit','12','2zhsci4h','','','','Yes'),(93,'s','Damage Return','ড্যামেজ রিটার্ন','22','No','','22','0okzx75w','jl70und9','0okzx75w','wihme8of','Yes'),(94,'p','Damage Sale','ড্যামেজ বিক্রয়','22','No','Credit','22','0okzx75w','4pu4oen2','0okzx75w','1x5qsyk2','Yes'),(95,'','Quotation','কোটেশন','22','No','','22','frgc5zx0','jl70und9','','wihme8of','Yes'),(96,'','Top Sheet','টপ শীট','79','No','Debit/Credit','79','ez51p53m','','','','Yes');
/*!40000 ALTER TABLE `ac_voucher` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bike_model`
--

DROP TABLE IF EXISTS `bike_model`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `bike_model` (
  `bkm_mid` int(50) NOT NULL AUTO_INCREMENT,
  `bkm_bid` varchar(50) NOT NULL,
  `bkm_brand` varchar(50) NOT NULL,
  `bkm_model` varchar(50) NOT NULL,
  `bkm_cc` varchar(20) NOT NULL,
  `bkm_weight` varchar(20) NOT NULL,
  `bkm_excel` varchar(20) NOT NULL,
  `bkm_tyre` varchar(20) NOT NULL,
  `bkm_tyref` varchar(30) NOT NULL,
  `bkm_tyreb` varchar(30) NOT NULL,
  `bkm_hpower` varchar(30) NOT NULL,
  `bkm_pcountry` varchar(30) NOT NULL,
  `bkm_mcountry` varchar(30) NOT NULL,
  `bkm_wbase` varchar(30) NOT NULL,
  `bkm_clinder` varchar(30) NOT NULL,
  `bkm_capacity` varchar(10) NOT NULL,
  `bkm_fuel` varchar(10) NOT NULL,
  `bkm_img_1` blob DEFAULT NULL,
  `bkm_img_2` blob DEFAULT NULL,
  `bkm_img_3` blob DEFAULT NULL,
  `bkm_vat` varchar(50) NOT NULL,
  `bkm_status` varchar(10) NOT NULL,
  PRIMARY KEY (`bkm_mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bike_model`
--

LOCK TABLES `bike_model` WRITE;
/*!40000 ALTER TABLE `bike_model` DISABLE KEYS */;
/*!40000 ALTER TABLE `bike_model` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bike_product`
--

DROP TABLE IF EXISTS `bike_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `bike_product` (
  `bkid` int(50) NOT NULL AUTO_INCREMENT,
  `bk_bid` varchar(10) NOT NULL,
  `bk_store` varchar(10) NOT NULL,
  `bk_model` varchar(10) NOT NULL,
  `bk_chassis` varchar(50) NOT NULL,
  `bk_engine` varchar(50) NOT NULL,
  `bk_info` varchar(50) NOT NULL,
  `bk_color` varchar(20) NOT NULL,
  `bk_year` varchar(10) NOT NULL,
  `bk_qty` varchar(10) NOT NULL,
  `bk_cost` varchar(50) NOT NULL,
  `bk_sale` varchar(50) NOT NULL,
  `bk_crdr` varchar(10) NOT NULL,
  `bk_kupon` varchar(10) NOT NULL,
  `bk_regno` varchar(50) NOT NULL,
  `bk_treasury` varchar(50) NOT NULL,
  `bk_gdate` date NOT NULL,
  `bk_rec_date` date NOT NULL,
  `bk_date` date NOT NULL,
  `bk_userid` varchar(20) NOT NULL,
  `bk_status` varchar(10) NOT NULL,
  PRIMARY KEY (`bkid`),
  KEY `bk_chassis` (`bk_chassis`),
  KEY `bk_engine` (`bk_engine`),
  KEY `bk_color` (`bk_color`),
  KEY `bk_year` (`bk_year`),
  KEY `bk_gdate` (`bk_gdate`),
  KEY `bk_rec_date` (`bk_rec_date`),
  KEY `bk_date` (`bk_date`),
  KEY `bk_regno` (`bk_regno`),
  KEY `bk_treasury` (`bk_treasury`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bike_product`
--

LOCK TABLES `bike_product` WRITE;
/*!40000 ALTER TABLE `bike_product` DISABLE KEYS */;
/*!40000 ALTER TABLE `bike_product` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `company` (
  `co_bid` int(11) NOT NULL AUTO_INCREMENT,
  `co_parent` varchar(30) NOT NULL,
  `co_group` varchar(30) NOT NULL,
  `co_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_owner` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_ph_code` varchar(50) NOT NULL,
  `co_phone` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_website` varchar(200) NOT NULL,
  `co_email` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_address` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_country` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_state` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_pin` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_financial_year` date NOT NULL,
  `co_sender` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_bin_code` varchar(100) NOT NULL,
  `co_gst` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_currency` varchar(50) NOT NULL,
  `co_decimal` varchar(50) NOT NULL,
  `co_permission` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_session_out` varchar(20) NOT NULL DEFAULT '1800',
  `co_terms_cash` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_terms_credit` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_terms_install` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_terms_other` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `co_inv_theme` varchar(100) NOT NULL DEFAULT 'default_invoice',
  `co_logo` longblob DEFAULT NULL,
  `co_size` varchar(200) NOT NULL,
  `co_signature` mediumblob DEFAULT NULL,
  `co_si_size` varchar(200) NOT NULL,
  `co_pad` longblob DEFAULT NULL,
  `co_stock_group` varchar(50) NOT NULL,
  `co_contra_send` varchar(50) NOT NULL,
  `co_status` varchar(50) NOT NULL,
  PRIMARY KEY (`co_bid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `company` WRITE;
/*!40000 ALTER TABLE `company` DISABLE KEYS */;
INSERT INTO `company` VALUES (1,'0','Yes','Accounting','Head_Office','Mohammad Ali','88','01912999220','www.tally-book.com','demo@gmail.com','Champatoli lane, Sawarighat, Dhaka-1211','Bangladesh','Dhaka','0012','1234','2025-10-31','','1','No','','3','abrixhg,vjdljai,re8pfi5,ldt2svl,uz5nl2xu,i0zl2ad,i68n9lz,9dnueza,axv836z,34fe0mi,n172fw3,v9a41zd,63hyatx,xqmi03f,re6qgl2,q9965f9,wqtxy38,zfm0re4,6nmpo7i,vv92ppz,9x45hdk,ad758fa,egx7gd8,,7c2jt1a,lm2265k,a763vdn,m23Pr2h,cqk8rwy,hs8c6bi,81ek4au,r3d0kaej,k5pagdk0,4pu4oen2,qre52387,82wbvp77,b2n06skn,0okzx75w,jl70und9,sy7b12q3,q5yjw36o,jy37ifur,4rxncyg0,h9z5vfvp,0eh3g9nr,1v4djezx,49wjv7a1,zlzsoh8f,51nf8p28,z6j7vr9d,d6ln377g,vdzx5b6o,8kctrzvr,a1929ml9,ijnx8wk5,5i88x160,9tbvouiz,6s16ckcw,553cag2i,hlmqa5v4,6kmhctw4,7jgvlkdh,bp29gntj,vws4fobk,eqpzo2w2,rj29idzg,4n89p3pt,cgye6zn4,0q5gtdye,9wczircj,wihme8of,1zszf10k,1x5qsyk2,2mecrcvm,1du6mw68,1v9iespw,5ld3du9l,ortr4ox8,3z30fq94,lex2tcn8,1l6hd2en,5jwh17i4,70d6oqar,0vdnxa4,eqoc14g,etqyltqs,pub43w1z,t23k63xa,2zhsci4h,x8qc2fvk,a7r9rn1,rbau3vhl,wmTxdazy1','600','','','','','default_invoice','','max-width:150px;height:55px','','max-width:150px;height:55px','','0','','Yes'),(2,'1','No','Electronics','Adil Mobile Gallery','Mohammad Ali','88','01912999220','','demo@gmail.com','Champatoli lane, Sawarighat, Dhaka-1211','Bangladesh','Dhaka','0012','1234','2025-10-31','','1','No','','3','abrixhg,re8pfi5,0vdnxa4,eqoc14g,ldt2svl,dcls3ea,i0zl2ad,9dnueza,axv836z,6ctuo2o0,34fe0mi,n172fw3,v9a41zd,63hyatx,xqmi03f,re6qgl2,q9965f9,wqtxy38,zfm0re4,6nmpo7i,vv92ppz,9x45hdk,ad758fa,mv3dh2h,egx7gd8,7c2jt1a,lm2265k,a763vdn,m23Pr2h,10t1hz2,0d5giuf,3nqf3jr,cqk8rwy,hs8c6bi,81ek4au,r3d0kaej,c9ou2een,1nl23z0w,lnrfprpg,h74a7v9s,px2wz0oj,uz5nl2xu,k5pagdk0,4pu4oen2,zp803ye2,qre52387,82wbvp77,0okzx75w,jl70und9,sy7b12q3,q5yjw36o,jy37ifur,4rxncyg0,h9z5vfvp,1v4djezx,8ksazvrr,ijnx8wk5,jwmy28qw,5i88x160,kn5bzhis,6s16ckcw,553cag2i,hlmqa5v4,6kmhctw4,7jgvlkdh,bp29gntj,vws4fobk,eqpzo2w2,rj29idzg,4n89p3pt,cgye6zn4,0q5gtdye,9wczircj,2mecrcvm,1x5qsyk2,wihme8of,1zszf10k,1du6mw68,5ld3du9l,3z30fq94,lex2tcn8,1v9iespw,1l6hd2en,c4hbrkxp,70d6oqar,t23k63xa,pub43w1z,kblp8g6n,368csk7t,x8qc2fvk,vltw6qx5,lexlq9p,5cf4jcy9,b1lwvsr5,g14kjkj6,f7dvpuop,n76gagg8,6liq349c,t8mqu8pg,gmpot4hj,62yec4k,if6dufve,84bw80nh','1800','','','','','default_invoice','','max-width:150px;height:55px','','max-width:150px;height:55px','','0','','Yes');
/*!40000 ALTER TABLE `company` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `day_close`
--

DROP TABLE IF EXISTS `day_close`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `day_close` (
  `day_id` int(11) NOT NULL AUTO_INCREMENT,
  `day_bid` int(10) NOT NULL,
  `day_device` varchar(50) NOT NULL,
  `day_device_ip` varchar(50) NOT NULL,
  `day_userid` varchar(50) NOT NULL,
  `day_latitude` varchar(50) NOT NULL,
  `day_longitude` varchar(50) NOT NULL,
  `day_date` date NOT NULL,
  `day_time` time NOT NULL,
  `day_modify` datetime NOT NULL,
  `day_status` varchar(20) NOT NULL,
  PRIMARY KEY (`day_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `day_close`
--

LOCK TABLES `day_close` WRITE;
/*!40000 ALTER TABLE `day_close` DISABLE KEYS */;
/*!40000 ALTER TABLE `day_close` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ele_order`
--

DROP TABLE IF EXISTS `ele_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ele_order` (
  `or_oid` bigint(100) NOT NULL AUTO_INCREMENT,
  `or_bid` int(10) NOT NULL,
  `or_acid` varchar(100) NOT NULL,
  `or_invoice` varchar(100) NOT NULL,
  `or_type` varchar(50) NOT NULL,
  `or_pid` int(20) NOT NULL,
  `or_mid` varchar(10) NOT NULL,
  `or_chassis` varchar(50) NOT NULL,
  `or_note` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `or_pack` varchar(30) NOT NULL,
  `or_pcs` varchar(30) NOT NULL,
  `or_qty` varchar(50) NOT NULL,
  `or_cost` varchar(50) NOT NULL,
  `or_th_cost` varchar(50) NOT NULL,
  `or_sale` varchar(50) NOT NULL,
  `or_dis_pr` varchar(50) NOT NULL,
  `or_subtotal` varchar(50) NOT NULL,
  `or_date` date NOT NULL,
  `or_time` time NOT NULL,
  `or_user` varchar(10) NOT NULL,
  `or_status` varchar(10) NOT NULL,
  PRIMARY KEY (`or_oid`),
  KEY `or_invoice` (`or_invoice`),
  KEY `or_bid` (`or_bid`),
  KEY `or_type` (`or_type`),
  KEY `or_pid` (`or_pid`),
  KEY `or_chassis` (`or_chassis`),
  KEY `or_note` (`or_note`),
  KEY `or_pcs` (`or_pcs`),
  KEY `or_qty` (`or_qty`),
  KEY `or_subtotal` (`or_subtotal`),
  KEY `or_date` (`or_date`),
  KEY `or_user` (`or_user`),
  KEY `or_status` (`or_status`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ele_order`
--

LOCK TABLES `ele_order` WRITE;
/*!40000 ALTER TABLE `ele_order` DISABLE KEYS */;
INSERT INTO `ele_order` VALUES (1,2,'','EPU-20251103-151633-1530','EPU',1,'','','','0','0','4','10','0','','0','40','2025-11-03','17:16:30','2','1'),(2,2,'','SAL-20251103-152036-2933','SAL',1,'','','','0 ','0 ','1','10','','20','0','20','2025-11-03','17:20:33','2','1');
/*!40000 ALTER TABLE `ele_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_barcode`
--

DROP TABLE IF EXISTS `inv_barcode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inv_barcode` (
  `br_id` bigint(100) NOT NULL AUTO_INCREMENT,
  `br_bid` int(10) NOT NULL,
  `br_inv_pid` int(11) NOT NULL,
  `br_barcode` varchar(100) NOT NULL,
  `br_in_date` date NOT NULL,
  `br_invoice_pu` varchar(100) NOT NULL,
  `br_out_date` date NOT NULL,
  `br_invoice_sa` varchar(100) NOT NULL,
  `br_invoice_sa_dl` varchar(100) NOT NULL,
  `bf_status` varchar(3) NOT NULL,
  PRIMARY KEY (`br_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inv_barcode`
--

LOCK TABLES `inv_barcode` WRITE;
/*!40000 ALTER TABLE `inv_barcode` DISABLE KEYS */;
INSERT INTO `inv_barcode` VALUES (1,2,1,'39913392','0000-00-00','','0000-00-00','','','Yes'),(2,2,1,'1111','2025-11-03','EPU-20251103-151633-1530','2025-11-03','SAL-20251103-152036-2933','','0'),(3,2,1,'2222','2025-11-03','EPU-20251103-151633-1530','0000-00-00','','','1'),(4,2,1,'4444','2025-11-03','EPU-20251103-151633-1530','0000-00-00','','','1'),(5,2,1,'666','2025-11-03','EPU-20251103-151633-1530','0000-00-00','','','1');
/*!40000 ALTER TABLE `inv_barcode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_group`
--

DROP TABLE IF EXISTS `inv_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inv_group` (
  `inv_gid` int(20) NOT NULL AUTO_INCREMENT,
  `inv_pic` varchar(200) NOT NULL,
  `inv_gbid` varchar(50) NOT NULL,
  `inv_g_name` varchar(200) NOT NULL,
  `inv_parent` varchar(20) NOT NULL,
  `inv_group` varchar(20) NOT NULL,
  `inv_form_type` varchar(100) NOT NULL,
  `inv_status` varchar(20) NOT NULL,
  `inv_active` varchar(20) NOT NULL,
  PRIMARY KEY (`inv_gid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inv_group`
--

LOCK TABLES `inv_group` WRITE;
/*!40000 ALTER TABLE `inv_group` DISABLE KEYS */;
INSERT INTO `inv_group` VALUES (1,'','2','Mobile','0','Yes','Goods','0','Yes'),(2,'','2','Smarts Phone','1','Yes','Goods','1','Yes'),(3,'','2','Batton Phone','1','Yes','Goods','1','Yes'),(4,'','2','Oppo','2','No','Goods','2','Yes'),(5,'','2','Vivo','2','No','Goods','2','Yes'),(6,'','2','Itel','2','No','Goods','2','Yes'),(7,'','2','Symphony ','2','No','Goods','2','Yes'),(8,'','2','Infinix','0','No','Automobiles','0','Yes');
/*!40000 ALTER TABLE `inv_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_price`
--

DROP TABLE IF EXISTS `inv_price`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inv_price` (
  `inp_pid` int(11) NOT NULL AUTO_INCREMENT,
  `inp_bid` smallint(6) NOT NULL,
  `inp_acid` varchar(100) NOT NULL,
  `inp_prid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `inp_details` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `inp_cost` varchar(50) NOT NULL,
  `inp_c_dis` varchar(50) NOT NULL,
  `inp_s_dis` varchar(50) NOT NULL,
  `inp_sale` varchar(50) NOT NULL,
  `inp_auto` varchar(10) NOT NULL,
  `inp_status` varchar(20) NOT NULL,
  PRIMARY KEY (`inp_pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inv_price`
--

LOCK TABLES `inv_price` WRITE;
/*!40000 ALTER TABLE `inv_price` DISABLE KEYS */;
/*!40000 ALTER TABLE `inv_price` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_product`
--

DROP TABLE IF EXISTS `inv_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inv_product` (
  `inv_pid` int(50) NOT NULL AUTO_INCREMENT,
  `inv_bid` int(5) NOT NULL,
  `inv_gid` int(10) NOT NULL,
  `inv_sid` int(10) NOT NULL,
  `inv_type` varchar(50) NOT NULL,
  `inv_code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `inv_part_no` varchar(100) NOT NULL,
  `inv_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `inv_details` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `inv_unit` varchar(50) NOT NULL,
  `inv_decimal` varchar(20) NOT NULL,
  `inv_packing` varchar(50) NOT NULL,
  `inv_color` varchar(50) NOT NULL,
  `inv_alart` varchar(20) NOT NULL,
  `inv_warranty` varchar(50) NOT NULL,
  `inv_free1` varchar(50) NOT NULL,
  `inv_free2` varchar(50) NOT NULL,
  `inv_qty` varchar(50) NOT NULL,
  `inv_mrp` varchar(50) NOT NULL,
  `inv_cost` varchar(50) NOT NULL,
  `inv_cost_p` varchar(50) NOT NULL,
  `inv_avarage` varchar(50) NOT NULL,
  `inv_sale` varchar(50) NOT NULL,
  `inv_sale_p` varchar(50) NOT NULL,
  `inv_online` varchar(50) NOT NULL,
  `inv_sdate` date NOT NULL,
  `inv_edate` date NOT NULL,
  `inv_pic1` longblob NOT NULL,
  `inv_pic2` blob NOT NULL,
  `inv_pic3` blob NOT NULL,
  `inv_status` varchar(50) NOT NULL,
  PRIMARY KEY (`inv_pid`),
  KEY `idx_inv_product_code` (`inv_code`),
  KEY `idx_inv_product_name` (`inv_name`),
  KEY `idx_inv_product_bid` (`inv_bid`),
  KEY `idx_inv_product_pid` (`inv_pid`,`inv_type`),
  KEY `idx_inv_details` (`inv_details`(255))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inv_product`
--

LOCK TABLES `inv_product` WRITE;
/*!40000 ALTER TABLE `inv_product` DISABLE KEYS */;
INSERT INTO `inv_product` VALUES (1,2,4,1,'Goods','39913392','','a3x','4/64','','No','PCS','black','2','','','','','20','10','0','','20','0','0','0000-00-00','0000-00-00','','','','Yes');
/*!40000 ALTER TABLE `inv_product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_store`
--

DROP TABLE IF EXISTS `inv_store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inv_store` (
  `inv_sid` int(20) NOT NULL AUTO_INCREMENT,
  `inv_bid` int(4) NOT NULL,
  `inv_stname` varchar(200) NOT NULL,
  `inv_parent` varchar(20) NOT NULL,
  `inv_group` varchar(20) NOT NULL,
  `inv_status` varchar(20) NOT NULL,
  `inv_active` varchar(20) NOT NULL,
  PRIMARY KEY (`inv_sid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inv_store`
--

LOCK TABLES `inv_store` WRITE;
/*!40000 ALTER TABLE `inv_store` DISABLE KEYS */;
INSERT INTO `inv_store` VALUES (1,2,'Warehouse-1','0','Yes','0','Yes'),(2,2,'Warehouse-2','0','Yes','0','Yes'),(3,2,'Line-1','1','No','1','Yes'),(4,2,'Line-2','1','No','1','Yes'),(5,2,'Line-3','2','No','2','Yes'),(6,2,'Line-4','2','No','2','Yes');
/*!40000 ALTER TABLE `inv_store` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_transfer`
--

DROP TABLE IF EXISTS `inv_transfer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inv_transfer` (
  `itr_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `itr_bid` int(11) NOT NULL,
  `itr_brid` int(11) NOT NULL,
  `itr_invoice` varchar(100) NOT NULL,
  `itr_ename` varchar(100) NOT NULL,
  `itr_mobile` varchar(15) NOT NULL,
  `itr_sdate` date NOT NULL,
  `itr_stime` time NOT NULL,
  `itr_rdate` date NOT NULL,
  `itr_rtime` time NOT NULL,
  `itr_suserid` int(11) NOT NULL,
  `itr_ruserid` int(11) NOT NULL,
  `itr_date` datetime NOT NULL DEFAULT current_timestamp(),
  `itr_status` varchar(50) NOT NULL,
  PRIMARY KEY (`itr_id`),
  KEY `itr_invoice` (`itr_invoice`),
  KEY `itr_status` (`itr_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inv_transfer`
--

LOCK TABLES `inv_transfer` WRITE;
/*!40000 ALTER TABLE `inv_transfer` DISABLE KEYS */;
/*!40000 ALTER TABLE `inv_transfer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_unit`
--

DROP TABLE IF EXISTS `inv_unit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inv_unit` (
  `un_id` int(11) NOT NULL AUTO_INCREMENT,
  `un_bid` varchar(10) NOT NULL,
  `un_name` varchar(30) NOT NULL,
  `un_min_name` varchar(30) NOT NULL,
  `un_qty` varchar(50) NOT NULL,
  `un_info` varchar(30) NOT NULL,
  `un_status` varchar(5) NOT NULL,
  PRIMARY KEY (`un_id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inv_unit`
--

LOCK TABLES `inv_unit` WRITE;
/*!40000 ALTER TABLE `inv_unit` DISABLE KEYS */;
INSERT INTO `inv_unit` VALUES (1,'1','PCS','','1','PCS-PIECES','Yes'),(2,'1','BOX','','1','BOX-BOX','Yes'),(3,'1','KG','','1','KGS-KILOGRAMS','Yes'),(4,'1','LITER','','1','LTR-LITRES','Yes'),(5,'1','BAG','','1','BAG-BAGS','Yes'),(6,'1','CARTON','','1','CTN-CARTONS','Yes'),(7,'1','TON','','1','TON-TONNES','Yes'),(8,'1','GRAM','','1','GMS-GRAMS','Yes'),(9,'1','DOZEN','','1','DOZ-DOZEN','Yes'),(10,'1','CM','','1','CMS-CENTIMETER','Yes'),(11,'1','PACK','','1','PAC-PACKS','Yes'),(12,'1','ML','','1','MLT-MILLILITRE','Yes'),(13,'1','KM','','1','KME-KILOMETRE','Yes'),(14,'1','BUNDLE','','1','BDL-BUNDLES','Yes'),(15,'1','BOTTLE','','1','BTL-BOTTLES','Yes'),(16,'1','CAN','','1','CAN-CANS','Yes'),(17,'1','INJ','','1','PCS-PIECES','Yes'),(18,'1','KLR','','1','KLR-KILOLITER','Yes'),(19,'1','MTR','','1','MTR-METERS','Yes'),(20,'1','NOS','','1','NOS-NUMBERS','Yes'),(21,'1','SET','','1','SET-SETS','Yes'),(22,'1','QTL','','1','QTL-QUINTAL','Yes'),(23,'1','STRIP','','1','PCS-PIECES','Yes'),(24,'1','TUBE','','1','TUB-TUBES','Yes'),(25,'1','Others','','1','','No'),(26,'2','PCS','','1','PCS-PIECES','Yes'),(27,'2','BOX','','1','BOX-BOX','Yes'),(28,'2','KG','','1','KGS-KILOGRAMS','Yes'),(29,'2','LITER','','1','LTR-LITRES','Yes'),(30,'2','BAG','','1','BAG-BAGS','Yes'),(31,'2','CARTON','','1','CTN-CARTONS','Yes'),(32,'2','TON','','1','TON-TONNES','Yes'),(33,'2','GRAM','','1','GMS-GRAMS','Yes'),(34,'2','DOZEN','','1','DOZ-DOZEN','Yes'),(35,'2','CM','','1','CMS-CENTIMETER','Yes'),(36,'2','PACK','','1','PAC-PACKS','Yes'),(37,'2','ML','','1','MLT-MILLILITRE','Yes'),(38,'2','KM','','1','KME-KILOMETRE','Yes'),(39,'2','BUNDLE','','1','BDL-BUNDLES','Yes'),(40,'2','BOTTLE','','1','BTL-BOTTLES','Yes'),(41,'2','CAN','','1','CAN-CANS','Yes'),(42,'2','INJ','','1','PCS-PIECES','Yes'),(43,'2','KLR','','1','KLR-KILOLITER','Yes'),(44,'2','MTR','','1','MTR-METERS','Yes'),(45,'2','NOS','','1','NOS-NUMBERS','Yes'),(46,'2','SET','','1','SET-SETS','Yes'),(47,'2','QTL','','1','QTL-QUINTAL','Yes'),(48,'2','STRIP','','1','PCS-PIECES','Yes'),(49,'2','TUBE','','1','TUB-TUBES','Yes'),(50,'2','Others','','1','Others','Yes');
/*!40000 ALTER TABLE `inv_unit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_ctrl`
--

DROP TABLE IF EXISTS `user_ctrl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_ctrl` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT,
  `us_bid` int(10) NOT NULL,
  `us_acid` int(20) NOT NULL,
  `us_cash_id` int(10) NOT NULL,
  `us_ugid` varchar(20) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `us_cr_date` date NOT NULL,
  `us_language` varchar(2) NOT NULL,
  `style_css_d` longtext NOT NULL,
  `us_theme` varchar(100) NOT NULL,
  `display_ctrl` longtext NOT NULL,
  `us_status` varchar(20) NOT NULL,
  PRIMARY KEY (`user_id`),
  KEY `username` (`username`),
  KEY `password` (`password`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_ctrl`
--

LOCK TABLES `user_ctrl` WRITE;
/*!40000 ALTER TABLE `user_ctrl` DISABLE KEYS */;
INSERT INTO `user_ctrl` VALUES (1,1,5,0,'1','sadmin','sadmin','2025-10-31','2','','','','Yes'),(2,2,10,0,'1','admin','admin','2025-10-31','2','','','','Yes');
/*!40000 ALTER TABLE `user_ctrl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_g_ctrl`
--

DROP TABLE IF EXISTS `user_g_ctrl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_g_ctrl` (
  `ugid` int(50) NOT NULL AUTO_INCREMENT,
  `bid` int(10) NOT NULL,
  `group_name` varchar(100) NOT NULL,
  `user_permission` longtext NOT NULL,
  `ug_date` date NOT NULL,
  `ug_status` varchar(10) NOT NULL,
  PRIMARY KEY (`ugid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_g_ctrl`
--

LOCK TABLES `user_g_ctrl` WRITE;
/*!40000 ALTER TABLE `user_g_ctrl` DISABLE KEYS */;
INSERT INTO `user_g_ctrl` VALUES (1,1,'Super Admin','abrixhg,vjdljai,re8pfi5,0vdnxa4,eqoc14g,ldt2svl,uz5nl2xu,i0zl2ad,i68n9lz,9dnueza,axv836z,34fe0mi,n172fw3,v9a41zd,63hyatx,xqmi03f,re6qgl2,q9965f9,wqtxy38,zfm0re4,6nmpo7i,vv92ppz,9x45hdk,lexlq9p,6ctuo2o0,62yec4k,uz5nl2xu,kn5bzhis,ad758fa,egx7gd8,0d5giuf,c9ou2een,px2wz0oj,jwmy28qw,dcls3ea,10t1hz2,3nqf3jr,lnrfprpg,h74a7v9s,1nl23z0w,7c2jt1a,lm2265k,a763vdn,m23Pr2h,cqk8rwy,hs8c6bi,81ek4au,r3d0kaej,k5pagdk0,4pu4oen2,qre52387,82wbvp77,b2n06skn,0okzx75w,jl70und9,sy7b12q3,q5yjw36o,jy37ifur,4rxncyg0,h9z5vfvp,0eh3g9nr,1v4djezx,49wjv7a1,zlzsoh8f,51nf8p28,z6j7vr9d,d6ln377g,vdzx5b6o,8kctrzvr,a1929ml9,ijnx8wk5,,5i88x160,9tbvouiz,6s16ckcw,553cag2i,hlmqa5v4,6kmhctw4,7jgvlkdh,bp29gntj,vws4fobk,eqpzo2w2,rj29idzg,4n89p3pt,cgye6zn4,0q5gtdye,9wczircj,wihme8of,1zszf10k,1x5qsyk2,2mecrcvm,1du6mw68,nekh8nkg,1v9iespw,5ld3du9l,ortr4ox8,lex2tcn8,1l6hd2en,5jwh17i4,6liq349c,n76gagg8,f7dvpuop,c4hbrkxp,t8mqu8pg,g14kjkj6,b1lwvsr5,vltw6qx5','2025-10-31','0');
/*!40000 ALTER TABLE `user_g_ctrl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'cd_adilmobi_4305ab'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-04-17  3:30:02
