TDB 335.20031 - 2020/03/16TDB335.20031

81 files changed, 22 insertions, 13 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index e7e73979332..09e4344c692 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.20021_2020_02_15.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.20031_2020_03_16.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 879fd7871df..a35e1412c32 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 5.7.25, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.7.29, for Linux (x86_64)
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	5.7.25-0ubuntu0.16.04.2
+-- Server version	5.7.29-0ubuntu0.18.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -1956,7 +1956,8 @@ INSERT INTO `updates` VALUES
 ('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),
 ('2020_01_15_00_auth.sql','D486C0CEF68FDE5122E835128A1F663E0E72A21E','ARCHIVED','2020-01-15 07:45:18',0),
-('2020_02_15_00_auth.sql','9CDBEBC722BEBB7C93091CF16EEB9C922C4116BD','ARCHIVED','2020-02-15 17:36:05',0);
+('2020_02_15_00_auth.sql','9CDBEBC722BEBB7C93091CF16EEB9C922C4116BD','ARCHIVED','2020-02-15 17:36:05',0),
+('2020_03_16_00_auth.sql','B27E4CE14C713C73216930A7F3F770786D902A3F','ARCHIVED','2020-03-16 08:47:49',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2058,4 +2059,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 2020-02-15 17:36:06
+-- Dump completed on 2020-03-16  8:47:50
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 063430cf421..27c0e8fc8e9 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 5.7.25, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.7.29, for Linux (x86_64)
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	5.7.25-0ubuntu0.16.04.2
+-- Server version	5.7.29-0ubuntu0.18.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2642,7 +2642,8 @@ INSERT INTO `updates` VALUES
 ('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),
 ('2020_01_15_00_characters.sql','CCA31041B25FC4BD631D07BB2E42B3C8F32465F0','ARCHIVED','2020-01-15 07:45:18',0),
-('2020_02_15_00_characters.sql','645EDA60CDD479B3D1E78D2D89DAB5D6EA1FB7BC','ARCHIVED','2020-02-15 17:36:05',0);
+('2020_02_15_00_characters.sql','645EDA60CDD479B3D1E78D2D89DAB5D6EA1FB7BC','ARCHIVED','2020-02-15 17:36:05',0),
+('2020_03_16_00_characters.sql','A38437DA80F6A5D35958A09CFC74EE1CDC465BA8','ARCHIVED','2020-03-16 08:47:49',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2809,4 +2810,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-02-15 17:36:06
+-- Dump completed on 2020-03-16  8:47:50
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index cafd81daf8d..9d57b264b90 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 5.7.25, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.7.29, for Linux (x86_64)
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	5.7.25-0ubuntu0.16.04.2
+-- Server version	5.7.29-0ubuntu0.18.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -320,7 +320,7 @@ CREATE TABLE `creature` (
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
   `spawntimesecs` int(10) unsigned NOT NULL DEFAULT '120',
-  `spawndist` float NOT NULL DEFAULT '0',
+  `wander_distance` float NOT NULL DEFAULT '0',
   `currentwaypoint` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `curhealth` int(10) unsigned NOT NULL DEFAULT '1',
   `curmana` int(10) unsigned NOT NULL DEFAULT '0',
@@ -3863,4 +3863,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-02-15 17:36:07
+-- Dump completed on 2020-03-16  8:47:51
diff --git a/sql/updates/auth/3.3.5/2020_02_15_00_auth.sql b/sql/old/3.3.5a/auth/20021_2020_03_16/2020_02_15_00_auth.sql
index f4fd84024f0..f4fd84024f0 100644
--- a/sql/updates/auth/3.3.5/2020_02_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/20021_2020_03_16/2020_02_15_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2020_02_15_00_characters.sql b/sql/old/3.3.5a/characters/20021_2020_03_16/2020_02_15_00_characters.sql
index d9b37cb4c4c..d9b37cb4c4c 100644
--- a/sql/updates/characters/3.3.5/2020_02_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/20021_2020_03_16/2020_02_15_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2020_02_15_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_15_00_world.sql
index c0a41c363ce..c0a41c363ce 100644
--- a/sql/updates/world/3.3.5/2020_02_15_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_15_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_15_01_world.sql
index 3a758fa3d20..3a758fa3d20 100644
--- a/sql/updates/world/3.3.5/2020_02_15_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_15_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_15_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_15_02_world.sql
index e061958df1d..e061958df1d 100644
--- a/sql/updates/world/3.3.5/2020_02_15_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_15_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_00_world_335.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_00_world_335.sql
index bc836d3804b..bc836d3804b 100644
--- a/sql/updates/world/3.3.5/2020_02_16_00_world_335.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_01_world.sql
index 9252ade8290..9252ade8290 100644
--- a/sql/updates/world/3.3.5/2020_02_16_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_02_world.sql
index a7c1191855d..a7c1191855d 100644
--- a/sql/updates/world/3.3.5/2020_02_16_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_03_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_03_world.sql
index 1a9a113a360..1a9a113a360 100644
--- a/sql/updates/world/3.3.5/2020_02_16_03_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_04_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_04_world.sql
index 7aafe0e21d9..7aafe0e21d9 100644
--- a/sql/updates/world/3.3.5/2020_02_16_04_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_05_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_05_world.sql
index 55562cb843f..55562cb843f 100644
--- a/sql/updates/world/3.3.5/2020_02_16_05_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_05_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_06_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_06_world.sql
index a517a06bdc6..a517a06bdc6 100644
--- a/sql/updates/world/3.3.5/2020_02_16_06_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_06_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_07_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_07_world.sql
index 68e09498b32..68e09498b32 100644
--- a/sql/updates/world/3.3.5/2020_02_16_07_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_07_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_16_08_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_08_world.sql
index a2d5c41ef66..a2d5c41ef66 100644
--- a/sql/updates/world/3.3.5/2020_02_16_08_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_16_08_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_17_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_17_00_world.sql
index 80fa61c508e..80fa61c508e 100644
--- a/sql/updates/world/3.3.5/2020_02_17_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_17_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_17_01_world.sql
index 52888edb6e2..52888edb6e2 100644
--- a/sql/updates/world/3.3.5/2020_02_17_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_17_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_17_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_17_02_world.sql
index d5525276ce1..d5525276ce1 100644
--- a/sql/updates/world/3.3.5/2020_02_17_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_17_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_17_03_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_17_03_world.sql
index 4e93ba887d8..4e93ba887d8 100644
--- a/sql/updates/world/3.3.5/2020_02_17_03_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_17_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_18_00_world_335.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_18_00_world_335.sql
index 005caa642a6..005caa642a6 100644
--- a/sql/updates/world/3.3.5/2020_02_18_00_world_335.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_18_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_02_18_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_18_01_world.sql
index ca5bd8bda54..ca5bd8bda54 100644
--- a/sql/updates/world/3.3.5/2020_02_18_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_18_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_18_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_18_02_world.sql
index 1f8d916045b..1f8d916045b 100644
--- a/sql/updates/world/3.3.5/2020_02_18_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_18_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_19_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_19_00_world.sql
index f5761434331..f5761434331 100644
--- a/sql/updates/world/3.3.5/2020_02_19_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_19_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_19_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_19_01_world.sql
index 3ba3df23e62..3ba3df23e62 100644
--- a/sql/updates/world/3.3.5/2020_02_19_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_19_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_21_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_21_00_world.sql
index 78c77433ec6..78c77433ec6 100644
--- a/sql/updates/world/3.3.5/2020_02_21_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_21_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_21_01_world.sql
index 6e2ec655157..6e2ec655157 100644
--- a/sql/updates/world/3.3.5/2020_02_21_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_21_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_21_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_21_02_world.sql
index e9f31cf982b..e9f31cf982b 100644
--- a/sql/updates/world/3.3.5/2020_02_21_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_21_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_22_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_22_00_world.sql
index 92239df23ed..92239df23ed 100644
--- a/sql/updates/world/3.3.5/2020_02_22_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_23_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_23_00_world.sql
index 7bbba750c76..7bbba750c76 100644
--- a/sql/updates/world/3.3.5/2020_02_23_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_25_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_25_00_world.sql
index 833dde6bb85..833dde6bb85 100644
--- a/sql/updates/world/3.3.5/2020_02_25_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_25_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_26_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_26_00_world.sql
index 82ac42a8455..82ac42a8455 100644
--- a/sql/updates/world/3.3.5/2020_02_26_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_26_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_27_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_27_00_world.sql
index e439563ad6b..e439563ad6b 100644
--- a/sql/updates/world/3.3.5/2020_02_27_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_28_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_00_world.sql
index e292cf74bde..e292cf74bde 100644
--- a/sql/updates/world/3.3.5/2020_02_28_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_28_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_01_world.sql
index c92c2abd357..c92c2abd357 100644
--- a/sql/updates/world/3.3.5/2020_02_28_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_28_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_02_world.sql
index ca0f280066e..ca0f280066e 100644
--- a/sql/updates/world/3.3.5/2020_02_28_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_28_03_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_03_world.sql
index b5f7d28f08f..b5f7d28f08f 100644
--- a/sql/updates/world/3.3.5/2020_02_28_03_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_28_04_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_04_world.sql
index 0de36ce22dd..0de36ce22dd 100644
--- a/sql/updates/world/3.3.5/2020_02_28_04_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_28_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_29_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_00_world.sql
index 5826c6c02b8..5826c6c02b8 100644
--- a/sql/updates/world/3.3.5/2020_02_29_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_29_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_01_world.sql
index 5c7893f35da..5c7893f35da 100644
--- a/sql/updates/world/3.3.5/2020_02_29_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_29_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_02_world.sql
index 6d4719382e0..6d4719382e0 100644
--- a/sql/updates/world/3.3.5/2020_02_29_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_29_03_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_03_world.sql
index 75a7693d507..75a7693d507 100644
--- a/sql/updates/world/3.3.5/2020_02_29_03_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_29_04_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_04_world.sql
index 25a28f40801..25a28f40801 100644
--- a/sql/updates/world/3.3.5/2020_02_29_04_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_02_29_05_world_335.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_05_world_335.sql
index 67f6a3f997f..67f6a3f997f 100644
--- a/sql/updates/world/3.3.5/2020_02_29_05_world_335.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_02_29_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_03_05_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_05_00_world.sql
index 4645f79b66c..4645f79b66c 100644
--- a/sql/updates/world/3.3.5/2020_03_05_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_05_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_06_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_06_00_world.sql
index d35389deb14..d35389deb14 100644
--- a/sql/updates/world/3.3.5/2020_03_06_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_06_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_06_01_world.sql
index 8c19d5fde4d..8c19d5fde4d 100644
--- a/sql/updates/world/3.3.5/2020_03_06_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_06_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_06_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_06_02_world.sql
index e9c87ba7a6a..e9c87ba7a6a 100644
--- a/sql/updates/world/3.3.5/2020_03_06_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_06_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_07_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_00_world.sql
index a54b79ed5b0..a54b79ed5b0 100644
--- a/sql/updates/world/3.3.5/2020_03_07_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_07_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_01_world.sql
index 7df5294c6cd..7df5294c6cd 100644
--- a/sql/updates/world/3.3.5/2020_03_07_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_07_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_02_world.sql
index 3a843688b24..3a843688b24 100644
--- a/sql/updates/world/3.3.5/2020_03_07_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_07_03_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_03_world.sql
index 96fad14cdd0..96fad14cdd0 100644
--- a/sql/updates/world/3.3.5/2020_03_07_03_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_07_04_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_04_world.sql
index cfe0e9da545..cfe0e9da545 100644
--- a/sql/updates/world/3.3.5/2020_03_07_04_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_07_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_08_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_08_00_world.sql
index e113d3aa8ec..e113d3aa8ec 100644
--- a/sql/updates/world/3.3.5/2020_03_08_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_08_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_08_01_world.sql
index 105e1c1e37d..105e1c1e37d 100644
--- a/sql/updates/world/3.3.5/2020_03_08_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_08_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_08_02_world.sql
index 8ecc84aa3f7..8ecc84aa3f7 100644
--- a/sql/updates/world/3.3.5/2020_03_08_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_08_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_10_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_10_00_world.sql
index 9efdc02f0d8..9efdc02f0d8 100644
--- a/sql/updates/world/3.3.5/2020_03_10_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_10_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_10_01_world.sql
index 22b5a09152d..22b5a09152d 100644
--- a/sql/updates/world/3.3.5/2020_03_10_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_10_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_13_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_13_00_world.sql
index 86ae9d5c5f8..86ae9d5c5f8 100644
--- a/sql/updates/world/3.3.5/2020_03_13_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_13_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_13_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_13_01_world.sql
index 9c4a71e6996..9c4a71e6996 100644
--- a/sql/updates/world/3.3.5/2020_03_13_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_13_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_13_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_13_02_world.sql
index d3f29bb326d..d3f29bb326d 100644
--- a/sql/updates/world/3.3.5/2020_03_13_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_13_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_14_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_00_world.sql
index 3659133a5b9..3659133a5b9 100644
--- a/sql/updates/world/3.3.5/2020_03_14_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_14_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_01_world.sql
index ef0b0d48982..ef0b0d48982 100644
--- a/sql/updates/world/3.3.5/2020_03_14_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_14_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_02_world.sql
index 98bdaf4b627..98bdaf4b627 100644
--- a/sql/updates/world/3.3.5/2020_03_14_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_14_03_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_03_world.sql
index 8114d6c8764..8114d6c8764 100644
--- a/sql/updates/world/3.3.5/2020_03_14_03_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_14_04_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_04_world.sql
index 12619940a01..12619940a01 100644
--- a/sql/updates/world/3.3.5/2020_03_14_04_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_14_05_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_05_world.sql
index 7f9b37313e1..7f9b37313e1 100644
--- a/sql/updates/world/3.3.5/2020_03_14_05_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_14_05_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_00_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_00_world.sql
index 59590cbe5b3..59590cbe5b3 100644
--- a/sql/updates/world/3.3.5/2020_03_15_00_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_01_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_01_world.sql
index 5efe02c8208..5efe02c8208 100644
--- a/sql/updates/world/3.3.5/2020_03_15_01_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_02_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_02_world.sql
index 9413d7181ae..9413d7181ae 100644
--- a/sql/updates/world/3.3.5/2020_03_15_02_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_03_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_03_world.sql
index 1fe6de1d333..1fe6de1d333 100644
--- a/sql/updates/world/3.3.5/2020_03_15_03_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_04_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_04_world.sql
index a51abbfdabd..a51abbfdabd 100644
--- a/sql/updates/world/3.3.5/2020_03_15_04_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_05_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_05_world.sql
index ec76e19c471..ec76e19c471 100644
--- a/sql/updates/world/3.3.5/2020_03_15_05_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_05_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_06_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_06_world.sql
index fca3e216ab2..fca3e216ab2 100644
--- a/sql/updates/world/3.3.5/2020_03_15_06_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_06_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_07_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_07_world.sql
index 566c0563e9d..566c0563e9d 100644
--- a/sql/updates/world/3.3.5/2020_03_15_07_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_07_world.sql
diff --git a/sql/updates/world/3.3.5/2020_03_15_08_world.sql b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_08_world.sql
index 92e4d63c7da..92e4d63c7da 100644
--- a/sql/updates/world/3.3.5/2020_03_15_08_world.sql
+++ b/sql/old/3.3.5a/world/20021_2020_03_16/2020_03_15_08_world.sql
diff --git a/sql/updates/auth/3.3.5/2020_03_16_00_auth.sql b/sql/updates/auth/3.3.5/2020_03_16_00_auth.sql
new file mode 100644
index 00000000000..8da368aabd3
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2020_03_16_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20031 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2020_03_16_00_characters.sql b/sql/updates/characters/3.3.5/2020_03_16_00_characters.sql
new file mode 100644
index 00000000000..c76a7a063b6
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2020_03_16_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20031 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2020_03_16_00_world.sql b/sql/updates/world/3.3.5/2020_03_16_00_world.sql
new file mode 100644
index 00000000000..cfdc9b5b73e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_03_16_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.20031 world
+UPDATE `version` SET `db_version`='TDB 335.20031', `cache_id`=20031 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';