Thread: 983 SQL fix!
View Single Post
  #2  
Old 02-16-2007, 02:34 AM
WildcardX
Developer
 
Join Date: Apr 2003
Posts: 589
Default

Did you source in this sql from the "aa_data.sql" file?

Code:
DROP TABLE IF EXISTS altadv_vars;
CREATE TABLE altadv_vars (
  skill_id int(11) NOT NULL default '0',
  name varchar(128) default NULL,
  cost int(11) default NULL,
  max_level int(11) default NULL,
  hotkey_sid int(10) unsigned NOT NULL default '0',
  hotkey_sid2 int(10) unsigned NOT NULL default '0',
  title_sid int(10) unsigned NOT NULL default '0',
  desc_sid int(10) unsigned NOT NULL default '0',
  type tinyint(3) unsigned NOT NULL default '1',
  spellid int(10) unsigned NOT NULL default '0',
  prereq_skill int(10) unsigned NOT NULL default '0',
  prereq_minpoints int(10) unsigned NOT NULL default '0',
  spell_type int(10) unsigned NOT NULL default '0',
  spell_refresh int(10) unsigned NOT NULL default '0',
  classes int(10) unsigned NOT NULL default '65534',
  berserker int(10) unsigned NOT NULL default '0',
  class_type int(10) unsigned NOT NULL default '0',
  cost_inc int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (skill_id)
) TYPE=MyISAM;
__________________
Read my developer notes at my blog.

Quote:
If it's not on IRC, it ain't l33t!

Last edited by WildcardX; 02-16-2007 at 10:36 AM..
Reply With Quote