-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.11.14-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 ngaugeportal-ahshub
CREATE DATABASE IF NOT EXISTS `ngaugeportal-ahshub` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci */;
USE `ngaugeportal-ahshub`;

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `account_code` varchar(255) DEFAULT NULL,
  `account_group` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `web_email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `salesperson` varchar(255) DEFAULT NULL COMMENT 'Sales Person',
  `referredby` varchar(255) DEFAULT NULL COMMENT 'Reffered By',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `acctype` text DEFAULT NULL COMMENT 'Account Type',
  `custype` text DEFAULT NULL COMMENT 'Customer Type',
  `marketingdate` date DEFAULT NULL,
  `address` blob DEFAULT NULL,
  `parentaccount` blob DEFAULT NULL COMMENT 'Parent Account',
  `extended` longtext DEFAULT NULL COMMENT 'Extended Data',
  `data` longtext DEFAULT NULL COMMENT 'JSON Data',
  `price_number` int(11) DEFAULT NULL,
  `intid` int(11) DEFAULT NULL,
  `stop` bit(1) DEFAULT NULL,
  `web_stop` bit(1) DEFAULT NULL,
  `web_client` bit(1) DEFAULT NULL,
  `allowcalls` bit(1) DEFAULT NULL,
  `allowemails` bit(1) DEFAULT NULL,
  `minfreedelivery` decimal(19,4) DEFAULT NULL,
  `deliverysupplement` decimal(19,4) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `rate` varchar(10) DEFAULT NULL,
  `accountid` blob DEFAULT NULL,
  `type` varchar(36) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `contact_email` tinyint(1) DEFAULT NULL COMMENT '"1"=>"Use contact email","0"=>"do not use contact email"',
  `is_default` tinyint(1) DEFAULT NULL COMMENT '"1"=>"Default Address","0"=>"Other Addresses"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `class` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `comment` text DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `type` blob DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `type` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `length` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `tooltip` text DEFAULT NULL,
  `value` varchar(50) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `typeid` blob DEFAULT NULL,
  `attributeid` blob DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `value` text DEFAULT NULL,
  `relatedto` varchar(50) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `attributeid` blob DEFAULT NULL,
  `decimal` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `attributesetid` blob DEFAULT NULL,
  `attributeid` blob DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.audit
CREATE TABLE IF NOT EXISTS `audit` (
  `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',
  `starttime` int(11) DEFAULT NULL COMMENT 'starttime',
  `finishtime` int(11) DEFAULT NULL COMMENT 'finishtime',
  `totaltime` int(11) DEFAULT NULL COMMENT 'totaltime',
  `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',
  `controller` varchar(255) DEFAULT NULL COMMENT 'controller',
  `action` varchar(255) DEFAULT NULL COMMENT 'action',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `oldattribs` text DEFAULT NULL COMMENT 'oldattribs',
  `newattribs` text DEFAULT NULL COMMENT 'newattribs',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `centrename` varchar(255) DEFAULT NULL,
  `name` 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,
  `country` varchar(255) DEFAULT NULL COMMENT 'Country',
  `sourceurl` varchar(255) DEFAULT NULL COMMENT 'Source Url',
  `porderref` varchar(255) DEFAULT NULL COMMENT 'Purchase Order Refernce',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `message` text DEFAULT NULL,
  `fulladdresses` text DEFAULT NULL,
  `data` text DEFAULT NULL,
  `fulladdress` text DEFAULT NULL,
  `account_code` varchar(10) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `deliveryaddress` blob DEFAULT NULL,
  `billingaddress` blob DEFAULT NULL,
  `agentid` blob DEFAULT NULL,
  `accountid` blob DEFAULT NULL COMMENT 'Account ID',
  `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,
  `ordernumber` int(11) DEFAULT NULL,
  `orderref` int(11) DEFAULT NULL,
  `stage` int(11) DEFAULT NULL,
  `save` bit(1) DEFAULT NULL,
  `terms` bit(1) DEFAULT NULL,
  `deliveryopt` bit(1) DEFAULT NULL,
  `paid` bit(1) DEFAULT NULL,
  `subtotal` decimal(10,5) DEFAULT NULL,
  `total` decimal(10,5) DEFAULT NULL,
  `tax` decimal(10,5) DEFAULT NULL,
  `shipping` decimal(10,5) DEFAULT NULL,
  `amountpaid` decimal(10,5) DEFAULT NULL,
  `amountout` decimal(10,5) 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',
  `delivery_notes` longtext DEFAULT NULL COMMENT 'Delivery Message',
  `extended` longtext DEFAULT NULL COMMENT 'Extended JSON Data',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `stock_code` varchar(255) DEFAULT NULL COMMENT 'Stock Code',
  `firstname` varchar(255) DEFAULT NULL COMMENT 'First Name',
  `lastname` varchar(255) DEFAULT NULL COMMENT 'Last Name',
  `ref` varchar(255) DEFAULT NULL COMMENT 'Reference',
  `currency_code` varchar(255) DEFAULT NULL COMMENT 'Currency Code',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `product_name` text DEFAULT NULL,
  `product_description` text DEFAULT NULL,
  `paid` bit(1) DEFAULT NULL,
  `pricelocked` bit(1) DEFAULT NULL,
  `requested_date` date DEFAULT NULL COMMENT 'Delivery / Collection requested date',
  `basketid` blob DEFAULT NULL,
  `productid` blob DEFAULT NULL,
  `customerid` blob DEFAULT NULL,
  `shipgroupid` blob DEFAULT NULL,
  `nameid` blob DEFAULT NULL,
  `orderref` int(11) DEFAULT NULL,
  `qty` decimal(19,5) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `totalweight` int(11) DEFAULT NULL,
  `shipmentline` int(11) DEFAULT NULL COMMENT 'Shipment Sequence No',
  `price` decimal(19,5) DEFAULT NULL,
  `disc` decimal(19,5) DEFAULT NULL,
  `vat` decimal(19,5) DEFAULT NULL,
  `totalvat` decimal(19,5) DEFAULT NULL,
  `linetotal` decimal(19,5) DEFAULT NULL,
  `glinetotal` decimal(19,5) DEFAULT NULL,
  `price_exvat` decimal(19,5) DEFAULT NULL,
  `taxrate` decimal(19,5) DEFAULT NULL,
  `amountout` decimal(19,5) DEFAULT NULL,
  `cost` decimal(19,5) DEFAULT NULL,
  `costtotal` decimal(19,5) DEFAULT NULL,
  `dispatch` tinyint(1) DEFAULT NULL COMMENT '"0"=>"delivery","1"=>"collect"',
  `lockqty` tinyint(1) DEFAULT NULL COMMENT 'Lock Qty',
  `deliveryline` tinyint(1) DEFAULT NULL COMMENT 'Delivery Line',
  `stockreduction` tinyint(1) DEFAULT NULL COMMENT '"0"=>"new","1"=>"reduced"',
  `extended` longtext DEFAULT NULL COMMENT 'Extended JSON Data',
  `taxdetails` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`,`language`),
  KEY `relatedid` (`relatedid`),
  KEY `basketid` (`basketid`(3072)),
  KEY `productid` (`productid`(3072)),
  KEY `shipgroupid` (`shipgroupid`(3072))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.cache
CREATE TABLE IF NOT EXISTS `cache` (
  `id` char(128) NOT NULL COMMENT 'ID',
  `expire` int(11) DEFAULT NULL COMMENT 'Expire Time',
  `data` longblob DEFAULT NULL COMMENT 'Cache Data',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `url` varchar(255) DEFAULT NULL,
  `ms_sitelayout` varchar(255) DEFAULT NULL COMMENT 'Microsite Layout',
  `type` varchar(255) DEFAULT NULL COMMENT 'Category Type',
  `subheading` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `description` text DEFAULT NULL,
  `parentlist` text DEFAULT NULL,
  `rating` text DEFAULT NULL,
  `short_description` varchar(50) DEFAULT NULL,
  `snippet` varchar(50) DEFAULT NULL COMMENT 'Snippet',
  `display` varchar(50) DEFAULT NULL,
  `parent_id` blob DEFAULT NULL,
  `mainimageid` blob DEFAULT NULL COMMENT 'Main Image ID',
  `intid` int(11) DEFAULT NULL,
  `childcount` int(11) DEFAULT NULL,
  `productcount` int(11) DEFAULT NULL,
  `totalproducts` int(11) DEFAULT NULL,
  `show_on_menu` bit(1) DEFAULT NULL,
  `microsite` bit(1) DEFAULT NULL COMMENT 'Microsite',
  `linkurl` bit(1) DEFAULT NULL COMMENT 'LinkUrl',
  `sequence` bigint(20) DEFAULT NULL,
  `low_price` decimal(19,4) DEFAULT NULL COMMENT 'Low Price (FROM)',
  `low_prices` longtext DEFAULT NULL COMMENT 'Json of Low Prices',
  `childcounts` longtext DEFAULT NULL COMMENT 'Json Categories counts per Branch',
  `productcounts` longtext DEFAULT NULL COMMENT 'Json Product counts per Branch',
  `searchfilters` longtext DEFAULT NULL,
  `related` longtext DEFAULT NULL,
  `imageData` longtext DEFAULT NULL,
  `urlData` longtext DEFAULT NULL,
  `category_type` tinyint(1) DEFAULT NULL COMMENT '"0"=>"Default","1"=>"Feed"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.data
CREATE TABLE IF NOT EXISTS `data` (
  `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',
  `revision` int(11) DEFAULT NULL,
  `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',
  `group` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `class` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `data` longtext DEFAULT NULL COMMENT 'Data',
  `revision_reason` longtext DEFAULT NULL,
  `indexes` longtext DEFAULT NULL,
  `indexes_ref` varchar(255) GENERATED ALWAYS AS (json_value(`data`,'$.TxREF')) VIRTUAL,
  `indexes_erpid` varchar(255) GENERATED ALWAYS AS (json_value(`data`,'$.erpid')) VIRTUAL,
  `indexes_account` varchar(255) GENERATED ALWAYS AS (json_value(`data`,'$.ACCOUNT')) VIRTUAL,
  `indexes_delaccount` varchar(255) GENERATED ALWAYS AS (json_value(`data`,'$.DEL_ADD_ACC')) VIRTUAL,
  `indexes_date` varchar(255) GENERATED ALWAYS AS (json_value(`data`,'$.TxDATE')) VIRTUAL,
  PRIMARY KEY (`id`,`language`,`type`),
  KEY `indexes_ref` (`indexes_ref`),
  KEY `indexes_account` (`indexes_account`),
  KEY `indexes_delaccount` (`indexes_delaccount`),
  KEY `indexes_erpid` (`indexes_erpid`),
  KEY `group` (`group`),
  KEY `type` (`type`),
  KEY `indexes_date` (`indexes_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.data_checks
