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/base | |
| 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/base')
| -rw-r--r-- | sql/base/characters_database.sql | 12 |
1 files changed, 6 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', |