From 634ec0061f9358f03aba91dc5411c2d38de94f5c Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 30 May 2016 23:41:08 +0200 Subject: Core/DataStores: Updated db2 to 7.0.3.21796 --- sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_06.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_06.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_06.sql b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_06.sql new file mode 100644 index 00000000000..bbb0075ac6b --- /dev/null +++ b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_06.sql @@ -0,0 +1,12 @@ +ALTER TABLE `lfg_dungeons` ADD `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0 AFTER `Description`; + +ALTER TABLE `map` + CHANGE `Flags` `Flags1` int(10) unsigned NOT NULL DEFAULT 0 AFTER `Directory`, + CHANGE `MapType` `Flags2` int(10) unsigned NOT NULL DEFAULT 0 AFTER `Flags1`, + ADD `WindSettingsID` smallint(5) unsigned NOT NULL DEFAULT 0 AFTER `CosmeticParentMapID`; + +ALTER TABLE `player_condition` + CHANGE `Unknown700_1` `Unknown7001` int(10) unsigned NOT NULL DEFAULT 0 AFTER `MaxAvgItemLevel`, + CHANGE `Unknown700_2` `Unknown7002` int(10) unsigned NOT NULL DEFAULT 0 AFTER `Unknown7001`; + +ALTER TABLE `world_map_transforms` ADD `AreaID` smallint(5) unsigned NOT NULL DEFAULT 0 AFTER `MapID`; -- cgit v1.2.3