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('Boat', 'images/boat.png', 'Needs water', 1.99, 5, 0);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Car', 'images/car.png', 'Needs roads', 0.01, 3, 1);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Motorcycle', 'images/motorcycle.png', 'Still needs roads', 42.39, 5, 0);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('plane', 'images/plane.png', 'Needs air', 99.99, 1, 1);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Wheelchair', 'images/wheelchair.png', 'NEED FOR SPEED', 10.00, 4, 1);
