-- 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int(11) DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `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=utf8 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(5) 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=utf8 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(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Default',
  `visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Visible on front',
  PRIMARY KEY (`status`,`state`),
  CONSTRAINT `SALES_ORDER_STATUS_STATE_STATUS_SALES_ORDER_STATUS_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `percent` decimal(12,4) DEFAULT NULL COMMENT 'Percent',
  `amount` decimal(20,4) DEFAULT NULL COMMENT 'Amount',
  `priority` int(11) NOT NULL COMMENT 'Priority',
  `position` int(11) NOT NULL COMMENT 'Position',
  `base_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount',
  `process` smallint(6) NOT NULL COMMENT 'Process',
  `base_real_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Real Amount',
  PRIMARY KEY (`tax_id`),
  KEY `SALES_ORDER_TAX_ORDER_ID_PRIORITY_POSITION` (`order_id`,`priority`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax Item ID',
  `tax_id` int(10) unsigned NOT NULL COMMENT 'Tax ID',
  `item_id` int(10) unsigned DEFAULT NULL COMMENT 'Item ID',
  `tax_percent` decimal(12,4) NOT NULL COMMENT 'Real Tax Percent For Item',
  `amount` decimal(20,4) NOT NULL COMMENT 'Tax amount for the item and tax rate',
  `base_amount` decimal(20,4) NOT NULL COMMENT 'Base tax amount for the item and tax rate',
  `real_amount` decimal(20,4) NOT NULL COMMENT 'Real tax amount for the item and tax rate',
  `real_base_amount` decimal(20,4) NOT NULL COMMENT 'Real base tax amount for the item and tax rate',
  `associated_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Id of the associated item',
  `taxable_item_type` varchar(32) NOT NULL COMMENT 'Type of the taxable item',
  PRIMARY KEY (`tax_item_id`),
  UNIQUE KEY `SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID` (`tax_id`,`item_id`),
  KEY `SALES_ORDER_TAX_ITEM_ITEM_ID` (`item_id`),
  KEY `SALES_ORDER_TAX_ITEM_ASSOCIATED_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` (`associated_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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Transaction ID',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent ID',
  `order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order ID',
  `payment_id` int(10) 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(5) 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
  `online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
  `offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_REFUNDED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_REFUNDED_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_REFUNDED_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
  `online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
  `offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_REFUNDED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `entity_type` varchar(32) NOT NULL COMMENT 'Prefix',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `sequence_table` varchar(64) NOT NULL COMMENT 'table for sequence',
  PRIMARY KEY (`meta_id`),
  UNIQUE KEY `SALES_SEQUENCE_META_ENTITY_TYPE_STORE_ID` (`entity_type`,`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8 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'),(9,'order',2,'sequence_order_2'),(10,'invoice',2,'sequence_invoice_2'),(11,'creditmemo',2,'sequence_creditmemo_2'),(12,'shipment',2,'sequence_shipment_2'),(13,'order',3,'sequence_order_3'),(14,'invoice',3,'sequence_invoice_3'),(15,'creditmemo',3,'sequence_creditmemo_3'),(16,'shipment',3,'sequence_shipment_3'),(17,'order',4,'sequence_order_4'),(18,'invoice',4,'sequence_invoice_4'),(19,'creditmemo',4,'sequence_creditmemo_4'),(20,'shipment',4,'sequence_shipment_4'),(21,'order',5,'sequence_order_5'),(22,'invoice',5,'sequence_invoice_5'),(23,'creditmemo',5,'sequence_creditmemo_5'),(24,'shipment',5,'sequence_shipment_5'),(25,'order',6,'sequence_order_6'),(26,'invoice',6,'sequence_invoice_6'),(27,'creditmemo',6,'sequence_creditmemo_6'),(28,'shipment',6,'sequence_shipment_6'),(29,'order',7,'sequence_order_7'),(30,'invoice',7,'sequence_invoice_7'),(31,'creditmemo',7,'sequence_creditmemo_7'),(32,'shipment',7,'sequence_shipment_7'),(33,'order',8,'sequence_order_8'),(34,'invoice',8,'sequence_invoice_8'),(35,'creditmemo',8,'sequence_creditmemo_8'),(36,'shipment',8,'sequence_shipment_8'),(37,'order',9,'sequence_order_9'),(38,'invoice',9,'sequence_invoice_9'),(39,'creditmemo',9,'sequence_creditmemo_9'),(40,'shipment',9,'sequence_shipment_9'),(41,'order',10,'sequence_order_10'),(42,'invoice',10,'sequence_invoice_10'),(43,'creditmemo',10,'sequence_creditmemo_10'),(44,'shipment',10,'sequence_shipment_10'),(45,'order',11,'sequence_order_11'),(46,'invoice',11,'sequence_invoice_11'),(47,'creditmemo',11,'sequence_creditmemo_11'),(48,'shipment',11,'sequence_shipment_11'),(49,'order',12,'sequence_order_12'),(50,'invoice',12,'sequence_invoice_12'),(51,'creditmemo',12,'sequence_creditmemo_12'),(52,'shipment',12,'sequence_shipment_12'),(53,'order',13,'sequence_order_13'),(54,'invoice',13,'sequence_invoice_13'),(55,'creditmemo',13,'sequence_creditmemo_13'),(56,'shipment',13,'sequence_shipment_13'),(57,'order',14,'sequence_order_14'),(58,'invoice',14,'sequence_invoice_14'),(59,'creditmemo',14,'sequence_creditmemo_14'),(60,'shipment',14,'sequence_shipment_14'),(61,'order',15,'sequence_order_15'),(62,'invoice',15,'sequence_invoice_15'),(63,'creditmemo',15,'sequence_creditmemo_15'),(64,'shipment',15,'sequence_shipment_15'),(65,'order',16,'sequence_order_16'),(66,'invoice',16,'sequence_invoice_16'),(67,'creditmemo',16,'sequence_creditmemo_16'),(68,'shipment',16,'sequence_shipment_16'),(69,'order',17,'sequence_order_17'),(70,'invoice',17,'sequence_invoice_17'),(71,'creditmemo',17,'sequence_creditmemo_17'),(72,'shipment',17,'sequence_shipment_17'),(73,'order',18,'sequence_order_18'),(74,'invoice',18,'sequence_invoice_18'),(75,'creditmemo',18,'sequence_creditmemo_18'),(76,'shipment',18,'sequence_shipment_18'),(77,'order',20,'sequence_order_20'),(78,'invoice',20,'sequence_invoice_20'),(79,'creditmemo',20,'sequence_creditmemo_20'),(80,'shipment',20,'sequence_shipment_20'),(81,'order',21,'sequence_order_21'),(82,'invoice',21,'sequence_invoice_21'),(83,'creditmemo',21,'sequence_creditmemo_21'),(84,'shipment',21,'sequence_shipment_21'),(85,'order',22,'sequence_order_22'),(86,'invoice',22,'sequence_invoice_22'),(87,'creditmemo',22,'sequence_creditmemo_22'),(88,'shipment',22,'sequence_shipment_22'),(89,'order',23,'sequence_order_23'),(90,'invoice',23,'sequence_invoice_23'),(91,'creditmemo',23,'sequence_creditmemo_23'),(92,'shipment',23,'sequence_shipment_23'),(93,'order',24,'sequence_order_24'),(94,'invoice',24,'sequence_invoice_24'),(95,'creditmemo',24,'sequence_creditmemo_24'),(96,'shipment',24,'sequence_shipment_24'),(97,'order',25,'sequence_order_25'),(98,'invoice',25,'sequence_invoice_25'),(99,'creditmemo',25,'sequence_creditmemo_25'),(100,'shipment',25,'sequence_shipment_25'),(101,'order',26,'sequence_order_26'),(102,'invoice',26,'sequence_invoice_26'),(103,'creditmemo',26,'sequence_creditmemo_26'),(104,'shipment',26,'sequence_shipment_26'),(105,'order',27,'sequence_order_27'),(106,'invoice',27,'sequence_invoice_27'),(107,'creditmemo',27,'sequence_creditmemo_27'),(108,'shipment',27,'sequence_shipment_27'),(109,'order',28,'sequence_order_28'),(110,'invoice',28,'sequence_invoice_28'),(111,'creditmemo',28,'sequence_creditmemo_28'),(112,'shipment',28,'sequence_shipment_28'),(113,'order',29,'sequence_order_29'),(114,'invoice',29,'sequence_invoice_29'),(115,'creditmemo',29,'sequence_creditmemo_29'),(116,'shipment',29,'sequence_shipment_29'),(117,'order',30,'sequence_order_30'),(118,'invoice',30,'sequence_invoice_30'),(119,'creditmemo',30,'sequence_creditmemo_30'),(120,'shipment',30,'sequence_shipment_30'),(121,'order',31,'sequence_order_31'),(122,'invoice',31,'sequence_invoice_31'),(123,'creditmemo',31,'sequence_creditmemo_31'),(124,'shipment',31,'sequence_shipment_31'),(125,'order',32,'sequence_order_32'),(126,'invoice',32,'sequence_invoice_32'),(127,'creditmemo',32,'sequence_creditmemo_32'),(128,'shipment',32,'sequence_shipment_32'),(129,'order',33,'sequence_order_33'),(130,'invoice',33,'sequence_invoice_33'),(131,'creditmemo',33,'sequence_creditmemo_33'),(132,'shipment',33,'sequence_shipment_33'),(133,'order',34,'sequence_order_34'),(134,'invoice',34,'sequence_invoice_34'),(135,'creditmemo',34,'sequence_creditmemo_34'),(136,'shipment',34,'sequence_shipment_34'),(137,'order',35,'sequence_order_35'),(138,'invoice',35,'sequence_invoice_35'),(139,'creditmemo',35,'sequence_creditmemo_35'),(140,'shipment',35,'sequence_shipment_35'),(141,'order',36,'sequence_order_36'),(142,'invoice',36,'sequence_invoice_36'),(143,'creditmemo',36,'sequence_creditmemo_36'),(144,'shipment',36,'sequence_shipment_36'),(145,'order',37,'sequence_order_37'),(146,'invoice',37,'sequence_invoice_37'),(147,'creditmemo',37,'sequence_creditmemo_37'),(148,'shipment',37,'sequence_shipment_37'),(149,'order',38,'sequence_order_38'),(150,'invoice',38,'sequence_invoice_38'),(151,'creditmemo',38,'sequence_creditmemo_38'),(152,'shipment',38,'sequence_shipment_38'),(153,'order',39,'sequence_order_39'),(154,'invoice',39,'sequence_invoice_39'),(155,'creditmemo',39,'sequence_creditmemo_39'),(156,'shipment',39,'sequence_shipment_39'),(157,'order',40,'sequence_order_40'),(158,'invoice',40,'sequence_invoice_40'),(159,'creditmemo',40,'sequence_creditmemo_40'),(160,'shipment',40,'sequence_shipment_40'),(161,'order',41,'sequence_order_41'),(162,'invoice',41,'sequence_invoice_41'),(163,'creditmemo',41,'sequence_creditmemo_41'),(164,'shipment',41,'sequence_shipment_41');

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

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

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

INSERT INTO `sales_sequence_profile` VALUES (1,1,NULL,NULL,1,1,0,0,1),(2,2,NULL,NULL,1,1,0,0,1),(3,3,NULL,NULL,1,1,0,0,1),(4,4,NULL,NULL,1,1,0,0,1),(5,5,NULL,NULL,1,1,0,0,1),(6,6,NULL,NULL,1,1,0,0,1),(7,7,NULL,NULL,1,1,0,0,1),(8,8,NULL,NULL,1,1,0,0,1),(9,9,'2',NULL,1,1,0,0,1),(10,10,'2',NULL,1,1,0,0,1),(11,11,'2',NULL,1,1,0,0,1),(12,12,'2',NULL,1,1,0,0,1),(13,13,'3',NULL,1,1,0,0,1),(14,14,'3',NULL,1,1,0,0,1),(15,15,'3',NULL,1,1,0,0,1),(16,16,'3',NULL,1,1,0,0,1),(17,17,'4',NULL,1,1,0,0,1),(18,18,'4',NULL,1,1,0,0,1),(19,19,'4',NULL,1,1,0,0,1),(20,20,'4',NULL,1,1,0,0,1),(21,21,'5',NULL,1,1,0,0,1),(22,22,'5',NULL,1,1,0,0,1),(23,23,'5',NULL,1,1,0,0,1),(24,24,'5',NULL,1,1,0,0,1),(25,25,'6',NULL,1,1,0,0,1),(26,26,'6',NULL,1,1,0,0,1),(27,27,'6',NULL,1,1,0,0,1),(28,28,'6',NULL,1,1,0,0,1),(29,29,'7',NULL,1,1,0,0,1),(30,30,'7',NULL,1,1,0,0,1),(31,31,'7',NULL,1,1,0,0,1),(32,32,'7',NULL,1,1,0,0,1),(33,33,'8',NULL,1,1,0,0,1),(34,34,'8',NULL,1,1,0,0,1),(35,35,'8',NULL,1,1,0,0,1),(36,36,'8',NULL,1,1,0,0,1),(37,37,'9',NULL,1,1,0,0,1),(38,38,'9',NULL,1,1,0,0,1),(39,39,'9',NULL,1,1,0,0,1),(40,40,'9',NULL,1,1,0,0,1),(41,41,'10',NULL,1,1,0,0,1),(42,42,'10',NULL,1,1,0,0,1),(43,43,'10',NULL,1,1,0,0,1),(44,44,'10',NULL,1,1,0,0,1),(45,45,'11',NULL,1,1,0,0,1),(46,46,'11',NULL,1,1,0,0,1),(47,47,'11',NULL,1,1,0,0,1),(48,48,'11',NULL,1,1,0,0,1),(49,49,'12',NULL,1,1,0,0,1),(50,50,'12',NULL,1,1,0,0,1),(51,51,'12',NULL,1,1,0,0,1),(52,52,'12',NULL,1,1,0,0,1),(53,53,'13',NULL,1,1,0,0,1),(54,54,'13',NULL,1,1,0,0,1),(55,55,'13',NULL,1,1,0,0,1),(56,56,'13',NULL,1,1,0,0,1),(57,57,'14',NULL,1,1,0,0,1),(58,58,'14',NULL,1,1,0,0,1),(59,59,'14',NULL,1,1,0,0,1),(60,60,'14',NULL,1,1,0,0,1),(61,61,'15',NULL,1,1,0,0,1),(62,62,'15',NULL,1,1,0,0,1),(63,63,'15',NULL,1,1,0,0,1),(64,64,'15',NULL,1,1,0,0,1),(65,65,'16',NULL,1,1,0,0,1),(66,66,'16',NULL,1,1,0,0,1),(67,67,'16',NULL,1,1,0,0,1),(68,68,'16',NULL,1,1,0,0,1),(69,69,'17',NULL,1,1,0,0,1),(70,70,'17',NULL,1,1,0,0,1),(71,71,'17',NULL,1,1,0,0,1),(72,72,'17',NULL,1,1,0,0,1),(73,73,'18',NULL,1,1,0,0,1),(74,74,'18',NULL,1,1,0,0,1),(75,75,'18',NULL,1,1,0,0,1),(76,76,'18',NULL,1,1,0,0,1),(77,77,'20',NULL,1,1,0,0,1),(78,78,'20',NULL,1,1,0,0,1),(79,79,'20',NULL,1,1,0,0,1),(80,80,'20',NULL,1,1,0,0,1),(81,81,'21',NULL,1,1,0,0,1),(82,82,'21',NULL,1,1,0,0,1),(83,83,'21',NULL,1,1,0,0,1),(84,84,'21',NULL,1,1,0,0,1),(85,85,'22',NULL,1,1,0,0,1),(86,86,'22',NULL,1,1,0,0,1),(87,87,'22',NULL,1,1,0,0,1),(88,88,'22',NULL,1,1,0,0,1),(89,89,'23',NULL,1,1,0,0,1),(90,90,'23',NULL,1,1,0,0,1),(91,91,'23',NULL,1,1,0,0,1),(92,92,'23',NULL,1,1,0,0,1),(93,93,'24',NULL,1,1,0,0,1),(94,94,'24',NULL,1,1,0,0,1),(95,95,'24',NULL,1,1,0,0,1),(96,96,'24',NULL,1,1,0,0,1),(97,97,'25',NULL,1,1,0,0,1),(98,98,'25',NULL,1,1,0,0,1),(99,99,'25',NULL,1,1,0,0,1),(100,100,'25',NULL,1,1,0,0,1),(101,101,'26',NULL,1,1,0,0,1),(102,102,'26',NULL,1,1,0,0,1),(103,103,'26',NULL,1,1,0,0,1),(104,104,'26',NULL,1,1,0,0,1),(105,105,'27',NULL,1,1,0,0,1),(106,106,'27',NULL,1,1,0,0,1),(107,107,'27',NULL,1,1,0,0,1),(108,108,'27',NULL,1,1,0,0,1),(109,109,'28',NULL,1,1,0,0,1),(110,110,'28',NULL,1,1,0,0,1),(111,111,'28',NULL,1,1,0,0,1),(112,112,'28',NULL,1,1,0,0,1),(113,113,'29',NULL,1,1,0,0,1),(114,114,'29',NULL,1,1,0,0,1),(115,115,'29',NULL,1,1,0,0,1),(116,116,'29',NULL,1,1,0,0,1),(117,117,'30',NULL,1,1,4294967295,4294966295,1),(118,118,'30',NULL,1,1,4294967295,4294966295,1),(119,119,'30',NULL,1,1,4294967295,4294966295,1),(120,120,'30',NULL,1,1,4294967295,4294966295,1),(121,121,'31',NULL,1,1,4294967295,4294966295,1),(122,122,'31',NULL,1,1,4294967295,4294966295,1),(123,123,'31',NULL,1,1,4294967295,4294966295,1),(124,124,'31',NULL,1,1,4294967295,4294966295,1),(125,125,'32',NULL,1,1,4294967295,4294966295,1),(126,126,'32',NULL,1,1,4294967295,4294966295,1),(127,127,'32',NULL,1,1,4294967295,4294966295,1),(128,128,'32',NULL,1,1,4294967295,4294966295,1),(129,129,'33',NULL,1,1,4294967295,4294966295,1),(130,130,'33',NULL,1,1,4294967295,4294966295,1),(131,131,'33',NULL,1,1,4294967295,4294966295,1),(132,132,'33',NULL,1,1,4294967295,4294966295,1),(133,133,'34',NULL,1,1,4294967295,4294966295,1),(134,134,'34',NULL,1,1,4294967295,4294966295,1),(135,135,'34',NULL,1,1,4294967295,4294966295,1),(136,136,'34',NULL,1,1,4294967295,4294966295,1),(137,137,'35',NULL,1,1,4294967295,4294966295,1),(138,138,'35',NULL,1,1,4294967295,4294966295,1),(139,139,'35',NULL,1,1,4294967295,4294966295,1),(140,140,'35',NULL,1,1,4294967295,4294966295,1),(141,141,'36',NULL,1,1,4294967295,4294966295,1),(142,142,'36',NULL,1,1,4294967295,4294966295,1),(143,143,'36',NULL,1,1,4294967295,4294966295,1),(144,144,'36',NULL,1,1,4294967295,4294966295,1),(145,145,'37',NULL,1,1,4294967295,4294966295,1),(146,146,'37',NULL,1,1,4294967295,4294966295,1),(147,147,'37',NULL,1,1,4294967295,4294966295,1),(148,148,'37',NULL,1,1,4294967295,4294966295,1),(149,149,'38',NULL,1,1,4294967295,4294966295,1),(150,150,'38',NULL,1,1,4294967295,4294966295,1),(151,151,'38',NULL,1,1,4294967295,4294966295,1),(152,152,'38',NULL,1,1,4294967295,4294966295,1),(153,153,'39',NULL,1,1,4294967295,4294966295,1),(154,154,'39',NULL,1,1,4294967295,4294966295,1),(155,155,'39',NULL,1,1,4294967295,4294966295,1),(156,156,'39',NULL,1,1,4294967295,4294966295,1),(157,157,'40',NULL,1,1,4294967295,4294966295,1),(158,158,'40',NULL,1,1,4294967295,4294966295,1),(159,159,'40',NULL,1,1,4294967295,4294966295,1),(160,160,'40',NULL,1,1,4294967295,4294966295,1),(161,161,'41',NULL,1,1,4294967295,4294966295,1),(162,162,'41',NULL,1,1,4294967295,4294966295,1),(163,163,'41',NULL,1,1,4294967295,4294966295,1),(164,164,'41',NULL,1,1,4294967295,4294966295,1);

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

CREATE TABLE `sales_shipment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `total_weight` decimal(12,4) DEFAULT NULL COMMENT 'Total Weight',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `shipment_status` int(11) DEFAULT NULL COMMENT 'Shipment Status',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `packages` text COMMENT 'Packed Products in Packages',
  `shipping_label` mediumblob COMMENT 'Shipping Label Content',
  `customer_note` text COMMENT 'Customer Note',
  `customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_SHIPMENT_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_SHIPMENT_STORE_ID` (`store_id`),
  KEY `SALES_SHIPMENT_TOTAL_QTY` (`total_qty`),
  KEY `SALES_SHIPMENT_ORDER_ID` (`order_id`),
  KEY `SALES_SHIPMENT_CREATED_AT` (`created_at`),
  KEY `SALES_SHIPMENT_UPDATED_AT` (`updated_at`),
  KEY `SALES_SHIPMENT_SEND_EMAIL` (`send_email`),
  KEY `SALES_SHIPMENT_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_SHIPMENT_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_SHIPMENT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int(11) DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `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=utf8 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(10) unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_increment_id` varchar(32) NOT NULL COMMENT 'Order Increment ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Order Increment ID',
  `customer_name` varchar(128) NOT NULL COMMENT 'Customer Name',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `shipment_status` int(11) DEFAULT NULL COMMENT 'Shipment Status',
  `order_status` varchar(32) DEFAULT NULL COMMENT 'Order',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `billing_name` varchar(128) DEFAULT NULL COMMENT 'Billing Name',
  `shipping_name` varchar(128) DEFAULT NULL COMMENT 'Shipping Name',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` int(11) DEFAULT NULL,
  `payment_method` varchar(32) DEFAULT NULL COMMENT 'Payment Method',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_SHIPMENT_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_SHIPMENT_GRID_STORE_ID` (`store_id`),
  KEY `SALES_SHIPMENT_GRID_TOTAL_QTY` (`total_qty`),
  KEY `SALES_SHIPMENT_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `SALES_SHIPMENT_GRID_SHIPMENT_STATUS` (`shipment_status`),
  KEY `SALES_SHIPMENT_GRID_ORDER_STATUS` (`order_status`),
  KEY `SALES_SHIPMENT_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_SHIPMENT_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_SHIPMENT_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `SALES_SHIPMENT_GRID_SHIPPING_NAME` (`shipping_name`),
  KEY `SALES_SHIPMENT_GRID_BILLING_NAME` (`billing_name`),
  FULLTEXT KEY `FTI_086B40C8955F167B8EA76653437879B4` (`increment_id`,`order_increment_id`,`shipping_name`,`customer_name`,`customer_email`,`billing_address`,`shipping_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
  `price` decimal(20,4) DEFAULT NULL COMMENT 'Price',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `product_id` int(11) DEFAULT NULL COMMENT 'Product ID',
  `order_item_id` int(11) DEFAULT NULL COMMENT 'Order Item ID',
  `additional_data` text 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) 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(10) 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
  `total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_SHPP_AGGRED_PERIOD_STORE_ID_ORDER_STS_SHPP_DESCRIPTION` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `SALES_SHIPPING_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_SHIPPING_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
  `total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_C05FAE47282EEA68654D0924E946761F` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Shipping Aggregated Order';

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


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

CREATE TABLE `salesrule` (
  `rule_id` int(10) 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(11) NOT NULL DEFAULT '0' COMMENT 'Uses Per Customer',
  `is_active` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `conditions_serialized` mediumtext COMMENT 'Conditions Serialized',
  `actions_serialized` mediumtext COMMENT 'Actions Serialized',
  `stop_rules_processing` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Stop Rules Processing',
  `is_advanced` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Advanced',
  `product_ids` text COMMENT 'Product Ids',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `simple_action` varchar(32) DEFAULT NULL COMMENT 'Simple Action',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `discount_qty` decimal(12,4) DEFAULT NULL COMMENT 'Discount Qty',
  `discount_step` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Discount Step',
  `apply_to_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Apply To Shipping',
  `times_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  `is_rss` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Rss',
  `coupon_type` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Coupon Type',
  `use_auto_generation` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Use Auto Generation',
  `uses_per_coupon` int(11) NOT NULL DEFAULT '0' COMMENT 'User Per Coupon',
  `simple_free_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' 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=utf8 COMMENT='Salesrule';

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


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

CREATE TABLE `salesrule_coupon` (
  `coupon_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Coupon ID',
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `usage_limit` int(10) unsigned DEFAULT NULL COMMENT 'Usage Limit',
  `usage_per_customer` int(10) unsigned DEFAULT NULL COMMENT 'Usage Per Customer',
  `times_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  `expiration_date` datetime DEFAULT NULL COMMENT 'Expiration Date',
  `is_primary` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Primary',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Coupon Code Creation Date',
  `type` smallint(6) DEFAULT '0' COMMENT 'Coupon Code Type',
  `generated_by_dotmailer` smallint(6) DEFAULT NULL COMMENT '1 = Generated by dotmailer',
  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=utf8 COMMENT='Salesrule Coupon';

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


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

CREATE TABLE `salesrule_coupon_aggregated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) 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(11) 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) 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(11) 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) 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(11) 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=utf8 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(10) unsigned NOT NULL COMMENT 'Coupon ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `times_used` int(10) 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Customer ID',
  `rule_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Rule ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `times_used` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  PRIMARY KEY (`rule_customer_id`),
  KEY `SALESRULE_CUSTOMER_RULE_ID_CUSTOMER_ID` (`rule_id`,`customer_id`),
  KEY `SALESRULE_CUSTOMER_CUSTOMER_ID_RULE_ID` (`customer_id`,`rule_id`),
  CONSTRAINT `SALESRULE_CUSTOMER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_CUSTOMER_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Customer';

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


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

CREATE TABLE `salesrule_customer_group` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  PRIMARY KEY (`rule_id`,`customer_group_id`),
  KEY `SALESRULE_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `SALESRULE_CSTR_GROUP_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_CUSTOMER_GROUP_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label ID',
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `store_id` smallint(5) 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=utf8 COMMENT='Salesrule Label';

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


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

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

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


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

CREATE TABLE `salesrule_website` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`rule_id`,`website_id`),
  KEY `SALESRULE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `SALESRULE_WEBSITE_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Query ID',
  `query_text` varchar(255) DEFAULT NULL COMMENT 'Query text',
  `num_results` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Num results',
  `popularity` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Popularity',
  `redirect` varchar(255) DEFAULT NULL COMMENT 'Redirect',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `display_in_terms` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Display in terms',
  `is_active` smallint(6) DEFAULT '1' COMMENT 'Active status',
  `is_processed` smallint(6) DEFAULT '0' COMMENT 'Processed status',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated at',
  PRIMARY KEY (`query_id`),
  UNIQUE KEY `SEARCH_QUERY_QUERY_TEXT_STORE_ID` (`query_text`,`store_id`),
  KEY `SEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`,`store_id`,`popularity`),
  KEY `SEARCH_QUERY_STORE_ID` (`store_id`),
  KEY `SEARCH_QUERY_IS_PROCESSED` (`is_processed`),
  KEY `SEARCH_QUERY_STORE_ID_POPULARITY` (`store_id`,`popularity`),
  CONSTRAINT `SEARCH_QUERY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1014 DEFAULT CHARSET=utf8 COMMENT='Search query table';

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

INSERT INTO `search_query` VALUES (1,'a',0,1,NULL,1,1,1,0,'2016-04-26 17:19:52'),(3,'Hero Hoodie',1,1,NULL,1,1,1,0,'2016-04-26 17:22:06'),(5,'Marco Lightweight Active',1,5,NULL,1,1,1,0,'2016-04-26 17:39:15'),(6,'Sed dignissim magna',1,3,NULL,1,1,1,0,'2019-05-23 12:45:37'),(8,'ab',0,5,NULL,1,1,1,0,'2016-05-03 05:14:08'),(18,'The Net Bag in Navy',2,4,NULL,1,1,1,0,'2016-05-03 05:20:11'),(26,'Cras sem sapien',14,1,NULL,1,1,1,0,'2016-05-03 05:19:18'),(27,'buberry',8,1,NULL,4,1,1,0,'2016-05-14 23:37:54'),(28,'sasasaaaaaaaaaaaaaaa',0,1,NULL,6,1,1,0,'2016-05-16 14:58:10'),(30,'Grouped Product',4,1,NULL,6,1,1,0,'2016-05-16 15:04:05'),(31,'nnmb',0,1,NULL,1,1,1,0,'2017-04-13 09:30:39'),(33,'buberry',8,4,NULL,1,1,1,0,'2017-04-17 22:08:50'),(35,'versace',3,1,NULL,1,1,1,0,'2017-04-16 01:27:39'),(37,'Marco Lightweight Active',1,1,NULL,6,1,1,0,'2017-04-16 09:23:28'),(45,'chanel',3,1,NULL,2,1,1,0,'2017-04-18 09:40:34'),(46,'sem',4,4,NULL,16,1,1,0,'2018-10-09 02:42:13'),(54,'black',4,2,NULL,16,1,1,0,'2018-10-10 04:33:45'),(58,'Fusce nec facilisi',1,1,NULL,1,1,1,0,'2019-05-21 06:28:42'),(60,'Primo Court Mid Suede',3,1,NULL,1,1,1,0,'2019-05-21 06:30:18'),(62,'group',1,1,NULL,1,1,1,0,'2019-05-21 06:33:30'),(64,'wa',0,2,NULL,1,1,1,0,'2019-05-23 08:20:11'),(66,'wave',3,2,NULL,1,1,1,0,'2019-05-23 08:20:18'),(72,'aa',0,2,NULL,1,1,1,0,'2020-12-30 13:57:19'),(74,'su',0,1,NULL,1,1,1,0,'2019-05-23 10:18:49'),(76,'suge',0,1,NULL,1,1,1,0,'2019-05-23 10:18:50'),(78,'sug',0,1,NULL,1,1,1,0,'2019-05-23 10:19:07'),(80,'sugge',0,1,NULL,1,1,1,0,'2019-05-23 10:19:08'),(82,'sugges',0,1,NULL,1,1,1,0,'2019-05-23 10:19:10'),(84,'suggested',0,7,NULL,1,1,1,0,'2019-05-23 10:20:00'),(98,'Wave Ripped Straight',3,1,NULL,1,1,1,0,'2019-05-23 10:20:23'),(100,'Mauris sollicitudin',14,2,NULL,1,1,1,0,'2019-05-24 02:15:17'),(102,'asa',0,2,NULL,1,1,1,0,'2019-05-23 12:45:15'),(110,'width: auto;  height: auto;',0,1,NULL,1,1,1,0,'2019-05-24 03:37:13'),(112,'Mauris sollicitudin',14,1,NULL,27,1,1,0,'2019-05-29 03:24:48'),(113,'asasa',0,2,NULL,33,1,1,0,'2019-07-30 01:17:50'),(117,'Marco Lightweight Active',1,1,NULL,33,1,1,0,'2019-07-30 01:20:00'),(119,'padding-bottom: 14px;',0,1,NULL,32,1,1,0,'2019-07-30 01:24:21'),(121,'Cras sem sapien',16,1,NULL,32,1,1,0,'2019-07-30 01:25:09'),(123,'Cras sem sapien',16,1,NULL,33,1,1,0,'2019-07-30 01:26:42'),(125,'asas',0,1,NULL,16,1,1,0,'2019-08-08 16:45:11'),(127,'Wave Ripped Straight',3,1,NULL,16,1,1,0,'2019-08-08 16:45:44'),(128,'ring',5,2,NULL,34,1,1,0,'2019-12-11 08:01:48'),(132,'bou',12,2,NULL,36,1,1,0,'2019-12-12 04:24:28'),(133,'cc',0,1,NULL,32,1,1,0,'2020-01-14 08:52:36'),(134,'el',39,2,NULL,1,1,1,0,'2020-01-31 10:13:09'),(138,'abc',0,1,NULL,1,1,1,0,'2020-02-03 01:15:55'),(140,'mar',10,2,NULL,1,1,1,0,'2020-07-02 11:58:16'),(142,'he',20,1,NULL,1,1,1,0,'2020-03-22 12:41:09'),(144,'hell',0,1,NULL,1,1,1,0,'2020-03-22 12:41:11'),(146,'getvov.com',3,2,NULL,1,1,1,0,'2020-03-24 09:09:11'),(147,'leg',19,1,NULL,12,1,1,0,'2020-03-26 14:24:48'),(149,'legg',18,1,NULL,12,1,1,0,'2020-03-26 14:24:53'),(151,'legging',18,1,NULL,12,1,1,0,'2020-03-26 14:24:55'),(152,'cas',0,1,NULL,1,1,1,0,'2020-04-06 16:00:48'),(153,'còn',17,13,NULL,1,1,1,0,'2020-07-04 08:55:08'),(155,'config',1,38,NULL,1,1,1,0,'2020-09-23 08:20:29'),(174,'watch',0,7,NULL,16,1,1,0,'2020-04-22 11:23:09'),(188,'cal',0,1,NULL,4,1,1,0,'2020-04-25 17:46:22'),(190,'te',54,1,NULL,4,1,1,0,'2020-04-25 17:46:25'),(192,'t-s',75,1,NULL,4,1,1,0,'2020-04-25 17:46:28'),(194,'t-sh',75,3,NULL,4,1,1,0,'2020-06-25 09:07:25'),(196,'t-shi',75,1,NULL,4,1,1,0,'2020-04-25 17:46:31'),(198,'t-shirt',75,2,NULL,4,1,1,0,'2020-06-25 09:07:23'),(200,'sprite',1,1,NULL,4,1,1,0,'2020-04-27 13:05:32'),(202,'sprite yo',4,1,NULL,4,1,1,0,'2020-04-27 13:05:33'),(203,'sas',0,1,NULL,34,1,1,0,'2020-05-24 11:20:17'),(205,'accesso',1,2,NULL,16,1,1,0,'2020-05-25 18:01:40'),(206,'dr',26,1,NULL,8,1,1,0,'2020-06-02 13:00:50'),(208,'dre',18,1,NULL,8,1,1,0,'2020-06-02 13:00:50'),(210,'dress',18,2,NULL,8,1,1,0,'2020-06-02 13:00:55'),(214,'shirt',0,3,NULL,1,1,1,0,'2020-07-21 21:52:07'),(216,'swee',1,1,NULL,1,1,1,0,'2020-06-04 08:35:47'),(218,'sweet',1,1,NULL,1,1,1,0,'2020-06-04 08:35:48'),(220,'dsd',0,1,NULL,8,1,1,0,'2020-06-07 18:37:00'),(222,'chi',3,1,NULL,21,1,1,0,'2020-06-08 16:59:12'),(224,'cloud',2,2,NULL,20,1,1,0,'2020-06-08 23:19:57'),(228,'cloud pri',43,1,NULL,20,1,1,0,'2020-06-08 23:19:58'),(230,'cloud prin',40,1,NULL,20,1,1,0,'2020-06-08 23:20:01'),(232,'cloud print',40,1,NULL,20,1,1,0,'2020-06-08 23:20:03'),(233,'sadsad',0,1,NULL,8,1,1,0,'2020-06-15 16:13:42'),(235,'confi',1,17,NULL,1,1,1,0,'2020-07-04 06:42:12'),(237,'con',17,2,NULL,38,1,1,0,'2020-06-16 17:16:12'),(239,'coni',0,1,NULL,38,1,1,0,'2020-06-16 17:16:09'),(243,'conf',1,1,NULL,38,1,1,0,'2020-06-16 17:16:13'),(245,'confi',1,1,NULL,3,1,1,0,'2020-06-16 22:38:00'),(246,'nutrition',1,1,NULL,37,1,1,0,'2020-06-18 22:45:52'),(248,'test',0,1,NULL,10,1,1,0,'2020-06-23 20:31:19'),(250,'super',2,1,NULL,10,1,1,0,'2020-06-23 20:31:33'),(252,'superfo',2,1,NULL,10,1,1,0,'2020-06-23 20:31:33'),(254,'ddgdfdf',0,1,NULL,38,1,1,0,'2020-06-25 08:37:20'),(256,'SHO',0,3,NULL,4,1,1,0,'2020-06-25 09:03:09'),(258,'SHOWE',0,1,NULL,4,1,1,0,'2020-06-25 09:03:04'),(262,'SHOO',0,2,NULL,4,1,1,0,'2020-06-25 09:03:08'),(264,'SHOOES',0,1,NULL,4,1,1,0,'2020-06-25 09:03:07'),(270,'SHOES',0,1,NULL,4,1,1,0,'2020-06-25 09:03:10'),(272,'CA',22,1,NULL,4,1,1,0,'2020-06-25 09:03:14'),(274,'CAN',22,1,NULL,4,1,1,0,'2020-06-25 09:03:14'),(276,'BA',24,1,NULL,4,1,1,0,'2020-06-25 09:04:17'),(278,'BAG',3,1,NULL,4,1,1,0,'2020-06-25 09:04:18'),(280,'ts',0,1,NULL,38,1,1,0,'2020-06-25 09:05:48'),(282,'t-',75,1,NULL,38,1,1,0,'2020-06-25 09:05:52'),(284,'t-shi',75,1,NULL,38,1,1,0,'2020-06-25 09:05:54'),(288,'Gu',6,1,NULL,4,1,1,0,'2020-06-25 09:07:15'),(290,'ts',0,1,NULL,4,1,1,0,'2020-06-25 09:07:20'),(294,'T-',75,1,NULL,4,1,1,0,'2020-06-25 09:07:23'),(298,'Jea',0,1,NULL,4,1,1,0,'2020-06-25 09:07:37'),(300,'Jean',0,1,NULL,4,1,1,0,'2020-06-25 09:07:39'),(302,'Jeans',0,2,NULL,4,1,1,0,'2020-06-25 09:07:43'),(306,'ner',0,1,NULL,1,1,1,0,'2020-06-25 16:36:37'),(308,'home',0,1,NULL,1,1,1,0,'2020-06-25 16:36:41'),(310,'for',2,1,NULL,16,1,1,0,'2020-06-26 20:10:37'),(312,'for men',2,4,NULL,16,1,1,0,'2020-06-26 20:12:07'),(313,'smart',0,28,NULL,1,1,1,0,'2020-07-06 04:30:29'),(317,'mac',2,7,NULL,1,1,1,0,'2020-07-03 03:16:15'),(325,'ma',73,1,NULL,1,1,1,0,'2020-07-03 03:16:14'),(329,'bund',1,1,NULL,1,1,1,0,'2020-07-03 04:32:43'),(331,'bundel',0,1,NULL,1,1,1,0,'2020-07-03 04:32:43'),(333,'bun',2,1,NULL,1,1,1,0,'2020-07-03 04:32:46'),(335,'bundle',1,5,NULL,1,1,1,0,'2020-07-03 04:48:11'),(340,'conf',1,30,NULL,1,1,1,0,'2020-07-04 09:01:30'),(353,'bu',50,1,NULL,1,1,1,0,'2020-07-03 04:48:03'),(358,'co',37,3,NULL,1,1,1,0,'2020-07-04 08:01:41'),(360,'cofi',0,1,NULL,1,1,1,0,'2020-07-03 14:28:36'),(362,'cofig',0,1,NULL,1,1,1,0,'2020-07-03 14:28:39'),(386,'còni',0,1,NULL,1,1,1,0,'2020-07-03 16:51:40'),(388,'cònif',0,1,NULL,1,1,1,0,'2020-07-03 16:51:41'),(408,'config?templatehints=magento',1,1,NULL,1,1,1,0,'2020-07-04 03:18:01'),(412,'xo',0,1,NULL,1,1,1,0,'2020-07-04 03:50:09'),(414,'congi',0,1,NULL,1,1,1,0,'2020-07-04 03:50:14'),(416,'cong',0,2,NULL,1,1,1,0,'2020-07-04 08:55:07'),(418,'cong=',0,1,NULL,1,1,1,0,'2020-07-04 03:50:16'),(449,'cif',0,1,NULL,1,1,1,0,'2020-07-04 04:13:02'),(451,'cof',0,1,NULL,1,1,1,0,'2020-07-04 04:13:04'),(470,'smar',0,5,NULL,1,1,1,0,'2020-07-04 08:50:23'),(474,'smat',0,1,NULL,1,1,1,0,'2020-07-04 07:10:16'),(522,'sm',2,1,NULL,1,1,1,0,'2020-07-04 07:30:59'),(524,'cn',0,1,NULL,1,1,1,0,'2020-07-04 07:31:03'),(563,'sms',0,1,NULL,16,1,1,0,'2020-07-06 03:56:48'),(565,'sma',0,2,NULL,16,1,1,0,'2020-07-06 04:03:53'),(577,'smar',0,1,NULL,16,1,1,0,'2020-07-06 04:03:54'),(579,'sm',2,1,NULL,16,1,1,0,'2020-07-06 04:04:07'),(583,'smart',0,4,NULL,16,1,1,0,'2020-07-06 04:38:12'),(597,'sma',0,2,NULL,1,1,1,0,'2020-07-06 09:51:56'),(601,'wo',20,2,NULL,6,1,1,0,'2020-07-07 09:32:46'),(603,'wom',0,1,NULL,6,1,1,0,'2020-07-07 09:32:41'),(604,'shi',0,1,NULL,30,1,1,0,'2020-07-09 09:20:29'),(606,'ba',24,1,NULL,30,1,1,0,'2020-07-09 09:20:33'),(607,'who',1,1,NULL,10,1,1,0,'2020-07-12 09:47:15'),(609,'whole',1,1,NULL,10,1,1,0,'2020-07-12 09:47:16'),(610,'luce',0,2,NULL,1,1,1,0,'2020-07-13 10:22:28'),(611,'hat',1,1,NULL,38,1,1,0,'2020-07-20 17:58:38'),(613,'hats',0,1,NULL,38,1,1,0,'2020-07-20 17:58:45'),(615,']teenage',0,1,NULL,38,1,1,0,'2020-07-20 17:58:55'),(617,'teenage',0,1,NULL,38,1,1,0,'2020-07-20 17:59:14'),(619,'appa',0,1,NULL,16,1,1,0,'2020-07-21 13:52:00'),(621,'apparel',0,2,NULL,16,1,1,0,'2020-07-21 13:52:02'),(629,'sd',0,1,NULL,14,1,1,0,'2020-07-27 06:51:40'),(631,'te',54,1,NULL,1,1,1,0,'2020-07-31 06:42:57'),(633,'test',0,1,NULL,1,1,1,0,'2020-07-31 06:42:59'),(634,'Ba',24,2,NULL,1,1,1,0,'2020-09-18 16:31:15'),(636,'Bag',3,4,NULL,1,1,1,0,'2020-09-18 16:31:22'),(640,'top',4,1,NULL,37,1,1,0,'2020-08-17 11:04:16'),(642,'sad',0,1,NULL,27,1,1,0,'2020-08-24 13:54:52'),(644,'a',74,2,NULL,6,1,1,0,'2020-09-15 03:25:04'),(648,'shirt',0,1,NULL,21,1,1,0,'2020-09-15 12:50:41'),(650,'shmairt',0,1,NULL,21,1,1,0,'2020-09-15 12:50:50'),(652,'shma',0,1,NULL,21,1,1,0,'2020-09-15 12:50:51'),(654,'ma',73,1,NULL,21,1,1,0,'2020-09-15 12:50:56'),(656,'man',1,1,NULL,21,1,1,0,'2020-09-15 12:50:56'),(658,'man',1,1,NULL,4,1,1,0,'2020-09-15 12:51:42'),(660,'cop',0,1,NULL,10,1,1,0,'2020-09-17 20:15:45'),(662,'conf',1,2,NULL,10,1,1,0,'2020-12-31 01:49:38'),(664,'ts',0,1,NULL,1,1,1,0,'2020-09-18 16:22:25'),(666,'tshirt',0,1,NULL,1,1,1,0,'2020-09-18 16:22:26'),(668,'bea',19,2,NULL,1,1,1,0,'2020-09-18 16:22:42'),(672,'bab',1,1,NULL,1,1,1,0,'2020-09-18 16:30:28'),(674,'jack',1,1,NULL,1,1,1,0,'2020-09-18 16:30:37'),(676,'boy',0,1,NULL,1,1,1,0,'2020-09-18 16:30:44'),(678,'acc',3,1,NULL,1,1,1,0,'2020-09-18 16:30:53'),(680,'access',1,1,NULL,1,1,1,0,'2020-09-18 16:30:54'),(682,'foot',2,1,NULL,1,1,1,0,'2020-09-18 16:31:07'),(684,'footw',0,1,NULL,1,1,1,0,'2020-09-18 16:31:08'),(696,'h',61,1,NULL,6,1,1,0,'2020-09-24 10:50:24'),(698,'mau',16,1,NULL,18,1,1,0,'2020-09-24 13:34:46'),(700,'mauris',16,4,NULL,18,1,1,0,'2020-09-24 13:34:59'),(708,'awd',0,1,NULL,6,1,1,0,'2020-10-01 07:36:12'),(710,'karim',0,2,NULL,16,1,1,0,'2020-10-08 21:19:50'),(714,'barabums',0,2,NULL,30,1,1,0,'2020-10-08 21:23:32'),(718,'fd',0,1,NULL,16,1,1,0,'2020-10-08 22:15:14'),(720,'fda',0,1,NULL,16,1,1,0,'2020-10-08 22:15:15'),(722,'con',17,1,NULL,30,1,1,0,'2020-10-14 20:55:43'),(724,'conf',1,1,NULL,30,1,1,0,'2020-10-14 20:55:44'),(726,'adw',0,1,NULL,1,1,1,0,'2020-10-15 06:18:44'),(728,'ad',3,1,NULL,1,1,1,0,'2020-10-15 06:18:46'),(730,'awd',0,1,NULL,30,1,1,0,'2020-10-15 06:20:39'),(732,'aw',1,1,NULL,30,1,1,0,'2020-10-15 06:20:41'),(734,'aaw',0,1,NULL,30,1,1,0,'2020-10-15 06:21:07'),(736,'fdfdddd',0,1,NULL,1,1,1,0,'2020-10-17 17:39:44'),(738,'fgf',0,1,NULL,1,1,1,0,'2020-10-17 17:43:59'),(740,'fg',0,1,NULL,1,1,1,0,'2020-10-17 17:44:02'),(742,'summit',1,1,NULL,1,1,1,0,'2020-10-18 05:12:22'),(744,'MARCASITE',9,2,NULL,10,1,1,0,'2020-10-18 07:18:31'),(748,'SWEET PEAR LAPIS STERLING SILVER RING',12,2,NULL,14,1,1,0,'2020-10-23 17:00:16'),(752,'je',1,1,NULL,1,1,1,0,'2020-11-12 11:52:00'),(754,'jea',0,1,NULL,1,1,1,0,'2020-11-12 11:52:02'),(756,'jean',0,1,NULL,1,1,1,0,'2020-11-12 11:52:07'),(758,'men',0,2,NULL,1,1,1,0,'2020-11-12 11:56:24'),(760,'me',17,1,NULL,1,1,1,0,'2020-11-12 11:56:23'),(764,'halo',1,1,NULL,16,1,1,0,'2020-11-12 12:04:30'),(766,'high',4,1,NULL,16,1,1,0,'2020-11-12 12:05:07'),(768,'ró',11,1,NULL,36,1,1,0,'2020-11-12 12:43:02'),(770,'rose',7,2,NULL,36,1,1,0,'2020-11-12 12:43:16'),(774,'shi',0,3,NULL,16,1,1,0,'2020-11-15 10:08:26'),(776,'shirt',0,3,NULL,16,1,1,0,'2021-01-06 13:45:44'),(778,'shir',0,2,NULL,16,1,1,0,'2020-11-15 10:08:30'),(782,'sh',4,3,NULL,16,1,1,0,'2021-01-06 13:45:43'),(784,'je',1,2,NULL,16,1,1,0,'2020-11-15 09:17:26'),(786,'jea',0,1,NULL,16,1,1,0,'2020-11-15 09:17:24'),(796,'Ma',73,1,NULL,16,1,1,0,'2020-11-15 10:08:36'),(798,'Man',1,7,NULL,16,1,1,0,'2020-11-15 10:11:32'),(807,'Wo',20,5,NULL,16,1,1,0,'2020-12-29 15:54:32'),(809,'Wom',0,2,NULL,16,1,1,0,'2020-12-29 15:54:28'),(815,'Man',1,1,NULL,8,1,1,0,'2020-11-16 11:27:54'),(817,'Ma',73,2,NULL,8,1,1,0,'2020-11-16 11:28:13'),(821,'Shi',0,2,NULL,8,1,1,0,'2020-11-16 11:28:52'),(823,'Shirr',0,1,NULL,8,1,1,0,'2020-11-16 11:28:43'),(825,'Shirt',0,1,NULL,8,1,1,0,'2020-11-16 11:28:45'),(827,'Shir',0,1,NULL,8,1,1,0,'2020-11-16 11:28:51'),(831,'Sh',4,1,NULL,8,1,1,0,'2020-11-16 11:28:55'),(833,'Aho',0,1,NULL,8,1,1,0,'2020-11-16 11:29:20'),(835,'Sho',0,1,NULL,8,1,1,0,'2020-11-16 11:29:23'),(837,'Shoe',0,1,NULL,8,1,1,0,'2020-11-16 11:29:26'),(839,'Shoes',0,1,NULL,8,1,1,0,'2020-11-16 11:29:29'),(841,'Hand',0,1,NULL,8,1,1,0,'2020-11-16 11:29:54'),(843,'Bag',3,1,NULL,8,1,1,0,'2020-11-16 11:29:59'),(845,'Man',1,1,NULL,10,1,1,0,'2020-11-16 14:19:39'),(847,'fdgfdgfdgfdgfd',0,1,NULL,1,1,1,0,'2020-11-23 01:19:29'),(849,'fdgfdgfdgfdgfdggggggggggggg',0,1,NULL,1,1,1,0,'2020-11-23 01:19:34'),(851,'hgfhgfhgfhg',0,1,NULL,38,1,1,0,'2020-11-23 01:24:55'),(853,'goo',70,2,NULL,38,1,1,0,'2020-11-23 01:25:07'),(857,'goo',70,2,NULL,41,1,1,0,'2020-11-23 01:25:29'),(861,'test',0,1,NULL,38,1,1,0,'2020-11-24 18:14:15'),(863,'tes',0,1,NULL,38,1,1,0,'2020-11-24 18:14:19'),(865,'te',54,1,NULL,38,1,1,0,'2020-11-24 18:14:22'),(867,'kids',1,1,NULL,38,1,1,0,'2020-11-24 18:14:24'),(869,'monitor',0,1,NULL,4,1,1,0,'2020-11-29 19:14:01'),(871,'monito',0,1,NULL,4,1,1,0,'2020-11-29 19:14:02'),(873,'cueco',0,2,NULL,4,1,1,0,'2020-11-29 19:14:07'),(877,'fl',0,2,NULL,36,1,1,0,'2021-02-24 12:18:51'),(879,'flo',0,2,NULL,36,1,1,0,'2021-02-24 12:18:53'),(881,'flow',10,5,NULL,36,1,1,0,'2021-02-24 12:19:10'),(883,'flower',10,1,NULL,36,1,1,0,'2020-12-01 13:06:03'),(885,'flowe',10,1,NULL,36,1,1,0,'2020-12-01 13:06:08'),(887,'flor',3,1,NULL,36,1,1,0,'2020-12-01 13:06:09'),(889,'floer',0,1,NULL,36,1,1,0,'2020-12-01 13:06:14'),(893,'marc',10,1,NULL,1,1,1,0,'2020-12-21 15:44:37'),(895,'con',17,1,NULL,14,1,1,0,'2020-12-24 07:46:19'),(897,'fdfsdfs',0,2,NULL,16,1,1,0,'2020-12-29 15:54:05'),(903,'women',0,1,NULL,16,1,1,0,'2020-12-29 15:54:21'),(911,'aaa',0,1,NULL,1,1,1,0,'2020-12-30 13:57:20'),(913,'SED',1,2,NULL,1,1,1,0,'2020-12-30 13:57:37'),(917,'SED',1,1,NULL,2,1,1,0,'2020-12-30 13:57:47'),(919,'FUSCE',1,2,NULL,2,1,1,0,'2020-12-30 14:09:19'),(925,'configua',0,1,NULL,10,1,1,0,'2020-12-31 01:49:40'),(927,'configu',1,1,NULL,10,1,1,0,'2020-12-31 01:49:44'),(929,'configura',1,1,NULL,10,1,1,0,'2020-12-31 01:49:47'),(931,'configurab',1,1,NULL,10,1,1,0,'2020-12-31 01:49:48'),(933,'configurabl',1,1,NULL,10,1,1,0,'2020-12-31 01:49:48'),(935,'configurable',1,2,NULL,10,1,1,0,'2020-12-31 01:49:57'),(941,'short',0,1,NULL,16,1,1,0,'2021-01-06 13:45:40'),(947,'so',37,1,NULL,16,1,1,0,'2021-01-06 13:45:49'),(949,'hat',1,1,NULL,16,1,1,0,'2021-01-06 13:46:05'),(951,'foot',2,2,NULL,16,1,1,0,'2021-01-06 13:46:20'),(955,'skin',2,2,NULL,16,1,1,0,'2021-01-06 13:46:52'),(959,'foot',2,1,NULL,6,1,1,0,'2021-01-06 13:47:02'),(961,'ghggh',0,1,NULL,1,1,1,0,'2021-01-09 16:42:36'),(963,'Camida',0,2,NULL,14,1,1,0,'2021-01-12 17:50:20'),(966,'Cami',0,1,NULL,14,1,1,0,'2021-01-12 17:50:20'),(969,'Camisa',0,2,NULL,14,1,1,0,'2021-01-12 17:50:21'),(973,'fa',23,1,NULL,1,1,1,0,'2021-01-21 07:22:15'),(975,'fak',0,1,NULL,1,1,1,0,'2021-01-21 07:22:16'),(977,'hlo',0,1,NULL,1,1,1,0,'2021-01-24 19:55:57'),(979,'halo',1,1,NULL,1,1,1,0,'2021-01-24 19:55:59'),(981,'bbjhbhbbhhbhbhbhbhbhhhhjb',0,1,NULL,1,1,1,0,'2021-01-27 06:12:45'),(983,'uohjh',0,1,NULL,8,1,1,0,'2021-02-08 14:21:11'),(985,'demo',1,1,NULL,1,1,1,0,'2021-02-19 16:20:53'),(987,'lotus',2,2,NULL,6,1,1,0,'2021-02-22 07:19:42'),(991,'lotus',2,2,NULL,14,1,1,0,'2021-02-24 08:17:17'),(995,'pi',0,1,NULL,36,1,1,0,'2021-02-24 12:18:40'),(997,'pin',0,2,NULL,36,1,1,0,'2021-02-24 12:18:44'),(999,'pink',1,1,NULL,36,1,1,0,'2021-02-24 12:18:44'),(1013,'coat',0,1,NULL,8,1,1,0,'2021-02-26 20:07:15');

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

CREATE TABLE `search_synonyms` (
  `group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Synonyms Group ID',
  `synonyms` text NOT NULL COMMENT 'list of synonyms making up this group',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID - identifies the store view these synonyms belong to',
  `website_id` smallint(5) 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `ip` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer IP address',
  `time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Log time',
  `website_id` smallint(5) 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=utf8 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(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

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


--
-- Table structure for table `sequence_creditmemo_10`
--

CREATE TABLE `sequence_creditmemo_10` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_10`
--


--
-- Table structure for table `sequence_creditmemo_11`
--

CREATE TABLE `sequence_creditmemo_11` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_11`
--


--
-- Table structure for table `sequence_creditmemo_12`
--

CREATE TABLE `sequence_creditmemo_12` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_12`
--


--
-- Table structure for table `sequence_creditmemo_13`
--

CREATE TABLE `sequence_creditmemo_13` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_13`
--


--
-- Table structure for table `sequence_creditmemo_14`
--

CREATE TABLE `sequence_creditmemo_14` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_14`
--


--
-- Table structure for table `sequence_creditmemo_15`
--

CREATE TABLE `sequence_creditmemo_15` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_15`
--


--
-- Table structure for table `sequence_creditmemo_16`
--

CREATE TABLE `sequence_creditmemo_16` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_16`
--


--
-- Table structure for table `sequence_creditmemo_17`
--

CREATE TABLE `sequence_creditmemo_17` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_17`
--


--
-- Table structure for table `sequence_creditmemo_18`
--

CREATE TABLE `sequence_creditmemo_18` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_18`
--


--
-- Table structure for table `sequence_creditmemo_2`
--

CREATE TABLE `sequence_creditmemo_2` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_2`
--


--
-- Table structure for table `sequence_creditmemo_20`
--

CREATE TABLE `sequence_creditmemo_20` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_20`
--


--
-- Table structure for table `sequence_creditmemo_21`
--

CREATE TABLE `sequence_creditmemo_21` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_21`
--


--
-- Table structure for table `sequence_creditmemo_22`
--

CREATE TABLE `sequence_creditmemo_22` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_22`
--


--
-- Table structure for table `sequence_creditmemo_23`
--

CREATE TABLE `sequence_creditmemo_23` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_23`
--


--
-- Table structure for table `sequence_creditmemo_24`
--

CREATE TABLE `sequence_creditmemo_24` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_24`
--


--
-- Table structure for table `sequence_creditmemo_25`
--

CREATE TABLE `sequence_creditmemo_25` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_25`
--


--
-- Table structure for table `sequence_creditmemo_26`
--

CREATE TABLE `sequence_creditmemo_26` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_26`
--


--
-- Table structure for table `sequence_creditmemo_27`
--

CREATE TABLE `sequence_creditmemo_27` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_27`
--


--
-- Table structure for table `sequence_creditmemo_28`
--

CREATE TABLE `sequence_creditmemo_28` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_28`
--


--
-- Table structure for table `sequence_creditmemo_29`
--

CREATE TABLE `sequence_creditmemo_29` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_29`
--


--
-- Table structure for table `sequence_creditmemo_3`
--

CREATE TABLE `sequence_creditmemo_3` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_3`
--


--
-- Table structure for table `sequence_creditmemo_30`
--

CREATE TABLE `sequence_creditmemo_30` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_30`
--


--
-- Table structure for table `sequence_creditmemo_31`
--

CREATE TABLE `sequence_creditmemo_31` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_31`
--


--
-- Table structure for table `sequence_creditmemo_32`
--

CREATE TABLE `sequence_creditmemo_32` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_32`
--


--
-- Table structure for table `sequence_creditmemo_33`
--

CREATE TABLE `sequence_creditmemo_33` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_33`
--


--
-- Table structure for table `sequence_creditmemo_34`
--

CREATE TABLE `sequence_creditmemo_34` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_34`
--


--
-- Table structure for table `sequence_creditmemo_35`
--

CREATE TABLE `sequence_creditmemo_35` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_35`
--


--
-- Table structure for table `sequence_creditmemo_36`
--

CREATE TABLE `sequence_creditmemo_36` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_36`
--


--
-- Table structure for table `sequence_creditmemo_37`
--

CREATE TABLE `sequence_creditmemo_37` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_37`
--


--
-- Table structure for table `sequence_creditmemo_38`
--

CREATE TABLE `sequence_creditmemo_38` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_38`
--


--
-- Table structure for table `sequence_creditmemo_39`
--

CREATE TABLE `sequence_creditmemo_39` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_39`
--


--
-- Table structure for table `sequence_creditmemo_4`
--

CREATE TABLE `sequence_creditmemo_4` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_4`
--


--
-- Table structure for table `sequence_creditmemo_40`
--

CREATE TABLE `sequence_creditmemo_40` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_40`
--


--
-- Table structure for table `sequence_creditmemo_41`
--

CREATE TABLE `sequence_creditmemo_41` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_41`
--


--
-- Table structure for table `sequence_creditmemo_5`
--

CREATE TABLE `sequence_creditmemo_5` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_5`
--


--
-- Table structure for table `sequence_creditmemo_6`
--

CREATE TABLE `sequence_creditmemo_6` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_6`
--


--
-- Table structure for table `sequence_creditmemo_7`
--

CREATE TABLE `sequence_creditmemo_7` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_7`
--


--
-- Table structure for table `sequence_creditmemo_8`
--

CREATE TABLE `sequence_creditmemo_8` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_8`
--


--
-- Table structure for table `sequence_creditmemo_9`
--

CREATE TABLE `sequence_creditmemo_9` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_creditmemo_9`
--


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

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

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


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

CREATE TABLE `sequence_invoice_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `sequence_invoice_10`
--

CREATE TABLE `sequence_invoice_10` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_10`
--


--
-- Table structure for table `sequence_invoice_11`
--

CREATE TABLE `sequence_invoice_11` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_11`
--


--
-- Table structure for table `sequence_invoice_12`
--

CREATE TABLE `sequence_invoice_12` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_12`
--


--
-- Table structure for table `sequence_invoice_13`
--

CREATE TABLE `sequence_invoice_13` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_13`
--


--
-- Table structure for table `sequence_invoice_14`
--

CREATE TABLE `sequence_invoice_14` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_14`
--


--
-- Table structure for table `sequence_invoice_15`
--

CREATE TABLE `sequence_invoice_15` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_15`
--


--
-- Table structure for table `sequence_invoice_16`
--

CREATE TABLE `sequence_invoice_16` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_16`
--


--
-- Table structure for table `sequence_invoice_17`
--

CREATE TABLE `sequence_invoice_17` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_17`
--


--
-- Table structure for table `sequence_invoice_18`
--

CREATE TABLE `sequence_invoice_18` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_18`
--


--
-- Table structure for table `sequence_invoice_2`
--

CREATE TABLE `sequence_invoice_2` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_2`
--


--
-- Table structure for table `sequence_invoice_20`
--

CREATE TABLE `sequence_invoice_20` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_20`
--


--
-- Table structure for table `sequence_invoice_21`
--

CREATE TABLE `sequence_invoice_21` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_21`
--


--
-- Table structure for table `sequence_invoice_22`
--

CREATE TABLE `sequence_invoice_22` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_22`
--


--
-- Table structure for table `sequence_invoice_23`
--

CREATE TABLE `sequence_invoice_23` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_23`
--


--
-- Table structure for table `sequence_invoice_24`
--

CREATE TABLE `sequence_invoice_24` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_24`
--


--
-- Table structure for table `sequence_invoice_25`
--

CREATE TABLE `sequence_invoice_25` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_25`
--


--
-- Table structure for table `sequence_invoice_26`
--

CREATE TABLE `sequence_invoice_26` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_26`
--


--
-- Table structure for table `sequence_invoice_27`
--

CREATE TABLE `sequence_invoice_27` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_27`
--


--
-- Table structure for table `sequence_invoice_28`
--

CREATE TABLE `sequence_invoice_28` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_28`
--


--
-- Table structure for table `sequence_invoice_29`
--

CREATE TABLE `sequence_invoice_29` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_29`
--


--
-- Table structure for table `sequence_invoice_3`
--

CREATE TABLE `sequence_invoice_3` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_3`
--


--
-- Table structure for table `sequence_invoice_30`
--

CREATE TABLE `sequence_invoice_30` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_30`
--


--
-- Table structure for table `sequence_invoice_31`
--

CREATE TABLE `sequence_invoice_31` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_31`
--


--
-- Table structure for table `sequence_invoice_32`
--

CREATE TABLE `sequence_invoice_32` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_32`
--


--
-- Table structure for table `sequence_invoice_33`
--

CREATE TABLE `sequence_invoice_33` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_33`
--


--
-- Table structure for table `sequence_invoice_34`
--

CREATE TABLE `sequence_invoice_34` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_34`
--


--
-- Table structure for table `sequence_invoice_35`
--

CREATE TABLE `sequence_invoice_35` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_35`
--


--
-- Table structure for table `sequence_invoice_36`
--

CREATE TABLE `sequence_invoice_36` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_36`
--


--
-- Table structure for table `sequence_invoice_37`
--

CREATE TABLE `sequence_invoice_37` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_37`
--


--
-- Table structure for table `sequence_invoice_38`
--

CREATE TABLE `sequence_invoice_38` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_38`
--


--
-- Table structure for table `sequence_invoice_39`
--

CREATE TABLE `sequence_invoice_39` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_39`
--


--
-- Table structure for table `sequence_invoice_4`
--

CREATE TABLE `sequence_invoice_4` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_4`
--


--
-- Table structure for table `sequence_invoice_40`
--

CREATE TABLE `sequence_invoice_40` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_40`
--


--
-- Table structure for table `sequence_invoice_41`
--

CREATE TABLE `sequence_invoice_41` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_41`
--


--
-- Table structure for table `sequence_invoice_5`
--

CREATE TABLE `sequence_invoice_5` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_5`
--


--
-- Table structure for table `sequence_invoice_6`
--

CREATE TABLE `sequence_invoice_6` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_6`
--


--
-- Table structure for table `sequence_invoice_7`
--

CREATE TABLE `sequence_invoice_7` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_7`
--


--
-- Table structure for table `sequence_invoice_8`
--

CREATE TABLE `sequence_invoice_8` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_8`
--


--
-- Table structure for table `sequence_invoice_9`
--

CREATE TABLE `sequence_invoice_9` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_invoice_9`
--


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

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

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


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

CREATE TABLE `sequence_order_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

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

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

--
-- Table structure for table `sequence_order_10`
--

CREATE TABLE `sequence_order_10` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_10`
--

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

--
-- Table structure for table `sequence_order_11`
--

CREATE TABLE `sequence_order_11` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_11`
--


--
-- Table structure for table `sequence_order_12`
--

CREATE TABLE `sequence_order_12` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_12`
--


--
-- Table structure for table `sequence_order_13`
--

CREATE TABLE `sequence_order_13` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_13`
--


--
-- Table structure for table `sequence_order_14`
--

CREATE TABLE `sequence_order_14` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_14`
--

INSERT INTO `sequence_order_14` VALUES (1),(2);

--
-- Table structure for table `sequence_order_15`
--

CREATE TABLE `sequence_order_15` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_15`
--


--
-- Table structure for table `sequence_order_16`
--

CREATE TABLE `sequence_order_16` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_16`
--

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

--
-- Table structure for table `sequence_order_17`
--

CREATE TABLE `sequence_order_17` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_17`
--


--
-- Table structure for table `sequence_order_18`
--

CREATE TABLE `sequence_order_18` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_18`
--

INSERT INTO `sequence_order_18` VALUES (1);

--
-- Table structure for table `sequence_order_2`
--

CREATE TABLE `sequence_order_2` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_2`
--


--
-- Table structure for table `sequence_order_20`
--

CREATE TABLE `sequence_order_20` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_20`
--


--
-- Table structure for table `sequence_order_21`
--

CREATE TABLE `sequence_order_21` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_21`
--


--
-- Table structure for table `sequence_order_22`
--

CREATE TABLE `sequence_order_22` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_22`
--


--
-- Table structure for table `sequence_order_23`
--

CREATE TABLE `sequence_order_23` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_23`
--


--
-- Table structure for table `sequence_order_24`
--

CREATE TABLE `sequence_order_24` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_24`
--


--
-- Table structure for table `sequence_order_25`
--

CREATE TABLE `sequence_order_25` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_25`
--


--
-- Table structure for table `sequence_order_26`
--

CREATE TABLE `sequence_order_26` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_26`
--


--
-- Table structure for table `sequence_order_27`
--

CREATE TABLE `sequence_order_27` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_27`
--

INSERT INTO `sequence_order_27` VALUES (1),(2),(3),(4),(5);

--
-- Table structure for table `sequence_order_28`
--

CREATE TABLE `sequence_order_28` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_28`
--


--
-- Table structure for table `sequence_order_29`
--

CREATE TABLE `sequence_order_29` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_29`
--


--
-- Table structure for table `sequence_order_3`
--

CREATE TABLE `sequence_order_3` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_3`
--


--
-- Table structure for table `sequence_order_30`
--

CREATE TABLE `sequence_order_30` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_30`
--


--
-- Table structure for table `sequence_order_31`
--

CREATE TABLE `sequence_order_31` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_31`
--


--
-- Table structure for table `sequence_order_32`
--

CREATE TABLE `sequence_order_32` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_32`
--


--
-- Table structure for table `sequence_order_33`
--

CREATE TABLE `sequence_order_33` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_33`
--


--
-- Table structure for table `sequence_order_34`
--

CREATE TABLE `sequence_order_34` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_34`
--


--
-- Table structure for table `sequence_order_35`
--

CREATE TABLE `sequence_order_35` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_35`
--


--
-- Table structure for table `sequence_order_36`
--

CREATE TABLE `sequence_order_36` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_36`
--


--
-- Table structure for table `sequence_order_37`
--

CREATE TABLE `sequence_order_37` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_37`
--

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

--
-- Table structure for table `sequence_order_38`
--

CREATE TABLE `sequence_order_38` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_38`
--

INSERT INTO `sequence_order_38` VALUES (1);

--
-- Table structure for table `sequence_order_39`
--

CREATE TABLE `sequence_order_39` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_39`
--


--
-- Table structure for table `sequence_order_4`
--

CREATE TABLE `sequence_order_4` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_4`
--

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

--
-- Table structure for table `sequence_order_40`
--

CREATE TABLE `sequence_order_40` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_40`
--


--
-- Table structure for table `sequence_order_41`
--

CREATE TABLE `sequence_order_41` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_41`
--


--
-- Table structure for table `sequence_order_5`
--

CREATE TABLE `sequence_order_5` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_5`
--


--
-- Table structure for table `sequence_order_6`
--

CREATE TABLE `sequence_order_6` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_6`
--

INSERT INTO `sequence_order_6` VALUES (1);

--
-- Table structure for table `sequence_order_7`
--

CREATE TABLE `sequence_order_7` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_7`
--


--
-- Table structure for table `sequence_order_8`
--

CREATE TABLE `sequence_order_8` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_8`
--

INSERT INTO `sequence_order_8` VALUES (1);

--
-- Table structure for table `sequence_order_9`
--

CREATE TABLE `sequence_order_9` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_order_9`
--


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

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

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


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

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

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


--
-- Table structure for table `sequence_shipment_10`
--

CREATE TABLE `sequence_shipment_10` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_10`
--


--
-- Table structure for table `sequence_shipment_11`
--

CREATE TABLE `sequence_shipment_11` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_11`
--


--
-- Table structure for table `sequence_shipment_12`
--

CREATE TABLE `sequence_shipment_12` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_12`
--


--
-- Table structure for table `sequence_shipment_13`
--

CREATE TABLE `sequence_shipment_13` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_13`
--


--
-- Table structure for table `sequence_shipment_14`
--

CREATE TABLE `sequence_shipment_14` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_14`
--


--
-- Table structure for table `sequence_shipment_15`
--

CREATE TABLE `sequence_shipment_15` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_15`
--


--
-- Table structure for table `sequence_shipment_16`
--

CREATE TABLE `sequence_shipment_16` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_16`
--


--
-- Table structure for table `sequence_shipment_17`
--

CREATE TABLE `sequence_shipment_17` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_17`
--


--
-- Table structure for table `sequence_shipment_18`
--

CREATE TABLE `sequence_shipment_18` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_18`
--


--
-- Table structure for table `sequence_shipment_2`
--

CREATE TABLE `sequence_shipment_2` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_2`
--


--
-- Table structure for table `sequence_shipment_20`
--

CREATE TABLE `sequence_shipment_20` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_20`
--


--
-- Table structure for table `sequence_shipment_21`
--

CREATE TABLE `sequence_shipment_21` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_21`
--


--
-- Table structure for table `sequence_shipment_22`
--

CREATE TABLE `sequence_shipment_22` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_22`
--


--
-- Table structure for table `sequence_shipment_23`
--

CREATE TABLE `sequence_shipment_23` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_23`
--


--
-- Table structure for table `sequence_shipment_24`
--

CREATE TABLE `sequence_shipment_24` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_24`
--


--
-- Table structure for table `sequence_shipment_25`
--

CREATE TABLE `sequence_shipment_25` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_25`
--


--
-- Table structure for table `sequence_shipment_26`
--

CREATE TABLE `sequence_shipment_26` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_26`
--


--
-- Table structure for table `sequence_shipment_27`
--

CREATE TABLE `sequence_shipment_27` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_27`
--


--
-- Table structure for table `sequence_shipment_28`
--

CREATE TABLE `sequence_shipment_28` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_28`
--


--
-- Table structure for table `sequence_shipment_29`
--

CREATE TABLE `sequence_shipment_29` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_29`
--


--
-- Table structure for table `sequence_shipment_3`
--

CREATE TABLE `sequence_shipment_3` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_3`
--


--
-- Table structure for table `sequence_shipment_30`
--

CREATE TABLE `sequence_shipment_30` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_30`
--


--
-- Table structure for table `sequence_shipment_31`
--

CREATE TABLE `sequence_shipment_31` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_31`
--


--
-- Table structure for table `sequence_shipment_32`
--

CREATE TABLE `sequence_shipment_32` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_32`
--


--
-- Table structure for table `sequence_shipment_33`
--

CREATE TABLE `sequence_shipment_33` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_33`
--


--
-- Table structure for table `sequence_shipment_34`
--

CREATE TABLE `sequence_shipment_34` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_34`
--


--
-- Table structure for table `sequence_shipment_35`
--

CREATE TABLE `sequence_shipment_35` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_35`
--


--
-- Table structure for table `sequence_shipment_36`
--

CREATE TABLE `sequence_shipment_36` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_36`
--


--
-- Table structure for table `sequence_shipment_37`
--

CREATE TABLE `sequence_shipment_37` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_37`
--


--
-- Table structure for table `sequence_shipment_38`
--

CREATE TABLE `sequence_shipment_38` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_38`
--


--
-- Table structure for table `sequence_shipment_39`
--

CREATE TABLE `sequence_shipment_39` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_39`
--


--
-- Table structure for table `sequence_shipment_4`
--

CREATE TABLE `sequence_shipment_4` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_4`
--


--
-- Table structure for table `sequence_shipment_40`
--

CREATE TABLE `sequence_shipment_40` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_40`
--


--
-- Table structure for table `sequence_shipment_41`
--

CREATE TABLE `sequence_shipment_41` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_41`
--


--
-- Table structure for table `sequence_shipment_5`
--

CREATE TABLE `sequence_shipment_5` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_5`
--


--
-- Table structure for table `sequence_shipment_6`
--

CREATE TABLE `sequence_shipment_6` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_6`
--


--
-- Table structure for table `sequence_shipment_7`
--

CREATE TABLE `sequence_shipment_7` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_7`
--


--
-- Table structure for table `sequence_shipment_8`
--

CREATE TABLE `sequence_shipment_8` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_8`
--


--
-- Table structure for table `sequence_shipment_9`
--

CREATE TABLE `sequence_shipment_9` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence_shipment_9`
--


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

CREATE TABLE `session` (
  `session_id` varchar(255) NOT NULL COMMENT 'Session Id',
  `session_expires` int(10) 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=utf8 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=utf8 COMMENT='Module versions registry';

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

INSERT INTO `setup_module` VALUES ('Amazon_Core','4.0.4','4.0.4'),('Amazon_Login','4.0.4','4.0.4'),('Amazon_Payment','4.0.4','4.0.4'),('Dotdigitalgroup_Chat','1.2.0','1.2.0'),('Dotdigitalgroup_Email','4.8.0','4.8.0'),('Klarna_Core','6.0.2','6.0.2'),('Klarna_Kp','7.1.0','7.1.0'),('Klarna_KpGraphQl','0.9.0','0.9.0'),('Klarna_Onsitemessaging','1.0.2','1.0.2'),('Klarna_Ordermanagement','6.0.3','6.0.3'),('Magefan_Blog','2.9.4','2.9.4'),('Magefan_Community','2.0.12','2.0.12'),('Magefan_WysiwygAdvanced','2.0.7','2.0.7'),('Magento_AdminNotification','2.0.0','2.0.0'),('Magento_AdvancedPricingImportExport','2.0.0','2.0.0'),('Magento_Analytics','2.0.0','2.0.0'),('Magento_Authorization','2.0.0','2.0.0'),('Magento_Authorizenet','2.0.0','2.0.0'),('Magento_AuthorizenetAcceptjs','1.0.0','1.0.0'),('Magento_Backend','2.0.0','2.0.0'),('Magento_Backup','2.0.0','2.0.0'),('Magento_Braintree','2.0.1','2.0.1'),('Magento_Bundle','2.0.4','2.0.4'),('Magento_BundleImportExport','2.0.0','2.0.0'),('Magento_CacheInvalidate','2.0.0','2.0.0'),('Magento_Captcha','2.0.0','2.0.0'),('Magento_Catalog','2.2.6','2.2.6'),('Magento_CatalogAnalytics','2.0.0','2.0.0'),('Magento_CatalogImportExport','2.0.0','2.0.0'),('Magento_CatalogInventory','2.3.0','2.3.0'),('Magento_CatalogRule','2.1.0','2.1.0'),('Magento_CatalogRuleConfigurable','2.0.0','2.0.0'),('Magento_CatalogSearch','2.0.0','2.0.0'),('Magento_CatalogUrlRewrite','2.0.0','2.0.0'),('Magento_CatalogWidget','2.0.0','2.0.0'),('Magento_Checkout','2.0.0','2.0.0'),('Magento_CheckoutAgreements','2.2.0','2.2.0'),('Magento_Cms','2.0.2','2.0.2'),('Magento_CmsUrlRewrite','2.0.0','2.0.0'),('Magento_Config','2.0.0','2.0.0'),('Magento_ConfigurableImportExport','2.0.0','2.0.0'),('Magento_ConfigurableProduct','2.2.1','2.2.1'),('Magento_ConfigurableProductSales','2.2.0','2.2.0'),('Magento_Contact','2.0.0','2.0.0'),('Magento_Cookie','2.0.0','2.0.0'),('Magento_Cron','2.0.0','2.0.0'),('Magento_CurrencySymbol','2.0.1','2.0.1'),('Magento_Customer','2.0.13','2.0.13'),('Magento_CustomerAnalytics','2.0.0','2.0.0'),('Magento_CustomerImportExport','2.0.0','2.0.0'),('Magento_Deploy','2.0.0','2.0.0'),('Magento_Developer','2.0.0','2.0.0'),('Magento_Dhl','2.0.0','2.0.0'),('Magento_Directory','2.0.2','2.0.2'),('Magento_Downloadable','2.0.2','2.0.2'),('Magento_DownloadableImportExport','2.0.0','2.0.0'),('Magento_Eav','2.1.1','2.1.1'),('Magento_Email','2.0.0','2.0.0'),('Magento_EncryptionKey','2.0.0','2.0.0'),('Magento_Fedex','2.0.0','2.0.0'),('Magento_GiftMessage','2.0.1','2.0.1'),('Magento_GoogleAdwords','2.0.0','2.0.0'),('Magento_GoogleAnalytics','2.0.0','2.0.0'),('Magento_GoogleOptimizer','2.0.0','2.0.0'),('Magento_GoogleShoppingAds','4.0.1','4.0.1'),('Magento_GroupedImportExport','2.0.0','2.0.0'),('Magento_GroupedProduct','2.0.1','2.0.1'),('Magento_ImportExport','2.0.1','2.0.1'),('Magento_Indexer','2.1.0','2.1.0'),('Magento_InstantPurchase','1.0.0','1.0.0'),('Magento_Integration','2.2.1','2.2.1'),('Magento_Inventory','1.0.0','1.0.0'),('Magento_InventoryAdminUi','1.0.0','1.0.0'),('Magento_InventoryApi','1.0.0','1.0.0'),('Magento_InventoryBundleProduct','1.0.0','1.0.0'),('Magento_InventoryBundleProductAdminUi','1.0.0','1.0.0'),('Magento_InventoryCache','1.0.0','1.0.0'),('Magento_InventoryCatalog','1.0.0','1.0.0'),('Magento_InventoryCatalogAdminUi','1.0.0','1.0.0'),('Magento_InventoryCatalogApi','1.0.0','1.0.0'),('Magento_InventoryCatalogSearch','1.0.0','1.0.0'),('Magento_InventoryConfigurableProduct','1.0.0','1.0.0'),('Magento_InventoryConfigurableProductAdminUi','1.0.0','1.0.0'),('Magento_InventoryConfigurableProductIndexer','1.0.0','1.0.0'),('Magento_InventoryConfiguration','1.0.0','1.0.0'),('Magento_InventoryConfigurationApi','1.0.0','1.0.0'),('Magento_InventoryElasticsearch','1.0.0','1.0.0'),('Magento_InventoryExportStock','1.0.0','1.0.0'),('Magento_InventoryExportStockApi','1.0.0','1.0.0'),('Magento_InventoryGroupedProduct','1.0.0','1.0.0'),('Magento_InventoryGroupedProductAdminUi','1.0.0','1.0.0'),('Magento_InventoryGroupedProductIndexer','1.0.0','1.0.0'),('Magento_InventoryImportExport','1.0.0','1.0.0'),('Magento_InventoryIndexer','1.0.0','1.0.0'),('Magento_InventoryLowQuantityNotification','1.0.0','1.0.0'),('Magento_InventoryLowQuantityNotificationAdminUi','1.0.0','1.0.0'),('Magento_InventoryLowQuantityNotificationApi','1.0.0','1.0.0'),('Magento_InventoryMultiDimensionalIndexerApi','1.0.0','1.0.0'),('Magento_InventoryProductAlert','1.0.0','1.0.0'),('Magento_InventoryReservationCli','1.0.0','1.0.0'),('Magento_InventoryReservations','1.0.0','1.0.0'),('Magento_InventoryReservationsApi','1.0.0','1.0.0'),('Magento_InventorySales','1.0.0','1.0.0'),('Magento_InventorySalesAdminUi','1.0.0','1.0.0'),('Magento_InventorySalesApi','1.0.0','1.0.0'),('Magento_InventoryShipping','1.0.0','1.0.0'),('Magento_InventoryShippingAdminUi','1.0.0','1.0.0'),('Magento_InventorySourceDeductionApi','1.0.0','1.0.0'),('Magento_InventorySourceSelection','1.0.0','1.0.0'),('Magento_InventorySourceSelectionApi','1.0.0','1.0.0'),('Magento_LayeredNavigation','2.0.0','2.0.0'),('Magento_Marketplace','1.0.0','1.0.0'),('Magento_MediaStorage','2.0.0','2.0.0'),('Magento_Msrp','2.1.3','2.1.3'),('Magento_Multishipping','2.0.0','2.0.0'),('Magento_NewRelicReporting','2.0.1','2.0.1'),('Magento_Newsletter','2.0.1','2.0.1'),('Magento_OfflinePayments','2.0.0','2.0.0'),('Magento_OfflineShipping','2.0.1','2.0.1'),('Magento_PageCache','2.0.0','2.0.0'),('Magento_Payment','2.0.0','2.0.0'),('Magento_Paypal','2.0.1','2.0.1'),('Magento_PaypalReCaptcha','2.0.0','2.0.0'),('Magento_Persistent','2.0.0','2.0.0'),('Magento_ProductAlert','2.0.0','2.0.0'),('Magento_ProductVideo','2.0.0.2','2.0.0.2'),('Magento_Quote','2.0.8','2.0.8'),('Magento_QuoteAnalytics','2.0.0','2.0.0'),('Magento_ReleaseNotification','2.2.0','2.2.0'),('Magento_Reports','2.0.0','2.0.0'),('Magento_RequireJs','2.0.0','2.0.0'),('Magento_Review','2.0.0','2.0.0'),('Magento_ReviewAnalytics','2.0.0','2.0.0'),('Magento_Robots','2.0.0','2.0.0'),('Magento_Rss','2.0.0','2.0.0'),('Magento_Rule','2.0.0','2.0.0'),('Magento_Sales','2.0.10','2.0.10'),('Magento_SalesAnalytics','2.0.0','2.0.0'),('Magento_SalesInventory','1.0.0','1.0.0'),('Magento_SalesRule','2.0.3','2.0.3'),('Magento_SalesSequence','2.0.0','2.0.0'),('Magento_SampleData','2.0.0','2.0.0'),('Magento_Search','2.0.4','2.0.4'),('Magento_Security','2.0.1','2.0.1'),('Magento_Securitytxt','1.0.0','1.0.0'),('Magento_SendFriend','2.0.0','2.0.0'),('Magento_Shipping','2.0.0','2.0.0'),('Magento_Signifyd','2.2.0','2.2.0'),('Magento_Sitemap','2.0.0','2.0.0'),('Magento_Store','2.1.0','2.1.0'),('Magento_Swagger','2.0.0','2.0.0'),('Magento_SwaggerWebapi','1.0.0','1.0.0'),('Magento_Swatches','2.0.3','2.0.3'),('Magento_SwatchesLayeredNavigation','2.0.0','2.0.0'),('Magento_Tax','2.0.3','2.0.3'),('Magento_TaxImportExport','2.0.0','2.0.0'),('Magento_Theme','2.0.2','2.0.2'),('Magento_Translation','2.0.0','2.0.0'),('Magento_Ui','2.0.0','2.0.0'),('Magento_Ups','2.0.0','2.0.0'),('Magento_UrlRewrite','2.0.1','2.0.1'),('Magento_User','2.0.3','2.0.3'),('Magento_Usps','2.0.1','2.0.1'),('Magento_Variable','2.0.0','2.0.0'),('Magento_Vault','2.0.3','2.0.3'),('Magento_Version','2.0.0','2.0.0'),('Magento_Webapi','2.0.0','2.0.0'),('Magento_WebapiSecurity','2.0.0','2.0.0'),('Magento_Weee','2.0.0','2.0.0'),('Magento_Widget','2.0.1','2.0.1'),('Magento_Wishlist','2.0.1','2.0.1'),('Magento_WishlistAnalytics','2.0.0','2.0.0'),('Magepow_Ajaxcart','1.1.4','1.1.4'),('Magepow_Gdpr','1.0.0','1.0.0'),('Magepow_Layerednav','1.0.0','1.0.0'),('Magepow_Lazyload','2.0','2.0'),('Magepow_Productzoom','2.0','2.0'),('Magepow_Quickedit','2.0','2.0'),('Magepow_SpeedOptimizer','1.0.0','1.0.0'),('Magepow_Stickycart','1.0.0','1.0.0'),('MageWorx_SearchSuiteAutocomplete','2.0.0','2.0.0'),('Magiccart_Alothemes','2.0','2.0'),('Magiccart_Lookbook','2.0','2.0'),('Magiccart_Magicmenu','2.0','2.0'),('Magiccart_Magicproduct','2.0','2.0'),('Magiccart_Magicslider','2.1','2.1'),('Magiccart_Shopbrand','2.0','2.0'),('Magiccart_Testimonial','2.1','2.1'),('MSP_ReCaptcha','1.6.0','1.6.0'),('MSP_TwoFactorAuth','3.1.0','3.1.0'),('PayPal_Braintree','4.0.3','4.0.3'),('Shopial_Facebook','1.0.0','1.0.0'),('Temando_Shipping','1.6.0','1.6.0'),('Vertex_AddressValidation','100.5.0','100.5.0'),('Vertex_Tax','100.5.1','100.5.1'),('Yotpo_Yotpo','3.1.2','3.1.2');

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

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

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


--
-- Table structure for table `signifyd_case`
--

CREATE TABLE `signifyd_case` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity_id',
  `order_id` int(10) unsigned DEFAULT NULL COMMENT 'Order_id',
  `case_id` int(10) unsigned DEFAULT NULL COMMENT 'Case_id',
  `guarantee_eligible` tinyint(1) DEFAULT NULL COMMENT 'Guarantee_eligible',
  `guarantee_disposition` varchar(32) DEFAULT 'PENDING' COMMENT 'Guarantee_disposition',
  `status` varchar(32) DEFAULT 'PENDING' COMMENT 'Status',
  `score` int(10) unsigned DEFAULT NULL COMMENT 'Score',
  `associated_team` text COMMENT 'Associated_team',
  `review_disposition` varchar(32) DEFAULT NULL COMMENT 'Review_disposition',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created_at',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated_at',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SIGNIFYD_CASE_ORDER_ID` (`order_id`),
  UNIQUE KEY `SIGNIFYD_CASE_CASE_ID` (`case_id`),
  CONSTRAINT `SIGNIFYD_CASE_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='signifyd_case';

--
-- Dumping data for table `signifyd_case`
--


--
-- Table structure for table `sitemap`
--

CREATE TABLE `sitemap` (
  `sitemap_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Sitemap ID',
  `sitemap_type` varchar(32) DEFAULT NULL COMMENT 'Sitemap Type',
  `sitemap_filename` varchar(32) DEFAULT NULL COMMENT 'Sitemap Filename',
  `sitemap_path` varchar(255) DEFAULT NULL COMMENT 'Sitemap Path',
  `sitemap_time` timestamp NULL DEFAULT NULL COMMENT 'Sitemap Time',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`sitemap_id`),
  KEY `SITEMAP_STORE_ID` (`store_id`),
  CONSTRAINT `SITEMAP_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='XML Sitemap';

--
-- Dumping data for table `sitemap`
--


--
-- Table structure for table `store`
--

CREATE TABLE `store` (
  `store_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Store ID',
  `code` varchar(32) DEFAULT NULL COMMENT 'Code',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Group ID',
  `name` varchar(255) NOT NULL COMMENT 'Store Name',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Sort Order',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Activity',
  PRIMARY KEY (`store_id`),
  UNIQUE KEY `STORE_CODE` (`code`),
  KEY `STORE_WEBSITE_ID` (`website_id`),
  KEY `STORE_IS_ACTIVE_SORT_ORDER` (`is_active`,`sort_order`),
  KEY `STORE_GROUP_ID` (`group_id`),
  CONSTRAINT `STORE_GROUP_ID_STORE_GROUP_GROUP_ID` FOREIGN KEY (`group_id`) REFERENCES `store_group` (`group_id`) ON DELETE CASCADE,
  CONSTRAINT `STORE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='Stores';

--
-- Dumping data for table `store`
--

INSERT INTO `store` VALUES (0,'admin',0,0,'Admin',0,1),(1,'default',1,1,'English',0,1),(2,'french',1,1,'French',0,1),(3,'german',1,1,'German',0,1),(4,'english_3',1,2,'English 3',0,1),(5,'french_3',1,2,'French',0,1),(6,'english_4',1,3,'English 4',0,1),(7,'french_4',1,3,'French',0,1),(8,'english_6',1,4,'English 6',0,1),(9,'french_6',1,4,'French',0,1),(10,'english_7',1,5,'English 7',0,1),(11,'french_7',1,5,'French',0,1),(12,'english_8',1,6,'English 8',0,1),(13,'french_8',1,6,'French',0,1),(14,'english_5',1,7,'English 5',0,1),(15,'french_5',1,7,'French',0,1),(16,'english_2',1,8,'English 2',0,1),(17,'french_2',1,8,'French',0,1),(18,'ar',1,1,'Arabic',0,1),(20,'ar_2',1,8,'Arabic',0,1),(21,'ar_3',1,2,'Arabic',0,1),(22,'ar_4',1,3,'Arabic',0,1),(23,'ar_5',1,7,'Arabic',0,1),(24,'ar_6',1,4,'Arabic',0,1),(25,'ar_7',1,5,'Arabic',0,1),(26,'ar_8',1,6,'Arabic',0,1),(27,'english_10',1,9,'English 10',0,1),(28,'french_10',1,9,'French',0,1),(29,'ar_10',1,9,'Arabic',0,1),(30,'english_11',1,10,'English 11',0,1),(31,'ar_11',1,10,'Arabic',0,1),(32,'english_12',1,11,'English 12',0,1),(33,'ar_12',1,11,'Arabic',0,1),(34,'english_13',1,12,'English 13',0,1),(35,'ar_13',1,12,'Arabic',0,1),(36,'english_14',1,13,'English 14',0,1),(37,'english_15',1,14,'English 15',0,1),(38,'english_16',1,15,'English 16',0,1),(39,'ar_14',1,13,'Arabic',0,1),(40,'ar_15',1,14,'Arabic',0,1),(41,'ar_16',1,15,'Arabic',0,1);

--
-- Table structure for table `store_group`
--

CREATE TABLE `store_group` (
  `group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Group ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `code` varchar(32) DEFAULT NULL COMMENT 'Store group unique code',
  `name` varchar(255) NOT NULL COMMENT 'Store Group Name',
  `root_category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Root Category ID',
  `default_store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Default Store ID',
  PRIMARY KEY (`group_id`),
  UNIQUE KEY `STORE_GROUP_CODE` (`code`),
  KEY `STORE_GROUP_WEBSITE_ID` (`website_id`),
  KEY `STORE_GROUP_DEFAULT_STORE_ID` (`default_store_id`),
  CONSTRAINT `STORE_GROUP_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='Store Groups';

--
-- Dumping data for table `store_group`
--

INSERT INTO `store_group` VALUES (0,0,'default','Default',0,0),(1,1,'demo_1','Demo 1',2,1),(2,1,'demo_3','Demo 3',2,4),(3,1,'demo_4','Demo 4',2,6),(4,1,'demo_6','Demo 6',2,8),(5,1,'demo_7','Demo 7',2,10),(6,1,'demo_8','Demo 8',2,12),(7,1,'demo_5','Demo 5',2,14),(8,1,'demo_2','Demo 2',2,16),(9,1,'demo_10','Demo 10',2,27),(10,1,'demo_11','Demo 11',2,30),(11,1,'demo_12','Demo 12',2,32),(12,1,'demo_13','Demo 13',92,34),(13,1,'demo_14','Demo 14',124,36),(14,1,'demo_15','Demo 15',157,37),(15,1,'demo_16','Demo 16',189,38);

--
-- Table structure for table `store_website`
--

CREATE TABLE `store_website` (
  `website_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Website ID',
  `code` varchar(32) DEFAULT NULL COMMENT 'Code',
  `name` varchar(64) DEFAULT NULL COMMENT 'Website Name',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `default_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Default Group ID',
  `is_default` smallint(5) unsigned DEFAULT '0' COMMENT 'Defines Is Website Default',
  PRIMARY KEY (`website_id`),
  UNIQUE KEY `STORE_WEBSITE_CODE` (`code`),
  KEY `STORE_WEBSITE_SORT_ORDER` (`sort_order`),
  KEY `STORE_WEBSITE_DEFAULT_GROUP_ID` (`default_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Websites';

--
-- Dumping data for table `store_website`
--

INSERT INTO `store_website` VALUES (0,'admin','Admin',0,0,0),(1,'base','Main Website',0,1,1);

--
-- Table structure for table `tax_calculation`
--

CREATE TABLE `tax_calculation` (
  `tax_calculation_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation ID',
  `tax_calculation_rate_id` int(11) NOT NULL COMMENT 'Tax Calculation Rate ID',
  `tax_calculation_rule_id` int(11) NOT NULL COMMENT 'Tax Calculation Rule ID',
  `customer_tax_class_id` smallint(6) NOT NULL COMMENT 'Customer Tax Class ID',
  `product_tax_class_id` smallint(6) NOT NULL COMMENT 'Product Tax Class ID',
  PRIMARY KEY (`tax_calculation_id`),
  KEY `TAX_CALCULATION_TAX_CALCULATION_RULE_ID` (`tax_calculation_rule_id`),
  KEY `TAX_CALCULATION_CUSTOMER_TAX_CLASS_ID` (`customer_tax_class_id`),
  KEY `TAX_CALCULATION_PRODUCT_TAX_CLASS_ID` (`product_tax_class_id`),
  KEY `TAX_CALC_TAX_CALC_RATE_ID_CSTR_TAX_CLASS_ID_PRD_TAX_CLASS_ID` (`tax_calculation_rate_id`,`customer_tax_class_id`,`product_tax_class_id`),
  CONSTRAINT `TAX_CALCULATION_CUSTOMER_TAX_CLASS_ID_TAX_CLASS_CLASS_ID` FOREIGN KEY (`customer_tax_class_id`) REFERENCES `tax_class` (`class_id`) ON DELETE CASCADE,
  CONSTRAINT `TAX_CALCULATION_PRODUCT_TAX_CLASS_ID_TAX_CLASS_CLASS_ID` FOREIGN KEY (`product_tax_class_id`) REFERENCES `tax_class` (`class_id`) ON DELETE CASCADE,
  CONSTRAINT `TAX_CALC_TAX_CALC_RATE_ID_TAX_CALC_RATE_TAX_CALC_RATE_ID` FOREIGN KEY (`tax_calculation_rate_id`) REFERENCES `tax_calculation_rate` (`tax_calculation_rate_id`) ON DELETE CASCADE,
  CONSTRAINT `TAX_CALC_TAX_CALC_RULE_ID_TAX_CALC_RULE_TAX_CALC_RULE_ID` FOREIGN KEY (`tax_calculation_rule_id`) REFERENCES `tax_calculation_rule` (`tax_calculation_rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Calculation';

--
-- Dumping data for table `tax_calculation`
--


--
-- Table structure for table `tax_calculation_rate`
--

CREATE TABLE `tax_calculation_rate` (
  `tax_calculation_rate_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation Rate ID',
  `tax_country_id` varchar(2) NOT NULL COMMENT 'Tax Country ID',
  `tax_region_id` int(11) NOT NULL COMMENT 'Tax Region ID',
  `tax_postcode` varchar(21) DEFAULT NULL COMMENT 'Tax Postcode',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `rate` decimal(12,4) NOT NULL COMMENT 'Rate',
  `zip_is_range` smallint(6) DEFAULT NULL COMMENT 'Zip Is Range',
  `zip_from` int(10) unsigned DEFAULT NULL COMMENT 'Zip From',
  `zip_to` int(10) unsigned DEFAULT NULL COMMENT 'Zip To',
  PRIMARY KEY (`tax_calculation_rate_id`),
  KEY `TAX_CALCULATION_RATE_TAX_COUNTRY_ID_TAX_REGION_ID_TAX_POSTCODE` (`tax_country_id`,`tax_region_id`,`tax_postcode`),
  KEY `TAX_CALCULATION_RATE_CODE` (`code`),
  KEY `IDX_CA799F1E2CB843495F601E56C84A626D` (`tax_calculation_rate_id`,`tax_country_id`,`tax_region_id`,`zip_is_range`,`tax_postcode`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Tax Calculation Rate';

--
-- Dumping data for table `tax_calculation_rate`
--

INSERT INTO `tax_calculation_rate` VALUES (1,'US',12,'*','US-CA-*-Rate 1',8.2500,NULL,NULL,NULL),(2,'US',43,'*','US-NY-*-Rate 1',8.3750,NULL,NULL,NULL);

--
-- Table structure for table `tax_calculation_rate_title`
--

CREATE TABLE `tax_calculation_rate_title` (
  `tax_calculation_rate_title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation Rate Title ID',
  `tax_calculation_rate_id` int(11) NOT NULL COMMENT 'Tax Calculation Rate ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` varchar(255) NOT NULL COMMENT 'Value',
  PRIMARY KEY (`tax_calculation_rate_title_id`),
  KEY `TAX_CALCULATION_RATE_TITLE_TAX_CALCULATION_RATE_ID_STORE_ID` (`tax_calculation_rate_id`,`store_id`),
  KEY `TAX_CALCULATION_RATE_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_37FB965F786AD5897BB3AE90470C42AB` FOREIGN KEY (`tax_calculation_rate_id`) REFERENCES `tax_calculation_rate` (`tax_calculation_rate_id`) ON DELETE CASCADE,
  CONSTRAINT `TAX_CALCULATION_RATE_TITLE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Calculation Rate Title';

--
-- Dumping data for table `tax_calculation_rate_title`
--


--
-- Table structure for table `tax_calculation_rule`
--

CREATE TABLE `tax_calculation_rule` (
  `tax_calculation_rule_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation Rule ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `priority` int(11) NOT NULL COMMENT 'Priority',
  `position` int(11) NOT NULL COMMENT 'Position',
  `calculate_subtotal` int(11) NOT NULL COMMENT 'Calculate off subtotal option',
  PRIMARY KEY (`tax_calculation_rule_id`),
  KEY `TAX_CALCULATION_RULE_PRIORITY_POSITION` (`priority`,`position`),
  KEY `TAX_CALCULATION_RULE_CODE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Calculation Rule';

--
-- Dumping data for table `tax_calculation_rule`
--


--
-- Table structure for table `tax_class`
--

CREATE TABLE `tax_class` (
  `class_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Class ID',
  `class_name` varchar(255) NOT NULL COMMENT 'Class Name',
  `class_type` varchar(8) NOT NULL DEFAULT 'CUSTOMER' COMMENT 'Class Type',
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Tax Class';

--
-- Dumping data for table `tax_class`
--

INSERT INTO `tax_class` VALUES (2,'Taxable Goods','PRODUCT'),(3,'Retail Customer','CUSTOMER'),(4,'Refund Adjustments','PRODUCT'),(5,'Gift Options','PRODUCT'),(6,'Order Gift Wrapping','PRODUCT'),(7,'Item Gift Wrapping','PRODUCT'),(8,'Printed Gift Card','PRODUCT'),(9,'Reward Points','PRODUCT'),(10,'','CUSTOMER');

--
-- Table structure for table `tax_order_aggregated_created`
--

CREATE TABLE `tax_order_aggregated_created` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `percent` float DEFAULT NULL COMMENT 'Percent',
  `orders_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `tax_base_amount_sum` float DEFAULT NULL COMMENT 'Tax Base Amount Sum',
  PRIMARY KEY (`id`),
  UNIQUE KEY `TAX_ORDER_AGGRED_CREATED_PERIOD_STORE_ID_CODE_PERCENT_ORDER_STS` (`period`,`store_id`,`code`,`percent`,`order_status`),
  KEY `TAX_ORDER_AGGREGATED_CREATED_STORE_ID` (`store_id`),
  CONSTRAINT `TAX_ORDER_AGGREGATED_CREATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Order Aggregation';

--
-- Dumping data for table `tax_order_aggregated_created`
--


--
-- Table structure for table `tax_order_aggregated_updated`
--

CREATE TABLE `tax_order_aggregated_updated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `percent` float DEFAULT NULL COMMENT 'Percent',
  `orders_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `tax_base_amount_sum` float DEFAULT NULL COMMENT 'Tax Base Amount Sum',
  PRIMARY KEY (`id`),
  UNIQUE KEY `TAX_ORDER_AGGRED_UPDATED_PERIOD_STORE_ID_CODE_PERCENT_ORDER_STS` (`period`,`store_id`,`code`,`percent`,`order_status`),
  KEY `TAX_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `TAX_ORDER_AGGREGATED_UPDATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Order Aggregated Updated';

--
-- Dumping data for table `tax_order_aggregated_updated`
--


--
-- Table structure for table `temando_product_attribute_mapping`
--

CREATE TABLE `temando_product_attribute_mapping` (
  `node_path_id` varchar(255) NOT NULL COMMENT 'Magento shipping path',
  `label` varchar(255) NOT NULL COMMENT 'label to be displayed to the end user',
  `description` text COMMENT 'Describes what the label and path are for',
  `mapping_attribute_id` varchar(255) DEFAULT NULL COMMENT 'Attribute ID reference that is mapped to the node path',
  `is_default` tinyint(1) NOT NULL COMMENT 'Determines if the attribute is available by default',
  PRIMARY KEY (`node_path_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Attribute Mapping Entity';

--
-- Dumping data for table `temando_product_attribute_mapping`
--

INSERT INTO `temando_product_attribute_mapping` VALUES ('classificationCodes.eccn','ECCN','Export Control Classification Number. Field Validation: 5 maximum characters.',NULL,1),('classificationCodes.hsCode','HS Code','Harmonized Commodity Description and Coding System. Field Validation: Between 2 and 5 Characters.','ts_hs_code',1),('classificationCodes.scheduleBInfo','Schedule B Info','Code for exporting goods out of the United States. Field Validation: 15 maximum characters.',NULL,1),('composition','Composition','Materials product is composed of',NULL,1),('manufacture.address.countryCode','Country of manufacture','Country of manufacture. Field Validation: Country as a valid ISO 3166-1 alpha-2 country code.',NULL,1),('origin.address.countryCode','Country of origin','Country of origin. Field Validation: Country as a valid ISO 3166-1 alpha-2 country code.','ts_country_of_origin',1);

--
-- Table structure for table `tfa_user_config`
--

CREATE TABLE `tfa_user_config` (
  `msp_tfa_user_config_id` int(10) unsigned NOT NULL COMMENT 'TFA admin user ID',
  `user_id` int(10) unsigned NOT NULL COMMENT 'User ID',
  `encoded_providers` text COMMENT 'Encoded providers list',
  `encoded_config` text COMMENT 'Encoded providers configuration',
  `default_provider` text COMMENT 'Default provider',
  PRIMARY KEY (`msp_tfa_user_config_id`),
  KEY `MSP_TFA_USER_CONFIG_USER_ID_ADMIN_USER_USER_ID` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='msp_tfa_user_config';

--
-- Dumping data for table `tfa_user_config`
--

INSERT INTO `tfa_user_config` VALUES (1,1,'[\"\"]','0:3:xsQCzAkopQpooZ5OdDim/qihNAL6qj9xStbzd5qe',NULL),(2,3,'[]','0:3:FVkOw+DxaUUXjUPB/v9kUw/ySm9PPffwDMjlYYus',NULL);

--
-- Table structure for table `theme`
--

CREATE TABLE `theme` (
  `theme_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Theme identifier',
  `parent_id` int(11) DEFAULT NULL COMMENT 'Parent ID',
  `theme_path` varchar(255) DEFAULT NULL COMMENT 'Theme Path',
  `theme_title` varchar(255) NOT NULL COMMENT 'Theme Title',
  `preview_image` varchar(255) DEFAULT NULL COMMENT 'Preview Image',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Theme Featured',
  `area` varchar(255) NOT NULL COMMENT 'Theme Area',
  `type` smallint(6) NOT NULL COMMENT 'Theme type: 0:physical, 1:virtual, 2:staging',
  `code` text COMMENT 'Full theme code, including package',
  PRIMARY KEY (`theme_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Core theme';

--
-- Dumping data for table `theme`
--

INSERT INTO `theme` VALUES (1,NULL,'Magento/blank','Magento Blank','preview_image_570478c36b7d7.jpeg',0,'frontend',0,'Magento/blank'),(2,1,'Magento/luma','Magento Luma','preview_image_570478c395ee9.jpeg',0,'frontend',0,'Magento/luma'),(3,NULL,'Magento/backend','Magento 2 backend',NULL,0,'adminhtml',0,'Magento/backend'),(4,1,'Alothemes/milano','Alothemes Milano','preview_image_570490714dd96.jpeg',0,'frontend',0,'Alothemes/milano'),(5,4,'Alothemes/milano3','Alothemes Milano3','preview_image_573972e7448b5.jpeg',0,'frontend',0,'Alothemes/milano3'),(6,4,'Alothemes/milano4','Alothemes Milano4','preview_image_573972e7f20fb.jpeg',0,'frontend',0,'Alothemes/milano4'),(7,4,'Alothemes/milano6','Alothemes Milano6','preview_image_573ae02dc936b.jpeg',0,'frontend',0,'Alothemes/milano6'),(8,4,'Alothemes/milano7','Alothemes Milano7','preview_image_57bbbd5a755d2.jpeg',0,'frontend',0,'Alothemes/milano7'),(9,4,'Alothemes/milano8','Alothemes Milano8','preview_image_57bbf938f3ecb.jpeg',0,'frontend',0,'Alothemes/milano8'),(10,4,'Alothemes/milano5','Alothemes Milano5','preview_image_57bc2a13d2b14.jpeg',0,'frontend',0,'Alothemes/milano5'),(11,4,'Alothemes/milano2','Alothemes Milano2','preview_image_58476e2a58dea.jpeg',0,'frontend',0,'Alothemes/milano2'),(12,4,'Alothemes/milano10','Alothemes Milano10','preview_image_5ae408ffda554.jpeg',0,'frontend',0,'Alothemes/milano10'),(13,4,'Alothemes/milano11','Alothemes Milano11','preview_image_5cee500820f8c.jpeg',0,'frontend',0,'Alothemes/milano11'),(14,4,'Alothemes/milano12','Alothemes Milano12','preview_image_5cee500845c24.jpeg',0,'frontend',0,'Alothemes/milano12'),(15,4,'Alothemes/milano13','Alothemes Milano13','preview_image_5dedac7870dfe.jpeg',0,'frontend',0,'Alothemes/milano13'),(16,4,'Alothemes/milano16','Alothemes Milano16','preview_image_5dedaf694f3fb.jpeg',0,'frontend',0,'Alothemes/milano16'),(17,4,'Alothemes/milano14','Alothemes Milano14','preview_image_5dedaf6965a5b.jpeg',0,'frontend',0,'Alothemes/milano14'),(18,4,'Alothemes/milano15','Alothemes Milano15','preview_image_5dedaf69777cf.jpeg',0,'frontend',0,'Alothemes/milano15');

--
-- Table structure for table `theme_file`
--

CREATE TABLE `theme_file` (
  `theme_files_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Theme files identifier',
  `theme_id` int(10) unsigned NOT NULL COMMENT 'Theme ID',
  `file_path` varchar(255) DEFAULT NULL COMMENT 'Relative path to file',
  `file_type` varchar(32) NOT NULL COMMENT 'File Type',
  `content` longtext NOT NULL COMMENT 'File Content',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `is_temporary` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Temporary File',
  PRIMARY KEY (`theme_files_id`),
  KEY `THEME_FILE_THEME_ID_THEME_THEME_ID` (`theme_id`),
  CONSTRAINT `THEME_FILE_THEME_ID_THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `theme` (`theme_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Core theme files';

--
-- Dumping data for table `theme_file`
--


--
-- Table structure for table `translation`
--

CREATE TABLE `translation` (
  `key_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Key ID of Translation',
  `string` varchar(255) NOT NULL DEFAULT 'Translate String' COMMENT 'Translation String',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `translate` varchar(255) DEFAULT NULL COMMENT 'Translate',
  `locale` varchar(20) NOT NULL DEFAULT 'en_US' COMMENT 'Locale',
  `crc_string` bigint(20) NOT NULL DEFAULT '1591228201' COMMENT 'Translation String CRC32 Hash',
  PRIMARY KEY (`key_id`),
  UNIQUE KEY `TRANSLATION_STORE_ID_LOCALE_CRC_STRING_STRING` (`store_id`,`locale`,`crc_string`,`string`),
  CONSTRAINT `TRANSLATION_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Translations';

--
-- Dumping data for table `translation`
--


--
-- Table structure for table `ui_bookmark`
--

CREATE TABLE `ui_bookmark` (
  `bookmark_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Bookmark identifier',
  `user_id` int(10) unsigned NOT NULL COMMENT 'User ID',
  `namespace` varchar(255) NOT NULL COMMENT 'Bookmark namespace',
  `identifier` varchar(255) NOT NULL COMMENT 'Bookmark Identifier',
  `current` smallint(6) NOT NULL COMMENT 'Mark current bookmark per user and identifier',
  `title` varchar(255) DEFAULT NULL COMMENT 'Bookmark title',
  `config` longtext COMMENT 'Bookmark config',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Bookmark created at',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Bookmark updated at',
  PRIMARY KEY (`bookmark_id`),
  KEY `UI_BOOKMARK_USER_ID_NAMESPACE_IDENTIFIER` (`user_id`,`namespace`,`identifier`),
  CONSTRAINT `UI_BOOKMARK_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='Bookmark';

--
-- Dumping data for table `ui_bookmark`
--

INSERT INTO `ui_bookmark` VALUES (1,1,'cms_page_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"},\"columns\":{\"page_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"meta_keywords\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"custom_theme\":{\"visible\":false,\"sorting\":false},\"custom_root_template\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false},\"custom_theme_from\":{\"visible\":false,\"sorting\":false},\"custom_theme_to\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false}},\"positions\":{\"ids\":0,\"page_id\":1,\"title\":2,\"identifier\":3,\"page_layout\":4,\"store_id\":5,\"is_active\":6,\"creation_time\":7,\"update_time\":8,\"custom_theme_from\":9,\"custom_theme_to\":10,\"custom_theme\":11,\"custom_root_template\":12,\"meta_keywords\":13,\"meta_description\":14,\"actions\":15,\"meta_title\":16},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":200,\"pageSize\":200,\"current\":1},\"displayMode\":\"grid\"}}','1970-01-01 00:00:00','2019-12-09 02:01:43'),(2,1,'cms_page_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"},\"columns\":{\"page_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"meta_keywords\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"custom_theme\":{\"visible\":false,\"sorting\":false},\"custom_root_template\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false},\"custom_theme_from\":{\"visible\":false,\"sorting\":false},\"custom_theme_to\":{\"visible\":false,\"sorting\":false}},\"positions\":{\"ids\":0,\"page_id\":1,\"title\":2,\"identifier\":3,\"page_layout\":4,\"store_id\":5,\"is_active\":6,\"creation_time\":7,\"update_time\":8,\"custom_theme_from\":9,\"custom_theme_to\":10,\"custom_theme\":11,\"custom_root_template\":12,\"meta_keywords\":13,\"meta_description\":14,\"actions\":15},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','1970-01-01 00:00:00','1970-01-01 00:00:00'),(3,1,'cms_block_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"block_id\":{\"visible\":true,\"sorting\":false},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":\"asc\"},\"store_id\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":200,\"pageSize\":200,\"current\":1},\"positions\":{\"ids\":0,\"block_id\":1,\"title\":2,\"identifier\":3,\"store_id\":4,\"is_active\":5,\"creation_time\":6,\"update_time\":7,\"actions\":8},\"displayMode\":\"grid\"}}','1970-01-01 00:00:00','2019-12-31 03:56:07'),(4,1,'cms_block_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"block_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"block_id\":1,\"title\":2,\"identifier\":3,\"store_id\":4,\"is_active\":5,\"creation_time\":6,\"update_time\":7,\"actions\":8}},\"value\":\"Default View\"}}}','1970-01-01 00:00:00','1970-01-01 00:00:00'),(5,1,'product_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":false},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"cost\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":\"asc\"},\"attribute_set_id\":{\"visible\":true,\"sorting\":false},\"visibility\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"websites\":{\"visible\":true,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"size\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false},\"material\":{\"visible\":true,\"sorting\":false},\"pattern\":{\"visible\":true,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"salable_quantity\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":200,\"pageSize\":200,\"current\":1},\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"attribute_set_id\":5,\"sku\":6,\"price\":7,\"qty\":8,\"visibility\":9,\"status\":10,\"websites\":11,\"short_description\":12,\"special_price\":13,\"special_from_date\":14,\"special_to_date\":15,\"cost\":16,\"weight\":17,\"manufacturer\":18,\"meta_title\":19,\"meta_keyword\":20,\"meta_description\":21,\"color\":22,\"news_from_date\":23,\"news_to_date\":24,\"custom_design\":25,\"custom_design_from\":26,\"custom_design_to\":27,\"page_layout\":28,\"country_of_manufacture\":29,\"url_key\":30,\"msrp\":31,\"tax_class_id\":32,\"gift_message_available\":33,\"size\":34,\"actions\":35,\"material\":36,\"pattern\":37,\"custom_layout\":38,\"salable_quantity\":39},\"displayMode\":\"grid\",\"search\":{\"value\":\"\"}}}','1970-01-01 00:00:00','2020-04-20 15:33:58'),(6,1,'product_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"cost\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"attribute_set_id\":{\"visible\":true,\"sorting\":false},\"visibility\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"websites\":{\"visible\":true,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"size\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"attribute_set_id\":5,\"sku\":6,\"price\":7,\"qty\":8,\"visibility\":9,\"status\":10,\"websites\":11,\"short_description\":12,\"special_price\":13,\"special_from_date\":14,\"special_to_date\":15,\"cost\":16,\"weight\":17,\"manufacturer\":18,\"meta_title\":19,\"meta_keyword\":20,\"meta_description\":21,\"color\":22,\"news_from_date\":23,\"news_to_date\":24,\"custom_design\":25,\"custom_design_from\":26,\"custom_design_to\":27,\"page_layout\":28,\"country_of_manufacture\":29,\"url_key\":30,\"msrp\":31,\"tax_class_id\":32,\"gift_message_available\":33,\"size\":34,\"actions\":35}},\"value\":\"Default View\"}}}','1970-01-01 00:00:00','1970-01-01 00:00:00'),(7,1,'product_attributes_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"columns\":{\"attribute_code\":{\"visible\":true,\"sorting\":\"asc\"},\"frontend_label\":{\"visible\":true,\"sorting\":false},\"is_filterable\":{\"visible\":true,\"sorting\":false},\"is_required\":{\"visible\":true,\"sorting\":false},\"is_user_defined\":{\"visible\":true,\"sorting\":false},\"is_visible\":{\"visible\":true,\"sorting\":false},\"is_global\":{\"visible\":true,\"sorting\":false},\"is_searchable\":{\"visible\":true,\"sorting\":false},\"is_comparable\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"positions\":{\"ids\":0,\"is_filterable\":1,\"attribute_code\":2,\"frontend_label\":3,\"is_required\":4,\"is_user_defined\":5,\"is_visible\":6,\"is_global\":7,\"is_searchable\":8,\"is_comparable\":9},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','1970-01-01 00:00:00','1970-01-01 00:00:00'),(8,1,'product_attributes_listing','current',0,NULL,'{\"current\":{\"columns\":{\"attribute_code\":{\"visible\":true,\"sorting\":\"asc\"},\"frontend_label\":{\"visible\":true,\"sorting\":false},\"is_filterable\":{\"visible\":true,\"sorting\":false},\"is_required\":{\"visible\":true,\"sorting\":false},\"is_user_defined\":{\"visible\":true,\"sorting\":false},\"is_visible\":{\"visible\":true,\"sorting\":false},\"is_global\":{\"visible\":true,\"sorting\":false},\"is_searchable\":{\"visible\":true,\"sorting\":false},\"is_comparable\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"positions\":{\"ids\":0,\"is_filterable\":1,\"attribute_code\":2,\"frontend_label\":3,\"is_required\":4,\"is_user_defined\":5,\"is_visible\":6,\"is_global\":7,\"is_searchable\":8,\"is_comparable\":9},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20,\"pageSize\":20,\"current\":1},\"displayMode\":\"grid\"}}','0000-00-00 00:00:00','2019-12-10 07:31:26'),(9,1,'sales_order_shipment_grid','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"total_qty\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"shipping_name\":5,\"total_qty\":6,\"order_status\":7,\"store_id\":8,\"customer_name\":9,\"customer_email\":10,\"customer_group_id\":11,\"billing_address\":12,\"shipping_address\":13,\"payment_method\":14,\"shipping_information\":15,\"actions\":16}}}','1970-01-01 00:00:00','1970-01-01 00:00:00'),(10,1,'sales_order_shipment_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"total_qty\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"shipping_name\":5,\"total_qty\":6,\"order_status\":7,\"store_id\":8,\"customer_name\":9,\"customer_email\":10,\"customer_group_id\":11,\"billing_address\":12,\"shipping_address\":13,\"payment_method\":14,\"shipping_information\":15,\"actions\":16}},\"value\":\"Default View\"}}}','1970-01-01 00:00:00','1970-01-01 00:00:00'),(11,1,'customer_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"billing_telephone\":{\"visible\":true,\"sorting\":false},\"billing_postcode\":{\"visible\":true,\"sorting\":false},\"billing_region\":{\"visible\":true,\"sorting\":false},\"confirmation\":{\"visible\":true,\"sorting\":false},\"created_in\":{\"visible\":true,\"sorting\":false},\"billing_full\":{\"visible\":false,\"sorting\":false},\"shipping_full\":{\"visible\":false,\"sorting\":false},\"taxvat\":{\"visible\":true,\"sorting\":false},\"billing_street\":{\"visible\":false,\"sorting\":false},\"billing_city\":{\"visible\":false,\"sorting\":false},\"billing_fax\":{\"visible\":false,\"sorting\":false},\"billing_vat_id\":{\"visible\":false,\"sorting\":false},\"billing_company\":{\"visible\":false,\"sorting\":false},\"billing_firstname\":{\"visible\":false,\"sorting\":false},\"billing_lastname\":{\"visible\":false,\"sorting\":false},\"group_id\":{\"visible\":true,\"sorting\":false},\"billing_country_id\":{\"visible\":true,\"sorting\":false},\"website_id\":{\"visible\":true,\"sorting\":false},\"gender\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"last_visit_at\":{\"visible\":false,\"sorting\":false},\"dob\":{\"visible\":true,\"sorting\":false},\"lock_expires\":{\"visible\":false,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20,\"pageSize\":20,\"current\":1},\"positions\":{\"ids\":0,\"entity_id\":1,\"name\":2,\"email\":3,\"group_id\":4,\"billing_telephone\":5,\"billing_postcode\":6,\"billing_country_id\":7,\"billing_region\":8,\"created_at\":9,\"website_id\":10,\"confirmation\":11,\"created_in\":12,\"billing_full\":13,\"shipping_full\":14,\"dob\":15,\"taxvat\":16,\"gender\":17,\"billing_street\":18,\"billing_city\":19,\"billing_fax\":20,\"billing_vat_id\":21,\"billing_company\":22,\"billing_firstname\":23,\"billing_lastname\":24,\"actions\":25,\"lock_expires\":26},\"displayMode\":\"grid\"}}','1970-01-01 00:00:00','2020-04-20 06:36:32'),(12,1,'customer_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"billing_telephone\":{\"visible\":true,\"sorting\":false},\"billing_postcode\":{\"visible\":true,\"sorting\":false},\"billing_region\":{\"visible\":true,\"sorting\":false},\"confirmation\":{\"visible\":true,\"sorting\":false},\"created_in\":{\"visible\":true,\"sorting\":false},\"billing_full\":{\"visible\":false,\"sorting\":false},\"shipping_full\":{\"visible\":false,\"sorting\":false},\"taxvat\":{\"visible\":true,\"sorting\":false},\"billing_street\":{\"visible\":false,\"sorting\":false},\"billing_city\":{\"visible\":false,\"sorting\":false},\"billing_fax\":{\"visible\":false,\"sorting\":false},\"billing_vat_id\":{\"visible\":false,\"sorting\":false},\"billing_company\":{\"visible\":false,\"sorting\":false},\"billing_firstname\":{\"visible\":false,\"sorting\":false},\"billing_lastname\":{\"visible\":false,\"sorting\":false},\"group_id\":{\"visible\":true,\"sorting\":false},\"billing_country_id\":{\"visible\":true,\"sorting\":false},\"website_id\":{\"visible\":true,\"sorting\":false},\"gender\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"last_visit_at\":{\"visible\":false,\"sorting\":false},\"dob\":{\"visible\":true,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"entity_id\":1,\"name\":2,\"email\":3,\"group_id\":4,\"billing_telephone\":5,\"billing_postcode\":6,\"billing_country_id\":7,\"billing_region\":8,\"created_at\":9,\"website_id\":10,\"last_visit_at\":11,\"confirmation\":12,\"created_in\":13,\"billing_full\":14,\"shipping_full\":15,\"dob\":16,\"taxvat\":17,\"gender\":18,\"billing_street\":19,\"billing_city\":20,\"billing_fax\":21,\"billing_vat_id\":22,\"billing_company\":23,\"billing_firstname\":24,\"billing_lastname\":25,\"actions\":26}},\"value\":\"Default View\"}}}','1970-01-01 00:00:00','1970-01-01 00:00:00'),(13,1,'design_config_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"displayMode\":\"grid\",\"filters\":{\"applied\":{\"placeholder\":true}},\"positions\":{\"default\":0,\"store_website_id\":1,\"store_group_id\":2,\"store_id\":3,\"theme_theme_id\":4,\"actions\":5},\"columns\":{\"default\":{\"visible\":true,\"sorting\":false},\"theme_theme_id\":{\"visible\":true,\"sorting\":false},\"store_website_id\":{\"visible\":true,\"sorting\":false},\"store_group_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','1970-01-01 00:00:00','1970-01-01 00:00:00'),(14,1,'design_config_listing','current',0,NULL,'{\"current\":{\"displayMode\":\"grid\",\"filters\":{\"applied\":{\"placeholder\":true}},\"positions\":{\"default\":0,\"store_website_id\":1,\"store_group_id\":2,\"store_id\":3,\"theme_theme_id\":4,\"actions\":5},\"columns\":{\"default\":{\"visible\":true,\"sorting\":false},\"theme_theme_id\":{\"visible\":true,\"sorting\":false},\"store_website_id\":{\"visible\":true,\"sorting\":false},\"store_group_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":50,\"pageSize\":50,\"current\":1}}}','0000-00-00 00:00:00','2019-07-26 07:25:53'),(15,2,'product_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"websites\":{\"visible\":true,\"sorting\":false},\"cost\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"attribute_set_id\":{\"visible\":true,\"sorting\":false},\"visibility\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"size\":{\"visible\":true,\"sorting\":false},\"material\":{\"visible\":true,\"sorting\":false},\"pattern\":{\"visible\":true,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"salable_quantity\":{\"visible\":true,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false}},\"search\":{\"value\":\"\"},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"attribute_set_id\":5,\"sku\":6,\"price\":7,\"qty\":8,\"salable_quantity\":9,\"visibility\":10,\"status\":11,\"websites\":12,\"short_description\":13,\"special_price\":14,\"special_from_date\":15,\"special_to_date\":16,\"weight\":17,\"manufacturer\":18,\"meta_title\":19,\"meta_keyword\":20,\"meta_description\":21,\"color\":22,\"news_from_date\":23,\"news_to_date\":24,\"custom_design\":25,\"custom_design_from\":26,\"custom_design_to\":27,\"page_layout\":28,\"country_of_manufacture\":29,\"url_key\":30,\"msrp\":31,\"tax_class_id\":32,\"gift_message_available\":33,\"size\":34,\"material\":35,\"pattern\":36,\"custom_layout\":37,\"cost\":38,\"actions\":39},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,2,'product_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"websites\":{\"visible\":true,\"sorting\":false},\"cost\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"attribute_set_id\":{\"visible\":true,\"sorting\":false},\"visibility\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"size\":{\"visible\":true,\"sorting\":false},\"material\":{\"visible\":true,\"sorting\":false},\"pattern\":{\"visible\":true,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"salable_quantity\":{\"visible\":true,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false}},\"search\":{\"value\":\"MH16\"},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"attribute_set_id\":5,\"sku\":6,\"price\":7,\"qty\":8,\"salable_quantity\":9,\"visibility\":10,\"status\":11,\"websites\":12,\"short_description\":13,\"special_price\":14,\"special_from_date\":15,\"special_to_date\":16,\"weight\":17,\"manufacturer\":18,\"meta_title\":19,\"meta_keyword\":20,\"meta_description\":21,\"color\":22,\"news_from_date\":23,\"news_to_date\":24,\"custom_design\":25,\"custom_design_from\":26,\"custom_design_to\":27,\"page_layout\":28,\"country_of_manufacture\":29,\"url_key\":30,\"msrp\":31,\"tax_class_id\":32,\"gift_message_available\":33,\"size\":34,\"material\":35,\"pattern\":36,\"custom_layout\":37,\"cost\":38,\"actions\":39},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,2,'sales_order_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"visible\":true,\"sorting\":false},\"grand_total\":{\"visible\":true,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"total_refunded\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":\"desc\"},\"status\":{\"visible\":true,\"sorting\":false},\"customer_group\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"signifyd_guarantee_status\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"increment_id\":1,\"store_id\":2,\"created_at\":3,\"billing_name\":4,\"shipping_name\":5,\"base_grand_total\":6,\"grand_total\":7,\"status\":8,\"billing_address\":9,\"shipping_address\":10,\"shipping_information\":11,\"customer_email\":12,\"customer_group\":13,\"subtotal\":14,\"shipping_and_handling\":15,\"customer_name\":16,\"payment_method\":17,\"total_refunded\":18,\"actions\":19,\"signifyd_guarantee_status\":20}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,2,'sales_order_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"visible\":true,\"sorting\":false},\"grand_total\":{\"visible\":true,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"total_refunded\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":\"desc\"},\"status\":{\"visible\":true,\"sorting\":false},\"customer_group\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"signifyd_guarantee_status\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"increment_id\":1,\"store_id\":2,\"created_at\":3,\"billing_name\":4,\"shipping_name\":5,\"base_grand_total\":6,\"grand_total\":7,\"status\":8,\"billing_address\":9,\"shipping_address\":10,\"shipping_information\":11,\"customer_email\":12,\"customer_group\":13,\"subtotal\":14,\"shipping_and_handling\":15,\"customer_name\":16,\"payment_method\":17,\"total_refunded\":18,\"actions\":19,\"signifyd_guarantee_status\":20}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,2,'sales_order_view_invoice_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"grand_total\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false},\"state\":{\"visible\":true,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"grand_total\":7,\"store_id\":8,\"billing_address\":9,\"shipping_address\":10,\"customer_name\":11,\"customer_email\":12,\"customer_group_id\":13,\"payment_method\":14,\"shipping_information\":15,\"subtotal\":16,\"shipping_and_handling\":17,\"actions\":18},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,2,'sales_order_view_shipment_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"total_qty\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"temando_shipment_status\":{\"visible\":false,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"shipping_name\":5,\"total_qty\":6,\"order_status\":7,\"store_id\":8,\"customer_name\":9,\"customer_email\":10,\"customer_group_id\":11,\"billing_address\":12,\"shipping_address\":13,\"payment_method\":14,\"shipping_information\":15,\"actions\":16,\"temando_shipment_status\":17},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,2,'sales_order_view_creditmemo_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":false},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"adjustment_positive\":{\"visible\":false,\"sorting\":false},\"adjustment_negative\":{\"visible\":false,\"sorting\":false},\"order_base_grand_total\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false},\"state\":{\"visible\":true,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"base_grand_total\":7,\"order_status\":8,\"store_id\":9,\"billing_address\":10,\"shipping_address\":11,\"customer_name\":12,\"customer_email\":13,\"customer_group_id\":14,\"payment_method\":15,\"shipping_information\":16,\"subtotal\":17,\"shipping_and_handling\":18,\"adjustment_positive\":19,\"adjustment_negative\":20,\"order_base_grand_total\":21,\"actions\":22},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,2,'sales_order_view_invoice_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"grand_total\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false},\"state\":{\"visible\":true,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"grand_total\":7,\"store_id\":8,\"billing_address\":9,\"shipping_address\":10,\"customer_name\":11,\"customer_email\":12,\"customer_group_id\":13,\"payment_method\":14,\"shipping_information\":15,\"subtotal\":16,\"shipping_and_handling\":17,\"actions\":18},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,2,'sales_order_view_creditmemo_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":false},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"adjustment_positive\":{\"visible\":false,\"sorting\":false},\"adjustment_negative\":{\"visible\":false,\"sorting\":false},\"order_base_grand_total\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false},\"state\":{\"visible\":true,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"base_grand_total\":7,\"order_status\":8,\"store_id\":9,\"billing_address\":10,\"shipping_address\":11,\"customer_name\":12,\"customer_email\":13,\"customer_group_id\":14,\"payment_method\":15,\"shipping_information\":16,\"subtotal\":17,\"shipping_and_handling\":18,\"adjustment_positive\":19,\"adjustment_negative\":20,\"order_base_grand_total\":21,\"actions\":22},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,2,'sales_order_view_shipment_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"total_qty\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"temando_shipment_status\":{\"visible\":false,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"shipping_name\":5,\"total_qty\":6,\"order_status\":7,\"store_id\":8,\"customer_name\":9,\"customer_email\":10,\"customer_group_id\":11,\"billing_address\":12,\"shipping_address\":13,\"payment_method\":14,\"shipping_information\":15,\"actions\":16,\"temando_shipment_status\":17},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,1,'grouped_product_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"attribute_set_id\":{\"visible\":false,\"sorting\":false},\"status\":{\"visible\":false,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"size\":{\"visible\":true,\"sorting\":false},\"material\":{\"visible\":true,\"sorting\":false},\"pattern\":{\"visible\":true,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"attribute_set_text\":{\"visible\":false,\"sorting\":false},\"status_text\":{\"visible\":false,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"cost\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false}},\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"sku\":5,\"qty\":6,\"price\":7,\"attribute_set_id\":8,\"attribute_set_text\":9,\"status\":10,\"short_description\":11,\"special_price\":12,\"special_from_date\":13,\"special_to_date\":14,\"cost\":15,\"weight\":16,\"manufacturer\":17,\"meta_title\":18,\"meta_keyword\":19,\"meta_description\":20,\"color\":21,\"news_from_date\":22,\"news_to_date\":23,\"custom_design\":24,\"custom_design_from\":25,\"custom_design_to\":26,\"page_layout\":27,\"country_of_manufacture\":28,\"url_key\":29,\"msrp\":30,\"tax_class_id\":31,\"gift_message_available\":32,\"size\":33,\"material\":34,\"pattern\":35,\"custom_layout\":36,\"status_text\":37},\"displayMode\":\"grid\"},\"value\":\"Default View\"}}}','2019-12-10 07:36:13','2019-12-10 07:36:13'),(26,1,'grouped_product_listing','current',0,NULL,'{\"current\":{\"paging\":{\"pageSize\":20,\"current\":6,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"attribute_set_id\":{\"visible\":false,\"sorting\":false},\"status\":{\"visible\":false,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"size\":{\"visible\":true,\"sorting\":false},\"material\":{\"visible\":true,\"sorting\":false},\"pattern\":{\"visible\":true,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"attribute_set_text\":{\"visible\":false,\"sorting\":false},\"status_text\":{\"visible\":false,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"cost\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false}},\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"sku\":5,\"qty\":6,\"price\":7,\"attribute_set_id\":8,\"attribute_set_text\":9,\"status\":10,\"short_description\":11,\"special_price\":12,\"special_from_date\":13,\"special_to_date\":14,\"cost\":15,\"weight\":16,\"manufacturer\":17,\"meta_title\":18,\"meta_keyword\":19,\"meta_description\":20,\"color\":21,\"news_from_date\":22,\"news_to_date\":23,\"custom_design\":24,\"custom_design_from\":25,\"custom_design_to\":26,\"page_layout\":27,\"country_of_manufacture\":28,\"url_key\":29,\"msrp\":30,\"tax_class_id\":31,\"gift_message_available\":32,\"size\":33,\"material\":34,\"pattern\":35,\"custom_layout\":36,\"status_text\":37},\"displayMode\":\"grid\"}}','2019-12-10 07:36:14','2019-12-31 02:03:46'),(27,1,'bundle_product_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"size\":{\"visible\":true,\"sorting\":false},\"material\":{\"visible\":true,\"sorting\":false},\"pattern\":{\"visible\":true,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"cost\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false}},\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"sku\":5,\"qty\":6,\"price\":7,\"short_description\":8,\"special_price\":9,\"special_from_date\":10,\"special_to_date\":11,\"cost\":12,\"weight\":13,\"manufacturer\":14,\"meta_title\":15,\"meta_keyword\":16,\"meta_description\":17,\"color\":18,\"news_from_date\":19,\"news_to_date\":20,\"custom_design\":21,\"custom_design_from\":22,\"custom_design_to\":23,\"page_layout\":24,\"country_of_manufacture\":25,\"url_key\":26,\"msrp\":27,\"tax_class_id\":28,\"gift_message_available\":29,\"size\":30,\"material\":31,\"pattern\":32,\"custom_layout\":33},\"displayMode\":\"grid\"},\"value\":\"Default View\"}}}','2019-12-10 07:40:27','2019-12-10 07:40:27'),(28,1,'bundle_product_listing','current',0,NULL,'{\"current\":{\"paging\":{\"pageSize\":20,\"current\":6,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"size\":{\"visible\":true,\"sorting\":false},\"material\":{\"visible\":true,\"sorting\":false},\"pattern\":{\"visible\":true,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"cost\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false}},\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"sku\":5,\"qty\":6,\"price\":7,\"short_description\":8,\"special_price\":9,\"special_from_date\":10,\"special_to_date\":11,\"cost\":12,\"weight\":13,\"manufacturer\":14,\"meta_title\":15,\"meta_keyword\":16,\"meta_description\":17,\"color\":18,\"news_from_date\":19,\"news_to_date\":20,\"custom_design\":21,\"custom_design_from\":22,\"custom_design_to\":23,\"page_layout\":24,\"country_of_manufacture\":25,\"url_key\":26,\"msrp\":27,\"tax_class_id\":28,\"gift_message_available\":29,\"size\":30,\"material\":31,\"pattern\":32,\"custom_layout\":33},\"displayMode\":\"grid\"}}','2019-12-10 07:40:29','2019-12-13 04:31:48'),(29,1,'inventory_source_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"source_code\":{\"visible\":true,\"sorting\":false},\"name\":{\"visible\":true,\"sorting\":false},\"contact_name\":{\"visible\":false,\"sorting\":false},\"email\":{\"visible\":false,\"sorting\":false},\"latitude\":{\"visible\":false,\"sorting\":false},\"longitude\":{\"visible\":false,\"sorting\":false},\"region\":{\"visible\":false,\"sorting\":false},\"city\":{\"visible\":false,\"sorting\":false},\"street\":{\"visible\":false,\"sorting\":false},\"postcode\":{\"visible\":false,\"sorting\":false},\"phone\":{\"visible\":false,\"sorting\":false},\"fax\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"enabled\":{\"visible\":true,\"sorting\":false},\"country_id\":{\"visible\":false,\"sorting\":false}},\"search\":{\"value\":\"\"},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"source_code\":1,\"name\":2,\"contact_name\":3,\"enabled\":4,\"email\":5,\"latitude\":6,\"longitude\":7,\"country_id\":8,\"region\":9,\"city\":10,\"street\":11,\"postcode\":12,\"phone\":13,\"fax\":14,\"actions\":15}},\"value\":\"Default View\"}}}','2020-07-04 07:09:46','2020-07-04 07:09:46'),(30,1,'inventory_source_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"source_code\":{\"visible\":true,\"sorting\":false},\"name\":{\"visible\":true,\"sorting\":false},\"contact_name\":{\"visible\":false,\"sorting\":false},\"email\":{\"visible\":false,\"sorting\":false},\"latitude\":{\"visible\":false,\"sorting\":false},\"longitude\":{\"visible\":false,\"sorting\":false},\"region\":{\"visible\":false,\"sorting\":false},\"city\":{\"visible\":false,\"sorting\":false},\"street\":{\"visible\":false,\"sorting\":false},\"postcode\":{\"visible\":false,\"sorting\":false},\"phone\":{\"visible\":false,\"sorting\":false},\"fax\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"enabled\":{\"visible\":true,\"sorting\":false},\"country_id\":{\"visible\":false,\"sorting\":false}},\"search\":{\"value\":\"\"},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"source_code\":1,\"name\":2,\"contact_name\":3,\"enabled\":4,\"email\":5,\"latitude\":6,\"longitude\":7,\"country_id\":8,\"region\":9,\"city\":10,\"street\":11,\"postcode\":12,\"phone\":13,\"fax\":14,\"actions\":15}}}','2020-07-04 07:09:46','2020-07-04 07:09:46'),(31,1,'inventory_stock_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"stock_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"sales_channels\":{\"visible\":true,\"sorting\":false},\"assigned_sources\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"stock_id\":1,\"name\":2,\"sales_channels\":3,\"assigned_sources\":4,\"actions\":5}},\"value\":\"Default View\"}}}','2020-07-04 07:09:50','2020-07-04 07:09:50'),(32,1,'inventory_stock_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"stock_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"sales_channels\":{\"visible\":true,\"sorting\":false},\"assigned_sources\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"stock_id\":1,\"name\":2,\"sales_channels\":3,\"assigned_sources\":4,\"actions\":5}}}','2020-07-04 07:09:52','2020-07-04 07:09:52');

--
