/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.29-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: staycati_tool
-- ------------------------------------------------------
-- Server version	10.5.29-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `configuration`
--

DROP TABLE IF EXISTS `configuration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `configuration` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(50) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4198853 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_country`
--

DROP TABLE IF EXISTS `tbl_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_country` (
  `cca2` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  KEY `idx_cca2` (`cca2`),
  KEY `idx_country_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_maintenance`
--

DROP TABLE IF EXISTS `tbl_maintenance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_maintenance` (
  `MaintenanceID` int(11) NOT NULL AUTO_INCREMENT,
  `VanID` int(11) DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `Status` varchar(255) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`MaintenanceID`)
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_page_views`
--

DROP TABLE IF EXISTS `tbl_page_views`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_page_views` (
  `page_view_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(10) unsigned DEFAULT NULL,
  `visitor_ip` varchar(255) NOT NULL,
  `visitor_country` varchar(25) DEFAULT NULL,
  `session_id` varchar(255) NOT NULL,
  `time_visited` datetime NOT NULL,
  PRIMARY KEY (`page_view_id`),
  KEY `tbl_page_views_ibfk_1` (`page_id`),
  KEY `idx_visitor_country` (`visitor_country`),
  KEY `idx_time_visited` (`time_visited`),
  KEY `idx_visitor_country_time` (`visitor_country`,`time_visited`),
  CONSTRAINT `tbl_page_views_ibfk_1` FOREIGN KEY (`page_id`) REFERENCES `tbl_pages` (`page_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=38358 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_van_damages`
--

DROP TABLE IF EXISTS `tbl_van_damages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_van_damages` (
  `Van_Damages_ID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `Cost_Repair_Materials` decimal(10,2) DEFAULT NULL,
  `Cost_Repair_Labor` decimal(10,2) DEFAULT NULL,
  `Cost_Repair_Customer` decimal(10,2) DEFAULT NULL,
  `Admin_Fee` decimal(10,2) DEFAULT NULL,
  `Deposit` decimal(10,2) DEFAULT NULL,
  `Receipt_Filename` varchar(255) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Van_Damages_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_van_damages_details`
--

DROP TABLE IF EXISTS `tbl_van_damages_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_van_damages_details` (
  `Van_Damages_Details_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Van_Damages_ID` int(11) NOT NULL,
  `BookingDamageReportID` int(11) DEFAULT NULL,
  `Van_Marker` varchar(255) DEFAULT NULL,
  `Filename` varchar(255) DEFAULT NULL,
  `Cost_Amount` decimal(10,0) DEFAULT NULL,
  `Note` varchar(255) DEFAULT NULL,
  `Status` int(11) NOT NULL DEFAULT 0 COMMENT '0 - In progress \r\n1 - Invoiced \r\n2 - Paid \r\n3 - Missed In progress \r\n4 - Missed completed \r\n5 - Resolved',
  `Customer_Name` varchar(100) DEFAULT NULL,
  `Cost_Repair_Materials` decimal(10,2) DEFAULT NULL,
  `Cost_Repair_Labor` decimal(10,2) DEFAULT NULL,
  `Cost_Repair_Customer` decimal(10,2) DEFAULT NULL,
  `Admin_Fee` decimal(10,2) DEFAULT NULL,
  `Deposit` decimal(10,2) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` int(11) DEFAULT 0,
  `FixedCost` decimal(10,2) DEFAULT NULL,
  `Balance_Due` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Van_Damages_Details_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=472 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_van_maintenance_email`
--

DROP TABLE IF EXISTS `tbl_van_maintenance_email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_van_maintenance_email` (
  `VanMaintenanceEmailID` int(11) NOT NULL AUTO_INCREMENT,
  `Type` varchar(50) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `NextMillage` decimal(10,2) NOT NULL DEFAULT 0.00,
  `VanID` int(11) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  `DateCreated` datetime NOT NULL,
  PRIMARY KEY (`VanMaintenanceEmailID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbladdon`
--

DROP TABLE IF EXISTS `tbladdon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbladdon` (
  `AddonID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `IsFree` bit(1) DEFAULT NULL,
  `IsFixedPrice` bit(1) NOT NULL,
  `ImageName` varchar(500) DEFAULT NULL,
  `Price` float DEFAULT NULL,
  `StockQty` int(11) DEFAULT NULL,
  `IsDailyCharged` bit(1) DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `Category` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`AddonID`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbanner`
--

DROP TABLE IF EXISTS `tblbanner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbanner` (
  `BannerID` int(11) NOT NULL AUTO_INCREMENT,
  `BannerImage` varchar(100) DEFAULT NULL,
  `BannerMobileImage` varchar(100) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `UpdatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `Active` bit(1) DEFAULT NULL,
  PRIMARY KEY (`BannerID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblblock_pickup_dropoff`
--

DROP TABLE IF EXISTS `tblblock_pickup_dropoff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblblock_pickup_dropoff` (
  `Block_pickup_dropoff_id` int(11) NOT NULL AUTO_INCREMENT,
  `Description` varchar(500) DEFAULT NULL,
  `StartDate` date NOT NULL,
  `EndDate` date NOT NULL,
  `DateCreated` datetime NOT NULL,
  `DateUpdated` datetime NOT NULL,
  `CreatedByID` int(11) NOT NULL,
  `UpdatedByID` int(11) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`Block_pickup_dropoff_id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbooking`
--

DROP TABLE IF EXISTS `tblbooking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbooking` (
  `BookingID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` int(11) DEFAULT NULL,
  `VanID` int(11) DEFAULT NULL,
  `CouponID` int(11) DEFAULT NULL,
  `BookingDate` datetime DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `BookedByID` int(11) DEFAULT NULL,
  `Status` varchar(45) DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `VanPrice` float DEFAULT NULL,
  `DiscountAmount` float NOT NULL,
  `DiscountType` varchar(10) NOT NULL,
  `DepositLink` varchar(500) DEFAULT NULL,
  `BookingCost` float NOT NULL,
  `HearAboutUs` varchar(350) DEFAULT NULL,
  `OtherHearAboutUs` text DEFAULT NULL,
  `IsSurpriseBooking` bit(1) NOT NULL DEFAULT b'0',
  `SurpriseDriver` int(11) DEFAULT NULL,
  `Location_Pick_Up` varchar(50) DEFAULT NULL,
  `Location_Drop_Off` varchar(50) DEFAULT NULL,
  `Pickup_LocatonID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`BookingID`),
  KEY `idx_booking_date` (`BookingDate`),
  KEY `idx_status` (`Status`),
  KEY `idx_flag_deleted` (`FlagDeleted`),
  KEY `idx_booking_date_status_deleted` (`BookingDate`,`Status`,`FlagDeleted`),
  KEY `idx_vanid` (`VanID`),
  KEY `idx_userid` (`UserID`),
  KEY `idx_startdate` (`StartDate`),
  KEY `idx_issurprise` (`IsSurpriseBooking`),
  KEY `idx_status_flagdeleted` (`Status`,`FlagDeleted`)
) ENGINE=InnoDB AUTO_INCREMENT=3388 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingaddon`
--

DROP TABLE IF EXISTS `tblbookingaddon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingaddon` (
  `BookingAddonID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `AddonId` int(11) DEFAULT NULL,
  `Qty` int(11) DEFAULT NULL,
  `Price` float DEFAULT NULL,
  `CouponID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `Category` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`BookingAddonID`),
  KEY `idx_bookingid` (`BookingID`),
  KEY `idx_bookingid_flagdeleted` (`BookingID`,`FlagDeleted`),
  KEY `idx_addonid` (`AddonId`)
) ENGINE=InnoDB AUTO_INCREMENT=5608 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingbillingdetails`
--

DROP TABLE IF EXISTS `tblbookingbillingdetails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingbillingdetails` (
  `BookingBillingDetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `FirstName` varchar(45) DEFAULT NULL,
  `LastName` varchar(45) DEFAULT NULL,
  `StreetAddress` varchar(300) DEFAULT NULL,
  `Town` varchar(45) DEFAULT NULL,
  `State` varchar(45) DEFAULT NULL,
  `Country` varchar(45) DEFAULT NULL,
  `Postcode` varchar(45) DEFAULT NULL,
  `PhoneNo` varchar(45) DEFAULT NULL,
  `EmailAddress` varchar(45) DEFAULT NULL,
  `DateOfBirth` datetime DEFAULT NULL,
  `Occupation` varchar(45) DEFAULT NULL,
  `NationalInsurance` varchar(45) DEFAULT NULL,
  `DriverLicenseNo` varchar(45) DEFAULT NULL,
  `DrivingConviction` varchar(45) DEFAULT NULL,
  `HadLicense` varchar(10) DEFAULT NULL,
  `LicenseType` varchar(45) DEFAULT NULL,
  `DrivingExperience` text DEFAULT NULL,
  `AccidentLastYear` varchar(10) DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `IsMainDriver` varchar(45) DEFAULT NULL,
  `HasDriverPermission` varchar(45) DEFAULT NULL,
  `PassengerCount` int(11) DEFAULT NULL,
  `MobilePrefix` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`BookingBillingDetailsID`),
  KEY `idx_booking_id` (`BookingID`),
  KEY `idx_country` (`Country`),
  KEY `idx_bookingid_flagdeleted` (`BookingID`,`FlagDeleted`)
) ENGINE=InnoDB AUTO_INCREMENT=3771 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='		';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingblockvan`
--

DROP TABLE IF EXISTS `tblbookingblockvan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingblockvan` (
  `BookingBlockVanID` int(11) NOT NULL AUTO_INCREMENT,
  `StartDate` date NOT NULL,
  `EndDate` date NOT NULL,
  `SessionID` varchar(100) NOT NULL,
  `DateTime` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  `VanID` int(11) NOT NULL,
  PRIMARY KEY (`BookingBlockVanID`)
) ENGINE=InnoDB AUTO_INCREMENT=30578 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdamage`
--

DROP TABLE IF EXISTS `tblbookingdamage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdamage` (
  `BookingDamageID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `Remarks` varchar(200) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`BookingDamageID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdamagecheckinout`
--

DROP TABLE IF EXISTS `tblbookingdamagecheckinout`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdamagecheckinout` (
  `BookingDamageReportCheckInOutID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `VanID` int(11) NOT NULL,
  `VanPart` varchar(100) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `ImageName` varchar(250) DEFAULT NULL,
  `Type` varchar(100) DEFAULT NULL,
  `DateCreated` datetime NOT NULL,
  `CreatedByID` int(11) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`BookingDamageReportCheckInOutID`)
) ENGINE=InnoDB AUTO_INCREMENT=2975 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdamageimage`
--

DROP TABLE IF EXISTS `tblbookingdamageimage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdamageimage` (
  `BookingDamageImageID` int(11) NOT NULL AUTO_INCREMENT,
  `DamagePhoto` varchar(200) NOT NULL,
  `BookingID` int(11) NOT NULL,
  `BookingDamageID` int(11) NOT NULL,
  `DateCreated` datetime NOT NULL,
  `DateUpdated` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`BookingDamageImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdamagereport`
--

DROP TABLE IF EXISTS `tblbookingdamagereport`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdamagereport` (
  `BookingDamageReportID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `VanID` int(11) NOT NULL,
  `VanPart` varchar(100) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `ImageName` varchar(250) DEFAULT NULL,
  `Type` varchar(100) DEFAULT NULL,
  `DateCreated` datetime NOT NULL,
  `CreatedByID` int(11) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`BookingDamageReportID`)
) ENGINE=InnoDB AUTO_INCREMENT=900 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdamagesignature`
--

DROP TABLE IF EXISTS `tblbookingdamagesignature`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdamagesignature` (
  `BookingDamageSignatureID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `CustomerID` int(11) NOT NULL,
  `CustomerSig` varchar(250) DEFAULT NULL,
  `CustDateSign` datetime DEFAULT NULL,
  `AdminID` int(11) NOT NULL,
  `AdminSig` varchar(250) DEFAULT NULL,
  `AdminDateSign` datetime DEFAULT NULL,
  `Type` varchar(100) DEFAULT NULL,
  `DateCreated` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  `FuelLevel` varchar(50) DEFAULT NULL,
  `ExactMillage` varchar(50) DEFAULT NULL,
  `IsConfirm` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`BookingDamageSignatureID`)
) ENGINE=InnoDB AUTO_INCREMENT=5676 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdemochecklist`
--

DROP TABLE IF EXISTS `tblbookingdemochecklist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdemochecklist` (
  `BookingDemoChecklistID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `CustomerID` int(11) NOT NULL,
  `Power` bit(1) NOT NULL,
  `Fridge` bit(1) NOT NULL,
  `Gas` bit(1) NOT NULL,
  `Oven` bit(1) NOT NULL,
  `Heater` bit(1) NOT NULL,
  `Sink` bit(1) NOT NULL,
  `Rock` bit(1) NOT NULL,
  `Poptop` bit(1) NOT NULL,
  `SpinSeats` bit(1) NOT NULL,
  `InTable` bit(1) NOT NULL,
  `InLights` bit(1) NOT NULL,
  `InLock` bit(1) NOT NULL,
  `AdBlue` bit(1) NOT NULL,
  `Wifi` bit(1) NOT NULL,
  `Cutlery` bit(1) NOT NULL,
  `Firstaid` bit(1) NOT NULL,
  `Media` bit(1) NOT NULL,
  `BikeRack` bit(1) NOT NULL,
  `Storage` bit(1) NOT NULL,
  `CarSeats` bit(1) NOT NULL,
  `Toilet` bit(1) NOT NULL,
  `Confirmed` bit(1) NOT NULL,
  `CustomerSig` varchar(250) NOT NULL,
  `DateSign` datetime NOT NULL,
  `DateCreated` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`BookingDemoChecklistID`)
) ENGINE=InnoDB AUTO_INCREMENT=911 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdocument`
--

DROP TABLE IF EXISTS `tblbookingdocument`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdocument` (
  `BookingDocumentID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `PrimaryPhotoID` varchar(200) DEFAULT NULL,
  `SecondaryPhotoID` varchar(200) DEFAULT NULL,
  `LicensePhotoFront` varchar(200) DEFAULT NULL,
  `LicensePhotoBack` varchar(200) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `AgeStat` varchar(45) DEFAULT NULL,
  `AccFieldStat` varchar(45) DEFAULT NULL,
  `YearsStat` varchar(45) DEFAULT NULL,
  `CpointStat` varchar(45) DEFAULT NULL,
  `Utility2Stat` varchar(45) DEFAULT NULL,
  `Utility1Stat` varchar(45) DEFAULT NULL,
  `DlRearStat` varchar(45) DEFAULT NULL,
  `DlFrontStat` varchar(45) DEFAULT NULL,
  `Comments` varchar(1000) DEFAULT NULL,
  `AccidentNumber` varchar(45) DEFAULT NULL,
  `AccidentNumberFault` varchar(45) DEFAULT NULL,
  `TravelOutsideUK` varchar(10) DEFAULT NULL,
  `DriverLicenseSummary` varchar(200) DEFAULT NULL,
  `DlSummaryStat` varchar(45) DEFAULT NULL,
  `FirstNameD` varchar(100) DEFAULT NULL,
  `LastNameD` varchar(100) DEFAULT NULL,
  `StreetAddressD` varchar(500) DEFAULT NULL,
  `TownCityD` varchar(45) DEFAULT NULL,
  `StateCountryD` varchar(45) DEFAULT NULL,
  `CountryD` varchar(45) DEFAULT NULL,
  `PostcodeZIPD` varchar(45) DEFAULT NULL,
  `PhoneD` varchar(45) DEFAULT NULL,
  `EmailAddressD` varchar(45) DEFAULT NULL,
  `DateBirthD` varchar(45) DEFAULT NULL,
  `OccupationD` varchar(100) DEFAULT NULL,
  `Utility1BillType` varchar(45) DEFAULT NULL,
  `Utility1Date` varchar(45) DEFAULT NULL,
  `Utility1IsSameAddress` varchar(45) DEFAULT NULL,
  `Utility2BillType` varchar(45) DEFAULT NULL,
  `Utility2Date` varchar(45) DEFAULT NULL,
  `Utility2IsSameAddress` varchar(45) DEFAULT NULL,
  `EULivesInUK` varchar(45) DEFAULT NULL,
  `EUDuration` varchar(100) DEFAULT NULL,
  `DriverLicenseNo` varchar(45) DEFAULT NULL,
  `LicenseType` varchar(45) DEFAULT NULL,
  `HadLicense` varchar(10) DEFAULT NULL,
  `DrivingConviction` varchar(45) DEFAULT NULL,
  `DrivingExperience` varchar(100) DEFAULT NULL,
  `AccidentLastYear` varchar(45) DEFAULT NULL,
  `PassportPhoto` varchar(200) DEFAULT NULL,
  `PassportPhotoStat` varchar(45) DEFAULT NULL,
  `HasMedicalCondition` varchar(45) DEFAULT NULL,
  `HasStopDriving` varchar(45) DEFAULT NULL,
  `HasRefuseInsurance` varchar(45) DEFAULT NULL,
  `HasMotoringConviciton` varchar(45) DEFAULT NULL,
  `HasMotoringPendingConviciton` varchar(45) DEFAULT NULL,
  `CustomerSignature` varchar(45) DEFAULT NULL,
  `SignedDate` datetime DEFAULT NULL,
  `AdminSignature` varchar(250) DEFAULT NULL,
  `AdminSignedDate` datetime DEFAULT NULL,
  `ApprovedByID` int(11) DEFAULT 0,
  `MobilePrefix` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`BookingDocumentID`),
  KEY `idx_bookingid_flagdeleted` (`BookingID`,`FlagDeleted`)
) ENGINE=InnoDB AUTO_INCREMENT=3833 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdriver`
--

DROP TABLE IF EXISTS `tblbookingdriver`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdriver` (
  `BookingDriverID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `Occupation` varchar(45) DEFAULT NULL,
  `NationalInsuranceNo` varchar(45) DEFAULT NULL,
  `DriverLicenseNo` varchar(45) DEFAULT NULL,
  `LicenseType` varchar(45) DEFAULT NULL,
  `HadLicense` varchar(10) DEFAULT NULL,
  `UKDrivingLicense` text DEFAULT NULL,
  `LicensePhotoFront` varchar(200) DEFAULT NULL,
  `LicensePhotoBack` varchar(200) DEFAULT NULL,
  `AccidentLastYear` varchar(10) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `DlFrontStatD` varchar(45) DEFAULT NULL,
  `DlRearStatD` varchar(45) DEFAULT NULL,
  `Utility1StatD` varchar(45) DEFAULT NULL,
  `Utility2StatD` varchar(45) DEFAULT NULL,
  `CpointStatD` varchar(45) DEFAULT NULL,
  `YearsStatD` varchar(45) DEFAULT NULL,
  `AccFieldStatD` varchar(45) DEFAULT NULL,
  `AgeStatD` varchar(45) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `PrimaryPhotoID` varchar(200) NOT NULL,
  `SecondaryPhotoID` varchar(200) NOT NULL,
  `OrderNotes` varchar(500) NOT NULL,
  `AccidentNumberFaultD` varchar(45) DEFAULT NULL,
  `AccidentNumberD` varchar(45) DEFAULT NULL,
  `DrivingConviction` varchar(45) DEFAULT NULL,
  `TravelOutsideUK` varchar(10) DEFAULT NULL,
  `DriverLicenseSummaryD` varchar(200) DEFAULT NULL,
  `DlSummaryDStat` varchar(45) DEFAULT NULL,
  `EUDuration` varchar(100) DEFAULT NULL,
  `DateBirthA` varchar(45) DEFAULT NULL,
  `EmailAddressA` varchar(100) DEFAULT NULL,
  `EULivesInUK` varchar(100) DEFAULT NULL,
  `FirstNameA` varchar(100) DEFAULT NULL,
  `LastNameA` varchar(100) DEFAULT NULL,
  `OccupationA` varchar(45) DEFAULT NULL,
  `PhoneA` varchar(45) DEFAULT NULL,
  `PostCodeZIPA` varchar(45) DEFAULT NULL,
  `StateCountryA` varchar(45) DEFAULT NULL,
  `CountryA` varchar(45) DEFAULT NULL,
  `StreetAddressA` varchar(500) DEFAULT NULL,
  `TownCityA` varchar(45) DEFAULT NULL,
  `Utility1BillTypeD` varchar(45) DEFAULT NULL,
  `Utility1DateD` varchar(45) DEFAULT NULL,
  `Utility1IsSameAddressD` varchar(45) DEFAULT NULL,
  `Utility2BillTypeD` varchar(45) DEFAULT NULL,
  `Utility2DateD` varchar(45) DEFAULT NULL,
  `Utility2IsSameAddressD` varchar(45) DEFAULT NULL,
  `HasMedicalCondition` varchar(45) DEFAULT NULL,
  `HasMotoringConviciton` varchar(45) DEFAULT NULL,
  `HasMotoringPendingConviciton` varchar(45) DEFAULT NULL,
  `HasRefuseInsurance` varchar(45) DEFAULT NULL,
  `HasStopDriving` varchar(45) DEFAULT NULL,
  `PassportPhoto` varchar(200) DEFAULT NULL,
  `PassportPhotoStat` varchar(45) DEFAULT NULL,
  `MobilePrefix` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`BookingDriverID`)
) ENGINE=InnoDB AUTO_INCREMENT=2946 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdriverlink`
--

DROP TABLE IF EXISTS `tblbookingdriverlink`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdriverlink` (
  `BookingDriverLinkID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `EmailAddress` varchar(100) DEFAULT NULL,
  `ContactNumber` varchar(45) DEFAULT NULL,
  `Type` varchar(45) DEFAULT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  `DateCreated` datetime NOT NULL,
  `UserID` int(11) NOT NULL,
  `FirstName` varchar(100) DEFAULT NULL,
  `LastName` varchar(100) DEFAULT NULL,
  `EmailedStatus` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`BookingDriverLinkID`)
) ENGINE=InnoDB AUTO_INCREMENT=5037 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdriversecond`
--

DROP TABLE IF EXISTS `tblbookingdriversecond`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdriversecond` (
  `BookingDriverSecondID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `NationalInsuranceNo` varchar(45) DEFAULT NULL,
  `DriverLicenseNo` varchar(45) DEFAULT NULL,
  `LicenseType` varchar(45) DEFAULT NULL,
  `HadLicense` varchar(10) DEFAULT NULL,
  `UKDrivingLicense` text DEFAULT NULL,
  `LicensePhotoFront` varchar(200) DEFAULT NULL,
  `LicensePhotoBack` varchar(200) DEFAULT NULL,
  `AccidentLastYear` varchar(10) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `PrimaryPhotoID` varchar(200) NOT NULL,
  `SecondaryPhotoID` varchar(200) NOT NULL,
  `OrderNotes` varchar(500) NOT NULL,
  `AccidentNumberFault` varchar(45) DEFAULT NULL,
  `AccidentNumber` varchar(45) DEFAULT NULL,
  `DrivingConviction` varchar(45) DEFAULT NULL,
  `TravelOutsideUK` varchar(10) DEFAULT NULL,
  `DriverLicenseSummary` varchar(200) DEFAULT NULL,
  `FirstName` varchar(100) DEFAULT NULL,
  `LastName` varchar(100) DEFAULT NULL,
  `StreetAddress` varchar(500) DEFAULT NULL,
  `TownCity` varchar(45) DEFAULT NULL,
  `StateCountry` varchar(45) DEFAULT NULL,
  `Country` varchar(45) DEFAULT NULL,
  `PostcodeZIP` varchar(45) DEFAULT NULL,
  `PhoneA` varchar(45) DEFAULT NULL,
  `EmailAddress` varchar(100) DEFAULT NULL,
  `DateBirth` varchar(45) DEFAULT NULL,
  `Occupation` varchar(45) DEFAULT NULL,
  `Utility1BillType` varchar(45) DEFAULT NULL,
  `Utility1Date` varchar(45) DEFAULT NULL,
  `Utility1IsSameAddress` varchar(45) DEFAULT NULL,
  `Utility2BillType` varchar(45) DEFAULT NULL,
  `Utility2Date` varchar(45) DEFAULT NULL,
  `Utility2IsSameAddress` varchar(45) DEFAULT NULL,
  `EULivesInUK` varchar(100) DEFAULT NULL,
  `EUDuration` varchar(100) DEFAULT NULL,
  `DlFrontStat` varchar(45) DEFAULT NULL,
  `DlRearStat` varchar(45) DEFAULT NULL,
  `Utility1Stat` varchar(45) DEFAULT NULL,
  `Utility2Stat` varchar(45) DEFAULT NULL,
  `CpointStat` varchar(45) DEFAULT NULL,
  `YearsStat` varchar(45) DEFAULT NULL,
  `AccFieldStat` varchar(45) DEFAULT NULL,
  `AgeStat` varchar(45) DEFAULT NULL,
  `DlSummaryDStat` varchar(45) DEFAULT NULL,
  `PassportPhoto` varchar(200) DEFAULT NULL,
  `PassportPhotoStat` varchar(45) DEFAULT NULL,
  `HasMedicalCondition` varchar(45) DEFAULT NULL,
  `HasStopDriving` varchar(45) DEFAULT NULL,
  `HasRefuseInsurance` varchar(45) DEFAULT NULL,
  `HasMotoringConviciton` varchar(45) DEFAULT NULL,
  `HasMotoringPendingConviciton` varchar(45) DEFAULT NULL,
  `MobilePrefix` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`BookingDriverSecondID`)
) ENGINE=InnoDB AUTO_INCREMENT=2117 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingdriverthird`
--

DROP TABLE IF EXISTS `tblbookingdriverthird`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingdriverthird` (
  `BookingDriverThirdID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `NationalInsuranceNo` varchar(45) DEFAULT NULL,
  `DriverLicenseNo` varchar(45) DEFAULT NULL,
  `LicenseType` varchar(45) DEFAULT NULL,
  `HadLicense` varchar(10) DEFAULT NULL,
  `UKDrivingLicense` text DEFAULT NULL,
  `LicensePhotoFront` varchar(200) DEFAULT NULL,
  `LicensePhotoBack` varchar(200) DEFAULT NULL,
  `AccidentLastYear` varchar(10) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `PrimaryPhotoID` varchar(200) NOT NULL,
  `SecondaryPhotoID` varchar(200) NOT NULL,
  `OrderNotes` varchar(500) NOT NULL,
  `AccidentNumberFault` varchar(45) DEFAULT NULL,
  `AccidentNumber` varchar(45) DEFAULT NULL,
  `DrivingConviction` varchar(45) DEFAULT NULL,
  `TravelOutsideUK` varchar(10) DEFAULT NULL,
  `DriverLicenseSummary` varchar(200) DEFAULT NULL,
  `FirstName` varchar(100) DEFAULT NULL,
  `LastName` varchar(100) DEFAULT NULL,
  `StreetAddress` varchar(500) DEFAULT NULL,
  `TownCity` varchar(45) DEFAULT NULL,
  `StateCountry` varchar(45) DEFAULT NULL,
  `Country` varchar(45) DEFAULT NULL,
  `PostcodeZIP` varchar(45) DEFAULT NULL,
  `PhoneA` varchar(45) DEFAULT NULL,
  `EmailAddress` varchar(100) DEFAULT NULL,
  `DateBirth` varchar(45) DEFAULT NULL,
  `Occupation` varchar(45) DEFAULT NULL,
  `Utility1BillType` varchar(45) DEFAULT NULL,
  `Utility1Date` varchar(45) DEFAULT NULL,
  `Utility1IsSameAddress` varchar(45) DEFAULT NULL,
  `Utility2BillType` varchar(45) DEFAULT NULL,
  `Utility2Date` varchar(45) DEFAULT NULL,
  `Utility2IsSameAddress` varchar(45) DEFAULT NULL,
  `EULivesInUK` varchar(100) DEFAULT NULL,
  `EUDuration` varchar(100) DEFAULT NULL,
  `DlFrontStat` varchar(45) DEFAULT NULL,
  `DlRearStat` varchar(45) DEFAULT NULL,
  `Utility1Stat` varchar(45) DEFAULT NULL,
  `Utility2Stat` varchar(45) DEFAULT NULL,
  `CpointStat` varchar(45) DEFAULT NULL,
  `YearsStat` varchar(45) DEFAULT NULL,
  `AccFieldStat` varchar(45) DEFAULT NULL,
  `AgeStat` varchar(45) DEFAULT NULL,
  `DlSummaryDStat` varchar(45) DEFAULT NULL,
  `PassportPhoto` varchar(200) DEFAULT NULL,
  `PassportPhotoStat` varchar(45) DEFAULT NULL,
  `HasMedicalCondition` varchar(45) DEFAULT NULL,
  `HasStopDriving` varchar(45) DEFAULT NULL,
  `HasRefuseInsurance` varchar(45) DEFAULT NULL,
  `HasMotoringConviciton` varchar(45) DEFAULT NULL,
  `HasMotoringPendingConviciton` varchar(45) DEFAULT NULL,
  `MobilePrefix` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`BookingDriverThirdID`)
) ENGINE=InnoDB AUTO_INCREMENT=2115 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookinglog`
--

DROP TABLE IF EXISTS `tblbookinglog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookinglog` (
  `BookingLogID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `Status` varchar(45) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `UpdatedByID` int(11) NOT NULL,
  PRIMARY KEY (`BookingLogID`)
) ENGINE=InnoDB AUTO_INCREMENT=7911 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingnotes`
--

DROP TABLE IF EXISTS `tblbookingnotes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingnotes` (
  `BookingNoteID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `CreatedByID` int(11) NOT NULL,
  `Notes` text NOT NULL,
  `DateCreated` datetime NOT NULL,
  PRIMARY KEY (`BookingNoteID`)
) ENGINE=InnoDB AUTO_INCREMENT=2828 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblbookingsignoff`
--

DROP TABLE IF EXISTS `tblbookingsignoff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblbookingsignoff` (
  `BookingSignOffID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `Damage` bit(1) NOT NULL,
  `Accident` bit(1) NOT NULL,
  `Liability` bit(1) NOT NULL,
  `BreakDown` bit(1) NOT NULL,
  `Fault` bit(1) NOT NULL,
  `Responsibility` bit(1) NOT NULL,
  `CustSig` varchar(250) NOT NULL,
  `DateSigned` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  `DateCreated` datetime NOT NULL,
  PRIMARY KEY (`BookingSignOffID`)
) ENGINE=MyISAM AUTO_INCREMENT=1153 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblcoupon`
--

DROP TABLE IF EXISTS `tblcoupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblcoupon` (
  `CouponID` int(11) NOT NULL AUTO_INCREMENT,
  `Code` varchar(45) DEFAULT NULL,
  `ValidFrom` datetime DEFAULT NULL,
  `ValidUntil` datetime DEFAULT NULL,
  `Type` varchar(45) DEFAULT NULL,
  `Limit` int(11) DEFAULT NULL,
  `IsFixed` bit(1) DEFAULT NULL,
  `Value` float DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `CouponApplicable` varchar(100) NOT NULL,
  `BookingValidFrom` datetime DEFAULT NULL,
  `BookingValidUntil` datetime DEFAULT NULL,
  PRIMARY KEY (`CouponID`)
) ENGINE=InnoDB AUTO_INCREMENT=268 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblcoupon_gift_voucher`
--

