TDB 335.21021 - 2021/02/15TDB335.21021

3 files changed, 22 insertions, 18 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index b5fc36682ae..701f60e3aa6 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1981,7 +1981,8 @@ INSERT INTO `updates` VALUES
 ('2020_11_16_00_auth.sql','C0E1AAA8876DB65B2B2FA0AFD5D6CDF233020D37','ARCHIVED','2020-11-16 13:37:22',0),
 ('2020_12_15_00_auth.sql','C416FC93AF6BC33A6CE59185CEB03B4945701233','ARCHIVED','2020-12-15 22:47:26',0),
 ('2020_12_31_00_auth.sql','05C9C105D55C6588CDA0D75AE3B135B7E6B54C06','ARCHIVED','2020-12-31 12:58:21',0),
-('2021_01_15_00_auth.sql','604B8B799F031C1074314D4D8081797CC8B22FE2','ARCHIVED','2021-01-15 08:29:32',0);
+('2021_01_15_00_auth.sql','604B8B799F031C1074314D4D8081797CC8B22FE2','ARCHIVED','2021-01-15 08:29:32',0),
+('2021_02_15_00_auth.sql','652C38A140C0B2C7E898A2F7A7AC799CA2440315','ARCHIVED','2021-02-15 12:37:46',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2087,4 +2088,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-01-15  8:29:39
+-- Dump completed on 2021-02-15 12:37:50
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index b6a9d29091b..bf4a00e729e 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2657,7 +2657,8 @@ INSERT INTO `updates` VALUES
 ('2020_10_15_00_characters.sql','72F769B6EFFA4C2C5E08235C89EF2629C0FA82EF','ARCHIVED','2020-10-15 07:33:14',0),
 ('2020_11_16_00_characters.sql','6389519BF44A6EC61E744E6A9727E9448337A276','ARCHIVED','2020-11-16 13:37:22',0),
 ('2020_12_15_00_characters.sql','650EE26F85517977FBDEB42CCB97CEFA6462502E','ARCHIVED','2020-12-15 22:47:26',0),
-('2021_01_15_00_characters.sql','4D3A4C71ACD4CB04B014C300E1D0B33C0699DBE7','ARCHIVED','2021-01-15 08:29:32',0);
+('2021_01_15_00_characters.sql','4D3A4C71ACD4CB04B014C300E1D0B33C0699DBE7','ARCHIVED','2021-01-15 08:29:32',0),
+('2021_02_15_00_characters.sql','53D94CFC60329E7BD036B77D4B298785AF57AD79','ARCHIVED','2021-02-15 12:37:46',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2828,4 +2829,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-01-15  8:29:39
+-- Dump completed on 2021-02-15 12:37:50
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index c6150505b32..daa2bcba04c 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -342,7 +342,7 @@ CREATE TABLE `creature` (
   `unit_flags` int(10) unsigned NOT NULL DEFAULT '0',
   `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0',
   `ScriptName` char(64) DEFAULT '',
-  `VerifiedBuild` smallint(5) DEFAULT '0',
+  `VerifiedBuild` int(11) DEFAULT '0',
   PRIMARY KEY (`guid`),
   KEY `idx_map` (`map`),
   KEY `idx_id` (`id`)
@@ -493,12 +493,13 @@ DROP TABLE IF EXISTS `creature_movement_override`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `creature_movement_override` (
   `SpawnId` int(10) unsigned NOT NULL DEFAULT '0',
-  `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Chase` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Random` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Ground` tinyint(3) unsigned DEFAULT NULL,
+  `Swim` tinyint(3) unsigned DEFAULT NULL,
+  `Flight` tinyint(3) unsigned DEFAULT NULL,
+  `Rooted` tinyint(3) unsigned DEFAULT NULL,
+  `Chase` tinyint(3) unsigned DEFAULT NULL,
+  `Random` tinyint(3) unsigned DEFAULT NULL,
+  `InteractionPauseTimer` int(10) unsigned DEFAULT NULL COMMENT 'Time (in milliseconds) during which creature will not move after interaction with player',
   PRIMARY KEY (`SpawnId`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -708,12 +709,13 @@ DROP TABLE IF EXISTS `creature_template_movement`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `creature_template_movement` (
   `CreatureId` int(10) unsigned NOT NULL DEFAULT '0',
-  `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Chase` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Random` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Ground` tinyint(3) unsigned DEFAULT NULL,
+  `Swim` tinyint(3) unsigned DEFAULT NULL,
+  `Flight` tinyint(3) unsigned DEFAULT NULL,
+  `Rooted` tinyint(3) unsigned DEFAULT NULL,
+  `Chase` tinyint(3) unsigned DEFAULT NULL,
+  `Random` tinyint(3) unsigned DEFAULT NULL,
+  `InteractionPauseTimer` int(10) unsigned DEFAULT NULL COMMENT 'Time (in milliseconds) during which creature will not move after interaction with player',
   PRIMARY KEY (`CreatureId`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -4042,4 +4044,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-01-15  8:29:39
+-- Dump completed on 2021-02-15 12:37:51