Core/Entities: First step to 128 bit guids

* Database fields storing full guid have been converted to BINARY(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;