diff options
| -rw-r--r-- | revision_data.h.in.cmake | 2 | ||||
| -rw-r--r-- | sql/base/auth_database.sql | 17 | ||||
| -rw-r--r-- | sql/base/characters_database.sql | 11 | ||||
| -rw-r--r-- | sql/base/dev/world_database.sql | 22 | ||||
| -rw-r--r-- | sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql (renamed from sql/updates/auth/3.3.5/2022_04_14_00_auth.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql (renamed from sql/updates/characters/3.3.5/2022_04_14_00_characters.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql (renamed from sql/updates/world/3.3.5/2022_04_14_00_world.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql (renamed from sql/updates/world/3.3.5/2022_04_16_00_world.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2022_06_01_00_auth.sql | 2 | ||||
| -rw-r--r-- | sql/updates/characters/3.3.5/2022_06_01_00_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2022_06_01_00_world.sql | 3 |
11 files changed, 34 insertions, 25 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake index 807d0cd534c..edc04e3c978 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.22041_2022_04_14.sql" + #define _FULL_DATABASE "TDB_full_world_335.22061_2022_06_01.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 bbe907094e6..25f2375dc40 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.28, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.29, for Linux (x86_64) -- -- Host: localhost Database: auth -- ------------------------------------------------------ --- Server version 8.0.28-0ubuntu0.20.04.3 +-- Server version 8.0.29-0ubuntu0.20.04.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -2000,7 +2000,8 @@ INSERT INTO `updates` VALUES ('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','ARCHIVED','2022-01-01 19:35:19',0), ('2022_01_15_00_auth.sql','A2123CEC10327ECA4C92A8B2212AEE25B43C457B','ARCHIVED','2022-01-15 18:05:55',0), ('2022_02_16_00_auth.sql','CFB54EB37319916B1B80E29F5572D12A7D9A33F5','ARCHIVED','2022-02-16 21:52:01',0), -('2022_04_14_00_auth.sql','B1ED102EB7C9A2A0BDA866201960E70CCCA22FB5','ARCHIVED','2022-04-14 16:24:35',0); +('2022_04_14_00_auth.sql','B1ED102EB7C9A2A0BDA866201960E70CCCA22FB5','ARCHIVED','2022-04-14 16:24:35',0), +('2022_06_01_00_auth.sql','351FA0BEE4F99B4EF451D0B1B6D822376DE4C26C','ARCHIVED','2022-06-01 10:50:50',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2102,8 +2103,8 @@ SET character_set_client = @saved_cs_client; /*!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 character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ @@ -2120,8 +2121,8 @@ SET character_set_client = @saved_cs_client; /*!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 character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ @@ -2139,4 +2140,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 2022-04-14 16:24:38 +-- Dump completed on 2022-06-01 10:50:53 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 3544c1aaa4b..8495fe538b2 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.28, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.29, for Linux (x86_64) -- -- Host: localhost Database: characters -- ------------------------------------------------------ --- Server version 8.0.28-0ubuntu0.20.04.3 +-- Server version 8.0.29-0ubuntu0.20.04.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -1340,7 +1340,7 @@ DROP TABLE IF EXISTS `characters`; CREATE TABLE `characters` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `account` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', - `name` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `name` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL, `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', `gender` tinyint unsigned NOT NULL DEFAULT '0', @@ -2673,7 +2673,8 @@ INSERT INTO `updates` VALUES ('2021_12_16_00_characters.sql','C250DF213B43FC2186520C3901C0A1FBF522BBDF','ARCHIVED','2021-12-16 21:17:10',0), ('2022_01_15_00_characters.sql','351DEB60A6BB87FD9ED5D097E15ADBC32424C58A','ARCHIVED','2022-01-15 18:05:55',0), ('2022_02_16_00_characters.sql','3086FE1DB569830190013FE0129F9CF072C12D6A','ARCHIVED','2022-02-16 21:52:01',0), -('2022_04_14_00_characters.sql','FFFF611BE95F047CD853701136452BF8D28C3130','ARCHIVED','2022-04-14 16:24:35',0); +('2022_04_14_00_characters.sql','FFFF611BE95F047CD853701136452BF8D28C3130','ARCHIVED','2022-04-14 16:24:35',0), +('2022_06_01_00_characters.sql','F33CA4F6F0A685CE1F42F0106269F3C39E31F1B0','ARCHIVED','2022-06-01 10:50:50',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2844,4 +2845,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-04-14 16:24:38 +-- Dump completed on 2022-06-01 10:50:53 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 0be4a3a500c..365b75a4f3e 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.28, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.29, for Linux (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 8.0.28-0ubuntu0.20.04.3 +-- Server version 8.0.29-0ubuntu0.20.04.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -3940,7 +3940,7 @@ CREATE TABLE `waypoint_data` ( `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', - `orientation` float NOT NULL DEFAULT '0', + `orientation` float DEFAULT NULL, `delay` int unsigned NOT NULL DEFAULT '0', `move_type` int NOT NULL DEFAULT '0', `action` int NOT NULL DEFAULT '0', @@ -3987,7 +3987,7 @@ CREATE TABLE `waypoints` ( `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', - `orientation` float NOT NULL DEFAULT '0', + `orientation` float DEFAULT NULL, `delay` int unsigned NOT NULL DEFAULT '0', `point_comment` text, PRIMARY KEY (`entry`,`pointid`) @@ -4006,8 +4006,8 @@ CREATE TABLE `waypoints` ( /*!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 character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ @@ -4024,8 +4024,8 @@ CREATE TABLE `waypoints` ( /*!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 character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ @@ -4042,8 +4042,8 @@ CREATE TABLE `waypoints` ( /*!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 character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ @@ -4061,4 +4061,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-04-14 16:24:40 +-- Dump completed on 2022-06-01 10:50:54 diff --git a/sql/updates/auth/3.3.5/2022_04_14_00_auth.sql b/sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql index 632b30d4531..632b30d4531 100644 --- a/sql/updates/auth/3.3.5/2022_04_14_00_auth.sql +++ b/sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql diff --git a/sql/updates/characters/3.3.5/2022_04_14_00_characters.sql b/sql/old/3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql index 3a5b28dd092..3a5b28dd092 100644 --- a/sql/updates/characters/3.3.5/2022_04_14_00_characters.sql +++ b/sql/old/3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql diff --git a/sql/updates/world/3.3.5/2022_04_14_00_world.sql b/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql index f8720daf989..f8720daf989 100644 --- a/sql/updates/world/3.3.5/2022_04_14_00_world.sql +++ b/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_04_16_00_world.sql b/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql index 6330c80461d..6330c80461d 100644 --- a/sql/updates/world/3.3.5/2022_04_16_00_world.sql +++ b/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql diff --git a/sql/updates/auth/3.3.5/2022_06_01_00_auth.sql b/sql/updates/auth/3.3.5/2022_06_01_00_auth.sql new file mode 100644 index 00000000000..7b91a8a470b --- /dev/null +++ b/sql/updates/auth/3.3.5/2022_06_01_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.22061 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2022_06_01_00_characters.sql b/sql/updates/characters/3.3.5/2022_06_01_00_characters.sql new file mode 100644 index 00000000000..135ad810aea --- /dev/null +++ b/sql/updates/characters/3.3.5/2022_06_01_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.22061 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2022_06_01_00_world.sql b/sql/updates/world/3.3.5/2022_06_01_00_world.sql new file mode 100644 index 00000000000..30dd4165af4 --- /dev/null +++ b/sql/updates/world/3.3.5/2022_06_01_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.22061 world +UPDATE `version` SET `db_version`='TDB 335.22061', `cache_id`=22061 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; |