2-data.sql

INSERT INTO products (name, category, description, created) VALUES
    ('Laptop Pro', 'Electronics', 'High-performance laptop for professionals', NOW()),
    ('Smartphone X', 'Electronics', 'Latest smartphone with advanced features', NOW()),
    ('Wireless Headphones', 'Electronics', 'Noise-cancelling wireless headphones', NOW()),
    ('Gaming Console', 'Electronics', 'Next-gen gaming console with 4K support', NOW()),
    ('Coffee Maker', 'Home Appliances', 'Automatic coffee maker with timer', NOW()),
    ('Vacuum Cleaner', 'Home Appliances', 'Bagless vacuum cleaner with HEPA filter', NOW()),
    ('Blender', 'Home Appliances', 'Multi-speed blender with glass jar', NOW()),
    ('Running Shoes', 'Sportswear', 'Lightweight running shoes for long-distance runners', NOW()),
    ('Yoga Mat', 'Sportswear', 'Non-slip yoga mat for home and studio use', NOW()),
    ('Dumbbell Set', 'Sportswear', 'Adjustable dumbbell set with weights', NOW()),
    ('Office Chair', 'Furniture', 'Ergonomic office chair with lumbar support', NOW()),
    ('Desk Lamp', 'Furniture', 'Adjustable desk lamp with LED lighting', NOW()),
    ('Bookshelf', 'Furniture', 'Wooden bookshelf with multiple compartments', NOW()),
    ('Winter Jacket', 'Clothing', 'Waterproof winter jacket with insulation', NOW()),
    ('T-shirt', 'Clothing', 'Cotton T-shirt with logo print', NOW()),
    ('Jeans', 'Clothing', 'Classic blue jeans with a slim fit', NOW()),
    ('Dress', 'Clothing', 'Elegant evening dress for special occasions', NOW()),
    ('Wristwatch', 'Accessories', 'Water-resistant wristwatch with leather strap', NOW()),
    ('Sunglasses', 'Accessories', 'UV-protective sunglasses with polarized lenses', NOW()),
    ('Backpack', 'Accessories', 'Durable backpack with multiple compartments', NOW());

INSERT INTO skus (product_id, sku_code, price, quantity, weight, created) VALUES
    (1, 'LAP12345', 1299.99, 10, 1.5, NOW()),
    (1, 'LAP12346', 1399.99, 5, 1.4, NOW()),
    (1, 'LAP12347', 1499.99, 8, 1.6, NOW()),
    (2, 'PHX98765', 899.99, 15, 0.3, NOW()),
    (2, 'PHX98766', 999.99, 10, 0.32, NOW()),
    (2, 'PHX98767', 1099.99, 6, 0.35, NOW()),
    (3, 'WHP55433', 199.99, 20, 0.25, NOW()),
    (3, 'WHP55434', 249.99, 12, 0.24, NOW()),
    (3, 'WHP55435', 179.99, 25, 0.23, NOW()),
    (4, 'GMC76543', 499.99, 7, 3.5, NOW()),
    (4, 'GMC76544', 549.99, 9, 3.6, NOW()),
    (5, 'CMK32123', 79.99, 30, 2.0, NOW()),
    (5, 'CMK32124', 99.99, 12, 2.1, NOW()),
    (6, 'VCL11111', 199.99, 20, 4.0, NOW()),
    (6, 'VCL11112', 249.99, 15, 4.2, NOW()),
    (6, 'VCL11113', 189.99, 18, 4.3, NOW()),
    (7, 'BLD77777', 69.99, 25, 1.8, NOW()),
    (7, 'BLD77778', 89.99, 14, 1.9, NOW()),
    (7, 'BLD77779', 79.99, 20, 1.7, NOW()),
    (8, 'RSH87654', 119.99, 50, 0.7, NOW()),
    (8, 'RSH87655', 149.99, 30, 0.65, NOW()),
    (9, 'YMT12345', 39.99, 40, 0.5, NOW()),
    (9, 'YMT12346', 49.99, 35, 0.6, NOW()),
    (10, 'DBS99876', 199.99, 10, 15.0, NOW()),
    (10, 'DBS99877', 249.99, 8, 16.5, NOW()),
    (11, 'OFC43211', 299.99, 15, 18.0, NOW()),
    (11, 'OFC43212', 349.99, 5, 17.5, NOW()),
    (12, 'DLP65432', 59.99, 25, 1.0, NOW()),
    (12, 'DLP65433', 69.99, 20, 0.9, NOW()),
    (13, 'BSH67890', 149.99, 8, 20.0, NOW()),
    (13, 'BSH67891', 179.99, 12, 21.0, NOW()),
    (14, 'WJK54321', 199.99, 30, 1.2, NOW()),
    (14, 'WJK54322', 249.99, 25, 1.3, NOW()),
    (15, 'TSH87654', 19.99, 100, 0.2, NOW()),
    (15, 'TSH87655', 24.99, 80, 0.18, NOW()),
    (16, 'JNS43211', 49.99, 60, 0.75, NOW()),
    (16, 'JNS43212', 59.99, 45, 0.8, NOW()),
    (17, 'DRS56789', 99.99, 25, 0.5, NOW()),
    (17, 'DRS56790', 129.99, 20, 0.55, NOW()),
    (18, 'WWT65432', 199.99, 40, 0.15, NOW()),
    (18, 'WWT65433', 249.99, 35, 0.18, NOW()),
    (19, 'SGS76543', 79.99, 50, 0.1, NOW()),
    (19, 'SGS76544', 99.99, 40, 0.12, NOW()),
    (20, 'BKP54321', 59.99, 70, 1.0, NOW()),
    (20, 'BKP54322', 79.99, 50, 1.1, NOW()),
    (1, 'LAP12348', 1599.99, 4, 1.5, NOW()),
    (2, 'PHX98768', 1099.99, 7, 0.33, NOW()),
    (3, 'WHP55436', 219.99, 15, 0.26, NOW()),
    (4, 'GMC76545', 599.99, 3, 3.8, NOW()),
    (5, 'CMK32125', 89.99, 20, 2.2, NOW());