diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/master/2018_02_08_00_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/master/2018_02_08_00_world.sql | 14 |
2 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2018_02_08_00_characters.sql b/sql/updates/characters/master/2018_02_08_00_characters.sql new file mode 100644 index 00000000000..5e8f8dbac02 --- /dev/null +++ b/sql/updates/characters/master/2018_02_08_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` ADD `lastLoginBuild` int(10) unsigned NOT NULL DEFAULT '0' AFTER `honorRestBonus`; diff --git a/sql/updates/world/master/2018_02_08_00_world.sql b/sql/updates/world/master/2018_02_08_00_world.sql new file mode 100644 index 00000000000..181eb7991f4 --- /dev/null +++ b/sql/updates/world/master/2018_02_08_00_world.sql @@ -0,0 +1,14 @@ +ALTER TABLE `guild_rewards` CHANGE `RaceMask` `RaceMask` bigint(20) unsigned DEFAULT '0'; + +ALTER TABLE `playerchoice` + ADD `UiTextureKitId` int(11) NOT NULL DEFAULT '0' AFTER `ChoiceId`, + ADD `HideWarboardHeader` tinyint(1) NOT NULL DEFAULT '0' AFTER `Question`; + +ALTER TABLE `quest_poi` ADD `AlwaysAllowMergingBlobs` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `WoDUnk1`; + +ALTER TABLE `quest_template` + ADD `MaxScalingLevel` int(11) NOT NULL DEFAULT '255' AFTER `QuestLevel`, + CHANGE `AllowableRaces` `AllowableRaces` bigint(20) unsigned NOT NULL DEFAULT 0xFFFFFFFFFFFFFFFF; + +RENAME TABLE `race_expansion_requirement` TO `race_unlock_requirement`; +ALTER TABLE `race_unlock_requirement` ADD `achievementId` int(10) unsigned NOT NULL DEFAULT '0'; |