-- Table structure for table `rating_option_vote`
--

CREATE TABLE `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) 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 `RATING_OPTION_VOTE_REVIEW_ID_REVIEW_REVIEW_ID` (`review_id`),
  KEY `RATING_OPTION_VOTE_OPTION_ID` (`option_id`),
  CONSTRAINT `RATING_OPTION_VOTE_OPTION_ID_RATING_OPTION_OPTION_ID` FOREIGN KEY (`option_id`) REFERENCES `rating_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `RATING_OPTION_VOTE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Rating option values';

--
-- Dumping data for table `rating_option_vote`
--


--
-- Table structure for table `rating_option_vote_aggregated`
--

CREATE TABLE `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 `RATING_OPTION_VOTE_AGGREGATED_RATING_ID` (`rating_id`),
  KEY `RATING_OPTION_VOTE_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `RATING_OPTION_VOTE_AGGREGATED_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `RATING_OPTION_VOTE_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Rating vote aggregated';

--
-- Dumping data for table `rating_option_vote_aggregated`
--


--
-- Table structure for table `rating_store`
--

CREATE TABLE `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 `RATING_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `RATING_STORE_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `RATING_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Rating Store';

--
-- Dumping data for table `rating_store`
--


--
-- Table structure for table `rating_title`
--

CREATE TABLE `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) NOT NULL COMMENT 'Rating Label',
  PRIMARY KEY (`rating_id`,`store_id`),
  KEY `RATING_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `RATING_TITLE_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `RATING_TITLE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Rating Title';

--
-- Dumping data for table `rating_title`
--


--
-- Table structure for table `release_notification_viewer_log`
--

CREATE TABLE `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) NOT NULL COMMENT 'Viewer last view on product version',
  PRIMARY KEY (`id`),
  UNIQUE KEY `RELEASE_NOTIFICATION_VIEWER_LOG_VIEWER_ID` (`viewer_id`),
  CONSTRAINT `RELEASE_NOTIFICATION_VIEWER_LOG_VIEWER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`viewer_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Release Notification Viewer Log Table';

--
-- Dumping data for table `release_notification_viewer_log`
--


--
-- Table structure for table `report_compared_product_index`
--

CREATE TABLE `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 `REPORT_COMPARED_PRODUCT_INDEX_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  UNIQUE KEY `REPORT_COMPARED_PRODUCT_INDEX_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `REPORT_COMPARED_PRODUCT_INDEX_STORE_ID` (`store_id`),
  KEY `REPORT_COMPARED_PRODUCT_INDEX_ADDED_AT` (`added_at`),
  KEY `REPORT_COMPARED_PRODUCT_INDEX_PRODUCT_ID` (`product_id`),
  CONSTRAINT `REPORT_CMPD_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_CMPD_PRD_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_COMPARED_PRODUCT_INDEX_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Reports Compared Product Index Table';

--
-- Dumping data for table `report_compared_product_index`
--


--
-- Table structure for table `report_event`
--

CREATE TABLE `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 `REPORT_EVENT_EVENT_TYPE_ID` (`event_type_id`),
  KEY `REPORT_EVENT_SUBJECT_ID` (`subject_id`),
  KEY `REPORT_EVENT_OBJECT_ID` (`object_id`),
  KEY `REPORT_EVENT_SUBTYPE` (`subtype`),
  KEY `REPORT_EVENT_STORE_ID` (`store_id`),
  CONSTRAINT `REPORT_EVENT_EVENT_TYPE_ID_REPORT_EVENT_TYPES_EVENT_TYPE_ID` FOREIGN KEY (`event_type_id`) REFERENCES `report_event_types` (`event_type_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_EVENT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Reports Event Table';

--
-- Dumping data for table `report_event`
--


--
-- Table structure for table `report_event_types`
--

CREATE TABLE `report_event_types` (
  `event_type_id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event Type ID',
  `event_name` varchar(64) 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=utf8mb3 COMMENT='Reports Event Type Table';

--
-- Dumping data for table `report_event_types`
--

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

CREATE TABLE `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) 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 `REPORT_VIEWED_PRD_AGGRED_DAILY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_STORE_ID` (`store_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `REPORT_VIEWED_PRD_AGGRED_DAILY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Most Viewed Products Aggregated Daily';

--
-- Dumping data for table `report_viewed_product_aggregated_daily`
--


--
-- Table structure for table `report_viewed_product_aggregated_monthly`
--

CREATE TABLE `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) 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 `REPORT_VIEWED_PRD_AGGRED_MONTHLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_STORE_ID` (`store_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `REPORT_VIEWED_PRD_AGGRED_MONTHLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Most Viewed Products Aggregated Monthly';

--
-- Dumping data for table `report_viewed_product_aggregated_monthly`
--


--
-- Table structure for table `report_viewed_product_aggregated_yearly`
--

CREATE TABLE `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) 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 `REPORT_VIEWED_PRD_AGGRED_YEARLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `REPORT_VIEWED_PRD_AGGRED_YEARLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Most Viewed Products Aggregated Yearly';

--
-- Dumping data for table `report_viewed_product_aggregated_yearly`
--


--
-- Table structure for table `report_viewed_product_index`
--

CREATE TABLE `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 `REPORT_VIEWED_PRODUCT_INDEX_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  UNIQUE KEY `REPORT_VIEWED_PRODUCT_INDEX_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `REPORT_VIEWED_PRODUCT_INDEX_STORE_ID` (`store_id`),
  KEY `REPORT_VIEWED_PRODUCT_INDEX_ADDED_AT` (`added_at`),
  KEY `REPORT_VIEWED_PRODUCT_INDEX_PRODUCT_ID` (`product_id`),
  CONSTRAINT `REPORT_VIEWED_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRD_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRODUCT_INDEX_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Reports Viewed Product Index Table';

--
-- Dumping data for table `report_viewed_product_index`
--


--
-- Table structure for table `reporting_counts`
--

CREATE TABLE `reporting_counts` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `type` varchar(255) 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=utf8mb3 COMMENT='Reporting for all count related events generated via the cron job';

--
-- Dumping data for table `reporting_counts`
--


--
-- Table structure for table `reporting_module_status`
--

CREATE TABLE `reporting_module_status` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Module ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Module Name',
  `active` varchar(255) DEFAULT NULL COMMENT 'Module Active Status',
  `setup_version` varchar(255) DEFAULT NULL COMMENT 'Module Version',
  `state` varchar(255) 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=utf8mb3 COMMENT='Module Status Table';

--
-- Dumping data for table `reporting_module_status`
--


--
-- Table structure for table `reporting_orders`
--

CREATE TABLE `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=utf8mb3 COMMENT='Reporting for all orders';

--
-- Dumping data for table `reporting_orders`
--


--
-- Table structure for table `reporting_system_updates`
--

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

--
-- Dumping data for table `reporting_system_updates`
--


--
-- Table structure for table `reporting_users`
--

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

--
-- Dumping data for table `reporting_users`
--


--
-- Table structure for table `review`
--

CREATE TABLE `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 `REVIEW_ENTITY_ID` (`entity_id`),
  KEY `REVIEW_STATUS_ID` (`status_id`),
  KEY `REVIEW_ENTITY_PK_VALUE` (`entity_pk_value`),
  CONSTRAINT `REVIEW_ENTITY_ID_REVIEW_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `review_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `review_status` (`status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Review base information';

--
-- Dumping data for table `review`
--


--
-- Table structure for table `review_detail`
--

CREATE TABLE `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) NOT NULL COMMENT 'Title',
  `detail` text NOT NULL COMMENT 'Detail description',
  `nickname` varchar(128) NOT NULL COMMENT 'User nickname',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  PRIMARY KEY (`detail_id`),
  KEY `REVIEW_DETAIL_REVIEW_ID` (`review_id`),
  KEY `REVIEW_DETAIL_STORE_ID` (`store_id`),
  KEY `REVIEW_DETAIL_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `REVIEW_DETAIL_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `REVIEW_DETAIL_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE,
  CONSTRAINT `REVIEW_DETAIL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Review detail information';

--
-- Dumping data for table `review_detail`
--


--
-- Table structure for table `review_entity`
--

