View Single Post
  #7  
Old 04-13-2004, 12:08 PM
KhaN's Avatar
KhaN
Dragon
 
Join Date: Mar 2004
Location: France, Bordeaux.
Posts: 677
Default

Code:
DROP TABLE IF EXISTS quest_globals; 
CREATE TABLE quest_globals ( 
  id int(11) NOT NULL auto_increment, 
  charid int(11) NOT NULL default 0, 
  npcid int(11) NOT NULL default 0, 
  zoneid int(11) NOT NULL default 0, 
  name varchar(65) NOT NULL, 
  value varchar(65) NOT NULL default "?", 
  expdate int(11) NOT NULL default 0, 
  PRIMARY KEY  (id), 
  UNIQUE KEY qname (name,charid,npcid,zoneid) 
) TYPE=MyISAM; 

alter table npc_types add qglobal int(2) unsigned default '0';
Or topic found 6 posts under this one called "EQ Quest Global.sql ?" :P
__________________

Reply With Quote