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
);

CREATE TABLE IF NOT EXISTS Users (  
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fname VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL
);