diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/7905_characters_character_equipmentsets.sql | 1 | ||||
| -rw-r--r-- | sql/updates/7905_characters_corpse.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7905_characters_group_member.sql | 1 | ||||
| -rw-r--r-- | sql/updates/7905_characters_guild.sql | 7 | ||||
| -rw-r--r-- | sql/updates/7905_characters_petition.sql | 2 |
5 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/7905_characters_character_equipmentsets.sql b/sql/updates/7905_characters_character_equipmentsets.sql new file mode 100644 index 00000000000..1617c61f1ee --- /dev/null +++ b/sql/updates/7905_characters_character_equipmentsets.sql @@ -0,0 +1 @@ +ALTER TABLE `character_equipmentsets` ADD INDEX `Idx_setindex` (`setindex`); diff --git a/sql/updates/7905_characters_corpse.sql b/sql/updates/7905_characters_corpse.sql new file mode 100644 index 00000000000..061c90e9bfc --- /dev/null +++ b/sql/updates/7905_characters_corpse.sql @@ -0,0 +1,2 @@ +ALTER TABLE `corpse` ADD INDEX `Idx_player`(`player`); +ALTER TABLE `corpse` ADD INDEX `Idx_time`(`time`); diff --git a/sql/updates/7905_characters_group_member.sql b/sql/updates/7905_characters_group_member.sql new file mode 100644 index 00000000000..7c7c3eace14 --- /dev/null +++ b/sql/updates/7905_characters_group_member.sql @@ -0,0 +1 @@ +ALTER TABLE `group_member` ADD INDEX `Idx_memberGuid`(`memberGuid`); 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`); diff --git a/sql/updates/7905_characters_petition.sql b/sql/updates/7905_characters_petition.sql new file mode 100644 index 00000000000..07132963b56 --- /dev/null +++ b/sql/updates/7905_characters_petition.sql @@ -0,0 +1,2 @@ +ALTER TABLE `petition_sign` ADD INDEX `Idx_playerguid`(`playerguid`); +ALTER TABLE `petition_sign` ADD INDEX `Idx_ownerguid`(`ownerguid`);
\ No newline at end of file |