-- ------------------------------------------------------
-- ------------------------------------------------------
--
-- WPBackItUp Database Export 
--
-- Created: 2021/05/10 on 04:31
--
-- Database : michehh108
--
-- Backup   Table  : mod725_wc_product_meta_lookup
-- Snapshot Table  : 1620671467_wc_product_meta_lookup
--
-- SQL    : SELECT * FROM mod725_wc_product_meta_lookup LIMIT 0,10000
-- Offset : 0
-- Rows   : 32
-- ------------------------------------------------------
-- ------------------------------------------------------
SET AUTOCOMMIT = 0 ;
SET FOREIGN_KEY_CHECKS=0 ;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40101 SET SESSION sql_mode = '' */;

--
-- Table structure for table `1620671467_wc_product_meta_lookup`
--
DROP TABLE  IF EXISTS `1620671467_wc_product_meta_lookup`;
CREATE TABLE `1620671467_wc_product_meta_lookup` (
  `product_id` bigint(20) NOT NULL,
  `sku` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  `virtual` tinyint(1) DEFAULT '0',
  `downloadable` tinyint(1) DEFAULT '0',
  `min_price` decimal(19,4) DEFAULT NULL,
  `max_price` decimal(19,4) DEFAULT NULL,
  `onsale` tinyint(1) DEFAULT '0',
  `stock_quantity` double DEFAULT NULL,
  `stock_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'instock',
  `rating_count` bigint(20) DEFAULT '0',
  `average_rating` decimal(3,2) DEFAULT '0.00',
  `total_sales` bigint(20) DEFAULT '0',
  `tax_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'taxable',
  `tax_class` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  PRIMARY KEY (`product_id`),
  KEY `virtual` (`virtual`),
  KEY `downloadable` (`downloadable`),
  KEY `stock_status` (`stock_status`),
  KEY `stock_quantity` (`stock_quantity`),
  KEY `onsale` (`onsale`),
  KEY `min_max_price` (`min_price`,`max_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;



--
-- Data for table `mod725_wc_product_meta_lookup`
-- Number of rows: 32
--
INSERT INTO `1620671467_wc_product_meta_lookup` VALUES 
(133,'',0,0,32.0000,35.0000,0,NULL,'instock',0,0.00,0,NULL,NULL),
 (143,'',0,0,32.0000,32.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (144,'',0,0,35.0000,35.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (145,'',0,0,39.0000,45.0000,0,NULL,'instock',0,0.00,0,NULL,NULL),
 (146,'',0,0,39.0000,39.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (147,'',0,0,45.0000,45.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (149,'',0,0,35.0000,39.0000,0,NULL,'instock',0,0.00,0,NULL,NULL),
 (150,'',0,0,35.0000,35.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (151,'',0,0,39.0000,39.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (152,'',0,0,31.0000,35.0000,0,NULL,'instock',0,0.00,0,NULL,NULL),
 (153,'',0,0,31.0000,31.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (154,'',0,0,35.0000,35.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (155,'',0,0,15.0000,59.0000,0,NULL,'instock',0,0.00,1,'',''),
 (156,'',0,0,15.0000,15.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (157,'',0,0,25.0000,25.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (158,'',0,0,59.0000,59.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (159,'',0,0,15.0000,15.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (160,'',0,0,14.0000,55.0000,0,NULL,'instock',0,0.00,0,NULL,NULL),
 (161,'',0,0,14.0000,14.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (162,'',0,0,22.0000,22.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (163,'',0,0,55.0000,55.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (164,'',0,0,14.0000,14.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (165,'',0,0,17.0000,40.0000,0,NULL,'instock',0,0.00,2,'',''),
 (166,'',0,0,17.0000,17.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (167,'',0,0,24.0000,24.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (168,'',0,0,40.0000,40.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (169,'',0,0,19.0000,19.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (170,'',0,0,14.0000,47.0000,0,NULL,'instock',0,0.00,5,'',''),
 (171,'',0,0,14.0000,14.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (172,'',0,0,26.0000,26.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (173,'',0,0,47.0000,47.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL),
 (174,'',0,0,14.0000,14.0000,0,NULL,'instock',0,NULL,NULL,NULL,NULL);

SET FOREIGN_KEY_CHECKS = 1 ; 
COMMIT ; 
SET AUTOCOMMIT = 1 ; 
