From 5357b1ba7773801bff66c3bbffe3d2b7c73847ad Mon Sep 17 00:00:00 2001 From: Azazel Date: Mon, 11 Apr 2011 14:39:00 +0600 Subject: Core/CharDB Cleanup: alter `corpse` table making column names lowerCamel and move all queries to prepared statements. NOTICE: column can be named `guid` only if it represents character guid. All other guids will be renamed to reflect their purpose (like corpseGuid in this specific case) --- sql/base/characters_database.sql | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) (limited to 'sql/base') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index bca9371d571..2b94f5e70ef 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1194,27 +1194,27 @@ DROP TABLE IF EXISTS `corpse`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `corpse` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `player` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', - `position_x` float NOT NULL DEFAULT '0', - `position_y` float NOT NULL DEFAULT '0', - `position_z` float NOT NULL DEFAULT '0', + `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `posX` float NOT NULL DEFAULT '0', + `posY` float NOT NULL DEFAULT '0', + `posZ` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', - `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1', `displayId` int(10) unsigned NOT NULL DEFAULT '0', `itemCache` text NOT NULL, `bytes1` int(10) unsigned NOT NULL DEFAULT '0', `bytes2` int(10) unsigned NOT NULL DEFAULT '0', - `guild` int(10) unsigned NOT NULL DEFAULT '0', + `guildId` int(10) unsigned NOT NULL DEFAULT '0', `flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL DEFAULT '0', - `corpse_type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `instance` 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`), KEY `idx_type` (`corpse_type`), - KEY `instance` (`instance`), + KEY `instance` (`instanceId`), KEY `Idx_player` (`player`), KEY `Idx_time` (`time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'; -- cgit v1.2.3