diff options
-rw-r--r-- | revision_data.h.in.cmake | 2 | ||||
-rw-r--r-- | sql/base/auth_database.sql | 5 | ||||
-rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
-rw-r--r-- | sql/base/dev/world_database.sql | 30 | ||||
-rw-r--r-- | sql/old/3.3.5a/auth/21011_2021_02_15/2021_01_15_00_auth.sql (renamed from sql/updates/auth/3.3.5/2021_01_15_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/characters/21011_2021_02_15/2021_01_15_00_characters.sql (renamed from sql/updates/characters/3.3.5/2021_01_15_00_characters.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_15_07_world.sql (renamed from sql/updates/world/3.3.5/2021_01_15_07_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_15_08_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_15_08_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_19_00_world.sql (renamed from sql/updates/world/3.3.5/2021_01_19_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_19_01_world.sql (renamed from sql/updates/world/3.3.5/2021_01_19_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_20_00_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_20_01_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_20_02_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_20_03_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_04_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_20_04_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_05_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_20_05_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_22_00_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_01_world.sql (renamed from sql/updates/world/3.3.5/2021_01_22_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_02_world.sql (renamed from sql/updates/world/3.3.5/2021_01_22_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_00_world.sql (renamed from sql/updates/world/3.3.5/2021_01_23_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_01_world.sql (renamed from sql/updates/world/3.3.5/2021_01_23_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_02_world.sql (renamed from sql/updates/world/3.3.5/2021_01_23_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_03_world.sql (renamed from sql/updates/world/3.3.5/2021_01_23_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_24_00_world.sql (renamed from sql/updates/world/3.3.5/2021_01_24_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_24_01_world.sql (renamed from sql/updates/world/3.3.5/2021_01_24_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_25_00_world.sql (renamed from sql/updates/world/3.3.5/2021_01_25_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_00_world.sql (renamed from sql/updates/world/3.3.5/2021_01_26_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_26_01_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_02_world.sql (renamed from sql/updates/world/3.3.5/2021_01_26_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_27_00_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_27_01_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_27_02_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_28_00_world.sql (renamed from sql/updates/world/3.3.5/2021_01_28_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_00_world.sql (renamed from sql/updates/world/3.3.5/2021_01_29_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_01_world.sql (renamed from sql/updates/world/3.3.5/2021_01_29_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_29_02_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_29_03_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_04_world.sql (renamed from sql/updates/world/3.3.5/2021_01_29_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_05_world.sql (renamed from sql/updates/world/3.3.5/2021_01_29_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_06_world.sql (renamed from sql/updates/world/3.3.5/2021_01_29_06_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_07_world.sql (renamed from sql/updates/world/3.3.5/2021_01_29_07_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_00_world.sql (renamed from sql/updates/world/3.3.5/2021_01_31_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_01_world.sql (renamed from sql/updates/world/3.3.5/2021_01_31_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_31_02_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_01_31_03_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_04_world.sql (renamed from sql/updates/world/3.3.5/2021_01_31_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_05_world.sql (renamed from sql/updates/world/3.3.5/2021_01_31_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_01_00_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_01_world.sql (renamed from sql/updates/world/3.3.5/2021_02_01_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_02_world.sql (renamed from sql/updates/world/3.3.5/2021_02_01_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_00_world.sql (renamed from sql/updates/world/3.3.5/2021_02_02_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_01_world.sql (renamed from sql/updates/world/3.3.5/2021_02_02_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_02_world.sql (renamed from sql/updates/world/3.3.5/2021_02_02_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_02_03_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_04_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_02_04_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_05_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_02_05_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_03_00_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_01_world.sql (renamed from sql/updates/world/3.3.5/2021_02_03_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_02_world.sql (renamed from sql/updates/world/3.3.5/2021_02_03_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_03_world.sql (renamed from sql/updates/world/3.3.5/2021_02_03_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_04_00_world.sql (renamed from sql/updates/world/3.3.5/2021_02_04_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_00_world.sql (renamed from sql/updates/world/3.3.5/2021_02_06_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_01_world.sql (renamed from sql/updates/world/3.3.5/2021_02_06_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_02_world.sql (renamed from sql/updates/world/3.3.5/2021_02_06_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_03_world.sql (renamed from sql/updates/world/3.3.5/2021_02_06_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_00_world.sql (renamed from sql/updates/world/3.3.5/2021_02_07_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_01_world.sql (renamed from sql/updates/world/3.3.5/2021_02_07_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_02_world.sql (renamed from sql/updates/world/3.3.5/2021_02_07_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_08_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_08_00_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_08_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_08_01_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_00_world.sql (renamed from sql/updates/world/3.3.5/2021_02_10_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_01_world.sql (renamed from sql/updates/world/3.3.5/2021_02_10_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_02_world.sql (renamed from sql/updates/world/3.3.5/2021_02_10_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_10_03_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_04_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_10_04_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_05_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_10_05_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_00_world.sql (renamed from sql/updates/world/3.3.5/2021_02_14_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_01_world.sql (renamed from sql/updates/world/3.3.5/2021_02_14_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_02_world.sql (renamed from sql/updates/world/3.3.5/2021_02_14_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_03_world.sql (renamed from sql/updates/world/3.3.5/2021_02_14_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_04_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_14_04_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_05_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_14_05_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_06_world_335.sql (renamed from sql/updates/world/3.3.5/2021_02_14_06_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/updates/auth/3.3.5/2021_02_15_00_auth.sql | 2 | ||||
-rw-r--r-- | sql/updates/characters/3.3.5/2021_02_15_00_characters.sql | 2 | ||||
-rw-r--r-- | sql/updates/world/3.3.5/2021_02_15_00_world.sql | 3 |
86 files changed, 30 insertions, 19 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake index 751377772d9..5eb3b080e78 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.21011_2021_01_15.sql" + #define _FULL_DATABASE "TDB_full_world_335.21021_2021_02_15.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 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 diff --git a/sql/updates/auth/3.3.5/2021_01_15_00_auth.sql b/sql/old/3.3.5a/auth/21011_2021_02_15/2021_01_15_00_auth.sql index 53c90c603b5..53c90c603b5 100644 --- a/sql/updates/auth/3.3.5/2021_01_15_00_auth.sql +++ b/sql/old/3.3.5a/auth/21011_2021_02_15/2021_01_15_00_auth.sql diff --git a/sql/updates/characters/3.3.5/2021_01_15_00_characters.sql b/sql/old/3.3.5a/characters/21011_2021_02_15/2021_01_15_00_characters.sql index 3e1b46c9621..3e1b46c9621 100644 --- a/sql/updates/characters/3.3.5/2021_01_15_00_characters.sql +++ b/sql/old/3.3.5a/characters/21011_2021_02_15/2021_01_15_00_characters.sql diff --git a/sql/updates/world/3.3.5/2021_01_15_07_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_15_07_world.sql index 87eeefa890c..87eeefa890c 100644 --- a/sql/updates/world/3.3.5/2021_01_15_07_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_15_07_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_15_08_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_15_08_world_335.sql index 0c1c341ca2c..0c1c341ca2c 100644 --- a/sql/updates/world/3.3.5/2021_01_15_08_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_15_08_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_19_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_19_00_world.sql index 803ce160da6..803ce160da6 100644 --- a/sql/updates/world/3.3.5/2021_01_19_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_19_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_19_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_19_01_world.sql index 0acb5e42d19..0acb5e42d19 100644 --- a/sql/updates/world/3.3.5/2021_01_19_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_19_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_20_00_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_00_world_335.sql index 4a6841e3a82..4a6841e3a82 100644 --- a/sql/updates/world/3.3.5/2021_01_20_00_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_00_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_20_01_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_01_world_335.sql index 46dfcccdd7e..46dfcccdd7e 100644 --- a/sql/updates/world/3.3.5/2021_01_20_01_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_01_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_20_02_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_02_world_335.sql index 8919626eb6e..8919626eb6e 100644 --- a/sql/updates/world/3.3.5/2021_01_20_02_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_02_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_20_03_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_03_world_335.sql index ece470fe13f..ece470fe13f 100644 --- a/sql/updates/world/3.3.5/2021_01_20_03_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_03_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_20_04_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_04_world_335.sql index dac5afbd78b..dac5afbd78b 100644 --- a/sql/updates/world/3.3.5/2021_01_20_04_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_04_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_20_05_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_05_world_335.sql index 219ff52a2e5..219ff52a2e5 100644 --- a/sql/updates/world/3.3.5/2021_01_20_05_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_20_05_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_22_00_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_00_world_335.sql index e241edb30b0..e241edb30b0 100644 --- a/sql/updates/world/3.3.5/2021_01_22_00_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_00_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_22_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_01_world.sql index 7b6a52d70ae..7b6a52d70ae 100644 --- a/sql/updates/world/3.3.5/2021_01_22_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_22_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_02_world.sql index 0d0ac02ada9..0d0ac02ada9 100644 --- a/sql/updates/world/3.3.5/2021_01_22_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_22_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_23_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_00_world.sql index 6fa4507b30d..6fa4507b30d 100644 --- a/sql/updates/world/3.3.5/2021_01_23_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_23_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_01_world.sql index 9aead6f54e9..9aead6f54e9 100644 --- a/sql/updates/world/3.3.5/2021_01_23_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_23_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_02_world.sql index 91345fd9056..91345fd9056 100644 --- a/sql/updates/world/3.3.5/2021_01_23_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_23_03_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_03_world.sql index 57c5039ca37..57c5039ca37 100644 --- a/sql/updates/world/3.3.5/2021_01_23_03_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_23_03_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_24_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_24_00_world.sql index 998389bd8f6..998389bd8f6 100644 --- a/sql/updates/world/3.3.5/2021_01_24_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_24_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_24_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_24_01_world.sql index 21716911fdc..21716911fdc 100644 --- a/sql/updates/world/3.3.5/2021_01_24_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_24_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_25_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_25_00_world.sql index 548f9a19c9a..548f9a19c9a 100644 --- a/sql/updates/world/3.3.5/2021_01_25_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_25_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_26_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_00_world.sql index 56453e474b6..56453e474b6 100644 --- a/sql/updates/world/3.3.5/2021_01_26_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_26_01_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_01_world_335.sql index 031063954bf..031063954bf 100644 --- a/sql/updates/world/3.3.5/2021_01_26_01_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_01_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_26_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_02_world.sql index f0500bbfd89..f0500bbfd89 100644 --- a/sql/updates/world/3.3.5/2021_01_26_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_26_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_27_00_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_00_world_335.sql index 79cfa6e929c..79cfa6e929c 100644 --- a/sql/updates/world/3.3.5/2021_01_27_00_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_00_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_27_01_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_01_world_335.sql index fd5ea00a891..fd5ea00a891 100644 --- a/sql/updates/world/3.3.5/2021_01_27_01_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_01_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_27_02_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_02_world_335.sql index 895e98dfa3c..895e98dfa3c 100644 --- a/sql/updates/world/3.3.5/2021_01_27_02_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_27_02_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_28_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_28_00_world.sql index 60ed2b34c59..60ed2b34c59 100644 --- a/sql/updates/world/3.3.5/2021_01_28_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_28_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_29_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_00_world.sql index 3fc012e1f6b..3fc012e1f6b 100644 --- a/sql/updates/world/3.3.5/2021_01_29_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_29_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_01_world.sql index 0cd337bc655..0cd337bc655 100644 --- a/sql/updates/world/3.3.5/2021_01_29_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_29_02_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_02_world_335.sql index 26ca96b5760..26ca96b5760 100644 --- a/sql/updates/world/3.3.5/2021_01_29_02_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_02_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_29_03_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_03_world_335.sql index acb1326019b..acb1326019b 100644 --- a/sql/updates/world/3.3.5/2021_01_29_03_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_03_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_29_04_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_04_world.sql index d9de4dcde85..d9de4dcde85 100644 --- a/sql/updates/world/3.3.5/2021_01_29_04_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_04_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_29_05_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_05_world.sql index 392605dddf0..392605dddf0 100644 --- a/sql/updates/world/3.3.5/2021_01_29_05_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_05_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_29_06_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_06_world.sql index b65f631fec9..b65f631fec9 100644 --- a/sql/updates/world/3.3.5/2021_01_29_06_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_06_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_29_07_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_07_world.sql index b51eb105716..b51eb105716 100644 --- a/sql/updates/world/3.3.5/2021_01_29_07_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_29_07_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_31_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_00_world.sql index 323f5ddc8e3..323f5ddc8e3 100644 --- a/sql/updates/world/3.3.5/2021_01_31_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_31_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_01_world.sql index ca9457e6902..ca9457e6902 100644 --- a/sql/updates/world/3.3.5/2021_01_31_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_31_02_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_02_world_335.sql index ebb43d382be..ebb43d382be 100644 --- a/sql/updates/world/3.3.5/2021_01_31_02_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_02_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_31_03_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_03_world_335.sql index 6ff1149ab11..6ff1149ab11 100644 --- a/sql/updates/world/3.3.5/2021_01_31_03_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_03_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_01_31_04_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_04_world.sql index 5dd6be9698e..5dd6be9698e 100644 --- a/sql/updates/world/3.3.5/2021_01_31_04_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_04_world.sql diff --git a/sql/updates/world/3.3.5/2021_01_31_05_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_05_world.sql index cb2e4c70b7a..cb2e4c70b7a 100644 --- a/sql/updates/world/3.3.5/2021_01_31_05_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_01_31_05_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_01_00_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_00_world_335.sql index ea8ce890d58..ea8ce890d58 100644 --- a/sql/updates/world/3.3.5/2021_02_01_00_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_00_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_01_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_01_world.sql index 5de4432be2c..5de4432be2c 100644 --- a/sql/updates/world/3.3.5/2021_02_01_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_01_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_02_world.sql index 9d901354d46..9d901354d46 100644 --- a/sql/updates/world/3.3.5/2021_02_01_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_01_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_02_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_00_world.sql index 7d8ad6ba1cb..7d8ad6ba1cb 100644 --- a/sql/updates/world/3.3.5/2021_02_02_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_02_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_01_world.sql index 5d634f7a6fc..5d634f7a6fc 100644 --- a/sql/updates/world/3.3.5/2021_02_02_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_02_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_02_world.sql index 5f2886efa4e..5f2886efa4e 100644 --- a/sql/updates/world/3.3.5/2021_02_02_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_02_03_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_03_world_335.sql index 6535f07c28c..6535f07c28c 100644 --- a/sql/updates/world/3.3.5/2021_02_02_03_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_03_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_02_04_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_04_world_335.sql index 5e13212c945..5e13212c945 100644 --- a/sql/updates/world/3.3.5/2021_02_02_04_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_04_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_02_05_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_05_world_335.sql index d339e4df4fa..d339e4df4fa 100644 --- a/sql/updates/world/3.3.5/2021_02_02_05_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_02_05_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_03_00_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_00_world_335.sql index 148faf2667a..148faf2667a 100644 --- a/sql/updates/world/3.3.5/2021_02_03_00_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_00_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_03_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_01_world.sql index a40295bfd42..a40295bfd42 100644 --- a/sql/updates/world/3.3.5/2021_02_03_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_03_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_02_world.sql index 635552f0702..635552f0702 100644 --- a/sql/updates/world/3.3.5/2021_02_03_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_03_03_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_03_world.sql index 09376ce647c..09376ce647c 100644 --- a/sql/updates/world/3.3.5/2021_02_03_03_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_03_03_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_04_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_04_00_world.sql index ffa4bc226c9..ffa4bc226c9 100644 --- a/sql/updates/world/3.3.5/2021_02_04_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_04_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_06_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_00_world.sql index ae4e0aa92b4..ae4e0aa92b4 100644 --- a/sql/updates/world/3.3.5/2021_02_06_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_06_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_01_world.sql index abbedea7921..abbedea7921 100644 --- a/sql/updates/world/3.3.5/2021_02_06_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_06_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_02_world.sql index ae3ac83149a..ae3ac83149a 100644 --- a/sql/updates/world/3.3.5/2021_02_06_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_06_03_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_03_world.sql index ef5648bd84d..ef5648bd84d 100644 --- a/sql/updates/world/3.3.5/2021_02_06_03_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_06_03_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_07_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_00_world.sql index 02754084a77..02754084a77 100644 --- a/sql/updates/world/3.3.5/2021_02_07_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_07_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_01_world.sql index 02b08f3227a..02b08f3227a 100644 --- a/sql/updates/world/3.3.5/2021_02_07_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_07_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_02_world.sql index 094b8dc52ec..094b8dc52ec 100644 --- a/sql/updates/world/3.3.5/2021_02_07_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_07_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_08_00_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_08_00_world_335.sql index a745061a1a2..a745061a1a2 100644 --- a/sql/updates/world/3.3.5/2021_02_08_00_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_08_00_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_08_01_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_08_01_world_335.sql index a929ff7127b..a929ff7127b 100644 --- a/sql/updates/world/3.3.5/2021_02_08_01_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_08_01_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_10_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_00_world.sql index c51a2cc284e..c51a2cc284e 100644 --- a/sql/updates/world/3.3.5/2021_02_10_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_10_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_01_world.sql index 4dd12bfdb1e..4dd12bfdb1e 100644 --- a/sql/updates/world/3.3.5/2021_02_10_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_10_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_02_world.sql index 76cbcead931..76cbcead931 100644 --- a/sql/updates/world/3.3.5/2021_02_10_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_10_03_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_03_world_335.sql index 8e4ee2106c5..8e4ee2106c5 100644 --- a/sql/updates/world/3.3.5/2021_02_10_03_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_03_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_10_04_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_04_world_335.sql index ea8dd2f3ded..ea8dd2f3ded 100644 --- a/sql/updates/world/3.3.5/2021_02_10_04_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_04_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_10_05_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_05_world_335.sql index bf19b3c7692..bf19b3c7692 100644 --- a/sql/updates/world/3.3.5/2021_02_10_05_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_10_05_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_14_00_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_00_world.sql index 6371f5eb15c..6371f5eb15c 100644 --- a/sql/updates/world/3.3.5/2021_02_14_00_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_00_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_14_01_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_01_world.sql index 6ab71c272c9..6ab71c272c9 100644 --- a/sql/updates/world/3.3.5/2021_02_14_01_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_01_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_14_02_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_02_world.sql index 48c823029c4..48c823029c4 100644 --- a/sql/updates/world/3.3.5/2021_02_14_02_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_02_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_14_03_world.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_03_world.sql index e1f7f9ef482..e1f7f9ef482 100644 --- a/sql/updates/world/3.3.5/2021_02_14_03_world.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_03_world.sql diff --git a/sql/updates/world/3.3.5/2021_02_14_04_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_04_world_335.sql index a4826646a9d..a4826646a9d 100644 --- a/sql/updates/world/3.3.5/2021_02_14_04_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_04_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_14_05_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_05_world_335.sql index 96c6d6308c5..96c6d6308c5 100644 --- a/sql/updates/world/3.3.5/2021_02_14_05_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_05_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_02_14_06_world_335.sql b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_06_world_335.sql index 30eec2b90aa..30eec2b90aa 100644 --- a/sql/updates/world/3.3.5/2021_02_14_06_world_335.sql +++ b/sql/old/3.3.5a/world/21011_2021_02_15/2021_02_14_06_world_335.sql diff --git a/sql/updates/auth/3.3.5/2021_02_15_00_auth.sql b/sql/updates/auth/3.3.5/2021_02_15_00_auth.sql new file mode 100644 index 00000000000..7f25aaffdaf --- /dev/null +++ b/sql/updates/auth/3.3.5/2021_02_15_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.21021 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2021_02_15_00_characters.sql b/sql/updates/characters/3.3.5/2021_02_15_00_characters.sql new file mode 100644 index 00000000000..fa7b9f1bcd9 --- /dev/null +++ b/sql/updates/characters/3.3.5/2021_02_15_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.21021 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2021_02_15_00_world.sql b/sql/updates/world/3.3.5/2021_02_15_00_world.sql new file mode 100644 index 00000000000..72575264617 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_02_15_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.21021 world +UPDATE `version` SET `db_version`='TDB 335.21021', `cache_id`=21021 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; |