-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 20, 2024 at 10:35 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `aemposinst` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_user` -- CREATE TABLE `admin_user` ( `Id` int(10) UNSIGNED NOT NULL, `FirstName` varchar(255) NOT NULL, `LastName` varchar(255) DEFAULT NULL, `Username` varchar(255) NOT NULL, `UserPassword` varchar(255) NOT NULL, `EmailAddress` varchar(255) NOT NULL, `UserTypeId` int(11) NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `BranchId` int(11) DEFAULT NULL, `ProfileId` int(11) NOT NULL, `CompanyId` int(11) DEFAULT NULL, `ZoneId` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admin_user` -- INSERT INTO `admin_user` (`Id`, `FirstName`, `LastName`, `Username`, `UserPassword`, `EmailAddress`, `UserTypeId`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`, `BranchId`, `ProfileId`, `CompanyId`, `ZoneId`) VALUES (1, 'admin', 'admin', 'admin', 'admin', 'admin@gmail.com', 1, 1, NULL, 0, NULL, 0, NULL, NULL, 1, 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `app_acct_account_group` -- CREATE TABLE `app_acct_account_group` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_acct_account_group` -- INSERT INTO `app_acct_account_group` (`Id`, `Code`, `Name`, `Description`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifedDate`) VALUES (1, '01', 'BALANCE SHEET', 'BALANCE SHEET', 1, NULL, NULL, NULL, NULL), (2, '02', 'PROFIT & LOSS', 'PROFIT & LOSS', 1, NULL, NULL, NULL, NULL), (3, '03', 'OTHERS', 'OTHERS', 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `app_acct_chart_of_account` -- CREATE TABLE `app_acct_chart_of_account` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `AccountNatureId` int(11) DEFAULT NULL, `ParentAccountId` int(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `AllowReconciliation` int(11) DEFAULT NULL, `OpeningBalance` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_acct_chart_of_account` -- INSERT INTO `app_acct_chart_of_account` (`Id`, `Code`, `Name`, `Description`, `AccountNatureId`, `ParentAccountId`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`, `AllowReconciliation`, `OpeningBalance`) VALUES (1, '01', 'Customers', 'Customers', 2, -1, 1, NULL, NULL, NULL, NULL, NULL, 0), (2, '02', 'Vendors', 'Vendors', 1, -1, 1, NULL, NULL, NULL, NULL, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `app_acct_nature_of_account` -- CREATE TABLE `app_acct_nature_of_account` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `AccountGroupId` int(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_acct_nature_of_account` -- INSERT INTO `app_acct_nature_of_account` (`Id`, `Code`, `Name`, `Description`, `AccountGroupId`, `Status`, `CreatedBy`, `CreatedDate`, `ModifedBy`, `ModifiedDate`) VALUES (1, '01', 'Accouonts Payable', 'Accouonts Payable', 1, 1, NULL, NULL, NULL, NULL), (2, '02', 'Accounts Receivable', 'Accounts Receivable', 1, 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `app_gen_setting_payment_type` -- CREATE TABLE `app_gen_setting_payment_type` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` date DEFAULT NULL, `ModififedBy` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_gen_setting_payment_type` -- INSERT INTO `app_gen_setting_payment_type` (`Id`, `Code`, `Name`, `Description`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModififedBy`) VALUES (1, 'CASH', 'CASH', 'CASH', 1, NULL, NULL, NULL, NULL), (2, 'CREDIT', 'CREDIT', 'CREDIT', 1, NULL, NULL, NULL, NULL), (3, 'RETURN', 'RETURN', 'RETURN', 1, NULL, NULL, NULL, NULL), (4, 'BANK TRANSFER', 'BANK TRANSFER', 'BANK TRANSFER', 1, NULL, NULL, NULL, NULL), (5, 'ONLINE BANK TRANSFER', 'ONLINE BANK TRANSFER', 'ONLINE BANK TRANSFER', 1, NULL, NULL, NULL, NULL), (6, 'CHEQUE', 'CHEQUE', 'CHEQUE', 1, NULL, NULL, NULL, NULL), (7, 'ADVANCE PAYMENT', 'ADVANCE PAYMENT', 'ADVANCE PAYMENT', 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `app_hr_department` -- CREATE TABLE `app_hr_department` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_hr_designation` -- CREATE TABLE `app_hr_designation` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_hr_employee_personal_information` -- CREATE TABLE `app_hr_employee_personal_information` ( `Id` bigint(20) NOT NULL, `FullName` varchar(255) DEFAULT NULL, `FatherName` varchar(255) DEFAULT NULL, `ControlNumber` varchar(255) DEFAULT NULL, `PFNumber` varchar(255) DEFAULT NULL, `Address` text DEFAULT NULL, `DateOfJoining` date DEFAULT NULL, `DateOfBirth` date DEFAULT NULL, `PresentAddress` text DEFAULT NULL, `NationalityId` int(11) DEFAULT NULL, `ReligionId` int(11) DEFAULT NULL, `MartialStatus` varchar(255) DEFAULT NULL, `EOBIPESSINo` varchar(255) DEFAULT NULL, `CNic` varchar(255) DEFAULT NULL, `MobileNumber` varchar(30) DEFAULT NULL, `PhoneNumber` varchar(30) DEFAULT NULL, `EmailAddress` varchar(255) DEFAULT NULL, `JobStatusId` int(11) DEFAULT NULL, `EmployeeTypeId` int(11) DEFAULT NULL, `Description` int(11) DEFAULT NULL, `isNTN` int(11) DEFAULT NULL, `isEOBI` int(11) DEFAULT NULL, `isSSN` int(11) DEFAULT NULL, `isPF` int(11) DEFAULT NULL, `ChartOfAccountId` int(11) DEFAULT NULL, `NTNNumber` varchar(255) DEFAULT NULL, `SSNNumber` varchar(255) DEFAULT NULL, `DateOfConfirmation` date DEFAULT NULL, `BloodGroup` varchar(255) DEFAULT NULL, `NextOfKin` varchar(255) DEFAULT NULL, `SecutityCardNo` varchar(255) DEFAULT NULL, `EmergencyPhone` varchar(255) DEFAULT NULL, `Gender` varchar(255) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` date DEFAULT NULL, `Picture` text DEFAULT NULL, `FullNameUr` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_hr_employee_personal_information` -- INSERT INTO `app_hr_employee_personal_information` (`Id`, `FullName`, `FatherName`, `ControlNumber`, `PFNumber`, `Address`, `DateOfJoining`, `DateOfBirth`, `PresentAddress`, `NationalityId`, `ReligionId`, `MartialStatus`, `EOBIPESSINo`, `CNic`, `MobileNumber`, `PhoneNumber`, `EmailAddress`, `JobStatusId`, `EmployeeTypeId`, `Description`, `isNTN`, `isEOBI`, `isSSN`, `isPF`, `ChartOfAccountId`, `NTNNumber`, `SSNNumber`, `DateOfConfirmation`, `BloodGroup`, `NextOfKin`, `SecutityCardNo`, `EmergencyPhone`, `Gender`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`, `Picture`, `FullNameUr`) 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', 'شچطشطدسفدسف'); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_bank` -- CREATE TABLE `app_inv_bank` ( `Id` int(11) NOT NULL, `Name` varchar(255) DEFAULT NULL, `BranchName` text DEFAULT NULL, `BranchAddress` text DEFAULT NULL, `AccountNo` varchar(1000) DEFAULT NULL, `IbanNo` varchar(1000) DEFAULT NULL, `BranchCode` varchar(255) DEFAULT NULL, `ChartOfAccountId` int(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_inv_bank` -- INSERT INTO `app_inv_bank` (`Id`, `Name`, `BranchName`, `BranchAddress`, `AccountNo`, `IbanNo`, `BranchCode`, `ChartOfAccountId`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedDate`, `ModifiedBy`) VALUES (1, 'Habib Bank Limited', 'MM Alam Road Branch', 'MM Alam Road Lahore', '123', 'IBN123', '542', 1, 1, 0, '2024-04-08 18:21:32', '2024-04-08 18:21:32', 0); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_customer` -- CREATE TABLE `app_inv_customer` ( `Id` bigint(20) NOT NULL, `CustomerName` varchar(255) DEFAULT NULL, `PhoneNo` varchar(30) DEFAULT NULL, `MobileNo` varchar(30) DEFAULT NULL, `EmailAddress` varchar(255) DEFAULT NULL, `TempAddress` text DEFAULT NULL, `PermanentAddress` text DEFAULT NULL, `OpeningBalance` double DEFAULT NULL, `CustomerTypeId` int(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `CustomerCode` varchar(255) DEFAULT NULL, `ContactPerson` varchar(255) DEFAULT NULL, `DiscountTypeId` int(11) DEFAULT NULL, `DiscountPerFlat` varchar(255) DEFAULT NULL, `DiscountValue` double DEFAULT NULL, `TaxStatus` int(11) DEFAULT NULL, `ChartOfAccountId` int(11) DEFAULT NULL, `SaleTaxRegNo` varchar(255) DEFAULT NULL, `NTNNo` varchar(255) DEFAULT NULL, `CNIC` varchar(255) DEFAULT NULL, `Picture` text DEFAULT NULL, `Description` text DEFAULT NULL, `CreditLimit` double DEFAULT 0, `MaxDiscountAllow` decimal(10,0) DEFAULT 0, `CustomerResidenceTypeId` int(11) DEFAULT NULL, `MobileNoTwo` varchar(255) DEFAULT NULL, `Location` text DEFAULT NULL, `AddressUr` text DEFAULT NULL, `ResidenceDuration` varchar(255) DEFAULT NULL, `LocationPicture` text DEFAULT NULL, `CNICFrontPicture` text DEFAULT NULL, `CNICBackPicture` int(11) DEFAULT NULL, `AccountNo` varchar(255) DEFAULT NULL, `PreAccountNo` varchar(255) DEFAULT NULL, `FatherName` varchar(255) DEFAULT NULL, `Occupation` varchar(255) DEFAULT NULL, `CustomerNameUr` varchar(255) DEFAULT NULL, `Bussiness` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_inv_customer` -- INSERT INTO `app_inv_customer` (`Id`, `CustomerName`, `PhoneNo`, `MobileNo`, `EmailAddress`, `TempAddress`, `PermanentAddress`, `OpeningBalance`, `CustomerTypeId`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `CustomerCode`, `ContactPerson`, `DiscountTypeId`, `DiscountPerFlat`, `DiscountValue`, `TaxStatus`, `ChartOfAccountId`, `SaleTaxRegNo`, `NTNNo`, `CNIC`, `Picture`, `Description`, `CreditLimit`, `MaxDiscountAllow`, `CustomerResidenceTypeId`, `MobileNoTwo`, `Location`, `AddressUr`, `ResidenceDuration`, `LocationPicture`, `CNICFrontPicture`, `CNICBackPicture`, `AccountNo`, `PreAccountNo`, `FatherName`, `Occupation`, `CustomerNameUr`, `Bussiness`) 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); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_customer_payment` -- CREATE TABLE `app_inv_customer_payment` ( `Id` bigint(20) NOT NULL, `CustomerInvoiceId` bigint(20) DEFAULT NULL, `CustomerId` int(11) DEFAULT NULL, `PaymentTypeId` int(11) DEFAULT NULL, `BankId` int(11) DEFAULT NULL, `BankBranch` varchar(255) DEFAULT NULL, `ChkNo` varchar(255) DEFAULT NULL, `ChkDate` date DEFAULT NULL, `ChkCashDate` date DEFAULT NULL, `PaymentDate` date DEFAULT NULL, `Amount` double DEFAULT NULL, `PaymentNote` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_inv_customer_type` -- CREATE TABLE `app_inv_customer_type` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `CustomerTypeName` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_inv_customer_type` -- INSERT INTO `app_inv_customer_type` (`Id`, `Code`, `CustomerTypeName`, `Description`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, '01', 'Walking', 'Walking', 1, NULL, NULL, NULL, NULL), (2, '2', 'CreditCustomer', 'CreditCustomer', 1, NULL, NULL, NULL, NULL), (3, '03', 'Inst Customer', 'Inst Customer', 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_discount_type` -- CREATE TABLE `app_inv_discount_type` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `FlatPer` varchar(255) DEFAULT NULL, `Discount` double DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) NOT NULL, `CreatedDate` datetime NOT NULL, `CreatedBy` int(11) NOT NULL, `ModifiedDate` datetime NOT NULL, `ModifiedBy` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_inv_grn_order` -- CREATE TABLE `app_inv_grn_order` ( `Id` bigint(20) NOT NULL, `OrderDate` date DEFAULT NULL, `PurchaseOrderId` bigint(20) DEFAULT NULL, `VendorId` int(11) DEFAULT NULL, `BillNo` varchar(255) DEFAULT NULL, `DiscountId` int(11) DEFAULT NULL, `DiscountType` varchar(255) 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(11) DEFAULT NULL, `DemandNoteId` int(11) DEFAULT NULL, `PaymentTypeId` int(11) DEFAULT NULL, `Note` text DEFAULT NULL, `ReferenceNo` varchar(255) DEFAULT NULL, `WareHouseId` int(11) DEFAULT NULL, `IsReturn` int(11) DEFAULT NULL, `OrderStatus` int(11) DEFAULT NULL, `BranchId` int(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_inv_grn_order` -- INSERT INTO `app_inv_grn_order` (`Id`, `OrderDate`, `PurchaseOrderId`, `VendorId`, `BillNo`, `DiscountId`, `DiscountType`, `DiscountValue`, `OrderTotal`, `DiscountTotal`, `SalesTax`, `FurtherTax`, `NetAmount`, `FinancialYearId`, `DemandNoteId`, `PaymentTypeId`, `Note`, `ReferenceNo`, `WareHouseId`, `IsReturn`, `OrderStatus`, `BranchId`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) 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); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_grn_order_detail` -- CREATE TABLE `app_inv_grn_order_detail` ( `Id` bigint(20) NOT NULL, `GrnOrderId` bigint(20) DEFAULT NULL, `ItemId` int(11) 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(11) DEFAULT NULL, `BrandId` int(11) DEFAULT NULL, `CategoryId` int(11) DEFAULT NULL, `SubCategoryId` int(11) DEFAULT NULL, `ChildCategoryId` int(11) DEFAULT NULL, `ItemTypeId` int(11) DEFAULT NULL, `UnitId` int(11) DEFAULT NULL, `DiscountId` int(11) DEFAULT NULL, `DiscountValue` decimal(10,0) DEFAULT NULL, `DiscPerFlat` varchar(255) 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(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_inv_grn_order_detail` -- INSERT INTO `app_inv_grn_order_detail` (`Id`, `GrnOrderId`, `ItemId`, `SalePrice`, `PurchasePrice`, `WholeSalePrice`, `TaxRate`, `TaxValue`, `TaxId`, `BrandId`, `CategoryId`, `SubCategoryId`, `ChildCategoryId`, `ItemTypeId`, `UnitId`, `DiscountId`, `DiscountValue`, `DiscPerFlat`, `DiscountTotal`, `TotalAmount`, `NetAmount`, `Quantity`, `StoreId`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) 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); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_grn_order_other_expense` -- CREATE TABLE `app_inv_grn_order_other_expense` ( `Id` bigint(20) NOT NULL, `ExpenseId` int(11) DEFAULT NULL, `Amount` decimal(10,0) DEFAULT NULL, `GRNId` bigint(20) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_inv_item_stock_adjustment` -- CREATE TABLE `app_inv_item_stock_adjustment` ( `Id` int(11) NOT NULL, `ItemId` int(11) DEFAULT NULL, `Quantity` decimal(10,0) DEFAULT NULL, `ReasonId` int(11) DEFAULT NULL, `AdjustmentDate` date DEFAULT NULL, `Note` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_inv_item_stock_adjustment` -- INSERT INTO `app_inv_item_stock_adjustment` (`Id`, `ItemId`, `Quantity`, `ReasonId`, `AdjustmentDate`, `Note`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (2, 20, 34, 1, '2024-06-06', NULL, 1, 1, '2024-06-06 12:11:45', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_item_stock_adjustment_reason` -- CREATE TABLE `app_inv_item_stock_adjustment_reason` ( `Id` int(11) NOT NULL, `Reason` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_inv_item_stock_adjustment_reason` -- INSERT INTO `app_inv_item_stock_adjustment_reason` (`Id`, `Reason`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 'Some Reason', 1, 1, NULL, 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_purchase_order` -- CREATE TABLE `app_inv_purchase_order` ( `Id` bigint(20) NOT NULL, `BillNo` varchar(255) DEFAULT NULL, `OrderDate` date DEFAULT NULL, `VendorId` int(11) DEFAULT NULL, `DiscountId` int(11) DEFAULT NULL, `DiscountType` varchar(255) 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(11) DEFAULT NULL, `OrderDueDate` date DEFAULT NULL, `JobNo` varchar(255) DEFAULT NULL, `PaymentTypeId` int(11) DEFAULT NULL, `Note` text NOT NULL, `ReferenceNo` varchar(255) NOT NULL, `BranchId` int(11) NOT NULL, `Status` int(11) NOT NULL, `CreatedBy` int(11) NOT NULL, `CreatedDate` datetime NOT NULL, `ModifiedBy` int(11) NOT NULL, `ModifiedDate` datetime NOT NULL, `IsTaxable` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_inv_purchase_order_detail` -- CREATE TABLE `app_inv_purchase_order_detail` ( `Id` bigint(20) NOT NULL, `PurchaseOrderId` bigint(20) DEFAULT NULL, `ItemId` int(11) 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(11) DEFAULT NULL, `DiscountType` varchar(255) DEFAULT NULL, `DiscountPerFlat` varchar(255) DEFAULT NULL, `DiscountValue` decimal(10,0) DEFAULT NULL, `BrandId` int(11) DEFAULT NULL, `CategoryId` int(11) DEFAULT NULL, `ItemTypeId` int(11) DEFAULT NULL, `UnitId` int(11) DEFAULT NULL, `TotalAmount` decimal(10,0) DEFAULT NULL, `NetAmount` decimal(10,0) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_inv_vendor` -- CREATE TABLE `app_inv_vendor` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `PhoneNo` varchar(255) DEFAULT NULL, `MobileNo` varchar(255) DEFAULT NULL, `EmailAddress` varchar(255) DEFAULT NULL, `Address` text DEFAULT NULL, `OpeningBalance` double DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ChartOfAccountId` int(11) DEFAULT NULL, `BranchId` int(11) DEFAULT NULL, `Picture` text DEFAULT NULL, `ContactPerson` varchar(255) DEFAULT NULL, `SaleTaxRegNo` varchar(255) DEFAULT NULL, `NTNNo` varchar(255) DEFAULT NULL, `CNIC` varchar(255) DEFAULT NULL, `TaxStatus` int(11) DEFAULT NULL, `NameUr` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_inv_vendor` -- INSERT INTO `app_inv_vendor` (`Id`, `Code`, `Name`, `Description`, `PhoneNo`, `MobileNo`, `EmailAddress`, `Address`, `OpeningBalance`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`, `ChartOfAccountId`, `BranchId`, `Picture`, `ContactPerson`, `SaleTaxRegNo`, `NTNNo`, `CNIC`, `TaxStatus`, `NameUr`) 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), (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), (3, 'VC-0000003', 'dfdf', NULL, 'dfg', 'fg', 'ffgf', 'fdg', 0, 1, 1, '2024-04-27 13:01:27', NULL, NULL, 0, NULL, NULL, 'fdg', 'fdg', 'fdg', 'fg', 0, 'فدگگسفددسفدسفدس'); -- -------------------------------------------------------- -- -- Table structure for table `app_inv_vendor_payment` -- CREATE TABLE `app_inv_vendor_payment` ( `Id` int(11) NOT NULL, `PurchaseOrderId` int(11) DEFAULT NULL, `VendorId` int(11) DEFAULT NULL, `PaymentTypeId` int(11) DEFAULT NULL, `BankId` int(11) DEFAULT NULL, `BankBranch` varchar(255) DEFAULT NULL, `ChkNo` varchar(255) DEFAULT NULL, `ChkDate` date DEFAULT NULL, `ChkCashDate` date DEFAULT NULL, `PaymentDate` date DEFAULT NULL, `Amount` double DEFAULT NULL, `PaymentNote` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `BranchId` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_pointofsale_customer_payment` -- CREATE TABLE `app_pointofsale_customer_payment` ( `Id` bigint(20) NOT NULL, `CustomerInvoiceId` bigint(20) DEFAULT NULL, `CustomerId` int(11) DEFAULT NULL, `PaymentTypeId` int(11) DEFAULT NULL, `BankId` int(11) DEFAULT NULL, `BankBranch` varchar(1000) DEFAULT NULL, `ChkNo` varchar(1000) DEFAULT NULL, `ChkDate` date DEFAULT NULL, `ChkCashDate` date DEFAULT NULL, `PaymentDate` date DEFAULT NULL, `Amount` decimal(10,0) DEFAULT NULL, `PaymentNote` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` date DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `BranchId` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_pointofsale_customer_payment` -- INSERT INTO `app_pointofsale_customer_payment` (`Id`, `CustomerInvoiceId`, `CustomerId`, `PaymentTypeId`, `BankId`, `BankBranch`, `ChkNo`, `ChkDate`, `ChkCashDate`, `PaymentDate`, `Amount`, `PaymentNote`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `BranchId`) 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); -- -------------------------------------------------------- -- -- Table structure for table `app_pointofsale_sale_order` -- CREATE TABLE `app_pointofsale_sale_order` ( `Id` bigint(20) NOT NULL, `OrderDate` datetime DEFAULT NULL, `CustomerId` int(11) DEFAULT NULL, `EmployeeId` int(11) DEFAULT NULL, `BillNo` varchar(255) 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(11) DEFAULT NULL, `BranchId` int(11) DEFAULT NULL, `FinancialYearId` int(11) DEFAULT NULL, `PointAwarded` decimal(10,0) DEFAULT NULL, `RedeemPoint` decimal(10,0) DEFAULT NULL, `RedeemAmount` decimal(10,0) DEFAULT NULL, `PyamentTypeId` int(11) DEFAULT NULL, `PaymentAmount` decimal(10,0) DEFAULT NULL, `Balance` decimal(10,0) DEFAULT NULL, `RetailWholeSale` varchar(255) DEFAULT NULL, `Commission` decimal(10,0) DEFAULT NULL, `CommissionValue` decimal(10,0) DEFAULT NULL, `SyncStatus` int(11) DEFAULT NULL, `RefundInvoiceId` bigint(20) DEFAULT NULL, `ReturnInvoiceId` bigint(20) DEFAULT NULL, `CustomerTypeId` int(11) DEFAULT NULL, `CustomerName` varchar(255) DEFAULT NULL, `Note` text DEFAULT NULL, `SaleTaxInvStatus` int(11) DEFAULT NULL, `FBRInvoiceNumber` varchar(255) DEFAULT NULL, `CustomerMobileNumber` varchar(255) DEFAULT NULL, `OrderTypeId` int(11) DEFAULT NULL, `TableId` int(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `TotalQty` decimal(10,0) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_pointofsale_sale_order` -- INSERT INTO `app_pointofsale_sale_order` (`Id`, `OrderDate`, `CustomerId`, `EmployeeId`, `BillNo`, `OrderTotal`, `DiscountTotal`, `SaleTax`, `NetAmount`, `DiscountId`, `BranchId`, `FinancialYearId`, `PointAwarded`, `RedeemPoint`, `RedeemAmount`, `PyamentTypeId`, `PaymentAmount`, `Balance`, `RetailWholeSale`, `Commission`, `CommissionValue`, `SyncStatus`, `RefundInvoiceId`, `ReturnInvoiceId`, `CustomerTypeId`, `CustomerName`, `Note`, `SaleTaxInvStatus`, `FBRInvoiceNumber`, `CustomerMobileNumber`, `OrderTypeId`, `TableId`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `TotalQty`) 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); -- -------------------------------------------------------- -- -- Table structure for table `app_pointofsale_sale_order_detail` -- CREATE TABLE `app_pointofsale_sale_order_detail` ( `Id` bigint(20) NOT NULL, `SaleOrderId` bigint(20) DEFAULT NULL, `ProductId` int(11) DEFAULT NULL, `UnitId` int(11) 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) DEFAULT NULL, `DiscountValue` decimal(10,0) DEFAULT NULL, `CategoryId` int(11) DEFAULT NULL, `SubCategoryId` int(11) DEFAULT NULL, `ChildCategoryId` int(11) DEFAULT NULL, `BrandId` int(11) DEFAULT NULL, `PointAward` decimal(10,0) DEFAULT NULL, `PointRedeem` decimal(10,0) DEFAULT NULL, `EmployeeId` int(11) DEFAULT NULL, `Commission` decimal(10,0) DEFAULT NULL, `CommissionValue` decimal(10,0) DEFAULT NULL, `ProjectId` int(11) DEFAULT NULL, `PricePerUnit` decimal(10,0) DEFAULT NULL, `QtyPerUnit` decimal(10,0) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `SyncStatus` int(11) DEFAULT NULL, `AssortmentId` int(11) DEFAULT NULL, `SizeValue` varchar(255) DEFAULT NULL, `SizeRange` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_pointofsale_sale_order_detail` -- INSERT INTO `app_pointofsale_sale_order_detail` (`Id`, `SaleOrderId`, `ProductId`, `UnitId`, `SalePrice`, `PurchasePrice`, `SalePriceSale`, `Quantity`, `SubTotal`, `DiscountAmount`, `TaxAmount`, `TotalAmount`, `DiscountPer`, `DiscountValue`, `CategoryId`, `SubCategoryId`, `ChildCategoryId`, `BrandId`, `PointAward`, `PointRedeem`, `EmployeeId`, `Commission`, `CommissionValue`, `ProjectId`, `PricePerUnit`, `QtyPerUnit`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `SyncStatus`, `AssortmentId`, `SizeValue`, `SizeRange`) 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, '', ''); -- -------------------------------------------------------- -- -- Table structure for table `app_pointofsale_store_expense` -- CREATE TABLE `app_pointofsale_store_expense` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_pointofsale_store_expense` -- INSERT INTO `app_pointofsale_store_expense` (`Id`, `Code`, `Name`, `Description`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, '01', 'Fuel', 'Fuel', 1, 1, '2024-03-31 22:11:03', NULL, NULL), (2, '45', 'updare', 'fghf', 1, 1, '2024-04-02 11:30:31', 1, '2024-04-06 07:48:10'); -- -------------------------------------------------------- -- -- Table structure for table `app_pos_branch` -- CREATE TABLE `app_pos_branch` ( `Id` int(11) NOT NULL, `Name` varchar(255) DEFAULT NULL, `Address` text DEFAULT NULL, `Code` varchar(255) DEFAULT NULL, `FBRPOSId` varchar(255) DEFAULT NULL, `CompanyId` int(11) DEFAULT NULL, `PhoneNoOne` varchar(255) DEFAULT NULL, `PhoneNoTwo` varchar(255) DEFAULT NULL, `EmailAddress` varchar(255) DEFAULT NULL, `Logo` text DEFAULT NULL, `BranchTypeId` int(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `Currency` varchar(255) DEFAULT NULL, `CurrencyCode` varchar(255) DEFAULT NULL, `CurrencySymbol` varchar(255) DEFAULT NULL, `AllowDiscount` int(11) DEFAULT 0, `MaximumDiscount` decimal(10,0) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_pos_branch` -- INSERT INTO `app_pos_branch` (`Id`, `Name`, `Address`, `Code`, `FBRPOSId`, `CompanyId`, `PhoneNoOne`, `PhoneNoTwo`, `EmailAddress`, `Logo`, `BranchTypeId`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedDate`, `ModifiedBy`, `Currency`, `CurrencyCode`, `CurrencySymbol`, `AllowDiscount`, `MaximumDiscount`) 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, NULL, NULL, NULL, NULL, NULL, 0, 0), (2, 'Dubai Branch', 'up add', '02', '12233 up', 1, '343435545fd', '4545', 'gba@gmail.com', 'otherimages/120240620070119admission-open.jpg', 1, 1, 1, '2024-06-20 06:39:41', '2024-06-20 07:44:24', 1, 'Dollars', 'USD', '$', 1, 10); -- -------------------------------------------------------- -- -- Table structure for table `app_pos_daily_expense` -- CREATE TABLE `app_pos_daily_expense` ( `Id` bigint(20) NOT NULL, `ExpenseId` int(11) DEFAULT NULL, `Amount` decimal(10,0) DEFAULT NULL, `ExpenseDate` date DEFAULT NULL, `RefNo` varchar(1000) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModififedBy` int(11) DEFAULT NULL, `BranchId` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_pos_daily_expense` -- INSERT INTO `app_pos_daily_expense` (`Id`, `ExpenseId`, `Amount`, `ExpenseDate`, `RefNo`, `Description`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModififedBy`, `BranchId`) VALUES (1, 1, 2000, '2024-04-09', '2323', 'descupdate', 1, '2024-04-08 11:37:26', 1, '2024-04-08 11:56:15', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `app_setting_branch_type` -- CREATE TABLE `app_setting_branch_type` ( `Id` int(11) NOT NULL, `Name` varchar(255) DEFAULT NULL, `Code` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_setting_branch_type` -- INSERT INTO `app_setting_branch_type` (`Id`, `Name`, `Code`, `Description`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 'Retail', '01', 'Retail', 1, 1, NULL, NULL, NULL), (2, 'WholeSale', '02', 'WholeSale', 1, 1, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `app_setting_company` -- CREATE TABLE `app_setting_company` ( `Id` int(11) NOT NULL, `Name` varchar(255) DEFAULT NULL, `ContactPersonName` varchar(255) DEFAULT NULL, `Logo` text DEFAULT NULL, `PhoneNumberOne` varchar(40) DEFAULT NULL, `PhoneNumberTwo` varchar(40) DEFAULT NULL, `MobileNumberOne` varchar(40) DEFAULT NULL, `MobileNumberTwo` varchar(40) DEFAULT NULL, `EmailAddress` int(255) DEFAULT NULL, `AddressOne` text DEFAULT NULL, `FaxNumber` varchar(30) DEFAULT NULL, `NtnNumber` varchar(30) DEFAULT NULL, `StrnNumber` varchar(30) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `app_setting_company` -- INSERT INTO `app_setting_company` (`Id`, `Name`, `ContactPersonName`, `Logo`, `PhoneNumberOne`, `PhoneNumberTwo`, `MobileNumberOne`, `MobileNumberTwo`, `EmailAddress`, `AddressOne`, `FaxNumber`, `NtnNumber`, `StrnNumber`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 'ABC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `area` -- CREATE TABLE `area` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `CityId` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `area` -- INSERT INTO `area` (`Id`, `Code`, `Name`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `CityId`, `created_at`, `updated_at`) VALUES (1, '01', 'Iqbal Town', 1, '2023-10-03 07:09:24', 0, '2023-10-03 07:14:08', 0, 1, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `attribute` -- CREATE TABLE `attribute` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `NameUr` varchar(255) DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `attribute` -- INSERT INTO `attribute` (`Id`, `Code`, `Name`, `NameUr`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, '01', 'Color', 'دسفدسف', 1, '2023-09-26 07:36:51', 0, '2024-04-27 12:37:05', 0, NULL, NULL), (3, '01', 'Pending', NULL, 1, '2023-09-26 09:24:49', 0, NULL, 0, NULL, NULL), (5, '05', 'سایذ', NULL, 1, '2023-12-21 06:44:44', 0, '2024-03-17 14:29:30', 0, NULL, NULL), (6, '34', 'کلر', NULL, 1, '2024-03-17 14:25:00', 0, NULL, 0, NULL, NULL), (7, '34', 'size', 'سائز', 1, '2024-04-26 15:44:08', 0, NULL, 0, NULL, NULL), (8, 'AC-0000008', 'dsf', 'سدفسف', 1, '2024-04-27 13:06:33', 0, NULL, 0, NULL, NULL), (9, 'AC-0000009', 'dsfds', 'سدفدسف', 1, '2024-05-04 16:09:07', 0, NULL, 0, NULL, NULL), (10, 'AC-0000010', 'update', 'گفھگفھگف', 1, '2024-05-04 16:09:17', 0, '2024-05-04 16:09:31', 0, NULL, NULL), (11, '3e43', 'Na', 'Na', 1, '2024-06-07 05:12:07', 1, NULL, 0, NULL, NULL), (12, '3e43', 'Na', 'Na', 1, '2024-06-07 05:12:12', 1, NULL, 0, NULL, NULL), (13, '3e43', 'sdf', 'sdf', 1, '2024-06-07 05:16:12', 1, NULL, 0, NULL, NULL), (14, '3e43', 'sdf', 'sdf', 1, '2024-06-07 09:11:58', 1, NULL, 0, NULL, NULL), (15, 'cdee', 'nab', 'nab', 1, '2024-06-07 09:16:26', 1, NULL, 0, NULL, NULL), (16, 'fdgdfg', 'test', 'test', 1, '2024-06-07 09:17:03', 1, NULL, 0, NULL, NULL), (17, 'sdfsdf', 'dsf', 'dsf', 1, '2024-06-07 09:35:08', 1, NULL, 0, NULL, NULL), (18, 'gsfdg', 'fdgfds', 'fdgfds', 1, '2024-06-07 09:41:39', 1, NULL, 0, NULL, NULL), (19, 'gsfdg', 'fdgfds', 'fdgfds', 1, '2024-06-07 09:41:40', 1, NULL, 0, NULL, NULL), (20, 'sdfsdf', 'sdf', 'sdf', 1, '2024-06-07 09:46:11', 1, NULL, 0, NULL, NULL), (21, 'dfgf', 'dfgdfg', 'dfgdfg', 1, '2024-06-07 09:46:26', 1, NULL, 0, NULL, NULL), (22, 'dfgfdg', 'fdgfdg', 'fdgfdg', 1, '2024-06-07 09:55:53', 1, NULL, 0, NULL, NULL), (23, 'fdgfdg', 'fdgfdg', 'fdgfdg', 1, '2024-06-07 09:57:23', 1, NULL, 0, NULL, NULL), (24, 'fdgfdg', 'gffdsgf', 'gffdsgf', 1, '2024-06-07 10:02:14', 1, NULL, 0, NULL, NULL), (25, '02121', 'Nab', 'Nab', 1, '2024-06-07 10:04:33', 1, NULL, 0, NULL, NULL), (26, 'gdfg', 'dfg', 'dfg', 1, '2024-06-07 10:04:53', 1, NULL, 0, NULL, NULL), (27, 'dfgfdg', 'dfg', 'dfg', 1, '2024-06-07 10:04:59', 1, NULL, 0, NULL, NULL), (28, 'AC-0000028', 'dfsgfdg', 'فدگدفگفگ', 1, '2024-06-07 10:05:31', 1, NULL, 0, NULL, NULL), (29, 'fghgfh', 'sdfgfdg', 'sdfgfdg', 1, '2024-06-07 10:05:36', 1, NULL, 0, NULL, NULL), (30, 'AC-0000030', 'sgdfg', 'فدسگھفدگفدگ', 1, '2024-06-07 10:05:55', 1, NULL, 0, NULL, NULL), (31, 'jhgfjhgj', 'test', 'test', 1, '2024-06-07 10:06:10', 1, NULL, 0, NULL, NULL), (32, '05we', 'ner', 'ner', 1, '2024-06-07 12:16:43', 1, NULL, 0, NULL, NULL), (33, 'AC-0000033', 'dfdf', NULL, 1, '2024-06-11 10:15:56', 1, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `banktransfer` -- CREATE TABLE `banktransfer` ( `Id` int(11) NOT NULL, `BankName` varchar(1000) DEFAULT NULL, `AccountHolder` varchar(1000) DEFAULT NULL, `AccountNumber` varchar(1000) DEFAULT NULL, `IBAN` varchar(1000) DEFAULT NULL, `SWIFTBIC` varchar(1000) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `blog` -- CREATE TABLE `blog` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `blogcategory` -- CREATE TABLE `blogcategory` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `brand` -- CREATE TABLE `brand` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `NameUr` varchar(255) DEFAULT NULL, `Icon` varchar(255) DEFAULT NULL, `Description` longtext DEFAULT NULL, `Picture` text DEFAULT NULL, `Slug` text DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `SellerId` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `brand` -- INSERT INTO `brand` (`Id`, `Code`, `Name`, `NameUr`, `Icon`, `Description`, `Picture`, `Slug`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `SellerId`, `created_at`, `updated_at`) VALUES (1, '01', 'Lee Theme', NULL, NULL, NULL, 'brandpicture/020240121053956our-logo-five.png', 'lee-theme', 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', 'shopify', 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', 'sino-slog', 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', 'wordpress', 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', 'rimbus', 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-03-17 11:45:04', 1, 0, NULL, NULL), (17, '45', '4rgsdg', NULL, NULL, 'dfdg', 'brandpicture/120240317114125Aem POS Logo (1).png', NULL, 1, '2024-03-17 11:41:24', 1, NULL, 0, 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); -- -------------------------------------------------------- -- -- Table structure for table `campaign` -- CREATE TABLE `campaign` ( `Id` int(10) UNSIGNED NOT NULL, `Name` varchar(255) NOT NULL, `Slug` varchar(255) NOT NULL, `Title` varchar(255) NOT NULL, `Offer` double NOT NULL, `StartDateTime` datetime DEFAULT NULL, `EndDateTime` datetime DEFAULT NULL, `ShowHomePage` smallint(6) NOT NULL DEFAULT 0, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `Picture` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `campaign` -- INSERT INTO `campaign` (`Id`, `Name`, `Slug`, `Title`, `Offer`, `StartDateTime`, `EndDateTime`, `ShowHomePage`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `Picture`, `created_at`, `updated_at`) VALUES (1, 'asdf', 'sdf', 'sdf', 34, '2024-01-06 21:10:00', '2024-01-06 21:10:00', 0, 1, '2024-01-06 16:11:46', 0, NULL, 0, '', NULL, NULL), (2, 'sdfs fsdf', 'sdfs-fsdf', 'dfdf', 33, '2024-01-06 21:17:00', '2024-01-06 21:17:00', 0, 0, '2024-01-06 16:17:54', 0, NULL, 0, 'campaignpicture/020240106161755sso.jpeg', NULL, NULL), (3, 'New Camp', 'new-camp', 'New Camp', 20, '2024-02-05 11:12:00', '2024-02-22 11:12:00', 0, 1, '2024-02-05 06:12:40', 0, NULL, 0, 'campaignpicture/020240205061241images.jpeg', NULL, NULL), (4, 'ds', 'ds', 'dsd', 34, '2024-02-05 11:18:00', '2024-02-05 11:18:00', 0, 1, '2024-02-05 06:18:08', 0, NULL, 0, 'campaignpicture/020240205061808images.jpeg', NULL, NULL), (5, 'test camp', 'test-camp', 'tes', 20, '2024-02-05 13:59:00', '2024-02-05 13:59:00', 1, 1, '2024-02-05 08:59:35', 0, NULL, 0, 'campaignpicture/020240205085935images.jpeg', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `campaignproduct` -- CREATE TABLE `campaignproduct` ( `Id` int(10) UNSIGNED NOT NULL, `CampaignId` int(11) NOT NULL DEFAULT 0, `ProductId` int(11) NOT NULL DEFAULT 0, `ShowHomePage` smallint(6) NOT NULL DEFAULT 0, `DiscOfferPer` float NOT NULL DEFAULT 0, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `campaignproduct` -- INSERT INTO `campaignproduct` (`Id`, `CampaignId`, `ProductId`, `ShowHomePage`, `DiscOfferPer`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 1, 13, 0, 50, 1, NULL, 0, NULL, 0, NULL, NULL), (2, 1, 14, 0, 20, 1, NULL, 0, NULL, 0, NULL, NULL), (3, 5, 13, 1, 20, 0, '2024-02-05 08:59:35', 0, NULL, 0, NULL, NULL), (4, 5, 13, 1, 20, 0, '2024-02-05 08:59:35', 0, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `NameUr` varchar(255) DEFAULT NULL, `Icon` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Picture` text DEFAULT NULL, `Slug` text DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `ParentCategoryId` int(11) NOT NULL DEFAULT -1, `SellerId` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `category` -- INSERT INTO `category` (`Id`, `Code`, `Name`, `NameUr`, `Icon`, `Description`, `Picture`, `Slug`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `ParentCategoryId`, `SellerId`, `created_at`, `updated_at`) 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); -- -------------------------------------------------------- -- -- Table structure for table `city` -- CREATE TABLE `city` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `StateId` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `city` -- INSERT INTO `city` (`Id`, `Code`, `Name`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `StateId`, `created_at`, `updated_at`) VALUES (1, '01', 'Lahore', 1, '2023-10-02 14:25:59', 0, '2023-10-02 14:36:05', 0, 1, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `contactus` -- CREATE TABLE `contactus` ( `Id` int(10) UNSIGNED NOT NULL, `Country` varchar(255) DEFAULT NULL, `Name` varchar(255) NOT NULL, `EmailAddress` varchar(255) DEFAULT NULL, `Subject` text DEFAULT NULL, `Description` text DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `MobileNumber` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `contactus` -- INSERT INTO `contactus` (`Id`, `Country`, `Name`, `EmailAddress`, `Subject`, `Description`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`, `MobileNumber`) VALUES (28, NULL, 'Nabeel Bin Ezad', 'nabeel.ezad@gmail.com', 'dsfa', 'sdfdsf', 1, '2024-02-23 19:17:52', 0, NULL, 0, NULL, NULL, '03244492569'), (29, NULL, 'Nabeel Bin Ezad', 'nabeel.ezad@gmail.com', 'dsfds', 'sfsdfdsf', 1, '2024-02-23 19:20:38', 0, NULL, 0, NULL, NULL, '03244492569'), (30, NULL, 'Nabeel Bin Ezad', 'nabeel.ezad@gmail.com', 'tete', 'dgdgdg', 1, '2024-02-23 19:31:47', 0, NULL, 0, NULL, NULL, '03244492569'), (31, NULL, 'Nabeel Bin Ezad', 'nabeel.ezad@gmail.com', 'tete', 'dgdgdg', 1, '2024-02-23 19:35:22', 0, NULL, 0, NULL, NULL, '03244492569'), (32, NULL, 'Nabeel Bin Ezad', 'nabeel.ezad@gmail.com', 'tete', 'dgdgdg', 1, '2024-02-23 19:36:13', 0, NULL, 0, NULL, NULL, '03244492569'), (33, NULL, 'Nabeel Bin Ezad', 'nabeel.ezad@gmail.com', 'test email', 'sddsfd', 1, '2024-02-23 19:37:30', 0, NULL, 0, NULL, NULL, '03244492569'); -- -------------------------------------------------------- -- -- Table structure for table `contactusreply` -- CREATE TABLE `contactusreply` ( `Id` int(10) UNSIGNED NOT NULL, `Country` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `EmailAddress` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `ReplyContactUsId` int(11) 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; -- -------------------------------------------------------- -- -- Table structure for table `country` -- CREATE TABLE `country` ( `Id` int(10) UNSIGNED NOT NULL, `iso` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `nicename` varchar(1000) DEFAULT NULL, `iso3` varchar(255) DEFAULT NULL, `numcode` varchar(255) DEFAULT NULL, `phonecode` varchar(255) DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `country` -- INSERT INTO `country` (`Id`, `iso`, `Name`, `nicename`, `iso3`, `numcode`, `phonecode`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 'AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', '4', '93', 1, NULL, 0, NULL, 0, NULL, NULL), (2, 'AL', 'ALBANIA', 'Albania', 'ALB', '8', '355', 1, NULL, 0, NULL, 0, NULL, NULL), (3, 'DZ', 'ALGERIA', 'Algeria', 'DZA', '12', '213', 1, NULL, 0, NULL, 0, NULL, NULL), (4, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', '16', '1684', 1, NULL, 0, NULL, 0, NULL, NULL), (5, 'AD', 'ANDORRA', 'Andorra', 'AND', '20', '376', 1, NULL, 0, NULL, 0, NULL, NULL), (6, 'AO', 'ANGOLA', 'Angola', 'AGO', '24', '244', 1, NULL, 0, NULL, 0, NULL, NULL), (7, 'AI', 'ANGUILLA', 'Anguilla', 'AIA', '660', '1264', 1, NULL, 0, NULL, 0, NULL, NULL), (8, 'AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL, '0', 1, NULL, 0, NULL, 0, NULL, NULL), (9, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', '28', '1268', 1, NULL, 0, NULL, 0, NULL, NULL), (10, 'AR', 'ARGENTINA', 'Argentina', 'ARG', '32', '54', 1, NULL, 0, NULL, 0, NULL, NULL), (11, 'AM', 'ARMENIA', 'Armenia', 'ARM', '51', '374', 1, NULL, 0, NULL, 0, NULL, NULL), (12, 'AW', 'ARUBA', 'Aruba', 'ABW', '533', '297', 1, NULL, 0, NULL, 0, NULL, NULL), (13, 'AU', 'AUSTRALIA', 'Australia', 'AUS', '36', '61', 1, NULL, 0, NULL, 0, NULL, NULL), (14, 'AT', 'AUSTRIA', 'Austria', 'AUT', '40', '43', 1, NULL, 0, NULL, 0, NULL, NULL), (15, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', '31', '994', 1, NULL, 0, NULL, 0, NULL, NULL), (16, 'BS', 'BAHAMAS', 'Bahamas', 'BHS', '44', '1242', 1, NULL, 0, NULL, 0, NULL, NULL), (17, 'BH', 'BAHRAIN', 'Bahrain', 'BHR', '48', '973', 1, NULL, 0, NULL, 0, NULL, NULL), (18, 'BD', 'BANGLADESH', 'Bangladesh', 'BGD', '50', '880', 1, NULL, 0, NULL, 0, NULL, NULL), (19, 'BB', 'BARBADOS', 'Barbados', 'BRB', '52', '1246', 1, NULL, 0, NULL, 0, NULL, NULL), (20, 'BY', 'BELARUS', 'Belarus', 'BLR', '112', '375', 1, NULL, 0, NULL, 0, NULL, NULL), (21, 'BE', 'BELGIUM', 'Belgium', 'BEL', '56', '32', 1, NULL, 0, NULL, 0, NULL, NULL), (22, 'BZ', 'BELIZE', 'Belize', 'BLZ', '84', '501', 1, NULL, 0, NULL, 0, NULL, NULL), (23, 'BJ', 'BENIN', 'Benin', 'BEN', '204', '229', 1, NULL, 0, NULL, 0, NULL, NULL), (24, 'BM', 'BERMUDA', 'Bermuda', 'BMU', '60', '1441', 1, NULL, 0, NULL, 0, NULL, NULL), (25, 'BT', 'BHUTAN', 'Bhutan', 'BTN', '64', '975', 1, NULL, 0, NULL, 0, NULL, NULL), (26, 'BO', 'BOLIVIA', 'Bolivia', 'BOL', '68', '591', 1, NULL, 0, NULL, 0, NULL, NULL), (27, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', '70', '387', 1, NULL, 0, NULL, 0, NULL, NULL), (28, 'BW', 'BOTSWANA', 'Botswana', 'BWA', '72', '267', 1, NULL, 0, NULL, 0, NULL, NULL), (29, 'BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, '0', 1, NULL, 0, NULL, 0, NULL, NULL), (30, 'BR', 'BRAZIL', 'Brazil', 'BRA', '76', '55', 1, NULL, 0, NULL, 0, NULL, NULL), (31, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL, '246', 1, NULL, 0, NULL, 0, NULL, NULL), (32, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', '96', '673', 1, NULL, 0, NULL, 0, NULL, NULL), (33, 'BG', 'BULGARIA', 'Bulgaria', 'BGR', '100', '359', 1, NULL, 0, NULL, 0, NULL, NULL), (34, 'BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', '854', '226', 1, NULL, 0, NULL, 0, NULL, NULL), (35, 'BI', 'BURUNDI', 'Burundi', 'BDI', '108', '257', 1, NULL, 0, NULL, 0, NULL, NULL), (36, 'KH', 'CAMBODIA', 'Cambodia', 'KHM', '116', '855', 1, NULL, 0, NULL, 0, NULL, NULL), (37, 'CM', 'CAMEROON', 'Cameroon', 'CMR', '120', '237', 1, NULL, 0, NULL, 0, NULL, NULL), (38, 'CA', 'CANADA', 'Canada', 'CAN', '124', '1', 1, NULL, 0, NULL, 0, NULL, NULL), (39, 'CV', 'CAPE VERDE', 'Cape Verde', 'CPV', '132', '238', 1, NULL, 0, NULL, 0, NULL, NULL), (40, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', '136', '1345', 1, NULL, 0, NULL, 0, NULL, NULL), (41, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', '140', '236', 1, NULL, 0, NULL, 0, NULL, NULL), (42, 'TD', 'CHAD', 'Chad', 'TCD', '148', '235', 1, NULL, 0, NULL, 0, NULL, NULL), (43, 'CL', 'CHILE', 'Chile', 'CHL', '152', '56', 1, NULL, 0, NULL, 0, NULL, NULL), (44, 'CN', 'CHINA', 'China', 'CHN', '156', '86', 1, NULL, 0, NULL, 0, NULL, NULL), (45, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, '61', 1, NULL, 0, NULL, 0, NULL, NULL), (46, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, '672', 1, NULL, 0, NULL, 0, NULL, NULL), (47, 'CO', 'COLOMBIA', 'Colombia', 'COL', '170', '57', 1, NULL, 0, NULL, 0, NULL, NULL), (48, 'KM', 'COMOROS', 'Comoros', 'COM', '174', '269', 1, NULL, 0, NULL, 0, NULL, NULL), (49, 'CG', 'CONGO', 'Congo', 'COG', '178', '242', 1, NULL, 0, NULL, 0, NULL, NULL), (50, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', '180', '242', 1, NULL, 0, NULL, 0, NULL, NULL), (51, 'CK', 'COOK ISLANDS', 'Cook Islands', 'COK', '184', '682', 1, NULL, 0, NULL, 0, NULL, NULL), (52, 'CR', 'COSTA RICA', 'Costa Rica', 'CRI', '188', '506', 1, NULL, 0, NULL, 0, NULL, NULL), (53, 'CI', 'COTE D\'IVOIRE', 'Cote D\'Ivoire', 'CIV', '384', '225', 1, NULL, 0, NULL, 0, NULL, NULL), (54, 'HR', 'CROATIA', 'Croatia', 'HRV', '191', '385', 1, NULL, 0, NULL, 0, NULL, NULL), (55, 'CU', 'CUBA', 'Cuba', 'CUB', '192', '53', 1, NULL, 0, NULL, 0, NULL, NULL), (56, 'CY', 'CYPRUS', 'Cyprus', 'CYP', '196', '357', 1, NULL, 0, NULL, 0, NULL, NULL), (57, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', '203', '420', 1, NULL, 0, NULL, 0, NULL, NULL), (58, 'DK', 'DENMARK', 'Denmark', 'DNK', '208', '45', 1, NULL, 0, NULL, 0, NULL, NULL), (59, 'DJ', 'DJIBOUTI', 'Djibouti', 'DJI', '262', '253', 1, NULL, 0, NULL, 0, NULL, NULL), (60, 'DM', 'DOMINICA', 'Dominica', 'DMA', '212', '1767', 1, NULL, 0, NULL, 0, NULL, NULL), (61, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', '214', '1809', 1, NULL, 0, NULL, 0, NULL, NULL), (62, 'EC', 'ECUADOR', 'Ecuador', 'ECU', '218', '593', 1, NULL, 0, NULL, 0, NULL, NULL), (63, 'EG', 'EGYPT', 'Egypt', 'EGY', '818', '20', 1, NULL, 0, NULL, 0, NULL, NULL), (64, 'SV', 'EL SALVADOR', 'El Salvador', 'SLV', '222', '503', 1, NULL, 0, NULL, 0, NULL, NULL), (65, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', '226', '240', 1, NULL, 0, NULL, 0, NULL, NULL), (66, 'ER', 'ERITREA', 'Eritrea', 'ERI', '232', '291', 1, NULL, 0, NULL, 0, NULL, NULL), (67, 'EE', 'ESTONIA', 'Estonia', 'EST', '233', '372', 1, NULL, 0, NULL, 0, NULL, NULL), (68, 'ET', 'ETHIOPIA', 'Ethiopia', 'ETH', '231', '251', 1, NULL, 0, NULL, 0, NULL, NULL), (69, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', '238', '500', 1, NULL, 0, NULL, 0, NULL, NULL), (70, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', '234', '298', 1, NULL, 0, NULL, 0, NULL, NULL), (71, 'FJ', 'FIJI', 'Fiji', 'FJI', '242', '679', 1, NULL, 0, NULL, 0, NULL, NULL), (72, 'FI', 'FINLAND', 'Finland', 'FIN', '246', '358', 1, NULL, 0, NULL, 0, NULL, NULL), (73, 'FR', 'FRANCE', 'France', 'FRA', '250', '33', 1, NULL, 0, NULL, 0, NULL, NULL), (74, 'GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', '254', '594', 1, NULL, 0, NULL, 0, NULL, NULL), (75, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', '258', '689', 1, NULL, 0, NULL, 0, NULL, NULL), (76, 'TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, '0', 1, NULL, 0, NULL, 0, NULL, NULL), (77, 'GA', 'GABON', 'Gabon', 'GAB', '266', '241', 1, NULL, 0, NULL, 0, NULL, NULL), (78, 'GM', 'GAMBIA', 'Gambia', 'GMB', '270', '220', 1, NULL, 0, NULL, 0, NULL, NULL), (79, 'GE', 'GEORGIA', 'Georgia', 'GEO', '268', '995', 1, NULL, 0, NULL, 0, NULL, NULL), (80, 'DE', 'GERMANY', 'Germany', 'DEU', '276', '49', 1, NULL, 0, NULL, 0, NULL, NULL), (81, 'GH', 'GHANA', 'Ghana', 'GHA', '288', '233', 1, NULL, 0, NULL, 0, NULL, NULL), (82, 'GI', 'GIBRALTAR', 'Gibraltar', 'GIB', '292', '350', 1, NULL, 0, NULL, 0, NULL, NULL), (83, 'GR', 'GREECE', 'Greece', 'GRC', '300', '30', 1, NULL, 0, NULL, 0, NULL, NULL), (84, 'GL', 'GREENLAND', 'Greenland', 'GRL', '304', '299', 1, NULL, 0, NULL, 0, NULL, NULL), (85, 'GD', 'GRENADA', 'Grenada', 'GRD', '308', '1473', 1, NULL, 0, NULL, 0, NULL, NULL), (86, 'GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', '312', '590', 1, NULL, 0, NULL, 0, NULL, NULL), (87, 'GU', 'GUAM', 'Guam', 'GUM', '316', '1671', 1, NULL, 0, NULL, 0, NULL, NULL), (88, 'GT', 'GUATEMALA', 'Guatemala', 'GTM', '320', '502', 1, NULL, 0, NULL, 0, NULL, NULL), (89, 'GN', 'GUINEA', 'Guinea', 'GIN', '324', '224', 1, NULL, 0, NULL, 0, NULL, NULL), (90, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', '624', '245', 1, NULL, 0, NULL, 0, NULL, NULL), (91, 'GY', 'GUYANA', 'Guyana', 'GUY', '328', '592', 1, NULL, 0, NULL, 0, NULL, NULL), (92, 'HT', 'HAITI', 'Haiti', 'HTI', '332', '509', 1, NULL, 0, NULL, 0, NULL, NULL), (93, 'HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL, '0', 1, NULL, 0, NULL, 0, NULL, NULL), (94, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', '336', '39', 1, NULL, 0, NULL, 0, NULL, NULL), (95, 'HN', 'HONDURAS', 'Honduras', 'HND', '340', '504', 1, NULL, 0, NULL, 0, NULL, NULL), (96, 'HK', 'HONG KONG', 'Hong Kong', 'HKG', '344', '852', 1, NULL, 0, NULL, 0, NULL, NULL), (97, 'HU', 'HUNGARY', 'Hungary', 'HUN', '348', '36', 1, NULL, 0, NULL, 0, NULL, NULL), (98, 'IS', 'ICELAND', 'Iceland', 'ISL', '352', '354', 1, NULL, 0, NULL, 0, NULL, NULL), (99, 'IN', 'INDIA', 'India', 'IND', '356', '91', 1, NULL, 0, NULL, 0, NULL, NULL), (100, 'ID', 'INDONESIA', 'Indonesia', 'IDN', '360', '62', 1, NULL, 0, NULL, 0, NULL, NULL), (101, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', '364', '98', 1, NULL, 0, NULL, 0, NULL, NULL), (102, 'IQ', 'IRAQ', 'Iraq', 'IRQ', '368', '964', 1, NULL, 0, NULL, 0, NULL, NULL), (103, 'IE', 'IRELAND', 'Ireland', 'IRL', '372', '353', 1, NULL, 0, NULL, 0, NULL, NULL), (104, 'IL', 'ISRAEL', 'Israel', 'ISR', '376', '972', 1, NULL, 0, NULL, 0, NULL, NULL), (105, 'IT', 'ITALY', 'Italy', 'ITA', '380', '39', 1, NULL, 0, NULL, 0, NULL, NULL), (106, 'JM', 'JAMAICA', 'Jamaica', 'JAM', '388', '1876', 1, NULL, 0, NULL, 0, NULL, NULL), (107, 'JP', 'JAPAN', 'Japan', 'JPN', '392', '81', 1, NULL, 0, NULL, 0, NULL, NULL), (108, 'JO', 'JORDAN', 'Jordan', 'JOR', '400', '962', 1, NULL, 0, NULL, 0, NULL, NULL), (109, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', '398', '7', 1, NULL, 0, NULL, 0, NULL, NULL), (110, 'KE', 'KENYA', 'Kenya', 'KEN', '404', '254', 1, NULL, 0, NULL, 0, NULL, NULL), (111, 'KI', 'KIRIBATI', 'Kiribati', 'KIR', '296', '686', 1, NULL, 0, NULL, 0, NULL, NULL), (112, 'KP', 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 'Korea, Democratic People\'s Republic of', 'PRK', '408', '850', 1, NULL, 0, NULL, 0, NULL, NULL), (113, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', '410', '82', 1, NULL, 0, NULL, 0, NULL, NULL), (114, 'KW', 'KUWAIT', 'Kuwait', 'KWT', '414', '965', 1, NULL, 0, NULL, 0, NULL, NULL), (115, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', '417', '996', 1, NULL, 0, NULL, 0, NULL, NULL), (116, 'LA', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 'Lao People\'s Democratic Republic', 'LAO', '418', '856', 1, NULL, 0, NULL, 0, NULL, NULL), (117, 'LV', 'LATVIA', 'Latvia', 'LVA', '428', '371', 1, NULL, 0, NULL, 0, NULL, NULL), (118, 'LB', 'LEBANON', 'Lebanon', 'LBN', '422', '961', 1, NULL, 0, NULL, 0, NULL, NULL), (119, 'LS', 'LESOTHO', 'Lesotho', 'LSO', '426', '266', 1, NULL, 0, NULL, 0, NULL, NULL), (120, 'LR', 'LIBERIA', 'Liberia', 'LBR', '430', '231', 1, NULL, 0, NULL, 0, NULL, NULL), (121, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', '434', '218', 1, NULL, 0, NULL, 0, NULL, NULL), (122, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', '438', '423', 1, NULL, 0, NULL, 0, NULL, NULL), (123, 'LT', 'LITHUANIA', 'Lithuania', 'LTU', '440', '370', 1, NULL, 0, NULL, 0, NULL, NULL), (124, 'LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', '442', '352', 1, NULL, 0, NULL, 0, NULL, NULL), (125, 'MO', 'MACAO', 'Macao', 'MAC', '446', '853', 1, NULL, 0, NULL, 0, NULL, NULL), (126, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', '807', '389', 1, NULL, 0, NULL, 0, NULL, NULL), (127, 'MG', 'MADAGASCAR', 'Madagascar', 'MDG', '450', '261', 1, NULL, 0, NULL, 0, NULL, NULL), (128, 'MW', 'MALAWI', 'Malawi', 'MWI', '454', '265', 1, NULL, 0, NULL, 0, NULL, NULL), (129, 'MY', 'MALAYSIA', 'Malaysia', 'MYS', '458', '60', 1, NULL, 0, NULL, 0, NULL, NULL), (130, 'MV', 'MALDIVES', 'Maldives', 'MDV', '462', '960', 1, NULL, 0, NULL, 0, NULL, NULL), (131, 'ML', 'MALI', 'Mali', 'MLI', '466', '223', 1, NULL, 0, NULL, 0, NULL, NULL), (132, 'MT', 'MALTA', 'Malta', 'MLT', '470', '356', 1, NULL, 0, NULL, 0, NULL, NULL), (133, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', '584', '692', 1, NULL, 0, NULL, 0, NULL, NULL), (134, 'MQ', 'MARTINIQUE', 'Martinique', 'MTQ', '474', '596', 1, NULL, 0, NULL, 0, NULL, NULL), (135, 'MR', 'MAURITANIA', 'Mauritania', 'MRT', '478', '222', 1, NULL, 0, NULL, 0, NULL, NULL), (136, 'MU', 'MAURITIUS', 'Mauritius', 'MUS', '480', '230', 1, NULL, 0, NULL, 0, NULL, NULL), (137, 'YT', 'MAYOTTE', 'Mayotte', NULL, NULL, '269', 1, NULL, 0, NULL, 0, NULL, NULL), (138, 'MX', 'MEXICO', 'Mexico', 'MEX', '484', '52', 1, NULL, 0, NULL, 0, NULL, NULL), (139, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', '583', '691', 1, NULL, 0, NULL, 0, NULL, NULL), (140, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', '498', '373', 1, NULL, 0, NULL, 0, NULL, NULL), (141, 'MC', 'MONACO', 'Monaco', 'MCO', '492', '377', 1, NULL, 0, NULL, 0, NULL, NULL), (142, 'MN', 'MONGOLIA', 'Mongolia', 'MNG', '496', '976', 1, NULL, 0, NULL, 0, NULL, NULL), (143, 'MS', 'MONTSERRAT', 'Montserrat', 'MSR', '500', '1664', 1, NULL, 0, NULL, 0, NULL, NULL), (144, 'MA', 'MOROCCO', 'Morocco', 'MAR', '504', '212', 1, NULL, 0, NULL, 0, NULL, NULL), (145, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', '508', '258', 1, NULL, 0, NULL, 0, NULL, NULL), (146, 'MM', 'MYANMAR', 'Myanmar', 'MMR', '104', '95', 1, NULL, 0, NULL, 0, NULL, NULL), (147, 'NA', 'NAMIBIA', 'Namibia', 'NAM', '516', '264', 1, NULL, 0, NULL, 0, NULL, NULL), (148, 'NR', 'NAURU', 'Nauru', 'NRU', '520', '674', 1, NULL, 0, NULL, 0, NULL, NULL), (149, 'NP', 'NEPAL', 'Nepal', 'NPL', '524', '977', 1, NULL, 0, NULL, 0, NULL, NULL), (150, 'NL', 'NETHERLANDS', 'Netherlands', 'NLD', '528', '31', 1, NULL, 0, NULL, 0, NULL, NULL), (151, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', '530', '599', 1, NULL, 0, NULL, 0, NULL, NULL), (152, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', '540', '687', 1, NULL, 0, NULL, 0, NULL, NULL), (153, 'NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', '554', '64', 1, NULL, 0, NULL, 0, NULL, NULL), (154, 'NI', 'NICARAGUA', 'Nicaragua', 'NIC', '558', '505', 1, NULL, 0, NULL, 0, NULL, NULL), (155, 'NE', 'NIGER', 'Niger', 'NER', '562', '227', 1, NULL, 0, NULL, 0, NULL, NULL), (156, 'NG', 'NIGERIA', 'Nigeria', 'NGA', '566', '234', 1, NULL, 0, NULL, 0, NULL, NULL), (157, 'NU', 'NIUE', 'Niue', 'NIU', '570', '683', 1, NULL, 0, NULL, 0, NULL, NULL), (158, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', '574', '672', 1, NULL, 0, NULL, 0, NULL, NULL), (159, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', '580', '1670', 1, NULL, 0, NULL, 0, NULL, NULL), (160, 'NO', 'NORWAY', 'Norway', 'NOR', '578', '47', 1, NULL, 0, NULL, 0, NULL, NULL), (161, 'OM', 'OMAN', 'Oman', 'OMN', '512', '968', 1, NULL, 0, NULL, 0, NULL, NULL), (162, 'PK', 'PAKISTAN', 'Pakistan', 'PAK', '586', '92', 1, NULL, 0, NULL, 0, NULL, NULL), (163, 'PW', 'PALAU', 'Palau', 'PLW', '585', '680', 1, NULL, 0, NULL, 0, NULL, NULL), (164, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, '970', 1, NULL, 0, NULL, 0, NULL, NULL), (165, 'PA', 'PANAMA', 'Panama', 'PAN', '591', '507', 1, NULL, 0, NULL, 0, NULL, NULL), (166, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', '598', '675', 1, NULL, 0, NULL, 0, NULL, NULL), (167, 'PY', 'PARAGUAY', 'Paraguay', 'PRY', '600', '595', 1, NULL, 0, NULL, 0, NULL, NULL), (168, 'PE', 'PERU', 'Peru', 'PER', '604', '51', 1, NULL, 0, NULL, 0, NULL, NULL), (169, 'PH', 'PHILIPPINES', 'Philippines', 'PHL', '608', '63', 1, NULL, 0, NULL, 0, NULL, NULL), (170, 'PN', 'PITCAIRN', 'Pitcairn', 'PCN', '612', '0', 1, NULL, 0, NULL, 0, NULL, NULL), (171, 'PL', 'POLAND', 'Poland', 'POL', '616', '48', 1, NULL, 0, NULL, 0, NULL, NULL), (172, 'PT', 'PORTUGAL', 'Portugal', 'PRT', '620', '351', 1, NULL, 0, NULL, 0, NULL, NULL), (173, 'PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', '630', '1787', 1, NULL, 0, NULL, 0, NULL, NULL), (174, 'QA', 'QATAR', 'Qatar', 'QAT', '634', '974', 1, NULL, 0, NULL, 0, NULL, NULL), (175, 'RE', 'REUNION', 'Reunion', 'REU', '638', '262', 1, NULL, 0, NULL, 0, NULL, NULL), (176, 'RO', 'ROMANIA', 'Romania', 'ROM', '642', '40', 1, NULL, 0, NULL, 0, NULL, NULL), (177, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', '643', '70', 1, NULL, 0, NULL, 0, NULL, NULL), (178, 'RW', 'RWANDA', 'Rwanda', 'RWA', '646', '250', 1, NULL, 0, NULL, 0, NULL, NULL), (179, 'SH', 'SAINT HELENA', 'Saint Helena', 'SHN', '654', '290', 1, NULL, 0, NULL, 0, NULL, NULL), (180, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', '659', '1869', 1, NULL, 0, NULL, 0, NULL, NULL), (181, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', '662', '1758', 1, NULL, 0, NULL, 0, NULL, NULL), (182, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', '666', '508', 1, NULL, 0, NULL, 0, NULL, NULL), (183, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', '670', '1784', 1, NULL, 0, NULL, 0, NULL, NULL), (184, 'WS', 'SAMOA', 'Samoa', 'WSM', '882', '684', 1, NULL, 0, NULL, 0, NULL, NULL), (185, 'SM', 'SAN MARINO', 'San Marino', 'SMR', '674', '378', 1, NULL, 0, NULL, 0, NULL, NULL), (186, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', '678', '239', 1, NULL, 0, NULL, 0, NULL, NULL), (187, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', '682', '966', 1, NULL, 0, NULL, 0, NULL, NULL), (188, 'SN', 'SENEGAL', 'Senegal', 'SEN', '686', '221', 1, NULL, 0, NULL, 0, NULL, NULL), (189, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, '381', 1, NULL, 0, NULL, 0, NULL, NULL), (190, 'SC', 'SEYCHELLES', 'Seychelles', 'SYC', '690', '248', 1, NULL, 0, NULL, 0, NULL, NULL), (191, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', '694', '232', 1, NULL, 0, NULL, 0, NULL, NULL), (192, 'SG', 'SINGAPORE', 'Singapore', 'SGP', '702', '65', 1, NULL, 0, NULL, 0, NULL, NULL), (193, 'SK', 'SLOVAKIA', 'Slovakia', 'SVK', '703', '421', 1, NULL, 0, NULL, 0, NULL, NULL), (194, 'SI', 'SLOVENIA', 'Slovenia', 'SVN', '705', '386', 1, NULL, 0, NULL, 0, NULL, NULL), (195, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', '90', '677', 1, NULL, 0, NULL, 0, NULL, NULL), (196, 'SO', 'SOMALIA', 'Somalia', 'SOM', '706', '252', 1, NULL, 0, NULL, 0, NULL, NULL), (197, 'ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', '710', '27', 1, NULL, 0, NULL, 0, NULL, NULL), (198, 'GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL, '0', 1, NULL, 0, NULL, 0, NULL, NULL), (199, 'ES', 'SPAIN', 'Spain', 'ESP', '724', '34', 1, NULL, 0, NULL, 0, NULL, NULL), (200, 'LK', 'SRI LANKA', 'Sri Lanka', 'LKA', '144', '94', 1, NULL, 0, NULL, 0, NULL, NULL), (201, 'SD', 'SUDAN', 'Sudan', 'SDN', '736', '249', 1, NULL, 0, NULL, 0, NULL, NULL), (202, 'SR', 'SURINAME', 'Suriname', 'SUR', '740', '597', 1, NULL, 0, NULL, 0, NULL, NULL), (203, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', '744', '47', 1, NULL, 0, NULL, 0, NULL, NULL), (204, 'SZ', 'SWAZILAND', 'Swaziland', 'SWZ', '748', '268', 1, NULL, 0, NULL, 0, NULL, NULL), (205, 'SE', 'SWEDEN', 'Sweden', 'SWE', '752', '46', 1, NULL, 0, NULL, 0, NULL, NULL), (206, 'CH', 'SWITZERLAND', 'Switzerland', 'CHE', '756', '41', 1, NULL, 0, NULL, 0, NULL, NULL), (207, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', '760', '963', 1, NULL, 0, NULL, 0, NULL, NULL), (208, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', '158', '886', 1, NULL, 0, NULL, 0, NULL, NULL), (209, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', '762', '992', 1, NULL, 0, NULL, 0, NULL, NULL), (210, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', '834', '255', 1, NULL, 0, NULL, 0, NULL, NULL), (211, 'TH', 'THAILAND', 'Thailand', 'THA', '764', '66', 1, NULL, 0, NULL, 0, NULL, NULL), (212, 'TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, '670', 1, NULL, 0, NULL, 0, NULL, NULL), (213, 'TG', 'TOGO', 'Togo', 'TGO', '768', '228', 1, NULL, 0, NULL, 0, NULL, NULL), (214, 'TK', 'TOKELAU', 'Tokelau', 'TKL', '772', '690', 1, NULL, 0, NULL, 0, NULL, NULL), (215, 'TO', 'TONGA', 'Tonga', 'TON', '776', '676', 1, NULL, 0, NULL, 0, NULL, NULL), (216, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', '780', '1868', 1, NULL, 0, NULL, 0, NULL, NULL), (217, 'TN', 'TUNISIA', 'Tunisia', 'TUN', '788', '216', 1, NULL, 0, NULL, 0, NULL, NULL), (218, 'TR', 'TURKEY', 'Turkey', 'TUR', '792', '90', 1, NULL, 0, NULL, 0, NULL, NULL), (219, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', '795', '7370', 1, NULL, 0, NULL, 0, NULL, NULL), (220, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', '796', '1649', 1, NULL, 0, NULL, 0, NULL, NULL), (221, 'TV', 'TUVALU', 'Tuvalu', 'TUV', '798', '688', 1, NULL, 0, NULL, 0, NULL, NULL), (222, 'UG', 'UGANDA', 'Uganda', 'UGA', '800', '256', 1, NULL, 0, NULL, 0, NULL, NULL), (223, 'UA', 'UKRAINE', 'Ukraine', 'UKR', '804', '380', 1, NULL, 0, NULL, 0, NULL, NULL), (224, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', '784', '971', 1, NULL, 0, NULL, 0, NULL, NULL), (225, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', '826', '44', 1, NULL, 0, NULL, 0, NULL, NULL), (226, 'US', 'UNITED STATES', 'United States', 'USA', '840', '1', 1, NULL, 0, NULL, 0, NULL, NULL), (227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, '1', 1, NULL, 0, NULL, 0, NULL, NULL), (228, 'UY', 'URUGUAY', 'Uruguay', 'URY', '858', '598', 1, NULL, 0, NULL, 0, NULL, NULL), (229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', '860', '998', 1, NULL, 0, NULL, 0, NULL, NULL), (230, 'VU', 'VANUATU', 'Vanuatu', 'VUT', '548', '678', 1, NULL, 0, NULL, 0, NULL, NULL), (231, 'VE', 'VENEZUELA', 'Venezuela', 'VEN', '862', '58', 1, NULL, 0, NULL, 0, NULL, NULL), (232, 'VN', 'VIET NAM', 'Viet Nam', 'VNM', '704', '84', 1, NULL, 0, NULL, 0, NULL, NULL), (233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', '92', '1284', 1, NULL, 0, NULL, 0, NULL, NULL), (234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', '850', '1340', 1, NULL, 0, NULL, 0, NULL, NULL), (235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', '876', '681', 1, NULL, 0, NULL, 0, NULL, NULL), (236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', '732', '212', 1, NULL, 0, NULL, 0, NULL, NULL), (237, 'YE', 'YEMEN', 'Yemen', 'YEM', '887', '967', 1, NULL, 0, NULL, 0, NULL, NULL), (238, 'ZM', 'ZAMBIA', 'Zambia', 'ZMB', '894', '260', 1, NULL, 0, NULL, 0, NULL, NULL), (239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', '716', '263', 1, NULL, 0, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `coupon` -- CREATE TABLE `coupon` ( `Id` bigint(20) UNSIGNED NOT NULL, `Name` varchar(255) NOT NULL, `Code` varchar(255) DEFAULT NULL, `NumberOfTime` int(11) DEFAULT NULL, `ExpireDate` datetime DEFAULT NULL, `DiscountPerFlat` varchar(255) DEFAULT NULL, `DiscountValue` double(8,2) DEFAULT NULL, `Status` int(11) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `ApplyQty` int(11) DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `coupon` -- INSERT INTO `coupon` (`Id`, `Name`, `Code`, `NumberOfTime`, `ExpireDate`, `DiscountPerFlat`, `DiscountValue`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `ApplyQty`, `created_at`, `updated_at`) VALUES (1, 'test', '0333', 6, '2024-02-02 00:00:00', 'Percentage', 10.00, 1, '2024-01-28 06:27:36', 0, NULL, 0, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `currency` -- CREATE TABLE `currency` ( `Id` int(11) NOT NULL, `Name` varchar(255) DEFAULT NULL, `Symbol` varchar(255) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) NOT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `currency` -- INSERT INTO `currency` (`Id`, `Name`, `Symbol`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 'USD', '$', 1, 0, NULL, NULL, NULL), (2, 'PKR', 'RS.', 1, 0, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `currencylist` -- CREATE TABLE `currencylist` ( `country` varchar(100) DEFAULT NULL, `currency` varchar(100) DEFAULT NULL, `code` varchar(100) DEFAULT NULL, `symbol` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `currencylist` -- INSERT INTO `currencylist` (`country`, `currency`, `code`, `symbol`) 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', '₹'); -- -------------------------------------------------------- -- -- Table structure for table `customer` -- CREATE TABLE `customer` ( `Id` bigint(20) UNSIGNED NOT NULL, `FirstName` varchar(255) DEFAULT NULL, `LastName` varchar(255) DEFAULT NULL, `EmailAddress` varchar(255) DEFAULT NULL, `Picture` text DEFAULT NULL, `PhoneNo` varchar(30) DEFAULT NULL, `Address` text DEFAULT NULL, `ZipCode` varchar(50) DEFAULT NULL, `CityId` int(11) DEFAULT NULL, `StateId` int(11) DEFAULT NULL, `AreaId` int(11) DEFAULT NULL, `CountryId` int(11) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `UserTypeId` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `FullName` varchar(255) DEFAULT NULL, `UserPassword` varchar(1000) NOT NULL, `DateOfBirth` date DEFAULT NULL, `Gender` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `customer` -- INSERT INTO `customer` (`Id`, `FirstName`, `LastName`, `EmailAddress`, `Picture`, `PhoneNo`, `Address`, `ZipCode`, `CityId`, `StateId`, `AreaId`, `CountryId`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `UserTypeId`, `created_at`, `updated_at`, `FullName`, `UserPassword`, `DateOfBirth`, `Gender`) 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, ''); -- -------------------------------------------------------- -- -- Table structure for table `customerbillinginfo` -- CREATE TABLE `customerbillinginfo` ( `Id` bigint(20) NOT NULL, `CustomerId` bigint(20) DEFAULT NULL, `FirstName` varchar(255) DEFAULT NULL, `LastName` varchar(255) DEFAULT NULL, `Address` longtext DEFAULT NULL, `CountryId` int(11) DEFAULT NULL, `CityId` int(11) DEFAULT NULL, `MobileNo` varchar(255) DEFAULT NULL, `PostalCode` varchar(30) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `customerbillinginfo` -- INSERT INTO `customerbillinginfo` (`Id`, `CustomerId`, `FirstName`, `LastName`, `Address`, `CountryId`, `CityId`, `MobileNo`, `PostalCode`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 1, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore update', 1, 1, '03244492569', NULL, 1, 0, '2024-01-29 12:31:06', 0, '2024-02-04 10:09:54'); -- -------------------------------------------------------- -- -- Table structure for table `customerresidancetype` -- CREATE TABLE `customerresidancetype` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `NameUr` varchar(25) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `customerresidancetype` -- INSERT INTO `customerresidancetype` (`Id`, `Code`, `Name`, `NameUr`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, '01', 'Owner House', 'مالک مکان', 1, NULL, NULL, NULL, NULL), (2, '02', 'Shopkeeper', 'دکاندار', 1, NULL, NULL, NULL, NULL), (3, '02', 'Mortgage', 'گروی', 1, NULL, NULL, NULL, NULL), (4, '04', 'Tenant', 'کرایے دار', 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `customershippinginfo` -- CREATE TABLE `customershippinginfo` ( `Id` bigint(20) NOT NULL, `CustomerId` bigint(20) DEFAULT NULL, `FirstName` varchar(255) DEFAULT NULL, `LastName` varchar(255) DEFAULT NULL, `Address` longtext DEFAULT NULL, `CountryId` int(11) DEFAULT NULL, `CityId` int(11) DEFAULT NULL, `MobileNo` varchar(255) DEFAULT NULL, `PostalCode` varchar(30) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `customershippinginfo` -- INSERT INTO `customershippinginfo` (`Id`, `CustomerId`, `FirstName`, `LastName`, `Address`, `CountryId`, `CityId`, `MobileNo`, `PostalCode`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 1, 'Nabeel', '343434', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, 1, '03244492569', '54600 update', 1, 0, '2024-01-29 12:31:06', 0, '2024-02-04 10:09:54'); -- -------------------------------------------------------- -- -- Table structure for table `customerwishlist` -- CREATE TABLE `customerwishlist` ( `Id` bigint(20) NOT NULL, `CustomerId` bigint(20) DEFAULT NULL, `ProductId` bigint(20) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `customerwishlist` -- INSERT INTO `customerwishlist` (`Id`, `CustomerId`, `ProductId`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (3, 1, 14, 1, 0, '2024-02-04 18:00:35', NULL, NULL), (4, 1, 13, 1, 0, '2024-02-15 12:53:34', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `emailconfig` -- CREATE TABLE `emailconfig` ( `Id` int(10) UNSIGNED NOT NULL, `MailHost` text NOT NULL, `Email` varchar(255) NOT NULL, `SMTPUserName` varchar(255) NOT NULL, `SMTPPassword` varchar(255) NOT NULL, `MailPort` int(11) NOT NULL DEFAULT 0, `MailExcryption` varchar(255) NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) 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; -- -------------------------------------------------------- -- -- Table structure for table `emailtemplate` -- CREATE TABLE `emailtemplate` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `findus` -- CREATE TABLE `findus` ( `Id` int(10) UNSIGNED NOT NULL, `StoreName` varchar(255) NOT NULL, `StoreAddress` text DEFAULT NULL, `PictureOne` varchar(255) DEFAULT NULL, `PictureTwo` varchar(255) DEFAULT NULL, `PictureThree` varchar(255) DEFAULT NULL, `PictureFour` varchar(255) DEFAULT NULL, `PictureFive` varchar(255) DEFAULT NULL, `LatVal` double NOT NULL DEFAULT 0, `LongVal` double NOT NULL DEFAULT 0, `CityId` int(11) NOT NULL DEFAULT 0, `AreaId` int(11) NOT NULL DEFAULT 0, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `findus` -- INSERT INTO `findus` (`Id`, `StoreName`, `StoreAddress`, `PictureOne`, `PictureTwo`, `PictureThree`, `PictureFour`, `PictureFive`, `LatVal`, `LongVal`, `CityId`, `AreaId`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 'dsfds', 'sdfd', 'NoImage', 'NoImage', 'NoImage', 'NoImage', 'NoImage', 4543, 3454, 1, 1, 1, '2023-12-21 07:23:07', 0, NULL, 0, NULL, NULL), (2, 'sadf', 'fasdf', 'storepicture/0202312210725191652239711955.jfif', 'NoImage', 'NoImage', 'NoImage', 'NoImage', 32423, 324, 1, 1, 1, '2023-12-21 07:25:19', 0, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `headerslider` -- CREATE TABLE `headerslider` ( `Id` int(11) NOT NULL, `Title` varchar(255) DEFAULT NULL, `TextOne` text DEFAULT NULL, `TextTwo` text DEFAULT NULL, `TextThree` text DEFAULT NULL, `RedirectLink` text DEFAULT NULL, `Picture` text DEFAULT NULL, `Status` int(11) DEFAULT 1, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModififedBy` int(11) DEFAULT NULL, `ModififedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `logofviconsetting` -- CREATE TABLE `logofviconsetting` ( `Id` int(11) NOT NULL, `Logo` text DEFAULT NULL, `FVIcon` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `logofviconsetting` -- INSERT INTO `logofviconsetting` (`Id`, `Logo`, `FVIcon`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 'logofviconpicture/020240221171136shoplixlogo.png', 'logofviconpicture/020240225105108shoplixlogo.png', 1, 0, '2024-02-25 10:51:08', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_reset_tokens_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2023_09_20_143010_create_category_table', 1), (6, '2023_09_20_143023_create_area_table', 1), (7, '2023_09_20_143031_create_attribute_table', 1), (8, '2023_09_20_143037_create_brand_table', 1), (9, '2023_09_20_143043_create_city_table', 1), (10, '2023_09_20_143051_create_country_table', 1), (11, '2023_09_20_143102_create_customer_table', 1), (12, '2023_09_20_143113_create_emailconfig_table', 1), (13, '2023_09_20_143128_create_emailtemplate_table', 1), (14, '2023_09_20_143138_create_order_table', 1), (15, '2023_09_20_143143_create_orderdetail_table', 1), (16, '2023_09_20_143152_create_orderstatus_table', 1), (17, '2023_09_20_143159_create_orderstype_table', 1), (18, '2023_09_20_143213_create_pages_table', 1), (19, '2023_09_20_143220_create_product_table', 1), (20, '2023_09_20_143225_create_productreview_table', 1), (21, '2023_09_20_143233_create_productreport_table', 1), (22, '2023_09_20_143246_create_returpolicy_table', 1), (23, '2023_09_20_143254_create_shipping_table', 1), (24, '2023_09_20_143300_create_state_table', 1), (25, '2023_09_20_143305_create_tax_table', 1), (26, '2023_09_20_143312_create_users_table', 2), (27, '2023_09_20_143319_create_usertype_table', 2), (28, '2023_09_25_142210_create_productattribute_table', 3), (29, '2023_09_25_144158_create_seller_table', 4), (30, '2023_10_13_103811_create_coupon_table', 5), (31, '2023_10_13_104931_create_blogcategory_table', 6), (32, '2023_10_13_104953_create_blog_table', 6), (33, '2023_12_11_140055_create_admin_user_table', 6), (34, '2023_12_19_111337_create_findus_table', 7), (35, '2023_12_21_091943_create_unit_table', 8), (36, '2023_12_21_122955_create_contactus_table', 9), (37, '2023_12_21_143831_create_contactusreply_table', 10), (38, '2023_12_24_085834_create_socialmedialinks_table', 11), (39, '2024_01_03_123645_create_campaign_table', 12), (40, '2024_01_03_124443_create_campaignproduct_table', 13); -- -------------------------------------------------------- -- -- Table structure for table `orderbillinginfo` -- CREATE TABLE `orderbillinginfo` ( `Id` bigint(20) NOT NULL, `OrderId` bigint(20) DEFAULT NULL, `FirstName` varchar(255) DEFAULT NULL, `LastName` varchar(255) DEFAULT NULL, `Address` longtext DEFAULT NULL, `CountryId` int(11) DEFAULT NULL, `CityId` int(11) DEFAULT NULL, `MobileNo` varchar(255) DEFAULT NULL, `PostalCode` varchar(30) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `orderbillinginfo` -- INSERT INTO `orderbillinginfo` (`Id`, `OrderId`, `FirstName`, `LastName`, `Address`, `CountryId`, `CityId`, `MobileNo`, `PostalCode`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 3, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, -1, '03244492569', '54600', 1, 0, '2024-01-29 12:46:26', NULL, NULL), (2, 4, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, 1, '03244492569', '54600', 1, 0, '2024-01-29 14:30:43', NULL, NULL), (3, 5, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, 1, '03244492569', '54600', 1, 0, '2024-01-31 07:36:38', NULL, NULL), (4, 6, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, 1, '03244492569', '54600', 1, 0, '2024-01-31 07:36:38', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `orderdetail` -- CREATE TABLE `orderdetail` ( `Id` bigint(20) UNSIGNED NOT NULL, `OrderId` bigint(20) DEFAULT NULL, `ProductId` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `AttributeValue` longtext DEFAULT NULL, `Price` double DEFAULT NULL, `Quantity` double DEFAULT NULL, `SubTotal` double DEFAULT NULL, `Discount` double DEFAULT NULL, `Tax` double DEFAULT 0, `NetAmount` double DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orderdetail` -- INSERT INTO `orderdetail` (`Id`, `OrderId`, `ProductId`, `created_at`, `updated_at`, `AttributeValue`, `Price`, `Quantity`, `SubTotal`, `Discount`, `Tax`, `NetAmount`) VALUES (1, 1, 14, NULL, NULL, 'None', 69, 1, 69, 0, 0, 69), (2, 2, 14, NULL, NULL, 'None', 69, 1, 69, 0, 0, 69), (3, 3, 14, NULL, NULL, 'None', 69, 2, 138, 0, 0, 138), (4, 3, 13, NULL, NULL, 'None', 184.5, 1, 184.5, 0, 0, 184.5), (5, 4, 14, NULL, NULL, 'None', 69, 1, 69, 0, 0, 69), (6, 4, 13, NULL, NULL, 'None', 184.5, 1, 184.5, 0, 0, 184.5), (7, 5, 14, NULL, NULL, 'None', 69, 1, 69, 0, 0, 69), (8, 6, 14, NULL, NULL, 'None', 69, 1, 69, 0, 0, 69); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `Id` bigint(20) NOT NULL, `OrderNo` varchar(255) 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(11) DEFAULT 1, `CustomerId` int(11) DEFAULT NULL, `PaymentStatus` int(11) DEFAULT 1, `Status` int(11) DEFAULT 1, `CreatedBy` int(11) DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `PaymentTypeId` int(11) DEFAULT NULL, `ShippingId` int(11) DEFAULT NULL, `ShippingCharges` double DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ShippedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`Id`, `OrderNo`, `OrderDate`, `Quantity`, `GrossTotal`, `TotalDiscount`, `TotalTax`, `NetTotal`, `OrderStatusId`, `CustomerId`, `PaymentStatus`, `Status`, `CreatedBy`, `ModifiedBy`, `PaymentTypeId`, `ShippingId`, `ShippingCharges`, `CreatedDate`, `ModifiedDate`, `ShippedDate`) VALUES (1, '1', '2024-01-29 12:29:24', 1, 69, 0, 0, 1269, 4, 1, 2, 1, 0, 0, 1, 1, 1200, '2024-01-29 12:29:24', '2024-02-23 13:00:24', NULL), (2, '1', '2024-01-29 12:31:06', 1, 69, 0, 0, 1269, 1, 1, 1, 1, 0, NULL, 1, 1, 1200, '2024-01-29 12:31:06', NULL, NULL), (3, '1', '2024-01-29 12:46:26', 3, 322.5, 0, 0, 1522.5, 2, 1, 1, 1, 0, 0, 1, 1, 1200, '2024-01-29 12:46:26', '2024-02-02 12:56:01', NULL), (4, '1', '2024-01-29 14:30:43', 2, 253.5, 0, 0, 1453.5, 4, 1, 2, 1, 0, 0, 1, 1, 1200, '2024-01-29 14:30:43', '2024-02-23 13:00:01', NULL), (5, '1', '2024-01-31 07:36:38', 1, 69, 0, 0, 1269, 3, 1, 1, 1, 0, 0, 1, 1, 1200, '2024-01-31 07:36:38', '2024-02-02 12:56:34', NULL), (6, '1', '2024-01-31 07:36:38', 1, 69, 0, 0, 1269, 1, 1, 1, 1, 0, NULL, 1, 1, 1200, '2024-01-31 07:36:38', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `ordershippinginfo` -- CREATE TABLE `ordershippinginfo` ( `Id` bigint(20) NOT NULL, `OrderId` bigint(20) DEFAULT NULL, `FirstName` varchar(255) DEFAULT NULL, `LastName` varchar(255) DEFAULT NULL, `Address` longtext DEFAULT NULL, `CountryId` int(11) DEFAULT NULL, `CityId` int(11) DEFAULT NULL, `MobileNo` varchar(255) DEFAULT NULL, `PostalCode` varchar(30) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `ordershippinginfo` -- INSERT INTO `ordershippinginfo` (`Id`, `OrderId`, `FirstName`, `LastName`, `Address`, `CountryId`, `CityId`, `MobileNo`, `PostalCode`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 3, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, -1, '03244492569', '54600', 1, 0, '2024-01-29 12:46:26', NULL, NULL), (2, 4, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, 1, '03244492569', '54600', 1, 0, '2024-01-29 14:30:43', NULL, NULL), (3, 5, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, 1, '03244492569', '54600', 1, 0, '2024-01-31 07:36:38', NULL, NULL), (4, 6, 'Nabeel', 'Ezad', 'House No 22 Nargis Street Taj Bagh Housing Scheme Lahore', 1, 1, '03244492569', '54600', 1, 0, '2024-01-31 07:36:38', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `orderstatus` -- CREATE TABLE `orderstatus` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orderstatus` -- INSERT INTO `orderstatus` (`Id`, `Code`, `Name`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, '01', 'Pending', 1, '2023-09-26 10:40:18', 0, '2023-09-26 10:40:36', 0, NULL, NULL), (2, '02', 'Progress', 1, '2023-09-26 10:40:46', 0, '2024-01-03 11:14:11', 0, NULL, NULL), (3, '03', 'Delivered', 1, '2024-01-03 11:14:32', 0, NULL, 0, NULL, NULL), (4, '04', 'Completed', 1, '2024-01-03 11:14:44', 0, NULL, 0, NULL, NULL), (5, '05', 'Declined', 1, '2024-01-03 11:15:14', 0, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `orderstype` -- CREATE TABLE `orderstype` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orderstype` -- INSERT INTO `orderstype` (`Id`, `Code`, `Name`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, '01', 'Pending', 1, '2023-09-26 09:25:41', 0, '2023-09-26 09:26:52', 0, NULL, NULL), (3, '45', 'Test', 1, '2024-01-06 05:25:10', 0, NULL, 0, NULL, NULL), (4, '035', 'Stripe', 1, '2024-03-06 19:34:40', 0, '2024-03-06 19:40:41', 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `Id` int(10) UNSIGNED NOT NULL, `Title` text NOT NULL, `Banner` longtext NOT NULL, `Description` longtext NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) 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; -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `paymentstatus` -- CREATE TABLE `paymentstatus` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `paymentstatus` -- INSERT INTO `paymentstatus` (`Id`, `Code`, `Name`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, '01', 'Pending', 1, NULL, NULL, NULL, NULL), (2, '02', 'Paid', 1, NULL, NULL, NULL, NULL), (3, '03', 'Refund', 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `paymenttype` -- CREATE TABLE `paymenttype` ( `Id` int(11) NOT NULL, `Code` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT 1, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `paymenttype` -- INSERT INTO `paymenttype` (`Id`, `Code`, `Name`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, '01', 'Cash on Delivery', 1, 1, NULL, NULL, NULL), (2, '02', 'Bank Transfer', 1, 1, NULL, NULL, NULL), (4, '03', 'Stripe', 1, 0, '2024-03-09 19:20:00', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `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; -- -------------------------------------------------------- -- -- Table structure for table `possetting` -- CREATE TABLE `possetting` ( `id` int(11) NOT NULL, `Lang` varchar(255) DEFAULT NULL, `Logo` text DEFAULT NULL, `ShopName` text DEFAULT NULL, `Address` text DEFAULT NULL, `PhoneNo` varchar(30) DEFAULT NULL, `PhoneNoTwo` varchar(30) DEFAULT NULL, `EmailAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `Id` bigint(20) UNSIGNED NOT NULL, `Thumbnai` text DEFAULT NULL, `BannerImage` text DEFAULT NULL, `ShorName` text DEFAULT NULL, `Name` text NOT NULL, `Slug` text DEFAULT NULL, `CategoryId` int(11) DEFAULT NULL, `SubCategoryId` int(11) DEFAULT NULL, `ChildCategoryId` int(11) DEFAULT NULL, `BrandId` int(11) 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 DEFAULT NULL, `ShortDescription` longtext DEFAULT NULL, `LongDescription` longtext DEFAULT NULL, `Tags` text DEFAULT NULL, `Returnable` int(11) NOT NULL DEFAULT 0, `Warranty` int(11) NOT NULL DEFAULT 0, `Status` int(11) NOT NULL DEFAULT 1, `SEOTitle` text DEFAULT NULL, `SeoDescription` longtext DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `SellerId` int(11) DEFAULT NULL, `TaxId` int(11) DEFAULT NULL, `TaxRate` float DEFAULT 0, `TaxValue` double DEFAULT 0, `SKU` varchar(255) DEFAULT NULL, `Featured` int(11) NOT NULL DEFAULT 0, `UnitId` int(11) DEFAULT NULL, `WholeSalePrice` double DEFAULT 0, `ExpireyDate` date DEFAULT NULL, `MinStockValue` double DEFAULT 0, `NameUr` varchar(255) DEFAULT NULL, `BarCode` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product` -- INSERT INTO `product` (`Id`, `Thumbnai`, `BannerImage`, `ShorName`, `Name`, `Slug`, `CategoryId`, `SubCategoryId`, `ChildCategoryId`, `BrandId`, `PurchasePrice`, `SalePrice`, `StockQty`, `VideoLink`, `ShortDescription`, `LongDescription`, `Tags`, `Returnable`, `Warranty`, `Status`, `SEOTitle`, `SeoDescription`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`, `SellerId`, `TaxId`, `TaxRate`, `TaxValue`, `SKU`, `Featured`, `UnitId`, `WholeSalePrice`, `ExpireyDate`, `MinStockValue`, `NameUr`, `BarCode`) VALUES (20, NULL, NULL, NULL, 'Motor Bike', NULL, 5, 13, NULL, 1, 145000.00, 170000.00, 4.00, NULL, NULL, 'desc', NULL, 2, 2, 1, NULL, NULL, '2024-04-27 07:25:37', 0, NULL, 0, NULL, NULL, NULL, 1, 0, 0, 'PR-0000019', 0, 1, 170000, '2024-04-27', 2, 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-04-27 07:38:46', 0, NULL, 0, NULL, NULL, 1, 1, 0, 0, 'PR-0000020', 0, 1, 55000, NULL, 2, 'سام سنگددفدف', 'PR-0000020e3'); -- -------------------------------------------------------- -- -- Table structure for table `productattribute` -- CREATE TABLE `productattribute` ( `Id` bigint(20) UNSIGNED NOT NULL, `ProductId` int(11) NOT NULL, `AttributeId` int(11) NOT NULL, `AttributeValue` text DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `ShonOnDetail` smallint(6) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `productattribute` -- INSERT INTO `productattribute` (`Id`, `ProductId`, `AttributeId`, `AttributeValue`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`, `ShonOnDetail`) 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), (64, 20, 1, 'Red', '2024-04-27 07:25:37', 0, NULL, 0, NULL, NULL, 0), (67, 21, 1, 'Blue', '2024-04-27 07:38:46', 0, NULL, 0, NULL, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `productpicture` -- CREATE TABLE `productpicture` ( `Id` bigint(20) NOT NULL, `ProductId` bigint(20) NOT NULL, `PictureThumbPath` longtext NOT NULL, `PicturePath` longtext NOT NULL, `Status` int(11) NOT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `productpicture` -- INSERT INTO `productpicture` (`Id`, `ProductId`, `PictureThumbPath`, `PicturePath`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 13, 'productmoreimage/020240123115425dress_green_5.jpg', 'productmoreimage/020240123115425dress_green_5.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (2, 13, 'productmoreimage/020240123115425dress_green_6.jpg', 'productmoreimage/020240123115425dress_green_6.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (3, 13, 'productmoreimage/020240123115425dress_green_7.jpg', 'productmoreimage/020240123115425dress_green_7.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (4, 13, 'productmoreimage/020240123115425dress_green_8.jpg', 'productmoreimage/020240123115425dress_green_8.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (5, 13, 'productmoreimage/020240123115425dress_green_9.jpg', 'productmoreimage/020240123115425dress_green_9.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (6, 13, 'productmoreimage/020240123115425dress_green_10.jpg', 'productmoreimage/020240123115425dress_green_10.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (7, 13, 'productmoreimage/020240123115425dress_green_11.jpg', 'productmoreimage/020240123115425dress_green_11.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (8, 13, 'productmoreimage/020240123115425dress_green_12.jpg', 'productmoreimage/020240123115425dress_green_12.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (9, 13, 'productmoreimage/020240123115425dress_green_13.jpg', 'productmoreimage/020240123115425dress_green_13.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (10, 13, 'productmoreimage/020240123115425dress_green_14.jpg', 'productmoreimage/020240123115425dress_green_14.jpg', 1, 0, '2024-01-23 11:54:25', NULL, NULL), (11, 14, 'productmoreimage/020240125132436dress_green_7.jpg', 'productmoreimage/020240125132436dress_green_7.jpg', 1, 0, '2024-01-25 13:24:36', NULL, NULL), (12, 14, 'productmoreimage/020240125132436dress_green_8.jpg', 'productmoreimage/020240125132436dress_green_8.jpg', 1, 0, '2024-01-25 13:24:36', NULL, NULL), (13, 14, 'productmoreimage/020240125132436dress_green_9.jpg', 'productmoreimage/020240125132436dress_green_9.jpg', 1, 0, '2024-01-25 13:24:36', NULL, NULL), (14, 14, 'productmoreimage/020240125132436dress_green_10.jpg', 'productmoreimage/020240125132436dress_green_10.jpg', 1, 0, '2024-01-25 13:24:36', NULL, NULL), (15, 14, 'productmoreimage/020240125132436dress_green_11.jpg', 'productmoreimage/020240125132436dress_green_11.jpg', 1, 0, '2024-01-25 13:24:36', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `productrating` -- CREATE TABLE `productrating` ( `Id` bigint(20) NOT NULL, `ProductId` bigint(20) NOT NULL, `Rating` float NOT NULL DEFAULT 0, `CustomerId` int(11) NOT NULL, `IPAddress` varchar(255) DEFAULT NULL, `Status` int(11) DEFAULT 1, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModififedBy` int(11) DEFAULT NULL, `ModififedDate` datetime DEFAULT NULL, `Comment` longtext DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `productrating` -- INSERT INTO `productrating` (`Id`, `ProductId`, `Rating`, `CustomerId`, `IPAddress`, `Status`, `CreatedBy`, `CreatedDate`, `ModififedBy`, `ModififedDate`, `Comment`) VALUES (2, 13, 5, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL), (3, 13, 5, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL), (4, 13, 1, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL), (5, 13, 0, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL), (6, 13, 4, 0, NULL, 1, 1, NULL, NULL, NULL, NULL), (8, 13, 3, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL), (9, 13, 3, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL), (10, 13, 4, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL), (11, 13, 4, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL), (12, 13, 3, 1, '1.1.1.1', 1, 0, '2024-01-25 11:37:10', 0, '2024-01-25 12:59:44', 'sdfdsf'), (13, 13, 5, 1, '127.0.0.1', 1, 0, '2024-01-25 11:41:00', 0, '2024-01-25 12:49:47', 'Test Update'), (14, 13, 2, 1, '127.0.0.1', 1, 0, '2024-01-25 13:04:58', 0, '2024-01-25 13:05:21', 'fhghfg'), (15, 13, 4, 1, '127.0.0.1', 1, 0, '2024-01-28 08:26:46', 0, '2024-01-28 08:27:11', 'test review update test'); -- -------------------------------------------------------- -- -- Table structure for table `productreport` -- CREATE TABLE `productreport` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `productype` -- CREATE TABLE `productype` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `NameUr` varchar(255) DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `productype` -- INSERT INTO `productype` (`Id`, `Code`, `Name`, `NameUr`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 'up', 'دفدسفد', 'سام سنگ', 1, '2024-03-17 15:20:51', 0, '2024-04-26 15:35:04', 0, NULL, NULL), (3, '34', 'sdfd', NULL, 1, '2024-04-26 15:30:13', 0, NULL, 0, NULL, NULL), (4, 'PT-0000004', 'Finished Goods', NULL, 1, '2024-06-12 13:07:49', 0, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `returpolicy` -- CREATE TABLE `returpolicy` ( `Id` int(20) UNSIGNED NOT NULL, `Name` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) NOT NULL DEFAULT 1, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `returpolicy` -- INSERT INTO `returpolicy` (`Id`, `Name`, `Description`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 'Title of return policy', 'Desc', 1, '2024-01-03 11:35:35', 0, NULL, NULL, NULL, NULL), (4, 'sdf', 'sdfsf', 1, '2024-01-06 05:26:09', 0, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `sec_forms` -- CREATE TABLE `sec_forms` ( `Id` int(11) NOT NULL, `FormName` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `ModuleId` int(11) DEFAULT NULL, `LeftMenu` int(11) DEFAULT NULL, `FormTitle` varchar(255) DEFAULT NULL, `OrderNo` float DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `sec_forms` -- INSERT INTO `sec_forms` (`Id`, `FormName`, `Description`, `Status`, `ModuleId`, `LeftMenu`, `FormTitle`, `OrderNo`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) 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, 'addpossaleorder', 'Cash Sale', 1, 5, 1, 'Cash Sale', 1, 1, '2024-06-13 06:43:34', NULL, NULL), (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'); -- -------------------------------------------------------- -- -- Table structure for table `sec_module` -- CREATE TABLE `sec_module` ( `Id` int(11) NOT NULL, `ModuleName` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `sec_module` -- INSERT INTO `sec_module` (`Id`, `ModuleName`, `Description`, `Status`) VALUES (1, 'HIRS', 'HRIS', 1), (2, 'INVENTORY', 'INVENTORY', 1), (3, 'ACCOUNTS', 'ACCOUNTS', 1), (4, 'SETTINGS', 'SETTINGS ', 0), (5, 'POINT OF SALE', 'POINT OF SALE', NULL), (6, 'SECURITY', 'SECURITY', 1); -- -------------------------------------------------------- -- -- Table structure for table `sec_users` -- CREATE TABLE `sec_users` ( `Id` int(11) NOT NULL, `UserName` varchar(255) DEFAULT NULL, `UserPassword` varchar(1000) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ZoneId` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `BranchId` int(11) DEFAULT NULL, `ProfileId` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `sec_users` -- INSERT INTO `sec_users` (`Id`, `UserName`, `UserPassword`, `Status`, `CreatedDate`, `ZoneId`, `CreatedBy`, `BranchId`, `ProfileId`) VALUES (1, 'admin', 'admin', 1, NULL, 1, 1, 1, 1), (2, 'posad', 'posadmin', 1, '2024-06-13 09:44:51', 3, 1, 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `sec_zone` -- CREATE TABLE `sec_zone` ( `Id` int(11) NOT NULL, `ZoneName` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `sec_zone` -- INSERT INTO `sec_zone` (`Id`, `ZoneName`, `Description`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES (1, 'admin', 'adminsdfsdfsd', 1, NULL, NULL, 1, '2024-06-13 11:11:59'), (3, 'Pos', NULL, 1, 1, '2024-06-13 09:00:29', 1, '2024-06-13 11:12:16'); -- -------------------------------------------------------- -- -- Table structure for table `sec_zone_gate` -- CREATE TABLE `sec_zone_gate` ( `Id` int(11) NOT NULL, `FormId` int(11) DEFAULT NULL, `ZoneId` int(11) 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(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `sec_zone_gate` -- INSERT INTO `sec_zone_gate` (`Id`, `FormId`, `ZoneId`, `AddRight`, `EditRight`, `DeleteRight`, `ViewRight`, `PrintRight`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedDate`, `ModifiedBy`) VALUES (325, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (326, 3, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (327, 4, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (328, 5, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (329, 6, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (330, 7, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (331, 8, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (332, 2, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (333, 9, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (334, 10, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (335, 11, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (336, 12, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (337, 13, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (338, 14, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (339, 15, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (340, 16, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (341, 17, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (342, 18, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (343, 19, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (344, 20, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (345, 21, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (346, 22, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (347, 23, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (348, 24, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (349, 25, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (350, 26, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (351, 27, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (352, 28, 1, 1, 1, 1, 1, 1, 1, 1, '2024-06-13 11:11:59', NULL, NULL), (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); -- -------------------------------------------------------- -- -- Table structure for table `seller` -- CREATE TABLE `seller` ( `Id` bigint(20) UNSIGNED NOT NULL, `Name` varchar(255) NOT NULL, `PhoneNo` varchar(255) DEFAULT NULL, `MobileNo` varchar(255) DEFAULT NULL, `EmailAddress` varchar(255) DEFAULT NULL, `Address` text DEFAULT NULL, `Picture` text DEFAULT NULL, `ZipCode` varchar(255) DEFAULT NULL, `CountryId` int(11) DEFAULT NULL, `StateId` int(11) DEFAULT NULL, `CityId` int(11) DEFAULT NULL, `Status` int(11) NOT NULL DEFAULT 0, `ShopStatus` int(11) NOT NULL DEFAULT 0, `UserStatus` int(11) NOT NULL DEFAULT 0, `RegisterDate` datetime DEFAULT NULL, `OpeningBalance` double NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `seller` -- INSERT INTO `seller` (`Id`, `Name`, `PhoneNo`, `MobileNo`, `EmailAddress`, `Address`, `Picture`, `ZipCode`, `CountryId`, `StateId`, `CityId`, `Status`, `ShopStatus`, `UserStatus`, `RegisterDate`, `OpeningBalance`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 'nab', NULL, '03245454', 'nabeel@gmail.com', 'asfdsd', '', '343', 1, 1, 1, 1, 1, 1, '2023-10-09 11:06:46', 343, '2023-10-09 11:06:46', 0, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `shipping` -- CREATE TABLE `shipping` ( `Id` int(20) UNSIGNED NOT NULL, `Name` varchar(255) NOT NULL, `ShippingCost` double NOT NULL DEFAULT 0, `Description` text DEFAULT NULL, `Status` int(11) NOT NULL DEFAULT 1, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `shipping` -- INSERT INTO `shipping` (`Id`, `Name`, `ShippingCost`, `Description`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 'Free Shipping', 1200, 'Free Shipping', 1, '2024-01-03 11:26:32', 0, '2024-01-27 15:06:52', 0, NULL, NULL), (2, 'Outside City', 120, 'Outside City', 1, '2024-01-06 05:32:28', 0, '2024-01-27 15:07:24', 0, NULL, NULL), (3, 'Inside City', 60, 'Inside City', 1, '2024-01-27 15:07:51', 0, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `socialmedialinks` -- CREATE TABLE `socialmedialinks` ( `Id` int(10) UNSIGNED NOT NULL, `Name` varchar(255) NOT NULL, `SocialMediaUrl` text NOT NULL, `IconOne` text DEFAULT NULL, `IconTwo` text DEFAULT NULL, `Description` text DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `socialmedialinks` -- INSERT INTO `socialmedialinks` (`Id`, `Name`, `SocialMediaUrl`, `IconOne`, `IconTwo`, `Description`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 'dsfd update', 'sdfdsf', 'ds', 'sdf', 'sdfds', 1, '2023-12-24 18:44:12', 0, '2023-12-24 18:57:37', 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `state` -- CREATE TABLE `state` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `CountryId` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `state` -- INSERT INTO `state` (`Id`, `Code`, `Name`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `CountryId`, `created_at`, `updated_at`) VALUES (1, '01up', 'Punjab', 1, '2023-10-02 12:06:01', 0, '2023-10-02 12:17:21', 0, 1, NULL, NULL), (3, '02', 'KPK', 1, '2023-10-02 13:44:14', 0, NULL, 0, 1, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `tax` -- CREATE TABLE `tax` ( `Id` int(20) UNSIGNED NOT NULL, `Name` varchar(255) DEFAULT NULL, `TaxRate` float NOT NULL DEFAULT 0, `Description` text NOT NULL, `Status` int(11) NOT NULL DEFAULT 1, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tax` -- INSERT INTO `tax` (`Id`, `Name`, `TaxRate`, `Description`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, '16Per', 16, 'test', 1, '2023-10-05 11:45:20', 0, '2023-10-05 11:46:07', 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `unit` -- CREATE TABLE `unit` ( `Id` int(10) UNSIGNED NOT NULL, `Code` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `NameUr` varchar(255) DEFAULT NULL, `Icon` varchar(255) DEFAULT NULL, `Description` text DEFAULT NULL, `Picture` text DEFAULT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `unit` -- INSERT INTO `unit` (`Id`, `Code`, `Name`, `NameUr`, `Icon`, `Description`, `Picture`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, '01', 'Pcs', NULL, NULL, NULL, NULL, 1, '2024-01-03 07:44:28', 0, NULL, 0, NULL, NULL), (2, '02', 'کلو گرم', NULL, NULL, NULL, NULL, 1, '2024-03-09 07:24:23', 0, '2024-03-17 13:08:40', 0, NULL, NULL), (4, '34', 'Kilo Gram up', 'کلو گرام اوپر', NULL, NULL, NULL, 1, '2024-04-26 15:25:04', 0, '2024-04-26 15:25:27', 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `usertype` -- CREATE TABLE `usertype` ( `Id` int(10) UNSIGNED NOT NULL, `Name` varchar(255) NOT NULL, `Description` varchar(255) NOT NULL, `Status` smallint(6) NOT NULL DEFAULT 0, `CreatedDate` datetime DEFAULT NULL, `CreatedBy` int(11) NOT NULL DEFAULT 0, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `usertype` -- INSERT INTO `usertype` (`Id`, `Name`, `Description`, `Status`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `created_at`, `updated_at`) VALUES (1, 'Standard', 'Standard', 1, '2023-10-05 10:48:17', 0, '2023-10-05 10:51:33', 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `websitegeneralsetting` -- CREATE TABLE `websitegeneralsetting` ( `Id` int(11) NOT NULL, `MainTitle` varchar(255) DEFAULT NULL, `ContactEmailAddress` varchar(255) DEFAULT NULL, `InfoEmailAddress` varchar(255) DEFAULT NULL, `DefaultCurrency` varchar(255) DEFAULT NULL, `CurrencyIcon` varchar(50) DEFAULT NULL, `TimeZone` varchar(255) DEFAULT NULL, `MobileNumber` varchar(50) DEFAULT NULL, `WhatsAppNumber` varchar(50) DEFAULT NULL, `LandlineNumber` varchar(50) DEFAULT NULL, `Address` text DEFAULT NULL, `MondayToFridayTiming` varchar(255) DEFAULT NULL, `SaturdayTiming` varchar(255) DEFAULT NULL, `SundayTiming` varchar(255) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `CreatedBy` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `ModifiedDate` datetime DEFAULT NULL, `ModifiedBy` int(11) DEFAULT NULL, `MainText` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `websitegeneralsetting` -- INSERT INTO `websitegeneralsetting` (`Id`, `MainTitle`, `ContactEmailAddress`, `InfoEmailAddress`, `DefaultCurrency`, `CurrencyIcon`, `TimeZone`, `MobileNumber`, `WhatsAppNumber`, `LandlineNumber`, `Address`, `MondayToFridayTiming`, `SaturdayTiming`, `SundayTiming`, `Status`, `CreatedBy`, `CreatedDate`, `ModifiedDate`, `ModifiedBy`, `MainText`) 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); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_user` -- ALTER TABLE `admin_user` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_acct_account_group` -- ALTER TABLE `app_acct_account_group` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_acct_chart_of_account` -- ALTER TABLE `app_acct_chart_of_account` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_acct_nature_of_account` -- ALTER TABLE `app_acct_nature_of_account` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_gen_setting_payment_type` -- ALTER TABLE `app_gen_setting_payment_type` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_hr_employee_personal_information` -- ALTER TABLE `app_hr_employee_personal_information` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_bank` -- ALTER TABLE `app_inv_bank` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_customer` -- ALTER TABLE `app_inv_customer` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_customer_payment` -- ALTER TABLE `app_inv_customer_payment` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_customer_type` -- ALTER TABLE `app_inv_customer_type` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_discount_type` -- ALTER TABLE `app_inv_discount_type` ADD UNIQUE KEY `Id` (`Id`); -- -- Indexes for table `app_inv_grn_order` -- ALTER TABLE `app_inv_grn_order` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_grn_order_detail` -- ALTER TABLE `app_inv_grn_order_detail` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_grn_order_other_expense` -- ALTER TABLE `app_inv_grn_order_other_expense` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_item_stock_adjustment` -- ALTER TABLE `app_inv_item_stock_adjustment` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_item_stock_adjustment_reason` -- ALTER TABLE `app_inv_item_stock_adjustment_reason` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_purchase_order` -- ALTER TABLE `app_inv_purchase_order` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_purchase_order_detail` -- ALTER TABLE `app_inv_purchase_order_detail` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_vendor` -- ALTER TABLE `app_inv_vendor` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_inv_vendor_payment` -- ALTER TABLE `app_inv_vendor_payment` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_pointofsale_customer_payment` -- ALTER TABLE `app_pointofsale_customer_payment` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_pointofsale_sale_order` -- ALTER TABLE `app_pointofsale_sale_order` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_pointofsale_sale_order_detail` -- ALTER TABLE `app_pointofsale_sale_order_detail` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_pointofsale_store_expense` -- ALTER TABLE `app_pointofsale_store_expense` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_pos_branch` -- ALTER TABLE `app_pos_branch` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_pos_daily_expense` -- ALTER TABLE `app_pos_daily_expense` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_setting_branch_type` -- ALTER TABLE `app_setting_branch_type` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `app_setting_company` -- ALTER TABLE `app_setting_company` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `area` -- ALTER TABLE `area` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `attribute` -- ALTER TABLE `attribute` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `banktransfer` -- ALTER TABLE `banktransfer` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `blog` -- ALTER TABLE `blog` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blogcategory` -- ALTER TABLE `blogcategory` ADD PRIMARY KEY (`id`); -- -- Indexes for table `brand` -- ALTER TABLE `brand` ADD PRIMARY KEY (`Id`), ADD UNIQUE KEY `Slug` (`Slug`) USING HASH; -- -- Indexes for table `campaign` -- ALTER TABLE `campaign` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `campaignproduct` -- ALTER TABLE `campaignproduct` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`Id`), ADD UNIQUE KEY `Slug` (`Slug`) USING HASH; -- -- Indexes for table `city` -- ALTER TABLE `city` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `contactus` -- ALTER TABLE `contactus` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `contactusreply` -- ALTER TABLE `contactusreply` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `country` -- ALTER TABLE `country` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `coupon` -- ALTER TABLE `coupon` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `currency` -- ALTER TABLE `currency` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `customer` -- ALTER TABLE `customer` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `customerbillinginfo` -- ALTER TABLE `customerbillinginfo` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `customerresidancetype` -- ALTER TABLE `customerresidancetype` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `customershippinginfo` -- ALTER TABLE `customershippinginfo` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `customerwishlist` -- ALTER TABLE `customerwishlist` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `emailconfig` -- ALTER TABLE `emailconfig` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `emailtemplate` -- ALTER TABLE `emailtemplate` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `findus` -- ALTER TABLE `findus` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `headerslider` -- ALTER TABLE `headerslider` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `logofviconsetting` -- ALTER TABLE `logofviconsetting` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orderbillinginfo` -- ALTER TABLE `orderbillinginfo` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `orderdetail` -- ALTER TABLE `orderdetail` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `ordershippinginfo` -- ALTER TABLE `ordershippinginfo` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `orderstatus` -- ALTER TABLE `orderstatus` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `orderstype` -- ALTER TABLE `orderstype` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `paymentstatus` -- ALTER TABLE `paymentstatus` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `paymenttype` -- ALTER TABLE `paymenttype` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `possetting` -- ALTER TABLE `possetting` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`Id`), ADD UNIQUE KEY `Slug` (`Slug`) USING HASH; -- -- Indexes for table `productattribute` -- ALTER TABLE `productattribute` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `productpicture` -- ALTER TABLE `productpicture` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `productrating` -- ALTER TABLE `productrating` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `productreport` -- ALTER TABLE `productreport` ADD PRIMARY KEY (`id`); -- -- Indexes for table `productype` -- ALTER TABLE `productype` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `returpolicy` -- ALTER TABLE `returpolicy` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `sec_forms` -- ALTER TABLE `sec_forms` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `sec_module` -- ALTER TABLE `sec_module` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `sec_users` -- ALTER TABLE `sec_users` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `sec_zone` -- ALTER TABLE `sec_zone` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `sec_zone_gate` -- ALTER TABLE `sec_zone_gate` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `seller` -- ALTER TABLE `seller` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `shipping` -- ALTER TABLE `shipping` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `socialmedialinks` -- ALTER TABLE `socialmedialinks` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `state` -- ALTER TABLE `state` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `tax` -- ALTER TABLE `tax` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `unit` -- ALTER TABLE `unit` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `usertype` -- ALTER TABLE `usertype` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `websitegeneralsetting` -- ALTER TABLE `websitegeneralsetting` ADD PRIMARY KEY (`Id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin_user` -- ALTER TABLE `admin_user` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `app_acct_account_group` -- ALTER TABLE `app_acct_account_group` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `app_acct_chart_of_account` -- ALTER TABLE `app_acct_chart_of_account` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `app_acct_nature_of_account` -- ALTER TABLE `app_acct_nature_of_account` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `app_gen_setting_payment_type` -- ALTER TABLE `app_gen_setting_payment_type` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `app_hr_employee_personal_information` -- ALTER TABLE `app_hr_employee_personal_information` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `app_inv_bank` -- ALTER TABLE `app_inv_bank` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `app_inv_customer` -- ALTER TABLE `app_inv_customer` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `app_inv_customer_payment` -- ALTER TABLE `app_inv_customer_payment` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `app_inv_customer_type` -- ALTER TABLE `app_inv_customer_type` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `app_inv_discount_type` -- ALTER TABLE `app_inv_discount_type` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `app_inv_grn_order` -- ALTER TABLE `app_inv_grn_order` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `app_inv_grn_order_detail` -- ALTER TABLE `app_inv_grn_order_detail` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `app_inv_grn_order_other_expense` -- ALTER TABLE `app_inv_grn_order_other_expense` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `app_inv_item_stock_adjustment` -- ALTER TABLE `app_inv_item_stock_adjustment` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `app_inv_item_stock_adjustment_reason` -- ALTER TABLE `app_inv_item_stock_adjustment_reason` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `app_inv_purchase_order` -- ALTER TABLE `app_inv_purchase_order` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `app_inv_purchase_order_detail` -- ALTER TABLE `app_inv_purchase_order_detail` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `app_inv_vendor` -- ALTER TABLE `app_inv_vendor` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `app_inv_vendor_payment` -- ALTER TABLE `app_inv_vendor_payment` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `app_pointofsale_customer_payment` -- ALTER TABLE `app_pointofsale_customer_payment` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `app_pointofsale_sale_order` -- ALTER TABLE `app_pointofsale_sale_order` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `app_pointofsale_sale_order_detail` -- ALTER TABLE `app_pointofsale_sale_order_detail` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79; -- -- AUTO_INCREMENT for table `app_pointofsale_store_expense` -- ALTER TABLE `app_pointofsale_store_expense` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `app_pos_branch` -- ALTER TABLE `app_pos_branch` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `app_pos_daily_expense` -- ALTER TABLE `app_pos_daily_expense` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `app_setting_branch_type` -- ALTER TABLE `app_setting_branch_type` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `app_setting_company` -- ALTER TABLE `app_setting_company` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `area` -- ALTER TABLE `area` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `attribute` -- ALTER TABLE `attribute` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `banktransfer` -- ALTER TABLE `banktransfer` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blog` -- ALTER TABLE `blog` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blogcategory` -- ALTER TABLE `blogcategory` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `brand` -- ALTER TABLE `brand` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `campaign` -- ALTER TABLE `campaign` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `campaignproduct` -- ALTER TABLE `campaignproduct` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48; -- -- AUTO_INCREMENT for table `city` -- ALTER TABLE `city` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `contactus` -- ALTER TABLE `contactus` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `contactusreply` -- ALTER TABLE `contactusreply` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `coupon` -- ALTER TABLE `coupon` MODIFY `Id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `currency` -- ALTER TABLE `currency` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `customer` -- ALTER TABLE `customer` MODIFY `Id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `customerbillinginfo` -- ALTER TABLE `customerbillinginfo` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `customerresidancetype` -- ALTER TABLE `customerresidancetype` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `customershippinginfo` -- ALTER TABLE `customershippinginfo` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `customerwishlist` -- ALTER TABLE `customerwishlist` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `emailconfig` -- ALTER TABLE `emailconfig` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `emailtemplate` -- ALTER TABLE `emailtemplate` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `findus` -- ALTER TABLE `findus` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `headerslider` -- ALTER TABLE `headerslider` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `logofviconsetting` -- ALTER TABLE `logofviconsetting` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `orderbillinginfo` -- ALTER TABLE `orderbillinginfo` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `orderdetail` -- ALTER TABLE `orderdetail` MODIFY `Id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `ordershippinginfo` -- ALTER TABLE `ordershippinginfo` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `orderstatus` -- ALTER TABLE `orderstatus` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `orderstype` -- ALTER TABLE `orderstype` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `paymentstatus` -- ALTER TABLE `paymentstatus` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `paymenttype` -- ALTER TABLE `paymenttype` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `possetting` -- ALTER TABLE `possetting` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `Id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `productattribute` -- ALTER TABLE `productattribute` MODIFY `Id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68; -- -- AUTO_INCREMENT for table `productpicture` -- ALTER TABLE `productpicture` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `productrating` -- ALTER TABLE `productrating` MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `productreport` -- ALTER TABLE `productreport` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `productype` -- ALTER TABLE `productype` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `returpolicy` -- ALTER TABLE `returpolicy` MODIFY `Id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `sec_forms` -- ALTER TABLE `sec_forms` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `sec_module` -- ALTER TABLE `sec_module` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `sec_users` -- ALTER TABLE `sec_users` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `sec_zone` -- ALTER TABLE `sec_zone` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `sec_zone_gate` -- ALTER TABLE `sec_zone_gate` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=381; -- -- AUTO_INCREMENT for table `seller` -- ALTER TABLE `seller` MODIFY `Id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `shipping` -- ALTER TABLE `shipping` MODIFY `Id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `socialmedialinks` -- ALTER TABLE `socialmedialinks` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `state` -- ALTER TABLE `state` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tax` -- ALTER TABLE `tax` MODIFY `Id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `unit` -- ALTER TABLE `unit` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `usertype` -- ALTER TABLE `usertype` MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `websitegeneralsetting` -- ALTER TABLE `websitegeneralsetting` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; CREATE TABLE `app_inv_delivery_order` ( `Id` BIGINT NOT NULL AUTO_INCREMENT, `OrderNo` VARCHAR(255) NOT NULL, `OrderDate` DATETIME NOT NULL, `RefNo` VARCHAR(255) NOT NULL, `OrderStatus` INT NOT NULL, `CustomerId` INT NOT NULL, `TaxRateId` INT NOT NULL, `ShipDate` DATETIME NOT NULL, `EmployeeId` INT NOT NULL, `SupplyPlaceId` INT NOT NULL, `Description` LONGTEXT CHARACTER SET 'armscii8' NOT NULL, `SubTotal` DECIMAL NOT NULL, `Discount` DECIMAL NOT NULL, `Tax` DECIMAL NOT NULL, `Freight` DECIMAL NULL, `SNo` VARCHAR(255) NOT NULL, `Remarks` LONGTEXT NOT NULL, `Status` INT NOT NULL, `CreatedBy` INT NOT NULL, `CreatedDate` DATETIME NOT NULL, `ModifiedBy` INT NOT NULL, `ModifiedDate` DATETIME NOT NULL, PRIMARY KEY (`Id`)); ALTER TABLE `app_inv_delivery_order` DROP INDEX `Freight_UNIQUE` ; ; ALTER TABLE `app_inv_delivery_order` CHANGE COLUMN `Freight` `Freight` DECIMAL(10,0) NOT NULL ; ALTER TABLE `app_inv_delivery_order` CHANGE COLUMN `OrderNo` `OrderNo` VARCHAR(255) NULL , CHANGE COLUMN `OrderDate` `OrderDate` DATETIME NULL , CHANGE COLUMN `RefNo` `RefNo` VARCHAR(255) NULL , CHANGE COLUMN `OrderStatus` `OrderStatus` INT NULL , CHANGE COLUMN `CustomerId` `CustomerId` INT NULL , CHANGE COLUMN `TaxRateId` `TaxRateId` INT NULL , CHANGE COLUMN `ShipDate` `ShipDate` DATETIME NULL , CHANGE COLUMN `EmployeeId` `EmployeeId` INT NULL , CHANGE COLUMN `SupplyPlaceId` `SupplyPlaceId` INT NULL , CHANGE COLUMN `Description` `Description` LONGTEXT CHARACTER SET 'armscii8' NULL , CHANGE COLUMN `SubTotal` `SubTotal` DECIMAL(10,0) NULL , CHANGE COLUMN `Discount` `Discount` DECIMAL(10,0) NULL , CHANGE COLUMN `Tax` `Tax` DECIMAL(10,0) NULL , CHANGE COLUMN `Freight` `Freight` DECIMAL(10,0) NULL , CHANGE COLUMN `SNo` `SNo` VARCHAR(255) NULL , CHANGE COLUMN `Remarks` `Remarks` LONGTEXT NULL , CHANGE COLUMN `Status` `Status` INT NULL , CHANGE COLUMN `CreatedBy` `CreatedBy` INT NULL , CHANGE COLUMN `CreatedDate` `CreatedDate` DATETIME NULL , CHANGE COLUMN `ModifiedBy` `ModifiedBy` INT NULL , CHANGE COLUMN `ModifiedDate` `ModifiedDate` DATETIME NULL ; ALTER TABLE `aemposinst`.`app_inv_delivery_order` ADD COLUMN `NetTotal` DECIMAL NULL AFTER `ModifiedDate` CREATE TABLE `aemposinst`.`app_inv_delivery_order_detail` ( `Id` BIGINT NOT NULL AUTO_INCREMENT, `DeliveryOrderId` BIGINT NULL, `ItemId` BIGINT NULL, `PurchasePrice` DECIMAL NULL, `WholeSalePrice` DECIMAL NULL, `SalePrice` DECIMAL NULL, `ActualSalePrice` DECIMAL NULL, `DiscountValue` DECIMAL NULL, `DiscountId` INT NULL, `DiscPerFlat` VARCHAR(255) NULL, `DiscountTotal` DECIMAL NULL, `TaxId` INT NULL, `TaxRate` DECIMAL NULL, `TaxValue` DECIMAL NULL, `Quantity` DECIMAL NULL, `SubTotal` DECIMAL NULL, `NetTotal` DECIMAL NULL, PRIMARY KEY (`Id`)); ALTER TABLE `app_inv_delivery_order` ADD `NetTotal` DECIMAL NULL AFTER `ModifiedDate`, ADD `InvoiceGen` INT NULL AFTER `NetTotal`; ALTER TABLE `product` ADD COLUMN `ProductTypeId` INT NULL AFTER `BarCode`; ALTER TABLE `app_inv_delivery_order` ADD COLUMN `TransactionStatus` INT NULL AFTER `InvoiceGen`; ALTER TABLE `app_inv_delivery_order` ADD COLUMN `BranchId` INT NULL AFTER `TransactionStatus`; CREATE TABLE `placeofsupply` ( `Id` INT NOT NULL AUTO_INCREMENT, `Code` VARCHAR(45) NULL, `Name` TEXT NULL, `Description` TEXT NULL, `Status` INT NULL, `CreatedBy` INT NULL, `CreatedDate` DATETIME NULL, `ModifiedBy` INT NULL, `ModifiedDate` DATETIME NULL, PRIMARY KEY (`Id`)); INSERT INTO `placeofsupply` (`Code`,`Name`,`Description`,`Status`,`CreatedBy`) VALUES ('01','UAE','UAE',1,1); ALTER TABLE `app_pointofsale_customer_payment` CHANGE COLUMN `Id` `Id` BIGINT NOT NULL AUTO_INCREMENT ; ALTER TABLE `category` CHANGE COLUMN `Id` `Id` INT UNSIGNED NOT NULL AUTO_INCREMENT , ADD PRIMARY KEY (`Id`); ALTER TABLE `brand` CHANGE COLUMN `Id` `Id` INT UNSIGNED NOT NULL AUTO_INCREMENT , ADD PRIMARY KEY (`Id`); ALTER TABLE `app_inv_purchase_order` CHANGE COLUMN `Id` `Id` BIGINT NOT NULL AUTO_INCREMENT ; ALTER TABLE `app_inv_purchase_order` CHANGE COLUMN `ReferenceNo` `ReferenceNo` VARCHAR(255) NULL , CHANGE COLUMN `BranchId` `BranchId` INT NULL , CHANGE COLUMN `Status` `Status` INT NULL , CHANGE COLUMN `CreatedBy` `CreatedBy` INT NULL , CHANGE COLUMN `CreatedDate` `CreatedDate` DATETIME NULL , CHANGE COLUMN `ModifiedBy` `ModifiedBy` INT NULL , CHANGE COLUMN `ModifiedDate` `ModifiedDate` DATETIME NULL ; ALTER TABLE `app_inv_purchase_order_detail` CHANGE COLUMN `DiscountType` `Discount` DECIMAL(10) NULL ; CREATE TABLE `app_inv_payment_term` ( `Id` INT NOT NULL AUTO_INCREMENT, `Title` VARCHAR(255) NULL, `TermDays` INT NULL, `Status` INT NULL, `CreatedBy` INT NULL, `CreatedDate` DATETIME NULL, `ModifiedBy` INT NULL, `ModifiedDate` DATETIME NULL, PRIMARY KEY (`Id`)); INSERT INTO `app_inv_payment_term` ( `Title`, `TermDays`, `Status`) VALUES ('90 Days',90,1); INSERT INTO `aemposinst`.`app_inv_payment_term` (`Title`, `TermDays`, `Status`) VALUES ('45 Days', '45', '1'); INSERT INTO `aemposinst`.`currencylist` (`country`, `currency`, `code`, `symbol`) VALUES ('United Arab Emirates', 'Dirham', 'AED', 'AED'); ALTER TABLE `aemposinst`.`app_inv_vendor` ADD COLUMN `Currency` VARCHAR(45) NULL AFTER `NameUr`, ADD COLUMN `CountryId` INT NULL AFTER `Currency`, ADD COLUMN `PeymentTermId` INT NULL AFTER `CountryId`; ALTER TABLE `aemposinst`.`app_acct_chart_of_account` CHANGE COLUMN `Id` `Id` INT NOT NULL AUTO_INCREMENT ; CREATE TABLE `aemposinst`.`app_acct_ledger_entries` ( `Id` BIGINT NOT NULL AUTO_INCREMENT, `TransactionId` BIGINT NULL, `TransactionTable` VARCHAR(255) NULL, `BookingDate` DATETIME NULL, `Notes` LONGTEXT NULL, `DocNo` VARCHAR(45) NULL, `VType` VARCHAR(45) NULL, `DebitAmount` DECIMAL NULL, `CreditAmount` DECIMAL NULL, `AccountId` INT NULL, `FinanicalYearId` INT NULL, `Status` INT NULL, `CreatedBy` INT NULL, `CreatedDate` DATETIME NULL, `ModifiedBy` INT NULL, `ModifedDate` DATETIME NULL, `app_acct_ledger_entriescol` VARCHAR(45) NULL, PRIMARY KEY (`Id`)); ALTER TABLE `aemposinst`.`app_acct_ledger_entries` CHANGE COLUMN `app_acct_ledger_entriescol` `PaymentType` VARCHAR(45) NULL DEFAULT NULL ; ALTER TABLE `aemposinst`.`app_acct_ledger_entries` ADD COLUMN `BranchId` INT NULL AFTER `PaymentType`; --------------------------------Updated-------------------------------- INSERT INTO `app_acct_nature_of_account` (`Code`, `Name`, `Description`, `AccountGroupId`, `Status`) VALUES ('03', 'Bank', 'Bank', '1', '1'); INSERT INTO `app_acct_chart_of_account` (`Code`, `Name`, `Description`, `AccountNatureId`, `ParentAccountId`, `Status`, `CreatedBy`, `AllowReconciliation`, `OpeningBalance`) VALUES ('03', 'Banks', 'Banks', '3', '-1', '1', '1', '1', '0'); INSERT INTO `app_acct_chart_of_account` (`Code`, `Name`, `Description`, `AccountNatureId`, `ParentAccountId`, `Status`, `CreatedBy`, `AllowReconciliation`, `OpeningBalance`) VALUES ('BANK-0000001', 'BANK-0000001-HBL', 'BANK-0000001-HBL', '0', '7', '1', '1', '1', '0'); UPDATE `app_inv_bank` SET `ChartOfAccountId` = '8' WHERE (`Id` = '1'); INSERT INTO `app_acct_nature_of_account` (`Code`, `Name`, `Description`, `AccountGroupId`, `Status`) VALUES ('04', 'Cash', 'Cash', '1', '1'); CREATE TABLE `aemposinst`.`app_inv_outward_gatepass` ( `Id` INT NOT NULL, `GatePassDate` DATETIME NULL, `GatePassNo` VARCHAR(100) NULL, `SaleOrderId` INT NULL, `VehicleId` INT NULL, `DriverName` VARCHAR(255) 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_outward_gatepass` ADD COLUMN `CustomerInvoiceId` INT NULL AFTER `ModifiedDate`; CREATE TABLE `aemposinst`.`app_inv_outward_gatepass_detail` ( `Id` INT NOT NULL, `OutWardGatePassId` INT NULL, `ItemId` INT NULL, `PurchasePrice` DECIMAL(10,0) NULL, `WholeSalePrice` DECIMAL NULL, `SalePrice` DECIMAL NULL, `Qty` DECIMAL(10,0) NULL, `NetTotal` DECIMAL NULL, `Status` INT NULL, `CreatedBy` INT NULL, `CreatedDate` DATETIME NULL, `ModifiedBy` INT NULL, `ModifiedDate` DATETIME NULL, PRIMARY KEY (`Id`)); ALTER TABLE `aemposinst`.`app_inv_outward_gatepass` ADD COLUMN `RefNo` VARCHAR(45) NULL AFTER `CustomerInvoiceId`; ALTER TABLE `aemposinst`.`app_inv_outward_gatepass` ADD COLUMN `VehicleNo` VARCHAR(255) NULL AFTER `RefNo`; CREATE TABLE `aemposinst`.`app_setting_vehicle` ( `Id` INT NOT NULL, `Title` VARCHAR(255) NULL, `VehicleNo` VARCHAR(50) NULL, `DriverName` VARCHAR(255) NULL, `VehicleTypeId` INT NULL, `Status` INT NULL, `CreatedBy` INT NULL, `CreatedDate` DATETIME NULL, `ModifiedBy` INT NULL, `ModifiedDate` DATETIME NULL, PRIMARY KEY (`Id`)); ALTER TABLE `aemposinst`.`app_setting_vehicle` CHANGE COLUMN `Id` `Id` INT NOT NULL AUTO_INCREMENT ; ALTER TABLE `aemposinst`.`app_inv_outward_gatepass` CHANGE COLUMN `Id` `Id` INT NOT NULL AUTO_INCREMENT ; ALTER TABLE `aemposinst`.`app_inv_outward_gatepass_detail` CHANGE COLUMN `Id` `Id` INT NOT NULL AUTO_INCREMENT ; ALTER TABLE `aemposinst`.`app_inv_outward_gatepass` ADD COLUMN `BranchId` INT NULL AFTER `VehicleNo`; CREATE TABLE `aemposinst`.`app_inv_performa_invoice` ( `Id` INT NOT NULL AUTO_INCREMENT, `InvoiceNo` VARCHAR(255) NULL, `InvoiceDate` DATE NULL, `CustomerId` INT NULL, `GrossAmount` DECIMAL NULL, `DiscountAmount` DECIMAL NULL, `TaxAmount` DECIMAL NULL, `NetAmount` DECIMAL NULL, `Quantity` DECIMAL NULL, `InvoiceStatus` INT NULL, `Status` INT NULL, `CreatedBy` INT NULL, `CreatedDate` DATETIME NULL, `ModifiedBy` INT NULL, `ModifiedDate` DATETIME NULL, PRIMARY KEY (`Id`)); CREATE TABLE `aemposinst`.`app_inv_performa_invoice_detail` ( `Id` INT NOT NULL AUTO_INCREMENT, `PerformaInvoiceId` INT NULL, `ItemId` INT NULL, `PurchasePrice` DECIMAL NULL, `WholeSalePrice` DECIMAL NULL, `SalePrice` DECIMAL NULL, `Quantity` DECIMAL NULL, `GrossTotal` DECIMAL NULL, `DiscountAmount` DECIMAL NULL, `Taxrate` DECIMAL NULL, `TaxAmount` DECIMAL NULL, `NetAmount` DECIMAL NULL, `Status` INT NULL, `CreatedBy` INT NULL, `CreatedDate` DATETIME NULL, `ModifiedBy` INT NULL, `ModifiedDate` DATETIME NULL, PRIMARY KEY (`Id`)); ALTER TABLE `aemposinst`.`app_inv_performa_invoice` ADD COLUMN `Remarks` LONGTEXT NULL AFTER `ModifiedDate`; ALTER TABLE `aemposinst`.`app_inv_performa_invoice` ADD COLUMN `BranchId` INT NULL AFTER `Remarks`; ALTER TABLE `aemposinst`.`app_inv_performa_invoice_detail` ADD COLUMN `DiscountPer` DECIMAL(10,0) NULL AFTER `ModifiedDate`, ADD COLUMN `DiscountValue` DECIMAL(10,0) NULL AFTER `DiscountPer`; /*!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 `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, 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_inward_gatepass` -- LOCK TABLES `app_inv_inward_gatepass` WRITE; /*!40000 ALTER TABLE `app_inv_inward_gatepass` DISABLE KEYS */; /*!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 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 */; /*!40000 ALTER TABLE `app_inv_inward_gatepass_detail` 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-07 0:40:06 ALTER TABLE `aemposinst`.`app_inv_inward_gatepass` ADD COLUMN `BranchId` INT NULL AFTER `ModifiedDate`; ALTER TABLE `aemposinst`.`app_inv_inward_gatepass` ADD COLUMN `RefNo` VARCHAR(45) NULL AFTER `BranchId`; ALTER TABLE `aemposinst`.`app_inv_inward_gatepass` ADD COLUMN `VehicleNo` VARCHAR(45) NULL AFTER `RefNo`;