Core/Entities: Changed object lowguid to uint64

1 files changed, 27 insertions, 0 deletions

diff --git a/sql/updates/characters/2014_10_26_00_characters.sql b/sql/updates/characters/2014_10_26_00_characters.sql
new file mode 100644
index 00000000000..0086228df8b
--- /dev/null
+++ b/sql/updates/characters/2014_10_26_00_characters.sql
@@ -0,0 +1,27 @@
+ALTER TABLE `item_instance` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `item_instance` CHANGE `owner_guid` `owner_guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `item_instance` CHANGE `creatorGuid` `creatorGuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `item_instance` CHANGE `giftCreatorGuid` `giftCreatorGuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `item_loot_items` CHANGE `container_id` `container_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `item_loot_money` CHANGE `container_id` `container_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `item_refund_instance` CHANGE `item_guid` `item_guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `item_refund_instance` CHANGE `player_guid` `player_guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `item_soulbound_trade_data` CHANGE `itemGuid` `itemGuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `lag_reports` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `mail` CHANGE `sender` `sender` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `mail` CHANGE `receiver` `receiver` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `mail_items` CHANGE `item_guid` `item_guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `mail_items` CHANGE `receiver` `receiver` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `petition` CHANGE `ownerguid` `ownerguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `petition` CHANGE `petitionguid` `petitionguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `petition_sign` CHANGE `ownerguid` `ownerguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `petition_sign` CHANGE `petitionguid` `petitionguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `petition_sign` CHANGE `playerguid` `playerguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `pvpstats_players` CHANGE `character_guid` `character_guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `quest_tracker` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `calendar_events` CHANGE `creator` `creator` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `calendar_invites` CHANGE `invitee` `invitee` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `calendar_invites` CHANGE `sender` `sender` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_pet` CHANGE `owner` `owner` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `creature_respawn` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_respawn` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';