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. --- .../auth_char/2011_04_08_00_characters_battleground_data.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/auth_char/2011_04_08_00_characters_battleground_data.sql (limited to 'sql/updates') diff --git a/sql/updates/auth_char/2011_04_08_00_characters_battleground_data.sql b/sql/updates/auth_char/2011_04_08_00_characters_battleground_data.sql new file mode 100644 index 00000000000..39a3de977ba --- /dev/null +++ b/sql/updates/auth_char/2011_04_08_00_characters_battleground_data.sql @@ -0,0 +1,10 @@ +ALTER TABLE `character_battleground_data` + CHANGE `instance_id` `instanceId` int(10) unsigned NOT NULL COMMENT 'Instance Identifier', + CHANGE `join_map` `joinMapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + CHANGE `join_x` `joinX` float NOT NULL DEFAULT '0', + CHANGE `join_y` `joinY` float NOT NULL DEFAULT '0', + CHANGE `join_z` `joinZ` float NOT NULL DEFAULT '0', + CHANGE `join_o` `joinO` float NOT NULL DEFAULT '0', + CHANGE `taxi_start` `taxiStart` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `taxi_end` `taxiEnd` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `mount_spell` `mountSpell` mediumint(8) unsigned NOT NULL DEFAULT '0'; -- cgit v1.2.3