Core/Creatures: Extended npcflags to uint64

2 files changed, 9 insertions, 1 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index bcca640a7d9..5c864dc8cf7 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2670,7 +2670,7 @@ CREATE TABLE `mail_items` (
   PRIMARY KEY (`item_guid`),
   KEY `idx_receiver` (`receiver`),
   KEY `idx_mail_id` (`mail_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
diff --git a/sql/updates/world/2015_05_04_00_world.sql b/sql/updates/world/2015_05_04_00_world.sql
new file mode 100644
index 00000000000..276464917a1
--- /dev/null
+++ b/sql/updates/world/2015_05_04_00_world.sql
@@ -0,0 +1,8 @@
+ALTER TABLE `creature` CHANGE `npcflag` `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` CHANGE `npcflag` `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npcflag` CHANGE `npcflag` `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gossip_menu_option` CHANGE `npc_option_npcflag` `npc_option_npcflag` bigint(20) unsigned NOT NULL DEFAULT '0';
+
+UPDATE `trinity_string` SET `content_default`='Player selected NPC\nDB GUID: %u, current %s.\nFaction: %u.\nnpcFlags: 0x%llX.\nEntry: %u.\nDisplayID: %u (Native: %u).' WHERE entry=539;
+UPDATE `trinity_string` SET `content_default`='%s, faction is %u, flags is 0x%X, npcflag is 0x%llX, dynflag is 0x%X.' WHERE entry=128;
+UPDATE `trinity_string` SET `content_default`='You changed %s Faction to %u, flags to 0x%X, npcflag to 0x%llX, dyflag to 0x%X.' WHERE entry=130;