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