/* INSIDE hw8.sql file */

/* 1. create the table in the sql file */
CREATE TABLE Products(
    id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(127) DEFAULT NULL,
    img VARCHAR(127) DEFAULT NULL,
    description VARCHAR(255) DEFAULT NULL,
    price DECIMAL(10, 2) DEFAULT NULL,
    rating TINYINT UNSIGNED DEFAULT NULL,
    stock TINYINT UNSIGNED
);

/* 2. insert 5 unique items into the table...? */
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES
("cheese", "cheese.jpeg", "yummy cheese mmm", 1.99, 5, 1),
("eggs", "eggs.jpeg", "get your healthy protein and fats in", 0.99, 4, 1),
("milk", "milk.jpeg", "don't neglect your calcium", 2.99, 2, 1),
("bread", "bread.jpeg", "dinner, just like the old days", 2.99, 3, 1),
("butter", "butter.jpeg", "like cheese, but less tasty", 1.99, 1, 0);



