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

);

-- Check! 

INSERT INTO Products (name, img, description, price, rating, stock ) VALUES
('Product 1', 'product_1.jpg', "This is product 1", 1.99, 5, 1 ),
('Product 2', 'product_2.jpg', "This is product 2", 2.99, 4, 1 ),
('Product 3', 'product_3.jpg', "This is product 3", 3.99, 3, 1 ),
('Product 4', 'product_4.jpg', "This is product 4", 4.99, 2, 1 ),
('Product 5', 'product_5.jpg', "This is product 5", 5.99, 1, 0 );

-- Check ! 

