CREATE TABLE inventory(
	itemid		VARCHAR(8) PRIMARY KEY,
	itemname	VARCHAR(30) NOT NULL,
	itemdesc	TEXT NOT NULL,
	itemprice	VARCHAR(10) NOT NULL,
	itemweight	VARCHAR(5) NOT NULL,
	imgtype		VARCHAR(4) NOT NULL);
