From c61ef6c73c1e69162acc97eb8539af284cf5c937 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Wed, 27 May 2009 23:24:22 -0500
Subject: [7902] Speed up Creature and GO loads. Author: AlexDereka

--HG--
branch : trunk
---
 sql/updates/7902_01_mangos_pool_creature.sql   | 4 ++++
 sql/updates/7902_02_mangos_pool_gameobject.sql | 4 ++++
 2 files changed, 8 insertions(+)
 create mode 100644 sql/updates/7902_01_mangos_pool_creature.sql
 create mode 100644 sql/updates/7902_02_mangos_pool_gameobject.sql

(limited to 'sql/updates')

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
-- 
cgit v1.2.3