TDB 335.20011 - 2020/01/15TDB335.20011

73 files changed, 16 insertions, 6 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 9b9e654bee5..161dbc92af9 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -9,7 +9,7 @@
  #define _SOURCE_DIRECTORY          R"(@CMAKE_SOURCE_DIR@)"
  #define _BUILD_DIRECTORY           R"(@BUILDDIR@)"
  #define _MYSQL_EXECUTABLE          R"(@MYSQL_EXECUTABLE@)"
- #define _FULL_DATABASE             "TDB_full_world_335.19121_2019_12_15.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.20011_2020_01_15.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-2019 TrinityCore"
  #define VER_FILEVERSION            0,0,0
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 55cf1e1f180..44d7229b1c7 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1954,7 +1954,8 @@ INSERT INTO `updates` VALUES
 ('2019_10_18_00_auth.sql','DFEDA33D7B9A108773B6AD8DE3016C6B12BD3832','ARCHIVED','2019-10-18 08:37:37',0),
 ('2019_11_16_00_auth.sql','A7CC55B9329F0DDFE91ADC31BFABD0D934ED0A5E','ARCHIVED','2019-11-16 12:06:06',0),
 ('2019_12_07_00_auth.sql','F354DA31D5B300609C6AE8A25667CA4DE0A7349F','ARCHIVED','2019-12-07 12:57:23',0),
