raw_spell_visuals_fix.sql 286 B

1234
  1. -- changes to spell_visuals
  2. ALTER TABLE `raw_spell_visuals` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  3. ALTER TABLE `raw_spell_visuals` DROP KEY `id_2`;
  4. ALTER TABLE `raw_spell_visuals` DROP KEY `id`, ADD UNIQUE `VisIDX` (`spell_id`, `spell_visual1`, `spell_visual2`);