-- Table structure for table `[[dbprefix]]inventory_stock`
--

CREATE TABLE `[[dbprefix]]inventory_stock` (
  `stock_id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `[[dbprefix]]inventory_stock`
--

INSERT INTO `[[dbprefix]]inventory_stock` VALUES (1,'Default Stock');

--
-- Temporary view structure for view `[[dbprefix]]inventory_stock_1`
--

/*!50001 DROP VIEW IF EXISTS `[[dbprefix]]inventory_stock_1`*/;
/*!50001 CREATE VIEW `[[dbprefix]]inventory_stock_1` AS SELECT 
 1 AS `product_id`,
 1 AS `website_id`,
 1 AS `stock_id`,
 1 AS `quantity`,
 1 AS `is_salable`,
 1 AS `sku`*/;

--
-- Table structure for table `[[dbprefix]]inventory_stock_sales_channel`
--

CREATE TABLE `[[dbprefix]]inventory_stock_sales_channel` (
  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `stock_id` int unsigned NOT NULL,
  PRIMARY KEY (`type`,`code`),
  KEY `[[DBPREFIX]]INV_STOCK_SALES_CHANNEL_STOCK_ID_[[DBPREFIX]]INV_STOCK_STOCK_ID` (`stock_id`),
  CONSTRAINT `[[DBPREFIX]]INV_STOCK_SALES_CHANNEL_STOCK_ID_[[DBPREFIX]]INV_STOCK_STOCK_ID` FOREIGN KEY (`stock_id`) REFERENCES `[[dbprefix]]inventory_stock` (`stock_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `[[dbprefix]]inventory_stock_sales_channel`
--

INSERT INTO `[[dbprefix]]inventory_stock_sales_channel` VALUES ('website','base',1);

--
-- Table structure for table `[[dbprefix]]jwt_auth_revoked`
--

CREATE TABLE `[[dbprefix]]jwt_auth_revoked` (
  `user_type_id` int unsigned NOT NULL COMMENT 'User Type ID',
  `user_id` int unsigned NOT NULL COMMENT 'User ID',
  `revoke_before` bigint unsigned NOT NULL COMMENT 'Not accepting tokens issued before this timestamp',
  PRIMARY KEY (`user_type_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Holds revoked JWT authentication data';

--
-- Dumping data for table `[[dbprefix]]jwt_auth_revoked`
--


--
-- Table structure for table `[[dbprefix]]layout_link`
--

CREATE TABLE `[[dbprefix]]layout_link` (
  `layout_link_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `theme_id` int unsigned NOT NULL COMMENT 'Theme ID',
  `layout_update_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Layout Update ID',
  `is_temporary` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Defines whether Layout Update is Temporary',
  PRIMARY KEY (`layout_link_id`),
  KEY `[[DBPREFIX]]LAYOUT_LINK_THEME_ID_[[DBPREFIX]]THEME_THEME_ID` (`theme_id`),
  KEY `[[DBPREFIX]]LAYOUT_LINK_LAYOUT_UPDATE_ID` (`layout_update_id`),
  KEY `[[DBPREFIX]]LAYOUT_LINK_STORE_ID_THEME_ID_LAYOUT_UPDATE_ID_IS_TEMPORARY` (`store_id`,`theme_id`,`layout_update_id`,`is_temporary`),
  CONSTRAINT `[[DBPREFIX]]LAYOUT_LINK_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]LAYOUT_LINK_THEME_ID_[[DBPREFIX]]THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `[[dbprefix]]theme` (`theme_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]LYT_LNK_LYT_UPDATE_ID_[[DBPREFIX]]LYT_UPDATE_LYT_UPDATE_ID` FOREIGN KEY (`layout_update_id`) REFERENCES `[[dbprefix]]layout_update` (`layout_update_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='Layout Link';

--
-- Dumping data for table `[[dbprefix]]layout_link`
--

INSERT INTO `[[dbprefix]]layout_link` VALUES (1,0,3,1,0),(2,0,3,2,0),(3,0,3,3,0),(4,0,3,4,0),(5,0,3,5,0),(6,0,3,6,0),(7,0,3,7,0),(8,0,3,8,0),(9,0,3,9,0),(10,0,3,10,0),(11,0,3,11,0),(12,0,3,12,0),(13,0,3,13,0),(14,0,3,14,0),(15,0,3,15,0),(16,0,3,16,0),(17,0,3,17,0);

--
-- Table structure for table `[[dbprefix]]layout_update`
--

CREATE TABLE `[[dbprefix]]layout_update` (
  `layout_update_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Layout Update ID',
  `handle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Handle',
  `xml` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Xml',
  `sort_order` smallint NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Update Timestamp',
  PRIMARY KEY (`layout_update_id`),
  KEY `[[DBPREFIX]]LAYOUT_UPDATE_HANDLE` (`handle`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='Layout Updates';

--
-- Dumping data for table `[[dbprefix]]layout_update`
--

INSERT INTO `[[dbprefix]]layout_update` VALUES (1,'contact_index_index','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"lRFf47CQocUd8QKpTBtD3TzulZseShF7\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">2</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(2,'default','<body><referenceContainer name=\"cms_footer_links_container\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"Lew0LpxhuJa1RnvNq9x4FmhdYeosEdAu\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">1</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(3,'catalog_category_view_id_37','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"dGkYPs3aa9drH2EwS2WlA708RIuFE0BW\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">3</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(4,'catalog_category_view_id_3','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"oO6ZamAVG78vOpSxhUdLsvIOpGHVpa4f\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">4</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(5,'catalog_category_view_id_11','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"z7Njthw4tf3RHRjwXR7pIxw7sKpXtsge\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">5</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(6,'catalog_category_view_id_20','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"TLYaQ2m75OYWkAwWz7ci1kpJyw8TMqx2\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">6</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(7,'catalog_category_view_id_38','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"cHJ9gGUmoeGLtbQy5I2CkFd0mWQmlMao\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">7</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(8,'catalog_category_view_id_20','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"SpG0HQ8UQo9FDa2E22gC0ulZ74eKxUZG\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">8</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(9,'catalog_category_view_id_9','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"5ptSninSVNq7f9QazIPACkRf5ojVyrgN\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">9</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(10,'catalog_category_view_id_11','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"6BgzOX1TCxCPuz0HaTdc6xWhZnU7hvNn\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">10</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(11,'catalog_category_view_id_3','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"bCbiMVIo8Y0SkLvKvvXz4q4q3OUbhZ5n\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">11</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(12,'catalog_category_view_id_38','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"IylA9sbgisF21lAqMVZ3cdvJwzTGTzJc\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">13</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(13,'catalog_category_view_id_37','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"9YaZOnqpOzJUBz7pgkwW9KfZfjr0Is8C\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">12</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(14,'cms_index_index','<body><referenceContainer name=\"content\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"Ohpnzx7FD5D0yYaARsjtpRxg4Clm2lCN\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">14</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(15,'catalog_category_view_id_39','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"1pTc13sgRF2pRkhO5WQA39o5hPDBj5Xf\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">15</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(16,'catalog_category_view_id_40','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"Kykuo9EydRSU6ZDMxqoas1xlyYG28x2E\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">16</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(17,'customer_account_login','<body><referenceContainer name=\"customer.login.container\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"UOx3qjLdCyY6BfU7LyyS9U1UFNkEeNdU\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">17</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00');

--
-- Table structure for table `[[dbprefix]]login_as_customer`
--

CREATE TABLE `[[dbprefix]]login_as_customer` (
  `secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Login Secret',
  `customer_id` int NOT NULL COMMENT 'Customer ID',
  `admin_id` int NOT NULL COMMENT 'Admin ID',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  PRIMARY KEY (`secret`),
  KEY `[[DBPREFIX]]LOGIN_AS_CUSTOMER_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Magento Login as Customer Table';

--
-- Dumping data for table `[[dbprefix]]login_as_customer`
--


--
-- Table structure for table `[[dbprefix]]login_as_customer_assistance_allowed`
--

CREATE TABLE `[[dbprefix]]login_as_customer_assistance_allowed` (
  `customer_id` int unsigned NOT NULL COMMENT 'Customer ID',
  PRIMARY KEY (`customer_id`),
  CONSTRAINT `FK_9A8E2AFC28B1513F453046DF7E9DBAFF` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Magento Login as Customer Assistance Allowed Table';

--
-- Dumping data for table `[[dbprefix]]login_as_customer_assistance_allowed`
--


--
-- Table structure for table `[[dbprefix]]magento_acknowledged_bulk`
--

CREATE TABLE `[[dbprefix]]magento_acknowledged_bulk` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Internal ID',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]MAGENTO_ACKNOWLEDGED_BULK_BULK_UUID` (`bulk_uuid`),
  CONSTRAINT `[[DBPREFIX]]MAGENTO_ACKNOWLEDGED_BULK_BULK_UUID_[[DBPREFIX]]MAGENTO_BULK_UUID` FOREIGN KEY (`bulk_uuid`) REFERENCES `[[dbprefix]]magento_bulk` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Bulk that was viewed by user from notification area';

--
-- Dumping data for table `[[dbprefix]]magento_acknowledged_bulk`
--


--
-- Table structure for table `[[dbprefix]]magento_bulk`
--

CREATE TABLE `[[dbprefix]]magento_bulk` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Bulk Internal ID (must not be exposed)',
  `uuid` varbinary(39) DEFAULT NULL COMMENT 'Bulk UUID (can be exposed to reference bulk entity)',
  `user_id` int unsigned DEFAULT NULL COMMENT 'ID of the WebAPI user that performed an action',
  `user_type` int DEFAULT NULL COMMENT 'Which type of user',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Bulk Description',
  `operation_count` int unsigned NOT NULL COMMENT 'Total number of operations scheduled within this bulk',
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Bulk start time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]MAGENTO_BULK_UUID` (`uuid`),
  KEY `[[DBPREFIX]]MAGENTO_BULK_USER_ID` (`user_id`),
  KEY `[[DBPREFIX]]MAGENTO_BULK_START_TIME` (`start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Bulk entity that represents set of related asynchronous operations';

--
-- Dumping data for table `[[dbprefix]]magento_bulk`
--


--
-- Table structure for table `[[dbprefix]]magento_login_as_customer_log`
--

CREATE TABLE `[[dbprefix]]magento_login_as_customer_log` (
  `log_id` int NOT NULL AUTO_INCREMENT COMMENT 'Log Id',
  `time` timestamp NULL DEFAULT NULL COMMENT 'Event Date',
  `user_id` int unsigned DEFAULT NULL COMMENT 'User Id',
  `user_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'User Name',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer Id',
  `customer_email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Customer email',
  PRIMARY KEY (`log_id`),
  KEY `[[DBPREFIX]]MAGENTO_LOGIN_AS_CUSTOMER_LOG_USER_ID` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Login as Customer Logging';

--
-- Dumping data for table `[[dbprefix]]magento_login_as_customer_log`
--


--
-- Table structure for table `[[dbprefix]]magento_operation`
--

CREATE TABLE `[[dbprefix]]magento_operation` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Operation ID',
  `operation_key` int unsigned DEFAULT NULL COMMENT 'Operation Key',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
  `topic_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Name of the related message queue topic',
  `serialized_data` blob COMMENT 'Data (serialized) required to perform an operation',
  `result_serialized_data` blob COMMENT 'Result data (serialized) after perform an operation',
  `status` smallint DEFAULT '0' COMMENT 'Operation status (OPEN | COMPLETE | RETRIABLY_FAILED | NOT_RETRIABLY_FAILED)',
  `error_code` smallint DEFAULT NULL COMMENT 'Code of the error that appeared during operation execution (used to aggregate related failed operations)',
  `result_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Operation result message',
  `started_at` timestamp NULL DEFAULT NULL COMMENT 'Datetime the operation started processing',
  PRIMARY KEY (`id`),
  KEY `[[DBPREFIX]]MAGENTO_OPERATION_BULK_UUID_ERROR_CODE` (`bulk_uuid`,`error_code`),
  KEY `[[DBPREFIX]]MAGENTO_OPERATION_STATUS_STARTED_AT` (`status`,`started_at`),
  CONSTRAINT `[[DBPREFIX]]MAGENTO_OPERATION_BULK_UUID_[[DBPREFIX]]MAGENTO_BULK_UUID` FOREIGN KEY (`bulk_uuid`) REFERENCES `[[dbprefix]]magento_bulk` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Operation entity';

--
-- Dumping data for table `[[dbprefix]]magento_operation`
--


--
-- Table structure for table `[[dbprefix]]media_content_asset`
--

CREATE TABLE `[[dbprefix]]media_content_asset` (
  `asset_id` int unsigned NOT NULL COMMENT 'Entity ID',
  `entity_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Content type',
  `entity_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Content entity id',
  `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Content field',
  PRIMARY KEY (`entity_type`,`entity_id`,`field`,`asset_id`),
  KEY `[[DBPREFIX]]MEDIA_CONTENT_ASSET_ASSET_ID` (`asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Relation between media content and media asset';

--
-- Dumping data for table `[[dbprefix]]media_content_asset`
--


--
-- Table structure for table `[[dbprefix]]media_gallery_asset`
--

CREATE TABLE `[[dbprefix]]media_gallery_asset` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Path',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Title',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Description',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Source',
  `hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'File hash',
  `content_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Content Type',
  `width` int unsigned NOT NULL DEFAULT '0' COMMENT 'Width',
  `height` int unsigned NOT NULL DEFAULT '0' COMMENT 'Height',
  `size` int unsigned NOT NULL COMMENT 'Asset file size in bytes',
  `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 `[[DBPREFIX]]MEDIA_GALLERY_ASSET_ID` (`id`),
  FULLTEXT KEY `[[DBPREFIX]]MEDIA_GALLERY_ASSET_TITLE` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Media Gallery Asset';

--
-- Dumping data for table `[[dbprefix]]media_gallery_asset`
--


--
-- Table structure for table `[[dbprefix]]media_gallery_asset_keyword`
--

CREATE TABLE `[[dbprefix]]media_gallery_asset_keyword` (
  `keyword_id` int unsigned NOT NULL COMMENT 'Keyword Id',
  `asset_id` int unsigned NOT NULL COMMENT 'Asset ID',
  PRIMARY KEY (`keyword_id`,`asset_id`),
  KEY `[[DBPREFIX]]MEDIA_GALLERY_ASSET_KEYWORD_ASSET_ID` (`asset_id`),
  KEY `[[DBPREFIX]]MEDIA_GALLERY_ASSET_KEYWORD_KEYWORD_ID` (`keyword_id`),
  CONSTRAINT `[[DBPREFIX]]MDA_GLR_ASSET_KEYWORD_ASSET_ID_[[DBPREFIX]]MDA_GLR_ASSET_ID` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]media_gallery_asset` (`id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]MDA_GLR_ASSET_KEYWORD_KEYWORD_ID_[[DBPREFIX]]MDA_GLR_KEYWORD_ID` FOREIGN KEY (`keyword_id`) REFERENCES `[[dbprefix]]media_gallery_keyword` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Media Gallery Asset Keyword';

--
-- Dumping data for table `[[dbprefix]]media_gallery_asset_keyword`
--


--
-- Table structure for table `[[dbprefix]]media_gallery_keyword`
--

CREATE TABLE `[[dbprefix]]media_gallery_keyword` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Keyword ID',
  `keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Keyword',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]MEDIA_GALLERY_KEYWORD_KEYWORD` (`keyword`),
  KEY `[[DBPREFIX]]MEDIA_GALLERY_KEYWORD_ID` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Media Gallery Keyword';

--
-- Dumping data for table `[[dbprefix]]media_gallery_keyword`
--


--
-- Table structure for table `[[dbprefix]]mview_state`
--

CREATE TABLE `[[dbprefix]]mview_state` (
  `state_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'View State ID',
  `view_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'View ID',
  `mode` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'disabled' COMMENT 'View Mode',
  `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'idle' COMMENT 'View Status',
  `updated` datetime DEFAULT NULL COMMENT 'View updated time',
  `version_id` int unsigned DEFAULT NULL COMMENT 'View Version ID',
  PRIMARY KEY (`state_id`),
  KEY `[[DBPREFIX]]MVIEW_STATE_VIEW_ID` (`view_id`),
  KEY `[[DBPREFIX]]MVIEW_STATE_MODE` (`mode`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='View State';

--
-- Dumping data for table `[[dbprefix]]mview_state`
--

INSERT INTO `[[dbprefix]]mview_state` VALUES (1,'cataloginventory_stock','enabled','idle','[[regtime]]',17897),(2,'design_config_dummy','enabled','idle','[[regtime]]',0),(3,'customer_dummy','enabled','idle','[[regtime]]',4),(4,'catalog_category_product','enabled','idle','[[regtime]]',314),(5,'catalog_product_category','enabled','idle','[[regtime]]',19825),(6,'catalogrule_rule','enabled','idle','[[regtime]]',1),(7,'catalog_product_attribute','enabled','idle','[[regtime]]',34053),(8,'inventory','enabled','idle','[[regtime]]',2040),(9,'catalog_product_price','enabled','idle','[[regtime]]',23880),(10,'catalogrule_product','enabled','idle','[[regtime]]',44099),(11,'catalogsearch_fulltext','enabled','idle','[[regtime]]',47994),(12,'sales_order_data_exporter','enabled','idle','[[regtime]]',16),(13,'sales_order_status_data_exporter','enabled','idle','[[regtime]]',12),(14,'store_data_exporter','enabled','idle','[[regtime]]',2);

--
-- Table structure for table `[[dbprefix]]newsletter_problem`
--

CREATE TABLE `[[dbprefix]]newsletter_problem` (
  `problem_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Problem ID',
  `subscriber_id` int unsigned DEFAULT NULL COMMENT 'Subscriber ID',
  `queue_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Queue ID',
  `problem_error_code` int unsigned DEFAULT '0' COMMENT 'Problem Error Code',
  `problem_error_text` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Problem Error Text',
  PRIMARY KEY (`problem_id`),
  KEY `[[DBPREFIX]]NEWSLETTER_PROBLEM_SUBSCRIBER_ID` (`subscriber_id`),
  KEY `[[DBPREFIX]]NEWSLETTER_PROBLEM_QUEUE_ID` (`queue_id`),
  CONSTRAINT `FK_9A0EF739131075541975180BD4666ABF` FOREIGN KEY (`subscriber_id`) REFERENCES `[[dbprefix]]newsletter_subscriber` (`subscriber_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]NEWSLETTER_PROBLEM_QUEUE_ID_[[DBPREFIX]]NEWSLETTER_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `[[dbprefix]]newsletter_queue` (`queue_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Newsletter Problems';

--
-- Dumping data for table `[[dbprefix]]newsletter_problem`
--


--
-- Table structure for table `[[dbprefix]]newsletter_queue`
--

CREATE TABLE `[[dbprefix]]newsletter_queue` (
  `queue_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue ID',
  `template_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Template ID',
  `newsletter_type` int DEFAULT NULL COMMENT 'Newsletter Type',
  `newsletter_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Newsletter Text',
  `newsletter_styles` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Newsletter Styles',
  `newsletter_subject` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Newsletter Subject',
  `newsletter_sender_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Newsletter Sender Name',
  `newsletter_sender_email` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Newsletter Sender Email',
  `queue_status` int 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 `[[DBPREFIX]]NEWSLETTER_QUEUE_TEMPLATE_ID` (`template_id`),
  CONSTRAINT `[[DBPREFIX]]NLTTR_QUEUE_TEMPLATE_ID_[[DBPREFIX]]NLTTR_TEMPLATE_TEMPLATE_ID` FOREIGN KEY (`template_id`) REFERENCES `[[dbprefix]]newsletter_template` (`template_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Newsletter Queue';

--
-- Dumping data for table `[[dbprefix]]newsletter_queue`
--


--
-- Table structure for table `[[dbprefix]]newsletter_queue_link`
--

CREATE TABLE `[[dbprefix]]newsletter_queue_link` (
  `queue_link_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue Link ID',
  `queue_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Queue ID',
  `subscriber_id` int 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 `[[DBPREFIX]]NEWSLETTER_QUEUE_LINK_SUBSCRIBER_ID` (`subscriber_id`),
  KEY `[[DBPREFIX]]NEWSLETTER_QUEUE_LINK_QUEUE_ID_LETTER_SENT_AT` (`queue_id`,`letter_sent_at`),
  CONSTRAINT `FK_C036601298B8945332203F84525A00FC` FOREIGN KEY (`subscriber_id`) REFERENCES `[[dbprefix]]newsletter_subscriber` (`subscriber_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]NLTTR_QUEUE_LNK_QUEUE_ID_[[DBPREFIX]]NLTTR_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `[[dbprefix]]newsletter_queue` (`queue_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Newsletter Queue Link';

--
-- Dumping data for table `[[dbprefix]]newsletter_queue_link`
--


--
-- Table structure for table `[[dbprefix]]newsletter_queue_store_link`
--

CREATE TABLE `[[dbprefix]]newsletter_queue_store_link` (
  `queue_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Queue ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`queue_id`,`store_id`),
  KEY `[[DBPREFIX]]NEWSLETTER_QUEUE_STORE_LINK_STORE_ID` (`store_id`),
  CONSTRAINT `[[DBPREFIX]]NEWSLETTER_QUEUE_STORE_LINK_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]NLTTR_QUEUE_STORE_LNK_QUEUE_ID_[[DBPREFIX]]NLTTR_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `[[dbprefix]]newsletter_queue` (`queue_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Newsletter Queue Store Link';

--
-- Dumping data for table `[[dbprefix]]newsletter_queue_store_link`
--


--
-- Table structure for table `[[dbprefix]]newsletter_subscriber`
--

CREATE TABLE `[[dbprefix]]newsletter_subscriber` (
  `subscriber_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Subscriber ID',
  `store_id` smallint unsigned DEFAULT '0' COMMENT 'Store ID',
  `change_status_at` timestamp NULL DEFAULT NULL COMMENT 'Change Status At',
  `customer_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `subscriber_email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Subscriber Email',
  `subscriber_status` int NOT NULL DEFAULT '0' COMMENT 'Subscriber Status',
  `subscriber_confirm_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'NULL' COMMENT 'Subscriber Confirm Code',
  PRIMARY KEY (`subscriber_id`),
  KEY `[[DBPREFIX]]NEWSLETTER_SUBSCRIBER_CUSTOMER_ID` (`customer_id`),
  KEY `[[DBPREFIX]]NEWSLETTER_SUBSCRIBER_STORE_ID` (`store_id`),
  KEY `[[DBPREFIX]]NEWSLETTER_SUBSCRIBER_SUBSCRIBER_EMAIL` (`subscriber_email`),
  CONSTRAINT `[[DBPREFIX]]NEWSLETTER_SUBSCRIBER_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Newsletter Subscriber';

--
-- Dumping data for table `[[dbprefix]]newsletter_subscriber`
--


--
-- Table structure for table `[[dbprefix]]newsletter_template`
--

CREATE TABLE `[[dbprefix]]newsletter_template` (
  `template_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Template ID',
  `template_code` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Template Code',
  `template_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Template Text',
  `template_styles` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Template Styles',
  `template_type` int unsigned DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Template Sender Email',
  `template_actual` smallint 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 `[[DBPREFIX]]NEWSLETTER_TEMPLATE_TEMPLATE_ACTUAL` (`template_actual`),
  KEY `[[DBPREFIX]]NEWSLETTER_TEMPLATE_ADDED_AT` (`added_at`),
  KEY `[[DBPREFIX]]NEWSLETTER_TEMPLATE_MODIFIED_AT` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Newsletter Template';

--
-- Dumping data for table `[[dbprefix]]newsletter_template`
--


--
-- Table structure for table `[[dbprefix]]oauth_consumer`
--

CREATE TABLE `[[dbprefix]]oauth_consumer` (
  `entity_id` int 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Name of consumer',
  `key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Key code',
  `secret` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Secret code',
  `callback_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Callback URL',
  `rejected_callback_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Rejected callback URL',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `[[DBPREFIX]]OAUTH_CONSUMER_KEY` (`key`),
  UNIQUE KEY `[[DBPREFIX]]OAUTH_CONSUMER_SECRET` (`secret`),
  KEY `[[DBPREFIX]]OAUTH_CONSUMER_CREATED_AT` (`created_at`),
  KEY `[[DBPREFIX]]OAUTH_CONSUMER_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='OAuth Consumers';

--
-- Dumping data for table `[[dbprefix]]oauth_consumer`
--


--
-- Table structure for table `[[dbprefix]]oauth_nonce`
--

CREATE TABLE `[[dbprefix]]oauth_nonce` (
  `nonce` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Nonce String',
  `timestamp` int unsigned NOT NULL COMMENT 'Nonce Timestamp',
  `consumer_id` int unsigned NOT NULL COMMENT 'Consumer ID',
  PRIMARY KEY (`nonce`,`consumer_id`),
  KEY `[[DBPREFIX]]OAUTH_NONCE_CONSUMER_ID_[[DBPREFIX]]OAUTH_CONSUMER_ENTITY_ID` (`consumer_id`),
  KEY `[[DBPREFIX]]OAUTH_NONCE_TIMESTAMP` (`timestamp`),
  CONSTRAINT `[[DBPREFIX]]OAUTH_NONCE_CONSUMER_ID_[[DBPREFIX]]OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `[[dbprefix]]oauth_consumer` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='OAuth Nonce';

--
-- Dumping data for table `[[dbprefix]]oauth_nonce`
--


--
-- Table structure for table `[[dbprefix]]oauth_token`
--

CREATE TABLE `[[dbprefix]]oauth_token` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `consumer_id` int unsigned DEFAULT NULL COMMENT 'Oauth Consumer ID',
  `admin_id` int unsigned DEFAULT NULL COMMENT 'Admin user ID',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer user ID',
  `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Token Type',
  `token` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Token',
  `secret` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Token Secret',
  `verifier` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Token Verifier',
  `callback_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Token Callback URL',
  `revoked` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token revoked',
  `authorized` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token authorized',
  `user_type` int DEFAULT NULL COMMENT 'User type',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Token creation timestamp',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `[[DBPREFIX]]OAUTH_TOKEN_TOKEN` (`token`),
  KEY `[[DBPREFIX]]OAUTH_TOKEN_ADMIN_ID_[[DBPREFIX]]ADMIN_USER_USER_ID` (`admin_id`),
  KEY `[[DBPREFIX]]OAUTH_TOKEN_CUSTOMER_ID_[[DBPREFIX]]CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
  KEY `[[DBPREFIX]]OAUTH_TOKEN_CONSUMER_ID` (`consumer_id`),
  KEY `[[DBPREFIX]]OAUTH_TOKEN_CREATED_AT` (`created_at`),
  CONSTRAINT `[[DBPREFIX]]OAUTH_TOKEN_ADMIN_ID_[[DBPREFIX]]ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`) REFERENCES `[[dbprefix]]admin_user` (`user_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]OAUTH_TOKEN_CONSUMER_ID_[[DBPREFIX]]OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `[[dbprefix]]oauth_consumer` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]OAUTH_TOKEN_CUSTOMER_ID_[[DBPREFIX]]CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='OAuth Tokens';

--
-- Dumping data for table `[[dbprefix]]oauth_token`
--


--
-- Table structure for table `[[dbprefix]]oauth_token_request_log`
--

CREATE TABLE `[[dbprefix]]oauth_token_request_log` (
  `log_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Customer email or admin login',
  `user_type` smallint unsigned NOT NULL COMMENT 'User type (admin or customer)',
  `failures_count` smallint 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 `[[DBPREFIX]]OAUTH_TOKEN_REQUEST_LOG_USER_NAME_USER_TYPE` (`user_name`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Log of token request authentication failures.';

--
-- Dumping data for table `[[dbprefix]]oauth_token_request_log`
--


--
-- Table structure for table `[[dbprefix]]pagebuilder_template`
--

CREATE TABLE `[[dbprefix]]pagebuilder_template` (
  `template_id` int NOT NULL AUTO_INCREMENT COMMENT 'Template ID Auto Increment',
  `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Template Name',
  `preview_image` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Template Preview Image',
  `template` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Master Format HTML',
  `created_for` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 `[[DBPREFIX]]PAGEBUILDER_TEMPLATE_NAME` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Page Builder Templates';

--
-- Dumping data for table `[[dbprefix]]pagebuilder_template`
--


--
-- Table structure for table `[[dbprefix]]password_reset_request_event`
--

CREATE TABLE `[[dbprefix]]password_reset_request_event` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `request_type` smallint unsigned NOT NULL COMMENT 'Type of the event under a security control',
  `account_reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Remote user IP',
  PRIMARY KEY (`id`),
  KEY `[[DBPREFIX]]PASSWORD_RESET_REQUEST_EVENT_ACCOUNT_REFERENCE` (`account_reference`),
  KEY `[[DBPREFIX]]PASSWORD_RESET_REQUEST_EVENT_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Password Reset Request Event under a security control';

--
-- Dumping data for table `[[dbprefix]]password_reset_request_event`
--


--
-- Table structure for table `[[dbprefix]]patch_list`
--

CREATE TABLE `[[dbprefix]]patch_list` (
  `patch_id` int NOT NULL AUTO_INCREMENT COMMENT 'Patch Auto Increment',
  `patch_name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Patch Class Name',
  PRIMARY KEY (`patch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8mb4 COMMENT='List of data/schema patches';

--
-- Dumping data for table `[[dbprefix]]patch_list`
--

INSERT INTO `[[dbprefix]]patch_list` VALUES (1,'Magento\\Store\\Setup\\Patch\\Schema\\InitializeStoresAndWebsites'),(2,'Magento\\Catalog\\Setup\\Patch\\Schema\\EnableSegmentation'),(3,'Magento\\CatalogRule\\Setup\\Patch\\Schema\\CleanUpProductPriceReplicaTable'),(4,'Magento\\Bundle\\Setup\\Patch\\Schema\\UpdateBundleRelatedSchema'),(5,'Magento\\TwoFactorAuth\\Setup\\Patch\\Schema\\CopyTablesFromOldModule'),(6,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\CreateLegacyStockStatusView'),(7,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\InitializeDefaultStock'),(8,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\UpdateInventorySourceItem'),(9,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\ReindexDefaultSource'),(10,'Magento\\InventorySales\\Setup\\Patch\\Schema\\InitializeWebsiteDefaultSock'),(11,'Magento\\Review\\Setup\\Patch\\Schema\\AddUniqueConstraintToReviewEntitySummary'),(12,'Magento\\Store\\Setup\\Patch\\Data\\DisableSid'),(13,'Magento\\Store\\Setup\\Patch\\Data\\UpdateStoreGroupCodes'),(14,'Magento\\Directory\\Setup\\Patch\\Data\\InitializeDirectoryData'),(15,'Magento\\Directory\\Setup\\Patch\\Data\\AddCountriesCaribbeanCuracaoKosovoSintMaarten'),(16,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForAlbania'),(17,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForArgentina'),(18,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForCroatia'),(19,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForIndia'),(20,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForAustralia'),(21,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForBelarus'),(22,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForBelgium'),(23,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForBolivia'),(24,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForBulgaria'),(25,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForChile'),(26,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForChina'),(27,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForColombia'),(28,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForCostaRica'),(29,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForCzechia'),(30,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForDenmark'),(31,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForEcuador'),(32,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForGreece'),(33,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForGuyana'),(34,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForIceland'),(35,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForItaly'),(36,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForMexico'),(37,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForParaguay'),(38,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForPeru'),(39,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForPoland'),(40,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForPortugal'),(41,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForSuriname'),(42,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForSweden'),(43,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForUkraine'),(44,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForUruguay'),(45,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForVenezuela'),(46,'Magento\\Directory\\Setup\\Patch\\Data\\AddRegionsForIndia'),(47,'Magento\\Directory\\Setup\\Patch\\Data\\UpdateRegionNamesForSwitzerland'),(48,'Magento\\Theme\\Setup\\Patch\\Data\\RegisterThemes'),(49,'Magento\\Theme\\Setup\\Patch\\Data\\ConvertSerializedData'),(50,'Magento\\Security\\Setup\\Patch\\Data\\SessionIDColumnCleanUp'),(51,'Magento\\Config\\Setup\\Patch\\Data\\RemoveTinymceConfig'),(52,'Magento\\Config\\Setup\\Patch\\Data\\UnsetTinymce3'),(53,'Magento\\Config\\Setup\\Patch\\Data\\UpdateClassAliases'),(54,'Magento\\User\\Setup\\Patch\\Data\\UpgradePasswordHashes'),(55,'Magento\\User\\Setup\\Patch\\Data\\UpgradeSerializedFields'),(56,'Magento\\Authorization\\Setup\\Patch\\Data\\InitializeAuthRoles'),(57,'Magento\\Eav\\Setup\\Patch\\Data\\InitializeAttributeModels'),(58,'Magento\\Customer\\Setup\\Patch\\Data\\DefaultCustomerGroupsAndAttributes'),(59,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAttributesMetadata'),(60,'Magento\\Customer\\Setup\\Patch\\Data\\AddNonSpecifiedGenderAttributeOption'),(61,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateIdentifierCustomerAttributesVisibility'),(62,'Magento\\Customer\\Setup\\Patch\\Data\\AddCustomerUpdatedAtAttribute'),(63,'Magento\\Customer\\Setup\\Patch\\Data\\UpgradePasswordHashAndAddress'),(64,'Magento\\Customer\\Setup\\Patch\\Data\\RemoveCheckoutRegisterAndUpdateAttributes'),(65,'Magento\\Customer\\Setup\\Patch\\Data\\AddSecurityTrackingAttributes'),(66,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateAutocompleteOnStorefrontConfigPath'),(67,'Magento\\Customer\\Setup\\Patch\\Data\\MigrateStoresAllowedCountriesToWebsite'),(68,'Magento\\Customer\\Setup\\Patch\\Data\\ConvertValidationRulesFromSerializedToJson'),(69,'Magento\\Customer\\Setup\\Patch\\Data\\SessionIDColumnCleanUp'),(70,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAddressAttributesSortOrder'),(71,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateVATNumber'),(72,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAttributeInputFilters'),(73,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateDefaultCustomerGroupInConfig'),(74,'Magento\\Indexer\\Setup\\Patch\\Data\\InitializeIndexerState'),(75,'Magento\\Cms\\Setup\\Patch\\Data\\CreateDefaultPages'),(76,'Magento\\Cms\\Setup\\Patch\\Data\\UpdatePrivacyPolicyPage'),(77,'Magento\\Cms\\Setup\\Patch\\Data\\ConvertWidgetConditionsToJson'),(78,'Magento\\Catalog\\Setup\\Patch\\Data\\InstallDefaultCategories'),(79,'Magento\\Catalog\\Setup\\Patch\\Data\\SetNewResourceModelsPaths'),(80,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateDefaultAttributeValue'),(81,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateMediaAttributesBackendTypes'),(82,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductAttributes'),(83,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductMetaDescription'),(84,'Magento\\Catalog\\Setup\\Patch\\Data\\ChangePriceAttributeDefaultScope'),(85,'Magento\\Catalog\\Setup\\Patch\\Data\\DisallowUsingHtmlForProductName'),(86,'Magento\\Catalog\\Setup\\Patch\\Data\\EnableDirectiveParsing'),(87,'Magento\\Catalog\\Setup\\Patch\\Data\\EnableSegmentation'),(88,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateCustomLayoutAttributes'),(89,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateDefaultSortyByBackendType'),(90,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateMultiselectAttributesBackendTypes'),(91,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductDescriptionOrder'),(92,'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\CreateUrlAttributes'),(93,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductUrlKey'),(94,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductUrlKeyBackendModel'),(95,'Magento\\Catalog\\Setup\\Patch\\Data\\UpgradeWidgetData'),(96,'Magento\\Catalog\\Setup\\Patch\\Data\\UpgradeWebsiteAttributes'),(97,'Magento\\Integration\\Setup\\Patch\\Data\\RemoveInactiveTokens'),(98,'Magento\\Integration\\Setup\\Patch\\Data\\UpgradeConsumerSecret'),(99,'Magento\\Integration\\Setup\\Patch\\Data\\UpgradeOauthToken'),(100,'Magento\\CatalogRule\\Setup\\Patch\\Data\\UpdateClassAliasesForCatalogRules'),(101,'Magento\\CatalogRule\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(102,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\CreateDefaultStock'),(103,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\UpdateStockItemsWebsite'),(104,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(105,'Magento\\CatalogSearch\\Setup\\Patch\\Data\\MySQLSearchRemovalNotification'),(106,'Magento\\CatalogSearch\\Setup\\Patch\\Data\\SetInitialSearchWeightForAttributes'),(107,'Magento\\Msrp\\Setup\\Patch\\Data\\InitializeMsrpAttributes'),(108,'Magento\\Msrp\\Setup\\Patch\\Data\\ChangeMsrpAttributeLabel'),(109,'Magento\\Msrp\\Setup\\Patch\\Data\\ChangePriceAttributeDefaultScope'),(110,'Magento\\Quote\\Setup\\Patch\\Data\\InstallEntityTypes'),(111,'Magento\\Quote\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(112,'Magento\\Quote\\Setup\\Patch\\Data\\WishlistDataCleanUp'),(113,'Magento\\Bundle\\Setup\\Patch\\Data\\ApplyAttributesUpdate'),(114,'Magento\\Bundle\\Setup\\Patch\\Data\\UpdateBundleRelatedEntityTypes'),(115,'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\UpdateUrlKeyForProducts'),(116,'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\UpdateUrlKeySearchable'),(117,'Magento\\Sales\\Setup\\Patch\\Data\\InstallOrderStatusesAndInitialSalesConfig'),(118,'Magento\\Sales\\Setup\\Patch\\Data\\UpdateEntityTypes'),(119,'Magento\\Sales\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(120,'Magento\\Sales\\Setup\\Patch\\Data\\FillQuoteAddressIdInSalesOrderAddress'),(121,'Magento\\Sales\\Setup\\Patch\\Data\\UpdateEntityTypeModelForInvoice'),(122,'Magento\\Sales\\Setup\\Patch\\Data\\WishlistDataCleanUp'),(123,'Magento\\MediaGalleryUi\\Setup\\Patch\\Data\\AddMediaGalleryPermissions'),(124,'Magento\\Downloadable\\Setup\\Patch\\Data\\AddDownloadableHostsConfig'),(125,'Magento\\Downloadable\\Setup\\Patch\\Data\\InstallDownloadableAttributes'),(126,'Magento\\Downloadable\\Setup\\Patch\\Data\\UpdateLinksExistDefaultAttributeValue'),(127,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\CopyConfigFromOldModule'),(128,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\EncryptConfiguration'),(129,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\EncryptGoogleSecrets'),(130,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\EncryptSecrets'),(131,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\PopulateCountryTable'),(132,'Magento\\TwoFactorAuth\\Setup\\Patch\\Data\\ResetU2fConfig'),(133,'Magento\\Checkout\\Setup\\Patch\\Data\\PrepareInitialCheckoutConfiguration'),(134,'Magento\\UrlRewrite\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(135,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\InstallInitialConfigurableAttributes'),(136,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\UpdateManufacturerAttribute'),(137,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\UpdateTierPriceAttribute'),(138,'Magento\\Tax\\Setup\\Patch\\Data\\AddTaxAttributeAndTaxClasses'),(139,'Magento\\Tax\\Setup\\Patch\\Data\\UpdateTaxClassAttributeVisibility'),(140,'Magento\\Tax\\Setup\\Patch\\Data\\UpdateTaxRegionId'),(141,'Magento\\Widget\\Setup\\Patch\\Data\\UpgradeModelInstanceClassAliases'),(142,'Magento\\Widget\\Setup\\Patch\\Data\\ConvertSerializedData'),(143,'Magento\\Analytics\\Setup\\Patch\\Data\\PrepareInitialConfig'),(144,'Magento\\Analytics\\Setup\\Patch\\Data\\ActivateDataCollection'),(145,'Magento\\Newsletter\\Setup\\Patch\\Data\\FlagLegacyTemplates'),(146,'Magento\\SampleData\\Setup\\Patch\\Data\\ClearSampleDataState'),(147,'Magento\\Dhl\\Setup\\Patch\\Data\\PrepareShipmentDays'),(148,'Magento\\GroupedProduct\\Setup\\Patch\\Data\\InitializeGroupedProductLinks'),(149,'Magento\\GroupedProduct\\Setup\\Patch\\Data\\UpdateProductRelations'),(150,'Magento\\Weee\\Setup\\Patch\\Data\\InitQuoteAndOrderAttributes'),(151,'Magento\\CatalogSampleData\\Setup\\Patch\\Data\\InstallCatalogSampleData'),(152,'Magento\\Elasticsearch\\Setup\\Patch\\Data\\InvalidateIndex'),(153,'Magento\\Email\\Setup\\Patch\\Data\\FlagLegacyTemplates'),(154,'Magento\\EncryptionKey\\Setup\\Patch\\Data\\SodiumChachaPatch'),(155,'Magento\\Fedex\\Setup\\Patch\\Data\\ConfigureFedexDefaults'),(156,'Magento\\GiftMessage\\Setup\\Patch\\Data\\AddGiftMessageAttributes'),(157,'Magento\\GiftMessage\\Setup\\Patch\\Data\\MoveGiftMessageToGiftOptionsGroup'),(158,'Magento\\GiftMessage\\Setup\\Patch\\Data\\UpdateGiftMessageAttribute'),(159,'Magento\\BundleSampleData\\Setup\\Patch\\Data\\InstallBundleSampleData'),(160,'Magento\\InventoryLowQuantityNotification\\Setup\\Patch\\Data\\MigrateCatalogInventoryNotifyStockQuantityData'),(161,'Magento\\Reports\\Setup\\Patch\\Data\\InitializeReportEntityTypesAndPages'),(162,'Magento\\Reports\\Setup\\Patch\\Data\\ReportDisableNotification'),(163,'Magento\\GroupedProductSampleData\\Setup\\Patch\\Data\\InstallGroupedProductSampleData'),(164,'Magento\\DownloadableSampleData\\Setup\\Patch\\Data\\InstallDownloadableSampleData'),(165,'Magento\\SalesRule\\Setup\\Patch\\Data\\PrepareRuleModelSerializedData'),(166,'Magento\\SalesRule\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(167,'Magento\\SalesRule\\Setup\\Patch\\Data\\FillSalesRuleProductAttributeTable'),(168,'Magento\\OfflineShipping\\Setup\\Patch\\Data\\UpdateQuoteShippingAddresses'),(169,'Magento\\OfflineShipping\\Setup\\Patch\\Data\\UpdateShippingTablerate'),(170,'Magento\\PageBuilder\\Setup\\Patch\\Data\\UpdateProductAttribute'),(171,'Magento\\PageBuilder\\Setup\\Patch\\Data\\UpgradePageBuilderStripStyles'),(172,'Magento\\ThemeSampleData\\Setup\\Patch\\Data\\InstallThemeSampleData'),(173,'Magento\\Vault\\Setup\\Patch\\Data\\SetCreditCardAsDefaultTokenType'),(174,'Magento\\Paypal\\Setup\\Patch\\Data\\AddPaypalOrderStatuses'),(175,'Magento\\Paypal\\Setup\\Patch\\Data\\UpdateBmltoPayLater'),(176,'Magento\\Paypal\\Setup\\Patch\\Data\\UpdatePaypalCreditOption'),(177,'Magento\\Paypal\\Setup\\Patch\\Data\\UpdateSmartButtonLabel'),(178,'Magento\\Paypal\\Setup\\Patch\\Data\\UpdateSmartButtonSize'),(179,'Magento\\ConfigurableSampleData\\Setup\\Patch\\Data\\InstallConfigurableSampleData'),(180,'Magento\\ServicesId\\Setup\\Patch\\Data\\RemoveKeySetEncryptedConfigFlag'),(181,'Magento\\ReCaptchaMigration\\Setup\\Patch\\Data\\MigrateConfigToRecaptchaModules'),(182,'Magento\\Review\\Setup\\Patch\\Data\\InitReviewStatusesAndData'),(183,'Magento\\ReviewSampleData\\Setup\\Patch\\Data\\InstallReviewSampleData'),(184,'Magento\\OfflineShippingSampleData\\Setup\\Patch\\Data\\InstallOfflineShippingSampleData'),(185,'Magento\\CatalogRuleSampleData\\Setup\\Patch\\Data\\InstallCatalogRuleSampleData'),(186,'Magento\\TaxSampleData\\Setup\\Patch\\Data\\InstallTaxSampleData'),(187,'Magento\\SalesRuleSampleData\\Setup\\Patch\\Data\\InstallSalesRuleSampleData'),(188,'Magento\\Swatches\\Setup\\Patch\\Data\\AddSwatchImageAttribute'),(189,'Magento\\Swatches\\Setup\\Patch\\Data\\AddSwatchImageToDefaultAttribtueSet'),(190,'Magento\\Swatches\\Setup\\Patch\\Data\\UpdateAdminTextSwatchValues'),(191,'Magento\\Swatches\\Setup\\Patch\\Data\\ConvertAdditionalDataToJson'),(192,'Magento\\SwatchesSampleData\\Setup\\Patch\\Data\\InstallSwatchesSampleData'),(193,'Magento\\MsrpSampleData\\Setup\\Patch\\Data\\InstallMsrpSampleData'),(194,'Magento\\CustomerSampleData\\Setup\\Patch\\Data\\InstallCustomerSampleData'),(195,'Magento\\CmsSampleData\\Setup\\Patch\\Data\\InstallCmsSampleData'),(196,'Magento\\SalesSampleData\\Setup\\Patch\\Data\\InstallSalesSampleData'),(197,'Magento\\Usps\\Setup\\Patch\\Data\\UpdateAllowedMethods'),(198,'Magento\\ProductLinksSampleData\\Setup\\Patch\\Data\\InstallProductLinksSampleData'),(199,'Magento\\CurrencySymbol\\Setup\\Patch\\Data\\ConvertSerializedCustomCurrencySymbolToJson'),(200,'Magento\\WidgetSampleData\\Setup\\Patch\\Data\\InstallWidgetSampleData'),(201,'Magento\\Wishlist\\Setup\\Patch\\Data\\ConvertSerializedData'),(202,'Magento\\Wishlist\\Setup\\Patch\\Data\\WishlistDataCleanUp'),(203,'Magento\\WishlistSampleData\\Setup\\Patch\\Data\\InstallWishlistSampleData');

--
-- Table structure for table `[[dbprefix]]payment_services_order_data_production_submitted_hash`
--

CREATE TABLE `[[dbprefix]]payment_services_order_data_production_submitted_hash` (
  `identifier` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Order identifier',
  `feed_hash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'feed_hash',
  `submitted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Submitted At',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Payment Services Order Feed Storage';

--
-- Dumping data for table `[[dbprefix]]payment_services_order_data_production_submitted_hash`
--


--
-- Table structure for table `[[dbprefix]]payment_services_order_data_sandbox_submitted_hash`
--

CREATE TABLE `[[dbprefix]]payment_services_order_data_sandbox_submitted_hash` (
  `identifier` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Order identifier',
  `feed_hash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'feed_hash',
  `submitted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Submitted At',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Payment Services Order Feed Storage';

--
-- Dumping data for table `[[dbprefix]]payment_services_order_data_sandbox_submitted_hash`
--


--
-- Table structure for table `[[dbprefix]]payment_services_order_status_data_prod_submitted_hash`
--

CREATE TABLE `[[dbprefix]]payment_services_order_status_data_prod_submitted_hash` (
  `identifier` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Order Status identifier',
  `feed_hash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'feed_hash',
  `submitted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Submitted At',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Payment Services Order Status Feed Storage';

--
-- Dumping data for table `[[dbprefix]]payment_services_order_status_data_prod_submitted_hash`
--


--
-- Table structure for table `[[dbprefix]]payment_services_order_status_data_sandbox_submitted_hash`
--

CREATE TABLE `[[dbprefix]]payment_services_order_status_data_sandbox_submitted_hash` (
  `identifier` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Order Status identifier',
  `feed_hash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'feed_hash',
  `submitted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Submitted At',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Payment Services Order Status Feed Storage';

--
-- Dumping data for table `[[dbprefix]]payment_services_order_status_data_sandbox_submitted_hash`
--


--
-- Table structure for table `[[dbprefix]]payment_services_store_data_production_submitted_hash`
--

CREATE TABLE `[[dbprefix]]payment_services_store_data_production_submitted_hash` (
  `identifier` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Store identifier',
  `feed_hash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'feed_hash',
  `submitted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Submitted At',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Payment Services Store Feed Storage';

--
-- Dumping data for table `[[dbprefix]]payment_services_store_data_production_submitted_hash`
--


--
-- Table structure for table `[[dbprefix]]payment_services_store_data_sandbox_submitted_hash`
--

CREATE TABLE `[[dbprefix]]payment_services_store_data_sandbox_submitted_hash` (
  `identifier` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Store identifier',
  `feed_hash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'feed_hash',
  `submitted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Submitted At',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Payment Services Store Feed Storage';

--
-- Dumping data for table `[[dbprefix]]payment_services_store_data_sandbox_submitted_hash`
--


--
-- Table structure for table `[[dbprefix]]paypal_billing_agreement`
--

CREATE TABLE `[[dbprefix]]paypal_billing_agreement` (
  `agreement_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Agreement ID',
  `customer_id` int unsigned NOT NULL COMMENT 'Customer ID',
  `method_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Method Code',
  `reference_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Reference ID',
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 unsigned DEFAULT NULL COMMENT 'Store ID',
  `agreement_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Agreement Label',
  PRIMARY KEY (`agreement_id`),
  KEY `[[DBPREFIX]]PAYPAL_BILLING_AGREEMENT_CUSTOMER_ID` (`customer_id`),
  KEY `[[DBPREFIX]]PAYPAL_BILLING_AGREEMENT_STORE_ID` (`store_id`),
  CONSTRAINT `[[DBPREFIX]]PAYPAL_BILLING_AGREEMENT_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE SET NULL,
  CONSTRAINT `[[DBPREFIX]]PAYPAL_BILLING_AGRT_CSTR_ID_[[DBPREFIX]]CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Sales Billing Agreement';

--
-- Dumping data for table `[[dbprefix]]paypal_billing_agreement`
--


--
-- Table structure for table `[[dbprefix]]paypal_billing_agreement_order`
--

CREATE TABLE `[[dbprefix]]paypal_billing_agreement_order` (
  `agreement_id` int unsigned NOT NULL COMMENT 'Agreement ID',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  PRIMARY KEY (`agreement_id`,`order_id`),
  KEY `[[DBPREFIX]]PAYPAL_BILLING_AGREEMENT_ORDER_ORDER_ID` (`order_id`),
  CONSTRAINT `FK_9EE0F3B5AE741E1A1BDDF5A663BFCB42` FOREIGN KEY (`agreement_id`) REFERENCES `[[dbprefix]]paypal_billing_agreement` (`agreement_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]PAYPAL_BILLING_AGRT_ORDER_ORDER_ID_[[DBPREFIX]]SALES_ORDER_ENTT_ID` FOREIGN KEY (`order_id`) REFERENCES `[[dbprefix]]sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Sales Billing Agreement Order';

--
-- Dumping data for table `[[dbprefix]]paypal_billing_agreement_order`
--


--
-- Table structure for table `[[dbprefix]]paypal_cert`
--

CREATE TABLE `[[dbprefix]]paypal_cert` (
  `cert_id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Cert ID',
  `website_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Content',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`cert_id`),
  KEY `[[DBPREFIX]]PAYPAL_CERT_WEBSITE_ID` (`website_id`),
  CONSTRAINT `[[DBPREFIX]]PAYPAL_CERT_WEBSITE_ID_[[DBPREFIX]]STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `[[dbprefix]]store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Paypal Certificate Table';

--
-- Dumping data for table `[[dbprefix]]paypal_cert`
--


--
-- Table structure for table `[[dbprefix]]paypal_payment_transaction`
--

CREATE TABLE `[[dbprefix]]paypal_payment_transaction` (
  `transaction_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `txn_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 `[[DBPREFIX]]PAYPAL_PAYMENT_TRANSACTION_TXN_ID` (`txn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='PayPal Payflow Link Payment Transaction';

--
-- Dumping data for table `[[dbprefix]]paypal_payment_transaction`
--


--
-- Table structure for table `[[dbprefix]]paypal_settlement_report`
--

CREATE TABLE `[[dbprefix]]paypal_settlement_report` (
  `report_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Report ID',
  `report_date` date DEFAULT NULL COMMENT 'Report Date',
  `account_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Account ID',
  `filename` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Filename',
  `last_modified` timestamp NULL DEFAULT NULL COMMENT 'Last Modified',
  PRIMARY KEY (`report_id`),
  UNIQUE KEY `[[DBPREFIX]]PAYPAL_SETTLEMENT_REPORT_REPORT_DATE_ACCOUNT_ID` (`report_date`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Paypal Settlement Report Table';

--
-- Dumping data for table `[[dbprefix]]paypal_settlement_report`
--


--
-- Table structure for table `[[dbprefix]]paypal_settlement_report_row`
--

CREATE TABLE `[[dbprefix]]paypal_settlement_report_row` (
  `row_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row ID',
  `report_id` int unsigned NOT NULL COMMENT 'Report ID',
  `transaction_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Transaction ID',
  `invoice_id` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Invoice ID',
  `paypal_reference_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Paypal Reference ID',
  `paypal_reference_id_type` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Paypal Reference ID Type',
  `transaction_event_code` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Gross Transaction Currency',
  `fee_debit_or_credit` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Fee Debit Or Credit',
  `fee_amount` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Fee Amount',
  `fee_currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Fee Currency',
  `custom_field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Custom Field',
  `consumer_id` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Consumer ID',
  `payment_tracking_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Payment Tracking ID',
  `store_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Store ID',
  PRIMARY KEY (`row_id`),
  KEY `[[DBPREFIX]]PAYPAL_SETTLEMENT_REPORT_ROW_REPORT_ID` (`report_id`),
  CONSTRAINT `FK_4B9222F51A9075175B75AB5C187FBFBF` FOREIGN KEY (`report_id`) REFERENCES `[[dbprefix]]paypal_settlement_report` (`report_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Paypal Settlement Report Row Table';

--
-- Dumping data for table `[[dbprefix]]paypal_settlement_report_row`
--


--
-- Table structure for table `[[dbprefix]]persistent_session`
--

CREATE TABLE `[[dbprefix]]persistent_session` (
  `persistent_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Session ID',
  `key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Unique cookie key',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  `website_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Session Data',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`persistent_id`),
  UNIQUE KEY `[[DBPREFIX]]PERSISTENT_SESSION_KEY` (`key`),
  UNIQUE KEY `[[DBPREFIX]]PERSISTENT_SESSION_CUSTOMER_ID` (`customer_id`),
  KEY `[[DBPREFIX]]PERSISTENT_SESSION_WEBSITE_ID_[[DBPREFIX]]STORE_WEBSITE_WEBSITE_ID` (`website_id`),
  KEY `[[DBPREFIX]]PERSISTENT_SESSION_UPDATED_AT` (`updated_at`),
  CONSTRAINT `[[DBPREFIX]]PERSISTENT_SESS_CSTR_ID_[[DBPREFIX]]CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]PERSISTENT_SESSION_WEBSITE_ID_[[DBPREFIX]]STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `[[dbprefix]]store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Persistent Session';

--
-- Dumping data for table `[[dbprefix]]persistent_session`
--


--
-- Table structure for table `[[dbprefix]]product_alert_price`
--

CREATE TABLE `[[dbprefix]]product_alert_price` (
  `alert_price_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product alert price ID',
  `customer_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `price` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Price amount',
  `website_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `store_id` smallint 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 unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert send count',
  `status` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert status',
  PRIMARY KEY (`alert_price_id`),
  KEY `[[DBPREFIX]]PRODUCT_ALERT_PRICE_CUSTOMER_ID` (`customer_id`),
  KEY `[[DBPREFIX]]PRODUCT_ALERT_PRICE_PRODUCT_ID` (`product_id`),
  KEY `[[DBPREFIX]]PRODUCT_ALERT_PRICE_WEBSITE_ID` (`website_id`),
  KEY `[[DBPREFIX]]PRODUCT_ALERT_PRICE_STORE_ID` (`store_id`),
  CONSTRAINT `[[DBPREFIX]]PRD_ALERT_PRICE_CSTR_ID_[[DBPREFIX]]CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]PRD_ALERT_PRICE_PRD_ID_[[DBPREFIX]]CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]PRD_ALERT_PRICE_WS_ID_[[DBPREFIX]]STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `[[dbprefix]]store_website` (`website_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]PRODUCT_ALERT_PRICE_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Product Alert Price';

--
-- Dumping data for table `[[dbprefix]]product_alert_price`
--


--
-- Table structure for table `[[dbprefix]]product_alert_stock`
--

CREATE TABLE `[[dbprefix]]product_alert_stock` (
  `alert_stock_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product alert stock ID',
  `customer_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `website_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `store_id` smallint 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 unsigned NOT NULL DEFAULT '0' COMMENT 'Send Count',
  `status` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert status',
  PRIMARY KEY (`alert_stock_id`),
  KEY `[[DBPREFIX]]PRODUCT_ALERT_STOCK_CUSTOMER_ID` (`customer_id`),
  KEY `[[DBPREFIX]]PRODUCT_ALERT_STOCK_PRODUCT_ID` (`product_id`),
  KEY `[[DBPREFIX]]PRODUCT_ALERT_STOCK_WEBSITE_ID` (`website_id`),
  KEY `[[DBPREFIX]]PRODUCT_ALERT_STOCK_STORE_ID` (`store_id`),
  CONSTRAINT `[[DBPREFIX]]PRD_ALERT_STOCK_CSTR_ID_[[DBPREFIX]]CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]PRD_ALERT_STOCK_PRD_ID_[[DBPREFIX]]CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]PRD_ALERT_STOCK_WS_ID_[[DBPREFIX]]STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `[[dbprefix]]store_website` (`website_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]PRODUCT_ALERT_STOCK_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Product Alert Stock';

--
-- Dumping data for table `[[dbprefix]]product_alert_stock`
--


--
-- Table structure for table `[[dbprefix]]queue`
--

CREATE TABLE `[[dbprefix]]queue` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Queue name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]QUEUE_NAME` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='Table storing unique queues';

--
-- Dumping data for table `[[dbprefix]]queue`
--

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

--
-- Table structure for table `[[dbprefix]]queue_lock`
--

CREATE TABLE `[[dbprefix]]queue_lock` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Message ID',
  `message_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 `[[DBPREFIX]]QUEUE_LOCK_MESSAGE_CODE` (`message_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Messages that were processed are inserted here to be locked.';

--
-- Dumping data for table `[[dbprefix]]queue_lock`
--


--
-- Table structure for table `[[dbprefix]]queue_message`
--

CREATE TABLE `[[dbprefix]]queue_message` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Message ID',
  `topic_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Message topic',
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Message body',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Queue messages';

--
-- Dumping data for table `[[dbprefix]]queue_message`
--

INSERT INTO `[[dbprefix]]queue_message` VALUES (1,'inventory.reservations.updateSalabilityStatus','{\"skus\":[],\"stock\":1}'),(2,'inventory.reservations.updateSalabilityStatus','{\"skus\":[\"WS03-XS-Red\"],\"stock\":1}'),(3,'inventory.reservations.updateSalabilityStatus','{\"skus\":[],\"stock\":1}'),(4,'inventory.reservations.updateSalabilityStatus','{\"skus\":[\"WS08-XS-Blue\"],\"stock\":1}');

--
-- Table structure for table `[[dbprefix]]queue_message_status`
--

CREATE TABLE `[[dbprefix]]queue_message_status` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Relation ID',
  `queue_id` int unsigned NOT NULL COMMENT 'Queue ID',
  `message_id` bigint unsigned NOT NULL COMMENT 'Message ID',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `status` smallint unsigned NOT NULL COMMENT 'Message status in particular queue',
  `number_of_trials` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Number of trials to processed failed message processing',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]QUEUE_MESSAGE_STATUS_QUEUE_ID_MESSAGE_ID` (`queue_id`,`message_id`),
  KEY `[[DBPREFIX]]QUEUE_MESSAGE_STATUS_MESSAGE_ID_[[DBPREFIX]]QUEUE_MESSAGE_ID` (`message_id`),
  KEY `[[DBPREFIX]]QUEUE_MESSAGE_STATUS_STATUS_UPDATED_AT` (`status`,`updated_at`),
  CONSTRAINT `[[DBPREFIX]]QUEUE_MESSAGE_STATUS_MESSAGE_ID_[[DBPREFIX]]QUEUE_MESSAGE_ID` FOREIGN KEY (`message_id`) REFERENCES `[[dbprefix]]queue_message` (`id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]QUEUE_MESSAGE_STATUS_QUEUE_ID_[[DBPREFIX]]QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `[[dbprefix]]queue` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Relation table to keep associations between queues and messages';

--
-- Dumping data for table `[[dbprefix]]queue_message_status`
--

INSERT INTO `[[dbprefix]]queue_message_status` VALUES (1,10,1,'[[regtime]]',2,0),(2,10,2,'[[regtime]]',2,0),(3,10,3,'[[regtime]]',2,0),(4,10,4,'[[regtime]]',2,0);

--
-- Table structure for table `[[dbprefix]]queue_poison_pill`
--

CREATE TABLE `[[dbprefix]]queue_poison_pill` (
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Poison Pill version.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Sequence table for poison pill versions';

--
-- Dumping data for table `[[dbprefix]]queue_poison_pill`
--

INSERT INTO `[[dbprefix]]queue_poison_pill` VALUES ('version-67f76561e98a4');

--
-- Table structure for table `[[dbprefix]]quote`
--

CREATE TABLE `[[dbprefix]]quote` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint 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 unsigned DEFAULT '1' COMMENT 'Is Active',
  `is_virtual` smallint unsigned DEFAULT '0' COMMENT 'Is Virtual',
  `is_multi_shipping` smallint unsigned DEFAULT '0' COMMENT 'Is Multi Shipping',
  `items_count` int unsigned DEFAULT '0' COMMENT 'Items Count',
  `items_qty` decimal(12,4) DEFAULT '0.0000' COMMENT 'Items Qty',
  `orig_order_id` int 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Base Currency Code',
  `store_currency_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Store Currency Code',
  `quote_currency_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Checkout Method',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  `customer_tax_class_id` int unsigned DEFAULT NULL COMMENT 'Customer Tax Class ID',
  `customer_group_id` int unsigned DEFAULT '0' COMMENT 'Customer Group ID',
  `customer_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Customer Email',
  `customer_prefix` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Customer Prefix',
  `customer_firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Customer Firstname',
  `customer_middlename` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Customer Middlename',
  `customer_lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Customer Lastname',
  `customer_suffix` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Customer Suffix',
  `customer_dob` datetime DEFAULT NULL COMMENT 'Customer Dob',
  `customer_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Customer Note',
  `customer_note_notify` smallint unsigned DEFAULT '1' COMMENT 'Customer Note Notify',
  `customer_is_guest` smallint unsigned DEFAULT '0' COMMENT 'Customer Is Guest',
  `remote_ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Remote Ip',
  `applied_rule_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Applied Rule Ids',
  `reserved_order_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Reserved Order ID',
  `password_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Password Hash',
  `coupon_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Coupon Code',
  `global_currency_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Customer Taxvat',
  `customer_gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 unsigned DEFAULT NULL COMMENT 'Is Changed',
  `trigger_recollect` smallint NOT NULL DEFAULT '0' COMMENT 'Trigger Recollect',
  `ext_shipping_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Ext Shipping Info',
  `gift_message_id` int DEFAULT NULL COMMENT 'Gift Message ID',
  `is_persistent` smallint unsigned DEFAULT '0' COMMENT 'Is Quote Persistent',
  PRIMARY KEY (`entity_id`),
  KEY `[[DBPREFIX]]QUOTE_CUSTOMER_ID_STORE_ID_IS_ACTIVE` (`customer_id`,`store_id`,`is_active`),
  KEY `[[DBPREFIX]]QUOTE_STORE_ID_UPDATED_AT` (`store_id`,`updated_at`),
  CONSTRAINT `[[DBPREFIX]]QUOTE_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='Sales Flat Quote';

--
-- Dumping data for table `[[dbprefix]]quote`
--

INSERT INTO `[[dbprefix]]quote` VALUES (1,1,'[[regtime]]','[[regtime]]',NULL,0,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',36.3900,36.3900,NULL,1,3,1,'roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,'1973-12-15 00:00:00',NULL,1,0,NULL,NULL,'000000001',NULL,NULL,'USD',1.0000,1.0000,NULL,'2',29.0000,29.0000,29.0000,29.0000,1,0,NULL,NULL,0),(2,1,'[[regtime]]','[[regtime]]',NULL,0,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',39.6400,39.6400,NULL,1,3,1,'roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,'1973-12-15 00:00:00',NULL,1,0,NULL,NULL,'000000002',NULL,NULL,'USD',1.0000,1.0000,NULL,'2',32.0000,32.0000,32.0000,32.0000,1,0,NULL,NULL,0);

--
-- Table structure for table `[[dbprefix]]quote_address`
--

CREATE TABLE `[[dbprefix]]quote_address` (
  `address_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address ID',
  `quote_id` int 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 unsigned DEFAULT NULL COMMENT 'Customer ID',
  `save_in_address_book` smallint DEFAULT '0' COMMENT 'Save In Address Book',
  `customer_address_id` int unsigned DEFAULT NULL COMMENT 'Customer Address ID',
  `address_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Address Type',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Email',
  `prefix` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Prefix',
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `middlename` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `suffix` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Suffix',
  `company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Company',
  `street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Street',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `region` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `region_id` int unsigned DEFAULT NULL COMMENT 'Region ID',
  `postcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Postcode',
  `country_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Country ID',
  `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fax` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `same_as_billing` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Same As Billing',
  `collect_shipping_rates` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Collect Shipping Rates',
  `shipping_method` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `shipping_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Customer Notes',
  `applied_taxes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Applied Taxes',
  `discount_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Vat ID',
  `vat_is_valid` smallint DEFAULT NULL COMMENT 'Vat Is Valid',
  `vat_request_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Vat Request ID',
  `vat_request_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Vat Request Date',
  `vat_request_success` smallint DEFAULT NULL COMMENT 'Vat Request Success',
  `validated_country_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Validated Country Code',
  `validated_vat_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Validated Vat Number',
  `gift_message_id` int DEFAULT NULL COMMENT 'Gift Message ID',
  `free_shipping` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
  PRIMARY KEY (`address_id`),
  KEY `[[DBPREFIX]]QUOTE_ADDRESS_QUOTE_ID` (`quote_id`),
  CONSTRAINT `[[DBPREFIX]]QUOTE_ADDRESS_QUOTE_ID_[[DBPREFIX]]QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `[[dbprefix]]quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Sales Flat Quote Address';

--
-- Dumping data for table `[[dbprefix]]quote_address`
--

INSERT INTO `[[dbprefix]]quote_address` VALUES (1,1,'[[regtime]]','[[regtime]]',1,0,1,'billing','roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,NULL,'6146 Honey Bluff Parkway','Calder','Michigan',33,'49628-7978','US','(555) 229-3326',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,0.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(2,1,'[[regtime]]','[[regtime]]',1,0,1,'shipping','roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,NULL,'6146 Honey Bluff Parkway','Calder','Michigan',33,'49628-7978','US','(555) 229-3326',NULL,1,0,'flatrate_flatrate','Flat Rate - Fixed',1.0000,29.0000,29.0000,29.0000,29.0000,2.3900,2.3900,5.0000,5.0000,0.0000,0.0000,0.0000,0.0000,36.3900,36.3900,NULL,'{\"US-MI-*-Rate 1\":{\"amount\":2.39,\"base_amount\":2.39,\"percent\":8.25,\"id\":\"US-MI-*-Rate 1\",\"rates\":[{\"percent\":8.25,\"code\":\"US-MI-*-Rate 1\",\"title\":\"US-MI-*-Rate 1\"}],\"item_id\":null,\"item_type\":\"product\",\"associated_item_id\":null,\"process\":0}}',NULL,0.0000,0.0000,31.3900,31.3900,0.0000,0.0000,0.0000,NULL,5.0000,5.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,2,'[[regtime]]','[[regtime]]',1,0,1,'billing','roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,NULL,'6146 Honey Bluff Parkway','Calder','Michigan',33,'49628-7978','US','(555) 229-3326',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,0.0000,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(4,2,'[[regtime]]','[[regtime]]',1,0,1,'shipping','roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,NULL,'6146 Honey Bluff Parkway','Calder','Michigan',33,'49628-7978','US','(555) 229-3326',NULL,1,0,'flatrate_flatrate','Flat Rate - Fixed',1.0000,32.0000,32.0000,32.0000,32.0000,2.6400,2.6400,5.0000,5.0000,0.0000,0.0000,0.0000,0.0000,39.6400,39.6400,NULL,'{\"US-MI-*-Rate 1\":{\"amount\":2.64,\"base_amount\":2.64,\"percent\":8.25,\"id\":\"US-MI-*-Rate 1\",\"rates\":[{\"percent\":8.25,\"code\":\"US-MI-*-Rate 1\",\"title\":\"US-MI-*-Rate 1\"}],\"item_id\":null,\"item_type\":\"product\",\"associated_item_id\":null,\"process\":0}}',NULL,0.0000,0.0000,34.6400,34.6400,0.0000,0.0000,0.0000,NULL,5.0000,5.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `[[dbprefix]]quote_address_item`
--

CREATE TABLE `[[dbprefix]]quote_address_item` (
  `address_item_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Item ID',
  `parent_item_id` int unsigned DEFAULT NULL COMMENT 'Parent Item ID',
  `quote_address_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Address ID',
  `quote_item_id` int 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Applied Rule Ids',
  `additional_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 unsigned DEFAULT NULL COMMENT 'Product ID',
  `super_product_id` int unsigned DEFAULT NULL COMMENT 'Super Product ID',
  `parent_product_id` int unsigned DEFAULT NULL COMMENT 'Parent Product ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `sku` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Sku',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Image',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Name',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Description',
  `is_qty_decimal` int 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 unsigned DEFAULT NULL COMMENT 'No Discount',
  `tax_percent` decimal(12,4) DEFAULT NULL COMMENT 'Tax Percent',
  `base_price` decimal(20,4) DEFAULT NULL COMMENT 'Base Price',
  `base_cost` decimal(20,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 DEFAULT NULL COMMENT 'Gift Message ID',
  `free_shipping` int unsigned DEFAULT NULL COMMENT 'Free Shipping',
  PRIMARY KEY (`address_item_id`),
  KEY `[[DBPREFIX]]QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS_ID` (`quote_address_id`),
  KEY `[[DBPREFIX]]QUOTE_ADDRESS_ITEM_PARENT_ITEM_ID` (`parent_item_id`),
  KEY `[[DBPREFIX]]QUOTE_ADDRESS_ITEM_QUOTE_ITEM_ID` (`quote_item_id`),
  KEY `[[DBPREFIX]]QUOTE_ADDRESS_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `FK_C8DC8D276B1E4E72CF56C0BA214DC849` FOREIGN KEY (`parent_item_id`) REFERENCES `[[dbprefix]]quote_address_item` (`address_item_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]QUOTE_ADDR_ITEM_QUOTE_ADDR_ID_[[DBPREFIX]]QUOTE_ADDR_ADDR_ID` FOREIGN KEY (`quote_address_id`) REFERENCES `[[dbprefix]]quote_address` (`address_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]QUOTE_ADDRESS_ITEM_QUOTE_ITEM_ID_[[DBPREFIX]]QUOTE_ITEM_ITEM_ID` FOREIGN KEY (`quote_item_id`) REFERENCES `[[dbprefix]]quote_item` (`item_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Sales Flat Quote Address Item';

--
-- Dumping data for table `[[dbprefix]]quote_address_item`
--


--
-- Table structure for table `[[dbprefix]]quote_id_mask`
--

CREATE TABLE `[[dbprefix]]quote_id_mask` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `quote_id` int unsigned NOT NULL COMMENT 'Quote ID',
  `masked_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Masked ID',
  PRIMARY KEY (`entity_id`,`quote_id`),
  KEY `[[DBPREFIX]]QUOTE_ID_MASK_QUOTE_ID` (`quote_id`),
  KEY `[[DBPREFIX]]QUOTE_ID_MASK_MASKED_ID` (`masked_id`),
  CONSTRAINT `[[DBPREFIX]]QUOTE_ID_MASK_QUOTE_ID_[[DBPREFIX]]QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `[[dbprefix]]quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Quote ID and masked ID mapping';

--
-- Dumping data for table `[[dbprefix]]quote_id_mask`
--


--
-- Table structure for table `[[dbprefix]]quote_item`
--

CREATE TABLE `[[dbprefix]]quote_item` (
  `item_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
  `quote_id` int 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 unsigned DEFAULT NULL COMMENT 'Product ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `parent_item_id` int unsigned DEFAULT NULL COMMENT 'Parent Item ID',
  `is_virtual` smallint unsigned DEFAULT NULL COMMENT 'Is Virtual',
  `sku` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Name',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Description',
  `applied_rule_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Applied Rule Ids',
  `additional_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Additional Data',
  `is_qty_decimal` smallint unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
  `no_discount` smallint 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(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `base_price` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Price',
  `custom_price` decimal(20,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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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(20,4) DEFAULT NULL COMMENT 'Original Custom Price',
  `redirect_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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',
  `weee_tax_applied` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Weee Tax Applied',
  `weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Amount',
  `weee_tax_applied_row_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Row Amount',
  `weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Disposition',
  `weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Row Disposition',
  `base_weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Amount',
  `base_weee_tax_applied_row_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Row Amnt',
  `base_weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Disposition',
  `base_weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Row Disposition',
  `gift_message_id` int DEFAULT NULL COMMENT 'Gift Message ID',
  `free_shipping` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
  PRIMARY KEY (`item_id`),
  KEY `[[DBPREFIX]]QUOTE_ITEM_PARENT_ITEM_ID` (`parent_item_id`),
  KEY `[[DBPREFIX]]QUOTE_ITEM_PRODUCT_ID` (`product_id`),
  KEY `[[DBPREFIX]]QUOTE_ITEM_QUOTE_ID` (`quote_id`),
  KEY `[[DBPREFIX]]QUOTE_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `[[DBPREFIX]]QUOTE_ITEM_PARENT_ITEM_ID_[[DBPREFIX]]QUOTE_ITEM_ITEM_ID` FOREIGN KEY (`parent_item_id`) REFERENCES `[[dbprefix]]quote_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]QUOTE_ITEM_QUOTE_ID_[[DBPREFIX]]QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `[[dbprefix]]quote` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]QUOTE_ITEM_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Sales Flat Quote Item';

--
-- Dumping data for table `[[dbprefix]]quote_item`
--

INSERT INTO `[[dbprefix]]quote_item` VALUES (1,1,'[[regtime]]','[[regtime]]',1428,1,NULL,0,'WS03-XS-Red','Iris Workout Top',NULL,NULL,NULL,0,0,1.0000,1.0000,29.0000,29.0000,NULL,0.0000,0.0000,0.0000,8.2500,2.3900,2.3900,29.0000,29.0000,0.0000,1.0000,'configurable',NULL,NULL,NULL,NULL,NULL,31.3900,31.3900,31.3900,31.3900,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(2,1,'[[regtime]]','[[regtime]]',1415,1,1,0,'WS03-XS-Red','Iris Workout Top-XS-Red',NULL,NULL,NULL,0,0,1.0000,1.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,2,'[[regtime]]','[[regtime]]',1492,1,NULL,0,'WS08-XS-Blue','Minerva LumaTech&trade; V-Tee',NULL,NULL,NULL,0,0,1.0000,1.0000,32.0000,32.0000,NULL,0.0000,0.0000,0.0000,8.2500,2.6400,2.6400,32.0000,32.0000,0.0000,1.0000,'configurable',NULL,NULL,NULL,NULL,NULL,34.6400,34.6400,34.6400,34.6400,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(4,2,'[[regtime]]','[[regtime]]',1478,1,3,0,'WS08-XS-Blue','Minerva LumaTech&trade; V-Tee-XS-Blue',NULL,NULL,NULL,0,0,1.0000,1.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `[[dbprefix]]quote_item_option`
--

CREATE TABLE `[[dbprefix]]quote_item_option` (
  `option_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `item_id` int unsigned NOT NULL COMMENT 'Item ID',
  `product_id` int unsigned NOT NULL COMMENT 'Product ID',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Code',
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Value',
  PRIMARY KEY (`option_id`),
  KEY `[[DBPREFIX]]QUOTE_ITEM_OPTION_ITEM_ID` (`item_id`),
  CONSTRAINT `[[DBPREFIX]]QUOTE_ITEM_OPTION_ITEM_ID_[[DBPREFIX]]QUOTE_ITEM_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `[[dbprefix]]quote_item` (`item_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='Sales Flat Quote Item Option';

--
-- Dumping data for table `[[dbprefix]]quote_item_option`
--

INSERT INTO `[[dbprefix]]quote_item_option` VALUES (1,1,1428,'info_buyRequest','{\"qty\":1,\"super_attribute\":{\"142\":\"166\",\"93\":\"58\"}}'),(2,1,1428,'attributes','{\"142\":\"166\",\"93\":\"58\"}'),(3,1,1415,'product_qty_1415','1'),(4,1,1415,'simple_product','1415'),(5,2,1415,'info_buyRequest','{\"qty\":1,\"super_attribute\":{\"142\":\"166\",\"93\":\"58\"}}'),(6,2,1415,'parent_product_id','1428'),(7,3,1492,'info_buyRequest','{\"qty\":1,\"super_attribute\":{\"142\":\"166\",\"93\":\"50\"}}'),(8,3,1492,'attributes','{\"142\":\"166\",\"93\":\"50\"}'),(9,3,1478,'product_qty_1478','1'),(10,3,1478,'simple_product','1478'),(11,4,1478,'info_buyRequest','{\"qty\":1,\"super_attribute\":{\"142\":\"166\",\"93\":\"50\"}}'),(12,4,1478,'parent_product_id','1492');

--
-- Table structure for table `[[dbprefix]]quote_payment`
--

CREATE TABLE `[[dbprefix]]quote_payment` (
  `payment_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Payment ID',
  `quote_id` int 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Method',
  `cc_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Cc Type',
  `cc_number_enc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Cc Number Enc',
  `cc_last_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Cc Last 4',
  `cc_cid_enc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Cc Cid Enc',
  `cc_owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Cc Owner',
  `cc_exp_month` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Cc Exp Month',
  `cc_exp_year` smallint unsigned DEFAULT '0' COMMENT 'Cc Exp Year',
  `cc_ss_owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Cc Ss Owner',
  `cc_ss_start_month` smallint unsigned DEFAULT '0' COMMENT 'Cc Ss Start Month',
  `cc_ss_start_year` smallint unsigned DEFAULT '0' COMMENT 'Cc Ss Start Year',
  `po_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Po Number',
  `additional_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Additional Data',
  `cc_ss_issue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Cc Ss Issue',
  `additional_information` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Additional Information',
  `paypal_payer_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Paypal Payer ID',
  `paypal_payer_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Paypal Payer Status',
  `paypal_correlation_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Paypal Correlation ID',
  PRIMARY KEY (`payment_id`),
  KEY `[[DBPREFIX]]QUOTE_PAYMENT_QUOTE_ID` (`quote_id`),
  CONSTRAINT `[[DBPREFIX]]QUOTE_PAYMENT_QUOTE_ID_[[DBPREFIX]]QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `[[dbprefix]]quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='Sales Flat Quote Payment';

--
-- Dumping data for table `[[dbprefix]]quote_payment`
--

INSERT INTO `[[dbprefix]]quote_payment` VALUES (1,1,'[[regtime]]','[[regtime]]','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL,'null',NULL,NULL,NULL),(2,2,'[[regtime]]','[[regtime]]','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL,'null',NULL,NULL,NULL);

--
-- Table structure for table `[[dbprefix]]quote_shipping_rate`
--

CREATE TABLE `[[dbprefix]]quote_shipping_rate` (
  `rate_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rate ID',
  `address_id` int 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Carrier',
  `carrier_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Carrier Title',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Code',
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Method',
  `method_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Method Description',
  `price` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Error Message',
  `method_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Method Title',
  PRIMARY KEY (`rate_id`),
  KEY `[[DBPREFIX]]QUOTE_SHIPPING_RATE_ADDRESS_ID` (`address_id`),
  CONSTRAINT `[[DBPREFIX]]QUOTE_SHPP_RATE_ADDR_ID_[[DBPREFIX]]QUOTE_ADDR_ADDR_ID` FOREIGN KEY (`address_id`) REFERENCES `[[dbprefix]]quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Sales Flat Quote Shipping Rate';

--
-- Dumping data for table `[[dbprefix]]quote_shipping_rate`
--

INSERT INTO `[[dbprefix]]quote_shipping_rate` VALUES (1,2,'[[regtime]]','[[regtime]]','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(2,2,'[[regtime]]','[[regtime]]','tablerate','Best Way','tablerate_bestway','bestway',NULL,15.0000,NULL,'Table Rate'),(3,4,'[[regtime]]','[[regtime]]','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(4,4,'[[regtime]]','[[regtime]]','tablerate','Best Way','tablerate_bestway','bestway',NULL,15.0000,NULL,'Table Rate');

--
-- Table structure for table `[[dbprefix]]rating`
--

CREATE TABLE `[[dbprefix]]rating` (
  `rating_id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rating ID',
  `entity_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `rating_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Rating Code',
  `position` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Position On Storefront',
  `is_active` smallint NOT NULL DEFAULT '1' COMMENT 'Rating is active.',
  PRIMARY KEY (`rating_id`),
  UNIQUE KEY `[[DBPREFIX]]RATING_RATING_CODE` (`rating_code`),
  KEY `[[DBPREFIX]]RATING_ENTITY_ID` (`entity_id`),
  CONSTRAINT `[[DBPREFIX]]RATING_ENTITY_ID_[[DBPREFIX]]RATING_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `[[dbprefix]]rating_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Ratings';

--
-- Dumping data for table `[[dbprefix]]rating`
--

INSERT INTO `[[dbprefix]]rating` VALUES (1,1,'Quality',0,1),(2,1,'Value',0,1),(3,1,'Price',0,1),(4,1,'Rating',0,1);

--
-- Table structure for table `[[dbprefix]]rating_entity`
--

CREATE TABLE `[[dbprefix]]rating_entity` (
  `entity_id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `entity_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Entity Code',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `[[DBPREFIX]]RATING_ENTITY_ENTITY_CODE` (`entity_code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='Rating entities';

--
-- Dumping data for table `[[dbprefix]]rating_entity`
--

INSERT INTO `[[dbprefix]]rating_entity` VALUES (1,'product'),(2,'product_review'),(3,'review');

--
-- Table structure for table `[[dbprefix]]rating_option`
--

CREATE TABLE `[[dbprefix]]rating_option` (
  `option_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rating Option ID',
  `rating_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating ID',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Rating Option Code',
  `value` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Option Value',
  `position` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Ration option position on Storefront',
  PRIMARY KEY (`option_id`),
  KEY `[[DBPREFIX]]RATING_OPTION_RATING_ID` (`rating_id`),
  CONSTRAINT `[[DBPREFIX]]RATING_OPTION_RATING_ID_[[DBPREFIX]]RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `[[dbprefix]]rating` (`rating_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='Rating options';

--
-- Dumping data for table `[[dbprefix]]rating_option`
--

INSERT INTO `[[dbprefix]]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),(16,4,'1',1,1),(17,4,'2',2,2),(18,4,'3',3,3),(19,4,'4',4,4),(20,4,'5',5,5);

--
-- Table structure for table `[[dbprefix]]rating_option_vote`
--

CREATE TABLE `[[dbprefix]]rating_option_vote` (
  `vote_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Vote ID',
  `option_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Vote option ID',
  `remote_ip` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Customer IP',
  `remote_ip_long` bigint NOT NULL DEFAULT '0' COMMENT 'Customer IP converted to long integer format',
  `customer_id` int unsigned DEFAULT '0' COMMENT 'Customer ID',
  `entity_pk_value` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `rating_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating ID',
  `review_id` bigint unsigned DEFAULT NULL COMMENT 'Review ID',
  `percent` smallint NOT NULL DEFAULT '0' COMMENT 'Percent amount',
  `value` smallint NOT NULL DEFAULT '0' COMMENT 'Vote option value',
  PRIMARY KEY (`vote_id`),
  KEY `[[DBPREFIX]]RATING_OPTION_VOTE_REVIEW_ID_[[DBPREFIX]]REVIEW_REVIEW_ID` (`review_id`),
  KEY `[[DBPREFIX]]RATING_OPTION_VOTE_OPTION_ID` (`option_id`),
  CONSTRAINT `[[DBPREFIX]]RATING_OPTION_VOTE_OPTION_ID_[[DBPREFIX]]RATING_OPTION_OPTION_ID` FOREIGN KEY (`option_id`) REFERENCES `[[dbprefix]]rating_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]RATING_OPTION_VOTE_REVIEW_ID_[[DBPREFIX]]REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `[[dbprefix]]review` (`review_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8mb4 COMMENT='Rating option values';

--
-- Dumping data for table `[[dbprefix]]rating_option_vote`
--

INSERT INTO `[[dbprefix]]rating_option_vote` VALUES (1,17,'',0,NULL,1,4,1,40,2),(2,18,'',0,NULL,1,4,2,60,3),(3,20,'',0,NULL,6,4,3,100,5),(4,18,'',0,NULL,6,4,4,60,3),(5,17,'',0,NULL,6,4,5,40,2),(6,19,'',0,NULL,3,4,6,80,4),(7,18,'',0,NULL,3,4,7,60,3),(8,18,'',0,NULL,3,4,8,60,3),(9,20,'',0,NULL,2,4,9,100,5),(10,19,'',0,NULL,2,4,10,80,4),(11,16,'',0,NULL,4,4,11,20,1),(12,19,'',0,NULL,4,4,12,80,4),(13,20,'',0,NULL,4,4,13,100,5),(14,20,'',0,NULL,5,4,14,100,5),(15,17,'',0,NULL,5,4,15,40,2),(16,20,'',0,NULL,37,4,16,100,5),(17,20,'',0,NULL,37,4,17,100,5),(18,18,'',0,NULL,37,4,18,60,3),(19,19,'',0,NULL,40,4,19,80,4),(20,19,'',0,NULL,40,4,20,80,4),(21,18,'',0,NULL,40,4,21,60,3),(22,18,'',0,NULL,38,4,22,60,3),(23,17,'',0,NULL,38,4,23,40,2),(24,17,'',0,NULL,38,4,24,40,2),(25,19,'',0,NULL,36,4,25,80,4),(26,19,'',0,NULL,36,4,26,80,4),(27,20,'',0,NULL,39,4,27,100,5),(28,19,'',0,NULL,39,4,28,80,4),(29,17,'',0,NULL,39,4,29,40,2),(30,17,'',0,NULL,39,4,30,40,2),(31,20,'',0,NULL,270,4,31,100,5),(32,19,'',0,NULL,270,4,32,80,4),(33,20,'',0,NULL,286,4,33,100,5),(34,19,'',0,NULL,286,4,34,80,4),(35,17,'',0,NULL,414,4,35,40,2),(36,17,'',0,NULL,414,4,36,40,2),(37,19,'',0,NULL,414,4,37,80,4),(38,20,'',0,NULL,302,4,38,100,5),(39,19,'',0,NULL,302,4,39,80,4),(40,20,'',0,NULL,302,4,40,100,5),(41,20,'',0,NULL,398,4,41,100,5),(42,18,'',0,NULL,398,4,42,60,3),(43,19,'',0,NULL,398,4,43,80,4),(44,17,'',0,NULL,318,4,44,40,2),(45,18,'',0,NULL,318,4,45,60,3),(46,18,'',0,NULL,334,4,46,60,3),(47,18,'',0,NULL,334,4,47,60,3),(48,19,'',0,NULL,334,4,48,80,4),(49,19,'',0,NULL,350,4,49,80,4),(50,18,'',0,NULL,350,4,50,60,3),(51,19,'',0,NULL,366,4,51,80,4),(52,18,'',0,NULL,366,4,52,60,3),(53,17,'',0,NULL,737,4,53,40,2),(54,19,'',0,NULL,737,4,54,80,4),(55,16,'',0,NULL,737,4,55,20,1),(56,17,'',0,NULL,750,4,56,40,2),(57,17,'',0,NULL,750,4,57,40,2),(58,18,'',0,NULL,750,4,58,60,3),(59,19,'',0,NULL,763,4,59,80,4),(60,18,'',0,NULL,763,4,60,60,3),(61,19,'',0,NULL,776,4,61,80,4),(62,20,'',0,NULL,776,4,62,100,5),(63,19,'',0,NULL,776,4,63,80,4),(64,19,'',0,NULL,789,4,64,80,4),(65,19,'',0,NULL,789,4,65,80,4),(66,18,'',0,NULL,789,4,66,60,3),(67,18,'',0,NULL,558,4,67,60,3),(68,19,'',0,NULL,558,4,68,80,4),(69,20,'',0,NULL,558,4,69,100,5),(70,20,'',0,NULL,574,4,70,100,5),(71,19,'',0,NULL,574,4,71,80,4),(72,20,'',0,NULL,526,4,72,100,5),(73,16,'',0,NULL,526,4,73,20,1),(74,20,'',0,NULL,446,4,74,100,5),(75,17,'',0,NULL,446,4,75,40,2),(76,18,'',0,NULL,446,4,76,60,3),(77,20,'',0,NULL,462,4,77,100,5),(78,19,'',0,NULL,462,4,78,80,4),(79,18,'',0,NULL,462,4,79,60,3),(80,18,'',0,NULL,542,4,80,60,3),(81,19,'',0,NULL,542,4,81,80,4),(82,18,'',0,NULL,606,4,82,60,3),(83,18,'',0,NULL,606,4,83,60,3),(84,19,'',0,NULL,606,4,84,80,4),(85,20,'',0,NULL,622,4,85,100,5),(86,18,'',0,NULL,622,4,86,60,3),(87,18,'',0,NULL,622,4,87,60,3),(88,17,'',0,NULL,622,4,88,40,2),(89,19,'',0,NULL,478,4,89,80,4),(90,17,'',0,NULL,478,4,90,40,2),(91,20,'',0,NULL,478,4,91,100,5),(92,20,'',0,NULL,590,4,92,100,5),(93,16,'',0,NULL,590,4,93,20,1),(94,18,'',0,NULL,590,4,94,60,3),(95,19,'',0,NULL,494,4,95,80,4),(96,18,'',0,NULL,494,4,96,60,3),(97,20,'',0,NULL,494,4,97,100,5),(98,16,'',0,NULL,510,4,98,20,1),(99,17,'',0,NULL,510,4,99,40,2),(100,20,'',0,NULL,510,4,100,100,5),(101,19,'',0,NULL,893,4,101,80,4),(102,19,'',0,NULL,893,4,102,80,4),(103,19,'',0,NULL,893,4,103,80,4),(104,18,'',0,NULL,911,4,104,60,3),(105,19,'',0,NULL,911,4,105,80,4),(106,19,'',0,NULL,911,4,106,80,4),(107,17,'',0,NULL,924,4,107,40,2),(108,18,'',0,NULL,924,4,108,60,3),(109,19,'',0,NULL,924,4,109,80,4),(110,20,'',0,NULL,937,4,110,100,5),(111,17,'',0,NULL,937,4,111,40,2),(112,19,'',0,NULL,937,4,112,80,4),(113,18,'',0,NULL,950,4,113,60,3),(114,19,'',0,NULL,950,4,114,80,4),(115,20,'',0,NULL,963,4,115,100,5),(116,20,'',0,NULL,963,4,116,100,5),(117,18,'',0,NULL,963,4,117,60,3),(118,19,'',0,NULL,976,4,118,80,4),(119,17,'',0,NULL,976,4,119,40,2),(120,18,'',0,NULL,989,4,120,60,3),(121,18,'',0,NULL,989,4,121,60,3),(122,19,'',0,NULL,989,4,122,80,4),(123,16,'',0,NULL,638,4,123,20,1),(124,19,'',0,NULL,638,4,124,80,4),(125,18,'',0,NULL,638,4,125,60,3),(126,18,'',0,NULL,638,4,126,60,3),(127,18,'',0,NULL,654,4,127,60,3),(128,19,'',0,NULL,654,4,128,80,4),(129,20,'',0,NULL,654,4,129,100,5),(130,18,'',0,NULL,670,4,130,60,3),(131,18,'',0,NULL,670,4,131,60,3),(132,17,'',0,NULL,670,4,132,40,2),(133,17,'',0,NULL,676,4,133,40,2),(134,18,'',0,NULL,676,4,134,60,3),(135,19,'',0,NULL,676,4,135,80,4),(136,20,'',0,NULL,676,4,136,100,5),(137,20,'',0,NULL,7,4,137,100,5),(138,19,'',0,NULL,7,4,138,80,4),(139,18,'',0,NULL,7,4,139,60,3),(140,20,'',0,NULL,20,4,140,100,5),(141,19,'',0,NULL,20,4,141,80,4),(142,16,'',0,NULL,20,4,142,20,1),(143,18,'',0,NULL,18,4,143,60,3),(144,18,'',0,NULL,18,4,144,60,3),(145,20,'',0,NULL,23,4,145,100,5),(146,16,'',0,NULL,23,4,146,20,1),(147,18,'',0,NULL,23,4,147,60,3),(148,19,'',0,NULL,17,4,148,80,4),(149,20,'',0,NULL,17,4,149,100,5),(150,20,'',0,NULL,17,4,150,100,5),(151,20,'',0,NULL,19,4,151,100,5),(152,18,'',0,NULL,19,4,152,60,3),(153,20,'',0,NULL,19,4,153,100,5),(154,18,'',0,NULL,15,4,154,60,3),(155,20,'',0,NULL,16,4,155,100,5),(156,20,'',0,NULL,16,4,156,100,5),(157,19,'',0,NULL,8,4,157,80,4),(158,18,'',0,NULL,8,4,158,60,3),(159,18,'',0,NULL,8,4,159,60,3),(160,19,'',0,NULL,9,4,160,80,4),(161,18,'',0,NULL,9,4,161,60,3),(162,20,'',0,NULL,12,4,162,100,5),(163,19,'',0,NULL,12,4,163,80,4),(164,19,'',0,NULL,14,4,164,80,4),(165,18,'',0,NULL,14,4,165,60,3),(166,18,'',0,NULL,14,4,166,60,3),(167,20,'',0,NULL,10,4,167,100,5),(168,18,'',0,NULL,10,4,168,60,3),(169,20,'',0,NULL,11,4,169,100,5),(170,20,'',0,NULL,11,4,170,100,5),(171,16,'',0,NULL,11,4,171,20,1),(172,17,'',0,NULL,13,4,172,40,2),(173,19,'',0,NULL,13,4,173,80,4),(174,18,'',0,NULL,13,4,174,60,3),(175,19,'',0,NULL,42,4,175,80,4),(176,18,'',0,NULL,42,4,176,60,3),(177,18,'',0,NULL,42,4,177,60,3),(178,20,'',0,NULL,44,4,178,100,5),(179,17,'',0,NULL,44,4,179,40,2),(180,17,'',0,NULL,43,4,180,40,2),(181,18,'',0,NULL,43,4,181,60,3),(182,18,'',0,NULL,43,4,182,60,3),(183,19,'',0,NULL,41,4,183,80,4),(184,19,'',0,NULL,41,4,184,80,4),(185,18,'',0,NULL,1044,4,185,60,3),(186,20,'',0,NULL,1044,4,186,100,5),(187,20,'',0,NULL,1044,4,187,100,5),(188,20,'',0,NULL,1060,4,188,100,5),(189,16,'',0,NULL,1060,4,189,20,1),(190,19,'',0,NULL,1060,4,190,80,4),(191,19,'',0,NULL,1076,4,191,80,4),(192,18,'',0,NULL,1076,4,192,60,3),(193,17,'',0,NULL,1076,4,193,40,2),(194,17,'',0,NULL,1092,4,194,40,2),(195,19,'',0,NULL,1092,4,195,80,4),(196,18,'',0,NULL,1092,4,196,60,3),(197,19,'',0,NULL,1108,4,197,80,4),(198,19,'',0,NULL,1108,4,198,80,4),(199,19,'',0,NULL,1108,4,199,80,4),(200,19,'',0,NULL,1114,4,200,80,4),(201,19,'',0,NULL,1114,4,201,80,4),(202,18,'',0,NULL,1220,4,202,60,3),(203,19,'',0,NULL,1220,4,203,80,4),(204,18,'',0,NULL,1220,4,204,60,3),(205,20,'',0,NULL,1236,4,205,100,5),(206,17,'',0,NULL,1236,4,206,40,2),(207,18,'',0,NULL,1236,4,207,60,3),(208,19,'',0,NULL,1236,4,208,80,4),(209,20,'',0,NULL,1252,4,209,100,5),(210,20,'',0,NULL,1252,4,210,100,5),(211,18,'',0,NULL,1252,4,211,60,3),(212,20,'',0,NULL,1268,4,212,100,5),(213,19,'',0,NULL,1268,4,213,80,4),(214,19,'',0,NULL,1284,4,214,80,4),(215,19,'',0,NULL,1284,4,215,80,4),(216,20,'',0,NULL,1284,4,216,100,5),(217,18,'',0,NULL,1380,4,217,60,3),(218,20,'',0,NULL,1380,4,218,100,5),(219,20,'',0,NULL,1380,4,219,100,5),(220,18,'',0,NULL,1300,4,220,60,3),(221,17,'',0,NULL,1300,4,221,40,2),(222,20,'',0,NULL,1300,4,222,100,5),(223,20,'',0,NULL,1316,4,223,100,5),(224,16,'',0,NULL,1316,4,224,20,1),(225,19,'',0,NULL,1332,4,225,80,4),(226,19,'',0,NULL,1332,4,226,80,4),(227,20,'',0,NULL,1332,4,227,100,5),(228,18,'',0,NULL,1348,4,228,60,3),(229,18,'',0,NULL,1348,4,229,60,3),(230,18,'',0,NULL,1348,4,230,60,3),(231,20,'',0,NULL,1364,4,231,100,5),(232,18,'',0,NULL,1364,4,232,60,3),(233,20,'',0,NULL,1364,4,233,100,5),(234,19,'',0,NULL,1819,4,234,80,4),(235,19,'',0,NULL,1819,4,235,80,4),(236,20,'',0,NULL,1826,4,236,100,5),(237,19,'',0,NULL,1826,4,237,80,4),(238,20,'',0,NULL,1826,4,238,100,5),(239,20,'',0,NULL,1833,4,239,100,5),(240,19,'',0,NULL,1833,4,240,80,4),(241,16,'',0,NULL,1833,4,241,20,1),(242,19,'',0,NULL,1840,4,242,80,4),(243,20,'',0,NULL,1840,4,243,100,5),(244,20,'',0,NULL,1840,4,244,100,5),(245,17,'',0,NULL,1840,4,245,40,2),(246,18,'',0,NULL,1847,4,246,60,3),(247,18,'',0,NULL,1847,4,247,60,3),(248,18,'',0,NULL,1854,4,248,60,3),(249,17,'',0,NULL,1854,4,249,40,2),(250,20,'',0,NULL,1854,4,250,100,5),(251,20,'',0,NULL,1572,4,251,100,5),(252,19,'',0,NULL,1572,4,252,80,4),(253,19,'',0,NULL,1572,4,253,80,4),(254,19,'',0,NULL,1412,4,254,80,4),(255,18,'',0,NULL,1412,4,255,60,3),(256,19,'',0,NULL,1412,4,256,80,4),(257,20,'',0,NULL,1428,4,257,100,5),(258,17,'',0,NULL,1428,4,258,40,2),(259,18,'',0,NULL,1428,4,259,60,3),(260,17,'',0,NULL,1428,4,260,40,2),(261,17,'',0,NULL,1444,4,261,40,2),(262,19,'',0,NULL,1444,4,262,80,4),(263,19,'',0,NULL,1588,4,263,80,4),(264,20,'',0,NULL,1588,4,264,100,5),(265,17,'',0,NULL,1588,4,265,40,2),(266,17,'',0,NULL,1476,4,266,40,2),(267,19,'',0,NULL,1476,4,267,80,4),(268,19,'',0,NULL,1492,4,268,80,4),(269,16,'',0,NULL,1492,4,269,20,1),(270,17,'',0,NULL,1492,4,270,40,2),(271,19,'',0,NULL,1508,4,271,80,4),(272,18,'',0,NULL,1508,4,272,60,3),(273,19,'',0,NULL,1508,4,273,80,4),(274,20,'',0,NULL,1524,4,274,100,5),(275,19,'',0,NULL,1524,4,275,80,4),(276,18,'',0,NULL,1524,4,276,60,3),(277,18,'',0,NULL,1540,4,277,60,3),(278,20,'',0,NULL,1540,4,278,100,5),(279,20,'',0,NULL,1540,4,279,100,5),(280,18,'',0,NULL,1556,4,280,60,3),(281,17,'',0,NULL,1556,4,281,40,2),(282,19,'',0,NULL,1556,4,282,80,4),(283,19,'',0,NULL,1919,4,283,80,4),(284,18,'',0,NULL,1919,4,284,60,3),(285,17,'',0,NULL,1919,4,285,40,2),(286,20,'',0,NULL,1935,4,286,100,5),(287,20,'',0,NULL,1935,4,287,100,5),(288,17,'',0,NULL,1935,4,288,40,2),(289,20,'',0,NULL,1951,4,289,100,5),(290,19,'',0,NULL,1951,4,290,80,4),(291,19,'',0,NULL,1967,4,291,80,4),(292,19,'',0,NULL,1967,4,292,80,4),(293,17,'',0,NULL,1983,4,293,40,2),(294,19,'',0,NULL,1983,4,294,80,4),(295,20,'',0,NULL,1983,4,295,100,5),(296,18,'',0,NULL,1990,4,296,60,3),(297,19,'',0,NULL,1990,4,297,80,4),(298,20,'',0,NULL,1997,4,298,100,5),(299,17,'',0,NULL,1997,4,299,40,2),(300,18,'',0,NULL,1997,4,300,60,3),(301,20,'',0,NULL,2003,4,301,100,5),(302,19,'',0,NULL,2003,4,302,80,4),(303,20,'',0,NULL,2003,4,303,100,5),(304,16,'',0,NULL,2010,4,304,20,1),(305,19,'',0,NULL,2010,4,305,80,4),(306,20,'',0,NULL,2010,4,306,100,5),(307,19,'',0,NULL,2017,4,307,80,4),(308,20,'',0,NULL,2017,4,308,100,5),(309,18,'',0,NULL,2017,4,309,60,3),(310,20,'',0,NULL,2024,4,310,100,5),(311,19,'',0,NULL,2024,4,311,80,4),(312,17,'',0,NULL,2024,4,312,40,2),(313,16,'',0,NULL,2040,4,313,20,1),(314,18,'',0,NULL,2040,4,314,60,3),(315,20,'',0,NULL,2040,4,315,100,5),(316,18,'',0,NULL,1604,4,316,60,3),(317,19,'',0,NULL,1604,4,317,80,4),(318,19,'',0,NULL,1604,4,318,80,4),(319,19,'',0,NULL,1604,4,319,80,4),(320,17,'',0,NULL,1620,4,320,40,2),(321,16,'',0,NULL,1620,4,321,20,1),(322,20,'',0,NULL,1620,4,322,100,5),(323,19,'',0,NULL,1620,4,323,80,4),(324,19,'',0,NULL,1636,4,324,80,4),(325,17,'',0,NULL,1636,4,325,40,2),(326,19,'',0,NULL,1636,4,326,80,4),(327,17,'',0,NULL,1652,4,327,40,2),(328,19,'',0,NULL,1652,4,328,80,4),(329,18,'',0,NULL,1652,4,329,60,3),(330,16,'',0,NULL,1668,4,330,20,1),(331,17,'',0,NULL,1668,4,331,40,2),(332,18,'',0,NULL,1668,4,332,60,3),(333,20,'',0,NULL,1764,4,333,100,5),(334,19,'',0,NULL,1764,4,334,80,4),(335,17,'',0,NULL,1764,4,335,40,2),(336,19,'',0,NULL,1780,4,336,80,4),(337,17,'',0,NULL,1796,4,337,40,2),(338,18,'',0,NULL,1796,4,338,60,3),(339,19,'',0,NULL,1796,4,339,80,4),(340,19,'',0,NULL,1812,4,340,80,4),(341,18,'',0,NULL,1812,4,341,60,3),(342,19,'',0,NULL,1684,4,342,80,4),(343,19,'',0,NULL,1684,4,343,80,4),(344,18,'',0,NULL,1700,4,344,60,3),(345,17,'',0,NULL,1700,4,345,40,2),(346,18,'',0,NULL,1700,4,346,60,3);

--
-- Table structure for table `[[dbprefix]]rating_option_vote_aggregated`
--

CREATE TABLE `[[dbprefix]]rating_option_vote_aggregated` (
  `primary_id` int NOT NULL AUTO_INCREMENT COMMENT 'Vote aggregation ID',
  `rating_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating ID',
  `entity_pk_value` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `vote_count` int unsigned NOT NULL DEFAULT '0' COMMENT 'Vote dty',
  `vote_value_sum` int unsigned NOT NULL DEFAULT '0' COMMENT 'General vote sum',
  `percent` smallint NOT NULL DEFAULT '0' COMMENT 'Vote percent',
  `percent_approved` smallint DEFAULT '0' COMMENT 'Vote percent approved by admin',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`primary_id`),
  KEY `[[DBPREFIX]]RATING_OPTION_VOTE_AGGREGATED_RATING_ID` (`rating_id`),
  KEY `[[DBPREFIX]]RATING_OPTION_VOTE_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `[[DBPREFIX]]RATING_OPT_VOTE_AGGRED_RATING_ID_[[DBPREFIX]]RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `[[dbprefix]]rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]RATING_OPTION_VOTE_AGGREGATED_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=utf8mb4 COMMENT='Rating vote aggregated';

--
-- Dumping data for table `[[dbprefix]]rating_option_vote_aggregated`
--

INSERT INTO `[[dbprefix]]rating_option_vote_aggregated` VALUES (1,4,1,2,5,50,50,0),(2,4,1,2,5,50,50,1),(3,4,6,3,10,67,67,0),(4,4,6,3,10,67,67,1),(5,4,3,3,10,67,67,0),(6,4,3,3,10,67,67,1),(7,4,2,2,9,90,90,0),(8,4,2,2,9,90,90,1),(9,4,4,3,10,67,67,0),(10,4,4,3,10,67,67,1),(11,4,5,2,7,70,70,0),(12,4,5,2,7,70,70,1),(13,4,37,3,13,87,87,0),(14,4,37,3,13,87,87,1),(15,4,40,3,11,73,73,0),(16,4,40,3,11,73,73,1),(17,4,38,3,7,47,47,0),(18,4,38,3,7,47,47,1),(19,4,36,2,8,80,80,0),(20,4,36,2,8,80,80,1),(21,4,39,4,13,65,65,0),(22,4,39,4,13,65,65,1),(23,4,270,2,9,90,90,0),(24,4,270,2,9,90,90,1),(25,4,286,2,9,90,90,0),(26,4,286,2,9,90,90,1),(27,4,414,3,8,53,53,0),(28,4,414,3,8,53,53,1),(29,4,302,3,14,93,93,0),(30,4,302,3,14,93,93,1),(31,4,398,3,12,80,80,0),(32,4,398,3,12,80,80,1),(33,4,318,2,5,50,50,0),(34,4,318,2,5,50,50,1),(35,4,334,3,10,67,67,0),(36,4,334,3,10,67,67,1),(37,4,350,2,7,70,70,0),(38,4,350,2,7,70,70,1),(39,4,366,2,7,70,70,0),(40,4,366,2,7,70,70,1),(41,4,737,3,7,47,47,0),(42,4,737,3,7,47,47,1),(43,4,750,3,7,47,47,0),(44,4,750,3,7,47,47,1),(45,4,763,2,7,70,70,0),(46,4,763,2,7,70,70,1),(47,4,776,3,13,87,87,0),(48,4,776,3,13,87,87,1),(49,4,789,3,11,73,73,0),(50,4,789,3,11,73,73,1),(51,4,558,3,12,80,80,0),(52,4,558,3,12,80,80,1),(53,4,574,2,9,90,90,0),(54,4,574,2,9,90,90,1),(55,4,526,2,6,60,60,0),(56,4,526,2,6,60,60,1),(57,4,446,3,10,67,67,0),(58,4,446,3,10,67,67,1),(59,4,462,3,12,80,80,0),(60,4,462,3,12,80,80,1),(61,4,542,2,7,70,70,0),(62,4,542,2,7,70,70,1),(63,4,606,3,10,67,67,0),(64,4,606,3,10,67,67,1),(65,4,622,4,13,65,65,0),(66,4,622,4,13,65,65,1),(67,4,478,3,11,73,73,0),(68,4,478,3,11,73,73,1),(69,4,590,3,9,60,60,0),(70,4,590,3,9,60,60,1),(71,4,494,3,12,80,80,0),(72,4,494,3,12,80,80,1),(73,4,510,3,8,53,53,0),(74,4,510,3,8,53,53,1),(75,4,893,3,12,80,80,0),(76,4,893,3,12,80,80,1),(77,4,911,3,11,73,73,0),(78,4,911,3,11,73,73,1),(79,4,924,3,9,60,60,0),(80,4,924,3,9,60,60,1),(81,4,937,3,11,73,73,0),(82,4,937,3,11,73,73,1),(83,4,950,2,7,70,70,0),(84,4,950,2,7,70,70,1),(85,4,963,3,13,87,87,0),(86,4,963,3,13,87,87,1),(87,4,976,2,6,60,60,0),(88,4,976,2,6,60,60,1),(89,4,989,3,10,67,67,0),(90,4,989,3,10,67,67,1),(91,4,638,4,11,55,55,0),(92,4,638,4,11,55,55,1),(93,4,654,3,12,80,80,0),(94,4,654,3,12,80,80,1),(95,4,670,3,8,53,53,0),(96,4,670,3,8,53,53,1),(97,4,676,4,14,70,70,0),(98,4,676,4,14,70,70,1),(99,4,7,3,12,80,80,0),(100,4,7,3,12,80,80,1),(101,4,20,3,10,67,67,0),(102,4,20,3,10,67,67,1),(103,4,18,2,6,60,60,0),(104,4,18,2,6,60,60,1),(105,4,23,3,9,60,60,0),(106,4,23,3,9,60,60,1),(107,4,17,3,14,93,93,0),(108,4,17,3,14,93,93,1),(109,4,19,3,13,87,87,0),(110,4,19,3,13,87,87,1),(111,4,15,1,3,60,60,0),(112,4,15,1,3,60,60,1),(113,4,16,2,10,100,100,0),(114,4,16,2,10,100,100,1),(115,4,8,3,10,67,67,0),(116,4,8,3,10,67,67,1),(117,4,9,2,7,70,70,0),(118,4,9,2,7,70,70,1),(119,4,12,2,9,90,90,0),(120,4,12,2,9,90,90,1),(121,4,14,3,10,67,67,0),(122,4,14,3,10,67,67,1),(123,4,10,2,8,80,80,0),(124,4,10,2,8,80,80,1),(125,4,11,3,11,73,73,0),(126,4,11,3,11,73,73,1),(127,4,13,3,9,60,60,0),(128,4,13,3,9,60,60,1),(129,4,42,3,10,67,67,0),(130,4,42,3,10,67,67,1),(131,4,44,2,7,70,70,0),(132,4,44,2,7,70,70,1),(133,4,43,3,8,53,53,0),(134,4,43,3,8,53,53,1),(135,4,41,2,8,80,80,0),(136,4,41,2,8,80,80,1),(137,4,1044,3,13,87,87,0),(138,4,1044,3,13,87,87,1),(139,4,1060,3,10,67,67,0),(140,4,1060,3,10,67,67,1),(141,4,1076,3,9,60,60,0),(142,4,1076,3,9,60,60,1),(143,4,1092,3,9,60,60,0),(144,4,1092,3,9,60,60,1),(145,4,1108,3,12,80,80,0),(146,4,1108,3,12,80,80,1),(147,4,1114,2,8,80,80,0),(148,4,1114,2,8,80,80,1),(149,4,1220,3,10,67,67,0),(150,4,1220,3,10,67,67,1),(151,4,1236,4,14,70,70,0),(152,4,1236,4,14,70,70,1),(153,4,1252,3,13,87,87,0),(154,4,1252,3,13,87,87,1),(155,4,1268,2,9,90,90,0),(156,4,1268,2,9,90,90,1),(157,4,1284,3,13,87,87,0),(158,4,1284,3,13,87,87,1),(159,4,1380,3,13,87,87,0),(160,4,1380,3,13,87,87,1),(161,4,1300,3,10,67,67,0),(162,4,1300,3,10,67,67,1),(163,4,1316,2,6,60,60,0),(164,4,1316,2,6,60,60,1),(165,4,1332,3,13,87,87,0),(166,4,1332,3,13,87,87,1),(167,4,1348,3,9,60,60,0),(168,4,1348,3,9,60,60,1),(169,4,1364,3,13,87,87,0),(170,4,1364,3,13,87,87,1),(171,4,1819,2,8,80,80,0),(172,4,1819,2,8,80,80,1),(173,4,1826,3,14,93,93,0),(174,4,1826,3,14,93,93,1),(175,4,1833,3,10,67,67,0),(176,4,1833,3,10,67,67,1),(177,4,1840,4,16,80,80,0),(178,4,1840,4,16,80,80,1),(179,4,1847,2,6,60,60,0),(180,4,1847,2,6,60,60,1),(181,4,1854,3,10,67,67,0),(182,4,1854,3,10,67,67,1),(183,4,1572,3,13,87,87,0),(184,4,1572,3,13,87,87,1),(185,4,1412,3,11,73,73,0),(186,4,1412,3,11,73,73,1),(187,4,1428,4,12,60,60,0),(188,4,1428,4,12,60,60,1),(189,4,1444,2,6,60,60,0),(190,4,1444,2,6,60,60,1),(191,4,1588,3,11,73,73,0),(192,4,1588,3,11,73,73,1),(193,4,1476,2,6,60,60,0),(194,4,1476,2,6,60,60,1),(195,4,1492,3,7,47,47,0),(196,4,1492,3,7,47,47,1),(197,4,1508,3,11,73,73,0),(198,4,1508,3,11,73,73,1),(199,4,1524,3,12,80,80,0),(200,4,1524,3,12,80,80,1),(201,4,1540,3,13,87,87,0),(202,4,1540,3,13,87,87,1),(203,4,1556,3,9,60,60,0),(204,4,1556,3,9,60,60,1),(205,4,1919,3,9,60,60,0),(206,4,1919,3,9,60,60,1),(207,4,1935,3,12,80,80,0),(208,4,1935,3,12,80,80,1),(209,4,1951,2,9,90,90,0),(210,4,1951,2,9,90,90,1),(211,4,1967,2,8,80,80,0),(212,4,1967,2,8,80,80,1),(213,4,1983,3,11,73,73,0),(214,4,1983,3,11,73,73,1),(215,4,1990,2,7,70,70,0),(216,4,1990,2,7,70,70,1),(217,4,1997,3,10,67,67,0),(218,4,1997,3,10,67,67,1),(219,4,2003,3,14,93,93,0),(220,4,2003,3,14,93,93,1),(221,4,2010,3,10,67,67,0),(222,4,2010,3,10,67,67,1),(223,4,2017,3,12,80,80,0),(224,4,2017,3,12,80,80,1),(225,4,2024,3,11,73,73,0),(226,4,2024,3,11,73,73,1),(227,4,2040,3,9,60,60,0),(228,4,2040,3,9,60,60,1),(229,4,1604,4,15,75,75,0),(230,4,1604,4,15,75,75,1),(231,4,1620,4,12,60,60,0),(232,4,1620,4,12,60,60,1),(233,4,1636,3,10,67,67,0),(234,4,1636,3,10,67,67,1),(235,4,1652,3,9,60,60,0),(236,4,1652,3,9,60,60,1),(237,4,1668,3,6,40,40,0),(238,4,1668,3,6,40,40,1),(239,4,1764,3,11,73,73,0),(240,4,1764,3,11,73,73,1),(241,4,1780,1,4,80,80,0),(242,4,1780,1,4,80,80,1),(243,4,1796,3,9,60,60,0),(244,4,1796,3,9,60,60,1),(245,4,1812,2,7,70,70,0),(246,4,1812,2,7,70,70,1),(247,4,1684,2,8,80,80,0),(248,4,1684,2,8,80,80,1),(249,4,1700,3,8,53,53,0),(250,4,1700,3,8,53,53,1);

--
-- Table structure for table `[[dbprefix]]rating_store`
--

CREATE TABLE `[[dbprefix]]rating_store` (
  `rating_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`rating_id`,`store_id`),
  KEY `[[DBPREFIX]]RATING_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `[[DBPREFIX]]RATING_STORE_RATING_ID_[[DBPREFIX]]RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `[[dbprefix]]rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]RATING_STORE_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Rating Store';

--
-- Dumping data for table `[[dbprefix]]rating_store`
--

INSERT INTO `[[dbprefix]]rating_store` VALUES (4,0),(4,1);

--
-- Table structure for table `[[dbprefix]]rating_title`
--

CREATE TABLE `[[dbprefix]]rating_title` (
  `rating_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Rating Label',
  PRIMARY KEY (`rating_id`,`store_id`),
  KEY `[[DBPREFIX]]RATING_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `[[DBPREFIX]]RATING_TITLE_RATING_ID_[[DBPREFIX]]RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `[[dbprefix]]rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]RATING_TITLE_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Rating Title';

--
-- Dumping data for table `[[dbprefix]]rating_title`
--


--
-- Table structure for table `[[dbprefix]]release_notification_viewer_log`
--

CREATE TABLE `[[dbprefix]]release_notification_viewer_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `viewer_id` int unsigned NOT NULL COMMENT 'Viewer admin user ID',
  `last_view_version` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Viewer last view on product version',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]RELEASE_NOTIFICATION_VIEWER_LOG_VIEWER_ID` (`viewer_id`),
  CONSTRAINT `[[DBPREFIX]]RELEASE_NTFC_VIEWER_LOG_VIEWER_ID_[[DBPREFIX]]ADM_USR_USR_ID` FOREIGN KEY (`viewer_id`) REFERENCES `[[dbprefix]]admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Release Notification Viewer Log Table';

--
-- Dumping data for table `[[dbprefix]]release_notification_viewer_log`
--


--
-- Table structure for table `[[dbprefix]]report_compared_product_index`
--

CREATE TABLE `[[dbprefix]]report_compared_product_index` (
  `index_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index ID',
  `visitor_id` int unsigned DEFAULT NULL COMMENT 'Visitor ID',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int unsigned NOT NULL COMMENT 'Product ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Added At',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `[[DBPREFIX]]REPORT_COMPARED_PRODUCT_INDEX_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  UNIQUE KEY `[[DBPREFIX]]REPORT_COMPARED_PRODUCT_INDEX_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `[[DBPREFIX]]REPORT_COMPARED_PRODUCT_INDEX_STORE_ID` (`store_id`),
  KEY `[[DBPREFIX]]REPORT_COMPARED_PRODUCT_INDEX_ADDED_AT` (`added_at`),
  KEY `[[DBPREFIX]]REPORT_COMPARED_PRODUCT_INDEX_PRODUCT_ID` (`product_id`),
  CONSTRAINT `[[DBPREFIX]]REPORT_CMPD_PRD_IDX_CSTR_ID_[[DBPREFIX]]CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]REPORT_CMPD_PRD_IDX_PRD_ID_[[DBPREFIX]]CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]REPORT_COMPARED_PRODUCT_INDEX_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Reports Compared Product Index Table';

--
-- Dumping data for table `[[dbprefix]]report_compared_product_index`
--


--
-- Table structure for table `[[dbprefix]]report_event`
--

CREATE TABLE `[[dbprefix]]report_event` (
  `event_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event ID',
  `logged_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Logged At',
  `event_type_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Event Type ID',
  `object_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Object ID',
  `subject_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Subject ID',
  `subtype` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Subtype',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`event_id`),
  KEY `[[DBPREFIX]]REPORT_EVENT_EVENT_TYPE_ID` (`event_type_id`),
  KEY `[[DBPREFIX]]REPORT_EVENT_SUBJECT_ID` (`subject_id`),
  KEY `[[DBPREFIX]]REPORT_EVENT_OBJECT_ID` (`object_id`),
  KEY `[[DBPREFIX]]REPORT_EVENT_SUBTYPE` (`subtype`),
  KEY `[[DBPREFIX]]REPORT_EVENT_STORE_ID` (`store_id`),
  CONSTRAINT `FK_1E9A364859CCE03F3DD9ACF825D18BF6` FOREIGN KEY (`event_type_id`) REFERENCES `[[dbprefix]]report_event_types` (`event_type_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]REPORT_EVENT_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Reports Event Table';

--
-- Dumping data for table `[[dbprefix]]report_event`
--


--
-- Table structure for table `[[dbprefix]]report_event_types`
--

CREATE TABLE `[[dbprefix]]report_event_types` (
  `event_type_id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event Type ID',
  `event_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Event Name',
  `customer_login` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Login',
  PRIMARY KEY (`event_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='Reports Event Type Table';

--
-- Dumping data for table `[[dbprefix]]report_event_types`
--

INSERT INTO `[[dbprefix]]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 `[[dbprefix]]report_viewed_product_aggregated_daily`
--

CREATE TABLE `[[dbprefix]]report_viewed_product_aggregated_daily` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `product_id` int unsigned DEFAULT NULL COMMENT 'Product ID',
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `views_num` int NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]REPORT_VIEWED_PRD_AGGRED_DAILY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_STORE_ID` (`store_id`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_E27C3B52E1A2D5E4845EB01EF11F49B2` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]REPORT_VIEWED_PRD_AGGRED_DAILY_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Most Viewed Products Aggregated Daily';

--
-- Dumping data for table `[[dbprefix]]report_viewed_product_aggregated_daily`
--


--
-- Table structure for table `[[dbprefix]]report_viewed_product_aggregated_monthly`
--

CREATE TABLE `[[dbprefix]]report_viewed_product_aggregated_monthly` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `product_id` int unsigned DEFAULT NULL COMMENT 'Product ID',
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `views_num` int NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]REPORT_VIEWED_PRD_AGGRED_MONTHLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_STORE_ID` (`store_id`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_B76260026D9FE9E45230A731A9860BA7` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D5C3C380933099BF6DBA36FC13AA307B` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Most Viewed Products Aggregated Monthly';

--
-- Dumping data for table `[[dbprefix]]report_viewed_product_aggregated_monthly`
--


--
-- Table structure for table `[[dbprefix]]report_viewed_product_aggregated_yearly`
--

CREATE TABLE `[[dbprefix]]report_viewed_product_aggregated_yearly` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `product_id` int unsigned DEFAULT NULL COMMENT 'Product ID',
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `views_num` int NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[DBPREFIX]]REPORT_VIEWED_PRD_AGGRED_YEARLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_6599AF5F11E05C842A7B226C6C7F3377` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D9D14244DB9E38A4F72DE0072D998249` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Most Viewed Products Aggregated Yearly';

--
-- Dumping data for table `[[dbprefix]]report_viewed_product_aggregated_yearly`
--


--
-- Table structure for table `[[dbprefix]]report_viewed_product_index`
--

CREATE TABLE `[[dbprefix]]report_viewed_product_index` (
  `index_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index ID',
  `visitor_id` int unsigned DEFAULT NULL COMMENT 'Visitor ID',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int unsigned NOT NULL COMMENT 'Product ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Added At',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_INDEX_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  UNIQUE KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_INDEX_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_INDEX_STORE_ID` (`store_id`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_INDEX_ADDED_AT` (`added_at`),
  KEY `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_INDEX_PRODUCT_ID` (`product_id`),
  CONSTRAINT `[[DBPREFIX]]REPORT_VIEWED_PRD_IDX_CSTR_ID_[[DBPREFIX]]CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]REPORT_VIEWED_PRD_IDX_PRD_ID_[[DBPREFIX]]CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]REPORT_VIEWED_PRODUCT_INDEX_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Reports Viewed Product Index Table';

--
-- Dumping data for table `[[dbprefix]]report_viewed_product_index`
--


--
-- Table structure for table `[[dbprefix]]reporting_counts`
--

CREATE TABLE `[[dbprefix]]reporting_counts` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Item Reported',
  `count` int unsigned DEFAULT NULL COMMENT 'Count Value',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Reporting for all count related events generated via the cron job';

--
-- Dumping data for table `[[dbprefix]]reporting_counts`
--


--
-- Table structure for table `[[dbprefix]]reporting_module_status`
--

CREATE TABLE `[[dbprefix]]reporting_module_status` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Module ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Module Name',
  `active` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Module Active Status',
  `setup_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Module Version',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Module State',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Module Status Table';

--
-- Dumping data for table `[[dbprefix]]reporting_module_status`
--


--
-- Table structure for table `[[dbprefix]]reporting_orders`
--

CREATE TABLE `[[dbprefix]]reporting_orders` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  `total` decimal(20,4) unsigned DEFAULT NULL,
  `total_base` decimal(20,4) unsigned DEFAULT NULL,
  `item_count` int unsigned NOT NULL COMMENT 'Line Item Count',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Reporting for all orders';

--
-- Dumping data for table `[[dbprefix]]reporting_orders`
--


--
-- Table structure for table `[[dbprefix]]reporting_system_updates`
--

CREATE TABLE `[[dbprefix]]reporting_system_updates` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Update Type',
  `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Action Performed',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Reporting for system updates';

--
-- Dumping data for table `[[dbprefix]]reporting_system_updates`
--


--
-- Table structure for table `[[dbprefix]]reporting_users`
--

CREATE TABLE `[[dbprefix]]reporting_users` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'User Type',
  `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Action Performed',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Reporting for user actions';

--
-- Dumping data for table `[[dbprefix]]reporting_users`
--


--
-- Table structure for table `[[dbprefix]]review`
--

CREATE TABLE `[[dbprefix]]review` (
  `review_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Review create date',
  `entity_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `entity_pk_value` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `status_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Status code',
  PRIMARY KEY (`review_id`),
  KEY `[[DBPREFIX]]REVIEW_ENTITY_ID` (`entity_id`),
  KEY `[[DBPREFIX]]REVIEW_STATUS_ID` (`status_id`),
  KEY `[[DBPREFIX]]REVIEW_ENTITY_PK_VALUE` (`entity_pk_value`),
  CONSTRAINT `[[DBPREFIX]]REVIEW_ENTITY_ID_[[DBPREFIX]]REVIEW_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `[[dbprefix]]review_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]REVIEW_STATUS_ID_[[DBPREFIX]]REVIEW_STATUS_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `[[dbprefix]]review_status` (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8mb4 COMMENT='Review base information';

--
-- Dumping data for table `[[dbprefix]]review`
--

INSERT INTO `[[dbprefix]]review` VALUES (1,'[[regtime]]',1,1,1),(2,'[[regtime]]',1,1,1),(3,'[[regtime]]',1,6,1),(4,'[[regtime]]',1,6,1),(5,'[[regtime]]',1,6,1),(6,'[[regtime]]',1,3,1),(7,'[[regtime]]',1,3,1),(8,'[[regtime]]',1,3,1),(9,'[[regtime]]',1,2,1),(10,'[[regtime]]',1,2,1),(11,'[[regtime]]',1,4,1),(12,'[[regtime]]',1,4,1),(13,'[[regtime]]',1,4,1),(14,'[[regtime]]',1,5,1),(15,'[[regtime]]',1,5,1),(16,'[[regtime]]',1,37,1),(17,'[[regtime]]',1,37,1),(18,'[[regtime]]',1,37,1),(19,'[[regtime]]',1,40,1),(20,'[[regtime]]',1,40,1),(21,'[[regtime]]',1,40,1),(22,'[[regtime]]',1,38,1),(23,'[[regtime]]',1,38,1),(24,'[[regtime]]',1,38,1),(25,'[[regtime]]',1,36,1),(26,'[[regtime]]',1,36,1),(27,'[[regtime]]',1,39,1),(28,'[[regtime]]',1,39,1),(29,'[[regtime]]',1,39,1),(30,'[[regtime]]',1,39,1),(31,'[[regtime]]',1,270,1),(32,'[[regtime]]',1,270,1),(33,'[[regtime]]',1,286,1),(34,'[[regtime]]',1,286,1),(35,'[[regtime]]',1,414,1),(36,'[[regtime]]',1,414,1),(37,'[[regtime]]',1,414,1),(38,'[[regtime]]',1,302,1),(39,'[[regtime]]',1,302,1),(40,'[[regtime]]',1,302,1),(41,'[[regtime]]',1,398,1),(42,'[[regtime]]',1,398,1),(43,'[[regtime]]',1,398,1),(44,'[[regtime]]',1,318,1),(45,'[[regtime]]',1,318,1),(46,'[[regtime]]',1,334,1),(47,'[[regtime]]',1,334,1),(48,'[[regtime]]',1,334,1),(49,'[[regtime]]',1,350,1),(50,'[[regtime]]',1,350,1),(51,'[[regtime]]',1,366,1),(52,'[[regtime]]',1,366,1),(53,'[[regtime]]',1,737,1),(54,'[[regtime]]',1,737,1),(55,'[[regtime]]',1,737,1),(56,'[[regtime]]',1,750,1),(57,'[[regtime]]',1,750,1),(58,'[[regtime]]',1,750,1),(59,'[[regtime]]',1,763,1),(60,'[[regtime]]',1,763,1),(61,'[[regtime]]',1,776,1),(62,'[[regtime]]',1,776,1),(63,'[[regtime]]',1,776,1),(64,'[[regtime]]',1,789,1),(65,'[[regtime]]',1,789,1),(66,'[[regtime]]',1,789,1),(67,'[[regtime]]',1,558,1),(68,'[[regtime]]',1,558,1),(69,'[[regtime]]',1,558,1),(70,'[[regtime]]',1,574,1),(71,'[[regtime]]',1,574,1),(72,'[[regtime]]',1,526,1),(73,'[[regtime]]',1,526,1),(74,'[[regtime]]',1,446,1),(75,'[[regtime]]',1,446,1),(76,'[[regtime]]',1,446,1),(77,'[[regtime]]',1,462,1),(78,'[[regtime]]',1,462,1),(79,'[[regtime]]',1,462,1),(80,'[[regtime]]',1,542,1),(81,'[[regtime]]',1,542,1),(82,'[[regtime]]',1,606,1),(83,'[[regtime]]',1,606,1),(84,'[[regtime]]',1,606,1),(85,'[[regtime]]',1,622,1),(86,'[[regtime]]',1,622,1),(87,'[[regtime]]',1,622,1),(88,'[[regtime]]',1,622,1),(89,'[[regtime]]',1,478,1),(90,'[[regtime]]',1,478,1),(91,'[[regtime]]',1,478,1),(92,'[[regtime]]',1,590,1),(93,'[[regtime]]',1,590,1),(94,'[[regtime]]',1,590,1),(95,'[[regtime]]',1,494,1),(96,'[[regtime]]',1,494,1),(97,'[[regtime]]',1,494,1),(98,'[[regtime]]',1,510,1),(99,'[[regtime]]',1,510,1),(100,'[[regtime]]',1,510,1),(101,'[[regtime]]',1,893,1),(102,'[[regtime]]',1,893,1),(103,'[[regtime]]',1,893,1),(104,'[[regtime]]',1,911,1),(105,'[[regtime]]',1,911,1),(106,'[[regtime]]',1,911,1),(107,'[[regtime]]',1,924,1),(108,'[[regtime]]',1,924,1),(109,'[[regtime]]',1,924,1),(110,'[[regtime]]',1,937,1),(111,'[[regtime]]',1,937,1),(112,'[[regtime]]',1,937,1),(113,'[[regtime]]',1,950,1),(114,'[[regtime]]',1,950,1),(115,'[[regtime]]',1,963,1),(116,'[[regtime]]',1,963,1),(117,'[[regtime]]',1,963,1),(118,'[[regtime]]',1,976,1),(119,'[[regtime]]',1,976,1),(120,'[[regtime]]',1,989,1),(121,'[[regtime]]',1,989,1),(122,'[[regtime]]',1,989,1),(123,'[[regtime]]',1,638,1),(124,'[[regtime]]',1,638,1),(125,'[[regtime]]',1,638,1),(126,'[[regtime]]',1,638,1),(127,'[[regtime]]',1,654,1),(128,'[[regtime]]',1,654,1),(129,'[[regtime]]',1,654,1),(130,'[[regtime]]',1,670,1),(131,'[[regtime]]',1,670,1),(132,'[[regtime]]',1,670,1),(133,'[[regtime]]',1,676,1),(134,'[[regtime]]',1,676,1),(135,'[[regtime]]',1,676,1),(136,'[[regtime]]',1,676,1),(137,'[[regtime]]',1,7,1),(138,'[[regtime]]',1,7,1),(139,'[[regtime]]',1,7,1),(140,'[[regtime]]',1,20,1),(141,'[[regtime]]',1,20,1),(142,'[[regtime]]',1,20,1),(143,'[[regtime]]',1,18,1),(144,'[[regtime]]',1,18,1),(145,'[[regtime]]',1,23,1),(146,'[[regtime]]',1,23,1),(147,'[[regtime]]',1,23,1),(148,'[[regtime]]',1,17,1),(149,'[[regtime]]',1,17,1),(150,'[[regtime]]',1,17,1),(151,'[[regtime]]',1,19,1),(152,'[[regtime]]',1,19,1),(153,'[[regtime]]',1,19,1),(154,'[[regtime]]',1,15,1),(155,'[[regtime]]',1,16,1),(156,'[[regtime]]',1,16,1),(157,'[[regtime]]',1,8,1),(158,'[[regtime]]',1,8,1),(159,'[[regtime]]',1,8,1),(160,'[[regtime]]',1,9,1),(161,'[[regtime]]',1,9,1),(162,'[[regtime]]',1,12,1),(163,'[[regtime]]',1,12,1),(164,'[[regtime]]',1,14,1),(165,'[[regtime]]',1,14,1),(166,'[[regtime]]',1,14,1),(167,'[[regtime]]',1,10,1),(168,'[[regtime]]',1,10,1),(169,'[[regtime]]',1,11,1),(170,'[[regtime]]',1,11,1),(171,'[[regtime]]',1,11,1),(172,'[[regtime]]',1,13,1),(173,'[[regtime]]',1,13,1),(174,'[[regtime]]',1,13,1),(175,'[[regtime]]',1,42,1),(176,'[[regtime]]',1,42,1),(177,'[[regtime]]',1,42,1),(178,'[[regtime]]',1,44,1),(179,'[[regtime]]',1,44,1),(180,'[[regtime]]',1,43,1),(181,'[[regtime]]',1,43,1),(182,'[[regtime]]',1,43,1),(183,'[[regtime]]',1,41,1),(184,'[[regtime]]',1,41,1),(185,'[[regtime]]',1,1044,1),(186,'[[regtime]]',1,1044,1),(187,'[[regtime]]',1,1044,1),(188,'[[regtime]]',1,1060,1),(189,'[[regtime]]',1,1060,1),(190,'[[regtime]]',1,1060,1),(191,'[[regtime]]',1,1076,1),(192,'[[regtime]]',1,1076,1),(193,'[[regtime]]',1,1076,1),(194,'[[regtime]]',1,1092,1),(195,'[[regtime]]',1,1092,1),(196,'[[regtime]]',1,1092,1),(197,'[[regtime]]',1,1108,1),(198,'[[regtime]]',1,1108,1),(199,'[[regtime]]',1,1108,1),(200,'[[regtime]]',1,1114,1),(201,'[[regtime]]',1,1114,1),(202,'[[regtime]]',1,1220,1),(203,'[[regtime]]',1,1220,1),(204,'[[regtime]]',1,1220,1),(205,'[[regtime]]',1,1236,1),(206,'[[regtime]]',1,1236,1),(207,'[[regtime]]',1,1236,1),(208,'[[regtime]]',1,1236,1),(209,'[[regtime]]',1,1252,1),(210,'[[regtime]]',1,1252,1),(211,'[[regtime]]',1,1252,1),(212,'[[regtime]]',1,1268,1),(213,'[[regtime]]',1,1268,1),(214,'[[regtime]]',1,1284,1),(215,'[[regtime]]',1,1284,1),(216,'[[regtime]]',1,1284,1),(217,'[[regtime]]',1,1380,1),(218,'[[regtime]]',1,1380,1),(219,'[[regtime]]',1,1380,1),(220,'[[regtime]]',1,1300,1),(221,'[[regtime]]',1,1300,1),(222,'[[regtime]]',1,1300,1),(223,'[[regtime]]',1,1316,1),(224,'[[regtime]]',1,1316,1),(225,'[[regtime]]',1,1332,1),(226,'[[regtime]]',1,1332,1),(227,'[[regtime]]',1,1332,1),(228,'[[regtime]]',1,1348,1),(229,'[[regtime]]',1,1348,1),(230,'[[regtime]]',1,1348,1),(231,'[[regtime]]',1,1364,1),(232,'[[regtime]]',1,1364,1),(233,'[[regtime]]',1,1364,1),(234,'[[regtime]]',1,1819,1),(235,'[[regtime]]',1,1819,1),(236,'[[regtime]]',1,1826,1),(237,'[[regtime]]',1,1826,1),(238,'[[regtime]]',1,1826,1),(239,'[[regtime]]',1,1833,1),(240,'[[regtime]]',1,1833,1),(241,'[[regtime]]',1,1833,1),(242,'[[regtime]]',1,1840,1),(243,'[[regtime]]',1,1840,1),(244,'[[regtime]]',1,1840,1),(245,'[[regtime]]',1,1840,1),(246,'[[regtime]]',1,1847,1),(247,'[[regtime]]',1,1847,1),(248,'[[regtime]]',1,1854,1),(249,'[[regtime]]',1,1854,1),(250,'[[regtime]]',1,1854,1),(251,'[[regtime]]',1,1572,1),(252,'[[regtime]]',1,1572,1),(253,'[[regtime]]',1,1572,1),(254,'[[regtime]]',1,1412,1),(255,'[[regtime]]',1,1412,1),(256,'[[regtime]]',1,1412,1),(257,'[[regtime]]',1,1428,1),(258,'[[regtime]]',1,1428,1),(259,'[[regtime]]',1,1428,1),(260,'[[regtime]]',1,1428,1),(261,'[[regtime]]',1,1444,1),(262,'[[regtime]]',1,1444,1),(263,'[[regtime]]',1,1588,1),(264,'[[regtime]]',1,1588,1),(265,'[[regtime]]',1,1588,1),(266,'[[regtime]]',1,1476,1),(267,'[[regtime]]',1,1476,1),(268,'[[regtime]]',1,1492,1),(269,'[[regtime]]',1,1492,1),(270,'[[regtime]]',1,1492,1),(271,'[[regtime]]',1,1508,1),(272,'[[regtime]]',1,1508,1),(273,'[[regtime]]',1,1508,1),(274,'[[regtime]]',1,1524,1),(275,'[[regtime]]',1,1524,1),(276,'[[regtime]]',1,1524,1),(277,'[[regtime]]',1,1540,1),(278,'[[regtime]]',1,1540,1),(279,'[[regtime]]',1,1540,1),(280,'[[regtime]]',1,1556,1),(281,'[[regtime]]',1,1556,1),(282,'[[regtime]]',1,1556,1),(283,'[[regtime]]',1,1919,1),(284,'[[regtime]]',1,1919,1),(285,'[[regtime]]',1,1919,1),(286,'[[regtime]]',1,1935,1),(287,'[[regtime]]',1,1935,1),(288,'[[regtime]]',1,1935,1),(289,'[[regtime]]',1,1951,1),(290,'[[regtime]]',1,1951,1),(291,'[[regtime]]',1,1967,1),(292,'[[regtime]]',1,1967,1),(293,'[[regtime]]',1,1983,1),(294,'[[regtime]]',1,1983,1),(295,'[[regtime]]',1,1983,1),(296,'[[regtime]]',1,1990,1),(297,'[[regtime]]',1,1990,1),(298,'[[regtime]]',1,1997,1),(299,'[[regtime]]',1,1997,1),(300,'[[regtime]]',1,1997,1),(301,'[[regtime]]',1,2003,1),(302,'[[regtime]]',1,2003,1),(303,'[[regtime]]',1,2003,1),(304,'[[regtime]]',1,2010,1),(305,'[[regtime]]',1,2010,1),(306,'[[regtime]]',1,2010,1),(307,'[[regtime]]',1,2017,1),(308,'[[regtime]]',1,2017,1),(309,'[[regtime]]',1,2017,1),(310,'[[regtime]]',1,2024,1),(311,'[[regtime]]',1,2024,1),(312,'[[regtime]]',1,2024,1),(313,'[[regtime]]',1,2040,1),(314,'[[regtime]]',1,2040,1),(315,'[[regtime]]',1,2040,1),(316,'[[regtime]]',1,1604,1),(317,'[[regtime]]',1,1604,1),(318,'[[regtime]]',1,1604,1),(319,'[[regtime]]',1,1604,1),(320,'[[regtime]]',1,1620,1),(321,'[[regtime]]',1,1620,1),(322,'[[regtime]]',1,1620,1),(323,'[[regtime]]',1,1620,1),(324,'[[regtime]]',1,1636,1),(325,'[[regtime]]',1,1636,1),(326,'[[regtime]]',1,1636,1),(327,'[[regtime]]',1,1652,1),(328,'[[regtime]]',1,1652,1),(329,'[[regtime]]',1,1652,1),(330,'[[regtime]]',1,1668,1),(331,'[[regtime]]',1,1668,1),(332,'[[regtime]]',1,1668,1),(333,'[[regtime]]',1,1764,1),(334,'[[regtime]]',1,1764,1),(335,'[[regtime]]',1,1764,1),(336,'[[regtime]]',1,1780,1),(337,'[[regtime]]',1,1796,1),(338,'[[regtime]]',1,1796,1),(339,'[[regtime]]',1,1796,1),(340,'[[regtime]]',1,1812,1),(341,'[[regtime]]',1,1812,1),(342,'[[regtime]]',1,1684,1),(343,'[[regtime]]',1,1684,1),(344,'[[regtime]]',1,1700,1),(345,'[[regtime]]',1,1700,1),(346,'[[regtime]]',1,1700,1);

--
-- Table structure for table `[[dbprefix]]review_detail`
--

CREATE TABLE `[[dbprefix]]review_detail` (
  `detail_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review detail ID',
  `review_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Review ID',
  `store_id` smallint unsigned DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Title',
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Detail description',
  `nickname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'User nickname',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  PRIMARY KEY (`detail_id`),
  KEY `[[DBPREFIX]]REVIEW_DETAIL_REVIEW_ID` (`review_id`),
  KEY `[[DBPREFIX]]REVIEW_DETAIL_STORE_ID` (`store_id`),
  KEY `[[DBPREFIX]]REVIEW_DETAIL_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `[[DBPREFIX]]REVIEW_DETAIL_CUSTOMER_ID_[[DBPREFIX]]CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `[[dbprefix]]customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `[[DBPREFIX]]REVIEW_DETAIL_REVIEW_ID_[[DBPREFIX]]REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `[[dbprefix]]review` (`review_id`) ON DELETE CASCADE,
  CONSTRAINT `[[DBPREFIX]]REVIEW_DETAIL_STORE_ID_[[DBPREFIX]]STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `[[dbprefix]]store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8mb4 COMMENT='Review detail information';

--
-- Dumping data for table `[[dbprefix]]review_detail`
--

INSERT INTO `[[dbprefix]]review_detail` VALUES (1,1,1,'I prefer more compartments','I prefer more compartments. If you don\'t mind putting everything in one space, it\'s fine. Good for the gym.','Chi',NULL),(2,2,1,'I use it a lot ','It\'s a good size and I use it a lot. My only issue with it was I wanted the handles to be longer so I can wear it on my back.','Filiberto',NULL),(3,3,1,'I\'ve had this thing for really long','I\'ve had this thing for a really long time and it barely shows any signs of wear and tear. It\'s really big, too! I\'ve taken it on day trips as well as short vacations and usually have no trouble finding room for my stuff.','Herb',NULL),(4,4,1,'Decent bag','Decent bag. I keep my stuff in it for work and the gym. It\'s nice and roomy. I wish it had a more sophisticated design, though. Kinda looks like it\'s for kids.','Craig',NULL),(5,5,1,'Screwed up my back','I can\'t believe they\'re claiming these straps are \"padded.\" Wearing this thing to class for a semester totally screwed up my back, and my shoulders would start to ache after a few minutes where the straps dug in.','Orville',NULL),(6,6,1,'Awesome bag','Awesome bag but I found it to be smaller than I thought. I haven\'t felt any additional strain on my back and I use it all day long for my job.','Marty',NULL),(7,7,1,'The back needs more padding','If the back had more padding I would recommend it for everyone. You can tell the material is strong and not cheap so it\'s definitely worth it.','Chase',NULL),(8,8,1,'I bought this backpack for my son','I bought this backpack for my son to take to school, but he carries it like a suitcase now! It\'s also really good for airplane travel.','Kennith',NULL),(9,9,1,'awesome for going back and forth','This is awesome for going back and forth to class. I live off campus and it\'s a longer walk, but this pack fits comfortably and I can even store my laptop in the main compartment.','Gaston',NULL),(10,10,1,'comfy and i don\'t feel like a loser','comfy and i don\'t feel like a loser carrying it.','Issac',NULL),(11,11,1,'The shoulder strap broke ','The shoulder strap broke the first time I used it. Awesome.','Daren',NULL),(12,12,1,'Good for work. Holds everything ','This is good for work. Holds everything I need. The fabric doesn\'t seem that strong, but so far so good.','Garry',NULL),(13,13,1,'Great bag! I use it for everything! ','Great bag! I use it for everything! Not sure what happened with the person who said the strap broke because mine is perfect. Maybe it was fluke? I\'d return it and try another. It\'s been awesome for me!','Quinn',NULL),(14,14,1,'This bag is really cool','This bag is really cool. I\'m an art major, so I have tons of supplies that I have to lug back and forth every day for class. I didn\'t think this would be big enough, but surprisingly it can hold just about all my stuff. I really like the way it looks too.','Jame',NULL),(15,15,1,'Color is weird','I wanted to like this bag, and it is definitely good quality, but the color is so weird in real life. From a distance it kind of looks like I just found it in a dumpster. Shame because that is the only drawback.','Adalberto',NULL),(16,16,1,'I am OBSESSED with these','I run 5 times a day and am OBSESSED with this watch! It tracks and calculates all the things my brain can\'t because I hate maths. PS I know this is a men\'s watch and I am not a man, but I have large wrists!','Refugio',NULL),(17,17,1,'This thing is awesome ','This thing is awesome and remembers all the stuff I\'ve stored. ','Jewel',NULL),(18,18,1,'It slides around on my wrist','It slides around on my wrist when I sweat. I\'ve tried making it smaller but that doesn\'t seem to help.','Brice',NULL),(19,19,1,'Working flawlessly','I recently replace my 25 year old watch with this one, so it had high expectations to live up to. So far all the features are working flawlessly, I only hope it lasts as long as my old one.','Billy',NULL),(20,20,1,'offers a lot of technology','can\'t say this is the coolest looking watch I\'ve ever owned (it\'s no FAMOUS DESIGNER or anything) but it has a lot to offer technology-wise','Marc',NULL),(21,21,1,'Hydration alarm','This was given as a gift to me and it wasn\'t the one I asked for, but I\'m starting to like the different perks like the hydration alarm','Luther',NULL),(22,22,1,'It works ok but the ugliness is blinding','It works ok but the ugliness is blinding I am literally blinded','Leon',NULL),(23,23,1,'Watch too tight','Watch too tight please email how to loosen it or I\'ll leave bad review','Max',NULL),(24,24,1,'No ticktock','I got it because I thought it would still make a ticktick noise even though it\'s digital, but it doesn\'t!','Chuck',NULL),(25,25,1,'Not a bad watch for the price','Not a bad watch for the price. Wish it had actual numbers instead of marks, though.','Robert',NULL),(26,26,1,'the only watch I wear','Hands down, it\'s the only watch I wear when I\'m out on a run. The strap is soft and smooth, and the face even glows in the dark.','Noe',NULL),(27,27,1,'Dual time zone settings','When I\'m in another country, I hate not knowing what time it really is back home so the dual time zone settings are awesome!','Frank',NULL),(28,28,1,'Really perfect for travel ','Really perfect for my needs. I travel a ton, so I\'ll always know what time to give my wife a call back home.','Jamie',NULL),(29,29,1,'I really like the modern look','I really like the modern look of this watch, but I could only get one time zone to work. I hope it has a warranty because I\'m sending it back!','Bobby',NULL),(30,30,1,'This watch is so tight','This watch is so tight around my wrist! I don\'t care if it\'s adjustable, it cuts off my circulation.','Tommie',NULL),(31,31,1,'My favorite layers','This is one of my favorite layers for running in the winter, it keeps me warm but it\'s not super bulky.','Markus',NULL),(32,32,1,'Weird looking pocket','I where it when I\'m coaching football so I can run up and down the sidelines and yell without getting to hot. The pocket on the chest is weird looking tho.','Xavier',NULL),(33,33,1,'Perfect layer for the game','Perfect layer for wearing to the game, it doesn\'t shed all over your clothes like a regular hoodie.','Mike',NULL),(34,34,1,'The fabric is great','the fabric is great, it keeps me warm but it\'s not bulky like my other hoodies. Runs large, though.','Emory',NULL),(35,35,1,'This jacket isn\'t keeping me warm','This jacket isn\'t keeping me warm','Jon',NULL),(36,36,1,'I don\'t feel protected','Not sure exactly what \"elements\" they\'re talking about here. I don\'t feel protected from any \"elements\" in this throw-away.','Homer',NULL),(37,37,1,'avid hiker/snowboarder','I\'m an avid hiker/snowboarder and know quality when I see it. Please don\'t be fooled by the thin feel of this jacket - I always feel very comfortable and only rarely feel too warm, and then it\'s only because I wear insulating base layers. You will not be disappointed, especially if you\'re into winter sports or outdoor activities at higher elevations. My only issue with it is the zipper, which broke and had to be replaced.','Wilbur',NULL),(38,38,1,'Has never let me down','This jacket is going to be by my side for the rest of my life. It\'s never let me down once in a rainstorm, always keeping me dry as I bike back and forth to work. ','Long',NULL),(39,39,1,'Practically perferct','I have to say this is a practically perfect rain jacket. I do wish it was heavier though since it only works for me in spring and summer rainstorms. ','Lindsay',NULL),(40,40,1,'Excellent quality. I actually love','Excellent quality. I actually love when it rains because I get a lot of compliments whenever I wear this jacket. ','Randell',NULL),(41,41,1,'I just live for this track jacket','I just live for this track jacket. Because it\'s solid, I can put it on over any t-shirt and look really athletic. I may not exercise all the time, but wearing this jacket makes other people think I do!','Wyatt',NULL),(42,42,1,'Not 100% sure how I feel','Not 100% sure how I feel about this yet so I\'m going to number it right in the middle. It keeps me warm but the fleece is kind of itchy. It definitely has to go on top of another layer or you\'ll spend all day itching!','Glen',NULL),(43,43,1,'fleece lining','The fleece lining is what sold me! I hate being cold and this jacket really helps me not to be. Almost perfect-the hem slightly unraveled which is preventing me from giving it a 5.','Shon',NULL),(44,44,1,'I didn\'t think it was that warm','I didn\'t think it was that warm at all and it needs a hood. I wouldn\'t wear it in the winter that\'s for sure. ','Neal',NULL),(45,45,1,'for my son to wear to school ','I got this for my son to wear to school and it\'s treated him very well. Not too bulky and the reversible design is a very nice touch!','Herschel',NULL),(46,46,1,'Kinda bulky','Kinda bulky when you wear both, but they still let me move ok. Great for football games.','Rudolf',NULL),(47,47,1,'easy to take apart','I like this one. It\'s easy to take apart when you want to wear the quilted part and zips back in no problem. If you\'re a big guy its fits a little tight under the arms though.','Emmett',NULL),(48,48,1,'does everything it\'s suppose','This jacket does everything it\'s supposed to do. Keeps me warm and has lots of room for my stuff. Good buy!','Burl',NULL),(49,49,1,'Love it; don\'t have to take off gloves','Love it; don\'t have to take my gloves off and dig around in my pocket for my ipod','Carol',NULL),(50,50,1,'Wish buttons were on sleeve','Wish the buttons were on the sleeve but still very cool. Jacket is way warm too','Ronald',NULL),(51,51,1,'Great on my evening ride','I went back to the site and snagged another in a different color - they\'re great on my evening rides. I usually prefer raglan sleeves but I am always comfortable in this design, and the mesh works wonders for keeping my temperature down. ','Arden',NULL),(52,52,1,'Loop thing broke','I\'d give it 4 or 5 stars if it wasn\'t for the fact that the effing  loop thing broke. It wasn\'t stretchy enough and now im back to carrying my fone and sweating on it ughghg! ','Jessie',NULL),(53,53,1,'They chafed me!','They chafed me!','Rashad',NULL),(54,54,1,'They are comfy','Don\'t know why people on here are so negative about these pants. They are comfy and feel very lightweight and soft. The internal pocket is great for cash when I need to refeul during runs! ','Barrett',NULL),(55,55,1,'Saggy pants','After running in these saggy pants I just wanted to crawl into a hole a die. ','Davis',NULL),(56,56,1,'These are really bulky','These are really bulky and not very flattering at all. It looks like I have a big bulge at my stomach. I wear them around the house but I wouldn\'t go out in public with them on.','Donte',NULL),(57,57,1,'Inseam is WAY too long','Either I\'m too short or this inseam is way off. WAY too long! I trip constantly in these.','Reyes',NULL),(58,58,1,'Keeping me warm before games','They do the job of keeping me warm before a game. I wear them then and only then-wouldn\'t wear them anywhere else.','Harold',NULL),(59,59,1,'There\'s nothing to dislike','There\'s nothing to dislike about these track pants bc they do everything you want??blocks the wind and keeps you warm. Very happy I got them!','Darius',NULL),(60,60,1,'The mesh lining sometimes snags','The mesh lining sometimes snags when your taking them off but that\'s pretty common I think. Like them and would recommend.','Armando',NULL),(61,61,1,'These are great!','These are great! Major major points for the two-tone design plus all those technologies - I never feel gross after my runs. A must have for anyone serious about their body! ','Hershel',NULL),(62,62,1,'I bought these for my man.','I bought these for my man. What can I say, these pants keep him comfortable and dry. Never heard any complaints except that he wishes they stretched more. Good buy! ','Hans',NULL),(63,63,1,'I like them','I like them, they keep my sweat on the down low. They are stretchy. And I like the pockets. They look cool, too. So yeah. Go buy them.','Kenny',NULL),(64,64,1,'THESE PANTS KEEP ME WARM','THESE PANTS KEEP ME WARM WHEN IM BENCHED AT MY GAME! I DON\'T GET TO PLAY A LOT. LOL','Nicky',NULL),(65,65,1,'Good dog walking pants','Good dog walking pants','Mark',NULL),(66,66,1,'The draw string is more like half a draw','The draw string is more like half a draw string. Dosent stay so pants fall of my butt. I think they run too big.','Margarito',NULL),(67,67,1,'I got this for running','I got this for running, but the fit is kind of funny so I just end up wearing it for yard work. It\'s light enough, just nothing special.','Tyree',NULL),(68,68,1,'Nice and light. ','Nice and light. I like that there\'s no obnoxious design.','Weston',NULL),(69,69,1,'I bought 5 of the same color!','People at the gym probably think I don\'t wwas my cloths because I wear this evryday but I just bought 5 of the same color because it\'s awesome!','Jude',NULL),(70,70,1,'my new favorite CrossFit shirt','Fits great. It\'s my new favorite CrossFit shirt.','Leigh',NULL),(71,71,1,'Works for the gym','Works for the gym and even as an undershirt.','Roland',NULL),(72,72,1,'I like the crew neck','I got this shirt in the v-neck version too and I like the crew a lot better. It seems to fit better and I think the fabric is lighter. This one doesn\'t have the mesh inserts but allover the fabric feels better.','Edison',NULL),(73,73,1,'Hate the fabric','Why is this kind of fabric all the rage? I know it\'s supposed to be the best thing since sliced bread with the moisture wicking crap but I feel like I sweat MORE than with just regular cotton. I\'m over paying an arm and a leg for the \"technology.\" give me a 5 dollar tshirt from the dollar store!','Hai',NULL),(74,74,1,'Ready to hit the gym','As soon as I put this shirt on I feel ready to hit the gym, even on my laziest days. Something about the way it feels just gets me psyched up!','Cletus',NULL),(75,75,1,'Too small ','I\'m a bodybuilder with extremely large, buff muscles and this shirt simply does not accommodate my bulk. Even with the V neck it\'s too tight around my neck, and the sleeve openings were practically cutting off circulation to my biceps and triceps! I had to send it back but I have to admit that felt good ;)','Gustavo',NULL),(76,76,1,'it says moisturewicking?','it says moisturewicking but i still sweat when i wear this shirt, don\'t trust what you read on the internet','Filiberto',NULL),(77,77,1,'This shirt is a dream come true','This shirt is a dream come true for a sweat bucket like me. Love the material and I don\'t look like I got stuck in the rain when I\'m done working out.','Nathan',NULL),(78,78,1,'Awesome tee! Not cheap.','Awesome tee! Not the cheapest though.','Darwin',NULL),(79,79,1,'Liked the way it fit mostly','Liked the way it fit mostly. But the collar was weird. I guess it kept me dry?','Jonas',NULL),(80,80,1,'Keeps me cool','I like this shirt, it keeps me cool when I\'m lifting. Would like a tighter fit though.','Warren',NULL),(81,81,1,'Gets the job done. Even when I\'m pouring','Gets the job done. Even when I\'m pouring sweat, this shirt maintains a nice dry feel. I think the sizing runs a little large, so order accordingly.','Jerome',NULL),(82,82,1,'I sweat SO much.','I sweat SO much. This top is fine when I don\'t intend to exert myself, but BOY does it NOT work for people with hyperhydrosis!','Alfonzo',NULL),(83,83,1,'This shirt is too tight and too thin.','This shirt is too tight and too thin. REALLY emphasizes the fact that I do not have clearly defined pectorals.','Sergio',NULL),(84,84,1,'Great training top. ','Great training top. I like that it also has UV protection because I\'m outdoors all the time. Seems are a little weird tho.','Donnell',NULL),(85,85,1,'I love this shirt. Perfect fit','I love this shirt. Perfect fit, perfect price. My dad plays on a softball team and I got one for him and he is very happy too. has my vote! ','Erwin',NULL),(86,86,1,'Comfortable and soft','On the plus side, it\'s definitely comfortble and soft,  and yes it does keep you dry  no matter how much you sweat. However, I found the cuffs to be too tight and the material is a little too sheer for my tastes. But it\'s not the most expensive on the shelf, so whatever.','Don',NULL),(87,87,1,'It\'s okay, a little boring. ','It\'s okay, a little boring. ','Maynard',NULL),(88,88,1,'Very comfy but wears thin','It is very comfy but wears thin - I won\'t be able to get much more use out it as it now is revealing my bra I think. I have the white one so I will switch to a darker color if I decide to by another 1. Very embarrassing when your at the gym. ','Hiram',NULL),(89,89,1,'I\'ve lost 50 pounds in 5 months','I\'ve lost 50 pounds in 5 months and this shirt kept me comfortable since day one. I would recommend it to anyone serious about workout. Sizes run small tho so order a size up. ','Darwin',NULL),(90,90,1,'Fell apart in wash','I don\'t even know where to begin. It fell apart during the third wash. Whoever says this is a good-quality piece of gear is lying through their teeth! ','Chung',NULL),(91,91,1,'Fantastic shirt for the price!','This is a fantastic shirt for the price!','Jae',NULL),(92,92,1,'Luma got it right with this one.','Luma got it right with this one. I don\'t care about looking stylish, I just want a shirt that will still feel good after an hour at the gym, and that\'s what I got.','Alfred',NULL),(93,93,1,'Ripped the FIRST TIME I wore ','This shirt ripped the FIRST TIME I wore it.','Carlo',NULL),(94,94,1,'Really comfy shirt','Really comfy shirt, sometimes clings a bit but at least it dries fast.','Gus',NULL),(95,95,1,'I work out a lot','I work out a lot and my shoulders are really big, most tank tops are too tight in the armholes but this one is great.','Harry',NULL),(96,96,1,'Nice fit and fabric','Nice fit and fabric, but the inserts are in weird places.','Damon',NULL),(97,97,1,'I purchased this tank top for my son','I purchased this tank top for my son when he\'s working out in the gym after school. It fits great and he loves it!','Duncan',NULL),(98,98,1,'Yea. This pilled imeddiately','Yea. This pilled imeddiately after I washed it. Definatly returning.','Wendell',NULL),(99,99,1,'Why can\'t you make this in my size?','Why can\'t you make this in my size? Thank you for the color at least. ','Harold',NULL),(100,100,1,'Wear this on evening runs','Wear this on evening runs. I absolutely adore it and will probably buy more.','Kasey',NULL),(101,101,1,'Great for baoting ','We go boating a lot and these are great for when I\'m putting our boat in the water. Those tiny rocks and pebbles can be super sharp but I never feel a single one of them. ','Manual',NULL),(102,102,1,'These do drain well','These do drain well and are really comfortable but the bottoms can still be slippery if you\'re walking on wet rocks. Just be careful!','Milton',NULL),(103,103,1,'They work great in water','They work great in water but I also like to wear em on hotter days if we\'re walking around and regular sandals will let too much debris get in.','Antwan',NULL),(104,104,1,'The only things I care about when I\'m ru','The only things I care about when I\'m running are comfort and speed. These are definitely comfortable but I don\'t think their lightweight enough to give me great speed. And the search continues.','Lamont',NULL),(105,105,1,'Great! I wear these almost every day-esp','Great! I wear these almost every day-especially love that I don\'t have to worry about the laces.','Gerald',NULL),(106,106,1,'These sit in my foyer waiting for my eve','These sit in my foyer waiting for my everyday run. Sometimes I run 5 miles in them, sometimes 10. They never let me down.','Ike',NULL),(107,107,1,'Running in these are imPOSSible!! I only','Running in these are imPOSSible!! I only can run 23 minutes at a time, but these hurt when I even do that. They look pretty snazzy though, lots of compliments from the ladies on my route.','Hugh',NULL),(108,108,1,'Pretty average cts. Their comfrtable whe','Pretty average cts. Their comfrtable when I first start but don\'t try working out too hard in them. You\'re feet will definitely start to hurt!','Judson',NULL),(109,109,1,'I wear these to my gym daily. I go hard ','I wear these to my gym daily. I go hard on the treadmill and these don\'t let me down.','Carlo',NULL),(110,110,1,'Love, love, love - did I say love? It wa','Love, love, love - did I say love? It was totally worth it to wait for Luma to come out with a trail running shoe. Very comfortable.','Jerold',NULL),(111,111,1,'I slipped on a rock on these shoes and I','I slipped on a rock on these shoes and I could feel all the pain. I would go out running on a regular day in these but not if it\'s been previously raining.','Ezra',NULL),(112,112,1,'The only thing I don\'t like about these ','The only thing I don\'t like about these shoes are the weird toes. They point upward making it look really strange on a guy. Otherwise very good.','Simon',NULL),(113,113,1,'These are really good to play tennis in ','These are really good to play tennis in too. They fit a little narrow in the heel which was fine for me but might be a problem for others.','Noah',NULL),(114,114,1,'I wore these until they finally gave out','I wore these until they finally gave out! Great running shoes..very comfortable and light and I could feel the difference the Torsion system makes. Highly recommended for anyone going out 4 to 5 times a week.','Joey',NULL),(115,115,1,'How awesome is it to find a product that','How awesome is it to find a product that works exactly as advertised! These seriously felt like I\'d been wearing them forever, the first time I put them on. The way it molds to your foot is amazing. I have run two full marathons in these with barely a blister. GO LUMA!','King',NULL),(116,116,1,'I wouldn\'t be a runner if it wasn\'t for ','I wouldn\'t be a runner if it wasn\'t for these shoes. I used to get really bad shin splints, blisters and pulled muscles no matter how much I stretched. Once I bought these it got so much eaiser. It is true that they are not that stylish but if you are serious about running, who cares?','Irwin',NULL),(117,117,1,'I wear these for a variety of sports and','I wear these for a variety of sports and they are very comfortable, no complaints there. I\'m not crazy about the design though. In person they look kind of feminine. Plus the color is no bueno. They somehow looked dirty and old even fresh out of the box.','Monroe',NULL),(118,118,1,'Awesome shoes!! I didn\'t realize how muc','Awesome shoes!! I didn\'t realize how much I\'d been missing by wearing other shoes without a lot of heel cushioning. I\'m sticking with these from now on.','Josh',NULL),(119,119,1,'They ran too narrow for me and the mater','They ran too narrow for me and the material was almost too light - seemed pretty flimsy and I don\'t think they would last very long.','Leslie',NULL),(120,120,1,'These are really REALLY LIGHT! Not much ','These are really REALLY LIGHT! Not much shoe or cushioning. My calves were sore after running in them 5 miles the first time.','Jody',NULL),(121,121,1,'Not great on slippery grass. I wear them','Not great on slippery grass. I wear them mostly for walking around.','Chad',NULL),(122,122,1,'I used these as racing flats and they we','I used these as racing flats and they were awesome. ','Anibal',NULL),(123,123,1,'Unflattering','Honestly, could this be any more unflattering? The cut is really bad and I can\'t see anyone looking good in this unless they\'re really muscular.','Dominic',NULL),(124,124,1,'Keeps me comfortable','I\'ve only worn it a few times so far, but it really keeps me comfortable at the gym. I throw on a pair of athletic shorts and call it a day.','Mervin',NULL),(125,125,1,'Nothing to write home about','I agree with the reviewer above. You can get this same tank in a million other stores, nothing to write home about. Do like the top stitching though-really adds some athleticsm.','Trey',NULL),(126,126,1,'Average tank','It\'s just an average tank. Nothing really to say about it. I rarely work out so I can\'t speak to the moisture-wicking part.','Edmund',NULL),(127,127,1,'NOT for skinny dudes ','Unless ur really muscular this won\'t look good. I\'m keeping it cuz it\'s motivation to keep working out. But skinny dudes be warned.','Tracey',NULL),(128,128,1,'Keeps me feeling dry','The fabric is great when I\'m sweating hard. It keeps me feeling dry. Wish there was more ventilation.','Archie',NULL),(129,129,1,'I feel awesome when I wear this','I feel awesome when I wear this to hit the gym!!!  The cut makes my triceps look huge. It\'s so rewarding to look in the mirror after a really tough workout. My girlfriend says I look like a lunkhead but I know she loves it!!','Eldon',NULL),(130,130,1,'Comfortable','Not as lightweight as it seems but it was ok. Comfortable.','Joey',NULL),(131,131,1,'I bought a few of these for my husband. ','I bought a few of these for my husband. He likes them but they did shrink when washed. I just don\'t put them in the dryer anymore and it\'s fine!','Matthew',NULL),(132,132,1,'TINY neck hole??','Why is the neck opening so small??? Didn\'t fit right.','Monroe',NULL),(133,133,1,'Shirt can stink after','Ok, MAYBE this is just me but I sweat a LOT when I run, and I\'ve noticed that this shirt really retains odor.  I washed it three times and it still stank so I had to just throw it away. Which sucks because I really liked it, but come on!','Scotty',NULL),(134,134,1,'Wish it was longer','wish it was longer. i\'m 5\'11 with a long torso and it\'s too short.','Alexander',NULL),(135,135,1,'Razorback version?','I\'d prefer if it was Racerback, but otherwise it\'s a great shirt. The Mesh zones are where you need them when you really get Sweaty.','Graham',NULL),(136,136,1,'Fits true to size, feels great.','Fits true to size, feels great. I bought three and I won\'t wear anything else when I\'m training.','Patrick',NULL),(137,137,1,'I bought this bag for my daughter','I bought this bag for my daughter because she travels all the time and she loves it! It\'s easy for her to roll and carry by herself even when full. ','Shella',NULL),(138,138,1,'Goes everywhere with me','I\'ve taken this bag to so many places and everything still works. I hate when the threads start to come apart and the zipper gets caught after like 2 uses. So far so good!','Crissy',NULL),(139,139,1,'The material is a little thin','The material is a little thin so I\'m afraid it won\'t last long. The zippers slide really nice and the wheels are good on the pavement. Overall a good purchase.','Alene',NULL),(140,140,1,'OBSESSED with this!','OBSESSED with this! I love that it\'s adjustable! A bit more expensive than I wanted, but TOTALLY worth it.','Cliff',NULL),(141,141,1,'Great but pricey','This totally makes me feel like I\'m actually working my muscles. The adjustable thing is awesome. A bit pricey though.','Fiona',NULL),(142,142,1,'I hate working out...This does not help.','I hate working out...This does not help.it gets tangled really easily.can\'t even get threw 1 work out with it. Returning.','Ardith',NULL),(143,143,1,'Want more resistance','Its great to be able to work out at home and sometimes on my lunch break at work - I wish this provided more resistance, though.','Randy',NULL),(144,144,1,'Agreed. More resistance','Agreed. I can do plenty of exercises with it and its awesome for when I can\'t make it to the gym, but I\'d like more resistance, too.','Keren',NULL),(145,145,1,'Too lazy to go to gym','I use these when I\'m too lazy to go to the gym. Really helps me stay in shape. I have already adjusted several times to increase the tension because I\'m getting stronger!','Madeleine',NULL),(146,146,1,'Do not buy!','Tried to adjust one and the plastic part just snapped in half. Very Disappointed. Do not buy!','Ricky',NULL),(147,147,1,'They work, nothing special. ','They work, nothing special. I had a set that I liked better but my ex stole it.   ','Krystle',NULL),(148,148,1,'Good value for the price','pretty satisfied with this jump rope. good value for the price','Lavonia',NULL),(149,149,1,'I BRING THIS TO ALL MY MEETS!','I BRING THIS TO ALL MY MEETS FOR WARMUP!!! BARELY TAKES UP ANY SPACE IN MY BAG','Andy',NULL),(150,150,1,'perfect for when I\'m too lazy','this is so perfect for when I\'m too lazy to go to the gym. I do a few pushups and then whip out the jump rope and work on my cardio. It\'s a quick workout that makes me feel greaat and I don\'t even have to leave the house','Orville',NULL),(151,151,1,'PURPLES','I bought these pushup grips because they came in purple!! my boyfriend has his own and I love using them but the purple was so perfect for me because I\'m a girly girl at heart','Toya',NULL),(152,152,1,'these are ok','these are ok, but my brother has the military ones and I like them loads better','Johanne',NULL),(153,153,1,'Will whip you into shape!','these things whip you into shape! a month after I got them and used them several times aeach week I could see a huge difference in my muscle tone. very happy with the results!!!  :)','Ashlea',NULL),(154,154,1,'Easy to clean','Wide mouth opening makes it easy to clean! ','Olimpia',NULL),(155,155,1,'Perfect weight','I always found 10 lb weights too light and 20 lb too heavy. This is just right!','Danielle',NULL),(156,156,1,'should\'ve got a while ago','I don\'t know why I didn\'t get this years ago. I\'ve been diligently doing ab workouts every day with little effect. Incorporated this into my routine and BAM! I can see my love handles melting away!','Keith',NULL),(157,157,1,'I love this bag! It\'s cute','I love this bag! It\'s cute and doesn\'t advertise that I\'m going to the gym like a duffel bag.','Dodie',NULL),(158,158,1,'I pack a TON of stuff','I take a TON of stuff to the gym and yoga studio. Way more than I should but this bag still allows me to carry a bunch of it. I like taking it better than any other bag.','Tara',NULL),(159,159,1,'Wish there were pockets ','I like it but I wish there were pockets on the inside instead of just one big space. I didn\'t think it would fit inside my locker but it did.','Chasidy',NULL),(160,160,1,'Motivated by this Bag!','I purchased this bag hoping it would give me more motivation to go to the gym and it has! Not too big, sized just right for me and all my friends love it :)','Tamisha',NULL),(161,161,1,'Wish it had more pocket','Wish it had more pockets, but it\'s still good. A shoulder strap would also have been nice.','Lidia',NULL),(162,162,1,'Fits tons of gear','I take this along whenever I head up to my cabin. Fits tons of gear plus a few of my favorite electronics. And duct tape.','Elizabeth',NULL),(163,163,1,'ok bag for a day\'s hike','ok bag for a day\'s hike around Hawk Mountain. Needs a sturdier top handle tho, things ripped','Sueann',NULL),(164,164,1,'I bike four miles a day to work and back','I bike four miles a day to work and back and I love this thing. It\'s a good size and it\'s pretty comfortable to wear across my back while I ride. So far I have not noticed much wear and tear on the fabric and I\'ve had it for 6 months.','Sadye',NULL),(165,165,1,'I would love this bag EXCEPT . . .','I would love this bag EXCEPT with the case on my Iphone won\'t fit in the cell phone pocket! Why make a pocket for cell phones if it\'s not going to fit an Iphone.','Adena',NULL),(166,166,1,'it\'s really ugly,','Its fine I guess but it\'s really ugly, I picked out a really cute bag for college but my mom got me this one instead.','Tracee',NULL),(167,167,1,'What\'s not to like about this bag?!!','What\'s not to like about this bag?!! It\'s simple, clean and modern, and it fits me perfeclty. The roominess is a big plus when I make multiple trips to the gym then the grocery store then wherever else. LOVE IT! ','Anglea',NULL),(168,168,1,'Did I get floor model?','I must have a floor model or soemthin cuz when I ordered it it came all stained up, some brown crust or somethin. Gross. I requested a refund so we\'ll see. Other than that I think it\'s a quality bag, just disappointed with mine. ','Lasandra',NULL),(169,169,1,'I bought this backpack for my daughter','I bought this backpack for my daughter who\'s going to college this year. Her campus is huge and I was concerned that she would hurt her back lugging all those books around. It seems like there\'s enough padding!','Francesca',NULL),(170,170,1,'I heart this backpack so hard. ','I heart this backpack so hard. The colors are soooo cute and there\'s enough room for all my stuff xoxo ','Susy',NULL),(171,171,1,'Can I give zero stars?','I would give this bag zero stars if I could!!!  All of the zippers fell off the first tim I used it!!!  DON\'T BUY THIS ','Ingeborg',NULL),(172,172,1,'Um, not actually waterproof','This bag is definitely not waterproof. I accidentally left it outside in a downpour, and my clothes got soaked. I\'m disappointed!','Aiko',NULL),(173,173,1,'A roomy duffle','I really love how roomy the duffle is. I\'m a clotheshorse, so I like to take a lot of outfits with me when I go away. I have no problem stuffing it all in. It\'s not a very stylish bag, but it serves its purpose.','Dollie',NULL),(174,174,1,'doesn\'t hold that much','It doesn\'t hold that much, so it\'s really just good for a night or two away. It\'s also pretty plain looking, so for those who like bells and whistles, look elsewhere.','Caroyln',NULL),(175,175,1,'Good bank for small hand','I bought this watch specifically for its band because I have really small wrists and have a hard time finding watches that fit, even ones that say women\'s. This one fit wonderfully and I could even make it smaller!','Desiree',NULL),(176,176,1,'Super sleek, love it. ','Super sleek, love it. I\'m buying another as a gift!','Cecelia',NULL),(177,177,1,'My mom loves it','I bought this watch for my mom to workout with and she loves it. It\'s not too difficult for her to set and she uses it all the time now.','Natosha',NULL),(178,178,1,'Not classical but cool','Even though I\'m a fan of classic/traditional styles, I bought this watch for something different since it\'s fun and I could really use for tracking my sprints. I have no complaints!','Pok',NULL),(179,179,1,'Buckle BROKE','my buckle BROKE off the 2nd time I wore it. And then I had issues getting a replacement even with the warranty. Luma needs to stick to clothing basics because they clearly are out of their league with the more technical stuff. UGH','Grace',NULL),(180,180,1,'It died after  a week','It died after  a week of infuriating malfunctionality! First that little plastic screen that houses the numbers - yeah. it popped off in 24 hours. Okay, no problem i thought, i\'ll just not touch any thing vital. Then the metal back popped off and landed in the toilet so there was just no recovering that. THEN  the buckle broke! In the trash it went!','Nadia',NULL),(181,181,1,'The strap broke','The strap broke, which made me think I have fat wrists but I don\'t.','Laronda',NULL),(182,182,1,'Pieces kept coming off','Pieces kept coming off.','Colleen',NULL),(183,183,1,'Keeps excellent time and is pretty tough','Keeps excellent time and is pretty tough! Still no scratches or scuffs after a year of wearing it.','Denese',NULL),(184,184,1,'Has been through quite a few adventures ','Has been through quite a few adventures and vacations with me and still looks and runs great. That includes plenty of trips to water parks with the kids! ','Joette',NULL),(185,185,1,'Rides up during workouts','Rides up a bit during workouts but otherwise it\'s pretty comfy! I like the hood.','Gala',NULL),(186,186,1,'Great for cooler runs. ','Great for cooler runs. ','Shonta',NULL),(187,187,1,'I literally wear this everywhere','I literally wear this everywhere even out to dinner!','Kathrine',NULL),(188,188,1,'I can\'t get enough of this hoodie','I can\'t get enough of this hoodie. It\'s so comfortable, I hate taking it off! I\'m buying it in more colors now so that I can wear it more without people realizing that I wear the same thing every day ;)','Olene',NULL),(189,189,1,'Not really flattering','Not really flattering for my body type','Scarlet',NULL),(190,190,1,'Softest hoodie ever','This hoodie may be the softest thing I\'ve ever touched! It\'s so perfect for curling up on a chilly day. I wore it hiking on a really cold day last November and it kept me really warm. My only issue is that it\'s kind of plain and unflattering. I would love to wear it all the time but it makes me look a little frumpy. Luma, I need this fabric with a more stylish design!','Martina',NULL),(191,191,1,'The fabric stains easily','The fabric stains easily but otherwise I\'m a big fan. I don\'t usually like to wear pullovers but the zipper makes it easy to get on and off.','Elly',NULL),(192,192,1,'I wear it to class','I usually just wear it to class but it\'s definitely comfortable and light enough that you could work out in it.','Temeka',NULL),(193,193,1,'Zipper is goofy','Honestly this hoodie is okay but I do not get thezipper. Why not just make a full length zipper? I would rather have no zipper.','Julieann',NULL),(194,194,1,'Needs long sleeves please','The fleece fabric is really nice, but I hate the short-sleeve design. Can you please make this with long sleeves? It\'ll keep me warmer!','Louisa',NULL),(195,195,1,'My favorite hoodie','This is definitely my favorite hoodie in my closet. I wouldn\'t wear it if it was freezing out, but it\'s a great extra layer on normal mornings.','Joelle',NULL),(196,196,1,'Not very stylish','It\'s kinda average and I don\'t know if I would get it again. With the right color combination, it might look ok, but the combo I have and the short sleeve style doesn\'t make it very stylish.','Jonna',NULL),(197,197,1,'Kept me warm','So I borrowed this from my mom and I have to say It\'s not my style but I was super cold and it did the job. ','Jeanelle',NULL),(198,198,1,'Great value','The sleeves are definitely thicker than you realize, which is a good thing! The photo is a little misleading because it makes the hoodie look thin but it\'s really quite substantial! Great value. ','Oma',NULL),(199,199,1,'Best hoodies I\'ve owned.','im planning on buying another one of these in another color. the best hoodie ive ever owned.','Beatris',NULL),(200,200,1,'Love it!','Walking our St. Benard is pretty serious exercise - you WILL sweat trying to keep up with him. This hoodie keeps me just warm enough and doesn\'t get bogged down with sweat. Love it! ','Georgeann',NULL),(201,201,1,'Fall weather jogs or walks','Perfect for fall weather jogs or walks on cool evenings. The sweat-wicking fabric works wonders, keeps the hoodie dry after you\'ve cooled down so you\'re not cold and wet (which I can\'t stand).','Stefany',NULL),(202,202,1,'Soft but not wrm','Definitely not as warm as I hoped, but its super soft. I\'ll wear it when I need another layer.','Lilliam',NULL),(203,203,1,'Ultra comfy','This is my go-to jacket when I\'m running in the morning. It keeps me warm and is ultra comfy.','Sadye',NULL),(204,204,1,'Pocket too small for mp3','The mp3 pocket barely fits my device. I was hoping for a slightly larger pocket.','Rolande',NULL),(205,205,1,'Fitted, awesome','Can I please wear this every day?! Would that be weird? It\'s fitted, which is awesome because I hate frumpy sweatshirts. And the fleece is a dream!','Elvina',NULL),(206,206,1,'Shrinks a lot','Mine shrunk to! :( I gave it to my little sister.','Alesha',NULL),(207,207,1,'Shrunk right away!','So annoyed! I loved this, but then it shrunk after I washed it once! It\'s adorable but now the sleeves are too short. Returning. :(','Tennille',NULL),(208,208,1,'my new fave zip up','OMG, I\'ve found my new fave zip up!! I live in this thing! I\'m just mad their arent more colors.','Lakeesha',NULL),(209,209,1,'Only shirt I wear anywmore','I wear this to class so often, my friend asked me if I actually own any other shirts!','Charlyn',NULL),(210,210,1,'it\'s so light and really long!','it\'s so light and really long! I wear it with jeans, yoga pants, whatever!','Regenia',NULL),(211,211,1,'Wish I\'d bought the tshirt','Love the material, but the hood kind of flops around. I should have bought the t-shirt instead of the hoodie.','Juliette',NULL),(212,212,1,'Fleece inside, sweater outside','I love wearing fleece, but I hate how it pills and picks up fluff and cat hair. This hoodie is perfect, because it\'s a fleece on the inside and a sweater on the outside. I wear it around the house all the time in the winter.','Anamaria',NULL),(213,213,1,'Great for hiking and camping','Great hoodie for hiking and camping in the fall. I really wish the pockets were bigger, though, I can\'t get my hands in them when I\'m wearing gloves.','Tiffiny',NULL),(214,214,1,'Super warm.','Super warm. My mom bought this for me for when I have to go watch my stupid brother play middle school football in 30 degree weather.','Cara',NULL),(215,215,1,'This is REALLY comfortable!','This is REALLY comfortable! It\'s a little too bulky to run or bike in, but for cold-weather hikes it\'s awesome.','Nadene',NULL),(216,216,1,'Thumb holes rock!','Thumb holes rock!','Tawny',NULL),(217,217,1,'REALLY lightweight.','OK this jacket is REALLY lightweight. But if it\'s really cold, you have to wear it with baselayers or you\'ll freeze. It\'s a good buy, but be prepared!','Illa',NULL),(218,218,1,'Nice for skiing','Looks good and feels good. It\'s nice for skiing because it blocks the wind and keeps you warm, but doesn\'t get too hot after you start sweating.','Ela',NULL),(219,219,1,'Most comfortable jacket','I have never worn such a comfortable jacket!!!  It\'s really thin and moves well with your body, I have no idea how it manages to keep you so warm. And if you\'ll be in really cold weather, you can easily add some extra layers underneath and still be comfortable.','Kecia',NULL),(220,220,1,'a little short for me','It\'s a little short for my loooooooooooooong torso, but it\'s still comfy and cute. Good for short runs.','Johna',NULL),(221,221,1,'Square shape','Makes me look like a square. Literally, like a square shape.','Jessi',NULL),(222,222,1,'This is my go-to jacket','This is my go-to jacket when I\'m running in the rain or cold! It\'s warm but lightweight, totally waterproof, and I love the colors!','Kellye',NULL),(223,223,1,'I wear this pretty much every day!','I wear this pretty much every day! The material is really soft and it goes with everything!','Marvella',NULL),(224,224,1,'Horrible unflatterung design','It\'s called not making clothes that are boxy and unflattering. Heard of it?','May',NULL),(225,225,1,'The actual color is brighter','The actual color is brighter than it looks in the photo, but thats why I like it for jogging in the neighborhood at night ','Chasidy',NULL),(226,226,1,'Big back pocket','my fave part is the back pocket. I needed a place to keep my cell phone safe when I run','Wava',NULL),(227,227,1,'Everyone loves this jacket on me','I got this jacket for tennis practice since its in my schools color and everyone on the team loves it!!','Kristyn',NULL),(228,228,1,'Rain proof?','I don\'t know if this jacket would be good for a whole day outside in the snow. It says waterproof but mine got pretty soaked one day when it was raining. ','Janna',NULL),(229,229,1,'Overheated','I agree with that other reviewer. I get very overheated while wearing this jacket while shoveling snow. ','Venetta',NULL),(230,230,1,'Great colors!','I\'m into the colors cause they\'re great for night skiing-but I overheated really fast in this jacket','Demetrice',NULL),(231,231,1,'This is the most dependable piece I own.','This is the most dependable piece I own. You\'ll rarely me without this on. (except in the summer)','Mathilde',NULL),(232,232,1,'Not for cold weather','This really doesn\'t deliver on the insulating part. I can\'t say I would throw this on in really chilly temperatures-need a coat.','Eda',NULL),(233,233,1,'Perfect, perfect, perfect in every way. ','Perfect, perfect, perfect in every way. I love the quilting and it keeps me toasty warm.','Denyse',NULL),(234,234,1,'Awesome bottoms ','Awesome bottoms for working out or just relaxing at the house.','Ashlee',NULL),(235,235,1,'Great for yoga','I\'m not a fan of really tight or compressed pants so I love these for my yoga classes (not so much for hot yoga, though). ','Nyla',NULL),(236,236,1,'Yoga is for hippees','I bought these to hang out in not for yoga. yoga is for hippees!','Judith',NULL),(237,237,1,'I can\'t stop lookin in the mirror! ','I can\'t stop lookin in the mirror! ','Isadora',NULL),(238,238,1,'Want more colors','Guys. I have like 10 pairs of these cause they\'re so comfy, natch! Please make more colors!','Isela',NULL),(239,239,1,'I have 5 pairs','I literally have about 5 pairs of these in my drawer. I don\'t just wear them to yoga though. Oh no! I wear them on a normal Saturday around town. Love them!','Dannielle',NULL),(240,240,1,'These pants move so well!','These pants move so well! They provide nice coverage so when I\'m in Downward Dog, I don\'t have to worry. I don\'t know about this Cooltech technology though. I sweat in them, so they definitely don\'t keep me dry. They\'re pretty warm!','Deloise',NULL),(241,241,1,'Seams separated righth away','I wear them once and the seams started to separate! Not constructed well at all. With the kazillion other yoga pants out there, there\'s no excuse for this!','Rosann',NULL),(242,242,1,'high waistband, no muffin top!','Love the cut and the high waistband. Bye bye, muffin top!','Lily',NULL),(243,243,1,'Relaxing','My favorite part of the day is when I get to come home, take my work pants off and slip these on. Sooo soft and perfect for relaxing.','Brittany',NULL),(244,244,1,'LOVE, LOVE, LOVE.  ','LOVE, LOVE, LOVE. They are so comfy and good for anything. I have two toddlers, so I rarely get a chance to finish my morning stretches and yoga, let alone get changed afterward before I get interrupted by my kids. Sometimes I will be making lunch and realize that I\'m still wearing these! They\'re so comfy and good for anything. It\'s nice to know that if I need to run out on a quick errand, I won\'t look like a total bum even if I forgot to change.','Brittni',NULL),(245,245,1,'NOT flattering.','NOT flattering. My boyfriend bought me these cuz he loves the way yoga pants look. I wore them once and he said I should return them then we broke up :(','Pamela',NULL),(246,246,1,'These are soft and stretchy','These are soft and stretchy enough but don\'t draw sweat away. ','Tarra',NULL),(247,247,1,'I bought these for yoga','I bought these for yoga but they make better pajama bottoms. I like a tighter fit for yoga.','Lue',NULL),(248,248,1,'These pants are so cute!','These pants are so cute! I like them better for lounging than exercising, though. The material gets a little too hot when I\'m working out.','Mavis',NULL),(249,249,1,'good for PJs but that\'s about it','good for PJs but that\'s about it','Kemberly',NULL),(250,250,1,'These are my favorite pants. ','These are my favorite pants. Super cute and soooo comfy.','Tashina',NULL),(251,251,1,'Soooooooooooooo light!','Soooooooooooooo light!','Beverlee',NULL),(252,252,1,'Cute.','Cute.','Latarsha',NULL),(253,253,1,'I really dig this shirt for races','I really dig this shirt for races, it makes me feel like I\'m flying.','Lorena',NULL),(254,254,1,'This shirt is decent for running','This shirt is pretty good! I\'m a long distance runner and it keeps me pretty comfortable, although these companies always act like their shirts are magical and really it\'s just pretty basic stuff. Still it\'s a decent shirt and I would recommend it. Just don\'t expect it to change your life.','Allyson',NULL),(255,255,1,'Wish it was longer','fits kind of awkward wish it was longer','Chloe',NULL),(256,256,1,'Fits my large head TG','So I have a really large head and I love this shirt bc the neckline is so stretchy! Honestly I have gotten stuck in other running shirts with the really small collar hahahahaha so embarrassing!!! !!','Hsiu',NULL),(257,257,1,'Flatters my big build','I have broad, strong shoulders and this top is one of the very few that flatters my build. 5 stars for sure!','Annamaria',NULL),(258,258,1,'Fits my fiancee better','My fiance accidentally put this on when he was getting dressed and it fit him better than it fits me?? ','Lang',NULL),(259,259,1,'Fabric is great for sport','I do think the fabric is great for sports but the cut and style are weeeird.','Becki',NULL),(260,260,1,'Doesn\'t help my figure one bit','The contored design is NOT really contored. I rarely wear this top out because it doesn\'t do anything for my figure.','Hellen',NULL),(261,261,1,'What\'s with the sleeve cut?','What\'s with the sleeve cut? I don\'t even have linebacker shoulders but I feel like the sleeves are cutting off circulation to my arms!','Pearle',NULL),(262,262,1,'Light, comfy','Light, comfy, does a good job shedding sweat.','Slyvia',NULL),(263,263,1,'Light but tight','This shirt is very light but a TIGHT fit! Almost compression-tight.','Nell',NULL),(264,264,1,'Looks and feels aweseom ','Really like the seams. Looks and feels awesome!','Skye',NULL),(265,265,1,'Really close-fitting. Do not love.','Really close-fitting. Do not love.','Amberly',NULL),(266,266,1,'Not at all soft','There\'s a ton of other t-shirts I\'d choose over this one. It\'s not soft at all and the fabric feels like sandpaper next to my skin-was really hoping for better.','Ashli',NULL),(267,267,1,'This T is a no brainer-solid color','This T is a no brainer-solid color, pairs with everything, and keeps me cool. What more could I want during my run?','Ruth',NULL),(268,268,1,'Thank you! ','Thank you! I\'m so sick of inappropriate workout clothes. This is exactly what I was looking for. Cover yourselves up, ladies!','Sonja',NULL),(269,269,1,'Um, NOT flattering at ALL.','Um, NOT flattering at ALL. Too tight and short.','Candie',NULL),(270,270,1,'Like the color .sleeves were too tight. ','Like the color .sleeves were too tight. felt constricted.','Elmira',NULL),(271,271,1,'Sooooooooooo soft! ','Sooooooooooo soft! Nice and long too.','Nyla',NULL),(272,272,1,'Cute, comfy. ','Cute, comfy. A little overpriced though.','Hollie',NULL),(273,273,1,'I love that it\'s so lightweight. ','I love that it\'s so lightweight. I can wear it under jackets and vests without feeling like a stuffed sausage.','Celestine',NULL),(274,274,1,'who doesn\'t love a racerback, amiright?!','who doesn\'t love a racerback, amiright?!','Irma',NULL),(275,275,1,'I where this AAALLLLL the time','I where this AAALLLLL the time to workout! Its so comfy and cute! I just wish it was a little longer.','Gidget',NULL),(276,276,1,'soft but a little tight','soft but a little tight for my liking.','Tatiana',NULL),(277,277,1,'Love the fabric, but it\'s huge!','Love the fabric, but it\'s huge! I look like a homeless person in it.','Maisie',NULL),(278,278,1,'Soft','seriously, I can\'t get over how soft this tank top is. Do you have anything else made with it?','Karine',NULL),(279,279,1,'omg I love this tank top, it\'s perfect','omg I love this tank top, it\'s perfect for running and yoga. The fabric is so soft and stretchy!','Bree',NULL),(280,280,1,'cool and dry','What I rally love here is that it does the job of keeping me cool and dry.  I\'m a big guy and sweat A LOT! Even after a day of gulf, I\'m still dry and comfortable. The problem is that the sleeves are very tight - actually bought a second shirt because i split the armpit/sleeve area of the first. Do yourself a favor and order a size bigger.  ','Lakeisha',NULL),(281,281,1,'Not great','Not great - buttons are too small and hurt my fingers trying to button it. I\'ve seen better designs...','Collette',NULL),(282,282,1,'What a versatile shirt!','What a versatile shirt! Not only does it feel very soft compared to my old worn out polos, but it also does the job promised. I like going out after my gamefor drinks so I look good then too and don\'t need to change into something fresh. ','Adaline',NULL),(283,283,1,'So comfortable I almost feel barefoot. T','So comfortable I almost feel barefoot. The treads on these is so intricate and deep, so they can be hard to clean. ','Karisa',NULL),(284,284,1,'On the plus side, the perforated cushion','On the plus side, the perforated cushioning  is really soft and reduces friction. However, they seem to absorb sweat and don\'t dry very quickly, which causes a lot of odor. ','Evelyn',NULL),(285,285,1,'I threw them out when the mushy lining s','I threw them out when the mushy lining started to ooze. ','Markita',NULL),(286,286,1,'Beyond perfection! I always get tons of ','Beyond perfection! I always get tons of compliments when I wear these out.','Manuela',NULL),(287,287,1,'These look awesome with EVERYTHING! Hone','These look awesome with EVERYTHING! Honestly, there\'s nothing you can wear that won\'t look perfect with these. Preppy and retro! Love them!','Gwen',NULL),(288,288,1,'The suede upper makes these pretty hard ','The suede upper makes these pretty hard to wear if its raining outside! The sneaker designers really weren\'t thinking on this one. Cute design though!','Jovan',NULL),(289,289,1,'Love a preppy sneaker! These are still a','Love a preppy sneaker! These are still adorable but not as casual as running shoes! Love them!','Shellie',NULL),(290,290,1,'These are my favorite new pair of sneake','These are my favorite new pair of sneakers! I just hate that they get dirty really fast.','Dena',NULL),(291,291,1,'Have had these for quite a while and the','Have had these for quite a while and they\'re still my go-to pair for every morning jog. Really hold up well and still feel good.','Evalyn',NULL),(292,292,1,'Really comfy and awesome for running or ','Really comfy and awesome for running or checking out trails at the park. ','Adele',NULL),(293,293,1,'Velcro straps?? Are you kidding me? Am I','Velcro straps?? Are you kidding me? Am I two years old? The bottom is cool though!','Star',NULL),(294,294,1,'Cool-looking kicks! I\'d wear them anywhe','Cool-looking kicks! I\'d wear them anywhere not just the gym or running. They\'ll look great with everything!','Nikki',NULL),(295,295,1,'I absolutely love these trainers. I can ','I absolutely love these trainers. I can get on the gym floor so quick becuz i don\'t have to tie any annoying ties.','Rosy',NULL),(296,296,1,'Don\'t like the strap on top; gets too lo','Don\'t like the strap on top; gets too loose sometimes','Aleen',NULL),(297,297,1,'Love the no laces and they feel really g','Love the no laces and they feel really good- wear em all the time!','Dannette',NULL),(298,298,1,'I love these for when I walk the boardwa','I love these for when I walk the boardwalk with my grandaughter. They seem pretty hip and I got lots of compliments on them from the ladies at the bingo night','Lita',NULL),(299,299,1,'These looked really ugly on my feet when','These looked really ugly on my feet when I got them. The picture online is much more flattering than the reality. I\'m bummed. ','Joyce',NULL),(300,300,1,'I can appreciate the concept, but I thin','I can appreciate the concept, but I think I\'ll be going back to regular laced sneakers from now on, they just didn\'t seem to fit my feet as well I guess because my feet are so narrow. People with narrow feet shouldn\'t buy these!','Gertrud',NULL),(301,301,1,'I couldn\'t live without these. I wear th','I couldn\'t live without these. I wear them everywhere, not just running. They feel like I don\'t have anything on my feet, and their so, so comfortble.','Leonia',NULL),(302,302,1,'These are really well made and so lightw','These are really well made and so lightweight. I\'ll definitely be buying more of these.','Nadene',NULL),(303,303,1,'Want these in every single color Luma ma','Want these in every single color Luma makes! I am the first to say that I\'m a couch potatoe, I don\'t run at all. I wear these to the mall for shopping instead. :)','Min',NULL),(304,304,1,'Ummm, fashion? If you say so. They\'re co','Ummm, fashion? If you say so. They\'re comfy and all, but these shoes are hideous.','Katy',NULL),(305,305,1,'Cute and comfortable definitely. The ela','Cute and comfortable definitely. The elastic streteched out a bit too much but I still wear them.','Laurice',NULL),(306,306,1,'Love love LOVE!!!  I can\'t get enough of ','Love love LOVE!!!  I can\'t get enough of these shoes. They are SUPER comfy and go with everything!','Kara',NULL),(307,307,1,'It was really hard to find the right siz','It was really hard to find the right size for these. I had to send them back 3 times before I got a pair that fit. Really aggravating!!!  I ended up having to get two sizes larger than I usually wear and a wide, which I\'ve never worn before in my life. Sizing is messed up do yourself a favor, go to the store and try them on.','Angeline',NULL),(308,308,1,'VERY LIGHTWEIGHT COMFY-GOOD SHOES','VERY LIGHTWEIGHT COMFY-GOOD SHOES','Marita',NULL),(309,309,1,'Wore these for a year and they started f','Wore these for a year and they started falling apart. For the price I guess I\'ll just get another pair cuz I do like them. But I think a shoe should last longer. It\'s not like I can take my sneakers to a cobbler haha','Pura',NULL),(310,310,1,'I am in love with these shoes and will b','I am in love with these shoes and will buy them until they don\'t make them anymore. I run every day in them and I\'m still on my first pair after a whole year. They\'re SO comfy.','Natashia',NULL),(311,311,1,'Design is adorable-when you have cute wo','Design is adorable-when you have cute workout gear, exercising is fun. I\'d buy these again.','Brigitte',NULL),(312,312,1,'Have no idea what all the fuss is about ','Have no idea what all the fuss is about with these. I don\'t know, maybe I just bought the wrong size, but these are so uncomfortable. They dig into my toes and I always end up with blisters. Their cute but will look elsewhere.','Roseline',NULL),(313,313,1,'Pic is WAY different then the real thing','Pic is WAY different then the real thing! My mom wouldn\'t even wear these there so ugly! Can I give a 0 rating?','Garnett',NULL),(314,314,1,'Meh, I\'m not hating them, but I\'m not in','Meh, I\'m not hating them, but I\'m not in love. The eyelet part looks way different online and the elastic band felt really tight. They are pretty comfy other than that.','Eugena',NULL),(315,315,1,'I\'m a mom on the go and I love these sho','I\'m a mom on the go and I love these shoes! They\'re comfy, cute and easy to slip on. What more could you ask for?','Elina',NULL),(316,316,1,'Not exactly true to size','Not exactly true to size but still very comfortable. ','Mistie',NULL),(317,317,1,'Snug fit without being too tight','Snug fit without being too tight and no irritation or chafing. ','Ming',NULL),(318,318,1,'bra stays comfy and dry','I play field hockey and it gets crazy hot outside - bra stays comfy and pretty dry. Recommended!','Mei',NULL),(319,319,1,'One of my favorites b/c no chafing!','One of my favorites b/c no chafing!','Bernetta',NULL),(320,320,1,'Doesn\'t fit me. Luma fail.','Doesn\'t fit me. Luma fail.','Roxie',NULL),(321,321,1,'does not fit. worthless.','does not fit. worthless.','Ardelia',NULL),(322,322,1,'So, so awesome. Great Support!','So, so awesome. Great Support! I just can\'t wait for the day that I\'m comfortable enough with my midriff to wear this sans shirt, because the pattern is really cute!!','Dorcas',NULL),(323,323,1,'I love this bra','I have a B cup and I love how this bra feels! It has a really firm fit but it doesn\'t feel too tight. I wish every bra felt like this!','Cayla',NULL),(324,324,1,'So comfortable','If I could wear this sports bra every day, I definitely would. It\'s so so comfortable and washes well.','Tonya',NULL),(325,325,1,'It\'s an average bra','It\'s an average bra-nothing to write home about. I don\'t like how the straps dig into my shoulders, and it really doesn\'t provide that much support.','Eartha',NULL),(326,326,1,'Make this with patterns','I wish they made this bra with patterns because I like to look good at the gym. This is a little blah, but still cute. I would never wear it by itself.','Jammie',NULL),(327,327,1,'Cute gym top','So, it doesn\'t say that theres no shelf bra. BEWARE! Other than that, cute gym top.','Lorena',NULL),(328,328,1,'Cute, stretchy top!','Cute, stretchy top! Perfect for people with zero body fat.','Modesta',NULL),(329,329,1,'I got every color','I am a compulsive hoarder of workout gear so of course I had to have this in every color. I feel better after I buy them all because it\'s a good price!','Ayanna',NULL),(330,330,1,'unflattering. Ugh.','unflattering. Ugh. The elastic was literaly digging into my skin. I got my exact size so I thought I\'d be good. All set.','Avelina',NULL),(331,331,1,'Training bra?','Makes me feel like I\'m wearing a training bra. Comfy though.','Maribel',NULL),(332,332,1,'Sizes are off','I had to order 3 sizes before I found my fit. The sizes do NOT line up. I did like it in the end. Just took too long to get there.','Krystina',NULL),(333,333,1,'Makes me feel so snug! WHOO! ','Makes me feel so snug! WHOO! ','Concepcion',NULL),(334,334,1,'Could be flirtier.','Could be flirtier.','Emerald',NULL),(335,335,1,'Not for non-petite','Watch out if you\'re shapely like me - this tiny thing makes it hard to breath! ','Teofila',NULL),(336,336,1,'one of my favorites','I do a lot of different exercises and this tank - I have 2 of them - is one of my favorites. It\'s really soft and stays drier than other tops I\'ve had.','Elza',NULL),(337,337,1,'Zero support/modesty','I would never wear this bra to anything but a low impact class like yoga. There\'s zero support and absolutely no modesty. Was hoping for better!','Shaunte',NULL),(338,338,1,'Not for high impact','Definitely not good for anything high-impact, but it\'s very stylish for yoga or something else low impact.','Merrie',NULL),(339,339,1,'A regular or me','This is in regular rotation at the gym. Its colorful and looks kinda cute under my exercise tanks.','Pearl',NULL),(340,340,1,'Great fit - love the v-neck design! ','Great fit - love the v-neck design! ','Thalia',NULL),(341,341,1,'The seams bother me','Some of the seams bother me during certain workouts but otherwise very comfortable','Carma',NULL),(342,342,1,'A sweet n sporty look for the gym','Always a sweet n sporty look for the gym! Keeps me cool and the seams don\'t rub up against me like some of my other tanks.','Maryanna',NULL),(343,343,1,'Good choice for working out','Good choice for working out and stylin\' enough to wear when I\'m hanging with friends on hot days. Also washes really well! ','Elfriede',NULL),(344,344,1,'I love the look','I love the look of this top, but I wasn\'t too crazy about the fit. The medium was too big in my opinion.','Yan',NULL),(345,345,1,'Huge arm holes??','I don\'t know why the arm holes are so big. It looked ok in the photo but in person they\'re really wide. It\'s really comfortable but that bugs me.','Valorie',NULL),(346,346,1,'Super cute!!!  I love it','Super cute!!!  I love it and want more colors. I really like running in this tank because it\'s not too tight.','Mikkel',NULL);

--
