-- MySQL dump 10.13 Distrib 8.0.36, for Win64 (x86_64) -- -- Host: localhost Database: aemposinst -- ------------------------------------------------------ -- Server version 8.0.37 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `admin_user` -- DROP TABLE IF EXISTS `admin_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `admin_user` ( `Id` int unsigned NOT NULL, `FirstName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `LastName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `UserPassword` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `EmailAddress` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `UserTypeId` int 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, `BranchId` int DEFAULT NULL, `ProfileId` int NOT NULL, `CompanyId` int DEFAULT NULL, `ZoneId` int DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admin_user` -- LOCK TABLES `admin_user` WRITE; /*!40000 ALTER TABLE `admin_user` DISABLE KEYS */; INSERT INTO `admin_user` VALUES (1,'admin','admin','admin','admin','admin@gmail.com',1,1,NULL,0,NULL,0,NULL,NULL,1,1,1,1); /*!40000 ALTER TABLE `admin_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_acct_account_group` -- DROP TABLE IF EXISTS `app_acct_account_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_acct_account_group` -- LOCK TABLES `app_acct_account_group` WRITE; /*!40000 ALTER TABLE `app_acct_account_group` DISABLE KEYS */; /*!40000 ALTER TABLE `app_acct_account_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_acct_chart_of_account` -- DROP TABLE IF EXISTS `app_acct_chart_of_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_acct_chart_of_account` -- LOCK TABLES `app_acct_chart_of_account` WRITE; /*!40000 ALTER TABLE `app_acct_chart_of_account` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_acct_chart_of_account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_acct_ledger_entries` -- DROP TABLE IF EXISTS `app_acct_ledger_entries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_acct_ledger_entries` -- LOCK TABLES `app_acct_ledger_entries` WRITE; /*!40000 ALTER TABLE `app_acct_ledger_entries` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_acct_ledger_entries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_acct_nature_of_account` -- DROP TABLE IF EXISTS `app_acct_nature_of_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_acct_nature_of_account` -- LOCK TABLES `app_acct_nature_of_account` WRITE; /*!40000 ALTER TABLE `app_acct_nature_of_account` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_acct_nature_of_account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_gen_setting_payment_type` -- DROP TABLE IF EXISTS `app_gen_setting_payment_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_gen_setting_payment_type` -- LOCK TABLES `app_gen_setting_payment_type` WRITE; /*!40000 ALTER TABLE `app_gen_setting_payment_type` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_gen_setting_payment_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_hr_department` -- DROP TABLE IF EXISTS `app_hr_department`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_hr_department` -- LOCK TABLES `app_hr_department` WRITE; /*!40000 ALTER TABLE `app_hr_department` DISABLE KEYS */; /*!40000 ALTER TABLE `app_hr_department` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_hr_designation` -- DROP TABLE IF EXISTS `app_hr_designation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_hr_designation` -- LOCK TABLES `app_hr_designation` WRITE; /*!40000 ALTER TABLE `app_hr_designation` DISABLE KEYS */; /*!40000 ALTER TABLE `app_hr_designation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_hr_employee_personal_information` -- DROP TABLE IF EXISTS `app_hr_employee_personal_information`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `app_hr_employee_personal_information` ( `Id` bigint NOT NULL, `FullName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `FatherName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `ControlNumber` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `PFNumber` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Address` text COLLATE utf8mb4_general_ci, `DateOfJoining` date DEFAULT NULL, `DateOfBirth` date DEFAULT NULL, `PresentAddress` text COLLATE utf8mb4_general_ci, `NationalityId` int DEFAULT NULL, `ReligionId` int DEFAULT NULL, `MartialStatus` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `EOBIPESSINo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `CNic` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `MobileNumber` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL, `PhoneNumber` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL, `EmailAddress` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `JobStatusId` int DEFAULT NULL, `EmployeeTypeId` int DEFAULT NULL, `Description` int DEFAULT NULL, `isNTN` int DEFAULT NULL, `isEOBI` int DEFAULT NULL, `isSSN` int DEFAULT NULL, `isPF` int DEFAULT NULL, `ChartOfAccountId` int DEFAULT NULL, `NTNNumber` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `SSNNumber` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `DateOfConfirmation` date DEFAULT NULL, `BloodGroup` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `NextOfKin` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `SecutityCardNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `EmergencyPhone` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Gender` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Status` int DEFAULT NULL, `CreatedBy` int DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `ModifiedBy` int DEFAULT NULL, `ModifiedDate` date DEFAULT NULL, `Picture` text COLLATE utf8mb4_general_ci, `FullNameUr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_hr_employee_personal_information` -- LOCK TABLES `app_hr_employee_personal_information` WRITE; /*!40000 ALTER TABLE `app_hr_employee_personal_information` DISABLE KEYS */; INSERT INTO `app_hr_employee_personal_information` VALUES (3,'xzcv',NULL,'EC-0000001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'zcxv','zcxv',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'2024-05-05',NULL,NULL,'None','زچشط'),(4,'xcvxvupdate',NULL,'EC-0000004',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'43543up','fdg435435',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'2024-05-05',1,'2024-05-05','employeepicture/120240505063939985px-Laravel.svg.png','شچطشطدسفدسف'); /*!40000 ALTER TABLE `app_hr_employee_personal_information` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_bank` -- DROP TABLE IF EXISTS `app_inv_bank`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `app_inv_bank` ( `Id` int NOT NULL, `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `BranchName` text COLLATE utf8mb4_general_ci, `BranchAddress` text COLLATE utf8mb4_general_ci, `AccountNo` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL, `IbanNo` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL, `BranchCode` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `ChartOfAccountId` int 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_bank` -- LOCK TABLES `app_inv_bank` WRITE; /*!40000 ALTER TABLE `app_inv_bank` DISABLE KEYS */; INSERT INTO `app_inv_bank` VALUES (1,'Habib Bank Limited','MM Alam Road Branch','MM Alam Road Lahore','123','IBN123','542',8,1,0,'2024-04-08 18:21:32','2024-04-08 18:21:32',0); /*!40000 ALTER TABLE `app_inv_bank` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_customer` -- DROP TABLE IF EXISTS `app_inv_customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_customer` -- LOCK TABLES `app_inv_customer` WRITE; /*!40000 ALTER TABLE `app_inv_customer` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_customer_payment` -- DROP TABLE IF EXISTS `app_inv_customer_payment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_customer_payment` -- LOCK TABLES `app_inv_customer_payment` WRITE; /*!40000 ALTER TABLE `app_inv_customer_payment` DISABLE KEYS */; /*!40000 ALTER TABLE `app_inv_customer_payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_customer_type` -- DROP TABLE IF EXISTS `app_inv_customer_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_customer_type` -- LOCK TABLES `app_inv_customer_type` WRITE; /*!40000 ALTER TABLE `app_inv_customer_type` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_customer_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_delivery_order` -- DROP TABLE IF EXISTS `app_inv_delivery_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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=' '; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_delivery_order` -- LOCK TABLES `app_inv_delivery_order` WRITE; /*!40000 ALTER TABLE `app_inv_delivery_order` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_delivery_order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_delivery_order_detail` -- DROP TABLE IF EXISTS `app_inv_delivery_order_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_delivery_order_detail` -- LOCK TABLES `app_inv_delivery_order_detail` WRITE; /*!40000 ALTER TABLE `app_inv_delivery_order_detail` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_delivery_order_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_discount_type` -- DROP TABLE IF EXISTS `app_inv_discount_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_discount_type` -- LOCK TABLES `app_inv_discount_type` WRITE; /*!40000 ALTER TABLE `app_inv_discount_type` DISABLE KEYS */; /*!40000 ALTER TABLE `app_inv_discount_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_grn_order` -- DROP TABLE IF EXISTS `app_inv_grn_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_grn_order` -- LOCK TABLES `app_inv_grn_order` WRITE; /*!40000 ALTER TABLE `app_inv_grn_order` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_grn_order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_grn_order_detail` -- DROP TABLE IF EXISTS `app_inv_grn_order_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_grn_order_detail` -- LOCK TABLES `app_inv_grn_order_detail` WRITE; /*!40000 ALTER TABLE `app_inv_grn_order_detail` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_grn_order_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_grn_order_other_expense` -- DROP TABLE IF EXISTS `app_inv_grn_order_other_expense`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_grn_order_other_expense` -- LOCK TABLES `app_inv_grn_order_other_expense` WRITE; /*!40000 ALTER TABLE `app_inv_grn_order_other_expense` DISABLE KEYS */; /*!40000 ALTER TABLE `app_inv_grn_order_other_expense` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_inward_gatepass` -- DROP TABLE IF EXISTS `app_inv_inward_gatepass`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_inward_gatepass` -- LOCK TABLES `app_inv_inward_gatepass` WRITE; /*!40000 ALTER TABLE `app_inv_inward_gatepass` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `app_inv_inward_gatepass` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_inward_gatepass_detail` -- DROP TABLE IF EXISTS `app_inv_inward_gatepass_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_inward_gatepass_detail` -- LOCK TABLES `app_inv_inward_gatepass_detail` WRITE; /*!40000 ALTER TABLE `app_inv_inward_gatepass_detail` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_inward_gatepass_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_item_stock_adjustment` -- DROP TABLE IF EXISTS `app_inv_item_stock_adjustment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_item_stock_adjustment` -- LOCK TABLES `app_inv_item_stock_adjustment` WRITE; /*!40000 ALTER TABLE `app_inv_item_stock_adjustment` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_item_stock_adjustment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_item_stock_adjustment_reason` -- DROP TABLE IF EXISTS `app_inv_item_stock_adjustment_reason`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_item_stock_adjustment_reason` -- LOCK TABLES `app_inv_item_stock_adjustment_reason` WRITE; /*!40000 ALTER TABLE `app_inv_item_stock_adjustment_reason` DISABLE KEYS */; INSERT INTO `app_inv_item_stock_adjustment_reason` VALUES (1,'Some Reason',1,1,NULL,1,NULL); /*!40000 ALTER TABLE `app_inv_item_stock_adjustment_reason` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_outward_gatepass` -- DROP TABLE IF EXISTS `app_inv_outward_gatepass`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_outward_gatepass` -- LOCK TABLES `app_inv_outward_gatepass` WRITE; /*!40000 ALTER TABLE `app_inv_outward_gatepass` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_outward_gatepass` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_outward_gatepass_detail` -- DROP TABLE IF EXISTS `app_inv_outward_gatepass_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_outward_gatepass_detail` -- LOCK TABLES `app_inv_outward_gatepass_detail` WRITE; /*!40000 ALTER TABLE `app_inv_outward_gatepass_detail` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_outward_gatepass_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_payment_term` -- DROP TABLE IF EXISTS `app_inv_payment_term`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_payment_term` -- LOCK TABLES `app_inv_payment_term` WRITE; /*!40000 ALTER TABLE `app_inv_payment_term` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_payment_term` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_performa_invoice` -- DROP TABLE IF EXISTS `app_inv_performa_invoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_performa_invoice` -- LOCK TABLES `app_inv_performa_invoice` WRITE; /*!40000 ALTER TABLE `app_inv_performa_invoice` DISABLE KEYS */; /*!40000 ALTER TABLE `app_inv_performa_invoice` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_performa_invoice_detail` -- DROP TABLE IF EXISTS `app_inv_performa_invoice_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_performa_invoice_detail` -- LOCK TABLES `app_inv_performa_invoice_detail` WRITE; /*!40000 ALTER TABLE `app_inv_performa_invoice_detail` DISABLE KEYS */; /*!40000 ALTER TABLE `app_inv_performa_invoice_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_purchase_order` -- DROP TABLE IF EXISTS `app_inv_purchase_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_purchase_order` -- LOCK TABLES `app_inv_purchase_order` WRITE; /*!40000 ALTER TABLE `app_inv_purchase_order` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_purchase_order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_purchase_order_detail` -- DROP TABLE IF EXISTS `app_inv_purchase_order_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_purchase_order_detail` -- LOCK TABLES `app_inv_purchase_order_detail` WRITE; /*!40000 ALTER TABLE `app_inv_purchase_order_detail` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_purchase_order_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_vendor` -- DROP TABLE IF EXISTS `app_inv_vendor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_vendor` -- LOCK TABLES `app_inv_vendor` WRITE; /*!40000 ALTER TABLE `app_inv_vendor` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_inv_vendor` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_inv_vendor_payment` -- DROP TABLE IF EXISTS `app_inv_vendor_payment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_inv_vendor_payment` -- LOCK TABLES `app_inv_vendor_payment` WRITE; /*!40000 ALTER TABLE `app_inv_vendor_payment` DISABLE KEYS */; /*!40000 ALTER TABLE `app_inv_vendor_payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_pointofsale_customer_payment` -- DROP TABLE IF EXISTS `app_pointofsale_customer_payment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_pointofsale_customer_payment` -- LOCK TABLES `app_pointofsale_customer_payment` WRITE; /*!40000 ALTER TABLE `app_pointofsale_customer_payment` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_pointofsale_customer_payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_pointofsale_sale_order` -- DROP TABLE IF EXISTS `app_pointofsale_sale_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_pointofsale_sale_order` -- LOCK TABLES `app_pointofsale_sale_order` WRITE; /*!40000 ALTER TABLE `app_pointofsale_sale_order` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_pointofsale_sale_order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_pointofsale_sale_order_detail` -- DROP TABLE IF EXISTS `app_pointofsale_sale_order_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_pointofsale_sale_order_detail` -- LOCK TABLES `app_pointofsale_sale_order_detail` WRITE; /*!40000 ALTER TABLE `app_pointofsale_sale_order_detail` DISABLE KEYS */; 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,'',''); /*!40000 ALTER TABLE `app_pointofsale_sale_order_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_pointofsale_store_expense` -- DROP TABLE IF EXISTS `app_pointofsale_store_expense`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_pointofsale_store_expense` -- LOCK TABLES `app_pointofsale_store_expense` WRITE; /*!40000 ALTER TABLE `app_pointofsale_store_expense` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `app_pointofsale_store_expense` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_pos_branch` -- DROP TABLE IF EXISTS `app_pos_branch`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_pos_branch` -- LOCK TABLES `app_pos_branch` WRITE; /*!40000 ALTER TABLE `app_pos_branch` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_pos_branch` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_pos_daily_expense` -- DROP TABLE IF EXISTS `app_pos_daily_expense`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_pos_daily_expense` -- LOCK TABLES `app_pos_daily_expense` WRITE; /*!40000 ALTER TABLE `app_pos_daily_expense` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_pos_daily_expense` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_setting_branch_type` -- DROP TABLE IF EXISTS `app_setting_branch_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_setting_branch_type` -- LOCK TABLES `app_setting_branch_type` WRITE; /*!40000 ALTER TABLE `app_setting_branch_type` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `app_setting_branch_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_setting_company` -- DROP TABLE IF EXISTS `app_setting_company`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_setting_company` -- LOCK TABLES `app_setting_company` WRITE; /*!40000 ALTER TABLE `app_setting_company` DISABLE KEYS */; INSERT INTO `app_setting_company` VALUES (1,'ABC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `app_setting_company` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app_setting_vehicle` -- DROP TABLE IF EXISTS `app_setting_vehicle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_setting_vehicle` -- LOCK TABLES `app_setting_vehicle` WRITE; /*!40000 ALTER TABLE `app_setting_vehicle` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `app_setting_vehicle` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `area` -- DROP TABLE IF EXISTS `area`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `area` -- LOCK TABLES `area` WRITE; /*!40000 ALTER TABLE `area` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `area` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `attribute` -- DROP TABLE IF EXISTS `attribute`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attribute` -- LOCK TABLES `attribute` WRITE; /*!40000 ALTER TABLE `attribute` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `attribute` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `banktransfer` -- DROP TABLE IF EXISTS `banktransfer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `banktransfer` ( `Id` int NOT NULL, `BankName` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL, `AccountHolder` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL, `AccountNumber` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL, `IBAN` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL, `SWIFTBIC` varchar(1000) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `banktransfer` -- LOCK TABLES `banktransfer` WRITE; /*!40000 ALTER TABLE `banktransfer` DISABLE KEYS */; /*!40000 ALTER TABLE `banktransfer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blog` -- DROP TABLE IF EXISTS `blog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog` -- LOCK TABLES `blog` WRITE; /*!40000 ALTER TABLE `blog` DISABLE KEYS */; /*!40000 ALTER TABLE `blog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blogcategory` -- DROP TABLE IF EXISTS `blogcategory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blogcategory` -- LOCK TABLES `blogcategory` WRITE; /*!40000 ALTER TABLE `blogcategory` DISABLE KEYS */; /*!40000 ALTER TABLE `blogcategory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `brand` -- DROP TABLE IF EXISTS `brand`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `brand` -- LOCK TABLES `brand` WRITE; /*!40000 ALTER TABLE `brand` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `brand` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaign` -- DROP TABLE IF EXISTS `campaign`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaign` -- LOCK TABLES `campaign` WRITE; /*!40000 ALTER TABLE `campaign` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `campaign` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaignproduct` -- DROP TABLE IF EXISTS `campaignproduct`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaignproduct` -- LOCK TABLES `campaignproduct` WRITE; /*!40000 ALTER TABLE `campaignproduct` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `campaignproduct` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category` -- DROP TABLE IF EXISTS `category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category` -- LOCK TABLES `category` WRITE; /*!40000 ALTER TABLE `category` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `city` -- DROP TABLE IF EXISTS `city`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `city` -- LOCK TABLES `city` WRITE; /*!40000 ALTER TABLE `city` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `city` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactus` -- DROP TABLE IF EXISTS `contactus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactus` -- LOCK TABLES `contactus` WRITE; /*!40000 ALTER TABLE `contactus` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `contactus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactusreply` -- DROP TABLE IF EXISTS `contactusreply`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactusreply` -- LOCK TABLES `contactusreply` WRITE; /*!40000 ALTER TABLE `contactusreply` DISABLE KEYS */; /*!40000 ALTER TABLE `contactusreply` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `country` -- DROP TABLE IF EXISTS `country`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `country` -- LOCK TABLES `country` WRITE; /*!40000 ALTER TABLE `country` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `country` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `coupon` -- DROP TABLE IF EXISTS `coupon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `coupon` -- LOCK TABLES `coupon` WRITE; /*!40000 ALTER TABLE `coupon` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `coupon` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `currency` -- DROP TABLE IF EXISTS `currency`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `currency` -- LOCK TABLES `currency` WRITE; /*!40000 ALTER TABLE `currency` DISABLE KEYS */; INSERT INTO `currency` VALUES (1,'USD','$',1,0,NULL,NULL,NULL),(2,'PKR','RS.',1,0,NULL,NULL,NULL); /*!40000 ALTER TABLE `currency` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `currencylist` -- DROP TABLE IF EXISTS `currencylist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `currencylist` -- LOCK TABLES `currencylist` WRITE; /*!40000 ALTER TABLE `currencylist` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `currencylist` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer` ( `Id` bigint unsigned NOT NULL, `FirstName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LastName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `EmailAddress` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Picture` text COLLATE utf8mb4_unicode_ci, `PhoneNo` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Address` text COLLATE utf8mb4_unicode_ci, `ZipCode` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `CityId` int DEFAULT NULL, `StateId` int DEFAULT NULL, `AreaId` int DEFAULT NULL, `CountryId` int DEFAULT NULL, `Status` int DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int DEFAULT NULL, `UserTypeId` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `FullName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `UserPassword` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL, `DateOfBirth` date DEFAULT NULL, `Gender` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer` -- LOCK TABLES `customer` WRITE; /*!40000 ALTER TABLE `customer` DISABLE KEYS */; INSERT INTO `customer` VALUES (1,'Nabeel','Ezad','nab@gmial.com','customerpicture/0202402040535381652239711955.jfif','032444925693',NULL,NULL,NULL,NULL,NULL,NULL,1,'2024-01-25 08:02:05',0,'2024-02-04 10:11:37',0,NULL,NULL,NULL,'Nabeel','12345','2024-02-02','Male'),(2,'sdf','sdf','dsfgdfgd@gmail.com',NULL,'fdfg',NULL,NULL,NULL,NULL,NULL,NULL,1,'2024-01-25 08:07:06',0,NULL,NULL,NULL,NULL,NULL,'sdf','$2y$12$8ZXIxCdaCJjCfZsxwy2DmeqXZbrJvpBwEqh89Nl.WoC1hQzucwSPm',NULL,''),(3,'Nabeel Bin Ezad','Nabeel Bin Ezad','nabeel@gmial.com',NULL,'032444925692',NULL,NULL,NULL,NULL,NULL,NULL,1,'2024-01-25 10:08:46',0,NULL,NULL,NULL,NULL,NULL,'Nabeel Bin Ezad','$2y$12$ogSkk40t9L6U/uKyrh9.nOwygTH4ejbjYcGbhzgdk27R/ILPw5GYa',NULL,''); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customerbillinginfo` -- DROP TABLE IF EXISTS `customerbillinginfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customerbillinginfo` -- LOCK TABLES `customerbillinginfo` WRITE; /*!40000 ALTER TABLE `customerbillinginfo` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `customerbillinginfo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customerresidancetype` -- DROP TABLE IF EXISTS `customerresidancetype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customerresidancetype` -- LOCK TABLES `customerresidancetype` WRITE; /*!40000 ALTER TABLE `customerresidancetype` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `customerresidancetype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customershippinginfo` -- DROP TABLE IF EXISTS `customershippinginfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customershippinginfo` -- LOCK TABLES `customershippinginfo` WRITE; /*!40000 ALTER TABLE `customershippinginfo` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `customershippinginfo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customerwishlist` -- DROP TABLE IF EXISTS `customerwishlist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customerwishlist` -- LOCK TABLES `customerwishlist` WRITE; /*!40000 ALTER TABLE `customerwishlist` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `customerwishlist` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailconfig` -- DROP TABLE IF EXISTS `emailconfig`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `emailconfig` ( `Id` int unsigned NOT NULL, `MailHost` text COLLATE utf8mb4_unicode_ci NOT NULL, `Email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `SMTPUserName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `SMTPPassword` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `MailPort` int NOT NULL DEFAULT '0', `MailExcryption` 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailconfig` -- LOCK TABLES `emailconfig` WRITE; /*!40000 ALTER TABLE `emailconfig` DISABLE KEYS */; /*!40000 ALTER TABLE `emailconfig` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailtemplate` -- DROP TABLE IF EXISTS `emailtemplate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailtemplate` -- LOCK TABLES `emailtemplate` WRITE; /*!40000 ALTER TABLE `emailtemplate` DISABLE KEYS */; /*!40000 ALTER TABLE `emailtemplate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `findus` -- DROP TABLE IF EXISTS `findus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `findus` -- LOCK TABLES `findus` WRITE; /*!40000 ALTER TABLE `findus` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `findus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `headerslider` -- DROP TABLE IF EXISTS `headerslider`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `headerslider` -- LOCK TABLES `headerslider` WRITE; /*!40000 ALTER TABLE `headerslider` DISABLE KEYS */; /*!40000 ALTER TABLE `headerslider` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `logofviconsetting` -- DROP TABLE IF EXISTS `logofviconsetting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `logofviconsetting` -- LOCK TABLES `logofviconsetting` WRITE; /*!40000 ALTER TABLE `logofviconsetting` DISABLE KEYS */; INSERT INTO `logofviconsetting` VALUES (1,'logofviconpicture/020240221171136shoplixlogo.png','logofviconpicture/020240225105108shoplixlogo.png',1,0,'2024-02-25 10:51:08',NULL,NULL); /*!40000 ALTER TABLE `logofviconsetting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orderbillinginfo` -- DROP TABLE IF EXISTS `orderbillinginfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orderbillinginfo` -- LOCK TABLES `orderbillinginfo` WRITE; /*!40000 ALTER TABLE `orderbillinginfo` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `orderbillinginfo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orderdetail` -- DROP TABLE IF EXISTS `orderdetail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orderdetail` -- LOCK TABLES `orderdetail` WRITE; /*!40000 ALTER TABLE `orderdetail` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `orderdetail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders` -- LOCK TABLES `orders` WRITE; /*!40000 ALTER TABLE `orders` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ordershippinginfo` -- DROP TABLE IF EXISTS `ordershippinginfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ordershippinginfo` -- LOCK TABLES `ordershippinginfo` WRITE; /*!40000 ALTER TABLE `ordershippinginfo` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `ordershippinginfo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orderstatus` -- DROP TABLE IF EXISTS `orderstatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orderstatus` -- LOCK TABLES `orderstatus` WRITE; /*!40000 ALTER TABLE `orderstatus` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `orderstatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orderstype` -- DROP TABLE IF EXISTS `orderstype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orderstype` -- LOCK TABLES `orderstype` WRITE; /*!40000 ALTER TABLE `orderstype` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `orderstype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pages` -- DROP TABLE IF EXISTS `pages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pages` -- LOCK TABLES `pages` WRITE; /*!40000 ALTER TABLE `pages` DISABLE KEYS */; /*!40000 ALTER TABLE `pages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paymentstatus` -- DROP TABLE IF EXISTS `paymentstatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `paymentstatus` -- LOCK TABLES `paymentstatus` WRITE; /*!40000 ALTER TABLE `paymentstatus` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `paymentstatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paymenttype` -- DROP TABLE IF EXISTS `paymenttype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `paymenttype` -- LOCK TABLES `paymenttype` WRITE; /*!40000 ALTER TABLE `paymenttype` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `paymenttype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `personal_access_tokens` ( `id` bigint unsigned NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `placeofsupply` -- DROP TABLE IF EXISTS `placeofsupply`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `placeofsupply` -- LOCK TABLES `placeofsupply` WRITE; /*!40000 ALTER TABLE `placeofsupply` DISABLE KEYS */; INSERT INTO `placeofsupply` VALUES (1,'01','UAE','UAE',1,1,NULL,NULL,NULL),(2,'01','UAE','UAE',0,1,NULL,NULL,NULL); /*!40000 ALTER TABLE `placeofsupply` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `possetting` -- DROP TABLE IF EXISTS `possetting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `possetting` -- LOCK TABLES `possetting` WRITE; /*!40000 ALTER TABLE `possetting` DISABLE KEYS */; /*!40000 ALTER TABLE `possetting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product` -- DROP TABLE IF EXISTS `product`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product` -- LOCK TABLES `product` WRITE; /*!40000 ALTER TABLE `product` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `product` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `productattribute` -- DROP TABLE IF EXISTS `productattribute`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `productattribute` -- LOCK TABLES `productattribute` WRITE; /*!40000 ALTER TABLE `productattribute` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `productattribute` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `productpicture` -- DROP TABLE IF EXISTS `productpicture`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `productpicture` -- LOCK TABLES `productpicture` WRITE; /*!40000 ALTER TABLE `productpicture` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `productpicture` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `productrating` -- DROP TABLE IF EXISTS `productrating`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `productrating` -- LOCK TABLES `productrating` WRITE; /*!40000 ALTER TABLE `productrating` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `productrating` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `productreport` -- DROP TABLE IF EXISTS `productreport`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `productreport` -- LOCK TABLES `productreport` WRITE; /*!40000 ALTER TABLE `productreport` DISABLE KEYS */; /*!40000 ALTER TABLE `productreport` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `productype` -- DROP TABLE IF EXISTS `productype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `productype` -- LOCK TABLES `productype` WRITE; /*!40000 ALTER TABLE `productype` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `productype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `returpolicy` -- DROP TABLE IF EXISTS `returpolicy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `returpolicy` -- LOCK TABLES `returpolicy` WRITE; /*!40000 ALTER TABLE `returpolicy` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `returpolicy` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sec_forms` -- DROP TABLE IF EXISTS `sec_forms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sec_forms` -- LOCK TABLES `sec_forms` WRITE; /*!40000 ALTER TABLE `sec_forms` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `sec_forms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sec_module` -- DROP TABLE IF EXISTS `sec_module`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sec_module` ( `Id` int NOT NULL, `ModuleName` varchar(255) DEFAULT NULL, `Description` text, `Status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sec_module` -- LOCK TABLES `sec_module` WRITE; /*!40000 ALTER TABLE `sec_module` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `sec_module` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sec_users` -- DROP TABLE IF EXISTS `sec_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sec_users` ( `Id` int NOT NULL, `UserName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `UserPassword` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL, `Status` int DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ZoneId` int DEFAULT NULL, `CreatedBy` int DEFAULT NULL, `BranchId` int DEFAULT NULL, `ProfileId` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sec_users` -- LOCK TABLES `sec_users` WRITE; /*!40000 ALTER TABLE `sec_users` DISABLE KEYS */; INSERT INTO `sec_users` VALUES (1,'admin','admin',1,NULL,1,1,1,1),(2,'posad','posadmin',1,'2024-06-13 09:44:51',3,1,1,NULL); /*!40000 ALTER TABLE `sec_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sec_zone` -- DROP TABLE IF EXISTS `sec_zone`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sec_zone` -- LOCK TABLES `sec_zone` WRITE; /*!40000 ALTER TABLE `sec_zone` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `sec_zone` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sec_zone_gate` -- DROP TABLE IF EXISTS `sec_zone_gate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sec_zone_gate` -- LOCK TABLES `sec_zone_gate` WRITE; /*!40000 ALTER TABLE `sec_zone_gate` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `sec_zone_gate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `seller` -- DROP TABLE IF EXISTS `seller`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `seller` -- LOCK TABLES `seller` WRITE; /*!40000 ALTER TABLE `seller` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `seller` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `shipping` -- DROP TABLE IF EXISTS `shipping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `shipping` -- LOCK TABLES `shipping` WRITE; /*!40000 ALTER TABLE `shipping` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `shipping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `socialmedialinks` -- DROP TABLE IF EXISTS `socialmedialinks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `socialmedialinks` -- LOCK TABLES `socialmedialinks` WRITE; /*!40000 ALTER TABLE `socialmedialinks` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `socialmedialinks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `state` -- DROP TABLE IF EXISTS `state`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `state` -- LOCK TABLES `state` WRITE; /*!40000 ALTER TABLE `state` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `state` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tax` -- DROP TABLE IF EXISTS `tax`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tax` -- LOCK TABLES `tax` WRITE; /*!40000 ALTER TABLE `tax` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `tax` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `unit` -- DROP TABLE IF EXISTS `unit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `unit` -- LOCK TABLES `unit` WRITE; /*!40000 ALTER TABLE `unit` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `unit` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usertype` -- DROP TABLE IF EXISTS `usertype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usertype` -- LOCK TABLES `usertype` WRITE; /*!40000 ALTER TABLE `usertype` DISABLE KEYS */; INSERT INTO `usertype` VALUES (1,'Standard','Standard',1,'2023-10-05 10:48:17',0,'2023-10-05 10:51:33',0,NULL,NULL); /*!40000 ALTER TABLE `usertype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `websitegeneralsetting` -- DROP TABLE IF EXISTS `websitegeneralsetting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `websitegeneralsetting` -- LOCK TABLES `websitegeneralsetting` WRITE; /*!40000 ALTER TABLE `websitegeneralsetting` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `websitegeneralsetting` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-08-08 6:04:19 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`;