diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
-rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
-rw-r--r-- | sql/base/dev/world_database.sql | 81 | ||||
-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.sql | 2 | ||||
-rw-r--r-- | sql/updates/characters/3.3.5/2020_09_15_00_characters.sql | 2 | ||||
-rw-r--r-- | sql/updates/world/3.3.5/2020_09_15_00_world.sql | 3 |
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'; |