Core/Entities: First step to 128 bit guids

* Database fields storing full guid have been converted to BINARY(16)

1 files changed, 16 insertions, 0 deletions

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;