--
-- Host: localhost    Database: aemposinst
-- ------------------------------------------------------


--
-- Table structure for table `app_acct_account_group`
--

CREATE TABLE `app_acct_account_group` (
  `Id` int NOT NULL,
  `Code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_acct_account_group`
--


--
-- Table structure for table `app_acct_chart_of_account`
--

CREATE TABLE `app_acct_chart_of_account` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `AccountNatureId` int DEFAULT NULL,
  `ParentAccountId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `AllowReconciliation` int DEFAULT NULL,
  `OpeningBalance` double DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_acct_chart_of_account`
--

INSERT INTO `app_acct_chart_of_account` VALUES (1,'112','ACCOUNT RECEIVABLE','ACCOUNT RECEIVABLE',1,-1,1,1,NULL,NULL,NULL,NULL,0),(2,'210','ACCOUNT PAYABLE','ACCOUNT PAYABLE',2,-1,1,1,NULL,NULL,NULL,NULL,0),(3,'110','CASH','CASH',1,-1,1,1,'2024-07-01 09:24:29',NULL,NULL,1,5455),(4,'111','NOTES RECEIVABLE','NOTES RECEIVABLE',1,-1,1,1,'2024-07-01 09:30:37',NULL,NULL,1,0),(5,'113','INTEREST RECEIVABLE','INTEREST RECEIVABLE',1,-1,1,1,'2024-07-03 10:29:26',NULL,NULL,1,0),(6,'115','MERCHANDISE INVENTORY','MERCHANDISE INVENTORY',1,-1,1,1,'2024-07-03 10:45:34',NULL,NULL,1,0),(7,'116','OFFICE SUPPLIES','OFFICE SUPPLIES',1,-1,1,1,NULL,NULL,NULL,1,0),(8,'117','PREPAID INSURANCE','PREPAID INSURANCE',1,-1,1,1,NULL,NULL,NULL,1,0),(9,'120','LAND','LAND',1,-1,1,1,NULL,NULL,NULL,1,0),(10,'123','STORE EQUIPMENT','STORE EQUIPMENT',1,-1,1,1,NULL,NULL,NULL,1,0),(11,'124','ACCOUMULATED DEPRECIATION-STORE EQUIPMENT','ACCOUMULATED DEPRECIATION-STORE EQUIPMENT',1,-1,1,1,NULL,NULL,NULL,NULL,NULL),(12,'125','OFFICE EQUIPMENT','OFFICE EQUIPMENT',1,-1,1,1,NULL,NULL,NULL,NULL,NULL),(13,'126','ACCUMULATED DEPRECIATION-OFFICE EQUIPMENT','ACCUMULATED DEPRECIATION-OFFICE EQUIPMENT',1,-1,1,1,NULL,NULL,NULL,NULL,NULL),(14,'211','SALARIES PAYABLE','SALARIES PAYABLE',2,-1,1,1,NULL,NULL,NULL,NULL,NULL),(15,'212','UNEARNED RENT','UNEARNED RENT',2,-1,1,1,NULL,NULL,NULL,NULL,NULL),(16,'215','NOTES PAYABLE','NOTES PAYABLE',2,-1,1,1,NULL,NULL,NULL,NULL,NULL),(17,'310','CAPITAL STOCK','CAPITAL STOCK',3,-1,1,1,NULL,NULL,NULL,NULL,NULL),(18,'311','RETAINED EARNINGS','RETAINED EARNINGS',3,-1,1,1,NULL,NULL,NULL,NULL,NULL),(19,'312','DIVIDENDS','DIVIDENDS',3,-1,1,1,NULL,NULL,NULL,NULL,NULL),(20,'313','INCOME SUMMARY','INCOME SUMMARY',3,-1,1,1,NULL,NULL,NULL,NULL,NULL),(21,'410','SALES','SALES',4,-1,1,1,NULL,NULL,NULL,NULL,NULL),(22,'411','SALES RETURN AND ALLOWANCES','SALES RETURN AND ALLOWANCES',4,-1,1,1,NULL,NULL,NULL,NULL,NULL),(23,'412','SALES DISCOUNT','SALES DISCOUNT',4,-1,1,1,NULL,NULL,NULL,NULL,NULL),(24,'510','COST OF GOODS SOLD','COST OF GOODS SOLD',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(25,'520','SALES SALARIES EXPENSES','SALES SALARIES EXPENSES',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(26,'521','ADVERTISING EXPENSE','ADVERTISING EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(27,'522','DEPRECIATION EXPENSE-STORE EQUIPMENT','DEPRECIATION EXPENSE-STORE EQUIPMENT',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(28,'529','MISCELLANEOUS SELLING EXPENSE','MISCELLANEOUS SELLING EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(29,'530','OFFICE SALARIES EXPENSE','OFFICE SALARIES EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(30,'531','RENT EXPENSE','RENT EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(31,'532','DEPRECIATION EXPENSE-OFFICE EQUIPMENT','DEPRECIATION EXPENSE-OFFICE EQUIPMENT',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(32,'533','INSURANCE EXPENSE','INSURANCE EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(33,'534','OFFICE SUPPLIES EXPENSE','OFFICE SUPPLIES EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL),(34,'539','MISCELLANEOUS ADMIN  EXPENSE','MISCELLANEOUS ADMIN  EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `app_acct_ledger_entries`
--

CREATE TABLE `app_acct_ledger_entries` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `TransactionId` bigint DEFAULT NULL,
  `TransactionTable` varchar(255) DEFAULT NULL,
  `BookingDate` datetime DEFAULT NULL,
  `Notes` longtext,
  `DocNo` varchar(45) DEFAULT NULL,
  `VType` varchar(45) DEFAULT NULL,
  `DebitAmount` decimal(10,0) DEFAULT NULL,
  `CreditAmount` decimal(10,0) DEFAULT NULL,
  `AccountId` int DEFAULT NULL,
  `FinanicalYearId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifedDate` datetime DEFAULT NULL,
  `PaymentType` varchar(45) DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_acct_ledger_entries`
--

INSERT INTO `app_acct_ledger_entries` VALUES (1,7,'CUSTOMERPAYMENT','2024-07-03 00:00:00','note','','CP',0,NULL,NULL,1,1,1,'2024-07-03 11:07:13',NULL,NULL,'CREDIT',1),(2,8,'CUSTOMERPAYMENT','2024-07-03 00:00:00',NULL,'','CP',0,1000,NULL,1,1,1,'2024-07-03 11:13:11',NULL,NULL,'CREDIT',1),(3,9,'CUSTOMERPAYMENT','2024-07-03 00:00:00',NULL,'','CP',0,15000,6,1,1,1,'2024-07-03 11:15:02',NULL,NULL,'CREDIT',1),(4,10,'CUSTOMERPAYMENT','2024-07-04 00:00:00',NULL,'','CP',0,20000,6,1,1,1,'2024-07-03 11:57:28',NULL,NULL,'CREDIT',1);

--
-- Table structure for table `app_acct_nature_of_account`
--

CREATE TABLE `app_acct_nature_of_account` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `AccountGroupId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_acct_nature_of_account`
--

INSERT INTO `app_acct_nature_of_account` VALUES (1,'100','ASSETS','ASSETS',1,1,NULL,NULL,NULL,NULL),(2,'02','LIABILITIES','LIABILITIES',1,1,NULL,NULL,NULL,NULL),(3,'03','EQUITY','EQUITY',1,1,NULL,NULL,NULL,NULL),(4,'04','REVENUES','REVENUES',1,1,NULL,NULL,NULL,NULL),(5,'05','COSTS AND EXPENSES','COSTS AND EXPENSES',1,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `app_gen_setting_payment_type`
--

CREATE TABLE `app_gen_setting_payment_type` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  `ModififedBy` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_gen_setting_payment_type`
--

INSERT INTO `app_gen_setting_payment_type` VALUES (1,'CASH','CASH','CASH',1,NULL,NULL,NULL,NULL),(2,'CREDIT','CREDIT','CREDIT',1,NULL,NULL,NULL,NULL),(3,'RETURN','RETURN','RETURN',1,NULL,NULL,NULL,NULL),(4,'BANK TRANSFER','BANK TRANSFER','BANK TRANSFER',1,NULL,NULL,NULL,NULL),(5,'ONLINE BANK TRANSFER','ONLINE BANK TRANSFER','ONLINE BANK TRANSFER',1,NULL,NULL,NULL,NULL),(6,'CHEQUE','CHEQUE','CHEQUE',1,NULL,NULL,NULL,NULL),(7,'ADVANCE PAYMENT','ADVANCE PAYMENT','ADVANCE PAYMENT',1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `app_hr_department`
--

CREATE TABLE `app_hr_department` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_hr_department`
--


--
-- Table structure for table `app_hr_designation`
--

CREATE TABLE `app_hr_designation` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_hr_designation`
--


--
-- Table structure for table `app_inv_customer`
--

CREATE TABLE `app_inv_customer` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `CustomerName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PhoneNo` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MobileNo` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `EmailAddress` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TempAddress` text COLLATE utf8mb4_general_ci,
  `PermanentAddress` text COLLATE utf8mb4_general_ci,
  `OpeningBalance` double DEFAULT NULL,
  `CustomerTypeId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `CustomerCode` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ContactPerson` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DiscountTypeId` int DEFAULT NULL,
  `DiscountPerFlat` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DiscountValue` double DEFAULT NULL,
  `TaxStatus` int DEFAULT NULL,
  `ChartOfAccountId` int DEFAULT NULL,
  `SaleTaxRegNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `NTNNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CNIC` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Picture` text COLLATE utf8mb4_general_ci,
  `Description` text COLLATE utf8mb4_general_ci,
  `CreditLimit` double DEFAULT '0',
  `MaxDiscountAllow` decimal(10,0) DEFAULT '0',
  `CustomerResidenceTypeId` int DEFAULT NULL,
  `MobileNoTwo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Location` text COLLATE utf8mb4_general_ci,
  `AddressUr` text COLLATE utf8mb4_general_ci,
  `ResidenceDuration` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LocationPicture` text COLLATE utf8mb4_general_ci,
  `CNICFrontPicture` text COLLATE utf8mb4_general_ci,
  `CNICBackPicture` int DEFAULT NULL,
  `AccountNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PreAccountNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FatherName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Occupation` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CustomerNameUr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Bussiness` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_customer`
--

INSERT INTO `app_inv_customer` VALUES (1,'445','dfs','dsf','dsf','dsf','dsfdsf',0,2,1,'2024-03-18 20:25:45',1,'2024-03-21 15:59:41',1,'34update','gfh',NULL,NULL,NULL,1,0,'hdfg','dsfds','dgdg','customerimage/120240321154825jedda.png','uodate',0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Nabeel Bin Ezad','03244492569','4545','nabeel.ezad@gmail.com',NULL,'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore Billing',0,3,1,'2024-05-04 07:19:35',1,NULL,NULL,'IC-0000002',NULL,NULL,NULL,NULL,0,0,'dsfdsf','dsfds','dsfsdf',NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'fdsg','sdg','sdfg','fds',NULL,'sdg',454,3,1,'2024-05-04 10:27:55',1,NULL,NULL,'IC-0000003',NULL,NULL,NULL,NULL,1,0,'gsdg','sfdg','dsgsgf','customerimage/120240504102755985px-Laravel.svg.png','zdd',4545,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'nab','34324','a','ba2ghaa','adf','adsf',4,0,1,'2024-07-03 10:23:03',1,NULL,NULL,'CC-0000004','a',NULL,NULL,NULL,0,0,'32','435','4354',NULL,'asdf',55,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'dfdf','dfdsf','dsf','dsf','dsf','sdf',0,0,1,'2024-07-03 10:29:26',1,NULL,NULL,'CC-0000005','dsf',NULL,NULL,NULL,0,5,NULL,NULL,NULL,'',NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'test','asdf','asdf',NULL,NULL,NULL,0,2,1,'2024-07-03 10:45:34',1,NULL,NULL,'CC-0000006',NULL,NULL,NULL,NULL,0,6,NULL,NULL,NULL,'',NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `app_inv_customer_payment`
--

CREATE TABLE `app_inv_customer_payment` (
  `Id` bigint NOT NULL,
  `CustomerInvoiceId` bigint DEFAULT NULL,
  `CustomerId` int DEFAULT NULL,
  `PaymentTypeId` int DEFAULT NULL,
  `BankId` int DEFAULT NULL,
  `BankBranch` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ChkNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ChkDate` date DEFAULT NULL,
  `ChkCashDate` date DEFAULT NULL,
  `PaymentDate` date DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `PaymentNote` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_customer_payment`
--


--
-- Table structure for table `app_inv_customer_type`
--

CREATE TABLE `app_inv_customer_type` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CustomerTypeName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_customer_type`
--

INSERT INTO `app_inv_customer_type` VALUES (1,'01','Walking','Walking',1,NULL,NULL,NULL,NULL),(2,'2','CreditCustomer','CreditCustomer',1,NULL,NULL,NULL,NULL),(3,'03','Inst Customer','Inst Customer',1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `app_inv_delivery_order`
--

CREATE TABLE `app_inv_delivery_order` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `OrderNo` varchar(255) DEFAULT NULL,
  `OrderDate` datetime DEFAULT NULL,
  `RefNo` varchar(255) DEFAULT NULL,
  `OrderStatus` int DEFAULT NULL,
  `CustomerId` int DEFAULT NULL,
  `TaxRateId` int DEFAULT NULL,
  `ShipDate` datetime DEFAULT NULL,
  `EmployeeId` int DEFAULT NULL,
  `SupplyPlaceId` int DEFAULT NULL,
  `Description` longtext CHARACTER SET armscii8 COLLATE armscii8_general_ci,
  `SubTotal` decimal(10,0) DEFAULT NULL,
  `Discount` decimal(10,0) DEFAULT NULL,
  `Tax` decimal(10,0) DEFAULT NULL,
  `Freight` decimal(10,0) DEFAULT NULL,
  `SNo` varchar(255) DEFAULT NULL,
  `Remarks` longtext,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `NetTotal` decimal(10,0) DEFAULT NULL,
  `InvoiceGen` int DEFAULT NULL,
  `TransactionStatus` int DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='			';

--
-- Dumping data for table `app_inv_delivery_order`
--

INSERT INTO `app_inv_delivery_order` VALUES (1,'202406251','2024-06-24 00:00:00','1212',1,1,0,'2024-06-24 00:00:00',3,1,NULL,170150,0,0,NULL,NULL,NULL,1,1,'2024-06-25 06:02:32',NULL,NULL,170150,0,0,1),(2,'202406251','2024-06-24 00:00:00','1212',1,1,0,'2024-06-24 00:00:00',3,1,NULL,170150,0,0,NULL,NULL,NULL,1,1,'2024-06-25 06:04:08',NULL,NULL,170150,0,0,1),(3,'202406252','2024-06-24 00:00:00','1212',1,1,0,'2024-06-24 00:00:00',3,1,NULL,170150,0,0,NULL,NULL,NULL,1,1,'2024-06-25 06:04:34',NULL,NULL,170150,0,0,1),(4,'202406253','2024-06-24 00:00:00','refno',1,1,0,'2024-06-24 00:00:00',3,1,NULL,225000,0,0,NULL,NULL,NULL,1,1,'2024-06-25 06:53:26',NULL,NULL,225000,0,0,1),(5,'202406254','2024-06-25 00:00:00','sdf',1,1,0,'2024-06-25 00:00:00',3,1,NULL,170306,0,67,NULL,NULL,NULL,1,1,'2024-06-25 07:11:41',NULL,NULL,170306,0,0,1),(6,'202406256','2024-06-25 00:00:00','ref',1,1,0,'2024-06-25 00:00:00',3,1,NULL,57750,0,2750,NULL,NULL,NULL,1,1,'2024-06-25 08:31:38',NULL,NULL,57750,0,0,1),(7,'202406257','2024-06-25 00:00:00',NULL,1,-1,0,NULL,-1,1,NULL,1963500,0,93500,NULL,NULL,NULL,1,1,'2024-06-25 08:40:48',NULL,NULL,1963500,0,0,1),(8,'202406258','2024-06-25 00:00:00','testr',1,-1,0,'2024-06-25 00:00:00',3,1,NULL,1963500,0,93500,NULL,NULL,NULL,1,1,'2024-06-25 08:40:56',NULL,NULL,1963500,0,0,1),(9,'202406259','2024-06-25 00:00:00','Ref222',1,1,0,'2024-06-25 00:00:00',3,1,NULL,2068500,0,98500,NULL,NULL,NULL,1,1,'2024-06-25 08:42:43',NULL,NULL,2068500,0,0,1),(10,'2024062510','2024-06-25 00:00:00',NULL,1,-1,17000,NULL,-1,1,NULL,153000,17000,0,NULL,NULL,NULL,1,1,'2024-06-25 09:01:15',NULL,NULL,153000,0,0,1),(11,'2024062511','2024-06-25 00:00:00',NULL,1,1,17000,'2024-06-25 00:00:00',3,1,NULL,161500,17000,8500,NULL,NULL,NULL,1,1,'2024-06-25 09:16:01',NULL,NULL,161500,0,0,1),(12,'2024062512','2024-06-25 00:00:00','Ref',2,1,NULL,'2024-06-25 00:00:00',4,NULL,NULL,170156,0,67,100,NULL,NULL,1,1,'2024-06-25 12:42:05',NULL,NULL,170156,0,0,1);

--
-- Table structure for table `app_inv_delivery_order_detail`
--

CREATE TABLE `app_inv_delivery_order_detail` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `DeliveryOrderId` bigint DEFAULT NULL,
  `ItemId` bigint DEFAULT NULL,
  `PurchasePrice` decimal(10,0) DEFAULT NULL,
  `WholeSalePrice` decimal(10,0) DEFAULT NULL,
  `SalePrice` decimal(10,0) DEFAULT NULL,
  `ActualSalePrice` decimal(10,0) DEFAULT NULL,
  `DiscountValue` decimal(10,0) DEFAULT NULL,
  `DiscountId` int DEFAULT NULL,
  `DiscPerFlat` varchar(255) DEFAULT NULL,
  `DiscountTotal` decimal(10,0) DEFAULT NULL,
  `TaxId` int DEFAULT NULL,
  `TaxRate` decimal(10,0) DEFAULT NULL,
  `TaxValue` decimal(10,0) DEFAULT NULL,
  `Quantity` decimal(10,0) DEFAULT NULL,
  `SubTotal` decimal(10,0) DEFAULT NULL,
  `NetTotal` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_inv_delivery_order_detail`
--

INSERT INTO `app_inv_delivery_order_detail` VALUES (1,3,20,0,0,170000,170000,0,NULL,'',0,NULL,NULL,0,1,170000,170000),(2,3,22,0,0,150,150,0,NULL,'',0,NULL,NULL,0,1,150,150),(3,4,20,0,0,170000,170000,0,NULL,'',0,NULL,NULL,0,1,170000,170000),(4,4,21,0,0,55000,55000,0,NULL,'',0,NULL,NULL,0,1,55000,55000),(5,5,20,0,0,170000,170000,0,NULL,'',0,NULL,NULL,0,1,170000,170000),(6,5,22,0,0,150,150,0,NULL,'',0,NULL,NULL,0,1,150,150),(7,5,23,0,0,89,89,0,NULL,'',0,NULL,NULL,67,1,89,156),(8,6,21,0,0,55000,55000,0,NULL,'',0,NULL,NULL,2750,1,55000,57750),(9,9,20,170000,170000,1970000,170000,0,NULL,'',0,NULL,NULL,98500,1,1970000,2068500),(10,11,20,170000,170000,170000,170000,10,NULL,'Per',17000,NULL,NULL,8500,1,170000,161500),(11,12,20,170000,170000,170000,170000,NULL,NULL,'-1',0,NULL,NULL,0,1,170000,170000),(12,12,23,89,89,89,89,0,NULL,'-1',0,NULL,NULL,67,1,89,156);

--
-- Table structure for table `app_inv_discount_type`
--

CREATE TABLE `app_inv_discount_type` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FlatPer` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Discount` double DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int NOT NULL,
  `CreatedDate` datetime NOT NULL,
  `CreatedBy` int NOT NULL,
  `ModifiedDate` datetime NOT NULL,
  `ModifiedBy` int NOT NULL,
  UNIQUE KEY `Id` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_discount_type`
--


--
-- Table structure for table `app_inv_grn_order`
--

CREATE TABLE `app_inv_grn_order` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `OrderDate` date DEFAULT NULL,
  `PurchaseOrderId` bigint DEFAULT NULL,
  `VendorId` int DEFAULT NULL,
  `BillNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DiscountId` int DEFAULT NULL,
  `DiscountType` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DiscountValue` decimal(10,0) DEFAULT NULL,
  `OrderTotal` decimal(10,0) DEFAULT NULL,
  `DiscountTotal` decimal(10,0) DEFAULT NULL,
  `SalesTax` decimal(10,0) DEFAULT NULL,
  `FurtherTax` decimal(10,0) DEFAULT NULL,
  `NetAmount` decimal(10,0) DEFAULT NULL,
  `FinancialYearId` int DEFAULT NULL,
  `DemandNoteId` int DEFAULT NULL,
  `PaymentTypeId` int DEFAULT NULL,
  `Note` text COLLATE utf8mb4_general_ci,
  `ReferenceNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `WareHouseId` int DEFAULT NULL,
  `IsReturn` int DEFAULT NULL,
  `OrderStatus` int DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_grn_order`
--

INSERT INTO `app_inv_grn_order` VALUES (1,'2024-06-03',NULL,1,'3434',NULL,NULL,NULL,440000,0,NULL,0,440000,NULL,0,1,'55000.00','3443',0,0,1,1,1,1,'2024-06-03 06:07:13',NULL,NULL),(2,'2024-06-03',NULL,1,'3434',NULL,NULL,NULL,440000,0,NULL,0,440000,NULL,0,1,'55000.00','3443',0,0,1,1,1,1,'2024-06-03 06:07:52',NULL,NULL),(3,NULL,NULL,2,'dgfdg',NULL,NULL,NULL,390000,0,NULL,0,390000,NULL,0,1,'55000.00',NULL,0,0,1,1,1,1,'2024-06-06 12:10:20',NULL,NULL),(4,'2024-07-08',4,2,'343',NULL,NULL,NULL,238,0,NULL,0,305,NULL,0,2,'23.00','adf',0,0,1,1,1,1,'2024-07-01 11:28:02',NULL,NULL),(5,'2024-07-01',3,5,'dsf',NULL,NULL,NULL,986,0,NULL,0,1431,NULL,0,1,'45.00','ref',0,0,1,1,1,1,'2024-07-01 11:28:39',NULL,NULL),(6,'2024-07-01',3,5,'dsf',NULL,NULL,NULL,986,0,NULL,0,1431,NULL,0,1,'45.00','ref',0,0,1,1,1,1,'2024-07-01 11:31:12',NULL,NULL),(7,'2024-07-01',1,4,'af',NULL,NULL,NULL,4300,0,NULL,0,4300,NULL,0,1,'150.00','asdf',0,0,1,1,1,1,'2024-07-01 11:38:01',NULL,NULL);

--
-- Table structure for table `app_inv_grn_order_detail`
--

CREATE TABLE `app_inv_grn_order_detail` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `GrnOrderId` bigint DEFAULT NULL,
  `ItemId` int DEFAULT NULL,
  `SalePrice` decimal(10,0) DEFAULT NULL,
  `PurchasePrice` decimal(10,0) DEFAULT NULL,
  `WholeSalePrice` decimal(10,0) DEFAULT NULL,
  `TaxRate` decimal(10,0) DEFAULT NULL,
  `TaxValue` decimal(10,0) DEFAULT NULL,
  `TaxId` int DEFAULT NULL,
  `BrandId` int DEFAULT NULL,
  `CategoryId` int DEFAULT NULL,
  `SubCategoryId` int DEFAULT NULL,
  `ChildCategoryId` int DEFAULT NULL,
  `ItemTypeId` int DEFAULT NULL,
  `UnitId` int DEFAULT NULL,
  `DiscountId` int DEFAULT NULL,
  `DiscountValue` decimal(10,0) DEFAULT NULL,
  `DiscPerFlat` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DiscountTotal` decimal(10,0) DEFAULT NULL,
  `TotalAmount` decimal(10,0) DEFAULT NULL,
  `NetAmount` decimal(10,0) DEFAULT NULL,
  `Quantity` decimal(10,0) DEFAULT NULL,
  `StoreId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_grn_order_detail`
--

INSERT INTO `app_inv_grn_order_detail` VALUES (1,2,20,170000,5,5,0,0,NULL,0,0,NULL,NULL,0,0,NULL,0,NULL,0,290000,290000,2,0,1,1,'2024-06-03 06:07:52',NULL,NULL),(2,2,21,55000,0,5,0,0,NULL,0,0,NULL,NULL,0,0,NULL,0,NULL,0,150000,150000,3,0,1,1,'2024-06-03 06:07:52',NULL,NULL),(3,3,20,170000,5,5,0,0,NULL,0,0,0,0,0,0,NULL,0,NULL,0,290000,290000,2,0,1,1,'2024-06-06 12:10:20',NULL,NULL),(4,3,21,55000,0,5,0,0,NULL,0,0,0,0,0,0,NULL,0,NULL,0,100000,100000,2,0,1,1,'2024-06-06 12:10:20',NULL,NULL),(5,4,23,89,1,0,0,67,NULL,0,0,0,0,0,0,NULL,0,NULL,0,234,301,3,0,1,1,'2024-07-01 11:28:02',NULL,NULL),(6,5,24,23,4,0,0,0,NULL,0,0,0,0,0,0,NULL,0,NULL,0,41,41,34,0,1,1,'2024-07-01 11:28:39',NULL,NULL),(7,6,24,23,1,0,0,0,NULL,0,0,0,0,0,0,NULL,0,NULL,0,41,41,34,0,1,1,'2024-07-01 11:31:12',NULL,NULL),(8,6,28,45,45,0,0,445,NULL,0,0,0,0,0,0,NULL,0,NULL,0,945,1390,21,0,1,1,'2024-07-01 11:31:12',NULL,NULL),(9,7,22,150,100,150,0,0,NULL,0,0,0,0,0,0,NULL,0,NULL,0,4300,4300,43,0,1,1,'2024-07-01 11:38:01',NULL,NULL);

--
-- Table structure for table `app_inv_grn_order_other_expense`
--

CREATE TABLE `app_inv_grn_order_other_expense` (
  `Id` bigint NOT NULL,
  `ExpenseId` int DEFAULT NULL,
  `Amount` decimal(10,0) DEFAULT NULL,
  `GRNId` bigint DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_grn_order_other_expense`
--


--
-- Table structure for table `app_inv_inward_gatepass`
--

CREATE TABLE `app_inv_inward_gatepass` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `GatePassDate` datetime DEFAULT NULL,
  `GatePassNo` varchar(100) DEFAULT NULL,
  `PurchaseOrderId` int DEFAULT NULL,
  `GRNId` int DEFAULT NULL,
  `VehicleId` int DEFAULT NULL,
  `DriverName` varchar(255) DEFAULT NULL,
  `Description` text,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  `RefNo` varchar(45) DEFAULT NULL,
  `VehicleNo` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_inv_inward_gatepass`
--

INSERT INTO `app_inv_inward_gatepass` VALUES (1,'2024-08-08 00:00:00','343',1,NULL,1,'Xyz',NULL,1,1,'2024-08-07 11:23:16',NULL,NULL,1,'adf','LE-12345'),(3,'2024-08-07 00:00:00','sdf',2,NULL,1,'Xyz',NULL,1,1,'2024-08-07 11:24:44',NULL,NULL,1,'sdf','LE-12345'),(4,'2024-08-07 00:00:00','sdf',2,NULL,1,'Xyz',NULL,1,1,'2024-08-07 11:26:30',NULL,NULL,1,'sdf','LE-12345');

--
-- Table structure for table `app_inv_inward_gatepass_detail`
--

CREATE TABLE `app_inv_inward_gatepass_detail` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `InWardGatePassId` int DEFAULT NULL,
  `ItemId` int DEFAULT NULL,
  `PurchasePrice` decimal(10,0) DEFAULT NULL,
  `WholeSalePrice` decimal(10,0) DEFAULT NULL,
  `SalePrice` decimal(10,0) DEFAULT NULL,
  `Qty` decimal(10,0) DEFAULT NULL,
  `NetTotal` decimal(10,0) DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_inv_inward_gatepass_detail`
--

INSERT INTO `app_inv_inward_gatepass_detail` VALUES (1,3,21,NULL,NULL,NULL,4,NULL,1,1,'2024-08-07 11:24:44',NULL,NULL),(2,3,23,NULL,NULL,NULL,6,NULL,1,1,'2024-08-07 11:24:44',NULL,NULL),(3,4,21,NULL,NULL,NULL,4,NULL,1,1,'2024-08-07 11:26:30',NULL,NULL),(4,4,23,NULL,NULL,NULL,6,NULL,1,1,'2024-08-07 11:26:30',NULL,NULL);

--
-- Table structure for table `app_inv_item_stock_adjustment`
--

CREATE TABLE `app_inv_item_stock_adjustment` (
  `Id` int NOT NULL,
  `ItemId` int DEFAULT NULL,
  `Quantity` decimal(10,0) DEFAULT NULL,
  `ReasonId` int DEFAULT NULL,
  `AdjustmentDate` date DEFAULT NULL,
  `Note` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_item_stock_adjustment`
--

INSERT INTO `app_inv_item_stock_adjustment` VALUES (2,20,34,1,'2024-06-06',NULL,1,1,'2024-06-06 12:11:45',NULL,NULL);

--
-- Table structure for table `app_inv_item_stock_adjustment_reason`
--

CREATE TABLE `app_inv_item_stock_adjustment_reason` (
  `Id` int NOT NULL,
  `Reason` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_item_stock_adjustment_reason`
--

INSERT INTO `app_inv_item_stock_adjustment_reason` VALUES (1,'Some Reason',1,1,NULL,1,NULL);

--
-- Table structure for table `app_inv_outward_gatepass`
--

CREATE TABLE `app_inv_outward_gatepass` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `GatePassDate` datetime DEFAULT NULL,
  `GatePassNo` varchar(100) DEFAULT NULL,
  `SaleOrderId` int DEFAULT NULL,
  `VehicleId` int DEFAULT NULL,
  `DriverName` varchar(255) DEFAULT NULL,
  `Description` text,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `CustomerInvoiceId` int DEFAULT NULL,
  `RefNo` varchar(45) DEFAULT NULL,
  `VehicleNo` varchar(255) DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_inv_outward_gatepass`
--

INSERT INTO `app_inv_outward_gatepass` VALUES (1,'2024-07-25 00:00:00','Test',5,1,'Xyz',NULL,1,1,'2024-07-26 06:40:09',NULL,NULL,0,NULL,'LE-12345',1),(2,'2024-07-25 00:00:00','Test',5,1,'Xyz',NULL,1,1,'2024-07-26 06:40:22',NULL,NULL,0,NULL,'LE-12345',1),(3,'2024-07-25 00:00:00','Test',5,1,'Xyz',NULL,1,1,'2024-07-26 06:43:43',NULL,NULL,0,NULL,'LE-12345',1),(4,'2024-07-25 00:00:00','abv',12,NULL,NULL,NULL,1,1,'2024-07-26 06:45:51',NULL,NULL,0,'rery',NULL,1);

--
-- Table structure for table `app_inv_outward_gatepass_detail`
--

CREATE TABLE `app_inv_outward_gatepass_detail` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `OutWardGatePassId` int DEFAULT NULL,
  `ItemId` int DEFAULT NULL,
  `PurchasePrice` decimal(10,0) DEFAULT NULL,
  `WholeSalePrice` decimal(10,0) DEFAULT NULL,
  `SalePrice` decimal(10,0) DEFAULT NULL,
  `Qty` decimal(10,0) DEFAULT NULL,
  `NetTotal` decimal(10,0) DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_inv_outward_gatepass_detail`
--

INSERT INTO `app_inv_outward_gatepass_detail` VALUES (1,2,20,NULL,NULL,NULL,1,NULL,1,1,'2024-07-26 06:40:22',NULL,NULL),(2,2,22,NULL,NULL,NULL,1,NULL,1,1,'2024-07-26 06:40:22',NULL,NULL),(3,2,23,NULL,NULL,NULL,1,NULL,1,1,'2024-07-26 06:40:22',NULL,NULL),(4,3,20,NULL,NULL,NULL,1,NULL,1,1,'2024-07-26 06:43:43',NULL,NULL),(5,3,22,NULL,NULL,NULL,1,NULL,1,1,'2024-07-26 06:43:43',NULL,NULL),(6,3,23,NULL,NULL,NULL,1,NULL,1,1,'2024-07-26 06:43:43',NULL,NULL),(7,4,20,NULL,NULL,NULL,54,NULL,1,1,'2024-07-26 06:45:51',NULL,NULL),(8,4,23,NULL,NULL,NULL,6,NULL,1,1,'2024-07-26 06:45:51',NULL,NULL),(9,1,21,NULL,NULL,NULL,3,NULL,1,1,'2024-08-07 11:23:16',NULL,NULL),(10,1,23,NULL,NULL,NULL,5,NULL,1,1,'2024-08-07 11:23:16',NULL,NULL);

--
-- Table structure for table `app_inv_payment_term`
--

CREATE TABLE `app_inv_payment_term` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Title` varchar(255) DEFAULT NULL,
  `TermDays` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_inv_payment_term`
--

INSERT INTO `app_inv_payment_term` VALUES (1,'90 Days',90,1,NULL,NULL,NULL,NULL),(2,'45 Days',45,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `app_inv_performa_invoice`
--

CREATE TABLE `app_inv_performa_invoice` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `InvoiceNo` varchar(255) DEFAULT NULL,
  `InvoiceDate` date DEFAULT NULL,
  `CustomerId` int DEFAULT NULL,
  `GrossAmount` decimal(10,0) DEFAULT NULL,
  `DiscountAmount` decimal(10,0) DEFAULT NULL,
  `TaxAmount` decimal(10,0) DEFAULT NULL,
  `NetAmount` decimal(10,0) DEFAULT NULL,
  `Quantity` decimal(10,0) DEFAULT NULL,
  `InvoiceStatus` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `Remarks` longtext,
  `BranchId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_inv_performa_invoice`
--


--
-- Table structure for table `app_inv_performa_invoice_detail`
--

CREATE TABLE `app_inv_performa_invoice_detail` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `PerformaInvoiceId` int DEFAULT NULL,
  `ItemId` int DEFAULT NULL,
  `PurchasePrice` decimal(10,0) DEFAULT NULL,
  `WholeSalePrice` decimal(10,0) DEFAULT NULL,
  `SalePrice` decimal(10,0) DEFAULT NULL,
  `Quantity` decimal(10,0) DEFAULT NULL,
  `GrossTotal` decimal(10,0) DEFAULT NULL,
  `DiscountAmount` decimal(10,0) DEFAULT NULL,
  `Taxrate` decimal(10,0) DEFAULT NULL,
  `TaxAmount` decimal(10,0) DEFAULT NULL,
  `NetAmount` decimal(10,0) DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `DiscountPer` decimal(10,0) DEFAULT NULL,
  `DiscountValue` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_inv_performa_invoice_detail`
--


--
-- Table structure for table `app_inv_purchase_order`
--

CREATE TABLE `app_inv_purchase_order` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `BillNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `OrderDate` date DEFAULT NULL,
  `VendorId` int DEFAULT NULL,
  `DiscountId` int DEFAULT NULL,
  `DiscountType` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DiscountValue` decimal(10,0) DEFAULT NULL,
  `OrderTotal` decimal(10,0) DEFAULT NULL,
  `DiscountTotal` decimal(10,0) DEFAULT NULL,
  `SalesTax` decimal(10,0) DEFAULT NULL,
  `FurtherTax` decimal(10,0) DEFAULT NULL,
  `NetAmount` decimal(10,0) DEFAULT NULL,
  `FinancialYearId` int DEFAULT NULL,
  `OrderDueDate` date DEFAULT NULL,
  `JobNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PaymentTypeId` int DEFAULT NULL,
  `Note` text COLLATE utf8mb4_general_ci,
  `ReferenceNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `IsTaxable` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_purchase_order`
--

INSERT INTO `app_inv_purchase_order` VALUES (1,'ertretg','2024-06-18',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'43543',1,NULL,'23453424',1,1,1,'2024-06-27 12:26:45',NULL,NULL,NULL),(2,'dsaf','2024-06-12',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dsafg',1,'sdf',NULL,1,1,1,'2024-06-27 12:27:42',NULL,NULL,NULL),(3,'B343','2024-06-27',2,NULL,NULL,NULL,200400,20000,0,NULL,180400,NULL,NULL,'J34',1,NULL,'Ref',1,1,1,'2024-06-28 06:43:01',NULL,NULL,NULL),(4,'B343','2024-06-27',2,NULL,NULL,NULL,200400,20000,0,NULL,180400,NULL,NULL,'J34',1,NULL,'Ref',1,1,1,'2024-06-28 06:43:19',NULL,NULL,NULL),(5,'test','2024-08-06',1,NULL,NULL,NULL,390,0,0,NULL,390,NULL,NULL,'tes',1,'test','test',1,1,1,'2024-08-07 06:29:19',NULL,NULL,NULL);

--
-- Table structure for table `app_inv_purchase_order_detail`
--

CREATE TABLE `app_inv_purchase_order_detail` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `PurchaseOrderId` bigint DEFAULT NULL,
  `ItemId` int DEFAULT NULL,
  `Quantity` decimal(10,0) DEFAULT NULL,
  `SalePrice` decimal(10,0) DEFAULT NULL,
  `TaxValue` decimal(10,0) DEFAULT NULL,
  `TaxRate` decimal(10,0) DEFAULT NULL,
  `PurchasePrice` decimal(10,0) DEFAULT NULL,
  `DiscountId` int DEFAULT NULL,
  `Discount` decimal(10,0) DEFAULT NULL,
  `DiscountPerFlat` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DiscountValue` decimal(10,0) DEFAULT NULL,
  `BrandId` int DEFAULT NULL,
  `CategoryId` int DEFAULT NULL,
  `ItemTypeId` int DEFAULT NULL,
  `UnitId` int DEFAULT NULL,
  `TotalAmount` decimal(10,0) DEFAULT NULL,
  `NetAmount` decimal(10,0) DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_purchase_order_detail`
--

INSERT INTO `app_inv_purchase_order_detail` VALUES (1,4,22,4,150,0,0,100,NULL,0,NULL,0,NULL,NULL,NULL,NULL,400,400,1,1,'2024-06-28 06:43:19',NULL,NULL),(2,4,21,4,55000,0,0,50000,NULL,20000,'Per',10,NULL,NULL,NULL,NULL,200000,180000,1,1,'2024-06-28 06:43:19',NULL,NULL),(3,5,20,3,170000,0,0,0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,0,0,1,1,'2024-08-07 06:29:19',NULL,NULL),(4,5,23,5,89,0,0,78,NULL,0,'null',0,NULL,NULL,NULL,NULL,390,390,1,1,'2024-08-07 06:29:19',NULL,NULL);

--
-- Table structure for table `app_inv_vendor`
--

CREATE TABLE `app_inv_vendor` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `PhoneNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MobileNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `EmailAddress` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` text COLLATE utf8mb4_general_ci,
  `OpeningBalance` double DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ChartOfAccountId` int DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  `Picture` text COLLATE utf8mb4_general_ci,
  `ContactPerson` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `SaleTaxRegNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `NTNNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CNIC` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TaxStatus` int DEFAULT NULL,
  `NameUr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Currency` varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CountryId` int DEFAULT NULL,
  `PeymentTermId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_vendor`
--

INSERT INTO `app_inv_vendor` VALUES (1,'01','AbcUpdate','desc','3345','45454','nabeel.ezad@gmail.com','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore Billing',0,1,1,'2024-03-21 17:40:39',NULL,NULL,1,NULL,NULL,'Nabeel Bin Ezad','3433','ntvds','cbnn',1,NULL,NULL,NULL,NULL),(2,'VC-0000001','test','sdf','43543','435','nabeel.ezad@gmail.com','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore Billing',545,1,1,'2024-04-27 12:55:31',NULL,NULL,2,NULL,NULL,'Nabeel Bin Ezad','4','35435','435',0,NULL,NULL,NULL,NULL),(3,'VC-0000003','dfdf','test','dfg','fg','ffgf','fdg',0,1,1,'2024-06-28 09:44:22',NULL,NULL,0,NULL,NULL,'fdg','fdg','fdg','fg',0,'فدگگسفددسفدسفدس',NULL,NULL,NULL),(4,'VC-0000004','sdafhide urdu',NULL,'345','adfdasf','asdfdsf','adsf',0,1,1,'2024-06-28 09:53:21',NULL,NULL,0,NULL,NULL,'dsaf','34','324234324','324234',0,NULL,NULL,NULL,NULL),(5,'VC-0000005','Nab Test','desc','3434','434543','111admin@gmail.com','pad',50000,1,1,'2024-07-01 09:16:12',NULL,NULL,NULL,NULL,'','ali','5','232323',NULL,1,NULL,'USD',15,1),(6,'VC-0000006','ag','sadd','dfg','fdg','sdf','gsdfg',555,1,1,'2024-07-01 09:19:44',NULL,NULL,NULL,NULL,'','sdfg','4',NULL,NULL,1,NULL,NULL,1,1),(7,'VC-0000007','dfdsf','sdf','sdf','sdf','111admin@gmail.com','ret',0,1,1,'2024-07-01 09:40:57',NULL,NULL,3,NULL,'','reter','34','435',NULL,0,NULL,'AFN',1,2),(8,'VC-0000008','dfgdf',NULL,'435','43435','3454',NULL,0,1,1,'2024-07-01 09:30:37',NULL,NULL,4,NULL,'',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `app_inv_vendor_payment`
--

CREATE TABLE `app_inv_vendor_payment` (
  `Id` int NOT NULL,
  `PurchaseOrderId` int DEFAULT NULL,
  `VendorId` int DEFAULT NULL,
  `PaymentTypeId` int DEFAULT NULL,
  `BankId` int DEFAULT NULL,
  `BankBranch` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ChkNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ChkDate` date DEFAULT NULL,
  `ChkCashDate` date DEFAULT NULL,
  `PaymentDate` date DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `PaymentNote` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_inv_vendor_payment`
--


--
-- Table structure for table `app_pointofsale_customer_payment`
--

CREATE TABLE `app_pointofsale_customer_payment` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `CustomerInvoiceId` bigint DEFAULT NULL,
  `CustomerId` int DEFAULT NULL,
  `PaymentTypeId` int DEFAULT NULL,
  `BankId` int DEFAULT NULL,
  `BankBranch` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ChkNo` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ChkDate` date DEFAULT NULL,
  `ChkCashDate` date DEFAULT NULL,
  `PaymentDate` date DEFAULT NULL,
  `Amount` decimal(10,0) DEFAULT NULL,
  `PaymentNote` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_pointofsale_customer_payment`
--

INSERT INTO `app_pointofsale_customer_payment` VALUES (1,40,1,4,1,'fgdupdate','454','2024-04-09','2024-04-10','2024-04-10',5000,'noteupdate',1,'2024-04-08',1,'2024-04-09',1,1),(2,40,1,1,1,'23432','2344','2024-06-27',NULL,'2024-06-27',34543,'34543',1,'2024-06-27',1,NULL,NULL,1),(3,0,1,2,0,'45','435435','2024-06-27','2024-06-18','2024-06-25',435,NULL,1,'2024-06-27',1,NULL,NULL,1),(4,40,1,2,1,'342','234','2024-06-27','2024-06-19','2024-06-27',434,NULL,1,'2024-06-27',1,NULL,NULL,1),(5,40,1,2,1,'232','234','2024-06-19',NULL,'2024-06-14',324324,NULL,1,'2024-06-27',1,NULL,NULL,1),(6,40,1,2,0,NULL,NULL,NULL,NULL,'2024-07-03',4545,NULL,1,'2024-06-27',1,NULL,NULL,1),(7,40,6,1,0,NULL,NULL,'2024-07-03',NULL,'2024-07-03',5000,'note',1,'2024-07-03',1,NULL,NULL,1),(8,45,6,1,0,NULL,NULL,NULL,NULL,'2024-07-03',1000,NULL,1,'2024-07-03',1,NULL,NULL,1),(9,41,6,1,0,NULL,NULL,NULL,NULL,'2024-07-03',15000,NULL,1,'2024-07-03',1,NULL,NULL,1),(10,41,6,4,1,'dfad','234',NULL,NULL,'2024-07-04',20000,NULL,1,'2024-07-03',1,NULL,NULL,1);

--
-- Table structure for table `app_pointofsale_sale_order`
--

CREATE TABLE `app_pointofsale_sale_order` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `OrderDate` datetime DEFAULT NULL,
  `CustomerId` int DEFAULT NULL,
  `EmployeeId` int DEFAULT NULL,
  `BillNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `OrderTotal` decimal(10,0) DEFAULT NULL,
  `DiscountTotal` decimal(10,0) DEFAULT NULL,
  `SaleTax` decimal(10,0) DEFAULT NULL,
  `NetAmount` decimal(10,0) DEFAULT NULL,
  `DiscountId` int DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  `FinancialYearId` int DEFAULT NULL,
  `PointAwarded` decimal(10,0) DEFAULT NULL,
  `RedeemPoint` decimal(10,0) DEFAULT NULL,
  `RedeemAmount` decimal(10,0) DEFAULT NULL,
  `PyamentTypeId` int DEFAULT NULL,
  `PaymentAmount` decimal(10,0) DEFAULT NULL,
  `Balance` decimal(10,0) DEFAULT NULL,
  `RetailWholeSale` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Commission` decimal(10,0) DEFAULT NULL,
  `CommissionValue` decimal(10,0) DEFAULT NULL,
  `SyncStatus` int DEFAULT NULL,
  `RefundInvoiceId` bigint DEFAULT NULL,
  `ReturnInvoiceId` bigint DEFAULT NULL,
  `CustomerTypeId` int DEFAULT NULL,
  `CustomerName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Note` text COLLATE utf8mb4_general_ci,
  `SaleTaxInvStatus` int DEFAULT NULL,
  `FBRInvoiceNumber` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CustomerMobileNumber` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `OrderTypeId` int DEFAULT NULL,
  `TableId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `TotalQty` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_pointofsale_sale_order`
--

INSERT INTO `app_pointofsale_sale_order` VALUES (17,'2024-03-28 00:00:00',-1,-1,'',714,0,0,714,0,0,0,0,0,0,0,800,-86,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-28 11:27:00',0,NULL,NULL,NULL),(18,'2024-03-28 00:00:00',-1,-1,'',738,0,0,738,0,0,0,0,0,0,0,800,-62,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-28 11:28:06',0,NULL,NULL,NULL),(19,'2024-03-29 00:00:00',-1,-1,'',714,0,0,714,0,0,0,0,0,0,0,800,-86,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-29 09:32:23',0,NULL,NULL,NULL),(20,'2024-03-29 00:00:00',-1,-1,'',714,0,0,714,0,0,0,0,0,0,0,800,-86,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-29 09:40:45',0,NULL,NULL,NULL),(21,'2024-03-29 00:00:00',-1,-1,'',1054,0,450,1504,0,0,0,0,0,0,0,1600,-96,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-29 10:51:50',0,NULL,NULL,NULL),(22,'2024-03-31 00:00:00',-1,-1,'',1059,0,0,1059,0,0,0,0,0,0,0,1100,-41,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-31 10:02:13',0,NULL,NULL,NULL),(23,'2024-03-31 00:00:00',-1,-1,'',1059,0,0,1059,0,0,0,0,0,0,0,1200,-141,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-31 10:06:59',0,NULL,NULL,NULL),(24,'2024-03-31 00:00:00',-1,-1,'',714,0,0,714,0,0,0,0,0,0,0,800,-86,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-31 10:15:45',0,NULL,NULL,NULL),(25,'2024-03-31 00:00:00',-1,-1,'',1054,0,450,1504,0,0,0,0,0,0,0,1600,-96,'0',0,0,0,0,0,0,'',NULL,0,'','',1,0,1,'2024-03-31 12:07:54',0,NULL,NULL,NULL),(26,'2024-03-31 00:00:00',-1,-1,'',1078,0,450,1528,0,NULL,0,0,0,0,1,1600,-72,'0',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 16:40:03',0,NULL,NULL,NULL),(27,'2024-03-31 00:00:00',1,-1,'',369,0,0,369,0,NULL,0,0,0,0,4,NULL,NULL,'0',0,0,0,0,0,2,'',NULL,0,'','',1,0,1,'2024-03-31 17:02:30',0,NULL,NULL,NULL),(28,'2024-03-31 00:00:00',1,-1,'',738,0,0,738,0,NULL,0,0,0,0,4,0,0,'0',0,0,0,0,0,2,'',NULL,0,'','',1,0,1,'2024-03-31 17:02:41',0,NULL,NULL,NULL),(29,'2024-03-31 00:00:00',1,-1,'',0,0,0,0,0,NULL,0,0,0,0,4,0,0,'0',0,0,0,0,0,2,'',NULL,0,'','',1,0,1,'2024-03-31 17:02:49',0,NULL,NULL,NULL),(30,'2024-03-31 00:00:00',-1,-1,'',714,0,0,714,0,NULL,0,0,0,0,1,NULL,NULL,'0',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:07:38',0,NULL,NULL,NULL),(31,'2024-03-31 00:00:00',-1,-1,'',714,0,0,714,0,NULL,0,0,0,0,1,NULL,NULL,'0',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:08:32',0,NULL,NULL,NULL),(32,'2024-03-31 00:00:00',-1,-1,'',714,0,0,714,0,NULL,0,0,0,0,1,0,NULL,'0',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:09:24',0,NULL,NULL,NULL),(33,'2024-03-31 00:00:00',-1,-1,'',714,0,0,714,0,NULL,0,0,0,0,1,0,NULL,'0',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:10:00',0,NULL,NULL,NULL),(34,'2024-03-31 00:00:00',-1,-1,'',714,0,0,714,0,NULL,0,0,0,0,1,750,-36,'0',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:10:52',0,NULL,NULL,NULL),(35,'2024-03-31 00:00:00',-1,-1,'',369,0,0,369,0,NULL,0,0,0,0,1,400,-31,'0',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:18:19',0,NULL,NULL,NULL),(36,'2024-03-31 00:00:00',-1,-1,'',1059,0,0,1059,0,NULL,0,0,0,0,1,1200,-141,'0',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:21:49',0,NULL,NULL,NULL),(37,'2024-03-31 00:00:00',-1,-1,'20240331',714,0,0,714,0,NULL,0,0,0,0,1,800,-86,'Retail',0,0,0,0,0,1,'','fg',0,'','',1,0,1,'2024-03-31 17:50:26',0,NULL,NULL,NULL),(38,'2024-03-31 00:00:00',-1,-1,'2024033137',738,0,0,738,0,NULL,0,0,0,0,1,800,-62,'Retail',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:55:05',0,NULL,NULL,NULL),(39,'2024-03-31 00:00:00',-1,-1,'2024033139',738,0,0,738,0,NULL,0,0,0,0,1,800,-62,'Retail',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-03-31 17:55:30',0,NULL,NULL,NULL),(40,'2024-03-31 00:00:00',1,-1,'2024033140',369,0,0,369,0,NULL,0,0,0,0,4,400,-31,'WholeSale',0,0,0,0,0,2,'',NULL,0,'','',1,0,1,'2024-03-31 17:56:06',0,NULL,NULL,NULL),(41,'2024-05-05 00:00:00',1,3,'2024050541',225000,0,0,225000,0,1,0,0,0,0,1,300000,-75000,'WholeSale',0,0,0,0,0,2,'',NULL,0,'','',1,0,1,'2024-05-05 14:27:27',0,NULL,NULL,NULL),(42,'2024-06-06 00:00:00',-1,-1,'2024060642',225000,0,0,225000,0,1,0,0,0,0,1,300000,-75000,'Retail',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-06-06 10:05:12',0,NULL,NULL,NULL),(43,'2024-06-06 00:00:00',-1,-1,'2024060643',170000,0,0,170000,0,1,0,0,0,0,1,200000,-30000,'Retail',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-06-06 10:54:06',0,NULL,NULL,NULL),(44,'2024-06-12 00:00:00',-1,-1,'2024061344',170000,0,0,170000,0,1,0,0,0,0,1,200000,-30000,'Retail',0,0,0,0,0,1,'',NULL,0,'','',1,0,1,'2024-06-13 06:44:26',0,NULL,NULL,NULL),(45,'2024-07-03 00:00:00',1,3,'2024070345',112,0,67,179,0,1,0,0,0,0,1,200,-21,'WholeSale',0,0,0,0,0,2,'',NULL,0,'','',5,0,1,'2024-07-03 09:06:03',0,NULL,NULL,NULL),(46,'2024-07-03 00:00:00',-1,-1,'2024070346',112,0,67,179,0,1,0,0,0,0,1,200,-21,'Retail',0,0,0,0,0,1,'',NULL,0,'','',4,0,1,'2024-07-03 09:48:30',0,NULL,NULL,NULL),(47,'2024-07-03 00:00:00',1,3,'2024070347',712,0,536,1248,0,1,0,0,0,0,1,1500,-252,'WholeSale',0,0,0,0,0,2,'',NULL,0,'','',4,0,1,'2024-07-03 09:49:16',0,NULL,NULL,NULL);

--
-- Table structure for table `app_pointofsale_sale_order_detail`
--

CREATE TABLE `app_pointofsale_sale_order_detail` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `SaleOrderId` bigint DEFAULT NULL,
  `ProductId` int DEFAULT NULL,
  `UnitId` int DEFAULT NULL,
  `SalePrice` decimal(10,0) DEFAULT NULL,
  `PurchasePrice` decimal(10,0) DEFAULT NULL,
  `SalePriceSale` decimal(10,0) DEFAULT NULL,
  `Quantity` decimal(10,0) DEFAULT NULL,
  `SubTotal` decimal(10,0) DEFAULT NULL,
  `DiscountAmount` decimal(10,0) DEFAULT NULL,
  `TaxAmount` decimal(10,0) DEFAULT NULL,
  `TotalAmount` decimal(10,0) DEFAULT NULL,
  `DiscountPer` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DiscountValue` decimal(10,0) DEFAULT NULL,
  `CategoryId` int DEFAULT NULL,
  `SubCategoryId` int DEFAULT NULL,
  `ChildCategoryId` int DEFAULT NULL,
  `BrandId` int DEFAULT NULL,
  `PointAward` decimal(10,0) DEFAULT NULL,
  `PointRedeem` decimal(10,0) DEFAULT NULL,
  `EmployeeId` int DEFAULT NULL,
  `Commission` decimal(10,0) DEFAULT NULL,
  `CommissionValue` decimal(10,0) DEFAULT NULL,
  `ProjectId` int DEFAULT NULL,
  `PricePerUnit` decimal(10,0) DEFAULT NULL,
  `QtyPerUnit` decimal(10,0) DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `SyncStatus` int DEFAULT NULL,
  `AssortmentId` int DEFAULT NULL,
  `SizeValue` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `SizeRange` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_pointofsale_sale_order_detail`
--

INSERT INTO `app_pointofsale_sale_order_detail` VALUES (73,41,20,0,170000,0,170000,1,170000,0,0,170000,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-05-05 14:27:27',0,NULL,NULL,0,1,'',''),(74,41,21,0,55000,0,55000,1,55000,0,0,55000,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-05-05 14:27:27',0,NULL,NULL,0,1,'',''),(75,42,20,0,170000,0,170000,1,170000,0,0,170000,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-06-06 10:05:12',0,NULL,NULL,0,1,'',''),(76,42,21,0,55000,0,55000,1,55000,0,0,55000,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-06-06 10:05:12',0,NULL,NULL,0,1,'',''),(77,43,20,0,170000,0,170000,1,170000,0,0,170000,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-06-06 10:54:06',0,NULL,NULL,0,1,'',''),(78,44,20,0,170000,0,170000,1,170000,0,0,170000,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-06-13 06:44:26',0,NULL,NULL,0,1,'',''),(79,45,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:06:03',0,NULL,NULL,0,1,'',''),(80,45,24,0,23,0,23,1,23,0,0,23,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:06:03',0,NULL,NULL,0,1,'',''),(81,46,24,0,23,0,23,1,23,0,0,23,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:48:30',0,NULL,NULL,0,1,'',''),(82,46,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:48:30',0,NULL,NULL,0,1,'',''),(83,47,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:49:16',0,NULL,NULL,0,1,'',''),(84,47,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:49:16',0,NULL,NULL,0,1,'',''),(85,47,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:49:16',0,NULL,NULL,0,1,'',''),(86,47,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:49:16',0,NULL,NULL,0,1,'',''),(87,47,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:49:16',0,NULL,NULL,0,1,'',''),(88,47,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:49:16',0,NULL,NULL,0,1,'',''),(89,47,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:49:16',0,NULL,NULL,0,1,'',''),(90,47,23,0,89,0,89,1,89,0,67,156,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2024-07-03 09:49:16',0,NULL,NULL,0,1,'','');

--
-- Table structure for table `app_pointofsale_store_expense`
--

CREATE TABLE `app_pointofsale_store_expense` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_pointofsale_store_expense`
--

INSERT INTO `app_pointofsale_store_expense` VALUES (1,'01','Fuel','Fuel',1,1,'2024-03-31 22:11:03',NULL,NULL),(2,'45','updare','fghf',1,1,'2024-04-02 11:30:31',1,'2024-04-06 07:48:10');

--
-- Table structure for table `app_pos_branch`
--

CREATE TABLE `app_pos_branch` (
  `Id` int NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` text COLLATE utf8mb4_general_ci,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FBRPOSId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CompanyId` int DEFAULT NULL,
  `PhoneNoOne` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PhoneNoTwo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `EmailAddress` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Logo` text COLLATE utf8mb4_general_ci,
  `BranchTypeId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `Currency` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CurrencyCode` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CurrencySymbol` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `AllowDiscount` int DEFAULT '0',
  `MaximumDiscount` decimal(10,0) DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_pos_branch`
--

INSERT INTO `app_pos_branch` VALUES (1,'FARAZ BOOK SELLERS','URDU BAZAR, GUJRANWALA','01','1111',1,'055-4442243','0301-8640825','faraz@gmail.com','http://localhost:8000/admin/assets/img/logo.png',1,1,NULL,NULL,'2024-06-24 05:28:26',1,'Dirham','AED','AED',1,10),(2,'Dubai Branch','up add','02','12233 up',1,'343435545fd','4545','gba@gmail.com','otherimages/120240620070119admission-open.jpg',1,1,1,'2024-06-20 06:39:41','2024-06-20 07:44:24',1,'Dollars','USD','$',1,10);

--
-- Table structure for table `app_pos_daily_expense`
--

CREATE TABLE `app_pos_daily_expense` (
  `Id` bigint NOT NULL,
  `ExpenseId` int DEFAULT NULL,
  `Amount` decimal(10,0) DEFAULT NULL,
  `ExpenseDate` date DEFAULT NULL,
  `RefNo` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModififedBy` int DEFAULT NULL,
  `BranchId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_pos_daily_expense`
--

INSERT INTO `app_pos_daily_expense` VALUES (1,1,2000,'2024-04-09','2323','descupdate',1,'2024-04-08 11:37:26',1,'2024-04-08 11:56:15',1,NULL);

--
-- Table structure for table `app_setting_branch_type`
--

CREATE TABLE `app_setting_branch_type` (
  `Id` int NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_setting_branch_type`
--

INSERT INTO `app_setting_branch_type` VALUES (1,'Retail','01','Retail',1,1,NULL,NULL,NULL),(2,'WholeSale','02','WholeSale',1,1,NULL,NULL,NULL);

--
-- Table structure for table `app_setting_company`
--

CREATE TABLE `app_setting_company` (
  `Id` int NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ContactPersonName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Logo` text COLLATE utf8mb4_general_ci,
  `PhoneNumberOne` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PhoneNumberTwo` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MobileNumberOne` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MobileNumberTwo` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `EmailAddress` int DEFAULT NULL,
  `AddressOne` text COLLATE utf8mb4_general_ci,
  `FaxNumber` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `NtnNumber` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `StrnNumber` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_setting_company`
--

INSERT INTO `app_setting_company` VALUES (1,'ABC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `app_setting_vehicle`
--

CREATE TABLE `app_setting_vehicle` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Title` varchar(255) DEFAULT NULL,
  `VehicleNo` varchar(50) DEFAULT NULL,
  `DriverName` varchar(255) DEFAULT NULL,
  `VehicleTypeId` int DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_setting_vehicle`
--

INSERT INTO `app_setting_vehicle` VALUES (1,'Abc','LE-12345','Xyz',1,1,NULL,NULL,NULL,NULL),(2,'Test','LE-1234up','Tabcvee',NULL,1,1,'2024-07-26 11:54:27',1,'2024-07-26 12:06:36');

--
-- Table structure for table `area`
--

CREATE TABLE `area` (
  `Id` int unsigned NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `CityId` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `area`
--

INSERT INTO `area` VALUES (1,'01','Iqbal Town',1,'2023-10-03 07:09:24',0,'2023-10-03 07:14:08',0,1,NULL,NULL);

--
-- Table structure for table `attribute`
--

CREATE TABLE `attribute` (
  `Id` int unsigned NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `NameUr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute`
--

INSERT INTO `attribute` VALUES (1,'01','Color','دسفدسف',1,'2023-09-26 07:36:51',0,'2024-04-27 12:37:05',0,NULL,NULL),(3,'01','Pending',NULL,1,'2023-09-26 09:24:49',0,NULL,0,NULL,NULL),(5,'05','سایذ',NULL,1,'2023-12-21 06:44:44',0,'2024-03-17 14:29:30',0,NULL,NULL),(6,'34','کلر',NULL,1,'2024-03-17 14:25:00',0,NULL,0,NULL,NULL),(7,'34','size','سائز',1,'2024-04-26 15:44:08',0,NULL,0,NULL,NULL),(8,'AC-0000008','dsf','سدفسف',1,'2024-04-27 13:06:33',0,NULL,0,NULL,NULL),(9,'AC-0000009','dsfds','سدفدسف',1,'2024-05-04 16:09:07',0,NULL,0,NULL,NULL),(10,'AC-0000010','update','گفھگفھگف',1,'2024-05-04 16:09:17',0,'2024-05-04 16:09:31',0,NULL,NULL),(11,'3e43','Na','Na',1,'2024-06-07 05:12:07',1,NULL,0,NULL,NULL),(12,'3e43','Na','Na',1,'2024-06-07 05:12:12',1,NULL,0,NULL,NULL),(13,'3e43','sdf','sdf',1,'2024-06-07 05:16:12',1,NULL,0,NULL,NULL),(14,'3e43','sdf','sdf',1,'2024-06-07 09:11:58',1,NULL,0,NULL,NULL),(15,'cdee','nab','nab',1,'2024-06-07 09:16:26',1,NULL,0,NULL,NULL),(16,'fdgdfg','test','test',1,'2024-06-07 09:17:03',1,NULL,0,NULL,NULL),(17,'sdfsdf','dsf','dsf',1,'2024-06-07 09:35:08',1,NULL,0,NULL,NULL),(18,'gsfdg','fdgfds','fdgfds',1,'2024-06-07 09:41:39',1,NULL,0,NULL,NULL),(19,'gsfdg','fdgfds','fdgfds',1,'2024-06-07 09:41:40',1,NULL,0,NULL,NULL),(20,'sdfsdf','sdf','sdf',1,'2024-06-07 09:46:11',1,NULL,0,NULL,NULL),(21,'dfgf','dfgdfg','dfgdfg',1,'2024-06-07 09:46:26',1,NULL,0,NULL,NULL),(22,'dfgfdg','fdgfdg','fdgfdg',1,'2024-06-07 09:55:53',1,NULL,0,NULL,NULL),(23,'fdgfdg','fdgfdg','fdgfdg',1,'2024-06-07 09:57:23',1,NULL,0,NULL,NULL),(24,'fdgfdg','gffdsgf','gffdsgf',1,'2024-06-07 10:02:14',1,NULL,0,NULL,NULL),(25,'02121','Nab','Nab',1,'2024-06-07 10:04:33',1,NULL,0,NULL,NULL),(26,'gdfg','dfg','dfg',1,'2024-06-07 10:04:53',1,NULL,0,NULL,NULL),(27,'dfgfdg','dfg','dfg',1,'2024-06-07 10:04:59',1,NULL,0,NULL,NULL),(28,'AC-0000028','dfsgfdg','فدگدفگفگ',1,'2024-06-07 10:05:31',1,NULL,0,NULL,NULL),(29,'fghgfh','sdfgfdg','sdfgfdg',1,'2024-06-07 10:05:36',1,NULL,0,NULL,NULL),(30,'AC-0000030','sgdfg','فدسگھفدگفدگ',1,'2024-06-07 10:05:55',1,NULL,0,NULL,NULL),(31,'jhgfjhgj','test','test',1,'2024-06-07 10:06:10',1,NULL,0,NULL,NULL),(32,'05we','ner','ner',1,'2024-06-07 12:16:43',1,NULL,0,NULL,NULL),(33,'AC-0000033','dfdf',NULL,1,'2024-06-11 10:15:56',1,NULL,0,NULL,NULL);

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog`
--


--
-- Table structure for table `blogcategory`
--

CREATE TABLE `blogcategory` (
  `id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogcategory`
--


--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `Id` int unsigned NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `NameUr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Description` longtext COLLATE utf8mb4_unicode_ci,
  `Picture` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Slug` int DEFAULT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `SellerId` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brand`
--

INSERT INTO `brand` VALUES (1,'01','Lee Theme',NULL,NULL,NULL,'brandpicture/020240121053956our-logo-five.png',0,1,'2023-10-02 10:46:44',0,'2024-01-21 05:39:56',0,0,NULL,NULL),(3,'02','Shopify',NULL,NULL,'Shopify desc','brandpicture/020240121054040our-logo-four.png',0,1,'2023-10-02 10:55:24',0,'2024-01-21 05:40:40',0,0,NULL,NULL),(4,'03','sino slog',NULL,NULL,NULL,'brandpicture/020240121054115our-logo-one.png',0,1,'2023-10-02 10:56:57',0,'2024-01-21 05:41:15',0,0,NULL,NULL),(6,'04','Wordpress',NULL,NULL,NULL,'brandpicture/020240121054139our-logo-six.png',0,1,'2023-10-02 10:59:03',0,'2024-01-21 05:41:39',0,0,NULL,NULL),(7,'05','Rimbus',NULL,NULL,NULL,'brandpicture/020240121054203our-logo-three.png',0,1,'2024-01-03 01:50:12',0,'2024-01-21 05:42:03',0,0,NULL,NULL),(11,'کوڈ','نوکیا',NULL,NULL,NULL,'brandpicture/120240316203459329163716_1155423281830821_140901815412114829_n.jpg',NULL,0,'2024-03-16 20:34:59',1,NULL,0,0,NULL,NULL),(15,'۳۴۳۲','دسفدف',NULL,NULL,'ددسف','brandpicture/120240316221819Python-Symbol.png',NULL,0,'2024-03-16 22:18:19',1,NULL,0,0,NULL,NULL),(16,'دفدف','فدگدگسدگ',NULL,NULL,'فدگفددسفد','brandpicture/120240316231507Python-Symbol.png',NULL,1,'2024-03-16 23:15:07',1,'2024-06-27 11:58:36',1,0,NULL,NULL),(18,'04','Samsung up','سام سنگ اوپر',NULL,'Samsung','None',NULL,1,'2024-04-26 13:44:49',1,'2024-04-26 13:45:42',1,0,NULL,NULL),(19,'testApiCode','BMNaehaAPI','ewre',NULL,'desc',NULL,NULL,1,NULL,0,NULL,0,0,NULL,NULL),(20,'testApiCodedsfdsf','BMNaehaAPI','ewre',NULL,'desc',NULL,NULL,1,NULL,0,NULL,0,0,NULL,NULL),(21,'testApiCodedsfdsf','BMNaehaAPI','ewre',NULL,'desc','brandpicture/120240527120848Puma-Logo.png',NULL,1,NULL,0,NULL,0,0,NULL,NULL),(22,'sdfdsf','BMNaehaAPI','ewre',NULL,'desc','None',NULL,1,NULL,0,NULL,0,0,NULL,NULL),(23,'sdfdsf','dsfdsf','ewre',NULL,'desc','None',NULL,1,NULL,0,NULL,0,0,NULL,NULL),(24,'sdfdsf','dsfdsf','ewre',NULL,'desc','None',NULL,1,NULL,0,NULL,0,0,NULL,NULL),(25,'BR-0000025','dsfsdf','سدف',NULL,'dsfdsf','None',NULL,1,'2024-06-27 11:56:56',1,NULL,0,0,NULL,NULL);

--
-- Table structure for table `campaign`
--

CREATE TABLE `campaign` (
  `Id` int unsigned NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Offer` double NOT NULL,
  `StartDateTime` datetime DEFAULT NULL,
  `EndDateTime` datetime DEFAULT NULL,
  `ShowHomePage` smallint NOT NULL DEFAULT '0',
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `Picture` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `campaign`
--

INSERT INTO `campaign` VALUES (1,'asdf','sdf','sdf',34,'2024-01-06 21:10:00','2024-01-06 21:10:00',0,1,'2024-01-06 16:11:46',0,NULL,0,'',NULL,NULL),(2,'sdfs fsdf','sdfs-fsdf','dfdf',33,'2024-01-06 21:17:00','2024-01-06 21:17:00',0,0,'2024-01-06 16:17:54',0,NULL,0,'campaignpicture/020240106161755sso.jpeg',NULL,NULL),(3,'New Camp','new-camp','New Camp',20,'2024-02-05 11:12:00','2024-02-22 11:12:00',0,1,'2024-02-05 06:12:40',0,NULL,0,'campaignpicture/020240205061241images.jpeg',NULL,NULL),(4,'ds','ds','dsd',34,'2024-02-05 11:18:00','2024-02-05 11:18:00',0,1,'2024-02-05 06:18:08',0,NULL,0,'campaignpicture/020240205061808images.jpeg',NULL,NULL),(5,'test camp','test-camp','tes',20,'2024-02-05 13:59:00','2024-02-05 13:59:00',1,1,'2024-02-05 08:59:35',0,NULL,0,'campaignpicture/020240205085935images.jpeg',NULL,NULL);

--
-- Table structure for table `campaignproduct`
--

CREATE TABLE `campaignproduct` (
  `Id` int unsigned NOT NULL,
  `CampaignId` int NOT NULL DEFAULT '0',
  `ProductId` int NOT NULL DEFAULT '0',
  `ShowHomePage` smallint NOT NULL DEFAULT '0',
  `DiscOfferPer` float NOT NULL DEFAULT '0',
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `campaignproduct`
--

INSERT INTO `campaignproduct` VALUES (1,1,13,0,50,1,NULL,0,NULL,0,NULL,NULL),(2,1,14,0,20,1,NULL,0,NULL,0,NULL,NULL),(3,5,13,1,20,0,'2024-02-05 08:59:35',0,NULL,0,NULL,NULL),(4,5,13,1,20,0,'2024-02-05 08:59:35',0,NULL,0,NULL,NULL);

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `Id` int unsigned NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `NameUr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_unicode_ci,
  `Picture` text COLLATE utf8mb4_unicode_ci,
  `Slug` text COLLATE utf8mb4_unicode_ci,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `ParentCategoryId` int NOT NULL DEFAULT '-1',
  `SellerId` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` VALUES (1,'01','Electronics',NULL,'PName',NULL,'categorypicture/02024012105100796x123.png','Electronics',1,'2023-10-03 07:46:09',0,'2024-01-21 05:10:07',0,-1,0,NULL,NULL),(3,'02','Mobile',NULL,NULL,NULL,'categorypicture/02024012105052496x123.png','mobile',1,'2023-10-08 10:09:29',0,'2024-01-21 05:05:24',0,-1,0,NULL,NULL),(4,'03','Television',NULL,NULL,NULL,'categorypicture/02024012105084396x123.png','television',0,'2023-10-08 10:09:53',0,'2024-01-21 05:09:09',0,-1,0,NULL,NULL),(5,'04','Bike',NULL,NULL,NULL,'categorypicture/02024012105102396x123.png','bike',1,'2023-10-08 14:11:23',0,'2024-01-21 05:10:23',0,-1,0,NULL,NULL),(6,'05','Men\'s Fashion',NULL,NULL,NULL,'categorypicture/02024012105332296x123.png','men\'s-fashion',1,'2023-10-08 14:37:21',0,'2024-01-21 05:33:22',0,-1,0,NULL,NULL),(7,'06','Women\'s Fashion',NULL,NULL,NULL,'categorypicture/02024012105334796x123.png','women-fashion',1,'2023-12-29 10:53:56',0,'2024-01-21 05:33:47',0,-1,0,NULL,NULL),(8,'07','Home and Lifestyle',NULL,NULL,NULL,'categorypicture/02024012105333396x123.png','home-and-lifestyle',1,'2023-12-29 10:55:42',0,'2024-01-21 05:33:33',0,-1,0,NULL,NULL),(9,'08','Babies and Toys',NULL,NULL,NULL,'categorypicture/02024012105051396x123.png','babies-and-toys',1,'2024-01-03 01:48:03',0,'2024-01-21 05:05:13',0,-1,0,NULL,NULL),(10,'09','Electronics Accessories',NULL,NULL,NULL,'categorypicture/02024012105341996x123.png','electronics-accessories',1,'2024-01-20 21:17:37',0,'2024-01-21 05:34:19',0,-1,0,NULL,NULL),(11,'10','Vehicles & Accessories',NULL,NULL,NULL,'categorypicture/02024012105343296x123.png','vehicles-accessories',1,'2024-01-20 21:18:04',0,'2024-01-21 05:34:32',0,-1,0,NULL,NULL),(12,'11','Camera',NULL,NULL,NULL,'categorypicture/020240120211846505-error.png','camera',1,'2024-01-20 21:18:46',0,NULL,0,1,0,NULL,NULL),(13,'12','Suzuki',NULL,NULL,NULL,'categorypicture/020240120211916505-error.png','suzuki',1,'2024-01-20 21:19:16',0,NULL,0,5,0,NULL,NULL),(14,'13','TVS Motor',NULL,NULL,NULL,'categorypicture/020240120211945505-error.png','tvs-motor',1,'2024-01-20 21:19:45',0,NULL,0,5,0,NULL,NULL),(15,'14','Honda',NULL,NULL,NULL,'categorypicture/02024012105350396x123.png','honda',1,'2024-01-20 21:20:46',0,'2024-01-21 05:35:03',0,5,0,NULL,NULL),(16,'15','T-shirt',NULL,NULL,NULL,'categorypicture/02024012105344796x123.png','tshirt',1,'2024-01-20 21:21:32',0,'2024-01-21 05:34:47',0,6,0,NULL,NULL),(17,'16','Face Wash',NULL,NULL,NULL,'categorypicture/02024012105340796x123.png','face-wash',1,'2024-01-20 21:21:55',0,'2024-01-21 05:34:07',0,7,0,NULL,NULL),(18,'17','Gaming Desktop',NULL,NULL,NULL,'categorypicture/02024012105024096x123.png','gaming-desktop',1,'2024-01-21 05:02:40',0,NULL,0,1,0,NULL,NULL),(19,'18','Computer Accessories',NULL,NULL,NULL,'categorypicture/02024012105041396x123.png','computer-accessories',1,'2024-01-21 05:04:13',0,'2024-01-21 05:04:59',0,1,0,NULL,NULL),(20,'19','Mobile Phone Accessories',NULL,NULL,NULL,'categorypicture/02024012105060196x123.png','mobile-phone-accessories',1,'2024-01-21 05:06:01',0,NULL,0,1,0,NULL,NULL),(21,'20','Samsung',NULL,NULL,NULL,'categorypicture/02024012105062896x123.png','samsung',1,'2024-01-21 05:06:28',0,NULL,0,3,0,NULL,NULL),(22,'21','I-Phone',NULL,NULL,NULL,'categorypicture/02024012105072096x123.png','iphone',1,'2024-01-21 05:07:20',0,NULL,0,3,0,NULL,NULL),(23,'22','Shirt',NULL,NULL,NULL,'categorypicture/02024012105074596x123.png','shirt',1,'2024-01-21 05:07:45',0,'2024-01-21 05:14:25',0,6,0,NULL,NULL),(24,'23','Shoulder Bag',NULL,NULL,NULL,'categorypicture/02024012105081296x123.png','shoulder-bag',1,'2024-01-21 05:08:12',0,'2024-01-21 05:14:41',0,7,0,NULL,NULL),(25,'24','Huddy',NULL,NULL,NULL,'categorypicture/02024012105105296x123.png','huddy',1,'2024-01-21 05:10:52',0,'2024-01-21 05:14:58',0,6,0,NULL,NULL),(26,'25','Huddy',NULL,NULL,NULL,'categorypicture/02024012105113596x123.png','women-huddy',1,'2024-01-21 05:11:35',0,NULL,0,7,0,NULL,NULL),(28,'27','Shoes',NULL,NULL,NULL,'categorypicture/02024012105124696x123.png','men-shoes',1,'2024-01-21 05:12:46',0,NULL,0,6,0,NULL,NULL),(29,'28','Shoes',NULL,NULL,NULL,'categorypicture/02024012105131096x123.png','women-shoes',1,'2024-01-21 05:13:10',0,NULL,0,7,0,NULL,NULL),(30,'29','Jeans',NULL,NULL,NULL,'categorypicture/02024012105212396x123.png','jeans',1,'2024-01-21 05:21:23',0,NULL,0,6,0,NULL,NULL),(31,'30','Jeans',NULL,NULL,NULL,'categorypicture/02024012105215196x123.png','ladies-jeans',1,'2024-01-21 05:21:51',0,'2024-01-21 05:24:18',0,7,0,NULL,NULL),(32,'31','Jean\'s shirt',NULL,NULL,NULL,'categorypicture/02024012105231996x123.png','jeans-shirt',1,'2024-01-21 05:23:19',0,'2024-01-21 05:24:40',0,6,0,NULL,NULL),(33,'32','LED',NULL,NULL,NULL,'categorypicture/02024012105250796x123.png','led',1,'2024-01-21 05:25:07',0,NULL,0,1,0,NULL,NULL),(34,'33','Laptop',NULL,NULL,NULL,'categorypicture/02024012105252796x123.png','laptop',1,'2024-01-21 05:25:27',0,NULL,0,1,0,NULL,NULL),(35,'34','AC',NULL,NULL,NULL,'categorypicture/02024012105255896x123.png','ac',0,'2024-01-21 05:25:58',0,'2024-01-21 05:27:29',0,1,0,NULL,NULL),(36,'35','Nokia',NULL,NULL,NULL,'categorypicture/02024012105275496x123.png','nokia',1,'2024-01-21 05:27:54',0,NULL,0,3,0,NULL,NULL),(37,'36','I-Zone',NULL,NULL,NULL,'categorypicture/02024012105282996x123.png','izone',1,'2024-01-21 05:28:29',0,NULL,0,3,0,NULL,NULL),(38,'37','Redme',NULL,NULL,NULL,'categorypicture/02024012105284996x123.png','redme',1,'2024-01-21 05:28:49',0,NULL,0,3,0,NULL,NULL),(39,'38','Vivo',NULL,NULL,NULL,'categorypicture/02024012105302396x123.png','vivo',1,'2024-01-21 05:30:23',0,NULL,0,3,0,NULL,NULL),(40,'39','Sazgar',NULL,NULL,NULL,'categorypicture/02024012105311396x123.png','sazgar',1,'2024-01-21 05:31:13',0,NULL,0,5,0,NULL,NULL),(43,'dsfd','ےسدس',NULL,NULL,NULL,'categorypicture/020240317105131campusonweb.png',NULL,1,'2024-03-17 10:51:31',0,'2024-03-17 11:56:26',0,44,0,NULL,NULL),(44,'dfr4','ثاتسدف',NULL,NULL,'تفصیل سدسفد','categorypicture/0202403171052081709115834399.jpeg',NULL,0,'2024-03-17 10:52:08',0,'2024-03-17 11:07:19',0,43,0,NULL,NULL),(45,'fggffg','طچبگھ',NULL,NULL,'فدگ فدگ فدگھگھکگ ھھج','categorypicture/020240323155723WhatsApp Image 2024-03-22 at 23.27.51.jpeg',NULL,1,'2024-03-23 15:57:23',0,'2024-03-23 15:57:58',0,44,0,NULL,NULL),(46,'066','Electronics Accessories update','الیکٹرانکس لوازمات کی تازہ کاری',NULL,NULL,'None',NULL,1,'2024-04-26 11:05:56',0,'2024-04-26 11:24:01',0,-1,0,NULL,NULL),(47,'CC-0000047','fsdgdfg',NULL,NULL,'dfg','categorypicture/020240610071411Puma-Logo.png',NULL,1,'2024-06-10 07:14:10',0,NULL,0,3,0,NULL,NULL),(48,'CC-0000048','gf','گفھفگ',NULL,'fgh','None',NULL,1,'2024-06-27 11:52:28',1,NULL,0,1,0,NULL,NULL);

--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `Id` int unsigned NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `StateId` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `city`
--

INSERT INTO `city` VALUES (1,'01','Lahore',1,'2023-10-02 14:25:59',0,'2023-10-02 14:36:05',0,1,NULL,NULL);

--
-- Table structure for table `contactus`
--

CREATE TABLE `contactus` (
  `Id` int unsigned NOT NULL,
  `Country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `EmailAddress` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Subject` text COLLATE utf8mb4_unicode_ci,
  `Description` text COLLATE utf8mb4_unicode_ci,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `MobileNumber` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contactus`
--

INSERT INTO `contactus` VALUES (28,NULL,'Nabeel Bin Ezad','nabeel.ezad@gmail.com','dsfa','sdfdsf',1,'2024-02-23 19:17:52',0,NULL,0,NULL,NULL,'03244492569'),(29,NULL,'Nabeel Bin Ezad','nabeel.ezad@gmail.com','dsfds','sfsdfdsf',1,'2024-02-23 19:20:38',0,NULL,0,NULL,NULL,'03244492569'),(30,NULL,'Nabeel Bin Ezad','nabeel.ezad@gmail.com','tete','dgdgdg',1,'2024-02-23 19:31:47',0,NULL,0,NULL,NULL,'03244492569'),(31,NULL,'Nabeel Bin Ezad','nabeel.ezad@gmail.com','tete','dgdgdg',1,'2024-02-23 19:35:22',0,NULL,0,NULL,NULL,'03244492569'),(32,NULL,'Nabeel Bin Ezad','nabeel.ezad@gmail.com','tete','dgdgdg',1,'2024-02-23 19:36:13',0,NULL,0,NULL,NULL,'03244492569'),(33,NULL,'Nabeel Bin Ezad','nabeel.ezad@gmail.com','test email','sddsfd',1,'2024-02-23 19:37:30',0,NULL,0,NULL,NULL,'03244492569');

--
-- Table structure for table `contactusreply`
--

CREATE TABLE `contactusreply` (
  `Id` int unsigned NOT NULL,
  `Country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `EmailAddress` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_unicode_ci,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `ReplyContactUsId` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contactusreply`
--


--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `Id` int unsigned NOT NULL,
  `iso` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nicename` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `numcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phonecode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` VALUES (1,'AF','AFGHANISTAN','Afghanistan','AFG','4','93',1,NULL,0,NULL,0,NULL,NULL),(2,'AL','ALBANIA','Albania','ALB','8','355',1,NULL,0,NULL,0,NULL,NULL),(3,'DZ','ALGERIA','Algeria','DZA','12','213',1,NULL,0,NULL,0,NULL,NULL),(4,'AS','AMERICAN SAMOA','American Samoa','ASM','16','1684',1,NULL,0,NULL,0,NULL,NULL),(5,'AD','ANDORRA','Andorra','AND','20','376',1,NULL,0,NULL,0,NULL,NULL),(6,'AO','ANGOLA','Angola','AGO','24','244',1,NULL,0,NULL,0,NULL,NULL),(7,'AI','ANGUILLA','Anguilla','AIA','660','1264',1,NULL,0,NULL,0,NULL,NULL),(8,'AQ','ANTARCTICA','Antarctica',NULL,NULL,'0',1,NULL,0,NULL,0,NULL,NULL),(9,'AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','28','1268',1,NULL,0,NULL,0,NULL,NULL),(10,'AR','ARGENTINA','Argentina','ARG','32','54',1,NULL,0,NULL,0,NULL,NULL),(11,'AM','ARMENIA','Armenia','ARM','51','374',1,NULL,0,NULL,0,NULL,NULL),(12,'AW','ARUBA','Aruba','ABW','533','297',1,NULL,0,NULL,0,NULL,NULL),(13,'AU','AUSTRALIA','Australia','AUS','36','61',1,NULL,0,NULL,0,NULL,NULL),(14,'AT','AUSTRIA','Austria','AUT','40','43',1,NULL,0,NULL,0,NULL,NULL),(15,'AZ','AZERBAIJAN','Azerbaijan','AZE','31','994',1,NULL,0,NULL,0,NULL,NULL),(16,'BS','BAHAMAS','Bahamas','BHS','44','1242',1,NULL,0,NULL,0,NULL,NULL),(17,'BH','BAHRAIN','Bahrain','BHR','48','973',1,NULL,0,NULL,0,NULL,NULL),(18,'BD','BANGLADESH','Bangladesh','BGD','50','880',1,NULL,0,NULL,0,NULL,NULL),(19,'BB','BARBADOS','Barbados','BRB','52','1246',1,NULL,0,NULL,0,NULL,NULL),(20,'BY','BELARUS','Belarus','BLR','112','375',1,NULL,0,NULL,0,NULL,NULL),(21,'BE','BELGIUM','Belgium','BEL','56','32',1,NULL,0,NULL,0,NULL,NULL),(22,'BZ','BELIZE','Belize','BLZ','84','501',1,NULL,0,NULL,0,NULL,NULL),(23,'BJ','BENIN','Benin','BEN','204','229',1,NULL,0,NULL,0,NULL,NULL),(24,'BM','BERMUDA','Bermuda','BMU','60','1441',1,NULL,0,NULL,0,NULL,NULL),(25,'BT','BHUTAN','Bhutan','BTN','64','975',1,NULL,0,NULL,0,NULL,NULL),(26,'BO','BOLIVIA','Bolivia','BOL','68','591',1,NULL,0,NULL,0,NULL,NULL),(27,'BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','70','387',1,NULL,0,NULL,0,NULL,NULL),(28,'BW','BOTSWANA','Botswana','BWA','72','267',1,NULL,0,NULL,0,NULL,NULL),(29,'BV','BOUVET ISLAND','Bouvet Island',NULL,NULL,'0',1,NULL,0,NULL,0,NULL,NULL),(30,'BR','BRAZIL','Brazil','BRA','76','55',1,NULL,0,NULL,0,NULL,NULL),(31,'IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL,'246',1,NULL,0,NULL,0,NULL,NULL),(32,'BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','96','673',1,NULL,0,NULL,0,NULL,NULL),(33,'BG','BULGARIA','Bulgaria','BGR','100','359',1,NULL,0,NULL,0,NULL,NULL),(34,'BF','BURKINA FASO','Burkina Faso','BFA','854','226',1,NULL,0,NULL,0,NULL,NULL),(35,'BI','BURUNDI','Burundi','BDI','108','257',1,NULL,0,NULL,0,NULL,NULL),(36,'KH','CAMBODIA','Cambodia','KHM','116','855',1,NULL,0,NULL,0,NULL,NULL),(37,'CM','CAMEROON','Cameroon','CMR','120','237',1,NULL,0,NULL,0,NULL,NULL),(38,'CA','CANADA','Canada','CAN','124','1',1,NULL,0,NULL,0,NULL,NULL),(39,'CV','CAPE VERDE','Cape Verde','CPV','132','238',1,NULL,0,NULL,0,NULL,NULL),(40,'KY','CAYMAN ISLANDS','Cayman Islands','CYM','136','1345',1,NULL,0,NULL,0,NULL,NULL),(41,'CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140','236',1,NULL,0,NULL,0,NULL,NULL),(42,'TD','CHAD','Chad','TCD','148','235',1,NULL,0,NULL,0,NULL,NULL),(43,'CL','CHILE','Chile','CHL','152','56',1,NULL,0,NULL,0,NULL,NULL),(44,'CN','CHINA','China','CHN','156','86',1,NULL,0,NULL,0,NULL,NULL),(45,'CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL,'61',1,NULL,0,NULL,0,NULL,NULL),(46,'CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL,'672',1,NULL,0,NULL,0,NULL,NULL),(47,'CO','COLOMBIA','Colombia','COL','170','57',1,NULL,0,NULL,0,NULL,NULL),(48,'KM','COMOROS','Comoros','COM','174','269',1,NULL,0,NULL,0,NULL,NULL),(49,'CG','CONGO','Congo','COG','178','242',1,NULL,0,NULL,0,NULL,NULL),(50,'CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180','242',1,NULL,0,NULL,0,NULL,NULL),(51,'CK','COOK ISLANDS','Cook Islands','COK','184','682',1,NULL,0,NULL,0,NULL,NULL),(52,'CR','COSTA RICA','Costa Rica','CRI','188','506',1,NULL,0,NULL,0,NULL,NULL),(53,'CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384','225',1,NULL,0,NULL,0,NULL,NULL),(54,'HR','CROATIA','Croatia','HRV','191','385',1,NULL,0,NULL,0,NULL,NULL),(55,'CU','CUBA','Cuba','CUB','192','53',1,NULL,0,NULL,0,NULL,NULL),(56,'CY','CYPRUS','Cyprus','CYP','196','357',1,NULL,0,NULL,0,NULL,NULL),(57,'CZ','CZECH REPUBLIC','Czech Republic','CZE','203','420',1,NULL,0,NULL,0,NULL,NULL),(58,'DK','DENMARK','Denmark','DNK','208','45',1,NULL,0,NULL,0,NULL,NULL),(59,'DJ','DJIBOUTI','Djibouti','DJI','262','253',1,NULL,0,NULL,0,NULL,NULL),(60,'DM','DOMINICA','Dominica','DMA','212','1767',1,NULL,0,NULL,0,NULL,NULL),(61,'DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214','1809',1,NULL,0,NULL,0,NULL,NULL),(62,'EC','ECUADOR','Ecuador','ECU','218','593',1,NULL,0,NULL,0,NULL,NULL),(63,'EG','EGYPT','Egypt','EGY','818','20',1,NULL,0,NULL,0,NULL,NULL),(64,'SV','EL SALVADOR','El Salvador','SLV','222','503',1,NULL,0,NULL,0,NULL,NULL),(65,'GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226','240',1,NULL,0,NULL,0,NULL,NULL),(66,'ER','ERITREA','Eritrea','ERI','232','291',1,NULL,0,NULL,0,NULL,NULL),(67,'EE','ESTONIA','Estonia','EST','233','372',1,NULL,0,NULL,0,NULL,NULL),(68,'ET','ETHIOPIA','Ethiopia','ETH','231','251',1,NULL,0,NULL,0,NULL,NULL),(69,'FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238','500',1,NULL,0,NULL,0,NULL,NULL),(70,'FO','FAROE ISLANDS','Faroe Islands','FRO','234','298',1,NULL,0,NULL,0,NULL,NULL),(71,'FJ','FIJI','Fiji','FJI','242','679',1,NULL,0,NULL,0,NULL,NULL),(72,'FI','FINLAND','Finland','FIN','246','358',1,NULL,0,NULL,0,NULL,NULL),(73,'FR','FRANCE','France','FRA','250','33',1,NULL,0,NULL,0,NULL,NULL),(74,'GF','FRENCH GUIANA','French Guiana','GUF','254','594',1,NULL,0,NULL,0,NULL,NULL),(75,'PF','FRENCH POLYNESIA','French Polynesia','PYF','258','689',1,NULL,0,NULL,0,NULL,NULL),(76,'TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL,'0',1,NULL,0,NULL,0,NULL,NULL),(77,'GA','GABON','Gabon','GAB','266','241',1,NULL,0,NULL,0,NULL,NULL),(78,'GM','GAMBIA','Gambia','GMB','270','220',1,NULL,0,NULL,0,NULL,NULL),(79,'GE','GEORGIA','Georgia','GEO','268','995',1,NULL,0,NULL,0,NULL,NULL),(80,'DE','GERMANY','Germany','DEU','276','49',1,NULL,0,NULL,0,NULL,NULL),(81,'GH','GHANA','Ghana','GHA','288','233',1,NULL,0,NULL,0,NULL,NULL),(82,'GI','GIBRALTAR','Gibraltar','GIB','292','350',1,NULL,0,NULL,0,NULL,NULL),(83,'GR','GREECE','Greece','GRC','300','30',1,NULL,0,NULL,0,NULL,NULL),(84,'GL','GREENLAND','Greenland','GRL','304','299',1,NULL,0,NULL,0,NULL,NULL),(85,'GD','GRENADA','Grenada','GRD','308','1473',1,NULL,0,NULL,0,NULL,NULL),(86,'GP','GUADELOUPE','Guadeloupe','GLP','312','590',1,NULL,0,NULL,0,NULL,NULL),(87,'GU','GUAM','Guam','GUM','316','1671',1,NULL,0,NULL,0,NULL,NULL),(88,'GT','GUATEMALA','Guatemala','GTM','320','502',1,NULL,0,NULL,0,NULL,NULL),(89,'GN','GUINEA','Guinea','GIN','324','224',1,NULL,0,NULL,0,NULL,NULL),(90,'GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624','245',1,NULL,0,NULL,0,NULL,NULL),(91,'GY','GUYANA','Guyana','GUY','328','592',1,NULL,0,NULL,0,NULL,NULL),(92,'HT','HAITI','Haiti','HTI','332','509',1,NULL,0,NULL,0,NULL,NULL),(93,'HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL,'0',1,NULL,0,NULL,0,NULL,NULL),(94,'VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336','39',1,NULL,0,NULL,0,NULL,NULL),(95,'HN','HONDURAS','Honduras','HND','340','504',1,NULL,0,NULL,0,NULL,NULL),(96,'HK','HONG KONG','Hong Kong','HKG','344','852',1,NULL,0,NULL,0,NULL,NULL),(97,'HU','HUNGARY','Hungary','HUN','348','36',1,NULL,0,NULL,0,NULL,NULL),(98,'IS','ICELAND','Iceland','ISL','352','354',1,NULL,0,NULL,0,NULL,NULL),(99,'IN','INDIA','India','IND','356','91',1,NULL,0,NULL,0,NULL,NULL),(100,'ID','INDONESIA','Indonesia','IDN','360','62',1,NULL,0,NULL,0,NULL,NULL),(101,'IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364','98',1,NULL,0,NULL,0,NULL,NULL),(102,'IQ','IRAQ','Iraq','IRQ','368','964',1,NULL,0,NULL,0,NULL,NULL),(103,'IE','IRELAND','Ireland','IRL','372','353',1,NULL,0,NULL,0,NULL,NULL),(104,'IL','ISRAEL','Israel','ISR','376','972',1,NULL,0,NULL,0,NULL,NULL),(105,'IT','ITALY','Italy','ITA','380','39',1,NULL,0,NULL,0,NULL,NULL),(106,'JM','JAMAICA','Jamaica','JAM','388','1876',1,NULL,0,NULL,0,NULL,NULL),(107,'JP','JAPAN','Japan','JPN','392','81',1,NULL,0,NULL,0,NULL,NULL),(108,'JO','JORDAN','Jordan','JOR','400','962',1,NULL,0,NULL,0,NULL,NULL),(109,'KZ','KAZAKHSTAN','Kazakhstan','KAZ','398','7',1,NULL,0,NULL,0,NULL,NULL),(110,'KE','KENYA','Kenya','KEN','404','254',1,NULL,0,NULL,0,NULL,NULL),(111,'KI','KIRIBATI','Kiribati','KIR','296','686',1,NULL,0,NULL,0,NULL,NULL),(112,'KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408','850',1,NULL,0,NULL,0,NULL,NULL),(113,'KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410','82',1,NULL,0,NULL,0,NULL,NULL),(114,'KW','KUWAIT','Kuwait','KWT','414','965',1,NULL,0,NULL,0,NULL,NULL),(115,'KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417','996',1,NULL,0,NULL,0,NULL,NULL),(116,'LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418','856',1,NULL,0,NULL,0,NULL,NULL),(117,'LV','LATVIA','Latvia','LVA','428','371',1,NULL,0,NULL,0,NULL,NULL),(118,'LB','LEBANON','Lebanon','LBN','422','961',1,NULL,0,NULL,0,NULL,NULL),(119,'LS','LESOTHO','Lesotho','LSO','426','266',1,NULL,0,NULL,0,NULL,NULL),(120,'LR','LIBERIA','Liberia','LBR','430','231',1,NULL,0,NULL,0,NULL,NULL),(121,'LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434','218',1,NULL,0,NULL,0,NULL,NULL),(122,'LI','LIECHTENSTEIN','Liechtenstein','LIE','438','423',1,NULL,0,NULL,0,NULL,NULL),(123,'LT','LITHUANIA','Lithuania','LTU','440','370',1,NULL,0,NULL,0,NULL,NULL),(124,'LU','LUXEMBOURG','Luxembourg','LUX','442','352',1,NULL,0,NULL,0,NULL,NULL),(125,'MO','MACAO','Macao','MAC','446','853',1,NULL,0,NULL,0,NULL,NULL),(126,'MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807','389',1,NULL,0,NULL,0,NULL,NULL),(127,'MG','MADAGASCAR','Madagascar','MDG','450','261',1,NULL,0,NULL,0,NULL,NULL),(128,'MW','MALAWI','Malawi','MWI','454','265',1,NULL,0,NULL,0,NULL,NULL),(129,'MY','MALAYSIA','Malaysia','MYS','458','60',1,NULL,0,NULL,0,NULL,NULL),(130,'MV','MALDIVES','Maldives','MDV','462','960',1,NULL,0,NULL,0,NULL,NULL),(131,'ML','MALI','Mali','MLI','466','223',1,NULL,0,NULL,0,NULL,NULL),(132,'MT','MALTA','Malta','MLT','470','356',1,NULL,0,NULL,0,NULL,NULL),(133,'MH','MARSHALL ISLANDS','Marshall Islands','MHL','584','692',1,NULL,0,NULL,0,NULL,NULL),(134,'MQ','MARTINIQUE','Martinique','MTQ','474','596',1,NULL,0,NULL,0,NULL,NULL),(135,'MR','MAURITANIA','Mauritania','MRT','478','222',1,NULL,0,NULL,0,NULL,NULL),(136,'MU','MAURITIUS','Mauritius','MUS','480','230',1,NULL,0,NULL,0,NULL,NULL),(137,'YT','MAYOTTE','Mayotte',NULL,NULL,'269',1,NULL,0,NULL,0,NULL,NULL),(138,'MX','MEXICO','Mexico','MEX','484','52',1,NULL,0,NULL,0,NULL,NULL),(139,'FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583','691',1,NULL,0,NULL,0,NULL,NULL),(140,'MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498','373',1,NULL,0,NULL,0,NULL,NULL),(141,'MC','MONACO','Monaco','MCO','492','377',1,NULL,0,NULL,0,NULL,NULL),(142,'MN','MONGOLIA','Mongolia','MNG','496','976',1,NULL,0,NULL,0,NULL,NULL),(143,'MS','MONTSERRAT','Montserrat','MSR','500','1664',1,NULL,0,NULL,0,NULL,NULL),(144,'MA','MOROCCO','Morocco','MAR','504','212',1,NULL,0,NULL,0,NULL,NULL),(145,'MZ','MOZAMBIQUE','Mozambique','MOZ','508','258',1,NULL,0,NULL,0,NULL,NULL),(146,'MM','MYANMAR','Myanmar','MMR','104','95',1,NULL,0,NULL,0,NULL,NULL),(147,'NA','NAMIBIA','Namibia','NAM','516','264',1,NULL,0,NULL,0,NULL,NULL),(148,'NR','NAURU','Nauru','NRU','520','674',1,NULL,0,NULL,0,NULL,NULL),(149,'NP','NEPAL','Nepal','NPL','524','977',1,NULL,0,NULL,0,NULL,NULL),(150,'NL','NETHERLANDS','Netherlands','NLD','528','31',1,NULL,0,NULL,0,NULL,NULL),(151,'AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530','599',1,NULL,0,NULL,0,NULL,NULL),(152,'NC','NEW CALEDONIA','New Caledonia','NCL','540','687',1,NULL,0,NULL,0,NULL,NULL),(153,'NZ','NEW ZEALAND','New Zealand','NZL','554','64',1,NULL,0,NULL,0,NULL,NULL),(154,'NI','NICARAGUA','Nicaragua','NIC','558','505',1,NULL,0,NULL,0,NULL,NULL),(155,'NE','NIGER','Niger','NER','562','227',1,NULL,0,NULL,0,NULL,NULL),(156,'NG','NIGERIA','Nigeria','NGA','566','234',1,NULL,0,NULL,0,NULL,NULL),(157,'NU','NIUE','Niue','NIU','570','683',1,NULL,0,NULL,0,NULL,NULL),(158,'NF','NORFOLK ISLAND','Norfolk Island','NFK','574','672',1,NULL,0,NULL,0,NULL,NULL),(159,'MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580','1670',1,NULL,0,NULL,0,NULL,NULL),(160,'NO','NORWAY','Norway','NOR','578','47',1,NULL,0,NULL,0,NULL,NULL),(161,'OM','OMAN','Oman','OMN','512','968',1,NULL,0,NULL,0,NULL,NULL),(162,'PK','PAKISTAN','Pakistan','PAK','586','92',1,NULL,0,NULL,0,NULL,NULL),(163,'PW','PALAU','Palau','PLW','585','680',1,NULL,0,NULL,0,NULL,NULL),(164,'PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL,'970',1,NULL,0,NULL,0,NULL,NULL),(165,'PA','PANAMA','Panama','PAN','591','507',1,NULL,0,NULL,0,NULL,NULL),(166,'PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598','675',1,NULL,0,NULL,0,NULL,NULL),(167,'PY','PARAGUAY','Paraguay','PRY','600','595',1,NULL,0,NULL,0,NULL,NULL),(168,'PE','PERU','Peru','PER','604','51',1,NULL,0,NULL,0,NULL,NULL),(169,'PH','PHILIPPINES','Philippines','PHL','608','63',1,NULL,0,NULL,0,NULL,NULL),(170,'PN','PITCAIRN','Pitcairn','PCN','612','0',1,NULL,0,NULL,0,NULL,NULL),(171,'PL','POLAND','Poland','POL','616','48',1,NULL,0,NULL,0,NULL,NULL),(172,'PT','PORTUGAL','Portugal','PRT','620','351',1,NULL,0,NULL,0,NULL,NULL),(173,'PR','PUERTO RICO','Puerto Rico','PRI','630','1787',1,NULL,0,NULL,0,NULL,NULL),(174,'QA','QATAR','Qatar','QAT','634','974',1,NULL,0,NULL,0,NULL,NULL),(175,'RE','REUNION','Reunion','REU','638','262',1,NULL,0,NULL,0,NULL,NULL),(176,'RO','ROMANIA','Romania','ROM','642','40',1,NULL,0,NULL,0,NULL,NULL),(177,'RU','RUSSIAN FEDERATION','Russian Federation','RUS','643','70',1,NULL,0,NULL,0,NULL,NULL),(178,'RW','RWANDA','Rwanda','RWA','646','250',1,NULL,0,NULL,0,NULL,NULL),(179,'SH','SAINT HELENA','Saint Helena','SHN','654','290',1,NULL,0,NULL,0,NULL,NULL),(180,'KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659','1869',1,NULL,0,NULL,0,NULL,NULL),(181,'LC','SAINT LUCIA','Saint Lucia','LCA','662','1758',1,NULL,0,NULL,0,NULL,NULL),(182,'PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666','508',1,NULL,0,NULL,0,NULL,NULL),(183,'VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670','1784',1,NULL,0,NULL,0,NULL,NULL),(184,'WS','SAMOA','Samoa','WSM','882','684',1,NULL,0,NULL,0,NULL,NULL),(185,'SM','SAN MARINO','San Marino','SMR','674','378',1,NULL,0,NULL,0,NULL,NULL),(186,'ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678','239',1,NULL,0,NULL,0,NULL,NULL),(187,'SA','SAUDI ARABIA','Saudi Arabia','SAU','682','966',1,NULL,0,NULL,0,NULL,NULL),(188,'SN','SENEGAL','Senegal','SEN','686','221',1,NULL,0,NULL,0,NULL,NULL),(189,'CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL,'381',1,NULL,0,NULL,0,NULL,NULL),(190,'SC','SEYCHELLES','Seychelles','SYC','690','248',1,NULL,0,NULL,0,NULL,NULL),(191,'SL','SIERRA LEONE','Sierra Leone','SLE','694','232',1,NULL,0,NULL,0,NULL,NULL),(192,'SG','SINGAPORE','Singapore','SGP','702','65',1,NULL,0,NULL,0,NULL,NULL),(193,'SK','SLOVAKIA','Slovakia','SVK','703','421',1,NULL,0,NULL,0,NULL,NULL),(194,'SI','SLOVENIA','Slovenia','SVN','705','386',1,NULL,0,NULL,0,NULL,NULL),(195,'SB','SOLOMON ISLANDS','Solomon Islands','SLB','90','677',1,NULL,0,NULL,0,NULL,NULL),(196,'SO','SOMALIA','Somalia','SOM','706','252',1,NULL,0,NULL,0,NULL,NULL),(197,'ZA','SOUTH AFRICA','South Africa','ZAF','710','27',1,NULL,0,NULL,0,NULL,NULL),(198,'GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL,'0',1,NULL,0,NULL,0,NULL,NULL),(199,'ES','SPAIN','Spain','ESP','724','34',1,NULL,0,NULL,0,NULL,NULL),(200,'LK','SRI LANKA','Sri Lanka','LKA','144','94',1,NULL,0,NULL,0,NULL,NULL),(201,'SD','SUDAN','Sudan','SDN','736','249',1,NULL,0,NULL,0,NULL,NULL),(202,'SR','SURINAME','Suriname','SUR','740','597',1,NULL,0,NULL,0,NULL,NULL),(203,'SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744','47',1,NULL,0,NULL,0,NULL,NULL),(204,'SZ','SWAZILAND','Swaziland','SWZ','748','268',1,NULL,0,NULL,0,NULL,NULL),(205,'SE','SWEDEN','Sweden','SWE','752','46',1,NULL,0,NULL,0,NULL,NULL),(206,'CH','SWITZERLAND','Switzerland','CHE','756','41',1,NULL,0,NULL,0,NULL,NULL),(207,'SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760','963',1,NULL,0,NULL,0,NULL,NULL),(208,'TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158','886',1,NULL,0,NULL,0,NULL,NULL),(209,'TJ','TAJIKISTAN','Tajikistan','TJK','762','992',1,NULL,0,NULL,0,NULL,NULL),(210,'TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834','255',1,NULL,0,NULL,0,NULL,NULL),(211,'TH','THAILAND','Thailand','THA','764','66',1,NULL,0,NULL,0,NULL,NULL),(212,'TL','TIMOR-LESTE','Timor-Leste',NULL,NULL,'670',1,NULL,0,NULL,0,NULL,NULL),(213,'TG','TOGO','Togo','TGO','768','228',1,NULL,0,NULL,0,NULL,NULL),(214,'TK','TOKELAU','Tokelau','TKL','772','690',1,NULL,0,NULL,0,NULL,NULL),(215,'TO','TONGA','Tonga','TON','776','676',1,NULL,0,NULL,0,NULL,NULL),(216,'TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780','1868',1,NULL,0,NULL,0,NULL,NULL),(217,'TN','TUNISIA','Tunisia','TUN','788','216',1,NULL,0,NULL,0,NULL,NULL),(218,'TR','TURKEY','Turkey','TUR','792','90',1,NULL,0,NULL,0,NULL,NULL),(219,'TM','TURKMENISTAN','Turkmenistan','TKM','795','7370',1,NULL,0,NULL,0,NULL,NULL),(220,'TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796','1649',1,NULL,0,NULL,0,NULL,NULL),(221,'TV','TUVALU','Tuvalu','TUV','798','688',1,NULL,0,NULL,0,NULL,NULL),(222,'UG','UGANDA','Uganda','UGA','800','256',1,NULL,0,NULL,0,NULL,NULL),(223,'UA','UKRAINE','Ukraine','UKR','804','380',1,NULL,0,NULL,0,NULL,NULL),(224,'AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784','971',1,NULL,0,NULL,0,NULL,NULL),(225,'GB','UNITED KINGDOM','United Kingdom','GBR','826','44',1,NULL,0,NULL,0,NULL,NULL),(226,'US','UNITED STATES','United States','USA','840','1',1,NULL,0,NULL,0,NULL,NULL),(227,'UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL,'1',1,NULL,0,NULL,0,NULL,NULL),(228,'UY','URUGUAY','Uruguay','URY','858','598',1,NULL,0,NULL,0,NULL,NULL),(229,'UZ','UZBEKISTAN','Uzbekistan','UZB','860','998',1,NULL,0,NULL,0,NULL,NULL),(230,'VU','VANUATU','Vanuatu','VUT','548','678',1,NULL,0,NULL,0,NULL,NULL),(231,'VE','VENEZUELA','Venezuela','VEN','862','58',1,NULL,0,NULL,0,NULL,NULL),(232,'VN','VIET NAM','Viet Nam','VNM','704','84',1,NULL,0,NULL,0,NULL,NULL),(233,'VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','92','1284',1,NULL,0,NULL,0,NULL,NULL),(234,'VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850','1340',1,NULL,0,NULL,0,NULL,NULL),(235,'WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876','681',1,NULL,0,NULL,0,NULL,NULL),(236,'EH','WESTERN SAHARA','Western Sahara','ESH','732','212',1,NULL,0,NULL,0,NULL,NULL),(237,'YE','YEMEN','Yemen','YEM','887','967',1,NULL,0,NULL,0,NULL,NULL),(238,'ZM','ZAMBIA','Zambia','ZMB','894','260',1,NULL,0,NULL,0,NULL,NULL),(239,'ZW','ZIMBABWE','Zimbabwe','ZWE','716','263',1,NULL,0,NULL,0,NULL,NULL);

--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `Id` bigint unsigned NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NumberOfTime` int DEFAULT NULL,
  `ExpireDate` datetime DEFAULT NULL,
  `DiscountPerFlat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DiscountValue` double(8,2) DEFAULT NULL,
  `Status` int NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `ApplyQty` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupon`
--

INSERT INTO `coupon` VALUES (1,'test','0333',6,'2024-02-02 00:00:00','Percentage',10.00,1,'2024-01-28 06:27:36',0,NULL,0,0,NULL,NULL);

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `Id` int NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Symbol` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int NOT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` VALUES (1,'USD','$',1,0,NULL,NULL,NULL),(2,'PKR','RS.',1,0,NULL,NULL,NULL);

--
-- Table structure for table `currencylist`
--

CREATE TABLE `currencylist` (
  `country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `symbol` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `currencylist`
--

INSERT INTO `currencylist` VALUES ('Albania','Leke','ALL','Lek'),('America','Dollars','USD','$'),('Afghanistan','Afghanis','AFN','؋'),('Argentina','Pesos','ARS','$'),('Aruba','Guilders','AWG','ƒ'),('Australia','Dollars','AUD','$'),('Azerbaijan','New Manats','AZN','ман'),('Bahamas','Dollars','BSD','$'),('Barbados','Dollars','BBD','$'),('Belarus','Rubles','BYR','p.'),('Belgium','Euro','EUR','€'),('Beliz','Dollars','BZD','BZ$'),('Bermuda','Dollars','BMD','$'),('Bolivia','Bolivianos','BOB','$b'),('Bosnia and Herzegovina','Convertible Marka','BAM','KM'),('Botswana','Pula','BWP','P'),('Bulgaria','Leva','BGN','лв'),('Brazil','Reais','BRL','R$'),('Britain (United Kingdom)','Pounds','GBP','£'),('Brunei Darussalam','Dollars','BND','$'),('Cambodia','Riels','KHR','៛'),('Canada','Dollars','CAD','$'),('Cayman Islands','Dollars','KYD','$'),('Chile','Pesos','CLP','$'),('China','Yuan Renminbi','CNY','¥'),('Colombia','Pesos','COP','$'),('Costa Rica','Colón','CRC','₡'),('Croatia','Kuna','HRK','kn'),('Cuba','Pesos','CUP','₱'),('Cyprus','Euro','EUR','€'),('Czech Republic','Koruny','CZK','Kč'),('Denmark','Kroner','DKK','kr'),('Dominican Republic','Pesos','DOP ','RD$'),('East Caribbean','Dollars','XCD','$'),('Egypt','Pounds','EGP','£'),('El Salvador','Colones','SVC','$'),('England (United Kingdom)','Pounds','GBP','£'),('Euro','Euro','EUR','€'),('Falkland Islands','Pounds','FKP','£'),('Fiji','Dollars','FJD','$'),('France','Euro','EUR','€'),('Ghana','Cedis','GHC','¢'),('Gibraltar','Pounds','GIP','£'),('Greece','Euro','EUR','€'),('Guatemala','Quetzales','GTQ','Q'),('Guernsey','Pounds','GGP','£'),('Guyana','Dollars','GYD','$'),('Holland (Netherlands)','Euro','EUR','€'),('Honduras','Lempiras','HNL','L'),('Hong Kong','Dollars','HKD','$'),('Hungary','Forint','HUF','Ft'),('Iceland','Kronur','ISK','kr'),('India','Rupees','INR','Rp'),('Indonesia','Rupiahs','IDR','Rp'),('Iran','Rials','IRR','﷼'),('Ireland','Euro','EUR','€'),('Isle of Man','Pounds','IMP','£'),('Israel','New Shekels','ILS','₪'),('Italy','Euro','EUR','€'),('Jamaica','Dollars','JMD','J$'),('Japan','Yen','JPY','¥'),('Jersey','Pounds','JEP','£'),('Kazakhstan','Tenge','KZT','лв'),('Korea (North)','Won','KPW','₩'),('Korea (South)','Won','KRW','₩'),('Kyrgyzstan','Soms','KGS','лв'),('Laos','Kips','LAK','₭'),('Latvia','Lati','LVL','Ls'),('Lebanon','Pounds','LBP','£'),('Liberia','Dollars','LRD','$'),('Liechtenstein','Switzerland Francs','CHF','CHF'),('Lithuania','Litai','LTL','Lt'),('Luxembourg','Euro','EUR','€'),('Macedonia','Denars','MKD','ден'),('Malaysia','Ringgits','MYR','RM'),('Malta','Euro','EUR','€'),('Mauritius','Rupees','MUR','₨'),('Mexico','Pesos','MXN','$'),('Mongolia','Tugriks','MNT','₮'),('Mozambique','Meticais','MZN','MT'),('Namibia','Dollars','NAD','$'),('Nepal','Rupees','NPR','₨'),('Netherlands Antilles','Guilders','ANG','ƒ'),('Netherlands','Euro','EUR','€'),('New Zealand','Dollars','NZD','$'),('Nicaragua','Cordobas','NIO','C$'),('Nigeria','Nairas','NGN','₦'),('North Korea','Won','KPW','₩'),('Norway','Krone','NOK','kr'),('Oman','Rials','OMR','﷼'),('Pakistan','Rupees','PKR','₨'),('Panama','Balboa','PAB','B/.'),('Paraguay','Guarani','PYG','Gs'),('Peru','Nuevos Soles','PEN','S/.'),('Philippines','Pesos','PHP','Php'),('Poland','Zlotych','PLN','zł'),('Qatar','Rials','QAR','﷼'),('Romania','New Lei','RON','lei'),('Russia','Rubles','RUB','руб'),('Saint Helena','Pounds','SHP','£'),('Saudi Arabia','Riyals','SAR','﷼'),('Serbia','Dinars','RSD','Дин.'),('Seychelles','Rupees','SCR','₨'),('Singapore','Dollars','SGD','$'),('Slovenia','Euro','EUR','€'),('Solomon Islands','Dollars','SBD','$'),('Somalia','Shillings','SOS','S'),('South Africa','Rand','ZAR','R'),('South Korea','Won','KRW','₩'),('Spain','Euro','EUR','€'),('Sri Lanka','Rupees','LKR','₨'),('Sweden','Kronor','SEK','kr'),('Switzerland','Francs','CHF','CHF'),('Suriname','Dollars','SRD','$'),('Syria','Pounds','SYP','£'),('Taiwan','New Dollars','TWD','NT$'),('Thailand','Baht','THB','฿'),('Trinidad and Tobago','Dollars','TTD','TT$'),('Turkey','Lira','TRY','TL'),('Turkey','Liras','TRL','£'),('Tuvalu','Dollars','TVD','$'),('Ukraine','Hryvnia','UAH','₴'),('United Kingdom','Pounds','GBP','£'),('United States of America','Dollars','USD','$'),('Uruguay','Pesos','UYU','$U'),('Uzbekistan','Sums','UZS','лв'),('Vatican City','Euro','EUR','€'),('Venezuela','Bolivares Fuertes','VEF','Bs'),('Vietnam','Dong','VND','₫'),('Yemen','Rials','YER','﷼'),('Zimbabwe','Zimbabwe Dollars','ZWD','Z$'),('India','Rupees','INR','₹'),('United Arab Emirates','Dirham','AED','AED');

--
-- Table structure for table `customerbillinginfo`
--

CREATE TABLE `customerbillinginfo` (
  `Id` bigint NOT NULL,
  `CustomerId` bigint DEFAULT NULL,
  `FirstName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LastName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` longtext COLLATE utf8mb4_general_ci,
  `CountryId` int DEFAULT NULL,
  `CityId` int DEFAULT NULL,
  `MobileNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PostalCode` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customerbillinginfo`
--

INSERT INTO `customerbillinginfo` VALUES (1,1,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore update',1,1,'03244492569',NULL,1,0,'2024-01-29 12:31:06',0,'2024-02-04 10:09:54');

--
-- Table structure for table `customerresidancetype`
--

CREATE TABLE `customerresidancetype` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `NameUr` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customerresidancetype`
--

INSERT INTO `customerresidancetype` VALUES (1,'01','Owner House','مالک مکان',1,NULL,NULL,NULL,NULL),(2,'02','Shopkeeper','دکاندار',1,NULL,NULL,NULL,NULL),(3,'02','Mortgage','گروی',1,NULL,NULL,NULL,NULL),(4,'04','Tenant','کرایے دار',1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customershippinginfo`
--

CREATE TABLE `customershippinginfo` (
  `Id` bigint NOT NULL,
  `CustomerId` bigint DEFAULT NULL,
  `FirstName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LastName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` longtext COLLATE utf8mb4_general_ci,
  `CountryId` int DEFAULT NULL,
  `CityId` int DEFAULT NULL,
  `MobileNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PostalCode` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customershippinginfo`
--

INSERT INTO `customershippinginfo` VALUES (1,1,'Nabeel','343434','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,1,'03244492569','54600 update',1,0,'2024-01-29 12:31:06',0,'2024-02-04 10:09:54');

--
-- Table structure for table `customerwishlist`
--

CREATE TABLE `customerwishlist` (
  `Id` bigint NOT NULL,
  `CustomerId` bigint DEFAULT NULL,
  `ProductId` bigint DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customerwishlist`
--

INSERT INTO `customerwishlist` VALUES (3,1,14,1,0,'2024-02-04 18:00:35',NULL,NULL),(4,1,13,1,0,'2024-02-15 12:53:34',NULL,NULL);

--
-- Table structure for table `emailtemplate`
--

CREATE TABLE `emailtemplate` (
  `id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emailtemplate`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `findus`
--

CREATE TABLE `findus` (
  `Id` int unsigned NOT NULL,
  `StoreName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `StoreAddress` text COLLATE utf8mb4_unicode_ci,
  `PictureOne` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PictureTwo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PictureThree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PictureFour` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PictureFive` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `LatVal` double NOT NULL DEFAULT '0',
  `LongVal` double NOT NULL DEFAULT '0',
  `CityId` int NOT NULL DEFAULT '0',
  `AreaId` int NOT NULL DEFAULT '0',
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `findus`
--

INSERT INTO `findus` VALUES (1,'dsfds','sdfd','NoImage','NoImage','NoImage','NoImage','NoImage',4543,3454,1,1,1,'2023-12-21 07:23:07',0,NULL,0,NULL,NULL),(2,'sadf','fasdf','storepicture/0202312210725191652239711955.jfif','NoImage','NoImage','NoImage','NoImage',32423,324,1,1,1,'2023-12-21 07:25:19',0,NULL,0,NULL,NULL);

--
-- Table structure for table `headerslider`
--

CREATE TABLE `headerslider` (
  `Id` int NOT NULL,
  `Title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TextOne` text COLLATE utf8mb4_general_ci,
  `TextTwo` text COLLATE utf8mb4_general_ci,
  `TextThree` text COLLATE utf8mb4_general_ci,
  `RedirectLink` text COLLATE utf8mb4_general_ci,
  `Picture` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT '1',
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModififedBy` int DEFAULT NULL,
  `ModififedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `headerslider`
--


--
-- Table structure for table `logofviconsetting`
--

CREATE TABLE `logofviconsetting` (
  `Id` int NOT NULL,
  `Logo` text COLLATE utf8mb4_general_ci,
  `FVIcon` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `logofviconsetting`
--

INSERT INTO `logofviconsetting` VALUES (1,'logofviconpicture/020240221171136shoplixlogo.png','logofviconpicture/020240225105108shoplixlogo.png',1,0,'2024-02-25 10:51:08',NULL,NULL);

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2023_09_20_143010_create_category_table',1),(6,'2023_09_20_143023_create_area_table',1),(7,'2023_09_20_143031_create_attribute_table',1),(8,'2023_09_20_143037_create_brand_table',1),(9,'2023_09_20_143043_create_city_table',1),(10,'2023_09_20_143051_create_country_table',1),(11,'2023_09_20_143102_create_customer_table',1),(12,'2023_09_20_143113_create_emailconfig_table',1),(13,'2023_09_20_143128_create_emailtemplate_table',1),(14,'2023_09_20_143138_create_order_table',1),(15,'2023_09_20_143143_create_orderdetail_table',1),(16,'2023_09_20_143152_create_orderstatus_table',1),(17,'2023_09_20_143159_create_orderstype_table',1),(18,'2023_09_20_143213_create_pages_table',1),(19,'2023_09_20_143220_create_product_table',1),(20,'2023_09_20_143225_create_productreview_table',1),(21,'2023_09_20_143233_create_productreport_table',1),(22,'2023_09_20_143246_create_returpolicy_table',1),(23,'2023_09_20_143254_create_shipping_table',1),(24,'2023_09_20_143300_create_state_table',1),(25,'2023_09_20_143305_create_tax_table',1),(26,'2023_09_20_143312_create_users_table',2),(27,'2023_09_20_143319_create_usertype_table',2),(28,'2023_09_25_142210_create_productattribute_table',3),(29,'2023_09_25_144158_create_seller_table',4),(30,'2023_10_13_103811_create_coupon_table',5),(31,'2023_10_13_104931_create_blogcategory_table',6),(32,'2023_10_13_104953_create_blog_table',6),(33,'2023_12_11_140055_create_admin_user_table',6),(34,'2023_12_19_111337_create_findus_table',7),(35,'2023_12_21_091943_create_unit_table',8),(36,'2023_12_21_122955_create_contactus_table',9),(37,'2023_12_21_143831_create_contactusreply_table',10),(38,'2023_12_24_085834_create_socialmedialinks_table',11),(39,'2024_01_03_123645_create_campaign_table',12),(40,'2024_01_03_124443_create_campaignproduct_table',13);

--
-- Table structure for table `orderbillinginfo`
--

CREATE TABLE `orderbillinginfo` (
  `Id` bigint NOT NULL,
  `OrderId` bigint DEFAULT NULL,
  `FirstName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LastName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` longtext COLLATE utf8mb4_general_ci,
  `CountryId` int DEFAULT NULL,
  `CityId` int DEFAULT NULL,
  `MobileNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PostalCode` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orderbillinginfo`
--

INSERT INTO `orderbillinginfo` VALUES (1,3,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,-1,'03244492569','54600',1,0,'2024-01-29 12:46:26',NULL,NULL),(2,4,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,1,'03244492569','54600',1,0,'2024-01-29 14:30:43',NULL,NULL),(3,5,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,1,'03244492569','54600',1,0,'2024-01-31 07:36:38',NULL,NULL),(4,6,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,1,'03244492569','54600',1,0,'2024-01-31 07:36:38',NULL,NULL);

--
-- Table structure for table `orderdetail`
--

CREATE TABLE `orderdetail` (
  `Id` bigint unsigned NOT NULL,
  `OrderId` bigint DEFAULT NULL,
  `ProductId` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `AttributeValue` longtext COLLATE utf8mb4_unicode_ci,
  `Price` double DEFAULT NULL,
  `Quantity` double DEFAULT NULL,
  `SubTotal` double DEFAULT NULL,
  `Discount` double DEFAULT NULL,
  `Tax` double DEFAULT '0',
  `NetAmount` double DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orderdetail`
--

INSERT INTO `orderdetail` VALUES (1,1,14,NULL,NULL,'None',69,1,69,0,0,69),(2,2,14,NULL,NULL,'None',69,1,69,0,0,69),(3,3,14,NULL,NULL,'None',69,2,138,0,0,138),(4,3,13,NULL,NULL,'None',184.5,1,184.5,0,0,184.5),(5,4,14,NULL,NULL,'None',69,1,69,0,0,69),(6,4,13,NULL,NULL,'None',184.5,1,184.5,0,0,184.5),(7,5,14,NULL,NULL,'None',69,1,69,0,0,69),(8,6,14,NULL,NULL,'None',69,1,69,0,0,69);

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `Id` bigint NOT NULL,
  `OrderNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `OrderDate` datetime DEFAULT NULL,
  `Quantity` double DEFAULT '0',
  `GrossTotal` double DEFAULT '0',
  `TotalDiscount` double DEFAULT '0',
  `TotalTax` double DEFAULT '0',
  `NetTotal` double NOT NULL DEFAULT '0',
  `OrderStatusId` int DEFAULT '1',
  `CustomerId` int DEFAULT NULL,
  `PaymentStatus` int DEFAULT '1',
  `Status` int DEFAULT '1',
  `CreatedBy` int DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `PaymentTypeId` int DEFAULT NULL,
  `ShippingId` int DEFAULT NULL,
  `ShippingCharges` double DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ShippedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (1,'1','2024-01-29 12:29:24',1,69,0,0,1269,4,1,2,1,0,0,1,1,1200,'2024-01-29 12:29:24','2024-02-23 13:00:24',NULL),(2,'1','2024-01-29 12:31:06',1,69,0,0,1269,1,1,1,1,0,NULL,1,1,1200,'2024-01-29 12:31:06',NULL,NULL),(3,'1','2024-01-29 12:46:26',3,322.5,0,0,1522.5,2,1,1,1,0,0,1,1,1200,'2024-01-29 12:46:26','2024-02-02 12:56:01',NULL),(4,'1','2024-01-29 14:30:43',2,253.5,0,0,1453.5,4,1,2,1,0,0,1,1,1200,'2024-01-29 14:30:43','2024-02-23 13:00:01',NULL),(5,'1','2024-01-31 07:36:38',1,69,0,0,1269,3,1,1,1,0,0,1,1,1200,'2024-01-31 07:36:38','2024-02-02 12:56:34',NULL),(6,'1','2024-01-31 07:36:38',1,69,0,0,1269,1,1,1,1,0,NULL,1,1,1200,'2024-01-31 07:36:38',NULL,NULL);

--
-- Table structure for table `ordershippinginfo`
--

CREATE TABLE `ordershippinginfo` (
  `Id` bigint NOT NULL,
  `OrderId` bigint DEFAULT NULL,
  `FirstName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LastName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` longtext COLLATE utf8mb4_general_ci,
  `CountryId` int DEFAULT NULL,
  `CityId` int DEFAULT NULL,
  `MobileNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PostalCode` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ordershippinginfo`
--

INSERT INTO `ordershippinginfo` VALUES (1,3,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,-1,'03244492569','54600',1,0,'2024-01-29 12:46:26',NULL,NULL),(2,4,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,1,'03244492569','54600',1,0,'2024-01-29 14:30:43',NULL,NULL),(3,5,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,1,'03244492569','54600',1,0,'2024-01-31 07:36:38',NULL,NULL),(4,6,'Nabeel','Ezad','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore',1,1,'03244492569','54600',1,0,'2024-01-31 07:36:38',NULL,NULL);

--
-- Table structure for table `orderstatus`
--

CREATE TABLE `orderstatus` (
  `Id` int unsigned NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orderstatus`
--

INSERT INTO `orderstatus` VALUES (1,'01','Pending',1,'2023-09-26 10:40:18',0,'2023-09-26 10:40:36',0,NULL,NULL),(2,'02','Progress',1,'2023-09-26 10:40:46',0,'2024-01-03 11:14:11',0,NULL,NULL),(3,'03','Delivered',1,'2024-01-03 11:14:32',0,NULL,0,NULL,NULL),(4,'04','Completed',1,'2024-01-03 11:14:44',0,NULL,0,NULL,NULL),(5,'05','Declined',1,'2024-01-03 11:15:14',0,NULL,0,NULL,NULL);

--
-- Table structure for table `orderstype`
--

CREATE TABLE `orderstype` (
  `Id` int unsigned NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orderstype`
--

INSERT INTO `orderstype` VALUES (1,'01','Pending',1,'2023-09-26 09:25:41',0,'2023-09-26 09:26:52',0,NULL,NULL),(3,'45','Test',1,'2024-01-06 05:25:10',0,NULL,0,NULL,NULL),(4,'035','Stripe',1,'2024-03-06 19:34:40',0,'2024-03-06 19:40:41',0,NULL,NULL);

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `Id` int unsigned NOT NULL,
  `Title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `Banner` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `Description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--


--
-- Table structure for table `paymentstatus`
--

CREATE TABLE `paymentstatus` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `paymentstatus`
--

INSERT INTO `paymentstatus` VALUES (1,'01','Pending',1,NULL,NULL,NULL,NULL),(2,'02','Paid',1,NULL,NULL,NULL,NULL),(3,'03','Refund',1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `paymenttype`
--

CREATE TABLE `paymenttype` (
  `Id` int NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT '1',
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `paymenttype`
--

INSERT INTO `paymenttype` VALUES (1,'01','Cash on Delivery',1,1,NULL,NULL,NULL),(2,'02','Bank Transfer',1,1,NULL,NULL,NULL),(4,'03','Stripe',1,0,'2024-03-09 19:20:00',NULL,NULL);

--
-- Table structure for table `placeofsupply`
--

CREATE TABLE `placeofsupply` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(45) DEFAULT NULL,
  `Name` text,
  `Description` text,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `placeofsupply`
--

INSERT INTO `placeofsupply` VALUES (1,'01','UAE','UAE',1,1,NULL,NULL,NULL),(2,'01','UAE','UAE',0,1,NULL,NULL,NULL);

--
-- Table structure for table `possetting`
--

CREATE TABLE `possetting` (
  `id` int NOT NULL,
  `Lang` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Logo` text COLLATE utf8mb4_general_ci,
  `ShopName` text COLLATE utf8mb4_general_ci,
  `Address` text COLLATE utf8mb4_general_ci,
  `PhoneNo` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PhoneNoTwo` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `EmailAddress` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `possetting`
--


--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `Id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `Thumbnai` text COLLATE utf8mb4_unicode_ci,
  `BannerImage` text COLLATE utf8mb4_unicode_ci,
  `ShorName` text COLLATE utf8mb4_unicode_ci,
  `Name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slug` text COLLATE utf8mb4_unicode_ci,
  `CategoryId` int DEFAULT NULL,
  `SubCategoryId` int DEFAULT NULL,
  `ChildCategoryId` int DEFAULT NULL,
  `BrandId` int DEFAULT NULL,
  `PurchasePrice` decimal(10,2) DEFAULT '0.00',
  `SalePrice` decimal(10,2) DEFAULT '0.00',
  `StockQty` double(10,2) DEFAULT '0.00',
  `VideoLink` text COLLATE utf8mb4_unicode_ci,
  `ShortDescription` longtext COLLATE utf8mb4_unicode_ci,
  `LongDescription` longtext COLLATE utf8mb4_unicode_ci,
  `Tags` text COLLATE utf8mb4_unicode_ci,
  `Returnable` int NOT NULL DEFAULT '0',
  `Warranty` int NOT NULL DEFAULT '0',
  `Status` int NOT NULL DEFAULT '1',
  `SEOTitle` text COLLATE utf8mb4_unicode_ci,
  `SeoDescription` longtext COLLATE utf8mb4_unicode_ci,
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `SellerId` int DEFAULT NULL,
  `TaxId` int DEFAULT NULL,
  `TaxRate` float DEFAULT '0',
  `TaxValue` double DEFAULT '0',
  `SKU` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Featured` int NOT NULL DEFAULT '0',
  `UnitId` int DEFAULT NULL,
  `WholeSalePrice` double DEFAULT '0',
  `ExpireyDate` date DEFAULT NULL,
  `MinStockValue` double DEFAULT '0',
  `NameUr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BarCode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ProductTypeId` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product`
--

INSERT INTO `product` VALUES (20,NULL,NULL,NULL,'Motor Bike',NULL,5,13,0,1,0.00,170000.00,4.00,NULL,NULL,NULL,NULL,0,0,1,NULL,NULL,'2024-06-27 11:43:31',0,NULL,0,NULL,NULL,0,NULL,0,0,'PR-0000019',0,1,170000,'2024-04-27',2,NULL,NULL,NULL),(21,NULL,NULL,NULL,'Samsung Mobile-1223',NULL,1,19,0,1,50000.00,55000.00,5.00,NULL,NULL,NULL,NULL,0,1,1,NULL,NULL,'2024-06-27 06:07:40',0,NULL,0,NULL,NULL,1,2,0,2750,'PR-0000020',0,1,55000,NULL,2,'سام سنگددفدف','PR-0000020e3',NULL),(22,NULL,NULL,NULL,'New Pro',NULL,1,12,0,1,100.00,150.00,25.00,NULL,NULL,NULL,NULL,0,0,1,NULL,NULL,'2024-06-24 05:51:46',0,NULL,0,NULL,NULL,1,2,0,0,'PR-0000022',0,1,150,'2024-06-23',100,'نبسدف','PR-0000022',4),(23,NULL,NULL,NULL,'dgdfg',NULL,1,12,NULL,1,78.00,89.00,67.00,NULL,NULL,'afd',NULL,1,2,1,NULL,NULL,'2024-06-24 05:51:02',0,NULL,0,NULL,NULL,1,2,0,67,'PR-0000023',0,1,89,'2024-06-24',45,NULL,'PR-0000023',4),(24,NULL,NULL,NULL,'afds',NULL,1,12,0,1,1.20,23.00,45.00,NULL,NULL,NULL,NULL,0,0,1,NULL,NULL,'2024-06-27 05:14:38',0,NULL,0,NULL,NULL,1,NULL,0,0,'PR-0000024',0,1,0,NULL,34,'اسف','PR-0000024',3),(25,NULL,NULL,NULL,'vcbcv',NULL,1,12,NULL,1,1.10,23.45,76.00,NULL,NULL,NULL,NULL,2,2,1,NULL,NULL,'2024-06-27 06:07:10',1,NULL,0,NULL,NULL,1,2,0,1.17,'PR-0000025',0,1,4506.7878,NULL,454,'بچطب','PR-0000025',1),(26,NULL,NULL,NULL,'dfgdfg',NULL,1,18,NULL,1,54.00,34.00,54.00,NULL,NULL,NULL,NULL,2,2,1,NULL,NULL,'2024-06-27 07:37:48',1,NULL,0,NULL,NULL,1,2,0,1.7,'PR-0000026',0,1,34,NULL,4,'دسفدسف','PR-0000026',0),(27,NULL,NULL,NULL,'test8',NULL,1,12,NULL,0,56.00,67.00,556.00,NULL,NULL,NULL,NULL,2,2,1,NULL,NULL,'2024-06-27 08:06:25',1,NULL,0,NULL,NULL,0,NULL,0,0,'PR-0000027',0,0,0,NULL,NULL,NULL,'PR-0000027',0),(28,NULL,NULL,NULL,'dsff',NULL,1,12,NULL,1,45.00,45.00,34.00,NULL,NULL,NULL,NULL,2,2,1,NULL,NULL,'2024-06-27 11:40:53',1,NULL,0,NULL,NULL,0,2,0,445,'PR-0000028',0,0,0,NULL,NULL,'سدفدسف','PR-0000028',0),(29,NULL,NULL,NULL,'dsff',NULL,1,12,NULL,1,45.00,45.00,34.00,NULL,NULL,NULL,NULL,2,2,1,NULL,NULL,'2024-06-27 11:42:11',1,NULL,0,NULL,NULL,0,2,0,445,'PR-0000028',0,0,0,NULL,NULL,'سدفدسف','PR-0000028',0);

--
-- Table structure for table `productattribute`
--

CREATE TABLE `productattribute` (
  `Id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ProductId` int NOT NULL,
  `AttributeId` int NOT NULL,
  `AttributeValue` text COLLATE utf8mb4_unicode_ci,
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ShonOnDetail` smallint NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `productattribute`
--

INSERT INTO `productattribute` VALUES (4,6,3,'test','2023-11-06 14:31:56',0,NULL,0,NULL,NULL,0),(51,13,1,'Yellow','2024-01-28 08:25:39',0,NULL,0,NULL,NULL,1),(52,13,1,'Brown','2024-01-28 08:25:39',0,NULL,0,NULL,NULL,1),(53,13,5,'Small','2024-01-28 08:25:39',0,NULL,0,NULL,NULL,1),(54,13,5,'Large','2024-01-28 08:25:39',0,NULL,0,NULL,NULL,1),(55,13,4,'40','2024-01-28 08:25:39',0,NULL,0,NULL,NULL,0),(56,13,1,'Black','2024-01-28 08:25:39',0,NULL,0,NULL,NULL,1),(57,14,1,'Green','2024-01-28 08:28:28',0,NULL,0,NULL,NULL,0),(58,14,1,'Pink','2024-01-28 08:28:28',0,NULL,0,NULL,NULL,0),(59,14,5,'Small','2024-01-28 08:28:28',0,NULL,0,NULL,NULL,0),(60,14,5,'Large','2024-01-28 08:28:28',0,NULL,0,NULL,NULL,0),(61,14,1,'Black','2024-01-28 08:28:28',0,NULL,0,NULL,NULL,1),(62,19,6,'43545','2024-03-18 07:44:38',0,NULL,0,NULL,NULL,1),(63,19,3,'454','2024-03-18 07:44:38',0,NULL,0,NULL,NULL,1),(68,23,3,'dfg','2024-06-24 05:51:02',0,NULL,0,NULL,NULL,0),(69,23,7,'4353','2024-06-24 05:51:02',0,NULL,0,NULL,NULL,0),(70,22,6,'435','2024-06-24 05:51:46',0,NULL,0,NULL,NULL,0),(71,22,7,'4564','2024-06-24 05:51:46',0,NULL,0,NULL,NULL,0),(73,21,1,'Blue','2024-06-27 06:07:40',0,NULL,0,NULL,NULL,0),(74,26,5,'23443','2024-06-27 07:37:48',1,NULL,0,NULL,NULL,0),(75,26,7,'3454','2024-06-27 07:37:48',1,NULL,0,NULL,NULL,0),(76,20,1,'Red','2024-06-27 11:43:31',0,NULL,0,NULL,NULL,0);

--
-- Table structure for table `productpicture`
--

CREATE TABLE `productpicture` (
  `Id` bigint NOT NULL,
  `ProductId` bigint NOT NULL,
  `PictureThumbPath` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `PicturePath` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `Status` int NOT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `productpicture`
--

INSERT INTO `productpicture` VALUES (1,13,'productmoreimage/020240123115425dress_green_5.jpg','productmoreimage/020240123115425dress_green_5.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(2,13,'productmoreimage/020240123115425dress_green_6.jpg','productmoreimage/020240123115425dress_green_6.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(3,13,'productmoreimage/020240123115425dress_green_7.jpg','productmoreimage/020240123115425dress_green_7.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(4,13,'productmoreimage/020240123115425dress_green_8.jpg','productmoreimage/020240123115425dress_green_8.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(5,13,'productmoreimage/020240123115425dress_green_9.jpg','productmoreimage/020240123115425dress_green_9.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(6,13,'productmoreimage/020240123115425dress_green_10.jpg','productmoreimage/020240123115425dress_green_10.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(7,13,'productmoreimage/020240123115425dress_green_11.jpg','productmoreimage/020240123115425dress_green_11.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(8,13,'productmoreimage/020240123115425dress_green_12.jpg','productmoreimage/020240123115425dress_green_12.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(9,13,'productmoreimage/020240123115425dress_green_13.jpg','productmoreimage/020240123115425dress_green_13.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(10,13,'productmoreimage/020240123115425dress_green_14.jpg','productmoreimage/020240123115425dress_green_14.jpg',1,0,'2024-01-23 11:54:25',NULL,NULL),(11,14,'productmoreimage/020240125132436dress_green_7.jpg','productmoreimage/020240125132436dress_green_7.jpg',1,0,'2024-01-25 13:24:36',NULL,NULL),(12,14,'productmoreimage/020240125132436dress_green_8.jpg','productmoreimage/020240125132436dress_green_8.jpg',1,0,'2024-01-25 13:24:36',NULL,NULL),(13,14,'productmoreimage/020240125132436dress_green_9.jpg','productmoreimage/020240125132436dress_green_9.jpg',1,0,'2024-01-25 13:24:36',NULL,NULL),(14,14,'productmoreimage/020240125132436dress_green_10.jpg','productmoreimage/020240125132436dress_green_10.jpg',1,0,'2024-01-25 13:24:36',NULL,NULL),(15,14,'productmoreimage/020240125132436dress_green_11.jpg','productmoreimage/020240125132436dress_green_11.jpg',1,0,'2024-01-25 13:24:36',NULL,NULL);

--
-- Table structure for table `productrating`
--

CREATE TABLE `productrating` (
  `Id` bigint NOT NULL,
  `ProductId` bigint NOT NULL,
  `Rating` float NOT NULL DEFAULT '0',
  `CustomerId` int NOT NULL,
  `IPAddress` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT '1',
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModififedBy` int DEFAULT NULL,
  `ModififedDate` datetime DEFAULT NULL,
  `Comment` longtext COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `productrating`
--

INSERT INTO `productrating` VALUES (2,13,5,0,NULL,1,NULL,NULL,NULL,NULL,NULL),(3,13,5,0,NULL,1,NULL,NULL,NULL,NULL,NULL),(4,13,1,0,NULL,1,NULL,NULL,NULL,NULL,NULL),(5,13,0,0,NULL,1,NULL,NULL,NULL,NULL,NULL),(6,13,4,0,NULL,1,1,NULL,NULL,NULL,NULL),(8,13,3,0,NULL,1,NULL,NULL,NULL,NULL,NULL),(9,13,3,0,NULL,1,NULL,NULL,NULL,NULL,NULL),(10,13,4,0,NULL,1,NULL,NULL,NULL,NULL,NULL),(11,13,4,0,NULL,1,NULL,NULL,NULL,NULL,NULL),(12,13,3,1,'1.1.1.1',1,0,'2024-01-25 11:37:10',0,'2024-01-25 12:59:44','sdfdsf'),(13,13,5,1,'127.0.0.1',1,0,'2024-01-25 11:41:00',0,'2024-01-25 12:49:47','Test Update'),(14,13,2,1,'127.0.0.1',1,0,'2024-01-25 13:04:58',0,'2024-01-25 13:05:21','fhghfg'),(15,13,4,1,'127.0.0.1',1,0,'2024-01-28 08:26:46',0,'2024-01-28 08:27:11','test review update test');

--
-- Table structure for table `productreport`
--

CREATE TABLE `productreport` (
  `id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `productreport`
--


--
-- Table structure for table `productype`
--

CREATE TABLE `productype` (
  `Id` int unsigned NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `NameUr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `productype`
--

INSERT INTO `productype` VALUES (1,'up','دفدسفد','سام سنگ',1,'2024-03-17 15:20:51',0,'2024-04-26 15:35:04',0,NULL,NULL),(3,'34','sdfd',NULL,1,'2024-04-26 15:30:13',0,NULL,0,NULL,NULL),(4,'PT-0000004','Finished Goods',NULL,1,'2024-06-12 13:07:49',0,NULL,0,NULL,NULL);

--
-- Table structure for table `returpolicy`
--

CREATE TABLE `returpolicy` (
  `Id` int unsigned NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_unicode_ci,
  `Status` int NOT NULL DEFAULT '1',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `returpolicy`
--

INSERT INTO `returpolicy` VALUES (1,'Title of return policy','Desc',1,'2024-01-03 11:35:35',0,NULL,NULL,NULL,NULL),(4,'sdf','sdfsf',1,'2024-01-06 05:26:09',0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `sec_forms`
--

CREATE TABLE `sec_forms` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `FormName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_general_ci,
  `Status` int DEFAULT NULL,
  `ModuleId` int DEFAULT NULL,
  `LeftMenu` int DEFAULT NULL,
  `FormTitle` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `OrderNo` float DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sec_forms`
--

INSERT INTO `sec_forms` VALUES (1,'employee','Employee',1,1,1,'Employee',1,NULL,NULL,NULL,NULL),(2,'category','Category',1,2,1,'Category',1,NULL,NULL,NULL,NULL),(3,'brand','Brand',1,2,1,'Brand',2,NULL,NULL,1,'2024-06-11 13:00:59'),(4,'unit','Unit',1,2,1,'Unit',3,NULL,NULL,1,'2024-06-11 13:01:08'),(5,'attribute','Attribute',1,2,1,'Attribute',4,1,NULL,1,'2024-06-11 13:01:24'),(6,'creditcustomer','creditcustomer',1,2,1,'Credit Customer',5,1,NULL,NULL,NULL),(7,'forms','Forms',1,6,1,'Forms',1,1,NULL,NULL,NULL),(8,'roles','Role',1,6,1,'Role',2,1,NULL,NULL,NULL),(9,'customerpayment','Customer Payment up',1,3,1,'Customer Payment',1,1,'2024-06-11 12:27:42',1,'2024-06-11 12:59:50'),(10,'vendorpayment','Vendor Payment',1,3,1,'Vendor Payment',2,1,'2024-06-11 13:00:39',NULL,NULL),(11,'vendor','Vendor',1,2,1,'Vendor',7,1,'2024-06-11 13:15:27',NULL,NULL),(12,'product','Product',1,2,1,'Product',3,1,'2024-06-11 13:16:09',1,'2024-06-12 10:43:42'),(13,'paymenttype','paymenttype',1,2,1,'Payment Method',7,1,'2024-06-12 11:07:40',NULL,NULL),(14,'grn','Goods Receiving Notes',1,2,1,'Goods Receiving Notes',8,1,'2024-06-12 11:09:20',NULL,NULL),(15,'stockadjust','Stock Adjustment',1,2,1,'Stock Adjustment',9,1,'2024-06-12 11:09:45',NULL,NULL),(16,'purchaseorder','Purchase Order',1,2,1,'Purchase Order',11,1,'2024-06-12 11:10:12',NULL,NULL),(17,'producttype','Product Type',1,2,1,'Product Type',10,1,'2024-06-12 11:25:17',NULL,NULL),(18,'storeexpense','Expense Type',1,5,1,'Expense Type',1,1,'2024-06-12 11:30:28',NULL,NULL),(19,'dailystoreexpense','Daily Store Expense',1,5,1,'Daily Store Expense',2,1,'2024-06-12 11:30:52',NULL,NULL),(20,'possetting','POS Setting',1,4,1,'POS Setting',1,1,'2024-06-13 06:40:35',NULL,NULL),(21,'saleorder','Cash Sale',1,5,1,'Customer Invoice',1,1,'2024-06-13 06:43:34',1,'2024-07-03 09:34:44'),(22,'posreport','POS Reports',1,5,1,'Reports',5,1,'2024-06-13 06:50:31',NULL,NULL),(23,'performainvoice','Performa Invoice',1,5,1,'Performa Invoice',6,1,'2024-06-13 06:54:57',NULL,NULL),(24,'creditsale','Credit Sale',1,5,1,'Credit Sale',8,1,'2024-06-13 06:55:20',NULL,NULL),(25,'returnsale','Return Sale',1,5,1,'Return Sale',8,1,'2024-06-13 06:55:44',NULL,NULL),(26,'users','Users',1,6,1,'Users',1,1,'2024-06-13 06:58:27',NULL,NULL),(27,'branch','Branch',1,4,1,'Branch',2,1,'2024-06-13 10:05:16',NULL,NULL),(28,'performainvoice','Performa Invoice',1,5,1,'Performa Invoice',10,1,'2024-06-13 11:11:03',1,'2024-06-13 11:11:24'),(29,'tax','Tax Rate',1,4,1,'Tax Rate',5,1,'2024-06-21 06:21:28',NULL,NULL),(30,'deliveryorder','Delivery Order',1,5,1,'Delivery Order',10,1,'2024-06-21 09:16:27',NULL,NULL),(31,'outwardgatepass','Outward Gate Pass',1,2,1,'Outward Gate Pass',10,1,'2024-07-25 06:05:55',NULL,NULL),(32,'vehicle','Vehicle Management',1,4,1,'Vehicle Management',1,1,'2024-07-26 11:40:40',NULL,NULL),(33,'inwardgatepass','Inward Gate Pass',1,2,1,'Inward Gate Pass',10,1,'2024-08-07 07:55:53',NULL,NULL);

--
-- Table structure for table `sec_module`
--

CREATE TABLE `sec_module` (
  `Id` int NOT NULL,
  `ModuleName` varchar(255) DEFAULT NULL,
  `Description` text,
  `Status` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sec_module`
--

INSERT INTO `sec_module` VALUES (1,'HIRS','HRIS',1),(2,'INVENTORY','INVENTORY',1),(3,'ACCOUNTS','ACCOUNTS',1),(4,'SETTINGS','SETTINGS	',0),(5,'POINT OF SALE','POINT OF SALE',NULL),(6,'SECURITY','SECURITY',1);

--
-- Table structure for table `sec_zone`
--

CREATE TABLE `sec_zone` (
  `Id` int NOT NULL,
  `ZoneName` varchar(255) DEFAULT NULL,
  `Description` text,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sec_zone`
--

INSERT INTO `sec_zone` VALUES (1,'admin','adminsdfsdfsd',1,NULL,NULL,1,'2024-08-07 07:56:14'),(3,'Pos',NULL,1,1,'2024-06-13 09:00:29',1,'2024-06-13 11:12:16');

--
-- Table structure for table `sec_zone_gate`
--

CREATE TABLE `sec_zone_gate` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `FormId` int DEFAULT NULL,
  `ZoneId` int DEFAULT NULL,
  `AddRight` tinyint(1) DEFAULT NULL,
  `EditRight` tinyint(1) DEFAULT NULL,
  `DeleteRight` tinyint(1) DEFAULT NULL,
  `ViewRight` tinyint(1) DEFAULT NULL,
  `PrintRight` tinyint(1) DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=536 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sec_zone_gate`
--

INSERT INTO `sec_zone_gate` VALUES (353,1,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(354,2,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(355,3,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(356,4,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(357,5,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(358,6,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(359,7,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(360,8,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(361,9,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(362,10,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(363,11,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(364,12,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(365,13,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(366,14,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(367,15,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(368,16,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(369,17,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(370,18,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(371,19,3,1,1,1,1,1,1,1,'2024-06-13 11:12:16',NULL,NULL),(372,20,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(373,21,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(374,22,3,1,1,1,1,1,1,1,'2024-06-13 11:12:16',NULL,NULL),(375,23,3,1,1,1,1,1,1,1,'2024-06-13 11:12:16',NULL,NULL),(376,24,3,1,1,1,1,1,1,1,'2024-06-13 11:12:16',NULL,NULL),(377,25,3,1,1,1,1,1,1,1,'2024-06-13 11:12:16',NULL,NULL),(378,26,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(379,27,3,0,0,0,0,0,1,1,'2024-06-13 11:12:16',NULL,NULL),(380,28,3,1,1,1,1,1,1,1,'2024-06-13 11:12:16',NULL,NULL),(503,1,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(504,2,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(505,3,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(506,4,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(507,5,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(508,6,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(509,7,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(510,8,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(511,9,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(512,10,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(513,11,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(514,12,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(515,13,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(516,14,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(517,15,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(518,16,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(519,17,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(520,18,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(521,19,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(522,20,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(523,21,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(524,22,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(525,23,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(526,24,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(527,25,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(528,26,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(529,27,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(530,28,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(531,29,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(532,30,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(533,31,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(534,32,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL),(535,33,1,1,1,1,1,1,1,1,'2024-08-07 07:56:14',NULL,NULL);

--
-- Table structure for table `seller`
--

CREATE TABLE `seller` (
  `Id` bigint unsigned NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `PhoneNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MobileNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `EmailAddress` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Address` text COLLATE utf8mb4_unicode_ci,
  `Picture` text COLLATE utf8mb4_unicode_ci,
  `ZipCode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CountryId` int DEFAULT NULL,
  `StateId` int DEFAULT NULL,
  `CityId` int DEFAULT NULL,
  `Status` int NOT NULL DEFAULT '0',
  `ShopStatus` int NOT NULL DEFAULT '0',
  `UserStatus` int NOT NULL DEFAULT '0',
  `RegisterDate` datetime DEFAULT NULL,
  `OpeningBalance` double NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seller`
--

INSERT INTO `seller` VALUES (1,'nab',NULL,'03245454','nabeel@gmail.com','asfdsd','','343',1,1,1,1,1,1,'2023-10-09 11:06:46',343,'2023-10-09 11:06:46',0,NULL,0,NULL,NULL);

--
-- Table structure for table `shipping`
--

CREATE TABLE `shipping` (
  `Id` int unsigned NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ShippingCost` double NOT NULL DEFAULT '0',
  `Description` text COLLATE utf8mb4_unicode_ci,
  `Status` int NOT NULL DEFAULT '1',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping`
--

INSERT INTO `shipping` VALUES (1,'Free Shipping',1200,'Free Shipping',1,'2024-01-03 11:26:32',0,'2024-01-27 15:06:52',0,NULL,NULL),(2,'Outside City',120,'Outside City',1,'2024-01-06 05:32:28',0,'2024-01-27 15:07:24',0,NULL,NULL),(3,'Inside City',60,'Inside City',1,'2024-01-27 15:07:51',0,NULL,0,NULL,NULL);

--
-- Table structure for table `socialmedialinks`
--

CREATE TABLE `socialmedialinks` (
  `Id` int unsigned NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `SocialMediaUrl` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `IconOne` text COLLATE utf8mb4_unicode_ci,
  `IconTwo` text COLLATE utf8mb4_unicode_ci,
  `Description` text COLLATE utf8mb4_unicode_ci,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `socialmedialinks`
--

INSERT INTO `socialmedialinks` VALUES (1,'dsfd update','sdfdsf','ds','sdf','sdfds',1,'2023-12-24 18:44:12',0,'2023-12-24 18:57:37',0,NULL,NULL);

--
-- Table structure for table `state`
--

CREATE TABLE `state` (
  `Id` int unsigned NOT NULL,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `CountryId` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `state`
--

INSERT INTO `state` VALUES (1,'01up','Punjab',1,'2023-10-02 12:06:01',0,'2023-10-02 12:17:21',0,1,NULL,NULL),(3,'02','KPK',1,'2023-10-02 13:44:14',0,NULL,0,1,NULL,NULL);

--
-- Table structure for table `tax`
--

CREATE TABLE `tax` (
  `Id` int unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TaxRate` float NOT NULL DEFAULT '0',
  `Description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` int NOT NULL DEFAULT '1',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tax`
--

INSERT INTO `tax` VALUES (1,'16Per',16,'update',0,'2023-10-05 11:45:20',0,'2024-06-21 06:48:46',0,NULL,NULL),(2,'Domestic Taxable Supplies @ 5%',5,'Domestic Taxable Supplies @ 5%',1,'2024-06-21 06:41:50',0,'2024-06-21 06:48:39',0,NULL,NULL);

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

CREATE TABLE `unit` (
  `Id` int unsigned NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `NameUr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_unicode_ci,
  `Picture` text COLLATE utf8mb4_unicode_ci,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `unit` VALUES (1,'01','Pcs',NULL,NULL,NULL,NULL,1,'2024-01-03 07:44:28',0,NULL,0,NULL,NULL),(2,'02','کلو گرم',NULL,NULL,NULL,NULL,1,'2024-03-09 07:24:23',0,'2024-03-17 13:08:40',0,NULL,NULL),(4,'34','Kilo Gram up','کلو گرام اوپر',NULL,NULL,NULL,1,'2024-04-26 15:25:04',0,'2024-04-26 15:25:27',0,NULL,NULL);

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

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `usertype`
--

CREATE TABLE `usertype` (
  `Id` int unsigned NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` smallint NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `CreatedBy` int NOT NULL DEFAULT '0',
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `usertype`
--

INSERT INTO `usertype` VALUES (1,'Standard','Standard',1,'2023-10-05 10:48:17',0,'2023-10-05 10:51:33',0,NULL,NULL);

--
-- Table structure for table `websitegeneralsetting`
--

CREATE TABLE `websitegeneralsetting` (
  `Id` int NOT NULL,
  `MainTitle` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ContactEmailAddress` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `InfoEmailAddress` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DefaultCurrency` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CurrencyIcon` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TimeZone` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MobileNumber` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `WhatsAppNumber` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LandlineNumber` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` text COLLATE utf8mb4_general_ci,
  `MondayToFridayTiming` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `SaturdayTiming` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `SundayTiming` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `CreatedBy` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT NULL,
  `MainText` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `websitegeneralsetting`
--

INSERT INTO `websitegeneralsetting` VALUES (1,'fdfg','nabeel.ezad@gmail.com','nabeel.ezad@gmail.com','PKR','RS.','usd','03244492569','3343434','6767674354','House No 22 Nargis Street Taj Bagh Housing Scheme Lahore Billing','435','435565','5656',1,0,'2024-02-25 10:47:32',NULL,NULL,'Fashion'),(2,'fdfg','nabeel.ezad@gmail.com','nabeel.ezad@gmail.com','usd','$','usd','03244492569',NULL,NULL,'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore Billing',NULL,NULL,NULL,1,0,'2024-02-07 14:17:56',NULL,NULL,NULL),(3,'fdfg','nabeel.ezad@gmail.com','nabeel.ezad@gmail.com','usd','$','usd','03244492569',NULL,NULL,'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore Billing',NULL,NULL,NULL,1,0,'2024-02-07 14:19:00',NULL,NULL,NULL),(4,'fdfg','nabeel.ezad@gmail.com','nabeel.ezad@gmail.com','usd','$','usd','03244492569',NULL,NULL,'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore Billing',NULL,NULL,NULL,1,0,'2024-02-07 14:20:03',NULL,NULL,NULL);




ALTER TABLE `aemposinst`.`app_inv_purchase_order` 
ADD COLUMN `ShipDate` DATE NULL AFTER `IsTaxable`,
ADD COLUMN `OrderTypeId` INT NULL AFTER `ShipDate`,
ADD COLUMN `TaxRateId` INT NULL AFTER `OrderTypeId`,
ADD COLUMN `TRNNo` VARCHAR(45) NULL AFTER `TaxRateId`,
ADD COLUMN `SNNo` VARCHAR(45) NULL AFTER `TRNNo`,
ADD COLUMN `InvoiceGenerated` INT NULL AFTER `SNNo`;


CREATE TABLE `aemposinst`.`sourceofsupply` (
  `Id` INT NOT NULL AUTO_INCREMENT,
  `Code` VARCHAR(45) NULL,
  `Name` VARCHAR(245) NULL,
  `Description` TEXT NULL,
  `Status` INT NULL,
  `CreatedBy` INT NULL,
  `CreatedDate` DATETIME NULL,
  `ModifiedBy` INT NULL,
  `ModifiedDate` DATETIME NULL,
  PRIMARY KEY (`Id`));

ALTER TABLE `aemposinst`.`app_inv_purchase_order` 
ADD COLUMN `SourceOfSupplyId` INT NULL AFTER `InvoiceGenerated`;
