TDB 335.19071 - 2019/07/15TDB335.19071

136 files changed, 76 insertions, 40 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index d4e946847e2..df1afdb5a51 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.19061_2019_06_15.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.19071_2019_07_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 2018786b018..f714714f6a7 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1002,8 +1002,8 @@ INSERT INTO `rbac_permissions` VALUES
 (5,'Join Arenas'),
 (6,'Join Dungeon Finder'),
 (7,'Skip idle connection check'),
-(8,"Cannot earn achievements"),
-(9,"Cannot earn realm first achievements"),
+(8,'Cannot earn achievements'),
+(9,'Cannot earn realm first achievements'),
 (11,'Log GM trades'),
 (13,'Skip Instance required bosses check'),
 (14,'Skip character creation team mask check'),
@@ -1793,7 +1793,8 @@ INSERT INTO `updates` VALUES
 ('2019_06_06_00_auth.sql','6DE8159E04BEE7BA0A4A81D72D160EB74934B6A5','ARCHIVED','2019-06-06 18:09:54',0),
 ('2019_06_15_00_auth.sql','456B92D99FFD2E7B6CBF64F4C68555A42B24B298','ARCHIVED','2019-06-15 07:33:45',0),
 ('2019_06_16_00_auth.sql','B14AED4D3387B56FF8C8161D3671750AEEAE0F2E','ARCHIVED','2019-06-15 23:32:12',0),
-('2019_06_21_00_auth.sql','C519239830204B68E710F698BC0C9E89B6D5FD24','ARCHIVED','2019-06-20 19:43:50',0);
+('2019_06_21_00_auth.sql','C519239830204B68E710F698BC0C9E89B6D5FD24','ARCHIVED','2019-06-20 19:43:50',0),
+('2019_07_15_00_auth.sql','64B491CD197A4466D7F739D67DD30C9502FF393A','ARCHIVED','2019-07-15 05:57:41',5);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -1895,4 +1896,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-06-15  7:33:48
+-- Dump completed on 2019-07-15  5:57:44
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index bc4a691747c..3b1ceb58b66 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1447,24 +1447,6 @@ LOCK TABLES `corpse` WRITE;
 UNLOCK TABLES;
 
 --
