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('Pack of Papers', 'product1.jpg', 'This is product 1: Stack of papers', 4.99, 5, 0);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Mechnical Pencils', 'product2.jpg', 'This is product 2: Mechanical pencils', 1.99, 3, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Eraser', 'product3.jpg', 'This is product 3: Eraser', 0.99, 4.1, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Pack of notebooks', 'product4.jpg', 'This is product 4: Notebooks', 3.49 , 2.3, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Laptop', 'product4.jpg', 'This is product 5', 699, 4.4, 0);