CREATE TABLE IF NOT EXISTS 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
("Milk", "https://i5.walmartimages.com/asr/6004346c-d7e2-4fd2-8cec-e0a00cea741c_1.f7377db640035383d22d17a96cc54402.jpeg?odnHeight=200&odnWidth=200&odnBg=ffffff", "A gallon of 2% milk.", 3.19, 4, 1),

("Pretzels", "https://i5.walmartimages.com/asr/ed2332de-9a18-4ffa-8721-54f74071ed52_1.66eb06234341220ce87321a9acf41603.jpeg?odnHeight=200&odnWidth=200&odnBg=ffffff", "A 16oz bag of Rold Gold Pretzels", 2.98, 3, 0),

("Cheez-Its", "https://i5.walmartimages.com/asr/0c7c5db4-eca3-49f1-8e4f-3e756656100a_1.1aa1e503e46c9c47b9b84ef6446b631b.jpeg?odnHeight=200&odnWidth=200&odnBg=ffffff", "A 21oz box of Cheez-Its", 4.54, 5, 1),

("Cool Ranch Doritos", "https://i5.walmartimages.com/asr/76507964-f892-4219-a379-0e523d5e5ae9_1.58e1847f458cd80be3fa84d829029426.jpeg?odnHeight=200&odnWidth=200&odnBg=ffffff", "A Party Sized 15oz bag of Cool Ranch Doritos", 3.48, 5, 0),

("Honey Nut Cheerios", "https://i5.walmartimages.com/asr/49cd2bf8-d861-4c38-840e-dddd26eb34f0_1.37dfe8a1f1ce46dc54fab0c48c30f4a8.jpeg?odnHeight=200&odnWidth=200&odnBg=ffffff", "A Family Sized 19.5oz box of Honey Nut Cheerios", 3.64, 4, 1);
