diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 22 |
1 files changed, 11 insertions, 11 deletions
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', |