diff options
| author | megamage <none@none> | 2009-05-27 23:24:22 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2009-05-27 23:24:22 -0500 |
| commit | c61ef6c73c1e69162acc97eb8539af284cf5c937 (patch) | |
| tree | 681fc587a0c1f5ad0da38ca13727e0954c004dc6 /sql/updates | |
| parent | 626630a1b0593094ccfabf10854374da55bc7fbf (diff) | |
[7902] Speed up Creature and GO loads. Author: AlexDereka
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/7902_01_mangos_pool_creature.sql | 4 | ||||
| -rw-r--r-- | sql/updates/7902_02_mangos_pool_gameobject.sql | 4 |
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/7902_01_mangos_pool_creature.sql b/sql/updates/7902_01_mangos_pool_creature.sql new file mode 100644 index 00000000000..309ca5e38fb --- /dev/null +++ b/sql/updates/7902_01_mangos_pool_creature.sql @@ -0,0 +1,4 @@ +ALTER TABLE db_version CHANGE COLUMN required_7896_01_mangos_creature_template required_7902_01_mangos_pool_creature bit; + +ALTER TABLE `pool_creature` + ADD INDEX `idx_guid`(`guid`);
\ No newline at end of file diff --git a/sql/updates/7902_02_mangos_pool_gameobject.sql b/sql/updates/7902_02_mangos_pool_gameobject.sql new file mode 100644 index 00000000000..46524337ab7 --- /dev/null +++ b/sql/updates/7902_02_mangos_pool_gameobject.sql @@ -0,0 +1,4 @@ +ALTER TABLE db_version CHANGE COLUMN required_7902_01_mangos_pool_creature required_7902_02_mangos_pool_gameobject bit; + +ALTER TABLE `pool_gameobject` + ADD INDEX `idx_guid`(`guid`);
\ No newline at end of file |