aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql17
-rw-r--r--sql/base/characters_database.sql5
-rw-r--r--sql/base/dev/world_database.sql2
-rw-r--r--sql/old/3.3.5a/auth/21121_2022_01_15/2021_12_16_00_auth.sql (renamed from sql/updates/auth/3.3.5/2021_12_16_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/auth/21121_2022_01_15/2022_01_01_00_auth.sql (renamed from sql/updates/auth/3.3.5/2022_01_01_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/characters/21121_2022_01_15/2021_12_16_00_characters.sql (renamed from sql/updates/characters/3.3.5/2021_12_16_00_characters.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_16_01_world.sql (renamed from sql/updates/world/3.3.5/2021_12_16_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_00_world.sql (renamed from sql/updates/world/3.3.5/2021_12_18_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_01_world.sql (renamed from sql/updates/world/3.3.5/2021_12_18_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_02_world.sql (renamed from sql/updates/world/3.3.5/2021_12_18_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_18_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_04_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_18_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_05_world.sql (renamed from sql/updates/world/3.3.5/2021_12_18_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_06_world.sql (renamed from sql/updates/world/3.3.5/2021_12_18_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_07_world.sql (renamed from sql/updates/world/3.3.5/2021_12_18_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_08_world.sql (renamed from sql/updates/world/3.3.5/2021_12_18_08_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_09_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_18_09_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_10_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_18_10_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_11_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_18_11_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_12_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_18_12_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_20_00_world.sql (renamed from sql/updates/world/3.3.5/2021_12_20_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_20_01_world.sql (renamed from sql/updates/world/3.3.5/2021_12_20_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_00_world.sql (renamed from sql/updates/world/3.3.5/2021_12_22_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_04_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_05_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_05_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_06_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_06_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_07_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_07_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_08_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_08_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_09_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_09_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_10_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_10_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_11_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_11_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_12_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_22_12_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_13_world.sql (renamed from sql/updates/world/3.3.5/2021_12_22_13_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_23_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_01_world.sql (renamed from sql/updates/world/3.3.5/2021_12_23_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_02_world.sql (renamed from sql/updates/world/3.3.5/2021_12_23_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_04_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_05_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_05_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_06_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_06_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_07_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_07_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_08_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_08_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_09_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_09_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_10_world_335.sql (renamed from sql/updates/world/3.3.5/2021_12_26_10_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_02_00_world_335.sql (renamed from sql/updates/world/3.3.5/2022_01_02_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_00_world_335.sql (renamed from sql/updates/world/3.3.5/2022_01_07_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_07_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_02_world.sql (renamed from sql/updates/world/3.3.5/2022_01_07_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_00_world_335.sql (renamed from sql/updates/world/3.3.5/2022_01_12_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_01_world_335.sql (renamed from sql/updates/world/3.3.5/2022_01_12_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_02_world.sql (renamed from sql/updates/world/3.3.5/2022_01_12_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_03_world.sql (renamed from sql/updates/world/3.3.5/2022_01_12_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_04_world.sql (renamed from sql/updates/world/3.3.5/2022_01_12_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_05_world.sql (renamed from sql/updates/world/3.3.5/2022_01_12_05_world.sql)0
-rw-r--r--sql/updates/auth/3.3.5/2022_01_15_00_auth.sql2
-rw-r--r--sql/updates/characters/3.3.5/2022_01_15_00_characters.sql2
-rw-r--r--sql/updates/world/3.3.5/2022_01_15_00_world.sql3
63 files changed, 20 insertions, 11 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 0c3e4cd9993..9c59ebd7291 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -176,12 +176,12 @@ CREATE TABLE `build_info` (
`majorVersion` int DEFAULT NULL,
`minorVersion` int DEFAULT NULL,
`bugfixVersion` int DEFAULT NULL,
- `hotfixVersion` char(3) DEFAULT NULL,
- `winAuthSeed` varchar(32) DEFAULT NULL,
- `win64AuthSeed` varchar(32) DEFAULT NULL,
- `mac64AuthSeed` varchar(32) DEFAULT NULL,
- `winChecksumSeed` varchar(40) DEFAULT NULL,
- `macChecksumSeed` varchar(40) DEFAULT NULL,
+ `hotfixVersion` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `winAuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `win64AuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `mac64AuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `winChecksumSeed` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `macChecksumSeed` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`build`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1997,7 +1997,8 @@ INSERT INTO `updates` VALUES
('2021_10_15_00_auth.sql','4FFD29A3ED1DB13874E755A84BFD7ABA2DF5C2DB','ARCHIVED','2021-10-15 08:43:41',0),
('2021_11_15_00_auth.sql','82D88B06301130C7149E21A991364F62279E219B','ARCHIVED','2021-11-15 16:22:37',0),
('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0),
-('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','RELEASED','2022-01-01 19:35:19',0);
+('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','ARCHIVED','2022-01-01 19:35:19',0),
+('2022_01_15_00_auth.sql','A2123CEC10327ECA4C92A8B2212AEE25B43C457B','ARCHIVED','2022-01-15 18:05:55',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2136,4 +2137,4 @@ SET character_set_client = @saved_cs_client;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-12-16 21:17:13
+-- Dump completed on 2022-01-15 18:05:58
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index e9b9f6336d0..5a3b41b5b25 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2670,7 +2670,8 @@ INSERT INTO `updates` VALUES
('2021_09_28_00_characters.sql','A57869AE14FFFA935AB57318F65F4F1217AA2421','ARCHIVED','2021-09-28 20:48:10',0),
('2021_10_15_00_characters.sql','174355CFEA8FADA50B731F54E028561AFCF46AA6','ARCHIVED','2021-10-15 08:43:41',0),
('2021_11_15_00_characters.sql','4C911C08E2E7A22E9A2FFC0AAC05481574D8048E','ARCHIVED','2021-11-15 16:22:37',0),
-('2021_12_16_00_characters.sql','C250DF213B43FC2186520C3901C0A1FBF522BBDF','ARCHIVED','2021-12-16 21:17:10',0);
+('2021_12_16_00_characters.sql','C250DF213B43FC2186520C3901C0A1FBF522BBDF','ARCHIVED','2021-12-16 21:17:10',0),
+('2022_01_15_00_characters.sql','351DEB60A6BB87FD9ED5D097E15ADBC32424C58A','ARCHIVED','2022-01-15 18:05:55',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2841,4 +2842,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-12-16 21:17:13
+-- Dump completed on 2022-01-15 18:05:59
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 34fb622d83e..2b7e24268a1 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -4061,4 +4061,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-12-16 21:17:15
+-- Dump completed on 2022-01-15 18:06:00
diff --git a/sql/updates/auth/3.3.5/2021_12_16_00_auth.sql b/sql/old/3.3.5a/auth/21121_2022_01_15/2021_12_16_00_auth.sql
index be51c4501d9..be51c4501d9 100644
--- a/sql/updates/auth/3.3.5/2021_12_16_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21121_2022_01_15/2021_12_16_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2022_01_01_00_auth.sql b/sql/old/3.3.5a/auth/21121_2022_01_15/2022_01_01_00_auth.sql
index cea9e9580b9..cea9e9580b9 100644
--- a/sql/updates/auth/3.3.5/2022_01_01_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21121_2022_01_15/2022_01_01_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2021_12_16_00_characters.sql b/sql/old/3.3.5a/characters/21121_2022_01_15/2021_12_16_00_characters.sql
index 9a5bcd39ffe..9a5bcd39ffe 100644
--- a/sql/updates/characters/3.3.5/2021_12_16_00_characters.sql
+++ b/sql/old/3.3.5a/characters/21121_2022_01_15/2021_12_16_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2021_12_16_01_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_16_01_world.sql
index b099c720c6f..b099c720c6f 100644
--- a/sql/updates/world/3.3.5/2021_12_16_01_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_16_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_00_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_00_world.sql
index 0e16f2c77ea..0e16f2c77ea 100644
--- a/sql/updates/world/3.3.5/2021_12_18_00_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_01_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_01_world.sql
index 78c9f2f965d..78c9f2f965d 100644
--- a/sql/updates/world/3.3.5/2021_12_18_01_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_02_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_02_world.sql
index 33946aff283..33946aff283 100644
--- a/sql/updates/world/3.3.5/2021_12_18_02_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_03_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_03_world_335.sql
index 67df00a937a..67df00a937a 100644
--- a/sql/updates/world/3.3.5/2021_12_18_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_04_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_04_world_335.sql
index 1922d28d557..1922d28d557 100644
--- a/sql/updates/world/3.3.5/2021_12_18_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_05_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_05_world.sql
index 63eb6789f1b..63eb6789f1b 100644
--- a/sql/updates/world/3.3.5/2021_12_18_05_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_05_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_06_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_06_world.sql
index 5703b5754b0..5703b5754b0 100644
--- a/sql/updates/world/3.3.5/2021_12_18_06_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_06_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_07_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_07_world.sql
index 331e85a4b89..331e85a4b89 100644
--- a/sql/updates/world/3.3.5/2021_12_18_07_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_07_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_08_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_08_world.sql
index 0c1561926b4..0c1561926b4 100644
--- a/sql/updates/world/3.3.5/2021_12_18_08_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_08_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_09_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_09_world_335.sql
index 5ddd9cf7ff5..5ddd9cf7ff5 100644
--- a/sql/updates/world/3.3.5/2021_12_18_09_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_09_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_10_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_10_world_335.sql
index 6b35965853c..6b35965853c 100644
--- a/sql/updates/world/3.3.5/2021_12_18_10_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_10_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_11_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_11_world_335.sql
index 08496ddefbe..08496ddefbe 100644
--- a/sql/updates/world/3.3.5/2021_12_18_11_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_11_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_18_12_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_12_world_335.sql
index 73818106f38..73818106f38 100644
--- a/sql/updates/world/3.3.5/2021_12_18_12_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_18_12_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_20_00_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_20_00_world.sql
index 76b1a514033..76b1a514033 100644
--- a/sql/updates/world/3.3.5/2021_12_20_00_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_20_01_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_20_01_world.sql
index 0da339500b3..0da339500b3 100644
--- a/sql/updates/world/3.3.5/2021_12_20_01_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_20_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_00_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_00_world.sql
index 0ee873bad04..0ee873bad04 100644
--- a/sql/updates/world/3.3.5/2021_12_22_00_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_01_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_01_world_335.sql
index 867ca6e34ef..867ca6e34ef 100644
--- a/sql/updates/world/3.3.5/2021_12_22_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_02_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_02_world_335.sql
index a1b2438c1b5..a1b2438c1b5 100644
--- a/sql/updates/world/3.3.5/2021_12_22_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_03_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_03_world_335.sql
index d4d3d672cc9..d4d3d672cc9 100644
--- a/sql/updates/world/3.3.5/2021_12_22_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_04_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_04_world_335.sql
index 60c3dfe7f3a..60c3dfe7f3a 100644
--- a/sql/updates/world/3.3.5/2021_12_22_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_05_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_05_world_335.sql
index f131949e671..f131949e671 100644
--- a/sql/updates/world/3.3.5/2021_12_22_05_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_06_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_06_world_335.sql
index 8c92b09c4c7..8c92b09c4c7 100644
--- a/sql/updates/world/3.3.5/2021_12_22_06_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_06_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_07_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_07_world_335.sql
index e28a683f72f..e28a683f72f 100644
--- a/sql/updates/world/3.3.5/2021_12_22_07_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_07_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_08_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_08_world_335.sql
index 4212c899a76..4212c899a76 100644
--- a/sql/updates/world/3.3.5/2021_12_22_08_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_08_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_09_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_09_world_335.sql
index 6ab5d279fe3..6ab5d279fe3 100644
--- a/sql/updates/world/3.3.5/2021_12_22_09_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_09_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_10_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_10_world_335.sql
index c3a5a6ec7d1..c3a5a6ec7d1 100644
--- a/sql/updates/world/3.3.5/2021_12_22_10_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_10_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_11_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_11_world_335.sql
index 7482d8fb812..7482d8fb812 100644
--- a/sql/updates/world/3.3.5/2021_12_22_11_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_11_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_12_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_12_world_335.sql
index c15242b3b2b..c15242b3b2b 100644
--- a/sql/updates/world/3.3.5/2021_12_22_12_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_12_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_22_13_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_13_world.sql
index a61963d460d..a61963d460d 100644
--- a/sql/updates/world/3.3.5/2021_12_22_13_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_22_13_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_23_00_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_00_world_335.sql
index d6cb094bd2f..d6cb094bd2f 100644
--- a/sql/updates/world/3.3.5/2021_12_23_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_23_01_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_01_world.sql
index fe90e7ff0f4..fe90e7ff0f4 100644
--- a/sql/updates/world/3.3.5/2021_12_23_01_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_23_02_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_02_world.sql
index 23b192c9643..23b192c9643 100644
--- a/sql/updates/world/3.3.5/2021_12_23_02_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_23_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_00_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_00_world_335.sql
index c93b3b424dd..c93b3b424dd 100644
--- a/sql/updates/world/3.3.5/2021_12_26_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_01_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_01_world_335.sql
index f42a258a11c..f42a258a11c 100644
--- a/sql/updates/world/3.3.5/2021_12_26_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_02_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_02_world_335.sql
index dcc65453e1f..dcc65453e1f 100644
--- a/sql/updates/world/3.3.5/2021_12_26_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_03_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_03_world_335.sql
index 4a9ad4e6778..4a9ad4e6778 100644
--- a/sql/updates/world/3.3.5/2021_12_26_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_04_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_04_world_335.sql
index 28b72ec4a4b..28b72ec4a4b 100644
--- a/sql/updates/world/3.3.5/2021_12_26_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_05_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_05_world_335.sql
index 001b38d52ff..001b38d52ff 100644
--- a/sql/updates/world/3.3.5/2021_12_26_05_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_06_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_06_world_335.sql
index 26f2554676b..26f2554676b 100644
--- a/sql/updates/world/3.3.5/2021_12_26_06_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_06_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_07_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_07_world_335.sql
index 3a285801c8d..3a285801c8d 100644
--- a/sql/updates/world/3.3.5/2021_12_26_07_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_07_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_08_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_08_world_335.sql
index a69d5ea4f3e..a69d5ea4f3e 100644
--- a/sql/updates/world/3.3.5/2021_12_26_08_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_08_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_09_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_09_world_335.sql
index daea10d4fba..daea10d4fba 100644
--- a/sql/updates/world/3.3.5/2021_12_26_09_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_09_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_12_26_10_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_10_world_335.sql
index 911109f34c7..911109f34c7 100644
--- a/sql/updates/world/3.3.5/2021_12_26_10_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2021_12_26_10_world_335.sql
diff --git a/sql/updates/world/3.3.5/2022_01_02_00_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_02_00_world_335.sql
index 459ec3e4824..459ec3e4824 100644
--- a/sql/updates/world/3.3.5/2022_01_02_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_02_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2022_01_07_00_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_00_world_335.sql
index f34f6d92b08..f34f6d92b08 100644
--- a/sql/updates/world/3.3.5/2022_01_07_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2022_01_07_01_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_01_world.sql
index b15f4d4bb9e..b15f4d4bb9e 100644
--- a/sql/updates/world/3.3.5/2022_01_07_01_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_07_02_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_02_world.sql
index 382c279cbd9..382c279cbd9 100644
--- a/sql/updates/world/3.3.5/2022_01_07_02_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_07_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_12_00_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_00_world_335.sql
index 0e6c433189c..0e6c433189c 100644
--- a/sql/updates/world/3.3.5/2022_01_12_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2022_01_12_01_world_335.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_01_world_335.sql
index 60af94bbde7..60af94bbde7 100644
--- a/sql/updates/world/3.3.5/2022_01_12_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2022_01_12_02_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_02_world.sql
index 7fb0fe798b4..7fb0fe798b4 100644
--- a/sql/updates/world/3.3.5/2022_01_12_02_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_12_03_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_03_world.sql
index 2fc2fefd3a9..2fc2fefd3a9 100644
--- a/sql/updates/world/3.3.5/2022_01_12_03_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_12_04_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_04_world.sql
index 142f6e1ac67..142f6e1ac67 100644
--- a/sql/updates/world/3.3.5/2022_01_12_04_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_04_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_12_05_world.sql b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_05_world.sql
index 096237d5154..096237d5154 100644
--- a/sql/updates/world/3.3.5/2022_01_12_05_world.sql
+++ b/sql/old/3.3.5a/world/21121_2022_01_15/2022_01_12_05_world.sql
diff --git a/sql/updates/auth/3.3.5/2022_01_15_00_auth.sql b/sql/updates/auth/3.3.5/2022_01_15_00_auth.sql
new file mode 100644
index 00000000000..8bff20717e3
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2022_01_15_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.22011 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2022_01_15_00_characters.sql b/sql/updates/characters/3.3.5/2022_01_15_00_characters.sql
new file mode 100644
index 00000000000..b2177772ff9
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2022_01_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.22011 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2022_01_15_00_world.sql b/sql/updates/world/3.3.5/2022_01_15_00_world.sql
new file mode 100644
index 00000000000..e3136864532
--- /dev/null
+++ b/sql/updates/world/3.3.5/2022_01_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.22011 world
+UPDATE `version` SET `db_version`='TDB 335.22011', `cache_id`=22011 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';