-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.11.13-MariaDB-ubu2204 - mariadb.org binary distribution
-- Server OS:                    debian-linux-gnu
-- HeidiSQL Version:             12.11.0.7065
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;


-- Dumping database structure for ngaugeshop-ahsgardoo
CREATE DATABASE IF NOT EXISTS `ngaugeshop-ahsgardoo` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci */;
USE `ngaugeshop-ahsgardoo`;

-- Dumping structure for table ngaugeshop-ahsgardoo.accounts
CREATE TABLE IF NOT EXISTS `accounts` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `address` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `price_number` int(11) DEFAULT NULL,
  `intid` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `account_code` varchar(255) DEFAULT NULL,
  `account_group` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `web_email` varchar(255) DEFAULT NULL,
  `stop` bit(1) DEFAULT NULL,
  `web_stop` bit(1) DEFAULT NULL,
  `web_client` bit(1) DEFAULT NULL,
  `minfreedelivery` decimal(19,4) DEFAULT NULL,
  `deliverysupplement` decimal(19,4) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.address
CREATE TABLE IF NOT EXISTS `address` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `accountid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `companyname` varchar(255) DEFAULT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `address3` varchar(255) DEFAULT NULL,
  `town` varchar(255) DEFAULT NULL,
  `county` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
  `long` varchar(255) DEFAULT NULL,
  `type` mediumtext DEFAULT NULL,
  `rate` varchar(10) DEFAULT NULL,
  `telephone` varchar(50) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `contact_email` tinyint(1) DEFAULT 1 COMMENT '"1"=>"Use contact email","0"=>"do not use contact email"',
  PRIMARY KEY (`id`,`language`),
  KEY `relatedid` (`relatedid`),
  KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.assets
CREATE TABLE IF NOT EXISTS `assets` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.attributes
CREATE TABLE IF NOT EXISTS `attributes` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `type` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `class` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `comment` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.attribute_set
CREATE TABLE IF NOT EXISTS `attribute_set` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.attribute_types
CREATE TABLE IF NOT EXISTS `attribute_types` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `length` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.attribute_values
CREATE TABLE IF NOT EXISTS `attribute_values` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `typeid` binary(36) DEFAULT NULL,
  `attributeid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `sequence` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `value` varchar(50) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `tooltip` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.attrib_values
CREATE TABLE IF NOT EXISTS `attrib_values` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `attributeid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `relatedto` varchar(50) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `value` mediumtext DEFAULT NULL,
  `decimal` decimal(10,0) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.attsetlookup
CREATE TABLE IF NOT EXISTS `attsetlookup` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `attributesetid` binary(36) DEFAULT NULL,
  `attributeid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.basket
