diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 10 | ||||
| -rw-r--r-- | sql/updates/auth_char/2011_04_08_01_characters_character_homebind.sql | 6 |
2 files changed, 11 insertions, 5 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 48b3b3f3eee..4de56b8fb5d 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -645,11 +645,11 @@ DROP TABLE IF EXISTS `character_homebind`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_homebind` ( `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', - `zone` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', - `position_x` float NOT NULL DEFAULT '0', - `position_y` float NOT NULL DEFAULT '0', - `position_z` float NOT NULL DEFAULT '0', + `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', + `posX` float NOT NULL DEFAULT '0', + `posY` float NOT NULL DEFAULT '0', + `posZ` float 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_01_characters_character_homebind.sql b/sql/updates/auth_char/2011_04_08_01_characters_character_homebind.sql new file mode 100644 index 00000000000..8d026b50494 --- /dev/null +++ b/sql/updates/auth_char/2011_04_08_01_characters_character_homebind.sql @@ -0,0 +1,6 @@ +ALTER TABLE `character_homebind` + CHANGE `map` `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + CHANGE `zone` `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', + CHANGE `position_x` `posX` float NOT NULL DEFAULT '0', + CHANGE `position_y` `posY` float NOT NULL DEFAULT '0', + CHANGE `position_z` `posZ` float NOT NULL DEFAULT '0'; |