TDB 335.19111 - 2019/11/16TDB335.19111

31 files changed, 15 insertions, 6 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index b9b6ded3f8c..7ded2adef81 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -9,7 +9,7 @@
  #define _SOURCE_DIRECTORY          R"(@CMAKE_SOURCE_DIR@)"
  #define _BUILD_DIRECTORY           R"(@BUILDDIR@)"
  #define _MYSQL_EXECUTABLE          R"(@MYSQL_EXECUTABLE@)"
- #define _FULL_DATABASE             "TDB_full_world_335.19101_2019_10_18.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.19111_2019_11_16.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-2019 TrinityCore"
  #define VER_FILEVERSION            0,0,0
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index f89763a4a48..6c710464b68 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1835,7 +1835,8 @@ INSERT INTO `updates` VALUES
 ('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0),
 ('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0),
 ('2019_09_15_00_auth.sql','2EEE632B5A365D45747B7BB25DE5239FB5B1A1BD','ARCHIVED','2019-09-15 09:21:36',0),
-('2019_10_18_00_auth.sql','DFEDA33D7B9A108773B6AD8DE3016C6B12BD3832','ARCHIVED','2019-10-18 08:37:37',0);
+('2019_10_18_00_auth.sql','DFEDA33D7B9A108773B6AD8DE3016C6B12BD3832','ARCHIVED','2019-10-18 08:37:37',0),
+('2019_11_16_00_auth.sql','A7CC55B9329F0DDFE91ADC31BFABD0D934ED0A5E','ARCHIVED','2019-11-16 12:06:06',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -1937,4 +1938,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-10-18  8:37:47
+-- Dump completed on 2019-11-16 12:06:07
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 9ffb354cc98..0e696ea72e3 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2638,7 +2638,8 @@ INSERT INTO `updates` VALUES
 ('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0),
 ('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0),
 ('2019_09_15_00_characters.sql','75F3355AF6E9C0A2CAF5F523D87208C726C9D042','ARCHIVED','2019-09-15 09:21:36',0),
-('2019_10_18_00_characters.sql','143669FB0AA803C7287A4FF4ABE85F45F63369E5','ARCHIVED','2019-10-18 08:37:37',0);
+('2019_10_18_00_characters.sql','143669FB0AA803C7287A4FF4ABE85F45F63369E5','ARCHIVED','2019-10-18 08:37:37',0),
+('2019_11_16_00_characters.sql','F29BBE2869E2187B278B27236A3D156B849F0E43','ARCHIVED','2019-11-16 12:06:06',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2805,4 +2806,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-10-18  8:37:47
+-- Dump completed on 2019-11-16 12:06:07
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 17f45fe713d..9d7d17f4c69 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -3843,4 +3843,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-10-18  8:37:47
+-- Dump completed on 2019-11-16 12:06:07
diff --git a/sql/updates/auth/3.3.5/2019_10_18_00_auth.sql b/sql/old/3.3.5a/auth/19101_2019_11_16/2019_10_18_00_auth.sql
index 78f7ecf4167..78f7ecf4167 100644
--- a/sql/updates/auth/3.3.5/2019_10_18_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19101_2019_11_16/2019_10_18_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2019_10_18_00_characters.sql b/sql/old/3.3.5a/characters/19101_2019_11_16/2019_10_18_00_characters.sql
index 6fa0cc4e878..6fa0cc4e878 100644
--- a/sql/updates/characters/3.3.5/2019_10_18_00_characters.sql
+++ b/sql/old/3.3.5a/characters/19101_2019_11_16/2019_10_18_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2019_10_18_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_18_00_world.sql
index 2230240af2b..2230240af2b 100644
--- a/sql/updates/world/3.3.5/2019_10_18_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_18_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_20_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_00_world.sql
index c41161d61ab..c41161d61ab 100644
--- a/sql/updates/world/3.3.5/2019_10_20_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_20_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_01_world.sql
index 62865c7c63b..62865c7c63b 100644
--- a/sql/updates/world/3.3.5/2019_10_20_01_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_20_02_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_02_world.sql
index 6ed5ad174f1..6ed5ad174f1 100644
--- a/sql/updates/world/3.3.5/2019_10_20_02_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_21_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_00_world.sql
index 085dfc4a44f..085dfc4a44f 100644
--- a/sql/updates/world/3.3.5/2019_10_21_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_21_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_01_world.sql
index 0350e637f3d..0350e637f3d 100644
--- a/sql/updates/world/3.3.5/2019_10_21_01_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_21_02_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_02_world.sql
index 446e3b568b9..446e3b568b9 100644
--- a/sql/updates/world/3.3.5/2019_10_21_02_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_21_03_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_03_world.sql
index 2bd16f61a5e..2bd16f61a5e 100644
--- a/sql/updates/world/3.3.5/2019_10_21_03_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_22_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_00_world.sql
index d3db029bdd1..d3db029bdd1 100644
--- a/sql/updates/world/3.3.5/2019_10_22_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_22_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_01_world.sql
index 2b1941f464b..2b1941f464b 100644
--- a/sql/updates/world/3.3.5/2019_10_22_01_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_22_02_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_02_world.sql
index eeaa4ebea22..eeaa4ebea22 100644
--- a/sql/updates/world/3.3.5/2019_10_22_02_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_22_03_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_03_world.sql
index 1fe3adeee65..1fe3adeee65 100644
--- a/sql/updates/world/3.3.5/2019_10_22_03_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_26_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_26_00_world.sql
index 27fd0eb82e3..27fd0eb82e3 100644
--- a/sql/updates/world/3.3.5/2019_10_26_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_26_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_10_29_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_29_00_world.sql
index e2709b0ae4b..e2709b0ae4b 100644
--- a/sql/updates/world/3.3.5/2019_10_29_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_29_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_11_03_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_00_world.sql
index d9070063b23..d9070063b23 100644
--- a/sql/updates/world/3.3.5/2019_11_03_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_11_03_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_01_world.sql
index 60ca202b872..60ca202b872 100644
--- a/sql/updates/world/3.3.5/2019_11_03_01_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_11_09_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_00_world.sql
index 1e65ad0d912..1e65ad0d912 100644
--- a/sql/updates/world/3.3.5/2019_11_09_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_11_09_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_01_world.sql
index 86aa7c5c177..86aa7c5c177 100644
--- a/sql/updates/world/3.3.5/2019_11_09_01_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_11_12_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_00_world.sql
index cef83d47b36..cef83d47b36 100644
--- a/sql/updates/world/3.3.5/2019_11_12_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_11_12_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_01_world.sql
index 15c1b650bae..15c1b650bae 100644
--- a/sql/updates/world/3.3.5/2019_11_12_01_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_11_14_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_00_world.sql
index 3b8ede9f947..3b8ede9f947 100644
--- a/sql/updates/world/3.3.5/2019_11_14_00_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_11_14_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_01_world.sql
index 028604de7c8..028604de7c8 100644
--- a/sql/updates/world/3.3.5/2019_11_14_01_world.sql
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_01_world.sql
diff --git a/sql/updates/auth/3.3.5/2019_11_16_00_auth.sql b/sql/updates/auth/3.3.5/2019_11_16_00_auth.sql
new file mode 100644
index 00000000000..8710b550286
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2019_11_16_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19111 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2019_11_16_00_characters.sql b/sql/updates/characters/3.3.5/2019_11_16_00_characters.sql
new file mode 100644
index 00000000000..7506a3e1a2c
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2019_11_16_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19111 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2019_11_16_00_world.sql b/sql/updates/world/3.3.5/2019_11_16_00_world.sql
new file mode 100644
index 00000000000..b96aa756c38
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_11_16_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.19111 world
+UPDATE `version` SET `db_version`='TDB 335.19111', `cache_id`=19111 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';