aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql3
-rw-r--r--sql/updates/8986_characters_worldstates.sql3
2 files changed, 5 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 4dc67ef97a1..16ed16de332 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1976,7 +1976,8 @@ LOCK TABLES `worldstates` WRITE;
INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES
(20001, 0, 'NextArenaPointDistributionTime'),
(20002, 0, 'NextWeeklyQuestResetTime'),
-(20003, 0, 'NextBGRandomDailyResetTime');
+(20003, 0, 'NextBGRandomDailyResetTime'),
+(20004, 0, 'cleaning_flags');
/*!40000 ALTER TABLE `worldstates` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
diff --git a/sql/updates/8986_characters_worldstates.sql b/sql/updates/8986_characters_worldstates.sql
new file mode 100644
index 00000000000..78234428a37
--- /dev/null
+++ b/sql/updates/8986_characters_worldstates.sql
@@ -0,0 +1,3 @@
+
+DELETE FROM `worldstates` WHERE `entry`=20004;
+INSERT INTO `worldstates` (`entry`,`value`,`comment`) VALUES (20004,0, 'cleaning_flags');