CREATE TABLE IF NOT EXISTS `data_checks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sourceClass` varchar(255) DEFAULT NULL,
  `destinationClass` varchar(255) DEFAULT NULL,
  `_ID` int(11) DEFAULT NULL,
  `EPRKEY` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `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,
  `ACCOUNT_GROUP` int(11) 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',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `ACCOUNT_CODE` varchar(10) DEFAULT NULL,
  `CUSTOMER_CODE` varchar(10) DEFAULT NULL,
  `DATE` datetime DEFAULT NULL,
  `FROM_DATE` datetime DEFAULT NULL,
  `ADDED_ON` datetime DEFAULT NULL,
  `LAST_UPD_ON` datetime DEFAULT NULL,
  `_ID` int(11) DEFAULT NULL,
  `STOCK_GROUP` int(11) DEFAULT NULL,
  `ADDED_AT` int(11) DEFAULT NULL,
  `LAST_UPD_AT` int(11) DEFAULT NULL,
  `ACCOUNT_GROUP` int(11) DEFAULT NULL,
  `CODE` varchar(32) DEFAULT NULL,
  `DISC_` decimal(10,5) DEFAULT NULL,
  `PRICE` decimal(10,5) DEFAULT NULL,
  `QTY_1` decimal(10,5) DEFAULT NULL,
  `DISC__1` decimal(10,5) DEFAULT NULL,
  `QTY_2` decimal(10,5) DEFAULT NULL,
  `DISC__2` decimal(10,5) DEFAULT NULL,
  `QTY_3` decimal(10,5) DEFAULT NULL,
  `DISC__3` decimal(10,5) DEFAULT NULL,
  `QTY_4` decimal(10,5) DEFAULT NULL,
  `DISC__4` decimal(10,5) DEFAULT NULL,
  `QTY_5` decimal(10,5) DEFAULT NULL,
  `DISC__5` decimal(10,5) DEFAULT NULL,
  `QTY_6` decimal(10,5) DEFAULT NULL,
  `DISC__6` decimal(10,5) DEFAULT NULL,
  `QTY_7` decimal(10,5) DEFAULT NULL,
  `DISC__7` decimal(10,5) DEFAULT NULL,
  `QTY_8` decimal(10,5) DEFAULT NULL,
  `DISC__8` decimal(10,5) DEFAULT NULL,
  `QTY_9` decimal(10,5) DEFAULT NULL,
  `DISC__9` decimal(10,5) DEFAULT NULL,
  `QTY_10` decimal(10,5) DEFAULT NULL,
  `DISC__10` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_1` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_2` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_3` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_4` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_5` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_6` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_7` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_8` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_9` decimal(10,5) DEFAULT NULL,
  `QTY_PRICE_10` decimal(10,5) 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,
  `PREVENT_SALE` 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,
  `PREV_MESSAGE` varchar(30) DEFAULT NULL,
  `STOCK_CODE` varchar(16) DEFAULT NULL,
  `ADDED_BY` varchar(6) DEFAULT NULL,
  `LAST_UPD_BY` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.dynamiccss
