CREATE TABLE ProductsLab11 (
    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 ProductsLab11 ( 
    prod_id,
    prod_name,
    prod_img,    
    prod_description,
    prod_price,
    prod_rating, 
    prod_sku,    
    prod_stock  
)

VALUES (
    1,
    'Secret Item',
    'download.jpeg',
    'This sis the first item, which is unknown and a super secret',
    5.99,
    4,
    'wefe1312',
    4
),

(
    2,
    'Doggy toy',
    'download.jpeg',
    'Chew toy, but only for dogs with the name kkingkkanga',
    99.99,
    5,
    'pup1234',
    2
),
(
    3,
    'minion blanky',
    'Egg.jpg',
    'Soft plushe blanket meant to carry around by children with bright blue and yellow colors',
    19.99,
    3,
    'min1234',
    0
),
(
    4,
    'snack',
    'shoes.jpg',
    'Snack box used to eat to help with exam stress. Stress eating as its finest',
    10.00,
    3,
    'snac1234',
    10
),
(
    5,
    'blue heels',
    'HEART.jpg',
    'heels to be worn by all ',
    49.99,
    4,
    'heel1234',
    2
);
