-- Dumping data for table `wal_mageworx_optiontemplates_group_option_type_value`
--

INSERT INTO `wal_mageworx_optiontemplates_group_option_type_value` VALUES ('',0,0.00,0.00,'',0,NULL,1,1,NULL,1,0,0.00,0,0,0);

--
-- Table structure for table `wal_mageworx_optiontemplates_relation`
--

CREATE TABLE `wal_mageworx_optiontemplates_relation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `group_id` int(10) unsigned NOT NULL COMMENT 'Group ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `is_changed` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Changed Flag',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_MAGEWORX_OPTIONTEMPLATES_RELATION_GROUP_ID_PRODUCT_ID` (`group_id`,`product_id`),
  KEY `FK_060BC0744B9CB48B3F1E5A2B223704EC` (`product_id`),
  CONSTRAINT `FK_060BC0744B9CB48B3F1E5A2B223704EC` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_1C76F0D61347D1568623762DC77ADC6A` FOREIGN KEY (`group_id`) REFERENCES `wal_mageworx_optiontemplates_group` (`group_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_mageworx_optiontemplates_relation`
--


--
-- Table structure for table `wal_mageworx_optionvisibility_option_customer_group`
--

CREATE TABLE `wal_mageworx_optionvisibility_option_customer_group` (
  `visibility_customer_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Visibility Customer Group Id',
  `mageworx_option_id` varchar(40) DEFAULT 'null' COMMENT 'MageWorx Option ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  PRIMARY KEY (`visibility_customer_group_id`),
  KEY `WAL_MAGEWORX_OPTIONVISIBILITY_OPTION_CUSTOMER_GROUP_OPTION_ID` (`option_id`),
  KEY `FK_58F120AEC9018EE629B14F2D83DD7E2E` (`customer_group_id`),
  KEY `WAL_MAGEWORX_OPTVISIBILITY_OPT_CSTR_GROUP_CSTR_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `FK_529BDA12479F4FD05F83D99BFD3116E2` FOREIGN KEY (`option_id`) REFERENCES `wal_catalog_product_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_58F120AEC9018EE629B14F2D83DD7E2E` FOREIGN KEY (`customer_group_id`) REFERENCES `wal_customer_group` (`customer_group_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Mageworx OptionVisibiity Option Customer Group Table';

--
-- Dumping data for table `wal_mageworx_optionvisibility_option_customer_group`
--


--
-- Table structure for table `wal_mageworx_optionvisibility_option_store_view`
--