CREATE TABLE IF NOT EXISTS `dynamiccss` (
  `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 'Name',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `valuea` varchar(255) DEFAULT NULL COMMENT 'Value A',
  `valueb` varchar(255) DEFAULT NULL COMMENT 'Value B',
  `valuec` varchar(255) DEFAULT NULL COMMENT 'Value C',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `section` varchar(50) DEFAULT NULL COMMENT 'Section',
  `store` varchar(50) DEFAULT NULL COMMENT 'Store',
  `store_id` int(11) DEFAULT NULL COMMENT 'Store Id',
  `color` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `image` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.dynamiccss_temp
CREATE TABLE IF NOT EXISTS `dynamiccss_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',
  `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 'Name',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `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',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `message` text DEFAULT NULL,
  `fulladdresses` text DEFAULT NULL,
  `data` text DEFAULT NULL,
  `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',
  `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',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for view ngaugeportal-ahshub.erp_outstanding_balance
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `erp_outstanding_balance` (
	`id` BINARY(36) NOT NULL COMMENT 'id',
	`language` VARCHAR(1) NOT NULL COMMENT 'language' COLLATE 'utf8mb3_general_ci',
	`created_by` BINARY(36) NULL COMMENT 'Created By',
	`updated_by` BINARY(36) NULL COMMENT 'Updated By',
	`deleted_by` BINARY(36) NULL COMMENT 'Deleted By',
	`relatedid` BINARY(36) NULL COMMENT 'Related ID',
	`centerid` BINARY(36) NULL COMMENT 'Center ID',
	`created_at` INT(11) NULL COMMENT 'Created At',
	`updated_at` INT(11) NULL COMMENT 'Updated At',
	`deleted_at` INT(11) NULL COMMENT 'Deleted At',
	`revision` INT(11) NULL,
	`status` VARCHAR(1) NULL COMMENT 'Status' COLLATE 'utf8mb3_general_ci',
	`createdby_name` VARCHAR(1) NULL COMMENT 'Created By Name' COLLATE 'utf8mb3_general_ci',
	`updatedby_name` VARCHAR(1) NULL COMMENT 'Updated By Name' COLLATE 'utf8mb3_general_ci',
	`deletedby_name` VARCHAR(1) NULL COMMENT 'Deleted By Name' COLLATE 'utf8mb3_general_ci',
	`group` VARCHAR(1) NULL COLLATE 'utf8mb3_general_ci',
	`name` VARCHAR(1) NULL COLLATE 'utf8mb3_general_ci',
	`type` VARCHAR(1) NOT NULL COLLATE 'utf8mb3_general_ci',
	`class` VARCHAR(1) NULL COLLATE 'utf8mb3_general_ci',
	`seodata` TEXT NULL COMMENT 'Seo Data' COLLATE 'utf8mb3_general_ci',
	`data` LONGTEXT NULL COMMENT 'Data' COLLATE 'utf8mb3_general_ci',
	`indexes` LONGTEXT NULL COLLATE 'utf8mb3_general_ci',
	`revision_reason` LONGTEXT NULL COLLATE 'utf8mb3_general_ci',
	`ACCOUNT` VARCHAR(1) NULL COLLATE 'utf8mb3_general_ci',
	`DATE` DATE NULL,
	`OS` DECIMAL(10,4) NULL
);

-- Dumping structure for table ngaugeportal-ahshub.fault
CREATE TABLE IF NOT EXISTS `fault` (
  `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',
  `cw_updated` int(11) DEFAULT NULL COMMENT 'Last Updated time from Connectwise',
  `cw_created` int(11) DEFAULT NULL COMMENT 'Created time from Connectwise',
  `cs_id` int(11) DEFAULT NULL COMMENT 'Ticket Number from Connectwise',
  `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 Address',
  `company_name` varchar(255) DEFAULT NULL COMMENT 'Company Name',
  `telephone_no` varchar(255) DEFAULT NULL COMMENT 'Telephone Number',
  `subject` varchar(255) DEFAULT NULL COMMENT 'Subject',
  `attachment` varchar(255) DEFAULT NULL COMMENT 'Attachment',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `message` longtext DEFAULT NULL COMMENT 'Message',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.fault_notes
CREATE TABLE IF NOT EXISTS `fault_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',
  `fault_id` binary(36) DEFAULT NULL COMMENT 'Fault 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',
  `cw_created` int(11) DEFAULT NULL COMMENT 'Created time for Notes from Connectwise',
  `cs_id` int(11) DEFAULT NULL COMMENT 'Ticket Number from Connectwise',
  `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',
  `attachment` varchar(255) DEFAULT NULL COMMENT 'Attachment',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `message` longtext DEFAULT NULL COMMENT 'Message',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `class` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `form` varchar(255) DEFAULT NULL,
  `subclass` varchar(15) DEFAULT NULL,
  `data` longtext DEFAULT NULL COMMENT 'Form Data',
  `captchadata` longtext DEFAULT NULL COMMENT 'Captcha Data',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `WEBDESCRIPTION` text DEFAULT NULL,
  `Column 10` text DEFAULT NULL,
  `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,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `source` varchar(255) DEFAULT NULL,
  `related` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `sourceid` blob DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `data` longtext DEFAULT NULL,
  `primaryrecord` bit(1) DEFAULT NULL,
  `sgimage` bit(1) DEFAULT NULL,
  `bannerimage` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`),
  KEY `sourceid` (`sourceid`(3072)),
  KEY `primaryrecord` (`primaryrecord`),
  KEY `related` (`related`),
  KEY `relatedid` (`relatedid`),
  KEY `source` (`source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `data` text DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `referer` text DEFAULT NULL,
  `validationcode` blob DEFAULT NULL,
  `userid` blob 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,
  `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,
  `ipaddress` varchar(20) DEFAULT NULL,
  `data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `contents` text DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `class` varchar(50) DEFAULT NULL,
  `backgroundcolour` varchar(50) DEFAULT NULL,
  `shortcontent_position` varchar(50) DEFAULT NULL,
  `mainimageid` blob DEFAULT NULL,
  `livedate` int(11) DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `active` bit(1) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `note` text DEFAULT NULL,
  `text` text DEFAULT NULL,
  `prevnote` text DEFAULT NULL,
  `private` bit(1) DEFAULT NULL,
  `sendasmail` bit(1) DEFAULT NULL,
  `urgency` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `backgroundimage` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `contents` text DEFAULT NULL,
  `class` text DEFAULT NULL,
  `custom_css` text DEFAULT NULL,
  `backgroundcolour` varchar(50) DEFAULT NULL,
  `container` varchar(50) DEFAULT NULL,
  `position` varchar(10) DEFAULT NULL,
  `image_only` bit(1) DEFAULT NULL,
  `plaintext` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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 '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',
  `replacementsource` varchar(255) DEFAULT NULL COMMENT 'Source Model',
  `layout` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `description` text DEFAULT NULL COMMENT 'Description',
  `headerjs` text DEFAULT NULL,
  `footerjs` text DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL COMMENT 'Name',
  `location` varchar(50) DEFAULT NULL COMMENT 'Location',
  `type` varchar(50) DEFAULT NULL COMMENT 'Type',
  `centreid` blob DEFAULT NULL COMMENT 'centreid',
  `sequence` int(11) DEFAULT NULL,
  `linkurl` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`),
  KEY `relatedid` (`relatedid`),
  KEY `type` (`type`),
  KEY `url` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.paymentallocations
CREATE TABLE IF NOT EXISTS `paymentallocations` (
  `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',
  `cartid` binary(36) DEFAULT NULL COMMENT 'Basket ID',
  `cartlineid` binary(36) DEFAULT NULL COMMENT 'Cartline 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',
  `amount` decimal(10,4) DEFAULT NULL COMMENT 'Amount',
  PRIMARY KEY (`id`,`language`),
  KEY `centerid` (`centerid`),
  KEY `relatedid` (`relatedid`),
  KEY `cartlineid` (`cartlineid`),
  KEY `cartid` (`cartid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.paymentresponses
CREATE TABLE IF NOT EXISTS `paymentresponses` (
  `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',
  `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',
  `bankref` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL COMMENT 'Invoice Type',
  `nom_code` varchar(255) DEFAULT NULL COMMENT 'Nominal Code',
  `incomename` varchar(255) DEFAULT NULL COMMENT 'Income Name',
  `takenby` varchar(255) DEFAULT NULL COMMENT 'Taken By',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `clientsignature` text DEFAULT NULL COMMENT 'Client Signature',
  `paymentref` varchar(50) DEFAULT NULL COMMENT 'Payment Reference',
  `currency` varchar(10) DEFAULT NULL COMMENT 'Currency',
  `result` varchar(10) DEFAULT NULL,
  `enddate` date DEFAULT NULL COMMENT 'End Date',
  `trxdate` datetime DEFAULT NULL COMMENT 'Transaction Date',
  `created` datetime DEFAULT NULL,
  `basketid` blob DEFAULT NULL COMMENT 'Basket ID',
  `invoiceid` blob DEFAULT NULL COMMENT 'Basket Id',
  `agencyid` blob DEFAULT NULL COMMENT 'Agent Id',
  `intamount` int(11) DEFAULT NULL COMMENT 'Amount',
  `statuscode` int(11) DEFAULT NULL COMMENT 'Status',
  `netsuiteid` int(11) DEFAULT NULL,
  `invoiceno` int(11) DEFAULT NULL COMMENT 'Invoice No',
  `reconciled` bit(1) DEFAULT NULL COMMENT 'Reconciled',
  `paid` bit(1) DEFAULT NULL COMMENT 'Paid',
  `amount` decimal(10,2) DEFAULT NULL COMMENT 'Amount',
  `camount` decimal(10,2) DEFAULT NULL COMMENT 'Currency Amount',
  `amountout` decimal(10,2) DEFAULT NULL COMMENT 'Amount Outstanding',
  `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,
  `comments` longtext DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `basketid` blob DEFAULT NULL COMMENT 'Basket Id',
  `ownerid` blob 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 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `model_name` varchar(255) DEFAULT NULL,
  `categoryname` varchar(255) DEFAULT NULL,
  `stock_code` varchar(255) DEFAULT NULL,
  `product_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,
  `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` varchar(255) DEFAULT NULL,
  `shipping_group` varchar(255) DEFAULT NULL COMMENT 'Shipping Group',
  `source` varchar(255) DEFAULT NULL,
  `displayname` varchar(255) DEFAULT NULL COMMENT 'Display Name',
  `alt_stock_code` varchar(255) DEFAULT NULL COMMENT 'Alt Stock Code',
  `df_sync_type` varchar(255) DEFAULT NULL COMMENT 'Sync Type',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `details` text DEFAULT NULL,
  `qrcode` text DEFAULT NULL,
  `product_description` text DEFAULT NULL,
  `search_terms` text DEFAULT NULL,
  `parentlist` text DEFAULT NULL,
  `rating` text 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,
  `donotpurge` bit(1) DEFAULT NULL COMMENT 'Do Not Purge',
  `availability_date` date DEFAULT NULL COMMENT 'Availability Date',
  `next_arrival_date` date DEFAULT NULL COMMENT 'Next Arrival Date',
  `mainimageid` blob DEFAULT NULL,
  `free_stock1` int(11) DEFAULT NULL,
  `price_group` 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,
  `categoryid` int(11) DEFAULT NULL,
  `pallet_size` int(11) DEFAULT NULL,
  `number_per_pallet` int(11) 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,
  `linkurl` bit(1) DEFAULT NULL,
  `price1` decimal(19,5) DEFAULT NULL,
  `price2` decimal(19,5) DEFAULT NULL,
  `price3` decimal(19,5) DEFAULT NULL,
  `price4` decimal(19,5) DEFAULT NULL,
  `price5` decimal(19,5) DEFAULT NULL,
  `price6` decimal(19,5) DEFAULT NULL,
  `price7` decimal(19,5) DEFAULT NULL,
  `price8` decimal(19,5) DEFAULT NULL,
  `price9` decimal(19,5) DEFAULT NULL,
  `free_stock` decimal(19,5) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `barcode1` bigint(20) DEFAULT NULL,
  `barcode` varchar(20) DEFAULT NULL,
  `ext_data` longtext DEFAULT NULL COMMENT 'Extra Data',
  `filter_data` longtext DEFAULT NULL COMMENT 'Filter Data',
  `importdata` longtext DEFAULT NULL COMMENT 'Imported Data',
  `config_json` longtext DEFAULT NULL COMMENT 'Taxonomies',
  `data` longtext DEFAULT NULL COMMENT 'Data',
  `imageData` longtext DEFAULT NULL COMMENT 'Image Data',
  `relationData` longtext DEFAULT NULL COMMENT 'Relation Data',
  `urlData` longtext DEFAULT NULL COMMENT 'URL Data',
  `pallet_weight` decimal(10,2) DEFAULT NULL COMMENT 'Pallet Weight',
  `percentage_of_pallet` decimal(10,2) DEFAULT NULL COMMENT 'Percentage of Pallet Space',
  PRIMARY KEY (`id`,`language`),
  KEY `stock_code` (`stock_code`),
  KEY `stock_group` (`stock_group`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.products_cop
CREATE TABLE IF NOT EXISTS `products_cop` (
  `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',
  `model_name` varchar(255) DEFAULT NULL,
  `categoryname` varchar(255) DEFAULT NULL,
  `stock_code` varchar(255) DEFAULT NULL,
  `product_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,
  `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` varchar(255) DEFAULT NULL,
  `shipping_group` varchar(255) DEFAULT NULL COMMENT 'Shipping Group',
  `source` varchar(255) DEFAULT NULL,
  `displayname` varchar(255) DEFAULT NULL COMMENT 'Display Name',
  `alt_stock_code` varchar(255) DEFAULT NULL COMMENT 'Alt Stock Code',
  `df_sync_type` varchar(255) DEFAULT NULL COMMENT 'Sync Type',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `details` text DEFAULT NULL,
  `qrcode` text DEFAULT NULL,
  `product_description` text DEFAULT NULL,
  `search_terms` text DEFAULT NULL,
  `parentlist` text DEFAULT NULL,
  `rating` text 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,
  `donotpurge` bit(1) DEFAULT NULL COMMENT 'Do Not Purge',
  `availability_date` date DEFAULT NULL COMMENT 'Availability Date',
  `next_arrival_date` date DEFAULT NULL COMMENT 'Next Arrival Date',
  `mainimageid` blob DEFAULT NULL,
  `free_stock1` int(11) DEFAULT NULL,
  `price_group` 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,
  `categoryid` int(11) DEFAULT NULL,
  `pallet_size` int(11) DEFAULT NULL,
  `number_per_pallet` int(11) 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,
  `linkurl` bit(1) DEFAULT NULL,
  `price1` decimal(19,5) DEFAULT NULL,
  `price2` decimal(19,5) DEFAULT NULL,
  `price3` decimal(19,5) DEFAULT NULL,
  `price4` decimal(19,5) DEFAULT NULL,
  `price5` decimal(19,5) DEFAULT NULL,
  `price6` decimal(19,5) DEFAULT NULL,
  `price7` decimal(19,5) DEFAULT NULL,
  `price8` decimal(19,5) DEFAULT NULL,
  `price9` decimal(19,5) DEFAULT NULL,
  `free_stock` decimal(19,5) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `barcode1` bigint(20) DEFAULT NULL,
  `barcode` varchar(20) DEFAULT NULL,
  `ext_data` longtext DEFAULT NULL COMMENT 'Extra Data',
  `filter_data` longtext DEFAULT NULL COMMENT 'Filter Data',
  `importdata` longtext DEFAULT NULL COMMENT 'Imported Data',
  `config_json` longtext DEFAULT NULL COMMENT 'Taxonomies',
  `data` longtext DEFAULT NULL COMMENT 'Data',
  `imageData` longtext DEFAULT NULL COMMENT 'Image Data',
  `relationData` longtext DEFAULT NULL COMMENT 'Relation Data',
  `urlData` longtext DEFAULT NULL COMMENT 'URL Data',
  `pallet_weight` decimal(10,2) DEFAULT NULL COMMENT 'Pallet Weight',
  `percentage_of_pallet` decimal(10,2) DEFAULT NULL COMMENT 'Percentage of Pallet Space',
  PRIMARY KEY (`id`,`language`) USING BTREE,
  KEY `stock_code` (`stock_code`) USING BTREE,
  KEY `stock_group` (`stock_group`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `model_name` varchar(255) DEFAULT NULL,
  `categoryname` varchar(255) DEFAULT NULL,
  `stock_code` varchar(255) DEFAULT NULL,
  `product_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,
  `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` varchar(255) DEFAULT NULL,
  `shipping_group` varchar(255) DEFAULT NULL COMMENT 'Shipping Group',
  `source` varchar(255) DEFAULT NULL,
  `displayname` varchar(255) DEFAULT NULL COMMENT 'Display Name',
  `alt_stock_code` varchar(255) DEFAULT NULL COMMENT 'Alt Stock Code',
  `df_sync_type` varchar(255) DEFAULT NULL COMMENT 'Sync Type',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `details` text DEFAULT NULL,
  `qrcode` text DEFAULT NULL,
  `product_description` text DEFAULT NULL,
  `search_terms` text DEFAULT NULL,
  `parentlist` text DEFAULT NULL,
  `rating` text 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,
  `donotpurge` bit(1) DEFAULT NULL COMMENT 'Do Not Purge',
  `availability_date` date DEFAULT NULL COMMENT 'Availability Date',
  `next_arrival_date` date DEFAULT NULL COMMENT 'Next Arrival Date',
  `mainimageid` blob DEFAULT NULL,
  `free_stock1` int(11) DEFAULT NULL,
  `price_group` 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,
  `categoryid` int(11) DEFAULT NULL,
  `pallet_size` int(11) DEFAULT NULL,
  `number_per_pallet` int(11) 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,
  `linkurl` bit(1) DEFAULT NULL,
  `price1` decimal(19,5) DEFAULT NULL,
  `price2` decimal(19,5) DEFAULT NULL,
  `price3` decimal(19,5) DEFAULT NULL,
  `price4` decimal(19,5) DEFAULT NULL,
  `price5` decimal(19,5) DEFAULT NULL,
  `price6` decimal(19,5) DEFAULT NULL,
  `price7` decimal(19,5) DEFAULT NULL,
  `price8` decimal(19,5) DEFAULT NULL,
  `price9` decimal(19,5) DEFAULT NULL,
  `free_stock` decimal(19,5) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `barcode1` bigint(20) DEFAULT NULL,
  `barcode` varchar(20) DEFAULT NULL,
  `ext_data` longtext DEFAULT NULL COMMENT 'Extra Data',
  `filter_data` longtext DEFAULT NULL COMMENT 'Filter Data',
  `importdata` longtext DEFAULT NULL COMMENT 'Imported Data',
  `config_json` longtext DEFAULT NULL COMMENT 'Taxonomies',
  `data` longtext DEFAULT NULL COMMENT 'Data',
  `imageData` longtext DEFAULT NULL COMMENT 'Image Data',
  `relationData` longtext DEFAULT NULL COMMENT 'Relation Data',
  `urlData` longtext DEFAULT NULL COMMENT 'URL Data',
  `pallet_weight` decimal(10,2) DEFAULT NULL COMMENT 'Pallet Weight',
  `percentage_of_pallet` decimal(10,2) DEFAULT NULL COMMENT 'Percentage of Pallet Space',
  PRIMARY KEY (`id`,`language`) USING BTREE,
  KEY `stock_code` (`stock_code`) USING BTREE,
  KEY `stock_group` (`stock_group`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.queue
CREATE TABLE IF NOT EXISTS `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',
  `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 'Job Name',
  `channel` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `job` blob DEFAULT NULL,
  `pushed_at` int(11) DEFAULT NULL,
  `ttr` int(11) DEFAULT NULL,
  `delay` int(11) DEFAULT NULL,
  `reserved_at` int(11) DEFAULT NULL,
  `attempt` int(11) DEFAULT NULL,
  `done_at` int(11) DEFAULT NULL,
  `priority` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`,`language`),
  KEY `reserved_at` (`reserved_at`),
  KEY `attempt` (`attempt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `email` varchar(255) DEFAULT NULL,
  `relatedto` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `reason` text DEFAULT NULL,
  `rating` decimal(19,4) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `message` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `message` text DEFAULT NULL,
  `fulladdress` text DEFAULT NULL,
  `account_code` varchar(10) DEFAULT NULL,
  `deliveryaddress` blob DEFAULT NULL,
  `billingaddress` blob DEFAULT NULL,
  `basketid` blob DEFAULT NULL,
  `date` int(11) DEFAULT NULL,
  `totalweight` int(11) DEFAULT NULL,
  `dateshipped` int(11) DEFAULT NULL,
  `dateordered` int(11) DEFAULT NULL,
  `terms` bit(1) DEFAULT NULL,
  `subtotal` decimal(19,4) DEFAULT NULL,
  `total` decimal(19,4) DEFAULT NULL,
  `tax` decimal(19,4) DEFAULT NULL,
  `shipping` decimal(19,4) DEFAULT NULL,
  `telephone` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `reason` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `product_name` text DEFAULT NULL,
  `reasoncomment` text DEFAULT NULL,
  `basketlineid` blob DEFAULT NULL,
  `productid` blob DEFAULT NULL,
  `attachment` blob DEFAULT NULL,
  `returnid` blob DEFAULT NULL,
  `basketid` blob DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `totalweight` int(11) 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,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `possibleproduct` varchar(255) DEFAULT NULL,
  `useragent` varchar(255) DEFAULT NULL,
  `ipaddress` varchar(20) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `term` text DEFAULT NULL,
  `results` int(11) DEFAULT NULL COMMENT 'Number of Results',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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,
  `meta_title` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `keywords` text DEFAULT NULL,
  `newskeywords` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `related_id` blob 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,
  `og_image` varchar(500) DEFAULT NULL COMMENT 'Open Graph Image',
  `og_logo` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`),
  KEY `relatedid` (`relatedid`),
  KEY `status` (`status`),
  KEY `related_to` (`related_to`),
  KEY `related_id` (`related_id`(3072))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.settings
CREATE TABLE IF NOT EXISTS `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',
  `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',
  `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_url` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `api` bit(1) DEFAULT NULL COMMENT 'api',
  `enable_shippingline` bit(1) DEFAULT NULL COMMENT 'enable_shippingline',
  `comment` longtext DEFAULT NULL COMMENT 'Comments',
  `logindetails` longtext DEFAULT NULL,
  `data` longtext DEFAULT NULL,
  `authdata` longtext DEFAULT NULL,
  `privacy_statement` longtext DEFAULT NULL COMMENT 'Privacy statement',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.shipping_info
CREATE TABLE IF NOT EXISTS `shipping_info` (
  `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',
  `courier` varchar(255) DEFAULT NULL COMMENT 'Courier',
  `shipping_status` varchar(255) DEFAULT NULL COMMENT 'Shipping Status',
  `tracking_code` varchar(255) DEFAULT NULL COMMENT 'Tracking Code',
  `tracking_url` varchar(255) DEFAULT NULL COMMENT 'Tracking URL',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for view ngaugeportal-ahshub.SLT
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `SLT` (
	`_ID` INT(11) NOT NULL,
	`TYPE` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`TxDATE` DATE NULL,
	`ACCOUNT` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`TxREF` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`NAME` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`AMOUNT` DECIMAL(16,2) NULL,
	`TAX` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`TAX_AMT` DECIMAL(16,2) NULL,
	`PAY_DISC` DECIMAL(16,2) NULL,
	`TOTAL` DECIMAL(16,4) NULL,
	`ALLOCATED` DECIMAL(16,2) NULL,
	`ACC_RECNO` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`NEXT_TX` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`OUTSTANDING` DECIMAL(16,4) NULL,
	`NOMINAL` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`NOM_UPD` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`GENERAL` INT(11) NULL,
	`ANALYSIS` INT(11) NULL,
	`DAYS_CREDIT` INT(11) NULL,
	`DUE_DATE` DATE NULL,
	`DATE_ALLOC` DATE NULL,
	`DAYS_OVERDUE` DECIMAL(16,4) NULL,
	`OLD_TX` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`USER_ONE` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`USER_TWO` DECIMAL(16,2) NULL,
	`USER_THREE` INT(11) NULL,
	`SETT_DISC_AMT` DECIMAL(16,2) NULL,
	`SETT_DAYS` INT(11) NULL,
	`SETT_DATE` DATE NULL,
	`BATCH_NUMBER` INT(11) NULL,
	`COST_VALUE` DECIMAL(16,2) NULL,
	`FWD_TRANS` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`FWD_ALLOC` DECIMAL(16,2) NULL,
	`PERIOD_NO` INT(11) NULL,
	`DEL_ADD_ACC` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`STM_ADD_ACC` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`GRP_ADD_ACC` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`ALLOC` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`ALLOC_XREF` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`DISPCONTRA` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`USERID_FLAGGD` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`EC_COUNTRY` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`EC_TAX_REG` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`OVERR_DISC_RT` DECIMAL(16,2) NULL,
	`ORDER_NO` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`STOCK_CODE` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`STOCK_QTY` DECIMAL(16,2) NULL,
	`UNIT_COST` DECIMAL(16,2) NULL,
	`TOTAL_COST` DECIMAL(16,4) NULL,
	`TAX_BF` DECIMAL(16,2) NULL,
	`ALLOC_BF` DECIMAL(16,2) NULL,
	`PAYMENT_TAX` DECIMAL(16,2) NULL,
	`FACTOR` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`FACTOR_NO` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`OVERR_DISC_AM` DECIMAL(16,4) NULL,
	`MARGIN_AMT` DECIMAL(16,4) NULL,
	`MARGIN_AGE` DECIMAL(16,4) NULL,
	`DEL_ACC_NAME` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`cust_ref` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`INV_YearWeek` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`Duplicate_ref` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`OS_ORR_DISC` DECIMAL(16,4) NULL,
	`SALES_AMT` DECIMAL(16,4) NULL,
	`STOCK_GROUP` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`SALESPERSON` INT(11) NULL,
	`STK_MAIN_QTY` DECIMAL(16,2) NULL,
	`ROUTE` INT(11) NULL,
	`DROP` INT(11) NULL,
	`INV_WEEKDAY` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`INV_DAYNUMBER` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`ACC_DAYNO` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`TEMP_GetCost` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`Unit_Cost_Was` DECIMAL(16,2) NULL,
	`LU_To_Stock` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`New_Cost` DECIMAL(16,2) NULL,
	`createdby` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`createdon` DATE NULL,
	`createdat` INT(11) NULL,
	`updatedby` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`updatedon` DATE NULL,
	`updatedat` INT(11) NULL,
	`ERPKEY` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci'
);

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `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 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.sys_assets
CREATE TABLE IF NOT EXISTS `sys_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',
  `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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `type` varchar(50) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `data` longtext DEFAULT NULL COMMENT 'Json Data',
  `imageData` longtext DEFAULT NULL COMMENT 'Image Data',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `communication` int(11) DEFAULT NULL COMMENT '"1"=>"newsletter","2"=>"promotions","3"=>"telephone","4"=>"cartupdates"',
  `email` tinyint(1) DEFAULT NULL COMMENT '"0"=>"on","1"=>"off"',
  `sms` tinyint(1) DEFAULT NULL COMMENT '"0"=>"on","1"=>"off"',
  `telephone` tinyint(1) DEFAULT NULL COMMENT '"0"=>"on","1"=>"off"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `account_number` int(11) DEFAULT NULL COMMENT 'Account Number',
  `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',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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 'Name',
  `alpha_2` varchar(255) DEFAULT NULL COMMENT 'Alpha 2',
  `alpha_3` varchar(255) DEFAULT NULL COMMENT 'Alpha 3',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `numerical` int(11) DEFAULT NULL COMMENT 'Numerical',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `drivername` varchar(255) DEFAULT NULL,
  `charset` varchar(255) DEFAULT NULL,
  `server` varchar(255) DEFAULT NULL,
  `database` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `cacheduration` int(11) DEFAULT NULL,
  `dsn` mediumtext DEFAULT NULL,
  `cache` bit(1) DEFAULT NULL,
  `encrypt` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `postcode` text DEFAULT NULL,
  `topostcode` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `weightfrom` int(11) DEFAULT NULL,
  `weightto` int(11) DEFAULT NULL,
  `pricefrom` decimal(19,4) DEFAULT NULL,
  `priceto` decimal(19,4) DEFAULT NULL,
  `price` decimal(19,4) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `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',
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `subject` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `to_email` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `to_cc` text DEFAULT NULL,
  `to_bcc` text DEFAULT NULL,
  `to_emailg` text DEFAULT NULL,
  `logdata` text 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,
  `date_published` datetime DEFAULT NULL,
  `last_attempt` datetime DEFAULT NULL,
  `date_sent` datetime DEFAULT NULL,
  `send_after` datetime DEFAULT NULL COMMENT 'Send After',
  `actid` blob DEFAULT NULL,
  `jobno` int(11) DEFAULT NULL,
  `statuscode` int(11) DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `success` bit(1) DEFAULT NULL,
  `emailfile` longtext DEFAULT NULL,
  `max_attempts` tinyint(3) DEFAULT NULL,
  `attempts` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`),
  KEY `subject` (`subject`),
  KEY `relatedid` (`relatedid`),
  KEY `success` (`success`),
  KEY `send_after` (`send_after`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `code` int(11) DEFAULT NULL COMMENT 'Code for message',
  `type` set('1','2','3','4') DEFAULT NULL COMMENT '"1" => "Cart", "2" => "Shipping", "3" => "System", "4" => "Other"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `title` varchar(255) DEFAULT NULL COMMENT 'Feed Name',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `taxonomy_management_id` blob DEFAULT NULL COMMENT 'Taxonomy',
  `site_url` varchar(155) DEFAULT NULL COMMENT 'Site base url',
  `template` longtext DEFAULT NULL COMMENT 'Feed Template',
  `description` longtext DEFAULT NULL COMMENT 'Feed Description',
  `is_xml` tinyint(1) DEFAULT NULL COMMENT '"0"=>"need update","1"=>"updated"',
  `product_status` tinyint(1) DEFAULT NULL COMMENT '"0"=>"all","1"=>"active"',
  `stock_group` tinyint(1) DEFAULT NULL COMMENT '"0"=>"all","1"=>"active"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `flagurl` varchar(255) DEFAULT NULL COMMENT 'flagurl',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `tlanguage` varchar(100) DEFAULT NULL COMMENT 'tlanguage',
  `shortcode` varchar(10) DEFAULT NULL COMMENT 'shortcode',
  `sequence` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.sys_log
CREATE TABLE IF NOT EXISTS `sys_log` (
  `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',
  `category` varchar(255) DEFAULT NULL COMMENT 'Category',
  `servername` varchar(255) DEFAULT NULL COMMENT 'Server Name',
  `controller` varchar(255) DEFAULT NULL COMMENT 'Controller',
  `action` varchar(255) DEFAULT NULL COMMENT 'Action',
  `source` varchar(255) DEFAULT NULL COMMENT 'Source',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `message` text DEFAULT NULL COMMENT 'Message',
  `prefix` text DEFAULT NULL COMMENT 'Prefix',
  `logged` datetime DEFAULT NULL COMMENT 'DT Logged',
  `log_time` decimal(10,0) DEFAULT NULL COMMENT 'logtime',
  `level` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `parentid` blob DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `accesslevel` int(11) DEFAULT NULL COMMENT 'Access Level Required',
  `label` mediumtext DEFAULT NULL,
  `tag` mediumtext DEFAULT NULL,
  `groups` mediumtext DEFAULT NULL,
  `design_positions` varchar(55) DEFAULT NULL COMMENT 'Design Position',
  `linkClass` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.sys_models
CREATE TABLE IF NOT EXISTS `sys_models` (
  `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,
  `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,
  `timezone` varchar(255) DEFAULT NULL,
  `conditionfield` varchar(255) DEFAULT NULL,
  `date_created_field` varchar(255) DEFAULT NULL,
  `date_updated_field` varchar(255) DEFAULT NULL,
  `timeupdatedfield` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `dsn` text DEFAULT NULL COMMENT 'dsn',
  `datamap` text DEFAULT NULL COMMENT 'Data Map',
  `remotefields` text DEFAULT NULL COMMENT 'Remote Fields',
  `localfields` text DEFAULT NULL COMMENT 'Local Field',
  `initdate` date DEFAULT NULL COMMENT 'Initial Date',
  `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',
  `timetosync` int(11) DEFAULT NULL,
  `cache` bit(1) DEFAULT NULL COMMENT 'cache',
  `enabled` bit(1) DEFAULT NULL,
  `conditions` mediumtext DEFAULT NULL,
  `options` longtext DEFAULT NULL COMMENT 'Options (JSON)',
  `lastdate` date DEFAULT NULL,
  `lasttime` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `link` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `company_id` blob DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL COMMENT 'Sequence',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `productid` blob DEFAULT NULL,
  `qty` int(11) DEFAULT NULL COMMENT 'Quantity',
  `type` int(11) DEFAULT NULL COMMENT '"0"=>"delivery","1"=>"collect"',
  `emailSent` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `flagged_by` blob DEFAULT NULL COMMENT 'Flagged By',
  `flagged_at` int(11) DEFAULT NULL COMMENT 'Flagged At',
  `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',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `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',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.sys_session
CREATE TABLE IF NOT EXISTS `sys_session` (
  `id` char(40) NOT NULL COMMENT 'id',
  `expire` int(11) DEFAULT NULL,
  `ipaddress` varchar(20) DEFAULT NULL,
  `userAgent` varchar(255) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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,
  `basicurl` varchar(255) DEFAULT NULL COMMENT 'Basic URL',
  `folder` varchar(255) DEFAULT NULL COMMENT 'Folder',
  `alias` varchar(255) DEFAULT NULL COMMENT 'Alias',
  `state` varchar(255) DEFAULT NULL COMMENT 'System State',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `logo` text DEFAULT NULL,
  `googletrackingjs` text DEFAULT NULL,
  `googleverification` text DEFAULT NULL,
  `rates` text DEFAULT NULL,
  `googletrackingjs_footer` text DEFAULT NULL,
  `data` text DEFAULT NULL,
  `settings` text DEFAULT NULL,
  `cookie_script_options` text DEFAULT NULL COMMENT 'Cookie Script Options',
  `trustpilot_controls` text DEFAULT NULL COMMENT 'Trust Pilot Contorls',
  `country` varchar(50) DEFAULT NULL,
  `long` varchar(50) DEFAULT NULL,
  `lat` varchar(50) DEFAULT NULL,
  `datafile_company_code` varchar(50) DEFAULT NULL,
  `seckey` blob DEFAULT NULL COMMENT 'Security GUID',
  `deliveryproductid` blob DEFAULT NULL,
  `agentid` blob DEFAULT NULL,
  `datafile_priceno` int(11) DEFAULT NULL COMMENT 'Datafile Web Price Number 1-9',
  `center` bit(1) DEFAULT NULL,
  `datafile_matrix` bit(1) DEFAULT NULL,
  `enable_shippingline` bit(1) DEFAULT NULL COMMENT 'Enable Shipping Line',
  `defaultdeliverycost` decimal(19,4) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `manifests` longtext DEFAULT NULL COMMENT 'Json Manifest Settings',
  `deliverycutoff` varchar(5) DEFAULT NULL,
  `postcode` varchar(8) DEFAULT NULL,
  `storeid` varchar(3) DEFAULT NULL COMMENT 'Store ID',
  `is_default` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `location` varchar(255) DEFAULT NULL COMMENT 'Purchase Location',
  `locationurl` varchar(255) DEFAULT NULL COMMENT 'Purchase Location URL',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `weatherid` int(11) DEFAULT NULL COMMENT 'Weather ID',
  `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',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `description` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `is_default` int(11) DEFAULT NULL COMMENT 'Deafault',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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"',
  `default_ship_status` varchar(255) DEFAULT NULL COMMENT 'Default Shipping Status',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `totaling_algo` int(11) DEFAULT NULL COMMENT 'Totaling Algorithm',
  `applicable_countries` int(11) DEFAULT NULL COMMENT 'Ship to Applicable Countries',
  `enabled` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `package_id` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `post_code_range` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `uk_post_code` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `discount_price` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `exclude_fornt_price` tinyint(1) DEFAULT NULL COMMENT 'Exclude Fornt Price',
  `cal_handling_fee` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `apply_handling_fee` tinyint(1) DEFAULT NULL COMMENT '"0"=>"no","1"=>"yes"',
  `show_ship_status` tinyint(1) DEFAULT NULL COMMENT 'Show Shipping Status on Frontend',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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 'Name',
  `link` varchar(255) DEFAULT NULL COMMENT 'URL',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `font_code` varchar(255) DEFAULT NULL COMMENT 'Font Code',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `company_id` blob DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL COMMENT 'Sequence',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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 'Name',
  `url` varchar(255) DEFAULT NULL COMMENT 'Taxonomy URL',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `country` blob DEFAULT NULL COMMENT 'Country',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `message` longtext DEFAULT NULL COMMENT 'message',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `taxonomy_id` int(11) DEFAULT NULL COMMENT 'Taxonomy ID',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `fields` longtext DEFAULT NULL COMMENT 'Json of fields',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `comment` text DEFAULT NULL,
  `relatedguid` blob DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `reason` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  `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,
  `access_token` varchar(255) DEFAULT NULL,
  `tfa_code` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `dob` date DEFAULT NULL COMMENT 'Date of Birth',
  `deleted` bit(1) DEFAULT NULL,
  `api` bit(1) DEFAULT NULL COMMENT 'Api Access',
  `blocked_at` int(11) DEFAULT NULL COMMENT 'Blocked At',
  `groups` longtext DEFAULT NULL,
  `udates` longtext DEFAULT NULL COMMENT 'Dates',
  `adv` longtext DEFAULT NULL COMMENT 'Useradv',
  `mailing` longtext DEFAULT NULL COMMENT 'Mailing Lists',
  `data` longtext DEFAULT NULL COMMENT 'Account Data',
  `accountData` longtext DEFAULT NULL COMMENT 'Account Data',
  `agentid` blob DEFAULT NULL COMMENT 'Agent ID',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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 'name',
  `provider` varchar(255) DEFAULT NULL COMMENT 'name',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `description` text DEFAULT NULL COMMENT 'description',
  `data` text DEFAULT NULL COMMENT 'Data',
  `type` varchar(50) DEFAULT NULL COMMENT 'Group Type',
  `mcid` varchar(50) DEFAULT NULL COMMENT 'Mail Chimp ID',
  `mcwid` int(11) DEFAULT NULL COMMENT 'Mail Chimp ID',
  `alerts` bit(1) DEFAULT NULL COMMENT 'alerts',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `sales_rate` decimal(19,4) DEFAULT NULL COMMENT 'sales_rate',
  `purchase_rate` decimal(19,4) DEFAULT NULL COMMENT 'purchase_rate',
  `type` varchar(1) DEFAULT NULL COMMENT 'type',
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `type` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `agent` text DEFAULT NULL,
  `ip` varchar(15) DEFAULT NULL,
  `userid` blob DEFAULT NULL,
  `terms` bit(1) DEFAULT NULL,
  `revision` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `description` text DEFAULT NULL,
  `private` bit(1) DEFAULT NULL,
  `sendemail` bit(1) DEFAULT NULL,
  `updated` bit(1) DEFAULT NULL,
  `orderref` int(11) DEFAULT NULL,
  `reference` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.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',
  `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,
  `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,
  `anchor_tag` varchar(255) DEFAULT NULL COMMENT 'Link',
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `data` text DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `searchterms` text DEFAULT NULL,
  `signature` text DEFAULT NULL,
  `permissions` text DEFAULT NULL COMMENT 'Permissions',
  `revisionData` text DEFAULT NULL,
  `relatedto` varchar(50) DEFAULT NULL,
  `revision` varchar(50) DEFAULT NULL,
  `approved_by` blob DEFAULT NULL,
  `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,
  `lat` varchar(45) DEFAULT NULL,
  `long` varchar(45) DEFAULT NULL,
  `datetaken` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ngaugeportal-ahshub.vouchers
CREATE TABLE IF NOT EXISTS `vouchers` (
  `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',
  `code` int(11) DEFAULT NULL COMMENT 'Nominal Code',
  `uses` int(11) DEFAULT NULL COMMENT 'Uses',
  `used` int(11) DEFAULT NULL COMMENT 'Times Used',
  `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',
  `tomainimage` varchar(255) DEFAULT NULL COMMENT 'tomainimage',
  `stock_code` varchar(255) DEFAULT NULL COMMENT 'Stock Code to Apply Against',
  `name` varchar(255) DEFAULT NULL COMMENT 'Voucher Name',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  `email` varchar(255) DEFAULT NULL COMMENT 'Issued to Email',
  `issuesby` varchar(255) DEFAULT NULL COMMENT 'Issued By',
  `firstname` varchar(255) DEFAULT NULL COMMENT 'First Name',
  `lastname` varchar(255) DEFAULT NULL COMMENT 'Last Name',
  `extref` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `seodata` text DEFAULT NULL COMMENT 'Seo Data',
  `value` varchar(50) DEFAULT NULL COMMENT 'Value (euro)',
  `startdate` date DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  `issuingto` binary(36) DEFAULT NULL COMMENT 'Issuing Tour Operator',
  `clientid` binary(36) DEFAULT NULL COMMENT 'Client ID',
  `productid` binary(36) DEFAULT NULL COMMENT 'Product ID',
  `amount` decimal(19,5) DEFAULT NULL COMMENT 'Amount currency',
  `amount_percentage` decimal(19,5) DEFAULT NULL COMMENT 'Amount Percentage',
  `remaining` decimal(19,5) DEFAULT NULL COMMENT 'Amount Remaining',
  `pdffile` text DEFAULT NULL COMMENT 'PDF',
  `description` text DEFAULT NULL COMMENT 'Description',
  `qrcode` text DEFAULT NULL,
  PRIMARY KEY (`id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `erp_outstanding_balance`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `erp_outstanding_balance` AS select `ngaugeportal_colinsfresh`.`data`.`id` AS `id`,`ngaugeportal_colinsfresh`.`data`.`language` AS `language`,`ngaugeportal_colinsfresh`.`data`.`created_by` AS `created_by`,`ngaugeportal_colinsfresh`.`data`.`updated_by` AS `updated_by`,`ngaugeportal_colinsfresh`.`data`.`deleted_by` AS `deleted_by`,`ngaugeportal_colinsfresh`.`data`.`relatedid` AS `relatedid`,`ngaugeportal_colinsfresh`.`data`.`centerid` AS `centerid`,`ngaugeportal_colinsfresh`.`data`.`created_at` AS `created_at`,`ngaugeportal_colinsfresh`.`data`.`updated_at` AS `updated_at`,`ngaugeportal_colinsfresh`.`data`.`deleted_at` AS `deleted_at`,`ngaugeportal_colinsfresh`.`data`.`revision` AS `revision`,`ngaugeportal_colinsfresh`.`data`.`status` AS `status`,`ngaugeportal_colinsfresh`.`data`.`createdby_name` AS `createdby_name`,`ngaugeportal_colinsfresh`.`data`.`updatedby_name` AS `updatedby_name`,`ngaugeportal_colinsfresh`.`data`.`deletedby_name` AS `deletedby_name`,`ngaugeportal_colinsfresh`.`data`.`group` AS `group`,`ngaugeportal_colinsfresh`.`data`.`name` AS `name`,`ngaugeportal_colinsfresh`.`data`.`type` AS `type`,`ngaugeportal_colinsfresh`.`data`.`class` AS `class`,`ngaugeportal_colinsfresh`.`data`.`seodata` AS `seodata`,`ngaugeportal_colinsfresh`.`data`.`data` AS `data`,`ngaugeportal_colinsfresh`.`data`.`indexes` AS `indexes`,`ngaugeportal_colinsfresh`.`data`.`revision_reason` AS `revision_reason`,`ngaugeportal_colinsfresh`.`data`.`indexes_account` AS `ACCOUNT`,`josn`.`DATE` AS `DATE`,`josn`.`OS` AS `OS` from (`ngaugeportal_colinsfresh`.`data` left join JSON_TABLE(`ngaugeportal_colinsfresh`.`data`.`data`, '$' COLUMNS (`DATE` date PATH '$.DATE', NESTED PATH '$.lines[*]' COLUMNS (`OS` decimal(10,4) PATH '$.OUTSTANDING'))) `josn` on(1))
;

-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `SLT`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `SLT` AS select `ngaugeportal_colinsfresh_df`.`vic-slt`.`_ID` AS `_ID`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TYPE` AS `TYPE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TxDATE` AS `TxDATE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ACCOUNT` AS `ACCOUNT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TxREF` AS `TxREF`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`NAME` AS `NAME`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`AMOUNT` AS `AMOUNT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TAX` AS `TAX`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TAX_AMT` AS `TAX_AMT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`PAY_DISC` AS `PAY_DISC`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TOTAL` AS `TOTAL`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ALLOCATED` AS `ALLOCATED`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ACC_RECNO` AS `ACC_RECNO`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`NEXT_TX` AS `NEXT_TX`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`OUTSTANDING` AS `OUTSTANDING`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`NOMINAL` AS `NOMINAL`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`NOM_UPD` AS `NOM_UPD`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`GENERAL` AS `GENERAL`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ANALYSIS` AS `ANALYSIS`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`DAYS_CREDIT` AS `DAYS_CREDIT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`DUE_DATE` AS `DUE_DATE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`DATE_ALLOC` AS `DATE_ALLOC`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`DAYS_OVERDUE` AS `DAYS_OVERDUE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`OLD_TX` AS `OLD_TX`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`USER_ONE` AS `USER_ONE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`USER_TWO` AS `USER_TWO`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`USER_THREE` AS `USER_THREE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`SETT_DISC_AMT` AS `SETT_DISC_AMT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`SETT_DAYS` AS `SETT_DAYS`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`SETT_DATE` AS `SETT_DATE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`BATCH_NUMBER` AS `BATCH_NUMBER`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`COST_VALUE` AS `COST_VALUE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`FWD_TRANS` AS `FWD_TRANS`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`FWD_ALLOC` AS `FWD_ALLOC`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`PERIOD_NO` AS `PERIOD_NO`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`DEL_ADD_ACC` AS `DEL_ADD_ACC`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`STM_ADD_ACC` AS `STM_ADD_ACC`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`GRP_ADD_ACC` AS `GRP_ADD_ACC`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ALLOC` AS `ALLOC`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ALLOC_XREF` AS `ALLOC_XREF`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`DISPCONTRA` AS `DISPCONTRA`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`USERID_FLAGGD` AS `USERID_FLAGGD`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`EC_COUNTRY` AS `EC_COUNTRY`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`EC_TAX_REG` AS `EC_TAX_REG`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`OVERR_DISC_RT` AS `OVERR_DISC_RT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ORDER_NO` AS `ORDER_NO`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`STOCK_CODE` AS `STOCK_CODE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`STOCK_QTY` AS `STOCK_QTY`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`UNIT_COST` AS `UNIT_COST`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TOTAL_COST` AS `TOTAL_COST`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TAX_BF` AS `TAX_BF`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ALLOC_BF` AS `ALLOC_BF`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`PAYMENT_TAX` AS `PAYMENT_TAX`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`FACTOR` AS `FACTOR`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`FACTOR_NO` AS `FACTOR_NO`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`OVERR_DISC_AM` AS `OVERR_DISC_AM`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`MARGIN_AMT` AS `MARGIN_AMT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`MARGIN_AGE` AS `MARGIN_AGE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`DEL_ACC_NAME` AS `DEL_ACC_NAME`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`cust_ref` AS `cust_ref`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`INV_YearWeek` AS `INV_YearWeek`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`Duplicate_ref` AS `Duplicate_ref`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`OS_ORR_DISC` AS `OS_ORR_DISC`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`SALES_AMT` AS `SALES_AMT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`STOCK_GROUP` AS `STOCK_GROUP`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`SALESPERSON` AS `SALESPERSON`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`STK_MAIN_QTY` AS `STK_MAIN_QTY`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ROUTE` AS `ROUTE`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`DROP` AS `DROP`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`INV_WEEKDAY` AS `INV_WEEKDAY`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`INV_DAYNUMBER` AS `INV_DAYNUMBER`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ACC_DAYNO` AS `ACC_DAYNO`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TEMP_GetCost` AS `TEMP_GetCost`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`Unit_Cost_Was` AS `Unit_Cost_Was`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`LU_To_Stock` AS `LU_To_Stock`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`New_Cost` AS `New_Cost`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`createdby` AS `createdby`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`createdon` AS `createdon`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`createdat` AS `createdat`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`updatedby` AS `updatedby`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`updatedon` AS `updatedon`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`updatedat` AS `updatedat`,concat(`ngaugeportal_colinsfresh_df`.`vic-slt`.`_ID`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`ACCOUNT`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TxREF`,`ngaugeportal_colinsfresh_df`.`vic-slt`.`TxDATE`) AS `ERPKEY` from `ngaugeportal_colinsfresh_df`.`vic-slt`
;

/*!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) */;
