From 9fa5c714096a9755a3a7ada45c8d5e6a54f18950 Mon Sep 17 00:00:00 2001 From: Treeston Date: Tue, 16 Jul 2019 12:29:34 +0200 Subject: 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) --- sql/base/characters_database.sql | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'sql/base/characters_database.sql') 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; -- cgit v1.2.3