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
('Original Gameboy', 'Game-Boy-FL.jpg', 'This is an original Gameboy', 24.99, 3, 1);

INSERT INTO Products (name, img, description, price, rating, stock) VALUES
('Raspberry pi 4', 'raspberrypi4.jpg', 'A credit card sized computer', 40.99, 4, 0);

INSERT INTO Products (name, img, description, price, rating, stock) VALUES
('Gaming keyboard', 'gamingKeyboard.jpg', 'A high quality gaming keyboard', 130.99, 5, 1);

INSERT INTO Products (name, img, description, price, rating, stock) VALUES
('mini keyboard', 'miniKeyboard.jpg', 'an ergonamic keyboard', 29.99, 2, 0);

INSERT INTO Products (name, img, description, price, rating, stock) VALUES
('Gameshell', 'gameShell.jpg', 'A modern handheld designed for retro titles', 130.99, 4, 1);
