diff options
| author | Treeston <treeston.mmoc@gmail.com> | 2019-07-16 12:29:34 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-16 21:20:38 +0100 |
| commit | 9fa5c714096a9755a3a7ada45c8d5e6a54f18950 (patch) | |
| tree | 16f00c8cd0e1868b18746193fa0f71aab0f3977e /sql | |
| parent | c204badd0f68904434e41ae7cbd9ca9b5b8e2aca (diff) | |
Core/DB: Add a world state for daily quest reset time to `characters`. Not used right now, but written to allow easier transition later.
(cherry picked from commit 1277c542638522b210addd22966c32db89cb29b6)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 8 | ||||
| -rw-r--r-- | sql/updates/characters/master/2021_12_16_01_characters_2019_07_16_00_characters.sql | 4 |
2 files changed, 10 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 651be3c5c17..bff724e46ac 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3650,7 +3650,8 @@ INSERT INTO `updates` VALUES ('2021_11_02_00_characters.sql','A3C0A6DA70CC70803C80685E4E2ED6255156520A','ARCHIVED','2021-11-02 18:11:13',0), ('2021_11_04_00_characters.sql','ED533235ADAD174F91A6B8E51D1046243B78B46D','ARCHIVED','2021-11-04 21:53:04',0), ('2021_11_17_00_characters.sql','03A0AB8ECD8BE5D818D41A8A610097C94A9C7DB9','ARCHIVED','2021-11-17 13:23:17',0), -('2021_12_16_00_characters_2019_07_14_00_characters.sql','DC1A3D3311FCF9106B4D91F8D2C5B893AD66C093','RELEASED','2021-12-16 01:06:53',0); +('2021_12_16_00_characters_2019_07_14_00_characters.sql','DC1A3D3311FCF9106B4D91F8D2C5B893AD66C093','RELEASED','2021-12-16 01:06:53',0), +('2021_12_16_01_characters_2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','RELEASED','2021-12-16 20:16:25',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3732,7 +3733,10 @@ INSERT INTO `worldstates` VALUES (20001,0,'NextArenaPointDistributionTime'), (20002,0,'NextWeeklyQuestResetTime'), (20003,0,'NextBGRandomDailyResetTime'), -(20004,0,'cleaning_flags'); +(20004,0,'cleaning_flags'), +(20006,0,'NextGuildDailyResetTime'), +(20007,0,'NextMonthlyQuestResetTime'), +(20008,0,'NextDailyQuestResetTime'); /*!40000 ALTER TABLE `worldstates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2021_12_16_01_characters_2019_07_16_00_characters.sql b/sql/updates/characters/master/2021_12_16_01_characters_2019_07_16_00_characters.sql new file mode 100644 index 00000000000..425972d7e0e --- /dev/null +++ b/sql/updates/characters/master/2021_12_16_01_characters_2019_07_16_00_characters.sql @@ -0,0 +1,4 @@ +-- +UPDATE `worldstates` SET `comment`='NextGuildDailyResetTime' WHERE `entry`=20006; +UPDATE `worldstates` SET `comment`='NextMonthlyQuestResetTime' WHERE `entry`=20007; +INSERT INTO `worldstates` (`entry`,`value`,`comment`) VALUES (20008,0,'NextDailyQuestResetTime'); |