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('Product 1', 'product1.jpg', 'This is product 1', 1.99, 5, 0);
*/


INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Good Kid, M.a.a.d City', 'imgs/gkmc.jpg', 'Kendrick Lamars album about influences from his hometown. (Released 2012)', 17.99, 5, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('2014 Forest Hills Drive', 'imgs/2014.jpg', 'J. Coles album about his transition from North Carolina to New York for his success. (Released 2014)', 21.47, 5, 0);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Swimming', 'swimming.jpg', 'Mac Millers intention of this album was to inspire self-love, healing and psychological growth. (Released 2018)', 29.98, 4, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('?', 'question.jpg', 'XXXTentacion album ? was released along with Bad Vibes Forever and Skins (Released 2018)', 34.27, 4, 0);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Flower Boy', 'fb.jpg', 'Compared to previous albums, Tyler, the creator wanted to make an album about his feelings. (Released 2017)', 23.26, 4, 1);
   