PDA

View Full Version : Missing the quest table? No problem!!!


Shawn319
12-16-2002, 06:28 PM
Since versions 0.3.1.3 and 0.4.0/0.4.0.1, the quest table has been taken out (I guess cause its not needed anymore). eqadmin still want this table and will give u errors if you have have it.

If you're getting errors in eqadmin, here's the table.

1. you can copy/paste this to a txt file and source it in, or
2. you can download the attachment to your mysql/bin folder and then source it in.


--
-- Table structure for table 'quest'
--

CREATE TABLE quest (
id int(11) NOT NULL auto_increment,
zone varchar(16) NOT NULL default '',
name varchar(32) NOT NULL default '',
activator varchar(64) NOT NULL default '',
text varchar(255) NOT NULL default '',
end varchar(64) NOT NULL default '',
npcID int(11) NOT NULL default '0',
questobject int(11) unsigned NOT NULL default '0',
priceobject int(11) unsigned NOT NULL default '0',
cash int(11) unsigned NOT NULL default '0',
exp int(11) unsigned NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY name (name)
) TYPE=MyISAM;