diff options
| author | Shauren <shauren.trinity@gmail.com> | 2014-10-20 19:25:50 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2014-10-20 19:25:50 +0200 |
| commit | 26c9d4dc418524c327d0754bb32c6c14375ba527 (patch) | |
| tree | 16801f4b837fe988c1788c7b10f4e3296f1367af /sql | |
| parent | 3af755e2eeee6e1c9b8be75d0cd65ffd006c09ac (diff) | |
Core/Entities: First part of required database changes for migrating guids to 128 bit - all fields storing lowguid must be extended to uint64
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 12 | ||||
| -rw-r--r-- | sql/updates/characters/2014_10_20_00_characters.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/2014_10_20_00_world.sql | 1 |
3 files changed, 13 insertions, 6 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 100bd007b35..f61701cc4bf 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -127,7 +127,7 @@ DROP TABLE IF EXISTS `arena_team`; CREATE TABLE `arena_team` ( `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL, - `captainGuid` int(10) unsigned NOT NULL DEFAULT '0', + `captainGuid` bigint(20) unsigned NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `rating` smallint(5) unsigned NOT NULL DEFAULT '0', `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -162,7 +162,7 @@ DROP TABLE IF EXISTS `arena_team_member`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `arena_team_member` ( `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0', - `guid` int(10) unsigned NOT NULL DEFAULT '0', + `guid` bigint(20) unsigned NOT NULL DEFAULT '0', `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0', `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0', `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -190,12 +190,12 @@ DROP TABLE IF EXISTS `auctionhouse`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auctionhouse` ( `id` int(10) unsigned NOT NULL DEFAULT '0', - `auctioneerguid` int(10) unsigned NOT NULL DEFAULT '0', - `itemguid` int(10) unsigned NOT NULL DEFAULT '0', - `itemowner` int(10) unsigned NOT NULL DEFAULT '0', + `auctioneerguid` bigint(20) unsigned NOT NULL DEFAULT '0', + `itemguid` bigint(20) unsigned NOT NULL DEFAULT '0', + `itemowner` bigint(20) unsigned NOT NULL DEFAULT '0', `buyoutprice` int(10) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL DEFAULT '0', - `buyguid` int(10) unsigned NOT NULL DEFAULT '0', + `buyguid` bigint(20) unsigned NOT NULL DEFAULT '0', `lastbid` int(10) unsigned NOT NULL DEFAULT '0', `startbid` int(10) unsigned NOT NULL DEFAULT '0', `deposit` int(10) unsigned NOT NULL DEFAULT '0', diff --git a/sql/updates/characters/2014_10_20_00_characters.sql b/sql/updates/characters/2014_10_20_00_characters.sql new file mode 100644 index 00000000000..30c57bf5470 --- /dev/null +++ b/sql/updates/characters/2014_10_20_00_characters.sql @@ -0,0 +1,6 @@ +ALTER TABLE `arena_team` CHANGE `captainGuid` `captainGuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `arena_team_member` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `auctionhouse` CHANGE `auctioneerguid` `auctioneerguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `auctionhouse` CHANGE `itemguid` `itemguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `auctionhouse` CHANGE `itemowner` `itemowner` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `auctionhouse` CHANGE `buyguid` `buyguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'; diff --git a/sql/updates/world/2014_10_20_00_world.sql b/sql/updates/world/2014_10_20_00_world.sql new file mode 100644 index 00000000000..fe1a7bbca18 --- /dev/null +++ b/sql/updates/world/2014_10_20_00_world.sql @@ -0,0 +1 @@ +UPDATE `trinity_string` SET `content_default`='%llu - owner: %s (guid: %llu account: %u) %s' WHERE `id`=510; |