Core/CharDB Cleanup: alter character_battleground_data table making column names lowerCamel and move all queries to prepared statements.

1 files changed, 10 insertions, 0 deletions

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';