diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/master/2019_06_08_00_auth.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/master/2019_06_08_00_world.sql | 18 |
2 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2019_06_08_00_auth.sql b/sql/updates/auth/master/2019_06_08_00_auth.sql new file mode 100644 index 00000000000..a979ce76fe6 --- /dev/null +++ b/sql/updates/auth/master/2019_06_08_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `battlenet_account_toys` ADD `hasFanfare` tinyint(1) DEFAULT '0' AFTER `isFavourite`; diff --git a/sql/updates/world/master/2019_06_08_00_world.sql b/sql/updates/world/master/2019_06_08_00_world.sql new file mode 100644 index 00000000000..a2538fa77f8 --- /dev/null +++ b/sql/updates/world/master/2019_06_08_00_world.sql @@ -0,0 +1,18 @@ +ALTER TABLE `creature_template` + ADD `FadeRegionRadius` float NOT NULL DEFAULT '0' AFTER `movementId`, + ADD `WidgetSetID` int(11) NOT NULL DEFAULT '0' AFTER `FadeRegionRadius`, + ADD `WidgetSetUnitConditionID` int(11) NOT NULL DEFAULT '0' AFTER `WidgetSetID`; + +ALTER TABLE `playerchoice` ADD `SoundKitId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `UiTextureKitId`; +ALTER TABLE `playerchoice_response` + ADD `UiTextureAtlasElementID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `WidgetSetID`, + ADD `SoundKitID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `UiTextureAtlasElementID`, + ADD `SubHeader` varchar(100) NOT NULL DEFAULT '' AFTER `Header`, + ADD `ButtonTooltip` varchar(400) NOT NULL DEFAULT '' AFTER `SubHeader`, + ADD `RewardQuestID` int(10) unsigned DEFAULT NULL AFTER `Confirmation`; + +ALTER TABLE `playerchoice_response_locale` + ADD `SubHeader` varchar(100) NOT NULL DEFAULT '' AFTER `Header`, + ADD `ButtonTooltip` varchar(400) NOT NULL DEFAULT '' AFTER `SubHeader`; + +ALTER TABLE `quest_template` ADD `ManagedWorldStateID` int(11) NOT NULL DEFAULT '0' AFTER `Expansion`; |