diff options
| author | Shauren <shauren.trinity@gmail.com> | 2016-05-30 23:41:08 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-05-30 23:41:08 +0200 |
| commit | 634ec0061f9358f03aba91dc5411c2d38de94f5c (patch) | |
| tree | 66b77b105a4f7927f590f9a67003a91ea46dcc4e /sql | |
| parent | b82332487afd7233850e7eed996615b3fdd7248c (diff) | |
Core/DataStores: Updated db2 to 7.0.3.21796
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_06.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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`; |