DROP TABLE Products;
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);

    INSERT INTO Products(name,img,description,price,rating,stock) VALUES('Eternity','../hw3/Images/eternity.webp','Was going to scalp on the AH, but then I got lost in its enclosed universe, send help.',100.00,5,1);
    INSERT INTO Products(name,img,description,price,rating,stock) VALUES('Chimera Claw','../hw3/Images/Cclaw.png','Has the power to obliterate planets, smells a bit like fish though.',56.00,3,1);
    INSERT INTO Products(name,img,description,price,rating,stock) VALUES('Vorpal Blade','../hw3/Images/Vorpal.png','Haha, swishy sword go vworp and cut off head.',80.00,5,0);
    INSERT INTO Products(name,img,description,price,rating,stock) VALUES('Novelty Chocolate Coin','../hw3/Images/novelty.png','Increases happiness by 2, but is not actually gold, so incurs a -1000 penalty in small children.',2.00,0,1);
    INSERT INTO Products(name,img,description,price,rating,stock) VALUES('Breakfast Cat','../hw3/Images/bcat.jpg','Continental Breakfast Cat.  Comes with assorted breakfast items.  Has fast scratching action.  Kibble not included.',70.00,2,1);