aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorclick <none@none>2010-04-21 20:34:04 +0200
committerclick <none@none>2010-04-21 20:34:04 +0200
commit123d40dcfec7183b8c26e671f9d05987fced7cfb (patch)
tree452943fd04330594a0b97c88e7140d2d83b6e934 /sql/updates
parentaaf3a62395cf38074ffa648fe47bc5a9ae78a61f (diff)
* Add some more transactioncontrol to pet database handling + adjust character_aura keys to avoid duplicates
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7974_characters_character_aura.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/7974_characters_character_aura.sql b/sql/updates/7974_characters_character_aura.sql
new file mode 100644
index 00000000000..636b1cc204f
--- /dev/null
+++ b/sql/updates/7974_characters_character_aura.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `character_aura` DROP PRIMARY KEY ,
+ADD PRIMARY KEY ( `guid` , `caster_guid` , `spell`, `effect_mask` )