-('2019_12_15_00_auth.sql','62CFB68A53F73E875B1104F0D0BAC81145090524','ARCHIVED','2019-12-15 18:26:21',0);
+('2019_12_15_00_auth.sql','62CFB68A53F73E875B1104F0D0BAC81145090524','ARCHIVED','2019-12-15 18:26:21',0),
+('2020_01_15_00_auth.sql','D486C0CEF68FDE5122E835128A1F663E0E72A21E','ARCHIVED','2020-01-15 07:45:18',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2056,4 +2057,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 2019-12-15 18:26:22
+-- Dump completed on 2020-01-15  7:45:19
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 9bdbae14d6e..80a0a678104 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2640,7 +2640,8 @@ INSERT INTO `updates` VALUES
 ('2019_09_15_00_characters.sql','75F3355AF6E9C0A2CAF5F523D87208C726C9D042','ARCHIVED','2019-09-15 09:21:36',0),
 ('2019_10_18_00_characters.sql','143669FB0AA803C7287A4FF4ABE85F45F63369E5','ARCHIVED','2019-10-18 08:37:37',0),
 ('2019_11_16_00_characters.sql','F29BBE2869E2187B278B27236A3D156B849F0E43','ARCHIVED','2019-11-16 12:06:06',0),
-('2019_12_15_00_characters.sql','2EE449B59D56F884796B5D43C89B7C73DBF53939','ARCHIVED','2019-12-15 18:26:21',0);
+('2019_12_15_00_characters.sql','2EE449B59D56F884796B5D43C89B7C73DBF53939','ARCHIVED','2019-12-15 18:26:21',0),
+('2020_01_15_00_characters.sql','CCA31041B25FC4BD631D07BB2E42B3C8F32465F0','ARCHIVED','2020-01-15 07:45:18',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2807,4 +2808,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-12-15 18:26:22
+-- Dump completed on 2020-01-15  7:45:20
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 77fb41a6b72..a99895c7c28 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1455,6 +1455,7 @@ CREATE TABLE `holiday_dates` (
   `id` int(10) unsigned NOT NULL,
   `date_id` tinyint(3) unsigned NOT NULL,
   `date_value` int(10) unsigned NOT NULL,
+  `holiday_duration` int(10) unsigned NOT NULL,
   PRIMARY KEY (`id`,`date_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3843,4 +3844,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-12-15 18:26:23
+-- Dump completed on 2020-01-15  7:45:20
diff --git a/sql/updates/auth/3.3.5/2019_12_15_00_auth.sql b/sql/old/3.3.5a/auth/19121_2020_01_15/2019_12_15_00_auth.sql
index fb97fbb27cd..fb97fbb27cd 100644
--- a/sql/updates/auth/3.3.5/2019_12_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19121_2020_01_15/2019_12_15_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2019_12_15_00_characters.sql b/sql/old/3.3.5a/characters/19121_2020_01_15/2019_12_15_00_characters.sql
index b83025b8509..b83025b8509 100644
--- a/sql/updates/characters/3.3.5/2019_12_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/19121_2020_01_15/2019_12_15_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2019_12_15_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_15_02_world.sql
index e04e330e3b4..e04e330e3b4 100644
--- a/sql/updates/world/3.3.5/2019_12_15_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_15_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_16_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_16_00_world.sql
index cdbcfcdb312..cdbcfcdb312 100644
--- a/sql/updates/world/3.3.5/2019_12_16_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_16_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_16_01_world.sql
index a4bd583daab..a4bd583daab 100644
--- a/sql/updates/world/3.3.5/2019_12_16_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_16_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_18_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_18_00_world.sql
index 67c11a06523..67c11a06523 100644
--- a/sql/updates/world/3.3.5/2019_12_18_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_18_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_18_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_18_01_world.sql
index d78228a42cc..d78228a42cc 100644
--- a/sql/updates/world/3.3.5/2019_12_18_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_18_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_19_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_00_world.sql
index deaa251dc65..deaa251dc65 100644
--- a/sql/updates/world/3.3.5/2019_12_19_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_19_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_01_world.sql
index 8d38d7ae005..8d38d7ae005 100644
--- a/sql/updates/world/3.3.5/2019_12_19_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_19_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_02_world.sql
index 1cc5ee5eeb8..1cc5ee5eeb8 100644
--- a/sql/updates/world/3.3.5/2019_12_19_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_19_03_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_03_world.sql
index 5977bfe86ff..5977bfe86ff 100644
--- a/sql/updates/world/3.3.5/2019_12_19_03_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_19_04_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_04_world.sql
index 6fa630eed21..6fa630eed21 100644
--- a/sql/updates/world/3.3.5/2019_12_19_04_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_19_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_20_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_20_00_world.sql
index f22cdf6c153..f22cdf6c153 100644
--- a/sql/updates/world/3.3.5/2019_12_20_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_20_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_20_01_world.sql
index 7f8d97fa5db..7f8d97fa5db 100644
--- a/sql/updates/world/3.3.5/2019_12_20_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_20_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_21_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_21_00_world.sql
index 288d75a4596..288d75a4596 100644
--- a/sql/updates/world/3.3.5/2019_12_21_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_21_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_21_01_world.sql
index 2594ef9fd54..2594ef9fd54 100644
--- a/sql/updates/world/3.3.5/2019_12_21_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_21_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_22_00_world_335.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_00_world_335.sql
index 1a8767a95d8..1a8767a95d8 100644
--- a/sql/updates/world/3.3.5/2019_12_22_00_world_335.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_12_22_01_world_335.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_01_world_335.sql
index 25bd781d8f0..25bd781d8f0 100644
--- a/sql/updates/world/3.3.5/2019_12_22_01_world_335.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_12_22_02_world_335.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_02_world_335.sql
index d3ccb22b5a2..d3ccb22b5a2 100644
--- a/sql/updates/world/3.3.5/2019_12_22_02_world_335.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_12_22_03_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_03_world.sql
index f8a27dfea78..f8a27dfea78 100644
--- a/sql/updates/world/3.3.5/2019_12_22_03_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_22_04_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_04_world.sql
index a7df094fe75..a7df094fe75 100644
--- a/sql/updates/world/3.3.5/2019_12_22_04_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_22_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_23_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_23_00_world.sql
index 404c187441c..404c187441c 100644
--- a/sql/updates/world/3.3.5/2019_12_23_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_23_01_world_335.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_23_01_world_335.sql
index 5c2d13d33b5..5c2d13d33b5 100644
--- a/sql/updates/world/3.3.5/2019_12_23_01_world_335.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_23_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_12_25_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_25_00_world.sql
index 071621c88e1..071621c88e1 100644
--- a/sql/updates/world/3.3.5/2019_12_25_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_25_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_25_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_25_01_world.sql
index 3b5183eea91..3b5183eea91 100644
--- a/sql/updates/world/3.3.5/2019_12_25_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_25_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_25_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_25_02_world.sql
index 398edc0580f..398edc0580f 100644
--- a/sql/updates/world/3.3.5/2019_12_25_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_25_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_26_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_26_00_world.sql
index 04ab8b791b7..04ab8b791b7 100644
--- a/sql/updates/world/3.3.5/2019_12_26_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_26_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_27_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_27_00_world.sql
index 18152fda17f..18152fda17f 100644
--- a/sql/updates/world/3.3.5/2019_12_27_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_27_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_27_01_world.sql
index 719c9f20608..719c9f20608 100644
--- a/sql/updates/world/3.3.5/2019_12_27_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_27_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_28_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_28_00_world.sql
index df6d285303a..df6d285303a 100644
--- a/sql/updates/world/3.3.5/2019_12_28_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_28_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_28_01_world.sql
index 68519239a7e..68519239a7e 100644
--- a/sql/updates/world/3.3.5/2019_12_28_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_28_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_29_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_29_00_world.sql
index 9a71b45987a..9a71b45987a 100644
--- a/sql/updates/world/3.3.5/2019_12_29_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_29_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_12_30_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_30_00_world.sql
index bb0b271b4a7..bb0b271b4a7 100644
--- a/sql/updates/world/3.3.5/2019_12_30_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2019_12_30_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_02_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_00_world.sql
index b82c1c5db35..b82c1c5db35 100644
--- a/sql/updates/world/3.3.5/2020_01_02_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_02_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_01_world.sql
index 5e0519d4500..5e0519d4500 100644
--- a/sql/updates/world/3.3.5/2020_01_02_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_02_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_02_world.sql
index fe9ff7f145c..fe9ff7f145c 100644
--- a/sql/updates/world/3.3.5/2020_01_02_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_02_03_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_03_world.sql
index cf5617d7a1b..cf5617d7a1b 100644
--- a/sql/updates/world/3.3.5/2020_01_02_03_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_02_04_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_04_world.sql
index 8e40feb844f..8e40feb844f 100644
--- a/sql/updates/world/3.3.5/2020_01_02_04_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_02_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_03_00_world_335.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_03_00_world_335.sql
index 967407f0bab..967407f0bab 100644
--- a/sql/updates/world/3.3.5/2020_01_03_00_world_335.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_03_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_01_03_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_03_01_world.sql
index db15abb5b04..db15abb5b04 100644
--- a/sql/updates/world/3.3.5/2020_01_03_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_03_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_03_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_03_02_world.sql
index e9275e6585c..e9275e6585c 100644
--- a/sql/updates/world/3.3.5/2020_01_03_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_03_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_03_03_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_03_03_world.sql
index d22b813fa24..d22b813fa24 100644
--- a/sql/updates/world/3.3.5/2020_01_03_03_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_03_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_04_00_world_335.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_04_00_world_335.sql
index 810bf21b17f..810bf21b17f 100644
--- a/sql/updates/world/3.3.5/2020_01_04_00_world_335.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_04_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_01_05_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_05_00_world.sql
index 171fdb58540..171fdb58540 100644
--- a/sql/updates/world/3.3.5/2020_01_05_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_05_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_05_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_05_01_world.sql
index 4c058ebdd66..4c058ebdd66 100644
--- a/sql/updates/world/3.3.5/2020_01_05_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_05_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_05_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_05_02_world.sql
index ece2ad335a8..ece2ad335a8 100644
--- a/sql/updates/world/3.3.5/2020_01_05_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_05_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_06_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_06_00_world.sql
index 937608a7fba..937608a7fba 100644
--- a/sql/updates/world/3.3.5/2020_01_06_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_06_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_06_01_world.sql
index 5e8402f4a79..5e8402f4a79 100644
--- a/sql/updates/world/3.3.5/2020_01_06_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_06_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_06_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_06_02_world.sql
index 1ad3d23f4cd..1ad3d23f4cd 100644
--- a/sql/updates/world/3.3.5/2020_01_06_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_06_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_07_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_07_00_world.sql
index 1b56b54f68a..1b56b54f68a 100644
--- a/sql/updates/world/3.3.5/2020_01_07_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_07_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_07_01_world.sql
index fad14bf814f..fad14bf814f 100644
--- a/sql/updates/world/3.3.5/2020_01_07_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_08_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_08_00_world.sql
index 069609e20ce..069609e20ce 100644
--- a/sql/updates/world/3.3.5/2020_01_08_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_08_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_08_01_world.sql
index 5ee388eebc6..5ee388eebc6 100644
--- a/sql/updates/world/3.3.5/2020_01_08_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_08_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_08_02_world.sql
index 80607647225..80607647225 100644
--- a/sql/updates/world/3.3.5/2020_01_08_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_08_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_09_00_world_335.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_00_world_335.sql
index 03e809644f2..03e809644f2 100644
--- a/sql/updates/world/3.3.5/2020_01_09_00_world_335.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_01_09_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_01_world.sql
index f4b5a8ed809..f4b5a8ed809 100644
--- a/sql/updates/world/3.3.5/2020_01_09_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_09_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_02_world.sql
index 72ad96f6a66..72ad96f6a66 100644
--- a/sql/updates/world/3.3.5/2020_01_09_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_09_03_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_03_world.sql
index 8ae57bbf0c0..8ae57bbf0c0 100644
--- a/sql/updates/world/3.3.5/2020_01_09_03_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_09_04_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_04_world.sql
index a27cb4548af..a27cb4548af 100644
--- a/sql/updates/world/3.3.5/2020_01_09_04_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_09_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_11_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_11_00_world.sql
index 62c271ad054..62c271ad054 100644
--- a/sql/updates/world/3.3.5/2020_01_11_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_11_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_12_00_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_00_world.sql
index 1e9f89d9678..1e9f89d9678 100644
--- a/sql/updates/world/3.3.5/2020_01_12_00_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_12_01_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_01_world.sql
index 3e4c1a3bb80..3e4c1a3bb80 100644
--- a/sql/updates/world/3.3.5/2020_01_12_01_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_12_02_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_02_world.sql
index 0b5b0239749..0b5b0239749 100644
--- a/sql/updates/world/3.3.5/2020_01_12_02_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_12_03_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_03_world.sql
index 798b3af845b..798b3af845b 100644
--- a/sql/updates/world/3.3.5/2020_01_12_03_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_12_04_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_04_world.sql
index cf68e4def66..cf68e4def66 100644
--- a/sql/updates/world/3.3.5/2020_01_12_04_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_01_12_05_world.sql b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_05_world.sql
index 6ad68b192da..6ad68b192da 100644
--- a/sql/updates/world/3.3.5/2020_01_12_05_world.sql
+++ b/sql/old/3.3.5a/world/19121_2020_01_15/2020_01_12_05_world.sql
diff --git a/sql/updates/auth/3.3.5/2020_01_15_00_auth.sql b/sql/updates/auth/3.3.5/2020_01_15_00_auth.sql
new file mode 100644
index 00000000000..f8d75b118c1
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2020_01_15_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20011 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2020_01_15_00_characters.sql b/sql/updates/characters/3.3.5/2020_01_15_00_characters.sql
new file mode 100644
index 00000000000..64255fa846d
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2020_01_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20011 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2020_01_15_00_world.sql b/sql/updates/world/3.3.5/2020_01_15_00_world.sql
new file mode 100644
index 00000000000..510279f2f5e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_01_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.20011 world
+UPDATE `version` SET `db_version`='TDB 335.20011', `cache_id`=20011 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';