9
3

raw_spells2.sql 468 B

12345
  1. ALTER TABLE `raw_spell_effects` ADD `index` TINYINT UNSIGNED DEFAULT '0' NOT NULL AFTER `tier`;
  2. ALTER TABLE `raw_spell_effects` DROP PRIMARY KEY, ADD PRIMARY KEY (`spell_id`, `tier`, `index`);
  3. ALTER TABLE `raw_spells` ADD `spell_visual` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `group_spell`;
  4. ALTER TABLE `raw_spells` ADD `success_message` VARCHAR(512) NULL AFTER `spell_visual`;
  5. ALTER TABLE `raw_spells` ADD `effect_message` VARCHAR(512) NULL AFTER `success_message`;