use jstaggs

CREATE TABLE Products(
    prod_id INT UNSIGNED NOT NULL PRIMARY KEY 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
);


insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'French Dip','fd.jpg','A beef sandwich, served with a side of Au jus.',11.99,5,'AAAAA',4
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Fish and Chips','fc.jpg','Cod with a side of french fries.',10.99,4,'BBBBB',9
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Bangers and Mash','bm.jpg','Sausage served with gravy and mashed potatoes.',12.99,5,'CCCCC',3
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Shephard\'s Pie','sp.jpg','Beef and cornbread pie.',10.99,4,'DDDDD',1
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Reuben','rb.jpg','A corned beef and sauerkraut sandwich',11.99,3,'EEEEE',0
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Corned Beef and Cabbbage','cb.jpg','Corned beef served with cabbage.',13.99,2,'FFFFF',6
);
