aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorTreeston <treeston.mmoc@gmail.com>2019-07-16 12:29:34 +0200
committerShauren <shauren.trinity@gmail.com>2021-12-16 21:20:38 +0100
commit9fa5c714096a9755a3a7ada45c8d5e6a54f18950 (patch)
tree16f00c8cd0e1868b18746193fa0f71aab0f3977e /sql/updates
parentc204badd0f68904434e41ae7cbd9ca9b5b8e2aca (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/updates')
-rw-r--r--sql/updates/characters/master/2021_12_16_01_characters_2019_07_16_00_characters.sql4
1 files changed, 4 insertions, 0 deletions
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');