CREATE TABLE IF NOT EXISTS 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
('Ps4', 'images/ps4.jpg', 'Newest gaming device by Sony', 299.99, 4, 1),
('Xbox1', 'images/xbox1.jpg', 'Newest gaming device by Microsoft', 249.99, 4, 0),
('Nintendo Switch', 'images/nintendoSwitch.jpg', 'Newest gaming device by Nintendo', 299.99, 2, 1),
('Airpods', 'images/airPods.jpg', 'Wireless Bluetooth earphones by Apple', 159.99, 3, 0),
('iPhone11', 'images/iPhone11.jpg', 'Newest iPhone by Apple', 699.99, 4, 1);