aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorTreeston <treeston.mmoc@gmail.com>2019-07-16 12:29:34 +0200
committerTreeston <treeston.mmoc@gmail.com>2019-07-16 12:50:16 +0200
commit1277c542638522b210addd22966c32db89cb29b6 (patch)
treec1d44e1d7b26f447390b891ec7599a6dabed71bc /sql/updates
parentc278044739761da935f51280468d752675c1cc4e (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.
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/characters/3.3.5/2019_07_16_00_characters.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/characters/3.3.5/2019_07_16_00_characters.sql b/sql/updates/characters/3.3.5/2019_07_16_00_characters.sql
new file mode 100644
index 00000000000..425972d7e0e
--- /dev/null
+++ b/sql/updates/characters/3.3.5/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');