1 files changed, 46 insertions, 21 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 109c9f9e2ee..0358dfb8939 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -3672,7 +3672,8 @@ INSERT INTO `updates` VALUES
 ('2022_03_06_00_characters.sql','474AAF9D03E6A56017899C968DC9875368301934','ARCHIVED','2022-03-06 15:12:24',0),
 ('2022_03_11_00_characters_2021_07_18_00_characters.sql','0BA579ED21F4E75AC2B4797421B5029568B3F6E2','RELEASED','2022-03-11 18:56:07',0),
 ('2022_06_01_00_characters.sql','582AC6E256F8365F83AB70BA165CCC8B218E19FF','RELEASED','2022-06-01 21:16:56',0),
-('2022_07_03_00_characters.sql','D3F04078C0846BCF7C8330AC20C39B8C3AEE7002','RELEASED','2022-07-03 23:37:24',0);
+('2022_07_03_00_characters.sql','D3F04078C0846BCF7C8330AC20C39B8C3AEE7002','RELEASED','2022-07-03 23:37:24',0),
+('2022_07_14_00_characters.sql','2EAD57D77FC39F6678F2D2A7D9C24046E6B836D8','RELEASED','2022-07-14 21:44:35',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3730,35 +3731,59 @@ LOCK TABLES `warden_action` WRITE;
 UNLOCK TABLES;
 
 --
--- Table structure for table `worldstates`
+-- Table structure for table `world_state_value`
 --
 
-DROP TABLE IF EXISTS `worldstates`;
+DROP TABLE IF EXISTS `world_state_value`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `worldstates` (
-  `entry` int unsigned NOT NULL DEFAULT '0',
-  `value` int unsigned NOT NULL DEFAULT '0',
-  `comment` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  PRIMARY KEY (`entry`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Variable Saves';
+CREATE TABLE `world_state_value` (
+  `Id` int NOT NULL,
+  `Value` int NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `world_state_value`
+--
+
+LOCK TABLES `world_state_value` WRITE;
+/*!40000 ALTER TABLE `world_state_value` DISABLE KEYS */;
+/*!40000 ALTER TABLE `world_state_value` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `world_variable`
+--
+
+DROP TABLE IF EXISTS `world_variable`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `world_variable` (
+  `ID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Value` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Dumping data for table `worldstates`
+-- Dumping data for table `world_variable`
 --
 
-LOCK TABLES `worldstates` WRITE;
-/*!40000 ALTER TABLE `worldstates` DISABLE KEYS */;
-INSERT INTO `worldstates` VALUES
-(20001,0,'NextArenaPointDistributionTime'),
-(20002,0,'NextWeeklyQuestResetTime'),
-(20003,0,'NextBGRandomDailyResetTime'),
-(20004,0,'cleaning_flags'),
-(20006,0,'NextGuildDailyResetTime'),
-(20007,0,'NextMonthlyQuestResetTime'),
-(20008,0,'NextDailyQuestResetTime');
-/*!40000 ALTER TABLE `worldstates` ENABLE KEYS */;
+LOCK TABLES `world_variable` WRITE;
+/*!40000 ALTER TABLE `world_variable` DISABLE KEYS */;
+INSERT INTO `world_variable` VALUES
+('NextCurrencyResetTime',0),
+('NextWeeklyQuestResetTime',0),
+('NextBGRandomDailyResetTime',0),
+('PersistentCharacterCleanFlags',0),
+('NextGuildDailyResetTime',0),
+('NextMonthlyQuestResetTime',0),
+('NextDailyQuestResetTime',0),
+('NextOldCalendarEventDeletionTime',0),
+('NextGuildWeeklyResetTime',0);
+/*!40000 ALTER TABLE `world_variable` ENABLE KEYS */;
 UNLOCK TABLES;
 
 --