CREATE TABLE IF NOT EXISTS Products (
    prod_id int(10) unsigned NOT NULL AUTO_INCREMENT,
    prod_name varchar(127) DEFAULT NULL,
    prod_img varchar(127) DEFAULT NULL,
    prod_description varchar(511) DEFAULT NULL,
    prod_price decimal(10,2) DEFAULT NULL,
    prod_rating tinyint unsigned DEFAULT NULL,
    prod_sku char(32) DEFAULT NULL,
    prod_stock int(10) unsigned,
    PRIMARY KEY (prod_id)
);

-- Insert into Products table

INSERT INTO Products (
    prod_id,
    prod_name,
    prod_img,
    prod_description,
    prod_price,
    prod_rating,
    prod_sku,
    prod_stock
)
VALUES
    -- 1
    (
        NULL,
        'Country Pork Rinds',
        'CPR.jpg',
        'Take these to the bus station with your good looks.',
        2.99,
        5,
        'cpr1312',
        15
    ),
    -- 2
    (
        NULL,
        'Space Pigeon',
        'SP.jpg',
        'Unauthorized space pigeons',
        5.99,
        0,
        'sp1231',
        99
    ),
    -- 3
    (
        NULL,
        'Banana',
        'BAN.jpg',
        'This is a banana',
        0.99,
        5,
        'ban1234',
        0
    ),
    -- 4
    (
        NULL,
        'Car',
        'CAR.jpg',
        'This is a car',
        599.99,
        4,
        'car9780',
        7
    ),
    -- 5
    (
        NULL,
        'George',
        'GEORGE.jpg',
        'We are legally required to list George as "for sale" but we highly recommend you do not purchase George.',
        9999.99,
        5,
        'george1',
        1
    ),
    -- 6
    (
        NULL,
        '"Peanut Butter"',
        'PB.jpg',
        'This is "Peanut Butter"',
        3.99,
        5,
        'pb4239',
        123134
    );
