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('Bicycle Premium', 'bike_prem.jpg', 'Bycle brand premium playing cards, green, bridge size, cardstock', 4.83, 2, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Brybelly Wide', 'brybelly.jpg', 'Brybelly 12-pack, 6 red 6 blue, poker size, cardstock', 10.22, 3, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Copag Poker', 'copag.jpg', 'Copag 2 deck set, black and gold, poker size, 100% plastic', 16.95, 4, 0);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Royal Bridge', 'royal.jpg', 'Royal 2 deck set, red and blue, bridge size, 100% plastic', 10.99, 5, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Teskyer Poker', 'teskyer.jpg', 'Teskyer 2 deck set, red and blue, poker size, cardstock', 6.99, 1, 1);