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).

1 files changed, 29 insertions, 0 deletions

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`);