Add index for some tables in characters DB. by AlexDereka.

--HG--
branch : trunk

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/7905_characters_guild.sql b/sql/updates/7905_characters_guild.sql
new file mode 100644
index 00000000000..451df6671db
--- /dev/null
+++ b/sql/updates/7905_characters_guild.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `guild_eventlog`      ADD INDEX `Idx_PlayerGuid1`(`PlayerGuid1`);
+ALTER TABLE `guild_eventlog`      ADD INDEX `Idx_PlayerGuid2`(`PlayerGuid2`);
+ALTER TABLE `guild_eventlog`      ADD INDEX `Idx_LogGuid`(`LogGuid`);
+ALTER TABLE `guild_bank_eventlog` ADD INDEX `Idx_PlayerGuid`(`PlayerGuid`);
+ALTER TABLE `guild_bank_eventlog` ADD INDEX `Idx_LogGuid`(`LogGuid`);
+ALTER TABLE `guild_bank_item`     ADD INDEX `Idx_item_guid`(`item_guid`);
+ALTER TABLE `guild_rank`          ADD INDEX `Idx_rid`(`rid`);