TDB 335.21051 - 2021/05/14TDB335.21051

45 files changed, 20 insertions, 11 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 843bc05a772..f28e5ac087e 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 5.7.32, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.7.34, for Linux (x86_64)
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	5.7.32-0ubuntu0.18.04.1
+-- Server version	5.7.34
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -1984,7 +1984,8 @@ INSERT INTO `updates` VALUES
 ('2021_01_15_00_auth.sql','604B8B799F031C1074314D4D8081797CC8B22FE2','ARCHIVED','2021-01-15 08:29:32',0),
 ('2021_02_15_00_auth.sql','652C38A140C0B2C7E898A2F7A7AC799CA2440315','ARCHIVED','2021-02-15 12:37:46',0),
 ('2021_03_15_00_auth.sql','571D2FD6A62F066CC789C73A4ECDD613C6FF5F10','ARCHIVED','2021-03-15 17:31:39',0),
-('2021_04_16_00_auth.sql','737670762C2AE4E04BFC2C2B0B6F3C71DCDF6C44','ARCHIVED','2021-04-16 21:23:03',0);
+('2021_04_16_00_auth.sql','737670762C2AE4E04BFC2C2B0B6F3C71DCDF6C44','ARCHIVED','2021-04-16 21:23:03',0),
+('2021_05_14_00_auth.sql','B89998D90CCFEB2480838D417AC9661372A6B959','ARCHIVED','2021-05-14 12:20:33',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2090,4 +2091,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-04-16 21:23:04
+-- Dump completed on 2021-05-14 12:20:36
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 78495d11744..78393753b58 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 5.7.32, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.7.34, for Linux (x86_64)
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	5.7.32-0ubuntu0.18.04.1
+-- Server version	5.7.34
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2660,7 +2660,8 @@ INSERT INTO `updates` VALUES
 ('2021_01_15_00_characters.sql','4D3A4C71ACD4CB04B014C300E1D0B33C0699DBE7','ARCHIVED','2021-01-15 08:29:32',0),
 ('2021_02_15_00_characters.sql','53D94CFC60329E7BD036B77D4B298785AF57AD79','ARCHIVED','2021-02-15 12:37:46',0),
 ('2021_03_15_00_characters.sql','D6274D688A3E2A4F727B565481D99A49E9C642D4','ARCHIVED','2021-03-15 17:31:39',0),
-('2021_04_16_00_characters.sql','0EBBF50CE3EB1197973E403C2F1D60881BB497FD','ARCHIVED','2021-04-16 21:23:03',0);
+('2021_04_16_00_characters.sql','0EBBF50CE3EB1197973E403C2F1D60881BB497FD','ARCHIVED','2021-04-16 21:23:03',0),
+('2021_05_14_00_characters.sql','9834A657E1E1F650E9A7E4E793BAB3E2AFF65293','ARCHIVED','2021-05-14 12:20:33',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2831,4 +2832,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-04-16 21:23:04
+-- Dump completed on 2021-05-14 12:20:36
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 6a4ffa97503..267aa14c743 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.32, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.7.34, for Linux (x86_64)
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	5.7.32-0ubuntu0.18.04.1
+-- Server version	5.7.34
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -4044,4 +4044,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-04-16 21:23:05
+-- Dump completed on 2021-05-14 12:20:37
diff --git a/sql/updates/auth/3.3.5/2021_04_16_00_auth.sql b/sql/old/3.3.5a/auth/21041_2021_05_14/2021_04_16_00_auth.sql
index aca5815f15b..aca5815f15b 100644
--- a/sql/updates/auth/3.3.5/2021_04_16_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21041_2021_05_14/2021_04_16_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2021_04_16_00_characters.sql b/sql/old/3.3.5a/characters/21041_2021_05_14/2021_04_16_00_characters.sql
index 90b2469af87..90b2469af87 100644
--- a/sql/updates/characters/3.3.5/2021_04_16_00_characters.sql
+++ b/sql/old/3.3.5a/characters/21041_2021_05_14/2021_04_16_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2021_04_16_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_16_00_world.sql
index c62bf3f63d4..c62bf3f63d4 100644
--- a/sql/updates/world/3.3.5/2021_04_16_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_19_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_19_00_world.sql
index b1551245ced..b1551245ced 100644
--- a/sql/updates/world/3.3.5/2021_04_19_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_19_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_23_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_23_00_world.sql
index 11d2acc03f2..11d2acc03f2 100644
--- a/sql/updates/world/3.3.5/2021_04_23_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_25_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_25_00_world.sql
index 567676f5185..567676f5185 100644
--- a/sql/updates/world/3.3.5/2021_04_25_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_25_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_00_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_00_world_335.sql
index 4c038330317..4c038330317 100644
--- a/sql/updates/world/3.3.5/2021_04_28_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_01_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_01_world_335.sql
index c3deaace214..c3deaace214 100644
--- a/sql/updates/world/3.3.5/2021_04_28_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_02_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_02_world_335.sql
index 6e3f0d2f17e..6e3f0d2f17e 100644
--- a/sql/updates/world/3.3.5/2021_04_28_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_03_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_03_world_335.sql
index 25516a9e31e..25516a9e31e 100644
--- a/sql/updates/world/3.3.5/2021_04_28_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_04_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_04_world_335.sql
index 714b4f1dd39..714b4f1dd39 100644
--- a/sql/updates/world/3.3.5/2021_04_28_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_05_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_05_world_335.sql
index 125b54bcec5..125b54bcec5 100644
--- a/sql/updates/world/3.3.5/2021_04_28_05_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_06_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_06_world_335.sql
index 1a83d3eb92b..1a83d3eb92b 100644
--- a/sql/updates/world/3.3.5/2021_04_28_06_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_06_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_07_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_07_world.sql
index d69f6853e7d..d69f6853e7d 100644
--- a/sql/updates/world/3.3.5/2021_04_28_07_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_07_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_28_08_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_08_world.sql
index d226e2d06ac..d226e2d06ac 100644
--- a/sql/updates/world/3.3.5/2021_04_28_08_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_28_08_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_29_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_29_00_world.sql
index a4f99bfa219..a4f99bfa219 100644
--- a/sql/updates/world/3.3.5/2021_04_29_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_04_29_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_00_world.sql
index 937d0c5086a..937d0c5086a 100644
--- a/sql/updates/world/3.3.5/2021_05_04_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_01_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_01_world.sql
index 0c8842d48fe..0c8842d48fe 100644
--- a/sql/updates/world/3.3.5/2021_05_04_01_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_02_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_02_world.sql
index 16bfcce110b..16bfcce110b 100644
--- a/sql/updates/world/3.3.5/2021_05_04_02_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_03_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_03_world.sql
index 7b655bad0de..7b655bad0de 100644
--- a/sql/updates/world/3.3.5/2021_05_04_03_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_04_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_04_world_335.sql
index 96fc4e62003..96fc4e62003 100644
--- a/sql/updates/world/3.3.5/2021_05_04_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_05_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_05_world_335.sql
index d1bdffcf659..d1bdffcf659 100644
--- a/sql/updates/world/3.3.5/2021_05_04_05_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_06_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_06_world_335.sql
index 11370068455..11370068455 100644
--- a/sql/updates/world/3.3.5/2021_05_04_06_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_06_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_07_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_07_world_335.sql
index 35598b2ebd1..35598b2ebd1 100644
--- a/sql/updates/world/3.3.5/2021_05_04_07_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_07_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_04_08_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_08_world_335.sql
index 35990ae9134..35990ae9134 100644
--- a/sql/updates/world/3.3.5/2021_05_04_08_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_04_08_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_06_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_06_00_world.sql
index 1e83d803619..1e83d803619 100644
--- a/sql/updates/world/3.3.5/2021_05_06_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_07_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_07_00_world.sql
index 6108221fd15..6108221fd15 100644
--- a/sql/updates/world/3.3.5/2021_05_07_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_07_01_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_07_01_world.sql
index 8de3aba5a97..8de3aba5a97 100644
--- a/sql/updates/world/3.3.5/2021_05_07_01_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_07_02_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_07_02_world.sql
index 8c9a90b45a5..8c9a90b45a5 100644
--- a/sql/updates/world/3.3.5/2021_05_07_02_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_07_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_08_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_08_00_world.sql
index b2ab67ad7d9..b2ab67ad7d9 100644
--- a/sql/updates/world/3.3.5/2021_05_08_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_08_01_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_08_01_world_335.sql
index 122a67df5aa..122a67df5aa 100644
--- a/sql/updates/world/3.3.5/2021_05_08_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_08_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_08_02_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_08_02_world_335.sql
index 36392740018..36392740018 100644
--- a/sql/updates/world/3.3.5/2021_05_08_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_08_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_08_03_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_08_03_world.sql
index 40f4301fa4b..40f4301fa4b 100644
--- a/sql/updates/world/3.3.5/2021_05_08_03_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_08_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_10_00_world.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_10_00_world.sql
index 29dba85c954..29dba85c954 100644
--- a/sql/updates/world/3.3.5/2021_05_10_00_world.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_10_01_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_10_01_world_335.sql
index 382d9e3e71f..382d9e3e71f 100644
--- a/sql/updates/world/3.3.5/2021_05_10_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_10_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_13_00_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_13_00_world_335.sql
index af1a647ff59..af1a647ff59 100644
--- a/sql/updates/world/3.3.5/2021_05_13_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_13_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_13_01_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_13_01_world_335.sql
index 4aaf9b9a798..4aaf9b9a798 100644
--- a/sql/updates/world/3.3.5/2021_05_13_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_13_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_13_02_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_13_02_world_335.sql
index 95d0dbdb208..95d0dbdb208 100644
--- a/sql/updates/world/3.3.5/2021_05_13_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_13_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_13_03_world_335.sql b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_13_03_world_335.sql
index 1c9626997b2..1c9626997b2 100644
--- a/sql/updates/world/3.3.5/2021_05_13_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21041_2021_05_14/2021_05_13_03_world_335.sql
diff --git a/sql/updates/auth/3.3.5/2021_05_14_00_auth.sql b/sql/updates/auth/3.3.5/2021_05_14_00_auth.sql
new file mode 100644
index 00000000000..5026d72fec5
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2021_05_14_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21051 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2021_05_14_00_characters.sql b/sql/updates/characters/3.3.5/2021_05_14_00_characters.sql
new file mode 100644
index 00000000000..5ff61a23b90
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2021_05_14_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21051 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2021_05_14_00_world.sql b/sql/updates/world/3.3.5/2021_05_14_00_world.sql
new file mode 100644
index 00000000000..8c277055e62
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_05_14_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.21051 world
+UPDATE `version` SET `db_version`='TDB 335.21051', `cache_id`=21051 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';