diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7974_characters_character_aura.sql | 2 |
2 files changed, 3 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index d07f43cf3a0..4c798262bb2 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -531,7 +531,7 @@ CREATE TABLE `character_aura` ( `maxduration` int(11) NOT NULL default '0', `remaintime` int(11) NOT NULL default '0', `remaincharges` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`spell`,`effect_mask`) + PRIMARY KEY (`guid`,`caster_guid`,`spell`,`effect_mask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; 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` ) |