diff options
| author | pete318 <pete318@hotmail.com> | 2015-10-08 00:14:01 +0200 |
|---|---|---|
| committer | pete318 <pete318@hotmail.com> | 2015-10-08 00:14:01 +0200 |
| commit | 996cbafd20af0e0e1eff99a53d77d5d1869f4a17 (patch) | |
| tree | 611182eb1924b34621818e666a81e32acbb595b6 /sql | |
| parent | 1b0f475e9593560224b9f8db84422ed89145a30d (diff) | |
Add caster guid to pet_aura table.
This prevents duplicate key and transaction completion fail on pet save, if pet has same aura from two different casters present.
This closes (already closed) issue https://github.com/TrinityCore/TrinityCore/issues/10529
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/characters/2015_10_07_00_characters.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/characters/2015_10_07_00_characters.sql b/sql/updates/characters/2015_10_07_00_characters.sql new file mode 100644 index 00000000000..a03fffcd77a --- /dev/null +++ b/sql/updates/characters/2015_10_07_00_characters.sql @@ -0,0 +1,3 @@ +ALTER TABLE `pet_aura` +DROP PRIMARY KEY, +ADD PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`); |