CREATE TABLE `wal_mageworx_optionvisibility_option_store_view` (
  `visibility_store_view_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Visibility Customer Store View Id',
  `mageworx_option_id` varchar(40) DEFAULT NULL COMMENT 'MageWorx Option ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `customer_store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`visibility_store_view_id`),
  KEY `WAL_MAGEWORX_OPTIONVISIBILITY_OPTION_STORE_VIEW_OPTION_ID` (`option_id`),
  KEY `FK_625309FCFB50F214556674465499DA67` (`customer_store_id`),
  KEY `WAL_MAGEWORX_OPTVISIBILITY_OPT_STORE_VIEW_CSTR_STORE_ID` (`customer_store_id`),
  CONSTRAINT `FK_625309FCFB50F214556674465499DA67` FOREIGN KEY (`customer_store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_E3C2A8AE1F44538A1498CCD3ECD0B21A` FOREIGN KEY (`option_id`) REFERENCES `wal_catalog_product_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Mageworx OptionVisibiity Option Store View Table';

--
-- Dumping data for table `wal_mageworx_optionvisibility_option_store_view`
--


--
-- Table structure for table `wal_mana_config_history`
--

CREATE TABLE `wal_mana_config_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Scope',
  `scope_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Scope_id',
  `path` varchar(255) NOT NULL DEFAULT 'general' COMMENT 'Path',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`id`),
  KEY `WAL_CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mana_config_history';

--
-- Dumping data for table `wal_mana_config_history`
--


--
-- Table structure for table `wal_mana_extension`
--

CREATE TABLE `wal_mana_extension` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store_id',
  `is_enabled` tinyint(1) DEFAULT NULL COMMENT 'Is_enabled',
  `is_pending` tinyint(1) DEFAULT NULL COMMENT 'Is_pending',
  `available_version` varchar(20) DEFAULT NULL COMMENT '..',
  PRIMARY KEY (`id`),
  KEY `WAL_MANA_EXTENSION_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_MANA_EXTENSION_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mana_extension';

--
-- Dumping data for table `wal_mana_extension`
--


--
-- Table structure for table `wal_mana_filter`
--

CREATE TABLE `wal_mana_filter` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `edit_id` bigint(20) DEFAULT NULL COMMENT 'Edit_id',
  `filter_id` bigint(20) DEFAULT NULL COMMENT 'Filter_id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store_id',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is_deleted',
  `attribute_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Attribute_id',
  `unique_key` varchar(255) NOT NULL COMMENT 'Unique_key',
  `param_name` varchar(255) NOT NULL COMMENT 'Param_name',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Title',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `template` varchar(255) NOT NULL DEFAULT '' COMMENT 'Template',
  `type` varchar(20) NOT NULL COMMENT '..',
  `minimum_product_count_per_option` int(11) NOT NULL DEFAULT '1' COMMENT '..',
  `is_enabled_in_categories` tinyint(1) NOT NULL DEFAULT '1' COMMENT '..',
  `is_enabled_in_search` tinyint(1) NOT NULL DEFAULT '1' COMMENT '..',
  `attribute_code` varchar(255) DEFAULT NULL COMMENT '..',
  `swatch_input_type` varchar(50) DEFAULT NULL COMMENT '..',
  `show_above_products` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `show_on_mobile` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `show_in_main_sidebar` tinyint(1) NOT NULL DEFAULT '1' COMMENT '..',
  `show_in_additional_sidebar` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `calculate_slider_min_max_based_on` varchar(20) NOT NULL DEFAULT 'page' COMMENT '..',
  `number_format` varchar(20) NOT NULL DEFAULT '$0' COMMENT '..',
  `decimal_digits` int(11) NOT NULL DEFAULT '0' COMMENT '..',
  `is_two_number_formats` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `use_second_number_format_on` int(11) NOT NULL DEFAULT '0' COMMENT '..',
  `second_number_format` varchar(20) NOT NULL DEFAULT '0' COMMENT '..',
  `second_decimal_digits` int(11) NOT NULL DEFAULT '0' COMMENT '..',
  `show_thousand_separator` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `is_slide_on_existing_values` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `is_manual_range` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `slider_style` varchar(20) NOT NULL DEFAULT '' COMMENT '..',
  `min_max_role` varchar(20) NOT NULL COMMENT '..',
  `min_slider_code` varchar(255) NOT NULL COMMENT '..',
  `hide_filter_with_single_visible_item` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `use_filter_title_in_url` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `url_part` varchar(20) NOT NULL DEFAULT 'suffix' COMMENT '..',
  `position_in_url` int(11) NOT NULL DEFAULT '0' COMMENT '..',
  `include_in_canonical_url` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `force_no_index` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `force_no_follow` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `include_in_meta_title` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `include_in_meta_description` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `include_in_meta_keywords` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `include_in_sitemap` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `show_selected_options_first` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  `sort_options_by` varchar(40) NOT NULL DEFAULT 'position' COMMENT '..',
  `show_more_method` varchar(255) NOT NULL COMMENT '..',
  `show_more_item_limit` int(11) NOT NULL COMMENT '..',
  `show_option_search` tinyint(1) NOT NULL COMMENT '..',
  `use_logical_and` tinyint(1) NOT NULL DEFAULT '0' COMMENT '..',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_MANA_FILTER_UNIQUE_KEY` (`unique_key`),
  KEY `WAL_MANA_FILTER_EDIT_ID` (`edit_id`),
  KEY `WAL_MANA_FILTER_FILTER_ID` (`filter_id`),
  KEY `WAL_MANA_FILTER_STORE_ID` (`store_id`),
  KEY `WAL_MANA_FILTER_IS_DELETED` (`is_deleted`),
  KEY `WAL_MANA_FILTER_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `WAL_MANA_FILTER_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `wal_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MANA_FILTER_EDIT_ID_MANA_FILTER_EDIT_ID` FOREIGN KEY (`edit_id`) REFERENCES `wal_mana_filter_edit` (`id`) ON DELETE SET NULL,
  CONSTRAINT `WAL_MANA_FILTER_FILTER_ID_MANA_FILTER_ID` FOREIGN KEY (`filter_id`) REFERENCES `wal_mana_filter` (`id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MANA_FILTER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='wal_mana_filter';

--
-- Dumping data for table `wal_mana_filter`
--

INSERT INTO `wal_mana_filter` VALUES (1,NULL,1,0,0,NULL,'category','cat','Category',-1,'category_parent_children','category',1,1,1,NULL,NULL,0,0,1,0,'page','$0',0,0,0,'0',0,0,0,0,'','','',0,1,'suffix',-1,1,0,0,1,1,1,0,0,'position','show_more_and_show_less',4,0,0),(2,NULL,2,0,0,93,'attribute-93','color','Color',0,'checkboxes','dropdown',1,1,0,'color',NULL,0,0,1,0,'page','$0',0,0,0,'0',0,0,0,0,'','min','',0,1,'suffix',0,1,0,0,1,1,1,0,0,'position','show_more_and_show_less',4,0,0),(3,NULL,3,0,0,83,'attribute-83','manufacturer','Manufacturer',0,'checkboxes','dropdown',1,1,0,'manufacturer',NULL,0,0,1,0,'page','$0',0,0,0,'0',0,0,0,0,'','min','',0,1,'suffix',0,1,0,0,1,1,1,0,0,'position','show_more_and_show_less',4,0,0),(5,NULL,5,0,0,77,'attribute-77','price','Price',0,'slider','price',1,1,0,'price',NULL,0,0,1,0,'page','$0',0,0,0,'0',0,0,0,0,'','min','',0,1,'suffix',0,1,0,0,1,1,1,0,0,'position','show_more_and_show_less',4,0,0),(6,NULL,1,1,0,NULL,'category-1','cat','Category',-1,'category_parent_children','category',1,1,1,NULL,NULL,0,0,1,0,'page','$0',0,0,0,'0',0,0,0,0,'','','',0,1,'suffix',-1,1,0,0,1,1,1,0,0,'position','show_more_and_show_less',4,0,0),(7,NULL,2,1,0,93,'attribute-93-1','color','Color',0,'checkboxes','dropdown',1,1,0,'color',NULL,0,0,1,0,'page','$0',0,0,0,'0',0,0,0,0,'','min','',0,1,'suffix',0,1,0,0,1,1,1,0,0,'position','show_more_and_show_less',4,0,0),(8,NULL,3,1,0,83,'attribute-83-1','manufacturer','Manufacturer',0,'checkboxes','dropdown',1,1,0,'manufacturer',NULL,0,0,1,0,'page','$0',0,0,0,'0',0,0,0,0,'','min','',0,1,'suffix',0,1,0,0,1,1,1,0,0,'position','show_more_and_show_less',4,0,0),(9,NULL,5,1,0,77,'attribute-77-1','price','Price',0,'slider','price',1,1,0,'price',NULL,0,0,1,0,'page','$0',0,0,0,'0',0,0,0,0,'','min','',0,1,'suffix',0,1,0,0,1,1,1,0,0,'position','show_more_and_show_less',4,0,0);

--
-- Table structure for table `wal_mana_filter_attribute_cl`
--

CREATE TABLE `wal_mana_filter_attribute_cl` (
  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='wal_mana_filter_attribute_cl';

--
-- Dumping data for table `wal_mana_filter_attribute_cl`
--

INSERT INTO `wal_mana_filter_attribute_cl` VALUES (1,180),(2,186),(3,186),(4,186),(5,187),(6,187),(7,188),(8,188),(9,189),(10,189),(11,190),(12,190),(13,191),(14,191),(15,192),(16,192),(17,193),(18,193),(19,194),(20,194),(21,195),(22,195),(23,196),(24,196),(25,197),(26,197),(27,198),(28,198),(29,199),(30,199),(31,82),(32,187),(33,188),(34,189),(35,190),(36,200),(37,201),(38,202),(39,203),(40,204),(41,204);

--
-- Table structure for table `wal_mana_filter_edit`
--

CREATE TABLE `wal_mana_filter_edit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `filter_id` bigint(20) NOT NULL COMMENT '..',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store_id',
  `attribute_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Attribute_id',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `template` varchar(255) DEFAULT NULL COMMENT 'Template',
  `minimum_product_count_per_option` int(11) DEFAULT '1' COMMENT '..',
  `is_enabled_in_categories` tinyint(1) DEFAULT NULL COMMENT '..',
  `is_enabled_in_search` tinyint(1) DEFAULT NULL COMMENT '..',
  `type` varchar(20) NOT NULL COMMENT '..',
  `param_name` varchar(255) DEFAULT NULL COMMENT '..',
  `show_above_products` tinyint(1) DEFAULT NULL COMMENT '..',
  `show_on_mobile` tinyint(1) DEFAULT NULL COMMENT '..',
  `show_in_main_sidebar` tinyint(1) DEFAULT NULL COMMENT '..',
  `show_in_additional_sidebar` tinyint(1) DEFAULT NULL COMMENT '..',
  `calculate_slider_min_max_based_on` varchar(20) DEFAULT NULL COMMENT '..',
  `number_format` varchar(20) DEFAULT NULL COMMENT '..',
  `decimal_digits` int(11) DEFAULT '0' COMMENT '..',
  `is_two_number_formats` tinyint(1) DEFAULT NULL COMMENT '..',
  `use_second_number_format_on` int(11) DEFAULT NULL COMMENT '..',
  `second_number_format` varchar(20) DEFAULT NULL COMMENT '..',
  `second_decimal_digits` int(11) DEFAULT NULL COMMENT '..',
  `show_thousand_separator` tinyint(1) DEFAULT NULL COMMENT '..',
  `is_slide_on_existing_values` tinyint(1) DEFAULT NULL COMMENT '..',
  `is_manual_range` tinyint(1) DEFAULT NULL COMMENT '..',
  `slider_style` varchar(20) DEFAULT NULL COMMENT '..',
  `min_max_role` varchar(20) DEFAULT '' COMMENT '..',
  `min_slider_code` varchar(255) DEFAULT '' COMMENT '..',
  `hide_filter_with_single_visible_item` tinyint(1) DEFAULT NULL COMMENT '..',
  `use_filter_title_in_url` tinyint(1) DEFAULT NULL COMMENT '..',
  `url_part` varchar(20) DEFAULT 'suffix' COMMENT '..',
  `position_in_url` int(11) DEFAULT '0' COMMENT '..',
  `include_in_canonical_url` tinyint(1) DEFAULT '0' COMMENT '..',
  `force_no_index` tinyint(1) DEFAULT '0' COMMENT '..',
  `force_no_follow` tinyint(1) DEFAULT '0' COMMENT '..',
  `include_in_meta_title` tinyint(1) DEFAULT '0' COMMENT '..',
  `include_in_meta_description` tinyint(1) DEFAULT '0' COMMENT '..',
  `include_in_meta_keywords` tinyint(1) DEFAULT '0' COMMENT '..',
  `include_in_sitemap` tinyint(1) DEFAULT '0' COMMENT '..',
  `show_selected_options_first` tinyint(1) DEFAULT NULL COMMENT '..',
  `sort_options_by` varchar(40) DEFAULT 'position' COMMENT '..',
  `show_more_method` varchar(255) DEFAULT NULL COMMENT '..',
  `show_more_item_limit` int(11) DEFAULT NULL COMMENT '..',
  `show_option_search` tinyint(1) DEFAULT NULL COMMENT '..',
  `use_logical_and` tinyint(1) DEFAULT NULL COMMENT '..',
  PRIMARY KEY (`id`),
  KEY `WAL_MANA_FILTER_EDIT_FILTER_ID` (`filter_id`),
  KEY `WAL_MANA_FILTER_EDIT_STORE_ID` (`store_id`),
  KEY `WAL_MANA_FILTER_EDIT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `WAL_MANA_FILTER_EDIT_TYPE` (`type`),
  CONSTRAINT `WAL_MANA_FILTER_EDIT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `wal_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MANA_FILTER_EDIT_FILTER_ID_MANA_FILTER_ID` FOREIGN KEY (`filter_id`) REFERENCES `wal_mana_filter` (`id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MANA_FILTER_EDIT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mana_filter_edit';

--
-- Dumping data for table `wal_mana_filter_edit`
--


--
-- Table structure for table `wal_mana_url_attribute_cl`
--

CREATE TABLE `wal_mana_url_attribute_cl` (
  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='wal_mana_url_attribute_cl';

--
-- Dumping data for table `wal_mana_url_attribute_cl`
--

INSERT INTO `wal_mana_url_attribute_cl` VALUES (1,180),(2,186),(3,187),(4,188),(5,189),(6,190),(7,191),(8,192),(9,193),(10,194),(11,195),(12,196),(13,197),(14,198),(15,199),(16,187),(17,188),(18,189),(19,190),(20,200),(21,201),(22,202),(23,203),(24,204);

--
-- Table structure for table `wal_mana_url_filter_cl`
--

CREATE TABLE `wal_mana_url_filter_cl` (
  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mana_url_filter_cl';

--
-- Dumping data for table `wal_mana_url_filter_cl`
--


--
-- Table structure for table `wal_mana_url_key`
--

CREATE TABLE `wal_mana_url_key` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `url_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'Url_key',
  `status` varchar(20) NOT NULL COMMENT 'Status',
  `position` int(11) NOT NULL COMMENT 'Position',
  `type` varchar(20) NOT NULL COMMENT 'Type',
  `sub_type` varchar(30) NOT NULL COMMENT 'Sub_type',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store_id',
  `category_id` int(10) unsigned DEFAULT NULL COMMENT 'Category_id',
  `cms_page_id` smallint(6) DEFAULT NULL COMMENT 'Cms_page_id',
  `option_id` int(10) unsigned DEFAULT NULL COMMENT 'Option_id',
  `original_url_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Original_url_key',
  `unique_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'Unique_key',
  `inferred_url_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'Inferred_url_key',
  `assigned_url_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'Assigned_url_key',
  `conflicting_url_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'Conflicting_url_key',
  `conflict_resolution` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'Conflict_resolution',
  `route` varchar(80) DEFAULT NULL COMMENT 'Route',
  `param_name` varchar(80) DEFAULT NULL COMMENT 'Param_name',
  `requires_param_name` tinyint(1) DEFAULT NULL COMMENT 'Requires_param_name',
  `url_part` varchar(20) DEFAULT NULL COMMENT 'Url_part',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `reference` varchar(255) DEFAULT NULL COMMENT 'Reference',
  `filter_id` bigint(20) DEFAULT NULL COMMENT '..',
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_A07CA3DDCBE776C8C9779CB92C81F033` (`type`,`sub_type`,`store_id`,`unique_key`,`original_url_key`),
  KEY `WAL_MANA_URL_KEY_URL_KEY` (`url_key`),
  KEY `WAL_MANA_URL_KEY_STATUS` (`status`),
  KEY `WAL_MANA_URL_KEY_STORE_ID` (`store_id`),
  KEY `WAL_MANA_URL_KEY_CATEGORY_ID` (`category_id`),
  KEY `WAL_MANA_URL_KEY_CMS_PAGE_ID` (`cms_page_id`),
  KEY `WAL_MANA_URL_KEY_OPTION_ID` (`option_id`),
  KEY `WAL_MANA_URL_KEY_CONFLICTING_URL_KEY` (`conflicting_url_key`),
  KEY `WAL_MANA_URL_KEY_REFERENCE` (`reference`),
  KEY `WAL_MANA_URL_KEY_FILTER_ID` (`filter_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COMMENT='wal_mana_url_key';

--
-- Dumping data for table `wal_mana_url_key`
--

INSERT INTO `wal_mana_url_key` VALUES (1,'no-route','active',0,'page','cms_page',1,NULL,1,NULL,'','1-no-route','no-route',NULL,'no-route',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'404 Not Found\' (ID 1)','cms-page-1.',NULL),(2,'home','active',0,'page','cms_page',1,NULL,2,NULL,'','2-home','home',NULL,'home',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'Home page\' (ID 2)','cms-page-2.',NULL),(3,'enable-cookies','active',0,'page','cms_page',1,NULL,3,NULL,'','3-enable-cookies','enable-cookies',NULL,'enable-cookies',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'Enable Cookies\' (ID 3)','cms-page-3.',NULL),(4,'privacy-policy-cookie-restriction-mode','active',0,'page','cms_page',1,NULL,4,NULL,'','4-privacy-policy-cookie-restriction-mode','privacy-policy-cookie-restriction-mode',NULL,'privacy-policy-cookie-restriction-mode',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'Privacy and Cookie Policy\' (ID 4)','cms-page-4.',NULL),(5,'about-us','active',0,'page','cms_page',1,NULL,5,NULL,'','5-about-us','about-us',NULL,'about-us',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'About us\' (ID 5)','cms-page-5.',NULL),(6,'customer-service','active',0,'page','cms_page',1,NULL,6,NULL,'','6-customer-service','customer-service',NULL,'customer-service',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'Customer Service\' (ID 6)','cms-page-6.',NULL),(7,'clothing-accessies-home-page','active',0,'page','cms_page',1,NULL,7,NULL,'','7-clothing-accessies-home-page','clothing-accessies-home-page',NULL,'clothing-accessies-home-page',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'Clothing Accessies Home Page\' (ID 7)','cms-page-7.',NULL),(8,'codazon-fastest-home-two-columns','active',0,'page','cms_page',1,NULL,8,NULL,'','8-codazon-fastest-home-two-columns','codazon-fastest-home-two-columns',NULL,'codazon-fastest-home-two-columns',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'Codazon Fastest - Homepage - Two Columns\' (ID 8)','cms-page-8.',NULL),(9,'webkul','active',0,'page','cms_page',1,NULL,9,NULL,'','9-webkul','webkul',NULL,'webkul',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'Marketplace\' (ID 9)','cms-page-9.',NULL),(10,'webkul-seller','active',0,'page','cms_page',1,NULL,10,NULL,'','10-webkul-seller','webkul-seller',NULL,'webkul-seller',NULL,'cms/page/view',NULL,NULL,NULL,'CMS page \'Marketplace Seller\' (ID 10)','cms-page-10.',NULL),(16,'search','active',0,'page','search_page',1,NULL,NULL,NULL,'','search','search',NULL,'search',NULL,'catalogsearch/result/index',NULL,NULL,NULL,'Quick search page','search-page.',NULL),(17,'page','active',9900,'parameter','toolbar_parameter',1,NULL,NULL,NULL,'','page','page',NULL,'page',NULL,NULL,'p',1,'suffix','p toolbar parameter','toolbar-parameter-p.',NULL),(18,'sort-by','active',9910,'parameter','toolbar_parameter',1,NULL,NULL,NULL,'','sort-by','sort-by',NULL,'sort-by',NULL,NULL,'product_list_order',1,'query','product_list_order toolbar parameter','toolbar-parameter-product_list_order.',NULL),(19,'sort-direction','active',9920,'parameter','toolbar_parameter',1,NULL,NULL,NULL,'','sort-direction','sort-direction',NULL,'sort-direction',NULL,NULL,'product_list_dir',1,'query','product_list_dir toolbar parameter','toolbar-parameter-product_list_dir.',NULL),(20,'mode','active',9930,'parameter','toolbar_parameter',1,NULL,NULL,NULL,'','mode','mode',NULL,'mode',NULL,NULL,'product_list_mode',1,'query','product_list_mode toolbar parameter','toolbar-parameter-product_list_mode.',NULL),(21,'show-per-page','active',9940,'parameter','toolbar_parameter',1,NULL,NULL,NULL,'','show-per-page','show-per-page',NULL,'show-per-page',NULL,NULL,'product_list_limit',1,'query','product_list_limit toolbar parameter','toolbar-parameter-product_list_limit.',NULL),(22,'keyword','active',-1000,'parameter','keyword_parameter',1,NULL,NULL,NULL,'','keyword','keyword',NULL,'keyword',NULL,NULL,'q',0,'suffix','Search keyword parameter','keyword-parameter.',NULL),(23,'color','active',0,'parameter','option_filter_parameter',1,NULL,NULL,NULL,'','2-color','color',NULL,'color',NULL,NULL,'color',1,'suffix','Filter parameter \'Color\' (ID 2)','filter-parameter-2.',2),(24,'manufacturer','active',0,'parameter','option_filter_parameter',1,NULL,NULL,NULL,'','3-manufacturer','manufacturer',NULL,'manufacturer',NULL,NULL,'manufacturer',1,'suffix','Filter parameter \'Manufacturer\' (ID 3)','filter-parameter-3.',3),(26,'price','active',0,'parameter','range_filter_parameter',1,NULL,NULL,NULL,'','5-price','price',NULL,'price',NULL,NULL,'price',1,'suffix','Filter parameter \'Price\' (ID 5)','filter-parameter-5.',5),(27,'category','active',-1,'parameter','category_filter_parameter',1,NULL,NULL,NULL,'','1-category','category',NULL,'category',NULL,NULL,'cat',1,'suffix','Filter parameter \'Category\' (ID 1)','filter-parameter-1.',1),(39,'demo-category','active',0,'page','category_page',1,3,NULL,NULL,'','3-demo-category','demo-category',NULL,'demo-category',NULL,'catalog/category/view',NULL,NULL,NULL,'Category page \'demo category\' (ID 3)','category-page-3.',NULL),(40,'demo-category','active',-65535,'option','category_option',1,3,NULL,NULL,'','3-demo-category','demo-category',NULL,'demo-category',NULL,NULL,'cat',1,NULL,'Category Option \'demo category\' (ID 3)','category-option-3.',1);

--
-- Table structure for table `wal_mana_url_key_conflict_resolution`
--

CREATE TABLE `wal_mana_url_key_conflict_resolution` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `scope` varchar(255) NOT NULL COMMENT 'Scope',
  `url_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'Url_key',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store_id',
  `last_used_resolution` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'Last_used_resolution',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_MANA_URL_KEY_CONFLICT_RESOLUTION_SCOPE_URL_KEY` (`scope`,`url_key`),
  KEY `WAL_MANA_URL_KEY_CONFLICT_RESOLUTION_SCOPE` (`scope`),
  KEY `WAL_MANA_URL_KEY_CONFLICT_RESOLUTION_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mana_url_key_conflict_resolution';

--
-- Dumping data for table `wal_mana_url_key_conflict_resolution`
--


--
-- Table structure for table `wal_mana_url_option_cl`
--

CREATE TABLE `wal_mana_url_option_cl` (
  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mana_url_option_cl';

--
-- Dumping data for table `wal_mana_url_option_cl`
--


--
-- Table structure for table `wal_mana_url_rewrite_cl`
--

CREATE TABLE `wal_mana_url_rewrite_cl` (
  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='wal_mana_url_rewrite_cl';

--
-- Dumping data for table `wal_mana_url_rewrite_cl`
--

INSERT INTO `wal_mana_url_rewrite_cl` VALUES (1,15);

--
-- Table structure for table `wal_media_content_asset`
--

CREATE TABLE `wal_media_content_asset` (
  `asset_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `entity_type` varchar(255) NOT NULL COMMENT 'Content type',
  `entity_id` varchar(255) NOT NULL COMMENT 'Content entity id',
  `field` varchar(255) NOT NULL COMMENT 'Content field',
  PRIMARY KEY (`entity_type`,`entity_id`,`field`,`asset_id`),
  KEY `WAL_MEDIA_CONTENT_ASSET_ASSET_ID` (`asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Relation between media content and media asset';

--
-- Dumping data for table `wal_media_content_asset`
--


--
-- Table structure for table `wal_media_gallery_asset`
--

CREATE TABLE `wal_media_gallery_asset` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `path` text COMMENT 'Path',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `source` varchar(255) DEFAULT NULL COMMENT 'Source',
  `content_type` varchar(255) DEFAULT NULL COMMENT 'Content Type',
  `width` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Width',
  `height` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Height',
  `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',
  `description` text COMMENT 'Description',
  `hash` varchar(255) DEFAULT NULL COMMENT 'File hash',
  `size` int(10) unsigned NOT NULL COMMENT 'Asset file size in bytes',
  PRIMARY KEY (`id`),
  KEY `WAL_MEDIA_GALLERY_ASSET_ID` (`id`),
  FULLTEXT KEY `WAL_MEDIA_GALLERY_ASSET_TITLE` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Media Gallery Asset';

--
-- Dumping data for table `wal_media_gallery_asset`
--


--
-- Table structure for table `wal_media_gallery_asset_keyword`
--

CREATE TABLE `wal_media_gallery_asset_keyword` (
  `keyword_id` int(10) unsigned NOT NULL COMMENT 'Keyword Id',
  `asset_id` int(10) unsigned NOT NULL COMMENT 'Asset ID',
  PRIMARY KEY (`keyword_id`,`asset_id`),
  KEY `WAL_MEDIA_GALLERY_ASSET_KEYWORD_ASSET_ID` (`asset_id`),
  KEY `WAL_MEDIA_GALLERY_ASSET_KEYWORD_KEYWORD_ID` (`keyword_id`),
  CONSTRAINT `WAL_MDA_GLR_ASSET_KEYWORD_ASSET_ID_WAL_MDA_GLR_ASSET_ID` FOREIGN KEY (`asset_id`) REFERENCES `wal_media_gallery_asset` (`id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MDA_GLR_ASSET_KEYWORD_KEYWORD_ID_WAL_MDA_GLR_KEYWORD_ID` FOREIGN KEY (`keyword_id`) REFERENCES `wal_media_gallery_keyword` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Media Gallery Asset Keyword';

--
-- Dumping data for table `wal_media_gallery_asset_keyword`
--


--
-- Table structure for table `wal_media_gallery_keyword`
--

CREATE TABLE `wal_media_gallery_keyword` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Keyword ID',
  `keyword` varchar(255) NOT NULL COMMENT 'Keyword',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_MEDIA_GALLERY_KEYWORD_KEYWORD` (`keyword`),
  KEY `WAL_MEDIA_GALLERY_KEYWORD_ID` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Media Gallery Keyword';

--
-- Dumping data for table `wal_media_gallery_keyword`
--


--
-- Table structure for table `wal_msp_tfa_country_codes`
--

CREATE TABLE `wal_msp_tfa_country_codes` (
  `msp_tfa_country_codes_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'TFA admin user ID',
  `code` text NOT NULL COMMENT 'Country code',
  `name` text NOT NULL COMMENT 'Country name',
  `dial_code` text NOT NULL COMMENT 'Prefix',
  PRIMARY KEY (`msp_tfa_country_codes_id`),
  KEY `WAL_MSP_TFA_COUNTRY_CODES_CODE` (`code`(128))
) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8 COMMENT='wal_msp_tfa_country_codes';

--
-- Dumping data for table `wal_msp_tfa_country_codes`
--

INSERT INTO `wal_msp_tfa_country_codes` VALUES (1,'IL','Israel','+972'),(2,'AF','Afghanistan','+93'),(3,'AL','Albania','+355'),(4,'DZ','Algeria','+213'),(5,'AS','AmericanSamoa','+1 684'),(6,'AD','Andorra','+376'),(7,'AO','Angola','+244'),(8,'AI','Anguilla','+1 264'),(9,'AG','Antigua and Barbuda','+1268'),(10,'AR','Argentina','+54'),(11,'AM','Armenia','+374'),(12,'AW','Aruba','+297'),(13,'AU','Australia','+61'),(14,'AT','Austria','+43'),(15,'AZ','Azerbaijan','+994'),(16,'BS','Bahamas','+1 242'),(17,'BH','Bahrain','+973'),(18,'BD','Bangladesh','+880'),(19,'BB','Barbados','+1 246'),(20,'BY','Belarus','+375'),(21,'BE','Belgium','+32'),(22,'BZ','Belize','+501'),(23,'BJ','Benin','+229'),(24,'BM','Bermuda','+1 441'),(25,'BT','Bhutan','+975'),(26,'BA','Bosnia and Herzegovina','+387'),(27,'BW','Botswana','+267'),(28,'BR','Brazil','+55'),(29,'IO','British Indian Ocean Territory','+246'),(30,'BG','Bulgaria','+359'),(31,'BF','Burkina Faso','+226'),(32,'BI','Burundi','+257'),(33,'KH','Cambodia','+855'),(34,'CM','Cameroon','+237'),(35,'CA','Canada','+1'),(36,'CV','Cape Verde','+238'),(37,'KY','Cayman Islands','+ 345'),(38,'CF','Central African Republic','+236'),(39,'TD','Chad','+235'),(40,'CL','Chile','+56'),(41,'CN','China','+86'),(42,'CX','Christmas Island','+61'),(43,'CO','Colombia','+57'),(44,'KM','Comoros','+269'),(45,'CG','Congo','+242'),(46,'CK','Cook Islands','+682'),(47,'CR','Costa Rica','+506'),(48,'HR','Croatia','+385'),(49,'CU','Cuba','+53'),(50,'CY','Cyprus','+537'),(51,'CZ','Czech Republic','+420'),(52,'DK','Denmark','+45'),(53,'DJ','Djibouti','+253'),(54,'DM','Dominica','+1 767'),(55,'DO','Dominican Republic','+1 849'),(56,'EC','Ecuador','+593'),(57,'EG','Egypt','+20'),(58,'SV','El Salvador','+503'),(59,'GQ','Equatorial Guinea','+240'),(60,'ER','Eritrea','+291'),(61,'EE','Estonia','+372'),(62,'ET','Ethiopia','+251'),(63,'FO','Faroe Islands','+298'),(64,'FJ','Fiji','+679'),(65,'FI','Finland','+358'),(66,'FR','France','+33'),(67,'GF','French Guiana','+594'),(68,'PF','French Polynesia','+689'),(69,'GA','Gabon','+241'),(70,'GM','Gambia','+220'),(71,'GE','Georgia','+995'),(72,'DE','Germany','+49'),(73,'GH','Ghana','+233'),(74,'GI','Gibraltar','+350'),(75,'GR','Greece','+30'),(76,'GL','Greenland','+299'),(77,'GD','Grenada','+1 473'),(78,'GP','Guadeloupe','+590'),(79,'GU','Guam','+1 671'),(80,'GT','Guatemala','+502'),(81,'GN','Guinea','+224'),(82,'GW','Guinea-Bissau','+245'),(83,'GY','Guyana','+595'),(84,'HT','Haiti','+509'),(85,'HN','Honduras','+504'),(86,'HU','Hungary','+36'),(87,'IS','Iceland','+354'),(88,'IN','India','+91'),(89,'ID','Indonesia','+62'),(90,'IQ','Iraq','+964'),(91,'IE','Ireland','+353'),(92,'IL','Israel','+972'),(93,'IT','Italy','+39'),(94,'JM','Jamaica','+1 876'),(95,'JP','Japan','+81'),(96,'JO','Jordan','+962'),(97,'KZ','Kazakhstan','+7 7'),(98,'KE','Kenya','+254'),(99,'KI','Kiribati','+686'),(100,'KW','Kuwait','+965'),(101,'KG','Kyrgyzstan','+996'),(102,'LV','Latvia','+371'),(103,'LB','Lebanon','+961'),(104,'LS','Lesotho','+266'),(105,'LR','Liberia','+231'),(106,'LI','Liechtenstein','+423'),(107,'LT','Lithuania','+370'),(108,'LU','Luxembourg','+352'),(109,'MG','Madagascar','+261'),(110,'MW','Malawi','+265'),(111,'MY','Malaysia','+60'),(112,'MV','Maldives','+960'),(113,'ML','Mali','+223'),(114,'MT','Malta','+356'),(115,'MH','Marshall Islands','+692'),(116,'MQ','Martinique','+596'),(117,'MR','Mauritania','+222'),(118,'MU','Mauritius','+230'),(119,'YT','Mayotte','+262'),(120,'MX','Mexico','+52'),(121,'MC','Monaco','+377'),(122,'MN','Mongolia','+976'),(123,'ME','Montenegro','+382'),(124,'MS','Montserrat','+1664'),(125,'MA','Morocco','+212'),(126,'MM','Myanmar','+95'),(127,'NA','Namibia','+264'),(128,'NR','Nauru','+674'),(129,'NP','Nepal','+977'),(130,'NL','Netherlands','+31'),(131,'AN','Netherlands Antilles','+599'),(132,'NC','New Caledonia','+687'),(133,'NZ','New Zealand','+64'),(134,'NI','Nicaragua','+505'),(135,'NE','Niger','+227'),(136,'NG','Nigeria','+234'),(137,'NU','Niue','+683'),(138,'NF','Norfolk Island','+672'),(139,'MP','Northern Mariana Islands','+1 670'),(140,'NO','Norway','+47'),(141,'OM','Oman','+968'),(142,'PK','Pakistan','+92'),(143,'PW','Palau','+680'),(144,'PA','Panama','+507'),(145,'PG','Papua New Guinea','+675'),(146,'PY','Paraguay','+595'),(147,'PE','Peru','+51'),(148,'PH','Philippines','+63'),(149,'PL','Poland','+48'),(150,'PT','Portugal','+351'),(151,'PR','Puerto Rico','+1 939'),(152,'QA','Qatar','+974'),(153,'RO','Romania','+40'),(154,'RW','Rwanda','+250'),(155,'WS','Samoa','+685'),(156,'SM','San Marino','+378'),(157,'SA','Saudi Arabia','+966'),(158,'SN','Senegal','+221'),(159,'RS','Serbia','+381'),(160,'SC','Seychelles','+248'),(161,'SL','Sierra Leone','+232'),(162,'SG','Singapore','+65'),(163,'SK','Slovakia','+421'),(164,'SI','Slovenia','+386'),(165,'SB','Solomon Islands','+677'),(166,'ZA','South Africa','+27'),(167,'GS','South Georgia and the South Sandwich Islands','+500'),(168,'ES','Spain','+34'),(169,'LK','Sri Lanka','+94'),(170,'SD','Sudan','+249'),(171,'SR','Suriname','+597'),(172,'SZ','Swaziland','+268'),(173,'SE','Sweden','+46'),(174,'CH','Switzerland','+41'),(175,'TJ','Tajikistan','+992'),(176,'TH','Thailand','+66'),(177,'TG','Togo','+228'),(178,'TK','Tokelau','+690'),(179,'TO','Tonga','+676'),(180,'TT','Trinidad and Tobago','+1 868'),(181,'TN','Tunisia','+216'),(182,'TR','Turkey','+90'),(183,'TM','Turkmenistan','+993'),(184,'TC','Turks and Caicos Islands','+1 649'),(185,'TV','Tuvalu','+688'),(186,'UG','Uganda','+256'),(187,'UA','Ukraine','+380'),(188,'AE','United Arab Emirates','+971'),(189,'GB','United Kingdom','+44'),(190,'US','United States','+1'),(191,'UY','Uruguay','+598'),(192,'UZ','Uzbekistan','+998'),(193,'VU','Vanuatu','+678'),(194,'WF','Wallis and Futuna','+681'),(195,'YE','Yemen','+967'),(196,'ZM','Zambia','+260'),(197,'ZW','Zimbabwe','+263'),(198,'AX','land Islands',''),(199,'BO','Bolivia, Plurinational State of','+591'),(200,'BN','Brunei Darussalam','+673'),(201,'CC','Cocos (Keeling) Islands','+61'),(202,'CD','Congo, The Democratic Republic of the','+243'),(203,'CI','Cote d\'Ivoire','+225'),(204,'FK','Falkland Islands (Malvinas)','+500'),(205,'GG','Guernsey','+44'),(206,'VA','Holy See (Vatican City State)','+379'),(207,'HK','Hong Kong','+852'),(208,'IR','Iran, Islamic Republic of','+98'),(209,'IM','Isle of Man','+44'),(210,'JE','Jersey','+44'),(211,'KP','Korea, Democratic People\'s Republic of','+850'),(212,'KR','Korea, Republic of','+82'),(213,'LA','Lao People\'s Democratic Republic','+856'),(214,'LY','Libyan Arab Jamahiriya','+218'),(215,'MO','Macao','+853'),(216,'MK','Macedonia, The Former Yugoslav Republic of','+389'),(217,'FM','Micronesia, Federated States of','+691'),(218,'MD','Moldova, Republic of','+373'),(219,'MZ','Mozambique','+258'),(220,'PS','Palestinian Territory, Occupied','+970'),(221,'PN','Pitcairn','+872'),(222,'RE','Réunion','+262'),(223,'RU','Russia','+7'),(224,'BL','Saint Barthélemy','+590'),(225,'SH','Saint Helena, Ascension and Tristan Da Cunha','+290'),(226,'KN','Saint Kitts and Nevis','+1 869'),(227,'LC','Saint Lucia','+1 758'),(228,'MF','Saint Martin','+590'),(229,'PM','Saint Pierre and Miquelon','+508'),(230,'VC','Saint Vincent and the Grenadines','+1 784'),(231,'ST','Sao Tome and Principe','+239'),(232,'SO','Somalia','+252'),(233,'SJ','Svalbard and Jan Mayen','+47'),(234,'SY','Syrian Arab Republic','+963'),(235,'TW','Taiwan, Province of China','+886'),(236,'TZ','Tanzania, United Republic of','+255'),(237,'TL','Timor-Leste','+670'),(238,'VE','Venezuela, Bolivarian Republic of','+58'),(239,'VN','Viet Nam','+84'),(240,'VG','Virgin Islands, British','+1 284'),(241,'VI','Virgin Islands, U.S.','+1 340');

--
-- Table structure for table `wal_mst_affiliate_account`
--

CREATE TABLE `wal_mst_affiliate_account` (
  `account_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Account ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `identifier` varchar(255) NOT NULL COMMENT 'Identifier',
  `website` varchar(255) DEFAULT NULL COMMENT 'website',
  `is_subscribed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'website',
  `status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Status',
  `payment_method` varchar(255) DEFAULT NULL COMMENT 'Payment Method',
  `payment_email` varchar(255) DEFAULT NULL COMMENT 'Payment Email',
  `balance` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Balance',
  `total_commissions` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Commissions',
  `total_withdrawals` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Withdrawals',
  `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',
  `program_ids` varchar(255) DEFAULT '' COMMENT 'Program Ids',
  `parent_id` int(11) DEFAULT NULL COMMENT 'Parent account',
  `group_id` int(10) unsigned DEFAULT NULL COMMENT 'group_id',
  PRIMARY KEY (`account_id`),
  KEY `WAL_MST_AFFILIATE_ACCOUNT_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
  CONSTRAINT `WAL_MST_AFFILIATE_ACCOUNT_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mst_affiliate_account';

--
-- Dumping data for table `wal_mst_affiliate_account`
--


--
-- Table structure for table `wal_mst_affiliate_account_customer`
--

CREATE TABLE `wal_mst_affiliate_account_customer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `account_id` int(11) NOT NULL COMMENT 'Account',
  `customer_id` int(11) NOT NULL COMMENT 'Customer',
  `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',
  PRIMARY KEY (`id`),
  KEY `WAL_MST_AFFILIATE_ACCOUNT_CUSTOMER_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account 2 Customer Relations';

--
-- Dumping data for table `wal_mst_affiliate_account_customer`
--


--
-- Table structure for table `wal_mst_affiliate_banner`
--

CREATE TABLE `wal_mst_affiliate_banner` (
  `banner_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Banner ID',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `type` varchar(255) NOT NULL COMMENT 'Banner Type',
  `source` text COMMENT 'Source',
  `width` int(10) unsigned DEFAULT NULL COMMENT 'Image Width',
  `height` int(10) unsigned DEFAULT NULL COMMENT 'Image Height',
  `link` text COMMENT 'Link',
  `is_active` int(11) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `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',
  `store_ids` varchar(255) NOT NULL DEFAULT '0' COMMENT 'store_ids',
  PRIMARY KEY (`banner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mst_affiliate_banner';

--
-- Dumping data for table `wal_mst_affiliate_banner`
--


--
-- Table structure for table `wal_mst_affiliate_coupon`
--

CREATE TABLE `wal_mst_affiliate_coupon` (
  `coupon_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Coupon Id',
  `account_id` int(11) NOT NULL COMMENT 'Account',
  `program_id` int(11) DEFAULT NULL COMMENT 'Program',
  `code` varchar(255) NOT NULL COMMENT 'Coupon Code',
  PRIMARY KEY (`coupon_id`),
  KEY `WAL_MST_AFFILIATE_COUPON_ACCOUNT_ID` (`account_id`),
  KEY `WAL_MST_AFFILIATE_COUPON_CODE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Coupon Code';

--
-- Dumping data for table `wal_mst_affiliate_coupon`
--


--
-- Table structure for table `wal_mst_affiliate_event`
--

CREATE TABLE `wal_mst_affiliate_event` (
  `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event ID',
  `account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
  `type` text NOT NULL COMMENT 'Event type',
  `visitor_identifier` text NOT NULL COMMENT 'Visitor',
  `entity_id` int(10) unsigned DEFAULT NULL COMMENT 'Entity ID',
  `arg_serialized` text COMMENT 'Arguments',
  `is_processed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Processed',
  `amount` decimal(12,4) unsigned DEFAULT '0.0000' COMMENT 'Amount',
  `referer` varchar(255) DEFAULT NULL COMMENT 'Referer',
  `commission` decimal(12,4) unsigned DEFAULT '0.0000' COMMENT 'Commission',
  `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(11) DEFAULT NULL COMMENT 'customer_id',
  `store_id` int(11) NOT NULL DEFAULT '0' COMMENT 'store_id',
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mst_affiliate_event';

--
-- Dumping data for table `wal_mst_affiliate_event`
--


--
-- Table structure for table `wal_mst_affiliate_group`
--

CREATE TABLE `wal_mst_affiliate_group` (
  `group_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'group_id',
  `name` text NOT NULL COMMENT 'name',
  `is_default` int(11) NOT NULL DEFAULT '0' COMMENT 'is_default',
  `is_auto_update` int(11) NOT NULL DEFAULT '0' COMMENT 'is_auto_update',
  `priority` int(11) DEFAULT '0' COMMENT 'priority',
  `conditions_serialized` text COMMENT 'conditions_serialized',
  `description` text COMMENT 'description',
  `is_visible` int(11) NOT NULL DEFAULT '0' COMMENT 'is_visible',
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Affiliate Groups';

--
-- Dumping data for table `wal_mst_affiliate_group`
--

INSERT INTO `wal_mst_affiliate_group` VALUES (1,'Default group',1,1,0,NULL,NULL,1);

--
-- Table structure for table `wal_mst_affiliate_program`
--

CREATE TABLE `wal_mst_affiliate_program` (
  `program_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Program ID',
  `name` varchar(255) NOT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `type` varchar(255) NOT NULL COMMENT 'Type',
  `is_active` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `active_from` datetime DEFAULT NULL COMMENT 'Active From',
  `active_to` datetime DEFAULT NULL COMMENT 'Active To',
  `is_visible` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Visible',
  `commission_amount_type` varchar(255) DEFAULT NULL COMMENT 'Commission Amount Type',
  `commission_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Commission Amount',
  `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',
  `tiers_serialized` text COMMENT 'Tiers',
  `conditions_serialized` text COMMENT 'conditions_serialized',
  `priority` int(11) DEFAULT '0' COMMENT 'priority',
  `store_ids` varchar(255) NOT NULL DEFAULT '0' COMMENT 'store_ids',
  `coupon_is_active` int(10) unsigned DEFAULT NULL COMMENT 'store_id',
  `cart_rule_id` int(10) unsigned DEFAULT NULL COMMENT 'store_id',
  `is_stop_processing` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Discard subsequent programs ',
  PRIMARY KEY (`program_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mst_affiliate_program';

--
-- Dumping data for table `wal_mst_affiliate_program`
--


--
-- Table structure for table `wal_mst_affiliate_transaction`
--

CREATE TABLE `wal_mst_affiliate_transaction` (
  `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Transaction ID',
  `account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
  `entity_id` int(10) unsigned DEFAULT NULL COMMENT 'Entity ID',
  `event_id` int(10) unsigned DEFAULT NULL COMMENT 'Event ID',
  `amount` decimal(12,4) NOT NULL COMMENT 'Transaction amount',
  `balance` decimal(12,4) NOT NULL COMMENT 'Balance',
  `type` varchar(255) NOT NULL COMMENT 'Transaction type',
  `message` text COMMENT 'Message',
  `status` varchar(255) NOT NULL COMMENT 'Status',
  `hold_to` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Hold to',
  `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(11) DEFAULT NULL COMMENT 'customer_id',
  `store_id` int(11) NOT NULL DEFAULT '0' COMMENT 'store_id',
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mst_affiliate_transaction';

--
-- Dumping data for table `wal_mst_affiliate_transaction`
--


--
-- Table structure for table `wal_mst_affiliate_withdraw`
--

CREATE TABLE `wal_mst_affiliate_withdraw` (
  `withdraw_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Withdraw ID',
  `account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
  `amount` decimal(12,4) unsigned NOT NULL COMMENT 'Amount',
  `fee` decimal(12,4) unsigned NOT NULL COMMENT 'Fee',
  `message` text COMMENT 'Message',
  `status` varchar(255) NOT NULL COMMENT 'Status',
  `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',
  PRIMARY KEY (`withdraw_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mst_affiliate_withdraw';

--
-- Dumping data for table `wal_mst_affiliate_withdraw`
--


--
-- Table structure for table `wal_mst_core_urlrewrite`
--

CREATE TABLE `wal_mst_core_urlrewrite` (
  `urlrewrite_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Url Rewrite Id',
  `url_key` varchar(255) NOT NULL COMMENT 'Url Key',
  `module` varchar(255) NOT NULL COMMENT 'Module',
  `type` varchar(255) NOT NULL COMMENT 'Type',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `store_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`urlrewrite_id`),
  UNIQUE KEY `WAL_CORE_URLREWRITE_INDEX1_MODULE_TYPE_ENTITY_ID_STORE_ID` (`module`,`type`,`entity_id`,`store_id`),
  UNIQUE KEY `WAL_CORE_URLREWRITE_INDEX2_URL_KEY_MODULE_STORE_ID` (`url_key`,`module`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mst_core_urlrewrite';

--
-- Dumping data for table `wal_mst_core_urlrewrite`
--


--
-- Table structure for table `wal_mst_report_email`
--

CREATE TABLE `wal_mst_report_email` (
  `email_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Email Id',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `is_active` int(11) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `is_attach_enabled` int(11) NOT NULL DEFAULT '0' COMMENT 'Is Attach Enabled',
  `subject` varchar(255) NOT NULL COMMENT 'Subject',
  `recipient` varchar(255) NOT NULL COMMENT 'Recipient',
  `schedule` varchar(255) NOT NULL COMMENT 'Schedule',
  `blocks_serialized` text NOT NULL COMMENT 'Content',
  `last_sent_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Sent At',
  PRIMARY KEY (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Report Email';

--
-- Dumping data for table `wal_mst_report_email`
--


--
-- Table structure for table `wal_mst_rewards_customer_referral_link`
--

CREATE TABLE `wal_mst_rewards_customer_referral_link` (
  `customer_referral_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Customer Referral Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer Id',
  `referral_link` varchar(50) NOT NULL COMMENT 'Referral Link',
  PRIMARY KEY (`customer_referral_id`),
  KEY `WAL_MST_REWARDS_CUSTOMER_REFERRAL_LINK_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `WAL_MST_REWARDS_CSTR_REFERRAL_LNK_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_customer_referral_link';

--
-- Dumping data for table `wal_mst_rewards_customer_referral_link`
--


--
-- Table structure for table `wal_mst_rewards_earning_rule`
--

CREATE TABLE `wal_mst_rewards_earning_rule` (
  `earning_rule_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Earning Rule Id',
  `name` varchar(255) NOT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `active_from` date DEFAULT NULL,
  `active_to` date DEFAULT NULL,
  `type` varchar(255) NOT NULL COMMENT 'Type',
  `conditions_serialized` text COMMENT 'Conditions Serialized',
  `actions_serialized` text COMMENT 'Actions Serialized',
  `earning_style` varchar(255) NOT NULL COMMENT 'Earning Style',
  `earn_points` int(11) DEFAULT NULL COMMENT 'Earn Points',
  `monetary_step` decimal(12,4) DEFAULT NULL COMMENT 'Monetary Step',
  `qty_step` int(11) DEFAULT NULL COMMENT 'Qty Step',
  `points_limit` int(11) DEFAULT NULL COMMENT 'Points Limit',
  `behavior_trigger` varchar(255) NOT NULL COMMENT 'Behavior Trigger',
  `sort_order` int(11) DEFAULT NULL COMMENT 'Sort Order',
  `is_stop_processing` int(11) NOT NULL DEFAULT '0' COMMENT 'Is Stop Processing',
  `is_show_on_product_page` int(11) NOT NULL COMMENT 'Is show on the product page',
  `param1` varchar(255) NOT NULL COMMENT 'Param1',
  `history_message` text COMMENT 'History Message',
  `email_message` text COMMENT 'Email Message',
  `product_notification` text NOT NULL COMMENT 'Product Notification',
  `transfer_to_group` smallint(5) unsigned DEFAULT NULL COMMENT 'Assign Customer to Group',
  `front_name` text COMMENT 'Front name',
  `tiers_serialized` text COMMENT 'Tier Settings',
  PRIMARY KEY (`earning_rule_id`),
  FULLTEXT KEY `Earning rule fulltext index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_earning_rule';

--
-- Dumping data for table `wal_mst_rewards_earning_rule`
--


--
-- Table structure for table `wal_mst_rewards_earning_rule_customer_group`
--

CREATE TABLE `wal_mst_rewards_earning_rule_customer_group` (
  `earning_rule_customer_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Earning Rule Customer Group Id',
  `customer_group_id` varchar(5) NOT NULL COMMENT 'Customer Group Id',
  `earning_rule_id` int(11) NOT NULL COMMENT 'Earning Rule Id',
  PRIMARY KEY (`earning_rule_customer_group_id`),
  KEY `WAL_MST_REWARDS_EARNING_RULE_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `WAL_MST_REWARDS_EARNING_RULE_CUSTOMER_GROUP_EARNING_RULE_ID` (`earning_rule_id`),
  CONSTRAINT `FK_5D649D821191EC4A98D956940B1AA460` FOREIGN KEY (`earning_rule_id`) REFERENCES `wal_mst_rewards_earning_rule` (`earning_rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_earning_rule_customer_group';

--
-- Dumping data for table `wal_mst_rewards_earning_rule_customer_group`
--


--
-- Table structure for table `wal_mst_rewards_earning_rule_product`
--

CREATE TABLE `wal_mst_rewards_earning_rule_product` (
  `earning_rule_product_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Earning Rule Product Id',
  `earning_rule_id` int(11) NOT NULL COMMENT 'Earning Rule Id',
  `er_product_id` int(10) unsigned NOT NULL COMMENT 'Er Product Id',
  `er_website_id` smallint(5) unsigned NOT NULL COMMENT 'Er Website Id',
  `er_customer_group_id` smallint(5) unsigned NOT NULL COMMENT 'Er Customer Group Id',
  PRIMARY KEY (`earning_rule_product_id`),
  KEY `WAL_MST_REWARDS_EARNING_RULE_PRODUCT_EARNING_RULE_ID` (`earning_rule_id`),
  KEY `WAL_MST_REWARDS_EARNING_RULE_PRODUCT_ER_PRODUCT_ID` (`er_product_id`),
  KEY `WAL_MST_REWARDS_EARNING_RULE_PRODUCT_ER_WEBSITE_ID` (`er_website_id`),
  KEY `WAL_MST_REWARDS_EARNING_RULE_PRODUCT_ER_CUSTOMER_GROUP_ID` (`er_customer_group_id`),
  CONSTRAINT `FK_B683735031B4D24C486655EF1B857120` FOREIGN KEY (`earning_rule_id`) REFERENCES `wal_mst_rewards_earning_rule` (`earning_rule_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MST_REWARDS_EARNING_RULE_PRD_ER_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`er_product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MST_REWARDS_EARNING_RULE_PRD_ER_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`er_website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_earning_rule_product';

--
-- Dumping data for table `wal_mst_rewards_earning_rule_product`
--


--
-- Table structure for table `wal_mst_rewards_earning_rule_queue`
--

CREATE TABLE `wal_mst_rewards_earning_rule_queue` (
  `queue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Queue Id',
  `customer_id` int(11) NOT NULL COMMENT 'Customer Id',
  `website_id` int(11) NOT NULL COMMENT 'Website Id',
  `rule_type` varchar(50) NOT NULL COMMENT 'Rule Type',
  `rule_code` text NOT NULL COMMENT 'Rule Code',
  `is_processed` int(11) NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`queue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_earning_rule_queue';

--
-- Dumping data for table `wal_mst_rewards_earning_rule_queue`
--


--
-- Table structure for table `wal_mst_rewards_earning_rule_website`
--

CREATE TABLE `wal_mst_rewards_earning_rule_website` (
  `earning_rule_website_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Earning Rule Website Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `earning_rule_id` int(11) NOT NULL COMMENT 'Earning Rule Id',
  PRIMARY KEY (`earning_rule_website_id`),
  KEY `WAL_MST_REWARDS_EARNING_RULE_WEBSITE_WEBSITE_ID` (`website_id`),
  KEY `WAL_MST_REWARDS_EARNING_RULE_WEBSITE_EARNING_RULE_ID` (`earning_rule_id`),
  CONSTRAINT `FK_BC79011A3366F346DAEF2AEECE2219EC` FOREIGN KEY (`earning_rule_id`) REFERENCES `wal_mst_rewards_earning_rule` (`earning_rule_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MST_REWARDS_EARNING_RULE_WS_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_earning_rule_website';

--
-- Dumping data for table `wal_mst_rewards_earning_rule_website`
--


--
-- Table structure for table `wal_mst_rewards_notification_rule`
--

CREATE TABLE `wal_mst_rewards_notification_rule` (
  `notification_rule_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Notification Rule Id',
  `name` varchar(255) NOT NULL COMMENT 'Name',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `active_from` date DEFAULT NULL,
  `active_to` date DEFAULT NULL,
  `conditions_serialized` text COMMENT 'Conditions Serialized',
  `actions_serialized` text COMMENT 'Actions Serialized',
  `sort_order` int(11) DEFAULT NULL COMMENT 'Sort Order',
  `is_stop_processing` int(11) NOT NULL DEFAULT '0' COMMENT 'Is Stop Processing',
  `type` varchar(255) NOT NULL COMMENT 'Type',
  `message` text COMMENT 'Message',
  PRIMARY KEY (`notification_rule_id`),
  FULLTEXT KEY `Notification rule fulltext index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_notification_rule';

--
-- Dumping data for table `wal_mst_rewards_notification_rule`
--


--
-- Table structure for table `wal_mst_rewards_notification_rule_customer_group`
--

CREATE TABLE `wal_mst_rewards_notification_rule_customer_group` (
  `notification_rule_customer_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Notification Rule Customer Group Id',
  `customer_group_id` varchar(5) NOT NULL COMMENT 'Customer Group Id',
  `notification_rule_id` int(11) NOT NULL COMMENT 'Notification Rule Id',
  PRIMARY KEY (`notification_rule_customer_group_id`),
  KEY `WAL_MST_REWARDS_NTFC_RULE_CSTR_GROUP_CSTR_GROUP_ID` (`customer_group_id`),
  KEY `WAL_MST_REWARDS_NTFC_RULE_CSTR_GROUP_NTFC_RULE_ID` (`notification_rule_id`),
  CONSTRAINT `FK_4EABFE26C85A919CB23481191AD50FE1` FOREIGN KEY (`notification_rule_id`) REFERENCES `wal_mst_rewards_notification_rule` (`notification_rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_notification_rule_customer_group';

--
-- Dumping data for table `wal_mst_rewards_notification_rule_customer_group`
--


--
-- Table structure for table `wal_mst_rewards_notification_rule_website`
--

CREATE TABLE `wal_mst_rewards_notification_rule_website` (
  `notification_rule_website_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Notification Rule Website Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `notification_rule_id` int(11) NOT NULL COMMENT 'Notification Rule Id',
  PRIMARY KEY (`notification_rule_website_id`),
  KEY `WAL_MST_REWARDS_NOTIFICATION_RULE_WEBSITE_WEBSITE_ID` (`website_id`),
  KEY `WAL_MST_REWARDS_NOTIFICATION_RULE_WEBSITE_NOTIFICATION_RULE_ID` (`notification_rule_id`),
  CONSTRAINT `FK_AB4CA5307FD57ACD1F5018C9F9E97E7F` FOREIGN KEY (`notification_rule_id`) REFERENCES `wal_mst_rewards_notification_rule` (`notification_rule_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MST_REWARDS_NTFC_RULE_WS_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_notification_rule_website';

--
-- Dumping data for table `wal_mst_rewards_notification_rule_website`
--


--
-- Table structure for table `wal_mst_rewards_points_aggregated_hour`
--

CREATE TABLE `wal_mst_rewards_points_aggregated_hour` (
  `period` datetime DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `customer_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Customer Id',
  `customer_group_id` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Customer Group Id',
  `order_earn` int(11) NOT NULL DEFAULT '0' COMMENT 'Earned points by order',
  `inactivity` int(11) NOT NULL DEFAULT '0' COMMENT 'Customer inactivity points',
  `send_link` int(11) NOT NULL DEFAULT '0' COMMENT 'Customer sends link',
  `order_earn_cancel` int(11) NOT NULL DEFAULT '0' COMMENT 'Canceled points',
  `expired_points` int(11) NOT NULL DEFAULT '0' COMMENT 'expired points',
  `order_refund` int(11) DEFAULT '0' COMMENT 'refunded',
  `order_spend` int(11) DEFAULT '0' COMMENT 'spent',
  `order_spend_restore` int(11) DEFAULT '0' COMMENT 'spend restore',
  `total_points_spent_in_money` int(11) DEFAULT '0' COMMENT 'total spent in money',
  `admin_transaction` int(11) DEFAULT '0' COMMENT 'added by admin',
  `facebook_like` int(11) DEFAULT '0' COMMENT 'like',
  `pinterest_pin` int(11) DEFAULT '0' COMMENT 'pin',
  `twitter_tweet` int(11) DEFAULT '0' COMMENT 'tweet',
  `create_rma` int(11) DEFAULT '0' COMMENT 'for RMA creation',
  `signup` int(11) DEFAULT '0' COMMENT 'signup',
  KEY `WAL_MST_REWARDS_POINTS_AGGREGATED_HOUR_CUSTOMER_GROUP_ID` (`period`,`store_id`,`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_points_aggregated_hour';

--
-- Dumping data for table `wal_mst_rewards_points_aggregated_hour`
--


--
-- Table structure for table `wal_mst_rewards_purchase`
--

CREATE TABLE `wal_mst_rewards_purchase` (
  `purchase_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Purchase Id',
  `quote_id` int(11) DEFAULT NULL COMMENT 'Quote Id',
  `order_id` int(11) DEFAULT NULL COMMENT 'Order Id',
  `spend_points` int(11) DEFAULT NULL COMMENT 'Spend Points',
  `base_spend_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Spend Amount',
  `spend_amount` decimal(12,4) DEFAULT NULL COMMENT 'Spend Amount',
  `spend_min_points` int(11) DEFAULT NULL COMMENT 'Spend Min Points',
  `spend_max_points` int(11) DEFAULT NULL COMMENT 'Spend Max Points',
  `earn_points` int(11) DEFAULT NULL COMMENT 'Earn Points',
  `lock_quote` timestamp NULL DEFAULT NULL COMMENT 'Prevent cheating with orders',
  `quote_product_ids` text COMMENT 'Applied discount',
  PRIMARY KEY (`purchase_id`),
  UNIQUE KEY `WAL_MST_REWARDS_PURCHASE_QUOTE_ID_ORDER_ID` (`quote_id`,`order_id`),
  UNIQUE KEY `WAL_MST_REWARDS_PURCHASE_ORDER_ID_QUOTE_ID` (`order_id`,`quote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_purchase';

--
-- Dumping data for table `wal_mst_rewards_purchase`
--

INSERT INTO `wal_mst_rewards_purchase` VALUES (1,5,NULL,0,0.0000,0.0000,0,0,NULL,NULL,NULL),(2,6,NULL,0,0.0000,0.0000,0,0,NULL,NULL,NULL),(3,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,8,NULL,0,0.0000,0.0000,0,0,NULL,NULL,NULL),(5,9,1,0,0.0000,0.0000,0,0,NULL,NULL,NULL),(6,13,NULL,0,0.0000,0.0000,0,0,NULL,NULL,NULL),(7,14,NULL,0,0.0000,0.0000,0,0,NULL,NULL,NULL),(8,15,NULL,0,0.0000,0.0000,0,0,NULL,NULL,NULL),(9,16,NULL,0,0.0000,0.0000,0,0,NULL,NULL,NULL);

--
-- Table structure for table `wal_mst_rewards_referral`
--

CREATE TABLE `wal_mst_rewards_referral` (
  `referral_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Referral Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer Id',
  `new_customer_id` int(10) unsigned DEFAULT NULL COMMENT 'New Customer Id',
  `email` varchar(255) NOT NULL COMMENT 'Email',
  `name` varchar(255) NOT NULL COMMENT 'Name',
  `status` varchar(255) NOT NULL COMMENT 'Status',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `last_transaction_id` int(11) DEFAULT NULL COMMENT 'Last Transaction Id',
  `points_amount` int(11) DEFAULT NULL COMMENT 'Points Amount',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `quote_id` int(11) DEFAULT NULL COMMENT 'Quote Id',
  PRIMARY KEY (`referral_id`),
  KEY `WAL_MST_REWARDS_REFERRAL_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_MST_REWARDS_REFERRAL_NEW_CUSTOMER_ID` (`new_customer_id`),
  KEY `WAL_MST_REWARDS_REFERRAL_STORE_ID` (`store_id`),
  KEY `WAL_MST_REWARDS_REFERRAL_LAST_TRANSACTION_ID` (`last_transaction_id`),
  CONSTRAINT `FK_11F651DD37BB0D8C3B142AD5AE3F4946` FOREIGN KEY (`last_transaction_id`) REFERENCES `wal_mst_rewards_transaction` (`transaction_id`) ON DELETE SET NULL,
  CONSTRAINT `WAL_MST_REWARDS_REFERRAL_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MST_REWARDS_REFERRAL_NEW_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`new_customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MST_REWARDS_REFERRAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_referral';

--
-- Dumping data for table `wal_mst_rewards_referral`
--


--
-- Table structure for table `wal_mst_rewards_refund`
--

CREATE TABLE `wal_mst_rewards_refund` (
  `refund_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Refund Id',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order Id',
  `invoice_id` int(10) unsigned NOT NULL COMMENT 'Invoice Id',
  `creditmemo_id` int(10) unsigned NOT NULL COMMENT 'Creditmemo Id',
  `refunded_points` int(10) unsigned NOT NULL COMMENT 'Refunded amount of points',
  `base_refunded` decimal(12,2) unsigned NOT NULL COMMENT 'Base refunded amount',
  `refunded` decimal(12,2) unsigned NOT NULL COMMENT 'Refunded amount',
  PRIMARY KEY (`refund_id`),
  KEY `WAL_MST_REWARDS_REFUND_ORDER_ID` (`order_id`),
  KEY `WAL_MST_REWARDS_REFUND_INVOICE_ID` (`invoice_id`),
  KEY `WAL_MST_REWARDS_REFUND_CREDITMEMO_ID` (`creditmemo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_refund';

--
-- Dumping data for table `wal_mst_rewards_refund`
--


--
-- Table structure for table `wal_mst_rewards_spending_rule`
--

CREATE TABLE `wal_mst_rewards_spending_rule` (
  `spending_rule_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Spending Rule Id',
  `name` varchar(255) NOT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `active_from` date DEFAULT NULL,
  `active_to` date DEFAULT NULL,
  `type` varchar(255) NOT NULL COMMENT 'Type',
  `conditions_serialized` text COMMENT 'Conditions Serialized',
  `actions_serialized` text COMMENT 'Actions Serialized',
  `spending_style` varchar(255) NOT NULL COMMENT 'Spending Style',
  `spend_points` int(11) DEFAULT NULL COMMENT 'Spend Points',
  `monetary_step` varchar(50) DEFAULT NULL COMMENT 'Monetary Step',
  `spend_min_points` varchar(255) NOT NULL COMMENT 'Spend Min Points',
  `spend_max_points` varchar(255) NOT NULL COMMENT 'Spend Max Points',
  `sort_order` int(11) DEFAULT NULL COMMENT 'Sort Order',
  `is_stop_processing` int(11) NOT NULL DEFAULT '0' COMMENT 'Is Stop Processing',
  `front_name` text COMMENT 'Front name',
  `tiers_serialized` text COMMENT 'Tier Settings',
  PRIMARY KEY (`spending_rule_id`),
  FULLTEXT KEY `Spending rule fulltext index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_spending_rule';

--
-- Dumping data for table `wal_mst_rewards_spending_rule`
--


--
-- Table structure for table `wal_mst_rewards_spending_rule_customer_group`
--

CREATE TABLE `wal_mst_rewards_spending_rule_customer_group` (
  `spending_rule_customer_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Spending Rule Customer Group Id',
  `customer_group_id` varchar(5) NOT NULL COMMENT 'Customer Group Id',
  `spending_rule_id` int(11) NOT NULL COMMENT 'Spending Rule Id',
  PRIMARY KEY (`spending_rule_customer_group_id`),
  KEY `WAL_MST_REWARDS_SPENDING_RULE_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `WAL_MST_REWARDS_SPENDING_RULE_CUSTOMER_GROUP_SPENDING_RULE_ID` (`spending_rule_id`),
  CONSTRAINT `FK_57E56B701C85804899A63C1B9B2FBE50` FOREIGN KEY (`spending_rule_id`) REFERENCES `wal_mst_rewards_spending_rule` (`spending_rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_spending_rule_customer_group';

--
-- Dumping data for table `wal_mst_rewards_spending_rule_customer_group`
--


--
-- Table structure for table `wal_mst_rewards_spending_rule_website`
--

CREATE TABLE `wal_mst_rewards_spending_rule_website` (
  `spending_rule_website_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Spending Rule Website Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `spending_rule_id` int(11) NOT NULL COMMENT 'Spending Rule Id',
  PRIMARY KEY (`spending_rule_website_id`),
  KEY `WAL_MST_REWARDS_SPENDING_RULE_WEBSITE_WEBSITE_ID` (`website_id`),
  KEY `WAL_MST_REWARDS_SPENDING_RULE_WEBSITE_SPENDING_RULE_ID` (`spending_rule_id`),
  CONSTRAINT `FK_B842A3CE57F7ECD63DC074850BFF7015` FOREIGN KEY (`spending_rule_id`) REFERENCES `wal_mst_rewards_spending_rule` (`spending_rule_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MST_REWARDS_SPENDING_RULE_WS_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_spending_rule_website';

--
-- Dumping data for table `wal_mst_rewards_spending_rule_website`
--


--
-- Table structure for table `wal_mst_rewards_tier`
--

CREATE TABLE `wal_mst_rewards_tier` (
  `tier_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tier ID',
  `name` text NOT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `is_active` int(10) unsigned DEFAULT '1' COMMENT 'Is Active',
  `min_earn_points` int(10) unsigned DEFAULT '0' COMMENT 'Minimum points number to reach the tier',
  `template_id` text COMMENT 'Email Template ID',
  `tier_logo` text COMMENT 'Tier Logo',
  PRIMARY KEY (`tier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_tier';

--
-- Dumping data for table `wal_mst_rewards_tier`
--

INSERT INTO `wal_mst_rewards_tier` VALUES (1,'[\"Beginner\"]',NULL,1,0,'[0]',NULL);

--
-- Table structure for table `wal_mst_rewards_tier_website`
--

CREATE TABLE `wal_mst_rewards_tier_website` (
  `tier_website_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tier_id` int(10) unsigned NOT NULL COMMENT 'Tier ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'WEbsite ID',
  PRIMARY KEY (`tier_website_id`),
  KEY `WAL_MST_REWARDS_TIER_WEBSITE_TIER_ID` (`tier_id`),
  KEY `WAL_MST_REWARDS_TIER_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `WAL_MST_REWARDS_TIER_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MST_REWARDS_TIER_WS_EARNING_RULE_ID_MST_REWARDS_TIER_TIER_ID` FOREIGN KEY (`tier_id`) REFERENCES `wal_mst_rewards_tier` (`tier_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_tier_website';

--
-- Dumping data for table `wal_mst_rewards_tier_website`
--

INSERT INTO `wal_mst_rewards_tier_website` VALUES (1,1,1);

--
-- Table structure for table `wal_mst_rewards_transaction`
--

CREATE TABLE `wal_mst_rewards_transaction` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Transaction Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer Id',
  `amount` int(11) DEFAULT NULL COMMENT 'Amount',
  `amount_used` int(11) DEFAULT NULL COMMENT 'Amount Used',
  `comment` text COMMENT 'Comment',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `is_expired` int(11) NOT NULL DEFAULT '0' COMMENT 'Is Expired',
  `is_expiration_email_sent` int(11) NOT NULL DEFAULT '0' COMMENT 'Is Expiration Email Sent',
  `expires_at` timestamp NULL DEFAULT NULL COMMENT 'Expires At',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `tier_id` int(11) DEFAULT NULL COMMENT 'Tier ID',
  `activated_at` timestamp NULL DEFAULT NULL COMMENT 'Date when transaction will be activated',
  `is_activated` int(11) NOT NULL DEFAULT '1' COMMENT 'Is transaction activated',
  PRIMARY KEY (`transaction_id`),
  KEY `WAL_MST_REWARDS_TRANSACTION_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `WAL_MST_REWARDS_TRANSACTION_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_mst_rewards_transaction';

--
-- Dumping data for table `wal_mst_rewards_transaction`
--


--
-- Table structure for table `wal_mview_state`
--

CREATE TABLE `wal_mview_state` (
  `state_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'View State ID',
  `view_id` varchar(255) DEFAULT NULL COMMENT 'View ID',
  `mode` varchar(16) DEFAULT 'disabled' COMMENT 'View Mode',
  `status` varchar(16) DEFAULT 'idle' COMMENT 'View Status',
  `updated` datetime DEFAULT NULL COMMENT 'View updated time',
  `version_id` int(10) unsigned DEFAULT NULL COMMENT 'View Version ID',
  PRIMARY KEY (`state_id`),
  KEY `WAL_MVIEW_STATE_VIEW_ID` (`view_id`),
  KEY `WAL_MVIEW_STATE_MODE` (`mode`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='View State';

--
-- Dumping data for table `wal_mview_state`
--

INSERT INTO `wal_mview_state` VALUES (3,'design_config_dummy','enabled','idle','2024-02-06 07:19:53',0),(4,'customer_dummy','enabled','idle','2024-02-06 07:19:53',0),(5,'catalog_category_product','enabled','idle','2024-02-06 07:19:54',3),(6,'catalog_product_category','enabled','idle','2024-02-06 07:19:54',7),(7,'catalogrule_rule','enabled','idle','2024-02-06 07:19:54',0),(8,'catalog_product_attribute','enabled','idle','2024-02-06 07:19:54',10),(9,'cataloginventory_stock','enabled','idle','2024-02-06 07:19:54',7),(10,'inventory','enabled','idle','2024-02-06 07:19:54',0),(11,'catalogrule_product','enabled','idle','2024-02-06 07:19:54',21),(12,'catalog_product_price','enabled','idle','2024-02-06 07:19:54',17),(13,'catalogsearch_fulltext','enabled','idle','2024-02-06 07:19:54',21),(14,'salesrule_rule','enabled','idle','2024-02-06 07:19:54',0),(15,'amasty_tabs_tab_product','enabled','idle','2024-02-06 07:19:54',0),(16,'amasty_tabs_product_tab','enabled','idle','2024-02-06 07:19:54',0),(17,'amasty_feed_entity','enabled','idle','2024-02-06 07:19:55',0),(18,'amasty_feed_product','enabled','idle','2024-02-06 07:19:55',0),(19,'amasty_sorting_bestseller','enabled','idle','2024-02-06 07:19:55',0),(20,'amasty_sorting_most_viewed','enabled','idle','2024-02-06 07:19:55',0),(21,'amasty_sorting_wished','enabled','idle','2024-02-06 07:19:55',0);

--
-- Table structure for table `wal_newsletter_problem`
--

CREATE TABLE `wal_newsletter_problem` (
  `problem_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Problem ID',
  `subscriber_id` int(10) unsigned DEFAULT NULL COMMENT 'Subscriber ID',
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue ID',
  `problem_error_code` int(10) unsigned DEFAULT '0' COMMENT 'Problem Error Code',
  `problem_error_text` varchar(200) DEFAULT NULL COMMENT 'Problem Error Text',
  PRIMARY KEY (`problem_id`),
  KEY `WAL_NEWSLETTER_PROBLEM_SUBSCRIBER_ID` (`subscriber_id`),
  KEY `WAL_NEWSLETTER_PROBLEM_QUEUE_ID` (`queue_id`),
  CONSTRAINT `FK_5C28E3EE459788395D1D0E7918BF6238` FOREIGN KEY (`subscriber_id`) REFERENCES `wal_newsletter_subscriber` (`subscriber_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_NEWSLETTER_PROBLEM_QUEUE_ID_WAL_NEWSLETTER_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `wal_newsletter_queue` (`queue_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Problems';

--
-- Dumping data for table `wal_newsletter_problem`
--


--
-- Table structure for table `wal_newsletter_queue`
--

CREATE TABLE `wal_newsletter_queue` (
  `queue_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue ID',
  `template_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Template ID',
  `newsletter_type` int(11) DEFAULT NULL COMMENT 'Newsletter Type',
  `newsletter_text` text COMMENT 'Newsletter Text',
  `newsletter_styles` text COMMENT 'Newsletter Styles',
  `newsletter_subject` varchar(200) DEFAULT NULL COMMENT 'Newsletter Subject',
  `newsletter_sender_name` varchar(200) DEFAULT NULL COMMENT 'Newsletter Sender Name',
  `newsletter_sender_email` varchar(200) DEFAULT NULL COMMENT 'Newsletter Sender Email',
  `queue_status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Status',
  `queue_start_at` timestamp NULL DEFAULT NULL COMMENT 'Queue Start At',
  `queue_finish_at` timestamp NULL DEFAULT NULL COMMENT 'Queue Finish At',
  PRIMARY KEY (`queue_id`),
  KEY `WAL_NEWSLETTER_QUEUE_TEMPLATE_ID` (`template_id`),
  CONSTRAINT `WAL_NLTTR_QUEUE_TEMPLATE_ID_WAL_NLTTR_TEMPLATE_TEMPLATE_ID` FOREIGN KEY (`template_id`) REFERENCES `wal_newsletter_template` (`template_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue';

--
-- Dumping data for table `wal_newsletter_queue`
--


--
-- Table structure for table `wal_newsletter_queue_link`
--

CREATE TABLE `wal_newsletter_queue_link` (
  `queue_link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue Link ID',
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue ID',
  `subscriber_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Subscriber ID',
  `letter_sent_at` timestamp NULL DEFAULT NULL COMMENT 'Letter Sent At',
  PRIMARY KEY (`queue_link_id`),
  KEY `WAL_NEWSLETTER_QUEUE_LINK_SUBSCRIBER_ID` (`subscriber_id`),
  KEY `WAL_NEWSLETTER_QUEUE_LINK_QUEUE_ID_LETTER_SENT_AT` (`queue_id`,`letter_sent_at`),
  CONSTRAINT `FK_3382EBEE704A7F2541359C5AFB7F129A` FOREIGN KEY (`subscriber_id`) REFERENCES `wal_newsletter_subscriber` (`subscriber_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_NEWSLETTER_QUEUE_LINK_QUEUE_ID_WAL_NEWSLETTER_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `wal_newsletter_queue` (`queue_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue Link';

--
-- Dumping data for table `wal_newsletter_queue_link`
--


--
-- Table structure for table `wal_newsletter_queue_store_link`
--

CREATE TABLE `wal_newsletter_queue_store_link` (
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`queue_id`,`store_id`),
  KEY `WAL_NEWSLETTER_QUEUE_STORE_LINK_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_NEWSLETTER_QUEUE_STORE_LINK_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_NLTTR_QUEUE_STORE_LNK_QUEUE_ID_WAL_NLTTR_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `wal_newsletter_queue` (`queue_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue Store Link';

--
-- Dumping data for table `wal_newsletter_queue_store_link`
--


--
-- Table structure for table `wal_newsletter_subscriber`
--

CREATE TABLE `wal_newsletter_subscriber` (
  `subscriber_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Subscriber ID',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store ID',
  `change_status_at` timestamp NULL DEFAULT NULL COMMENT 'Change Status At',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `subscriber_email` varchar(150) DEFAULT NULL COMMENT 'Subscriber Email',
  `subscriber_status` int(11) NOT NULL DEFAULT '0' COMMENT 'Subscriber Status',
  `subscriber_confirm_code` varchar(32) DEFAULT 'NULL' COMMENT 'Subscriber Confirm Code',
  PRIMARY KEY (`subscriber_id`),
  KEY `WAL_NEWSLETTER_SUBSCRIBER_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_NEWSLETTER_SUBSCRIBER_STORE_ID` (`store_id`),
  KEY `WAL_NEWSLETTER_SUBSCRIBER_SUBSCRIBER_EMAIL` (`subscriber_email`),
  CONSTRAINT `WAL_NEWSLETTER_SUBSCRIBER_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Subscriber';

--
-- Dumping data for table `wal_newsletter_subscriber`
--


--
-- Table structure for table `wal_newsletter_template`
--

CREATE TABLE `wal_newsletter_template` (
  `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Template ID',
  `template_code` varchar(150) DEFAULT NULL COMMENT 'Template Code',
  `template_text` text COMMENT 'Template Text',
  `template_styles` text COMMENT 'Template Styles',
  `template_type` int(10) unsigned DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) DEFAULT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) DEFAULT NULL COMMENT 'Template Sender Email',
  `template_actual` smallint(5) unsigned DEFAULT '1' COMMENT 'Template Actual',
  `added_at` timestamp NULL DEFAULT NULL COMMENT 'Added At',
  `modified_at` timestamp NULL DEFAULT NULL COMMENT 'Modified At',
  `is_legacy` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Should the template render in legacy mode',
  PRIMARY KEY (`template_id`),
  KEY `WAL_NEWSLETTER_TEMPLATE_TEMPLATE_ACTUAL` (`template_actual`),
  KEY `WAL_NEWSLETTER_TEMPLATE_ADDED_AT` (`added_at`),
  KEY `WAL_NEWSLETTER_TEMPLATE_MODIFIED_AT` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Template';

--
-- Dumping data for table `wal_newsletter_template`
--


--
-- Table structure for table `wal_oauth_consumer`
--

CREATE TABLE `wal_oauth_consumer` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `name` varchar(255) NOT NULL COMMENT 'Name of consumer',
  `key` varchar(32) NOT NULL COMMENT 'Key code',
  `secret` varchar(128) NOT NULL COMMENT 'Secret code',
  `callback_url` text COMMENT 'Callback URL',
  `rejected_callback_url` text NOT NULL COMMENT 'Rejected callback URL',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_OAUTH_CONSUMER_KEY` (`key`),
  UNIQUE KEY `WAL_OAUTH_CONSUMER_SECRET` (`secret`),
  KEY `WAL_OAUTH_CONSUMER_CREATED_AT` (`created_at`),
  KEY `WAL_OAUTH_CONSUMER_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='OAuth Consumers';

--
-- Dumping data for table `wal_oauth_consumer`
--

INSERT INTO `wal_oauth_consumer` VALUES (1,'2020-06-08 08:00:07','2022-04-25 08:14:14','Integration1','yyw7t4s0mu6r4c74e7p8zgkcxnjdw2o4','0:3:PVPsKJRFWXRLVJqxhWRrnMgQ1yVhq+iaMvpC++dVEOmD7o7vnsXu+86Ml+Pnaj58Y2tP0+8CvGm4C0Xf',NULL,'');

--
-- Table structure for table `wal_oauth_nonce`
--

CREATE TABLE `wal_oauth_nonce` (
  `nonce` varchar(32) NOT NULL COMMENT 'Nonce String',
  `timestamp` int(10) unsigned NOT NULL COMMENT 'Nonce Timestamp',
  `consumer_id` int(10) unsigned NOT NULL COMMENT 'Consumer ID',
  PRIMARY KEY (`nonce`,`consumer_id`),
  KEY `WAL_OAUTH_NONCE_CONSUMER_ID_WAL_OAUTH_CONSUMER_ENTITY_ID` (`consumer_id`),
  KEY `WAL_OAUTH_NONCE_TIMESTAMP` (`timestamp`),
  CONSTRAINT `WAL_OAUTH_NONCE_CONSUMER_ID_WAL_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `wal_oauth_consumer` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Nonce';

--
-- Dumping data for table `wal_oauth_nonce`
--


--
-- Table structure for table `wal_oauth_token`
--

CREATE TABLE `wal_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 `WAL_OAUTH_TOKEN_TOKEN` (`token`),
  KEY `WAL_OAUTH_TOKEN_ADMIN_ID_WAL_ADMIN_USER_USER_ID` (`admin_id`),
  KEY `WAL_OAUTH_TOKEN_CUSTOMER_ID_WAL_CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
  KEY `WAL_OAUTH_TOKEN_CONSUMER_ID` (`consumer_id`),
  CONSTRAINT `WAL_OAUTH_TOKEN_ADMIN_ID_WAL_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`) REFERENCES `wal_admin_user` (`user_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_OAUTH_TOKEN_CONSUMER_ID_WAL_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `wal_oauth_consumer` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_OAUTH_TOKEN_CUSTOMER_ID_WAL_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='OAuth Tokens';

--
-- Dumping data for table `wal_oauth_token`
--

INSERT INTO `wal_oauth_token` VALUES (1,1,NULL,NULL,'access','hkmdiobik6z3s8c59ypguh5x5ie1ue09','0:3:kFDQwiduHGhbDVbB+vndaBZd+a6DDKBvYmCxxunSxY/0pQC8nVM0VRCyizl9nQZErH7WXjJeps9oKN7U','y4jxnwr6xhm552i0opajafe5vugb33em','oob',0,0,1,'2020-06-08 08:00:08');

--
-- Table structure for table `wal_oauth_token_request_log`
--

CREATE TABLE `wal_oauth_token_request_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `user_name` varchar(255) NOT NULL COMMENT 'Customer email or admin login',
  `user_type` smallint(5) unsigned NOT NULL COMMENT 'User type (admin or customer)',
  `failures_count` smallint(5) unsigned DEFAULT '0' COMMENT 'Number of failed authentication attempts in a row',
  `lock_expires_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Lock expiration time',
  PRIMARY KEY (`log_id`),
  UNIQUE KEY `WAL_OAUTH_TOKEN_REQUEST_LOG_USER_NAME_USER_TYPE` (`user_name`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log of token request authentication failures.';

--
-- Dumping data for table `wal_oauth_token_request_log`
--


--
-- Table structure for table `wal_pagebuilder_template`
--

CREATE TABLE `wal_pagebuilder_template` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Template ID Auto Increment',
  `name` varchar(1024) NOT NULL COMMENT 'Template Name',
  `preview_image` varchar(1024) DEFAULT NULL COMMENT 'Template Preview Image',
  `template` longtext NOT NULL COMMENT 'Master Format HTML',
  `created_for` varchar(255) DEFAULT NULL COMMENT 'Created For',
  `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 (`template_id`),
  FULLTEXT KEY `WAL_PAGEBUILDER_TEMPLATE_NAME` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Page Builder Templates';

--
-- Dumping data for table `wal_pagebuilder_template`
--


--
-- Table structure for table `wal_password_reset_request_event`
--

CREATE TABLE `wal_password_reset_request_event` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `request_type` smallint(5) unsigned NOT NULL COMMENT 'Type of the event under a security control',
  `account_reference` varchar(255) DEFAULT NULL COMMENT 'An identifier for existing account or another target',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp when the event occurs',
  `ip` varchar(15) NOT NULL COMMENT 'Remote user IP',
  PRIMARY KEY (`id`),
  KEY `WAL_PASSWORD_RESET_REQUEST_EVENT_ACCOUNT_REFERENCE` (`account_reference`),
  KEY `WAL_PASSWORD_RESET_REQUEST_EVENT_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Password Reset Request Event under a security control';

--
-- Dumping data for table `wal_password_reset_request_event`
--


--
-- Table structure for table `wal_patch_list`
--

CREATE TABLE `wal_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=265 DEFAULT CHARSET=utf8 COMMENT='List of data/schema patches';

--
-- Dumping data for table `wal_patch_list`
--

INSERT INTO `wal_patch_list` VALUES (1,'Magento\\Store\\Setup\\Patch\\Schema\\InitializeStoresAndWebsites'),(2,'Magento\\Catalog\\Setup\\Patch\\Schema\\EnableSegmentation'),(3,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\CreateLegacyStockStatusView'),(4,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\InitializeDefaultStock'),(5,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\UpdateInventorySourceItem'),(6,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\ReindexDefaultSource'),(7,'Magento\\Store\\Setup\\Patch\\Schema\\InitializeStoresAndWebsites'),(8,'Magento\\InventorySales\\Setup\\Patch\\Schema\\InitializeWebsiteDefaultSock'),(9,'Magento\\Wishlist\\Setup\\Patch\\Schema\\AddProductIdConstraint'),(10,'Magento\\Bundle\\Setup\\Patch\\Schema\\UpdateBundleRelatedSchema'),(11,'Magento\\Store\\Setup\\Patch\\Data\\UpdateStoreGroupCodes'),(12,'Magento\\Directory\\Setup\\Patch\\Data\\InitializeDirectoryData'),(13,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForCroatia'),(14,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForIndia'),(15,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForAustralia'),(16,'Magento\\Theme\\Setup\\Patch\\Data\\RegisterThemes'),(17,'Magento\\Theme\\Setup\\Patch\\Data\\ConvertSerializedData'),(18,'Magento\\Eav\\Setup\\Patch\\Data\\InitializeAttributeModels'),(19,'Magento\\Config\\Setup\\Patch\\Data\\UpdateClassAliases'),(20,'Magento\\Indexer\\Setup\\Patch\\Data\\InitializeIndexerState'),(21,'Magento\\User\\Setup\\Patch\\Data\\UpgradePasswordHashes'),(22,'Magento\\User\\Setup\\Patch\\Data\\UpgradeSerializedFields'),(23,'Magento\\Authorization\\Setup\\Patch\\Data\\InitializeAuthRoles'),(24,'Magento\\Customer\\Setup\\Patch\\Data\\DefaultCustomerGroupsAndAttributes'),(25,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAttributesMetadata'),(26,'Magento\\Customer\\Setup\\Patch\\Data\\AddNonSpecifiedGenderAttributeOption'),(27,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateIdentifierCustomerAttributesVisibility'),(28,'Magento\\Customer\\Setup\\Patch\\Data\\AddCustomerUpdatedAtAttribute'),(29,'Magento\\Customer\\Setup\\Patch\\Data\\UpgradePasswordHashAndAddress'),(30,'Magento\\Customer\\Setup\\Patch\\Data\\RemoveCheckoutRegisterAndUpdateAttributes'),(31,'Magento\\Customer\\Setup\\Patch\\Data\\AddSecurityTrackingAttributes'),(32,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateAutocompleteOnStorefrontConfigPath'),(33,'Magento\\Customer\\Setup\\Patch\\Data\\MigrateStoresAllowedCountriesToWebsite'),(34,'Magento\\Customer\\Setup\\Patch\\Data\\ConvertValidationRulesFromSerializedToJson'),(35,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateVATNumber'),(36,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAttributeInputFilters'),(37,'Magento\\Cms\\Setup\\Patch\\Data\\CreateDefaultPages'),(38,'Magento\\Cms\\Setup\\Patch\\Data\\UpdatePrivacyPolicyPage'),(39,'Magento\\Cms\\Setup\\Patch\\Data\\ConvertWidgetConditionsToJson'),(40,'Magento\\Quote\\Setup\\Patch\\Data\\InstallEntityTypes'),(41,'Magento\\Quote\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(42,'Magento\\Catalog\\Setup\\Patch\\Data\\InstallDefaultCategories'),(43,'Magento\\Catalog\\Setup\\Patch\\Data\\SetNewResourceModelsPaths'),(44,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateDefaultAttributeValue'),(45,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateMediaAttributesBackendTypes'),(46,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductAttributes'),(47,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductMetaDescription'),(48,'Magento\\Catalog\\Setup\\Patch\\Data\\ChangePriceAttributeDefaultScope'),(49,'Magento\\Catalog\\Setup\\Patch\\Data\\DisallowUsingHtmlForProductName'),(50,'Magento\\Catalog\\Setup\\Patch\\Data\\EnableDirectiveParsing'),(51,'Magento\\Catalog\\Setup\\Patch\\Data\\EnableSegmentation'),(52,'Magento\\Catalog\\Setup\\Patch\\Data\\UpgradeWidgetData'),(53,'Magento\\Catalog\\Setup\\Patch\\Data\\UpgradeWebsiteAttributes'),(54,'Magento\\CatalogRule\\Setup\\Patch\\Data\\UpdateClassAliasesForCatalogRules'),(55,'Magento\\CatalogRule\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(56,'Magento\\Integration\\Setup\\Patch\\Data\\RemoveInactiveTokens'),(57,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\CreateDefaultStock'),(58,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\UpdateStockItemsWebsite'),(59,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(60,'Magento\\Msrp\\Setup\\Patch\\Data\\InitializeMsrpAttributes'),(61,'Magento\\Msrp\\Setup\\Patch\\Data\\ChangePriceAttributeDefaultScope'),(62,'Magento\\CatalogSearch\\Setup\\Patch\\Data\\MySQLSearchDeprecationNotification'),(63,'Magento\\CatalogSearch\\Setup\\Patch\\Data\\SetInitialSearchWeightForAttributes'),(64,'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\CreateUrlAttributes'),(65,'Magento\\Widget\\Setup\\Patch\\Data\\UpgradeModelInstanceClassAliases'),(66,'Magento\\Widget\\Setup\\Patch\\Data\\ConvertSerializedData'),(67,'Magento\\Sales\\Setup\\Patch\\Data\\InstallOrderStatusesAndInitialSalesConfig'),(68,'Magento\\Sales\\Setup\\Patch\\Data\\UpdateEntityTypes'),(69,'Magento\\Sales\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(70,'Magento\\Sales\\Setup\\Patch\\Data\\FillQuoteAddressIdInSalesOrderAddress'),(71,'Magento\\Sales\\Setup\\Patch\\Data\\UpdateEntityTypeModelForInvoice'),(72,'Magento\\Checkout\\Setup\\Patch\\Data\\PrepareInitialCheckoutConfiguration'),(73,'Magento\\Vault\\Setup\\Patch\\Data\\SetCreditCardAsDefaultTokenType'),(74,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\InstallInitialConfigurableAttributes'),(75,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\UpdateManufacturerAttribute'),(76,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\UpdateTierPriceAttribute'),(77,'Magento\\CurrencySymbol\\Setup\\Patch\\Data\\ConvertSerializedCustomCurrencySymbolToJson'),(78,'Magento\\Paypal\\Setup\\Patch\\Data\\AddPaypalOrderStatuses'),(79,'Magento\\Paypal\\Setup\\Patch\\Data\\UpdatePaypalCreditOption'),(80,'Magento\\Analytics\\Setup\\Patch\\Data\\PrepareInitialConfig'),(81,'Magento\\Dhl\\Setup\\Patch\\Data\\PrepareShipmentDays'),(82,'Magento\\Downloadable\\Setup\\Patch\\Data\\InstallDownloadableAttributes'),(83,'Magento\\Downloadable\\Setup\\Patch\\Data\\UpdateLinksExistDefaultAttributeValue'),(84,'Magento\\EncryptionKey\\Setup\\Patch\\Data\\SodiumChachaPatch'),(85,'Magento\\Fedex\\Setup\\Patch\\Data\\ConfigureFedexDefaults'),(86,'Magento\\GiftMessage\\Setup\\Patch\\Data\\AddGiftMessageAttributes'),(87,'Magento\\GiftMessage\\Setup\\Patch\\Data\\MoveGiftMessageToGiftOptionsGroup'),(88,'Magento\\GiftMessage\\Setup\\Patch\\Data\\UpdateGiftMessageAttribute'),(89,'Magento\\GroupedProduct\\Setup\\Patch\\Data\\InitializeGroupedProductLinks'),(90,'Magento\\GroupedProduct\\Setup\\Patch\\Data\\UpdateProductRelations'),(91,'Magento\\AuthorizenetAcceptjs\\Setup\\Patch\\Data\\CopyCurrentConfig'),(92,'Magento\\InventoryLowQuantityNotification\\Setup\\Patch\\Data\\MigrateCatalogInventoryNotifyStockQuantityData'),(93,'Magento\\SalesRule\\Setup\\Patch\\Data\\PrepareRuleModelSerializedData'),(94,'Magento\\SalesRule\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(95,'Magento\\SalesRule\\Setup\\Patch\\Data\\FillSalesRuleProductAttributeTable'),(96,'Magento\\Braintree\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(97,'Magento\\Reports\\Setup\\Patch\\Data\\InitializeReportEntityTypesAndPages'),(98,'Magento\\Review\\Setup\\Patch\\Data\\InitReviewStatusesAndData'),(99,'Magento\\OfflineShipping\\Setup\\Patch\\Data\\UpdateQuoteShippingAddresses'),(100,'Magento\\OfflineShipping\\Setup\\Patch\\Data\\UpdateShippingTablerate'),(101,'Magento\\UrlRewrite\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(102,'Magento\\Wishlist\\Setup\\Patch\\Data\\ConvertSerializedData'),(103,'Magento\\Swatches\\Setup\\Patch\\Data\\AddSwatchImageAttribute'),(104,'Magento\\Swatches\\Setup\\Patch\\Data\\AddSwatchImageToDefaultAttribtueSet'),(105,'Magento\\Swatches\\Setup\\Patch\\Data\\UpdateAdminTextSwatchValues'),(106,'Magento\\Swatches\\Setup\\Patch\\Data\\ConvertAdditionalDataToJson'),(107,'Magento\\Tax\\Setup\\Patch\\Data\\AddTaxAttributeAndTaxClasses'),(108,'Magento\\Tax\\Setup\\Patch\\Data\\UpdateTaxClassAttributeVisibility'),(109,'Magento\\Tax\\Setup\\Patch\\Data\\UpdateTaxRegionId'),(110,'Magento\\SampleData\\Setup\\Patch\\Data\\ClearSampleDataState'),(111,'Magento\\Usps\\Setup\\Patch\\Data\\UpdateAllowedMethods'),(112,'Magento\\Bundle\\Setup\\Patch\\Data\\ApplyAttributesUpdate'),(113,'Magento\\Bundle\\Setup\\Patch\\Data\\UpdateBundleRelatedEntityTypes'),(114,'Magento\\Weee\\Setup\\Patch\\Data\\InitQuoteAndOrderAttributes'),(115,'Temando\\ShippingRemover\\Setup\\Patch\\Schema\\EmptyTablesRemoval'),(116,'Magento\\Store\\Setup\\Patch\\Data\\DisableSid'),(117,'Magento\\Directory\\Setup\\Patch\\Data\\AddCountriesCaribbeanCuracaoKosovoSintMaarten'),(118,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForBelgium'),(119,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForChina'),(120,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForColombia'),(121,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForMexico'),(122,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForPoland'),(123,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateCustomLayoutAttributes'),(124,'Magento\\Msrp\\Setup\\Patch\\Data\\ChangeMsrpAttributeLabel'),(125,'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\UpdateUrlKeySearchable'),(126,'Magento\\Downloadable\\Setup\\Patch\\Data\\AddDownloadableHostsConfig'),(127,'Magento\\Email\\Setup\\Patch\\Data\\FlagLegacyTemplates'),(128,'Magento\\Analytics\\Setup\\Patch\\Data\\ActivateDataCollection'),(129,'Magento\\Reports\\Setup\\Patch\\Data\\ReportDisableNotification'),(130,'Magento\\Newsletter\\Setup\\Patch\\Data\\FlagLegacyTemplates'),(131,'Temando\\ShippingRemover\\Setup\\Patch\\Data\\AttributesRemoval'),(132,'Temando\\ShippingRemover\\Setup\\Patch\\Data\\BookmarkCleaner'),(133,'Temando\\ShippingRemover\\Setup\\Patch\\Data\\ConfigRemoval'),(134,'Magento\\Quote\\Setup\\Patch\\Data\\WishlistDataCleanUp'),(135,'Magento\\Sales\\Setup\\Patch\\Data\\WishlistDataCleanUp'),(136,'Magento\\Wishlist\\Setup\\Patch\\Data\\WishlistDataCleanUp'),(137,'Magento\\CustomerSegment\\Setup\\Patch\\Data\\AddCustomerSegmentAttributes'),(138,'Magento\\CustomerSegment\\Setup\\Patch\\Data\\ConvertDataFromSerializedToJson'),(139,'Magento\\CustomerSegment\\Setup\\Patch\\Data\\UpdateSegmentConditionSql'),(140,'Magento\\GiftCard\\Setup\\Patch\\Data\\AddGifcardAttributes'),(141,'Magento\\GiftCard\\Setup\\Patch\\Data\\UpdateGifcardAttributes'),(142,'Magento\\GiftCardAccount\\Setup\\Patch\\Data\\ConvertFromSerializedToJson'),(143,'Magento\\Logging\\Setup\\Patch\\Data\\ConvertDataSerializedToJson'),(144,'Magento\\CatalogEvent\\Setup\\Patch\\Data\\EventsListenerCmsBlock'),(145,'Magento\\CatalogEvent\\Setup\\Patch\\Data\\UpdateCatalogEventsStatus'),(146,'Magento\\Reminder\\Setup\\Patch\\Data\\AddReminderAttributes'),(147,'Magento\\Reminder\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(148,'Magento\\Reward\\Setup\\Patch\\Data\\AddRewardAttributes'),(149,'Magento\\Reward\\Setup\\Patch\\Data\\ConvertDataSerializedToJson'),(150,'Magento\\VisualMerchandiser\\Setup\\Patch\\Data\\CreateAutosortAttribute'),(151,'Magento\\VisualMerchandiser\\Setup\\Patch\\Data\\UpdateRulesWithSourceAttributes'),(152,'Magento\\GiftRegistry\\Setup\\Patch\\Data\\AddGiftRegistryAttributes'),(153,'Magento\\GiftRegistry\\Setup\\Patch\\Data\\ConvertFromSerializedToJson'),(154,'Magento\\GiftRegistry\\Setup\\Patch\\Data\\GiftRegistryPersonTableConvertation'),(155,'Magento\\Review\\Setup\\Patch\\Schema\\AddUniqueConstraintToReviewEntitySummary'),(156,'Magento\\TwoFactorAuth\\Setup\\Patch\\Schema\\CopyTablesFromOldModule'),(157,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForAlbania'),(158,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForArgentina'),(159,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForBolivia'),(160,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForBulgaria'),(161,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForChile'),(162,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForDenmark'),(163,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForEcuador'),(164,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForGreece'),(165,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForGuyana'),(166,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForIceland'),(167,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForItaly'),(168,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForParaguay'),(169,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForPeru'),(170,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForPortugal'),(171,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForSuriname'),(172,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForSweden'),(173,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForUruguay'),(174,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForVenezuela'),(175,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAddressAttributesSortOrder'),(176,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateDefaultCustomerGroupInConfig'),(177,'Magento\\Config\\Setup\\Patch\\Data\\UnsetTinymce3'),(178,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductDescriptionOrder'),(179,'Magento\\CatalogSearch\\Setup\\Patch\\Data\\MySQLSearchRemovalNotification'),(180,'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\UpdateUrlKeyForProducts'),(181,'Magento\\MediaGalleryUi\\Setup\\Patch\\Data\\AddMediaGalleryPermissions'),(182,'Magento\\PageBuilder\\Setup\\Patch\\Data\\UpdateProductAttribute'),(183,'Magento\\PageBuilder\\Setup\\Patch\\Data\\UpgradePageBuilderStripStyles'),(184,'Magento\\Paypal\\Setup\\Patch\\Data\\UpdateBmltoPayLater'),(185,'Magento\\Paypal\\Setup\\Patch\\Data\\UpdateSmartButtonLabel'),(186,'Magento\\Paypal\\Setup\\Patch\\Data\\UpdateSmartButtonSize'),(187,'Magento\\ReCaptchaMigration\\Setup\\Patch\\Data\\MigrateConfigToRecaptchaModules'),(188,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\CopyConfigFromOldModule'),(189,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\EncryptConfiguration'),(190,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\EncryptGoogleSecrets'),(191,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\EncryptSecrets'),(192,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\GenerateDuoSecurityKey'),(193,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\PopulateCountryTable'),(194,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\ResetU2fConfig'),(195,'Vertex\\RequestLogging\\Setup\\Patch\\Data\\UpdateCronConfiguration'),(196,'Magento\\Elasticsearch\\Setup\\Patch\\Data\\InvalidateIndex'),(197,'Magento\\GiftRegistry\\Setup\\Patch\\Data\\WishlistDataCleanUp'),(198,'Magento\\Customer\\Setup\\Patch\\Data\\SessionIDColumnCleanUp'),(199,'Magento\\Security\\Setup\\Patch\\Data\\SessionIDColumnCleanUp'),(200,'Amasty\\PageSpeedOptimizer\\Setup\\Patch\\Data\\UpdateTo190'),(201,'Amasty\\ShopbyBase\\Setup\\Patch\\Schema\\AddOptionsCmsBlockReference'),(202,'Amasty\\Shopby\\Setup\\Patch\\Data\\RemoveCmsDuplicates'),(203,'Amasty\\Shopby\\Setup\\Patch\\Schema\\AddCmsPageUniqueKey'),(204,'Amasty\\Shopby\\Setup\\Patch\\Schema\\AddCmsPageReference'),(205,'Amasty\\ShopbyPage\\Setup\\Patch\\Schema\\AddPageCmsBlockReference'),(206,'Amasty\\ShopbyBase\\Setup\\Patch\\Data\\AnchorRootCategories'),(207,'Amasty\\Shopby\\Setup\\Patch\\Data\\AddCategoryExcludeFromFilter'),(208,'Amasty\\Shopby\\Setup\\Patch\\Data\\AddCategoryThumbnail'),(209,'Amasty\\Shopby\\Setup\\Patch\\Data\\DeployPub'),(210,'Amasty\\Shopby\\Setup\\Patch\\Data\\DisableShopbyLite'),(211,'Amasty\\Shopby\\Setup\\Patch\\Data\\DisableShopbyRoot'),(212,'Amasty\\Shopby\\Setup\\Patch\\Data\\MigrateSubmitFilters'),(213,'Amasty\\ShopbyBrand\\Setup\\Patch\\Data\\BrandAttributeIcon'),(214,'Amasty\\ShopbyBrand\\Setup\\Patch\\Data\\CreateAllBrandsCmsPage'),(215,'Amasty\\ShopbyBrand\\Setup\\Patch\\Data\\DropStoreSpecificBrandAttributeSettings'),(216,'Amasty\\ShopbyBrand\\Setup\\Patch\\Data\\ReplaceProductListingSetting'),(217,'Amasty\\ShopbyBrand\\Setup\\Patch\\Data\\UpdateBrandOptions'),(218,'Amasty\\ShopbySeo\\Setup\\Patch\\Data\\UpgradeCharConfig'),(219,'Amasty\\FacebookPixel\\Setup\\Patch\\Data\\MigrateSettings'),(220,'Amasty\\SeoRichData\\Setup\\Patch\\Data\\AddOfferConditionAttribute'),(221,'Magento\\Banner\\Setup\\Patch\\Data\\BannerContentInitializer'),(222,'Magento\\Banner\\Setup\\Patch\\Data\\ChangeSerializationForBanner'),(223,'Afterpay\\Afterpay\\Setup\\Patch\\Data\\AdaptPayments'),(224,'StripeIntegration\\Payments\\Setup\\Patch\\Data\\InitialInstall'),(225,'StripeIntegration\\Payments\\Setup\\Patch\\Data\\Patch001WebhooksConfiguration'),(226,'Magento\\Integration\\Setup\\Patch\\Data\\UpgradeConsumerSecret'),(227,'Magento\\Integration\\Setup\\Patch\\Data\\UpgradeOauthToken'),(228,'Amasty\\InvisibleCaptcha\\Setup\\Patch\\Data\\EncryptSecretKeys'),(229,'Mirasvit\\Report\\Setup\\Patch\\Schema\\AddSalesTableIndexes'),(230,'Mirasvit\\Affiliate\\Setup\\Patch\\Data\\DataPatch100'),(231,'Mirasvit\\Affiliate\\Setup\\Patch\\Data\\DataPatch1010'),(232,'Mirasvit\\Affiliate\\Setup\\Patch\\Data\\DataPatch1013'),(233,'Mirasvit\\Core\\Setup\\Patch\\Data\\IncludeFontAwesome'),(234,'Amasty\\Base\\Setup\\Patch\\Data\\MoveSystemValuesToFlags'),(235,'Amasty\\Base\\Setup\\Patch\\Data\\UpdateResourceConfigPatch'),(236,'MageWorx\\OptionBase\\Setup\\Patch\\Schema\\DropTrigger'),(237,'MageWorx\\OptionBase\\Setup\\Patch\\Schema\\InstallForeignKey'),(238,'MageWorx\\OptionBase\\Setup\\Patch\\Schema\\RenameProductAttributesTable'),(239,'MageWorx\\OptionBase\\Setup\\Patch\\Schema\\SortTableColumns'),(240,'MageWorx\\OptionFeatures\\Setup\\Patch\\Schema\\SortTableColumns'),(241,'MageWorx\\OptionDependency\\Setup\\Patch\\Schema\\InstallForeignKey'),(242,'MageWorx\\OptionDependency\\Setup\\Patch\\Schema\\InstallOldColumns'),(243,'MageWorx\\OptionDependency\\Setup\\Patch\\Data\\ConvertMageWorxIds'),(244,'MageWorx\\OptionDependency\\Setup\\Patch\\Schema\\MoveOptionIdsDataToNewColumns'),(245,'MageWorx\\OptionDependency\\Setup\\Patch\\Schema\\RemoveUnusedIdColumns'),(246,'MageWorx\\OptionDependency\\Setup\\Patch\\Schema\\SortTableColumns'),(247,'MageWorx\\OptionTemplates\\Setup\\Patch\\Schema\\DropTrigger'),(248,'MageWorx\\OptionTemplates\\Setup\\Patch\\Schema\\SortTableColumns'),(249,'MageWorx\\OptionAdvancedPricing\\Setup\\Patch\\Schema\\SortTableColumns'),(250,'MageWorx\\OptionVisibility\\Setup\\Patch\\Schema\\SortTableColumns'),(251,'MageWorx\\OptionFeatures\\Setup\\Patch\\Data\\ConvertMageWorxIds'),(252,'MageWorx\\OptionFeatures\\Setup\\Patch\\Data\\UpdateCoreConfigData'),(253,'MageWorx\\DynamicOptionsBase\\Setup\\Patch\\Data\\AddPricePerUnitAttribute'),(254,'MageWorx\\DynamicOptionsBase\\Setup\\Patch\\Data\\UpdatePricePerUnitAttribute'),(255,'MageWorx\\OptionDependency\\Setup\\Patch\\Data\\UpdateCoreConfigData'),(256,'MageWorx\\OptionDependency\\Setup\\Patch\\Data\\UpdateInitialStatesData'),(257,'MageWorx\\OptionLink\\Setup\\Patch\\Data\\UpdateCoreConfigData'),(258,'MageWorx\\OptionLink\\Setup\\Patch\\Data\\UpdateSkuIsValidData'),(259,'MageWorx\\OptionTemplates\\Setup\\Patch\\Data\\UpdateCoreConfigData'),(260,'MageWorx\\OptionInventory\\Setup\\Patch\\Data\\UpdateCoreConfigData'),(261,'MageWorx\\OptionAdvancedPricing\\Setup\\Patch\\Data\\ConvertMageWorxIds'),(262,'MageWorx\\OptionSwatches\\Setup\\Patch\\Data\\UpdateSwatchSize'),(263,'MageWorx\\OptionVisibility\\Setup\\Patch\\Data\\ConvertMageWorxIds'),(264,'MageWorx\\OptionHealthChecker\\Setup\\Patch\\Data\\DataCleaner');

--
-- Table structure for table `wal_paypal_billing_agreement`
--

CREATE TABLE `wal_paypal_billing_agreement` (
  `agreement_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Agreement ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `method_code` varchar(32) NOT NULL COMMENT 'Method Code',
  `reference_id` varchar(32) NOT NULL COMMENT 'Reference ID',
  `status` varchar(20) NOT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `agreement_label` varchar(255) DEFAULT NULL COMMENT 'Agreement Label',
  PRIMARY KEY (`agreement_id`),
  KEY `WAL_PAYPAL_BILLING_AGREEMENT_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_PAYPAL_BILLING_AGREEMENT_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_PAYPAL_BILLING_AGREEMENT_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL,
  CONSTRAINT `WAL_PAYPAL_BILLING_AGRT_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Billing Agreement';

--
-- Dumping data for table `wal_paypal_billing_agreement`
--


--
-- Table structure for table `wal_paypal_billing_agreement_order`
--

CREATE TABLE `wal_paypal_billing_agreement_order` (
  `agreement_id` int(10) unsigned NOT NULL COMMENT 'Agreement ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  PRIMARY KEY (`agreement_id`,`order_id`),
  KEY `WAL_PAYPAL_BILLING_AGREEMENT_ORDER_ORDER_ID` (`order_id`),
  CONSTRAINT `FK_4B90624ADB83BB0470C1F0752ACB64B7` FOREIGN KEY (`agreement_id`) REFERENCES `wal_paypal_billing_agreement` (`agreement_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_PAYPAL_BILLING_AGRT_ORDER_ORDER_ID_WAL_SALES_ORDER_ENTT_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Billing Agreement Order';

--
-- Dumping data for table `wal_paypal_billing_agreement_order`
--


--
-- Table structure for table `wal_paypal_cert`
--

CREATE TABLE `wal_paypal_cert` (
  `cert_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Cert ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `content` text COMMENT 'Content',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`cert_id`),
  KEY `WAL_PAYPAL_CERT_WEBSITE_ID` (`website_id`),
  CONSTRAINT `WAL_PAYPAL_CERT_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Certificate Table';

--
-- Dumping data for table `wal_paypal_cert`
--


--
-- Table structure for table `wal_paypal_payment_transaction`
--

CREATE TABLE `wal_paypal_payment_transaction` (
  `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `txn_id` varchar(100) DEFAULT NULL COMMENT 'Txn ID',
  `additional_information` blob COMMENT 'Additional Information',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `WAL_PAYPAL_PAYMENT_TRANSACTION_TXN_ID` (`txn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='PayPal Payflow Link Payment Transaction';

--
-- Dumping data for table `wal_paypal_payment_transaction`
--


--
-- Table structure for table `wal_paypal_settlement_report`
--

CREATE TABLE `wal_paypal_settlement_report` (
  `report_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Report ID',
  `report_date` date DEFAULT NULL COMMENT 'Report Date',
  `account_id` varchar(64) DEFAULT NULL COMMENT 'Account ID',
  `filename` varchar(24) DEFAULT NULL COMMENT 'Filename',
  `last_modified` timestamp NULL DEFAULT NULL COMMENT 'Last Modified',
  PRIMARY KEY (`report_id`),
  UNIQUE KEY `WAL_PAYPAL_SETTLEMENT_REPORT_REPORT_DATE_ACCOUNT_ID` (`report_date`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Settlement Report Table';

--
-- Dumping data for table `wal_paypal_settlement_report`
--


--
-- Table structure for table `wal_paypal_settlement_report_row`
--

CREATE TABLE `wal_paypal_settlement_report_row` (
  `row_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row ID',
  `report_id` int(10) unsigned NOT NULL COMMENT 'Report ID',
  `transaction_id` varchar(19) DEFAULT NULL COMMENT 'Transaction ID',
  `invoice_id` varchar(127) DEFAULT NULL COMMENT 'Invoice ID',
  `paypal_reference_id` varchar(19) DEFAULT NULL COMMENT 'Paypal Reference ID',
  `paypal_reference_id_type` varchar(3) DEFAULT NULL COMMENT 'Paypal Reference ID Type',
  `transaction_event_code` varchar(5) DEFAULT NULL COMMENT 'Transaction Event Code',
  `transaction_initiation_date` timestamp NULL DEFAULT NULL COMMENT 'Transaction Initiation Date',
  `transaction_completion_date` timestamp NULL DEFAULT NULL COMMENT 'Transaction Completion Date',
  `transaction_debit_or_credit` varchar(2) NOT NULL DEFAULT 'CR' COMMENT 'Transaction Debit Or Credit',
  `gross_transaction_amount` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Gross Transaction Amount',
  `gross_transaction_currency` varchar(3) DEFAULT NULL COMMENT 'Gross Transaction Currency',
  `fee_debit_or_credit` varchar(2) DEFAULT NULL COMMENT 'Fee Debit Or Credit',
  `fee_amount` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Fee Amount',
  `fee_currency` varchar(3) DEFAULT NULL COMMENT 'Fee Currency',
  `custom_field` varchar(255) DEFAULT NULL COMMENT 'Custom Field',
  `consumer_id` varchar(127) DEFAULT NULL COMMENT 'Consumer ID',
  `payment_tracking_id` varchar(255) DEFAULT NULL COMMENT 'Payment Tracking ID',
  `store_id` varchar(50) DEFAULT NULL COMMENT 'Store ID',
  PRIMARY KEY (`row_id`),
  KEY `WAL_PAYPAL_SETTLEMENT_REPORT_ROW_REPORT_ID` (`report_id`),
  CONSTRAINT `FK_FEDD6FF932D28957933116BD8EB330D7` FOREIGN KEY (`report_id`) REFERENCES `wal_paypal_settlement_report` (`report_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Settlement Report Row Table';

--
-- Dumping data for table `wal_paypal_settlement_report_row`
--


--
-- Table structure for table `wal_persistent_session`
--

CREATE TABLE `wal_persistent_session` (
  `persistent_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Session ID',
  `key` varchar(50) NOT NULL COMMENT 'Unique cookie key',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `info` text COMMENT 'Session Data',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`persistent_id`),
  UNIQUE KEY `WAL_PERSISTENT_SESSION_KEY` (`key`),
  UNIQUE KEY `WAL_PERSISTENT_SESSION_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_PERSISTENT_SESSION_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` (`website_id`),
  KEY `WAL_PERSISTENT_SESSION_UPDATED_AT` (`updated_at`),
  CONSTRAINT `WAL_PERSISTENT_SESSION_CUSTOMER_ID_WAL_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_PERSISTENT_SESSION_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Persistent Session';

--
-- Dumping data for table `wal_persistent_session`
--


--
-- Table structure for table `wal_product_alert_price`
--

CREATE TABLE `wal_product_alert_price` (
  `alert_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product alert price ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `price` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Price amount',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store ID',
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Product alert add date',
  `last_send_date` timestamp NULL DEFAULT NULL COMMENT 'Product alert last send date',
  `send_count` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert send count',
  `status` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert status',
  PRIMARY KEY (`alert_price_id`),
  KEY `WAL_PRODUCT_ALERT_PRICE_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_PRODUCT_ALERT_PRICE_PRODUCT_ID` (`product_id`),
  KEY `WAL_PRODUCT_ALERT_PRICE_WEBSITE_ID` (`website_id`),
  KEY `WAL_PRODUCT_ALERT_PRICE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_PRD_ALERT_PRICE_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_PRD_ALERT_PRICE_PRD_ID_WAL_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_PRODUCT_ALERT_PRICE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_PRODUCT_ALERT_PRICE_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Alert Price';

--
-- Dumping data for table `wal_product_alert_price`
--


--
-- Table structure for table `wal_product_alert_stock`
--

CREATE TABLE `wal_product_alert_stock` (
  `alert_stock_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product alert stock ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store ID',
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Product alert add date',
  `send_date` timestamp NULL DEFAULT NULL COMMENT 'Product alert send date',
  `send_count` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Send Count',
  `status` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert status',
  PRIMARY KEY (`alert_stock_id`),
  KEY `WAL_PRODUCT_ALERT_STOCK_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_PRODUCT_ALERT_STOCK_PRODUCT_ID` (`product_id`),
  KEY `WAL_PRODUCT_ALERT_STOCK_WEBSITE_ID` (`website_id`),
  KEY `WAL_PRODUCT_ALERT_STOCK_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_PRD_ALERT_STOCK_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_PRD_ALERT_STOCK_PRD_ID_WAL_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_PRODUCT_ALERT_STOCK_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_PRODUCT_ALERT_STOCK_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Alert Stock';

--
-- Dumping data for table `wal_product_alert_stock`
--


--
-- Table structure for table `wal_queue`
--

CREATE TABLE `wal_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 `WAL_QUEUE_NAME` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Table storing unique queues';

--
-- Dumping data for table `wal_queue`
--

INSERT INTO `wal_queue` VALUES (9,'async.operations.all'),(8,'codegenerator'),(18,'customer_segment.match.queue'),(3,'export'),(12,'inventory.indexer.sourceItem'),(13,'inventory.indexer.stock'),(5,'inventory.mass.update'),(6,'inventory.reservations.cleanup'),(7,'inventory.reservations.update'),(11,'inventory.reservations.updateSalabilityStatus'),(4,'inventory.source.items.cleanup'),(14,'media.content.synchronization'),(15,'media.gallery.renditions.update'),(16,'media.gallery.synchronization'),(10,'media.storage.catalog.image.resize'),(1,'product_action_attribute.update'),(2,'product_action_attribute.website.update'),(17,'sales.rule.update.coupon.usage');

--
-- Table structure for table `wal_queue_lock`
--

CREATE TABLE `wal_queue_lock` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Message ID',
  `message_code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Message Code',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_QUEUE_LOCK_MESSAGE_CODE` (`message_code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Messages that were processed are inserted here to be locked.';

--
-- Dumping data for table `wal_queue_lock`
--

INSERT INTO `wal_queue_lock` VALUES (1,'0b66d3e2da9e7f6e65b916d7802d65a5','2022-06-17 09:15:16');

--
-- Table structure for table `wal_queue_message`
--

CREATE TABLE `wal_queue_message` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Message ID',
  `topic_name` varchar(255) DEFAULT NULL COMMENT 'Message topic',
  `body` longtext COMMENT 'Message body',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Queue messages';

--
-- Dumping data for table `wal_queue_message`
--

INSERT INTO `wal_queue_message` VALUES (1,'inventory.reservations.updateSalabilityStatus','{\"skus\":[\"demo product\"],\"stock\":1}');

--
-- Table structure for table `wal_queue_message_status`
--

CREATE TABLE `wal_queue_message_status` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Relation ID',
  `queue_id` int(10) unsigned NOT NULL COMMENT 'Queue ID',
  `message_id` bigint(20) unsigned NOT NULL COMMENT 'Message ID',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `status` smallint(5) unsigned NOT NULL COMMENT 'Message status in particular queue',
  `number_of_trials` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of trials to processed failed message processing',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_QUEUE_MESSAGE_STATUS_QUEUE_ID_MESSAGE_ID` (`queue_id`,`message_id`),
  KEY `WAL_QUEUE_MESSAGE_STATUS_MESSAGE_ID_WAL_QUEUE_MESSAGE_ID` (`message_id`),
  KEY `WAL_QUEUE_MESSAGE_STATUS_STATUS_UPDATED_AT` (`status`,`updated_at`),
  CONSTRAINT `WAL_QUEUE_MESSAGE_STATUS_MESSAGE_ID_WAL_QUEUE_MESSAGE_ID` FOREIGN KEY (`message_id`) REFERENCES `wal_queue_message` (`id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_QUEUE_MESSAGE_STATUS_QUEUE_ID_WAL_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `wal_queue` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Relation table to keep associations between queues and messages';

--
-- Dumping data for table `wal_queue_message_status`
--

INSERT INTO `wal_queue_message_status` VALUES (1,11,1,'2022-06-17 09:15:16',4,1);

--
-- Table structure for table `wal_queue_poison_pill`
--

CREATE TABLE `wal_queue_poison_pill` (
  `version` varchar(255) NOT NULL COMMENT 'Poison Pill version.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sequence table for poison pill versions';

--
-- Dumping data for table `wal_queue_poison_pill`
--

INSERT INTO `wal_queue_poison_pill` VALUES ('version-65d6a6017dbcc');

--
-- Table structure for table `wal_quote`
--

CREATE TABLE `wal_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 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 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',
  `customer_balance_amount_used` decimal(20,4) DEFAULT NULL COMMENT 'Customer Balance Amount Used',
  `base_customer_bal_amount_used` decimal(20,4) DEFAULT NULL COMMENT 'Base Customer Bal Amount Used',
  `use_customer_balance` int(11) DEFAULT NULL COMMENT 'Use Customer Balance',
  `use_reward_points` int(11) DEFAULT NULL COMMENT 'Use Reward Points',
  `reward_points_balance` int(11) DEFAULT NULL COMMENT 'Reward Points Balance',
  `base_reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Reward Currency Amount',
  `reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Reward Currency Amount',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_QUOTE_CUSTOMER_ID_STORE_ID_IS_ACTIVE` (`customer_id`,`store_id`,`is_active`),
  KEY `WAL_QUOTE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_QUOTE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote';

--
-- Dumping data for table `wal_quote`
--

INSERT INTO `wal_quote` VALUES (1,1,'2021-08-26 01:52:04','2021-08-26 01:52:04',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',100.0000,100.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'172.68.189.172',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'2021-08-26 05:46:06','2021-08-26 05:46:06',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',100.0000,100.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'172.68.189.172',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,'2021-10-18 09:35:06','2021-10-18 09:35:06',NULL,1,0,0,0,0.0000,0,0.0000,0.0000,'USD','USD','USD',0.0000,0.0000,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'221.226.251.250',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,0.0000,0.0000,0.0000,0.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(4,1,'2021-12-24 07:54:06','2021-12-24 08:32:45',NULL,1,0,0,1,2.0000,0,0.0000,0.0000,'USD','USD','USD',200.0000,200.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'221.226.251.250',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,200.0000,200.0000,200.0000,200.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(5,1,'2022-01-28 09:45:05','2022-01-28 09:45:05',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',100.0000,100.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'221.226.251.250',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(6,1,'2022-03-03 05:29:16','2022-03-03 05:31:29',NULL,1,0,0,2,2.0000,0,0.0000,0.0000,'USD','USD','USD',200.0000,200.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'221.226.251.250',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,200.0000,200.0000,200.0000,200.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(7,1,'2022-03-04 05:55:35','2022-03-04 05:55:35',NULL,1,0,0,0,0.0000,0,0.0000,0.0000,'USD','USD','USD',0.0000,0.0000,NULL,1,NULL,1,'taoyong2022@hotmail.com',NULL,'Yong',NULL,'Tao',NULL,NULL,NULL,1,0,'221.226.251.250',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,0.0000,0.0000,0.0000,0.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(8,1,'2022-03-24 03:12:10','2022-03-24 03:23:13',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',105.0000,105.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'221.226.251.250',NULL,'000000001',NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(9,1,'2022-03-24 05:44:53','2022-03-24 06:04:34',NULL,0,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',105.0000,105.0000,NULL,NULL,3,0,'anyan_2266@126.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'221.226.251.250',NULL,'000000002',NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(10,1,'2022-04-01 08:54:43','2022-04-01 08:57:55',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',100.0000,100.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'117.89.89.227',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,0.0000,0.0000,0,NULL,NULL,NULL,NULL),(11,1,'2022-04-08 05:12:31','2022-04-08 05:12:31',NULL,0,0,0,0,0.0000,0,0.0000,0.0000,'USD','USD','USD',0.0000,0.0000,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,0.0000,0.0000,0.0000,0.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(12,1,'2023-03-29 10:40:11','2023-03-29 10:40:11',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',100.0000,100.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'172.71.154.138',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(13,1,'2023-04-20 00:59:13','2023-04-20 02:10:54',NULL,1,0,0,1,2.0000,0,0.0000,0.0000,'USD','USD','USD',200.0000,200.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'172.70.210.33',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,200.0000,200.0000,200.0000,200.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(14,1,'2023-10-30 01:10:39','2023-10-30 01:10:39',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',100.0000,100.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'172.70.42.69',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(15,1,'2024-02-06 07:23:13','2024-02-06 07:23:13',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',100.0000,100.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'221.226.251.250',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL),(16,1,'2024-02-22 01:21:21','2024-02-22 01:21:21',NULL,1,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',100.0000,100.0000,NULL,NULL,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'221.226.251.250',NULL,NULL,NULL,NULL,'USD',1.0000,1.0000,NULL,NULL,100.0000,100.0000,100.0000,100.0000,1,0,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `wal_quote_address`
--

CREATE TABLE `wal_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 COMMENT 'Customer Notes',
  `applied_taxes` text 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 COMMENT 'Vat ID',
  `vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
  `vat_request_id` text COMMENT 'Vat Request ID',
  `vat_request_date` text COMMENT 'Vat Request Date',
  `vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `validated_country_code` text COMMENT 'Validated Country Code',
  `validated_vat_number` text COMMENT 'Validated Vat Number',
  `free_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
  `base_customer_balance_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Customer Balance Amount',
  `customer_balance_amount` decimal(20,4) DEFAULT NULL COMMENT 'Customer Balance Amount',
  `giftregistry_item_id` int(11) DEFAULT NULL COMMENT 'Giftregistry Item Id',
  `reward_points_balance` int(11) DEFAULT NULL COMMENT 'Reward Points Balance',
  `base_reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Reward Currency Amount',
  `reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Reward Currency Amount',
  PRIMARY KEY (`address_id`),
  KEY `WAL_QUOTE_ADDRESS_QUOTE_ID` (`quote_id`),
  CONSTRAINT `WAL_QUOTE_ADDRESS_QUOTE_ID_WAL_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `wal_quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Address';

--
-- Dumping data for table `wal_quote_address`
--

INSERT INTO `wal_quote_address` VALUES (1,1,'2021-08-26 01:52:04','2021-08-26 01:52:04',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'2021-08-26 01:52:04','2021-08-26 01:52:04',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,'2021-08-26 05:46:06','2021-08-26 05:46:06',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(4,2,'2021-08-26 05:46:06','2021-08-26 05:46:06',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(5,3,'2021-10-18 09:35:06','2021-10-18 09:35:06',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(6,3,'2021-10-18 09:35:07','2021-10-18 09:35:07',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(7,4,'2021-12-24 07:54:06','2021-12-24 07:54:06',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(8,4,'2021-12-24 07:54:06','2021-12-24 07:54:06',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,0.0000,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,NULL,'[]',NULL,0.0000,0.0000,200.0000,200.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(9,5,'2022-01-28 09:45:05','2022-01-28 09:45:05',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(10,5,'2022-01-28 09:45:05','2022-01-28 09:45:05',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(11,6,'2022-03-03 05:29:16','2022-03-03 05:29:16',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(12,6,'2022-03-03 05:29:16','2022-03-03 05:29:16',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,0.0000,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,NULL,'[]',NULL,0.0000,0.0000,200.0000,200.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(13,7,'2022-03-04 05:55:35','2022-03-04 05:55:35',1,0,NULL,'billing','taoyong2022@hotmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(14,7,'2022-03-04 05:55:35','2022-03-04 05:55:35',1,0,NULL,'shipping','taoyong2022@hotmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(16,8,'2022-03-24 03:12:10','2022-03-24 03:23:13',NULL,0,NULL,'shipping',NULL,NULL,'Viola',NULL,'Peels',NULL,NULL,'5324 JOHNSON ST','MERRILLVILLE','Indiana',24,NULL,'US','2194845669',NULL,0,0,'flatrate_flatrate','Flat Rate - Fixed',0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,5.0000,5.0000,0.0000,0.0000,0.0000,0.0000,105.0000,105.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,5.0000,5.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(17,8,'2022-03-24 03:23:10','2022-03-24 03:23:10',NULL,NULL,NULL,'billing','anyan_2266@126.com',NULL,'Viola',NULL,'Peels',NULL,NULL,'5324 JOHNSON ST','MERRILLVILLE','Indiana',24,'46410','US','2194845669',NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(19,9,'2022-03-24 05:44:53','2022-03-24 06:02:33',NULL,0,NULL,'shipping','anyan_2266@126.com',NULL,'test',NULL,'11',NULL,'wolan','542 N Longwood Dr','Glenwood','Illinois',23,'60425','US','3123752875',NULL,0,0,'flatrate_flatrate','Flat Rate - Fixed',0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,5.0000,5.0000,0.0000,0.0000,0.0000,0.0000,105.0000,105.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,5.0000,5.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(20,9,'2022-03-24 06:02:31','2022-03-24 06:02:31',NULL,NULL,NULL,'billing','anyan_2266@126.com',NULL,'test',NULL,'11',NULL,'wolan','542 N Longwood Dr','Glenwood','Illinois',23,'60425','US','3123752875',NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(23,10,'2022-04-01 08:56:06','2022-04-01 08:56:06',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(24,10,'2022-04-01 08:56:06','2022-04-01 08:56:06',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(25,11,'2022-04-08 05:12:31','2022-04-08 05:12:31',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(26,11,'2022-04-08 05:12:31','2022-04-08 05:12:31',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(27,12,'2023-03-29 10:40:11','2023-03-29 10:40:11',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(28,12,'2023-03-29 10:40:11','2023-03-29 10:40:11',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(29,13,'2023-04-20 00:59:13','2023-04-20 00:59:13',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(30,13,'2023-04-20 00:59:13','2023-04-20 00:59:13',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,0.0000,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,NULL,'[]',NULL,0.0000,0.0000,200.0000,200.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(31,14,'2023-10-30 01:10:39','2023-10-30 01:10:39',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(32,14,'2023-10-30 01:10:39','2023-10-30 01:10:39',NULL,0,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(33,15,'2024-02-06 07:23:13','2024-02-06 07:23:13',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(34,15,'2024-02-06 07:23:13','2024-02-06 07:23:13',NULL,1,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'US',NULL,NULL,1,0,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(35,16,'2024-02-22 01:21:21','2024-02-22 01:21:21',NULL,0,NULL,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL),(36,16,'2024-02-22 01:21:21','2024-02-22 01:21:21',NULL,1,NULL,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'US',NULL,NULL,1,0,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,'[]',NULL,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0.0000,0.0000,NULL,NULL,NULL,NULL);

--
-- Table structure for table `wal_quote_address_item`
--

CREATE TABLE `wal_quote_address_item` (
  `address_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Item ID',
  `parent_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Item ID',
  `quote_address_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Address ID',
  `quote_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Item 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',
  `applied_rule_ids` text COMMENT 'Applied Rule Ids',
  `additional_data` text COMMENT 'Additional Data',
  `weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Weight',
  `qty` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty',
  `discount_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Discount Amount',
  `tax_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Tax Amount',
  `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_total_with_discount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Row Total With Discount',
  `base_discount_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Discount Amount',
  `base_tax_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Tax Amount',
  `row_weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Weight',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product ID',
  `super_product_id` int(10) unsigned DEFAULT NULL COMMENT 'Super Product ID',
  `parent_product_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `is_qty_decimal` int(10) unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `discount_percent` decimal(12,4) DEFAULT NULL COMMENT 'Discount Percent',
  `no_discount` int(10) unsigned DEFAULT NULL COMMENT 'No Discount',
  `tax_percent` decimal(12,4) DEFAULT NULL COMMENT 'Tax Percent',
  `base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `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',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `free_shipping` int(10) unsigned DEFAULT NULL COMMENT 'Free Shipping',
  PRIMARY KEY (`address_item_id`),
  KEY `WAL_QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS_ID` (`quote_address_id`),
  KEY `WAL_QUOTE_ADDRESS_ITEM_PARENT_ITEM_ID` (`parent_item_id`),
  KEY `WAL_QUOTE_ADDRESS_ITEM_QUOTE_ITEM_ID` (`quote_item_id`),
  KEY `WAL_QUOTE_ADDRESS_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `FK_423E2D2086354446810E6DC7B4D189C5` FOREIGN KEY (`parent_item_id`) REFERENCES `wal_quote_address_item` (`address_item_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_QUOTE_ADDRESS_ITEM_QUOTE_ITEM_ID_WAL_QUOTE_ITEM_ITEM_ID` FOREIGN KEY (`quote_item_id`) REFERENCES `wal_quote_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_QUOTE_ADDR_ITEM_QUOTE_ADDR_ID_WAL_QUOTE_ADDR_ADDR_ID` FOREIGN KEY (`quote_address_id`) REFERENCES `wal_quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Address Item';

--
-- Dumping data for table `wal_quote_address_item`
--


--
-- Table structure for table `wal_quote_id_mask`
--

CREATE TABLE `wal_quote_id_mask` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote ID',
  `masked_id` varchar(32) DEFAULT NULL COMMENT 'Masked ID',
  PRIMARY KEY (`entity_id`,`quote_id`),
  KEY `WAL_QUOTE_ID_MASK_QUOTE_ID` (`quote_id`),
  KEY `WAL_QUOTE_ID_MASK_MASKED_ID` (`masked_id`),
  CONSTRAINT `WAL_QUOTE_ID_MASK_QUOTE_ID_WAL_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `wal_quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='Quote ID and masked ID mapping';

--
-- Dumping data for table `wal_quote_id_mask`
--

INSERT INTO `wal_quote_id_mask` VALUES (5,5,'26sqGYgHvqVyHSom6XIMNlb2EjtpHrTP'),(4,4,'4OINKmRVuGCWkbkaJ4oYtB1GrKv1a6kL'),(9,10,'BeG1DdnbQRw0ZMuSHDiGUsR66vD6SlPk'),(10,12,'e5wB6euILRfhKcFe9wA4yaHsbsbMvcyP'),(13,15,'eieZYcXB3GI5Lx2u8SXMcoVylytutzSU'),(1,1,'hdX9bXYDZmpL8lDfgcIyVNQTvQeJWH0G'),(14,16,'MSlWBI4ctvKUkRqeS25W9QzYTLpdnDnT'),(8,9,'ODa3ypAIQ7namE83GZarVNpCtmd9dJAT'),(7,8,'oymehMrlBnIBlecIxSVIqUz6Oi2VHfvH'),(6,6,'pv9ZYBjB8RkgH0AyFXc51MjmaZyVHT4j'),(11,13,'PvXomtOkktdpyhaBBIE7M7vy1SAK0MgH'),(2,2,'utosF3dYoICHWgd8WdIputDYogX4J7Vf'),(12,14,'v73mEp1ObRM80UKi74elm6TC6tBU3TPr'),(3,3,'wMN9nd5OvWPfr5tgUMPFeoj7vBBQH1ZO');

--
-- Table structure for table `wal_quote_item`
--

CREATE TABLE `wal_quote_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item 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',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `parent_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Item ID',
  `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 COMMENT 'Description',
  `applied_rule_ids` text COMMENT 'Applied Rule Ids',
  `additional_data` text COMMENT 'Additional Data',
  `is_qty_decimal` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
  `no_discount` smallint(5) unsigned DEFAULT '0' COMMENT 'No Discount',
  `weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Weight',
  `qty` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `base_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Price',
  `custom_price` decimal(12,4) DEFAULT NULL COMMENT 'Custom Price',
  `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',
  `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',
  `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_total_with_discount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Row Total With Discount',
  `row_weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Weight',
  `product_type` varchar(255) DEFAULT NULL COMMENT 'Product Type',
  `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',
  `original_custom_price` decimal(12,4) DEFAULT NULL COMMENT 'Original Custom Price',
  `redirect_url` varchar(255) DEFAULT NULL COMMENT 'Redirect Url',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `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',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `free_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
  `event_id` int(11) DEFAULT NULL COMMENT 'Event Id',
  `giftregistry_item_id` int(11) DEFAULT NULL COMMENT 'Giftregistry Item Id',
  PRIMARY KEY (`item_id`),
  KEY `WAL_QUOTE_ITEM_PARENT_ITEM_ID` (`parent_item_id`),
  KEY `WAL_QUOTE_ITEM_PRODUCT_ID` (`product_id`),
  KEY `WAL_QUOTE_ITEM_QUOTE_ID` (`quote_id`),
  KEY `WAL_QUOTE_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_QUOTE_ITEM_PARENT_ITEM_ID_WAL_QUOTE_ITEM_ITEM_ID` FOREIGN KEY (`parent_item_id`) REFERENCES `wal_quote_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_QUOTE_ITEM_QUOTE_ID_WAL_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `wal_quote` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_QUOTE_ITEM_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Item';

--
-- Dumping data for table `wal_quote_item`
--

INSERT INTO `wal_quote_item` VALUES (1,1,'2021-08-26 01:52:04','2021-08-26 01:52:04',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(2,2,'2021-08-26 05:46:06','2021-08-26 05:46:06',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(4,4,'2021-12-24 08:32:39','2021-12-24 08:32:39',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,2.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,200.0000,200.0000,0.0000,0.0000,NULL,0,NULL,NULL),(5,5,'2022-01-28 09:45:05','2022-01-28 09:45:05',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(6,6,'2022-03-03 05:29:16','2022-03-03 05:29:16',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(7,6,'2022-03-03 05:31:29','2022-03-03 05:31:29',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(8,8,'2022-03-24 03:12:10','2022-03-24 03:12:10',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(9,9,'2022-03-24 05:44:53','2022-03-24 05:44:53',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(11,10,'2022-04-01 08:57:55','2022-04-01 08:57:55',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(12,12,'2023-03-29 10:40:11','2023-03-29 10:40:11',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(13,13,'2023-04-20 00:59:13','2023-04-20 02:10:54',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,2.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,200.0000,200.0000,0.0000,0.0000,NULL,0,NULL,NULL),(14,14,'2023-10-30 01:10:39','2023-10-30 01:10:39',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(15,15,'2024-02-06 07:23:13','2024-02-06 07:23:13',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL),(16,16,'2024-02-22 01:21:21','2024-02-22 01:21:21',1,1,NULL,0,'demo product','demo product',NULL,NULL,NULL,0,0,0.0000,1.0000,100.0000,100.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,0.0000,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,0,NULL,NULL);

--
-- Table structure for table `wal_quote_item_option`
--

CREATE TABLE `wal_quote_item_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `item_id` int(10) unsigned NOT NULL COMMENT 'Item ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`option_id`),
  KEY `WAL_QUOTE_ITEM_OPTION_ITEM_ID` (`item_id`),
  CONSTRAINT `WAL_QUOTE_ITEM_OPTION_ITEM_ID_WAL_QUOTE_ITEM_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `wal_quote_item` (`item_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Item Option';

--
-- Dumping data for table `wal_quote_item_option`
--

INSERT INTO `wal_quote_item_option` VALUES (1,1,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly92aXAubXlmaXJzdHdpZy5jb20vZGVtby1wcm9kdWN0Lmh0bWw,\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"123\"},\"qty\":\"1\"}'),(2,1,1,'option_ids','1'),(3,1,1,'option_1','123'),(4,2,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly92aXAubXlmaXJzdHdpZy5jb20vZGVtby1wcm9kdWN0Lmh0bWw,\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"test\"},\"qty\":\"1\"}'),(5,2,1,'option_ids','1'),(6,2,1,'option_1','test'),(10,4,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"test\"},\"qty\":\"2\"}'),(11,4,1,'option_ids','1'),(12,4,1,'option_1','test'),(13,5,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"123\"},\"qty\":\"1\"}'),(14,5,1,'option_ids','1'),(15,5,1,'option_1','123'),(16,6,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"123\"},\"qty\":\"1\"}'),(17,6,1,'option_ids','1'),(18,6,1,'option_1','123'),(19,7,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"123123\"},\"qty\":\"1\"}'),(20,7,1,'option_ids','1'),(21,7,1,'option_1','123123'),(22,8,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"df\"},\"qty\":\"1\"}'),(23,8,1,'option_ids','1'),(24,8,1,'option_1','df'),(25,9,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"asd\"},\"qty\":\"1\"}'),(26,9,1,'option_ids','1'),(27,9,1,'option_1','asd'),(31,11,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"1\":\"123\"},\"qty\":\"1\"}'),(32,11,1,'option_ids','1'),(33,11,1,'option_1','123'),(34,12,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"7\":\"7\"},\"qty\":\"1\"}'),(35,12,1,'option_ids','7'),(36,12,1,'option_7','7'),(37,13,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"7\":\"7\"},\"qty\":\"1\"}'),(38,13,1,'option_ids','7'),(39,13,1,'option_7','7'),(40,14,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9tMmJhc2Uud2FsLWxhbmQuY29tLmNuL2RlbW8tcHJvZHVjdC5odG1s\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"7\":\"7\"},\"qty\":\"1\"}'),(41,14,1,'option_ids','7'),(42,14,1,'option_7','7'),(43,15,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9kamYud2FsLWxhbmQuY29tLmNuL21hZ2VudG8yLTQtMy9kZW1vLXByb2R1Y3QuaHRtbA,,\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"7\":\"7\"},\"qty\":\"1\"}'),(44,15,1,'option_ids','7'),(45,15,1,'option_7','7'),(46,16,1,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9kamYud2FsLWxhbmQuY29tLmNuL21hZ2VudG8yLTQtMy9kZW1vLXByb2R1Y3QuaHRtbA,,\",\"product\":\"1\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"1\",\"options\":{\"7\":\"7\"},\"qty\":\"1\"}'),(47,16,1,'option_ids','7'),(48,16,1,'option_7','7');

--
-- Table structure for table `wal_quote_payment`
--

CREATE TABLE `wal_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 COMMENT 'Additional Data',
  `cc_ss_issue` varchar(255) DEFAULT NULL COMMENT 'Cc Ss Issue',
  `additional_information` text 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 `WAL_QUOTE_PAYMENT_QUOTE_ID` (`quote_id`),
  CONSTRAINT `WAL_QUOTE_PAYMENT_QUOTE_ID_WAL_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `wal_quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Payment';

--
-- Dumping data for table `wal_quote_payment`
--

INSERT INTO `wal_quote_payment` VALUES (1,8,'2022-03-24 03:13:21','2022-03-24 03:13:21','afterpay',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL,'null',NULL,NULL,NULL),(2,9,'2022-03-24 06:02:26','2022-03-24 06:02:26','afterpay',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL,'{\"afterpay_token\":\"002.tfg0v2egug5m3vn5v1m9agqsls89cn0m6q1ok6c1jvjmocef\"}',NULL,NULL,NULL);

--
-- Table structure for table `wal_quote_shipping_rate`
--

CREATE TABLE `wal_quote_shipping_rate` (
  `rate_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rate ID',
  `address_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Address 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',
  `carrier` varchar(255) DEFAULT NULL COMMENT 'Carrier',
  `carrier_title` varchar(255) DEFAULT NULL COMMENT 'Carrier Title',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `method` varchar(255) DEFAULT NULL COMMENT 'Method',
  `method_description` text COMMENT 'Method Description',
  `price` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `error_message` text COMMENT 'Error Message',
  `method_title` text COMMENT 'Method Title',
  PRIMARY KEY (`rate_id`),
  KEY `WAL_QUOTE_SHIPPING_RATE_ADDRESS_ID` (`address_id`),
  CONSTRAINT `WAL_QUOTE_SHIPPING_RATE_ADDRESS_ID_WAL_QUOTE_ADDRESS_ADDRESS_ID` FOREIGN KEY (`address_id`) REFERENCES `wal_quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Shipping Rate';

--
-- Dumping data for table `wal_quote_shipping_rate`
--

INSERT INTO `wal_quote_shipping_rate` VALUES (7,16,'2022-03-24 03:30:18','2022-03-24 03:30:18','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(13,19,'2022-03-24 06:02:33','2022-03-24 06:02:33','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(16,34,'2024-02-06 07:23:51','2024-02-06 07:23:51','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(19,36,'2024-02-22 01:22:23','2024-02-22 01:22:23','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed');

--
-- Table structure for table `wal_rating`
--

CREATE TABLE `wal_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 `WAL_RATING_RATING_CODE` (`rating_code`),
  KEY `WAL_RATING_ENTITY_ID` (`entity_id`),
  CONSTRAINT `WAL_RATING_ENTITY_ID_WAL_RATING_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `wal_rating_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Ratings';

--
-- Dumping data for table `wal_rating`
--

INSERT INTO `wal_rating` VALUES (1,1,'Quality',0,1),(2,1,'Value',0,1),(3,1,'Price',0,1);

--
-- Table structure for table `wal_rating_entity`
--

CREATE TABLE `wal_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 `WAL_RATING_ENTITY_ENTITY_CODE` (`entity_code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Rating entities';

--
-- Dumping data for table `wal_rating_entity`
--

INSERT INTO `wal_rating_entity` VALUES (1,'product'),(2,'product_review'),(3,'review');

--
-- Table structure for table `wal_rating_option`
--

CREATE TABLE `wal_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 `WAL_RATING_OPTION_RATING_ID` (`rating_id`),
  CONSTRAINT `WAL_RATING_OPTION_RATING_ID_WAL_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `wal_rating` (`rating_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='Rating options';

--
-- Dumping data for table `wal_rating_option`
--

INSERT INTO `wal_rating_option` VALUES (1,1,'1',1,1),(2,1,'2',2,2),(3,1,'3',3,3),(4,1,'4',4,4),(5,1,'5',5,5),(6,2,'1',1,1),(7,2,'2',2,2),(8,2,'3',3,3),(9,2,'4',4,4),(10,2,'5',5,5),(11,3,'1',1,1),(12,3,'2',2,2),(13,3,'3',3,3),(14,3,'4',4,4),(15,3,'5',5,5);

--
-- Table structure for table `wal_rating_option_vote`
--

CREATE TABLE `wal_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 `WAL_RATING_OPTION_VOTE_OPTION_ID` (`option_id`),
  KEY `WAL_RATING_OPTION_VOTE_REVIEW_ID_WAL_REVIEW_REVIEW_ID` (`review_id`),
  CONSTRAINT `WAL_RATING_OPTION_VOTE_OPTION_ID_WAL_RATING_OPTION_OPTION_ID` FOREIGN KEY (`option_id`) REFERENCES `wal_rating_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_RATING_OPTION_VOTE_REVIEW_ID_WAL_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `wal_review` (`review_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating option values';

--
-- Dumping data for table `wal_rating_option_vote`
--


--
-- Table structure for table `wal_rating_option_vote_aggregated`
--

CREATE TABLE `wal_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 `WAL_RATING_OPTION_VOTE_AGGREGATED_RATING_ID` (`rating_id`),
  KEY `WAL_RATING_OPTION_VOTE_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_RATING_OPTION_VOTE_AGGREGATED_RATING_ID_WAL_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `wal_rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_RATING_OPTION_VOTE_AGGREGATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating vote aggregated';

--
-- Dumping data for table `wal_rating_option_vote_aggregated`
--


--
-- Table structure for table `wal_rating_store`
--

CREATE TABLE `wal_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 `WAL_RATING_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_RATING_STORE_RATING_ID_WAL_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `wal_rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_RATING_STORE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating Store';

--
-- Dumping data for table `wal_rating_store`
--


--
-- Table structure for table `wal_rating_title`
--

CREATE TABLE `wal_rating_title` (
  `rating_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` varchar(255) NOT NULL COMMENT 'Rating Label',
  PRIMARY KEY (`rating_id`,`store_id`),
  KEY `WAL_RATING_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_RATING_TITLE_RATING_ID_WAL_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `wal_rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_RATING_TITLE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating Title';

--
-- Dumping data for table `wal_rating_title`
--


--
-- Table structure for table `wal_release_notification_viewer_log`
--

CREATE TABLE `wal_release_notification_viewer_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `viewer_id` int(10) unsigned NOT NULL COMMENT 'Viewer admin user ID',
  `last_view_version` varchar(16) NOT NULL COMMENT 'Viewer last view on product version',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_RELEASE_NOTIFICATION_VIEWER_LOG_VIEWER_ID` (`viewer_id`),
  CONSTRAINT `WAL_RELEASE_NTFC_VIEWER_LOG_VIEWER_ID_WAL_ADM_USR_USR_ID` FOREIGN KEY (`viewer_id`) REFERENCES `wal_admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Release Notification Viewer Log Table';

--
-- Dumping data for table `wal_release_notification_viewer_log`
--


--
-- Table structure for table `wal_report_compared_product_index`
--

CREATE TABLE `wal_report_compared_product_index` (
  `index_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index ID',
  `visitor_id` int(10) unsigned DEFAULT NULL COMMENT 'Visitor ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Added At',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `WAL_REPORT_COMPARED_PRODUCT_INDEX_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  UNIQUE KEY `WAL_REPORT_COMPARED_PRODUCT_INDEX_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `WAL_REPORT_COMPARED_PRODUCT_INDEX_STORE_ID` (`store_id`),
  KEY `WAL_REPORT_COMPARED_PRODUCT_INDEX_ADDED_AT` (`added_at`),
  KEY `WAL_REPORT_COMPARED_PRODUCT_INDEX_PRODUCT_ID` (`product_id`),
  CONSTRAINT `WAL_REPORT_CMPD_PRD_IDX_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REPORT_CMPD_PRD_IDX_PRD_ID_WAL_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REPORT_COMPARED_PRODUCT_INDEX_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Compared Product Index Table';

--
-- Dumping data for table `wal_report_compared_product_index`
--


--
-- Table structure for table `wal_report_event`
--

CREATE TABLE `wal_report_event` (
  `event_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event ID',
  `logged_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Logged At',
  `event_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Event Type ID',
  `object_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Object ID',
  `subject_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Subject ID',
  `subtype` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Subtype',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`event_id`),
  KEY `WAL_REPORT_EVENT_EVENT_TYPE_ID` (`event_type_id`),
  KEY `WAL_REPORT_EVENT_SUBJECT_ID` (`subject_id`),
  KEY `WAL_REPORT_EVENT_OBJECT_ID` (`object_id`),
  KEY `WAL_REPORT_EVENT_SUBTYPE` (`subtype`),
  KEY `WAL_REPORT_EVENT_STORE_ID` (`store_id`),
  CONSTRAINT `FK_6DD93D5BB40E572E9DE8A01F2A132342` FOREIGN KEY (`event_type_id`) REFERENCES `wal_report_event_types` (`event_type_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REPORT_EVENT_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Event Table';

--
-- Dumping data for table `wal_report_event`
--


--
-- Table structure for table `wal_report_event_types`
--

CREATE TABLE `wal_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=utf8 COMMENT='Reports Event Type Table';

--
-- Dumping data for table `wal_report_event_types`
--

INSERT INTO `wal_report_event_types` VALUES (1,'catalog_product_view',0),(2,'sendfriend_product',0),(3,'catalog_product_compare_add_product',0),(4,'checkout_cart_add_product',0),(5,'wishlist_add_product',0),(6,'wishlist_share',0);

--
-- Table structure for table `wal_report_viewed_product_aggregated_daily`
--

CREATE TABLE `wal_report_viewed_product_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',
  `views_num` int(11) NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_REPORT_VIEWED_PRD_AGGRED_DAILY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_STORE_ID` (`store_id`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_92F67516A57F35642F3F94A7C084871C` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REPORT_VIEWED_PRD_AGGRED_DAILY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Daily';

--
-- Dumping data for table `wal_report_viewed_product_aggregated_daily`
--


--
-- Table structure for table `wal_report_viewed_product_aggregated_monthly`
--

CREATE TABLE `wal_report_viewed_product_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',
  `views_num` int(11) NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_REPORT_VIEWED_PRD_AGGRED_MONTHLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_STORE_ID` (`store_id`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_7F791771DCA2B545B9E7CB2949BC375C` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REPORT_VIEWED_PRD_AGGRED_MONTHLY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Monthly';

--
-- Dumping data for table `wal_report_viewed_product_aggregated_monthly`
--


--
-- Table structure for table `wal_report_viewed_product_aggregated_yearly`
--

CREATE TABLE `wal_report_viewed_product_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',
  `views_num` int(11) NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_REPORT_VIEWED_PRD_AGGRED_YEARLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_C8EEB3EF695D4A75D7FA827EF60535C9` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REPORT_VIEWED_PRD_AGGRED_YEARLY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Yearly';

--
-- Dumping data for table `wal_report_viewed_product_aggregated_yearly`
--


--
-- Table structure for table `wal_report_viewed_product_index`
--

CREATE TABLE `wal_report_viewed_product_index` (
  `index_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index ID',
  `visitor_id` int(10) unsigned DEFAULT NULL COMMENT 'Visitor ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Added At',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `WAL_REPORT_VIEWED_PRODUCT_INDEX_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  UNIQUE KEY `WAL_REPORT_VIEWED_PRODUCT_INDEX_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_INDEX_STORE_ID` (`store_id`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_INDEX_ADDED_AT` (`added_at`),
  KEY `WAL_REPORT_VIEWED_PRODUCT_INDEX_PRODUCT_ID` (`product_id`),
  CONSTRAINT `WAL_REPORT_VIEWED_PRD_IDX_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REPORT_VIEWED_PRD_IDX_PRD_ID_WAL_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REPORT_VIEWED_PRODUCT_INDEX_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Viewed Product Index Table';

--
-- Dumping data for table `wal_report_viewed_product_index`
--


--
-- Table structure for table `wal_review`
--

CREATE TABLE `wal_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',
  `answer` text COMMENT 'Admin answer',
  `verified_buyer` smallint(6) DEFAULT '0' COMMENT 'Verified Buyer',
  `is_recommended` smallint(6) DEFAULT '0' COMMENT 'Is Recommended',
  `amasty_admin_answer_account_only` smallint(6) DEFAULT NULL COMMENT 'is admin answer visible on account area only',
  PRIMARY KEY (`review_id`),
  KEY `WAL_REVIEW_ENTITY_ID` (`entity_id`),
  KEY `WAL_REVIEW_STATUS_ID` (`status_id`),
  KEY `WAL_REVIEW_ENTITY_PK_VALUE` (`entity_pk_value`),
  CONSTRAINT `WAL_REVIEW_ENTITY_ID_WAL_REVIEW_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `wal_review_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REVIEW_STATUS_ID_WAL_REVIEW_STATUS_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `wal_review_status` (`status_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Review base information';

--
-- Dumping data for table `wal_review`
--

INSERT INTO `wal_review` VALUES (1,'2021-12-08 06:23:50',1,1,1,NULL,0,2,0);

--
-- Table structure for table `wal_review_detail`
--

CREATE TABLE `wal_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',
  `review_images` text COMMENT 'review_images',
  `like_about` text COMMENT 'Customer like about this product',
  `not_like_about` text COMMENT 'Customer do not like about this product',
  `guest_email` text COMMENT 'Guest Email',
  PRIMARY KEY (`detail_id`),
  KEY `WAL_REVIEW_DETAIL_REVIEW_ID` (`review_id`),
  KEY `WAL_REVIEW_DETAIL_STORE_ID` (`store_id`),
  KEY `WAL_REVIEW_DETAIL_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `WAL_REVIEW_DETAIL_CUSTOMER_ID_WAL_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `WAL_REVIEW_DETAIL_REVIEW_ID_WAL_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `wal_review` (`review_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REVIEW_DETAIL_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Review detail information';

--
-- Dumping data for table `wal_review_detail`
--

INSERT INTO `wal_review_detail` VALUES (1,1,0,'test','test Review','tao',NULL,NULL,'','',NULL);

--
-- Table structure for table `wal_review_entity`
--

CREATE TABLE `wal_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=utf8 COMMENT='Review entities';

--
-- Dumping data for table `wal_review_entity`
--

INSERT INTO `wal_review_entity` VALUES (1,'product'),(2,'customer'),(3,'category');

--
-- Table structure for table `wal_review_entity_summary`
--

CREATE TABLE `wal_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 `WAL_REVIEW_ENTITY_SUMMARY_ENTITY_PK_VALUE_STORE_ID_ENTITY_TYPE` (`entity_pk_value`,`store_id`,`entity_type`),
  KEY `WAL_REVIEW_ENTITY_SUMMARY_STORE_ID` (`store_id`),
  KEY `WAL_REVIEW_ENTITY_SUMMARY_ENTITY_PK_VALUE_ENTITY_TYPE_STORE_ID` (`entity_pk_value`,`entity_type`,`store_id`),
  CONSTRAINT `WAL_REVIEW_ENTITY_SUMMARY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Review aggregates';

--
-- Dumping data for table `wal_review_entity_summary`
--

INSERT INTO `wal_review_entity_summary` VALUES (1,1,1,1,0,1);

--
-- Table structure for table `wal_review_status`
--

CREATE TABLE `wal_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=utf8 COMMENT='Review statuses';

--
-- Dumping data for table `wal_review_status`
--

INSERT INTO `wal_review_status` VALUES (1,'Approved'),(2,'Pending'),(3,'Not Approved');

--
-- Table structure for table `wal_review_store`
--

CREATE TABLE `wal_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 `WAL_REVIEW_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_REVIEW_STORE_REVIEW_ID_WAL_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `wal_review` (`review_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_REVIEW_STORE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review Store';

--
-- Dumping data for table `wal_review_store`
--

INSERT INTO `wal_review_store` VALUES (1,0),(1,1);

--
-- Table structure for table `wal_sales_bestsellers_aggregated_daily`
--

CREATE TABLE `wal_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 `WAL_SALES_BESTSELLERS_AGGRED_DAILY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `WAL_SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID` (`store_id`),
  KEY `WAL_SALES_BESTSELLERS_AGGREGATED_DAILY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `WAL_SALES_BESTSELLERS_AGGRED_DAILY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Daily';

--
-- Dumping data for table `wal_sales_bestsellers_aggregated_daily`
--


--
-- Table structure for table `wal_sales_bestsellers_aggregated_monthly`
--

CREATE TABLE `wal_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 `WAL_SALES_BESTSELLERS_AGGRED_MONTHLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `WAL_SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID` (`store_id`),
  KEY `WAL_SALES_BESTSELLERS_AGGREGATED_MONTHLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `WAL_SALES_BESTSELLERS_AGGRED_MONTHLY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Monthly';

--
-- Dumping data for table `wal_sales_bestsellers_aggregated_monthly`
--


--
-- Table structure for table `wal_sales_bestsellers_aggregated_yearly`
--

CREATE TABLE `wal_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 `WAL_SALES_BESTSELLERS_AGGRED_YEARLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `WAL_SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
  KEY `WAL_SALES_BESTSELLERS_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `WAL_SALES_BESTSELLERS_AGGRED_YEARLY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Yearly';

--
-- Dumping data for table `wal_sales_bestsellers_aggregated_yearly`
--


--
-- Table structure for table `wal_sales_creditmemo`
--

CREATE TABLE `wal_sales_creditmemo` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `store_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `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',
  `base_adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Negative',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `store_to_base_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `base_adjustment` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `adjustment` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Positive',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `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',
  `creditmemo_status` int(11) DEFAULT NULL COMMENT 'Creditmemo Status',
  `state` int(11) DEFAULT NULL COMMENT 'State',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `invoice_id` int(11) DEFAULT NULL COMMENT 'Invoice ID',
  `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',
  `transaction_id` varchar(255) DEFAULT NULL COMMENT 'Transaction ID',
  `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',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `customer_note` text COMMENT 'Customer Note',
  `customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  `base_customer_balance_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Customer Balance Amount',
  `customer_balance_amount` decimal(20,4) DEFAULT NULL COMMENT 'Customer Balance Amount',
  `bs_customer_bal_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Bs Customer Bal Total Refunded',
  `customer_bal_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Customer Bal Total Refunded',
  `base_reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Reward Currency Amount',
  `reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Reward Currency Amount',
  `reward_points_balance` int(11) DEFAULT NULL COMMENT 'Reward Points Balance',
  `reward_points_balance_refund` int(11) DEFAULT NULL COMMENT 'Reward Points Balance Refund',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_SALES_CREDITMEMO_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `WAL_SALES_CREDITMEMO_STORE_ID` (`store_id`),
  KEY `WAL_SALES_CREDITMEMO_ORDER_ID` (`order_id`),
  KEY `WAL_SALES_CREDITMEMO_CREDITMEMO_STATUS` (`creditmemo_status`),
  KEY `WAL_SALES_CREDITMEMO_STATE` (`state`),
  KEY `WAL_SALES_CREDITMEMO_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_CREDITMEMO_UPDATED_AT` (`updated_at`),
  KEY `WAL_SALES_CREDITMEMO_SEND_EMAIL` (`send_email`),
  KEY `WAL_SALES_CREDITMEMO_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `WAL_SALES_CREDITMEMO_ORDER_ID_WAL_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALES_CREDITMEMO_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Creditmemo';

--
-- Dumping data for table `wal_sales_creditmemo`
--


--
-- Table structure for table `wal_sales_creditmemo_comment`
--

CREATE TABLE `wal_sales_creditmemo_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 COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_CREDITMEMO_COMMENT_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_CREDITMEMO_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `FK_A9BA9822154D60C185C7334F40BBC3F4` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_creditmemo` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Creditmemo Comment';

--
-- Dumping data for table `wal_sales_creditmemo_comment`
--


--
-- Table structure for table `wal_sales_creditmemo_grid`
--

CREATE TABLE `wal_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 `WAL_SALES_CREDITMEMO_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `WAL_SALES_CREDITMEMO_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `WAL_SALES_CREDITMEMO_GRID_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_CREDITMEMO_GRID_UPDATED_AT` (`updated_at`),
  KEY `WAL_SALES_CREDITMEMO_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `WAL_SALES_CREDITMEMO_GRID_STATE` (`state`),
  KEY `WAL_SALES_CREDITMEMO_GRID_BILLING_NAME` (`billing_name`),
  KEY `WAL_SALES_CREDITMEMO_GRID_ORDER_STATUS` (`order_status`),
  KEY `WAL_SALES_CREDITMEMO_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  KEY `WAL_SALES_CREDITMEMO_GRID_STORE_ID` (`store_id`),
  KEY `WAL_SALES_CREDITMEMO_GRID_ORDER_BASE_GRAND_TOTAL` (`order_base_grand_total`),
  KEY `WAL_SALES_CREDITMEMO_GRID_ORDER_ID` (`order_id`),
  FULLTEXT KEY `FTI_94656C3D93C81AC783992687B81EA6DE` (`increment_id`,`order_increment_id`,`billing_name`,`billing_address`,`shipping_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Creditmemo Grid';

--
-- Dumping data for table `wal_sales_creditmemo_grid`
--


--
-- Table structure for table `wal_sales_creditmemo_item`
--

CREATE TABLE `wal_sales_creditmemo_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(12,4) DEFAULT NULL COMMENT 'Base Row Total',
  `discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Amount',
  `row_total` decimal(12,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 COMMENT 'Additional Data',
  `description` text 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 COMMENT 'Ratio of tax in the creditmemo item over tax of the order item',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_CREDITMEMO_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `WAL_SALES_CREDITMEMO_ITEM_PARENT_ID_WAL_SALES_CREDITMEMO_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_creditmemo` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Creditmemo Item';

--
