diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 18 | ||||
| -rw-r--r-- | sql/updates/auth_char/2011_04_08_00_characters_battleground_data.sql | 10 |
2 files changed, 19 insertions, 9 deletions
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 */; 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'; |