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('Product 1', 'product1.jpg', 'This is product 1', 24.99, 2, 0);

    INSERT INTO Products(name, img, description, price, rating, stock)
    VALUES('Product 2', 'product2.jpg', 'This is product 2', 10.99, 5, 0);

    INSERT INTO Products(name, img, description, price, rating, stock)
    VALUES('Product 3', 'product3.jpg', 'This is product 3', 12.99, 4, 0);

    INSERT INTO Products(name, img, description, price, rating, stock)
    VALUES('Product 4', 'product4.jpg', 'This is product 4', 9.99, 4, 0);

    INSERT INTO Products(name, img, description, price, rating, stock)
    VALUES('Product 5', 'Fifthproduct5.jpg', 'This is product 5', 3.99, 5, 0);

    sd.jpg
    /pics/

*/


    