--- Table structure for table `respawn`
---
-
-DROP TABLE IF EXISTS `respawn`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `respawn` (
-  `type` smallint(10) unsigned NOT NULL,
-  `spawnId` int(10) unsigned NOT NULL,
-  `respawnTime` bigint(20) unsigned NOT NULL,
-  `mapId` smallint(10) unsigned NOT NULL,
-  `instanceId` int(10) unsigned NOT NULL,
-  PRIMARY KEY (`type`,`spawnId`,`instanceId`),
-  KEY `idx_instance` (`instanceId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stored respawn times';
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
 -- Table structure for table `game_event_condition_save`
 --
 
@@ -2542,6 +2524,33 @@ LOCK TABLES `reserved_name` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `respawn`
+--
+
+DROP TABLE IF EXISTS `respawn`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `respawn` (
+  `type` smallint(10) unsigned NOT NULL,
+  `spawnId` int(10) unsigned NOT NULL,
+  `respawnTime` bigint(20) unsigned NOT NULL,
+  `mapId` smallint(10) unsigned NOT NULL,
+  `instanceId` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`type`,`spawnId`,`instanceId`),
+  KEY `idx_instance` (`instanceId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stored respawn times';
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `respawn`
+--
+
+LOCK TABLES `respawn` WRITE;
+/*!40000 ALTER TABLE `respawn` DISABLE KEYS */;
+/*!40000 ALTER TABLE `respawn` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `updates`
 --
 
@@ -2599,7 +2608,8 @@ INSERT INTO `updates` VALUES
 ('2019_04_15_00_characters.sql','942FB57BF890E523B35B9BFEF3686CB0AA52B795','ARCHIVED','2019-04-15 06:16:09',0),
 ('2019_05_15_00_characters.sql','A12F21C8044C8BC8E2AA17F4C6CEB8B722CBC714','ARCHIVED','2019-05-15 06:13:20',0),
 ('2019_06_15_00_characters.sql','32DA6E004D7DD6EFFB0BB26238D17F6CC9E51DE6','ARCHIVED','2019-06-15 07:33:45',0),
-('2019_07_14_00_characters.sql','A141F4F15BDF0320483921429871D4C572BD7E2D','ARCHIVED','2019-07-04 00:00:00',0);
+('2019_07_14_00_characters.sql','A141F4F15BDF0320483921429871D4C572BD7E2D','ARCHIVED','2019-07-04 00:00:00',0),
+('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 05:57:41',4);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2765,4 +2775,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-06-15  7:33:48
+-- Dump completed on 2019-07-15  5:57:44
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index ef21172ddbb..32d12d9dcb5 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -623,20 +623,6 @@ CREATE TABLE `creature_template` (
   `lootid` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `pickpocketloot` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `skinloot` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `resistance1` smallint(6) NOT NULL DEFAULT '0',
-  `resistance2` smallint(6) NOT NULL DEFAULT '0',
-  `resistance3` smallint(6) NOT NULL DEFAULT '0',
-  `resistance4` smallint(6) NOT NULL DEFAULT '0',
-  `resistance5` smallint(6) NOT NULL DEFAULT '0',
-  `resistance6` smallint(6) NOT NULL DEFAULT '0',
-  `spell1` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `spell2` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `spell3` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `spell4` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `spell5` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `spell6` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `spell7` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `spell8` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `PetSpellDataId` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `VehicleId` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -719,6 +705,38 @@ CREATE TABLE `creature_template_movement` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `creature_template_resistance`
+--
+
+DROP TABLE IF EXISTS `creature_template_resistance`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_template_resistance` (
+  `CreatureID` mediumint(8) unsigned NOT NULL,
+  `School` tinyint(6) unsigned NOT NULL,
+  `Resistance` smallint(6) DEFAULT NULL,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`CreatureID`,`School`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `creature_template_spell`
+--
+
+DROP TABLE IF EXISTS `creature_template_spell`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_template_spell` (
+  `CreatureID` mediumint(8) unsigned NOT NULL,
+  `Index` tinyint(6) unsigned NOT NULL DEFAULT '0',
+  `Spell` mediumint(8) unsigned DEFAULT NULL,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`CreatureID`,`Index`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `creature_text`
 --
 
@@ -3826,4 +3844,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-06-15  7:33:48
+-- Dump completed on 2019-07-15  5:57:44
diff --git a/sql/updates/auth/3.3.5/2019_06_15_00_auth.sql b/sql/old/3.3.5a/auth/19061_2019_07_15/2019_06_15_00_auth.sql
index fc5c617d408..fc5c617d408 100644
--- a/sql/updates/auth/3.3.5/2019_06_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19061_2019_07_15/2019_06_15_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2019_06_16_00_auth.sql b/sql/old/3.3.5a/auth/19061_2019_07_15/2019_06_16_00_auth.sql
index 627e4dcab5d..627e4dcab5d 100644
--- a/sql/updates/auth/3.3.5/2019_06_16_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19061_2019_07_15/2019_06_16_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2019_06_21_00_auth.sql b/sql/old/3.3.5a/auth/19061_2019_07_15/2019_06_21_00_auth.sql
index 1db042a632f..1db042a632f 100644
--- a/sql/updates/auth/3.3.5/2019_06_21_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19061_2019_07_15/2019_06_21_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2019_06_15_00_characters.sql b/sql/old/3.3.5a/characters/19061_2019_07_15/2019_06_15_00_characters.sql
index 96e266d212b..96e266d212b 100644
--- a/sql/updates/characters/3.3.5/2019_06_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/19061_2019_07_15/2019_06_15_00_characters.sql
diff --git a/sql/updates/characters/3.3.5/2019_07_14_00_characters.sql b/sql/old/3.3.5a/characters/19061_2019_07_15/2019_07_14_00_characters.sql
index 24fc278db61..24fc278db61 100644
--- a/sql/updates/characters/3.3.5/2019_07_14_00_characters.sql
+++ b/sql/old/3.3.5a/characters/19061_2019_07_15/2019_07_14_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2019_06_15_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_00_world.sql
index 686bb33d199..686bb33d199 100644
--- a/sql/updates/world/3.3.5/2019_06_15_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_15_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_01_world.sql
index 0b6b18c60f9..0b6b18c60f9 100644
--- a/sql/updates/world/3.3.5/2019_06_15_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_15_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_02_world.sql
index 2ffb41d2f63..2ffb41d2f63 100644
--- a/sql/updates/world/3.3.5/2019_06_15_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_15_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_03_world.sql
index f7a012150cc..f7a012150cc 100644
--- a/sql/updates/world/3.3.5/2019_06_15_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_15_04_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_04_world.sql
index 559a41443da..559a41443da 100644
--- a/sql/updates/world/3.3.5/2019_06_15_04_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_15_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_16_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_16_00_world.sql
index 8e851752eaa..8e851752eaa 100644
--- a/sql/updates/world/3.3.5/2019_06_16_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_16_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_16_01_world.sql
index 8405d7ca31c..8405d7ca31c 100644
--- a/sql/updates/world/3.3.5/2019_06_16_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_16_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_16_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_16_02_world.sql
index 7a9ea2100dd..7a9ea2100dd 100644
--- a/sql/updates/world/3.3.5/2019_06_16_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_16_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_16_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_16_03_world.sql
index c1e698f1a0d..c1e698f1a0d 100644
--- a/sql/updates/world/3.3.5/2019_06_16_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_16_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_17_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_17_00_world.sql
index b88ba01cf53..b88ba01cf53 100644
--- a/sql/updates/world/3.3.5/2019_06_17_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_17_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_17_01_world.sql
index 9ac90753fe8..9ac90753fe8 100644
--- a/sql/updates/world/3.3.5/2019_06_17_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_17_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_17_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_17_02_world.sql
index 4e7e30b2c3d..4e7e30b2c3d 100644
--- a/sql/updates/world/3.3.5/2019_06_17_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_17_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_17_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_17_03_world.sql
index a64869b613c..a64869b613c 100644
--- a/sql/updates/world/3.3.5/2019_06_17_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_17_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_18_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_18_00_world.sql
index 58fb26a8734..58fb26a8734 100644
--- a/sql/updates/world/3.3.5/2019_06_18_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_18_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_18_01_world_335.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_18_01_world_335.sql
index 3e3cc22dade..3e3cc22dade 100644
--- a/sql/updates/world/3.3.5/2019_06_18_01_world_335.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_18_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_06_19_00_world_335.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_00_world_335.sql
index 7d9e371e080..7d9e371e080 100644
--- a/sql/updates/world/3.3.5/2019_06_19_00_world_335.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_06_19_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_01_world.sql
index fb257cd0595..fb257cd0595 100644
--- a/sql/updates/world/3.3.5/2019_06_19_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_19_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_02_world.sql
index ef368d9e384..ef368d9e384 100644
--- a/sql/updates/world/3.3.5/2019_06_19_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_19_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_03_world.sql
index 57574982ad9..57574982ad9 100644
--- a/sql/updates/world/3.3.5/2019_06_19_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_19_04_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_04_world.sql
index 6e3094f03b1..6e3094f03b1 100644
--- a/sql/updates/world/3.3.5/2019_06_19_04_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_19_05_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_05_world.sql
index d2071f42200..d2071f42200 100644
--- a/sql/updates/world/3.3.5/2019_06_19_05_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_19_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_20_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_00_world.sql
index a10cba5e827..a10cba5e827 100644
--- a/sql/updates/world/3.3.5/2019_06_20_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_20_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_01_world.sql
index 80a09fec7df..80a09fec7df 100644
--- a/sql/updates/world/3.3.5/2019_06_20_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_20_02_world_335.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_02_world_335.sql
index d72adcfa958..d72adcfa958 100644
--- a/sql/updates/world/3.3.5/2019_06_20_02_world_335.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_06_20_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_03_world.sql
index 8ef1415d257..8ef1415d257 100644
--- a/sql/updates/world/3.3.5/2019_06_20_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_20_04_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_04_world.sql
index b191006d674..b191006d674 100644
--- a/sql/updates/world/3.3.5/2019_06_20_04_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_20_05_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_05_world.sql
index f68651e9459..f68651e9459 100644
--- a/sql/updates/world/3.3.5/2019_06_20_05_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_20_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_21_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_21_00_world.sql
index 85f39872406..85f39872406 100644
--- a/sql/updates/world/3.3.5/2019_06_21_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_21_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_21_01_world.sql
index f531b7639aa..f531b7639aa 100644
--- a/sql/updates/world/3.3.5/2019_06_21_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_21_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_21_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_21_02_world.sql
index bc4749e4311..bc4749e4311 100644
--- a/sql/updates/world/3.3.5/2019_06_21_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_21_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_22_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_22_00_world.sql
index 29f3e21722d..29f3e21722d 100644
--- a/sql/updates/world/3.3.5/2019_06_22_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_22_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_22_01_world.sql
index 3ae3cc42291..3ae3cc42291 100644
--- a/sql/updates/world/3.3.5/2019_06_22_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_22_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_00_world.sql
index 56634f67b00..56634f67b00 100644
--- a/sql/updates/world/3.3.5/2019_06_23_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_01_world.sql
index aeb0282436d..aeb0282436d 100644
--- a/sql/updates/world/3.3.5/2019_06_23_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_02_world.sql
index b3f71013551..b3f71013551 100644
--- a/sql/updates/world/3.3.5/2019_06_23_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_03_world.sql
index 6efa7bd946c..6efa7bd946c 100644
--- a/sql/updates/world/3.3.5/2019_06_23_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_04_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_04_world.sql
index 8d064cdc1cd..8d064cdc1cd 100644
--- a/sql/updates/world/3.3.5/2019_06_23_04_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_05_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_05_world.sql
index f9465930275..f9465930275 100644
--- a/sql/updates/world/3.3.5/2019_06_23_05_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_06_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_06_world.sql
index 0ab7581fc0a..0ab7581fc0a 100644
--- a/sql/updates/world/3.3.5/2019_06_23_06_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_07_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_07_world.sql
index c9835194661..c9835194661 100644
--- a/sql/updates/world/3.3.5/2019_06_23_07_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_07_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_08_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_08_world.sql
index 7fdc6ad6418..7fdc6ad6418 100644
--- a/sql/updates/world/3.3.5/2019_06_23_08_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_08_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_09_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_09_world.sql
index 346fdf9e2b9..346fdf9e2b9 100644
--- a/sql/updates/world/3.3.5/2019_06_23_09_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_09_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_10_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_10_world.sql
index df3cd7828ad..df3cd7828ad 100644
--- a/sql/updates/world/3.3.5/2019_06_23_10_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_10_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_11_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_11_world.sql
index c13f9fcd724..c13f9fcd724 100644
--- a/sql/updates/world/3.3.5/2019_06_23_11_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_11_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_12_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_12_world.sql
index ff1ce658779..ff1ce658779 100644
--- a/sql/updates/world/3.3.5/2019_06_23_12_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_12_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_13_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_13_world.sql
index c670691a9e1..c670691a9e1 100644
--- a/sql/updates/world/3.3.5/2019_06_23_13_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_13_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_14_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_14_world.sql
index 409df2d5c12..409df2d5c12 100644
--- a/sql/updates/world/3.3.5/2019_06_23_14_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_14_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_15_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_15_world.sql
index d85e6c61667..d85e6c61667 100644
--- a/sql/updates/world/3.3.5/2019_06_23_15_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_15_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_16_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_16_world.sql
index 2b50e617dd2..2b50e617dd2 100644
--- a/sql/updates/world/3.3.5/2019_06_23_16_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_16_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_17_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_17_world.sql
index 9c1f8aa866a..9c1f8aa866a 100644
--- a/sql/updates/world/3.3.5/2019_06_23_17_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_17_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_18_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_18_world.sql
index a8889112f4f..a8889112f4f 100644
--- a/sql/updates/world/3.3.5/2019_06_23_18_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_18_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_23_19_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_19_world.sql
index 26abe3a02a0..26abe3a02a0 100644
--- a/sql/updates/world/3.3.5/2019_06_23_19_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_23_19_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_24_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_00_world.sql
index c2d0645d1a7..c2d0645d1a7 100644
--- a/sql/updates/world/3.3.5/2019_06_24_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_24_01_world_335.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_01_world_335.sql
index 15db2bd6e46..15db2bd6e46 100644
--- a/sql/updates/world/3.3.5/2019_06_24_01_world_335.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_06_24_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_02_world.sql
index 5bd4650ff4d..5bd4650ff4d 100644
--- a/sql/updates/world/3.3.5/2019_06_24_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_24_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_03_world.sql
index 7c7a91475e9..7c7a91475e9 100644
--- a/sql/updates/world/3.3.5/2019_06_24_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_24_04_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_04_world.sql
index 133f9159553..133f9159553 100644
--- a/sql/updates/world/3.3.5/2019_06_24_04_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_24_05_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_05_world.sql
index b1fdabb492d..b1fdabb492d 100644
--- a/sql/updates/world/3.3.5/2019_06_24_05_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_24_06_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_06_world.sql
index 6d01554c83f..6d01554c83f 100644
--- a/sql/updates/world/3.3.5/2019_06_24_06_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_24_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_25_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_25_00_world.sql
index c79f9cd9543..c79f9cd9543 100644
--- a/sql/updates/world/3.3.5/2019_06_25_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_25_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_25_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_25_01_world.sql
index 86a9029e86c..86a9029e86c 100644
--- a/sql/updates/world/3.3.5/2019_06_25_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_25_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_25_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_25_02_world.sql
index 7f25e5c32b7..7f25e5c32b7 100644
--- a/sql/updates/world/3.3.5/2019_06_25_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_25_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_26_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_00_world.sql
index 15169ab85c2..15169ab85c2 100644
--- a/sql/updates/world/3.3.5/2019_06_26_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_26_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_01_world.sql
index 12a8500acf4..12a8500acf4 100644
--- a/sql/updates/world/3.3.5/2019_06_26_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_26_02_world_335.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_02_world_335.sql
index 8885f92153b..8885f92153b 100644
--- a/sql/updates/world/3.3.5/2019_06_26_02_world_335.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_06_26_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_03_world.sql
index 4a71d73beba..4a71d73beba 100644
--- a/sql/updates/world/3.3.5/2019_06_26_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_26_04_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_04_world.sql
index 8f2072212be..8f2072212be 100644
--- a/sql/updates/world/3.3.5/2019_06_26_04_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_26_05_world_335.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_05_world_335.sql
index 14693e1753d..14693e1753d 100644
--- a/sql/updates/world/3.3.5/2019_06_26_05_world_335.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_06_26_06_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_06_world.sql
index 9cff6783632..9cff6783632 100644
--- a/sql/updates/world/3.3.5/2019_06_26_06_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_26_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_27_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_27_00_world.sql
index 6775fbd6307..6775fbd6307 100644
--- a/sql/updates/world/3.3.5/2019_06_27_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_27_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_27_01_world.sql
index e28fccf06f6..e28fccf06f6 100644
--- a/sql/updates/world/3.3.5/2019_06_27_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_27_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_27_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_27_02_world.sql
index 2b4231d0679..2b4231d0679 100644
--- a/sql/updates/world/3.3.5/2019_06_27_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_27_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_27_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_27_03_world.sql
index 61d250858d0..61d250858d0 100644
--- a/sql/updates/world/3.3.5/2019_06_27_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_27_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_28_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_28_00_world.sql
index 9ba191bba0b..9ba191bba0b 100644
--- a/sql/updates/world/3.3.5/2019_06_28_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_28_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_28_01_world.sql
index 00b99addd44..00b99addd44 100644
--- a/sql/updates/world/3.3.5/2019_06_28_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_28_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_29_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_29_00_world.sql
index be171cc208f..be171cc208f 100644
--- a/sql/updates/world/3.3.5/2019_06_29_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_29_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_29_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_29_01_world.sql
index 7e5afdfc8e0..7e5afdfc8e0 100644
--- a/sql/updates/world/3.3.5/2019_06_29_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_29_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_29_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_29_02_world.sql
index 3ba2064d088..3ba2064d088 100644
--- a/sql/updates/world/3.3.5/2019_06_29_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_29_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_30_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_30_00_world.sql
index 5f3892e78fa..5f3892e78fa 100644
--- a/sql/updates/world/3.3.5/2019_06_30_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_30_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_30_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_30_01_world.sql
index bec6d0652f6..bec6d0652f6 100644
--- a/sql/updates/world/3.3.5/2019_06_30_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_30_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_30_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_30_02_world.sql
index 8f90f79220e..8f90f79220e 100644
--- a/sql/updates/world/3.3.5/2019_06_30_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_30_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_06_30_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_30_03_world.sql
index b0fa402b1b3..b0fa402b1b3 100644
--- a/sql/updates/world/3.3.5/2019_06_30_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_06_30_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_00_world.sql
index 4301ed3d3aa..4301ed3d3aa 100644
--- a/sql/updates/world/3.3.5/2019_07_01_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_01_world.sql
index 661f1820194..661f1820194 100644
--- a/sql/updates/world/3.3.5/2019_07_01_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_02_world.sql
index d321b2994fd..d321b2994fd 100644
--- a/sql/updates/world/3.3.5/2019_07_01_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_03_world.sql
index c511052085f..c511052085f 100644
--- a/sql/updates/world/3.3.5/2019_07_01_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_04_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_04_world.sql
index 92b7b1687d3..92b7b1687d3 100644
--- a/sql/updates/world/3.3.5/2019_07_01_04_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_05_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_05_world.sql
index 2cab05fad38..2cab05fad38 100644
--- a/sql/updates/world/3.3.5/2019_07_01_05_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_06_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_06_world.sql
index f194f0538c3..f194f0538c3 100644
--- a/sql/updates/world/3.3.5/2019_07_01_06_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_07_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_07_world.sql
index 525f9a55f89..525f9a55f89 100644
--- a/sql/updates/world/3.3.5/2019_07_01_07_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_07_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_01_08_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_08_world.sql
index 2f2312ebed8..2f2312ebed8 100644
--- a/sql/updates/world/3.3.5/2019_07_01_08_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_01_08_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_03_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_03_00_world.sql
index ffb955a9c8c..ffb955a9c8c 100644
--- a/sql/updates/world/3.3.5/2019_07_03_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_03_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_03_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_03_01_world.sql
index 17872d5ebba..17872d5ebba 100644
--- a/sql/updates/world/3.3.5/2019_07_03_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_03_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_03_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_03_02_world.sql
index 4b602c9acd8..4b602c9acd8 100644
--- a/sql/updates/world/3.3.5/2019_07_03_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_03_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_04_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_04_00_world.sql
index 762db275dc5..762db275dc5 100644
--- a/sql/updates/world/3.3.5/2019_07_04_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_04_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_04_01_world.sql
index 7825cf82f27..7825cf82f27 100644
--- a/sql/updates/world/3.3.5/2019_07_04_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_04_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_05_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_05_00_world.sql
index 60191109234..60191109234 100644
--- a/sql/updates/world/3.3.5/2019_07_05_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_05_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_05_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_05_01_world.sql
index ba512f95e21..ba512f95e21 100644
--- a/sql/updates/world/3.3.5/2019_07_05_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_05_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_05_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_05_02_world.sql
index 5bc9b735876..5bc9b735876 100644
--- a/sql/updates/world/3.3.5/2019_07_05_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_05_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_05_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_05_03_world.sql
index 6eb0f75d0ed..6eb0f75d0ed 100644
--- a/sql/updates/world/3.3.5/2019_07_05_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_05_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_06_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_06_00_world.sql
index bc264df5a9f..bc264df5a9f 100644
--- a/sql/updates/world/3.3.5/2019_07_06_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_06_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_06_01_world.sql
index eb3e6af01be..eb3e6af01be 100644
--- a/sql/updates/world/3.3.5/2019_07_06_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_06_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_07_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_07_00_world.sql
index ad1672f6c31..ad1672f6c31 100644
--- a/sql/updates/world/3.3.5/2019_07_07_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_07_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_07_01_world.sql
index 8a0f825c0d0..8a0f825c0d0 100644
--- a/sql/updates/world/3.3.5/2019_07_07_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_07_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_07_02_world.sql
index 72c8e7d2343..72c8e7d2343 100644
--- a/sql/updates/world/3.3.5/2019_07_07_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_07_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_08_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_08_00_world.sql
index e1df8449bd6..e1df8449bd6 100644
--- a/sql/updates/world/3.3.5/2019_07_08_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_08_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_08_01_world.sql
index 0fc6b13ee3a..0fc6b13ee3a 100644
--- a/sql/updates/world/3.3.5/2019_07_08_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_09_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_00_world.sql
index 9cd4b34edc6..9cd4b34edc6 100644
--- a/sql/updates/world/3.3.5/2019_07_09_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_09_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_01_world.sql
index a5bbcf280c9..a5bbcf280c9 100644
--- a/sql/updates/world/3.3.5/2019_07_09_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_09_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_02_world.sql
index d5a22976ef8..d5a22976ef8 100644
--- a/sql/updates/world/3.3.5/2019_07_09_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_09_03_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_03_world.sql
index 07497f3d16a..07497f3d16a 100644
--- a/sql/updates/world/3.3.5/2019_07_09_03_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_09_04_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_04_world.sql
index f8b4d182323..f8b4d182323 100644
--- a/sql/updates/world/3.3.5/2019_07_09_04_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_09_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_10_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_10_00_world.sql
index b4d4536fcbc..b4d4536fcbc 100644
--- a/sql/updates/world/3.3.5/2019_07_10_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_11_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_00_world.sql
index a7c079fa507..a7c079fa507 100644
--- a/sql/updates/world/3.3.5/2019_07_11_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_11_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_01_world.sql
index fbbb18f7a85..fbbb18f7a85 100644
--- a/sql/updates/world/3.3.5/2019_07_11_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_11_02_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_02_world.sql
index 6b174265453..6b174265453 100644
--- a/sql/updates/world/3.3.5/2019_07_11_02_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_11_03_world_335.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_03_world_335.sql
index adbd61eb5d5..adbd61eb5d5 100644
--- a/sql/updates/world/3.3.5/2019_07_11_03_world_335.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_11_04_world_335.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_04_world_335.sql
index aa0aa6a6331..aa0aa6a6331 100644
--- a/sql/updates/world/3.3.5/2019_07_11_04_world_335.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_11_05_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_05_world.sql
index c6b15609387..c6b15609387 100644
--- a/sql/updates/world/3.3.5/2019_07_11_05_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_11_06_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_06_world.sql
index ccc1f808d6a..ccc1f808d6a 100644
--- a/sql/updates/world/3.3.5/2019_07_11_06_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_11_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_12_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_12_00_world.sql
index e4aedc713da..e4aedc713da 100644
--- a/sql/updates/world/3.3.5/2019_07_12_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_12_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_12_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_12_01_world.sql
index cdf2aefaf81..cdf2aefaf81 100644
--- a/sql/updates/world/3.3.5/2019_07_12_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_12_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_13_00_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_13_00_world.sql
index 25d51416223..25d51416223 100644
--- a/sql/updates/world/3.3.5/2019_07_13_00_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_13_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_13_01_world.sql b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_13_01_world.sql
index 235fdd27d7a..235fdd27d7a 100644
--- a/sql/updates/world/3.3.5/2019_07_13_01_world.sql
+++ b/sql/old/3.3.5a/world/19061_2019_07_15/2019_07_13_01_world.sql
diff --git a/sql/updates/auth/3.3.5/2019_07_15_00_auth.sql b/sql/updates/auth/3.3.5/2019_07_15_00_auth.sql
new file mode 100644
index 00000000000..f96eaa66920
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2019_07_15_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19071 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2019_07_15_00_characters.sql b/sql/updates/characters/3.3.5/2019_07_15_00_characters.sql
new file mode 100644
index 00000000000..7b15aaa0140
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2019_07_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19071 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2019_07_15_00_world.sql b/sql/updates/world/3.3.5/2019_07_15_00_world.sql
new file mode 100644
index 00000000000..695f04e35ba
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_07_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.19071 world
+UPDATE `version` SET `db_version`='TDB 335.19071', `cache_id`=19071 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';