aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql7
-rw-r--r--sql/base/characters_database.sql5
-rw-r--r--sql/base/dev/world_database.sql81
-rw-r--r--sql/old/3.3.5a/auth/20082_2020_09_15/2020_08_22_00_auth.sql (renamed from sql/updates/auth/3.3.5/2020_08_22_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/auth/20082_2020_09_15/2020_09_06_00_auth.sql (renamed from sql/updates/auth/3.3.5/2020_09_06_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/characters/20082_2020_09_15/2020_08_22_00_characters.sql (renamed from sql/updates/characters/3.3.5/2020_08_22_00_characters.sql)0
-rw-r--r--sql/old/3.3.5a/characters/20082_2020_09_15/2020_09_02_00_characters.sql (renamed from sql/updates/characters/3.3.5/2020_09_02_00_characters.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_02_world.sql (renamed from sql/updates/world/3.3.5/2020_08_22_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_03_world.sql (renamed from sql/updates/world/3.3.5/2020_08_22_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_04_world.sql (renamed from sql/updates/world/3.3.5/2020_08_22_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_23_00_world.sql (renamed from sql/updates/world/3.3.5/2020_08_23_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_23_01_world.sql (renamed from sql/updates/world/3.3.5/2020_08_23_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_00_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_24_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_01_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_24_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_02_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_24_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_03_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_24_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_04_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_24_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_00_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_26_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_01_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_26_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_02_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_26_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_03_world.sql (renamed from sql/updates/world/3.3.5/2020_08_26_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_00_world.sql (renamed from sql/updates/world/3.3.5/2020_08_27_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_01_world.sql (renamed from sql/updates/world/3.3.5/2020_08_27_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_02_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_27_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_03_world.sql (renamed from sql/updates/world/3.3.5/2020_08_27_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_00_world.sql (renamed from sql/updates/world/3.3.5/2020_08_28_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_01_world.sql (renamed from sql/updates/world/3.3.5/2020_08_28_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_02_world.sql (renamed from sql/updates/world/3.3.5/2020_08_28_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_03_world.sql (renamed from sql/updates/world/3.3.5/2020_08_28_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_04_world.sql (renamed from sql/updates/world/3.3.5/2020_08_28_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_00_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_29_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_01_world.sql (renamed from sql/updates/world/3.3.5/2020_08_29_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_02_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_29_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_03_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_29_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_00_world.sql (renamed from sql/updates/world/3.3.5/2020_08_31_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_01_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_31_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_02_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_31_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_03_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_31_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_04_world_335.sql (renamed from sql/updates/world/3.3.5/2020_08_31_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_00_world.sql (renamed from sql/updates/world/3.3.5/2020_09_04_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_01_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_04_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_02_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_04_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_03_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_04_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_04_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_04_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_05_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_04_05_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_06_world.sql (renamed from sql/updates/world/3.3.5/2020_09_04_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_00_world.sql (renamed from sql/updates/world/3.3.5/2020_09_06_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_01_world.sql (renamed from sql/updates/world/3.3.5/2020_09_06_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_02_world.sql (renamed from sql/updates/world/3.3.5/2020_09_06_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_00_world.sql (renamed from sql/updates/world/3.3.5/2020_09_08_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_01_world.sql (renamed from sql/updates/world/3.3.5/2020_09_08_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_02_world.sql (renamed from sql/updates/world/3.3.5/2020_09_08_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_00_world.sql (renamed from sql/updates/world/3.3.5/2020_09_09_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_01_world.sql (renamed from sql/updates/world/3.3.5/2020_09_09_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_02_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_09_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_03_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_09_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_04_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_09_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_05_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_09_05_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_06_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_09_06_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_07_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_09_07_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_08_world.sql (renamed from sql/updates/world/3.3.5/2020_09_09_08_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_10_00_world.sql (renamed from sql/updates/world/3.3.5/2020_09_10_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_00_world.sql (renamed from sql/updates/world/3.3.5/2020_09_12_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_01_world.sql (renamed from sql/updates/world/3.3.5/2020_09_12_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_02_world.sql (renamed from sql/updates/world/3.3.5/2020_09_12_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_03_world_335.sql (renamed from sql/updates/world/3.3.5/2020_09_12_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_04_world.sql (renamed from sql/updates/world/3.3.5/2020_09_12_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_05_world.sql (renamed from sql/updates/world/3.3.5/2020_09_12_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_06_world.sql (renamed from sql/updates/world/3.3.5/2020_09_12_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_07_world.sql (renamed from sql/updates/world/3.3.5/2020_09_12_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_08_world.sql (renamed from sql/updates/world/3.3.5/2020_09_12_08_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_13_00_world.sql (renamed from sql/updates/world/3.3.5/2020_09_13_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/20082_2020_09_15/2020_09_13_01_world.sql (renamed from sql/updates/world/3.3.5/2020_09_13_01_world.sql)0
-rw-r--r--sql/updates/auth/3.3.5/2020_09_15_00_auth.sql2
-rw-r--r--sql/updates/characters/3.3.5/2020_09_15_00_characters.sql2
-rw-r--r--sql/updates/world/3.3.5/2020_09_15_00_world.sql3
76 files changed, 94 insertions, 6 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 06ae7646c24..dba680bea8b 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1970,8 +1970,9 @@ INSERT INTO `updates` VALUES
('2020_08_03_01_auth.sql','EC1063396CA20A2303D83238470D41EF4439EC72','ARCHIVED','2020-08-03 00:00:01',0),
('2020_08_11_00_auth.sql','14C99177E43003D83A4D6F2227722F15FC15A1D0','ARCHIVED','2020-08-11 00:00:00',0),
('2020_08_15_00_auth.sql','A49F4A776E1583B1FF63DFE99BC0E0DD97A74674','ARCHIVED','2020-08-15 00:00:00',0),
-('2020_08_22_00_auth.sql','060A87FCC8F836A96D9D55BEDC32CBAD05008B4C','RELEASED','2020-08-22 00:00:00',0),
-('2020_09_06_00_auth.sql','DC4B5D4C65EB138D5609F137799C3289B9CC2493','RELEASED','2020-09-06 00:00:00',0);
+('2020_08_22_00_auth.sql','060A87FCC8F836A96D9D55BEDC32CBAD05008B4C','ARCHIVED','2020-08-22 00:00:00',0),
+('2020_09_06_00_auth.sql','DC4B5D4C65EB138D5609F137799C3289B9CC2493','ARCHIVED','2020-09-06 00:00:00',0),
+('2020_09_15_00_auth.sql','0AA5BCA384A372DC789647F838657766D51D8CC7','ARCHIVED','2020-09-15 19:35:18',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2077,4 +2078,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-08-22 16:27:28
+-- Dump completed on 2020-09-15 19:35:20
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index c8680b592fe..0a03202302e 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2650,7 +2650,8 @@ INSERT INTO `updates` VALUES
('2020_07_15_00_characters.sql','D87627DC6E4D222F68A1F56F0B3B986EF9A590EF','ARCHIVED','2020-07-15 10:35:41',0),
('2020_08_15_00_characters.sql','70979D488ACD23DEB8E45D31C3ADC690A1B81F79','ARCHIVED','2020-08-15 09:34:44',0),
('2020_08_22_00_characters.sql','78251072C9281D98BC4EAC523DA0858C9F8425D9','ARCHIVED','2020-08-22 16:27:27',0),
-('2020_09_02_00_characters.sql','627F320D58A42F401AB10ABA927F2B37C1981576','RELEASED','2020-09-02 17:41:04',0);
+('2020_09_02_00_characters.sql','627F320D58A42F401AB10ABA927F2B37C1981576','ARCHIVED','2020-09-02 17:41:04',0),
+('2020_09_15_00_characters.sql','1B650E8C815E29AE261238B010BC9EB35BD49A25','ARCHIVED','2020-09-15 19:35:18',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2821,4 +2822,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2020-08-22 16:27:28
+-- Dump completed on 2020-09-15 19:35:20
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 41db59aff37..5886ca48b22 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -3792,6 +3792,49 @@ CREATE TABLE `version` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Temporary table structure for view `vw_conditions_with_labels`
+--
+
+DROP TABLE IF EXISTS `vw_conditions_with_labels`;
+/*!50001 DROP VIEW IF EXISTS `vw_conditions_with_labels`*/;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `vw_conditions_with_labels` AS SELECT
+ 1 AS `SourceTypeOrReferenceId`,
+ 1 AS `SourceGroup`,
+ 1 AS `SourceEntry`,
+ 1 AS `SourceId`,
+ 1 AS `ElseGroup`,
+ 1 AS `ConditionTypeOrReference`,
+ 1 AS `ConditionTarget`,
+ 1 AS `ConditionValue1`,
+ 1 AS `ConditionValue2`,
+ 1 AS `ConditionValue3`,
+ 1 AS `NegativeCondition`,
+ 1 AS `ErrorType`,
+ 1 AS `ErrorTextId`,
+ 1 AS `ScriptName`,
+ 1 AS `Comment`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary table structure for view `vw_disables_with_labels`
+--
+
+DROP TABLE IF EXISTS `vw_disables_with_labels`;
+/*!50001 DROP VIEW IF EXISTS `vw_disables_with_labels`*/;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `vw_disables_with_labels` AS SELECT
+ 1 AS `sourceType`,
+ 1 AS `entry`,
+ 1 AS `flags`,
+ 1 AS `params_0`,
+ 1 AS `params_1`,
+ 1 AS `comment`*/;
+SET character_set_client = @saved_cs_client;
+
+--
-- Temporary table structure for view `vw_smart_scripts_with_labels`
--
@@ -3922,6 +3965,42 @@ CREATE TABLE `waypoints` (
--
--
+-- Final view structure for view `vw_conditions_with_labels`
+--
+
+/*!50001 DROP VIEW IF EXISTS `vw_conditions_with_labels`*/;
+/*!50001 SET @saved_cs_client = @@character_set_client */;
+/*!50001 SET @saved_cs_results = @@character_set_results */;
+/*!50001 SET @saved_col_connection = @@collation_connection */;
+/*!50001 SET character_set_client = utf8 */;
+/*!50001 SET character_set_results = utf8 */;
+/*!50001 SET collation_connection = utf8_general_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 */
+/*!50001 VIEW `vw_conditions_with_labels` AS (select (case when (`conditions`.`SourceTypeOrReferenceId` = 0) then 'CONDITION_SOURCE_TYPE_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 1) then 'CONDITION_SOURCE_TYPE_CREATURE_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 2) then 'CONDITION_SOURCE_TYPE_DISENCHANT_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 3) then 'CONDITION_SOURCE_TYPE_FISHING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 4) then 'CONDITION_SOURCE_TYPE_GAMEOBJECT_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 5) then 'CONDITION_SOURCE_TYPE_ITEM_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 6) then 'CONDITION_SOURCE_TYPE_MAIL_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 7) then 'CONDITION_SOURCE_TYPE_MILLING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 8) then 'CONDITION_SOURCE_TYPE_PICKPOCKETING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 9) then 'CONDITION_SOURCE_TYPE_PROSPECTING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 10) then 'CONDITION_SOURCE_TYPE_REFERENCE_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 11) then 'CONDITION_SOURCE_TYPE_SKINNING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 12) then 'CONDITION_SOURCE_TYPE_SPELL_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 13) then 'CONDITION_SOURCE_TYPE_SPELL_IMPLICIT_TARGET' when (`conditions`.`SourceTypeOrReferenceId` = 14) then 'CONDITION_SOURCE_TYPE_GOSSIP_MENU' when (`conditions`.`SourceTypeOrReferenceId` = 15) then 'CONDITION_SOURCE_TYPE_GOSSIP_MENU_OPTION' when (`conditions`.`SourceTypeOrReferenceId` = 16) then 'CONDITION_SOURCE_TYPE_CREATURE_TEMPLATE_VEHICLE' when (`conditions`.`SourceTypeOrReferenceId` = 17) then 'CONDITION_SOURCE_TYPE_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 18) then 'CONDITION_SOURCE_TYPE_SPELL_CLICK_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 19) then 'CONDITION_SOURCE_TYPE_QUEST_AVAILABLE' when (`conditions`.`SourceTypeOrReferenceId` = 21) then 'CONDITION_SOURCE_TYPE_VEHICLE_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 22) then 'CONDITION_SOURCE_TYPE_SMART_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 23) then 'CONDITION_SOURCE_TYPE_NPC_VENDOR' when (`conditions`.`SourceTypeOrReferenceId` = 24) then 'CONDITION_SOURCE_TYPE_SPELL_PROC' when (`conditions`.`SourceTypeOrReferenceId` = 25) then 'CONDITION_SOURCE_TYPE_TERRAIN_SWAP' when (`conditions`.`SourceTypeOrReferenceId` = 26) then 'CONDITION_SOURCE_TYPE_PHASE' when (`conditions`.`SourceTypeOrReferenceId` = 27) then 'CONDITION_SOURCE_TYPE_GRAVEYARD' else `conditions`.`SourceTypeOrReferenceId` end) AS `SourceTypeOrReferenceId`,`conditions`.`SourceGroup` AS `SourceGroup`,`conditions`.`SourceEntry` AS `SourceEntry`,`conditions`.`SourceId` AS `SourceId`,`conditions`.`ElseGroup` AS `ElseGroup`,(case when (`conditions`.`SourceTypeOrReferenceId` = 0) then 'CONDITION_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 1) then 'CONDITION_AURA' when (`conditions`.`SourceTypeOrReferenceId` = 2) then 'CONDITION_ITEM' when (`conditions`.`SourceTypeOrReferenceId` = 3) then 'CONDITION_ITEM_EQUIPPED' when (`conditions`.`SourceTypeOrReferenceId` = 4) then 'CONDITION_ZONEID' when (`conditions`.`SourceTypeOrReferenceId` = 5) then 'CONDITION_REPUTATION_RANK' when (`conditions`.`SourceTypeOrReferenceId` = 6) then 'CONDITION_TEAM' when (`conditions`.`SourceTypeOrReferenceId` = 7) then 'CONDITION_SKILL' when (`conditions`.`SourceTypeOrReferenceId` = 8) then 'CONDITION_QUESTREWARDED' when (`conditions`.`SourceTypeOrReferenceId` = 9) then 'CONDITION_QUESTTAKEN' when (`conditions`.`SourceTypeOrReferenceId` = 10) then 'CONDITION_DRUNKENSTATE' when (`conditions`.`SourceTypeOrReferenceId` = 11) then 'CONDITION_WORLD_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 12) then 'CONDITION_ACTIVE_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 13) then 'CONDITION_INSTANCE_INFO' when (`conditions`.`SourceTypeOrReferenceId` = 14) then 'CONDITION_QUEST_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 15) then 'CONDITION_CLASS' when (`conditions`.`SourceTypeOrReferenceId` = 16) then 'CONDITION_RACE' when (`conditions`.`SourceTypeOrReferenceId` = 17) then 'CONDITION_ACHIEVEMENT' when (`conditions`.`SourceTypeOrReferenceId` = 18) then 'CONDITION_TITLE' when (`conditions`.`SourceTypeOrReferenceId` = 19) then 'CONDITION_SPAWNMASK' when (`conditions`.`SourceTypeOrReferenceId` = 20) then 'CONDITION_GENDER' when (`conditions`.`SourceTypeOrReferenceId` = 21) then 'CONDITION_UNIT_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 22) then 'CONDITION_MAPID' when (`conditions`.`SourceTypeOrReferenceId` = 23) then 'CONDITION_AREAID' when (`conditions`.`SourceTypeOrReferenceId` = 24) then 'CONDITION_CREATURE_TYPE' when (`conditions`.`SourceTypeOrReferenceId` = 25) then 'CONDITION_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 26) then 'CONDITION_PHASEMASK' when (`conditions`.`SourceTypeOrReferenceId` = 27) then 'CONDITION_LEVEL' when (`conditions`.`SourceTypeOrReferenceId` = 28) then 'CONDITION_QUEST_COMPLETE' when (`conditions`.`SourceTypeOrReferenceId` = 29) then 'CONDITION_NEAR_CREATURE' when (`conditions`.`SourceTypeOrReferenceId` = 30) then 'CONDITION_NEAR_GAMEOBJECT' when (`conditions`.`SourceTypeOrReferenceId` = 31) then 'CONDITION_OBJECT_ENTRY_GUID' when (`conditions`.`SourceTypeOrReferenceId` = 32) then 'CONDITION_TYPE_MASK' when (`conditions`.`SourceTypeOrReferenceId` = 33) then 'CONDITION_RELATION_TO' when (`conditions`.`SourceTypeOrReferenceId` = 34) then 'CONDITION_REACTION_TO' when (`conditions`.`SourceTypeOrReferenceId` = 35) then 'CONDITION_DISTANCE_TO' when (`conditions`.`SourceTypeOrReferenceId` = 36) then 'CONDITION_ALIVE' when (`conditions`.`SourceTypeOrReferenceId` = 37) then 'CONDITION_HP_VAL' when (`conditions`.`SourceTypeOrReferenceId` = 38) then 'CONDITION_HP_PCT' when (`conditions`.`SourceTypeOrReferenceId` = 39) then 'CONDITION_REALM_ACHIEVEMENT' when (`conditions`.`SourceTypeOrReferenceId` = 40) then 'CONDITION_IN_WATER' when (`conditions`.`SourceTypeOrReferenceId` = 41) then 'CONDITION_TERRAIN_SWAP' when (`conditions`.`SourceTypeOrReferenceId` = 42) then 'CONDITION_STAND_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 43) then 'CONDITION_DAILY_QUEST_DONE' when (`conditions`.`SourceTypeOrReferenceId` = 44) then 'CONDITION_CHARMED' when (`conditions`.`SourceTypeOrReferenceId` = 45) then 'CONDITION_PET_TYPE' when (`conditions`.`SourceTypeOrReferenceId` = 46) then 'CONDITION_TAXI' when (`conditions`.`SourceTypeOrReferenceId` = 47) then 'CONDITION_QUESTSTATE' when (`conditions`.`SourceTypeOrReferenceId` = 48) then 'CONDITION_QUEST_OBJECTIVE_PROGRESS' when (`conditions`.`SourceTypeOrReferenceId` = 49) then 'CONDITION_DIFFICULTY_ID' when (`conditions`.`SourceTypeOrReferenceId` = 50) then 'CONDITION_GAMEMASTER' when (`conditions`.`SourceTypeOrReferenceId` = 51) then 'CONDITION_OBJECT_ENTRY_GUID_MASTER' when (`conditions`.`SourceTypeOrReferenceId` = 52) then 'CONDITION_TYPE_MASK_MASTER' else `conditions`.`ConditionTypeOrReference` end) AS `ConditionTypeOrReference`,`conditions`.`ConditionTarget` AS `ConditionTarget`,`conditions`.`ConditionValue1` AS `ConditionValue1`,`conditions`.`ConditionValue2` AS `ConditionValue2`,`conditions`.`ConditionValue3` AS `ConditionValue3`,`conditions`.`NegativeCondition` AS `NegativeCondition`,`conditions`.`ErrorType` AS `ErrorType`,`conditions`.`ErrorTextId` AS `ErrorTextId`,`conditions`.`ScriptName` AS `ScriptName`,`conditions`.`Comment` AS `Comment` from `conditions`) */;
+/*!50001 SET character_set_client = @saved_cs_client */;
+/*!50001 SET character_set_results = @saved_cs_results */;
+/*!50001 SET collation_connection = @saved_col_connection */;
+
+--
+-- Final view structure for view `vw_disables_with_labels`
+--
+
+/*!50001 DROP VIEW IF EXISTS `vw_disables_with_labels`*/;
+/*!50001 SET @saved_cs_client = @@character_set_client */;
+/*!50001 SET @saved_cs_results = @@character_set_results */;
+/*!50001 SET @saved_col_connection = @@collation_connection */;
+/*!50001 SET character_set_client = utf8 */;
+/*!50001 SET character_set_results = utf8 */;
+/*!50001 SET collation_connection = utf8_general_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 */
+/*!50001 VIEW `vw_disables_with_labels` AS (select (case when (`disables`.`sourceType` = 0) then 'DISABLE_TYPE_SPELL' when (`disables`.`sourceType` = 1) then 'DISABLE_TYPE_QUEST' when (`disables`.`sourceType` = 2) then 'DISABLE_TYPE_MAP' when (`disables`.`sourceType` = 3) then 'DISABLE_TYPE_BATTLEGROUND' when (`disables`.`sourceType` = 4) then 'DISABLE_TYPE_ACHIEVEMENT_CRITERIA' when (`disables`.`sourceType` = 5) then 'DISABLE_TYPE_OUTDOORPVP' when (`disables`.`sourceType` = 6) then 'DISABLE_TYPE_VMAP' when (`disables`.`sourceType` = 7) then 'DISABLE_TYPE_MMAP' when (`disables`.`sourceType` = 8) then 'DISABLE_TYPE_LFG_MAP' else `disables`.`sourceType` end) AS `sourceType`,`disables`.`entry` AS `entry`,`disables`.`flags` AS `flags`,`disables`.`params_0` AS `params_0`,`disables`.`params_1` AS `params_1`,`disables`.`comment` AS `comment` from `disables`) */;
+/*!50001 SET character_set_client = @saved_cs_client */;
+/*!50001 SET character_set_results = @saved_cs_results */;
+/*!50001 SET collation_connection = @saved_col_connection */;
+
+--
-- Final view structure for view `vw_smart_scripts_with_labels`
--
@@ -3948,4 +4027,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2020-08-22 16:27:28
+-- Dump completed on 2020-09-15 19:35:21
diff --git a/sql/updates/auth/3.3.5/2020_08_22_00_auth.sql b/sql/old/3.3.5a/auth/20082_2020_09_15/2020_08_22_00_auth.sql
index bd3423adffd..bd3423adffd 100644
--- a/sql/updates/auth/3.3.5/2020_08_22_00_auth.sql
+++ b/sql/old/3.3.5a/auth/20082_2020_09_15/2020_08_22_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2020_09_06_00_auth.sql b/sql/old/3.3.5a/auth/20082_2020_09_15/2020_09_06_00_auth.sql
index d04bdf6f4fe..d04bdf6f4fe 100644
--- a/sql/updates/auth/3.3.5/2020_09_06_00_auth.sql
+++ b/sql/old/3.3.5a/auth/20082_2020_09_15/2020_09_06_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2020_08_22_00_characters.sql b/sql/old/3.3.5a/characters/20082_2020_09_15/2020_08_22_00_characters.sql
index f5d9494240b..f5d9494240b 100644
--- a/sql/updates/characters/3.3.5/2020_08_22_00_characters.sql
+++ b/sql/old/3.3.5a/characters/20082_2020_09_15/2020_08_22_00_characters.sql
diff --git a/sql/updates/characters/3.3.5/2020_09_02_00_characters.sql b/sql/old/3.3.5a/characters/20082_2020_09_15/2020_09_02_00_characters.sql
index 058a34f93f4..058a34f93f4 100644
--- a/sql/updates/characters/3.3.5/2020_09_02_00_characters.sql
+++ b/sql/old/3.3.5a/characters/20082_2020_09_15/2020_09_02_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2020_08_22_02_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_02_world.sql
index 88b0ab9a224..88b0ab9a224 100644
--- a/sql/updates/world/3.3.5/2020_08_22_02_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_22_03_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_03_world.sql
index 8b528479835..8b528479835 100644
--- a/sql/updates/world/3.3.5/2020_08_22_03_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_22_04_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_04_world.sql
index 9bac2e2aa02..9bac2e2aa02 100644
--- a/sql/updates/world/3.3.5/2020_08_22_04_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_22_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_23_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_23_00_world.sql
index 1c77738405b..1c77738405b 100644
--- a/sql/updates/world/3.3.5/2020_08_23_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_23_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_23_01_world.sql
index d88ea73422a..d88ea73422a 100644
--- a/sql/updates/world/3.3.5/2020_08_23_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_23_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_24_00_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_00_world_335.sql
index d1c654972c1..d1c654972c1 100644
--- a/sql/updates/world/3.3.5/2020_08_24_00_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_24_01_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_01_world_335.sql
index 70e3f2683dc..70e3f2683dc 100644
--- a/sql/updates/world/3.3.5/2020_08_24_01_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_24_02_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_02_world_335.sql
index ba001057f88..ba001057f88 100644
--- a/sql/updates/world/3.3.5/2020_08_24_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_24_03_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_03_world_335.sql
index 6928ff340ff..6928ff340ff 100644
--- a/sql/updates/world/3.3.5/2020_08_24_03_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_24_04_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_04_world_335.sql
index 09a1e720dfc..09a1e720dfc 100644
--- a/sql/updates/world/3.3.5/2020_08_24_04_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_24_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_26_00_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_00_world_335.sql
index 38bc45e5fd8..38bc45e5fd8 100644
--- a/sql/updates/world/3.3.5/2020_08_26_00_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_26_01_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_01_world_335.sql
index f6c146135f8..f6c146135f8 100644
--- a/sql/updates/world/3.3.5/2020_08_26_01_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_26_02_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_02_world_335.sql
index c7f4d27b2da..c7f4d27b2da 100644
--- a/sql/updates/world/3.3.5/2020_08_26_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_26_03_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_03_world.sql
index 6da84679fd8..6da84679fd8 100644
--- a/sql/updates/world/3.3.5/2020_08_26_03_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_26_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_27_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_00_world.sql
index 870726c3477..870726c3477 100644
--- a/sql/updates/world/3.3.5/2020_08_27_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_27_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_01_world.sql
index 5cc62d1d641..5cc62d1d641 100644
--- a/sql/updates/world/3.3.5/2020_08_27_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_27_02_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_02_world_335.sql
index b745a6a32b8..b745a6a32b8 100644
--- a/sql/updates/world/3.3.5/2020_08_27_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_27_03_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_03_world.sql
index 197c90f52e1..197c90f52e1 100644
--- a/sql/updates/world/3.3.5/2020_08_27_03_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_27_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_28_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_00_world.sql
index 24c86d0f2c1..24c86d0f2c1 100644
--- a/sql/updates/world/3.3.5/2020_08_28_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_28_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_01_world.sql
index 53afbd4e0d1..53afbd4e0d1 100644
--- a/sql/updates/world/3.3.5/2020_08_28_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_28_02_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_02_world.sql
index 19e99c54bc8..19e99c54bc8 100644
--- a/sql/updates/world/3.3.5/2020_08_28_02_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_28_03_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_03_world.sql
index 788887ef03b..788887ef03b 100644
--- a/sql/updates/world/3.3.5/2020_08_28_03_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_28_04_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_04_world.sql
index fa4040cab55..fa4040cab55 100644
--- a/sql/updates/world/3.3.5/2020_08_28_04_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_28_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_29_00_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_00_world_335.sql
index 9e09313fedf..9e09313fedf 100644
--- a/sql/updates/world/3.3.5/2020_08_29_00_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_29_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_01_world.sql
index 43cf79092a3..43cf79092a3 100644
--- a/sql/updates/world/3.3.5/2020_08_29_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_29_02_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_02_world_335.sql
index 59947d8f77f..59947d8f77f 100644
--- a/sql/updates/world/3.3.5/2020_08_29_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_29_03_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_03_world_335.sql
index 54343391cb1..54343391cb1 100644
--- a/sql/updates/world/3.3.5/2020_08_29_03_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_29_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_31_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_00_world.sql
index 50e89380780..50e89380780 100644
--- a/sql/updates/world/3.3.5/2020_08_31_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_31_01_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_01_world_335.sql
index 403b30c7b2d..403b30c7b2d 100644
--- a/sql/updates/world/3.3.5/2020_08_31_01_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_31_02_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_02_world_335.sql
index 5e893f29e7e..5e893f29e7e 100644
--- a/sql/updates/world/3.3.5/2020_08_31_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_31_03_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_03_world_335.sql
index 01b57428052..01b57428052 100644
--- a/sql/updates/world/3.3.5/2020_08_31_03_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_31_04_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_04_world_335.sql
index 69907ae7f61..69907ae7f61 100644
--- a/sql/updates/world/3.3.5/2020_08_31_04_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_08_31_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_04_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_00_world.sql
index 809f26df858..809f26df858 100644
--- a/sql/updates/world/3.3.5/2020_09_04_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_04_01_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_01_world_335.sql
index 8ca450b2bb4..8ca450b2bb4 100644
--- a/sql/updates/world/3.3.5/2020_09_04_01_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_04_02_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_02_world_335.sql
index b20cc0dc2dd..b20cc0dc2dd 100644
--- a/sql/updates/world/3.3.5/2020_09_04_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_04_03_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_03_world_335.sql
index 1c83bfc722d..1c83bfc722d 100644
--- a/sql/updates/world/3.3.5/2020_09_04_03_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_04_04_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_04_world_335.sql
index 377bd69731f..377bd69731f 100644
--- a/sql/updates/world/3.3.5/2020_09_04_04_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_04_05_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_05_world_335.sql
index ceb6f635e0f..ceb6f635e0f 100644
--- a/sql/updates/world/3.3.5/2020_09_04_05_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_04_06_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_06_world.sql
index 6e8215ab2be..6e8215ab2be 100644
--- a/sql/updates/world/3.3.5/2020_09_04_06_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_04_06_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_06_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_00_world.sql
index 5fc01df74f5..5fc01df74f5 100644
--- a/sql/updates/world/3.3.5/2020_09_06_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_06_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_01_world.sql
index 6224f1f9621..6224f1f9621 100644
--- a/sql/updates/world/3.3.5/2020_09_06_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_06_02_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_02_world.sql
index 8c7c21dcd46..8c7c21dcd46 100644
--- a/sql/updates/world/3.3.5/2020_09_06_02_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_06_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_08_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_00_world.sql
index 97bfb0b992d..97bfb0b992d 100644
--- a/sql/updates/world/3.3.5/2020_09_08_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_08_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_01_world.sql
index 1449331f8a3..1449331f8a3 100644
--- a/sql/updates/world/3.3.5/2020_09_08_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_08_02_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_02_world.sql
index 9f50fd4167c..9f50fd4167c 100644
--- a/sql/updates/world/3.3.5/2020_09_08_02_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_08_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_00_world.sql
index 05fcd7d2acd..05fcd7d2acd 100644
--- a/sql/updates/world/3.3.5/2020_09_09_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_01_world.sql
index 10774dc9c49..10774dc9c49 100644
--- a/sql/updates/world/3.3.5/2020_09_09_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_02_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_02_world_335.sql
index 8fc5cdb38c7..8fc5cdb38c7 100644
--- a/sql/updates/world/3.3.5/2020_09_09_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_03_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_03_world_335.sql
index 9332b89be4b..9332b89be4b 100644
--- a/sql/updates/world/3.3.5/2020_09_09_03_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_04_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_04_world_335.sql
index 5a1d179d7be..5a1d179d7be 100644
--- a/sql/updates/world/3.3.5/2020_09_09_04_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_05_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_05_world_335.sql
index 557c8e0ec63..557c8e0ec63 100644
--- a/sql/updates/world/3.3.5/2020_09_09_05_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_06_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_06_world_335.sql
index b43278bbf05..b43278bbf05 100644
--- a/sql/updates/world/3.3.5/2020_09_09_06_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_06_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_07_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_07_world_335.sql
index f06593bfe14..f06593bfe14 100644
--- a/sql/updates/world/3.3.5/2020_09_09_07_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_07_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_09_08_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_08_world.sql
index 23c5dd7bec2..23c5dd7bec2 100644
--- a/sql/updates/world/3.3.5/2020_09_09_08_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_09_08_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_10_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_10_00_world.sql
index a2e9d6b964a..a2e9d6b964a 100644
--- a/sql/updates/world/3.3.5/2020_09_10_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_00_world.sql
index f66646875e7..f66646875e7 100644
--- a/sql/updates/world/3.3.5/2020_09_12_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_01_world.sql
index c7297c7c846..c7297c7c846 100644
--- a/sql/updates/world/3.3.5/2020_09_12_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_02_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_02_world.sql
index b080eb937dc..b080eb937dc 100644
--- a/sql/updates/world/3.3.5/2020_09_12_02_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_03_world_335.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_03_world_335.sql
index a8118f0f9b7..a8118f0f9b7 100644
--- a/sql/updates/world/3.3.5/2020_09_12_03_world_335.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_04_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_04_world.sql
index 0c97b1d252b..0c97b1d252b 100644
--- a/sql/updates/world/3.3.5/2020_09_12_04_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_05_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_05_world.sql
index 90ac14a4cc2..90ac14a4cc2 100644
--- a/sql/updates/world/3.3.5/2020_09_12_05_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_05_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_06_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_06_world.sql
index f9061c2d673..f9061c2d673 100644
--- a/sql/updates/world/3.3.5/2020_09_12_06_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_06_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_07_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_07_world.sql
index 24fe556f365..24fe556f365 100644
--- a/sql/updates/world/3.3.5/2020_09_12_07_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_07_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_12_08_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_08_world.sql
index ede9aa57bf0..ede9aa57bf0 100644
--- a/sql/updates/world/3.3.5/2020_09_12_08_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_12_08_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_13_00_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_13_00_world.sql
index f1696998b4c..f1696998b4c 100644
--- a/sql/updates/world/3.3.5/2020_09_13_00_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_13_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_09_13_01_world.sql b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_13_01_world.sql
index 07bdd59494b..07bdd59494b 100644
--- a/sql/updates/world/3.3.5/2020_09_13_01_world.sql
+++ b/sql/old/3.3.5a/world/20082_2020_09_15/2020_09_13_01_world.sql
diff --git a/sql/updates/auth/3.3.5/2020_09_15_00_auth.sql b/sql/updates/auth/3.3.5/2020_09_15_00_auth.sql
new file mode 100644
index 00000000000..5cb125b7ddc
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2020_09_15_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20091 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2020_09_15_00_characters.sql b/sql/updates/characters/3.3.5/2020_09_15_00_characters.sql
new file mode 100644
index 00000000000..0f00721aeda
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2020_09_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20091 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2020_09_15_00_world.sql b/sql/updates/world/3.3.5/2020_09_15_00_world.sql
new file mode 100644
index 00000000000..fa2caa22c04
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_09_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.20091 world
+UPDATE `version` SET `db_version`='TDB 335.20091', `cache_id`=20091 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';