
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
);

CREATE TABLE Users (  
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fname VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL
);

INSERT INTO Products(name, img, description, price, rating, stock) VALUES (
"Bush's", "./images/bush-bean.png", "Not as good as Campbells", 14000.30, 1, 1
);

INSERT INTO Products(name, img, description, price, rating, stock) VALUES (
"Campbell's", "./images/campbell-beans.png", "Not as good as Bush's", 322.30, 2, 1
);

INSERT INTO Products(name, img, description, price, rating, stock) VALUES (
"Heinz", "./images/cool-beans.png", "Wish these beans weren't cold", 50000, 3, 1
);

INSERT INTO Products(name, img, description, price, rating, stock) VALUES (
"Dr. Pepper", "./images/dr-pepper-beans.png", "DO not an MD", 2.33, 5, 1
);

INSERT INTO Products(name, img, description, price, rating, stock) VALUES (
"Meijer", "./images/meijer-beans.png", "Wish they had more sodium :(", 1000, 5, 0
);

