From 08c56eb1109aed2c6dabe728c945d4afd4943753 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 23 Oct 2014 17:01:26 +0200 Subject: Core/Entities: First step to 128 bit guids * Database fields storing full guid have been converted to BINARY(16) --- sql/base/characters_database.sql | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) (limited to 'sql/base') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index f61701cc4bf..440ebbb7066 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -483,8 +483,8 @@ DROP TABLE IF EXISTS `character_aura`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_aura` ( `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `caster_guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', - `item_guid` bigint(20) unsigned NOT NULL DEFAULT '0', + `caster_guid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', + `item_guid` binary(16) unsigned NOT NULL DEFAULT '0', `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', `effect_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', `recalculate_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -1705,14 +1705,14 @@ CREATE TABLE `groups` ( `lootMethod` tinyint(3) unsigned NOT NULL, `looterGuid` int(10) unsigned NOT NULL, `lootThreshold` tinyint(3) unsigned NOT NULL, - `icon1` bigint(20) unsigned NOT NULL, - `icon2` bigint(20) unsigned NOT NULL, - `icon3` bigint(20) unsigned NOT NULL, - `icon4` bigint(20) unsigned NOT NULL, - `icon5` bigint(20) unsigned NOT NULL, - `icon6` bigint(20) unsigned NOT NULL, - `icon7` bigint(20) unsigned NOT NULL, - `icon8` bigint(20) unsigned NOT NULL, + `icon1` binary(16) NOT NULL, + `icon2` binary(16) NOT NULL, + `icon3` binary(16) NOT NULL, + `icon4` binary(16) NOT NULL, + `icon5` binary(16) NOT NULL, + `icon6` binary(16) NOT NULL, + `icon7` binary(16) NOT NULL, + `icon8` binary(16) NOT NULL, `groupType` tinyint(3) unsigned NOT NULL, `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', `raiddifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -2453,7 +2453,7 @@ DROP TABLE IF EXISTS `pet_aura`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pet_aura` ( `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `caster_guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', + `caster_guid` binary(16) NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', `effect_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', `recalculate_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', -- cgit v1.2.3