From 37a6fe2ae737db97015acd38fad16c7306d68dd2 Mon Sep 17 00:00:00 2001 From: Azazel Date: Fri, 8 Apr 2011 11:28:10 +0600 Subject: Core/CharDB Cleanup: alter character_battleground_data table making column names lowerCamel and move all queries to prepared statements. --- sql/base/characters_database.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'sql/base') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index cac288e160a..48b3b3f3eee 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -462,16 +462,16 @@ DROP TABLE IF EXISTS `character_battleground_data`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_battleground_data` ( `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `instance_id` int(10) unsigned NOT NULL, + `instanceId` int(10) unsigned NOT NULL COMMENT 'Instance Identifier', `team` smallint(5) unsigned NOT NULL, - `join_x` float NOT NULL DEFAULT '0', - `join_y` float NOT NULL DEFAULT '0', - `join_z` float NOT NULL DEFAULT '0', - `join_o` float NOT NULL DEFAULT '0', - `join_map` smallint(5) unsigned NOT NULL DEFAULT '0', - `taxi_start` int(10) unsigned NOT NULL DEFAULT '0', - `taxi_end` int(10) unsigned NOT NULL DEFAULT '0', - `mount_spell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `joinX` float NOT NULL DEFAULT '0', + `joinY` float NOT NULL DEFAULT '0', + `joinZ` float NOT NULL DEFAULT '0', + `joinO` float NOT NULL DEFAULT '0', + `joinMapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `taxiStart` int(10) unsigned NOT NULL DEFAULT '0', + `taxiEnd` int(10) unsigned NOT NULL DEFAULT '0', + `mountSpell` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- cgit v1.2.3