From a26b4ff95e5f3100ee9860bc723aced8f4bc749f Mon Sep 17 00:00:00 2001
From: Azazel <azazel.kon@gmail.com>
Date: Thu, 14 Apr 2011 11:31:15 +0600
Subject: Core/SQL: fix a few minor mishaps with wrong keys not being updated
 in commit 5357b1ba77 - fixes import of base characters database (thanks click
 for pointing out). Closes #1231. Also rename indexes in recently cleaned
 tables to have 'idx_' prefix. Add queries to recreate indexes based on
 recently modified columns (just to make sure that all indexes are correct).

---
 sql/updates/auth_char/2011_04_14_00_characters.sql | 29 ++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 sql/updates/auth_char/2011_04_14_00_characters.sql

(limited to 'sql/updates')

diff --git a/sql/updates/auth_char/2011_04_14_00_characters.sql b/sql/updates/auth_char/2011_04_14_00_characters.sql
new file mode 100644
index 00000000000..ab9bd93419d
--- /dev/null
+++ b/sql/updates/auth_char/2011_04_14_00_characters.sql
@@ -0,0 +1,29 @@
+ALTER TABLE corpse
+    DROP PRIMARY KEY,
+    DROP KEY `idx_type`,
+    DROP KEY `instance`,
+    DROP KEY `Idx_player`,
+    DROP KEY `Idx_time`;
+
+ALTER TABLE corpse
+    ADD PRIMARY KEY (`corpseGuid`),
+    ADD KEY `idx_type`(`corpseType`),
+    ADD KEY `idx_instance`(`instanceId`),
+    ADD KEY `idx_player`(`guid`),
+    ADD KEY `idx_time`(`time`);
+
+ALTER TABLE creature_respawn
+    DROP PRIMARY KEY,
+    DROP KEY `instance`;
+
+ALTER TABLE creature_respawn
+    ADD PRIMARY KEY (`guid`, `instanceId`),
+    ADD KEY `idx_instance`(`instanceId`);
+
+ALTER TABLE gameobject_respawn
+    DROP PRIMARY KEY,
+    DROP KEY `instance`;
+
+ALTER TABLE gameobject_respawn
+    ADD PRIMARY KEY (`guid`, `instanceId`),
+    ADD KEY `idx_instance`(`instanceId`);
-- 
cgit v1.2.3