aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql2
-rw-r--r--sql/base/characters_database.sql52
-rw-r--r--sql/base/dev/world_database.sql36
-rw-r--r--sql/updates/auth/2014_10_26_00_auth.sql1
-rw-r--r--sql/updates/characters/2014_10_26_00_characters.sql27
-rw-r--r--sql/updates/world/2014_10_26_00_world.sql32
6 files changed, 105 insertions, 45 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index c223456dab6..accc9eb0d16 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -434,7 +434,7 @@ DROP TABLE IF EXISTS `logs_ip_actions`;
CREATE TABLE `logs_ip_actions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
`account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
- `character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid',
+ `character_guid` bigint(20) unsigned NOT NULL COMMENT 'Character Guid',
`type` tinyint(3) unsigned NOT NULL,
`ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
`systemnote` text COMMENT 'Notes inserted by system',
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 88b47203eea..4019edc1e5c 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -272,7 +272,7 @@ DROP TABLE IF EXISTS `calendar_events`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calendar_events` (
`id` bigint(20) unsigned NOT NULL DEFAULT '0',
- `creator` int(10) unsigned NOT NULL DEFAULT '0',
+ `creator` bigint(20) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`type` tinyint(1) unsigned NOT NULL DEFAULT '4',
@@ -303,8 +303,8 @@ DROP TABLE IF EXISTS `calendar_invites`;
CREATE TABLE `calendar_invites` (
`id` bigint(20) unsigned NOT NULL DEFAULT '0',
`event` bigint(20) unsigned NOT NULL DEFAULT '0',
- `invitee` int(10) unsigned NOT NULL DEFAULT '0',
- `sender` int(10) unsigned NOT NULL DEFAULT '0',
+ `invitee` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `sender` bigint(20) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`statustime` int(10) unsigned NOT NULL DEFAULT '0',
`rank` tinyint(1) unsigned NOT NULL DEFAULT '0',
@@ -875,7 +875,7 @@ DROP TABLE IF EXISTS `character_pet`;
CREATE TABLE `character_pet` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`entry` int(10) unsigned NOT NULL DEFAULT '0',
- `owner` int(10) unsigned NOT NULL DEFAULT '0',
+ `owner` bigint(10) unsigned NOT NULL DEFAULT '0',
`modelid` int(10) unsigned DEFAULT '0',
`CreatedBySpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
`PetType` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -1459,7 +1459,7 @@ DROP TABLE IF EXISTS `creature_respawn`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `creature_respawn` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
`mapId` smallint(10) unsigned NOT NULL DEFAULT '0',
`instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
@@ -1533,7 +1533,7 @@ DROP TABLE IF EXISTS `gameobject_respawn`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gameobject_respawn` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
`mapId` smallint(10) unsigned NOT NULL DEFAULT '0',
`instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
@@ -2199,11 +2199,11 @@ DROP TABLE IF EXISTS `item_instance`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_instance` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `owner_guid` int(10) unsigned NOT NULL DEFAULT '0',
- `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0',
- `giftCreatorGuid` int(10) unsigned NOT NULL DEFAULT '0',
+ `owner_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `creatorGuid` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `giftCreatorGuid` bigint(20) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '1',
`duration` int(10) NOT NULL DEFAULT '0',
`charges` tinytext,
@@ -2235,7 +2235,7 @@ DROP TABLE IF EXISTS `item_loot_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_loot_items` (
- `container_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)',
+ `container_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)',
`item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'loot item entry (item_instance.itemEntry)',
`item_count` int(10) NOT NULL DEFAULT '0' COMMENT 'stack size',
`follow_rules` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'follow loot rules',
@@ -2266,7 +2266,7 @@ DROP TABLE IF EXISTS `item_loot_money`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_loot_money` (
- `container_id` int(10) NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)',
+ `container_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)',
`money` int(10) NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2288,8 +2288,8 @@ DROP TABLE IF EXISTS `item_refund_instance`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_refund_instance` (
- `item_guid` int(10) unsigned NOT NULL COMMENT 'Item GUID',
- `player_guid` int(10) unsigned NOT NULL COMMENT 'Player GUID',
+ `item_guid` bigint(20) unsigned NOT NULL COMMENT 'Item GUID',
+ `player_guid` bigint(20) unsigned NOT NULL COMMENT 'Player GUID',
`paidMoney` int(10) unsigned NOT NULL DEFAULT '0',
`paidExtendedCost` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`item_guid`,`player_guid`)
@@ -2313,7 +2313,7 @@ DROP TABLE IF EXISTS `item_soulbound_trade_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_soulbound_trade_data` (
- `itemGuid` int(10) unsigned NOT NULL COMMENT 'Item GUID',
+ `itemGuid` bigint(20) unsigned NOT NULL COMMENT 'Item GUID',
`allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade',
PRIMARY KEY (`itemGuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System';
@@ -2337,7 +2337,7 @@ DROP TABLE IF EXISTS `lag_reports`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lag_reports` (
`reportId` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`lagType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
`posX` float NOT NULL DEFAULT '0',
@@ -2394,8 +2394,8 @@ CREATE TABLE `mail` (
`messageType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`stationery` tinyint(3) NOT NULL DEFAULT '41',
`mailTemplateId` smallint(5) unsigned NOT NULL DEFAULT '0',
- `sender` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
- `receiver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
+ `sender` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
+ `receiver` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
`subject` longtext,
`body` longtext,
`has_items` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -2427,8 +2427,8 @@ DROP TABLE IF EXISTS `mail_items`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mail_items` (
`mail_id` int(10) unsigned NOT NULL DEFAULT '0',
- `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
- `receiver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
+ `item_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `receiver` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
PRIMARY KEY (`item_guid`),
KEY `idx_receiver` (`receiver`),
KEY `idx_mail_id` (`mail_id`)
@@ -2536,8 +2536,8 @@ DROP TABLE IF EXISTS `petition`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `petition` (
- `ownerguid` int(10) unsigned NOT NULL,
- `petitionguid` int(10) unsigned DEFAULT '0',
+ `ownerguid` bigint(20) unsigned NOT NULL,
+ `petitionguid` bigint(20) unsigned DEFAULT '0',
`name` varchar(24) NOT NULL,
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ownerguid`,`type`),
@@ -2562,9 +2562,9 @@ DROP TABLE IF EXISTS `petition_sign`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `petition_sign` (
- `ownerguid` int(10) unsigned NOT NULL,
- `petitionguid` int(10) unsigned NOT NULL DEFAULT '0',
- `playerguid` int(10) unsigned NOT NULL DEFAULT '0',
+ `ownerguid` bigint(20) unsigned NOT NULL,
+ `petitionguid` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `playerguid` bigint(20) unsigned NOT NULL DEFAULT '0',
`player_account` int(10) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`petitionguid`,`playerguid`),
@@ -2640,7 +2640,7 @@ DROP TABLE IF EXISTS `pvpstats_players`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pvpstats_players` (
`battleground_id` bigint(20) unsigned NOT NULL,
- `character_guid` int(10) unsigned NOT NULL,
+ `character_guid` bigint(20) unsigned NOT NULL,
`score_killing_blows` mediumint(8) unsigned NOT NULL,
`score_deaths` mediumint(8) unsigned NOT NULL,
`score_honorable_kills` mediumint(8) unsigned NOT NULL,
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 474843b7c84..ab80b4aa343 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -272,7 +272,7 @@ DROP TABLE IF EXISTS `creature`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `creature` (
- `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
`id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
`map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1',
@@ -309,7 +309,7 @@ DROP TABLE IF EXISTS `creature_addon`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `creature_addon` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`path_id` int(10) unsigned NOT NULL DEFAULT '0',
`mount` mediumint(8) unsigned NOT NULL DEFAULT '0',
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
@@ -373,8 +373,8 @@ DROP TABLE IF EXISTS `creature_formations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `creature_formations` (
- `leaderGUID` int(10) unsigned NOT NULL,
- `memberGUID` int(10) unsigned NOT NULL,
+ `leaderGUID` bigint(20) unsigned NOT NULL,
+ `memberGUID` bigint(20) unsigned NOT NULL,
`dist` float unsigned NOT NULL,
`angle` float unsigned NOT NULL,
`groupAI` int(10) unsigned NOT NULL,
@@ -801,7 +801,7 @@ DROP TABLE IF EXISTS `game_event_creature`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `game_event_creature` (
`eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.',
- `guid` int(10) unsigned NOT NULL,
+ `guid` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`guid`,`eventEntry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -830,7 +830,7 @@ DROP TABLE IF EXISTS `game_event_gameobject`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `game_event_gameobject` (
`eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.',
- `guid` int(10) unsigned NOT NULL,
+ `guid` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`guid`,`eventEntry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -859,7 +859,7 @@ DROP TABLE IF EXISTS `game_event_model_equip`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `game_event_model_equip` (
`eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event.',
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`modelid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`equipment_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
@@ -875,7 +875,7 @@ DROP TABLE IF EXISTS `game_event_npc_vendor`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `game_event_npc_vendor` (
`eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event.',
- `guid` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`slot` smallint(6) NOT NULL DEFAULT '0',
`item` mediumint(8) unsigned NOT NULL DEFAULT '0',
`maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -896,7 +896,7 @@ DROP TABLE IF EXISTS `game_event_npcflag`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `game_event_npcflag` (
`eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event',
- `guid` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`npcflag` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`eventEntry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -1029,7 +1029,7 @@ DROP TABLE IF EXISTS `gameobject`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gameobject` (
- `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
`id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier',
`map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1',
@@ -1602,8 +1602,8 @@ DROP TABLE IF EXISTS `linked_respawn`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `linked_respawn` (
- `guid` int(10) unsigned NOT NULL COMMENT 'dependent creature',
- `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master creature',
+ `guid` bigint(20) unsigned NOT NULL COMMENT 'dependent creature',
+ `linkedGuid` bigint(20) unsigned NOT NULL COMMENT 'master creature',
`linkType` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`linkType`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System';
@@ -2723,7 +2723,7 @@ DROP TABLE IF EXISTS `pool_creature`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool_creature` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
`chance` float unsigned NOT NULL DEFAULT '0',
`description` varchar(255) DEFAULT NULL,
@@ -2740,7 +2740,7 @@ DROP TABLE IF EXISTS `pool_gameobject`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool_gameobject` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
`chance` float unsigned NOT NULL DEFAULT '0',
`description` varchar(255) DEFAULT NULL,
@@ -3195,7 +3195,7 @@ DROP TABLE IF EXISTS `smart_scripts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smart_scripts` (
- `entryorguid` int(11) NOT NULL,
+ `entryorguid` bigint(20) NOT NULL,
`source_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`id` smallint(5) unsigned NOT NULL DEFAULT '0',
`link` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -3642,7 +3642,7 @@ DROP TABLE IF EXISTS `transports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transports` (
- `guid` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `guid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
`name` text,
`phaseid` int(10) NOT NULL DEFAULT '0',
@@ -3683,7 +3683,7 @@ DROP TABLE IF EXISTS `vehicle_accessory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehicle_accessory` (
- `guid` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`accessory_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
`seat_id` tinyint(4) NOT NULL DEFAULT '0',
`minion` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -3767,7 +3767,7 @@ CREATE TABLE `waypoint_data` (
`move_type` int(11) NOT NULL DEFAULT '0',
`action` int(11) NOT NULL DEFAULT '0',
`action_chance` smallint(6) NOT NULL DEFAULT '100',
- `wpguid` int(11) NOT NULL DEFAULT '0',
+ `wpguid` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`,`point`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/auth/2014_10_26_00_auth.sql b/sql/updates/auth/2014_10_26_00_auth.sql
new file mode 100644
index 00000000000..db24968656e
--- /dev/null
+++ b/sql/updates/auth/2014_10_26_00_auth.sql
@@ -0,0 +1 @@
+ALTER TABLE `logs_ip_actions` CHANGE `character_guid` `character_guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
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';
diff --git a/sql/updates/world/2014_10_26_00_world.sql b/sql/updates/world/2014_10_26_00_world.sql
new file mode 100644
index 00000000000..79d5842c14c
--- /dev/null
+++ b/sql/updates/world/2014_10_26_00_world.sql
@@ -0,0 +1,32 @@
+UPDATE `trinity_string` SET `content_default`='Sender: %s(%llu), Receiver: %s(%llu)' WHERE `entry`=1153;
+UPDATE `trinity_string` SET `content_default`='%llu - sender: %s (guid: %llu account: %u) receiver: %s (guid: %llu account: %u) %s' WHERE `entry`=509;
+UPDATE `trinity_string` SET `content_default`='Game Object |cffffffff|Hgameobject:%llu|h[%s]|h|r (%s) turned' WHERE `entry`=276;
+UPDATE `trinity_string` SET `content_default`='Game Object |cffffffff|Hgameobject:%llu|h[%s]|h|r (%s) moved' WHERE `entry`=277;
+UPDATE `trinity_string` SET `content_default`='%d (Entry: %d) - |cffffffff|Hgameobject:%llu|h[%s X:%f Y:%f Z:%f MapId:%d]|h|r ' WHERE `entry`=517;
+UPDATE `trinity_string` SET `content_default`='Selected object:\n|cffffffff|Hgameobject:%llu|h[%s]|h|r GUID: %u ID: %u\nX: %f Y: %f Z: %f MapId: %u\nOrientation: %f\nPhasemask %u' WHERE `entry`=524;
+UPDATE `trinity_string` SET `content_default`='%llu - |cffffffff|Hcreature:%llu|h[%s X:%f Y:%f Z:%f MapId:%d]|h|r' WHERE `entry`=515;
+UPDATE `trinity_string` SET `content_default`='%llu - %s X:%f Y:%f Z:%f MapId:%d' WHERE `entry`=1110;
+UPDATE `trinity_string` SET `content_default`='%llu - %s X:%f Y:%f Z:%f MapId:%d' WHERE `entry`=1111;
+UPDATE `trinity_string` SET `content_default`='Character guid %llu in use!' WHERE `entry`=1117;
+UPDATE `trinity_string` SET `content_default`='Game Object (GUID: %llu) not found' WHERE `entry`=273;
+UPDATE `trinity_string` SET `content_default`='>> Add Game Object ''%i'' (%s) (GUID: %llu) added at ''%f %f %f''.' WHERE `entry`=525;
+UPDATE `trinity_string` SET `content_default`='Creature (GUID: %llu) not found' WHERE `entry`=287;
+
+ALTER TABLE `creature` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `creature_addon` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `creature_formations` CHANGE `leaderGUID` `leaderGUID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `creature_formations` CHANGE `memberGUID` `memberGUID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_creature` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_gameobject` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_model_equip` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npc_vendor` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npcflag` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `linked_respawn` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `linked_respawn` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `pool_creature` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `pool_gameobject` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `smart_scripts` CHANGE `entryorguid` `entryorguid` BIGINT(20) NOT NULL DEFAULT '0';
+ALTER TABLE `transports` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `vehicle_accessory` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `waypoint_data` CHANGE `wpguid` `wpguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';