CREATE TABLE Products (
	prod_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	prod_name varchar(127) DEFAULT NULL,
	prod_img varchar(127) DEFAULT NULL,
	prod_description varchar(511) DEFAULT NULL,
	prod_price decimal(10,2) DEFAULT NULL,
	prod_rating tinyint unsigned DEFAULT NULL,
	prod_sku char(32) DEFAULT NULL,
	prod_stock int(10) unsigned,
	PRIMARY KEY (prod_id)
);

CREATE TABLE Users (
	user_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	user_uname varchar(127) DEFAULT NULL,
	user_fname varchar(127) DEFAULT NULL,
	user_email varchar(127) DEFAULT NULL,
	user_password varchar(127) DEFAULT NULL,
	PRIMARY KEY (user_id)
);


