-- Table structure for table `sales_invoiced_aggregated_order`
--

CREATE TABLE `sales_invoiced_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) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
  `invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
  `invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
  `invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_INVOICED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_INVOICED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_INVOICED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='Sales Invoiced Aggregated Order';

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

INSERT INTO `sales_invoiced_aggregated_order` VALUES (1,'2018-03-16',1,'complete',1,1.0000,5060.0000,5060.0000,0.0000),(2,'2018-03-21',1,'complete',1,1.0000,1825.0000,1825.0000,0.0000),(4,'2018-03-16',0,'complete',1,1.0000,5060.0000,5060.0000,0.0000),(5,'2018-03-21',0,'complete',1,1.0000,1825.0000,1825.0000,0.0000),(8,'2018-07-23',1,'complete',2,2.0000,9735.0000,9735.0000,0.0000),(11,'2018-07-23',0,'complete',2,2.0000,9735.0000,9735.0000,0.0000),(13,'2018-07-24',1,'complete',1,1.0000,1375.0000,1375.0000,0.0000),(14,'2018-07-25',1,'complete',1,1.0000,660.0000,660.0000,0.0000),(16,'2018-07-24',0,'complete',1,1.0000,1375.0000,1375.0000,0.0000),(17,'2018-07-25',0,'complete',1,1.0000,660.0000,660.0000,0.0000);

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

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

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

