View Single Post
  #2  
Old 04-10-2004, 02:31 AM
Scorpious2k's Avatar
Scorpious2k
Demi-God
 
Join Date: Mar 2003
Location: USA
Posts: 1,067
Default

Here it is:

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';
__________________
Maybe I should try making one of these servers...
Reply With Quote