1801 lines
110 KiB
Plaintext
1801 lines
110 KiB
Plaintext
好的，为了满足`intent_shopping_admin.txt`文件中列出的所有意图，我们需要保留一个核心的表集合，这些表涵盖了订单管理、客户信息、产品目录、库存、评论和报告等关键功能。
|
||
|
||
以下是分析后得出的 **必须保留的表** 的完整 `schema`。省略了与权限、API、主题、布局、废弃的购物车（quote）以及一些非核心聚合表等无关的表，以确保只包含响应指定意图所需的最小集合。
|
||
|
||
### 核心保留表分析
|
||
|
||
1. **产品目录 (`catalog_...`)**: 用于查找、创建、更新产品信息（名称、价格、SKU、状态）。
|
||
2. **库存 (`cataloginventory_...`)**: 用于更新和查询产品库存数量。
|
||
3. **客户 (`customer_...`)**: 用于查找、创建客户，更新客户组和地址。
|
||
4. **订单 (`sales_order...`)**: 几乎是所有操作的核心，用于查询订单、更新状态（挂起、取消）、修改地址、打印发票/装箱单等。
|
||
5. **发票/货运/退款 (`sales_invoice...`, `sales_shipment...`, `sales_creditmemo...`)**: 订单流程的延伸，用于处理发票、发货和退款操作。
|
||
6. **评论 (`review_...`, `rating_...`)**: 用于查询、更新和管理客户对产品的评论和评级。
|
||
7. **报告 (`sales_bestsellers...`, `sales_order_aggregated...`)**: 用于生成销售报告，如畅销产品。
|
||
8. **CMS (`cms_page`)**: 用于管理静态内容页面，如“关于我们”。
|
||
9. **商店结构 (`store...`)**: Magento的多商店基础，所有数据都与之关联，必须保留。
|
||
10. **EAV 核心 (`eav_...`)**: EAV（实体-属性-值）模型是Magento的核心，用于定义产品、客户等实体的可扩展属性。
|
||
11. **地区 (`directory_...`)**: 用于客户和订单地址中的国家和地区信息。
|
||
12. **序列号 (`sequence_...`, `sales_sequence_...`)**: 用于为新订单、发票等生成唯一的、连续的ID。
|
||
|
||
---
|
||
|
||
### 最小化核心表 Schema
|
||
|
||
```sql
|
||
-- 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 `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_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_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_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_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_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`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `cataloginventory_stock`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `cataloginventory_stock` (
|
||
`stock_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Stock ID',
|
||
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
|
||
`stock_name` varchar(255) DEFAULT NULL COMMENT 'Stock Name',
|
||
PRIMARY KEY (`stock_id`),
|
||
KEY `CATALOGINVENTORY_STOCK_WEBSITE_ID` (`website_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Cataloginventory Stock';
|
||
/*!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 `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 `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_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_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 `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 `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_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_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_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 `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 `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_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 `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_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_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_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_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_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 `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 `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 */;
|
||
|
||
/*!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 |