CREATE TABLE IF NOT EXISTS `basket` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `agentid` binary(36) DEFAULT NULL,
  `deliveryaddress` binary(36) DEFAULT NULL,
  `billingaddress` binary(36) DEFAULT NULL,
  `customerid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `date` int(11) DEFAULT NULL,
  `totalweight` decimal(19,4) DEFAULT NULL,
  `dateshipped` int(11) DEFAULT NULL,
  `dateordered` int(11) DEFAULT NULL,
  `invoiceno` int(11) DEFAULT NULL,
  `netsuiteid` varchar(255) DEFAULT NULL,
  `nooflines` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `ordernumber` varchar(255) DEFAULT NULL,
  `orderref` varchar(255) DEFAULT NULL,
  `paymentmethod` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `billingstatus` varchar(255) DEFAULT NULL,
  `shippingstatus` varchar(255) DEFAULT NULL,
  `consignmentno` varchar(255) DEFAULT NULL,
  `companyname` varchar(255) DEFAULT NULL,
  `courier` varchar(255) DEFAULT NULL,
  `shippingmethod` varchar(255) DEFAULT NULL,
  `account_code` varchar(10) DEFAULT NULL,
  `sourceurl` varchar(255) DEFAULT NULL COMMENT 'Source Url',
  `save` bit(1) DEFAULT NULL,
  `terms` bit(1) DEFAULT NULL,
  `paid` bit(1) DEFAULT NULL,
  `shippingnotification` bit(1) DEFAULT NULL,
  `subtotal` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `amountpaid` decimal(10,2) DEFAULT NULL,
  `amountout` decimal(10,2) DEFAULT NULL,
  `tax` decimal(10,2) DEFAULT NULL,
  `shipping` decimal(10,2) DEFAULT NULL,
  `discounts` decimal(10,2) DEFAULT NULL,
  `discountcodes` mediumtext DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `fulladdress` mediumtext DEFAULT NULL,
  `data` longtext DEFAULT NULL,
  `imported_data` longtext DEFAULT NULL,
  `telephone` varchar(30) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `country` varchar(255) DEFAULT NULL COMMENT 'Country',
  `is_shipment` tinyint(1) DEFAULT 0 COMMENT 'allow shipment method if is_shipment set to 1',
  `deliveryopt` bit(1) DEFAULT NULL,
  `newsletter` tinyint(1) DEFAULT 0,
  `mageid` int(11) DEFAULT NULL,
  `holddate` date DEFAULT NULL,
  `created` date DEFAULT NULL,
  `collection_date` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `ipaddress4` varchar(16) DEFAULT NULL,
  `magecid` int(11) DEFAULT NULL,
  `collection_message` longtext DEFAULT NULL COMMENT 'Collection Message',
  `delivery_message` longtext DEFAULT NULL COMMENT 'Delivery Message',
  `createaccount` tinyint(1) DEFAULT 0,
  `allow_sale` bit(1) DEFAULT b'1',
  PRIMARY KEY (`id`,`language`),
  KEY `dateordered` (`dateordered`),
  KEY `billingstatus` (`billingstatus`),
  KEY `orderref` (`orderref`),
  KEY `shippingstatus` (`shippingstatus`),
  KEY `dateshipped` (`dateshipped`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.basketlines
CREATE TABLE IF NOT EXISTS `basketlines` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `basketid` binary(36) DEFAULT NULL,
  `productid` binary(36) DEFAULT NULL,
  `customerid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `qty` int(11) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `weight` decimal(19,4) DEFAULT NULL,
  `totalweight` decimal(19,4) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `product_type` varchar(255) DEFAULT NULL,
  `price` decimal(19,5) DEFAULT NULL,
  `price_exvat` decimal(19,5) DEFAULT NULL,
  `disc` decimal(19,2) DEFAULT NULL,
  `vat` decimal(19,4) DEFAULT NULL,
  `totalvat` decimal(19,5) DEFAULT NULL,
  `linetotal` decimal(19,5) DEFAULT NULL,
  `taxrate` decimal(19,4) DEFAULT NULL,
  `product_name` mediumtext DEFAULT NULL,
  `product_description` mediumtext DEFAULT NULL,
  `comments` mediumtext DEFAULT NULL,
  `notices` mediumtext DEFAULT NULL,
  `taxdetails` mediumtext DEFAULT NULL,
  `shipmentline` int(11) DEFAULT NULL COMMENT 'Shipment Sequence No',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `paid` bit(1) DEFAULT NULL,
  `codeapplied` bit(1) DEFAULT NULL,
  `deliveryline` bit(1) DEFAULT NULL COMMENT 'Delivery Line',
  `stockreduction` bit(1) DEFAULT NULL COMMENT '"0"=>"new","1"=>"reduced"',
  `pricelocked` bit(1) DEFAULT NULL,
  `requested_date` date DEFAULT NULL COMMENT 'Delivery / Collection requested date',
  `dispatch` tinyint(1) DEFAULT 0 COMMENT '"0"=>"delivery","1"=>"collect"',
  `shipgroupid` binary(36) DEFAULT NULL,
  `lockqty` tinyint(1) DEFAULT 0 COMMENT 'Lock Qty',
  `erpqty` int(11) DEFAULT NULL COMMENT 'ERP QTY',
  `haulierint` int(11) DEFAULT NULL COMMENT 'Haulierint',
  `cost` decimal(19,4) DEFAULT NULL COMMENT 'Cost',
  `costtotal` decimal(19,4) DEFAULT NULL COMMENT 'Cost Total',
  `dispatch_type` varchar(255) DEFAULT NULL COMMENT 'Dispatch Type',
  `dispatch_date` date DEFAULT NULL COMMENT 'Dispatch date',
  `availability_date` date DEFAULT NULL COMMENT 'Availability Date of Product',
  `hidden_info` text DEFAULT NULL COMMENT 'Hidden Information',
  PRIMARY KEY (`id`,`language`),
  KEY `basketid` (`basketid`),
  KEY `productid` (`productid`),
  KEY `relatedid` (`relatedid`),
  KEY `product_type` (`product_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `parent_id` binary(36) DEFAULT NULL,
  `mainimageid` binary(36) DEFAULT NULL COMMENT 'Main Image ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `intid` int(11) DEFAULT NULL,
  `childcount` int(11) DEFAULT NULL,
  `productcount` int(11) DEFAULT NULL,
  `totalproducts` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `ms_sitelayout` varchar(255) DEFAULT NULL COMMENT 'Microsite Layout',
  `short_description` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL COMMENT 'Category Type',
  `category_type` varchar(50) DEFAULT NULL COMMENT '"0"=>"Default","1"=>"Feed"',
  `show_on_menu` bit(1) DEFAULT NULL,
  `microsite` bit(1) DEFAULT NULL COMMENT 'Microsite',
  `linkurl` bit(1) DEFAULT NULL COMMENT 'LinkUrl',
  `subheading` mediumtext DEFAULT NULL,
  `childcounts` mediumtext DEFAULT NULL COMMENT 'Json Categories counts per Branch',
  `productcounts` mediumtext DEFAULT NULL COMMENT 'Json Product counts per Branch',
  `description` mediumtext DEFAULT NULL,
  `description2` mediumtext DEFAULT NULL,
  `parentlist` mediumtext DEFAULT NULL,
  `rating` mediumtext DEFAULT NULL,
  `snippet` mediumtext DEFAULT NULL COMMENT 'Snippet',
  `low_prices` mediumtext DEFAULT NULL COMMENT 'Json of Low Prices',
  `low_price` decimal(10,4) DEFAULT NULL COMMENT 'Low Price (FROM)',
  `sequence` bigint(20) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `ext_data` longtext DEFAULT NULL COMMENT 'Extra Data',
  `searchfilters` text DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.dfmatrix_temp
CREATE TABLE IF NOT EXISTS `dfmatrix_temp` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `ACCOUNT_GROUP` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `ACCOUNT_CODE` varchar(10) DEFAULT NULL COMMENT 'ACCOUNT CODE',
  `CUSTOMER_CODE` varchar(10) DEFAULT NULL,
  `ADDED_BY` varchar(10) DEFAULT NULL,
  `ADDED_ON` varchar(10) DEFAULT NULL,
  `LAST_UPD_BY` varchar(10) DEFAULT NULL,
  `LAST_UPD_ON` varchar(10) DEFAULT NULL,
  `LAST_UPD_AT` varchar(10) DEFAULT NULL,
  `CODE` varchar(32) DEFAULT NULL COMMENT 'CODE',
  `DATE` varchar(30) DEFAULT NULL COMMENT 'DATE',
  `_ID` varchar(30) DEFAULT NULL COMMENT 'ID',
  `STOCK_GROUP` varchar(30) DEFAULT NULL COMMENT 'STOCK GROUP',
  `COMMENT1` varchar(30) DEFAULT NULL COMMENT 'COMMENT 1',
  `COMMENT2` varchar(30) DEFAULT NULL COMMENT 'COMMENT 2',
  `COMMENT3` varchar(30) DEFAULT NULL COMMENT 'COMMENT 3',
  `ACCOUNT_NAME` varchar(30) DEFAULT NULL COMMENT 'ACCOUNT NAME',
  `DESCRIPTION` varchar(30) DEFAULT NULL COMMENT 'DESCRIPTION',
  `PREV_MESSAGE` varchar(30) DEFAULT NULL,
  `STOCK_CODE` varchar(16) DEFAULT NULL COMMENT 'STOCK CODE',
  `QTY_BRK` varchar(1) DEFAULT NULL COMMENT 'QTY BRK',
  `QTY_WH_PR_1` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 1',
  `QTY_WH_PR_2` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 2',
  `QTY_WH_PR_3` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 3',
  `QTY_WH_PR_4` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 4',
  `QTY_WH_PR_5` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 5',
  `QTY_WH_PR_6` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 6',
  `QTY_WH_PR_7` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 7',
  `QTY_WH_PR_8` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 8',
  `QTY_WH_PR_9` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 9',
  `QTY_WH_PR_10` varchar(1) DEFAULT NULL COMMENT 'QTY WH PR 10',
  `PREVENT_SALE` varchar(1) DEFAULT NULL,
  `DISC_` varchar(25) DEFAULT NULL COMMENT 'DISC_',
  `PRICE` varchar(25) DEFAULT NULL COMMENT 'PRICE',
  `QTY_1` varchar(25) DEFAULT NULL COMMENT 'QTY 1',
  `DISC__1` varchar(25) DEFAULT NULL COMMENT 'DISC 1',
  `QTY_2` varchar(25) DEFAULT NULL COMMENT 'QTY 2',
  `DISC__2` varchar(25) DEFAULT NULL COMMENT 'DISC 2',
  `QTY_3` varchar(25) DEFAULT NULL COMMENT 'QTY 3',
  `DISC__3` varchar(25) DEFAULT NULL COMMENT 'DISC 3',
  `QTY_4` varchar(25) DEFAULT NULL COMMENT 'QTY 4',
  `DISC__4` varchar(25) DEFAULT NULL COMMENT 'DISC 4',
  `QTY_5` varchar(25) DEFAULT NULL COMMENT 'QTY 5',
  `DISC__5` varchar(25) DEFAULT NULL COMMENT 'DISC 5',
  `QTY_6` varchar(25) DEFAULT NULL COMMENT 'QTY 6',
  `DISC__6` varchar(25) DEFAULT NULL COMMENT 'DISC 6',
  `QTY_7` varchar(25) DEFAULT NULL COMMENT 'QTY 7',
  `DISC__7` varchar(25) DEFAULT NULL COMMENT 'DISC 7',
  `QTY_8` varchar(25) DEFAULT NULL COMMENT 'QTY 8',
  `DISC__8` varchar(25) DEFAULT NULL COMMENT 'DISC 8',
  `QTY_9` varchar(25) DEFAULT NULL COMMENT 'QTY 9',
  `DISC__9` varchar(25) DEFAULT NULL COMMENT 'DISC 9',
  `QTY_10` varchar(25) DEFAULT NULL COMMENT 'QTY 10',
  `DISC__10` varchar(25) DEFAULT NULL COMMENT 'DISC 10',
  `QTY_PRICE_1` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 1',
  `QTY_PRICE_2` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 2',
  `QTY_PRICE_3` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 3',
  `QTY_PRICE_4` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 4',
  `QTY_PRICE_5` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 5',
  `QTY_PRICE_6` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 6',
  `QTY_PRICE_7` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 7',
  `QTY_PRICE_8` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 8',
  `QTY_PRICE_9` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 9',
  `QTY_PRICE_10` varchar(25) DEFAULT NULL COMMENT 'QTY PRICE 10',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.df_matrix
CREATE TABLE IF NOT EXISTS `df_matrix` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `_ID` int(11) DEFAULT NULL,
  `STOCK_GROUP` int(11) DEFAULT NULL,
  `ADDED_AT` int(11) DEFAULT NULL,
  `LAST_UPD_AT` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `ACCOUNT_CODE` varchar(10) DEFAULT NULL,
  `DATE` datetime DEFAULT NULL,
  `ADDED_ON` datetime DEFAULT NULL,
  `LAST_UPD_ON` datetime DEFAULT NULL,
  `CODE` varchar(32) DEFAULT NULL,
  `DISC_` decimal(10,0) DEFAULT NULL,
  `PRICE` decimal(10,0) DEFAULT NULL,
  `QTY_1` decimal(10,0) DEFAULT NULL,
  `DISC__1` decimal(10,0) DEFAULT NULL,
  `QTY_2` decimal(10,0) DEFAULT NULL,
  `DISC__2` decimal(10,0) DEFAULT NULL,
  `QTY_3` decimal(10,0) DEFAULT NULL,
  `DISC__3` decimal(10,0) DEFAULT NULL,
  `QTY_4` decimal(10,0) DEFAULT NULL,
  `DISC__4` decimal(10,0) DEFAULT NULL,
  `QTY_5` decimal(10,0) DEFAULT NULL,
  `DISC__5` decimal(10,0) DEFAULT NULL,
  `QTY_6` decimal(10,0) DEFAULT NULL,
  `DISC__6` decimal(10,0) DEFAULT NULL,
  `QTY_7` decimal(10,0) DEFAULT NULL,
  `DISC__7` decimal(10,0) DEFAULT NULL,
  `QTY_8` decimal(10,0) DEFAULT NULL,
  `DISC__8` decimal(10,0) DEFAULT NULL,
  `QTY_9` decimal(10,0) DEFAULT NULL,
  `DISC__9` decimal(10,0) DEFAULT NULL,
  `QTY_10` decimal(10,0) DEFAULT NULL,
  `DISC__10` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_1` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_2` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_3` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_4` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_5` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_6` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_7` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_8` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_9` decimal(10,0) DEFAULT NULL,
  `QTY_PRICE_10` decimal(10,0) DEFAULT NULL,
  `QTY_BRK` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_1` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_2` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_3` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_4` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_5` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_6` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_7` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_8` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_9` varchar(1) DEFAULT NULL,
  `QTY_WH_PR_10` varchar(1) DEFAULT NULL,
  `COMMENT1` varchar(30) DEFAULT NULL,
  `COMMENT2` varchar(30) DEFAULT NULL,
  `COMMENT3` varchar(30) DEFAULT NULL,
  `ACCOUNT_NAME` varchar(30) DEFAULT NULL,
  `DESCRIPTION` varchar(30) DEFAULT NULL,
  `STOCK_CODE` varchar(16) DEFAULT NULL,
  `ADDED_BY` varchar(6) DEFAULT NULL,
  `LAST_UPD_BY` varchar(6) DEFAULT NULL,
  `ACCOUNT_GROUP` int(11) DEFAULT NULL,
  `CUSTOMER_CODE` varchar(10) DEFAULT NULL,
  `PREVENT_SALE` varchar(1) DEFAULT NULL,
  `PREV_MESSAGE` varchar(30) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.df_orders_lines
CREATE TABLE IF NOT EXISTS `df_orders_lines` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `record` int(11) DEFAULT NULL,
  `_id` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `web_order_ref` varchar(64) DEFAULT NULL,
  `order_date` varchar(64) DEFAULT NULL,
  `time` varchar(64) DEFAULT NULL,
  `product` varchar(64) DEFAULT NULL,
  `product_desc` varchar(64) DEFAULT NULL,
  `account_code` varchar(64) DEFAULT NULL,
  `cust_name` varchar(64) DEFAULT NULL,
  `cust_company` varchar(64) DEFAULT NULL,
  `cust_add1` varchar(64) DEFAULT NULL,
  `cust_add2` varchar(64) DEFAULT NULL,
  `cust_town` varchar(64) DEFAULT NULL,
  `cust_county` varchar(64) DEFAULT NULL,
  `cust_country` varchar(64) DEFAULT NULL,
  `cust_postcode` varchar(64) DEFAULT NULL,
  `cust_tel` varchar(64) DEFAULT NULL,
  `cust_email` varchar(64) DEFAULT NULL,
  `cust_porder` varchar(64) DEFAULT NULL,
  `del_name` varchar(64) DEFAULT NULL,
  `del_company` varchar(64) DEFAULT NULL,
  `del_add1` varchar(64) DEFAULT NULL,
  `del_add2` varchar(64) DEFAULT NULL,
  `del_town` varchar(64) DEFAULT NULL,
  `del_county` varchar(64) DEFAULT NULL,
  `del_country` varchar(64) DEFAULT NULL,
  `del_postcode` varchar(64) DEFAULT NULL,
  `del_tel` varchar(64) DEFAULT NULL,
  `paid` varchar(64) DEFAULT NULL,
  `pay_type` varchar(64) DEFAULT NULL,
  `pay_c_status` varchar(64) DEFAULT NULL,
  `pay_processed` varchar(64) DEFAULT NULL,
  `pay_gateway` varchar(64) DEFAULT NULL,
  `pay_trans_ref` varchar(64) DEFAULT NULL,
  `pay_status` varchar(64) DEFAULT NULL,
  `pay_agr_terms` varchar(64) DEFAULT NULL,
  `ipaddress` varchar(64) DEFAULT NULL,
  `ref_site` varchar(64) DEFAULT NULL,
  `del_method` varchar(64) DEFAULT NULL,
  `order_created` varchar(64) DEFAULT NULL,
  `ord_error` varchar(64) DEFAULT NULL,
  `lineid` varchar(64) DEFAULT NULL,
  `web_order_no` varchar(64) DEFAULT NULL,
  `prod_price_to` varchar(64) DEFAULT NULL,
  `order_total` varchar(64) DEFAULT NULL,
  `cust_fax` varchar(64) DEFAULT NULL,
  `_ID1` varchar(64) DEFAULT NULL,
  `pay_total` varchar(64) DEFAULT NULL,
  `OrderID` varchar(64) DEFAULT NULL,
  `__H` varchar(64) DEFAULT NULL,
  `ADD_TIME` varchar(64) DEFAULT NULL,
  `ADD_DATE` varchar(64) DEFAULT NULL,
  `ADD_USER` varchar(64) DEFAULT NULL,
  `product_qty` decimal(10,0) DEFAULT NULL,
  `prod_price_ea` decimal(10,0) DEFAULT NULL,
  `goods_total` decimal(10,0) DEFAULT NULL,
  `ship_total` decimal(10,0) DEFAULT NULL,
  `disc_total` decimal(10,0) DEFAULT NULL,
  `tax_total` decimal(10,0) DEFAULT NULL,
  `bank_nl_code` varchar(12) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.dynamiccss
CREATE TABLE IF NOT EXISTS `dynamiccss` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT '0' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `store_id` int(11) DEFAULT NULL COMMENT 'Store Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  `valuea` varchar(255) DEFAULT NULL COMMENT 'Value A',
  `valueb` varchar(255) DEFAULT NULL COMMENT 'Value B',
  `valuec` varchar(255) DEFAULT NULL COMMENT 'Value C',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `section` varchar(50) DEFAULT NULL COMMENT 'Section',
  `store` varchar(50) DEFAULT NULL COMMENT 'Store',
  `color` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `image` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `status` varchar(255) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.dynamiccss_temp
CREATE TABLE IF NOT EXISTS `dynamiccss_temp` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT '0' COMMENT 'language',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `section` varchar(50) DEFAULT NULL COMMENT 'Section',
  `dynamic_id` varchar(50) DEFAULT NULL COMMENT 'Dynamic ID',
  `store_id` varchar(20) DEFAULT NULL COMMENT 'Store ID',
  `color` varchar(20) DEFAULT NULL COMMENT 'Color',
  `image` varchar(20) DEFAULT NULL COMMENT 'Image',
  `sheet_id` varchar(20) DEFAULT NULL COMMENT 'Sheet ID',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.erp_order
CREATE TABLE IF NOT EXISTS `erp_order` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `name` varchar(255) DEFAULT NULL,
  `ordernumber` varchar(255) DEFAULT NULL,
  `orderref` varchar(255) DEFAULT NULL,
  `porderref` varchar(255) DEFAULT NULL COMMENT 'Purchase Order Reference',
  `corderref` varchar(255) DEFAULT NULL COMMENT 'Customer Reference',
  `paymentmethod` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `billingstatus` varchar(255) DEFAULT NULL,
  `shippingstatus` varchar(255) DEFAULT NULL,
  `consignmentno` varchar(255) DEFAULT NULL,
  `companyname` varchar(255) DEFAULT NULL,
  `courier` varchar(255) DEFAULT NULL,
  `shippingmethod` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL COMMENT 'Country',
  `sourceurl` varchar(255) DEFAULT NULL COMMENT 'Source Url',
  `days_credit` varchar(255) DEFAULT NULL COMMENT 'Days Credit',
  `accounts_email` varchar(255) DEFAULT NULL COMMENT 'Accounts Email',
  `sales_email` varchar(255) DEFAULT NULL COMMENT 'Sales Email',
  `account_code` varchar(10) DEFAULT NULL,
  `date_delivered` date DEFAULT NULL,
  `date_invoiced` date DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `date` int(11) DEFAULT NULL,
  `totalweight` int(11) DEFAULT NULL,
  `dateshipped` int(11) DEFAULT NULL,
  `dateordered` int(11) DEFAULT NULL,
  `invoiceno` int(11) DEFAULT NULL,
  `nooflines` int(11) DEFAULT NULL,
  `erpid` int(11) DEFAULT NULL COMMENT 'ERP ID',
  `erpstatus` int(11) DEFAULT NULL COMMENT 'ERP Status',
  `priceno` int(11) DEFAULT NULL COMMENT 'Price Number',
  `save` bit(1) DEFAULT NULL,
  `terms` bit(1) DEFAULT NULL,
  `deliveryopt` bit(1) DEFAULT NULL,
  `paid` bit(1) DEFAULT NULL,
  `subtotal` decimal(10,4) DEFAULT NULL,
  `ordertotal` decimal(10,4) DEFAULT NULL,
  `invoicetotal` decimal(10,4) DEFAULT NULL,
  `tax` decimal(10,4) DEFAULT NULL,
  `shipping` decimal(10,4) DEFAULT NULL,
  `amountpaid` decimal(10,4) DEFAULT NULL COMMENT 'Amount Paid',
  `message` text DEFAULT NULL,
  `fulladdresses` text DEFAULT NULL,
  `data` text DEFAULT NULL,
  `telephone` varchar(30) DEFAULT NULL,
  `is_shipment` tinyint(1) DEFAULT NULL COMMENT 'allow shipment method if is_shipment set to 1',
  `newsletter` tinyint(1) DEFAULT NULL,
  `createaccount` tinyint(1) DEFAULT NULL,
  `collection_message` longtext DEFAULT NULL COMMENT 'Collection Message',
  `delivery_message` longtext DEFAULT NULL COMMENT 'Delivery Message',
  `orderlines` longtext DEFAULT NULL COMMENT 'Order lines',
  `magestatus` varchar(255) DEFAULT NULL COMMENT 'Magento Status',
  `mageid` int(11) DEFAULT NULL COMMENT 'Magento ID',
  `magecid` int(11) DEFAULT NULL COMMENT 'Magento Customer ID',
  `payment_data` longtext DEFAULT NULL COMMENT 'Payment Data',
  `notes_data` longtext DEFAULT NULL COMMENT 'Notes Data',
  `imported_data` longtext DEFAULT NULL COMMENT 'Imported Data',
  `amountout` decimal(10,4) DEFAULT NULL COMMENT 'Amount Outstanding',
  `discounts` decimal(10,4) DEFAULT NULL COMMENT 'discounts',
  `ipaddress4` varchar(30) DEFAULT NULL COMMENT 'ipaddress4',
  `total` decimal(10,4) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`),
  KEY `total` (`total`),
  KEY `status` (`status`(250))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.forms
