

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', 1.99, 5, 0), ('Product 2', 'product2.jpg', 'This is product 2', 1.99, 5, 0), ('Product 3', 'product3.jpg', 'This is product 3', 1.99, 5, 0), ('Product 4', 'product4.jpg', 'This is product 4', 1.99, 5, 0), ('Product 5', 'product5.jpg', 'This is product 5', 1.99, 5, 0) ;
