EQEmulator Forums - View Single Post

einsteinrs · #10 11-07-2004, 05:52 AM

try this

Code:

CREATE TABLE merchantlist_temp (
  npcid int(10) unsigned NOT NULL default '0',
  slot tinyint(3) unsigned NOT NULL default '0',
  itemid int(10) unsigned NOT NULL default '0',
  charges int(10) unsigned NOT NULL default '1',
  UNIQUE KEY merchantid (npcid,slot)
) TYPE=MyISAM;