INSERT INTO `sales_order_address` VALUES (1,1,1,6,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,NULL,21,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,1,25,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,2,1,26,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,3,2,50,NULL,NULL,NULL,NULL,'AB123CD','Diano','Geo Street','Geo','test2@yahoo.com','123456789','GB','Leo','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,3,NULL,51,NULL,NULL,NULL,NULL,'AB123CD','Diano','Geo Street','Geo','test2@yahoo.com','123456789','GB','Leo','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,4,2,53,NULL,NULL,NULL,NULL,'AB123CD','Diano','Geo Street','Geo','test2@yahoo.com','123456789','GB','Leo','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,4,2,54,NULL,NULL,NULL,NULL,'AB123CD','Diano','Geo Street','Geo','test2@yahoo.com','123456789','GB','Leo','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,5,1,44,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,5,1,59,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,6,1,61,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,6,1,62,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,7,1,413,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,7,1,444,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,8,1,446,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,8,1,448,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,9,1,450,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,9,1,452,12,NULL,NULL,'California','10000','Statham','123 CS','HN','test@gmail.com','12345','US','Jason','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

CREATE TABLE `sales_order_aggregated_created` (
  `id` int(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',
  `total_qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Ordered',
  `total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Invoiced',
  `total_income_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Income Amount',
  `total_revenue_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Revenue Amount',
  `total_profit_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Profit Amount',
  `total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Invoiced Amount',
  `total_canceled_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Canceled Amount',
  `total_paid_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Paid Amount',
  `total_refunded_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Refunded Amount',
  `total_tax_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount',
  `total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount Actual',
  `total_shipping_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount',
  `total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount Actual',
  `total_discount_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount',
  `total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_ORDER_AGGREGATED_CREATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_ORDER_AGGREGATED_CREATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_AGGREGATED_CREATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='Sales Order Aggregated Created';

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

INSERT INTO `sales_order_aggregated_created` VALUES (1,'2018-03-16',1,'complete',1,9.0000,9.0000,5060.0000,5035.0000,5035.0000,5060.0000,0.0000,5060.0000,0.0000,0.0000,0.0000,25.0000,25.0000,0.0000,0.0000),(2,'2018-03-21',1,'complete',1,5.0000,5.0000,1825.0000,1800.0000,1800.0000,1825.0000,0.0000,1825.0000,0.0000,0.0000,0.0000,25.0000,25.0000,0.0000,0.0000),(4,'2018-03-16',0,'complete',1,9.0000,9.0000,5060.0000,5035.0000,5035.0000,5060.0000,0.0000,5060.0000,0.0000,0.0000,0.0000,25.0000,25.0000,0.0000,0.0000),(5,'2018-03-21',0,'complete',1,5.0000,5.0000,1825.0000,1800.0000,1800.0000,1825.0000,0.0000,1825.0000,0.0000,0.0000,0.0000,25.0000,25.0000,0.0000,0.0000),(8,'2018-07-23',1,'complete',2,117.0000,117.0000,9735.0000,9150.0000,9150.0000,9735.0000,0.0000,9735.0000,0.0000,0.0000,0.0000,585.0000,585.0000,0.0000,0.0000),(11,'2018-07-23',0,'complete',2,117.0000,117.0000,9735.0000,9150.0000,9150.0000,9735.0000,0.0000,9735.0000,0.0000,0.0000,0.0000,585.0000,585.0000,0.0000,0.0000),(13,'2018-07-24',1,'complete',1,8.0000,8.0000,1375.0000,1335.0000,1335.0000,1375.0000,0.0000,1375.0000,0.0000,0.0000,0.0000,40.0000,40.0000,0.0000,0.0000),(14,'2018-07-25',1,'complete',1,2.0000,2.0000,660.0000,650.0000,650.0000,660.0000,0.0000,660.0000,0.0000,0.0000,0.0000,10.0000,10.0000,0.0000,0.0000),(16,'2018-07-24',0,'complete',1,8.0000,8.0000,1375.0000,1335.0000,1335.0000,1375.0000,0.0000,1375.0000,0.0000,0.0000,0.0000,40.0000,40.0000,0.0000,0.0000),(17,'2018-07-25',0,'complete',1,2.0000,2.0000,660.0000,650.0000,650.0000,660.0000,0.0000,660.0000,0.0000,0.0000,0.0000,10.0000,10.0000,0.0000,0.0000);

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

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

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

INSERT INTO `sales_order_aggregated_updated` VALUES (1,'2018-03-16',1,'complete',1,9.0000,9.0000,5060.0000,5035.0000,5035.0000,5060.0000,0.0000,5060.0000,0.0000,0.0000,0.0000,25.0000,25.0000,0.0000,0.0000),(2,'2018-03-21',1,'complete',1,5.0000,5.0000,1825.0000,1800.0000,1800.0000,1825.0000,0.0000,1825.0000,0.0000,0.0000,0.0000,25.0000,25.0000,0.0000,0.0000),(4,'2018-03-16',0,'complete',1,9.0000,9.0000,5060.0000,5035.0000,5035.0000,5060.0000,0.0000,5060.0000,0.0000,0.0000,0.0000,25.0000,25.0000,0.0000,0.0000),(5,'2018-03-21',0,'complete',1,5.0000,5.0000,1825.0000,1800.0000,1800.0000,1825.0000,0.0000,1825.0000,0.0000,0.0000,0.0000,25.0000,25.0000,0.0000,0.0000),(8,'2018-07-23',1,'complete',2,117.0000,117.0000,9735.0000,9150.0000,9150.0000,9735.0000,0.0000,9735.0000,0.0000,0.0000,0.0000,585.0000,585.0000,0.0000,0.0000),(11,'2018-07-23',0,'complete',2,117.0000,117.0000,9735.0000,9150.0000,9150.0000,9735.0000,0.0000,9735.0000,0.0000,0.0000,0.0000,585.0000,585.0000,0.0000,0.0000),(13,'2018-07-24',1,'complete',1,8.0000,8.0000,1375.0000,1335.0000,1335.0000,1375.0000,0.0000,1375.0000,0.0000,0.0000,0.0000,40.0000,40.0000,0.0000,0.0000),(14,'2018-07-25',1,'complete',1,2.0000,2.0000,660.0000,650.0000,650.0000,660.0000,0.0000,660.0000,0.0000,0.0000,0.0000,10.0000,10.0000,0.0000,0.0000),(16,'2018-07-24',0,'complete',1,8.0000,8.0000,1375.0000,1335.0000,1335.0000,1375.0000,0.0000,1375.0000,0.0000,0.0000,0.0000,40.0000,40.0000,0.0000,0.0000),(17,'2018-07-25',0,'complete',1,2.0000,2.0000,660.0000,650.0000,650.0000,660.0000,0.0000,660.0000,0.0000,0.0000,0.0000,10.0000,10.0000,0.0000,0.0000);

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

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

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

INSERT INTO `sales_order_grid` VALUES (1,'complete',1,'Main Website\r\nMain Website Store',1,5060.0000,5060.0000,5060.0000,5060.0000,'000000001','USD','USD','Jason Statham','Jason Statham','2018-03-15 09:10:00','2018-03-15 09:25:33','123 CS HN California 10000','123 CS HN California 10000','Flat Rate - Fixed','test@gmail.com','1',5035.0000,25.0000,'Jason Statham','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'complete',1,'Main Website\r\nMain Website Store',1,1825.0000,1825.0000,1825.0000,1825.0000,'000000002','USD','USD','Jason Statham','Jason Statham','2018-03-20 06:29:49','2018-03-20 07:25:19','123 CS HN California 10000','123 CS HN California 10000','Flat Rate - Fixed','test@gmail.com','1',1800.0000,25.0000,'Jason Statham','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'complete',1,'Main Website\r\nMain Website Store',2,7735.0000,7735.0000,7735.0000,7735.0000,'000000003','USD','USD','Leo Diano','Leo Diano','2018-07-22 10:25:29','2018-07-22 10:28:36','Geo Street Geo AB123CD','Geo Street Geo AB123CD','Flat Rate - Fixed','test2@yahoo.com','1',7400.0000,335.0000,'Leo Diano','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'complete',1,'Main Website\r\nMain Website Store',2,2000.0000,2000.0000,2000.0000,2000.0000,'000000004','USD','USD','Leo Diano','Leo Diano','2018-07-22 10:37:21','2018-07-22 10:38:48','Geo Street Geo AB123CD','Geo Street Geo AB123CD','Flat Rate - Fixed','test2@yahoo.com','1',1750.0000,250.0000,'Leo Diano','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'complete',1,'Main Website\r\nMain Website Store',1,1375.0000,1375.0000,1375.0000,1375.0000,'000000005','USD','USD','Jason Statham','Jason Statham','2018-07-23 10:13:57','2018-07-23 10:17:52','123 CS HN California 10000','123 CS HN California 10000','Flat Rate - Fixed','test@gmail.com','1',1335.0000,40.0000,'Jason Statham','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'complete',1,'Main Website\r\nMain Website Store',1,660.0000,660.0000,660.0000,660.0000,'000000006','USD','USD','Jason Statham','Jason Statham','2018-07-24 04:49:52','2018-07-24 04:51:29','123 CS HN California 10000','123 CS HN California 10000','Flat Rate - Fixed','test@gmail.com','1',650.0000,10.0000,'Jason Statham','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'complete',1,'Main Website\nMain Website Store\nEnglish',1,530.0000,530.0000,530.0000,530.0000,'000000007','USD','USD','Jason Statham','Jason Statham','2020-10-01 14:11:17','2020-10-01 14:12:13','123 CS,HN,California,10000','123 CS,HN,California,10000','Flat Rate - Fixed','test@gmail.com','1',525.0000,5.0000,'Jason Statham','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'complete',1,'Main Website\nMain Website Store\nEnglish',1,827.0000,827.0000,827.0000,827.0000,'000000008','USD','USD','Jason Statham','Jason Statham','2020-10-02 22:24:30','2020-10-02 22:26:12','123 CS,HN,California,10000','123 CS,HN,California,10000','Flat Rate - Fixed','test@gmail.com','1',812.0000,15.0000,'Jason Statham','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'complete',1,'Main Website\nMain Website Store\nEnglish',1,355.0000,355.0000,355.0000,355.0000,'000000009','USD','USD','Jason Statham','Jason Statham','2020-10-02 22:28:04','2020-10-02 22:29:18','123 CS,HN,California,10000','123 CS,HN,California,10000','Flat Rate - Fixed','test@gmail.com','1',350.0000,5.0000,'Jason Statham','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

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

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

INSERT INTO `sales_order_item` VALUES (1,1,NULL,10,1,'2018-03-15 09:10:00','2018-03-15 16:59:56',58,'downloadable','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3QvZ3JhbmQtc2xhbS1pbmRvb3Itb2Ytc2hvdy1qdW1waW5nLW5vdmVsLmh0bWw,\",\"product\":\"58\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"links\":[\"1\",\"2\"],\"qty\":\"1\"},\"links\":[\"1\",\"2\"],\"is_downloadable\":true,\"real_product_type\":\"downloadable\"}',NULL,1,'MB044','Grand Slam Indoor Of Show Jumping Novel',NULL,NULL,NULL,0,0,NULL,0.0000,4.0000,4.0000,0.0000,0.0000,NULL,40.0000,40.0000,30.0000,30.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,160.0000,160.0000,160.0000,160.0000,0.0000,NULL,NULL,NULL,NULL,NULL,40.0000,40.0000,160.0000,160.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,NULL,24,1,'2018-03-15 09:10:00','2018-04-07 10:42:59',8,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3Qv\",\"product\":\"8\",\"qty\":1}}',1000.0000,0,'MB008','DJI Phantom 4 Quadcopter Camera',NULL,NULL,NULL,0,0,NULL,0.0000,5.0000,5.0000,0.0000,5.0000,NULL,975.0000,975.0000,1200.0000,1200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,4875.0000,4875.0000,4875.0000,4875.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,975.0000,975.0000,4875.0000,4875.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,NULL,34,1,'2018-03-20 06:29:49','2018-03-20 07:25:18',14,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3QveHRyZW1lcG93ZXJ1cy1zdGFpbmxlc3Mtc3RlZWwtdHVtYmxlLWNsb3Rocy1kcnllci5odG1s\",\"product\":\"14\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"qty\":\"1\"}}',5000.0000,0,'MB014','XtremepowerUS Stainless Steel Tumble Cloths Dryer',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,200.0000,200.0000,300.0000,300.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,200.0000,200.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,2,NULL,35,1,'2018-03-20 06:29:49','2018-03-20 07:25:18',8,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3QvY2hlY2tvdXQvY2FydC8,\",\"product\":\"8\",\"in_cart\":\"1\",\"qty\":1}}',1000.0000,0,'MB008','DJI Phantom 4 Quadcopter Camera',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,800.0000,800.0000,900.0000,900.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,800.0000,800.0000,800.0000,800.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,800.0000,800.0000,800.0000,800.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,2,NULL,36,1,'2018-03-20 06:29:49','2018-03-20 07:25:18',2,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3QvY29uc3VtZXItZWxlY3RyaWMuaHRtbD9wPTI,\",\"product\":\"2\",\"qty\":1}}',2000.0000,0,'MB002','Canon MX492 Wireless All-IN-One Small Printer',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,250.0000,250.0000,300.0000,300.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,250.0000,250.0000,250.0000,250.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,250.0000,250.0000,250.0000,250.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,2,NULL,37,1,'2018-03-20 06:29:49','2018-03-20 07:25:18',19,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3QvY29uc3VtZXItZWxlY3RyaWMuaHRtbD9wPTE,\",\"product\":\"19\",\"qty\":1}}',1500.0000,0,'MB017','DBPOWER T20 1500 Lumens LCD Projector',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,200.0000,200.0000,1500.0000,NULL,NULL,NULL,NULL,NULL,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,2,NULL,38,1,'2018-03-20 06:29:49','2018-03-20 07:25:18',15,'configurable','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3QvY29uc3VtZXItZWxlY3RyaWMuaHRtbD9wPTE,\",\"product\":\"15\",\"super_attribute\":{\"93\":\"4\"},\"qty\":1},\"attributes_info\":[{\"label\":\"Color\",\"value\":\"Black\",\"option_id\":93,\"option_value\":\"4\"}],\"simple_name\":\"Marshall PBluetooth Speaker-black\",\"simple_sku\":\"MB015-black\",\"product_calculations\":1,\"shipment_type\":0}',500.0000,0,'MB015-black','Marshall PBluetooth Speaker',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,350.0000,350.0000,350.0000,350.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,350.0000,350.0000,350.0000,350.0000,500.0000,NULL,NULL,NULL,NULL,NULL,350.0000,350.0000,350.0000,350.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,2,7,39,1,'2018-03-20 06:29:49','2018-03-20 07:25:18',16,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3QvY29uc3VtZXItZWxlY3RyaWMuaHRtbD9wPTE,\",\"product\":\"15\",\"super_attribute\":{\"93\":\"4\"},\"qty\":1}}',500.0000,0,'MB015-black','Marshall PBluetooth Speaker-black',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,3,NULL,77,1,'2018-07-22 10:25:29','2018-07-22 10:28:36',8,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3Qv\",\"product\":\"8\",\"qty\":1}}',1000.0000,0,'MB008','DJI Phantom 4 Quadcopter Camera',NULL,NULL,NULL,0,0,NULL,0.0000,6.0000,6.0000,0.0000,6.0000,NULL,800.0000,800.0000,900.0000,900.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,4800.0000,4800.0000,4800.0000,4800.0000,6000.0000,NULL,NULL,NULL,NULL,NULL,800.0000,800.0000,4800.0000,4800.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,3,NULL,78,1,'2018-07-22 10:25:29','2018-07-22 10:28:36',14,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3Qv\",\"product\":\"14\",\"qty\":1}}',5000.0000,0,'MB014','XtremepowerUS Stainless Steel Tumble Cloths Dryer',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,200.0000,200.0000,300.0000,300.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,200.0000,200.0000,5000.0000,NULL,NULL,NULL,NULL,NULL,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,3,NULL,79,1,'2018-07-22 10:25:29','2018-07-22 10:28:36',20,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL21hcnRmdXJ5LnRlc3QvbXZtdGgtY2xhc3NpY2FsLWxlYXRoZXItd2F0Y2gtaW4tYmxhY2suaHRtbA,,\",\"product\":\"20\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"qty\":\"1\"}}',100.0000,0,'MB018','MVMTH Classical Leather Watch In Black',NULL,NULL,NULL,0,0,NULL,0.0000,60.0000,60.0000,0.0000,60.0000,NULL,40.0000,40.0000,60.0000,60.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,2400.0000,2400.0000,2400.0000,2400.0000,6000.0000,NULL,NULL,NULL,NULL,NULL,40.0000,40.0000,2400.0000,2400.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,4,NULL,80,1,'2018-07-22 10:37:21','2018-07-22 10:38:48',72,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L2F1Z2Fzb24tZmFybXMtZnJlZXplLWRyaWVkLWJlZWYtY2h1bmtzLTEtbGItbm8tMTAuaHRtbA,,\",\"product\":\"72\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"qty\":\"30\"}}',100.0000,0,'MB0058','Augason Farms Freeze Dried Beef Chunks 1 lb No. 10',NULL,NULL,NULL,0,0,NULL,0.0000,30.0000,30.0000,0.0000,30.0000,NULL,45.0000,45.0000,60.0000,60.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1350.0000,1350.0000,1350.0000,1350.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,45.0000,45.0000,1350.0000,1350.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,4,NULL,81,1,'2018-07-22 10:37:21','2018-07-22 10:38:48',69,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L3ZpdGEtY29jby1jb2NvbnV0LXdhdGVyLXBhY2stb2YtMTIuaHRtbA,,\",\"product\":\"69\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"qty\":\"20\"}}',100.0000,0,'MB0055','Vita Coco Coconut Water - Pack of 12',NULL,NULL,NULL,0,0,NULL,0.0000,20.0000,20.0000,0.0000,20.0000,NULL,20.0000,20.0000,30.0000,30.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,400.0000,400.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,20.0000,20.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,5,NULL,90,1,'2018-07-23 10:13:57','2018-07-23 10:17:52',49,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L2hvbWUtZ2FyZGVuLWtpdGNoZW4uaHRtbA,,\",\"product\":\"49\",\"qty\":1}}',1000.0000,0,'MB035','Simple Plastice Chair',NULL,NULL,NULL,0,0,NULL,0.0000,3.0000,3.0000,0.0000,3.0000,NULL,45.0000,45.0000,45.0000,45.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,135.0000,135.0000,135.0000,135.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,45.0000,45.0000,135.0000,135.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,5,NULL,91,1,'2018-07-23 10:13:57','2018-07-23 10:17:52',76,'configurable','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L3F1aWNrdmlldy92aWV3L2luZGV4L2lkLzc2Lw,,\",\"product\":\"76\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"super_attribute\":{\"93\":\"7\"},\"qty\":\"1\"},\"attributes_info\":[{\"label\":\"Color\",\"value\":\"Blue\",\"option_id\":93,\"option_value\":\"7\"}],\"simple_name\":\"Sofa Fabric In Blue & Brown Chair-blue\",\"simple_sku\":\"MB0060-2\",\"product_calculations\":1,\"shipment_type\":0}',5000.0000,0,'MB0060-2','Sofa In Blue & Brown Chair',NULL,NULL,NULL,0,0,NULL,0.0000,2.0000,2.0000,0.0000,2.0000,NULL,200.0000,200.0000,300.0000,300.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,400.0000,400.0000,10000.0000,NULL,NULL,NULL,NULL,NULL,200.0000,200.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,5,15,92,1,'2018-07-23 10:13:57','2018-07-23 10:17:52',75,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L3F1aWNrdmlldy92aWV3L2luZGV4L2lkLzc2Lw,,\",\"product\":\"76\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"super_attribute\":{\"93\":\"7\"},\"qty\":\"1\"}}',5000.0000,0,'MB0060-2','Sofa Fabric In Blue & Brown Chair-blue',NULL,NULL,NULL,0,0,NULL,0.0000,2.0000,2.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,5,NULL,93,1,'2018-07-23 10:13:57','2018-07-23 10:17:52',77,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L2hvbWUtZ2FyZGVuLWtpdGNoZW4uaHRtbA,,\",\"product\":\"77\",\"qty\":1}}',2500.0000,0,'MB0061','Simple Short TV Board Combine Book Shelf',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,300.0000,300.0000,300.0000,300.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,300.0000,300.0000,300.0000,300.0000,2500.0000,NULL,NULL,NULL,NULL,NULL,300.0000,300.0000,300.0000,300.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,5,NULL,94,1,'2018-07-23 10:13:57','2018-07-23 10:17:52',79,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L2hvbWUtZ2FyZGVuLWtpdGNoZW4uaHRtbA,,\",\"product\":\"79\",\"qty\":1}}',3000.0000,0,'MB0063','Korea Small Wood 4 Boxes Storage',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,300.0000,300.0000,340.0000,340.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,300.0000,300.0000,300.0000,300.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,300.0000,300.0000,300.0000,300.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,5,NULL,95,1,'2018-07-23 10:13:57','2018-07-23 22:50:56',80,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L2hvbWUtZ2FyZGVuLWtpdGNoZW4uaHRtbA,,\",\"product\":\"80\",\"qty\":1}}',1000.0000,0,'MB0064','Simple Wood Combine With Leather Chair',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,200.0000,200.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,6,NULL,96,1,'2018-07-24 04:49:52','2018-07-24 04:51:29',79,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L2hvbWUtZ2FyZGVuLWtpdGNoZW4uaHRtbA,,\",\"product\":\"79\",\"qty\":1}}',3000.0000,0,'MB0063','Korea Small Wood 4 Boxes Storage',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,300.0000,300.0000,340.0000,340.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,300.0000,300.0000,300.0000,300.0000,3000.0000,NULL,NULL,NULL,NULL,NULL,300.0000,300.0000,300.0000,300.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,6,NULL,97,1,'2018-07-24 04:49:52','2018-07-24 04:51:29',81,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tYXJ0ZnVyeS50ZXN0L2hvbWUtZ2FyZGVuLWtpdGNoZW4uaHRtbD9wPTI,\",\"product\":\"81\",\"qty\":1}}',1000.0000,0,'MB0065','Simple Tea Teable With Glass Surface',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,350.0000,350.0000,350.0000,350.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,350.0000,350.0000,350.0000,350.0000,1000.0000,NULL,NULL,NULL,NULL,NULL,350.0000,350.0000,350.0000,350.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,7,NULL,528,1,'2020-10-01 14:11:17','2020-10-01 14:12:13',6,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tMjMudGVzdC9jb25zdW1lci1lbGVjdHJpYy5odG1s\",\"product\":\"6\",\"qty\":1}}',100.0000,0,'MB006','Gopro Quick Sliver Hero4 24K HD Camera',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,525.0000,525.0000,525.0000,525.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,525.0000,525.0000,525.0000,525.0000,100.0000,NULL,NULL,NULL,NULL,NULL,525.0000,525.0000,525.0000,525.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,8,NULL,529,1,'2020-10-02 22:24:30','2020-10-02 22:26:12',3,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tMjMudGVzdC9jb25zdW1lci1lbGVjdHJpYy5odG1sP3A9Mg,,\",\"product\":\"3\",\"qty\":1}}',2000.0000,0,'MB003','Samsung 55-Inch 4K Ultra HD Smart LED TV',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,350.0000,350.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,350.0000,350.0000,350.0000,350.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,350.0000,350.0000,350.0000,350.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,8,NULL,530,1,'2020-10-02 22:24:30','2020-10-02 22:26:12',10,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tMjMudGVzdC9jb25zdW1lci1lbGVjdHJpYy5odG1s\",\"product\":\"10\",\"qty\":1}}',50.0000,0,'MB010','iClever BoostCube Mini Charger',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,12.0000,12.0000,12.0000,12.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,12.0000,12.0000,12.0000,12.0000,50.0000,NULL,NULL,NULL,NULL,NULL,12.0000,12.0000,12.0000,12.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,8,NULL,531,1,'2020-10-02 22:24:30','2020-10-02 22:26:12',5,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tMjMudGVzdC9jb25zdW1lci1lbGVjdHJpYy5odG1sP3A9Mg,,\",\"product\":\"5\",\"qty\":1}}',200.0000,0,'MB005','Nikon Coolpix 24 MP Camera',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,450.0000,450.0000,450.0000,450.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,450.0000,450.0000,450.0000,450.0000,200.0000,NULL,NULL,NULL,NULL,NULL,450.0000,450.0000,450.0000,450.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,9,NULL,532,1,'2020-10-02 22:28:04','2020-10-02 22:29:18',3,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cHM6Ly9tMjMudGVzdC9jb25zdW1lci1lbGVjdHJpYy5odG1sP3A9Mg,,\",\"product\":\"3\",\"qty\":1}}',2000.0000,0,'MB003','Samsung 55-Inch 4K Ultra HD Smart LED TV',NULL,NULL,NULL,0,0,NULL,0.0000,1.0000,1.0000,0.0000,1.0000,NULL,350.0000,350.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,350.0000,350.0000,350.0000,350.0000,2000.0000,NULL,NULL,NULL,NULL,NULL,350.0000,350.0000,350.0000,350.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- 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=77 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');

--
-- 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=77 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,4294967295,4294966295,1),(2,2,NULL,NULL,1,1,4294967295,4294966295,1),(3,3,NULL,NULL,1,1,4294967295,4294966295,1),(4,4,NULL,NULL,1,1,4294967295,4294966295,1),(5,5,NULL,NULL,1,1,4294967295,4294966295,1),(6,6,NULL,NULL,1,1,4294967295,4294966295,1),(7,7,NULL,NULL,1,1,4294967295,4294966295,1),(8,8,NULL,NULL,1,1,4294967295,4294966295,1),(9,9,'2',NULL,1,1,4294967295,4294966295,1),(10,10,'2',NULL,1,1,4294967295,4294966295,1),(11,11,'2',NULL,1,1,4294967295,4294966295,1),(12,12,'2',NULL,1,1,4294967295,4294966295,1),(13,13,'3',NULL,1,1,4294967295,4294966295,1),(14,14,'3',NULL,1,1,4294967295,4294966295,1),(15,15,'3',NULL,1,1,4294967295,4294966295,1),(16,16,'3',NULL,1,1,4294967295,4294966295,1),(17,17,'4',NULL,1,1,4294967295,4294966295,1),(18,18,'4',NULL,1,1,4294967295,4294966295,1),(19,19,'4',NULL,1,1,4294967295,4294966295,1),(20,20,'4',NULL,1,1,4294967295,4294966295,1),(21,21,'5',NULL,1,1,4294967295,4294966295,1),(22,22,'5',NULL,1,1,4294967295,4294966295,1),(23,23,'5',NULL,1,1,4294967295,4294966295,1),(24,24,'5',NULL,1,1,4294967295,4294966295,1),(25,25,'6',NULL,1,1,4294967295,4294966295,1),(26,26,'6',NULL,1,1,4294967295,4294966295,1),(27,27,'6',NULL,1,1,4294967295,4294966295,1),(28,28,'6',NULL,1,1,4294967295,4294966295,1),(29,29,'7',NULL,1,1,4294967295,4294966295,1),(30,30,'7',NULL,1,1,4294967295,4294966295,1),(31,31,'7',NULL,1,1,4294967295,4294966295,1),(32,32,'7',NULL,1,1,4294967295,4294966295,1),(33,33,'8',NULL,1,1,4294967295,4294966295,1),(34,34,'8',NULL,1,1,4294967295,4294966295,1),(35,35,'8',NULL,1,1,4294967295,4294966295,1),(36,36,'8',NULL,1,1,4294967295,4294966295,1),(37,37,'9',NULL,1,1,4294967295,4294966295,1),(38,38,'9',NULL,1,1,4294967295,4294966295,1),(39,39,'9',NULL,1,1,4294967295,4294966295,1),(40,40,'9',NULL,1,1,4294967295,4294966295,1),(41,41,'10',NULL,1,1,4294967295,4294966295,1),(42,42,'10',NULL,1,1,4294967295,4294966295,1),(43,43,'10',NULL,1,1,4294967295,4294966295,1),(44,44,'10',NULL,1,1,4294967295,4294966295,1),(45,45,'11',NULL,1,1,4294967295,4294966295,1),(46,46,'11',NULL,1,1,4294967295,4294966295,1),(47,47,'11',NULL,1,1,4294967295,4294966295,1),(48,48,'11',NULL,1,1,4294967295,4294966295,1),(49,49,'12',NULL,1,1,4294967295,4294966295,1),(50,50,'12',NULL,1,1,4294967295,4294966295,1),(51,51,'12',NULL,1,1,4294967295,4294966295,1),(52,52,'12',NULL,1,1,4294967295,4294966295,1),(53,53,'13',NULL,1,1,4294967295,4294966295,1),(54,54,'13',NULL,1,1,4294967295,4294966295,1),(55,55,'13',NULL,1,1,4294967295,4294966295,1),(56,56,'13',NULL,1,1,4294967295,4294966295,1),(57,57,'14',NULL,1,1,4294967295,4294966295,1),(58,58,'14',NULL,1,1,4294967295,4294966295,1),(59,59,'14',NULL,1,1,4294967295,4294966295,1),(60,60,'14',NULL,1,1,4294967295,4294966295,1),(61,61,'15',NULL,1,1,4294967295,4294966295,1),(62,62,'15',NULL,1,1,4294967295,4294966295,1),(63,63,'15',NULL,1,1,4294967295,4294966295,1),(64,64,'15',NULL,1,1,4294967295,4294966295,1),(65,65,'16',NULL,1,1,4294967295,4294966295,1),(66,66,'16',NULL,1,1,4294967295,4294966295,1),(67,67,'16',NULL,1,1,4294967295,4294966295,1),(68,68,'16',NULL,1,1,4294967295,4294966295,1),(69,69,'17',NULL,1,1,4294967295,4294966295,1),(70,70,'17',NULL,1,1,4294967295,4294966295,1),(71,71,'17',NULL,1,1,4294967295,4294966295,1),(72,72,'17',NULL,1,1,4294967295,4294966295,1),(73,73,'18',NULL,1,1,4294967295,4294966295,1),(74,74,'18',NULL,1,1,4294967295,4294966295,1),(75,75,'18',NULL,1,1,4294967295,4294966295,1),(76,76,'18',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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment';

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

INSERT INTO `sales_shipment` VALUES (1,1,NULL,5.0000,NULL,NULL,1,1,1,2,NULL,'000000001','2018-03-15 09:24:06','2018-03-15 09:24:06','[]',NULL,NULL,NULL),(2,1,NULL,5.0000,NULL,NULL,2,1,3,4,NULL,'000000002','2018-03-20 07:23:14','2018-03-20 07:23:14','[]',NULL,NULL,NULL),(3,1,NULL,67.0000,NULL,NULL,3,2,5,6,NULL,'000000003','2018-07-22 10:28:05','2018-07-22 10:28:05','[]',NULL,NULL,NULL),(4,1,NULL,50.0000,NULL,NULL,4,2,7,8,NULL,'000000004','2018-07-22 10:38:32','2018-07-22 10:38:32','[]',NULL,NULL,NULL),(5,1,NULL,8.0000,NULL,NULL,5,1,9,10,NULL,'000000005','2018-07-23 10:17:34','2018-07-23 10:17:34','[]',NULL,NULL,NULL),(6,1,NULL,2.0000,NULL,NULL,6,1,11,12,NULL,'000000006','2018-07-24 04:51:14','2018-07-24 04:51:14','[]',NULL,NULL,NULL),(7,1,NULL,1.0000,NULL,NULL,7,1,13,14,NULL,'000000007','2020-10-01 14:12:05','2020-10-01 14:12:05','[]',NULL,NULL,NULL),(8,1,NULL,3.0000,NULL,NULL,8,1,15,16,NULL,'000000008','2020-10-02 22:26:02','2020-10-02 22:26:02','[]',NULL,NULL,NULL),(9,1,NULL,1.0000,NULL,NULL,9,1,17,18,NULL,'000000009','2020-10-02 22:28:57','2020-10-02 22:28:57','[]',NULL,NULL,NULL);

--
-- 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 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`),
  KEY `SALES_SHIPMENT_GRID_ORDER_ID` (`order_id`),
  FULLTEXT KEY `FTI_086B40C8955F167B8EA76653437879B4` (`increment_id`,`order_increment_id`,`shipping_name`,`customer_name`,`customer_email`,`billing_address`,`shipping_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Grid';

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

INSERT INTO `sales_shipment_grid` VALUES (1,'000000001',1,'000000001',1,'2018-03-15 09:10:00','Jason Statham',5.0000,NULL,'pending','123 CS HN California 10000','123 CS HN California 10000','Jason Statham','Jason Statham','test@gmail.com',1,'checkmo','Flat Rate - Fixed','2018-03-15 09:24:06','2018-03-15 09:24:06'),(2,'000000002',1,'000000002',2,'2018-03-20 06:29:49','Jason Statham',5.0000,NULL,'pending','123 CS HN California 10000','123 CS HN California 10000','Jason Statham','Jason Statham','test@gmail.com',1,'checkmo','Flat Rate - Fixed','2018-03-20 07:23:14','2018-03-20 07:23:14'),(3,'000000003',1,'000000003',3,'2018-07-22 10:25:29','Leo Diano',67.0000,NULL,'pending','Geo Street Geo AB123CD','Geo Street Geo AB123CD','Leo Diano','Leo Diano','test2@yahoo.com',1,'checkmo','Flat Rate - Fixed','2018-07-22 10:28:05','2018-07-22 10:28:05'),(4,'000000004',1,'000000004',4,'2018-07-22 10:37:21','Leo Diano',50.0000,NULL,'pending','Geo Street Geo AB123CD','Geo Street Geo AB123CD','Leo Diano','Leo Diano','test2@yahoo.com',1,'checkmo','Flat Rate - Fixed','2018-07-22 10:38:32','2018-07-22 10:38:32'),(5,'000000005',1,'000000005',5,'2018-07-23 10:13:57','Jason Statham',8.0000,NULL,'pending','123 CS HN California 10000','123 CS HN California 10000','Jason Statham','Jason Statham','test@gmail.com',1,'checkmo','Flat Rate - Fixed','2018-07-23 10:17:34','2018-07-23 10:17:34'),(6,'000000006',1,'000000006',6,'2018-07-24 04:49:52','Jason Statham',2.0000,NULL,'pending','123 CS HN California 10000','123 CS HN California 10000','Jason Statham','Jason Statham','test@gmail.com',1,'checkmo','Flat Rate - Fixed','2018-07-24 04:51:14','2018-07-24 04:51:14'),(7,'000000007',1,'000000007',7,'2020-10-01 14:11:17','Jason Statham',1.0000,NULL,'processing','123 CS,HN,California,10000','123 CS,HN,California,10000','Jason Statham','Jason Statham','test@gmail.com',1,'checkmo','Flat Rate - Fixed','2020-10-01 14:12:05','2020-10-01 14:12:05'),(8,'000000008',1,'000000008',8,'2020-10-02 22:24:30','Jason Statham',3.0000,NULL,'processing','123 CS,HN,California,10000','123 CS,HN,California,10000','Jason Statham','Jason Statham','test@gmail.com',1,'checkmo','Flat Rate - Fixed','2020-10-02 22:26:02','2020-10-02 22:26:02'),(9,'000000009',1,'000000009',9,'2020-10-02 22:28:04','Jason Statham',1.0000,NULL,'processing','123 CS,HN,California,10000','123 CS,HN,California,10000','Jason Statham','Jason Statham','test@gmail.com',1,'checkmo','Flat Rate - Fixed','2020-10-02 22:28:57','2020-10-02 22:28:57');

--
-- 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 AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Item';

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

INSERT INTO `sales_shipment_item` VALUES (1,1,NULL,975.0000,1000.0000,5.0000,8,2,NULL,NULL,'DJI Phantom 4 Quadcopter Camera','MB008'),(2,2,NULL,200.0000,5000.0000,1.0000,14,3,NULL,NULL,'XtremepowerUS Stainless Steel Tumble Cloths Dryer','MB014'),(3,2,NULL,800.0000,1000.0000,1.0000,8,4,NULL,NULL,'DJI Phantom 4 Quadcopter Camera','MB008'),(4,2,NULL,250.0000,2000.0000,1.0000,2,5,NULL,NULL,'Canon MX492 Wireless All-IN-One Small Printer','MB002'),(5,2,NULL,200.0000,1500.0000,1.0000,19,6,NULL,NULL,'DBPOWER T20 1500 Lumens LCD Projector','MB017'),(6,2,NULL,350.0000,500.0000,1.0000,15,7,NULL,NULL,'Marshall PBluetooth Speaker','MB015-black'),(7,3,NULL,800.0000,1000.0000,6.0000,8,9,NULL,NULL,'DJI Phantom 4 Quadcopter Camera','MB008'),(8,3,NULL,200.0000,5000.0000,1.0000,14,10,NULL,NULL,'XtremepowerUS Stainless Steel Tumble Cloths Dryer','MB014'),(9,3,NULL,40.0000,100.0000,60.0000,20,11,NULL,NULL,'MVMTH Classical Leather Watch In Black','MB018'),(10,4,NULL,45.0000,100.0000,30.0000,72,12,NULL,NULL,'Augason Farms Freeze Dried Beef Chunks 1 lb No. 10','MB0058'),(11,4,NULL,20.0000,100.0000,20.0000,69,13,NULL,NULL,'Vita Coco Coconut Water - Pack of 12','MB0055'),(12,5,NULL,45.0000,1000.0000,3.0000,49,14,NULL,NULL,'Simple Plastice Chair','MB035'),(13,5,NULL,200.0000,5000.0000,2.0000,76,15,NULL,NULL,'Sofa In Blue & Brown Chair','MB0060-2'),(14,5,NULL,300.0000,2500.0000,1.0000,77,17,NULL,NULL,'Simple Short TV Board Combine Book Shelf','MB0061'),(15,5,NULL,300.0000,3000.0000,1.0000,79,18,NULL,NULL,'Korea Small Wood 4 Boxes Storage','MB0063'),(16,5,NULL,200.0000,1000.0000,1.0000,80,19,NULL,NULL,'Simple Wood Combine With Leather Chair','MB0064'),(17,6,NULL,300.0000,3000.0000,1.0000,79,20,NULL,NULL,'Korea Small Wood 4 Boxes Storage','MB0063'),(18,6,NULL,350.0000,1000.0000,1.0000,81,21,NULL,NULL,'Simple Tea Teable With Glass Surface','MB0065'),(19,7,NULL,525.0000,100.0000,1.0000,6,22,NULL,NULL,'Gopro Quick Sliver Hero4 24K HD Camera','MB006'),(20,8,NULL,350.0000,2000.0000,1.0000,3,23,NULL,NULL,'Samsung 55-Inch 4K Ultra HD Smart LED TV','MB003'),(21,8,NULL,12.0000,50.0000,1.0000,10,24,NULL,NULL,'iClever BoostCube Mini Charger','MB010'),(22,8,NULL,450.0000,200.0000,1.0000,5,25,NULL,NULL,'Nikon Coolpix 24 MP Camera','MB005'),(23,9,NULL,350.0000,2000.0000,1.0000,3,26,NULL,NULL,'Samsung 55-Inch 4K Ultra HD Smart LED TV','MB003');

--
-- 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 AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='Sales Shipping Aggregated';

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

INSERT INTO `sales_shipping_aggregated` VALUES (1,'2018-03-16',1,'complete','Flat Rate - Fixed',1,25.0000,25.0000),(2,'2018-03-21',1,'complete','Flat Rate - Fixed',1,25.0000,25.0000),(4,'2018-03-16',0,'complete','Flat Rate - Fixed',1,25.0000,25.0000),(5,'2018-03-21',0,'complete','Flat Rate - Fixed',1,25.0000,25.0000),(8,'2018-07-23',1,'complete','Flat Rate - Fixed',2,585.0000,585.0000),(11,'2018-07-23',0,'complete','Flat Rate - Fixed',2,585.0000,585.0000),(13,'2018-07-24',1,'complete','Flat Rate - Fixed',1,40.0000,40.0000),(14,'2018-07-25',1,'complete','Flat Rate - Fixed',1,10.0000,10.0000),(16,'2018-07-24',0,'complete','Flat Rate - Fixed',1,40.0000,40.0000),(17,'2018-07-25',0,'complete','Flat Rate - Fixed',1,10.0000,10.0000);

--
-- 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 AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='Sales Shipping Aggregated Order';

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

INSERT INTO `sales_shipping_aggregated_order` VALUES (1,'2018-03-16',1,'complete','Flat Rate - Fixed',1,25.0000,25.0000),(2,'2018-03-21',1,'complete','Flat Rate - Fixed',1,25.0000,25.0000),(4,'2018-03-16',0,'complete','Flat Rate - Fixed',1,25.0000,25.0000),(5,'2018-03-21',0,'complete','Flat Rate - Fixed',1,25.0000,25.0000),(8,'2018-07-23',1,'complete','Flat Rate - Fixed',2,585.0000,585.0000),(11,'2018-07-23',0,'complete','Flat Rate - Fixed',2,585.0000,585.0000),(13,'2018-07-24',1,'complete','Flat Rate - Fixed',1,40.0000,40.0000),(14,'2018-07-25',1,'complete','Flat Rate - Fixed',1,10.0000,10.0000),(16,'2018-07-24',0,'complete','Flat Rate - Fixed',1,40.0000,40.0000),(17,'2018-07-25',0,'complete','Flat Rate - Fixed',1,10.0000,10.0000);

--
-- 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',
  `is_spellchecked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is the query spellchecked',
  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=10 DEFAULT CHARSET=utf8 COMMENT='Search query table';

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

INSERT INTO `search_query` VALUES (1,'camera',5,4,NULL,1,1,1,0,'2020-09-04 09:33:05',0),(9,'fdf',0,1,NULL,1,1,1,0,'2020-09-04 09:32:03',0);

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `sequence_invoice_1` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9);

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=10 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `sequence_order_1` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9);

--
-- 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 DEFAULT CHARSET=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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 DEFAULT CHARSET=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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 DEFAULT CHARSET=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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 DEFAULT CHARSET=utf8mb4;

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


--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

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


--
-- 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 DEFAULT CHARSET=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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 DEFAULT CHARSET=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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 DEFAULT CHARSET=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `sequence_shipment_1` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9);

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

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


