1 files changed, 6 insertions, 6 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 3ac49e0b8b3..29fa888ed78 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1212,11 +1212,11 @@ CREATE TABLE `corpse` (
   `time` int(10) unsigned NOT NULL DEFAULT '0',
   `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
-  PRIMARY KEY (`guid`),
+  PRIMARY KEY (`corpseGuid`),
   KEY `idx_type` (`corpseType`),
-  KEY `instance` (`instanceId`),
-  KEY `Idx_player` (`player`),
-  KEY `Idx_time` (`time`)
+  KEY `idx_instance` (`instanceId`),
+  KEY `idx_player` (`guid`),
+  KEY `idx_time` (`time`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -1241,7 +1241,7 @@ CREATE TABLE `creature_respawn` (
   `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
   `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
   PRIMARY KEY (`guid`,`instanceId`),
-  KEY `instance` (`instanceId`)
+  KEY `idx_instance` (`instanceId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -1314,7 +1314,7 @@ CREATE TABLE `gameobject_respawn` (
   `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
   `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
   PRIMARY KEY (`guid`,`instanceId`),
-  KEY `instance` (`instanceId`)
+  KEY `idx_instance` (`instanceId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
 /*!40101 SET character_set_client = @saved_cs_client */;