9
3

raw_spell_visuals.sql 663 B

123456789101112131415
  1. DROP TABLE IF EXISTS `raw_spell_visuals`;
  2. CREATE TABLE `raw_spell_visuals` (
  3. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  5. `num_targets` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  6. `spell_visual1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  7. `spell_visual2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  8. `cast_time` FLOAT NOT NULL DEFAULT '0',
  9. `spell_level` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  10. `spell_tier` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  11. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  12. `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  13. PRIMARY KEY (`id`)
  14. ) ENGINE=MYISAM;