diff options
| author | n0n4m3 <none@none> | 2010-04-14 13:02:05 +0400 |
|---|---|---|
| committer | n0n4m3 <none@none> | 2010-04-14 13:02:05 +0400 |
| commit | 8b6005666dc10ba6acb423c7ad936b8b290fd6ee (patch) | |
| tree | 16ef262dbc4513f34a8cdeb2921b629a8e9f1a7a /sql/updates | |
| parent | e3e5ca62270f010d5dbc2c160db22cbffa6dc94b (diff) | |
Add index for some tables in characters DB. by AlexDereka.
--HG--
branch : trunk
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 |