diff options
| author | Shocker <none@none> | 2010-09-06 01:38:50 +0300 |
|---|---|---|
| committer | Shocker <none@none> | 2010-09-06 01:38:50 +0300 |
| commit | e6450df9c4bdd0e1b2133a455930f02c9faa0fbc (patch) | |
| tree | 70d6334486cddadbe0a07bea5517cc7bdb8fbdaa /sql/updates | |
| parent | 5e95be0c33d25bb9832d20e724f7c7279d1e82ca (diff) | |
DB-Schema/Characters: Add indexes for some columns used in JOINs in the core
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/9792_characters_groups.sql | 1 | ||||
| -rw-r--r-- | sql/updates/9792_characters_instance.sql | 1 | ||||
| -rw-r--r-- | sql/updates/9792_characters_instance_reset.sql | 1 |
3 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/9792_characters_groups.sql b/sql/updates/9792_characters_groups.sql new file mode 100644 index 00000000000..940875d217a --- /dev/null +++ b/sql/updates/9792_characters_groups.sql @@ -0,0 +1 @@ +ALTER TABLE `groups` ADD INDEX ( `leaderGuid` ); diff --git a/sql/updates/9792_characters_instance.sql b/sql/updates/9792_characters_instance.sql new file mode 100644 index 00000000000..0571b1c8953 --- /dev/null +++ b/sql/updates/9792_characters_instance.sql @@ -0,0 +1 @@ +ALTER TABLE `instance` ADD INDEX ( `difficulty` ); diff --git a/sql/updates/9792_characters_instance_reset.sql b/sql/updates/9792_characters_instance_reset.sql new file mode 100644 index 00000000000..f5d21b33951 --- /dev/null +++ b/sql/updates/9792_characters_instance_reset.sql @@ -0,0 +1 @@ +ALTER TABLE `instance_reset` ADD INDEX ( `difficulty` ); |