

CREATE TABLE products (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    img VARCHAR(127) DEFAULT NULL,
    description VARCHAR(255) DEFAULT NULL, 
    price VARCHAR(255) NOT NULL,
    rating INT(11) UNSIGNED DEFAULT NULL,
    stock TINYINT UNSIGNED
);


INSERT INTO products(name, img, description, price, rating, stock) VALUES('Cherry Toaster Strudels', 'https://www.cs.csubak.edu/~cwomack/3680_S21/Project%202/images/product-1.jpg', 'The best snack on the planet.', 75.99, 5, 0), ('The Mystical Adventures of Billy Owens', 'https://www.cs.csubak.edu/~cwomack/3680_S21/Project%202/images/product-2.jpg', 'Sit down with your friends and family to enjoy a blockbuster hit of the century!', 0.99, 4, 1), ('AS SEEN ON TV SHAKEWEIGHT', 'https://www.cs.csubak.edu/~cwomack/3680_S21/Project%202/images/product-3.jpg', 'Get fit and have fun doing it with ShakeWeight!', 24.99, 2, 0), ('Super Cool Epic Awesome Ninja Fidget Spinner Action Toy ADHD Fidget Helper Made in Japan in America(TM)', 'https://www.cs.csubak.edu/~cwomack/3680_S21/Project%202/images/product-4.jpg', 'Spin this toy all day or do not, we do not care. :) ', 44.99, 1, 1), ('Jake the Dog Plushie Toy', 'https://www.cs.csubak.edu/~cwomack/3680_S21/Project%202/images/product-5.jpg', 'Just like the real(fake) Jake the Dog from hit TV Show Adventure Time', 999.9, 5, 0);

