diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 4 | ||||
| -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 |
3 files changed, 22 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 19da747f6fa..cd0f77945c2 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -336,6 +336,7 @@ CREATE TABLE `battlenet_account_toys` ( `accountId` int(10) unsigned NOT NULL, `itemId` int(11) NOT NULL DEFAULT '0', `isFavourite` tinyint(1) DEFAULT '0', + `hasFanfare` tinyint(1) DEFAULT '0', PRIMARY KEY (`accountId`,`itemId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2193,7 +2194,8 @@ INSERT INTO `updates` VALUES ('2018_06_23_00_auth.sql','BE35312C386A127D047E5A7CE0D14DB41D905F8E','RELEASED','2018-05-23 10:14:39',0), ('2018_06_29_00_auth.sql','03AAEA7E52848FA5522C3F0C6D9C38B988407480','RELEASED','2018-06-29 22:34:04',0), ('2018_12_09_00_auth_2017_01_06_00_auth.sql','6CCFE6A9774EC733C9863D36A0F15F3534189BBD','RELEASED','2018-11-22 22:21:26',0), -('2018_12_09_01_auth.sql','576C2A11BE671D8420FA3EB705E594E381ECCC56','RELEASED','2018-12-09 14:49:17',0); +('2018_12_09_01_auth.sql','576C2A11BE671D8420FA3EB705E594E381ECCC56','RELEASED','2018-12-09 14:49:17',0), +('2019_06_08_00_auth.sql','EA5A78F5A26C17BC790481EA9B3772D3A6912459','RELEASED','2019-05-20 17:21:20',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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`; |