CREATE TABLE foods (
    prod_id int(10) unsigned NOT NULL AUTO_INCREMENT,
    prod_name varchar(127) DEFAULT NULL,
    prod_img varchar(127) DEFAULT NULL,
    prod_price decimal(10,2) DEFAULT NULL,
    prod_rating tinyint unsigned DEFAULT NULL,
    prod_stock int(10) unsigned,
    PRIMARY KEY (prod_id)
);
