DROP TABLE IF EXISTS `raw_spells`;
CREATE TABLE `raw_spells` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `aa_spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `tier` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(128) DEFAULT '',
  `description` VARCHAR(512) DEFAULT '',
  `icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `icon2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `icontype` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `class_skill` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `mastery_skill` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `min_class_skill_req` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
  `spell_text_color` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `friendly_spell` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `display_spell_tier` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `duration_flag` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `target` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `group_spell` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `spell_visual` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `success_message` VARCHAR(512) DEFAULT NULL,
  `effect_message` VARCHAR(512) DEFAULT NULL,
  `unknown1` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `can_effect_raid` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `affect_only_group_members` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `aa_unknown` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `aa_unknown2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `uses_remaining` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `damage_remaining` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unknown3` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `unknown4` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `log_file` VARCHAR(255) DEFAULT NULL,
  `data_version` SMALLINT(5) UNSIGNED NOT NULL,
  `processed` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `SpellLanguageTypeIDX` (`spell_id`,`tier`)
) ENGINE=MYISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
