diff options
| author | funjoker <torti-esser@web.de> | 2017-11-05 18:23:27 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-11-05 18:23:27 +0100 |
| commit | 6b1f8f3358a3ba32ea02ab4771e8f2fa3962b982 (patch) | |
| tree | 09fc9c45b976f5c2e867144b67f6a85941143963 /sql | |
| parent | 5f3434387eb5ff98ca9abbf9e5a309f0641e8e77 (diff) | |
Core/Entities: Added DB-support for conversation actorGuids (#20757)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_11_05_10_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_11_05_10_world.sql b/sql/updates/world/master/2017_11_05_10_world.sql new file mode 100644 index 00000000000..e22fb5d56cf --- /dev/null +++ b/sql/updates/world/master/2017_11_05_10_world.sql @@ -0,0 +1,5 @@ +ALTER TABLE `conversation_actors` + CHANGE COLUMN `ConversationActorId` `ConversationActorId` INT(10) UNSIGNED NOT NULL DEFAULT '0', + ADD COLUMN `ConversationActorGuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `ConversationActorId`, + DROP PRIMARY KEY, + ADD PRIMARY KEY (`ConversationId`, `Idx`); |