TDB 335.21101 - 2021/10/15TDB335.21101

33 files changed, 32 insertions, 6 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 5d3203fa528..bab147ad407 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.21091_2021_09_28.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.21101_2021_10_15.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-@rev_year@ TrinityCore"
  #define VER_FILEVERSION            0,0,0
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 9e5e9a975bc..6b23fce3edb 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1993,7 +1993,8 @@ INSERT INTO `updates` VALUES
 ('2021_06_20_00_auth.sql','7CA418D570DC1444C19AAD18F4A50FF187642310','ARCHIVED','2021-06-20 17:29:17',0),
 ('2021_07_15_00_auth.sql','C8B29D477A5A6704775517EF8203871BFE3D4906','ARCHIVED','2021-07-15 07:32:48',0),
 ('2021_08_15_00_auth.sql','256E06BF052C246B92B61AD7DD6233D98EEA6E9E','ARCHIVED','2021-08-15 16:59:31',0),
-('2021_09_28_00_auth.sql','07B3ECF2EBAF1F1C3692059CB3A05B1088A93E18','ARCHIVED','2021-09-28 20:48:10',0);
+('2021_09_28_00_auth.sql','07B3ECF2EBAF1F1C3692059CB3A05B1088A93E18','ARCHIVED','2021-09-28 20:48:10',0),
+('2021_10_15_00_auth.sql','4FFD29A3ED1DB13874E755A84BFD7ABA2DF5C2DB','ARCHIVED','2021-10-15 08:43:41',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2132,4 +2133,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-09-28 20:48:13
+-- Dump completed on 2021-10-15  8:43:43
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 65e1d98bea8..cb8f8c2fa06 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2667,7 +2667,8 @@ INSERT INTO `updates` VALUES
 ('2021_07_15_00_characters.sql','2ACFF71253DEA0F059476AEA52A55196E6D5DCFE','ARCHIVED','2021-07-15 07:32:48',0),
 ('2021_07_18_00_characters.sql','0BA579ED21F4E75AC2B4797421B5029568B3F6E2','ARCHIVED','2021-07-18 11:55:00',0),
 ('2021_08_15_00_characters.sql','A8A32D47C65FB6A0C7995F8342D85B6A50C6C63F','ARCHIVED','2021-08-15 16:59:31',0),
-('2021_09_28_00_characters.sql','A57869AE14FFFA935AB57318F65F4F1217AA2421','ARCHIVED','2021-09-28 20:48:10',0);
+('2021_09_28_00_characters.sql','A57869AE14FFFA935AB57318F65F4F1217AA2421','ARCHIVED','2021-09-28 20:48:10',0),
+('2021_10_15_00_characters.sql','174355CFEA8FADA50B731F54E028561AFCF46AA6','ARCHIVED','2021-10-15 08:43:41',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2838,4 +2839,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-09-28 20:48:13
+-- Dump completed on 2021-10-15  8:43:44
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 254a4a4871b..bf3274c62b1 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -360,6 +360,7 @@ CREATE TABLE `creature_addon` (
   `guid` int(10) unsigned NOT NULL DEFAULT '0',
   `path_id` int(10) unsigned NOT NULL DEFAULT '0',
   `mount` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `MountCreatureID` int(10) unsigned NOT NULL DEFAULT '0',
   `bytes1` int(10) unsigned NOT NULL DEFAULT '0',
   `bytes2` int(10) unsigned NOT NULL DEFAULT '1',
   `emote` int(10) unsigned NOT NULL DEFAULT '0',
@@ -485,6 +486,21 @@ CREATE TABLE `creature_model_info` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `creature_movement_info`
+--
+
+DROP TABLE IF EXISTS `creature_movement_info`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_movement_info` (
+  `MovementID` int(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template.movementId value',
+  `WalkSpeed` float unsigned DEFAULT NULL,
+  `RunSpeed` float unsigned DEFAULT NULL,
+  PRIMARY KEY (`MovementID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `creature_movement_override`
 --
 
@@ -674,6 +690,7 @@ CREATE TABLE `creature_template_addon` (
   `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `path_id` int(10) unsigned NOT NULL DEFAULT '0',
   `mount` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `MountCreatureID` int(10) unsigned NOT NULL DEFAULT '0',
   `bytes1` int(10) unsigned NOT NULL DEFAULT '0',
   `bytes2` int(10) unsigned NOT NULL DEFAULT '1',
   `emote` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -4044,4 +4061,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-09-28 20:48:13
+-- Dump completed on 2021-10-15  8:43:44
diff --git a/sql/updates/auth/3.3.5/2021_09_28_00_auth.sql b/sql/old/3.3.5a/auth/21091_2021_10_15/2021_09_28_00_auth.sql
index 59d08fb98b4..59d08fb98b4 100644
--- a/sql/updates/auth/3.3.5/2021_09_28_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21091_2021_10_15/2021_09_28_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2021_09_28_00_characters.sql b/sql/old/3.3.5a/characters/21091_2021_10_15/2021_09_28_00_characters.sql
index b8f2d6228f7..b8f2d6228f7 100644
--- a/sql/updates/characters/3.3.5/2021_09_28_00_characters.sql
+++ b/sql/old/3.3.5a/characters/21091_2021_10_15/2021_09_28_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2021_09_28_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_01_world.sql
index 59569c06bf9..59569c06bf9 100644
--- a/sql/updates/world/3.3.5/2021_09_28_01_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_28_02_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_02_world.sql
index 7b6cb00f1a7..7b6cb00f1a7 100644
--- a/sql/updates/world/3.3.5/2021_09_28_02_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_01_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_00_world.sql
index a32f8532e3f..a32f8532e3f 100644
--- a/sql/updates/world/3.3.5/2021_10_01_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_01_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_01_world.sql
index 217ca50bfb0..217ca50bfb0 100644
--- a/sql/updates/world/3.3.5/2021_10_01_01_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_01_02_world_335.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_02_world_335.sql
index 6bf71977a15..6bf71977a15 100644
--- a/sql/updates/world/3.3.5/2021_10_01_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_10_01_03_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_03_world.sql
index 6562030f709..6562030f709 100644
--- a/sql/updates/world/3.3.5/2021_10_01_03_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_01_04_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_04_world.sql
index 49929bb8f1c..49929bb8f1c 100644
--- a/sql/updates/world/3.3.5/2021_10_01_04_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_04_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_01_05_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_05_world.sql
index 3de765d5bee..3de765d5bee 100644
--- a/sql/updates/world/3.3.5/2021_10_01_05_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_05_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_01_06_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_06_world.sql
index a85c978bdce..a85c978bdce 100644
--- a/sql/updates/world/3.3.5/2021_10_01_06_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_06_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_02_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_02_00_world.sql
index 71c4ce7f89b..71c4ce7f89b 100644
--- a/sql/updates/world/3.3.5/2021_10_02_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_02_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_04_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_00_world.sql
index baa42f5590f..baa42f5590f 100644
--- a/sql/updates/world/3.3.5/2021_10_04_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_04_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_01_world.sql
index dc31b2c5ced..dc31b2c5ced 100644
--- a/sql/updates/world/3.3.5/2021_10_04_01_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_04_02_world_335.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_02_world_335.sql
index 72b57300516..72b57300516 100644
--- a/sql/updates/world/3.3.5/2021_10_04_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_10_07_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_07_00_world.sql
index fe6cc6dddcc..fe6cc6dddcc 100644
--- a/sql/updates/world/3.3.5/2021_10_07_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_08_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_00_world.sql
index f848ee97abb..f848ee97abb 100644
--- a/sql/updates/world/3.3.5/2021_10_08_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_08_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_01_world.sql
index 89697c6468a..89697c6468a 100644
--- a/sql/updates/world/3.3.5/2021_10_08_01_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_08_02_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_02_world.sql
index 59b306e96ea..59b306e96ea 100644
--- a/sql/updates/world/3.3.5/2021_10_08_02_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_09_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_00_world.sql
index 052636740a8..052636740a8 100644
--- a/sql/updates/world/3.3.5/2021_10_09_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_09_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_01_world.sql
index 136f32181c5..136f32181c5 100644
--- a/sql/updates/world/3.3.5/2021_10_09_01_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_10_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_10_00_world.sql
index 306f3ca200f..306f3ca200f 100644
--- a/sql/updates/world/3.3.5/2021_10_10_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_12_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_00_world.sql
index bd8cb88174a..bd8cb88174a 100644
--- a/sql/updates/world/3.3.5/2021_10_12_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_12_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_01_world.sql
index c215e20599c..c215e20599c 100644
--- a/sql/updates/world/3.3.5/2021_10_12_01_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_13_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_13_00_world.sql
index 190ed06a9a9..190ed06a9a9 100644
--- a/sql/updates/world/3.3.5/2021_10_13_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_13_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_10_14_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_14_00_world.sql
index 03e46e4e8bf..03e46e4e8bf 100644
--- a/sql/updates/world/3.3.5/2021_10_14_00_world.sql
+++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_14_00_world.sql
diff --git a/sql/updates/auth/3.3.5/2021_10_15_00_auth.sql b/sql/updates/auth/3.3.5/2021_10_15_00_auth.sql
new file mode 100644
index 00000000000..8d15b158a75
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2021_10_15_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21101 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2021_10_15_00_characters.sql b/sql/updates/characters/3.3.5/2021_10_15_00_characters.sql
new file mode 100644
index 00000000000..fa084278181
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2021_10_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21101 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2021_10_15_00_world.sql b/sql/updates/world/3.3.5/2021_10_15_00_world.sql
new file mode 100644
index 00000000000..b711facf1b5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_10_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.21101 world
+UPDATE `version` SET `db_version`='TDB 335.21101', `cache_id`=21101 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';