diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -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 |
3 files changed, 18 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 964dd61d6d0..f407dd0afef 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1710,6 +1710,7 @@ CREATE TABLE `characters` ( `prestigeLevel` INT(10) unsigned NOT NULL DEFAULT '0', `honorRestState` TINYINT unsigned NOT NULL DEFAULT '2', `honorRestBonus` FLOAT NOT NULL DEFAULT '0', + `lastLoginBuild` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), @@ -3534,7 +3535,8 @@ INSERT INTO `updates` VALUES ('2017_08_20_00_characters.sql','8C5BBF6AEAA6C7DE2F40A7D3878C8187A4729F13','ARCHIVED','2017-08-20 17:00:00',0), ('2017_08_20_01_characters.sql','2F50D5E6BF3888B8C5270D79228A1D0601FAFF1D','ARCHIVED','2017-08-20 17:52:21',0), ('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',25), -('2018_02_03_00_characters.sql','73E9BFD848D7A22F2A7DD89CF64E30E3A8689512','RELEASED','2018-02-03 23:52:42', 0); +('2018_02_03_00_characters.sql','73E9BFD848D7A22F2A7DD89CF64E30E3A8689512','RELEASED','2018-02-03 23:52:42',0), +('2018_02_08_00_characters.sql','75FA162A9B85D678B26F972371265F1EC2C75187','RELEASED','2018-02-08 22:23:28',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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'; |