DROP TABLE IF EXISTS `tblcoupon_gift_voucher`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblcoupon_gift_voucher` (
  `GiftVoucherID` int(11) NOT NULL AUTO_INCREMENT,
  `CouponID` int(11) NOT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `ScheduleDate` datetime NOT NULL,
  `DesignType` varchar(45) NOT NULL,
  `MessageText` text NOT NULL,
  `Sender` varchar(200) DEFAULT NULL,
  `Status` varchar(45) NOT NULL,
  `DiscountID` int(11) NOT NULL DEFAULT 0,
  `DiscountAmount` float NOT NULL DEFAULT 0,
  `DateCreated` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`GiftVoucherID`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblcouponaddon`
--

DROP TABLE IF EXISTS `tblcouponaddon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblcouponaddon` (
  `CouponAddonID` int(11) NOT NULL AUTO_INCREMENT,
  `CouponID` int(11) DEFAULT NULL,
  `AddonID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  PRIMARY KEY (`CouponAddonID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblcouponvan`
--

DROP TABLE IF EXISTS `tblcouponvan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblcouponvan` (
  `CouponVanID` int(11) NOT NULL AUTO_INCREMENT,
  `CouponID` int(11) DEFAULT NULL,
  `VanID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  PRIMARY KEY (`CouponVanID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblcustomermessage`
--

DROP TABLE IF EXISTS `tblcustomermessage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblcustomermessage` (
  `CustomerMessageID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` int(11) DEFAULT NULL,
  `Subject` varchar(100) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`CustomerMessageID`)
) ENGINE=InnoDB AUTO_INCREMENT=573 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblemailnotification`
--

DROP TABLE IF EXISTS `tblemailnotification`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblemailnotification` (
  `EmailNotificationID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `EmailType` varchar(45) DEFAULT NULL,
  `Descrition` varchar(200) DEFAULT NULL,
  `UserID` int(11) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  `DateCreated` datetime NOT NULL,
  PRIMARY KEY (`EmailNotificationID`)
) ENGINE=InnoDB AUTO_INCREMENT=8063 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblerror_log`
--

DROP TABLE IF EXISTS `tblerror_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblerror_log` (
  `LogID` int(11) NOT NULL AUTO_INCREMENT,
  `RefID` int(11) NOT NULL,
  `RefType` varchar(50) NOT NULL,
  `ErrorType` varchar(50) NOT NULL,
  `Description` text DEFAULT NULL,
  `DateCreated` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`LogID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblfacility`
--

DROP TABLE IF EXISTS `tblfacility`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblfacility` (
  `FacilityID` int(11) NOT NULL AUTO_INCREMENT,
  `FacilityName` varchar(45) DEFAULT NULL,
  `FacilityImage` varchar(200) DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`FacilityID`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='	';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblinvoice`
--

DROP TABLE IF EXISTS `tblinvoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblinvoice` (
  `InvoiceID` int(11) NOT NULL AUTO_INCREMENT,
  `OrderID` int(11) DEFAULT NULL,
  `GiftVoucherID` int(11) DEFAULT NULL,
  `CustomerID` int(11) NOT NULL,
  `Damage_Details_ID` int(11) NOT NULL DEFAULT 0,
  `InvoiceDate` datetime DEFAULT NULL,
  `InvoiceDue` datetime DEFAULT NULL,
  `Amount` float DEFAULT NULL,
  `Notes` varchar(500) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `UpdatedByID` int(11) DEFAULT NULL,
  `Status` varchar(100) NOT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `PaymentTerms` varchar(50) DEFAULT NULL,
  `InvoiceStripeRefID` varchar(100) NOT NULL DEFAULT '0',
  `InvoicePaymentMethod` varchar(100) DEFAULT NULL,
  `IsExcludeTax` bit(1) NOT NULL DEFAULT b'0',
  `Type` varchar(45) DEFAULT 'SI',
  `ProductOrderID` int(11) DEFAULT NULL,
  `PersonOrdered` varchar(100) DEFAULT NULL,
  `DeliveryDate` datetime DEFAULT NULL,
  PRIMARY KEY (`InvoiceID`)
) ENGINE=InnoDB AUTO_INCREMENT=1776 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblinvoicedetails`
--

DROP TABLE IF EXISTS `tblinvoicedetails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblinvoicedetails` (
  `InvoiceDetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `InvoiceID` int(11) DEFAULT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Rate` float DEFAULT NULL,
  `Qty` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `UpdatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `Description` varchar(500) NOT NULL,
  `Type` varchar(45) NOT NULL,
  `VanDamageDetailsID` int(11) DEFAULT NULL,
  PRIMARY KEY (`InvoiceDetailsID`)
) ENGINE=InnoDB AUTO_INCREMENT=236 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbllocation`
--

DROP TABLE IF EXISTS `tbllocation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbllocation` (
  `LocationID` int(11) NOT NULL,
  `LocationName` varchar(100) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbllog`
--

DROP TABLE IF EXISTS `tbllog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbllog` (
  `LogID` int(11) NOT NULL AUTO_INCREMENT,
  `MethodName` varchar(100) DEFAULT NULL,
  `Details` text DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `Type` varchar(50) DEFAULT NULL,
  `RefID` int(11) NOT NULL,
  PRIMARY KEY (`LogID`)
) ENGINE=InnoDB AUTO_INCREMENT=1735 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblnotificationmessage`
--

DROP TABLE IF EXISTS `tblnotificationmessage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblnotificationmessage` (
  `NotificationMessageID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) DEFAULT NULL,
  `Type` varchar(45) DEFAULT NULL,
  `Message` text DEFAULT NULL,
  `NotifStatus` varchar(45) DEFAULT NULL,
  `NotifDate` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `TypeID` int(11) DEFAULT NULL,
  PRIMARY KEY (`NotificationMessageID`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblpackageorder`
--

DROP TABLE IF EXISTS `tblpackageorder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblpackageorder` (
  `PackageOrderID` int(11) NOT NULL AUTO_INCREMENT,
  `OrderID` int(11) NOT NULL,
  `Status` varchar(45) NOT NULL,
  `DateCreated` datetime NOT NULL,
  `DateUpdated` datetime NOT NULL,
  `CreatedByID` int(11) NOT NULL,
  `UpdatedByID` int(11) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`PackageOrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblpackageorderaddons`
--

DROP TABLE IF EXISTS `tblpackageorderaddons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblpackageorderaddons` (
  `PackageOrderAddonsID` int(11) NOT NULL AUTO_INCREMENT,
  `PackageOrderID` int(11) NOT NULL,
  `OrderAddonsID` int(11) NOT NULL,
  `IsChecked` bit(1) NOT NULL,
  `DateCreated` datetime NOT NULL,
  `DateUpdated` datetime NOT NULL,
  `CreatedByID` int(11) NOT NULL,
  `UpdatedByID` int(11) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`PackageOrderAddonsID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblpackageorderdetails`
--

DROP TABLE IF EXISTS `tblpackageorderdetails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblpackageorderdetails` (
  `PackageOrderDetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `PackageOrderID` int(11) NOT NULL,
  `OrderDetailsID` int(11) NOT NULL,
  `IsChecked` bit(1) NOT NULL,
  `DateCreated` datetime NOT NULL,
  `DateUpdated` datetime NOT NULL,
  `CreatedByID` int(11) NOT NULL,
  `UpdatedByID` int(11) NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`PackageOrderDetailsID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblpayment`
--

DROP TABLE IF EXISTS `tblpayment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblpayment` (
  `PaymentID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `GiftVoucherID` int(11) DEFAULT NULL,
  `Invoice_ID` int(11) NOT NULL DEFAULT 0,
  `PaymentType` varchar(45) DEFAULT NULL,
  `TotalAmount` float DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`PaymentID`),
  KEY `idx_bookingid` (`BookingID`),
  KEY `idx_bookingid_flagdeleted` (`BookingID`,`FlagDeleted`)
) ENGINE=InnoDB AUTO_INCREMENT=2923 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblpaymentdetails`
--

DROP TABLE IF EXISTS `tblpaymentdetails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblpaymentdetails` (
  `PaymentDetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `PaymentID` int(11) DEFAULT NULL,
  `Amount` float DEFAULT NULL,
  `PaymentDate` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`PaymentDetailsID`),
  KEY `idx_paymentid` (`PaymentID`),
  KEY `idx_paymentid_flagdeleted` (`PaymentID`,`FlagDeleted`)
) ENGINE=InnoDB AUTO_INCREMENT=3281 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblpaymenttransaction`
--

DROP TABLE IF EXISTS `tblpaymenttransaction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblpaymenttransaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `OrderID` varchar(10) NOT NULL,
  `responseCode` varchar(10) NOT NULL,
  `responseMessage` text NOT NULL,
  `transactionID` varchar(100) NOT NULL,
  `xref` varchar(100) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `transactionUnique` varchar(100) NOT NULL,
  `orderRef` varchar(100) NOT NULL,
  `amountReceived` float NOT NULL DEFAULT 0,
  `PaymentType` varchar(100) NOT NULL,
  `DateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2219 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblpreinspectionlist`
--

DROP TABLE IF EXISTS `tblpreinspectionlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblpreinspectionlist` (
  `PreInspectionListID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) NOT NULL,
  `CustomerID` int(11) NOT NULL,
  `AdminID` int(11) NOT NULL,
  `AdminSig` varchar(50) NOT NULL,
  `DateSign` datetime NOT NULL,
  `SeatBelt` bit(1) NOT NULL,
  `Tyres` bit(1) NOT NULL,
  `Heater` bit(1) NOT NULL,
  `Plug` bit(1) NOT NULL,
  `AdBlue` bit(1) NOT NULL,
  `SreenWash` bit(1) NOT NULL,
  `Fueled` bit(1) NOT NULL,
  `Dashboard` bit(1) NOT NULL,
  `Hob` bit(1) NOT NULL,
  `Indicator` bit(1) NOT NULL,
  `Wiper` bit(1) NOT NULL,
  `Strap` bit(1) NOT NULL,
  `Gas` bit(1) NOT NULL,
  `Water` bit(1) NOT NULL,
  `Oil` bit(1) NOT NULL,
  `Widescreen` bit(1) NOT NULL,
  `Coolant` bit(1) NOT NULL,
  `Leisure` bit(1) NOT NULL,
  `Horn` bit(1) NOT NULL,
  `Interior` bit(1) NOT NULL,
  `Exterior` bit(1) NOT NULL,
  `Bed` bit(1) NOT NULL,
  `Charger` bit(1) NOT NULL,
  `Fridge` bit(1) NOT NULL,
  `Swivel` bit(1) NOT NULL,
  `SpareTyre` bit(1) NOT NULL,
  `Vehicle` bit(1) NOT NULL,
  `SunVisor` bit(1) NOT NULL,
  `Kettle` bit(1) NOT NULL,
  `Cutlery` bit(1) NOT NULL,
  `CoffeePot` bit(1) NOT NULL,
  `WiFi` bit(1) NOT NULL,
  `InternalTable` bit(1) NOT NULL,
  `Chairs` bit(1) NOT NULL,
  `OutsideTable` bit(1) NOT NULL,
  `HookCable` bit(1) NOT NULL,
  `HairDryer` bit(1) NOT NULL,
  `Pots` bit(1) NOT NULL,
  `Colander` bit(1) NOT NULL,
  `BakingTray` bit(1) NOT NULL,
  `OvenGloves` bit(1) NOT NULL,
  `TTowel` bigint(1) NOT NULL,
  `CanOpener` bit(1) NOT NULL,
  `BottleOpener` bit(1) NOT NULL,
  `BreadKnife` bit(1) NOT NULL,
  `SmallKnife` bit(1) NOT NULL,
  `BBQ` bit(1) NOT NULL,
  `Gin` bit(1) NOT NULL,
  `Cleaning` bit(1) NOT NULL,
  `Spatula` bit(1) NOT NULL,
  `DateCreated` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`PreInspectionListID`)
) ENGINE=MyISAM AUTO_INCREMENT=340 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblreferafriend`
--

DROP TABLE IF EXISTS `tblreferafriend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblreferafriend` (
  `ReferAFriendID` int(11) NOT NULL AUTO_INCREMENT,
  `CouponID` int(11) NOT NULL,
  `BookingID` int(11) NOT NULL DEFAULT 0,
  `EmailAddress` varchar(200) DEFAULT NULL,
  `MessageText` text DEFAULT NULL,
  `Type` varchar(45) DEFAULT NULL,
  `Status` varchar(45) DEFAULT NULL,
  `DateCreated` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`ReferAFriendID`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblreview`
--

DROP TABLE IF EXISTS `tblreview`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblreview` (
  `ReviewID` int(11) NOT NULL AUTO_INCREMENT,
  `BookingID` int(11) DEFAULT NULL,
  `UserID` int(11) DEFAULT NULL,
  `Remarks` text DEFAULT NULL,
  `Ratings` float DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`ReviewID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblreviewdetails`
--

DROP TABLE IF EXISTS `tblreviewdetails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblreviewdetails` (
  `ReviewDetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `ReviewID` int(11) DEFAULT NULL,
  `ImageName` varchar(45) DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`ReviewDetailsID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblseason`
--

DROP TABLE IF EXISTS `tblseason`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblseason` (
  `SeasonID` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(45) DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `MinDays` int(11) NOT NULL,
  `IsOverride` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`SeasonID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblstory`
--

DROP TABLE IF EXISTS `tblstory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblstory` (
  `StoryID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` int(11) DEFAULT NULL,
  `MonthOfStaycation` varchar(45) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  PRIMARY KEY (`StoryID`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblstoryimage`
--

DROP TABLE IF EXISTS `tblstoryimage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblstoryimage` (
  `StoryImageID` int(11) NOT NULL AUTO_INCREMENT,
  `StoryID` int(11) DEFAULT NULL,
  `ImageName` varchar(500) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`StoryImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbltask`
--

DROP TABLE IF EXISTS `tbltask`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbltask` (
  `TaskID` int(11) NOT NULL AUTO_INCREMENT,
  `CustomerID` int(11) DEFAULT NULL,
  `Name` varchar(500) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `TaskTime` time DEFAULT NULL,
  PRIMARY KEY (`TaskID`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbltaskassignment`
--

DROP TABLE IF EXISTS `tbltaskassignment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbltaskassignment` (
  `TaskAssignmentID` int(11) NOT NULL AUTO_INCREMENT,
  `AssignmentType` varchar(20) DEFAULT NULL,
  `TaskID` int(11) DEFAULT NULL,
  `UserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`TaskAssignmentID`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbltasknote`
--

DROP TABLE IF EXISTS `tbltasknote`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbltasknote` (
  `TaskNoteID` int(11) NOT NULL AUTO_INCREMENT,
  `TaskID` int(11) DEFAULT NULL,
  `Notes` text DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`TaskNoteID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbltodolist`
--

DROP TABLE IF EXISTS `tbltodolist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbltodolist` (
  `TodoListID` int(11) NOT NULL AUTO_INCREMENT,
  `CustomerID` int(11) DEFAULT NULL,
  `Name` varchar(45) DEFAULT NULL,
  `Description` varchar(45) DEFAULT NULL,
  `UserID` int(11) DEFAULT NULL,
  `Duration` varchar(45) DEFAULT NULL,
  `Status` varchar(45) DEFAULT NULL,
  `SortOrder` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateCompletion` datetime DEFAULT NULL,
  `TodoTime` time DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`TodoListID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbluser`
--

DROP TABLE IF EXISTS `tbluser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbluser` (
  `UserID` int(11) NOT NULL AUTO_INCREMENT,
  `FirstName` varchar(45) DEFAULT NULL,
  `LastName` varchar(45) DEFAULT NULL,
  `ContactNo` varchar(45) DEFAULT NULL,
  `UserName` varchar(45) DEFAULT NULL,
  `Password` varchar(255) DEFAULT NULL,
  `UserTypeID` int(11) DEFAULT NULL,
  `EmailAddress` varchar(100) DEFAULT NULL,
  `ImangeName` varchar(100) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `SortingOrder` int(11) DEFAULT NULL,
  `ImageName` varchar(100) NOT NULL,
  `TenantID` int(11) NOT NULL,
  `Postcode` varchar(45) DEFAULT NULL,
  `State` varchar(45) DEFAULT NULL,
  `Town` varchar(45) DEFAULT NULL,
  `StreetAddress` varchar(300) DEFAULT NULL,
  `ProfileSig` varchar(250) DEFAULT NULL,
  `MobilePrefix` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`UserID`)
) ENGINE=InnoDB AUTO_INCREMENT=3191 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbluser_orig`
--

DROP TABLE IF EXISTS `tbluser_orig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbluser_orig` (
  `UserID` int(11) NOT NULL DEFAULT 0,
  `FirstName` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LastName` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ContactNo` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `UserName` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Password` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `UserTypeID` int(11) DEFAULT NULL,
  `EmailAddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ImangeName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `SortingOrder` int(11) DEFAULT NULL,
  `ImageName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `TenantID` int(11) NOT NULL,
  `Postcode` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `State` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Town` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `StreetAddress` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ProfileSig` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblusercoupon`
--

DROP TABLE IF EXISTS `tblusercoupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblusercoupon` (
  `UserCouponID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` int(11) DEFAULT NULL,
  `CouponID` int(11) DEFAULT NULL,
  `DateUsed` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`UserCouponID`)
) ENGINE=InnoDB AUTO_INCREMENT=972 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblvan`
--

DROP TABLE IF EXISTS `tblvan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblvan` (
  `VanID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(500) DEFAULT NULL,
  `IsExternal` bit(1) DEFAULT NULL,
  `ExternalVanID` int(11) DEFAULT NULL,
  `Status` varchar(45) DEFAULT NULL,
  `Remarks` varchar(500) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `Description` varchar(500) NOT NULL,
  `MinDays` int(11) NOT NULL,
  `VanColor` varchar(100) DEFAULT NULL,
  `RegPrice` varchar(250) NOT NULL DEFAULT '0',
  `RegNumber` varchar(45) DEFAULT NULL,
  `Make` varchar(100) DEFAULT NULL,
  `Model` varchar(100) DEFAULT NULL,
  `ExternalType` varchar(45) DEFAULT NULL,
  `MaintenanceStartDate` datetime DEFAULT NULL,
  `MaintenanceEndDate` datetime DEFAULT NULL,
  `IsDefectiveIndefinitely` bit(1) DEFAULT NULL,
  `VanManual` varchar(200) DEFAULT NULL,
  `SortOrder` int(11) NOT NULL DEFAULT 0,
  `VideoFile` text DEFAULT NULL,
  `TourImageIframe` text DEFAULT NULL,
  `maint_Mileage_Current` decimal(10,2) DEFAULT NULL,
  `maint_Mileage_Next` decimal(10,2) DEFAULT NULL,
  `maint_Service_Date` datetime DEFAULT NULL,
  `maint_MOT_Date` datetime DEFAULT NULL,
  `maint_MOT_Duration` int(11) DEFAULT NULL,
  `maint_MOT_Cost` decimal(10,2) DEFAULT NULL,
  `maint_TAX_Date` datetime DEFAULT NULL,
  `maint_TAX_Duration` int(11) DEFAULT NULL,
  `maint_TAX_Cost` decimal(10,2) DEFAULT NULL,
  `maint_Insurance_Date` datetime DEFAULT NULL,
  `maint_Insurance_Duration` int(11) DEFAULT NULL,
  `maint_Insurance_Cost` decimal(10,2) DEFAULT NULL,
  `maint_Is_SORN` bit(1) NOT NULL DEFAULT b'0',
  `maint_SORN_Date` datetime DEFAULT NULL,
  `maint_SORN_Cost` decimal(10,2) DEFAULT NULL,
  `maint_Breakdown_Date` datetime DEFAULT NULL,
  `maint_Breakdown_Cost` decimal(10,2) DEFAULT NULL,
  `SlugName` varchar(50) DEFAULT NULL,
  `maint_mot_file` varchar(250) DEFAULT NULL,
  `maint_tax_file` varchar(250) DEFAULT NULL,
  `maint_insurance_file` varchar(250) DEFAULT NULL,
  `maint_breakdown_file` varchar(250) DEFAULT NULL,
  `maint_sorn_file` varchar(250) DEFAULT NULL,
  `Transmission` varchar(50) DEFAULT NULL,
  `Sleeps` int(11) DEFAULT 0,
  `Passengers` int(11) DEFAULT 0,
  `IsPetFriendly` bit(1) DEFAULT b'0',
  `IsBrownVan` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`VanID`)
) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblvanaddon`
--

DROP TABLE IF EXISTS `tblvanaddon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblvanaddon` (
  `VanAddonID` int(11) NOT NULL AUTO_INCREMENT,
  `VanID` int(11) DEFAULT NULL,
  `AddonID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`VanAddonID`)
) ENGINE=InnoDB AUTO_INCREMENT=818 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblvandamageitems`
--

DROP TABLE IF EXISTS `tblvandamageitems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblvandamageitems` (
  `VanDamageItemsID` int(11) NOT NULL AUTO_INCREMENT,
  `VanID` int(11) NOT NULL,
  `DamageName` varchar(200) NOT NULL,
  `ImageName` varchar(200) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `Price` float NOT NULL,
  `CreatedByID` int(11) NOT NULL,
  `DateUpdated` datetime NOT NULL,
  `DateCreated` datetime NOT NULL,
  `FlagDeleted` bit(1) NOT NULL,
  PRIMARY KEY (`VanDamageItemsID`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblvanfacility`
--

DROP TABLE IF EXISTS `tblvanfacility`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblvanfacility` (
  `VanFacilityID` int(11) NOT NULL AUTO_INCREMENT,
  `VanID` int(11) DEFAULT NULL,
  `FacilityID` int(11) DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`VanFacilityID`)
) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblvanimage`
--

DROP TABLE IF EXISTS `tblvanimage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblvanimage` (
  `VanImageID` int(11) NOT NULL AUTO_INCREMENT,
  `VanID` int(11) DEFAULT NULL,
  `Type` varchar(45) DEFAULT NULL,
  `ImageName` varchar(1500) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DefaultImage` bit(1) NOT NULL,
  PRIMARY KEY (`VanImageID`),
  KEY `idx_vanid_default` (`VanID`,`FlagDeleted`,`DefaultImage`)
) ENGINE=InnoDB AUTO_INCREMENT=815 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblvanrule`
--

DROP TABLE IF EXISTS `tblvanrule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblvanrule` (
  `VanRuleID` int(11) NOT NULL AUTO_INCREMENT,
  `VanID` int(11) DEFAULT NULL,
  `Price` float DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `Remarks` varchar(500) DEFAULT NULL,
  `IsOverride` bit(1) NOT NULL,
  `MinDays` int(11) NOT NULL,
  `LocationID` int(11) NOT NULL DEFAULT 0,
  `CreatedByID` int(11) DEFAULT NULL,
  `UpdatedByID` int(11) DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`VanRuleID`)
) ENGINE=InnoDB AUTO_INCREMENT=716 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblvanseasonprice`
--

DROP TABLE IF EXISTS `tblvanseasonprice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblvanseasonprice` (
  `VanSeasonPriceID` int(11) NOT NULL AUTO_INCREMENT,
  `VanID` int(11) DEFAULT NULL,
  `SeasonID` int(11) DEFAULT NULL,
  `Price` float DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`VanSeasonPriceID`)
) ENGINE=InnoDB AUTO_INCREMENT=660 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tblvanspecification`
--

DROP TABLE IF EXISTS `tblvanspecification`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblvanspecification` (
  `VanSpecificationID` int(11) NOT NULL AUTO_INCREMENT,
  `VanID` int(11) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `TechSpec` text DEFAULT NULL,
  `AdditionalInformation` text DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateUpdated` datetime DEFAULT NULL,
  `CreatedByID` int(11) DEFAULT NULL,
  `FlagDeleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`VanSpecificationID`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `transaction_log`
--

DROP TABLE IF EXISTS `transaction_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `transaction_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `amount_` varchar(50) DEFAULT NULL,
  `amount_minor` decimal(20,0) DEFAULT NULL,
  `amount_major` float DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `cross_reference` varchar(30) DEFAULT NULL,
  `status_code` int(11) DEFAULT NULL,
  `status` varchar(40) DEFAULT NULL,
  `gateway_message` varchar(255) DEFAULT NULL,
  `transaction_datetime` datetime DEFAULT NULL,
  `transaction_datetime_txt` varchar(100) DEFAULT NULL,
  `integration_type` varchar(50) DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1378 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-03-12  5:36:49