--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

--
-- 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=utf8mb4;

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


--
-- Table structure for table `service_calls`
--

CREATE TABLE `service_calls` (
  `service_call_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Service call id',
  `increment_id` varchar(20) NOT NULL DEFAULT '' COMMENT 'Increment id',
  `status` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Status',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer id',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `email_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Email Id',
  `phone_number` varchar(20) NOT NULL DEFAULT '' COMMENT 'Phone Number',
  `company_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Company Name',
  `skus` varchar(255) NOT NULL DEFAULT '' COMMENT 'Skus',
  `issue_types` varchar(255) NOT NULL DEFAULT '' COMMENT 'Issue Types',
  `payment_status` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Payment Status',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote id',
  `order_id` int(10) unsigned DEFAULT NULL COMMENT 'Order id',
  `have_agreement` varchar(10) NOT NULL DEFAULT '' COMMENT 'Have Agreement',
  `quoted_price` decimal(10,2) DEFAULT NULL COMMENT 'Quoted price',
  `quotation` text COMMENT 'Quotation',
  `service_report` text COMMENT 'Service Report',
  `comments` text COMMENT 'Customer Comments',
  `store_view` varchar(255) NOT NULL DEFAULT '' COMMENT 'Store View',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modified At',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT 'city',
  `street` varchar(255) NOT NULL DEFAULT '' COMMENT 'street',
  `country_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'country_id',
  `region` varchar(255) NOT NULL DEFAULT '' COMMENT 'region',
  `longitude` varchar(255) NOT NULL DEFAULT '' COMMENT 'longitude',
  `latitude` varchar(255) NOT NULL DEFAULT '' COMMENT 'latitude',
  `clusternumber` varchar(255) NOT NULL DEFAULT '' COMMENT 'Cluster Number',
  PRIMARY KEY (`service_call_id`),
  KEY `SERVICE_CALLS_QUOTE_ID_QUOTE_ENTITY_ID` (`quote_id`),
  KEY `SERVICE_CALLS_SERVICE_CALL_ID` (`service_call_id`),
  CONSTRAINT `SERVICE_CALLS_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Service Calls';

--
-- Dumping data for table `service_calls`
--


--
-- Table structure for table `service_plans`
--

CREATE TABLE `service_plans` (
  `service_plan_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Maintenance Plans id',
  `increment_id` varchar(20) NOT NULL DEFAULT '' COMMENT 'Increment id',
  `status` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Status',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer id',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `email_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Email Id',
  `phone_number` varchar(20) NOT NULL DEFAULT '' COMMENT 'Phone Number',
  `brand` varchar(255) NOT NULL DEFAULT '' COMMENT 'Brand',
  `series` varchar(255) NOT NULL DEFAULT '' COMMENT 'Series',
  `model` varchar(20) NOT NULL DEFAULT '' COMMENT 'Model',
  `company_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Company Name',
  `skus` varchar(255) NOT NULL DEFAULT '' COMMENT 'Skus',
  `clusternumber` varchar(255) NOT NULL DEFAULT '' COMMENT 'Cluster Number',
  `qtys` varchar(255) NOT NULL DEFAULT '' COMMENT 'Quantities',
  `store_view` varchar(255) NOT NULL DEFAULT '' COMMENT 'Store View',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT 'city',
  `street` varchar(255) NOT NULL DEFAULT '' COMMENT 'street',
  `country_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'country_id',
  `region` varchar(255) NOT NULL DEFAULT '' COMMENT 'region',
  `longitude` varchar(255) NOT NULL DEFAULT '' COMMENT 'longitude',
  `latitude` varchar(255) NOT NULL DEFAULT '' COMMENT 'latitude',
  `payment_status` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Payment Status',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote id',
  `order_id` int(10) unsigned DEFAULT NULL COMMENT 'Order id',
  `service_plan_type` varchar(255) NOT NULL DEFAULT '' COMMENT 'Plan type',
  `quoted_price` decimal(10,2) DEFAULT NULL COMMENT 'Quoted price',
  `quotation` text COMMENT 'Quotation',
  `service_agreement` text COMMENT 'Service Agreement',
  `comments` text COMMENT 'Customer Comments',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `starts_at` datetime DEFAULT NULL COMMENT 'Starts At',
  `expires_at` datetime DEFAULT NULL COMMENT 'Expires At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modified At',
  PRIMARY KEY (`service_plan_id`),
  KEY `SERVICE_PLANS_QUOTE_ID_QUOTE_ENTITY_ID` (`quote_id`),
  KEY `SERVICE_PLANS_SERVICE_PLAN_ID` (`service_plan_id`),
  CONSTRAINT `SERVICE_PLANS_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Maintenance Plans';

--
-- Dumping data for table `service_plans`
--


--
-- 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'),('Ambab_Attributes','1.0.0','1.0.0'),('Ambab_Chekoutlogin','1.0.0','1.0.0'),('Ambab_DiscountFilter','1.0.0','1.0.0'),('Ambab_EstimatingDelivery','1.0.0','1.0.0'),('Ambab_PriceDecimal','2.1.0','2.1.0'),('Ambab_Services','1.0.1','1.0.1'),('Ambab_Subscribe','2.1.2','2.1.2'),('Bss_ThemeFixed','1.0.0','1.0.0'),('Dotdigitalgroup_Chat','1.2.0','1.2.0'),('Dotdigitalgroup_Email','4.8.0','4.8.0'),('Hyperpay_Extension','2.0.0','2.0.0'),('Ibnab_MegaMenu','1.1.0','1.1.0'),('Ideo_StoreLocator','2.0.5','2.0.5'),('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'),('MageBig_AjaxCart','2.0.0','2.0.0'),('MageBig_Ajaxcompare','2.0.0','2.0.0'),('MageBig_AjaxFilter','2.0.0','2.0.0'),('MageBig_AjaxInfiniteScroll','2.0.0','2.0.0'),('MageBig_AjaxSearch','2.0.0','2.0.0'),('MageBig_Ajaxwishlist','2.0.0','2.0.0'),('MageBig_ExtendPageBuilder','2.0.0','2.0.0'),('MageBig_MbFrame','2.0.1','2.0.1'),('MageBig_MbLib','2.0.0','2.0.0'),('MageBig_NewsPopup','2.0.0','2.0.0'),('MageBig_QuickView','2.0.0','2.0.0'),('MageBig_Shopbybrand','2.0.1','2.0.1'),('MageBig_SmartMenu','2.0.1','2.0.1'),('MageBig_SocialLogin','3.0.0','3.0.0'),('MageBig_SyntaxCms','3.0.0','3.0.0'),('MageBig_WidgetPlus','2.0.0','2.0.0'),('MageBig_WysiwygFiles','2.0.0','2.0.0'),('Magefan_AdminUserGuide','2.0.1','2.0.1'),('Magefan_Blog','2.10.8','2.10.8'),('Magefan_Community','2.1.10','2.1.10'),('Magefan_WysiwygAdvanced','2.0.11','2.0.11'),('MageModule_Core','1.1.5','1.1.5'),('MageModule_OrderImportExport','1.2.0','1.2.0'),('Magenman_Mobilelogin','2.1.2','2.1.2'),('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_ComposerRootUpdatePlugin','0.1.0','0.1.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'),('Mageplaza_Blog','2.5.2','2.5.2'),('Mageplaza_Core','1.0.0','1.0.0'),('Mageplaza_PdfInvoice','1.1.0','1.1.0'),('Mageplaza_Smtp','1.2.5','1.2.5'),('Mageplaza_SocialShare','1.0.0','1.0.0'),('Magepow_Ajaxcart','1.1.4','1.1.4'),('Magepow_CancelOrder','1.0.0','1.0.0'),('Magepow_Gdpr','1.0.0','1.0.0'),('Magepow_Layerednav','1.0.0','1.0.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_PaymentRestriction','1.0.0','1.0.0'),('MageWorx_SearchSuiteAutocomplete','2.0.0','2.0.0'),('Magiccart_Alothemes','2.0','2.0'),('Magiccart_Lookbook','2.1','2.1'),('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'),('Manadev_Core','3','3'),('Manadev_ElasticSearch','1','1'),('Manadev_LayeredNavigation','28','28'),('Manadev_ProductCollection','1','1'),('MGS_Brand','2.0.1','2.0.1'),('MGS_Core','0.1.0','0.1.0'),('MobiSms_Notify','2.0.0','2.0.0'),('MSP_ReCaptcha','1.6.0','1.6.0'),('MSP_TwoFactorAuth','3.1.0','3.1.0'),('PayPal_Braintree','4.0.3','4.0.3'),('Rbj_CategoryWidget','2.1.1','2.1.1'),('ReviewRating_Outright','1.0.0','1.0.0'),('ReviewRating_Servicecall','1.0.0','1.0.0'),('ReviewRating_Serviceplan','1.0.0','1.0.0'),('ReviewRating_Subscription','1.0.0','1.0.0'),('Sagistri_CspWhitelist','1.0.0','1.0.0'),('Shopial_Facebook','1.0.0','1.0.0'),('SR_CustomerSession','2.0.0','2.0.0'),('SV_ClusterNumber','1.0.0','1.0.0'),('Swissup_Core','1.2.1','1.2.1'),('Swissup_Testimonials','1.0.0','1.0.0'),('Tawk_Widget','1.5.1','1.5.1'),('Vertex_AddressValidation','100.5.0','100.5.0'),('Vertex_Tax','100.5.1','100.5.1'),('Webkul_GoogleMapPinAddress','3.0.0','3.0.0'),('Worx_Device','1.0.0','1.0.0'),('Worx_DeviceImport','1.0.0','1.0.0'),('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 `sms_forgot_otp`
--

CREATE TABLE `sms_forgot_otp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Code ID',
  `created_time` date DEFAULT NULL COMMENT 'Created Time',
  `mobile` varchar(255) DEFAULT NULL COMMENT 'Mobile Number',
  `email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `ipaddress` varchar(255) DEFAULT NULL COMMENT 'IP Address',
  `random_code` varchar(255) DEFAULT NULL COMMENT 'Random Code',
  `is_verify` int(11) DEFAULT NULL COMMENT 'Is verify',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='sms_forgot_otp';

--
-- Dumping data for table `sms_forgot_otp`
--


--
-- Table structure for table `sms_login_otp`
--

CREATE TABLE `sms_login_otp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Code ID',
  `random_code` varchar(255) DEFAULT NULL COMMENT 'Random Code',
  `created_time` date DEFAULT NULL COMMENT 'Created Time',
  `mobile` varchar(255) DEFAULT NULL COMMENT 'Mobile Number',
  `is_verify` int(11) DEFAULT NULL COMMENT 'Is verify',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='sms_login_otp';

--
-- Dumping data for table `sms_login_otp`
--


--
-- Table structure for table `sms_register_otp`
--

CREATE TABLE `sms_register_otp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Code ID',
  `random_code` varchar(255) DEFAULT NULL COMMENT 'Random Code',
  `created_time` date DEFAULT NULL COMMENT 'Created Time',
  `mobile` varchar(255) DEFAULT NULL COMMENT 'Mobile Number',
  `is_verify` int(11) DEFAULT NULL COMMENT 'Is verify',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='sms_register_otp';

--
-- Dumping data for table `sms_register_otp`
--


--
-- 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=19 DEFAULT CHARSET=utf8 COMMENT='Stores';

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

INSERT INTO `store` VALUES (0,'admin',0,0,'Admin',0,1),(1,'en',1,1,'English',0,1),(2,'du',1,2,'Dutch',1,1),(3,'ge',1,3,'German',1,1),(4,'fr',1,4,'French',1,1),(5,'ge2',1,1,'German',2,1),(6,'ar',1,1,'Arabic',3,1),(7,'en2',1,2,'English',2,1),(8,'ar2',1,2,'Arabic',3,1),(9,'en3',1,3,'English',2,1),(10,'ar3',1,3,'Arabic',3,1),(11,'en4',1,4,'English',2,1),(12,'ar4',1,4,'Arabic',3,1),(13,'en5',1,5,'English',1,1),(14,'es',1,5,'Spanish',2,1),(15,'ar5',1,5,'Arabic',3,1),(16,'en6',1,6,'English',1,1),(17,'br',1,6,'Brazil',2,1),(18,'ar6',1,6,'Arabic',3,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=7 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,'main_website_store','Main Website Store',2,1),(2,1,'store02','store02',2,2),(3,1,'store03','store03',2,3),(4,1,'store04','store04',2,4),(5,1,'store05','store05',2,13),(6,1,'store06','store06',2,16);

--
-- 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 `swissup_core_module`
--

CREATE TABLE `swissup_core_module` (
  `code` varchar(50) NOT NULL COMMENT 'Code',
  `name` varchar(50) DEFAULT NULL COMMENT 'Package Name',
  `description` varchar(255) DEFAULT NULL COMMENT 'Package Description',
  `keywords` varchar(255) DEFAULT NULL COMMENT 'Keywords',
  `data_version` varchar(50) DEFAULT NULL COMMENT 'Data_version',
  `identity_key` varchar(255) DEFAULT NULL COMMENT 'Identity_key',
  `store_ids` varchar(64) DEFAULT NULL COMMENT 'Store_ids',
  `type` varchar(32) DEFAULT NULL COMMENT 'Package Type',
  `version` varchar(50) DEFAULT NULL COMMENT 'Version',
  `latest_version` varchar(50) DEFAULT NULL COMMENT 'Latest Version',
  `release_date` datetime DEFAULT NULL COMMENT 'Release Date',
  `link` varchar(255) DEFAULT NULL COMMENT 'Module Homepage',
  `download_link` varchar(255) DEFAULT NULL COMMENT 'Module Download Link',
  `identity_key_link` varchar(255) DEFAULT NULL COMMENT 'Identity Key Link',
  PRIMARY KEY (`code`),
  FULLTEXT KEY `SWISSUP_CORE_MODULE_CODE_NAME_DESCRIPTION_KEYWORDS` (`code`,`name`,`description`,`keywords`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='swissup_core_module';

--
-- Dumping data for table `swissup_core_module`
--


--
-- Table structure for table `swissup_testimonials_data`
--

CREATE TABLE `swissup_testimonials_data` (
  `testimonial_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Testimonial ID',
  `status` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Testimonial status',
  `date` datetime NOT NULL COMMENT 'Testimonial creation time',
  `name` varchar(100) NOT NULL COMMENT 'User name',
  `email` varchar(100) NOT NULL COMMENT 'User email',
  `message` text NOT NULL COMMENT 'User message',
  `company` varchar(255) DEFAULT NULL COMMENT 'User company',
  `website` varchar(255) DEFAULT NULL COMMENT 'User website',
  `twitter` varchar(255) DEFAULT NULL COMMENT 'User twitter',
  `facebook` varchar(255) DEFAULT NULL COMMENT 'User facebook',
  `image` varchar(100) DEFAULT NULL COMMENT 'User image path',
  `rating` smallint(6) DEFAULT NULL COMMENT 'User rating',
  `widget` smallint(6) DEFAULT '1' COMMENT 'Show testimonial in widget',
  PRIMARY KEY (`testimonial_id`),
  FULLTEXT KEY `SWISSUP_TESTIMONIALS_DATA_NAME_EMAIL_MESSAGE` (`name`,`email`,`message`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Swissup Testimonials Data Table';

--
-- Dumping data for table `swissup_testimonials_data`
--


--
-- Table structure for table `swissup_testimonials_store`
--

CREATE TABLE `swissup_testimonials_store` (
  `testimonial_id` smallint(6) NOT NULL COMMENT 'Testimonial ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`testimonial_id`,`store_id`),
  KEY `SWISSUP_TESTIMONIALS_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_6075F59DE8F3F62A95A3F8371EA6D77D` FOREIGN KEY (`testimonial_id`) REFERENCES `swissup_testimonials_data` (`testimonial_id`) ON DELETE CASCADE,
  CONSTRAINT `SWISSUP_TESTIMONIALS_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Swissup Testimonial To Store Linkage Table';

--
-- Dumping data for table `swissup_testimonials_store`
--


--
-- Table structure for table `tawk_widget`
--

CREATE TABLE `tawk_widget` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `for_store_id` varchar(50) DEFAULT NULL COMMENT 'For store Id',
  `page_id` varchar(50) DEFAULT NULL COMMENT 'Page Id',
  `widget_id` varchar(50) DEFAULT NULL COMMENT 'Widget Id',
  `always_display` int(11) DEFAULT NULL COMMENT 'always_display',
  `exclude_url` varchar(255) DEFAULT NULL COMMENT 'exclude_url',
  `do_not_display` int(11) DEFAULT NULL COMMENT 'do_not_display',
  `include_url` varchar(255) DEFAULT NULL COMMENT 'include_url',
  `enable_visitor_recognition` int(11) NOT NULL DEFAULT '1' COMMENT 'Enable visitor recognition feature',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tawk Widget table that makes connection between stores and widgets';

--
-- Dumping data for table `tawk_widget`
--


--
-- 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 `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=26 DEFAULT CHARSET=utf8 COMMENT='Core theme';

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

INSERT INTO `theme` VALUES (1,NULL,'Magento/blank','Magento Blank','preview_image_5af290293bdd1.jpeg',0,'frontend',0,'Magento/blank'),(2,1,'Magento/luma','Magento Luma','preview_image_5af2902963445.jpeg',0,'frontend',0,'Magento/luma'),(3,NULL,'Magento/backend','Magento 2 backend',NULL,0,'adminhtml',0,'Magento/backend'),(4,1,'MageBig/martfury_layout01','Martfury - 01 Market','preview_image_5af2902981171.jpeg',0,'frontend',1,'MageBig/martfury_layout01'),(5,1,'MageBig/martfury_layout02','Martfury - 02 Electronic','preview_image_5af29029b6af1.jpeg',0,'frontend',1,'MageBig/martfury_layout02'),(6,1,'MageBig/martfury_layout03','Martfury - 03 Organic','preview_image_5af29029e302a.jpeg',0,'frontend',1,'MageBig/martfury_layout03'),(7,1,'MageBig/martfury_layout04','Martfury - 04 Furniture','preview_image_5b35f1ff58932.jpeg',0,'frontend',1,'MageBig/martfury_layout04'),(8,1,'MageBig/martfury_layout05','Martfury - 05 Market','preview_image_5be1907c2ffbd.jpeg',0,'frontend',1,'MageBig/martfury_layout05'),(9,1,'MageBig/martfury_layout06','Martfury - 06 Kids','preview_image_5d7b2793c32a6.jpeg',0,'frontend',1,'MageBig/martfury_layout06'),(11,1,'Alothemes/milano','Alothemes Milano','preview_image_62f22d1e68ed9.jpeg',0,'frontend',0,'Alothemes/milano'),(12,11,'Alothemes/milano6','Alothemes Milano6','preview_image_62f22d1e818f6.jpeg',0,'frontend',0,'Alothemes/milano6'),(13,11,'Alothemes/milano13','Alothemes Milano13','preview_image_62f22d1e98ab4.jpeg',0,'frontend',0,'Alothemes/milano13'),(14,11,'Alothemes/milano5','Alothemes Milano5','preview_image_62f22d1eaeb10.jpeg',0,'frontend',0,'Alothemes/milano5'),(15,11,'Alothemes/milano15','Alothemes Milano15','preview_image_62f22d1ec4db5.jpeg',0,'frontend',0,'Alothemes/milano15'),(16,11,'Alothemes/milano11','Alothemes Milano11','preview_image_62f22d1eda0ab.jpeg',0,'frontend',0,'Alothemes/milano11'),(17,11,'Alothemes/milano14','Alothemes Milano14','preview_image_62f22d1eef776.jpeg',0,'frontend',0,'Alothemes/milano14'),(18,11,'Alothemes/milano7','Alothemes Milano7','preview_image_62f22d1f10f63.jpeg',0,'frontend',0,'Alothemes/milano7'),(19,11,'Alothemes/milano10','Alothemes Milano10','preview_image_62f22d1f25d0c.jpeg',0,'frontend',0,'Alothemes/milano10'),(20,11,'Alothemes/milano2','Alothemes Milano2','preview_image_62f22d1f3b49a.jpeg',0,'frontend',0,'Alothemes/milano2'),(21,11,'Alothemes/milano3','Alothemes Milano3','preview_image_62f22d1f50043.jpeg',0,'frontend',0,'Alothemes/milano3'),(22,11,'Alothemes/milano8','Alothemes Milano8','preview_image_62f22d1f657b4.jpeg',0,'frontend',0,'Alothemes/milano8'),(23,11,'Alothemes/milano12','Alothemes Milano12','preview_image_62f22d1f7bd42.jpeg',0,'frontend',0,'Alothemes/milano12'),(24,11,'Alothemes/milano16','Alothemes Milano16','preview_image_62f22d1f9194c.jpeg',0,'frontend',0,'Alothemes/milano16'),(25,11,'Alothemes/milano4','Alothemes Milano4','preview_image_62f22d1fa87ef.jpeg',0,'frontend',0,'Alothemes/milano4');

--
-- 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=39 DEFAULT CHARSET=utf8 COMMENT='Bookmark';

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

INSERT INTO `ui_bookmark` VALUES (1,1,'product_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"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},\"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},\"msrp\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"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},\"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},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"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,\"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,\"custom_layout\":30,\"msrp\":31,\"url_key\":32,\"gift_message_available\":33,\"tax_class_id\":34,\"actions\":35},\"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'),(2,1,'product_listing','current',0,NULL,'{\"current\":{\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"desc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"websites\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":true,\"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},\"msrp\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false},\"special_from_date\":{\"visible\":true,\"sorting\":false},\"special_to_date\":{\"visible\":true,\"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},\"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},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"size\":{\"visible\":false,\"sorting\":false},\"country_of_origin\":{\"visible\":false,\"sorting\":false},\"style\":{\"visible\":false,\"sorting\":false},\"pattern\":{\"visible\":false,\"sorting\":false},\"salable_quantity\":{\"visible\":true,\"sorting\":false}},\"filters\":{\"applied\":{\"placeholder\":true}},\"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,\"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,\"custom_layout\":30,\"msrp\":31,\"url_key\":32,\"gift_message_available\":33,\"tax_class_id\":34,\"actions\":35,\"size\":36,\"country_of_origin\":37,\"style\":38,\"pattern\":39,\"salable_quantity\":40},\"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},\"search\":{\"value\":\"\"}}}','0000-00-00 00:00:00','2019-12-26 11:38:55'),(3,1,'product_attributes_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"columns\":{\"ids\":{\"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},\"is_filterable\":{\"visible\":true,\"sorting\":false},\"attribute_code\":{\"visible\":true,\"sorting\":\"asc\"},\"frontend_label\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"attribute_code\":1,\"frontend_label\":2,\"is_required\":3,\"is_user_defined\":4,\"is_visible\":5,\"is_global\":6,\"is_searchable\":7,\"is_comparable\":8,\"is_filterable\":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\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,1,'product_attributes_grid','current',0,NULL,'{\"current\":{\"columns\":{\"ids\":{\"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},\"is_filterable\":{\"visible\":true,\"sorting\":false},\"attribute_code\":{\"visible\":true,\"sorting\":\"asc\"},\"frontend_label\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"attribute_code\":1,\"frontend_label\":2,\"is_required\":3,\"is_user_defined\":4,\"is_visible\":5,\"is_global\":6,\"is_searchable\":7,\"is_comparable\":8,\"is_filterable\":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}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,1,'product_attributes_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"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},\"columns\":{\"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},\"attribute_code\":{\"visible\":true,\"sorting\":\"asc\"},\"frontend_label\":{\"visible\":true,\"sorting\":false}},\"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},\"displayMode\":\"grid\"},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,1,'product_attributes_listing','current',0,NULL,'{\"current\":{\"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},\"columns\":{\"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},\"attribute_code\":{\"visible\":true,\"sorting\":\"asc\"},\"frontend_label\":{\"visible\":true,\"sorting\":false}},\"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},\"displayMode\":\"grid\"}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,1,'grouped_product_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"thumbnail\":{\"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},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"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},\"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},\"msrp\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"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,\"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,\"custom_layout\":29,\"msrp\":30,\"url_key\":31,\"gift_message_available\":32,\"tax_class_id\":33,\"status_text\":34},\"displayMode\":\"grid\"},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,1,'grouped_product_listing','current',0,NULL,'{\"current\":{\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"thumbnail\":{\"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},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"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},\"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},\"msrp\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"size\":{\"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},\"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,\"custom_layout\":29,\"msrp\":30,\"url_key\":31,\"gift_message_available\":32,\"tax_class_id\":33,\"status_text\":34,\"size\":35},\"displayMode\":\"grid\"}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,1,'bundle_product_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"displayMode\":\"grid\",\"columns\":{\"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},\"msrp\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"thumbnail\":{\"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},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"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}},\"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,\"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,\"custom_layout\":26,\"msrp\":27,\"url_key\":28,\"gift_message_available\":29,\"tax_class_id\":30}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,1,'bundle_product_listing','current',0,NULL,'{\"current\":{\"displayMode\":\"grid\",\"columns\":{\"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},\"msrp\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"thumbnail\":{\"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},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"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}},\"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,\"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,\"custom_layout\":26,\"msrp\":27,\"url_key\":28,\"gift_message_available\":29,\"tax_class_id\":30}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,1,'cms_block_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"block_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"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,\"block_id\":1,\"title\":2,\"identifier\":3,\"store_id\":4,\"is_active\":5,\"creation_time\":6,\"update_time\":7,\"actions\":8},\"filters\":{\"applied\":{\"placeholder\":true}}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,1,'cms_block_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"block_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"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\":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},\"filters\":{\"applied\":{\"placeholder\":true}}}}','0000-00-00 00:00:00','2020-09-27 18:21:56'),(13,1,'cms_page_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"page_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keywords\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"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},\"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},\"actions\":{\"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,\"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_title\":13,\"meta_keywords\":14,\"meta_description\":15,\"actions\":16}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,1,'cms_page_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"page_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keywords\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"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},\"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},\"actions\":{\"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,\"pageSize\":20,\"current\":1},\"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_title\":13,\"meta_keywords\":14,\"meta_description\":15,\"actions\":16}}}','0000-00-00 00:00:00','2019-11-21 09:33:29'),(15,1,'sales_order_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"columns\":{\"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},\"actions\":{\"visible\":true,\"sorting\":false},\"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}},\"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},\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,1,'sales_order_grid','current',0,NULL,'{\"current\":{\"columns\":{\"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},\"actions\":{\"visible\":true,\"sorting\":false},\"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},\"allocated_sources\":{\"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,\"pageSize\":20,\"current\":1},\"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,\"allocated_sources\":21},\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"}}}','0000-00-00 00:00:00','2020-10-02 18:11:41'),(17,1,'sales_order_view_invoice_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\":\"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},\"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},\"actions\":{\"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,\"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}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,1,'sales_order_view_creditmemo_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},\"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},\"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},\"actions\":{\"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,\"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}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,1,'sales_order_view_creditmemo_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"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},\"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},\"actions\":{\"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,\"pageSize\":20,\"current\":1},\"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}}}','0000-00-00 00:00:00','2020-10-02 18:11:55'),(20,1,'sales_order_view_shipment_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"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},\"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},\"actions\":{\"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,\"pageSize\":20,\"current\":1},\"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}}}','0000-00-00 00:00:00','2020-10-02 18:11:55'),(21,1,'sales_order_view_shipment_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\":\"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},\"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},\"actions\":{\"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,\"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\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,1,'sales_order_view_invoice_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"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},\"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},\"actions\":{\"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,\"pageSize\":20,\"current\":1},\"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}}}','0000-00-00 00:00:00','2020-10-02 18:11:55'),(23,1,'design_config_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"store_website_id\":{\"visible\":true,\"sorting\":false},\"store_group_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"theme_theme_id\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"default\":{\"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\":{\"default\":0,\"store_website_id\":1,\"store_group_id\":2,\"store_id\":3,\"actions\":4,\"theme_theme_id\":5}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,1,'design_config_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"store_website_id\":{\"visible\":true,\"sorting\":false},\"store_group_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"theme_theme_id\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"default\":{\"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,\"pageSize\":20,\"current\":1},\"positions\":{\"default\":0,\"store_website_id\":1,\"store_group_id\":2,\"store_id\":3,\"actions\":4,\"theme_theme_id\":5}}}','0000-00-00 00:00:00','2020-09-07 02:34:45'),(25,1,'sales_order_invoice_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"columns\":{\"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},\"actions\":{\"visible\":true,\"sorting\":false},\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"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}},\"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,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"base_grand_total\":7,\"grand_total\":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,\"actions\":19},\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,1,'sales_order_invoice_grid','current',0,NULL,'{\"current\":{\"columns\":{\"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},\"actions\":{\"visible\":true,\"sorting\":false},\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"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}},\"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,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"base_grand_total\":7,\"grand_total\":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,\"actions\":19},\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,1,'customer_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"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},\"lock_expires\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"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},\"created_at\":{\"visible\":true,\"sorting\":false},\"dob\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"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,\"lock_expires\":25,\"actions\":26},\"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'),(28,1,'customer_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"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},\"lock_expires\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"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},\"created_at\":{\"visible\":true,\"sorting\":false},\"dob\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"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,\"lock_expires\":25,\"actions\":26},\"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'),(29,1,'dotdigitalgroup_cron_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"schedule_id\":{\"visible\":true,\"sorting\":false},\"job_code\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"messages\":{\"visible\":true,\"sorting\":\"asc\"},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"scheduled_at\":{\"visible\":true,\"sorting\":false},\"executed_at\":{\"visible\":true,\"sorting\":false},\"finished_at\":{\"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,\"schedule_id\":1,\"job_code\":2,\"status\":3,\"messages\":4,\"created_at\":5,\"scheduled_at\":6,\"executed_at\":7,\"finished_at\":8}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,1,'dotdigitalgroup_cron_grid','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"schedule_id\":{\"visible\":true,\"sorting\":false},\"job_code\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"messages\":{\"visible\":true,\"sorting\":\"asc\"},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"scheduled_at\":{\"visible\":true,\"sorting\":false},\"executed_at\":{\"visible\":true,\"sorting\":false},\"finished_at\":{\"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,\"schedule_id\":1,\"job_code\":2,\"status\":3,\"messages\":4,\"created_at\":5,\"scheduled_at\":6,\"executed_at\":7,\"finished_at\":8}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,1,'dotdigitalgroup_campaign_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"campaign_id\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"customer_id\":{\"visible\":true,\"sorting\":false},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"quote_id\":{\"visible\":true,\"sorting\":false},\"event_name\":{\"visible\":true,\"sorting\":false},\"message\":{\"visible\":true,\"sorting\":false},\"checkout_method\":{\"visible\":true,\"sorting\":false},\"send_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"sent_at\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":\"desc\"},\"updated_at\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"send_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,\"campaign_id\":1,\"email\":2,\"customer_id\":3,\"order_increment_id\":4,\"quote_id\":5,\"event_name\":6,\"message\":7,\"checkout_method\":8,\"sent_at\":9,\"send_id\":10,\"send_status\":11,\"store_id\":12,\"created_at\":13,\"updated_at\":14}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,1,'dotdigitalgroup_campaign_grid','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"campaign_id\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"customer_id\":{\"visible\":true,\"sorting\":false},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"quote_id\":{\"visible\":true,\"sorting\":false},\"event_name\":{\"visible\":true,\"sorting\":false},\"message\":{\"visible\":true,\"sorting\":false},\"checkout_method\":{\"visible\":true,\"sorting\":false},\"send_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"sent_at\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":\"desc\"},\"updated_at\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"send_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,\"campaign_id\":1,\"email\":2,\"customer_id\":3,\"order_increment_id\":4,\"quote_id\":5,\"event_name\":6,\"message\":7,\"checkout_method\":8,\"sent_at\":9,\"send_id\":10,\"send_status\":11,\"store_id\":12,\"created_at\":13,\"updated_at\":14}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,1,'dotdigitalgroup_abandoned_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"id\":{\"visible\":true,\"sorting\":false},\"quote_id\":{\"visible\":true,\"sorting\":false},\"customer_id\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"abandoned_cart_number\":{\"visible\":true,\"sorting\":false},\"items_count\":{\"visible\":true,\"sorting\":false},\"items_ids\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"quote_updated_at\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":\"desc\"},\"updated_at\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"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,\"id\":1,\"quote_id\":2,\"customer_id\":3,\"email\":4,\"is_active\":5,\"quote_updated_at\":6,\"abandoned_cart_number\":7,\"items_count\":8,\"items_ids\":9,\"store_id\":10,\"created_at\":11,\"updated_at\":12}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,1,'dotdigitalgroup_abandoned_grid','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"id\":{\"visible\":true,\"sorting\":false},\"quote_id\":{\"visible\":true,\"sorting\":false},\"customer_id\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"abandoned_cart_number\":{\"visible\":true,\"sorting\":false},\"items_count\":{\"visible\":true,\"sorting\":false},\"items_ids\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"quote_updated_at\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":\"desc\"},\"updated_at\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"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,\"id\":1,\"quote_id\":2,\"customer_id\":3,\"email\":4,\"is_active\":5,\"quote_updated_at\":6,\"abandoned_cart_number\":7,\"items_count\":8,\"items_ids\":9,\"store_id\":10,\"created_at\":11,\"updated_at\":12}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,1,'customer_online_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"customer_id\":{\"visible\":true,\"sorting\":\"asc\"},\"firstname\":{\"visible\":true,\"sorting\":false},\"lastname\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"last_visit_at\":{\"visible\":true,\"sorting\":false},\"visitor_type\":{\"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\":{\"customer_id\":0,\"firstname\":1,\"lastname\":2,\"email\":3,\"last_visit_at\":4,\"visitor_type\":5}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,1,'customer_online_grid','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"customer_id\":{\"visible\":true,\"sorting\":false},\"firstname\":{\"visible\":true,\"sorting\":false},\"lastname\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"last_visit_at\":{\"visible\":true,\"sorting\":\"desc\"},\"visitor_type\":{\"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\":{\"customer_id\":0,\"firstname\":1,\"lastname\":2,\"email\":3,\"last_visit_at\":4,\"visitor_type\":5}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(37,1,'bulk_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\":{\"uuid\":{\"visible\":true,\"sorting\":false},\"description\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":false,\"sorting\":false},\"start_time\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"uuid\":1,\"start_time\":2,\"description\":3,\"status\":4,\"actions\":5}},\"value\":\"Default View\"}}}','2021-11-11 00:59:24','2021-11-11 00:59:24'),(38,1,'bulk_listing','current',0,NULL,'{\"current\":{\"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\":{\"uuid\":{\"visible\":true,\"sorting\":false},\"description\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":false,\"sorting\":false},\"start_time\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"uuid\":1,\"start_time\":2,\"description\":3,\"status\":4,\"actions\":5}}}','2021-11-11 00:59:25','2021-11-11 00:59:25');

--