CREATE TABLE IF NOT EXISTS `forms` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `form` varchar(15) DEFAULT NULL,
  `data` longtext DEFAULT NULL COMMENT 'Json Form Data',
  `revision` longtext DEFAULT NULL COMMENT 'Json Form Data',
  `subclass` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.importdata
CREATE TABLE IF NOT EXISTS `importdata` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `STOCKGROUP` varchar(100) DEFAULT NULL,
  `BARCODE` varchar(50) DEFAULT NULL,
  `WEIGHT` varchar(50) DEFAULT NULL,
  `STOCKCODE` varchar(25) DEFAULT NULL,
  `WEBNAME` varchar(150) DEFAULT NULL,
  `LENGTH` varchar(7) DEFAULT NULL,
  `HEIGHT` varchar(7) DEFAULT NULL,
  `WIDTH` varchar(6) DEFAULT NULL,
  `COLOUR` varchar(30) DEFAULT NULL,
  `WEBDESCRIPTION` mediumtext DEFAULT NULL,
  `Column 10` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.lookuptable
CREATE TABLE IF NOT EXISTS `lookuptable` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `sourceid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `sequence` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `source` varchar(255) DEFAULT NULL,
  `related` varchar(255) DEFAULT NULL,
  `primaryrecord` bit(1) DEFAULT NULL,
  `sgimage` bit(1) DEFAULT NULL,
  `bannerimage` bit(1) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`),
  KEY `sourceid` (`sourceid`),
  KEY `relatedid` (`relatedid`),
  KEY `primaryrecord` (`primaryrecord`),
  KEY `source` (`source`),
  KEY `related` (`related`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.mailchimphooks
CREATE TABLE IF NOT EXISTS `mailchimphooks` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `data` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.mailinglist
CREATE TABLE IF NOT EXISTS `mailinglist` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `validationcode` binary(36) DEFAULT NULL,
  `userid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `email` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `subscribed` bit(1) DEFAULT NULL,
  `verified` bit(1) DEFAULT NULL,
  `allowcalls` bit(1) DEFAULT NULL,
  `allowtexts` bit(1) DEFAULT NULL,
  `incompletecarts` bit(1) DEFAULT NULL,
  `allowpost` bit(1) DEFAULT NULL,
  `promotions` bit(1) DEFAULT NULL,
  `allowemails` bit(1) DEFAULT NULL,
  `ipaddress` varchar(20) DEFAULT NULL,
  `referer` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data`)),
  `emailsafety` bit(1) DEFAULT NULL,
  `servicereminders` bit(1) DEFAULT NULL,
  `choicenocontact` bit(1) DEFAULT NULL,
  `methodnocontact` bit(1) DEFAULT NULL,
  `systememails` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.migration
CREATE TABLE IF NOT EXISTS `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.news
CREATE TABLE IF NOT EXISTS `news` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `mainimageid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `livedate` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `backgroundimage` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `shortcontent` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `backgroundcolour` varchar(50) DEFAULT NULL,
  `shortcontent_position` varchar(50) DEFAULT NULL,
  `active` bit(1) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `contents` mediumtext DEFAULT NULL,
  `tags` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.notes