CREATE TABLE `review_entity` (
  `entity_id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review entity ID',
  `entity_code` varchar(32) NOT NULL COMMENT 'Review entity code',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='Review entities';

--
-- Dumping data for table `review_entity`
--

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

--
-- Table structure for table `review_entity_summary`
--

CREATE TABLE `review_entity_summary` (
  `primary_id` bigint NOT NULL AUTO_INCREMENT COMMENT 'Summary review entity ID',
  `entity_pk_value` bigint NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `entity_type` smallint NOT NULL DEFAULT '0' COMMENT 'Entity type ID',
  `reviews_count` smallint NOT NULL DEFAULT '0' COMMENT 'Qty of reviews',
  `rating_summary` smallint NOT NULL DEFAULT '0' COMMENT 'Summarized rating',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`primary_id`),
  UNIQUE KEY `REVIEW_ENTITY_SUMMARY_ENTITY_PK_VALUE_STORE_ID_ENTITY_TYPE` (`entity_pk_value`,`store_id`,`entity_type`),
  KEY `REVIEW_ENTITY_SUMMARY_STORE_ID` (`store_id`),
  CONSTRAINT `REVIEW_ENTITY_SUMMARY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Review aggregates';

--
-- Dumping data for table `review_entity_summary`
--


--
-- Table structure for table `review_status`
--

CREATE TABLE `review_status` (
  `status_id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Status ID',
  `status_code` varchar(32) NOT NULL COMMENT 'Status code',
  PRIMARY KEY (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='Review statuses';

--
-- Dumping data for table `review_status`
--

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

--
-- Table structure for table `review_store`
--

CREATE TABLE `review_store` (
  `review_id` bigint unsigned NOT NULL COMMENT 'Review ID',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`review_id`,`store_id`),
  KEY `REVIEW_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `REVIEW_STORE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE,
  CONSTRAINT `REVIEW_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Review Store';

--
-- Dumping data for table `review_store`
--


--
-- Table structure for table `sales_bestsellers_aggregated_daily`
--

CREATE TABLE `sales_bestsellers_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) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty Ordered',
  `rating_pos` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID` (`store_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Bestsellers Aggregated Daily';

--
-- Dumping data for table `sales_bestsellers_aggregated_daily`
--


--
-- Table structure for table `sales_bestsellers_aggregated_monthly`
--

CREATE TABLE `sales_bestsellers_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) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty Ordered',
  `rating_pos` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID` (`store_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Bestsellers Aggregated Monthly';

--
-- Dumping data for table `sales_bestsellers_aggregated_monthly`
--


--
-- Table structure for table `sales_bestsellers_aggregated_yearly`
--

CREATE TABLE `sales_bestsellers_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) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty Ordered',
  `rating_pos` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Bestsellers Aggregated Yearly';

--
-- Dumping data for table `sales_bestsellers_aggregated_yearly`
--


--
-- Table structure for table `sales_creditmemo`
--

CREATE TABLE `sales_creditmemo` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `store_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `base_adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Negative',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `store_to_base_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `base_adjustment` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `adjustment` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Positive',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `email_sent` smallint unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint unsigned DEFAULT NULL COMMENT 'Send Email',
  `creditmemo_status` int DEFAULT NULL COMMENT 'Creditmemo Status',
  `state` int DEFAULT NULL COMMENT 'State',
  `shipping_address_id` int DEFAULT NULL COMMENT 'Shipping Address ID',
  `billing_address_id` int DEFAULT NULL COMMENT 'Billing Address ID',
  `invoice_id` int DEFAULT NULL COMMENT 'Invoice ID',
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `transaction_id` varchar(255) DEFAULT NULL COMMENT 'Transaction ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `customer_note` text COMMENT 'Customer Note',
  `customer_note_notify` smallint unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_CREDITMEMO_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_CREDITMEMO_STORE_ID` (`store_id`),
  KEY `SALES_CREDITMEMO_ORDER_ID` (`order_id`),
  KEY `SALES_CREDITMEMO_CREDITMEMO_STATUS` (`creditmemo_status`),
  KEY `SALES_CREDITMEMO_STATE` (`state`),
  KEY `SALES_CREDITMEMO_CREATED_AT` (`created_at`),
  KEY `SALES_CREDITMEMO_UPDATED_AT` (`updated_at`),
  KEY `SALES_CREDITMEMO_SEND_EMAIL` (`send_email`),
  KEY `SALES_CREDITMEMO_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_CREDITMEMO_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_CREDITMEMO_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Creditmemo';

--
-- Dumping data for table `sales_creditmemo`
--


--
-- Table structure for table `sales_creditmemo_comment`
--

CREATE TABLE `sales_creditmemo_comment` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_CREDITMEMO_COMMENT_CREATED_AT` (`created_at`),
  KEY `SALES_CREDITMEMO_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_CREDITMEMO_COMMENT_PARENT_ID_SALES_CREDITMEMO_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_creditmemo` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Creditmemo Comment';

--
-- Dumping data for table `sales_creditmemo_comment`
--


--
-- Table structure for table `sales_creditmemo_grid`
--

CREATE TABLE `sales_creditmemo_grid` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_created_at` timestamp NULL DEFAULT NULL COMMENT 'Order Created At',
  `billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
  `state` int DEFAULT NULL COMMENT 'Status',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `order_status` varchar(32) DEFAULT NULL COMMENT 'Order Status',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `customer_name` varchar(128) NOT NULL COMMENT 'Customer Name',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` smallint DEFAULT NULL COMMENT 'Customer Group ID',
  `payment_method` varchar(32) DEFAULT NULL COMMENT 'Payment Method',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
  `adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
  `adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
  `order_base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Order Grand Total',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_CREDITMEMO_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `SALES_CREDITMEMO_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_CREDITMEMO_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `SALES_CREDITMEMO_GRID_STATE` (`state`),
  KEY `SALES_CREDITMEMO_GRID_BILLING_NAME` (`billing_name`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_STATUS` (`order_status`),
  KEY `SALES_CREDITMEMO_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  KEY `SALES_CREDITMEMO_GRID_STORE_ID` (`store_id`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_BASE_GRAND_TOTAL` (`order_base_grand_total`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_ID` (`order_id`),
  FULLTEXT KEY `FTI_32B7BA885941A8254EE84AE650ABDC86` (`increment_id`,`order_increment_id`,`billing_name`,`billing_address`,`shipping_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Creditmemo Grid';

--
-- Dumping data for table `sales_creditmemo_grid`
--


--
-- Table structure for table `sales_creditmemo_item`
--

CREATE TABLE `sales_creditmemo_item` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
  `tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Tax Amount',
  `base_row_total` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total',
  `discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Amount',
  `row_total` decimal(12,4) DEFAULT NULL COMMENT 'Row Total',
  `base_discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `base_price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `base_row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `product_id` int DEFAULT NULL COMMENT 'Product ID',
  `order_item_id` int DEFAULT NULL COMMENT 'Order Item ID',
  `additional_data` text COMMENT 'Additional Data',
  `description` text COMMENT 'Description',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `tax_ratio` text COMMENT 'Ratio of tax in the creditmemo item over tax of the order item',
  `weee_tax_applied` text COMMENT 'Weee Tax Applied',
  `weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Amount',
  `weee_tax_applied_row_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Row Amount',
  `weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Disposition',
  `weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Row Disposition',
  `base_weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Amount',
  `base_weee_tax_applied_row_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Row Amnt',
  `base_weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Disposition',
  `base_weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Row Disposition',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_CREDITMEMO_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_CREDITMEMO_ITEM_PARENT_ID_SALES_CREDITMEMO_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_creditmemo` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Creditmemo Item';

--
-- Dumping data for table `sales_creditmemo_item`
--


--
-- Table structure for table `sales_invoice`
--

CREATE TABLE `sales_invoice` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `store_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `store_to_base_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `billing_address_id` int DEFAULT NULL COMMENT 'Billing Address ID',
  `is_used_for_refund` smallint unsigned DEFAULT NULL COMMENT 'Is Used For Refund',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `email_sent` smallint unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint unsigned DEFAULT NULL COMMENT 'Send Email',
  `can_void_flag` smallint unsigned DEFAULT NULL COMMENT 'Can Void Flag',
  `state` int DEFAULT NULL COMMENT 'State',
  `shipping_address_id` int DEFAULT NULL COMMENT 'Shipping Address ID',
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `transaction_id` varchar(255) DEFAULT NULL COMMENT 'Transaction ID',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `base_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Refunded',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `customer_note` text COMMENT 'Customer Note',
  `customer_note_notify` smallint unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_INVOICE_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_INVOICE_STORE_ID` (`store_id`),
  KEY `SALES_INVOICE_GRAND_TOTAL` (`grand_total`),
  KEY `SALES_INVOICE_ORDER_ID` (`order_id`),
  KEY `SALES_INVOICE_STATE` (`state`),
  KEY `SALES_INVOICE_CREATED_AT` (`created_at`),
  KEY `SALES_INVOICE_UPDATED_AT` (`updated_at`),
  KEY `SALES_INVOICE_SEND_EMAIL` (`send_email`),
  KEY `SALES_INVOICE_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_INVOICE_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_INVOICE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Invoice';

--
-- Dumping data for table `sales_invoice`
--

INSERT INTO `sales_invoice` VALUES (1,1,303.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,303.0000,5.0000,298.0000,298.0000,0.0000,5.0000,1.0000,1.0000,298.0000,298.0000,0.0000,6,NULL,3,NULL,NULL,0,2,5,'USD',NULL,'USD','USD','USD','000000001','2024-05-31 17:15:17','2024-05-31 17:15:17',0.0000,0.0000,0.0000,0.0000,5.0000,5.0000,NULL,NULL,NULL,NULL);

--
-- Table structure for table `sales_invoice_comment`
--

CREATE TABLE `sales_invoice_comment` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` smallint unsigned DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_INVOICE_COMMENT_CREATED_AT` (`created_at`),
  KEY `SALES_INVOICE_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_INVOICE_COMMENT_PARENT_ID_SALES_INVOICE_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_invoice` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Invoice Comment';

--
-- Dumping data for table `sales_invoice_comment`
--


--
-- Table structure for table `sales_invoice_grid`
--

CREATE TABLE `sales_invoice_grid` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `state` int DEFAULT NULL COMMENT 'State',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_created_at` timestamp NULL DEFAULT NULL COMMENT 'Order Created At',
  `customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer Name',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` int DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL COMMENT 'Payment Method',
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_INVOICE_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_INVOICE_GRID_STORE_ID` (`store_id`),
  KEY `SALES_INVOICE_GRID_GRAND_TOTAL` (`grand_total`),
  KEY `SALES_INVOICE_GRID_ORDER_ID` (`order_id`),
  KEY `SALES_INVOICE_GRID_STATE` (`state`),
  KEY `SALES_INVOICE_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `SALES_INVOICE_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_INVOICE_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_INVOICE_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `SALES_INVOICE_GRID_BILLING_NAME` (`billing_name`),
  KEY `SALES_INVOICE_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  FULLTEXT KEY `FTI_95D9C924DD6A8734EB8B5D01D60F90DE` (`increment_id`,`order_increment_id`,`billing_name`,`billing_address`,`shipping_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Invoice Grid';

--
-- Dumping data for table `sales_invoice_grid`
--

INSERT INTO `sales_invoice_grid` VALUES (1,'000000001',2,1,'Main Website\nMain Website Store\nDefault Store View',3,'000000003','2024-05-31 17:14:14','Arpit Ahuja','arpitahuja1704@gmail.com',0,'checkmo','USD','USD','USD','USD','Arpit Ahuja','48 lawrence avenue,surrey','48 lawrence avenue,surrey','Flat Rate - Fixed',298.0000,5.0000,303.0000,'2024-05-31 17:15:17','2024-05-31 17:15:17',303.0000);

--
-- Table structure for table `sales_invoice_item`
--

CREATE TABLE `sales_invoice_item` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
  `tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Tax Amount',
  `base_row_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total',
  `discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Amount',
  `row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
  `base_discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `base_price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `base_row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `product_id` int DEFAULT NULL COMMENT 'Product ID',
  `order_item_id` int DEFAULT NULL COMMENT 'Order Item ID',
  `additional_data` text COMMENT 'Additional Data',
  `description` text COMMENT 'Description',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `tax_ratio` text COMMENT 'Ratio of tax invoiced over tax of the order item',
  `weee_tax_applied` text COMMENT 'Weee Tax Applied',
  `weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Amount',
  `weee_tax_applied_row_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Row Amount',
  `weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Disposition',
  `weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Row Disposition',
  `base_weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Amount',
  `base_weee_tax_applied_row_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Row Amnt',
  `base_weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Disposition',
  `base_weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Row Disposition',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_INVOICE_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_INVOICE_ITEM_PARENT_ID_SALES_INVOICE_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_invoice` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Invoice Item';

--
-- Dumping data for table `sales_invoice_item`
--

INSERT INTO `sales_invoice_item` VALUES (1,1,298.0000,0.0000,298.0000,NULL,298.0000,NULL,298.0000,0.0000,298.0000,1.0000,NULL,298.0000,298.0000,298.0000,1,3,NULL,NULL,'Test','Test',0.0000,0.0000,NULL,'[]',NULL,0.0000,NULL,0.0000,NULL,NULL,NULL,0.0000);

--
-- Table structure for table `sales_invoiced_aggregated`
--

CREATE TABLE `sales_invoiced_aggregated` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `orders_count` int NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
  `invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
  `invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
  `invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_INVOICED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_INVOICED_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_INVOICED_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Invoiced Aggregated';

--
-- Dumping data for table `sales_invoiced_aggregated`
--


--
-- Table structure for table `sales_invoiced_aggregated_order`
--

CREATE TABLE `sales_invoiced_aggregated_order` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
  `invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
  `invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
  `invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_INVOICED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_INVOICED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_INVOICED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Invoiced Aggregated Order';

--
-- Dumping data for table `sales_invoiced_aggregated_order`
--


--
-- Table structure for table `sales_order`
--

CREATE TABLE `sales_order` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `state` varchar(32) DEFAULT NULL COMMENT 'State',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `coupon_code` varchar(255) DEFAULT NULL COMMENT 'Coupon Code',
  `protect_code` varchar(255) DEFAULT NULL COMMENT 'Protect Code',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `is_virtual` smallint unsigned DEFAULT NULL COMMENT 'Is Virtual',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  `base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `base_discount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Canceled',
  `base_discount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Invoiced',
  `base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `base_shipping_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Canceled',
  `base_shipping_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Invoiced',
  `base_shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Refunded',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `base_shipping_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Refunded',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `base_subtotal_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Canceled',
  `base_subtotal_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Invoiced',
  `base_subtotal_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Refunded',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `base_tax_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Canceled',
  `base_tax_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Invoiced',
  `base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
  `base_total_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Canceled',
  `base_total_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Invoiced',
  `base_total_invoiced_cost` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Invoiced Cost',
  `base_total_offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Offline Refunded',
  `base_total_online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Online Refunded',
  `base_total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Paid',
  `base_total_qty_ordered` decimal(12,4) DEFAULT NULL COMMENT 'Base Total Qty Ordered',
  `base_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Refunded',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `discount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Canceled',
  `discount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Invoiced',
  `discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `shipping_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Canceled',
  `shipping_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Invoiced',
  `shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Refunded',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `shipping_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Refunded',
  `store_to_base_rate` decimal(12,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `store_to_order_rate` decimal(12,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `subtotal_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Canceled',
  `subtotal_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Invoiced',
  `subtotal_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Refunded',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `tax_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Tax Canceled',
  `tax_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Tax Invoiced',
  `tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
  `total_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Total Canceled',
  `total_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Total Invoiced',
  `total_offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Offline Refunded',
  `total_online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Online Refunded',
  `total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Total Paid',
  `total_qty_ordered` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty Ordered',
  `total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Refunded',
  `can_ship_partially` smallint unsigned DEFAULT NULL COMMENT 'Can Ship Partially',
  `can_ship_partially_item` smallint unsigned DEFAULT NULL COMMENT 'Can Ship Partially Item',
  `customer_is_guest` smallint unsigned DEFAULT NULL COMMENT 'Customer Is Guest',
  `customer_note_notify` smallint unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  `billing_address_id` int DEFAULT NULL COMMENT 'Billing Address ID',
  `customer_group_id` int DEFAULT NULL,
  `edit_increment` int DEFAULT NULL COMMENT 'Edit Increment',
  `email_sent` smallint unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint unsigned DEFAULT NULL COMMENT 'Send Email',
  `forced_shipment_with_invoice` smallint unsigned DEFAULT NULL COMMENT 'Forced Do Shipment With Invoice',
  `payment_auth_expiration` int DEFAULT NULL COMMENT 'Payment Authorization Expiration',
  `quote_address_id` int DEFAULT NULL COMMENT 'Quote Address ID',
  `quote_id` int DEFAULT NULL COMMENT 'Quote ID',
  `shipping_address_id` int DEFAULT NULL COMMENT 'Shipping Address ID',
  `adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
  `adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
  `base_adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Negative',
  `base_adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Positive',
  `base_shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Amount',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `base_total_due` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Due',
  `payment_authorization_amount` decimal(20,4) DEFAULT NULL COMMENT 'Payment Authorization Amount',
  `shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `total_due` decimal(20,4) DEFAULT NULL COMMENT 'Total Due',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `customer_dob` datetime DEFAULT NULL COMMENT 'Customer Dob',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `applied_rule_ids` varchar(128) DEFAULT NULL COMMENT 'Applied Rule Ids',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_firstname` varchar(128) DEFAULT NULL COMMENT 'Customer Firstname',
  `customer_lastname` varchar(128) DEFAULT NULL COMMENT 'Customer Lastname',
  `customer_middlename` varchar(128) DEFAULT NULL COMMENT 'Customer Middlename',
  `customer_prefix` varchar(32) DEFAULT NULL COMMENT 'Customer Prefix',
  `customer_suffix` varchar(32) DEFAULT NULL COMMENT 'Customer Suffix',
  `customer_taxvat` varchar(32) DEFAULT NULL COMMENT 'Customer Taxvat',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `ext_customer_id` varchar(32) DEFAULT NULL COMMENT 'Ext Customer ID',
  `ext_order_id` varchar(32) DEFAULT NULL COMMENT 'Ext Order ID',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `hold_before_state` varchar(32) DEFAULT NULL COMMENT 'Hold Before State',
  `hold_before_status` varchar(32) DEFAULT NULL COMMENT 'Hold Before Status',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `original_increment_id` varchar(50) DEFAULT NULL COMMENT 'Original Increment ID',
  `relation_child_id` varchar(32) DEFAULT NULL COMMENT 'Relation Child ID',
  `relation_child_real_id` varchar(32) DEFAULT NULL COMMENT 'Relation Child Real ID',
  `relation_parent_id` varchar(32) DEFAULT NULL COMMENT 'Relation Parent ID',
  `relation_parent_real_id` varchar(32) DEFAULT NULL COMMENT 'Relation Parent Real ID',
  `remote_ip` varchar(45) DEFAULT NULL COMMENT 'Remote Ip',
  `shipping_method` varchar(120) DEFAULT NULL,
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `x_forwarded_for` varchar(255) DEFAULT NULL COMMENT 'X Forwarded For',
  `customer_note` text COMMENT 'Customer Note',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `total_item_count` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Total Item Count',
  `customer_gender` int DEFAULT NULL COMMENT 'Customer Gender',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Invoiced',
  `base_discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Invoiced',
  `discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Refunded',
  `base_discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Refunded',
  `shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `coupon_rule_name` varchar(255) DEFAULT NULL COMMENT 'Coupon Sales Rule Name',
  `gift_message_id` int DEFAULT NULL COMMENT 'Gift Message ID',
  `paypal_ipn_customer_notified` int DEFAULT '0' COMMENT 'Paypal Ipn Customer Notified',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_ORDER_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_ORDER_STATUS` (`status`),
  KEY `SALES_ORDER_STATE` (`state`),
  KEY `SALES_ORDER_STORE_ID` (`store_id`),
  KEY `SALES_ORDER_CREATED_AT` (`created_at`),
  KEY `SALES_ORDER_CUSTOMER_ID` (`customer_id`),
  KEY `SALES_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  KEY `SALES_ORDER_QUOTE_ID` (`quote_id`),
  KEY `SALES_ORDER_UPDATED_AT` (`updated_at`),
  KEY `SALES_ORDER_SEND_EMAIL` (`send_email`),
  KEY `SALES_ORDER_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `SALES_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Order';

--
-- Dumping data for table `sales_order`
--

INSERT INTO `sales_order` VALUES (1,'new','pending',NULL,'0ed8389866566ad1ef6b7a57d0f20c88','Flat Rate - Fixed',0,1,NULL,0.0000,NULL,NULL,NULL,303.0000,5.0000,NULL,NULL,NULL,0.0000,NULL,298.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,303.0000,5.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,298.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.0000,NULL,NULL,NULL,1,1,2,0,NULL,NULL,1,NULL,NULL,NULL,7,1,NULL,NULL,NULL,NULL,0.0000,298.0000,303.0000,NULL,0.0000,298.0000,303.0000,0.0000,NULL,'000000001',NULL,'USD','arpitahuja1704@gmail.com','arpit','ahuja',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'81.149.201.107','flatrate_flatrate','USD','Main Website\nMain Website Store\nDefault Store View',NULL,NULL,'2024-05-31 16:37:30','2024-05-31 16:37:31',1,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,5.0000,5.0000,NULL,NULL,0),(2,'new','pending',NULL,'260fd25c1f306669889b51ede70d3ccd','Flat Rate - Fixed',0,1,NULL,0.0000,NULL,NULL,NULL,353.0000,5.0000,NULL,NULL,NULL,0.0000,NULL,348.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,353.0000,5.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,348.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.0000,NULL,NULL,NULL,1,1,4,0,NULL,NULL,1,NULL,NULL,NULL,8,3,NULL,NULL,NULL,NULL,0.0000,348.0000,353.0000,NULL,0.0000,348.0000,353.0000,0.0000,NULL,'000000002',NULL,'USD','arpitahuja1704@gmail.com','Arpit','ahuja',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'81.149.201.107','flatrate_flatrate','USD','Main Website\nMain Website Store\nDefault Store View',NULL,NULL,'2024-05-31 16:51:08','2024-05-31 16:51:08',1,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,5.0000,5.0000,NULL,NULL,0),(3,'processing','processing',NULL,'703b99ed7df5a1b535adcb1509f21e57','Flat Rate - Fixed',0,1,NULL,0.0000,NULL,0.0000,NULL,303.0000,5.0000,NULL,5.0000,NULL,0.0000,NULL,298.0000,NULL,298.0000,NULL,0.0000,NULL,0.0000,NULL,1.0000,1.0000,NULL,303.0000,0.0000,NULL,NULL,303.0000,NULL,NULL,0.0000,NULL,0.0000,NULL,303.0000,5.0000,NULL,5.0000,NULL,0.0000,NULL,0.0000,0.0000,298.0000,NULL,298.0000,NULL,0.0000,NULL,0.0000,NULL,NULL,303.0000,NULL,NULL,303.0000,1.0000,NULL,NULL,NULL,1,0,6,0,NULL,NULL,1,NULL,NULL,NULL,9,5,NULL,NULL,NULL,NULL,0.0000,298.0000,0.0000,NULL,0.0000,298.0000,0.0000,0.0000,NULL,'000000003',NULL,'USD','arpitahuja1704@gmail.com','Arpit','Ahuja',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'81.149.201.107','flatrate_flatrate','USD','Main Website\nMain Website Store\nDefault Store View',NULL,NULL,'2024-05-31 17:14:14','2024-05-31 17:15:17',1,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,5.0000,5.0000,NULL,NULL,0);

--
-- Table structure for table `sales_order_address`
--

CREATE TABLE `sales_order_address` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned DEFAULT NULL COMMENT 'Parent ID',
  `customer_address_id` int DEFAULT NULL COMMENT 'Customer Address ID',
  `quote_address_id` int DEFAULT NULL COMMENT 'Quote Address ID',
  `region_id` int DEFAULT NULL COMMENT 'Region ID',
  `customer_id` int DEFAULT NULL COMMENT 'Customer ID',
  `fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
  `region` varchar(255) DEFAULT NULL COMMENT 'Region',
  `postcode` varchar(255) DEFAULT NULL COMMENT 'Postcode',
  `lastname` varchar(255) DEFAULT NULL COMMENT 'Lastname',
  `street` varchar(255) DEFAULT NULL COMMENT 'Street',
  `city` varchar(255) DEFAULT NULL COMMENT 'City',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `telephone` varchar(255) DEFAULT NULL COMMENT 'Phone Number',
  `country_id` varchar(2) DEFAULT NULL COMMENT 'Country ID',
  `firstname` varchar(255) DEFAULT NULL COMMENT 'Firstname',
  `address_type` varchar(255) DEFAULT NULL COMMENT 'Address Type',
  `prefix` varchar(255) DEFAULT NULL COMMENT 'Prefix',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middlename',
  `suffix` varchar(255) DEFAULT NULL COMMENT 'Suffix',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `vat_id` text COMMENT 'Vat ID',
  `vat_is_valid` smallint DEFAULT NULL COMMENT 'Vat Is Valid',
  `vat_request_id` text COMMENT 'Vat Request ID',
  `vat_request_date` text COMMENT 'Vat Request Date',
  `vat_request_success` smallint DEFAULT NULL COMMENT 'Vat Request Success',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_ORDER_ADDRESS_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_ORDER_ADDRESS_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Order Address';

--
-- Dumping data for table `sales_order_address`
--

INSERT INTO `sales_order_address` VALUES (1,1,NULL,16,NULL,NULL,NULL,'surrey',NULL,'ahuja','abc 123','surrey','arpitahuja1704@gmail.com','07935480688','GB','arpit','shipping',NULL,NULL,NULL,'arpitahuja',NULL,NULL,NULL,NULL,NULL),(2,1,NULL,17,NULL,NULL,NULL,'surrey',NULL,'ahuja','abc 123','surrey','arpitahuja1704@gmail.com','07935480688','GB','arpit','billing',NULL,NULL,NULL,'arpitahuja',NULL,NULL,NULL,NULL,NULL),(3,2,NULL,19,NULL,NULL,NULL,NULL,NULL,'ahuja','def456','London','arpitahuja1704@gmail.com','07935480688','GB','Arpit','shipping',NULL,NULL,NULL,'arpitahuja',NULL,NULL,NULL,NULL,NULL),(4,2,NULL,20,NULL,NULL,NULL,NULL,NULL,'ahuja','def456','London','arpitahuja1704@gmail.com','07935480688','GB','Arpit','billing',NULL,NULL,NULL,'arpitahuja',NULL,NULL,NULL,NULL,NULL),(5,3,NULL,22,NULL,NULL,NULL,NULL,NULL,'Ahuja','48 lawrence avenue','surrey','arpitahuja1704@gmail.com','07935480688','GB','Arpit','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,3,NULL,23,NULL,NULL,NULL,NULL,NULL,'Ahuja','48 lawrence avenue','surrey','arpitahuja1704@gmail.com','07935480688','GB','Arpit','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `sales_order_aggregated_created`
--

CREATE TABLE `sales_order_aggregated_created` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Ordered',
  `total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Invoiced',
  `total_income_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Income Amount',
  `total_revenue_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Revenue Amount',
  `total_profit_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Profit Amount',
  `total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Invoiced Amount',
  `total_canceled_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Canceled Amount',
  `total_paid_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Paid Amount',
  `total_refunded_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Refunded Amount',
  `total_tax_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount',
  `total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount Actual',
  `total_shipping_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount',
  `total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount Actual',
  `total_discount_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount',
  `total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_ORDER_AGGREGATED_CREATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_ORDER_AGGREGATED_CREATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_AGGREGATED_CREATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Order Aggregated Created';

--
-- Dumping data for table `sales_order_aggregated_created`
--


--
-- Table structure for table `sales_order_aggregated_updated`
--

CREATE TABLE `sales_order_aggregated_updated` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Ordered',
  `total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Invoiced',
  `total_income_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Income Amount',
  `total_revenue_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Revenue Amount',
  `total_profit_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Profit Amount',
  `total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Invoiced Amount',
  `total_canceled_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Canceled Amount',
  `total_paid_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Paid Amount',
  `total_refunded_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Refunded Amount',
  `total_tax_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount',
  `total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount Actual',
  `total_shipping_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount',
  `total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount Actual',
  `total_discount_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount',
  `total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Order Aggregated Updated';

--
-- Dumping data for table `sales_order_aggregated_updated`
--


--
-- Table structure for table `sales_order_grid`
--

CREATE TABLE `sales_order_grid` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity ID',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Paid',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Total Paid',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `order_currency_code` varchar(255) DEFAULT NULL COMMENT 'Order Currency Code',
  `shipping_name` varchar(255) DEFAULT NULL COMMENT 'Shipping Name',
  `billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group` varchar(255) DEFAULT NULL COMMENT 'Customer Group',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
  `customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer Name',
  `payment_method` varchar(255) DEFAULT NULL COMMENT 'Payment Method',
  `total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Refunded',
  `pickup_location_code` varchar(255) DEFAULT NULL COMMENT 'Pickup Location Code',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_ORDER_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_ORDER_GRID_STATUS` (`status`),
  KEY `SALES_ORDER_GRID_STORE_ID` (`store_id`),
  KEY `SALES_ORDER_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  KEY `SALES_ORDER_GRID_BASE_TOTAL_PAID` (`base_total_paid`),
  KEY `SALES_ORDER_GRID_GRAND_TOTAL` (`grand_total`),
  KEY `SALES_ORDER_GRID_TOTAL_PAID` (`total_paid`),
  KEY `SALES_ORDER_GRID_SHIPPING_NAME` (`shipping_name`),
  KEY `SALES_ORDER_GRID_BILLING_NAME` (`billing_name`),
  KEY `SALES_ORDER_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_ORDER_GRID_CUSTOMER_ID` (`customer_id`),
  KEY `SALES_ORDER_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_ORDER_GRID_PICKUP_LOCATION_CODE` (`pickup_location_code`),
  FULLTEXT KEY `FTI_65B9E9925EC58F0C7C2E2F6379C233E7` (`increment_id`,`billing_name`,`shipping_name`,`shipping_address`,`billing_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Order Grid';

--
-- Dumping data for table `sales_order_grid`
--

INSERT INTO `sales_order_grid` VALUES (1,'pending',1,'Main Website\nMain Website Store\nDefault Store View',NULL,303.0000,NULL,303.0000,NULL,'000000001','USD','USD','arpit ahuja','arpit ahuja','2024-05-31 16:37:30','2024-05-31 16:37:30','arpitahuja,abc 123,surrey,surrey','arpitahuja,abc 123,surrey,surrey','Flat Rate - Fixed','arpitahuja1704@gmail.com','0',298.0000,5.0000,'arpit ahuja','checkmo',NULL,NULL),(2,'pending',1,'Main Website\nMain Website Store\nDefault Store View',NULL,353.0000,NULL,353.0000,NULL,'000000002','USD','USD','Arpit ahuja','Arpit ahuja','2024-05-31 16:51:08','2024-05-31 16:51:08','arpitahuja,def456,London','arpitahuja,def456,London','Flat Rate - Fixed','arpitahuja1704@gmail.com','0',348.0000,5.0000,'Arpit ahuja','checkmo',NULL,NULL),(3,'processing',1,'Main Website\nMain Website Store\nDefault Store View',NULL,303.0000,303.0000,303.0000,303.0000,'000000003','USD','USD','Arpit Ahuja','Arpit Ahuja','2024-05-31 17:14:14','2024-05-31 17:15:17','48 lawrence avenue,surrey','48 lawrence avenue,surrey','Flat Rate - Fixed','arpitahuja1704@gmail.com','0',298.0000,5.0000,'Arpit Ahuja','checkmo',NULL,NULL);

--
-- Table structure for table `sales_order_item`
--

CREATE TABLE `sales_order_item` (
  `item_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
  `order_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Order ID',
  `parent_item_id` int unsigned DEFAULT NULL COMMENT 'Parent Item ID',
  `quote_item_id` int unsigned DEFAULT NULL COMMENT 'Quote Item ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `product_id` int unsigned DEFAULT NULL COMMENT 'Product ID',
  `product_type` varchar(255) DEFAULT NULL COMMENT 'Product Type',
  `product_options` longtext COMMENT 'Product Options',
  `weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Weight',
  `is_virtual` smallint unsigned DEFAULT NULL COMMENT 'Is Virtual',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `applied_rule_ids` text COMMENT 'Applied Rule Ids',
  `additional_data` text COMMENT 'Additional Data',
  `is_qty_decimal` smallint unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
  `no_discount` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'No Discount',
  `qty_backordered` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Backordered',
  `qty_canceled` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Canceled',
  `qty_invoiced` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Invoiced',
  `qty_ordered` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Ordered',
  `qty_refunded` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Refunded',
  `qty_shipped` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Shipped',
  `base_cost` decimal(12,4) DEFAULT '0.0000' COMMENT 'Base Cost',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `base_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Price',
  `original_price` decimal(12,4) DEFAULT NULL COMMENT 'Original Price',
  `base_original_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Original Price',
  `tax_percent` decimal(12,4) DEFAULT '0.0000' COMMENT 'Tax Percent',
  `tax_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Tax Amount',
  `base_tax_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Tax Amount',
  `tax_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Tax Invoiced',
  `base_tax_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Tax Invoiced',
  `discount_percent` decimal(12,4) DEFAULT '0.0000' COMMENT 'Discount Percent',
  `discount_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Discount Amount',
  `base_discount_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Discount Amount',
  `discount_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Discount Invoiced',
  `base_discount_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Discount Invoiced',
  `amount_refunded` decimal(20,4) DEFAULT '0.0000' COMMENT 'Amount Refunded',
  `base_amount_refunded` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Amount Refunded',
  `row_total` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Row Total',
  `base_row_total` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Row Total',
  `row_invoiced` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Row Invoiced',
  `base_row_invoiced` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Row Invoiced',
  `row_weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Weight',
  `base_tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Before Discount',
  `tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Before Discount',
  `ext_order_item_id` varchar(255) DEFAULT NULL COMMENT 'Ext Order Item ID',
  `locked_do_invoice` smallint unsigned DEFAULT NULL COMMENT 'Locked Do Invoice',
  `locked_do_ship` smallint unsigned DEFAULT NULL COMMENT 'Locked Do Ship',
  `price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `base_row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Invoiced',
  `base_discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Invoiced',
  `discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Refunded',
  `base_discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Refunded',
  `tax_canceled` decimal(12,4) DEFAULT NULL COMMENT 'Tax Canceled',
  `discount_tax_compensation_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Canceled',
  `tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
  `base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
  `discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
  `base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
  `gift_message_id` int DEFAULT NULL COMMENT 'Gift Message ID',
  `gift_message_available` int DEFAULT NULL COMMENT 'Gift Message Available',
  `free_shipping` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
  `weee_tax_applied` text 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',
  `json` text COMMENT 'JSON DATA',
  PRIMARY KEY (`item_id`),
  KEY `SALES_ORDER_ITEM_ORDER_ID` (`order_id`),
  KEY `SALES_ORDER_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_ITEM_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_ORDER_ITEM_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Order Item';

--
-- Dumping data for table `sales_order_item`
--

INSERT INTO `sales_order_item` VALUES (1,1,NULL,10,1,'2024-05-31 16:37:30','2024-05-31 16:37:30',1,'simple','{\"info_buyRequest\":{\"product\":\"1\",\"price\":\"298.00\",\"qty\":1}}',NULL,0,'Test','Test',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,298.0000,298.0000,100.0000,100.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,298.0000,298.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,298.0000,298.0000,298.0000,298.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"custom_product_image\":\"\\/shirt-tool\\/customize-image\\/img_1717173369.png\",\"style\":{\"fit\":\"Slim Fit\",\"style\":\"Single Breasted\",\"lapel\":\"Notch\",\"pockets\":\"Flap Pockets\",\"sleevebuttons\":\"4 Button\",\"vents\":\"Center Vent\",\"buttons\":\"2 Button\",\"veststyle\":\"Single Breasted 5 Buttons\",\"vestlapel\":\"No Lapel\",\"vestpockets\":\"No pocket\",\"breastpocket\":\"Without Breast Pocket\",\"vestedge\":\"Diagonal\",\"pantfit\":\"Traditional Fit\",\"pantpleats\":\"No Pleat\",\"fastening\":\"Centered\",\"pantpockets\":\"Diagonal Pocket\",\"pantcuff\":\"No Cuffs\",\"pantstripe\":\"Full Strips\",\"brass buttons\":\"Default\",\"threads\":\"Blue\",\"lining\":\"White\",\"pocket square\":\"No\",\"vestlapel_v\":\"Black\",\"plastic buttons\":\"Black\",\"bow\":\"Blue\"}}'),(2,2,NULL,11,1,'2024-05-31 16:51:08','2024-05-31 16:51:08',1,'simple','{\"info_buyRequest\":{\"product\":\"1\",\"price\":\"348.00\",\"qty\":1}}',NULL,0,'Test','Test',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,348.0000,348.0000,100.0000,100.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,348.0000,348.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,348.0000,348.0000,348.0000,348.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"custom_product_image\":\"\\/shirt-tool\\/customize-image\\/img_1717173910.png\",\"style\":{\"fit\":\"Classic Fit\",\"style\":\"Single Breasted\",\"lapel\":\"Notch\",\"pockets\":\"Flap Pockets\",\"sleevebuttons\":\"4 Button\",\"vents\":\"Center Vent\",\"buttons\":\"2 Button\",\"veststyle\":\"Single Breasted 5 Buttons\",\"vestlapel\":\"No Lapel\",\"vestpockets\":\"No pocket\",\"breastpocket\":\"Without Breast Pocket\",\"vestedge\":\"Diagonal\",\"pantfit\":\"Traditional Fit\",\"pantpleats\":\"No Pleat\",\"fastening\":\"Centered\",\"pantpockets\":\"Diagonal Pocket\",\"pantcuff\":\"No Cuffs\",\"pantstripe\":\"Full Strips\",\"brass buttons\":\"Default\",\"threads\":\"Blue\",\"lining\":\"White\",\"pocket square\":\"No\",\"vestlapel_v\":\"Black\",\"plastic buttons\":\"Black\",\"bow\":\"Blue\"}}'),(3,3,NULL,12,1,'2024-05-31 17:14:14','2024-05-31 17:15:17',1,'simple','{\"info_buyRequest\":{\"product\":\"1\",\"price\":\"298.00\",\"qty\":1}}',NULL,0,'Test','Test',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,0.0000,NULL,298.0000,298.0000,100.0000,100.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,298.0000,298.0000,298.0000,298.0000,0.0000,NULL,NULL,NULL,NULL,NULL,298.0000,298.0000,298.0000,298.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"custom_product_image\":\"\\/shirt-tool\\/customize-image\\/img_1717175611.png\",\"style\":{\"fit\":\"Slim Fit\",\"style\":\"Single Breasted\",\"lapel\":\"Notch\",\"pockets\":\"Flap Pockets\",\"sleevebuttons\":\"4 Button\",\"vents\":\"Center Vent\",\"buttons\":\"2 Button\",\"veststyle\":\"Single Breasted 5 Buttons\",\"vestlapel\":\"No Lapel\",\"vestpockets\":\"No pocket\",\"breastpocket\":\"Without Breast Pocket\",\"vestedge\":\"Diagonal\",\"pantfit\":\"Traditional Fit\",\"pantpleats\":\"No Pleat\",\"fastening\":\"Centered\",\"pantpockets\":\"Diagonal Pocket\",\"pantcuff\":\"No Cuffs\",\"pantstripe\":\"Full Strips\",\"brass buttons\":\"Default\",\"threads\":\"Blue\",\"lining\":\"White\",\"pocket square\":\"No\",\"vestlapel_v\":\"Black\",\"plastic buttons\":\"Black\",\"bow\":\"Blue\",\"fabric\":\"test2\"}}');

--
-- Table structure for table `sales_order_payment`
--

CREATE TABLE `sales_order_payment` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `base_shipping_captured` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Captured',
  `shipping_captured` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Captured',
  `amount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Amount Refunded',
  `base_amount_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Paid',
  `amount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Amount Canceled',
  `base_amount_authorized` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Authorized',
  `base_amount_paid_online` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Paid Online',
  `base_amount_refunded_online` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Refunded Online',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `amount_paid` decimal(20,4) DEFAULT NULL COMMENT 'Amount Paid',
  `amount_authorized` decimal(20,4) DEFAULT NULL COMMENT 'Amount Authorized',
  `base_amount_ordered` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Ordered',
  `base_shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Refunded',
  `shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Refunded',
  `base_amount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Refunded',
  `amount_ordered` decimal(20,4) DEFAULT NULL COMMENT 'Amount Ordered',
  `base_amount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Canceled',
  `quote_payment_id` int DEFAULT NULL COMMENT 'Quote Payment ID',
  `additional_data` text COMMENT 'Additional Data',
  `cc_exp_month` varchar(12) DEFAULT NULL COMMENT 'Cc Exp Month',
  `cc_ss_start_year` varchar(12) DEFAULT NULL COMMENT 'Cc Ss Start Year',
  `echeck_bank_name` varchar(128) DEFAULT NULL COMMENT 'Echeck Bank Name',
  `method` varchar(128) DEFAULT NULL COMMENT 'Method',
  `cc_debug_request_body` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Request Body',
  `cc_secure_verify` varchar(32) DEFAULT NULL COMMENT 'Cc Secure Verify',
  `protection_eligibility` varchar(32) DEFAULT NULL COMMENT 'Protection Eligibility',
  `cc_approval` varchar(32) DEFAULT NULL COMMENT 'Cc Approval',
  `cc_last_4` varchar(100) DEFAULT NULL COMMENT 'Cc Last 4',
  `cc_status_description` varchar(32) DEFAULT NULL COMMENT 'Cc Status Description',
  `echeck_type` varchar(32) DEFAULT NULL COMMENT 'Echeck Type',
  `cc_debug_response_serialized` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Response Serialized',
  `cc_ss_start_month` varchar(128) DEFAULT NULL COMMENT 'Cc Ss Start Month',
  `echeck_account_type` varchar(255) DEFAULT NULL COMMENT 'Echeck Account Type',
  `last_trans_id` varchar(255) DEFAULT NULL COMMENT 'Last Trans ID',
  `cc_cid_status` varchar(32) DEFAULT NULL COMMENT 'Cc Cid Status',
  `cc_owner` varchar(128) DEFAULT NULL COMMENT 'Cc Owner',
  `cc_type` varchar(32) DEFAULT NULL COMMENT 'Cc Type',
  `po_number` varchar(32) DEFAULT NULL COMMENT 'Po Number',
  `cc_exp_year` varchar(4) DEFAULT NULL COMMENT 'Cc Exp Year',
  `cc_status` varchar(4) DEFAULT NULL COMMENT 'Cc Status',
  `echeck_routing_number` varchar(32) DEFAULT NULL COMMENT 'Echeck Routing Number',
  `account_status` varchar(32) DEFAULT NULL COMMENT 'Account Status',
  `anet_trans_method` varchar(32) DEFAULT NULL COMMENT 'Anet Trans Method',
  `cc_debug_response_body` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Response Body',
  `cc_ss_issue` varchar(32) DEFAULT NULL COMMENT 'Cc Ss Issue',
  `echeck_account_name` varchar(32) DEFAULT NULL COMMENT 'Echeck Account Name',
  `cc_avs_status` varchar(32) DEFAULT NULL COMMENT 'Cc Avs Status',
  `cc_number_enc` varchar(128) DEFAULT NULL,
  `cc_trans_id` varchar(32) DEFAULT NULL COMMENT 'Cc Trans ID',
  `address_status` varchar(32) DEFAULT NULL COMMENT 'Address Status',
  `additional_information` text COMMENT 'Additional Information',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_ORDER_PAYMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_ORDER_PAYMENT_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Order Payment';

--
-- Dumping data for table `sales_order_payment`
--

INSERT INTO `sales_order_payment` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5.0000,5.0000,NULL,NULL,303.0000,NULL,NULL,NULL,303.0000,NULL,NULL,NULL,NULL,'0',NULL,'checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Check \\/ Money order\"}'),(2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5.0000,5.0000,NULL,NULL,353.0000,NULL,NULL,NULL,353.0000,NULL,NULL,NULL,NULL,'0',NULL,'checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Check \\/ Money order\"}'),(3,3,5.0000,5.0000,NULL,303.0000,NULL,NULL,NULL,NULL,5.0000,5.0000,303.0000,NULL,303.0000,NULL,NULL,NULL,303.0000,NULL,NULL,NULL,NULL,'0',NULL,'checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Check \\/ Money order\"}');

--
-- Table structure for table `sales_order_status`
--

CREATE TABLE `sales_order_status` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `label` varchar(128) NOT NULL COMMENT 'Label',
  PRIMARY KEY (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Order Status Table';

--
-- Dumping data for table `sales_order_status`
--

INSERT INTO `sales_order_status` VALUES ('canceled','Canceled'),('closed','Closed'),('complete','Complete'),('fraud','Suspected Fraud'),('holded','On Hold'),('payment_review','Payment Review'),('paypal_canceled_reversal','PayPal Canceled Reversal'),('paypal_reversed','PayPal Reversed'),('pending','Pending'),('pending_payment','Pending Payment'),('pending_paypal','Pending PayPal'),('processing','Processing');

--
-- Table structure for table `sales_order_status_history`
--

CREATE TABLE `sales_order_status_history` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `entity_name` varchar(32) DEFAULT NULL COMMENT 'Shows what entity history is bind to.',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_ORDER_STATUS_HISTORY_PARENT_ID` (`parent_id`),
  KEY `SALES_ORDER_STATUS_HISTORY_CREATED_AT` (`created_at`),
  CONSTRAINT `SALES_ORDER_STATUS_HISTORY_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Order Status History';

--
-- Dumping data for table `sales_order_status_history`
--


--
-- Table structure for table `sales_order_status_label`
--

CREATE TABLE `sales_order_status_label` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  `label` varchar(128) NOT NULL COMMENT 'Label',
  PRIMARY KEY (`status`,`store_id`),
  KEY `SALES_ORDER_STATUS_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_STATUS_LABEL_STATUS_SALES_ORDER_STATUS_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE,
  CONSTRAINT `SALES_ORDER_STATUS_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Order Status Label Table';

--
-- Dumping data for table `sales_order_status_label`
--


--
-- Table structure for table `sales_order_status_state`
--

CREATE TABLE `sales_order_status_state` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `state` varchar(32) NOT NULL COMMENT 'Label',
  `is_default` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Default',
  `visible_on_front` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Visible on front',
  PRIMARY KEY (`status`,`state`),
  CONSTRAINT `SALES_ORDER_STATUS_STATE_STATUS_SALES_ORDER_STATUS_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Order Status Table';

--
-- Dumping data for table `sales_order_status_state`
--

INSERT INTO `sales_order_status_state` VALUES ('canceled','canceled',1,1),('closed','closed',1,1),('complete','complete',1,1),('fraud','payment_review',0,1),('fraud','processing',0,1),('holded','holded',1,1),('payment_review','payment_review',1,1),('pending','new',1,1),('pending_payment','pending_payment',1,0),('processing','processing',1,1);

--
-- Table structure for table `sales_order_tax`
--

CREATE TABLE `sales_order_tax` (
  `tax_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax ID',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `percent` decimal(12,4) DEFAULT NULL COMMENT 'Percent',
  `amount` decimal(20,4) DEFAULT NULL COMMENT 'Amount',
  `priority` int NOT NULL COMMENT 'Priority',
  `position` int NOT NULL COMMENT 'Position',
  `base_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount',
  `process` smallint NOT NULL COMMENT 'Process',
  `base_real_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Real Amount',
  PRIMARY KEY (`tax_id`),
  KEY `SALES_ORDER_TAX_ORDER_ID_PRIORITY_POSITION` (`order_id`,`priority`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Order Tax Table';

--
-- Dumping data for table `sales_order_tax`
--


--
-- Table structure for table `sales_order_tax_item`
--

CREATE TABLE `sales_order_tax_item` (
  `tax_item_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax Item ID',
  `tax_id` int unsigned NOT NULL COMMENT 'Tax ID',
  `item_id` int unsigned DEFAULT NULL COMMENT 'Item ID',
  `tax_percent` decimal(12,4) NOT NULL COMMENT 'Real Tax Percent For Item',
  `amount` decimal(20,4) NOT NULL COMMENT 'Tax amount for the item and tax rate',
  `base_amount` decimal(20,4) NOT NULL COMMENT 'Base tax amount for the item and tax rate',
  `real_amount` decimal(20,4) NOT NULL COMMENT 'Real tax amount for the item and tax rate',
  `real_base_amount` decimal(20,4) NOT NULL COMMENT 'Real base tax amount for the item and tax rate',
  `associated_item_id` int unsigned DEFAULT NULL COMMENT 'Id of the associated item',
  `taxable_item_type` varchar(32) NOT NULL COMMENT 'Type of the taxable item',
  PRIMARY KEY (`tax_item_id`),
  UNIQUE KEY `SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID` (`tax_id`,`item_id`),
  KEY `SALES_ORDER_TAX_ITEM_ASSOCIATED_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` (`associated_item_id`),
  KEY `SALES_ORDER_TAX_ITEM_ITEM_ID` (`item_id`),
  CONSTRAINT `SALES_ORDER_TAX_ITEM_ASSOCIATED_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` FOREIGN KEY (`associated_item_id`) REFERENCES `sales_order_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_ORDER_TAX_ITEM_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `sales_order_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_ORDER_TAX_ITEM_TAX_ID_SALES_ORDER_TAX_TAX_ID` FOREIGN KEY (`tax_id`) REFERENCES `sales_order_tax` (`tax_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Order Tax Item';

--
-- Dumping data for table `sales_order_tax_item`
--


--
-- Table structure for table `sales_payment_transaction`
--

CREATE TABLE `sales_payment_transaction` (
  `transaction_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Transaction ID',
  `parent_id` int unsigned DEFAULT NULL COMMENT 'Parent ID',
  `order_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Order ID',
  `payment_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Payment ID',
  `txn_id` varchar(100) DEFAULT NULL COMMENT 'Txn ID',
  `parent_txn_id` varchar(100) DEFAULT NULL COMMENT 'Parent Txn ID',
  `txn_type` varchar(15) DEFAULT NULL COMMENT 'Txn Type',
  `is_closed` smallint unsigned NOT NULL DEFAULT '1' COMMENT 'Is Closed',
  `additional_information` blob COMMENT 'Additional Information',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `SALES_PAYMENT_TRANSACTION_ORDER_ID_PAYMENT_ID_TXN_ID` (`order_id`,`payment_id`,`txn_id`),
  KEY `SALES_PAYMENT_TRANSACTION_PARENT_ID` (`parent_id`),
  KEY `SALES_PAYMENT_TRANSACTION_PAYMENT_ID` (`payment_id`),
  CONSTRAINT `FK_B99FF1A06402D725EBDB0F3A7ECD47A2` FOREIGN KEY (`parent_id`) REFERENCES `sales_payment_transaction` (`transaction_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_PAYMENT_TRANSACTION_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_PAYMENT_TRANSACTION_PAYMENT_ID_SALES_ORDER_PAYMENT_ENTT_ID` FOREIGN KEY (`payment_id`) REFERENCES `sales_order_payment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Payment Transaction';

--
-- Dumping data for table `sales_payment_transaction`
--


--
-- Table structure for table `sales_refunded_aggregated`
--

CREATE TABLE `sales_refunded_aggregated` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
  `online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
  `offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_REFUNDED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_REFUNDED_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_REFUNDED_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Refunded Aggregated';

--
-- Dumping data for table `sales_refunded_aggregated`
--


--
-- Table structure for table `sales_refunded_aggregated_order`
--

CREATE TABLE `sales_refunded_aggregated_order` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `orders_count` int NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
  `online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
  `offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_REFUNDED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Refunded Aggregated Order';

--
-- Dumping data for table `sales_refunded_aggregated_order`
--


--
-- Table structure for table `sales_sequence_meta`
--

CREATE TABLE `sales_sequence_meta` (
  `meta_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `entity_type` varchar(32) NOT NULL COMMENT 'Prefix',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  `sequence_table` varchar(64) NOT NULL COMMENT 'table for sequence',
  PRIMARY KEY (`meta_id`),
  UNIQUE KEY `SALES_SEQUENCE_META_ENTITY_TYPE_STORE_ID` (`entity_type`,`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COMMENT='sales_sequence_meta';

--
-- Dumping data for table `sales_sequence_meta`
--

INSERT INTO `sales_sequence_meta` VALUES (1,'order',0,'sequence_order_0'),(2,'invoice',0,'sequence_invoice_0'),(3,'creditmemo',0,'sequence_creditmemo_0'),(4,'shipment',0,'sequence_shipment_0'),(5,'order',1,'sequence_order_1'),(6,'invoice',1,'sequence_invoice_1'),(7,'creditmemo',1,'sequence_creditmemo_1'),(8,'shipment',1,'sequence_shipment_1');

--
-- Table structure for table `sales_sequence_profile`
--

CREATE TABLE `sales_sequence_profile` (
  `profile_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `meta_id` int unsigned NOT NULL COMMENT 'Meta_id',
  `prefix` varchar(32) DEFAULT NULL COMMENT 'Prefix',
  `suffix` varchar(32) DEFAULT NULL COMMENT 'Suffix',
  `start_value` int unsigned NOT NULL DEFAULT '1' COMMENT 'Start value for sequence',
  `step` int unsigned NOT NULL DEFAULT '1' COMMENT 'Step for sequence',
  `max_value` int unsigned NOT NULL COMMENT 'MaxValue for sequence',
  `warning_value` int unsigned NOT NULL COMMENT 'WarningValue for sequence',
  `is_active` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'isActive flag',
  PRIMARY KEY (`profile_id`),
  UNIQUE KEY `SALES_SEQUENCE_PROFILE_META_ID_PREFIX_SUFFIX` (`meta_id`,`prefix`,`suffix`),
  CONSTRAINT `SALES_SEQUENCE_PROFILE_META_ID_SALES_SEQUENCE_META_META_ID` FOREIGN KEY (`meta_id`) REFERENCES `sales_sequence_meta` (`meta_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COMMENT='sales_sequence_profile';

--
-- Dumping data for table `sales_sequence_profile`
--

INSERT INTO `sales_sequence_profile` VALUES (1,1,NULL,NULL,1,1,4294967295,4294966295,1),(2,2,NULL,NULL,1,1,4294967295,4294966295,1),(3,3,NULL,NULL,1,1,4294967295,4294966295,1),(4,4,NULL,NULL,1,1,4294967295,4294966295,1),(5,5,NULL,NULL,1,1,4294967295,4294966295,1),(6,6,NULL,NULL,1,1,4294967295,4294966295,1),(7,7,NULL,NULL,1,1,4294967295,4294966295,1),(8,8,NULL,NULL,1,1,4294967295,4294966295,1);

--
-- Table structure for table `sales_shipment`
--

CREATE TABLE `sales_shipment` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `total_weight` decimal(12,4) DEFAULT NULL COMMENT 'Total Weight',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `email_sent` smallint unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint unsigned DEFAULT NULL COMMENT 'Send Email',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `customer_id` int DEFAULT NULL COMMENT 'Customer ID',
  `shipping_address_id` int DEFAULT NULL COMMENT 'Shipping Address ID',
  `billing_address_id` int DEFAULT NULL COMMENT 'Billing Address ID',
  `shipment_status` int DEFAULT NULL COMMENT 'Shipment Status',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `packages` text COMMENT 'Packed Products in Packages',
  `shipping_label` mediumblob COMMENT 'Shipping Label Content',
  `customer_note` text COMMENT 'Customer Note',
  `customer_note_notify` smallint unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_SHIPMENT_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_SHIPMENT_STORE_ID` (`store_id`),
  KEY `SALES_SHIPMENT_TOTAL_QTY` (`total_qty`),
  KEY `SALES_SHIPMENT_ORDER_ID` (`order_id`),
  KEY `SALES_SHIPMENT_CREATED_AT` (`created_at`),
  KEY `SALES_SHIPMENT_UPDATED_AT` (`updated_at`),
  KEY `SALES_SHIPMENT_SEND_EMAIL` (`send_email`),
  KEY `SALES_SHIPMENT_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_SHIPMENT_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_SHIPMENT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Shipment';

--
-- Dumping data for table `sales_shipment`
--


--
-- Table structure for table `sales_shipment_comment`
--

CREATE TABLE `sales_shipment_comment` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_SHIPMENT_COMMENT_CREATED_AT` (`created_at`),
  KEY `SALES_SHIPMENT_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_SHIPMENT_COMMENT_PARENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Shipment Comment';

--
-- Dumping data for table `sales_shipment_comment`
--


--
-- Table structure for table `sales_shipment_grid`
--

CREATE TABLE `sales_shipment_grid` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_increment_id` varchar(32) NOT NULL COMMENT 'Order Increment ID',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `order_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Order Increment ID',
  `customer_name` varchar(128) NOT NULL COMMENT 'Customer Name',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `shipment_status` int DEFAULT NULL COMMENT 'Shipment Status',
  `order_status` varchar(32) DEFAULT NULL COMMENT 'Order',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `billing_name` varchar(128) DEFAULT NULL COMMENT 'Billing Name',
  `shipping_name` varchar(128) DEFAULT NULL COMMENT 'Shipping Name',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` int DEFAULT NULL,
  `payment_method` varchar(32) DEFAULT NULL COMMENT 'Payment Method',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_SHIPMENT_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_SHIPMENT_GRID_STORE_ID` (`store_id`),
  KEY `SALES_SHIPMENT_GRID_TOTAL_QTY` (`total_qty`),
  KEY `SALES_SHIPMENT_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `SALES_SHIPMENT_GRID_SHIPMENT_STATUS` (`shipment_status`),
  KEY `SALES_SHIPMENT_GRID_ORDER_STATUS` (`order_status`),
  KEY `SALES_SHIPMENT_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_SHIPMENT_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_SHIPMENT_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `SALES_SHIPMENT_GRID_SHIPPING_NAME` (`shipping_name`),
  KEY `SALES_SHIPMENT_GRID_BILLING_NAME` (`billing_name`),
  KEY `SALES_SHIPMENT_GRID_ORDER_ID` (`order_id`),
  FULLTEXT KEY `FTI_086B40C8955F167B8EA76653437879B4` (`increment_id`,`order_increment_id`,`shipping_name`,`customer_name`,`customer_email`,`billing_address`,`shipping_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Shipment Grid';

--
-- Dumping data for table `sales_shipment_grid`
--


--
-- Table structure for table `sales_shipment_item`
--

CREATE TABLE `sales_shipment_item` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
  `price` decimal(20,4) DEFAULT NULL COMMENT 'Price',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `product_id` int DEFAULT NULL COMMENT 'Product ID',
  `order_item_id` int DEFAULT NULL COMMENT 'Order Item ID',
  `additional_data` text COMMENT 'Additional Data',
  `description` text COMMENT 'Description',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_SHIPMENT_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_SHIPMENT_ITEM_PARENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Shipment Item';

--
-- Dumping data for table `sales_shipment_item`
--


--
-- Table structure for table `sales_shipment_track`
--

CREATE TABLE `sales_shipment_track` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int unsigned NOT NULL COMMENT 'Parent ID',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `track_number` text COMMENT 'Number',
  `description` text COMMENT 'Description',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `carrier_code` varchar(32) DEFAULT NULL COMMENT 'Carrier Code',
  `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 (`entity_id`),
  KEY `SALES_SHIPMENT_TRACK_PARENT_ID` (`parent_id`),
  KEY `SALES_SHIPMENT_TRACK_ORDER_ID` (`order_id`),
  KEY `SALES_SHIPMENT_TRACK_CREATED_AT` (`created_at`),
  CONSTRAINT `SALES_SHIPMENT_TRACK_PARENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Flat Shipment Track';

--
-- Dumping data for table `sales_shipment_track`
--


--
-- Table structure for table `sales_shipping_aggregated`
--

CREATE TABLE `sales_shipping_aggregated` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `orders_count` int NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
  `total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_SHPP_AGGRED_PERIOD_STORE_ID_ORDER_STS_SHPP_DESCRIPTION` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `SALES_SHIPPING_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_SHIPPING_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Shipping Aggregated';

--
-- Dumping data for table `sales_shipping_aggregated`
--


--
-- Table structure for table `sales_shipping_aggregated_order`
--

CREATE TABLE `sales_shipping_aggregated_order` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `orders_count` int NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
  `total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_C05FAE47282EEA68654D0924E946761F` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Shipping Aggregated Order';

--
-- Dumping data for table `sales_shipping_aggregated_order`
--


--
-- Table structure for table `salesrule`
--

CREATE TABLE `salesrule` (
  `rule_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `from_date` date DEFAULT NULL COMMENT 'From',
  `to_date` date DEFAULT NULL COMMENT 'To',
  `uses_per_customer` int NOT NULL DEFAULT '0' COMMENT 'Uses Per Customer',
  `is_active` smallint NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `conditions_serialized` mediumtext COMMENT 'Conditions Serialized',
  `actions_serialized` mediumtext COMMENT 'Actions Serialized',
  `stop_rules_processing` smallint NOT NULL DEFAULT '1' COMMENT 'Stop Rules Processing',
  `is_advanced` smallint unsigned NOT NULL DEFAULT '1' COMMENT 'Is Advanced',
  `product_ids` text COMMENT 'Product Ids',
  `sort_order` int unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `simple_action` varchar(32) DEFAULT NULL COMMENT 'Simple Action',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `discount_qty` decimal(12,4) DEFAULT NULL COMMENT 'Discount Qty',
  `discount_step` int unsigned NOT NULL DEFAULT '0' COMMENT 'Discount Step',
  `apply_to_shipping` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Apply To Shipping',
  `times_used` int unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  `is_rss` smallint NOT NULL DEFAULT '0' COMMENT 'Is Rss',
  `coupon_type` smallint unsigned NOT NULL DEFAULT '1' COMMENT 'Coupon Type',
  `use_auto_generation` smallint NOT NULL DEFAULT '0' COMMENT 'Use Auto Generation',
  `uses_per_coupon` int NOT NULL DEFAULT '0' COMMENT 'User Per Coupon',
  `simple_free_shipping` smallint unsigned DEFAULT NULL COMMENT 'Simple Free Shipping',
  PRIMARY KEY (`rule_id`),
  KEY `SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Salesrule';

--
-- Dumping data for table `salesrule`
--


--
-- Table structure for table `salesrule_coupon`
--

CREATE TABLE `salesrule_coupon` (
  `coupon_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Coupon ID',
  `rule_id` int unsigned NOT NULL COMMENT 'Rule ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `usage_limit` int unsigned DEFAULT NULL COMMENT 'Usage Limit',
  `usage_per_customer` int unsigned DEFAULT NULL COMMENT 'Usage Per Customer',
  `times_used` int unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  `expiration_date` datetime DEFAULT NULL COMMENT 'Expiration Date',
  `is_primary` smallint unsigned DEFAULT NULL COMMENT 'Is Primary',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Coupon Code Creation Date',
  `type` smallint DEFAULT '0' COMMENT 'Coupon Code Type',
  PRIMARY KEY (`coupon_id`),
  UNIQUE KEY `SALESRULE_COUPON_CODE` (`code`),
  UNIQUE KEY `SALESRULE_COUPON_RULE_ID_IS_PRIMARY` (`rule_id`,`is_primary`),
  KEY `SALESRULE_COUPON_RULE_ID` (`rule_id`),
  CONSTRAINT `SALESRULE_COUPON_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Salesrule Coupon';

--
-- Dumping data for table `salesrule_coupon`
--


--
-- Table structure for table `salesrule_coupon_aggregated`
--

CREATE TABLE `salesrule_coupon_aggregated` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int NOT NULL DEFAULT '0' COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount',
  `subtotal_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount Actual',
  `discount_amount_actual` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount Actual',
  `total_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount Actual',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALESRULE_COUPON_AGGRED_PERIOD_STORE_ID_ORDER_STS_COUPON_CODE` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `SALESRULE_COUPON_AGGREGATED_STORE_ID` (`store_id`),
  KEY `SALESRULE_COUPON_AGGREGATED_RULE_NAME` (`rule_name`),
  CONSTRAINT `SALESRULE_COUPON_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Coupon Aggregated';

--
-- Dumping data for table `salesrule_coupon_aggregated`
--


--
-- Table structure for table `salesrule_coupon_aggregated_order`
--

CREATE TABLE `salesrule_coupon_aggregated_order` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int NOT NULL DEFAULT '0' COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_1094D1FBBCBB11704A29DEF3ACC37D2B` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `SALESRULE_COUPON_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  KEY `SALESRULE_COUPON_AGGREGATED_ORDER_RULE_NAME` (`rule_name`),
  CONSTRAINT `SALESRULE_COUPON_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Coupon Aggregated Order';

--
-- Dumping data for table `salesrule_coupon_aggregated_order`
--


--
-- Table structure for table `salesrule_coupon_aggregated_updated`
--

CREATE TABLE `salesrule_coupon_aggregated_updated` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int NOT NULL DEFAULT '0' COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount',
  `subtotal_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount Actual',
  `discount_amount_actual` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount Actual',
  `total_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount Actual',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_7196FA120A4F0F84E1B66605E87E213E` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `SALESRULE_COUPON_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  KEY `SALESRULE_COUPON_AGGREGATED_UPDATED_RULE_NAME` (`rule_name`),
  CONSTRAINT `SALESRULE_COUPON_AGGREGATED_UPDATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Salesrule Coupon Aggregated Updated';

--
-- Dumping data for table `salesrule_coupon_aggregated_updated`
--


--
-- Table structure for table `salesrule_coupon_usage`
--

CREATE TABLE `salesrule_coupon_usage` (
  `coupon_id` int unsigned NOT NULL COMMENT 'Coupon ID',
  `customer_id` int unsigned NOT NULL COMMENT 'Customer ID',
  `times_used` int unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  PRIMARY KEY (`coupon_id`,`customer_id`),
  KEY `SALESRULE_COUPON_USAGE_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `SALESRULE_COUPON_USAGE_COUPON_ID_SALESRULE_COUPON_COUPON_ID` FOREIGN KEY (`coupon_id`) REFERENCES `salesrule_coupon` (`coupon_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_COUPON_USAGE_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Salesrule Coupon Usage';

--
-- Dumping data for table `salesrule_coupon_usage`
--


--
-- Table structure for table `salesrule_customer`
--

CREATE TABLE `salesrule_customer` (
  `rule_customer_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Customer ID',
  `rule_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Rule ID',
  `customer_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `times_used` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  PRIMARY KEY (`rule_customer_id`),
  KEY `SALESRULE_CUSTOMER_RULE_ID_CUSTOMER_ID` (`rule_id`,`customer_id`),
  KEY `SALESRULE_CUSTOMER_CUSTOMER_ID_RULE_ID` (`customer_id`,`rule_id`),
  CONSTRAINT `SALESRULE_CUSTOMER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_CUSTOMER_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Salesrule Customer';

--
-- Dumping data for table `salesrule_customer`
--


--
-- Table structure for table `salesrule_customer_group`
--

CREATE TABLE `salesrule_customer_group` (
  `rule_id` int unsigned NOT NULL COMMENT 'Rule ID',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  PRIMARY KEY (`rule_id`,`customer_group_id`),
  KEY `SALESRULE_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `SALESRULE_CSTR_GROUP_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_CUSTOMER_GROUP_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Rules To Customer Groups Relations';

--
-- Dumping data for table `salesrule_customer_group`
--


--
-- Table structure for table `salesrule_label`
--

CREATE TABLE `salesrule_label` (
  `label_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label ID',
  `rule_id` int unsigned NOT NULL COMMENT 'Rule ID',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  PRIMARY KEY (`label_id`),
  UNIQUE KEY `SALESRULE_LABEL_RULE_ID_STORE_ID` (`rule_id`,`store_id`),
  KEY `SALESRULE_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `SALESRULE_LABEL_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Salesrule Label';

--
-- Dumping data for table `salesrule_label`
--


--
-- Table structure for table `salesrule_product_attribute`
--

CREATE TABLE `salesrule_product_attribute` (
  `rule_id` int unsigned NOT NULL COMMENT 'Rule ID',
  `website_id` smallint unsigned NOT NULL COMMENT 'Website ID',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  `attribute_id` smallint unsigned NOT NULL COMMENT 'Attribute ID',
  PRIMARY KEY (`rule_id`,`website_id`,`customer_group_id`,`attribute_id`),
  KEY `SALESRULE_PRODUCT_ATTRIBUTE_WEBSITE_ID` (`website_id`),
  KEY `SALESRULE_PRODUCT_ATTRIBUTE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `SALESRULE_PRODUCT_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `SALESRULE_PRD_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_PRD_ATTR_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_PRODUCT_ATTRIBUTE_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_PRODUCT_ATTRIBUTE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Salesrule Product Attribute';

--
-- Dumping data for table `salesrule_product_attribute`
--


--
-- Table structure for table `salesrule_website`
--

CREATE TABLE `salesrule_website` (
  `rule_id` int unsigned NOT NULL COMMENT 'Rule ID',
  `website_id` smallint unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`rule_id`,`website_id`),
  KEY `SALESRULE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `SALESRULE_WEBSITE_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Sales Rules To Websites Relations';

--
-- Dumping data for table `salesrule_website`
--


--
-- Table structure for table `search_query`
--

CREATE TABLE `search_query` (
  `query_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Query ID',
  `query_text` varchar(255) DEFAULT NULL COMMENT 'Query text',
  `num_results` int unsigned NOT NULL DEFAULT '0' COMMENT 'Num results',
  `popularity` int unsigned NOT NULL DEFAULT '0' COMMENT 'Popularity',
  `redirect` varchar(255) DEFAULT NULL COMMENT 'Redirect',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `display_in_terms` smallint NOT NULL DEFAULT '1' COMMENT 'Display in terms',
  `is_active` smallint DEFAULT '1' COMMENT 'Active status',
  `is_processed` smallint DEFAULT '0' COMMENT 'Processed status',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated at',
  PRIMARY KEY (`query_id`),
  UNIQUE KEY `SEARCH_QUERY_QUERY_TEXT_STORE_ID` (`query_text`,`store_id`),
  KEY `SEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`,`store_id`,`popularity`),
  KEY `SEARCH_QUERY_STORE_ID` (`store_id`),
  KEY `SEARCH_QUERY_IS_PROCESSED` (`is_processed`),
  KEY `SEARCH_QUERY_STORE_ID_POPULARITY` (`store_id`,`popularity`),
  CONSTRAINT `SEARCH_QUERY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Search query table';

--
-- Dumping data for table `search_query`
--


--
-- Table structure for table `search_synonyms`
--

CREATE TABLE `search_synonyms` (
  `group_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Synonyms Group ID',
  `synonyms` text NOT NULL COMMENT 'list of synonyms making up this group',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID - identifies the store view these synonyms belong to',
  `website_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID - identifies the website ID these synonyms belong to',
  PRIMARY KEY (`group_id`),
  KEY `SEARCH_SYNONYMS_STORE_ID` (`store_id`),
  KEY `SEARCH_SYNONYMS_WEBSITE_ID` (`website_id`),
  FULLTEXT KEY `SEARCH_SYNONYMS_SYNONYMS` (`synonyms`),
  CONSTRAINT `SEARCH_SYNONYMS_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `SEARCH_SYNONYMS_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='table storing various synonyms groups';

--
-- Dumping data for table `search_synonyms`
--


--
-- Table structure for table `sendfriend_log`
--

CREATE TABLE `sendfriend_log` (
  `log_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `ip` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Customer IP address',
  `time` int unsigned NOT NULL DEFAULT '0' COMMENT 'Log time',
  `website_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  PRIMARY KEY (`log_id`),
  KEY `SENDFRIEND_LOG_IP` (`ip`),
  KEY `SENDFRIEND_LOG_TIME` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Send to friend function log storage table';

--
-- Dumping data for table `sendfriend_log`
--


--
-- Table structure for table `sequence_creditmemo_0`
--

CREATE TABLE `sequence_creditmemo_0` (
  `sequence_value` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sequence_creditmemo_0`
--


--
-- Table structure for table `sequence_creditmemo_1`
--

CREATE TABLE `sequence_creditmemo_1` (
  `sequence_value` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sequence_creditmemo_1`
--


--
-- Table structure for table `sequence_invoice_0`
--

CREATE TABLE `sequence_invoice_0` (
  `sequence_value` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sequence_invoice_0`
--


--
-- Table structure for table `sequence_invoice_1`
--

CREATE TABLE `sequence_invoice_1` (
  `sequence_value` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sequence_invoice_1`
--

INSERT INTO `sequence_invoice_1` VALUES (1);

--
-- Table structure for table `sequence_order_0`
--

CREATE TABLE `sequence_order_0` (
  `sequence_value` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sequence_order_0`
--


--
-- Table structure for table `sequence_order_1`
--

CREATE TABLE `sequence_order_1` (
  `sequence_value` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sequence_order_1`
--

INSERT INTO `sequence_order_1` VALUES (1),(2),(3);

--
-- Table structure for table `sequence_shipment_0`
--

CREATE TABLE `sequence_shipment_0` (
  `sequence_value` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sequence_shipment_0`
--


--
-- Table structure for table `sequence_shipment_1`
--

CREATE TABLE `sequence_shipment_1` (
  `sequence_value` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sequence_shipment_1`
--


--
-- Table structure for table `session`
--

CREATE TABLE `session` (
  `session_id` varchar(255) NOT NULL COMMENT 'Session Id',
  `session_expires` int unsigned NOT NULL DEFAULT '0' COMMENT 'Date of Session Expiration',
  `session_data` mediumblob NOT NULL COMMENT 'Session Data',
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Database Sessions Storage';

--
-- Dumping data for table `session`
--


--
-- Table structure for table `setup_module`
--

CREATE TABLE `setup_module` (
  `module` varchar(50) NOT NULL COMMENT 'Module',
  `schema_version` varchar(50) DEFAULT NULL COMMENT 'Schema Version',
  `data_version` varchar(50) DEFAULT NULL COMMENT 'Data Version',
  PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Module versions registry';

--
-- Dumping data for table `setup_module`
--

INSERT INTO `setup_module` VALUES ('Katalyst_Base','2.2.6','2.2.6'),('Katalyst_Price','2.2.6','2.2.6'),('Katalyst_Shirt','2.2.6','2.2.6'),('Katalyst_Thread','2.2.6','2.2.6'),('Magento_GoogleShoppingAds','4.0.1','4.0.1'),('Magento_Securitytxt','1.0.0','1.0.0'),('PayPal_Braintree','4.4.0','4.4.0'),('Suit_Data','2.1.4','2.1.4'),('Suit_LapelColor','2.1.4','2.1.4'),('Suit_Lining','2.1.4','2.1.4'),('Suit_Price','2.1.4','2.1.4'),('Suit_SuitTool','2.1.4','2.1.4'),('Suit_Tie','2.1.4','2.1.4'),('Tailcoat_Additional','2.1.4','2.1.4'),('Tailcoat_Data','2.1.4','2.1.4'),('Tailcoat_LapelColor','2.1.4','2.1.4'),('Tailcoat_Lining','2.1.4','2.1.4'),('Tailcoat_Price','2.1.4','2.1.4'),('Tailcoat_SuitTool','2.1.4','2.1.4'),('Tailcoat_Tie','2.1.4','2.1.4'),('Vest_Data','2.1.4','2.1.4'),('Vest_LapelColor','2.1.4','2.1.4'),('Vest_Lining','2.1.4','2.1.4'),('Vest_Price','2.1.4','2.1.4'),('Vest_SuitTool','2.1.4','2.1.4'),('Vest_Tie','2.1.4','2.1.4'),('WeddingSuit_Additional','2.1.4','2.1.4'),('WeddingSuit_Data','2.1.4','2.1.4'),('WeddingSuit_LapelColor','2.1.4','2.1.4'),('WeddingSuit_Lining','2.1.4','2.1.4'),('WeddingSuit_Price','2.1.4','2.1.4'),('WeddingSuit_SuitTool','2.1.4','2.1.4'),('WeddingSuit_Tie','2.1.4','2.1.4'),('WeSupply_Toolbox','1.0.1','1.0.1');

--
-- Table structure for table `shipping_tablerate`
--

CREATE TABLE `shipping_tablerate` (
  `pk` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',
  `website_id` int NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `dest_country_id` varchar(4) NOT NULL DEFAULT '0' COMMENT 'Destination coutry ISO/2 or ISO/3 code',
  `dest_region_id` int NOT NULL DEFAULT '0' COMMENT 'Destination Region ID',
  `dest_zip` varchar(10) NOT NULL DEFAULT '*' COMMENT 'Destination Post Code (Zip)',
  `condition_name` varchar(30) NOT NULL COMMENT 'Rate Condition name',
  `condition_value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Rate condition value',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `cost` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Cost',
  PRIMARY KEY (`pk`),
  UNIQUE KEY `UNQ_D60821CDB2AFACEE1566CFC02D0D4CAA` (`website_id`,`dest_country_id`,`dest_region_id`,`dest_zip`,`condition_name`,`condition_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Shipping Tablerate';

--
-- Dumping data for table `shipping_tablerate`
--


--
-- Table structure for table `shirt_accent_chestpleats`
--

CREATE TABLE `shirt_accent_chestpleats` (
  `chestpleats_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(40) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `class` varchar(100) NOT NULL,
  `view1_image` varchar(255) DEFAULT NULL,
  `view2_image` varchar(255) DEFAULT NULL,
  `view4_image` varchar(255) DEFAULT NULL,
  `status` smallint NOT NULL,
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`chestpleats_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_accent_chestpleats`
--

INSERT INTO `shirt_accent_chestpleats` VALUES (1,'No',1.00,'icon-No',NULL,NULL,NULL,1,'2018-01-22 01:39:16','2024-05-08 08:41:38'),(2,'Yes',1.00,'icon-Yes','men/generated_shirt_images/chestpleats/Shirt_Tuxedo_Front_Glow_1.png','men/generated_shirt_images/chestpleats/Shirt_Tuxedo_Side_Glow_2.png','men/generated_shirt_images/chestpleats/Shirt_Tuxedo_Folded_Glow_4.png',1,'2018-01-22 01:40:28','2024-05-08 08:41:40');

--
-- Table structure for table `shirt_accent_collarstyle`
--

CREATE TABLE `shirt_accent_collarstyle` (
  `collarstyle_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(40) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `class` varchar(100) NOT NULL,
  `status` smallint NOT NULL,
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`collarstyle_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_accent_collarstyle`
--

INSERT INTO `shirt_accent_collarstyle` VALUES (1,'By Default',1.00,'icon-By_Default',1,'2017-12-30 07:03:27','2024-05-08 08:41:14'),(2,'All',1.00,'icon-All',1,'2017-12-30 07:04:46','2024-05-08 08:41:15'),(3,'Outer Fabric',1.00,'icon-Oruter',1,'2018-01-22 00:47:27','2024-05-08 08:41:23'),(4,'Inner Fabric',1.00,'icon-Inner',1,'2018-01-22 00:47:42','2024-05-08 08:41:25');

--
-- Table structure for table `shirt_accent_cuffs`
--

CREATE TABLE `shirt_accent_cuffs` (
  `cuff_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(40) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `class` varchar(100) NOT NULL,
  `status` smallint NOT NULL,
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`cuff_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_accent_cuffs`
--

INSERT INTO `shirt_accent_cuffs` VALUES (1,'By Default',1.00,'icon-By_Default2',1,'2018-01-20 06:03:13','2024-05-08 08:42:00'),(2,'All',1.00,'icon-All2',1,'2018-01-22 01:36:58','2024-05-08 08:42:05'),(3,'Outer Fabric',1.00,'icon-Outer',1,'2018-01-22 01:37:11','2024-05-08 08:42:07'),(4,'Inner Fabric',1.00,'icon-Inner2',1,'2018-01-22 01:37:27','2024-05-08 08:42:03');

--
-- Table structure for table `shirt_accent_elbowpatches`
--

CREATE TABLE `shirt_accent_elbowpatches` (
  `elbowpatches_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(40) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `class` varchar(100) DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0',
  `glow_back_image` varchar(255) DEFAULT NULL,
  `mask_back_image` varchar(255) DEFAULT NULL,
  `highlighted_back_image` varchar(255) NOT NULL,
  `status` smallint DEFAULT NULL,
  PRIMARY KEY (`elbowpatches_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_accent_elbowpatches`
--

INSERT INTO `shirt_accent_elbowpatches` VALUES (1,'Without elbow patch',1.00,'icon-Without_Elbow_Patch','1','','','',1),(2,'With elbow patch',1.00,'icon-With_Elbow_Patch','1','glow_mask/Back_View/elbowpatches/back_elbowpatch_shad.png','glow_mask/Back_View/elbowpatches/back_elbowpatch_mask.png','glow_mask/Back_View/elbowpatches/back_elbowpatch_hi.png',1);

--
-- Table structure for table `shirt_accent_placket`
--

CREATE TABLE `shirt_accent_placket` (
  `placket_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(40) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `class` varchar(100) NOT NULL,
  `status` smallint NOT NULL,
  PRIMARY KEY (`placket_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_accent_placket`
--

INSERT INTO `shirt_accent_placket` VALUES (1,'By Default',0.00,'icon-Default',1),(2,'All',17.00,'icon-All3',1),(3,'Outer Fabric',15.00,'icon-outer',1),(4,'Inner Fabric',10.00,'icon-inner',1);

--
-- Table structure for table `shirt_accent_threadcolor`
--

CREATE TABLE `shirt_accent_threadcolor` (
  `threadcolor_id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `class` varchar(200) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  PRIMARY KEY (`threadcolor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_accent_threadcolor`
--

INSERT INTO `shirt_accent_threadcolor` VALUES (1,'Green','icon-icon-43',NULL,'',1);

--
-- Table structure for table `shirt_accent_threads`
--

CREATE TABLE `shirt_accent_threads` (
  `threads_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(40) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `class` varchar(100) DEFAULT NULL,
  `mask_front_image` varchar(255) DEFAULT NULL,
  `mask_side_image` varchar(255) DEFAULT NULL,
  `mask_back_image` varchar(255) DEFAULT NULL,
  `mask_fold_image` varchar(255) DEFAULT NULL,
  `mask_zoom_view` varchar(255) DEFAULT NULL,
  `mask_front_buttonhole_image` varchar(255) DEFAULT NULL,
  `mask_side_buttonhole_image` varchar(255) DEFAULT NULL,
  `mask_back_buttonhole_image` varchar(255) DEFAULT NULL,
  `mask_fold_buttonhole_image` varchar(255) DEFAULT NULL,
  `mask_zoomview_buttonhole_image` int DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`threads_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_accent_threads`
--

INSERT INTO `shirt_accent_threads` VALUES (1,'By Default',0.00,'icon-By_Default3\n',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-01-20 07:03:40','2018-07-02 13:16:24'),(2,'All',5.00,'icon-All4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-01-23 23:09:26','2018-07-02 13:15:17'),(3,'Only Cuff',5.00,'icon-Cuff_only','','','','','',NULL,NULL,NULL,NULL,NULL,1,'2018-01-23 23:09:26','2018-05-21 13:49:11'),(4,'Only Placket',5.00,'icon-Only_placket','','','','','','','','','',0,1,'2018-01-23 23:24:07','2018-05-21 13:49:33');

--
-- Table structure for table `shirt_button_fabric`
--

CREATE TABLE `shirt_button_fabric` (
  `button_fabric_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `class` varchar(40) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `btn_count` int DEFAULT NULL,
  `fabric_thumb` varchar(200) NOT NULL,
  `fabric_real_image` varchar(200) NOT NULL,
  UNIQUE KEY `id` (`button_fabric_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_button_fabric`
--

INSERT INTO `shirt_button_fabric` VALUES (1,'Thread','icos-thread',10.00,1,'men/threadfabric_images/thumbs/threadfabric_1_main.png','men/threadfabric_images/threadfabric_1_main.png'),(2,'Brown',NULL,15.00,NULL,'men/threadfabric_images/thumbs/threadfabric_4_main.png','men/threadfabric_images/threadfabric_4_main.png'),(3,'Oranage',NULL,NULL,NULL,'men/threadfabric_images/thumbs/solid_01.png','men/threadfabric_images/solid_01.png');

--
-- Table structure for table `shirt_fabric`
--

CREATE TABLE `shirt_fabric` (
  `fabric_id` int NOT NULL AUTO_INCREMENT,
  `fabric_name` varchar(100) DEFAULT NULL,
  `fabric_thumb` varchar(255) DEFAULT NULL,
  `fabric_real_image` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  `shirt_material_id` int DEFAULT NULL,
  `shirt_pattern_id` int DEFAULT NULL,
  `shirt_season_id` int DEFAULT NULL,
  `shirt_color_id` int DEFAULT NULL,
  `shirt_category_id` int DEFAULT NULL,
  `display_fabric_thumb` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fabric_id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_fabric`
--

INSERT INTO `shirt_fabric` VALUES (51,'Montana','men/fabric_images/thumbs/5a66d37255d8a_12.png','men/fabric_images/5a66d37257791_12.jpg',10.00,1,3,2,2,2,7,'men/fabric_images/display_thumb/5a66d37243145_12_Montana.png'),(52,'Conrad','men/fabric_images/thumbs/5a66d76f74072_03.png','men/fabric_images/5a66d76f7411c_03.jpg',40.00,1,1,2,2,2,5,'men/fabric_images/display_thumb/5a66d76f73b25_03_Conrad.png'),(53,'Kent','men/fabric_images/thumbs/5a66f669307aa_02.png','men/fabric_images/5a66f66930868_02.jpg',200.00,1,4,3,1,3,1,'men/fabric_images/display_thumb/5a66f6692a517_02_Kent.png'),(54,'Norfolk','men/fabric_images/thumbs/5a672bce25a0f_14.png','men/fabric_images/5a672bce25b05_14.jpg',78.00,1,3,1,2,2,1,'men/fabric_images/display_thumb/5a672bce252cc_14_Norfolk.png'),(56,'Nashville','men/fabric_images/thumbs/5a6732055e752_08.png','men/fabric_images/5a6732055e846_08.jpg',90.00,1,2,4,1,5,1,'men/fabric_images/display_thumb/5a6732055e0cf_08_Nashville.png'),(60,'Kent','men/fabric_images/thumbs/5a699616e444a_02.png','men/fabric_images/5a699616e454a_02.jpg',100.00,1,1,1,1,3,1,'men/fabric_images/display_thumb/5a699616e3d53_02_Kent.png'),(61,'Test1','men/fabric_images/thumbs/5ae9c800ac670_fabric_01_100.png','men/fabric_images/5ae9c800ac9f6_fabric_01_1000.png',30.00,1,5,1,1,5,1,'men/fabric_images/display_thumb/5ae9c800abcdc_fabric_01_360.png'),(64,'Test2','men/fabric_images/thumbs/5ae9cba6be236_fabric_02_100.png','men/fabric_images/5ae9cba6be337_Fabric_02_1000.png',40.00,1,2,1,3,6,7,'men/fabric_images/display_thumb/5ae9cba6bda96_fabric_02_360.png');

--
-- Table structure for table `shirt_shirtfabric`
--

CREATE TABLE `shirt_shirtfabric` (
  `fabric_id` int unsigned NOT NULL AUTO_INCREMENT,
  `display_fabric_thumb` varchar(255) DEFAULT '',
  `fabric_thumb` varchar(255) DEFAULT '',
  `fabric_large_image` varchar(255) DEFAULT '',
  `btn_color_id` smallint DEFAULT NULL,
  `shoes_color_id` smallint DEFAULT NULL,
  `fabric_material_id` smallint DEFAULT NULL,
  `fabric_pattern_id` smallint DEFAULT NULL,
  `fabric_season_id` smallint DEFAULT NULL,
  `fabric_color_id` smallint DEFAULT NULL,
  `fabric_category_id` smallint DEFAULT NULL,
  `title` varchar(255) DEFAULT '',
  `type` smallint DEFAULT '0',
  `status` smallint DEFAULT '0',
  `created_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `price` int DEFAULT '10',
  `title_german` varchar(255) DEFAULT NULL,
  `croped_scale` varchar(255) NOT NULL COMMENT 'Cropped Height',
  `fabric_image` varchar(255) NOT NULL COMMENT 'String Identifier',
  `x1` int DEFAULT NULL COMMENT 'x1',
  `y1` int DEFAULT NULL COMMENT 'y1',
  `x2` int DEFAULT NULL COMMENT 'x2',
  `y2` int DEFAULT NULL COMMENT 'y2',
  `h` int DEFAULT NULL COMMENT 'height',
  `w` int DEFAULT NULL COMMENT 'width',
  PRIMARY KEY (`fabric_id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirt_shirtfabric`
--

INSERT INTO `shirt_shirtfabric` VALUES (37,'men/fabric_images/display_thumb/600_066_1.jpg','men/fabric_images/thumbs/600_066_1.jpg','men/fabric_images/600_066_1.jpg',NULL,NULL,6,2,1,1,1,'600_066',0,1,NULL,NULL,0,'600_066','70','men/fabric_images/600_066_1.jpg',0,0,500,500,500,500),(38,'men/fabric_images/display_thumb/heathered-forest-green-large-thumb-1707298736.png','men/fabric_images/thumbs/heathered-forest-green-large-thumb-1707298736.png','men/fabric_images/heathered-forest-green-large-thumb-1707298736.png',NULL,NULL,1,1,1,1,1,'New Fab',0,1,NULL,NULL,100,'New Fab','100','men/fabric_images/heathered-forest-green-large-thumb-1707298736.png',0,0,500,500,0,0),(39,'men/fabric_images/display_thumb/heathered-forest-green-large-thumb-1707298736_1.png','men/fabric_images/thumbs/heathered-forest-green-large-thumb-1707298736_1.png','men/fabric_images/heathered-forest-green-large-thumb-1707298736_1.png',NULL,NULL,1,1,1,1,1,'new',0,1,NULL,NULL,80,'new','100','men/fabric_images/heathered-forest-green-large-thumb-1707298736_1.png',0,0,500,500,0,0),(58,'men/fabric_images/display_thumb/remaed_11.png','men/fabric_images/thumbs/remaed_11.png','men/fabric_images/remaed_11.png',NULL,NULL,1,1,1,1,1,'Akshay Jadhav',0,1,NULL,NULL,343,'Akshay','100','men/fabric_images/remaed_11.png',256,192,756,692,500,500);

--
-- Table structure for table `shirt_thread_fabric`
--

CREATE TABLE `shirt_thread_fabric` (
  `fabric_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Fabric Name',
  `fabric_thumb` varchar(255) DEFAULT NULL COMMENT 'Fabric Image',
  `price` decimal(10,2) DEFAULT NULL COMMENT 'Price',
  `status` int DEFAULT '0' COMMENT 'Status',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'creation_time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update_time',
  `title_german` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fabric_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COMMENT='Thread Fabric Category';

--
-- Dumping data for table `shirt_thread_fabric`
--

INSERT INTO `shirt_thread_fabric` VALUES (1,'Yellow','men/fabric_images/threads/thumbs/yellow_1.png',0.00,1,'2019-07-31 14:03:39','2019-09-20 07:16:25','Gelb'),(2,'Blue','men/fabric_images/threads/thumbs/blue.png',0.00,1,'2019-07-31 14:27:23','2019-11-29 16:39:49','Blau'),(3,'Red','men/fabric_images/threads/thumbs/red.png',0.00,1,'2019-07-31 14:33:54','2019-11-29 16:39:55','Rot'),(4,'BVlues','men/fabric_images/threads/thumbs/red_1.png',99.00,1,'2024-05-08 06:37:06','2024-05-08 06:42:07','Bluesh');

--
-- Table structure for table `shirtbottom`
--

CREATE TABLE `shirtbottom` (
  `shirtbottom_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `class` varchar(40) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0',
  `view1_image` varchar(200) DEFAULT NULL,
  `view2_image` varchar(255) DEFAULT NULL,
  `view3_image` varchar(255) DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  PRIMARY KEY (`shirtbottom_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtbottom`
--

INSERT INTO `shirtbottom` VALUES (1,'Tail','icon-Tailed',1.00,'0','men/generated_shirt_images/bottom/Shirt_Bottom_1_1.png','men/generated_shirt_images/bottom/Shirt_Bottom_2_1.png','men/generated_shirt_images/bottom/Shirt_Bottom_3_1.png',1),(2,'Square','icon-Squared',1.00,'0','men/generated_shirt_images/bottom/Shirt_Bottom_1_2.png','men/generated_shirt_images/bottom/Shirt_Bottom_2_2.png','men/generated_shirt_images/bottom/Shirt_Bottom_3_2.png',1);

--
-- Table structure for table `shirtcolor`
--

CREATE TABLE `shirtcolor` (
  `shirtcolor_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `status` smallint NOT NULL,
  PRIMARY KEY (`shirtcolor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtcolor`
--

INSERT INTO `shirtcolor` VALUES (1,'Grey',1),(2,'Black',1),(3,'Blue',1),(4,'Brown',1),(5,'White Shade',1),(6,'pink',1);

--
-- Table structure for table `shirtcuff`
--

CREATE TABLE `shirtcuff` (
  `shirtcuff_id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `class` varchar(200) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `glow_front_left_image` varchar(255) DEFAULT NULL,
  `mask_front_left_image` varchar(255) DEFAULT NULL,
  `highlighted_front_left_image` varchar(255) DEFAULT NULL,
  `glow_front_right_image` varchar(255) DEFAULT NULL,
  `mask_front_right_image` varchar(255) DEFAULT NULL,
  `highlighted_front_right_image` varchar(255) DEFAULT NULL,
  `glow_front_opencuff_left_image` varchar(255) DEFAULT NULL,
  `mask_front_opencuff_left_image` varchar(255) DEFAULT NULL,
  `highlighted_front_opencuff_left_image` varchar(255) DEFAULT NULL,
  `glow_front_opencuff_right_image` varchar(255) DEFAULT NULL,
  `mask_front_opencuff_right_image` varchar(255) DEFAULT NULL,
  `highlighted_front_opencuff_right_image` varchar(255) DEFAULT NULL,
  `glow_side_left_image` varchar(255) DEFAULT NULL,
  `mask_side_left_image` varchar(255) DEFAULT NULL,
  `highlighted_side_left_image` varchar(255) DEFAULT NULL,
  `glow_side_right_image` varchar(255) DEFAULT NULL,
  `mask_side_right_image` varchar(255) DEFAULT NULL,
  `highlighted_side_right_image` varchar(255) DEFAULT NULL,
  `glow_side_opencuff_left_image` varchar(255) DEFAULT NULL,
  `mask_side_opencuff_left_image` varchar(255) DEFAULT NULL,
  `highlighted_side_opencuff_left_image` varchar(255) DEFAULT NULL,
  `glow_side_opencuff_right_image` varchar(255) DEFAULT NULL,
  `mask_side_opencuff_right_image` varchar(255) DEFAULT NULL,
  `highlighted_side_opencuff_right_image` varchar(255) DEFAULT NULL,
  `glow_back_left_image` varchar(255) DEFAULT NULL,
  `mask_back_left_image` varchar(255) DEFAULT NULL,
  `highlighted_back_left_image` varchar(255) DEFAULT NULL,
  `glow_back_right_image` varchar(255) DEFAULT NULL,
  `mask_back_right_image` varchar(255) DEFAULT NULL,
  `highlighted_back_right_image` varchar(255) DEFAULT NULL,
  `glow_back_opencuff_left_image` varchar(255) DEFAULT NULL,
  `mask_back_opencuff_left_image` varchar(255) DEFAULT NULL,
  `highlighted_back_opencuff_left_image` varchar(255) DEFAULT NULL,
  `glow_back_opencuff_right_image` varchar(255) DEFAULT NULL,
  `mask_back_opencuff_right_image` varchar(255) DEFAULT NULL,
  `highlighted_back_opencuff_right_image` varchar(255) DEFAULT NULL,
  `glow_fold_main_image` varchar(255) DEFAULT NULL,
  `mask_fold_main_image` varchar(255) DEFAULT NULL,
  `highlighted_fold_main_image` varchar(255) DEFAULT NULL,
  `glow_fold_inner_image` varchar(255) DEFAULT NULL,
  `mask_fold_inner_image` varchar(255) DEFAULT NULL,
  `highlighted_fold_inner_image` varchar(255) DEFAULT NULL,
  `back_button_image` varchar(255) DEFAULT NULL,
  `fold_button_image` varchar(255) DEFAULT NULL,
  `back_thread_image` varchar(255) DEFAULT NULL,
  `fold_thread_image` varchar(255) DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  PRIMARY KEY (`shirtcuff_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtcuff`
--

INSERT INTO `shirtcuff` VALUES (1,'Double rounded french','icon-Cuff_double_rounded_french1',1.00,'1','1','glow_mask/Front_View/Cuffs/French_left_shad.png','glow_mask/Front_View/Cuffs/French_left_mask.png','glow_mask/Front_View/Cuffs/French_left_hi.png','glow_mask/Front_View/Cuffs/French_right_shad.png','glow_mask/Front_View/Cuffs/French_right_mask.png','glow_mask/Front_View/Cuffs/French_right_hi.png','glow_mask/Open_Cuffs/Front/CasualCuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/DoubleFrenchRounded_left_shad.png','glow_mask/Back_View/Cuffs/DoubleFrenchRounded_left_mask.png','glow_mask/Back_View/Cuffs/DoubleFrenchRounded_left_hi.png','glow_mask/Back_View/Cuffs/DoubleFrenchRounded_right_shad.png','glow_mask/Back_View/Cuffs/DoubleFrenchRounded_right_mask.png','glow_mask/Back_View/Cuffs/DoubleFrenchRounded_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/DoubleFrenchRounded_Main_shad.png','glow_mask/Folded_View/Cuffs/DoubleFrenchRounded_Main_mask.png','glow_mask/Folded_View/Cuffs/DoubleFrenchRounded_Main_hi.png','glow_mask/Folded_View/Cuffs/DoubleFrenchRounded_Inner_shad.png','glow_mask/Folded_View/Cuffs/DoubleFrenchRounded_Inner_mask.png','glow_mask/Folded_View/Cuffs/DoubleFrenchRounded_Inner_hi.png',NULL,NULL,NULL,NULL,1),(2,'Double Squared french','icon-Cuff_double_squared_french2',1.00,'1','1','glow_mask/Front_View/Cuffs/French_left_shad.png','glow_mask/Front_View/Cuffs/French_left_mask.png','glow_mask/Front_View/Cuffs/French_left_hi.png','glow_mask/Front_View/Cuffs/French_right_shad.png','glow_mask/Front_View/Cuffs/French_right_mask.png','glow_mask/Front_View/Cuffs/French_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/DoubleFrenchStraight_left_shad.png','glow_mask/Back_View/Cuffs/DoubleFrenchStraight_left_mask.png','glow_mask/Back_View/Cuffs/DoubleFrenchStraight_left_hi.png','glow_mask/Back_View/Cuffs/DoubleFrenchStraight_right_shad.png','glow_mask/Back_View/Cuffs/DoubleFrenchStraight_right_mask.png','glow_mask/Back_View/Cuffs/DoubleFrenchStraight_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/DoubleFrenchStraight_left_shad.png','glow_mask/Folded_View/Cuffs/DoubleFrenchStraight_Main_shad.png','glow_mask/Folded_View/Cuffs/DoubleFrenchStraight_Main_mask.png','glow_mask/Folded_View/Cuffs/DoubleFrenchStraight_Main_hi.png','glow_mask/Folded_View/Cuffs/DoubleFrenchStraight_Inner_shad.png','glow_mask/Folded_View/Cuffs/DoubleFrenchStraight_Inner_mask.png','glow_mask/Folded_View/Cuffs/DoubleFrenchStraight_Inner_hi.png',NULL,NULL,NULL,NULL,1),(3,'One-button-cut','icon-Cuff_one_button_cut3',1.00,'1','1','glow_mask/Front_View/Cuffs/normal_left_shad.png','glow_mask/Front_View/Cuffs/normal_left_mask.png','glow_mask/Front_View/Cuffs/normal_left_hi.png','glow_mask/Front_View/Cuffs/normal_right_shad.png','glow_mask/Front_View/Cuffs/normal_right_mask.png','glow_mask/Front_View/Cuffs/normal_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/NormalCut_left_shad.png','glow_mask/Back_View/Cuffs/NormalCut_left_mask.png','glow_mask/Back_View/Cuffs/NormalCut_left_hi.png','glow_mask/Back_View/Cuffs/NormalCut_right_shad.png','glow_mask/Back_View/Cuffs/NormalCut_right_mask.png','glow_mask/Back_View/Cuffs/NormalCut_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/NormalCut_Main_shad.png','glow_mask/Folded_View/Cuffs/NormalCut_Main_mask.png','glow_mask/Folded_View/Cuffs/NormalCut_Main_hi.png','glow_mask/Folded_View/Cuffs/NormalCut_Inner_shad.png','glow_mask/Folded_View/Cuffs/NormalCut_Inner_mask.png','glow_mask/Folded_View/Cuffs/NormalCut_Inner_hi.png',NULL,NULL,NULL,NULL,1),(4,'Rounded 1 button','icon-Cuff_one_button_rounded4',1.00,'1','1','glow_mask/Front_View/Cuffs/normal_left_shad.png','glow_mask/Front_View/Cuffs/normal_left_mask.png','glow_mask/Front_View/Cuffs/normal_left_hi.png','glow_mask/Front_View/Cuffs/normal_right_shad.png','glow_mask/Front_View/Cuffs/normal_right_mask.png','glow_mask/Front_View/Cuffs/normal_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/NormalRounded_left_shad.png','glow_mask/Back_View/Cuffs/NormalRounded_left_mask.png','glow_mask/Back_View/Cuffs/NormalRounded_left_hi.png','glow_mask/Back_View/Cuffs/NormalRounded_right_shad.png','glow_mask/Back_View/Cuffs/NormalRounded_right_mask.png','glow_mask/Back_View/Cuffs/NormalRounded_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/NormalRounded_Main_shad.png','glow_mask/Folded_View/Cuffs/NormalRounded_Main_mask.png','glow_mask/Folded_View/Cuffs/NormalRounded_Main_hi.png','glow_mask/Folded_View/Cuffs/NormalRounded_Inner_shad.png','glow_mask/Folded_View/Cuffs/NormalRounded_Inner_mask.png','glow_mask/Folded_View/Cuffs/NormalRounded_Inner_hi.png',NULL,NULL,NULL,NULL,1),(5,'Rounded 2 buttons','icon-Cuff_two_button_rounded5',1.00,'1','1','glow_mask/Front_View/Cuffs/normal_left_shad.png','glow_mask/Front_View/Cuffs/normal_left_mask.png','glow_mask/Front_View/Cuffs/normal_left_hi.png','glow_mask/Front_View/Cuffs/normal_right_shad.png','glow_mask/Front_View/Cuffs/normal_right_mask.png','glow_mask/Front_View/Cuffs/normal_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/NormalRounded_left_shad.png','glow_mask/Back_View/Cuffs/NormalRounded_left_mask.png','glow_mask/Back_View/Cuffs/NormalRounded_left_hi.png','glow_mask/Back_View/Cuffs/NormalRounded_right_shad.png','glow_mask/Back_View/Cuffs/NormalRounded_right_mask.png','glow_mask/Back_View/Cuffs/NormalRounded_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/NormalRounded_Main_shad.png','glow_mask/Folded_View/Cuffs/NormalRounded_Main_mask.png','glow_mask/Folded_View/Cuffs/NormalRounded_Main_hi.png','glow_mask/Folded_View/Cuffs/NormalRounded_Inner_shad.png','glow_mask/Folded_View/Cuffs/NormalRounded_Inner_mask.png','glow_mask/Folded_View/Cuffs/NormalRounded_Inner_hi.png',NULL,NULL,NULL,NULL,1),(6,'Rounded french','icon-Cuff_rounded_french6',1.00,'1','1','glow_mask/Front_View/Cuffs/French_left_shad.png','glow_mask/Front_View/Cuffs/French_left_mask.png','glow_mask/Front_View/Cuffs/French_left_hi.png','glow_mask/Front_View/Cuffs/French_right_shad.png','glow_mask/Front_View/Cuffs/French_right_mask.png','glow_mask/Front_View/Cuffs/French_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/FrenchRound_left_shad.png','glow_mask/Back_View/Cuffs/FrenchRound_left_mask.png','glow_mask/Back_View/Cuffs/FrenchRound_left_hi.png','glow_mask/Back_View/Cuffs/FrenchRound_right_shad.png','glow_mask/Back_View/Cuffs/FrenchRound_right_mask.png','glow_mask/Back_View/Cuffs/FrenchRound_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/FrenchRounded_Main_shad.png','glow_mask/Folded_View/Cuffs/FrenchRounded_Main_mask.png','glow_mask/Folded_View/Cuffs/FrenchRounded_Main_hi.png','glow_mask/Folded_View/Cuffs/FrenchRounded_Inner_shad.png','glow_mask/Folded_View/Cuffs/FrenchRounded_Inner_mask.png','glow_mask/Folded_View/Cuffs/FrenchRounded_Inner_hi.png',NULL,NULL,NULL,NULL,1),(7,'Single cuff 1 button','icon-Cuff_one_button_straight7',1.00,'1','1','glow_mask/Front_View/Cuffs/normal_left_shad.png','glow_mask/Front_View/Cuffs/normal_left_mask.png','glow_mask/Front_View/Cuffs/normal_left_hi.png','glow_mask/Front_View/Cuffs/normal_right_shad.png','glow_mask/Front_View/Cuffs/normal_right_mask.png','glow_mask/Front_View/Cuffs/normal_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/NormalStraight_left_shad.png','glow_mask/Back_View/Cuffs/NormalStraight_left_mask.png','glow_mask/Back_View/Cuffs/NormalStraight_left_hi.png','glow_mask/Back_View/Cuffs/NormalStraight_right_shad.png','glow_mask/Back_View/Cuffs/NormalStraight_right_mask.png','glow_mask/Back_View/Cuffs/NormalStraight_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/NormalStraight_Main_shad.png','glow_mask/Folded_View/Cuffs/NormalStraight_Main_mask.png','glow_mask/Folded_View/Cuffs/NormalStraight_Main_hi.png','glow_mask/Folded_View/Cuffs/NormalStraight_Inner_shad.png','glow_mask/Folded_View/Cuffs/NormalStraight_Inner_mask.png','glow_mask/Folded_View/Cuffs/NormalStraight_Inner_hi.png',NULL,NULL,NULL,NULL,1),(8,'Single cuff 2 buttons','icon-Cuff_two_button_straight8',1.00,'1','1','glow_mask/Front_View/Cuffs/normal_left_shad.png','glow_mask/Front_View/Cuffs/normal_left_mask.png','glow_mask/Front_View/Cuffs/normal_left_hi.png','glow_mask/Front_View/Cuffs/normal_right_shad.png','glow_mask/Front_View/Cuffs/normal_right_mask.png','glow_mask/Front_View/Cuffs/normal_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/NormalStraight_left_shad.png','glow_mask/Back_View/Cuffs/NormalStraight_left_mask.png','glow_mask/Back_View/Cuffs/NormalStraight_left_hi.png','glow_mask/Back_View/Cuffs/NormalStraight_right_shad.png','glow_mask/Back_View/Cuffs/NormalStraight_right_mask.png','glow_mask/Back_View/Cuffs/NormalStraight_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/NormalStraight_Main_shad.png','glow_mask/Folded_View/Cuffs/NormalStraight_Main_mask.png','glow_mask/Folded_View/Cuffs/NormalStraight_Main_hi.png','glow_mask/Folded_View/Cuffs/NormalStraight_Inner_shad.png','glow_mask/Folded_View/Cuffs/NormalStraight_Inner_mask.png','glow_mask/Folded_View/Cuffs/NormalStraight_Inner_hi.png',NULL,NULL,NULL,NULL,1),(9,'Squared French','icon-Cuff_squared_french9',1.00,'1','1','glow_mask/Front_View/Cuffs/French_left_shad.png','glow_mask/Front_View/Cuffs/French_left_mask.png','glow_mask/Front_View/Cuffs/French_left_hi.png','glow_mask/Front_View/Cuffs/French_right_shad.png','glow_mask/Front_View/Cuffs/French_right_mask.png','glow_mask/Front_View/Cuffs/French_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/FrenchStraight_left_shad.png','glow_mask/Back_View/Cuffs/FrenchStraight_left_mask.png','glow_mask/Back_View/Cuffs/FrenchStraight_left_hi.png','glow_mask/Back_View/Cuffs/FrenchStraight_right_shad.png','glow_mask/Back_View/Cuffs/FrenchStraight_right_mask.png','glow_mask/Back_View/Cuffs/FrenchStraight_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/FrenchStraight_Main_shad.png','glow_mask/Folded_View/Cuffs/FrenchStraight_Main_mask.png','glow_mask/Folded_View/Cuffs/FrenchStraight_Main_hi.png','glow_mask/Folded_View/Cuffs/FrenchStraight_Inner_shad.png','glow_mask/Folded_View/Cuffs/FrenchStraight_Inner_mask.png','glow_mask/Folded_View/Cuffs/FrenchStraight_Inner_hi.png',NULL,NULL,NULL,NULL,1),(10,'Two-button-cut','icon-Cuff_two_button_cut10',1.00,'1','1','glow_mask/Front_View/Cuffs/normal_left_shad.png','glow_mask/Front_View/Cuffs/normal_left_mask.png','glow_mask/Front_View/Cuffs/normal_left_hi.png','glow_mask/Front_View/Cuffs/normal_right_shad.png','glow_mask/Front_View/Cuffs/normal_right_mask.png','glow_mask/Front_View/Cuffs/normal_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_shad.png','glow_mask/Side_View/Cuffs/Normal_left_mask.png','glow_mask/Side_View/Cuffs/Normal_left_hi.png','glow_mask/Side_View/Cuffs/Normal_right_shad.png','glow_mask/Side_View/Cuffs/Normal_right_mask.png','glow_mask/Side_View/Cuffs/Normal_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/NormalCut_left_shad.png','glow_mask/Back_View/Cuffs/NormalCut_left_mask.png','glow_mask/Back_View/Cuffs/NormalCut_left_hi.png','glow_mask/Back_View/Cuffs/NormalCut_right_shad.png','glow_mask/Back_View/Cuffs/NormalCut_right_mask.png','glow_mask/Back_View/Cuffs/NormalCut_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/NormalCut_Main_shad.png','glow_mask/Folded_View/Cuffs/NormalCut_Main_mask.png','glow_mask/Folded_View/Cuffs/NormalCut_Main_hi.png','glow_mask/Folded_View/Cuffs/NormalCut_Inner_shad.png','glow_mask/Folded_View/Cuffs/NormalCut_Inner_mask.png','glow_mask/Folded_View/Cuffs/NormalCut_Inner_hi.png',NULL,NULL,NULL,NULL,1),(11,'Narrow','icon-Cuff_Narrow_11',1.00,'1','1','glow_mask/Front_View/Cuffs/Narrown_left_shad.png','glow_mask/Front_View/Cuffs/Narrown_left_mask.png','glow_mask/Front_View/Cuffs/Narrown_left_hi.png','glow_mask/Front_View/Cuffs/Narrown_right_shad.png','glow_mask/Front_View/Cuffs/Narrown_right_mask.png','glow_mask/Front_View/Cuffs/Narrown_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/Narrow_left_shad.png','glow_mask/Side_View/Cuffs/Narrow_left_mask.png','glow_mask/Side_View/Cuffs/Narrow_left_hi.png','glow_mask/Side_View/Cuffs/Narrow_right_shad.png','glow_mask/Side_View/Cuffs/Narrow_right_mask.png','glow_mask/Side_View/Cuffs/Narrow_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/NarrowStraight_left_shad.png','glow_mask/Back_View/Cuffs/NarrowStraight_left_mask.png','glow_mask/Back_View/Cuffs/NarrowStraight_left_hi.png','glow_mask/Back_View/Cuffs/NarrowStraight_right_shad.png','glow_mask/Back_View/Cuffs/NarrowStraight_right_mask.png','glow_mask/Back_View/Cuffs/NarrowStraight_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/NarrownStraight_Main_shad.png','glow_mask/Folded_View/Cuffs/NarrownStraight_Main_mask.png','glow_mask/Folded_View/Cuffs/NarrownStraight_Main_hi.png','glow_mask/Folded_View/Cuffs/NarrownStraight_Inner_shad.png','glow_mask/Folded_View/Cuffs/NarrownStraight_Inner_mask.png','glow_mask/Folded_View/Cuffs/NarrownStraight_Inner_hi.png',NULL,NULL,NULL,NULL,1),(12,'French Cut','icon-Cuff_French_Cut',1.00,'1','1','glow_mask/Front_View/Cuffs/French_left_shad.png','glow_mask/Front_View/Cuffs/French_left_mask.png','glow_mask/Front_View/Cuffs/French_left_hi.png','glow_mask/Front_View/Cuffs/French_right_shad.png','glow_mask/Front_View/Cuffs/French_right_mask.png','glow_mask/Front_View/Cuffs/French_right_hi.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_glow.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Open_Cuffs/Front/Casualcuff_Front_left_mask.png','glow_mask/Side_View/Cuffs/FrenchCut_left_shad.png','glow_mask/Side_View/Cuffs/FrenchCut_left_mask.png','glow_mask/Side_View/Cuffs/FrenchCut_left_hi.png','glow_mask/Side_View/Cuffs/FrenchCut_right_shad.png','glow_mask/Side_View/Cuffs/FrenchCut_right_mask.png','glow_mask/Side_View/Cuffs/FrenchCut_right_hi.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_glow.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Open_Cuffs/Side/Casualcuff_Side_left_mask.png','glow_mask/Back_View/Cuffs/FrenchCut_left_shad.png','glow_mask/Back_View/Cuffs/FrenchCut_left_mask.png','glow_mask/Back_View/Cuffs/FrenchCut_left_hi.png','glow_mask/Back_View/Cuffs/FrenchCut_right_shad.png','glow_mask/Back_View/Cuffs/FrenchCut_right_mask.png','glow_mask/Back_View/Cuffs/FrenchCut_right_hi.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_glow.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Open_Cuffs/Back/Casualcuff_Back_left_mask.png','glow_mask/Folded_View/Cuffs/FrenchCut_Main_shad.png','glow_mask/Folded_View/Cuffs/FrenchCut_Main_mask.png','glow_mask/Folded_View/Cuffs/FrenchCut_Main_hi.png','glow_mask/Folded_View/Cuffs/FrenchCut_Inner_shad.png','glow_mask/Folded_View/Cuffs/FrenchCut_Inner_mask.png','glow_mask/Folded_View/Cuffs/FrenchCut_Inner_hi.png',NULL,NULL,NULL,NULL,1);

--
-- Table structure for table `shirtfit`
--

CREATE TABLE `shirtfit` (
  `shirtfit_id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `class` varchar(200) NOT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0',
  `glow_front_image` varchar(200) DEFAULT NULL,
  `mask_front_image` varchar(200) DEFAULT NULL,
  `highlighted_front_image` varchar(200) DEFAULT NULL,
  `glow_side_image` varchar(255) DEFAULT NULL,
  `mask_side_image` varchar(255) DEFAULT NULL,
  `highlighted_side_image` varchar(255) DEFAULT NULL,
  `glow_back_image` varchar(255) DEFAULT NULL,
  `mask_back_image` varchar(255) DEFAULT NULL,
  `highlighted_back_image` varchar(255) DEFAULT NULL,
  `glow_fold_image` varchar(255) DEFAULT NULL,
  `mask_fold_image` varchar(255) DEFAULT NULL,
  `highlighted_fold_image` varchar(255) DEFAULT NULL,
  `glow_zoom_image` varchar(255) DEFAULT NULL,
  `mask_zoom_image` varchar(255) DEFAULT NULL,
  `highlighted_zoom_image` varchar(255) DEFAULT NULL,
  `status` smallint NOT NULL DEFAULT '0',
  PRIMARY KEY (`shirtfit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtfit`
--

INSERT INTO `shirtfit` VALUES (1,'Loose','icon-Loose_Fit',2.00,'0','glow_mask/Front_View/Fit/Shirt_Loosefit_Front_Shad.png','glow_mask/Front_View/Fit/Shirt_Loosefit_Front_Mask.png','glow_mask/Front_View/Fit/Shirt_Loosefit_Front_Hi.png','glow_mask/Side_View/Fit/Shirt_Loosefit_Side_Shad.png','glow_mask/Side_View/Fit/Shirt_Loosefit_Side_Mask.png','glow_mask/Side_View/Fit/Shirt_Loosefit_Side_Hi.png','glow_mask/Back_View/Fit/Shirt_Loosefit_Back_Shad.png','glow_mask/Back_View/Fit/Shirt_Loosefit_Back_Mask.png','glow_mask/Back_View/Fit/Shirt_Loosefit_Back_Hi.png','glow_mask/Folded_View/Fit/Shirt_Mainfit_Folded_Shad.png','glow_mask/Folded_View/Fit/Shirt_Mainfit_Folded_Mask.png','glow_mask/Folded_View/Fit/Shirt_Mainfit_Folded_Hi.png','glow_mask/Zoom_View/Fit/Torso_Shad.png','glow_mask/Zoom_View/Fit/Torso_Mask.png','glow_mask/Zoom_View/Fit/Torso_Hi.png',1),(2,'Waisted','icon-Slim_Fit',1.00,'0','','','','','','','','','','','','','','','',1);

--
-- Table structure for table `shirtplackets`
--

CREATE TABLE `shirtplackets` (
  `shirtplackets_id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `class` varchar(200) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `glow_front_image` varchar(200) DEFAULT NULL,
  `mask_front_image` varchar(200) DEFAULT NULL,
  `highlighted_front_image` varchar(200) DEFAULT NULL,
  `glow_side_image` varchar(255) DEFAULT NULL,
  `mask_side_image` varchar(255) DEFAULT NULL,
  `highlighted_side_image` varchar(255) DEFAULT NULL,
  `glow_fold_image` varchar(255) DEFAULT NULL,
  `mask_fold_image` varchar(255) DEFAULT NULL,
  `highlighted_fold_image` varchar(255) DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  PRIMARY KEY (`shirtplackets_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtplackets`
--

INSERT INTO `shirtplackets` VALUES (1,'Standard','icon-Standard_Placket',1.00,NULL,'glow_mask/Front_View/Plackets/Shirt_Placket_Front_shad.png','glow_mask/Front_View/Plackets/Shirt_Placket_Front_mask.png','glow_mask/Front_View/Plackets/Shirt_Placket_Front_hi.png','glow_mask/Side_View/Plackets/Shirt_Placket_Side_shad.png','glow_mask/Side_View/Plackets/Shirt_Placket_Side_mask.png','glow_mask/Side_View/Plackets/Shirt_Placket_Side_hi.png','glow_mask/Folded_View/Plackets/Shirt_Placket_Folded_shad.png','glow_mask/Folded_View/Plackets/Shirt_Placket_Folded_mask.png','glow_mask/Folded_View/Plackets/Shirt_Placket_Folded_hi.png',1),(2,'Hidden Buttons','icon-Hidden_Button_Placket',1.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(3,'French','icon-French_Placket',1.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);

--
-- Table structure for table `shirtpleats`
--

CREATE TABLE `shirtpleats` (
  `shirtpleats_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `class` varchar(40) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  PRIMARY KEY (`shirtpleats_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtpleats`
--

INSERT INTO `shirtpleats` VALUES (1,'No Pleats','icon-No_Pleats1',1.00,'',1),(2,'Box pleat','icon-Box_Pleats2',1.00,'men/generated_shirt_images/pleats/Shirt_pleats_2_Back.png',1),(3,'Side folds','icon-Side_Folds3',1.00,'men/generated_shirt_images/pleats/Shirt_pleats_3_Back.png',1);

--
-- Table structure for table `shirtpocket`
--

CREATE TABLE `shirtpocket` (
  `shirtpocket_id` int unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `class` varchar(200) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `thumb` varchar(200) DEFAULT NULL,
  `glow_front_left_image` varchar(255) DEFAULT NULL,
  `mask_front_left_image` varchar(200) DEFAULT NULL,
  `highlighted_front_left_image` varchar(200) DEFAULT NULL,
  `glow_front_right_image` varchar(255) DEFAULT NULL,
  `mask_front_right_image` varchar(200) DEFAULT NULL,
  `highlighted_front_right_image` varchar(200) DEFAULT NULL,
  `glow_side_left_image` varchar(255) DEFAULT NULL,
  `mask_side_left_image` varchar(200) DEFAULT NULL,
  `highlighted_side_left_image` varchar(200) DEFAULT NULL,
  `glow_side_right_image` varchar(255) DEFAULT NULL,
  `mask_side_right_image` varchar(200) DEFAULT NULL,
  `highlighted_side_right_image` varchar(200) DEFAULT NULL,
  `glow_fold_left_image` varchar(255) DEFAULT NULL,
  `mask_fold_left_image` varchar(200) DEFAULT NULL,
  `highlighted_fold_left_image` varchar(200) DEFAULT NULL,
  `glow_fold_right_image` varchar(255) DEFAULT NULL,
  `mask_fold_right_image` varchar(200) DEFAULT NULL,
  `highlighted_fold_right_image` varchar(200) DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  PRIMARY KEY (`shirtpocket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtpocket`
--

INSERT INTO `shirtpocket` VALUES (1,'No Pocket','icon-No_pocket_Icon',1.00,'1','glow_mask/pocket/Pockets_Regular_Flaps_Main_Glow.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(2,'Left Flap Pockets','icon-left_flap_pocket',1.00,'1','glow_mask/pocket/Pockets_Regular_Flaps_Main_Glow.png','glow_mask/Front_View/Pockets/Flap_left_shad.png','glow_mask/Front_View/Pockets/Flap_left_mask.png','glow_mask/Front_View/Pockets/Flap_left_hi.png',NULL,NULL,NULL,'glow_mask/Side_View/Pockets/FlapPocket_Left_shad.png','glow_mask/Side_View/Pockets/FlapPocket_Left_mask.png','glow_mask/Side_View/Pockets/FlapPocket_Left_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Pockets/FlappedPockets_left_Folded_shad.png','glow_mask/Folded_View/Pockets/FlappedPockets_left_Folded_mask.png','glow_mask/Folded_View/Pockets/FlappedPockets_left_Folded_hi.png',NULL,NULL,NULL,1),(3,'Left Without flaps',' icon-Withoutflap_Pocket_Left',1.00,'1','glow_mask/pocket/Pockets_Regular_Flaps_Main_Glow.png','glow_mask/Front_View/Pockets/WithoutFlap_left_shad.png','glow_mask/Front_View/Pockets/WithoutFlap_left_mask.png','glow_mask/Front_View/Pockets/WithoutFlap_left_hi.png',NULL,NULL,NULL,'glow_mask/Side_View/Pockets/WithoutFlap_Left_shad.png','glow_mask/Side_View/Pockets/WithoutFlap_Left_mask.png','glow_mask/Side_View/Pockets/WithoutFlap_Left_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Pockets/WithoutFlap_left_Folded_shad.png','glow_mask/Folded_View/Pockets/WithoutFlap_left_Folded_mask.png','glow_mask/Folded_View/Pockets/WithoutFlap_left_Folded_hi.png',NULL,NULL,NULL,1),(4,'Right Flap Pockets','icon-right_flap_pocket',1.00,'1','glow_mask/pocket/Pockets_Regular_Flaps_Main_Glow.png',NULL,NULL,NULL,'glow_mask/Front_View/Pockets/Flap_right_shad.png','glow_mask/Front_View/Pockets/Flap_right_mask.png','glow_mask/Front_View/Pockets/Flap_right_hi.png',NULL,NULL,NULL,'glow_mask/Side_View/Pockets/FlapPocket_Right_shad.png','glow_mask/Side_View/Pockets/FlapPocket_Right_mask.png','glow_mask/Side_View/Pockets/FlapPocket_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Pockets/FlappedPockets_right_Folded_shad.png','glow_mask/Folded_View/Pockets/FlappedPockets_right_Folded_mask.png','glow_mask/Folded_View/Pockets/FlappedPockets_right_Folded_hi.png',1),(5,'Right Without flaps','icon-Withoutflap_Pocket_Right',1.00,'1','glow_mask/pocket/Pockets_Regular_Flaps_Main_Glow.png',NULL,NULL,NULL,'glow_mask/Front_View/Pockets/WithoutFlap_right_shad.png','glow_mask/Front_View/Pockets/WithoutFlap_right_mask.png','glow_mask/Front_View/Pockets/WithoutFlap_right_hi.png',NULL,NULL,NULL,'glow_mask/Side_View/Pockets/WithoutFlap_Right_shad.png','glow_mask/Side_View/Pockets/WithoutFlap_Right_mask.png','glow_mask/Side_View/Pockets/WithoutFlap_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Pockets/WithoutFlap_right_Folded_shad.png','glow_mask/Folded_View/Pockets/WithoutFlap_right_Folded_mask.png','glow_mask/Folded_View/Pockets/WithoutFlap_right_Folded_hi.png',1),(6,'Flap PocketsX2','icon-flap_pocket_x2',1.00,'1','glow_mask/pocket/Pockets_Regular_Flaps_Main_Glow.png','glow_mask/Front_View/Pockets/Flap_left_shad.png','glow_mask/Front_View/Pockets/Flap_left_mask.png','glow_mask/Front_View/Pockets/Flap_left_hi.png','glow_mask/Front_View/Pockets/Flap_right_shad.png','glow_mask/Front_View/Pockets/Flap_right_mask.png','glow_mask/Front_View/Pockets/Flap_right_hi.png','glow_mask/Side_View/Pockets/FlapPocket_Left_shad.png','glow_mask/Side_View/Pockets/FlapPocket_Left_mask.png','glow_mask/Side_View/Pockets/FlapPocket_Left_hi.png','glow_mask/Side_View/Pockets/FlapPocket_Right_shad.png','glow_mask/Side_View/Pockets/FlapPocket_Right_mask.png','glow_mask/Side_View/Pockets/FlapPocket_Right_hi.png','glow_mask/Folded_View/Pockets/FlappedPockets_left_Folded_shad.png','glow_mask/Folded_View/Pockets/FlappedPockets_left_Folded_mask.png','glow_mask/Folded_View/Pockets/FlappedPockets_left_Folded_hi.png','glow_mask/Folded_View/Pockets/FlappedPockets_right_Folded_shad.png','glow_mask/Folded_View/Pockets/FlappedPockets_right_Folded_mask.png','glow_mask/Folded_View/Pockets/FlappedPockets_right_Folded_hi.png',1),(7,'Without flapsX2','icon-Withoutflap_Pocket_x2',1.00,'1','glow_mask/pocket/Pockets_Regular_Flaps_Main_Glow.png','glow_mask/Front_View/Pockets/WithoutFlap_left_shad.png','glow_mask/Front_View/Pockets/WithoutFlap_left_mask.png','glow_mask/Front_View/Pockets/WithoutFlap_left_hi.png','glow_mask/Front_View/Pockets/WithoutFlap_right_shad.png','glow_mask/Front_View/Pockets/WithoutFlap_right_mask.png','glow_mask/Front_View/Pockets/WithoutFlap_right_hi.png','glow_mask/Side_View/Pockets/WithoutFlap_Left_shad.png','glow_mask/Side_View/Pockets/WithoutFlap_Left_mask.png','glow_mask/Side_View/Pockets/WithoutFlap_Left_hi.png','glow_mask/Side_View/Pockets/WithoutFlap_Right_shad.png','glow_mask/Side_View/Pockets/WithoutFlap_Right_mask.png','glow_mask/Side_View/Pockets/WithoutFlap_Right_hi.png','glow_mask/Folded_View/Pockets/WithoutFlap_left_Folded_shad.png','glow_mask/Folded_View/Pockets/WithoutFlap_left_Folded_mask.png','glow_mask/Folded_View/Pockets/WithoutFlap_left_Folded_hi.png','glow_mask/Folded_View/Pockets/WithoutFlap_right_Folded_shad.png','glow_mask/Folded_View/Pockets/WithoutFlap_right_Folded_mask.png','glow_mask/Folded_View/Pockets/WithoutFlap_right_Folded_hi.png',1);

--
-- Table structure for table `shirtseason`
--

CREATE TABLE `shirtseason` (
  `shirtseason_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `status` smallint NOT NULL,
  PRIMARY KEY (`shirtseason_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtseason`
--

INSERT INTO `shirtseason` VALUES (1,'Summer',1),(2,'Winter',1),(3,'Year Round',1);

--
-- Table structure for table `shirtsleeves`
--

CREATE TABLE `shirtsleeves` (
  `shirtsleeves_id` int unsigned NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `class` varchar(200) NOT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0',
  `gender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0',
  `glow_front_left_image` varchar(255) NOT NULL DEFAULT '',
  `mask_front_left_image` varchar(255) NOT NULL,
  `highlighted_front_left_image` varchar(255) NOT NULL,
  `glow_front_right_image` varchar(255) NOT NULL DEFAULT '',
  `mask_front_right_image` varchar(255) NOT NULL,
  `highlighted_front_right_image` varchar(255) NOT NULL,
  `glow_side_left_image` varchar(255) NOT NULL,
  `mask_side_left_image` varchar(255) NOT NULL,
  `highlighted_side_left_image` varchar(255) NOT NULL,
  `glow_side_right_image` varchar(255) NOT NULL,
  `mask_side_right_image` varchar(255) NOT NULL,
  `highlighted_side_right_image` varchar(255) NOT NULL,
  `glow_back_left_image` varchar(255) NOT NULL,
  `mask_back_left_image` varchar(255) NOT NULL,
  `highlighted_back_left_image` varchar(255) NOT NULL,
  `glow_back_right_image` varchar(255) NOT NULL,
  `mask_back_right_image` varchar(255) NOT NULL,
  `highlighted_back_right_image` varchar(255) NOT NULL,
  `glow_fold_image` varchar(255) NOT NULL,
  `mask_fold_image` varchar(255) NOT NULL,
  `highlighted_fold_image` varchar(255) NOT NULL,
  `status` smallint DEFAULT NULL,
  PRIMARY KEY (`shirtsleeves_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtsleeves`
--

INSERT INTO `shirtsleeves` VALUES (1,'Long','icon-Sleeve_Full',2.00,'1','0','glow_mask/Front_View/Sleeves/Shirt_Fullsleeve_Front_Left_shad.png','glow_mask/Front_View/Sleeves/Shirt_Fullsleeve_Front_Left_mask.png','glow_mask/Front_View/Sleeves/Shirt_Fullsleeve_Front_Left_hi.png','glow_mask/Front_View/Sleeves/Shirt_Fullsleeve_Front_right_shad.png','glow_mask/Front_View/Sleeves/Shirt_Fullsleeve_Front_right_mask.png','glow_mask/Front_View/Sleeves/Shirt_Fullsleeve_Front_right_hi.png','glow_mask/Side_View/Sleeves/Shirt_Fullsleeve_Side_Left_shad.png','glow_mask/Side_View/Sleeves/Shirt_Fullsleeve_Side_Left_mask.png','glow_mask/Side_View/Sleeves/Shirt_Fullsleeve_Side_Left_hi.png','glow_mask/Side_View/Sleeves/Shirt_Fullsleeve_Side_Right_shad.png','glow_mask/Side_View/Sleeves/Shirt_Fullsleeve_Side_Right_mask.png','glow_mask/Side_View/Sleeves/Shirt_Fullsleeve_Side_Right_hi.png','glow_mask/Back_View/Sleeves/Full_left_shad.png','glow_mask/Back_View/Sleeves/Full_left_mask.png','glow_mask/Back_View/Sleeves/Full_left_hi.png','glow_mask/Back_View/Sleeves/Full_right_shad.png','glow_mask/Back_View/Sleeves/Full_right_mask.png','glow_mask/Back_View/Sleeves/Full_right_hi.png','','','',1),(2,'Short','icon-Half_Sleeves',1.00,'1','0','glow_mask/Front_View/Sleeves/Shirt_Halfsleeve_Front_Left_shad.png','glow_mask/Front_View/Sleeves/Shirt_Halfsleeve_Front_Left_mask.png','glow_mask/Front_View/Sleeves/Shirt_Halfsleeve_Front_Left_hi.png','glow_mask/Front_View/Sleeves/Shirt_Halfsleeve_Front_right_shad.png','glow_mask/Front_View/Sleeves/Shirt_Halfsleeve_Front_right_mask.png','glow_mask/Front_View/Sleeves/Shirt_Halfsleeve_Front_right_hi.png','glow_mask/Side_View/Sleeves/Shirt_Halfsleeve_Side_Left_shad.png','glow_mask/Side_View/Sleeves/Shirt_Halfsleeve_Side_Left_mask.png','glow_mask/Side_View/Sleeves/Shirt_Halfsleeve_Side_Left_hi.png','glow_mask/Side_View/Sleeves/Shirt_Halfsleeve_Side_Right_shad.png','glow_mask/Side_View/Sleeves/Shirt_Halfsleeve_Side_Right_mask.png','glow_mask/Side_View/Sleeves/Shirt_Halfsleeve_Side_Right_hi.png','glow_mask/Back_View/Sleeves/Half_left_shad.png','glow_mask/Back_View/Sleeves/Half_left_mask.png','glow_mask/Back_View/Sleeves/Half_left_hi.png','glow_mask/Back_View/Sleeves/Half_right_shad.png','glow_mask/Back_View/Sleeves/Half_right_mask.png','glow_mask/Back_View/Sleeves/Half_right_hi.png','glow_mask/Folded_View/Sleeves/Shirt_Halfsleeves_Folded_shad.png','glow_mask/Folded_View/Sleeves/Shirt_Halfsleeves_Folded_mask.png','glow_mask/Folded_View/Sleeves/Shirt_Halfsleeves_Folded_hi.png',1),(3,'Rollup','icon-Rollup',1.00,'1','0','glow_mask/Front_View/Sleeves/Rollup_Left_shad.png','glow_mask/Front_View/Sleeves/Rollup_Left_mask.png','glow_mask/Front_View/Sleeves/Rollup_Left_hi.png','glow_mask/Front_View/Sleeves/Rollup_Right_shad.png','glow_mask/Front_View/Sleeves/Rollup_Right_mask.png','glow_mask/Front_View/Sleeves/Rollup_Right_hi.png','glow_mask/Side_View/Sleeves/Rollup_Left_shad.png','glow_mask/Side_View/Sleeves/Rollup_Left_mask.png','glow_mask/Side_View/Sleeves/Rollup_Left_hi.png','glow_mask/Side_View/Sleeves/Rollup_Right_shad.png','glow_mask/Side_View/Sleeves/Rollup_Right_mask.png','glow_mask/Side_View/Sleeves/Rollup_Right_hi.png','glow_mask/Back_View/Sleeves/Rollup_left_shad.png','glow_mask/Back_View/Sleeves/Rollup_left_mask.png','glow_mask/Back_View/Sleeves/Rollup_left_hi.png','glow_mask/Back_View/Sleeves/Rollup_right_shad.png','glow_mask/Back_View/Sleeves/Rollup_right_mask.png','glow_mask/Back_View/Sleeves/Rollup_right_hi.png','','','',0);

--
-- Table structure for table `shirtstyle`
--

CREATE TABLE `shirtstyle` (
  `shirtstyle_id` int unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `class` varchar(200) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `thumb` varchar(200) DEFAULT NULL,
  `view1_glow_left_image` varchar(255) DEFAULT NULL,
  `view1_mask_left_image` varchar(255) DEFAULT NULL,
  `view1_highlighted_left_image` varchar(255) DEFAULT NULL,
  `view1_glow_right_image` varchar(255) DEFAULT NULL,
  `view1_mask_right_image` varchar(255) DEFAULT NULL,
  `view1_highlighted_right_image` varchar(255) DEFAULT NULL,
  `view2_glow_left_image` varchar(255) DEFAULT NULL,
  `view2_mask_left_image` varchar(255) DEFAULT NULL,
  `view2_highlighted_left_image` varchar(255) DEFAULT NULL,
  `view2_glow_right_image` varchar(255) DEFAULT NULL,
  `view2_mask_right_image` varchar(255) DEFAULT NULL,
  `view2_highlighted_right_image` varchar(255) DEFAULT NULL,
  `view3_glow_back_image` varchar(255) DEFAULT NULL,
  `view3_mask_back_image` varchar(255) DEFAULT NULL,
  `view3_highlighted_back_image` varchar(255) DEFAULT NULL,
  `view4_glow_left_image` varchar(255) DEFAULT NULL,
  `view4_mask_left_image` varchar(255) DEFAULT NULL,
  `view4_highlighted_left_image` varchar(255) DEFAULT NULL,
  `view4_glow_right_image` varchar(255) DEFAULT NULL,
  `view4_mask_right_image` varchar(255) DEFAULT NULL,
  `view4_highlighted_right_image` varchar(255) DEFAULT NULL,
  `view5_glow_left_image` varchar(255) DEFAULT NULL,
  `view5_mask_left_image` varchar(255) DEFAULT NULL,
  `view5_highlighted_left_image` varchar(255) DEFAULT NULL,
  `view5_glow_right_image` varchar(255) DEFAULT NULL,
  `view5_mask_right_image` varchar(255) DEFAULT NULL,
  `view5_highlighted_right_image` varchar(255) DEFAULT NULL,
  `view1_casual_glow_left_image` varchar(255) DEFAULT NULL,
  `view1_casual_mask_left_image` varchar(255) DEFAULT NULL,
  `view1_casual_highlighted_left_image` varchar(255) DEFAULT NULL,
  `view1_casual_glow_right_image` varchar(255) DEFAULT NULL,
  `view1_casual_mask_right_image` varchar(255) DEFAULT NULL,
  `view1_casual_highlighted_right_image` varchar(255) DEFAULT NULL,
  `view2_casual_glow_left_image` varchar(255) DEFAULT NULL,
  `view2_casual_mask_left_image` varchar(255) DEFAULT NULL,
  `view2_casual_highlighted_left_image` varchar(255) DEFAULT NULL,
  `view2_casual_glow_right_image` varchar(255) DEFAULT NULL,
  `view2_casual_mask_right_image` varchar(255) DEFAULT NULL,
  `view2_casual_highlighted_right_image` varchar(255) DEFAULT NULL,
  `view4_glow_inner_image` varchar(200) DEFAULT NULL,
  `view4_mask_inner_image` varchar(200) DEFAULT NULL,
  `view4_highlighted_inner_image` varchar(200) DEFAULT NULL,
  `view5_glow_inner_image` varchar(255) DEFAULT NULL,
  `view5_mask_inner_image` varchar(255) DEFAULT NULL,
  `view5_highlighted_inner_image` varchar(255) DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`shirtstyle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shirtstyle`
--

INSERT INTO `shirtstyle` VALUES (1,'Rounded collar','icon-collar_rounded',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_Roundedcollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Roundedcollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Roundedcollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Roundedcollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Roundedcollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Roundedcollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Roundedcollar_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Roundedcollar_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Roundedcollar_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Roundedcollar_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Roundedcollar_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Roundedcollar_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Roundedcollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Roundedcollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Roundedcollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Roundedcollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Roundedcollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Roundedcollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/RoundedCollar_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/RoundedCollar_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/RoundedCollar_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/RoundedCollar_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/RoundedCollar_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/RoundedCollar_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Rounded_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Rounded_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Rounded_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Rounded_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Rounded_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Rounded_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Rounded_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Rounded_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Rounded_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Rounded_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Rounded_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Rounded_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,0,'2017-01-26 06:12:53','2019-11-29 10:05:15'),(2,'Button down collar','shirt-lib-2-button_dowin',0.00,'1','glow_mask/style/Style_1_button_Single_breasted.png','glow_mask/Front_View/Collar_Styles/Shirt_Buttondowncollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Buttondowncollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Buttondowncollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Buttondowncollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Buttondowncollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Buttondowncollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Buttondowncollar_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Buttondowncollar_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Buttondowncollar_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Buttondowncollar_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Buttondowncollar_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Buttondowncollar_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Buttondowncollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Buttondowncollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Buttondowncollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Buttondowncollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Buttondowncollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Buttondowncollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/ButtondownCollar_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/ButtondownCollar_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/ButtondownCollar_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/ButtondownCollar_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/ButtondownCollar_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/ButtondownCollar_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Buttondown_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Buttondown_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Buttondown_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Buttondown_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Buttondown_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Buttondown_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Buttondown_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Buttondown_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Buttondown_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Buttondown_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Buttondown_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Buttondown_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:11:50','2019-11-29 10:05:21'),(3,'Cutaway collar','icon-Collar_Cutaway',0.00,'2','glow_mask/style/Style_4_button_Double_breasted.png','glow_mask/Front_View/Collar_Styles/Shirt_Cutawaycollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Cutawaycollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Cutawaycollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Cutawaycollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Cutawaycollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Cutawaycollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Cutaway_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Cutaway_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Cutaway_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Cutaway_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Cutaway_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Cutaway_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Cutawaycollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Cutawaycollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Cutawaycollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Cutawaycollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Cutawaycollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Cutawaycollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/CutawayCollar_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/CutawayCollar_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/CutawayCollar_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/CutawayCollar_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/CutawayCollar_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/CutawayCollar_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Cutaway_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Cutaway_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Cutaway_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Cutaway_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Cutaway_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Cutaway_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Cutaway_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Cutaway_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Cutaway_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Cutaway_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Cutaway_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Cutaway_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,0,'2017-02-01 07:50:06','2019-11-29 10:05:28'),(4,'Kent collar','shirt-lib-2-strenght_kent',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_Kentcollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Kentcollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Kentcollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Kentcollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Kentcollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Kentcollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Kent_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Kent_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Kent_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Kent_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Kent_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Kent_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Kentcollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Kentcollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Kentcollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Kentcollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Kentcollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Kentcollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/KentCollar_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/KentCollar_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/KentCollar_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/KentCollar_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/KentCollar_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/KentCollar_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Kent_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Kent_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Kent_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Kent_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Kent_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Kent_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Kent_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Kent_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Kent_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Kent_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Kent_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Kent_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:05:35'),(5,'Long collar','icon-Collar_Long',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_Longcollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Longcollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Longcollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Longcollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Longcollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Longcollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Longcollar_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Longcollar_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Longcollar_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Longcollar_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Longcollar_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Longcollar_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Longcollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Longcollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Longcollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Longcollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Longcollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Longcollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/LongCollar_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/LongCollar_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/LongCollar_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/LongCollar_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/LongCollar_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/LongCollar_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Longcollar_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Longcollar_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Longcollar_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Longcollar_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Longcollar_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Longcollar_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Long_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Long_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Long_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Long_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Long_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Long_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,0,'2017-01-26 06:12:53','2019-11-29 10:05:42'),(6,'Pinned collar','shirt-lib-2-pinned_collar',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_Pinnedcollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Pinnedcollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Pinnedcollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Pinnedcollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Pinnedcollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Pinnedcollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Pinnedcollar_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Pinnedcollar_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Pinnedcollar_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Pinnedcollar_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Pinnedcollar_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Pinnedcollar_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Pinnedcollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Pinnedcollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Pinnedcollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Pinnedcollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Pinnedcollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Pinnedcollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/Pinned_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/Pinned_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/Pinned_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/Pinned_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/Pinned_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/Pinned_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Pinned_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Pinned_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Pinned_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Pinned_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Pinned_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Pinned_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Pinned_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Pinned_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Pinned_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Pinned_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Pinned_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Pinned_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:06:04'),(7,'Hai collar','shirt-lib-2-hai_collar',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_ShortClassic_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_ShortClassic_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_ShortClassic_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_ShortClassic_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_ShortClassic_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_ShortClassic_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Shortclassiccollar_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Shortclassiccollar_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Shortclassiccollar_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Shortclassiccollar_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Shortclassiccollar_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Shortclassiccollar_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Shortclassiccollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Shortclassiccollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Shortclassiccollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Shortclassiccollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Shortclassiccollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Shortclassiccollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/ClassicShortCollar_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/ClassicShortCollar_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/ClassicShortCollar_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/ClassicShortCollar_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/ClassicShortCollar_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/ClassicShortCollar_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_ShortClassic_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_ShortClassic_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_ShortClassic_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_ShortClassic_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_ShortClassic_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_ShortClassic_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Short_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Short_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Short_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Short_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Short_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Short_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:06:10'),(8,'Band collar','shirt-lib-2-band_collar',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_Standupcollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Standupcollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Standupcollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Standupcollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Standupcollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Standupcollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Standupcollar_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Standupcollar_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Standupcollar_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Standupcollar_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Standupcollar_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Standupcollar_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Standupcollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Standupcollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Standupcollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Standupcollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Standupcollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Standupcollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/CollarBase_Left_Shad.png','glow_mask/Zoom_View/Collar_Styles/CollarBase_Left_Mask.png','glow_mask/Zoom_View/Collar_Styles/CollarBase_Left_Hi.png','glow_mask/Zoom_View/Collar_Styles/CollarBase_Right_Shad.png','glow_mask/Zoom_View/Collar_Styles/CollarBase_Right_Mask.png','glow_mask/Zoom_View/Collar_Styles/CollarBase_Right_Hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Standup_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Standup_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Standup_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Standup_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Standup_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Standup_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Standup_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Standup_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Standup_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Standup_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Standup_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Standup_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:06:16'),(9,'Wide Cutaway','icon-collar_Wide_Cutaway',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_Widecutawaycollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Widecutawaycollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Widecutawaycollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Widecutawaycollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Widecutawaycollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Widecutawaycollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Widecutaway_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Widecutaway_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Widecutaway_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Widecutaway_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Widecutaway_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Widecutaway_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Widecutawaycollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Widecutawaycollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Widecutawaycollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Widecutawaycollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Widecutawaycollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Widecutawaycollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/WideCutawayCollar_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/WideCutawayCollar_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/WideCutawayCollar_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/WideCutawayCollar_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/WideCutawayCollar_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/WideCutawayCollar_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Widecutaway_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Widecutaway_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Widecutaway_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Widecutaway_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Widecutaway_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Widecutaway_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Widecutaway_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Widecutaway_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Widecutaway_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Widecutaway_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Widecutaway_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Widecutaway_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,0,'2017-01-26 06:12:53','2019-11-29 10:06:24'),(10,'Wing collar','shirt-lib-2-wing_collar',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_Wingcollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Wingcollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Wingcollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_Wingcollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_Wingcollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_Wingcollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Wingedcollar_Side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Wingedcollar_Side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Wingedcollar_Side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_Wingedcollar_Side_Right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_Wingedcollar_Side_Right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_Wingedcollar_Side_Right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_Wingcollar_Folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Wingcollar_Folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Wingcollar_Folded_Left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_Wingcollar_Folded_Right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_Wingcollar_Folded_Right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_Wingcollar_Folded_Right_hi.png','glow_mask/Zoom_View/Collar_Styles/WingCollar_Left_shad.png','glow_mask/Zoom_View/Collar_Styles/WingCollar_Left_mask.png','glow_mask/Zoom_View/Collar_Styles/WingCollar_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/WingCollar_Right_shad.png','glow_mask/Zoom_View/Collar_Styles/WingCollar_Right_mask.png','glow_mask/Zoom_View/Collar_Styles/WingCollar_Right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:06:31'),(11,'Tab collar','shirt-lib-2-tab_collar',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_tabcollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_tabcollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_tabcollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_tabcollar_Front_right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_tabcollar_Front_right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_tabcollar_Front_right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_tabcollar_side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_tabcollar_side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_tabcollar_side_Left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_tabcollar_side_right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_tabcollar_side_right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_tabcollar_side_right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_tabcollar_folded_right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_tabcollar_folded_right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_tabcollar_folded_right_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_tabcollar_folded_Left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_tabcollar_folded_Left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_tabcollar_folded_Left_hi.png','glow_mask/Zoom_View/Collar_Styles/Shirt_tabcollar_zoom_left_shad.png','glow_mask/Zoom_View/Collar_Styles/Shirt_tabcollar_zoom_left_mask.png','glow_mask/Zoom_View/Collar_Styles/Shirt_tabcollar_zoom_left_hi.png','glow_mask/Zoom_View/Collar_Styles/Shirt_tabcollar_zoom_right_shad.png','glow_mask/Zoom_View/Collar_Styles/Shirt_tabcollar_zoom_right_mask.png','glow_mask/Zoom_View/Collar_Styles/Shirt_tabcollar_zoom_right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:06:38'),(12,'Imperial collar','shirt-lib-2-imperial_collar',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_imperialcollar_Front_left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_imperialcollar_Front_left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_imperialcollar_Front_left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_imperialcollar_Front_right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_imperialcollar_Front_right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_imperialcollar_Front_right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_imperialcollar_side_left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_imperialcollar_side_left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_imperialcollar_side_left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_imperialcollar_side_right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_imperialcollar_side_right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_imperialcollar_side_right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_imperialcollar_folded_left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_imperialcollar_folded_left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_imperialcollar_folded_left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_imperialcollar_folded_right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_imperialcollar_folded_right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_imperialcollar_folded_right_hi.png','glow_mask/Zoom_View/Collar_Styles/Shirt_imperialcollar_zoom_left_shad.png','glow_mask/Zoom_View/Collar_Styles/Shirt_imperialcollar_zoom_left_mask.png','glow_mask/Zoom_View/Collar_Styles/Shirt_imperialcollar_zoom_left_hi.png','glow_mask/Zoom_View/Collar_Styles/Shirt_imperialcollar_zoom_right_shad.png','glow_mask/Zoom_View/Collar_Styles/Shirt_imperialcollar_zoom_right_mask.png','glow_mask/Zoom_View/Collar_Styles/Shirt_imperialcollar_zoom_right_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:06:44'),(13,'Italian collar','shirt-lib-2-Italian_collar',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/Shirt_italiancollar_Front_Left_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_italiancollar_Front_Left_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_italiancollar_Front_Left_hi.png','glow_mask/Front_View/Collar_Styles/Shirt_italiancollar_Front_Right_shad.png','glow_mask/Front_View/Collar_Styles/Shirt_italiancollar_Front_Right_mask.png','glow_mask/Front_View/Collar_Styles/Shirt_italiancollar_Front_Right_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_italiancollar_side_Left_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_italiancollar_side_Left_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_imperialcollar_side_left_hi.png','glow_mask/Side_View/Collar_Styles/Shirt_italiancollar_side_right_shad.png','glow_mask/Side_View/Collar_Styles/Shirt_italiancollar_side_right_mask.png','glow_mask/Side_View/Collar_Styles/Shirt_italiancollar_side_right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/Shirt_italiancollar_folded_left_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_italiancollar_folded_left_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_italiancollar_folded_left_hi.png','glow_mask/Folded_View/Collar_Styles/Shirt_italiancollar_folded_right_shad.png','glow_mask/Folded_View/Collar_Styles/Shirt_italiancollar_folded_right_mask.png','glow_mask/Folded_View/Collar_Styles/Shirt_italiancollar_folded_right_hi.png','glow_mask/Zoom_View/Collar_Styles/Shirt_italiancollar_zoom_left_shad.png','glow_mask/Zoom_View/Collar_Styles/Shirt_italiancollar_zoom_left_mask.png','glow_mask/Zoom_View/Collar_Styles/Shirt_italiancollar_zoom_left_hi.png','glow_mask/Zoom_View/Collar_Styles/Shirt_italiancollar_zoom_right_shad.png','glow_mask/Zoom_View/Collar_Styles/Shirt_italiancollar_zoom_right_mask.png','glow_mask/Zoom_View/Collar_Styles/Shirt_italiancollar_zoom_right_hi.png','glow_mask/Front_View/Collar_Casual/Shirt_italiancollar_zoom_right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:06:52'),(14,'Hidden Button Down collar','shirt-lib-2-hidden_button',0.00,'0','glow_mask/style/Style_Mandarin.png','glow_mask/Front_View/Collar_Styles/hidden_button_down_front_left_shad.png','glow_mask/Front_View/Collar_Styles/hidden_button_down_front_left_mask.png','glow_mask/Front_View/Collar_Styles/hidden_button_down_front_left_hi.png','glow_mask/Front_View/Collar_Styles/hidden_button_down_front_right_shad.png','glow_mask/Front_View/Collar_Styles/hidden_button_down_front_right_mask.png','glow_mask/Front_View/Collar_Styles/hidden_button_down_front_right_hi.png','glow_mask/Side_View/Collar_Styles/hidden_button_down_side_left_shad.png','glow_mask/Side_View/Collar_Styles/hidden_button_down_side_left_mask.png','glow_mask/Side_View/Collar_Styles/hidden_button_down_side_left_hi.png','glow_mask/Side_View/Collar_Styles/hidden_button_down_side_right_shad.png','glow_mask/Side_View/Collar_Styles/hidden_button_down_side_right_mask.png','glow_mask/Side_View/Collar_Styles/hidden_button_down_side_right_hi.png',NULL,NULL,NULL,'glow_mask/Folded_View/Collar_Styles/hidden_button_down_folded_left_shad.png','glow_mask/Folded_View/Collar_Styles/hidden_button_down_folded_left_mask.png','glow_mask/Folded_View/Collar_Styles/hidden_button_down_folded_left_hi.png','glow_mask/Folded_View/Collar_Styles/hidden_button_down_folded_right_shad.png','glow_mask/Folded_View/Collar_Styles/hidden_button_down_folded_right_mask.png','glow_mask/Folded_View/Collar_Styles/hidden_button_down_folded_right_hi.png','glow_mask/Zoom_View/Collar_Styles/hidden_button_down_zoom_left_shad.png','glow_mask/Zoom_View/Collar_Styles/hidden_button_down_zoom_left_mask.png','glow_mask/Zoom_View/Collar_Styles/hidden_button_down_zoom_left_hi.png','glow_mask/Zoom_View/Collar_Styles/hidden_button_down_zoom_right_shad.png','glow_mask/Zoom_View/Collar_Styles/hidden_button_down_zoom_right_mask.png','glow_mask/Zoom_View/Collar_Styles/hidden_button_down_zoom_right_hi.png','glow_mask/Front_View/Collar_Casual/Shirt_italiancollar_zoom_right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Left_hi.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_shad.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_mask.png','glow_mask/Front_View/Collar_Casual/Casual-Bust_Front_Winged_Right_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Left_hi.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_shad.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_mask.png','glow_mask/Side_View/Collar_Casual/Casual-Bust_Side_Wing_Right_hi.png',NULL,NULL,NULL,NULL,NULL,NULL,1,'2017-01-26 06:12:53','2019-11-29 10:06:58');

--
