9
3

raw_spells_aa.sql 957 B

123456789101112131415161718
  1. DROP TABLE IF EXISTS `raw_spells_aa`;
  2. CREATE TABLE `raw_spells_aa` (
  3. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `aa_spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  5. `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  6. `tier` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  7. `unknown` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  8. `icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  9. `icon2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  10. `current_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  11. `max_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  12. `rank_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  13. `unknown2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  14. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  15. `log_file` VARCHAR(255) DEFAULT '',
  16. PRIMARY KEY (`id`),
  17. UNIQUE KEY `NewIndex1` (`aa_spell_id`,`language_type`)
  18. ) ENGINE=MYISAM CHECKSUM=1 AUTO_INCREMENT=1 COMMENT='' DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC CHARSET=latin1 COLLATE=latin1_swedish_ci;