diff options
| author | Treeston <treeston.mmoc@gmail.com> | 2019-07-16 12:29:34 +0200 |
|---|---|---|
| committer | Treeston <treeston.mmoc@gmail.com> | 2019-07-16 12:50:16 +0200 |
| commit | 1277c542638522b210addd22966c32db89cb29b6 (patch) | |
| tree | c1d44e1d7b26f447390b891ec7599a6dabed71bc /sql | |
| parent | c278044739761da935f51280468d752675c1cc4e (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')
| -rw-r--r-- | sql/base/characters_database.sql | 15 | ||||
| -rw-r--r-- | sql/updates/characters/3.3.5/2019_07_16_00_characters.sql | 4 |
2 files changed, 13 insertions, 6 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 03428777328..668c8adb45f 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2633,8 +2633,10 @@ INSERT INTO `updates` VALUES ('2019_05_15_00_characters.sql','A12F21C8044C8BC8E2AA17F4C6CEB8B722CBC714','ARCHIVED','2019-05-15 06:13:20',0), ('2019_06_15_00_characters.sql','32DA6E004D7DD6EFFB0BB26238D17F6CC9E51DE6','ARCHIVED','2019-06-15 07:33:45',0), ('2019_07_14_00_characters.sql','A141F4F15BDF0320483921429871D4C572BD7E2D','ARCHIVED','2019-07-04 00:00:00',0), -('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 05:57:41',4), -('2019_07_15_01_characters.sql','5D383B026AB9EDE7114F249D206DE7E432E19468','RELEASED','2019-07-15 17:41:30',0); +('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 00:00:00',0), +('2019_07_15_01_characters.sql','5D383B026AB9EDE7114F249D206DE7E432E19468','ARCHIVED','2019-07-15 00:00:00',0), +('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0); + /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2783,11 +2785,12 @@ INSERT INTO `worldstates` VALUES (3801,0,NULL), (3802,1,NULL), (20001,0,'NextArenaPointDistributionTime'), -(20002,1477230266,'NextWeeklyQuestResetTime'), -(20003,1476680400,'NextBGRandomDailyResetTime'), +(20002,0,'NextWeeklyQuestResetTime'), +(20003,0,'NextBGRandomDailyResetTime'), (20004,0,'cleaning_flags'), -(20006,1476680400,NULL), -(20007,1477954800,NULL); +(20006,0,'NextGuildDailyResetTime'), +(20007,0,'NextMonthlyQuestResetTime'), +(20008,0,'NextDailyQuestResetTime'); /*!40000 ALTER TABLE `worldstates` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 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'); |