yuyr/webrlvr
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
webrlvr/static_workflow/archive/schema_nonempty.txt.bak
yuyr f34e4a464d 完成三种构建方法
2025-06-11 17:30:06 +08:00

4149 lines
241 KiB
Plaintext
Raw Permalink Blame History

-- MariaDB dump 10.19 Distrib 10.6.12-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: magentodb
-- ------------------------------------------------------
-- Server version 10.6.12-MariaDB-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `admin_system_messages`
--
DROP TABLE IF EXISTS `admin_system_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_system_messages` (
`identity` varchar(100) NOT NULL COMMENT 'Message ID',
`severity` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Problem type',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Create date',
PRIMARY KEY (`identity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Admin System Messages';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `adminnotification_inbox`
--
DROP TABLE IF EXISTS `adminnotification_inbox`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adminnotification_inbox` (
`notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Notification ID',
`severity` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Problem type',
`date_added` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Create date',
`title` varchar(255) NOT NULL COMMENT 'Title',
`description` text DEFAULT NULL COMMENT 'Description',
`url` varchar(255) DEFAULT NULL COMMENT 'Url',
`is_read` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Flag if notification read',
`is_remove` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Flag if notification might be removed',
PRIMARY KEY (`notification_id`),
KEY `ADMINNOTIFICATION_INBOX_SEVERITY` (`severity`),
KEY `ADMINNOTIFICATION_INBOX_IS_READ` (`is_read`),
KEY `ADMINNOTIFICATION_INBOX_IS_REMOVE` (`is_remove`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Adminnotification Inbox';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `authorization_role`
--
DROP TABLE IF EXISTS `authorization_role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `authorization_role` (
`role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Role ID',
`parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Parent Role ID',
`tree_level` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Role Tree Level',
`sort_order` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Role Sort Order',
`role_type` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Role Type',
`user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'User ID',
`user_type` varchar(16) DEFAULT NULL COMMENT 'User Type',
`role_name` varchar(50) DEFAULT NULL COMMENT 'Role Name',
PRIMARY KEY (`role_id`),
KEY `AUTHORIZATION_ROLE_PARENT_ID_SORT_ORDER` (`parent_id`,`sort_order`),
KEY `AUTHORIZATION_ROLE_TREE_LEVEL` (`tree_level`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Admin Role Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `authorization_rule`
--
DROP TABLE IF EXISTS `authorization_rule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `authorization_rule` (
`rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule ID',
`role_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Role ID',
`resource_id` varchar(255) DEFAULT NULL COMMENT 'Resource ID',
`privileges` varchar(20) DEFAULT NULL COMMENT 'Privileges',
`permission` varchar(10) DEFAULT NULL COMMENT 'Permission',
PRIMARY KEY (`rule_id`),
KEY `AUTHORIZATION_RULE_RESOURCE_ID_ROLE_ID` (`resource_id`,`role_id`),
KEY `AUTHORIZATION_RULE_ROLE_ID_RESOURCE_ID` (`role_id`,`resource_id`),
CONSTRAINT `AUTHORIZATION_RULE_ROLE_ID_AUTHORIZATION_ROLE_ROLE_ID` FOREIGN KEY (`role_id`) REFERENCES `authorization_role` (`role_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=70227 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Admin Rule Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_category_entity`
--
DROP TABLE IF EXISTS `catalog_category_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_category_entity` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute Set ID',
`parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Parent Category ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Creation Time',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Update Time',
`path` varchar(255) NOT NULL COMMENT 'Tree Path',
`position` int(11) NOT NULL COMMENT 'Position',
`level` int(11) NOT NULL DEFAULT 0 COMMENT 'Tree Level',
`children_count` int(11) NOT NULL COMMENT 'Child Count',
PRIMARY KEY (`entity_id`),
KEY `CATALOG_CATEGORY_ENTITY_LEVEL` (`level`),
KEY `CATALOG_CATEGORY_ENTITY_PATH` (`path`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Category Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_category_entity_int`
--
DROP TABLE IF EXISTS `catalog_category_entity_int`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_category_entity_int` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`value` int(11) DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
KEY `CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID` (`entity_id`),
KEY `CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
KEY `CATALOG_CATEGORY_ENTITY_INT_STORE_ID` (`store_id`),
CONSTRAINT `CATALOG_CATEGORY_ENTITY_INT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_CTGR_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_CTGR_ENTT_INT_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Category Integer Attribute Backend Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_category_entity_varchar`
--
DROP TABLE IF EXISTS `catalog_category_entity_varchar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_category_entity_varchar` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`value` varchar(255) DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
KEY `CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID` (`entity_id`),
KEY `CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
KEY `CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID` (`store_id`),
CONSTRAINT `CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_CTGR_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_CTGR_ENTT_VCHR_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Category Varchar Attribute Backend Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_category_product`
--
DROP TABLE IF EXISTS `catalog_category_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_category_product` (
`entity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category ID',
`product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`position` int(11) NOT NULL DEFAULT 0 COMMENT 'Position',
PRIMARY KEY (`entity_id`,`category_id`,`product_id`),
UNIQUE KEY `CATALOG_CATEGORY_PRODUCT_CATEGORY_ID_PRODUCT_ID` (`category_id`,`product_id`),
KEY `CATALOG_CATEGORY_PRODUCT_PRODUCT_ID` (`product_id`),
CONSTRAINT `CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_CTGR_PRD_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5166 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product To Category Linkage Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_eav_attribute`
--
DROP TABLE IF EXISTS `catalog_eav_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_eav_attribute` (
`attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
`frontend_input_renderer` varchar(255) DEFAULT NULL COMMENT 'Frontend Input Renderer',
`is_global` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Global',
`is_visible` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Visible',
`is_searchable` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Searchable',
`is_filterable` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Filterable',
`is_comparable` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Comparable',
`is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible On Front',
`is_html_allowed_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is HTML Allowed On Front',
`is_used_for_price_rules` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used For Price Rules',
`is_filterable_in_search` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Filterable In Search',
`used_in_product_listing` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used In Product Listing',
`used_for_sort_by` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used For Sorting',
`apply_to` varchar(255) DEFAULT NULL COMMENT 'Apply To',
`is_visible_in_advanced_search` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible In Advanced Search',
`position` int(11) NOT NULL DEFAULT 0 COMMENT 'Position',
`is_wysiwyg_enabled` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is WYSIWYG Enabled',
`is_used_for_promo_rules` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used For Promo Rules',
`is_required_in_admin_store` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Required In Admin Store',
`is_used_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used in Grid',
`is_visible_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible in Grid',
`is_filterable_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Filterable in Grid',
`search_weight` float NOT NULL DEFAULT 1 COMMENT 'Search Weight',
`is_pagebuilder_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is PageBuilder Enabled',
`additional_data` text DEFAULT NULL COMMENT 'Additional swatch attributes data',
PRIMARY KEY (`attribute_id`),
KEY `CATALOG_EAV_ATTRIBUTE_USED_FOR_SORT_BY` (`used_for_sort_by`),
KEY `CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING` (`used_in_product_listing`),
CONSTRAINT `CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog EAV Attribute Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_bundle_option`
--
DROP TABLE IF EXISTS `catalog_product_bundle_option`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_bundle_option` (
`option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
`parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
`required` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Required',
`position` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Position',
`type` varchar(255) DEFAULT NULL COMMENT 'Type',
PRIMARY KEY (`option_id`),
KEY `CATALOG_PRODUCT_BUNDLE_OPTION_PARENT_ID` (`parent_id`),
CONSTRAINT `CAT_PRD_BNDL_OPT_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Bundle Option';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_bundle_option_value`
--
DROP TABLE IF EXISTS `catalog_product_bundle_option_value`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_bundle_option_value` (
`value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
`title` varchar(255) DEFAULT NULL COMMENT 'Title',
`parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CAT_PRD_BNDL_OPT_VAL_OPT_ID_PARENT_PRD_ID_STORE_ID` (`option_id`,`parent_product_id`,`store_id`),
CONSTRAINT `CAT_PRD_BNDL_OPT_VAL_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Bundle Option Value';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_bundle_selection`
--
DROP TABLE IF EXISTS `catalog_product_bundle_selection`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_bundle_selection` (
`selection_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Selection ID',
`option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
`parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
`product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
`position` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Position',
`is_default` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Default',
`selection_price_type` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Selection Price Type',
`selection_price_value` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Selection Price Value',
`selection_qty` decimal(12,4) DEFAULT NULL COMMENT 'Selection Qty',
`selection_can_change_qty` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Selection Can Change Qty',
PRIMARY KEY (`selection_id`),
KEY `CATALOG_PRODUCT_BUNDLE_SELECTION_OPTION_ID` (`option_id`),
KEY `CATALOG_PRODUCT_BUNDLE_SELECTION_PRODUCT_ID` (`product_id`),
CONSTRAINT `CAT_PRD_BNDL_SELECTION_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Bundle Selection';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity`
--
DROP TABLE IF EXISTS `catalog_product_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute Set ID',
`type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type ID',
`sku` varchar(64) NOT NULL COMMENT 'SKU',
`has_options` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Has Options',
`required_options` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Required Options',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Creation Time',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Update Time',
PRIMARY KEY (`entity_id`),
KEY `CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` (`attribute_set_id`),
KEY `CATALOG_PRODUCT_ENTITY_SKU` (`sku`)
) ENGINE=InnoDB AUTO_INCREMENT=2051 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity_datetime`
--
DROP TABLE IF EXISTS `catalog_product_entity_datetime`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity_datetime` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`value` datetime DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
KEY `CATALOG_PRODUCT_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
KEY `CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID` (`store_id`),
CONSTRAINT `CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_DTIME_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Datetime Attribute Backend Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity_decimal`
--
DROP TABLE IF EXISTS `catalog_product_entity_decimal`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity_decimal` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`value` decimal(20,6) DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID` (`store_id`),
KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
CONSTRAINT `CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_DEC_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3914 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Decimal Attribute Backend Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity_int`
--
DROP TABLE IF EXISTS `catalog_product_entity_int`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity_int` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`value` int(11) DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
KEY `CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
KEY `CATALOG_PRODUCT_ENTITY_INT_STORE_ID` (`store_id`),
KEY `CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID_STORE_ID_VALUE` (`attribute_id`,`store_id`,`value`),
CONSTRAINT `CATALOG_PRODUCT_ENTITY_INT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_INT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25930 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Integer Attribute Backend Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity_media_gallery`
--
DROP TABLE IF EXISTS `catalog_product_entity_media_gallery`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity_media_gallery` (
`value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`value` varchar(255) DEFAULT NULL COMMENT 'Value',
`media_type` varchar(32) NOT NULL DEFAULT 'image' COMMENT 'Media entry type',
`disabled` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Visibility status',
PRIMARY KEY (`value_id`),
KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_ATTRIBUTE_ID` (`attribute_id`),
CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Media Gallery Attribute Backend Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity_media_gallery_value`
--
DROP TABLE IF EXISTS `catalog_product_entity_media_gallery_value`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity_media_gallery_value` (
`value_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Value ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`label` varchar(255) DEFAULT NULL COMMENT 'Label',
`position` int(10) unsigned DEFAULT NULL COMMENT 'Position',
`disabled` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Disabled',
`record_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Record ID',
PRIMARY KEY (`record_id`),
KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_STORE_ID` (`store_id`),
KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_ENTITY_ID` (`entity_id`),
KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_VALUE_ID` (`value_id`),
KEY `CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID` (`entity_id`,`value_id`,`store_id`),
CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Media Gallery Attribute Value Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity_media_gallery_value_to_entity`
--
DROP TABLE IF EXISTS `catalog_product_entity_media_gallery_value_to_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity_media_gallery_value_to_entity` (
`value_id` int(10) unsigned NOT NULL COMMENT 'Value media Entry ID',
`entity_id` int(10) unsigned NOT NULL COMMENT 'Product Entity ID',
PRIMARY KEY (`value_id`,`entity_id`),
KEY `CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` (`entity_id`),
CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `FK_A6C6C8FAA386736921D3A7C4B50B1185` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Link Media value to Product entity table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity_text`
--
DROP TABLE IF EXISTS `catalog_product_entity_text`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity_text` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`value` mediumtext DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
KEY `CATALOG_PRODUCT_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
KEY `CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID` (`store_id`),
CONSTRAINT `CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_TEXT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2815 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Text Attribute Backend Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_entity_varchar`
--
DROP TABLE IF EXISTS `catalog_product_entity_varchar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity_varchar` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`value` varchar(255) DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID` (`store_id`),
CONSTRAINT `CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_VCHR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8445 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Varchar Attribute Backend Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_index_eav`
--
DROP TABLE IF EXISTS `catalog_product_index_eav`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_index_eav` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
`value` int(10) unsigned NOT NULL COMMENT 'Value',
`source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
KEY `CATALOG_PRODUCT_INDEX_EAV_ATTRIBUTE_ID` (`attribute_id`),
KEY `CATALOG_PRODUCT_INDEX_EAV_STORE_ID` (`store_id`),
KEY `CATALOG_PRODUCT_INDEX_EAV_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product EAV Index Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_index_eav_replica`
--
DROP TABLE IF EXISTS `catalog_product_index_eav_replica`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_index_eav_replica` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
`value` int(10) unsigned NOT NULL COMMENT 'Value',
`source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
KEY `CATALOG_PRODUCT_INDEX_EAV_ATTRIBUTE_ID` (`attribute_id`),
KEY `CATALOG_PRODUCT_INDEX_EAV_STORE_ID` (`store_id`),
KEY `CATALOG_PRODUCT_INDEX_EAV_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product EAV Index Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_index_price`
--
DROP TABLE IF EXISTS `catalog_product_index_price`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_index_price` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
`tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
`price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
`final_price` decimal(20,6) DEFAULT NULL COMMENT 'Final Price',
`min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
`max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
`tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
KEY `CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
KEY `CATALOG_PRODUCT_INDEX_PRICE_MIN_PRICE` (`min_price`),
KEY `CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE` (`website_id`,`customer_group_id`,`min_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Price Index Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_index_price_replica`
--
DROP TABLE IF EXISTS `catalog_product_index_price_replica`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_index_price_replica` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
`tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
`price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
`final_price` decimal(20,6) DEFAULT NULL COMMENT 'Final Price',
`min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
`max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
`tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
KEY `CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
KEY `CATALOG_PRODUCT_INDEX_PRICE_MIN_PRICE` (`min_price`),
KEY `CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE` (`website_id`,`customer_group_id`,`min_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Price Index Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_index_website`
--
DROP TABLE IF EXISTS `catalog_product_index_website`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_index_website` (
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
`default_store_id` smallint(5) unsigned NOT NULL COMMENT 'Default store ID for website',
`website_date` date DEFAULT NULL COMMENT 'Website Date',
`rate` float DEFAULT 1 COMMENT 'Rate',
PRIMARY KEY (`website_id`),
KEY `CATALOG_PRODUCT_INDEX_WEBSITE_WEBSITE_DATE` (`website_date`),
CONSTRAINT `CAT_PRD_IDX_WS_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Website Index Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_link`
--
DROP TABLE IF EXISTS `catalog_product_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_link` (
`link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
`product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`linked_product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Linked Product ID',
`link_type_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Link Type ID',
PRIMARY KEY (`link_id`),
UNIQUE KEY `CATALOG_PRODUCT_LINK_LINK_TYPE_ID_PRODUCT_ID_LINKED_PRODUCT_ID` (`link_type_id`,`product_id`,`linked_product_id`),
KEY `CATALOG_PRODUCT_LINK_PRODUCT_ID` (`product_id`),
KEY `CATALOG_PRODUCT_LINK_LINKED_PRODUCT_ID` (`linked_product_id`),
CONSTRAINT `CATALOG_PRODUCT_LINK_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_LNK_LNKED_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`linked_product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_LNK_LNK_TYPE_ID_CAT_PRD_LNK_TYPE_LNK_TYPE_ID` FOREIGN KEY (`link_type_id`) REFERENCES `catalog_product_link_type` (`link_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2435 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product To Product Linkage Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_link_attribute`
--
DROP TABLE IF EXISTS `catalog_product_link_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_link_attribute` (
`product_link_attribute_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product Link Attribute ID',
`link_type_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Link Type ID',
`product_link_attribute_code` varchar(32) DEFAULT NULL COMMENT 'Product Link Attribute Code',
`data_type` varchar(32) DEFAULT NULL COMMENT 'Data Type',
PRIMARY KEY (`product_link_attribute_id`),
KEY `CATALOG_PRODUCT_LINK_ATTRIBUTE_LINK_TYPE_ID` (`link_type_id`),
CONSTRAINT `CAT_PRD_LNK_ATTR_LNK_TYPE_ID_CAT_PRD_LNK_TYPE_LNK_TYPE_ID` FOREIGN KEY (`link_type_id`) REFERENCES `catalog_product_link_type` (`link_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Link Attribute Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_link_attribute_decimal`
--
DROP TABLE IF EXISTS `catalog_product_link_attribute_decimal`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_link_attribute_decimal` (
`value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`product_link_attribute_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Product Link Attribute ID',
`link_id` int(10) unsigned NOT NULL COMMENT 'Link ID',
`value` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CAT_PRD_LNK_ATTR_DEC_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),
KEY `CATALOG_PRODUCT_LINK_ATTRIBUTE_DECIMAL_LINK_ID` (`link_id`),
CONSTRAINT `CAT_PRD_LNK_ATTR_DEC_LNK_ID_CAT_PRD_LNK_LNK_ID` FOREIGN KEY (`link_id`) REFERENCES `catalog_product_link` (`link_id`) ON DELETE CASCADE,
CONSTRAINT `FK_AB2EFA9A14F7BCF1D5400056203D14B6` FOREIGN KEY (`product_link_attribute_id`) REFERENCES `catalog_product_link_attribute` (`product_link_attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Link Decimal Attribute Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_link_attribute_int`
--
DROP TABLE IF EXISTS `catalog_product_link_attribute_int`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_link_attribute_int` (
`value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`product_link_attribute_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Product Link Attribute ID',
`link_id` int(10) unsigned NOT NULL COMMENT 'Link ID',
`value` int(11) NOT NULL DEFAULT 0 COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),
KEY `CATALOG_PRODUCT_LINK_ATTRIBUTE_INT_LINK_ID` (`link_id`),
CONSTRAINT `CAT_PRD_LNK_ATTR_INT_LNK_ID_CAT_PRD_LNK_LNK_ID` FOREIGN KEY (`link_id`) REFERENCES `catalog_product_link` (`link_id`) ON DELETE CASCADE,
CONSTRAINT `FK_D6D878F8BA2A4282F8DDED7E6E3DE35C` FOREIGN KEY (`product_link_attribute_id`) REFERENCES `catalog_product_link_attribute` (`product_link_attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2438 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Link Integer Attribute Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_link_type`
--
DROP TABLE IF EXISTS `catalog_product_link_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_link_type` (
`link_type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link Type ID',
`code` varchar(32) DEFAULT NULL COMMENT 'Code',
PRIMARY KEY (`link_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Link Type Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_relation`
--
DROP TABLE IF EXISTS `catalog_product_relation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_relation` (
`parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
`child_id` int(10) unsigned NOT NULL COMMENT 'Child ID',
PRIMARY KEY (`parent_id`,`child_id`),
KEY `CATALOG_PRODUCT_RELATION_CHILD_ID` (`child_id`),
CONSTRAINT `CAT_PRD_RELATION_CHILD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`child_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_RELATION_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Relation Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_super_attribute`
--
DROP TABLE IF EXISTS `catalog_product_super_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_super_attribute` (
`product_super_attribute_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product Super Attribute ID',
`product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`position` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Position',
PRIMARY KEY (`product_super_attribute_id`),
UNIQUE KEY `CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID` (`product_id`,`attribute_id`),
CONSTRAINT `CAT_PRD_SPR_ATTR_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=296 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Super Attribute Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_super_attribute_label`
--
DROP TABLE IF EXISTS `catalog_product_super_attribute_label`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_super_attribute_label` (
`value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`product_super_attribute_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product Super Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`use_default` smallint(5) unsigned DEFAULT 0 COMMENT 'Use Default Value',
`value` varchar(255) DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
UNIQUE KEY `CAT_PRD_SPR_ATTR_LBL_PRD_SPR_ATTR_ID_STORE_ID` (`product_super_attribute_id`,`store_id`),
KEY `CATALOG_PRODUCT_SUPER_ATTRIBUTE_LABEL_STORE_ID` (`store_id`),
CONSTRAINT `CATALOG_PRODUCT_SUPER_ATTRIBUTE_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `FK_309442281DF7784210ED82B2CC51E5D5` FOREIGN KEY (`product_super_attribute_id`) REFERENCES `catalog_product_super_attribute` (`product_super_attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Super Attribute Label Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_super_link`
--
DROP TABLE IF EXISTS `catalog_product_super_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_super_link` (
`link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
`product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Parent ID',
PRIMARY KEY (`link_id`),
UNIQUE KEY `CATALOG_PRODUCT_SUPER_LINK_PRODUCT_ID_PARENT_ID` (`product_id`,`parent_id`),
KEY `CATALOG_PRODUCT_SUPER_LINK_PARENT_ID` (`parent_id`),
CONSTRAINT `CAT_PRD_SPR_LNK_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_SPR_LNK_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2100 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product Super Link Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalog_product_website`
--
DROP TABLE IF EXISTS `catalog_product_website`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_website` (
`product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
PRIMARY KEY (`product_id`,`website_id`),
KEY `CATALOG_PRODUCT_WEBSITE_WEBSITE_ID` (`website_id`),
CONSTRAINT `CATALOG_PRODUCT_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_WS_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Product To Website Linkage Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cataloginventory_stock_item`
--
DROP TABLE IF EXISTS `cataloginventory_stock_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cataloginventory_stock_item` (
`item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
`product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`stock_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Stock ID',
`qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
`min_qty` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Min Qty',
`use_config_min_qty` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Use Config Min Qty',
`is_qty_decimal` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Qty Decimal',
`backorders` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Backorders',
`use_config_backorders` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Use Config Backorders',
`min_sale_qty` decimal(12,4) NOT NULL DEFAULT 1.0000 COMMENT 'Min Sale Qty',
`use_config_min_sale_qty` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Use Config Min Sale Qty',
`max_sale_qty` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Max Sale Qty',
`use_config_max_sale_qty` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Use Config Max Sale Qty',
`is_in_stock` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is In Stock',
`low_stock_date` timestamp NULL DEFAULT NULL COMMENT 'Low Stock Date',
`notify_stock_qty` decimal(12,4) DEFAULT NULL COMMENT 'Notify Stock Qty',
`use_config_notify_stock_qty` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Use Config Notify Stock Qty',
`manage_stock` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Manage Stock',
`use_config_manage_stock` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Use Config Manage Stock',
`stock_status_changed_auto` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Stock Status Changed Automatically',
`use_config_qty_increments` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Use Config Qty Increments',
`qty_increments` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Increments',
`use_config_enable_qty_inc` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Use Config Enable Qty Increments',
`enable_qty_increments` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Enable Qty Increments',
`is_decimal_divided` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Divided into Multiple Boxes for Shipping',
`website_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Website ID',
PRIMARY KEY (`item_id`),
UNIQUE KEY `CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID` (`product_id`,`stock_id`),
KEY `CATALOGINVENTORY_STOCK_ITEM_WEBSITE_ID` (`website_id`),
KEY `CATALOGINVENTORY_STOCK_ITEM_WEBSITE_ID_PRODUCT_ID` (`website_id`,`product_id`),
KEY `CATALOGINVENTORY_STOCK_ITEM_STOCK_ID` (`stock_id`),
CONSTRAINT `CATINV_STOCK_ITEM_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CATINV_STOCK_ITEM_STOCK_ID_CATINV_STOCK_STOCK_ID` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2051 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Cataloginventory Stock Item';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cataloginventory_stock_status`
--
DROP TABLE IF EXISTS `cataloginventory_stock_status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cataloginventory_stock_status` (
`product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
`stock_id` smallint(5) unsigned NOT NULL COMMENT 'Stock ID',
`qty` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty',
`stock_status` smallint(5) unsigned NOT NULL COMMENT 'Stock Status',
PRIMARY KEY (`product_id`,`website_id`,`stock_id`),
KEY `CATALOGINVENTORY_STOCK_STATUS_STOCK_ID` (`stock_id`),
KEY `CATALOGINVENTORY_STOCK_STATUS_WEBSITE_ID` (`website_id`),
KEY `CATALOGINVENTORY_STOCK_STATUS_STOCK_STATUS` (`stock_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Cataloginventory Stock Status';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cataloginventory_stock_status_replica`
--
DROP TABLE IF EXISTS `cataloginventory_stock_status_replica`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cataloginventory_stock_status_replica` (
`product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
`stock_id` smallint(5) unsigned NOT NULL COMMENT 'Stock ID',
`qty` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty',
`stock_status` smallint(5) unsigned NOT NULL COMMENT 'Stock Status',
PRIMARY KEY (`product_id`,`website_id`,`stock_id`),
KEY `CATALOGINVENTORY_STOCK_STATUS_STOCK_ID` (`stock_id`),
KEY `CATALOGINVENTORY_STOCK_STATUS_WEBSITE_ID` (`website_id`),
KEY `CATALOGINVENTORY_STOCK_STATUS_STOCK_STATUS` (`stock_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Cataloginventory Stock Status';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalogrule`
--
DROP TABLE IF EXISTS `catalogrule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalogrule` (
`rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`name` varchar(255) DEFAULT NULL COMMENT 'Name',
`description` text DEFAULT NULL COMMENT 'Description',
`from_date` date DEFAULT NULL COMMENT 'From',
`to_date` date DEFAULT NULL COMMENT 'To',
`is_active` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Active',
`conditions_serialized` mediumtext DEFAULT NULL COMMENT 'Conditions Serialized',
`actions_serialized` mediumtext DEFAULT NULL COMMENT 'Actions Serialized',
`stop_rules_processing` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Stop Rules Processing',
`sort_order` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
`simple_action` varchar(32) DEFAULT NULL COMMENT 'Simple Action',
`discount_amount` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Discount Amount',
PRIMARY KEY (`rule_id`),
KEY `CATALOGRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='CatalogRule';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalogrule_customer_group`
--
DROP TABLE IF EXISTS `catalogrule_customer_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalogrule_customer_group` (
`rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
`customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
PRIMARY KEY (`rule_id`,`customer_group_id`),
KEY `CATALOGRULE_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
CONSTRAINT `CATALOGRULE_CUSTOMER_GROUP_RULE_ID_CATALOGRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `catalogrule` (`rule_id`) ON DELETE CASCADE,
CONSTRAINT `CATRULE_CSTR_GROUP_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Rules To Customer Groups Relations';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalogrule_group_website`
--
DROP TABLE IF EXISTS `catalogrule_group_website`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalogrule_group_website` (
`rule_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Rule ID',
`customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
`website_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Website ID',
PRIMARY KEY (`rule_id`,`customer_group_id`,`website_id`),
KEY `CATALOGRULE_GROUP_WEBSITE_CUSTOMER_GROUP_ID` (`customer_group_id`),
KEY `CATALOGRULE_GROUP_WEBSITE_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='CatalogRule Group Website';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalogrule_product`
--
DROP TABLE IF EXISTS `catalogrule_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalogrule_product` (
`rule_product_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Product ID',
`rule_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Rule ID',
`from_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'From Time',
`to_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'To time',
`customer_group_id` int(11) DEFAULT NULL,
`product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`action_operator` varchar(10) DEFAULT 'to_fixed' COMMENT 'Action Operator',
`action_amount` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Action Amount',
`action_stop` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Action Stop',
`sort_order` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
PRIMARY KEY (`rule_product_id`),
UNIQUE KEY `UNQ_EAA51B56FF092A0DCB795D1CEF812B7B` (`rule_id`,`from_time`,`to_time`,`website_id`,`customer_group_id`,`product_id`,`sort_order`),
KEY `CATALOGRULE_PRODUCT_CUSTOMER_GROUP_ID` (`customer_group_id`),
KEY `CATALOGRULE_PRODUCT_WEBSITE_ID` (`website_id`),
KEY `CATALOGRULE_PRODUCT_FROM_TIME` (`from_time`),
KEY `CATALOGRULE_PRODUCT_TO_TIME` (`to_time`),
KEY `CATALOGRULE_PRODUCT_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2792 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='CatalogRule Product';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalogrule_product_price`
--
DROP TABLE IF EXISTS `catalogrule_product_price`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalogrule_product_price` (
`rule_product_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Product PriceId',
`rule_date` date NOT NULL COMMENT 'Rule Date',
`customer_group_id` int(11) DEFAULT NULL,
`product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`rule_price` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Rule Price',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
`latest_start_date` date DEFAULT NULL COMMENT 'Latest StartDate',
`earliest_end_date` date DEFAULT NULL COMMENT 'Earliest EndDate',
PRIMARY KEY (`rule_product_price_id`),
UNIQUE KEY `CATRULE_PRD_PRICE_RULE_DATE_WS_ID_CSTR_GROUP_ID_PRD_ID` (`rule_date`,`website_id`,`customer_group_id`,`product_id`),
KEY `CATALOGRULE_PRODUCT_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
KEY `CATALOGRULE_PRODUCT_PRICE_WEBSITE_ID` (`website_id`),
KEY `CATALOGRULE_PRODUCT_PRICE_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7702 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='CatalogRule Product Price';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `catalogrule_website`
--
DROP TABLE IF EXISTS `catalogrule_website`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalogrule_website` (
`rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
PRIMARY KEY (`rule_id`,`website_id`),
KEY `CATALOGRULE_WEBSITE_WEBSITE_ID` (`website_id`),
CONSTRAINT `CATALOGRULE_WEBSITE_RULE_ID_CATALOGRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `catalogrule` (`rule_id`) ON DELETE CASCADE,
CONSTRAINT `CATALOGRULE_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Catalog Rules To Websites Relations';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cms_block`
--
DROP TABLE IF EXISTS `cms_block`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_block` (
`block_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`title` varchar(255) NOT NULL COMMENT 'Block Title',
`identifier` varchar(255) NOT NULL COMMENT 'Block String Identifier',
`content` mediumtext DEFAULT NULL COMMENT 'Block Content',
`creation_time` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Block Creation Time',
`update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Block Modification Time',
`is_active` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Is Block Active',
PRIMARY KEY (`block_id`),
KEY `CMS_BLOCK_IDENTIFIER` (`identifier`),
FULLTEXT KEY `CMS_BLOCK_TITLE_IDENTIFIER_CONTENT` (`title`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='CMS Block Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cms_block_store`
--
DROP TABLE IF EXISTS `cms_block_store`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_block_store` (
`block_id` smallint(6) NOT NULL,
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`block_id`,`store_id`),
KEY `CMS_BLOCK_STORE_STORE_ID` (`store_id`),
CONSTRAINT `CMS_BLOCK_STORE_BLOCK_ID_CMS_BLOCK_BLOCK_ID` FOREIGN KEY (`block_id`) REFERENCES `cms_block` (`block_id`) ON DELETE CASCADE,
CONSTRAINT `CMS_BLOCK_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='CMS Block To Store Linkage Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cms_page`
--
DROP TABLE IF EXISTS `cms_page`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_page` (
`page_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
`page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
`meta_keywords` text DEFAULT NULL COMMENT 'Page Meta Keywords',
`meta_description` text DEFAULT NULL COMMENT 'Page Meta Description',
`identifier` varchar(100) DEFAULT NULL COMMENT 'Page String Identifier',
`content_heading` varchar(255) DEFAULT NULL COMMENT 'Page Content Heading',
`content` mediumtext DEFAULT NULL COMMENT 'Page Content',
`creation_time` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Page Creation Time',
`update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Page Modification Time',
`is_active` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Is Page Active',
`sort_order` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Page Sort Order',
`layout_update_xml` text DEFAULT NULL COMMENT 'Page Layout Update Content',
`custom_theme` varchar(100) DEFAULT NULL COMMENT 'Page Custom Theme',
`custom_root_template` varchar(255) DEFAULT NULL COMMENT 'Page Custom Template',
`custom_layout_update_xml` text DEFAULT NULL COMMENT 'Page Custom Layout Update Content',
`layout_update_selected` varchar(128) DEFAULT NULL COMMENT 'Page Custom Layout File',
`custom_theme_from` date DEFAULT NULL COMMENT 'Page Custom Theme Active From Date',
`custom_theme_to` date DEFAULT NULL COMMENT 'Page Custom Theme Active To Date',
`meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Meta Title',
PRIMARY KEY (`page_id`),
KEY `CMS_PAGE_IDENTIFIER` (`identifier`),
FULLTEXT KEY `CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='CMS Page Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cms_page_store`
--
DROP TABLE IF EXISTS `cms_page_store`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_page_store` (
`page_id` smallint(6) NOT NULL COMMENT 'Entity ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`page_id`,`store_id`),
KEY `CMS_PAGE_STORE_STORE_ID` (`store_id`),
CONSTRAINT `CMS_PAGE_STORE_PAGE_ID_CMS_PAGE_PAGE_ID` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`page_id`) ON DELETE CASCADE,
CONSTRAINT `CMS_PAGE_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='CMS Page To Store Linkage Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `core_config_data`
--
DROP TABLE IF EXISTS `core_config_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_config_data` (
`config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Config ID',
`scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Config Scope',
`scope_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Config Scope ID',
`path` varchar(255) NOT NULL DEFAULT 'general' COMMENT 'Config Path',
`value` text DEFAULT NULL COMMENT 'Config Value',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
PRIMARY KEY (`config_id`),
UNIQUE KEY `CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Config Data';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cron_schedule`
--
DROP TABLE IF EXISTS `cron_schedule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cron_schedule` (
`schedule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Schedule ID',
`job_code` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Job Code',
`status` varchar(7) NOT NULL DEFAULT 'pending' COMMENT 'Status',
`messages` text DEFAULT NULL COMMENT 'Messages',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`scheduled_at` timestamp NULL DEFAULT NULL COMMENT 'Scheduled At',
`executed_at` timestamp NULL DEFAULT NULL COMMENT 'Executed At',
`finished_at` timestamp NULL DEFAULT NULL COMMENT 'Finished At',
PRIMARY KEY (`schedule_id`),
KEY `CRON_SCHEDULE_JOB_CODE_STATUS_SCHEDULED_AT` (`job_code`,`status`,`scheduled_at`)
) ENGINE=InnoDB AUTO_INCREMENT=1274372 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Cron Schedule';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `customer_address_entity`
--
DROP TABLE IF EXISTS `customer_address_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_address_entity` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`is_active` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Active',
`city` varchar(255) NOT NULL COMMENT 'City',
`company` varchar(255) DEFAULT NULL COMMENT 'Company',
`country_id` varchar(255) NOT NULL COMMENT 'Country',
`fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
`firstname` varchar(255) NOT NULL COMMENT 'First Name',
`lastname` varchar(255) NOT NULL COMMENT 'Last Name',
`middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name',
`postcode` varchar(255) DEFAULT NULL COMMENT 'Zip/Postal Code',
`prefix` varchar(40) DEFAULT NULL COMMENT 'Name Prefix',
`region` varchar(255) DEFAULT NULL COMMENT 'State/Province',
`region_id` int(10) unsigned DEFAULT NULL COMMENT 'State/Province',
`street` text NOT NULL COMMENT 'Street Address',
`suffix` varchar(40) DEFAULT NULL COMMENT 'Name Suffix',
`telephone` varchar(255) NOT NULL COMMENT 'Phone Number',
`vat_id` varchar(255) DEFAULT NULL COMMENT 'VAT number',
`vat_is_valid` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validity',
`vat_request_date` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request date',
`vat_request_id` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request ID',
`vat_request_success` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validation request success',
PRIMARY KEY (`entity_id`),
KEY `CUSTOMER_ADDRESS_ENTITY_PARENT_ID` (`parent_id`),
CONSTRAINT `CUSTOMER_ADDRESS_ENTITY_PARENT_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Customer Address Entity';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `customer_eav_attribute`
--
DROP TABLE IF EXISTS `customer_eav_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_eav_attribute` (
`attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
`is_visible` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Visible',
`input_filter` varchar(255) DEFAULT NULL COMMENT 'Input Filter',
`multiline_count` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Multiline Count',
`validate_rules` text DEFAULT NULL COMMENT 'Validate Rules',
`is_system` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is System',
`sort_order` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
`data_model` varchar(255) DEFAULT NULL COMMENT 'Data Model',
`is_used_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used in Grid',
`is_visible_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible in Grid',
`is_filterable_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Filterable in Grid',
`is_searchable_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Searchable in Grid',
`grid_filter_condition_type` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Grid Filter Condition Type',
PRIMARY KEY (`attribute_id`),
KEY `CUSTOMER_EAV_ATTRIBUTE_SORT_ORDER` (`sort_order`),
CONSTRAINT `CUSTOMER_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Customer Eav Attribute';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `customer_eav_attribute_website`
--
DROP TABLE IF EXISTS `customer_eav_attribute_website`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_eav_attribute_website` (
`attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
`is_visible` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Visible',
`is_required` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Required',
`default_value` text DEFAULT NULL COMMENT 'Default Value',
`multiline_count` smallint(5) unsigned DEFAULT NULL COMMENT 'Multiline Count',
PRIMARY KEY (`attribute_id`,`website_id`),
KEY `CUSTOMER_EAV_ATTRIBUTE_WEBSITE_WEBSITE_ID` (`website_id`),
CONSTRAINT `CSTR_EAV_ATTR_WS_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `CSTR_EAV_ATTR_WS_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Customer Eav Attribute Website';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `customer_entity`
--
DROP TABLE IF EXISTS `customer_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_entity` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`website_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Website ID',
`email` varchar(255) DEFAULT NULL COMMENT 'Email',
`group_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Group ID',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`store_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Store ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`is_active` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Active',
`disable_auto_group_change` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Disable automatic group change based on VAT ID',
`created_in` varchar(255) DEFAULT NULL COMMENT 'Created From',
`prefix` varchar(40) DEFAULT NULL COMMENT 'Name Prefix',
`firstname` varchar(255) DEFAULT NULL COMMENT 'First Name',
`middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name/Initial',
`lastname` varchar(255) DEFAULT NULL COMMENT 'Last Name',
`suffix` varchar(40) DEFAULT NULL COMMENT 'Name Suffix',
`dob` date DEFAULT NULL COMMENT 'Date of Birth',
`password_hash` varchar(128) DEFAULT NULL COMMENT 'Password_hash',
`rp_token` varchar(128) DEFAULT NULL COMMENT 'Reset password token',
`rp_token_created_at` datetime DEFAULT NULL COMMENT 'Reset password token creation time',
`default_billing` int(10) unsigned DEFAULT NULL COMMENT 'Default Billing Address',
`default_shipping` int(10) unsigned DEFAULT NULL COMMENT 'Default Shipping Address',
`taxvat` varchar(50) DEFAULT NULL COMMENT 'Tax/VAT Number',
`confirmation` varchar(64) DEFAULT NULL COMMENT 'Is Confirmed',
`gender` smallint(5) unsigned DEFAULT NULL COMMENT 'Gender',
`failures_num` smallint(6) DEFAULT 0 COMMENT 'Failure Number',
`first_failure` timestamp NULL DEFAULT NULL COMMENT 'First Failure',
`lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock Expiration Date',
`session_cutoff` timestamp NULL DEFAULT NULL COMMENT 'Session Cutoff Time',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`,`website_id`),
KEY `CUSTOMER_ENTITY_STORE_ID` (`store_id`),
KEY `CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
KEY `CUSTOMER_ENTITY_FIRSTNAME` (`firstname`),
KEY `CUSTOMER_ENTITY_LASTNAME` (`lastname`),
CONSTRAINT `CUSTOMER_ENTITY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL,
CONSTRAINT `CUSTOMER_ENTITY_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Customer Entity';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `customer_form_attribute`
--
DROP TABLE IF EXISTS `customer_form_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_form_attribute` (
`form_code` varchar(32) NOT NULL COMMENT 'Form Code',
`attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
PRIMARY KEY (`form_code`,`attribute_id`),
KEY `CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
CONSTRAINT `CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Customer Form Attribute';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `customer_grid_flat`
--
DROP TABLE IF EXISTS `customer_grid_flat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_grid_flat` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`name` text DEFAULT NULL COMMENT 'Name',
`email` varchar(255) DEFAULT NULL COMMENT 'Email',
`group_id` int(11) DEFAULT NULL COMMENT 'Group_id',
`created_at` timestamp NULL DEFAULT NULL COMMENT 'Created_at',
`website_id` int(11) DEFAULT NULL COMMENT 'Website_id',
`confirmation` varchar(255) DEFAULT NULL COMMENT 'Confirmation',
`created_in` text DEFAULT NULL COMMENT 'Created_in',
`dob` date DEFAULT NULL COMMENT 'Dob',
`gender` int(11) DEFAULT NULL COMMENT 'Gender',
`taxvat` varchar(255) DEFAULT NULL COMMENT 'Taxvat',
`lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock_expires',
`shipping_full` text DEFAULT NULL COMMENT 'Shipping_full',
`billing_full` text DEFAULT NULL COMMENT 'Billing_full',
`billing_firstname` varchar(255) DEFAULT NULL COMMENT 'Billing_firstname',
`billing_lastname` varchar(255) DEFAULT NULL COMMENT 'Billing_lastname',
`billing_telephone` varchar(255) DEFAULT NULL COMMENT 'Billing_telephone',
`billing_postcode` varchar(255) DEFAULT NULL COMMENT 'Billing_postcode',
`billing_country_id` varchar(255) DEFAULT NULL COMMENT 'Billing_country_id',
`billing_region` varchar(255) DEFAULT NULL COMMENT 'Billing_region',
`billing_region_id` int(11) DEFAULT NULL COMMENT 'Billing_region_id',
`billing_street` varchar(255) DEFAULT NULL COMMENT 'Billing_street',
`billing_city` varchar(255) DEFAULT NULL COMMENT 'Billing_city',
`billing_fax` varchar(255) DEFAULT NULL COMMENT 'Billing_fax',
`billing_vat_id` varchar(255) DEFAULT NULL COMMENT 'Billing_vat_id',
`billing_company` varchar(255) DEFAULT NULL COMMENT 'Billing_company',
PRIMARY KEY (`entity_id`),
KEY `CUSTOMER_GRID_FLAT_GROUP_ID` (`group_id`),
KEY `CUSTOMER_GRID_FLAT_CREATED_AT` (`created_at`),
KEY `CUSTOMER_GRID_FLAT_WEBSITE_ID` (`website_id`),
KEY `CUSTOMER_GRID_FLAT_CONFIRMATION` (`confirmation`),
KEY `CUSTOMER_GRID_FLAT_DOB` (`dob`),
KEY `CUSTOMER_GRID_FLAT_GENDER` (`gender`),
KEY `CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID` (`billing_country_id`),
FULLTEXT KEY `FTI_8746F705702DD5F6D45B8C7CE7FE9F2F` (`name`,`email`,`created_in`,`taxvat`,`shipping_full`,`billing_full`,`billing_firstname`,`billing_lastname`,`billing_telephone`,`billing_postcode`,`billing_region`,`billing_city`,`billing_fax`,`billing_company`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='customer_grid_flat';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `customer_group`
--
DROP TABLE IF EXISTS `customer_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_group` (
`customer_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`customer_group_code` varchar(32) NOT NULL COMMENT 'Customer Group Code',
`tax_class_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Tax Class ID',
PRIMARY KEY (`customer_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Customer Group';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `customer_log`
--
DROP TABLE IF EXISTS `customer_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_log` (
`log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
`customer_id` int(11) NOT NULL COMMENT 'Customer ID',
`last_login_at` timestamp NULL DEFAULT NULL COMMENT 'Last Login Time',
`last_logout_at` timestamp NULL DEFAULT NULL COMMENT 'Last Logout Time',
PRIMARY KEY (`log_id`),
UNIQUE KEY `CUSTOMER_LOG_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Customer Log Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `design_config_grid_flat`
--
DROP TABLE IF EXISTS `design_config_grid_flat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `design_config_grid_flat` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`store_website_id` int(11) DEFAULT NULL COMMENT 'Store_website_id',
`store_group_id` int(11) DEFAULT NULL COMMENT 'Store_group_id',
`store_id` int(11) DEFAULT NULL COMMENT 'Store_id',
`theme_theme_id` varchar(255) DEFAULT NULL COMMENT 'Theme_theme_id',
PRIMARY KEY (`entity_id`),
KEY `DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`),
KEY `DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`),
KEY `DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`),
FULLTEXT KEY `DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='design_config_grid_flat';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `directory_country`
--
DROP TABLE IF EXISTS `directory_country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directory_country` (
`country_id` varchar(2) NOT NULL COMMENT 'Country ID in ISO-2',
`iso2_code` varchar(2) DEFAULT NULL COMMENT 'Country ISO-2 format',
`iso3_code` varchar(3) DEFAULT NULL COMMENT 'Country ISO-3',
PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Directory Country';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `directory_country_region`
--
DROP TABLE IF EXISTS `directory_country_region`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directory_country_region` (
`region_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Region ID',
`country_id` varchar(4) NOT NULL DEFAULT '0' COMMENT 'Country ID in ISO-2',
`code` varchar(32) DEFAULT NULL COMMENT 'Region code',
`default_name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
PRIMARY KEY (`region_id`),
KEY `DIRECTORY_COUNTRY_REGION_COUNTRY_ID` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1122 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Directory Country Region';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `directory_country_region_name`
--
DROP TABLE IF EXISTS `directory_country_region_name`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directory_country_region_name` (
`locale` varchar(16) NOT NULL COMMENT 'Locale',
`region_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Region ID',
`name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
PRIMARY KEY (`locale`,`region_id`),
KEY `DIRECTORY_COUNTRY_REGION_NAME_REGION_ID` (`region_id`),
CONSTRAINT `DIR_COUNTRY_REGION_NAME_REGION_ID_DIR_COUNTRY_REGION_REGION_ID` FOREIGN KEY (`region_id`) REFERENCES `directory_country_region` (`region_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Directory Country Region Name';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `directory_currency_rate`
--
DROP TABLE IF EXISTS `directory_currency_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directory_currency_rate` (
`currency_from` varchar(3) NOT NULL COMMENT 'Currency Code Convert From',
`currency_to` varchar(3) NOT NULL COMMENT 'Currency Code Convert To',
`rate` decimal(24,12) NOT NULL DEFAULT 0.000000000000 COMMENT 'Currency Conversion Rate',
PRIMARY KEY (`currency_from`,`currency_to`),
KEY `DIRECTORY_CURRENCY_RATE_CURRENCY_TO` (`currency_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Directory Currency Rate';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_attribute`
--
DROP TABLE IF EXISTS `eav_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_attribute` (
`attribute_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute ID',
`entity_type_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
`attribute_code` varchar(255) NOT NULL COMMENT 'Attribute Code',
`attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
`backend_model` varchar(255) DEFAULT NULL COMMENT 'Backend Model',
`backend_type` varchar(8) NOT NULL DEFAULT 'static' COMMENT 'Backend Type',
`backend_table` varchar(255) DEFAULT NULL COMMENT 'Backend Table',
`frontend_model` varchar(255) DEFAULT NULL COMMENT 'Frontend Model',
`frontend_input` varchar(50) DEFAULT NULL COMMENT 'Frontend Input',
`frontend_label` varchar(255) DEFAULT NULL COMMENT 'Frontend Label',
`frontend_class` varchar(255) DEFAULT NULL COMMENT 'Frontend Class',
`source_model` varchar(255) DEFAULT NULL COMMENT 'Source Model',
`is_required` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Defines Is Required',
`is_user_defined` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Defines Is User Defined',
`default_value` text DEFAULT NULL COMMENT 'Default Value',
`is_unique` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Defines Is Unique',
`note` varchar(255) DEFAULT NULL COMMENT 'Note',
PRIMARY KEY (`attribute_id`),
UNIQUE KEY `EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE` (`entity_type_id`,`attribute_code`),
KEY `EAV_ATTRIBUTE_FRONTEND_INPUT_ENTITY_TYPE_ID_IS_USER_DEFINED` (`frontend_input`,`entity_type_id`,`is_user_defined`),
CONSTRAINT `EAV_ATTRIBUTE_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Attribute';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_attribute_group`
--
DROP TABLE IF EXISTS `eav_attribute_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_attribute_group` (
`attribute_group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Group ID',
`attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute Set ID',
`attribute_group_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Group Name',
`sort_order` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Sort Order',
`default_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Default ID',
`attribute_group_code` varchar(255) NOT NULL COMMENT 'Attribute Group Code',
`tab_group_code` varchar(255) DEFAULT NULL COMMENT 'Tab Group Code',
PRIMARY KEY (`attribute_group_id`),
UNIQUE KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE` (`attribute_set_id`,`attribute_group_code`),
UNIQUE KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME` (`attribute_set_id`,`attribute_group_name`),
KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
CONSTRAINT `EAV_ATTR_GROUP_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Attribute Group';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_attribute_label`
--
DROP TABLE IF EXISTS `eav_attribute_label`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_attribute_label` (
`attribute_label_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Label ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`value` varchar(255) DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`attribute_label_id`),
KEY `EAV_ATTRIBUTE_LABEL_STORE_ID` (`store_id`),
KEY `EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID` (`attribute_id`,`store_id`),
CONSTRAINT `EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `EAV_ATTRIBUTE_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Attribute Label';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_attribute_option`
--
DROP TABLE IF EXISTS `eav_attribute_option`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_attribute_option` (
`option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`sort_order` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
PRIMARY KEY (`option_id`),
KEY `EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID` (`attribute_id`),
CONSTRAINT `EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=212 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Attribute Option';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_attribute_option_swatch`
--
DROP TABLE IF EXISTS `eav_attribute_option_swatch`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_attribute_option_swatch` (
`swatch_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Swatch ID',
`option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
`type` smallint(5) unsigned NOT NULL COMMENT 'Swatch type: 0 - text, 1 - visual color, 2 - visual image',
`value` varchar(255) DEFAULT NULL COMMENT 'Swatch Value',
PRIMARY KEY (`swatch_id`),
UNIQUE KEY `EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_OPTION_ID` (`store_id`,`option_id`),
KEY `EAV_ATTR_OPT_SWATCH_OPT_ID_EAV_ATTR_OPT_OPT_ID` (`option_id`),
KEY `EAV_ATTRIBUTE_OPTION_SWATCH_SWATCH_ID` (`swatch_id`),
CONSTRAINT `EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `EAV_ATTR_OPT_SWATCH_OPT_ID_EAV_ATTR_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `eav_attribute_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Magento Swatches table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_attribute_option_value`
--
DROP TABLE IF EXISTS `eav_attribute_option_value`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_attribute_option_value` (
`value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`value` varchar(255) DEFAULT NULL COMMENT 'Value',
PRIMARY KEY (`value_id`),
KEY `EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID` (`option_id`),
KEY `EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID` (`store_id`),
CONSTRAINT `EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `EAV_ATTR_OPT_VAL_OPT_ID_EAV_ATTR_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `eav_attribute_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=239 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Attribute Option Value';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_attribute_set`
--
DROP TABLE IF EXISTS `eav_attribute_set`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_attribute_set` (
`attribute_set_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Set ID',
`entity_type_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
`attribute_set_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Set Name',
`sort_order` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Sort Order',
PRIMARY KEY (`attribute_set_id`),
UNIQUE KEY `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME` (`entity_type_id`,`attribute_set_name`),
KEY `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_SORT_ORDER` (`entity_type_id`,`sort_order`),
CONSTRAINT `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Attribute Set';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_entity_attribute`
--
DROP TABLE IF EXISTS `eav_entity_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_entity_attribute` (
`entity_attribute_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Attribute ID',
`entity_type_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
`attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute Set ID',
`attribute_group_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute Group ID',
`attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
`sort_order` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Sort Order',
PRIMARY KEY (`entity_attribute_id`),
UNIQUE KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID` (`attribute_set_id`,`attribute_id`),
UNIQUE KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID` (`attribute_group_id`,`attribute_id`),
KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
CONSTRAINT `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `EAV_ENTT_ATTR_ATTR_GROUP_ID_EAV_ATTR_GROUP_ATTR_GROUP_ID` FOREIGN KEY (`attribute_group_id`) REFERENCES `eav_attribute_group` (`attribute_group_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=676 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Entity Attributes';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_entity_type`
--
DROP TABLE IF EXISTS `eav_entity_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_entity_type` (
`entity_type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Type ID',
`entity_type_code` varchar(50) NOT NULL COMMENT 'Entity Type Code',
`entity_model` varchar(255) NOT NULL COMMENT 'Entity Model',
`attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
`entity_table` varchar(255) DEFAULT NULL COMMENT 'Entity Table',
`value_table_prefix` varchar(255) DEFAULT NULL COMMENT 'Value Table Prefix',
`entity_id_field` varchar(255) DEFAULT NULL COMMENT 'Entity ID Field',
`is_data_sharing` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Defines Is Data Sharing',
`data_sharing_key` varchar(100) DEFAULT 'default' COMMENT 'Data Sharing Key',
`default_attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Default Attribute Set ID',
`increment_model` varchar(255) DEFAULT NULL COMMENT 'Increment Model',
`increment_per_store` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Increment Per Store',
`increment_pad_length` smallint(5) unsigned NOT NULL DEFAULT 8 COMMENT 'Increment Pad Length',
`increment_pad_char` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Increment Pad Char',
`additional_attribute_table` varchar(255) DEFAULT NULL COMMENT 'Additional Attribute Table',
`entity_attribute_collection` varchar(255) DEFAULT NULL COMMENT 'Entity Attribute Collection',
PRIMARY KEY (`entity_type_id`),
KEY `EAV_ENTITY_TYPE_ENTITY_TYPE_CODE` (`entity_type_code`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Entity Type';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_form_element`
--
DROP TABLE IF EXISTS `eav_form_element`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_form_element` (
`element_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Element ID',
`type_id` smallint(5) unsigned NOT NULL COMMENT 'Type ID',
`fieldset_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Fieldset ID',
`attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
`sort_order` int(11) NOT NULL DEFAULT 0 COMMENT 'Sort Order',
PRIMARY KEY (`element_id`),
UNIQUE KEY `EAV_FORM_ELEMENT_TYPE_ID_ATTRIBUTE_ID` (`type_id`,`attribute_id`),
KEY `EAV_FORM_ELEMENT_FIELDSET_ID` (`fieldset_id`),
KEY `EAV_FORM_ELEMENT_ATTRIBUTE_ID` (`attribute_id`),
CONSTRAINT `EAV_FORM_ELEMENT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `EAV_FORM_ELEMENT_FIELDSET_ID_EAV_FORM_FIELDSET_FIELDSET_ID` FOREIGN KEY (`fieldset_id`) REFERENCES `eav_form_fieldset` (`fieldset_id`) ON DELETE SET NULL,
CONSTRAINT `EAV_FORM_ELEMENT_TYPE_ID_EAV_FORM_TYPE_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `eav_form_type` (`type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Form Element';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_form_type`
--
DROP TABLE IF EXISTS `eav_form_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_form_type` (
`type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Type ID',
`code` varchar(64) NOT NULL COMMENT 'Code',
`label` varchar(255) NOT NULL COMMENT 'Label',
`is_system` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is System',
`theme` varchar(64) DEFAULT NULL COMMENT 'Theme',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`type_id`),
UNIQUE KEY `EAV_FORM_TYPE_CODE_THEME_STORE_ID` (`code`,`theme`,`store_id`),
KEY `EAV_FORM_TYPE_STORE_ID` (`store_id`),
CONSTRAINT `EAV_FORM_TYPE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Form Type';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `eav_form_type_entity`
--
DROP TABLE IF EXISTS `eav_form_type_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eav_form_type_entity` (
`type_id` smallint(5) unsigned NOT NULL COMMENT 'Type ID',
`entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
PRIMARY KEY (`type_id`,`entity_type_id`),
KEY `EAV_FORM_TYPE_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
CONSTRAINT `EAV_FORM_TYPE_ENTITY_TYPE_ID_EAV_FORM_TYPE_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `eav_form_type` (`type_id`) ON DELETE CASCADE,
CONSTRAINT `EAV_FORM_TYPE_ENTT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Eav Form Type Entity';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `flag`
--
DROP TABLE IF EXISTS `flag`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `flag` (
`flag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Flag Id',
`flag_code` varchar(255) NOT NULL COMMENT 'Flag Code',
`state` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Flag State',
`flag_data` mediumtext DEFAULT NULL COMMENT 'Flag Data',
`last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date of Last Flag Update',
PRIMARY KEY (`flag_id`),
KEY `FLAG_LAST_UPDATE` (`last_update`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Flag';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `indexer_state`
--
DROP TABLE IF EXISTS `indexer_state`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `indexer_state` (
`state_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Indexer State ID',
`indexer_id` varchar(255) DEFAULT NULL COMMENT 'Indexer ID',
`status` varchar(16) DEFAULT 'invalid' COMMENT 'Indexer Status',
`updated` datetime DEFAULT NULL COMMENT 'Indexer Status',
`hash_config` varchar(32) NOT NULL COMMENT 'Hash of indexer config',
PRIMARY KEY (`state_id`),
KEY `INDEXER_STATE_INDEXER_ID` (`indexer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Indexer State';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `integration`
--
DROP TABLE IF EXISTS `integration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `integration` (
`integration_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Integration ID',
`name` varchar(255) NOT NULL COMMENT 'Integration name is displayed in the admin interface',
`email` varchar(255) NOT NULL COMMENT 'Email address of the contact person',
`endpoint` varchar(255) DEFAULT NULL COMMENT 'Endpoint for posting consumer credentials',
`status` smallint(5) unsigned NOT NULL COMMENT 'Integration status',
`consumer_id` int(10) unsigned DEFAULT NULL COMMENT 'Oauth consumer',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Creation Time',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Update Time',
`setup_type` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Integration type - manual or config file',
`identity_link_url` varchar(255) DEFAULT NULL COMMENT 'Identity linking Url',
PRIMARY KEY (`integration_id`),
UNIQUE KEY `INTEGRATION_NAME` (`name`),
UNIQUE KEY `INTEGRATION_CONSUMER_ID` (`consumer_id`),
CONSTRAINT `INTEGRATION_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `oauth_consumer` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='integration';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `inventory_low_stock_notification_configuration`
--
DROP TABLE IF EXISTS `inventory_low_stock_notification_configuration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory_low_stock_notification_configuration` (
`source_code` varchar(255) NOT NULL,
`sku` varchar(64) NOT NULL,
`notify_stock_qty` decimal(12,4) DEFAULT NULL,
PRIMARY KEY (`source_code`,`sku`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `inventory_reservation`
--
DROP TABLE IF EXISTS `inventory_reservation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory_reservation` (
`reservation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`stock_id` int(10) unsigned NOT NULL,
`sku` varchar(64) NOT NULL,
`quantity` decimal(10,4) NOT NULL DEFAULT 0.0000,
`metadata` varchar(255) DEFAULT NULL,
PRIMARY KEY (`reservation_id`),
KEY `INVENTORY_RESERVATION_STOCK_ID_SKU_QUANTITY` (`stock_id`,`sku`,`quantity`)
) ENGINE=InnoDB AUTO_INCREMENT=924 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `inventory_shipment_source`
--
DROP TABLE IF EXISTS `inventory_shipment_source`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory_shipment_source` (
`shipment_id` int(10) unsigned NOT NULL,
`source_code` varchar(255) NOT NULL,
PRIMARY KEY (`shipment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `inventory_source_item`
--
DROP TABLE IF EXISTS `inventory_source_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory_source_item` (
`source_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`source_code` varchar(255) NOT NULL,
`sku` varchar(64) NOT NULL,
`quantity` decimal(12,4) NOT NULL DEFAULT 0.0000,
`status` smallint(5) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`source_item_id`),
UNIQUE KEY `INVENTORY_SOURCE_ITEM_SOURCE_CODE_SKU` (`source_code`,`sku`),
KEY `INVENTORY_SOURCE_ITEM_SKU_SOURCE_CODE_QUANTITY` (`sku`,`source_code`,`quantity`),
CONSTRAINT `INVENTORY_SOURCE_ITEM_SOURCE_CODE_INVENTORY_SOURCE_SOURCE_CODE` FOREIGN KEY (`source_code`) REFERENCES `inventory_source` (`source_code`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2173 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `inventory_stock`
--
DROP TABLE IF EXISTS `inventory_stock`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory_stock` (
`stock_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Temporary table structure for view `inventory_stock_1`
--
DROP TABLE IF EXISTS `inventory_stock_1`;
/*!50001 DROP VIEW IF EXISTS `inventory_stock_1`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `inventory_stock_1` AS SELECT
1 AS `product_id`,
1 AS `website_id`,
1 AS `stock_id`,
1 AS `quantity`,
1 AS `is_salable`,
1 AS `sku` */;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `layout_link`
--
DROP TABLE IF EXISTS `layout_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `layout_link` (
`layout_link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`theme_id` int(10) unsigned NOT NULL COMMENT 'Theme ID',
`layout_update_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Layout Update ID',
`is_temporary` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Defines whether Layout Update is Temporary',
PRIMARY KEY (`layout_link_id`),
KEY `LAYOUT_LINK_THEME_ID_THEME_THEME_ID` (`theme_id`),
KEY `LAYOUT_LINK_LAYOUT_UPDATE_ID` (`layout_update_id`),
KEY `LAYOUT_LINK_STORE_ID_THEME_ID_LAYOUT_UPDATE_ID_IS_TEMPORARY` (`store_id`,`theme_id`,`layout_update_id`,`is_temporary`),
CONSTRAINT `LAYOUT_LINK_LAYOUT_UPDATE_ID_LAYOUT_UPDATE_LAYOUT_UPDATE_ID` FOREIGN KEY (`layout_update_id`) REFERENCES `layout_update` (`layout_update_id`) ON DELETE CASCADE,
CONSTRAINT `LAYOUT_LINK_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
CONSTRAINT `LAYOUT_LINK_THEME_ID_THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `theme` (`theme_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Layout Link';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `layout_update`
--
DROP TABLE IF EXISTS `layout_update`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `layout_update` (
`layout_update_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Layout Update ID',
`handle` varchar(255) DEFAULT NULL COMMENT 'Handle',
`xml` text DEFAULT NULL COMMENT 'Xml',
`sort_order` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Sort Order',
`updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp() COMMENT 'Last Update Timestamp',
PRIMARY KEY (`layout_update_id`),
KEY `LAYOUT_UPDATE_HANDLE` (`handle`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Layout Updates';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `magento_operation`
--
DROP TABLE IF EXISTS `magento_operation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `magento_operation` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Operation ID',
`operation_key` int(10) unsigned DEFAULT NULL COMMENT 'Operation Key',
`bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
`topic_name` varchar(255) DEFAULT NULL COMMENT 'Name of the related message queue topic',
`serialized_data` blob DEFAULT NULL COMMENT 'Data (serialized) required to perform an operation',
`result_serialized_data` blob DEFAULT NULL COMMENT 'Result data (serialized) after perform an operation',
`status` smallint(6) DEFAULT 0 COMMENT 'Operation status (OPEN | COMPLETE | RETRIABLY_FAILED | NOT_RETRIABLY_FAILED)',
`error_code` smallint(6) DEFAULT NULL COMMENT 'Code of the error that appeared during operation execution (used to aggregate related failed operations)',
`result_message` varchar(255) DEFAULT NULL COMMENT 'Operation result message',
`started_at` timestamp NULL DEFAULT NULL COMMENT 'Datetime the operation started processing',
PRIMARY KEY (`id`),
KEY `MAGENTO_OPERATION_BULK_UUID_ERROR_CODE` (`bulk_uuid`,`error_code`),
KEY `MAGENTO_OPERATION_STATUS_STARTED_AT` (`status`,`started_at`),
CONSTRAINT `MAGENTO_OPERATION_BULK_UUID_MAGENTO_BULK_UUID` FOREIGN KEY (`bulk_uuid`) REFERENCES `magento_bulk` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Operation entity';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth_token`
--
DROP TABLE IF EXISTS `oauth_token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_token` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`consumer_id` int(10) unsigned DEFAULT NULL COMMENT 'Oauth Consumer ID',
`admin_id` int(10) unsigned DEFAULT NULL COMMENT 'Admin user ID',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer user ID',
`type` varchar(16) NOT NULL COMMENT 'Token Type',
`token` varchar(32) NOT NULL COMMENT 'Token',
`secret` varchar(128) NOT NULL COMMENT 'Token Secret',
`verifier` varchar(32) DEFAULT NULL COMMENT 'Token Verifier',
`callback_url` text NOT NULL COMMENT 'Token Callback URL',
`revoked` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Token revoked',
`authorized` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Token authorized',
`user_type` int(11) DEFAULT NULL COMMENT 'User type',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Token creation timestamp',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `OAUTH_TOKEN_TOKEN` (`token`),
KEY `OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` (`admin_id`),
KEY `OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
KEY `OAUTH_TOKEN_CONSUMER_ID` (`consumer_id`),
KEY `OAUTH_TOKEN_CREATED_AT` (`created_at`),
CONSTRAINT `OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE,
CONSTRAINT `OAUTH_TOKEN_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `oauth_consumer` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='OAuth Tokens';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `patch_list`
--
DROP TABLE IF EXISTS `patch_list`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `patch_list` (
`patch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Patch Auto Increment',
`patch_name` varchar(1024) NOT NULL COMMENT 'Patch Class Name',
PRIMARY KEY (`patch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='List of data/schema patches';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `queue`
--
DROP TABLE IF EXISTS `queue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `queue` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue ID',
`name` varchar(255) DEFAULT NULL COMMENT 'Queue name',
PRIMARY KEY (`id`),
UNIQUE KEY `QUEUE_NAME` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Table storing unique queues';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `quote`
--
DROP TABLE IF EXISTS `quote`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quote` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`converted_at` timestamp NULL DEFAULT NULL COMMENT 'Converted At',
`is_active` smallint(5) unsigned DEFAULT 1 COMMENT 'Is Active',
`is_virtual` smallint(5) unsigned DEFAULT 0 COMMENT 'Is Virtual',
`is_multi_shipping` smallint(5) unsigned DEFAULT 0 COMMENT 'Is Multi Shipping',
`items_count` int(10) unsigned DEFAULT 0 COMMENT 'Items Count',
`items_qty` decimal(12,4) DEFAULT 0.0000 COMMENT 'Items Qty',
`orig_order_id` int(10) unsigned DEFAULT 0 COMMENT 'Orig Order ID',
`store_to_base_rate` decimal(12,4) DEFAULT 0.0000 COMMENT 'Store To Base Rate',
`store_to_quote_rate` decimal(12,4) DEFAULT 0.0000 COMMENT 'Store To Quote Rate',
`base_currency_code` varchar(255) DEFAULT NULL COMMENT 'Base Currency Code',
`store_currency_code` varchar(255) DEFAULT NULL COMMENT 'Store Currency Code',
`quote_currency_code` varchar(255) DEFAULT NULL COMMENT 'Quote Currency Code',
`grand_total` decimal(20,4) DEFAULT 0.0000 COMMENT 'Grand Total',
`base_grand_total` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Grand Total',
`checkout_method` varchar(255) DEFAULT NULL COMMENT 'Checkout Method',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
`customer_tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Tax Class ID',
`customer_group_id` int(10) unsigned DEFAULT 0 COMMENT 'Customer Group ID',
`customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
`customer_prefix` varchar(40) DEFAULT NULL COMMENT 'Customer Prefix',
`customer_firstname` varchar(255) DEFAULT NULL COMMENT 'Customer Firstname',
`customer_middlename` varchar(40) DEFAULT NULL COMMENT 'Customer Middlename',
`customer_lastname` varchar(255) DEFAULT NULL COMMENT 'Customer Lastname',
`customer_suffix` varchar(40) DEFAULT NULL COMMENT 'Customer Suffix',
`customer_dob` datetime DEFAULT NULL COMMENT 'Customer Dob',
`customer_note` text DEFAULT NULL COMMENT 'Customer Note',
`customer_note_notify` smallint(5) unsigned DEFAULT 1 COMMENT 'Customer Note Notify',
`customer_is_guest` smallint(5) unsigned DEFAULT 0 COMMENT 'Customer Is Guest',
`remote_ip` varchar(45) DEFAULT NULL COMMENT 'Remote Ip',
`applied_rule_ids` varchar(255) DEFAULT NULL COMMENT 'Applied Rule Ids',
`reserved_order_id` varchar(64) DEFAULT NULL COMMENT 'Reserved Order ID',
`password_hash` varchar(255) DEFAULT NULL COMMENT 'Password Hash',
`coupon_code` varchar(255) DEFAULT NULL COMMENT 'Coupon Code',
`global_currency_code` varchar(255) DEFAULT NULL COMMENT 'Global Currency Code',
`base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
`base_to_quote_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Quote Rate',
`customer_taxvat` varchar(255) DEFAULT NULL COMMENT 'Customer Taxvat',
`customer_gender` varchar(255) DEFAULT NULL COMMENT 'Customer Gender',
`subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
`base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
`subtotal_with_discount` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal With Discount',
`base_subtotal_with_discount` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal With Discount',
`is_changed` int(10) unsigned DEFAULT NULL COMMENT 'Is Changed',
`trigger_recollect` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Trigger Recollect',
`ext_shipping_info` text DEFAULT NULL COMMENT 'Ext Shipping Info',
`gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
`is_persistent` smallint(5) unsigned DEFAULT 0 COMMENT 'Is Quote Persistent',
PRIMARY KEY (`entity_id`),
KEY `QUOTE_CUSTOMER_ID_STORE_ID_IS_ACTIVE` (`customer_id`,`store_id`,`is_active`),
KEY `QUOTE_STORE_ID` (`store_id`),
CONSTRAINT `QUOTE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Quote';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `quote_address`
--
DROP TABLE IF EXISTS `quote_address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quote_address` (
`address_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address ID',
`quote_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Quote ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
`save_in_address_book` smallint(6) DEFAULT 0 COMMENT 'Save In Address Book',
`customer_address_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Address ID',
`address_type` varchar(10) DEFAULT NULL COMMENT 'Address Type',
`email` varchar(255) DEFAULT NULL COMMENT 'Email',
`prefix` varchar(40) DEFAULT NULL COMMENT 'Prefix',
`firstname` varchar(255) DEFAULT NULL,
`middlename` varchar(40) DEFAULT NULL,
`lastname` varchar(255) DEFAULT NULL,
`suffix` varchar(40) DEFAULT NULL COMMENT 'Suffix',
`company` varchar(255) DEFAULT NULL COMMENT 'Company',
`street` varchar(255) DEFAULT NULL COMMENT 'Street',
`city` varchar(255) DEFAULT NULL,
`region` varchar(255) DEFAULT NULL,
`region_id` int(10) unsigned DEFAULT NULL COMMENT 'Region ID',
`postcode` varchar(20) DEFAULT NULL COMMENT 'Postcode',
`country_id` varchar(30) DEFAULT NULL COMMENT 'Country ID',
`telephone` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`same_as_billing` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Same As Billing',
`collect_shipping_rates` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Collect Shipping Rates',
`shipping_method` varchar(120) DEFAULT NULL,
`shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
`weight` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Weight',
`subtotal` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal',
`base_subtotal` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Subtotal',
`subtotal_with_discount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal With Discount',
`base_subtotal_with_discount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Subtotal With Discount',
`tax_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Tax Amount',
`base_tax_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Tax Amount',
`shipping_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Shipping Amount',
`base_shipping_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Shipping Amount',
`shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
`base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
`discount_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
`base_discount_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Discount Amount',
`grand_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Grand Total',
`base_grand_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Grand Total',
`customer_notes` text DEFAULT NULL COMMENT 'Customer Notes',
`applied_taxes` text DEFAULT NULL COMMENT 'Applied Taxes',
`discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
`shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Amount',
`base_shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Amount',
`subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
`base_subtotal_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Total Incl Tax',
`discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
`base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
`shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
`base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
`shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
`base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
`vat_id` text DEFAULT NULL COMMENT 'Vat ID',
`vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
`vat_request_id` text DEFAULT NULL COMMENT 'Vat Request ID',
`vat_request_date` text DEFAULT NULL COMMENT 'Vat Request Date',
`vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
`validated_country_code` text DEFAULT NULL COMMENT 'Validated Country Code',
`validated_vat_number` text DEFAULT NULL COMMENT 'Validated Vat Number',
`gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
`free_shipping` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Free Shipping',
PRIMARY KEY (`address_id`),
KEY `QUOTE_ADDRESS_QUOTE_ID` (`quote_id`),
CONSTRAINT `QUOTE_ADDRESS_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=943 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Quote Address';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `quote_payment`
--
DROP TABLE IF EXISTS `quote_payment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quote_payment` (
`payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Payment ID',
`quote_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Quote ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`method` varchar(255) DEFAULT NULL COMMENT 'Method',
`cc_type` varchar(255) DEFAULT NULL COMMENT 'Cc Type',
`cc_number_enc` varchar(255) DEFAULT NULL COMMENT 'Cc Number Enc',
`cc_last_4` varchar(255) DEFAULT NULL COMMENT 'Cc Last 4',
`cc_cid_enc` varchar(255) DEFAULT NULL COMMENT 'Cc Cid Enc',
`cc_owner` varchar(255) DEFAULT NULL COMMENT 'Cc Owner',
`cc_exp_month` varchar(255) DEFAULT NULL COMMENT 'Cc Exp Month',
`cc_exp_year` smallint(5) unsigned DEFAULT 0 COMMENT 'Cc Exp Year',
`cc_ss_owner` varchar(255) DEFAULT NULL COMMENT 'Cc Ss Owner',
`cc_ss_start_month` smallint(5) unsigned DEFAULT 0 COMMENT 'Cc Ss Start Month',
`cc_ss_start_year` smallint(5) unsigned DEFAULT 0 COMMENT 'Cc Ss Start Year',
`po_number` varchar(255) DEFAULT NULL COMMENT 'Po Number',
`additional_data` text DEFAULT NULL COMMENT 'Additional Data',
`cc_ss_issue` varchar(255) DEFAULT NULL COMMENT 'Cc Ss Issue',
`additional_information` text DEFAULT NULL COMMENT 'Additional Information',
`paypal_payer_id` varchar(255) DEFAULT NULL COMMENT 'Paypal Payer ID',
`paypal_payer_status` varchar(255) DEFAULT NULL COMMENT 'Paypal Payer Status',
`paypal_correlation_id` varchar(255) DEFAULT NULL COMMENT 'Paypal Correlation ID',
PRIMARY KEY (`payment_id`),
KEY `QUOTE_PAYMENT_QUOTE_ID` (`quote_id`),
CONSTRAINT `QUOTE_PAYMENT_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=311 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Quote Payment';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rating`
--
DROP TABLE IF EXISTS `rating`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rating` (
`rating_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rating ID',
`entity_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`rating_code` varchar(64) NOT NULL COMMENT 'Rating Code',
`position` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating Position On Storefront',
`is_active` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Rating is active.',
PRIMARY KEY (`rating_id`),
UNIQUE KEY `RATING_RATING_CODE` (`rating_code`),
KEY `RATING_ENTITY_ID` (`entity_id`),
CONSTRAINT `RATING_ENTITY_ID_RATING_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `rating_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Ratings';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rating_entity`
--
DROP TABLE IF EXISTS `rating_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rating_entity` (
`entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`entity_code` varchar(64) NOT NULL COMMENT 'Entity Code',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `RATING_ENTITY_ENTITY_CODE` (`entity_code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rating entities';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rating_option`
--
DROP TABLE IF EXISTS `rating_option`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rating_option` (
`option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rating Option ID',
`rating_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating ID',
`code` varchar(32) NOT NULL COMMENT 'Rating Option Code',
`value` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating Option Value',
`position` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Ration option position on Storefront',
PRIMARY KEY (`option_id`),
KEY `RATING_OPTION_RATING_ID` (`rating_id`),
CONSTRAINT `RATING_OPTION_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rating options';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rating_option_vote`
--
DROP TABLE IF EXISTS `rating_option_vote`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rating_option_vote` (
`vote_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Vote ID',
`option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Vote option ID',
`remote_ip` varchar(16) NOT NULL COMMENT 'Customer IP',
`remote_ip_long` bigint(20) NOT NULL DEFAULT 0 COMMENT 'Customer IP converted to long integer format',
`customer_id` int(10) unsigned DEFAULT 0 COMMENT 'Customer ID',
`entity_pk_value` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`rating_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating ID',
`review_id` bigint(20) unsigned DEFAULT NULL COMMENT 'Review ID',
`percent` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Percent amount',
`value` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Vote option value',
PRIMARY KEY (`vote_id`),
KEY `RATING_OPTION_VOTE_REVIEW_ID_REVIEW_REVIEW_ID` (`review_id`),
KEY `RATING_OPTION_VOTE_OPTION_ID` (`option_id`),
CONSTRAINT `RATING_OPTION_VOTE_OPTION_ID_RATING_OPTION_OPTION_ID` FOREIGN KEY (`option_id`) REFERENCES `rating_option` (`option_id`) ON DELETE CASCADE,
CONSTRAINT `RATING_OPTION_VOTE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=354 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rating option values';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rating_option_vote_aggregated`
--
DROP TABLE IF EXISTS `rating_option_vote_aggregated`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rating_option_vote_aggregated` (
`primary_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Vote aggregation ID',
`rating_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating ID',
`entity_pk_value` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`vote_count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Vote dty',
`vote_value_sum` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'General vote sum',
`percent` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Vote percent',
`percent_approved` smallint(6) DEFAULT 0 COMMENT 'Vote percent approved by admin',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
PRIMARY KEY (`primary_id`),
KEY `RATING_OPTION_VOTE_AGGREGATED_RATING_ID` (`rating_id`),
KEY `RATING_OPTION_VOTE_AGGREGATED_STORE_ID` (`store_id`),
CONSTRAINT `RATING_OPTION_VOTE_AGGREGATED_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
CONSTRAINT `RATING_OPTION_VOTE_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rating vote aggregated';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rating_store`
--
DROP TABLE IF EXISTS `rating_store`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rating_store` (
`rating_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating ID',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
PRIMARY KEY (`rating_id`,`store_id`),
KEY `RATING_STORE_STORE_ID` (`store_id`),
CONSTRAINT `RATING_STORE_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
CONSTRAINT `RATING_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rating Store';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `report_event_types`
--
DROP TABLE IF EXISTS `report_event_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `report_event_types` (
`event_type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event Type ID',
`event_name` varchar(64) NOT NULL COMMENT 'Event Name',
`customer_login` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Login',
PRIMARY KEY (`event_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Reports Event Type Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `review`
--
DROP TABLE IF EXISTS `review`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review` (
`review_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Review create date',
`entity_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Entity ID',
`entity_pk_value` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
`status_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Status code',
PRIMARY KEY (`review_id`),
KEY `REVIEW_ENTITY_ID` (`entity_id`),
KEY `REVIEW_STATUS_ID` (`status_id`),
KEY `REVIEW_ENTITY_PK_VALUE` (`entity_pk_value`),
CONSTRAINT `REVIEW_ENTITY_ID_REVIEW_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `review_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `review_status` (`status_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=354 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Review base information';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `review_detail`
--
DROP TABLE IF EXISTS `review_detail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_detail` (
`detail_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review detail ID',
`review_id` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT 'Review ID',
`store_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Store ID',
`title` varchar(255) NOT NULL COMMENT 'Title',
`detail` text NOT NULL COMMENT 'Detail description',
`nickname` varchar(128) NOT NULL COMMENT 'User nickname',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
PRIMARY KEY (`detail_id`),
KEY `REVIEW_DETAIL_REVIEW_ID` (`review_id`),
KEY `REVIEW_DETAIL_STORE_ID` (`store_id`),
KEY `REVIEW_DETAIL_CUSTOMER_ID` (`customer_id`),
CONSTRAINT `REVIEW_DETAIL_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL,
CONSTRAINT `REVIEW_DETAIL_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE,
CONSTRAINT `REVIEW_DETAIL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=354 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Review detail information';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `review_entity`
--
DROP TABLE IF EXISTS `review_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_entity` (
`entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review entity ID',
`entity_code` varchar(32) NOT NULL COMMENT 'Review entity code',
PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Review entities';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `review_entity_summary`
--
DROP TABLE IF EXISTS `review_entity_summary`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_entity_summary` (
`primary_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Summary review entity ID',
`entity_pk_value` bigint(20) NOT NULL DEFAULT 0 COMMENT 'Product ID',
`entity_type` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Entity type ID',
`reviews_count` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Qty of reviews',
`rating_summary` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Summarized rating',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
PRIMARY KEY (`primary_id`),
UNIQUE KEY `REVIEW_ENTITY_SUMMARY_ENTITY_PK_VALUE_STORE_ID_ENTITY_TYPE` (`entity_pk_value`,`store_id`,`entity_type`),
KEY `REVIEW_ENTITY_SUMMARY_STORE_ID` (`store_id`),
CONSTRAINT `REVIEW_ENTITY_SUMMARY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Review aggregates';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `review_status`
--
DROP TABLE IF EXISTS `review_status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_status` (
`status_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Status ID',
`status_code` varchar(32) NOT NULL COMMENT 'Status code',
PRIMARY KEY (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Review statuses';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `review_store`
--
DROP TABLE IF EXISTS `review_store`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_store` (
`review_id` bigint(20) unsigned NOT NULL COMMENT 'Review ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`review_id`,`store_id`),
KEY `REVIEW_STORE_STORE_ID` (`store_id`),
CONSTRAINT `REVIEW_STORE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE,
CONSTRAINT `REVIEW_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Review Store';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_bestsellers_aggregated_daily`
--
DROP TABLE IF EXISTS `sales_bestsellers_aggregated_daily`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_bestsellers_aggregated_daily` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product ID',
`product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
`product_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Product Price',
`qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Ordered',
`rating_pos` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating Pos',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID` (`store_id`),
KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_PRODUCT_ID` (`product_id`),
CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1141 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Bestsellers Aggregated Daily';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_bestsellers_aggregated_monthly`
--
DROP TABLE IF EXISTS `sales_bestsellers_aggregated_monthly`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_bestsellers_aggregated_monthly` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product ID',
`product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
`product_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Product Price',
`qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Ordered',
`rating_pos` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating Pos',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID` (`store_id`),
KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_PRODUCT_ID` (`product_id`),
CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1060 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Bestsellers Aggregated Monthly';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_bestsellers_aggregated_yearly`
--
DROP TABLE IF EXISTS `sales_bestsellers_aggregated_yearly`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_bestsellers_aggregated_yearly` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product ID',
`product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
`product_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Product Price',
`qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Ordered',
`rating_pos` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating Pos',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`),
CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1060 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Bestsellers Aggregated Yearly';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_creditmemo_grid`
--
DROP TABLE IF EXISTS `sales_creditmemo_grid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_creditmemo_grid` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
`updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
`order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
`order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
`order_created_at` timestamp NULL DEFAULT NULL COMMENT 'Order Created At',
`billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
`state` int(11) DEFAULT NULL COMMENT 'Status',
`base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
`order_status` varchar(32) DEFAULT NULL COMMENT 'Order Status',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
`shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
`customer_name` varchar(128) NOT NULL COMMENT 'Customer Name',
`customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
`customer_group_id` smallint(6) DEFAULT NULL COMMENT 'Customer Group ID',
`payment_method` varchar(32) DEFAULT NULL COMMENT 'Payment Method',
`shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
`subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
`shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
`adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
`adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
`order_base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Order Grand Total',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `SALES_CREDITMEMO_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
KEY `SALES_CREDITMEMO_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
KEY `SALES_CREDITMEMO_GRID_CREATED_AT` (`created_at`),
KEY `SALES_CREDITMEMO_GRID_UPDATED_AT` (`updated_at`),
KEY `SALES_CREDITMEMO_GRID_ORDER_CREATED_AT` (`order_created_at`),
KEY `SALES_CREDITMEMO_GRID_STATE` (`state`),
KEY `SALES_CREDITMEMO_GRID_BILLING_NAME` (`billing_name`),
KEY `SALES_CREDITMEMO_GRID_ORDER_STATUS` (`order_status`),
KEY `SALES_CREDITMEMO_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
KEY `SALES_CREDITMEMO_GRID_STORE_ID` (`store_id`),
KEY `SALES_CREDITMEMO_GRID_ORDER_BASE_GRAND_TOTAL` (`order_base_grand_total`),
KEY `SALES_CREDITMEMO_GRID_ORDER_ID` (`order_id`),
FULLTEXT KEY `FTI_32B7BA885941A8254EE84AE650ABDC86` (`increment_id`,`order_increment_id`,`billing_name`,`billing_address`,`shipping_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Creditmemo Grid';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_invoice`
--
DROP TABLE IF EXISTS `sales_invoice`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_invoice` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
`shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
`tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
`base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
`store_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Order Rate',
`base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
`base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
`base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
`grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
`shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
`subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
`base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
`store_to_base_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Base Rate',
`base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
`total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
`base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
`subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
`base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
`discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
`billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
`is_used_for_refund` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Used For Refund',
`order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
`email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
`send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
`can_void_flag` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Void Flag',
`state` int(11) DEFAULT NULL COMMENT 'State',
`shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
`store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
`transaction_id` varchar(255) DEFAULT NULL COMMENT 'Transaction ID',
`order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
`base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
`global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
`base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
`shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
`base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
`shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
`base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
`base_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Refunded',
`discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
`customer_note` text DEFAULT NULL COMMENT 'Customer Note',
`customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `SALES_INVOICE_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
KEY `SALES_INVOICE_STORE_ID` (`store_id`),
KEY `SALES_INVOICE_GRAND_TOTAL` (`grand_total`),
KEY `SALES_INVOICE_ORDER_ID` (`order_id`),
KEY `SALES_INVOICE_STATE` (`state`),
KEY `SALES_INVOICE_CREATED_AT` (`created_at`),
KEY `SALES_INVOICE_UPDATED_AT` (`updated_at`),
KEY `SALES_INVOICE_SEND_EMAIL` (`send_email`),
KEY `SALES_INVOICE_EMAIL_SENT` (`email_sent`),
CONSTRAINT `SALES_INVOICE_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `SALES_INVOICE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Invoice';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_invoice_grid`
--
DROP TABLE IF EXISTS `sales_invoice_grid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_invoice_grid` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`state` int(11) DEFAULT NULL COMMENT 'State',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
`order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
`order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
`order_created_at` timestamp NULL DEFAULT NULL COMMENT 'Order Created At',
`customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer Name',
`customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
`customer_group_id` int(11) DEFAULT NULL,
`payment_method` varchar(128) DEFAULT NULL COMMENT 'Payment Method',
`store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
`order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
`base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
`global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
`billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
`billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
`shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
`shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
`subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
`shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
`grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
`created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
`updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
`base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `SALES_INVOICE_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
KEY `SALES_INVOICE_GRID_STORE_ID` (`store_id`),
KEY `SALES_INVOICE_GRID_GRAND_TOTAL` (`grand_total`),
KEY `SALES_INVOICE_GRID_ORDER_ID` (`order_id`),
KEY `SALES_INVOICE_GRID_STATE` (`state`),
KEY `SALES_INVOICE_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
KEY `SALES_INVOICE_GRID_CREATED_AT` (`created_at`),
KEY `SALES_INVOICE_GRID_UPDATED_AT` (`updated_at`),
KEY `SALES_INVOICE_GRID_ORDER_CREATED_AT` (`order_created_at`),
KEY `SALES_INVOICE_GRID_BILLING_NAME` (`billing_name`),
KEY `SALES_INVOICE_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
FULLTEXT KEY `FTI_95D9C924DD6A8734EB8B5D01D60F90DE` (`increment_id`,`order_increment_id`,`billing_name`,`billing_address`,`shipping_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Invoice Grid';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_invoice_item`
--
DROP TABLE IF EXISTS `sales_invoice_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_invoice_item` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
`base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
`tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Tax Amount',
`base_row_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total',
`discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Amount',
`row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
`base_discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Amount',
`price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Price Incl Tax',
`base_tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Tax Amount',
`base_price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
`qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
`base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
`price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
`base_row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
`row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
`product_id` int(11) DEFAULT NULL COMMENT 'Product ID',
`order_item_id` int(11) DEFAULT NULL COMMENT 'Order Item ID',
`additional_data` text DEFAULT NULL COMMENT 'Additional Data',
`description` text DEFAULT NULL COMMENT 'Description',
`sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
`name` varchar(255) DEFAULT NULL COMMENT 'Name',
`discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
`base_discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
`tax_ratio` text DEFAULT NULL COMMENT 'Ratio of tax invoiced over tax of the order item',
`weee_tax_applied` text DEFAULT NULL COMMENT 'Weee Tax Applied',
`weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Amount',
`weee_tax_applied_row_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Row Amount',
`weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Disposition',
`weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Row Disposition',
`base_weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Amount',
`base_weee_tax_applied_row_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Row Amnt',
`base_weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Disposition',
`base_weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Row Disposition',
PRIMARY KEY (`entity_id`),
KEY `SALES_INVOICE_ITEM_PARENT_ID` (`parent_id`),
CONSTRAINT `SALES_INVOICE_ITEM_PARENT_ID_SALES_INVOICE_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_invoice` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Invoice Item';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_invoiced_aggregated`
--
DROP TABLE IF EXISTS `sales_invoiced_aggregated`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_invoiced_aggregated` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
`orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
`invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
`invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
`invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_INVOICED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
KEY `SALES_INVOICED_AGGREGATED_STORE_ID` (`store_id`),
CONSTRAINT `SALES_INVOICED_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Invoiced Aggregated';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_invoiced_aggregated_order`
--
DROP TABLE IF EXISTS `sales_invoiced_aggregated_order`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_invoiced_aggregated_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_status` varchar(50) NOT NULL COMMENT 'Order Status',
`orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
`invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
`invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
`invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_INVOICED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
KEY `SALES_INVOICED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
CONSTRAINT `SALES_INVOICED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Invoiced Aggregated Order';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order`
--
DROP TABLE IF EXISTS `sales_order`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`state` varchar(32) DEFAULT NULL COMMENT 'State',
`status` varchar(32) DEFAULT NULL COMMENT 'Status',
`coupon_code` varchar(255) DEFAULT NULL COMMENT 'Coupon Code',
`protect_code` varchar(255) DEFAULT NULL COMMENT 'Protect Code',
`shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
`is_virtual` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Virtual',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
`base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
`base_discount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Canceled',
`base_discount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Invoiced',
`base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
`base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
`base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
`base_shipping_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Canceled',
`base_shipping_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Invoiced',
`base_shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Refunded',
`base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
`base_shipping_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Refunded',
`base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
`base_subtotal_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Canceled',
`base_subtotal_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Invoiced',
`base_subtotal_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Refunded',
`base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
`base_tax_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Canceled',
`base_tax_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Invoiced',
`base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
`base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
`base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
`base_total_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Canceled',
`base_total_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Invoiced',
`base_total_invoiced_cost` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Invoiced Cost',
`base_total_offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Offline Refunded',
`base_total_online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Online Refunded',
`base_total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Paid',
`base_total_qty_ordered` decimal(12,4) DEFAULT NULL COMMENT 'Base Total Qty Ordered',
`base_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Refunded',
`discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
`discount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Canceled',
`discount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Invoiced',
`discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
`grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
`shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
`shipping_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Canceled',
`shipping_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Invoiced',
`shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Refunded',
`shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
`shipping_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Refunded',
`store_to_base_rate` decimal(12,4) DEFAULT NULL COMMENT 'Store To Base Rate',
`store_to_order_rate` decimal(12,4) DEFAULT NULL COMMENT 'Store To Order Rate',
`subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
`subtotal_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Canceled',
`subtotal_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Invoiced',
`subtotal_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Refunded',
`tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
`tax_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Tax Canceled',
`tax_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Tax Invoiced',
`tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
`total_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Total Canceled',
`total_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Total Invoiced',
`total_offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Offline Refunded',
`total_online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Online Refunded',
`total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Total Paid',
`total_qty_ordered` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty Ordered',
`total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Refunded',
`can_ship_partially` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Ship Partially',
`can_ship_partially_item` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Ship Partially Item',
`customer_is_guest` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Is Guest',
`customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
`billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
`customer_group_id` int(11) DEFAULT NULL,
`edit_increment` int(11) DEFAULT NULL COMMENT 'Edit Increment',
`email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
`send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
`forced_shipment_with_invoice` smallint(5) unsigned DEFAULT NULL COMMENT 'Forced Do Shipment With Invoice',
`payment_auth_expiration` int(11) DEFAULT NULL COMMENT 'Payment Authorization Expiration',
`quote_address_id` int(11) DEFAULT NULL COMMENT 'Quote Address ID',
`quote_id` int(11) DEFAULT NULL COMMENT 'Quote ID',
`shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
`adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
`adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
`base_adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Negative',
`base_adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Positive',
`base_shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Amount',
`base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
`base_total_due` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Due',
`payment_authorization_amount` decimal(20,4) DEFAULT NULL COMMENT 'Payment Authorization Amount',
`shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Amount',
`subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
`total_due` decimal(20,4) DEFAULT NULL COMMENT 'Total Due',
`weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
`customer_dob` datetime DEFAULT NULL COMMENT 'Customer Dob',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`applied_rule_ids` varchar(128) DEFAULT NULL COMMENT 'Applied Rule Ids',
`base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
`customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
`customer_firstname` varchar(128) DEFAULT NULL COMMENT 'Customer Firstname',
`customer_lastname` varchar(128) DEFAULT NULL COMMENT 'Customer Lastname',
`customer_middlename` varchar(128) DEFAULT NULL COMMENT 'Customer Middlename',
`customer_prefix` varchar(32) DEFAULT NULL COMMENT 'Customer Prefix',
`customer_suffix` varchar(32) DEFAULT NULL COMMENT 'Customer Suffix',
`customer_taxvat` varchar(32) DEFAULT NULL COMMENT 'Customer Taxvat',
`discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
`ext_customer_id` varchar(32) DEFAULT NULL COMMENT 'Ext Customer ID',
`ext_order_id` varchar(32) DEFAULT NULL COMMENT 'Ext Order ID',
`global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
`hold_before_state` varchar(32) DEFAULT NULL COMMENT 'Hold Before State',
`hold_before_status` varchar(32) DEFAULT NULL COMMENT 'Hold Before Status',
`order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
`original_increment_id` varchar(50) DEFAULT NULL COMMENT 'Original Increment ID',
`relation_child_id` varchar(32) DEFAULT NULL COMMENT 'Relation Child ID',
`relation_child_real_id` varchar(32) DEFAULT NULL COMMENT 'Relation Child Real ID',
`relation_parent_id` varchar(32) DEFAULT NULL COMMENT 'Relation Parent ID',
`relation_parent_real_id` varchar(32) DEFAULT NULL COMMENT 'Relation Parent Real ID',
`remote_ip` varchar(45) DEFAULT NULL COMMENT 'Remote Ip',
`shipping_method` varchar(120) DEFAULT NULL,
`store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
`store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
`x_forwarded_for` varchar(255) DEFAULT NULL COMMENT 'X Forwarded For',
`customer_note` text DEFAULT NULL COMMENT 'Customer Note',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`total_item_count` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Total Item Count',
`customer_gender` int(11) DEFAULT NULL COMMENT 'Customer Gender',
`discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
`base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
`shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
`base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
`discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Invoiced',
`base_discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Invoiced',
`discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Refunded',
`base_discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Refunded',
`shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
`base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
`coupon_rule_name` varchar(255) DEFAULT NULL COMMENT 'Coupon Sales Rule Name',
`gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
`paypal_ipn_customer_notified` int(11) DEFAULT 0 COMMENT 'Paypal Ipn Customer Notified',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `SALES_ORDER_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
KEY `SALES_ORDER_STATUS` (`status`),
KEY `SALES_ORDER_STATE` (`state`),
KEY `SALES_ORDER_STORE_ID` (`store_id`),
KEY `SALES_ORDER_CREATED_AT` (`created_at`),
KEY `SALES_ORDER_CUSTOMER_ID` (`customer_id`),
KEY `SALES_ORDER_EXT_ORDER_ID` (`ext_order_id`),
KEY `SALES_ORDER_QUOTE_ID` (`quote_id`),
KEY `SALES_ORDER_UPDATED_AT` (`updated_at`),
KEY `SALES_ORDER_SEND_EMAIL` (`send_email`),
KEY `SALES_ORDER_EMAIL_SENT` (`email_sent`),
CONSTRAINT `SALES_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL,
CONSTRAINT `SALES_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Order';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_address`
--
DROP TABLE IF EXISTS `sales_order_address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_address` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent ID',
`customer_address_id` int(11) DEFAULT NULL COMMENT 'Customer Address ID',
`quote_address_id` int(11) DEFAULT NULL COMMENT 'Quote Address ID',
`region_id` int(11) DEFAULT NULL COMMENT 'Region ID',
`customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
`fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
`region` varchar(255) DEFAULT NULL COMMENT 'Region',
`postcode` varchar(255) DEFAULT NULL COMMENT 'Postcode',
`lastname` varchar(255) DEFAULT NULL COMMENT 'Lastname',
`street` varchar(255) DEFAULT NULL COMMENT 'Street',
`city` varchar(255) DEFAULT NULL COMMENT 'City',
`email` varchar(255) DEFAULT NULL COMMENT 'Email',
`telephone` varchar(255) DEFAULT NULL COMMENT 'Phone Number',
`country_id` varchar(2) DEFAULT NULL COMMENT 'Country ID',
`firstname` varchar(255) DEFAULT NULL COMMENT 'Firstname',
`address_type` varchar(255) DEFAULT NULL COMMENT 'Address Type',
`prefix` varchar(255) DEFAULT NULL COMMENT 'Prefix',
`middlename` varchar(255) DEFAULT NULL COMMENT 'Middlename',
`suffix` varchar(255) DEFAULT NULL COMMENT 'Suffix',
`company` varchar(255) DEFAULT NULL COMMENT 'Company',
`vat_id` text DEFAULT NULL COMMENT 'Vat ID',
`vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
`vat_request_id` text DEFAULT NULL COMMENT 'Vat Request ID',
`vat_request_date` text DEFAULT NULL COMMENT 'Vat Request Date',
`vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
PRIMARY KEY (`entity_id`),
KEY `SALES_ORDER_ADDRESS_PARENT_ID` (`parent_id`),
CONSTRAINT `SALES_ORDER_ADDRESS_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=617 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Order Address';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_aggregated_created`
--
DROP TABLE IF EXISTS `sales_order_aggregated_created`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_aggregated_created` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_status` varchar(50) NOT NULL COMMENT 'Order Status',
`orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`total_qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Qty Ordered',
`total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Qty Invoiced',
`total_income_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Income Amount',
`total_revenue_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Revenue Amount',
`total_profit_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Profit Amount',
`total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Invoiced Amount',
`total_canceled_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Canceled Amount',
`total_paid_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Paid Amount',
`total_refunded_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Refunded Amount',
`total_tax_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Tax Amount',
`total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Tax Amount Actual',
`total_shipping_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Shipping Amount',
`total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Shipping Amount Actual',
`total_discount_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Discount Amount',
`total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Discount Amount Actual',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_ORDER_AGGREGATED_CREATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
KEY `SALES_ORDER_AGGREGATED_CREATED_STORE_ID` (`store_id`),
CONSTRAINT `SALES_ORDER_AGGREGATED_CREATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=814 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Order Aggregated Created';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_aggregated_updated`
--
DROP TABLE IF EXISTS `sales_order_aggregated_updated`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_aggregated_updated` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_status` varchar(50) NOT NULL COMMENT 'Order Status',
`orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`total_qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Qty Ordered',
`total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Qty Invoiced',
`total_income_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Income Amount',
`total_revenue_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Revenue Amount',
`total_profit_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Profit Amount',
`total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Invoiced Amount',
`total_canceled_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Canceled Amount',
`total_paid_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Paid Amount',
`total_refunded_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Refunded Amount',
`total_tax_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Tax Amount',
`total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Tax Amount Actual',
`total_shipping_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Shipping Amount',
`total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Shipping Amount Actual',
`total_discount_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Discount Amount',
`total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Discount Amount Actual',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
KEY `SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
CONSTRAINT `SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Order Aggregated Updated';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_grid`
--
DROP TABLE IF EXISTS `sales_order_grid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_grid` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`status` varchar(32) DEFAULT NULL COMMENT 'Status',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
`base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
`base_total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Paid',
`grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
`total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Total Paid',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
`order_currency_code` varchar(255) DEFAULT NULL COMMENT 'Order Currency Code',
`shipping_name` varchar(255) DEFAULT NULL COMMENT 'Shipping Name',
`billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
`created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
`updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
`billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
`shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
`shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
`customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
`customer_group` varchar(255) DEFAULT NULL COMMENT 'Customer Group',
`subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
`shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
`customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer Name',
`payment_method` varchar(255) DEFAULT NULL COMMENT 'Payment Method',
`total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Refunded',
`pickup_location_code` varchar(255) DEFAULT NULL COMMENT 'Pickup Location Code',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `SALES_ORDER_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
KEY `SALES_ORDER_GRID_STATUS` (`status`),
KEY `SALES_ORDER_GRID_STORE_ID` (`store_id`),
KEY `SALES_ORDER_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
KEY `SALES_ORDER_GRID_BASE_TOTAL_PAID` (`base_total_paid`),
KEY `SALES_ORDER_GRID_GRAND_TOTAL` (`grand_total`),
KEY `SALES_ORDER_GRID_TOTAL_PAID` (`total_paid`),
KEY `SALES_ORDER_GRID_SHIPPING_NAME` (`shipping_name`),
KEY `SALES_ORDER_GRID_BILLING_NAME` (`billing_name`),
KEY `SALES_ORDER_GRID_CREATED_AT` (`created_at`),
KEY `SALES_ORDER_GRID_CUSTOMER_ID` (`customer_id`),
KEY `SALES_ORDER_GRID_UPDATED_AT` (`updated_at`),
KEY `SALES_ORDER_GRID_PICKUP_LOCATION_CODE` (`pickup_location_code`),
FULLTEXT KEY `FTI_65B9E9925EC58F0C7C2E2F6379C233E7` (`increment_id`,`billing_name`,`shipping_name`,`shipping_address`,`billing_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Order Grid';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_item`
--
DROP TABLE IF EXISTS `sales_order_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_item` (
`item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
`order_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Order ID',
`parent_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Item ID',
`quote_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Quote Item ID',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product ID',
`product_type` varchar(255) DEFAULT NULL COMMENT 'Product Type',
`product_options` longtext DEFAULT NULL COMMENT 'Product Options',
`weight` decimal(12,4) DEFAULT 0.0000 COMMENT 'Weight',
`is_virtual` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Virtual',
`sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
`name` varchar(255) DEFAULT NULL COMMENT 'Name',
`description` text DEFAULT NULL COMMENT 'Description',
`applied_rule_ids` text DEFAULT NULL COMMENT 'Applied Rule Ids',
`additional_data` text DEFAULT NULL COMMENT 'Additional Data',
`is_qty_decimal` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
`no_discount` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'No Discount',
`qty_backordered` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Backordered',
`qty_canceled` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Canceled',
`qty_invoiced` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Invoiced',
`qty_ordered` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Ordered',
`qty_refunded` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Refunded',
`qty_shipped` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Shipped',
`base_cost` decimal(12,4) DEFAULT 0.0000 COMMENT 'Base Cost',
`price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Price',
`base_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Price',
`original_price` decimal(12,4) DEFAULT NULL COMMENT 'Original Price',
`base_original_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Original Price',
`tax_percent` decimal(12,4) DEFAULT 0.0000 COMMENT 'Tax Percent',
`tax_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Tax Amount',
`base_tax_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Tax Amount',
`tax_invoiced` decimal(20,4) DEFAULT 0.0000 COMMENT 'Tax Invoiced',
`base_tax_invoiced` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Tax Invoiced',
`discount_percent` decimal(12,4) DEFAULT 0.0000 COMMENT 'Discount Percent',
`discount_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Discount Amount',
`base_discount_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Discount Amount',
`discount_invoiced` decimal(20,4) DEFAULT 0.0000 COMMENT 'Discount Invoiced',
`base_discount_invoiced` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Discount Invoiced',
`amount_refunded` decimal(20,4) DEFAULT 0.0000 COMMENT 'Amount Refunded',
`base_amount_refunded` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Amount Refunded',
`row_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Row Total',
`base_row_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Row Total',
`row_invoiced` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Row Invoiced',
`base_row_invoiced` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Row Invoiced',
`row_weight` decimal(12,4) DEFAULT 0.0000 COMMENT 'Row Weight',
`base_tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Before Discount',
`tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Before Discount',
`ext_order_item_id` varchar(255) DEFAULT NULL COMMENT 'Ext Order Item ID',
`locked_do_invoice` smallint(5) unsigned DEFAULT NULL COMMENT 'Locked Do Invoice',
`locked_do_ship` smallint(5) unsigned DEFAULT NULL COMMENT 'Locked Do Ship',
`price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Price Incl Tax',
`base_price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
`row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
`base_row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
`discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
`base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
`discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Invoiced',
`base_discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Invoiced',
`discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Refunded',
`base_discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Refunded',
`tax_canceled` decimal(12,4) DEFAULT NULL COMMENT 'Tax Canceled',
`discount_tax_compensation_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Canceled',
`tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
`base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
`discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
`base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
`gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
`gift_message_available` int(11) DEFAULT NULL COMMENT 'Gift Message Available',
`free_shipping` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Free Shipping',
`weee_tax_applied` text DEFAULT NULL COMMENT 'Weee Tax Applied',
`weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Amount',
`weee_tax_applied_row_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Row Amount',
`weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Disposition',
`weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Row Disposition',
`base_weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Amount',
`base_weee_tax_applied_row_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Row Amnt',
`base_weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Disposition',
`base_weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Row Disposition',
PRIMARY KEY (`item_id`),
KEY `SALES_ORDER_ITEM_ORDER_ID` (`order_id`),
KEY `SALES_ORDER_ITEM_STORE_ID` (`store_id`),
CONSTRAINT `SALES_ORDER_ITEM_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `SALES_ORDER_ITEM_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=1631 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Order Item';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_payment`
--
DROP TABLE IF EXISTS `sales_order_payment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_payment` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
`base_shipping_captured` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Captured',
`shipping_captured` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Captured',
`amount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Amount Refunded',
`base_amount_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Paid',
`amount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Amount Canceled',
`base_amount_authorized` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Authorized',
`base_amount_paid_online` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Paid Online',
`base_amount_refunded_online` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Refunded Online',
`base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
`shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
`amount_paid` decimal(20,4) DEFAULT NULL COMMENT 'Amount Paid',
`amount_authorized` decimal(20,4) DEFAULT NULL COMMENT 'Amount Authorized',
`base_amount_ordered` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Ordered',
`base_shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Refunded',
`shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Refunded',
`base_amount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Refunded',
`amount_ordered` decimal(20,4) DEFAULT NULL COMMENT 'Amount Ordered',
`base_amount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Canceled',
`quote_payment_id` int(11) DEFAULT NULL COMMENT 'Quote Payment ID',
`additional_data` text DEFAULT NULL COMMENT 'Additional Data',
`cc_exp_month` varchar(12) DEFAULT NULL COMMENT 'Cc Exp Month',
`cc_ss_start_year` varchar(12) DEFAULT NULL COMMENT 'Cc Ss Start Year',
`echeck_bank_name` varchar(128) DEFAULT NULL COMMENT 'Echeck Bank Name',
`method` varchar(128) DEFAULT NULL COMMENT 'Method',
`cc_debug_request_body` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Request Body',
`cc_secure_verify` varchar(32) DEFAULT NULL COMMENT 'Cc Secure Verify',
`protection_eligibility` varchar(32) DEFAULT NULL COMMENT 'Protection Eligibility',
`cc_approval` varchar(32) DEFAULT NULL COMMENT 'Cc Approval',
`cc_last_4` varchar(100) DEFAULT NULL COMMENT 'Cc Last 4',
`cc_status_description` varchar(32) DEFAULT NULL COMMENT 'Cc Status Description',
`echeck_type` varchar(32) DEFAULT NULL COMMENT 'Echeck Type',
`cc_debug_response_serialized` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Response Serialized',
`cc_ss_start_month` varchar(128) DEFAULT NULL COMMENT 'Cc Ss Start Month',
`echeck_account_type` varchar(255) DEFAULT NULL COMMENT 'Echeck Account Type',
`last_trans_id` varchar(255) DEFAULT NULL COMMENT 'Last Trans ID',
`cc_cid_status` varchar(32) DEFAULT NULL COMMENT 'Cc Cid Status',
`cc_owner` varchar(128) DEFAULT NULL COMMENT 'Cc Owner',
`cc_type` varchar(32) DEFAULT NULL COMMENT 'Cc Type',
`po_number` varchar(32) DEFAULT NULL COMMENT 'Po Number',
`cc_exp_year` varchar(4) DEFAULT NULL COMMENT 'Cc Exp Year',
`cc_status` varchar(4) DEFAULT NULL COMMENT 'Cc Status',
`echeck_routing_number` varchar(32) DEFAULT NULL COMMENT 'Echeck Routing Number',
`account_status` varchar(32) DEFAULT NULL COMMENT 'Account Status',
`anet_trans_method` varchar(32) DEFAULT NULL COMMENT 'Anet Trans Method',
`cc_debug_response_body` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Response Body',
`cc_ss_issue` varchar(32) DEFAULT NULL COMMENT 'Cc Ss Issue',
`echeck_account_name` varchar(32) DEFAULT NULL COMMENT 'Echeck Account Name',
`cc_avs_status` varchar(32) DEFAULT NULL COMMENT 'Cc Avs Status',
`cc_number_enc` varchar(128) DEFAULT NULL,
`cc_trans_id` varchar(32) DEFAULT NULL COMMENT 'Cc Trans ID',
`address_status` varchar(32) DEFAULT NULL COMMENT 'Address Status',
`additional_information` text DEFAULT NULL COMMENT 'Additional Information',
PRIMARY KEY (`entity_id`),
KEY `SALES_ORDER_PAYMENT_PARENT_ID` (`parent_id`),
CONSTRAINT `SALES_ORDER_PAYMENT_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Order Payment';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_status`
--
DROP TABLE IF EXISTS `sales_order_status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_status` (
`status` varchar(32) NOT NULL COMMENT 'Status',
`label` varchar(128) NOT NULL COMMENT 'Label',
PRIMARY KEY (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Order Status Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_status_state`
--
DROP TABLE IF EXISTS `sales_order_status_state`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_status_state` (
`status` varchar(32) NOT NULL COMMENT 'Status',
`state` varchar(32) NOT NULL COMMENT 'Label',
`is_default` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Default',
`visible_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Visible on front',
PRIMARY KEY (`status`,`state`),
CONSTRAINT `SALES_ORDER_STATUS_STATE_STATUS_SALES_ORDER_STATUS_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Order Status Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_tax`
--
DROP TABLE IF EXISTS `sales_order_tax`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_tax` (
`tax_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax ID',
`order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
`code` varchar(255) DEFAULT NULL COMMENT 'Code',
`title` varchar(255) DEFAULT NULL COMMENT 'Title',
`percent` decimal(12,4) DEFAULT NULL COMMENT 'Percent',
`amount` decimal(20,4) DEFAULT NULL COMMENT 'Amount',
`priority` int(11) NOT NULL COMMENT 'Priority',
`position` int(11) NOT NULL COMMENT 'Position',
`base_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount',
`process` smallint(6) NOT NULL COMMENT 'Process',
`base_real_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Real Amount',
PRIMARY KEY (`tax_id`),
KEY `SALES_ORDER_TAX_ORDER_ID_PRIORITY_POSITION` (`order_id`,`priority`,`position`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Order Tax Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_order_tax_item`
--
DROP TABLE IF EXISTS `sales_order_tax_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_order_tax_item` (
`tax_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax Item ID',
`tax_id` int(10) unsigned NOT NULL COMMENT 'Tax ID',
`item_id` int(10) unsigned DEFAULT NULL COMMENT 'Item ID',
`tax_percent` decimal(12,4) NOT NULL COMMENT 'Real Tax Percent For Item',
`amount` decimal(20,4) NOT NULL COMMENT 'Tax amount for the item and tax rate',
`base_amount` decimal(20,4) NOT NULL COMMENT 'Base tax amount for the item and tax rate',
`real_amount` decimal(20,4) NOT NULL COMMENT 'Real tax amount for the item and tax rate',
`real_base_amount` decimal(20,4) NOT NULL COMMENT 'Real base tax amount for the item and tax rate',
`associated_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Id of the associated item',
`taxable_item_type` varchar(32) NOT NULL COMMENT 'Type of the taxable item',
PRIMARY KEY (`tax_item_id`),
UNIQUE KEY `SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID` (`tax_id`,`item_id`),
KEY `SALES_ORDER_TAX_ITEM_ASSOCIATED_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` (`associated_item_id`),
KEY `SALES_ORDER_TAX_ITEM_ITEM_ID` (`item_id`),
CONSTRAINT `SALES_ORDER_TAX_ITEM_ASSOCIATED_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` FOREIGN KEY (`associated_item_id`) REFERENCES `sales_order_item` (`item_id`) ON DELETE CASCADE,
CONSTRAINT `SALES_ORDER_TAX_ITEM_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `sales_order_item` (`item_id`) ON DELETE CASCADE,
CONSTRAINT `SALES_ORDER_TAX_ITEM_TAX_ID_SALES_ORDER_TAX_TAX_ID` FOREIGN KEY (`tax_id`) REFERENCES `sales_order_tax` (`tax_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Order Tax Item';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_refunded_aggregated`
--
DROP TABLE IF EXISTS `sales_refunded_aggregated`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_refunded_aggregated` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_status` varchar(50) NOT NULL COMMENT 'Order Status',
`orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
`online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
`offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_REFUNDED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
KEY `SALES_REFUNDED_AGGREGATED_STORE_ID` (`store_id`),
CONSTRAINT `SALES_REFUNDED_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Refunded Aggregated';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_refunded_aggregated_order`
--
DROP TABLE IF EXISTS `sales_refunded_aggregated_order`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_refunded_aggregated_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
`orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
`online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
`offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_REFUNDED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
KEY `SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
CONSTRAINT `SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Refunded Aggregated Order';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_sequence_meta`
--
DROP TABLE IF EXISTS `sales_sequence_meta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_sequence_meta` (
`meta_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`entity_type` varchar(32) NOT NULL COMMENT 'Prefix',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
`sequence_table` varchar(64) NOT NULL COMMENT 'table for sequence',
PRIMARY KEY (`meta_id`),
UNIQUE KEY `SALES_SEQUENCE_META_ENTITY_TYPE_STORE_ID` (`entity_type`,`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='sales_sequence_meta';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_sequence_profile`
--
DROP TABLE IF EXISTS `sales_sequence_profile`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_sequence_profile` (
`profile_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`meta_id` int(10) unsigned NOT NULL COMMENT 'Meta_id',
`prefix` varchar(32) DEFAULT NULL COMMENT 'Prefix',
`suffix` varchar(32) DEFAULT NULL COMMENT 'Suffix',
`start_value` int(10) unsigned NOT NULL DEFAULT 1 COMMENT 'Start value for sequence',
`step` int(10) unsigned NOT NULL DEFAULT 1 COMMENT 'Step for sequence',
`max_value` int(10) unsigned NOT NULL COMMENT 'MaxValue for sequence',
`warning_value` int(10) unsigned NOT NULL COMMENT 'WarningValue for sequence',
`is_active` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'isActive flag',
PRIMARY KEY (`profile_id`),
UNIQUE KEY `SALES_SEQUENCE_PROFILE_META_ID_PREFIX_SUFFIX` (`meta_id`,`prefix`,`suffix`),
CONSTRAINT `SALES_SEQUENCE_PROFILE_META_ID_SALES_SEQUENCE_META_META_ID` FOREIGN KEY (`meta_id`) REFERENCES `sales_sequence_meta` (`meta_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='sales_sequence_profile';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_shipment`
--
DROP TABLE IF EXISTS `sales_shipment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_shipment` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`total_weight` decimal(12,4) DEFAULT NULL COMMENT 'Total Weight',
`total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
`email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
`send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
`order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
`customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
`shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
`billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
`shipment_status` int(11) DEFAULT NULL COMMENT 'Shipment Status',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`packages` text DEFAULT NULL COMMENT 'Packed Products in Packages',
`shipping_label` mediumblob DEFAULT NULL COMMENT 'Shipping Label Content',
`customer_note` text DEFAULT NULL COMMENT 'Customer Note',
`customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `SALES_SHIPMENT_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
KEY `SALES_SHIPMENT_STORE_ID` (`store_id`),
KEY `SALES_SHIPMENT_TOTAL_QTY` (`total_qty`),
KEY `SALES_SHIPMENT_ORDER_ID` (`order_id`),
KEY `SALES_SHIPMENT_CREATED_AT` (`created_at`),
KEY `SALES_SHIPMENT_UPDATED_AT` (`updated_at`),
KEY `SALES_SHIPMENT_SEND_EMAIL` (`send_email`),
KEY `SALES_SHIPMENT_EMAIL_SENT` (`email_sent`),
CONSTRAINT `SALES_SHIPMENT_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `SALES_SHIPMENT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Shipment';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_shipment_comment`
--
DROP TABLE IF EXISTS `sales_shipment_comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_shipment_comment` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
`is_customer_notified` int(11) DEFAULT NULL COMMENT 'Is Customer Notified',
`is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible On Front',
`comment` text DEFAULT NULL COMMENT 'Comment',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
PRIMARY KEY (`entity_id`),
KEY `SALES_SHIPMENT_COMMENT_CREATED_AT` (`created_at`),
KEY `SALES_SHIPMENT_COMMENT_PARENT_ID` (`parent_id`),
CONSTRAINT `SALES_SHIPMENT_COMMENT_PARENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Shipment Comment';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_shipment_grid`
--
DROP TABLE IF EXISTS `sales_shipment_grid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_shipment_grid` (
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_increment_id` varchar(32) NOT NULL COMMENT 'Order Increment ID',
`order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
`order_created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Order Increment ID',
`customer_name` varchar(128) NOT NULL COMMENT 'Customer Name',
`total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
`shipment_status` int(11) DEFAULT NULL COMMENT 'Shipment Status',
`order_status` varchar(32) DEFAULT NULL COMMENT 'Order',
`billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
`shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
`billing_name` varchar(128) DEFAULT NULL COMMENT 'Billing Name',
`shipping_name` varchar(128) DEFAULT NULL COMMENT 'Shipping Name',
`customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
`customer_group_id` int(11) DEFAULT NULL,
`payment_method` varchar(32) DEFAULT NULL COMMENT 'Payment Method',
`shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
`created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
`updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
PRIMARY KEY (`entity_id`),
UNIQUE KEY `SALES_SHIPMENT_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
KEY `SALES_SHIPMENT_GRID_STORE_ID` (`store_id`),
KEY `SALES_SHIPMENT_GRID_TOTAL_QTY` (`total_qty`),
KEY `SALES_SHIPMENT_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
KEY `SALES_SHIPMENT_GRID_SHIPMENT_STATUS` (`shipment_status`),
KEY `SALES_SHIPMENT_GRID_ORDER_STATUS` (`order_status`),
KEY `SALES_SHIPMENT_GRID_CREATED_AT` (`created_at`),
KEY `SALES_SHIPMENT_GRID_UPDATED_AT` (`updated_at`),
KEY `SALES_SHIPMENT_GRID_ORDER_CREATED_AT` (`order_created_at`),
KEY `SALES_SHIPMENT_GRID_SHIPPING_NAME` (`shipping_name`),
KEY `SALES_SHIPMENT_GRID_BILLING_NAME` (`billing_name`),
KEY `SALES_SHIPMENT_GRID_ORDER_ID` (`order_id`),
FULLTEXT KEY `FTI_086B40C8955F167B8EA76653437879B4` (`increment_id`,`order_increment_id`,`shipping_name`,`customer_name`,`customer_email`,`billing_address`,`shipping_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Shipment Grid';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_shipment_item`
--
DROP TABLE IF EXISTS `sales_shipment_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_shipment_item` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
`row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
`price` decimal(20,4) DEFAULT NULL COMMENT 'Price',
`weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
`qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
`product_id` int(11) DEFAULT NULL COMMENT 'Product ID',
`order_item_id` int(11) DEFAULT NULL COMMENT 'Order Item ID',
`additional_data` text DEFAULT NULL COMMENT 'Additional Data',
`description` text DEFAULT NULL COMMENT 'Description',
`name` varchar(255) DEFAULT NULL COMMENT 'Name',
`sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
PRIMARY KEY (`entity_id`),
KEY `SALES_SHIPMENT_ITEM_PARENT_ID` (`parent_id`),
CONSTRAINT `SALES_SHIPMENT_ITEM_PARENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Flat Shipment Item';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_shipping_aggregated`
--
DROP TABLE IF EXISTS `sales_shipping_aggregated`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_shipping_aggregated` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
`shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
`orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
`total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
PRIMARY KEY (`id`),
UNIQUE KEY `SALES_SHPP_AGGRED_PERIOD_STORE_ID_ORDER_STS_SHPP_DESCRIPTION` (`period`,`store_id`,`order_status`,`shipping_description`),
KEY `SALES_SHIPPING_AGGREGATED_STORE_ID` (`store_id`),
CONSTRAINT `SALES_SHIPPING_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Shipping Aggregated';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sales_shipping_aggregated_order`
--
DROP TABLE IF EXISTS `sales_shipping_aggregated_order`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_shipping_aggregated_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
`shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
`orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
`total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
PRIMARY KEY (`id`),
UNIQUE KEY `UNQ_C05FAE47282EEA68654D0924E946761F` (`period`,`store_id`,`order_status`,`shipping_description`),
KEY `SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID` (`store_id`),
CONSTRAINT `SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=780 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Shipping Aggregated Order';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `salesrule`
--
DROP TABLE IF EXISTS `salesrule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salesrule` (
`rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`name` varchar(255) DEFAULT NULL COMMENT 'Name',
`description` text DEFAULT NULL COMMENT 'Description',
`from_date` date DEFAULT NULL COMMENT 'From',
`to_date` date DEFAULT NULL COMMENT 'To',
`uses_per_customer` int(11) NOT NULL DEFAULT 0 COMMENT 'Uses Per Customer',
`is_active` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Active',
`conditions_serialized` mediumtext DEFAULT NULL COMMENT 'Conditions Serialized',
`actions_serialized` mediumtext DEFAULT NULL COMMENT 'Actions Serialized',
`stop_rules_processing` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Stop Rules Processing',
`is_advanced` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Advanced',
`product_ids` text DEFAULT NULL COMMENT 'Product Ids',
`sort_order` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
`simple_action` varchar(32) DEFAULT NULL COMMENT 'Simple Action',
`discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
`discount_qty` decimal(12,4) DEFAULT NULL COMMENT 'Discount Qty',
`discount_step` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Discount Step',
`apply_to_shipping` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Apply To Shipping',
`times_used` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Times Used',
`is_rss` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Rss',
`coupon_type` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Coupon Type',
`use_auto_generation` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Use Auto Generation',
`uses_per_coupon` int(11) NOT NULL DEFAULT 0 COMMENT 'User Per Coupon',
`simple_free_shipping` smallint(5) unsigned DEFAULT NULL COMMENT 'Simple Free Shipping',
PRIMARY KEY (`rule_id`),
KEY `SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Salesrule';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `salesrule_customer`
--
DROP TABLE IF EXISTS `salesrule_customer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salesrule_customer` (
`rule_customer_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Customer ID',
`rule_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Rule ID',
`customer_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer ID',
`times_used` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Times Used',
PRIMARY KEY (`rule_customer_id`),
KEY `SALESRULE_CUSTOMER_RULE_ID_CUSTOMER_ID` (`rule_id`,`customer_id`),
KEY `SALESRULE_CUSTOMER_CUSTOMER_ID_RULE_ID` (`customer_id`,`rule_id`),
CONSTRAINT `SALESRULE_CUSTOMER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `SALESRULE_CUSTOMER_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Salesrule Customer';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `salesrule_customer_group`
--
DROP TABLE IF EXISTS `salesrule_customer_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salesrule_customer_group` (
`rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
`customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
PRIMARY KEY (`rule_id`,`customer_group_id`),
KEY `SALESRULE_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
CONSTRAINT `SALESRULE_CSTR_GROUP_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
CONSTRAINT `SALESRULE_CUSTOMER_GROUP_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Rules To Customer Groups Relations';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `salesrule_product_attribute`
--
DROP TABLE IF EXISTS `salesrule_product_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salesrule_product_attribute` (
`rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
`customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
`attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
PRIMARY KEY (`rule_id`,`website_id`,`customer_group_id`,`attribute_id`),
KEY `SALESRULE_PRODUCT_ATTRIBUTE_WEBSITE_ID` (`website_id`),
KEY `SALESRULE_PRODUCT_ATTRIBUTE_CUSTOMER_GROUP_ID` (`customer_group_id`),
KEY `SALESRULE_PRODUCT_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
CONSTRAINT `SALESRULE_PRD_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
CONSTRAINT `SALESRULE_PRD_ATTR_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
CONSTRAINT `SALESRULE_PRODUCT_ATTRIBUTE_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
CONSTRAINT `SALESRULE_PRODUCT_ATTRIBUTE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Salesrule Product Attribute';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `salesrule_website`
--
DROP TABLE IF EXISTS `salesrule_website`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salesrule_website` (
`rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
PRIMARY KEY (`rule_id`,`website_id`),
KEY `SALESRULE_WEBSITE_WEBSITE_ID` (`website_id`),
CONSTRAINT `SALESRULE_WEBSITE_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
CONSTRAINT `SALESRULE_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Sales Rules To Websites Relations';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `search_query`
--
DROP TABLE IF EXISTS `search_query`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `search_query` (
`query_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Query ID',
`query_text` varchar(255) DEFAULT NULL COMMENT 'Query text',
`num_results` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Num results',
`popularity` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Popularity',
`redirect` varchar(255) DEFAULT NULL COMMENT 'Redirect',
`store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
`display_in_terms` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Display in terms',
`is_active` smallint(6) DEFAULT 1 COMMENT 'Active status',
`is_processed` smallint(6) DEFAULT 0 COMMENT 'Processed status',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated at',
PRIMARY KEY (`query_id`),
UNIQUE KEY `SEARCH_QUERY_QUERY_TEXT_STORE_ID` (`query_text`,`store_id`),
KEY `SEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`,`store_id`,`popularity`),
KEY `SEARCH_QUERY_STORE_ID` (`store_id`),
KEY `SEARCH_QUERY_IS_PROCESSED` (`is_processed`),
KEY `SEARCH_QUERY_STORE_ID_POPULARITY` (`store_id`,`popularity`),
CONSTRAINT `SEARCH_QUERY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Search query table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sequence_invoice_1`
--
DROP TABLE IF EXISTS `sequence_invoice_1`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sequence_invoice_1` (
`sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sequence_order_1`
--
DROP TABLE IF EXISTS `sequence_order_1`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sequence_order_1` (
`sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sequence_shipment_1`
--
DROP TABLE IF EXISTS `sequence_shipment_1`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sequence_shipment_1` (
`sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `setup_module`
--
DROP TABLE IF EXISTS `setup_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `setup_module` (
`module` varchar(50) NOT NULL COMMENT 'Module',
`schema_version` varchar(50) DEFAULT NULL COMMENT 'Schema Version',
`data_version` varchar(50) DEFAULT NULL COMMENT 'Data Version',
PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Module versions registry';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `shipping_tablerate`
--
DROP TABLE IF EXISTS `shipping_tablerate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shipping_tablerate` (
`pk` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',
`website_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Website ID',
`dest_country_id` varchar(4) NOT NULL DEFAULT '0' COMMENT 'Destination coutry ISO/2 or ISO/3 code',
`dest_region_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Destination Region ID',
`dest_zip` varchar(10) NOT NULL DEFAULT '*' COMMENT 'Destination Post Code (Zip)',
`condition_name` varchar(30) NOT NULL COMMENT 'Rate Condition name',
`condition_value` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Rate condition value',
`price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Price',
`cost` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Cost',
PRIMARY KEY (`pk`),
UNIQUE KEY `UNQ_D60821CDB2AFACEE1566CFC02D0D4CAA` (`website_id`,`dest_country_id`,`dest_region_id`,`dest_zip`,`condition_name`,`condition_value`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Shipping Tablerate';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `store`
--
DROP TABLE IF EXISTS `store`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `store` (
`store_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Store ID',
`code` varchar(32) DEFAULT NULL COMMENT 'Code',
`website_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Website ID',
`group_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Group ID',
`name` varchar(255) NOT NULL COMMENT 'Store Name',
`sort_order` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store Sort Order',
`is_active` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store Activity',
PRIMARY KEY (`store_id`),
UNIQUE KEY `STORE_CODE` (`code`),
KEY `STORE_WEBSITE_ID` (`website_id`),
KEY `STORE_IS_ACTIVE_SORT_ORDER` (`is_active`,`sort_order`),
KEY `STORE_GROUP_ID` (`group_id`),
CONSTRAINT `STORE_GROUP_ID_STORE_GROUP_GROUP_ID` FOREIGN KEY (`group_id`) REFERENCES `store_group` (`group_id`) ON DELETE CASCADE,
CONSTRAINT `STORE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Stores';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `store_group`
--
DROP TABLE IF EXISTS `store_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `store_group` (
`group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Group ID',
`website_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Website ID',
`name` varchar(255) NOT NULL COMMENT 'Store Group Name',
`root_category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Root Category ID',
`default_store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Default Store ID',
`code` varchar(32) DEFAULT NULL COMMENT 'Store group unique code',
PRIMARY KEY (`group_id`),
UNIQUE KEY `STORE_GROUP_CODE` (`code`),
KEY `STORE_GROUP_WEBSITE_ID` (`website_id`),
KEY `STORE_GROUP_DEFAULT_STORE_ID` (`default_store_id`),
CONSTRAINT `STORE_GROUP_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Store Groups';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `store_website`
--
DROP TABLE IF EXISTS `store_website`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `store_website` (
`website_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Website ID',
`code` varchar(32) DEFAULT NULL COMMENT 'Code',
`name` varchar(64) DEFAULT NULL COMMENT 'Website Name',
`sort_order` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
`default_group_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Default Group ID',
`is_default` smallint(5) unsigned DEFAULT 0 COMMENT 'Defines Is Website Default',
PRIMARY KEY (`website_id`),
UNIQUE KEY `STORE_WEBSITE_CODE` (`code`),
KEY `STORE_WEBSITE_SORT_ORDER` (`sort_order`),
KEY `STORE_WEBSITE_DEFAULT_GROUP_ID` (`default_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Websites';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tax_calculation_rate`
--
DROP TABLE IF EXISTS `tax_calculation_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tax_calculation_rate` (
`tax_calculation_rate_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation Rate ID',
`tax_country_id` varchar(2) NOT NULL COMMENT 'Tax Country ID',
`tax_region_id` int(11) NOT NULL COMMENT 'Tax Region ID',
`tax_postcode` varchar(21) DEFAULT NULL COMMENT 'Tax Postcode',
`code` varchar(255) NOT NULL COMMENT 'Code',
`rate` decimal(12,4) NOT NULL COMMENT 'Rate',
`zip_is_range` smallint(6) DEFAULT NULL COMMENT 'Zip Is Range',
`zip_from` int(10) unsigned DEFAULT NULL COMMENT 'Zip From',
`zip_to` int(10) unsigned DEFAULT NULL COMMENT 'Zip To',
PRIMARY KEY (`tax_calculation_rate_id`),
KEY `TAX_CALCULATION_RATE_TAX_COUNTRY_ID_TAX_REGION_ID_TAX_POSTCODE` (`tax_country_id`,`tax_region_id`,`tax_postcode`),
KEY `TAX_CALCULATION_RATE_CODE` (`code`),
KEY `IDX_CA799F1E2CB843495F601E56C84A626D` (`tax_calculation_rate_id`,`tax_country_id`,`tax_region_id`,`zip_is_range`,`tax_postcode`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Tax Calculation Rate';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tax_class`
--
DROP TABLE IF EXISTS `tax_class`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tax_class` (
`class_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Class ID',
`class_name` varchar(255) NOT NULL COMMENT 'Class Name',
`class_type` varchar(8) NOT NULL DEFAULT 'CUSTOMER' COMMENT 'Class Type',
PRIMARY KEY (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Tax Class';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tax_order_aggregated_created`
--
DROP TABLE IF EXISTS `tax_order_aggregated_created`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tax_order_aggregated_created` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`code` varchar(255) NOT NULL COMMENT 'Code',
`order_status` varchar(50) NOT NULL COMMENT 'Order Status',
`percent` float DEFAULT NULL COMMENT 'Percent',
`orders_count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`tax_base_amount_sum` float DEFAULT NULL COMMENT 'Tax Base Amount Sum',
PRIMARY KEY (`id`),
UNIQUE KEY `TAX_ORDER_AGGRED_CREATED_PERIOD_STORE_ID_CODE_PERCENT_ORDER_STS` (`period`,`store_id`,`code`,`percent`,`order_status`),
KEY `TAX_ORDER_AGGREGATED_CREATED_STORE_ID` (`store_id`),
CONSTRAINT `TAX_ORDER_AGGREGATED_CREATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Tax Order Aggregation';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tax_order_aggregated_updated`
--
DROP TABLE IF EXISTS `tax_order_aggregated_updated`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tax_order_aggregated_updated` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
`code` varchar(255) NOT NULL COMMENT 'Code',
`order_status` varchar(50) NOT NULL COMMENT 'Order Status',
`percent` float DEFAULT NULL COMMENT 'Percent',
`orders_count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Orders Count',
`tax_base_amount_sum` float DEFAULT NULL COMMENT 'Tax Base Amount Sum',
PRIMARY KEY (`id`),
UNIQUE KEY `TAX_ORDER_AGGRED_UPDATED_PERIOD_STORE_ID_CODE_PERCENT_ORDER_STS` (`period`,`store_id`,`code`,`percent`,`order_status`),
KEY `TAX_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
CONSTRAINT `TAX_ORDER_AGGREGATED_UPDATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Tax Order Aggregated Updated';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `theme`
--
DROP TABLE IF EXISTS `theme`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `theme` (
`theme_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Theme identifier',
`parent_id` int(11) DEFAULT NULL COMMENT 'Parent ID',
`theme_path` varchar(255) DEFAULT NULL COMMENT 'Theme Path',
`theme_title` varchar(255) NOT NULL COMMENT 'Theme Title',
`preview_image` varchar(255) DEFAULT NULL COMMENT 'Preview Image',
`is_featured` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is Theme Featured',
`area` varchar(255) NOT NULL COMMENT 'Theme Area',
`type` smallint(6) NOT NULL COMMENT 'Theme type: 0:physical, 1:virtual, 2:staging',
`code` text DEFAULT NULL COMMENT 'Full theme code, including package',
PRIMARY KEY (`theme_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Core theme';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ui_bookmark`
--
DROP TABLE IF EXISTS `ui_bookmark`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ui_bookmark` (
`bookmark_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Bookmark identifier',
`user_id` int(10) unsigned NOT NULL COMMENT 'User ID',
`namespace` varchar(255) NOT NULL COMMENT 'Bookmark namespace',
`identifier` varchar(255) NOT NULL COMMENT 'Bookmark Identifier',
`current` smallint(6) NOT NULL COMMENT 'Mark current bookmark per user and identifier',
`title` varchar(255) DEFAULT NULL COMMENT 'Bookmark title',
`config` longtext DEFAULT NULL COMMENT 'Bookmark config',
`created_at` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'Bookmark created at',
`updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Bookmark updated at',
PRIMARY KEY (`bookmark_id`),
KEY `UI_BOOKMARK_USER_ID_NAMESPACE_IDENTIFIER` (`user_id`,`namespace`,`identifier`),
CONSTRAINT `UI_BOOKMARK_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Bookmark';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `url_rewrite`
--
DROP TABLE IF EXISTS `url_rewrite`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `url_rewrite` (
`url_rewrite_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rewrite ID',
`entity_type` varchar(32) NOT NULL COMMENT 'Entity type code',
`entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
`request_path` varchar(255) DEFAULT NULL COMMENT 'Request Path',
`target_path` varchar(255) DEFAULT NULL COMMENT 'Target Path',
`redirect_type` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Redirect Type',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
`description` varchar(255) DEFAULT NULL COMMENT 'Description',
`is_autogenerated` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is rewrite generated automatically flag',
`metadata` varchar(255) DEFAULT NULL COMMENT 'Meta data for url rewrite',
PRIMARY KEY (`url_rewrite_id`),
UNIQUE KEY `URL_REWRITE_REQUEST_PATH_STORE_ID` (`request_path`,`store_id`),
KEY `URL_REWRITE_TARGET_PATH` (`target_path`),
KEY `URL_REWRITE_STORE_ID_ENTITY_ID` (`store_id`,`entity_id`),
KEY `URL_REWRITE_ENTITY_ID` (`entity_id`),
KEY `URL_REWRITE_IS_AUTOGENERATED_METADATA` (`is_autogenerated`,`metadata`)
) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Url Rewrites';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `widget_instance`
--
DROP TABLE IF EXISTS `widget_instance`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `widget_instance` (
`instance_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Instance ID',
`instance_type` varchar(255) DEFAULT NULL COMMENT 'Instance Type',
`theme_id` int(10) unsigned NOT NULL COMMENT 'Theme ID',
`title` varchar(255) DEFAULT NULL COMMENT 'Widget Title',
`store_ids` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Store ids',
`widget_parameters` text DEFAULT NULL COMMENT 'Widget parameters',
`sort_order` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort order',
PRIMARY KEY (`instance_id`),
KEY `WIDGET_INSTANCE_THEME_ID_THEME_THEME_ID` (`theme_id`),
CONSTRAINT `WIDGET_INSTANCE_THEME_ID_THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `theme` (`theme_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Instances of Widget for Package Theme';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `widget_instance_page`
--
DROP TABLE IF EXISTS `widget_instance_page`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `widget_instance_page` (
`page_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Page ID',
`instance_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Instance ID',
`page_group` varchar(25) DEFAULT NULL COMMENT 'Block Group Type',
`layout_handle` varchar(255) DEFAULT NULL COMMENT 'Layout Handle',
`block_reference` varchar(255) DEFAULT NULL COMMENT 'Container',
`page_for` varchar(25) DEFAULT NULL COMMENT 'For instance entities',
`entities` text DEFAULT NULL COMMENT 'Catalog entities (comma separated)',
`page_template` varchar(255) DEFAULT NULL COMMENT 'Path to widget template',
PRIMARY KEY (`page_id`),
KEY `WIDGET_INSTANCE_PAGE_INSTANCE_ID` (`instance_id`),
CONSTRAINT `WIDGET_INSTANCE_PAGE_INSTANCE_ID_WIDGET_INSTANCE_INSTANCE_ID` FOREIGN KEY (`instance_id`) REFERENCES `widget_instance` (`instance_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Instance of Widget on Page';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `widget_instance_page_layout`
--
DROP TABLE IF EXISTS `widget_instance_page_layout`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `widget_instance_page_layout` (
`page_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Page ID',
`layout_update_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Layout Update ID',
PRIMARY KEY (`layout_update_id`,`page_id`),
KEY `WIDGET_INSTANCE_PAGE_LAYOUT_PAGE_ID` (`page_id`),
CONSTRAINT `WIDGET_INSTANCE_PAGE_LAYOUT_PAGE_ID_WIDGET_INSTANCE_PAGE_PAGE_ID` FOREIGN KEY (`page_id`) REFERENCES `widget_instance_page` (`page_id`) ON DELETE CASCADE,
CONSTRAINT `WIDGET_INSTANCE_PAGE_LYT_LYT_UPDATE_ID_LYT_UPDATE_LYT_UPDATE_ID` FOREIGN KEY (`layout_update_id`) REFERENCES `layout_update` (`layout_update_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Layout updates';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wishlist`
--
DROP TABLE IF EXISTS `wishlist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wishlist` (
`wishlist_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Wishlist ID',
`customer_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer ID',
`shared` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Sharing flag (0 or 1)',
`sharing_code` varchar(32) DEFAULT NULL COMMENT 'Sharing encrypted code',
`updated_at` timestamp NULL DEFAULT NULL COMMENT 'Last updated date',
PRIMARY KEY (`wishlist_id`),
UNIQUE KEY `WISHLIST_CUSTOMER_ID` (`customer_id`),
KEY `WISHLIST_SHARED` (`shared`),
CONSTRAINT `WISHLIST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Wishlist main Table';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Final view structure for view `inventory_stock_1`
--
/*!50001 DROP VIEW IF EXISTS `inventory_stock_1`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb3 */;
/*!50001 SET character_set_results = utf8mb3 */;
/*!50001 SET collation_connection = utf8mb3_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`magentouser`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `inventory_stock_1` AS select distinct `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` from (`cataloginventory_stock_status` `legacy_stock_status` join `catalog_product_entity` `product` on(`legacy_stock_status`.`product_id` = `product`.`entity_id`)) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-05-30 7:59:49
Reference in New Issue View Git Blame Copy Permalink