diff options
| author | Shauren <shauren.trinity@gmail.com> | 2013-05-13 05:55:43 -0700 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2013-05-13 05:55:43 -0700 |
| commit | e5928e13d705e6bb50571742f6c967c559f983ee (patch) | |
| tree | a4e97fb899b17a9a24ddb2b4b6f619a3b8f10e84 /sql | |
| parent | 16074667c074131476adb6166918d4a9ee450d4d (diff) | |
| parent | 78195b3c54a32866f96efb02457fe8161460b692 (diff) | |
Merge pull request #9790 from vlad852/master
spell_target_position - allow use effectIndex
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_05_13_00_world_spell_target_position.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2013_05_13_00_world_spell_target_position.sql b/sql/updates/world/2013_05_13_00_world_spell_target_position.sql new file mode 100644 index 00000000000..c4ef5521094 --- /dev/null +++ b/sql/updates/world/2013_05_13_00_world_spell_target_position.sql @@ -0,0 +1,5 @@ +ALTER TABLE `spell_target_position` ADD COLUMN `effIndex` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `id`; +ALTER TABLE `spell_target_position` DROP INDEX `PRIMARY`, ADD PRIMARY KEY (`id`, `effIndex`); + +UPDATE `spell_target_position` SET `effIndex`='1' WHERE `id` IN (53821, 68081, 46473, 73655, 72546, 72340, 67838, 67835, 67836, 67837, 67834, 49098, 49097, 54963, 11012, 8606); +UPDATE `spell_target_position` SET `effIndex`='2' WHERE `id` IN (36801, 71765, 71763, 71762, 71744, 71712, 71751, 43209, 51852); |