CREATE TABLE Products (
  id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  img VARCHAR(127) DEFAULT NULL,
  name 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('Into the Wild', 'wild.jpg', 'Written by LP', 1.99, 4, 1),
('Feb. 28 2016', 'feb.jpg', 'Written by Koe Wetzel', 1.25, 5, 1),
('Broken Window Senerade', 'broken.jpg', 'Written by Whiskey Meyers', 1.49, 5, 1),
('Good Life', 'good-life.jpg', 'Written by Eric Dylan', 0.59, 5, 1),
('Recovery', 'recovery.jpg', 'Written by LP', 0.99, 4, 0)

