VvebOIDC/install/sql/insert/product/product.sql

22 lines
4.3 KiB
SQL

INSERT INTO `product` (`admin_id`,`model`, `sku`, `upc`, `ean`, `jan`, `isbn`, `mpn`, `location`, `stock_quantity`, `stock_status_id`, `image`, `manufacturer_id`, `vendor_id`, `requires_shipping`, `price`, `old_price`, `points`, `tax_type_id`, `date_available`, `weight`, `weight_type_id`, `length`, `width`, `height`, `length_type_id`, `subtract_stock`, `minimum_quantity`, `sort_order`, `status`, `type`, `template`, `views`, `created_at`, `updated_at`) VALUES
(1, 'Product 1','','','','','','','',939,7,'demo/products/1-1.jpg',1,1,1,99.00,0, 200,1,'2023-05-01',146.40000000,2,0.0000,0.0000,0.0000,1,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 2','','','','','','','',999,6,'demo/products/2-1.jpg',2,1,1,279.9900,0, 0,1,'2023-05-01',133.0000,2,0.0000,0.0000,0.0000,3,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 3','','','','','','','',7,6,'demo/products/3-1.jpg',3,1,1,100.00,0, 0,1,'2023-05-01',0.0000,1,0.0000,0.0000,0.0000,1,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 4','','','','','','','',1000,6,'demo/products/4-1.jpg',0,1,1,80.00,0, 0,1,'2023-05-01',0.0000,1,0.0000,0.0000,0.0000,3,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 5','','','','','','','',999,6,'demo/products/5-1.jpg',4,1,1,100.00,0, 0,1,'2023-05-01',5.0000,1,0.0000,0.0000,0.0000,1,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 6','','','','','','','',1000,6,'demo/products/6-1.jpg',0,1,1,200.00,0, 0,1,'2023-05-01',5.0000,1,0.0000,0.0000,0.0000,2,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 7','','','','','','','',1000,6,'demo/products/7-1.jpg',1,1,1,100.00,0, 0,1,'2023-05-01',5.0000,1,0.0000,0.0000,0.0000,2,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 8','','','','','','','',1000,5,'demo/products/8-1.jpg',0,0,1,100.00,0, 0,1,'2023-05-01',5.0000,1,0.0000,0.0000,0.0000,1,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 9','','','','','','','',994,6,'demo/products/9-1.jpg',2,0,1,100.00,0, 1,1,'2023-05-01',5.0000,1,0.0000,0.0000,0.0000,2,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 10','','','','','','','',970,5,'demo/products/10-1.jpg',3,1,1,101.00,0, 0,1,'2023-05-01',10.0000,1,0.0000,0.0000,0.0000,1,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 11','','','','','','','',977,5,'demo/products/1-1.jpg',4,1,1,100.00,0, 0,1,'2023-05-01',5.0000,1,0.0000,0.0000,0.0000,1,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 12','','','','','','','',990,5,'demo/products/2-1.jpg',1,1,1,100.00,0, 400,1,'2009-02-04',12.50000000,1,1.0000,2.0000,3.0000,1,1,2,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 13','','','','','','','',929,5,'demo/products/3-1.jpg',2,0,1,500.00,0, 0,1,'2023-05-01',0.0000,1,0.0000,0.0000,0.0000,2,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 14','','','','','','','',1000,5,'demo/products/4-1.jpg',3,1,1,1000.00,0, 0,1,'2023-05-01',0.0000,1,0.0000,0.0000,0.0000,2,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 15','','','','','','','',998,5,'demo/products/5-1.jpg',3,1,1,2000.00,0, 0,1,'2023-05-01',0.0000,1,0.0000,0.0000,0.0000,2,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 16','','','','','','','',1000,5,'demo/products/6-1.jpg',4,1,1,1000.00,0, 0,1,'2023-05-01',0.0000,1,0.0000,0.0000,0.0000,2,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 17','','','','','','','',0,5,'demo/products/7-1.jpg',5,1,1,100.00,0, 400,1,'2023-05-01',1.0000,1,0.0000,0.0000,0.0000,1,0,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 18','test 1','','','','','','test 2',995,5,'demo/products/8-1.jpg',1,1,1,100.00,120.00, 0,1,'2009-02-08',1.0000,1,0.0000,0.0000,0.0000,2,1,1,0,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00'),
(1, 'Product 19','','','','','','','',1000,1,'demo/products/9-1.jpg',0,1,1,199.9900,0, 0,1,'2011-04-25',0.0000,1,0.0000,0.0000,0.0000,1,1,1,1,1, 'product', '', 0,'2022-05-01 00:00:00','2022-05-01 00:00:00');