EQ2EMu/EQ2/devtools/PacketParser/sql_updates/eq2_rawdata_aa_tables.sql

CREATE TABLE `raw_aa_class` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `unknown6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `unknown7` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `unknown10` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(250) DEFAULT NULL,
  `description` VARCHAR(250) DEFAULT NULL,
  `icon` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `icon2` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `current_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `max_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `rank_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `unknown11` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `class_name` VARCHAR(50) DEFAULT NULL,
  `points_req` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `subclass_name` VARCHAR(50) DEFAULT NULL,
  `icon_col` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `icon_row` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `line_title` VARCHAR(50) DEFAULT NULL,
  `unknown20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `SpellIDX` (`spell_id`)
) ENGINE=MYISAM;


CREATE TABLE `raw_aa_subclass` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `unknown6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `unknown7` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `unknown10` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(250) DEFAULT NULL,
  `description` VARCHAR(250) DEFAULT NULL,
  `icon` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `icon2` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `current_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `max_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `rank_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `unknown11` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `class_name` VARCHAR(50) DEFAULT NULL,
  `points_req` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `subclass_name` VARCHAR(50) DEFAULT NULL,
  `icon_col` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `icon_row` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `line_title` VARCHAR(50) DEFAULT NULL,
  `unknown20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `SpellIDX` (`spell_id`)
) ENGINE=MYISAM;


CREATE TABLE `raw_aa_tso` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `unknown6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `unknown7` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `unknown10` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(250) DEFAULT NULL,
  `description` VARCHAR(250) DEFAULT NULL,
  `icon` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `icon2` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `current_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `max_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `rank_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `unknown11` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `class_name` VARCHAR(50) DEFAULT NULL,
  `points_req` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `subclass_name` VARCHAR(50) DEFAULT NULL,
  `icon_col` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `icon_row` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `line_title` VARCHAR(50) DEFAULT NULL,
  `unknown20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `SpellIDX` (`spell_id`)
) ENGINE=MYISAM;