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(8) unsigned,
);

INSERT INTO Products(name, img, description, price, rating, stock)
values(
    ('Game Boy Color', './images/gameboycolorpurple.jpeg', 'A built-in console featuring up to 16 colors of each of the four layers', 49.99, 3, 0),
     ('Game Boy Advance', './images/gameboyadvance.jpeg', 'A 32-bit system developed and manufactured by nintendo the successor to the GAme Boy Color and plays Game boy color games.', 69.99, 1, 1),
     ('Game Boy Advance SP', './images/gameboyadvancesp.jpeg', 'A handheld video game system developed by Nintendo which is the final game boy system released. It plays any game boy games and TV cartoon episodes with Gameboy Advance Video.', 89.99, 3, 1),
     ('Game Boy Micro', './images/gameboymicro.jpeg', 'A handheld game console developed by nintendo which is a smaller redesign of the Game Boy Advance which is the last console of the Game Boy system with the Game Boy Advance SP. It only plays any Game Boy Advance games or watch episodes with Gameboy Advance Video.', 129.99, 7, 1),
     ('Nintendo DS', './images/nintendods.jpeg', 'The handheld game console released by nintendo. The DS is an acronym for Dual-Screan where one screen at the bottom is a touch screen and the otehr on top is display screen. The Nintendo DS features other DS consoles to connect to an existing wireless network within a short range to interact online using a Nintendo Wi-Fi Connection service.', 149.99, 4, 1)

);
