diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 22 | ||||
| -rw-r--r-- | sql/updates/characters/2014_10_23_00_characters.sql | 16 |
2 files changed, 27 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', diff --git a/sql/updates/characters/2014_10_23_00_characters.sql b/sql/updates/characters/2014_10_23_00_characters.sql new file mode 100644 index 00000000000..e6ee7048ac6 --- /dev/null +++ b/sql/updates/characters/2014_10_23_00_characters.sql @@ -0,0 +1,16 @@ +TRUNCATE `character_aura`; +TRUNCATE `pet_aura`; +TRUNCATE `group_instance`; +TRUNCATE `group_member`; +TRUNCATE `groups`; +ALTER TABLE `character_aura` CHANGE `caster_guid` `caster_guid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier'; +ALTER TABLE `character_aura` CHANGE `item_guid` `item_guid` binary(16) NOT NULL; +ALTER TABLE `pet_aura` CHANGE `caster_guid` `caster_guid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier'; +ALTER TABLE `groups` CHANGE `icon1` `icon1` binary(16) NOT NULL; +ALTER TABLE `groups` CHANGE `icon2` `icon2` binary(16) NOT NULL; +ALTER TABLE `groups` CHANGE `icon3` `icon3` binary(16) NOT NULL; +ALTER TABLE `groups` CHANGE `icon4` `icon4` binary(16) NOT NULL; +ALTER TABLE `groups` CHANGE `icon5` `icon5` binary(16) NOT NULL; +ALTER TABLE `groups` CHANGE `icon6` `icon6` binary(16) NOT NULL; +ALTER TABLE `groups` CHANGE `icon7` `icon7` binary(16) NOT NULL; +ALTER TABLE `groups` CHANGE `icon8` `icon8` binary(16) NOT NULL; |