CREATE TABLE IF NOT EXISTS `notes` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `mailid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `relatedto` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `private` bit(1) DEFAULT NULL,
  `sendasmail` bit(1) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `text` text DEFAULT NULL,
  `prevnote` text DEFAULT NULL,
  `urgency` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.pagecontents
CREATE TABLE IF NOT EXISTS `pagecontents` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `backgroundimage` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `backgroundcolour` varchar(50) DEFAULT NULL,
  `container` varchar(50) DEFAULT NULL,
  `position` varchar(10) DEFAULT NULL,
  `image_only` bit(1) DEFAULT NULL,
  `contents` mediumtext DEFAULT NULL,
  `class` mediumtext DEFAULT NULL,
  `custom_css` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`),
  KEY `relatedid` (`relatedid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.pagecontents_copy
CREATE TABLE IF NOT EXISTS `pagecontents_copy` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `backgroundimage` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `backgroundcolour` varchar(50) DEFAULT NULL,
  `container` varchar(50) DEFAULT NULL,
  `position` varchar(10) DEFAULT NULL,
  `image_only` bit(1) DEFAULT NULL,
  `contents` mediumtext DEFAULT NULL,
  `class` mediumtext DEFAULT NULL,
  `custom_css` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.pagegroup
CREATE TABLE IF NOT EXISTS `pagegroup` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `centreid` binary(36) DEFAULT NULL COMMENT 'centreid',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `sequence` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `url` varchar(255) DEFAULT NULL COMMENT 'Url',
  `category` varchar(255) DEFAULT NULL COMMENT 'Category',
  `class` varchar(255) DEFAULT NULL COMMENT 'class',
  `position` varchar(255) DEFAULT NULL COMMENT 'position',
  `backgroundimage` varchar(255) DEFAULT NULL COMMENT 'backgroundimage',
  `image_only` varchar(255) DEFAULT NULL COMMENT 'image_only',
  `backgroundcolour` varchar(255) DEFAULT NULL COMMENT 'backgroundcolour',
  `name` varchar(50) DEFAULT NULL COMMENT 'Name',
  `location` varchar(50) DEFAULT NULL COMMENT 'Location',
  `description` mediumtext DEFAULT NULL COMMENT 'Description',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `replacementsource` varchar(255) DEFAULT NULL COMMENT 'Source Model',
  `headerjs` text DEFAULT NULL,
  `footerjs` text DEFAULT NULL,
  `linkurl` bit(1) DEFAULT NULL COMMENT 'Linked Url',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.paymentresponse
CREATE TABLE IF NOT EXISTS `paymentresponse` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `basketid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `result` varchar(255) DEFAULT NULL,
  `authcode` varchar(50) DEFAULT NULL,
  `orderid` varchar(50) DEFAULT NULL,
  `paymentsreference` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.paymentresponses
CREATE TABLE IF NOT EXISTS `paymentresponses` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(5) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `basketid` binary(36) DEFAULT NULL COMMENT 'Basket ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `intamount` int(11) DEFAULT NULL COMMENT 'Amount',
  `statuscode` int(11) DEFAULT NULL COMMENT 'Status',
  `netsuiteid` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `paymentmethod` varchar(255) DEFAULT NULL COMMENT 'Payment Method',
  `authcode` varchar(255) DEFAULT NULL COMMENT 'Auth Code',
  `name` varchar(255) DEFAULT NULL COMMENT 'Customer Code',
  `source` varchar(255) DEFAULT NULL COMMENT 'Sale Source',
  `clientsignature` text DEFAULT NULL COMMENT 'Client Signature',
  `paymentref` varchar(50) DEFAULT NULL COMMENT 'Payment Reference',
  `currency` varchar(10) DEFAULT NULL COMMENT 'Currency',
  `enddate` varchar(10) DEFAULT NULL COMMENT 'End Date',
  `trxdate` varchar(10) DEFAULT NULL COMMENT 'Transaction Date',
  `result` varchar(10) DEFAULT NULL,
  `reconciled` bit(1) DEFAULT NULL COMMENT 'Reconciled',
  `amount` decimal(10,2) DEFAULT NULL COMMENT 'Amount',
  `brand` varchar(20) DEFAULT NULL COMMENT 'Brand',
  `cardno` varchar(20) DEFAULT NULL COMMENT 'Card Number',
  `apaddress` varchar(20) DEFAULT NULL,
  `ipaddress` varchar(20) DEFAULT NULL COMMENT 'IP Address',
  `data` longtext DEFAULT NULL,
  `comment` longtext DEFAULT NULL,
  `bankref` varchar(255) DEFAULT NULL,
  `invoiceid` binary(36) DEFAULT NULL COMMENT 'Basket Id',
  `agencyid` binary(36) DEFAULT NULL COMMENT 'Agent Id',
  `type` varchar(255) DEFAULT NULL COMMENT 'Invoice Type',
  `invoiceno` int(11) DEFAULT NULL COMMENT 'Invoice No',
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`language`),
  KEY `basketid` (`basketid`),
  KEY `paymentref` (`paymentref`),
  KEY `statuscode` (`statuscode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.pdfs
CREATE TABLE IF NOT EXISTS `pdfs` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `filename` varchar(255) DEFAULT NULL COMMENT 'File Name',
  `basketid` binary(36) NOT NULL COMMENT 'Basket Id',
  `ownerid` binary(36) DEFAULT NULL COMMENT 'Agent Id',
  `data` longtext DEFAULT NULL COMMENT 'Base 64 / Gzcompress / DATA',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.products
CREATE TABLE IF NOT EXISTS `products` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `mainimageid` binary(36) DEFAULT NULL,
  `google_category` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `free_stock1` int(11) DEFAULT NULL,
  `sg_sequence` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `snomcode` int(11) DEFAULT NULL,
  `pnomcode` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `stock_code` varchar(255) DEFAULT NULL,
  `stock_group` varchar(255) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_description_extra` varchar(255) DEFAULT NULL,
  `pack_qty` varchar(255) DEFAULT NULL,
  `nom_sales_code` varchar(255) DEFAULT NULL,
  `default_tax` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `linkurl` bit(1) DEFAULT NULL,
  `redirect_on_change` bit(1) DEFAULT NULL,
  `price_type` varchar(255) DEFAULT NULL,
  `colour` varchar(255) DEFAULT NULL,
  `storage` varchar(255) DEFAULT NULL,
  `ms_sitelayout` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `locationurl` varchar(255) DEFAULT NULL,
  `product_short_description` text DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `product_short_description1` varchar(50) DEFAULT NULL,
  `unit` varchar(50) DEFAULT NULL,
  `visibility` varchar(50) DEFAULT NULL,
  `product_type` varchar(50) DEFAULT NULL,
  `webstock` bit(1) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `df_sync` bit(1) DEFAULT NULL,
  `stock_group_master` bit(1) DEFAULT NULL,
  `expires` bit(1) DEFAULT NULL,
  `training` bit(1) DEFAULT NULL,
  `serialnoneeded` bit(1) DEFAULT NULL,
  `microsite` bit(1) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `barcode1` bigint(20) DEFAULT NULL,
  `price1` decimal(10,2) DEFAULT NULL,
  `price2` decimal(10,2) DEFAULT NULL,
  `price3` decimal(10,2) DEFAULT NULL,
  `price4` decimal(10,2) DEFAULT NULL,
  `price5` decimal(10,2) DEFAULT NULL,
  `price6` decimal(10,2) DEFAULT NULL,
  `price7` decimal(10,2) DEFAULT NULL,
  `price8` decimal(10,2) DEFAULT NULL,
  `price9` decimal(10,2) DEFAULT NULL,
  `free_stock` decimal(10,2) DEFAULT NULL,
  `details` mediumtext DEFAULT NULL,
  `qrcode` mediumtext DEFAULT NULL,
  `product_description` mediumtext DEFAULT NULL,
  `search_terms` mediumtext DEFAULT NULL,
  `parentlist` mediumtext DEFAULT NULL,
  `rating` mediumtext DEFAULT NULL,
  `barcode` varchar(20) DEFAULT NULL,
  `categoryname` varchar(255) DEFAULT NULL,
  `categoryid` int(11) DEFAULT NULL,
  `shipping_group` varchar(255) DEFAULT NULL COMMENT 'Shipping Group',
  `ext_data` longtext DEFAULT NULL COMMENT 'Extra Data',
  `importdata` longtext DEFAULT NULL COMMENT 'Imported Data',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `config_json` longtext DEFAULT NULL COMMENT 'Taxonomies',
  `pallet_size` int(11) DEFAULT NULL,
  `number_per_pallet` int(11) DEFAULT NULL,
  `displayname` varchar(255) DEFAULT NULL COMMENT 'Display Name',
  `pallet_weight` decimal(10,2) DEFAULT NULL COMMENT 'Pallet Weight',
  `percentage_of_pallet` decimal(10,2) DEFAULT NULL COMMENT 'Percentage of Pallet Space',
  `filter_data` longtext DEFAULT NULL COMMENT 'Filter Data',
  `clone_count` int(11) DEFAULT 0 COMMENT 'Count of clone',
  `availability_date` date DEFAULT NULL COMMENT 'Availability Date of Product',
  `stock_limit` int(11) DEFAULT NULL COMMENT 'Stock Limit',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.products2
CREATE TABLE IF NOT EXISTS `products2` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `mainimageid` binary(36) DEFAULT NULL,
  `google_category` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `free_stock1` int(11) DEFAULT NULL,
  `sg_sequence` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `snomcode` int(11) DEFAULT NULL,
  `pnomcode` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `stock_code` varchar(255) DEFAULT NULL,
  `stock_group` varchar(255) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_description_extra` varchar(255) DEFAULT NULL,
  `pack_qty` varchar(255) DEFAULT NULL,
  `nom_sales_code` varchar(255) DEFAULT NULL,
  `default_tax` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `linkurl` bit(1) DEFAULT NULL,
  `redirect_on_change` bit(1) DEFAULT NULL,
  `price_type` varchar(255) DEFAULT NULL,
  `colour` varchar(255) DEFAULT NULL,
  `storage` varchar(255) DEFAULT NULL,
  `ms_sitelayout` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `locationurl` varchar(255) DEFAULT NULL,
  `product_short_description` text DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `product_short_description1` varchar(50) DEFAULT NULL,
  `unit` varchar(50) DEFAULT NULL,
  `visibility` varchar(50) DEFAULT NULL,
  `product_type` varchar(50) DEFAULT NULL,
  `webstock` bit(1) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `df_sync` bit(1) DEFAULT NULL,
  `stock_group_master` bit(1) DEFAULT NULL,
  `expires` bit(1) DEFAULT NULL,
  `training` bit(1) DEFAULT NULL,
  `serialnoneeded` bit(1) DEFAULT NULL,
  `microsite` bit(1) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `barcode1` bigint(20) DEFAULT NULL,
  `price1` decimal(10,2) DEFAULT NULL,
  `price2` decimal(10,2) DEFAULT NULL,
  `price3` decimal(10,2) DEFAULT NULL,
  `price4` decimal(10,2) DEFAULT NULL,
  `price5` decimal(10,2) DEFAULT NULL,
  `price6` decimal(10,2) DEFAULT NULL,
  `price7` decimal(10,2) DEFAULT NULL,
  `price8` decimal(10,2) DEFAULT NULL,
  `price9` decimal(10,2) DEFAULT NULL,
  `free_stock` decimal(10,2) DEFAULT NULL,
  `details` mediumtext DEFAULT NULL,
  `qrcode` mediumtext DEFAULT NULL,
  `product_description` mediumtext DEFAULT NULL,
  `search_terms` mediumtext DEFAULT NULL,
  `parentlist` mediumtext DEFAULT NULL,
  `rating` mediumtext DEFAULT NULL,
  `barcode` varchar(20) DEFAULT NULL,
  `categoryname` varchar(255) DEFAULT NULL,
  `categoryid` int(11) DEFAULT NULL,
  `shipping_group` varchar(255) DEFAULT NULL COMMENT 'Shipping Group',
  `ext_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Extra Data',
  `importdata` longtext DEFAULT NULL COMMENT 'Imported Data',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `config_json` longtext DEFAULT NULL COMMENT 'Taxonomies',
  `pallet_size` int(11) DEFAULT NULL,
  `number_per_pallet` int(11) DEFAULT NULL,
  `displayname` varchar(255) DEFAULT NULL COMMENT 'Display Name',
  `pallet_weight` decimal(10,2) DEFAULT NULL COMMENT 'Pallet Weight',
  `percentage_of_pallet` decimal(10,2) DEFAULT NULL COMMENT 'Percentage of Pallet Space',
  `filter_data` longtext DEFAULT NULL COMMENT 'Filter Data',
  `clone_count` int(11) DEFAULT 0 COMMENT 'Count of clone',
  `availability_date` date DEFAULT NULL COMMENT 'Availability Date of Product',
  `stock_limit` int(11) DEFAULT NULL COMMENT 'Stock Limit',
  PRIMARY KEY (`id`,`language`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.products_copy
CREATE TABLE IF NOT EXISTS `products_copy` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `mainimageid` binary(36) DEFAULT NULL,
  `google_category` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `free_stock1` int(11) DEFAULT NULL,
  `sg_sequence` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `snomcode` int(11) DEFAULT NULL,
  `pnomcode` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `stock_code` varchar(255) DEFAULT NULL,
  `stock_group` varchar(255) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_description_extra` varchar(255) DEFAULT NULL,
  `pack_qty` varchar(255) DEFAULT NULL,
  `nom_sales_code` varchar(255) DEFAULT NULL,
  `default_tax` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `linkurl` bit(1) DEFAULT NULL,
  `redirect_on_change` bit(1) DEFAULT NULL,
  `price_type` varchar(255) DEFAULT NULL,
  `colour` varchar(255) DEFAULT NULL,
  `storage` varchar(255) DEFAULT NULL,
  `ms_sitelayout` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `locationurl` varchar(255) DEFAULT NULL,
  `product_short_description` text DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `product_short_description1` varchar(50) DEFAULT NULL,
  `unit` varchar(50) DEFAULT NULL,
  `visibility` varchar(50) DEFAULT NULL,
  `product_type` varchar(50) DEFAULT NULL,
  `webstock` bit(1) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `df_sync` bit(1) DEFAULT NULL,
  `stock_group_master` bit(1) DEFAULT NULL,
  `expires` bit(1) DEFAULT NULL,
  `training` bit(1) DEFAULT NULL,
  `serialnoneeded` bit(1) DEFAULT NULL,
  `microsite` bit(1) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `barcode1` bigint(20) DEFAULT NULL,
  `price1` decimal(10,2) DEFAULT NULL,
  `price2` decimal(10,2) DEFAULT NULL,
  `price3` decimal(10,2) DEFAULT NULL,
  `price4` decimal(10,2) DEFAULT NULL,
  `price5` decimal(10,2) DEFAULT NULL,
  `price6` decimal(10,2) DEFAULT NULL,
  `price7` decimal(10,2) DEFAULT NULL,
  `price8` decimal(10,2) DEFAULT NULL,
  `price9` decimal(10,2) DEFAULT NULL,
  `free_stock` decimal(10,2) DEFAULT NULL,
  `details` mediumtext DEFAULT NULL,
  `qrcode` mediumtext DEFAULT NULL,
  `product_description` mediumtext DEFAULT NULL,
  `search_terms` mediumtext DEFAULT NULL,
  `parentlist` mediumtext DEFAULT NULL,
  `rating` mediumtext DEFAULT NULL,
  `barcode` varchar(20) DEFAULT NULL,
  `categoryname` varchar(255) DEFAULT NULL,
  `categoryid` int(11) DEFAULT NULL,
  `shipping_group` varchar(255) DEFAULT NULL COMMENT 'Shipping Group',
  `ext_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Extra Data',
  `importdata` longtext DEFAULT NULL COMMENT 'Imported Data',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `config_json` longtext DEFAULT NULL COMMENT 'Taxonomies',
  `pallet_size` int(11) DEFAULT NULL,
  `number_per_pallet` int(11) DEFAULT NULL,
  `displayname` varchar(255) DEFAULT NULL COMMENT 'Display Name',
  `pallet_weight` decimal(10,2) DEFAULT NULL COMMENT 'Pallet Weight',
  `percentage_of_pallet` decimal(10,2) DEFAULT NULL COMMENT 'Percentage of Pallet Space',
  `filter_data` longtext DEFAULT NULL COMMENT 'Filter Data',
  `clone_count` int(11) DEFAULT 0 COMMENT 'Count of clone',
  `availability_date` date DEFAULT NULL COMMENT 'Availability Date of Product',
  `stock_limit` int(11) DEFAULT NULL COMMENT 'Stock Limit',
  PRIMARY KEY (`id`,`language`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.queue
CREATE TABLE IF NOT EXISTS `queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel` varchar(255) NOT NULL,
  `job` blob NOT NULL,
  `pushed_at` int(11) NOT NULL,
  `ttr` int(11) NOT NULL,
  `delay` int(11) NOT NULL DEFAULT 0,
  `priority` int(11) unsigned NOT NULL DEFAULT 1024,
  `reserved_at` int(11) DEFAULT NULL,
  `attempt` int(11) DEFAULT NULL,
  `done_at` int(11) DEFAULT NULL,
  `relatedid` binary(36) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `channel` (`channel`),
  KEY `reserved_at` (`reserved_at`),
  KEY `priority` (`priority`)
) ENGINE=InnoDB AUTO_INCREMENT=2014148 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.ratings
CREATE TABLE IF NOT EXISTS `ratings` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `relatedto` varchar(255) DEFAULT NULL,
  `rating` decimal(19,4) DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.realexcodes
CREATE TABLE IF NOT EXISTS `realexcodes` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `code` varchar(50) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.return
CREATE TABLE IF NOT EXISTS `return` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `deliveryaddress` binary(36) DEFAULT NULL,
  `billingaddress` binary(36) DEFAULT NULL,
  `basketid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `date` int(11) DEFAULT NULL,
  `totalweight` int(11) DEFAULT NULL,
  `dateshipped` int(11) DEFAULT NULL,
  `dateordered` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `ordernumber` varchar(255) DEFAULT NULL,
  `orderref` varchar(255) DEFAULT NULL,
  `paymentmethod` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `billingstatus` varchar(255) DEFAULT NULL,
  `shippingstatus` varchar(255) DEFAULT NULL,
  `consignmentno` varchar(255) DEFAULT NULL,
  `courier` varchar(255) DEFAULT NULL,
  `account_code` varchar(10) DEFAULT NULL,
  `terms` bit(1) DEFAULT NULL,
  `subtotal` decimal(10,0) DEFAULT NULL,
  `total` decimal(10,0) DEFAULT NULL,
  `tax` decimal(10,0) DEFAULT NULL,
  `shipping` decimal(10,0) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `fulladdress` mediumtext DEFAULT NULL,
  `telephone` varchar(30) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.returnlines
CREATE TABLE IF NOT EXISTS `returnlines` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `basketlineid` binary(36) DEFAULT NULL,
  `productid` binary(36) DEFAULT NULL,
  `attachment` binary(36) DEFAULT NULL,
  `returnid` binary(36) DEFAULT NULL,
  `basketid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `qty` int(11) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `totalweight` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `reason` varchar(255) DEFAULT NULL,
  `price` decimal(19,4) DEFAULT NULL,
  `disc` decimal(19,4) DEFAULT NULL,
  `vat` decimal(19,4) DEFAULT NULL,
  `totalvat` decimal(19,4) DEFAULT NULL,
  `linetotal` decimal(19,4) DEFAULT NULL,
  `product_name` mediumtext DEFAULT NULL,
  `reasoncomment` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.searchterms
CREATE TABLE IF NOT EXISTS `searchterms` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `possibleproduct` varchar(255) DEFAULT NULL,
  `term` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `results` int(11) DEFAULT NULL COMMENT 'Number of Results',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.seo
CREATE TABLE IF NOT EXISTS `seo` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `related_id` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `related_to` varchar(255) DEFAULT NULL,
  `isbn` varchar(255) DEFAULT NULL,
  `mpn` varchar(255) DEFAULT NULL,
  `upc` varchar(255) DEFAULT NULL,
  `ean` varchar(255) DEFAULT NULL,
  `robot` varchar(255) DEFAULT NULL,
  `directive` varchar(255) DEFAULT NULL,
  `includeinsitemap` bit(1) DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `sku` varchar(500) DEFAULT NULL,
  `url` varchar(500) DEFAULT NULL,
  `offer_type` varchar(500) DEFAULT NULL,
  `offer_price` varchar(500) DEFAULT NULL,
  `offer_pricecurrency` varchar(500) DEFAULT NULL,
  `offer_availability` varchar(500) DEFAULT NULL,
  `canonicalurl` varchar(500) DEFAULT NULL,
  `twitter_card` varchar(500) DEFAULT NULL,
  `twitter_image` varchar(500) DEFAULT NULL,
  `twitter_title` varchar(500) DEFAULT NULL,
  `twitter_site` varchar(500) DEFAULT NULL,
  `twitter_creator` varchar(500) DEFAULT NULL,
  `twitter_description` varchar(500) DEFAULT NULL,
  `relateditem` varchar(500) DEFAULT NULL,
  `og_locale` varchar(500) DEFAULT NULL,
  `og_type` varchar(500) DEFAULT NULL,
  `og_title` varchar(500) DEFAULT NULL,
  `og_description` varchar(500) DEFAULT NULL,
  `og_url` varchar(500) DEFAULT NULL,
  `keywords` mediumtext DEFAULT NULL,
  `newskeywords` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `og_image` varchar(500) DEFAULT NULL COMMENT 'Open Graph Image',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`),
  KEY `related_id` (`related_id`),
  KEY `relatedid` (`relatedid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(5) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `apiurl` varchar(255) DEFAULT NULL COMMENT 'Api Url',
  `username` varchar(255) DEFAULT NULL COMMENT 'Username',
  `password` varchar(255) DEFAULT NULL COMMENT 'Password',
  `authkey` varchar(255) DEFAULT NULL COMMENT 'Auth Key',
  `companyname` varchar(255) DEFAULT NULL COMMENT 'Company Name',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  `name` varchar(255) DEFAULT NULL COMMENT 'Type',
  `setting` varchar(255) DEFAULT NULL,
  `api` bit(1) DEFAULT NULL COMMENT 'api',
  `comment` text DEFAULT NULL COMMENT 'Comments',
  `logindetails` mediumtext DEFAULT NULL,
  `data` mediumtext DEFAULT NULL,
  `authdata` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.shipment
CREATE TABLE IF NOT EXISTS `shipment` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `cart_id` binary(36) DEFAULT NULL COMMENT 'Cart ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `shipment` int(11) DEFAULT NULL COMMENT 'Shipment',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `delivery` varchar(255) DEFAULT NULL,
  `price` decimal(19,4) DEFAULT NULL,
  `no_shipment` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `shipment_date` varchar(255) DEFAULT NULL COMMENT 'shipment date',
  `shipment_type` tinyint(1) DEFAULT 0 COMMENT '"0"=>"delivery","1"=>"collect"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.shipping_costs
CREATE TABLE IF NOT EXISTS `shipping_costs` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `type` varchar(255) DEFAULT NULL COMMENT 'Shipping Type',
  `haulierid` int(11) DEFAULT NULL COMMENT 'Haulier ID',
  `prices` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Price',
  `no_of_prices` int(11) DEFAULT NULL,
  `postcodes` text DEFAULT NULL COMMENT 'Post Codes Range',
  `notes` text DEFAULT NULL COMMENT 'Notes',
  `price` decimal(19,4) DEFAULT NULL COMMENT 'Price',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.shipping_costs_08-21
CREATE TABLE IF NOT EXISTS `shipping_costs_08-21` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `type` varchar(255) DEFAULT NULL COMMENT 'Shipping Type',
  `haulierid` int(11) DEFAULT NULL COMMENT 'Haulier ID',
  `prices` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Price',
  `no_of_prices` int(11) DEFAULT NULL,
  `postcodes` text DEFAULT NULL COMMENT 'Post Codes Range',
  `notes` text DEFAULT NULL COMMENT 'Notes',
  `price` decimal(19,4) DEFAULT NULL COMMENT 'Price',
  PRIMARY KEY (`id`,`language`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.stock_adjustments
CREATE TABLE IF NOT EXISTS `stock_adjustments` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `message` varchar(255) DEFAULT NULL COMMENT 'Message',
  `product_id` binary(36) NOT NULL,
  `old_qty` decimal(10,2) DEFAULT NULL COMMENT 'Old Quantity',
  `new_qty` decimal(10,2) DEFAULT NULL COMMENT 'New Quantity',
  `changed_amnt` decimal(10,2) DEFAULT NULL COMMENT 'Amount Changed',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_communcation
CREATE TABLE IF NOT EXISTS `sys_communcation` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `communication` int(11) DEFAULT NULL COMMENT '"1"=>"newsletter","2"=>"promotions","3"=>"telephone","4"=>"cartupdates"',
  `email` tinyint(1) DEFAULT 0 COMMENT '"0"=>"on","1"=>"off"',
  `sms` tinyint(1) DEFAULT 0 COMMENT '"0"=>"on","1"=>"off"',
  `telephone` tinyint(1) DEFAULT 0 COMMENT '"0"=>"on","1"=>"off"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_companybankingfo
CREATE TABLE IF NOT EXISTS `sys_companybankingfo` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `account_number` int(11) DEFAULT NULL COMMENT 'Account Number',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `bank_name` varchar(55) DEFAULT NULL COMMENT 'Bank Name',
  `address_1` varchar(55) DEFAULT NULL COMMENT 'Address 1',
  `address_2` varchar(55) DEFAULT NULL COMMENT 'Address 2',
  `address_3` varchar(55) DEFAULT NULL COMMENT 'Address 3',
  `town` varchar(55) DEFAULT NULL COMMENT 'Town',
  `county` varchar(55) DEFAULT NULL COMMENT 'County',
  `country` varchar(55) DEFAULT NULL COMMENT 'Country',
  `iban` varchar(34) DEFAULT NULL COMMENT 'IBAN',
  `bic` varchar(11) DEFAULT NULL COMMENT 'BIC',
  `postcode` varchar(11) DEFAULT NULL COMMENT 'Post Code',
  `sort_code` varchar(8) DEFAULT NULL COMMENT 'Sort Code',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_country
CREATE TABLE IF NOT EXISTS `sys_country` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `alpha_2` varchar(255) DEFAULT NULL COMMENT 'Alpha 2',
  `alpha_3` varchar(255) DEFAULT NULL COMMENT 'Alpha 3',
  `numerical` int(11) DEFAULT NULL COMMENT 'Numerical',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_datasources
CREATE TABLE IF NOT EXISTS `sys_datasources` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `cacheduration` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `drivername` varchar(255) DEFAULT NULL,
  `charset` varchar(255) DEFAULT NULL,
  `dsn` mediumtext DEFAULT NULL,
  `cache` bit(1) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `server` text DEFAULT NULL,
  `database` text DEFAULT NULL,
  `encrypt` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_deliverymatrix
CREATE TABLE IF NOT EXISTS `sys_deliverymatrix` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `weightfrom` int(11) DEFAULT NULL,
  `weightto` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `country` varchar(255) DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `stock_code` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `pricefrom` decimal(19,4) DEFAULT NULL,
  `priceto` decimal(19,4) DEFAULT NULL,
  `price` decimal(19,4) DEFAULT NULL,
  `postcode` mediumtext DEFAULT NULL,
  `topostcode` mediumtext DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_delivery_dates
CREATE TABLE IF NOT EXISTS `sys_delivery_dates` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `day` int(11) DEFAULT NULL COMMENT 'Day',
  `month` int(11) DEFAULT NULL COMMENT 'month in number 1 for january, 12 for december',
  `year` int(11) DEFAULT NULL COMMENT 'Year',
  `type` int(11) DEFAULT NULL COMMENT 'Year',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_email_queue
CREATE TABLE IF NOT EXISTS `sys_email_queue` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `actid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `jobno` int(11) DEFAULT NULL,
  `statuscode` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `subject` varchar(255) DEFAULT NULL,
  `from_name` varchar(100) DEFAULT NULL,
  `from_email` varchar(100) DEFAULT NULL,
  `reply_to` varchar(100) DEFAULT NULL,
  `filename` varchar(100) DEFAULT NULL,
  `mimetype` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `charset` varchar(10) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `success` bit(1) DEFAULT NULL,
  `date_published` datetime DEFAULT NULL,
  `last_attempt` datetime DEFAULT NULL,
  `date_sent` datetime DEFAULT NULL,
  `to_email` mediumtext DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `to_cc` mediumtext DEFAULT NULL,
  `to_bcc` mediumtext DEFAULT NULL,
  `to_emailg` mediumtext DEFAULT NULL,
  `logdata` mediumtext DEFAULT NULL,
  `emailfile` longtext DEFAULT NULL,
  `max_attempts` tinyint(3) DEFAULT NULL,
  `attempts` tinyint(3) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `send_after` datetime DEFAULT NULL COMMENT 'Send After',
  PRIMARY KEY (`id`,`language`),
  KEY `type` (`type`),
  KEY `subject` (`subject`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_errors
CREATE TABLE IF NOT EXISTS `sys_errors` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `message` varchar(255) DEFAULT NULL COMMENT 'message',
  `code` int(11) DEFAULT NULL COMMENT 'Code for message',
  `type` set('1','2','3','4') NOT NULL DEFAULT '4' COMMENT '"1" => "Cart", "2" => "Shipping", "3" => "System", "4" => "Other"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_feed_management
CREATE TABLE IF NOT EXISTS `sys_feed_management` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `name` varchar(255) DEFAULT NULL COMMENT 'Feed Name',
  `site_url` varchar(155) DEFAULT NULL COMMENT 'Site base url',
  `template` longtext DEFAULT NULL COMMENT 'Feed Template',
  `is_xml` tinyint(1) DEFAULT 0 COMMENT '"0"=>"need update","1"=>"updated"',
  `taxonomy_management_id` binary(36) DEFAULT NULL COMMENT 'Taxonomy',
  `title` varchar(255) DEFAULT NULL COMMENT 'Feed Name',
  `product_status` tinyint(1) DEFAULT 0 COMMENT '"0"=>"all","1"=>"active"',
  `description` longtext DEFAULT NULL COMMENT 'Feed Description',
  `stock_group` tinyint(1) DEFAULT 0 COMMENT '"0"=>"all","1"=>"active"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_languages
CREATE TABLE IF NOT EXISTS `sys_languages` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `flagurl` varchar(255) DEFAULT NULL COMMENT 'flagurl',
  `tlanguage` varchar(100) DEFAULT NULL COMMENT 'tlanguage',
  `shortcode` varchar(10) DEFAULT NULL COMMENT 'shortcode',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `sequence` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_log
CREATE TABLE IF NOT EXISTS `sys_log` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(5) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `level` int(11) DEFAULT NULL COMMENT 'Level',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `category` varchar(255) DEFAULT NULL COMMENT 'Category',
  `servername` varchar(255) DEFAULT NULL COMMENT 'Server Name',
  `message` mediumtext DEFAULT NULL COMMENT 'Message',
  `prefix` mediumtext DEFAULT NULL COMMENT 'pre_fix',
  `logged` datetime DEFAULT NULL COMMENT 'Logged Time',
  `log_time` decimal(10,0) DEFAULT NULL COMMENT 'Log Time',
  `controller` varchar(50) DEFAULT NULL,
  `action` varchar(50) DEFAULT NULL,
  `source` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`) USING BTREE,
  KEY `relatedid` (`relatedid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_menu
CREATE TABLE IF NOT EXISTS `sys_menu` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `parentid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `sequence` int(11) DEFAULT NULL,
  `accesslevel` int(11) DEFAULT NULL COMMENT 'Access Level Required',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `displayname` varchar(255) DEFAULT NULL,
  `linkto` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `tagtype` varchar(255) DEFAULT NULL,
  `relatedto` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `label` mediumtext DEFAULT NULL,
  `tag` mediumtext DEFAULT NULL,
  `design_positions` varchar(55) DEFAULT NULL COMMENT 'Design Position',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`),
  KEY `parentid` (`parentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_models
CREATE TABLE IF NOT EXISTS `sys_models` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(5) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `sequence` int(11) DEFAULT NULL COMMENT 'Sequence',
  `daysup` int(11) DEFAULT NULL COMMENT 'Days to Sync Up',
  `daysdown` int(11) DEFAULT NULL COMMENT 'Days to Sync Down',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `direction` varchar(255) DEFAULT NULL COMMENT 'Direction',
  `source` varchar(255) DEFAULT NULL COMMENT 'Source Model',
  `sourceid` varchar(255) DEFAULT NULL COMMENT 'Source ID',
  `tablename` varchar(255) DEFAULT NULL COMMENT 'Table Name',
  `destination` varchar(255) DEFAULT NULL COMMENT 'Destination Model',
  `destinationid` varchar(255) DEFAULT NULL COMMENT 'Destination ID',
  `sourceurl` varchar(255) DEFAULT NULL COMMENT 'Source URL',
  `destinationurl` varchar(255) DEFAULT NULL COMMENT 'Destination URL',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  `dsn` text DEFAULT NULL COMMENT 'dsn',
  `cache` bit(1) DEFAULT NULL COMMENT 'cache',
  `initdate` date DEFAULT NULL COMMENT 'Initial Date',
  `conditions` longtext DEFAULT NULL COMMENT 'Conditions Field',
  `datamap` longtext DEFAULT NULL COMMENT 'Data Map',
  `remotefields` longtext DEFAULT NULL COMMENT 'Remote Fields',
  `localfields` longtext DEFAULT NULL COMMENT 'Local Field',
  `date_created_field` varchar(255) DEFAULT NULL,
  `date_updated_field` varchar(255) DEFAULT NULL,
  `timeupdatedfield` varchar(255) DEFAULT NULL,
  `lastdate` date DEFAULT NULL,
  `lasttime` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_paymentlogos
CREATE TABLE IF NOT EXISTS `sys_paymentlogos` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `company_id` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `sequence` int(11) DEFAULT NULL COMMENT 'Sequence',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_preordermail
CREATE TABLE IF NOT EXISTS `sys_preordermail` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `productid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `qty` int(11) DEFAULT NULL COMMENT 'Quantity',
  `type` int(11) DEFAULT NULL COMMENT '"0"=>"delivery","1"=>"collect"',
  `emailSent` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_product_shipping
CREATE TABLE IF NOT EXISTS `sys_product_shipping` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `flagged_by` binary(36) DEFAULT NULL COMMENT 'Flagged By',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `flagged_at` int(11) DEFAULT NULL COMMENT 'Flagged At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `country` varchar(255) DEFAULT NULL COMMENT 'Country',
  `shipping_group` varchar(255) DEFAULT NULL COMMENT 'Shipping Group',
  `customer_group` varchar(255) DEFAULT NULL COMMENT 'Customer Group',
  `shipping_price` varchar(255) DEFAULT NULL COMMENT 'Shipping Price',
  `algorithm` varchar(255) DEFAULT NULL COMMENT 'Algorithm',
  `delivery_type` varchar(255) DEFAULT NULL COMMENT 'Delivery Type',
  `tooltip_notes` varchar(255) DEFAULT NULL COMMENT 'Tooltip/Notes',
  `weight_from` varchar(255) DEFAULT NULL COMMENT 'Weight From',
  `weight_to` varchar(255) DEFAULT NULL COMMENT 'Weight To',
  `price_from` varchar(255) DEFAULT NULL COMMENT 'Price From',
  `price_to` varchar(255) DEFAULT NULL COMMENT 'Price To',
  `volume_from` varchar(255) DEFAULT NULL COMMENT 'Volume From',
  `volume_to` varchar(255) DEFAULT NULL COMMENT 'Volume To',
  `item_from` varchar(255) DEFAULT NULL COMMENT 'Item From',
  `item_to` varchar(255) DEFAULT NULL COMMENT 'Item To',
  `region` varchar(555) DEFAULT NULL COMMENT 'Region',
  `city` varchar(555) DEFAULT NULL COMMENT 'City',
  `zip_from` longtext DEFAULT NULL COMMENT 'Zip From',
  `zip_to` longtext DEFAULT NULL COMMENT 'Zip To',
  `flag` tinyint(1) DEFAULT NULL COMMENT 'flag to maintain import csv data: 0=> to remove,1=> new',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`),
  KEY `zip_from` (`zip_from`(1024))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_product_shipping_temp
CREATE TABLE IF NOT EXISTS `sys_product_shipping_temp` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `country` varchar(255) DEFAULT NULL COMMENT 'Country',
  `shipping_group` varchar(255) DEFAULT NULL COMMENT 'Shipping Group',
  `customer_group` varchar(255) DEFAULT NULL COMMENT 'Customer Group',
  `shipping_price` varchar(255) DEFAULT NULL COMMENT 'Shipping Price',
  `algorithm` varchar(255) DEFAULT NULL COMMENT 'Algorithm',
  `delivery_type` varchar(255) DEFAULT NULL COMMENT 'Delivery Type',
  `tooltip_notes` varchar(255) DEFAULT NULL COMMENT 'Tooltip/Notes',
  `weight_from` varchar(255) DEFAULT NULL COMMENT 'Weight From',
  `weight_to` varchar(255) DEFAULT NULL COMMENT 'Weight To',
  `price_from` varchar(255) DEFAULT NULL COMMENT 'Price From',
  `price_to` varchar(255) DEFAULT NULL COMMENT 'Price To',
  `volume_from` varchar(255) DEFAULT NULL COMMENT 'Volume From',
  `volume_to` varchar(255) DEFAULT NULL COMMENT 'Volume To',
  `item_from` varchar(255) DEFAULT NULL COMMENT 'Item From',
  `item_to` varchar(255) DEFAULT NULL COMMENT 'Item To',
  `store_id` varchar(255) DEFAULT NULL COMMENT 'Store Id',
  `region` varchar(555) DEFAULT NULL COMMENT 'Region',
  `city` varchar(555) DEFAULT NULL COMMENT 'City',
  `zip_from` longtext DEFAULT NULL COMMENT 'Zip From',
  `zip_to` longtext DEFAULT NULL COMMENT 'Zip To',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_session
CREATE TABLE IF NOT EXISTS `sys_session` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `expire` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `data` longblob DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_settings
CREATE TABLE IF NOT EXISTS `sys_settings` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `deliveryproductid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `state` varchar(10) DEFAULT NULL COMMENT 'System State',
  `nickname` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `owner` varchar(255) DEFAULT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `address3` varchar(255) DEFAULT NULL,
  `town` varchar(255) DEFAULT NULL,
  `county` varchar(255) DEFAULT NULL,
  `accountupdateemail` varchar(255) DEFAULT NULL,
  `neworderemail` varchar(255) DEFAULT NULL,
  `newaccountemail` varchar(255) DEFAULT NULL,
  `contactformemail` varchar(255) DEFAULT NULL,
  `sagepaykey` varchar(255) DEFAULT NULL,
  `sagepayurl` varchar(255) DEFAULT NULL,
  `vatno` varchar(255) DEFAULT NULL,
  `registrationno` varchar(255) DEFAULT NULL,
  `emailfrom` varchar(255) DEFAULT NULL,
  `emaildisplayname` varchar(255) DEFAULT NULL,
  `meta_robots` varchar(255) DEFAULT NULL,
  `sitetitle` varchar(255) DEFAULT NULL,
  `noimageimage` varchar(255) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `long` varchar(50) DEFAULT NULL,
  `lat` varchar(50) DEFAULT NULL,
  `center` bit(1) DEFAULT NULL,
  `datafile_matrix` bit(1) DEFAULT NULL,
  `defaultstore` bit(1) DEFAULT NULL,
  `defaultdeliverycost` decimal(19,4) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `logo` mediumtext DEFAULT NULL,
  `googletrackingjs` mediumtext DEFAULT NULL,
  `paypalclientid` mediumtext DEFAULT NULL,
  `paypalclientsecret` mediumtext DEFAULT NULL,
  `googleverification` mediumtext DEFAULT NULL,
  `rates` mediumtext DEFAULT NULL,
  `deliverycutoff` varchar(5) DEFAULT NULL,
  `postcode` varchar(8) DEFAULT NULL,
  `seckey` binary(36) NOT NULL DEFAULT uuid() COMMENT 'Security GUID',
  `storeid` varchar(3) DEFAULT NULL COMMENT 'Store ID',
  `googletrackingjs_footer` text DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `basicurl` varchar(255) DEFAULT NULL COMMENT 'Basic URL',
  `data` longtext DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `ext_data` longtext DEFAULT NULL COMMENT 'Extra Data',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_settings_cust
CREATE TABLE IF NOT EXISTS `sys_settings_cust` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `weatherid` int(11) DEFAULT NULL COMMENT 'Weather ID',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `location` varchar(255) DEFAULT NULL COMMENT 'Purchase Location',
  `locationurl` varchar(255) DEFAULT NULL COMMENT 'Purchase Location URL',
  `regformpage1` bit(1) DEFAULT NULL COMMENT 'Registration Form Page 1',
  `regformpage2` bit(1) DEFAULT NULL COMMENT 'Registration Form Page 2',
  `regformpage3` bit(1) DEFAULT NULL COMMENT 'Registration Form Page 3',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_shipgroup
CREATE TABLE IF NOT EXISTS `sys_shipgroup` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `is_default` int(11) DEFAULT NULL COMMENT 'Deafault',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_shipping_setting
CREATE TABLE IF NOT EXISTS `sys_shipping_setting` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `max_shipping_cost` varchar(255) DEFAULT NULL COMMENT 'Maximun Shipping Cost',
  `shipping_promotion` varchar(255) DEFAULT NULL COMMENT 'Free Shippimg Promotion Text',
  `zero_cost_shipping` varchar(255) DEFAULT NULL COMMENT 'Zero Cost Shipping Text',
  `handling_fee` varchar(255) DEFAULT NULL COMMENT 'Zero Cost Shipping Text',
  `countries` varchar(255) DEFAULT NULL COMMENT 'Ship to Specific Countries',
  `error_message` varchar(255) DEFAULT NULL COMMENT 'Displayed Error Message',
  `shipping_group` varchar(255) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `totaling_algo` varchar(255) DEFAULT NULL COMMENT 'Totaling Algorithm',
  `applicable_countries` int(11) DEFAULT NULL COMMENT 'Ship to Applicable Countries',
  `enabled` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `package_id` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `post_code_range` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `uk_post_code` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `discount_price` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `exclude_fornt_price` tinyint(1) DEFAULT 0 COMMENT 'Exclude Fornt Price',
  `cal_handling_fee` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `apply_handling_fee` tinyint(1) DEFAULT 0 COMMENT '"0"=>"no","1"=>"yes"',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_social
CREATE TABLE IF NOT EXISTS `sys_social` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `company_id` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL COMMENT 'Sequence',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_taxonomy_feed
CREATE TABLE IF NOT EXISTS `sys_taxonomy_feed` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `country` binary(36) DEFAULT NULL COMMENT 'Country',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `url` varchar(255) DEFAULT NULL COMMENT 'Taxonomy URL',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_taxonomy_file
CREATE TABLE IF NOT EXISTS `sys_taxonomy_file` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `file_name` varchar(255) DEFAULT NULL COMMENT 'File Name with extension',
  `from` varchar(255) DEFAULT NULL COMMENT 'from',
  `to` varchar(255) DEFAULT NULL COMMENT 'to',
  `chunk` varchar(255) DEFAULT NULL COMMENT 'chunk',
  `message` longtext DEFAULT NULL COMMENT 'message',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_taxonomy_management
CREATE TABLE IF NOT EXISTS `sys_taxonomy_management` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `full_path` varchar(255) DEFAULT NULL COMMENT 'Full Path',
  `last_child` varchar(255) DEFAULT NULL COMMENT 'Last Child',
  `taxonomy_id` int(11) DEFAULT NULL COMMENT 'Taxonomy ID',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_taxonomy_template
CREATE TABLE IF NOT EXISTS `sys_taxonomy_template` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `fields` longtext DEFAULT NULL COMMENT 'Json of fields',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_urlmanager
CREATE TABLE IF NOT EXISTS `sys_urlmanager` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `relatedguid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `sequence` int(11) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `reason` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `source` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `relatedto` varchar(255) DEFAULT NULL,
  `anchor` varchar(255) DEFAULT NULL,
  `relateditem` varchar(255) DEFAULT NULL,
  `comment` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_user
CREATE TABLE IF NOT EXISTS `sys_user` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `agentid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `blocked_at` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `username` varchar(255) DEFAULT NULL,
  `auth_key` varchar(255) DEFAULT NULL,
  `password_hash` varchar(255) DEFAULT NULL,
  `password_reset_token` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `access_token` varchar(255) DEFAULT NULL,
  `api` bit(1) DEFAULT NULL COMMENT 'Api Access',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_useradv
CREATE TABLE IF NOT EXISTS `sys_useradv` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `userid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `accesslevel` int(11) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `mageid` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `salutation` varchar(10) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `staff` bit(1) DEFAULT NULL,
  `phoneno` varchar(12) DEFAULT NULL,
  `mobileno` varchar(12) DEFAULT NULL,
  `bio` mediumtext DEFAULT NULL,
  `account_code` varchar(20) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `type` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `reg` varchar(255) DEFAULT NULL,
  `nationality` varchar(255) DEFAULT NULL,
  `gender` varchar(100) DEFAULT NULL,
  `dob` varchar(100) DEFAULT NULL,
  `preferedlanguage` varchar(10) DEFAULT NULL,
  `firstlogin` bit(1) DEFAULT NULL,
  `firstlogin_at` datetime DEFAULT NULL,
  `loginalert` bit(1) DEFAULT NULL,
  `managerid` binary(36) DEFAULT NULL,
  `addressid` binary(36) DEFAULT NULL,
  `phoneno1` varchar(12) DEFAULT NULL,
  `mobileno1` varchar(12) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `qrcode` text DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `relatedid` (`relatedid`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.sys_usergroups
CREATE TABLE IF NOT EXISTS `sys_usergroups` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `alerts` bit(1) DEFAULT NULL COMMENT 'alerts',
  `description` mediumtext DEFAULT NULL COMMENT 'description',
  `mcwid` int(11) DEFAULT NULL COMMENT 'Mail Chimp ID',
  `mcid` varchar(50) DEFAULT NULL COMMENT 'Mail Chimp ID',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.tax_rates
CREATE TABLE IF NOT EXISTS `tax_rates` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `country` varchar(255) DEFAULT NULL COMMENT 'country',
  `sales_rate` decimal(10,0) DEFAULT NULL COMMENT 'sales_rate',
  `purchase_rate` decimal(10,0) DEFAULT NULL COMMENT 'purchase_rate',
  `type` varchar(1) DEFAULT NULL COMMENT 'type',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.terms
CREATE TABLE IF NOT EXISTS `terms` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `userid` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `ip` varchar(15) DEFAULT NULL,
  `terms` bit(1) DEFAULT NULL,
  `revision` varchar(6) DEFAULT NULL,
  `agent` mediumtext DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.ticket
CREATE TABLE IF NOT EXISTS `ticket` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `basketid` binary(36) DEFAULT NULL,
  `customer_id` binary(36) DEFAULT NULL,
  `order_id` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `client_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `priority` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `orderref` int(11) DEFAULT NULL,
  `reference` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `private` bit(1) DEFAULT NULL,
  `sendemail` bit(1) DEFAULT NULL,
  `updated` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.uploads
CREATE TABLE IF NOT EXISTS `uploads` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(10) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `approved_by` binary(36) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `size` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `reviewdate` int(11) DEFAULT NULL,
  `approved_at` int(11) DEFAULT NULL,
  `jobno` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `type` varchar(255) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `filepath` varchar(255) DEFAULT NULL,
  `mime` varchar(255) DEFAULT NULL,
  `alttag` varchar(255) DEFAULT NULL,
  `ofilepath` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `relatedto` varchar(50) DEFAULT NULL,
  `revision` varchar(50) DEFAULT NULL,
  `data` mediumtext DEFAULT NULL,
  `comments` mediumtext DEFAULT NULL,
  `searchterms` mediumtext DEFAULT NULL,
  `signature` mediumtext DEFAULT NULL,
  `lat` varchar(45) DEFAULT NULL,
  `long` varchar(45) DEFAULT NULL,
  `datetaken` varchar(45) DEFAULT NULL,
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Created By Name',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Updated By Name',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Deleted By Name',
  `anchor_tag` varchar(255) DEFAULT NULL COMMENT 'Link',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeshop-ahsgardoo.vouchers
CREATE TABLE IF NOT EXISTS `vouchers` (
  `id` binary(36) NOT NULL DEFAULT uuid() COMMENT 'id',
  `language` varchar(5) NOT NULL DEFAULT 'en' COMMENT 'language',
  `created_by` binary(36) DEFAULT NULL COMMENT 'Created By',
  `updated_by` binary(36) DEFAULT NULL COMMENT 'Updated By',
  `deleted_by` binary(36) DEFAULT NULL COMMENT 'Deleted By',
  `relatedid` binary(36) DEFAULT NULL COMMENT 'Related ID',
  `centerid` binary(36) DEFAULT NULL COMMENT 'Center ID',
  `tomainimage` binary(36) DEFAULT NULL COMMENT 'Tour Operator Image',
  `issuingto` binary(36) DEFAULT NULL COMMENT 'Issuing Tour Operator',
  `clientid` binary(36) DEFAULT NULL COMMENT 'Client ID',
  `created_at` int(11) DEFAULT NULL COMMENT 'Created At',
  `updated_at` int(11) DEFAULT NULL COMMENT 'Updated At',
  `deleted_at` int(11) DEFAULT NULL COMMENT 'Deleted At',
  `code` int(11) DEFAULT NULL COMMENT 'Nominal Code',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `createdby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `updatedby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `deletedby_name` varchar(255) DEFAULT NULL COMMENT 'Status',
  `name` varchar(255) DEFAULT NULL COMMENT 'Voucher Name',
  `email` varchar(255) DEFAULT NULL COMMENT 'Issued to Email',
  `issuesby` varchar(255) DEFAULT NULL COMMENT 'Issued By',
  `extref` varchar(50) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL COMMENT 'Description',
  `qrcode` text DEFAULT NULL,
  `value` decimal(10,2) DEFAULT NULL COMMENT 'Value (euro)',
  `remaining` decimal(10,2) DEFAULT NULL,
  `used` bit(1) DEFAULT NULL COMMENT 'Used',
  `startdate` date DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data exporting was unselected.

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
