CREATE TEMPORARY TABLE ib_items (
ITEMID int(10) NOT NULL,
CAT int(2) NOT NULL default "0",
NAME varchar(250) NOT NULL default "0",
COST int(10) NOT NULL default "0",
STOCK int(5) NOT NULL default "0",
SOLD int(11) NOT NULL default "0",
DAMAGE int(10) NOT NULL default "0",
LVLREQ int(20) NOT NULL default "0",
DESCR varchar(200) NOT NULL default "0",
ICON varchar(200) NOT NULL default "0",
ARMOR int(10) NOT NULL default "0",
IHP int(5) NOT NULL default "0",
IMP int(5) NOT NULL default "0",
WCL varchar(150) NOT NULL default "0",
PRIMARY KEY (ITEMID)
) TYPE=MyISAM;