diff options
| author | Azazel <azazel.kon@gmail.com> | 2011-04-08 17:04:51 +0600 |
|---|---|---|
| committer | Azazel <azazel.kon@gmail.com> | 2011-04-08 17:04:51 +0600 |
| commit | 9f1cc4407a385e1ab3a835fd983e6b3d259aa47c (patch) | |
| tree | 173f212ef8955023ff14a22bcc603ae86917601a /sql | |
| parent | 37a6fe2ae737db97015acd38fad16c7306d68dd2 (diff) | |
Core/CharDB Cleanup: alter character_homebind table making column names lowerCamel and move all queries to prepared statements.
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'; |