
--
-- Table structure for table `variable`
--

CREATE TABLE `variable` (
  `variable_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Variable ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Variable Code',
  `name` varchar(255) DEFAULT NULL COMMENT 'Variable Name',
  PRIMARY KEY (`variable_id`),
  UNIQUE KEY `VARIABLE_CODE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variables';

--
-- Dumping data for table `variable`
--


--
-- Table structure for table `variable_value`
--

CREATE TABLE `variable_value` (
  `value_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Variable Value ID',
  `variable_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Variable ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `plain_value` text COMMENT 'Plain Text Value',
  `html_value` text COMMENT 'Html Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `VARIABLE_VALUE_VARIABLE_ID_STORE_ID` (`variable_id`,`store_id`),
  KEY `VARIABLE_VALUE_STORE_ID` (`store_id`),
  CONSTRAINT `VARIABLE_VALUE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `VARIABLE_VALUE_VARIABLE_ID_VARIABLE_VARIABLE_ID` FOREIGN KEY (`variable_id`) REFERENCES `variable` (`variable_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variable Value';

--
-- Dumping data for table `variable_value`
--


--
-- Table structure for table `vault_payment_token`
--

CREATE TABLE `vault_payment_token` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  `public_hash` varchar(128) NOT NULL COMMENT 'Hash code for using on frontend',
  `payment_method_code` varchar(128) NOT NULL COMMENT 'Payment method code',
  `type` varchar(128) NOT NULL COMMENT 'Type',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `expires_at` timestamp NULL DEFAULT NULL COMMENT 'Expires At',
  `gateway_token` varchar(255) NOT NULL COMMENT 'Gateway Token',
  `details` text COMMENT 'Details',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_visible` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `VAULT_PAYMENT_TOKEN_PUBLIC_HASH` (`public_hash`),
  UNIQUE KEY `VAULT_PAYMENT_TOKEN_PAYMENT_METHOD_CODE_CSTR_ID_GATEWAY_TOKEN` (`payment_method_code`,`customer_id`,`gateway_token`),
  KEY `VAULT_PAYMENT_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
  CONSTRAINT `VAULT_PAYMENT_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Vault tokens of payment';

--
-- Dumping data for table `vault_payment_token`
--


--
-- Table structure for table `vault_payment_token_order_payment_link`
--

CREATE TABLE `vault_payment_token_order_payment_link` (
  `order_payment_id` int unsigned NOT NULL COMMENT 'Order payment ID',
  `payment_token_id` int unsigned NOT NULL COMMENT 'Payment token ID',
  PRIMARY KEY (`order_payment_id`,`payment_token_id`),
  KEY `FK_4ED894655446D385894580BECA993862` (`payment_token_id`),
  CONSTRAINT `FK_4ED894655446D385894580BECA993862` FOREIGN KEY (`payment_token_id`) REFERENCES `vault_payment_token` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_CF37B9D854256534BE23C818F6291CA2` FOREIGN KEY (`order_payment_id`) REFERENCES `sales_order_payment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Order payments to vault token';

--
-- Dumping data for table `vault_payment_token_order_payment_link`
--


--
-- Table structure for table `vertex_custom_option_flex_field`
--

CREATE TABLE `vertex_custom_option_flex_field` (
  `entity_id` int NOT NULL AUTO_INCREMENT COMMENT 'Map Entity ID',
  `option_id` int NOT NULL COMMENT 'Customizable Option ID',
  `website_id` int NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `flex_field` int DEFAULT '0' COMMENT 'Customizable Option to Flex Field Map',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `VERTEX_CUSTOM_OPTION_FLEX_FIELD_OPTION_ID_WEBSITE_ID` (`option_id`,`website_id`),
  KEY `VERTEX_CUSTOM_OPTION_FLEX_FIELD_OPTION_ID` (`option_id`),
  KEY `VERTEX_CUSTOM_OPTION_FLEX_FIELD_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customizable Option to Flex Field Map';

--
-- Dumping data for table `vertex_custom_option_flex_field`
--


--
-- Table structure for table `vertex_customer_code`
--

CREATE TABLE `vertex_customer_code` (
  `customer_id` int unsigned NOT NULL COMMENT 'Customer ID',
  `customer_code` text COMMENT 'Customer Code for Vertex',
  PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Code for Vertex';

--
-- Dumping data for table `vertex_customer_code`
--


--
-- Table structure for table `vertex_invoice_sent`
--

CREATE TABLE `vertex_invoice_sent` (
  `invoice_id` int unsigned NOT NULL COMMENT 'Invoice ID',
  `sent_to_vertex` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Invoice has been logged in Vertex',
  PRIMARY KEY (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vertex_invoice_sent`
--


--
-- Table structure for table `vertex_order_invoice_status`
--

CREATE TABLE `vertex_order_invoice_status` (
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `sent_to_vertex` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Invoice has been logged in Vertex',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Invoice has been logged in Vertex';

--
-- Dumping data for table `vertex_order_invoice_status`
--


--
-- Table structure for table `vertex_sales_creditmemo_item_invoice_text_code`
--

CREATE TABLE `vertex_sales_creditmemo_item_invoice_text_code` (
  `item_id` int NOT NULL COMMENT 'Creditmemo Item ID',
  `invoice_text_code` varchar(100) NOT NULL COMMENT 'Invoice text code from Vertex',
  UNIQUE KEY `UNQ_4BC40DA748D7713ADA661D2DE1BCF161` (`item_id`,`invoice_text_code`),
  KEY `VERTEX_SALES_CREDITMEMO_ITEM_INVOICE_TEXT_CODE_ITEM_ID` (`item_id`),
  KEY `VERTEX_SALES_CREDITMEMO_ITEM_INVOICE_TEXT_CODE_INVOICE_TEXT_CODE` (`invoice_text_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Invoice text code from Vertex';

--
-- Dumping data for table `vertex_sales_creditmemo_item_invoice_text_code`
--


--
-- Table structure for table `vertex_sales_creditmemo_item_tax_code`
--

CREATE TABLE `vertex_sales_creditmemo_item_tax_code` (
  `item_id` int NOT NULL COMMENT 'Creditmemo Item ID',
  `tax_code` varchar(100) NOT NULL COMMENT 'Invoice text code from Vertex',
  UNIQUE KEY `VERTEX_SALES_CREDITMEMO_ITEM_TAX_CODE_ITEM_ID_TAX_CODE` (`item_id`,`tax_code`),
  KEY `VERTEX_SALES_CREDITMEMO_ITEM_TAX_CODE_ITEM_ID` (`item_id`),
  KEY `VERTEX_SALES_CREDITMEMO_ITEM_TAX_CODE_TAX_CODE` (`tax_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Invoice text code from Vertex';

--
-- Dumping data for table `vertex_sales_creditmemo_item_tax_code`
--


--
-- Table structure for table `vertex_sales_creditmemo_item_vertex_tax_code`
--

CREATE TABLE `vertex_sales_creditmemo_item_vertex_tax_code` (
  `item_id` int NOT NULL COMMENT 'Creditmemo Item ID',
  `vertex_tax_code` varchar(100) NOT NULL COMMENT 'Invoice text code from Vertex',
  UNIQUE KEY `UNQ_31D7AADB3412BC7E7C1C98D5CC3A5D46` (`item_id`,`vertex_tax_code`),
  KEY `VERTEX_SALES_CREDITMEMO_ITEM_VERTEX_TAX_CODE_ITEM_ID` (`item_id`),
  KEY `VERTEX_SALES_CREDITMEMO_ITEM_VERTEX_TAX_CODE_VERTEX_TAX_CODE` (`vertex_tax_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Invoice text code from Vertex';

--
-- Dumping data for table `vertex_sales_creditmemo_item_vertex_tax_code`
--


--
-- Table structure for table `vertex_sales_order_item_invoice_text_code`
--

CREATE TABLE `vertex_sales_order_item_invoice_text_code` (
  `item_id` int unsigned NOT NULL COMMENT 'Order ID',
  `invoice_text_code` varchar(100) NOT NULL COMMENT 'Invoice text code from Vertex',
  UNIQUE KEY `UNQ_96F6BE3160A4185CEA4D866018EAF6DC` (`item_id`,`invoice_text_code`),
  KEY `VERTEX_SALES_ORDER_ITEM_INVOICE_TEXT_CODE_ITEM_ID` (`item_id`),
  KEY `VERTEX_SALES_ORDER_ITEM_INVOICE_TEXT_CODE_INVOICE_TEXT_CODE` (`invoice_text_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Invoice text code from Vertex';

--
-- Dumping data for table `vertex_sales_order_item_invoice_text_code`
--


--
-- Table structure for table `vertex_sales_order_item_tax_code`
--

CREATE TABLE `vertex_sales_order_item_tax_code` (
  `item_id` int NOT NULL COMMENT 'Creditmemo Item ID',
  `tax_code` varchar(100) NOT NULL COMMENT 'Invoice text code from Vertex',
  UNIQUE KEY `VERTEX_SALES_ORDER_ITEM_TAX_CODE_ITEM_ID_TAX_CODE` (`item_id`,`tax_code`),
  KEY `VERTEX_SALES_ORDER_ITEM_TAX_CODE_ITEM_ID` (`item_id`),
  KEY `VERTEX_SALES_ORDER_ITEM_TAX_CODE_TAX_CODE` (`tax_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Invoice text code from Vertex';

--
-- Dumping data for table `vertex_sales_order_item_tax_code`
--


--
-- Table structure for table `vertex_sales_order_item_vertex_tax_code`
--

CREATE TABLE `vertex_sales_order_item_vertex_tax_code` (
  `item_id` int NOT NULL COMMENT 'Creditmemo Item ID',
  `vertex_tax_code` varchar(100) NOT NULL COMMENT 'Text code from Vertex',
  `tax_code` varchar(100) NOT NULL COMMENT 'Invoice text code from Vertex',
  UNIQUE KEY `VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_ITEM_ID_VERTEX_TAX_CODE` (`item_id`,`vertex_tax_code`),
  UNIQUE KEY `VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_ITEM_ID_TAX_CODE` (`item_id`,`tax_code`),
  KEY `VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_ITEM_ID` (`item_id`),
  KEY `VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_TAX_CODE` (`tax_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Invoice text code from Vertex';

--
-- Dumping data for table `vertex_sales_order_item_vertex_tax_code`
--


--
-- Table structure for table `vertex_taxrequest`
--

CREATE TABLE `vertex_taxrequest` (
  `request_id` bigint NOT NULL AUTO_INCREMENT COMMENT 'Request Id',
  `request_type` varchar(255) NOT NULL COMMENT 'Request type',
  `response_time` int unsigned NOT NULL COMMENT 'Milliseconds taken for Vertex API call to complete',
  `quote_id` bigint NOT NULL COMMENT 'Quote Id',
  `order_id` bigint NOT NULL COMMENT 'Order Id',
  `total_tax` varchar(255) NOT NULL COMMENT 'Total Tax Amount',
  `source_path` varchar(255) NOT NULL COMMENT 'Source path controller_module_action',
  `tax_area_id` varchar(255) NOT NULL COMMENT 'Tax Jurisdictions Id',
  `sub_total` varchar(255) NOT NULL COMMENT 'Response Subtotal Amount',
  `total` varchar(255) NOT NULL COMMENT 'Response Total Amount',
  `lookup_result` varchar(255) NOT NULL COMMENT 'Tax Area Response Lookup Result',
  `request_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Request create date',
  `request_xml` text NOT NULL COMMENT 'Request XML',
  `response_xml` text NOT NULL COMMENT 'Response XML',
  PRIMARY KEY (`request_id`),
  UNIQUE KEY `VERTEX_TAXREQUEST_REQUEST_ID` (`request_id`),
  KEY `VERTEX_TAXREQUEST_REQUEST_TYPE` (`request_type`),
  KEY `VERTEX_TAXREQUEST_ORDER_ID` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The tax request table';

--
-- Dumping data for table `vertex_taxrequest`
--


--
-- Table structure for table `weee_tax`
--

CREATE TABLE `weee_tax` (
  `value_id` int NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `website_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `country` varchar(2) DEFAULT NULL COMMENT 'Country',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  `state` int NOT NULL DEFAULT '0' COMMENT 'State',
  `attribute_id` smallint unsigned NOT NULL COMMENT 'Attribute ID',
  PRIMARY KEY (`value_id`),
  KEY `WEEE_TAX_WEBSITE_ID` (`website_id`),
  KEY `WEEE_TAX_ENTITY_ID` (`entity_id`),
  KEY `WEEE_TAX_COUNTRY` (`country`),
  KEY `WEEE_TAX_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `WEEE_TAX_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `WEEE_TAX_COUNTRY_DIRECTORY_COUNTRY_COUNTRY_ID` FOREIGN KEY (`country`) REFERENCES `directory_country` (`country_id`) ON DELETE CASCADE,
  CONSTRAINT `WEEE_TAX_ENTITY_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WEEE_TAX_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Weee Tax';

--
-- Dumping data for table `weee_tax`
--


--
-- Table structure for table `widget`
--

CREATE TABLE `widget` (
  `widget_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Widget ID',
  `widget_code` varchar(255) DEFAULT NULL COMMENT 'Widget code for template directive',
  `widget_type` varchar(255) DEFAULT NULL COMMENT 'Widget Type',
  `parameters` text COMMENT 'Parameters',
  PRIMARY KEY (`widget_id`),
  KEY `WIDGET_WIDGET_CODE` (`widget_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Preconfigured Widgets';

--
-- Dumping data for table `widget`
--


--
-- Table structure for table `widget_instance`
--

CREATE TABLE `widget_instance` (
  `instance_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Instance ID',
  `instance_type` varchar(255) DEFAULT NULL COMMENT 'Instance Type',
  `theme_id` int unsigned NOT NULL COMMENT 'Theme ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Widget Title',
  `store_ids` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Store ids',
  `widget_parameters` text COMMENT 'Widget parameters',
  `sort_order` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Sort order',
  PRIMARY KEY (`instance_id`),
  KEY `WIDGET_INSTANCE_THEME_ID_THEME_THEME_ID` (`theme_id`),
  CONSTRAINT `WIDGET_INSTANCE_THEME_ID_THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `theme` (`theme_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Instances of Widget for Package Theme';

--
-- Dumping data for table `widget_instance`
--


--
-- Table structure for table `widget_instance_page`
--

CREATE TABLE `widget_instance_page` (
  `page_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Page ID',
  `instance_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Instance ID',
  `page_group` varchar(25) DEFAULT NULL COMMENT 'Block Group Type',
  `layout_handle` varchar(255) DEFAULT NULL COMMENT 'Layout Handle',
  `block_reference` varchar(255) DEFAULT NULL COMMENT 'Container',
  `page_for` varchar(25) DEFAULT NULL COMMENT 'For instance entities',
  `entities` text COMMENT 'Catalog entities (comma separated)',
  `page_template` varchar(255) DEFAULT NULL COMMENT 'Path to widget template',
  PRIMARY KEY (`page_id`),
  KEY `WIDGET_INSTANCE_PAGE_INSTANCE_ID` (`instance_id`),
  CONSTRAINT `WIDGET_INSTANCE_PAGE_INSTANCE_ID_WIDGET_INSTANCE_INSTANCE_ID` FOREIGN KEY (`instance_id`) REFERENCES `widget_instance` (`instance_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Instance of Widget on Page';

--
-- Dumping data for table `widget_instance_page`
--


--
-- Table structure for table `widget_instance_page_layout`
--

CREATE TABLE `widget_instance_page_layout` (
  `page_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Page ID',
  `layout_update_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Layout Update ID',
  PRIMARY KEY (`layout_update_id`,`page_id`),
  KEY `WIDGET_INSTANCE_PAGE_LAYOUT_PAGE_ID` (`page_id`),
  CONSTRAINT `WIDGET_INSTANCE_PAGE_LAYOUT_PAGE_ID_WIDGET_INSTANCE_PAGE_PAGE_ID` FOREIGN KEY (`page_id`) REFERENCES `widget_instance_page` (`page_id`) ON DELETE CASCADE,
  CONSTRAINT `WIDGET_INSTANCE_PAGE_LYT_LYT_UPDATE_ID_LYT_UPDATE_LYT_UPDATE_ID` FOREIGN KEY (`layout_update_id`) REFERENCES `layout_update` (`layout_update_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Layout updates';

--
-- Dumping data for table `widget_instance_page_layout`
--


--
-- Table structure for table `wishlist`
--

CREATE TABLE `wishlist` (
  `wishlist_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Wishlist ID',
  `customer_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `shared` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Sharing flag (0 or 1)',
  `sharing_code` varchar(32) DEFAULT NULL COMMENT 'Sharing encrypted code',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Last updated date',
  PRIMARY KEY (`wishlist_id`),
  UNIQUE KEY `WISHLIST_CUSTOMER_ID` (`customer_id`),
  KEY `WISHLIST_SHARED` (`shared`),
  CONSTRAINT `WISHLIST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Wishlist main Table';

--
-- Dumping data for table `wishlist`
--

INSERT INTO `wishlist` VALUES (1,1,0,'c1d8b8c311dc587587b2cd2793a7a3c4','2017-12-28 08:41:54'),(2,2,0,'e4da1e8dc5fc9ffbf75ec10fbf7b90dd','2017-10-19 04:43:34'),(3,3,0,'40cb18858a775512d2939bf97559b8c3','2017-11-28 03:31:18'),(4,4,0,'ee4f9e9eb7fffceae0c65cd85add68a1','2017-12-28 02:48:14'),(5,5,0,'08T8fdlQvxgC157wUOdW3kWgkKQU4VL6','2018-10-11 04:51:41'),(6,6,0,'Q5LYpjQSX0HKTSIr1UpsqhlfdaKkH7hC','2018-10-12 02:56:10'),(7,7,0,'kI5ot7ZnfQcTCNjglR3pOsXUHk7z34dB','2018-10-12 04:38:22'),(8,8,0,'gbQlPA7G20ZEfeH6AxAMcw8mnyjD7fp9','2022-02-25 11:28:29'),(9,9,0,'qsXNJAHsz8ouIQqUApQTa3DVWBbUDUEy','2022-10-05 05:16:57'),(10,10,0,'6yB4WIfcBn9hIU4iqPelkylqxW0ovGGL','2023-03-07 12:32:25');

--
-- Table structure for table `wishlist_item`
--

CREATE TABLE `wishlist_item` (
  `wishlist_item_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Wishlist item ID',
  `wishlist_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Wishlist ID',
  `product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NULL DEFAULT NULL COMMENT 'Add date and time',
  `description` text COMMENT 'Short description of wish list item',
  `qty` decimal(12,4) NOT NULL COMMENT 'Qty',
  PRIMARY KEY (`wishlist_item_id`),
  KEY `WISHLIST_ITEM_WISHLIST_ID` (`wishlist_id`),
  KEY `WISHLIST_ITEM_PRODUCT_ID` (`product_id`),
  KEY `WISHLIST_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `WISHLIST_ITEM_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WISHLIST_ITEM_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL,
  CONSTRAINT `WISHLIST_ITEM_WISHLIST_ID_WISHLIST_WISHLIST_ID` FOREIGN KEY (`wishlist_id`) REFERENCES `wishlist` (`wishlist_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='Wishlist items';

--
-- Dumping data for table `wishlist_item`
--

INSERT INTO `wishlist_item` VALUES (6,2,1,1,'2017-10-17 09:42:05',NULL,1.0000),(7,2,10,1,'2017-10-17 09:43:01',NULL,1.0000),(8,2,17,1,'2017-10-19 04:42:49',NULL,1.0000),(9,2,16,1,'2017-10-19 04:42:53',NULL,1.0000),(10,2,15,1,'2017-10-19 04:42:56',NULL,1.0000),(11,2,14,1,'2017-10-19 04:42:59',NULL,1.0000),(12,2,13,1,'2017-10-19 04:43:34',NULL,1.0000),(13,3,11,1,'2017-11-27 02:52:04',NULL,6.0000),(14,3,6,1,'2017-11-27 02:54:10',NULL,2.0000),(15,3,13,1,'2017-11-27 02:55:29',NULL,3.0000),(16,3,7,1,'2017-11-27 03:07:43',NULL,1.0000),(19,3,18,1,'2017-11-27 03:20:39',NULL,1.0000),(20,3,10,1,'2017-11-27 03:25:10',NULL,2.0000),(21,3,4,1,'2017-11-27 03:47:24',NULL,1.0000),(27,3,3,1,'2017-11-28 03:30:24',NULL,2.0000),(36,4,1,1,'2017-12-26 04:49:47',NULL,1.0000),(37,4,6,1,'2017-12-26 04:53:29',NULL,1.0000),(39,4,13,1,'2017-12-28 02:41:53',NULL,1.0000),(40,4,3,1,'2017-12-28 02:45:17',NULL,1.0000),(41,4,30,1,'2017-12-28 02:48:14',NULL,1.0000),(43,1,35,1,'2017-12-28 04:10:39',NULL,1.0000),(50,1,15,1,'2017-12-28 04:11:02',NULL,1.0000),(51,1,1,1,'2017-12-28 08:38:55',NULL,1.0000);

--
-- Table structure for table `wishlist_item_option`
--

CREATE TABLE `wishlist_item_option` (
  `option_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `wishlist_item_id` int unsigned NOT NULL COMMENT 'Wishlist Item ID',
  `product_id` int unsigned NOT NULL COMMENT 'Product ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`option_id`),
  KEY `FK_A014B30B04B72DD0EAB3EECD779728D6` (`wishlist_item_id`),
  KEY `WISHLIST_ITEM_OPTION_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` (`product_id`),
  CONSTRAINT `FK_A014B30B04B72DD0EAB3EECD779728D6` FOREIGN KEY (`wishlist_item_id`) REFERENCES `wishlist_item` (`wishlist_item_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='Wishlist Item Option Table';

--
-- Dumping data for table `wishlist_item_option`
--

INSERT INTO `wishlist_item_option` VALUES (6,6,1,'info_buyRequest','{\"product\":\"1\",\"form_key\":\"dS1IqLupESurNOHV\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS40OS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLWJlc3RzaG9wLW5ldy8,\"}'),(7,7,10,'info_buyRequest','{\"product\":\"10\",\"form_key\":\"dS1IqLupESurNOHV\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS40OS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLWJlc3RzaG9wLW5ldy9jdXN0b21lci9hY2NvdW50Lw,,\",\"isComparePage\":\"1\"}'),(8,8,17,'info_buyRequest','{\"product\":\"17\",\"form_key\":\"uHcCPlZ5FUQqAtc1\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS40OS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLWJlc3RzaG9wLW5ldy8,\"}'),(9,9,16,'info_buyRequest','{\"product\":\"16\",\"form_key\":\"uHcCPlZ5FUQqAtc1\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS40OS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLWJlc3RzaG9wLW5ldy8,\"}'),(10,10,15,'info_buyRequest','{\"product\":\"15\",\"form_key\":\"uHcCPlZ5FUQqAtc1\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS40OS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLWJlc3RzaG9wLW5ldy8,\"}'),(11,11,14,'info_buyRequest','{\"product\":\"14\",\"form_key\":\"uHcCPlZ5FUQqAtc1\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS40OS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLWJlc3RzaG9wLW5ldy8,\"}'),(12,12,13,'info_buyRequest','{\"product\":\"13\",\"form_key\":\"uHcCPlZ5FUQqAtc1\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS40OS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLWJlc3RzaG9wLW5ldy9jdXN0b21lci9hY2NvdW50Lw,,\",\"isComparePage\":\"1\"}'),(13,13,11,'info_buyRequest','{\"product\":\"11\",\"form_key\":\"h7mUO1b7TGiOS72s\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4zNS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLXNoaW55MjIxL2NhcnRxdWlja3Byby9jYXRhbG9nX3Byb2R1Y3Qvdmlldy9pZC8xMS9yYW5kdGltZS8xNTExNzUxMTE5NzEz\"}'),(14,14,6,'info_buyRequest','{\"product\":\"6\",\"form_key\":\"h7mUO1b7TGiOS72s\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4zNS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLXNoaW55MjIxLw,,\"}'),(15,15,13,'info_buyRequest','{\"product\":\"13\",\"form_key\":\"h7mUO1b7TGiOS72s\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4zNS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLXNoaW55MjIxL2xpc3Rpbmd0YWJzL2luZGV4L2luZGV4\"}'),(16,16,7,'info_buyRequest','{\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4zNS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLXNoaW55MjIxLw,,\",\"product\":\"7\",\"qty\":1,\"original_qty\":1}'),(19,19,18,'info_buyRequest','{\"product\":\"18\",\"form_key\":\"u6XILUjx5euiD4So\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4zNS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLXNoaW55MjIxLw,,\"}'),(20,20,10,'info_buyRequest','{\"product\":\"10\",\"form_key\":\"u6XILUjx5euiD4So\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4zNS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLXNoaW55MjIxL2N1c3RvbWVyL2FjY291bnQv\",\"isComparePage\":\"1\"}'),(21,21,4,'info_buyRequest','{\"product\":\"4\",\"form_key\":\"u6XILUjx5euiD4So\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4zNS95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLXNoaW55MjIxL2hpdGFjaGkta2MxOC0xOHZvbHQtY29yZGxlc3MuaHRtbA,,\"}'),(27,27,3,'info_buyRequest','{\"product\":\"3\",\"form_key\":\"yY2wC6rCwTm1FBc8\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS42Ni95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLXNoaW55MjIxLw,,\"}'),(36,36,1,'info_buyRequest','{\"product\":\"1\",\"form_key\":\"uqhPkeVLdI4MDQzf\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4xNC95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLW11bHRlMjIyL2thdHN1ZG9uLXBvcmstY3V0bGV0LXJpY2UuaHRtbA,,\"}'),(37,37,6,'info_buyRequest','{\"product\":\"6\",\"form_key\":\"uqhPkeVLdI4MDQzf\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4xNC95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLW11bHRlMjIyL2thdHN1ZG9uLXBvcmstY3V0bGV0LXJpY2UuaHRtbA,,\"}'),(39,39,13,'info_buyRequest','{\"product\":\"13\",\"form_key\":\"44aeWzwv4J2StLNt\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4xNC95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLW11bHRlMjIyL2N1c3RvbWVyL2FjY291bnQv\",\"isComparePage\":\"1\"}'),(40,40,3,'info_buyRequest','{\"product\":\"3\",\"form_key\":\"44aeWzwv4J2StLNt\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4xNC95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLW11bHRlMjIyL2NoZWNrb3V0L2NhcnQv\",\"isCheckoutPage\":\"1\"}'),(41,41,30,'info_buyRequest','{\"product\":\"30\",\"form_key\":\"44aeWzwv4J2StLNt\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4xNC95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLW11bHRlMjIyL2NhdGFsb2dzZWFyY2gvcmVzdWx0Lz9xPStwcm9kdWN0\"}'),(43,43,35,'info_buyRequest','{\"product\":\"35\",\"form_key\":\"fYyLI98nfrLauzIh\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4xNC95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLW11bHRlMjIyL291ci1tZW51Lmh0bWw,\"}'),(50,50,15,'info_buyRequest','{\"product\":\"15\",\"form_key\":\"fYyLI98nfrLauzIh\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4xNC95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLW11bHRlMjIyL291ci1tZW51Lmh0bWw,\"}'),(51,51,1,'info_buyRequest','{\"product\":\"1\",\"uenc\":\"aHR0cDovLzE5Mi4xNjguMS4xNC95dGNfdGVtcGxhdGVzL21hZ2VudG8yL3NtLW11bHRlMjIyLw,,\",\"form_key\":\"fYyLI98nfrLauzIh\"}');

--
-- Table structure for table `yotpo_rich_snippets`
--

CREATE TABLE `yotpo_rich_snippets` (
  `rich_snippet_id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `product_id` int NOT NULL COMMENT 'Product Id',
  `store_id` int NOT NULL COMMENT 'Store Id',
  `average_score` decimal(10,2) DEFAULT NULL COMMENT 'Average Score',
  `reviews_count` float(10,0) NOT NULL COMMENT 'Reviews Count',
  `expiration_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Expiry Time',
  PRIMARY KEY (`rich_snippet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='yotpo_rich_snippets';

--
-- Dumping data for table `yotpo_rich_snippets`
--


--
-- Table structure for table `yotpo_sync`
--

CREATE TABLE `yotpo_sync` (
  `sync_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `store_id` int unsigned DEFAULT NULL COMMENT 'Store ID',
  `entity_type` varchar(50) DEFAULT NULL COMMENT 'Entity Type',
  `entity_id` int unsigned DEFAULT NULL COMMENT 'Entity ID',
  `sync_flag` smallint DEFAULT '0' COMMENT 'Sync Flag',
  `sync_date` datetime NOT NULL COMMENT 'Sync Date',
  PRIMARY KEY (`sync_id`),
  UNIQUE KEY `YOTPO_SYNC_STORE_ID_ENTITY_TYPE_ENTITY_ID` (`store_id`,`entity_type`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='yotpo_sync';

--
-- Dumping data for table `yotpo_sync`
--

