aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--revision_data.h.in.cmake4
-rw-r--r--sql/base/auth_database.sql23
-rw-r--r--sql/base/characters_database.sql7
-rw-r--r--sql/base/dev/hotfixes_database.sql45
-rw-r--r--sql/base/dev/world_database.sql4
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_02_03_00_auth.sql (renamed from sql/updates/auth/master/2023_02_03_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_02_07_00_auth.sql (renamed from sql/updates/auth/master/2023_02_07_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_02_09_00_auth.sql (renamed from sql/updates/auth/master/2023_02_09_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_02_14_00_auth.sql (renamed from sql/updates/auth/master/2023_02_14_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_02_28_00_auth.sql (renamed from sql/updates/auth/master/2023_02_28_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_03_08_00_auth.sql (renamed from sql/updates/auth/master/2023_03_08_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_03_11_00_auth.sql (renamed from sql/updates/auth/master/2023_03_11_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_03_22_00_auth.sql (renamed from sql/updates/auth/master/2023_03_22_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_03_27_00_auth.sql (renamed from sql/updates/auth/master/2023_03_27_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_03_31_00_auth.sql (renamed from sql/updates/auth/master/2023_03_31_00_auth.sql)0
-rw-r--r--sql/old/10.x/auth/23021_2023_04_02/2023_03_31_01_auth.sql (renamed from sql/updates/auth/master/2023_03_31_01_auth.sql)0
-rw-r--r--sql/old/10.x/characters/23021_2023_04_02/2023_02_03_00_characters.sql (renamed from sql/updates/characters/master/2023_02_03_00_characters.sql)0
-rw-r--r--sql/old/10.x/characters/23021_2023_04_02/2023_02_08_00_characters.sql (renamed from sql/updates/characters/master/2023_02_08_00_characters.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_02_03_11_hotfixes.sql (renamed from sql/updates/hotfixes/master/2023_02_03_11_hotfixes.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_02_09_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2023_02_09_00_hotfixes.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_22_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2023_03_22_00_hotfixes.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_00_hotfixes_enUS.sql (renamed from sql/updates/hotfixes/master/2023_03_25_00_hotfixes_enUS.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_01_hotfixes_esMX.sql (renamed from sql/updates/hotfixes/master/2023_03_25_01_hotfixes_esMX.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_02_hotfixes_ptBR.sql (renamed from sql/updates/hotfixes/master/2023_03_25_02_hotfixes_ptBR.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_03_hotfixes_frFR.sql (renamed from sql/updates/hotfixes/master/2023_03_25_03_hotfixes_frFR.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_04_hotfixes_deDE.sql (renamed from sql/updates/hotfixes/master/2023_03_25_04_hotfixes_deDE.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_05_hotfixes_esES.sql (renamed from sql/updates/hotfixes/master/2023_03_25_05_hotfixes_esES.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_06_hotfixes_itIT.sql (renamed from sql/updates/hotfixes/master/2023_03_25_06_hotfixes_itIT.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_07_hotfixes_ruRU.sql (renamed from sql/updates/hotfixes/master/2023_03_25_07_hotfixes_ruRU.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_08_hotfixes_koKR.sql (renamed from sql/updates/hotfixes/master/2023_03_25_08_hotfixes_koKR.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_09_hotfixes_zhTW.sql (renamed from sql/updates/hotfixes/master/2023_03_25_09_hotfixes_zhTW.sql)0
-rw-r--r--sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_10_hotfixes_zhCN.sql (renamed from sql/updates/hotfixes/master/2023_03_25_10_hotfixes_zhCN.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_03_12_world.sql (renamed from sql/updates/world/master/2023_02_03_12_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_09_00_world.sql (renamed from sql/updates/world/master/2023_02_09_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_09_01_world.sql (renamed from sql/updates/world/master/2023_02_09_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_10_00_world.sql (renamed from sql/updates/world/master/2023_02_10_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_10_01_world.sql (renamed from sql/updates/world/master/2023_02_10_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_11_00_world.sql (renamed from sql/updates/world/master/2023_02_11_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_11_01_world.sql (renamed from sql/updates/world/master/2023_02_11_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_17_00_world.sql (renamed from sql/updates/world/master/2023_02_17_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_00_world.sql (renamed from sql/updates/world/master/2023_02_20_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_01_world.sql (renamed from sql/updates/world/master/2023_02_20_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_02_world.sql (renamed from sql/updates/world/master/2023_02_20_02_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_03_world.sql (renamed from sql/updates/world/master/2023_02_20_03_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_04_world.sql (renamed from sql/updates/world/master/2023_02_20_04_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_05_world.sql (renamed from sql/updates/world/master/2023_02_20_05_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_06_world.sql (renamed from sql/updates/world/master/2023_02_20_06_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_07_world.sql (renamed from sql/updates/world/master/2023_02_20_07_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_08_world.sql (renamed from sql/updates/world/master/2023_02_20_08_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_09_world.sql (renamed from sql/updates/world/master/2023_02_20_09_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_10_world.sql (renamed from sql/updates/world/master/2023_02_20_10_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_11_world.sql (renamed from sql/updates/world/master/2023_02_20_11_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_02_20_12_world.sql (renamed from sql/updates/world/master/2023_02_20_12_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_02_00_world.sql (renamed from sql/updates/world/master/2023_03_02_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_02_01_world.sql (renamed from sql/updates/world/master/2023_03_02_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_02_02_world.sql (renamed from sql/updates/world/master/2023_03_02_02_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_02_03_world.sql (renamed from sql/updates/world/master/2023_03_02_03_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_04_00_world.sql (renamed from sql/updates/world/master/2023_03_04_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_04_01_world.sql (renamed from sql/updates/world/master/2023_03_04_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_08_00_world.sql (renamed from sql/updates/world/master/2023_03_08_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_08_01_world.sql (renamed from sql/updates/world/master/2023_03_08_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_08_02_world.sql (renamed from sql/updates/world/master/2023_03_08_02_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_09_00_world.sql (renamed from sql/updates/world/master/2023_03_09_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_00_world_enUS.sql (renamed from sql/updates/world/master/2023_03_25_00_world_enUS.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_01_world_esMX.sql (renamed from sql/updates/world/master/2023_03_25_01_world_esMX.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_02_world_ptBR.sql (renamed from sql/updates/world/master/2023_03_25_02_world_ptBR.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_03_world_frFR.sql (renamed from sql/updates/world/master/2023_03_25_03_world_frFR.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_04_world_deDE.sql (renamed from sql/updates/world/master/2023_03_25_04_world_deDE.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_05_world_esES.sql (renamed from sql/updates/world/master/2023_03_25_05_world_esES.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_06_world_itIT.sql (renamed from sql/updates/world/master/2023_03_25_06_world_itIT.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_07_world_ruRU.sql (renamed from sql/updates/world/master/2023_03_25_07_world_ruRU.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_08_world_koKR.sql (renamed from sql/updates/world/master/2023_03_25_08_world_koKR.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_09_world_zhTW.sql (renamed from sql/updates/world/master/2023_03_25_09_world_zhTW.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_10_world_zhCN.sql (renamed from sql/updates/world/master/2023_03_25_10_world_zhCN.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_25_11_world_poi.sql (renamed from sql/updates/world/master/2023_03_25_11_world_poi.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_28_00_world.sql (renamed from sql/updates/world/master/2023_03_28_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_29_00_world.sql (renamed from sql/updates/world/master/2023_03_29_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_29_01_world.sql (renamed from sql/updates/world/master/2023_03_29_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_29_02_world.sql (renamed from sql/updates/world/master/2023_03_29_02_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_29_03_world.sql (renamed from sql/updates/world/master/2023_03_29_03_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_29_04_world.sql (renamed from sql/updates/world/master/2023_03_29_04_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_30_00_world.sql (renamed from sql/updates/world/master/2023_03_30_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_31_00_world.sql (renamed from sql/updates/world/master/2023_03_31_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_31_01_world.sql (renamed from sql/updates/world/master/2023_03_31_01_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_03_31_02_world.sql (renamed from sql/updates/world/master/2023_03_31_02_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_04_01_00_world.sql (renamed from sql/updates/world/master/2023_04_01_00_world.sql)0
-rw-r--r--sql/old/10.x/world/23021_2023_04_02/2023_04_02_00_world.sql (renamed from sql/updates/world/master/2023_04_02_00_world.sql)0
-rw-r--r--sql/updates/auth/master/2023_04_02_00_auth.sql3
-rw-r--r--sql/updates/characters/master/2023_04_02_00_characters.sql3
-rw-r--r--sql/updates/hotfixes/master/2023_04_02_00_hotfixes.sql3
-rw-r--r--sql/updates/world/master/2023_04_02_01_world.sql4
91 files changed, 64 insertions, 32 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 731100bd7fe..04789d86366 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -9,8 +9,8 @@
#define _SOURCE_DIRECTORY R"(@CMAKE_SOURCE_DIR@)"
#define _BUILD_DIRECTORY R"(@BUILDDIR@)"
#define _MYSQL_EXECUTABLE R"(@MYSQL_EXECUTABLE@)"
- #define _FULL_DATABASE "TDB_full_world_1005.23021_2023_02_03.sql"
- #define _HOTFIXES_DATABASE "TDB_full_hotfixes_1005.23021_2023_02_03.sql"
+ #define _FULL_DATABASE "TDB_full_world_1007.23041_2023_04_02.sql"
+ #define _HOTFIXES_DATABASE "TDB_full_hotfixes_1007.23041_2023_04_02.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 feaef406778..aa2c18f48a0 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -2666,16 +2666,17 @@ INSERT INTO `updates` VALUES
('2023_02_01_00_auth.sql','9C1FB6820EF3A543AB7DE2E2913014AFF445F91E','ARCHIVED','2023-02-01 10:10:30',0),
('2023_02_02_00_auth.sql','8AC163759C83D887D5D7A48CFB8272FFBA71B801','ARCHIVED','2023-02-02 10:44:28',0),
('2023_02_03_00_auth.sql','0309A99757DE1FAE595C6C32586B2B8F8CA4C134','ARCHIVED','2023-02-03 01:13:52',0),
-('2023_02_07_00_auth.sql','92D6C7A47B2F98ED93D62F6B7293D604C8F6BE16','RELEASED','2023-02-07 10:39:13',0),
-('2023_02_09_00_auth.sql','F4B797776CA62D9A048D231C8117D51AA312932C','RELEASED','2023-02-09 00:19:27',0),
-('2023_02_14_00_auth.sql','033F4460715121A8B6E9DD0F7456AE930DD18A7A','RELEASED','2023-02-14 10:02:49',0),
-('2023_02_28_00_auth.sql','F57F70D6E1BBB1CB799E338C3358C265FD7F8689','RELEASED','2023-02-28 21:32:14',0),
-('2023_03_08_00_auth.sql','2490CEA2EBDB0ECD3590F1D9328DD88266E179F3','RELEASED','2023-03-08 21:58:27',0),
-('2023_03_11_00_auth.sql','6532C5E043692E7361689090DA19E6350705B591','RELEASED','2023-03-11 00:10:17',0),
-('2023_03_22_00_auth.sql','C589D68CF88A62E03F2E797E03CF2F237371BD34','RELEASED','2023-03-21 18:12:28',0),
-('2023_03_27_00_auth.sql','25B04268224275D0A90EF13E62460CBF61B90CEF','RELEASED','2023-03-27 21:22:59',0),
-('2023_03_31_00_auth.sql','3F8CB31A261BCFE5C9A08B12945221CAA652AB24','RELEASED','2023-03-31 11:15:43',0),
-('2023_03_31_01_auth.sql','A70E14B46537BC9208663B94EDF6CE51CB1B23BA','RELEASED','2023-03-31 23:16:09',0);
+('2023_02_07_00_auth.sql','92D6C7A47B2F98ED93D62F6B7293D604C8F6BE16','ARCHIVED','2023-02-07 10:39:13',0),
+('2023_02_09_00_auth.sql','F4B797776CA62D9A048D231C8117D51AA312932C','ARCHIVED','2023-02-09 00:19:27',0),
+('2023_02_14_00_auth.sql','033F4460715121A8B6E9DD0F7456AE930DD18A7A','ARCHIVED','2023-02-14 10:02:49',0),
+('2023_02_28_00_auth.sql','F57F70D6E1BBB1CB799E338C3358C265FD7F8689','ARCHIVED','2023-02-28 21:32:14',0),
+('2023_03_08_00_auth.sql','2490CEA2EBDB0ECD3590F1D9328DD88266E179F3','ARCHIVED','2023-03-08 21:58:27',0),
+('2023_03_11_00_auth.sql','6532C5E043692E7361689090DA19E6350705B591','ARCHIVED','2023-03-11 00:10:17',0),
+('2023_03_22_00_auth.sql','C589D68CF88A62E03F2E797E03CF2F237371BD34','ARCHIVED','2023-03-21 18:12:28',0),
+('2023_03_27_00_auth.sql','25B04268224275D0A90EF13E62460CBF61B90CEF','ARCHIVED','2023-03-27 21:22:59',0),
+('2023_03_31_00_auth.sql','3F8CB31A261BCFE5C9A08B12945221CAA652AB24','ARCHIVED','2023-03-31 11:15:43',0),
+('2023_03_31_01_auth.sql','A70E14B46537BC9208663B94EDF6CE51CB1B23BA','ARCHIVED','2023-03-31 23:16:09',0),
+('2023_04_02_00_auth.sql','0238E0CE22D6422B19F648D026349A018CD4DB04','ARCHIVED','2023-04-02 01:02:26',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2818,4 +2819,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 2023-02-03 1:13:54
+-- Dump completed on 2023-04-02 1:02:28
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 16bf4837b27..28744467d85 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1511,7 +1511,7 @@ CREATE TABLE `character_skills` (
`skill` smallint unsigned NOT NULL,
`value` smallint unsigned NOT NULL,
`max` smallint unsigned NOT NULL,
- `professionSlot` tinyint NOT NULL DEFAULT -1,
+ `professionSlot` tinyint NOT NULL DEFAULT '-1',
PRIMARY KEY (`guid`,`skill`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3698,7 +3698,8 @@ INSERT INTO `updates` VALUES
('2023_01_28_00_characters.sql','0280F79FD6EC93FFB3CC67B6499CEDA49D582BFC','ARCHIVED','2023-01-28 00:11:03',0),
('2023_01_29_00_characters.sql','24FA9E0F616BF77AC588A25A8A8699903A19A5FE','ARCHIVED','2023-01-29 16:31:12',0),
('2023_02_03_00_characters.sql','A04BA4386B3D5C60407D22CA4BF9A4A6258AA39D','ARCHIVED','2023-02-03 01:13:52',0),
-('2023_02_08_00_characters.sql','C9DF607CCE99540F613F5E25E17090176C995C7C','RELEASED','2023-02-08 21:41:17',0);
+('2023_02_08_00_characters.sql','C9DF607CCE99540F613F5E25E17090176C995C7C','ARCHIVED','2023-02-08 21:41:17',0),
+('2023_04_02_00_characters.sql','AAC1B81AFE4716CF4DAB6BCF01D22F421BFAD253','ARCHIVED','2023-04-02 01:02:26',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3825,4 +3826,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2023-02-03 1:13:55
+-- Dump completed on 2023-04-02 1:02:28
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index d9b81296107..1db012d7a3e 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -385,7 +385,7 @@ CREATE TABLE `area_trigger` (
`BoxYaw` float NOT NULL DEFAULT '0',
`ShapeType` tinyint NOT NULL DEFAULT '0',
`ShapeID` smallint NOT NULL DEFAULT '0',
- `AreaTriggerActionSetID` smallint NOT NULL DEFAULT '0',
+ `AreaTriggerActionSetID` int NOT NULL DEFAULT '0',
`Flags` tinyint NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -2542,7 +2542,7 @@ CREATE TABLE `currency_container` (
`MinAmount` int NOT NULL DEFAULT '0',
`MaxAmount` int NOT NULL DEFAULT '0',
`ContainerIconID` int NOT NULL DEFAULT '0',
- `ContainerQuality` int NOT NULL DEFAULT '0',
+ `ContainerQuality` tinyint NOT NULL DEFAULT '0',
`OnLootSpellVisualKitID` int NOT NULL DEFAULT '0',
`CurrencyTypesID` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -2729,9 +2729,9 @@ CREATE TABLE `difficulty` (
`Flags` smallint unsigned NOT NULL DEFAULT '0',
`ItemContext` tinyint unsigned NOT NULL DEFAULT '0',
`ToggleDifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
- `GroupSizeHealthCurveID` smallint unsigned NOT NULL DEFAULT '0',
- `GroupSizeDmgCurveID` smallint unsigned NOT NULL DEFAULT '0',
- `GroupSizeSpellPointsCurveID` smallint unsigned NOT NULL DEFAULT '0',
+ `GroupSizeHealthCurveID` int unsigned NOT NULL DEFAULT '0',
+ `GroupSizeDmgCurveID` int unsigned NOT NULL DEFAULT '0',
+ `GroupSizeSpellPointsCurveID` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3351,7 +3351,7 @@ CREATE TABLE `garr_building` (
`AllianceName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Tooltip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0',
+ `GarrTypeID` tinyint NOT NULL DEFAULT '0',
`BuildingType` tinyint NOT NULL DEFAULT '0',
`HordeGameObjectID` int NOT NULL DEFAULT '0',
`AllianceGameObjectID` int NOT NULL DEFAULT '0',
@@ -3487,7 +3487,7 @@ CREATE TABLE `garr_follower` (
`HordeSourceText` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`AllianceSourceText` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`TitleName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0',
+ `GarrTypeID` tinyint NOT NULL DEFAULT '0',
`GarrFollowerTypeID` tinyint NOT NULL DEFAULT '0',
`HordeCreatureID` int NOT NULL DEFAULT '0',
`AllianceCreatureID` int NOT NULL DEFAULT '0',
@@ -3585,7 +3585,7 @@ CREATE TABLE `garr_mission` (
`MapPosY` float NOT NULL DEFAULT '0',
`WorldPosX` float NOT NULL DEFAULT '0',
`WorldPosY` float NOT NULL DEFAULT '0',
- `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0',
+ `GarrTypeID` tinyint NOT NULL DEFAULT '0',
`GarrMissionTypeID` tinyint unsigned NOT NULL DEFAULT '0',
`GarrFollowerTypeID` tinyint unsigned NOT NULL DEFAULT '0',
`MaxFollowers` tinyint unsigned NOT NULL DEFAULT '0',
@@ -3752,7 +3752,7 @@ DROP TABLE IF EXISTS `garr_talent_tree`;
CREATE TABLE `garr_talent_tree` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0',
+ `GarrTypeID` tinyint NOT NULL DEFAULT '0',
`ClassID` int NOT NULL DEFAULT '0',
`MaxTiers` tinyint NOT NULL DEFAULT '0',
`UiOrder` tinyint NOT NULL DEFAULT '0',
@@ -5568,11 +5568,12 @@ DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `languages` (
- `ID` int unsigned NOT NULL DEFAULT '0',
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ID` int unsigned NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
`UiTextureKitID` int NOT NULL DEFAULT '0',
`UiTextureKitElementCount` int NOT NULL DEFAULT '0',
+ `LearningCurveID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6895,7 +6896,7 @@ CREATE TABLE `quest_info` (
`InfoName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Type` tinyint NOT NULL DEFAULT '0',
`Modifiers` int NOT NULL DEFAULT '0',
- `Profession` int NOT NULL DEFAULT '0',
+ `Profession` smallint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -8064,6 +8065,24 @@ CREATE TABLE `spell_item_enchantment_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `spell_keybound_override`
+--
+
+DROP TABLE IF EXISTS `spell_keybound_override`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `spell_keybound_override` (
+ `ID` int unsigned NOT NULL DEFAULT '0',
+ `Function` text COLLATE utf8mb4_unicode_ci,
+ `Type` tinyint NOT NULL DEFAULT '0',
+ `Data` int NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `spell_label`
--
@@ -9342,7 +9361,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_cost`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_node_x_trait_cost` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitNodeID` int unsigned NOT NULL DEFAULT '0',
+ `TraitNodeID` int NOT NULL DEFAULT '0',
`TraitCostID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -10219,4 +10238,4 @@ CREATE TABLE `world_state_expression` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2023-02-03 1:14:00
+-- Dump completed on 2023-04-02 1:02:34
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 361c4710a4d..e98242646cd 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -904,8 +904,6 @@ CREATE TABLE `creature_template` (
`TitleAlt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`IconName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gossip_menu_id` int unsigned NOT NULL DEFAULT '0',
- `minlevel` smallint NOT NULL DEFAULT '1',
- `maxlevel` smallint NOT NULL DEFAULT '1',
`HealthScalingExpansion` int NOT NULL DEFAULT '0',
`RequiredExpansion` int NOT NULL DEFAULT '0',
`VignetteID` int NOT NULL DEFAULT '0',
@@ -4874,4 +4872,4 @@ CREATE TABLE `world_state` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2023-02-03 1:13:57
+-- Dump completed on 2023-04-02 1:02:30
diff --git a/sql/updates/auth/master/2023_02_03_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_02_03_00_auth.sql
index be4f170bd17..be4f170bd17 100644
--- a/sql/updates/auth/master/2023_02_03_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_02_03_00_auth.sql
diff --git a/sql/updates/auth/master/2023_02_07_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_02_07_00_auth.sql
index 20f7b37a77a..20f7b37a77a 100644
--- a/sql/updates/auth/master/2023_02_07_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_02_07_00_auth.sql
diff --git a/sql/updates/auth/master/2023_02_09_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_02_09_00_auth.sql
index 662d52994f9..662d52994f9 100644
--- a/sql/updates/auth/master/2023_02_09_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_02_09_00_auth.sql
diff --git a/sql/updates/auth/master/2023_02_14_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_02_14_00_auth.sql
index 1f3790c5ed2..1f3790c5ed2 100644
--- a/sql/updates/auth/master/2023_02_14_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_02_14_00_auth.sql
diff --git a/sql/updates/auth/master/2023_02_28_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_02_28_00_auth.sql
index 9532089409e..9532089409e 100644
--- a/sql/updates/auth/master/2023_02_28_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_02_28_00_auth.sql
diff --git a/sql/updates/auth/master/2023_03_08_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_03_08_00_auth.sql
index ead0db461d7..ead0db461d7 100644
--- a/sql/updates/auth/master/2023_03_08_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_03_08_00_auth.sql
diff --git a/sql/updates/auth/master/2023_03_11_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_03_11_00_auth.sql
index 7fcacc3a624..7fcacc3a624 100644
--- a/sql/updates/auth/master/2023_03_11_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_03_11_00_auth.sql
diff --git a/sql/updates/auth/master/2023_03_22_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_03_22_00_auth.sql
index 46edc6b85f7..46edc6b85f7 100644
--- a/sql/updates/auth/master/2023_03_22_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_03_22_00_auth.sql
diff --git a/sql/updates/auth/master/2023_03_27_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_03_27_00_auth.sql
index b99fc3ba934..b99fc3ba934 100644
--- a/sql/updates/auth/master/2023_03_27_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_03_27_00_auth.sql
diff --git a/sql/updates/auth/master/2023_03_31_00_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_03_31_00_auth.sql
index 90be152981e..90be152981e 100644
--- a/sql/updates/auth/master/2023_03_31_00_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_03_31_00_auth.sql
diff --git a/sql/updates/auth/master/2023_03_31_01_auth.sql b/sql/old/10.x/auth/23021_2023_04_02/2023_03_31_01_auth.sql
index 51ecd118aae..51ecd118aae 100644
--- a/sql/updates/auth/master/2023_03_31_01_auth.sql
+++ b/sql/old/10.x/auth/23021_2023_04_02/2023_03_31_01_auth.sql
diff --git a/sql/updates/characters/master/2023_02_03_00_characters.sql b/sql/old/10.x/characters/23021_2023_04_02/2023_02_03_00_characters.sql
index 3358156788c..3358156788c 100644
--- a/sql/updates/characters/master/2023_02_03_00_characters.sql
+++ b/sql/old/10.x/characters/23021_2023_04_02/2023_02_03_00_characters.sql
diff --git a/sql/updates/characters/master/2023_02_08_00_characters.sql b/sql/old/10.x/characters/23021_2023_04_02/2023_02_08_00_characters.sql
index f4f6b459fc8..f4f6b459fc8 100644
--- a/sql/updates/characters/master/2023_02_08_00_characters.sql
+++ b/sql/old/10.x/characters/23021_2023_04_02/2023_02_08_00_characters.sql
diff --git a/sql/updates/hotfixes/master/2023_02_03_11_hotfixes.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_02_03_11_hotfixes.sql
index dadd4baffaa..dadd4baffaa 100644
--- a/sql/updates/hotfixes/master/2023_02_03_11_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_02_03_11_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2023_02_09_00_hotfixes.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_02_09_00_hotfixes.sql
index 35bc9144003..35bc9144003 100644
--- a/sql/updates/hotfixes/master/2023_02_09_00_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_02_09_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2023_03_22_00_hotfixes.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_22_00_hotfixes.sql
index 1a8a2278925..1a8a2278925 100644
--- a/sql/updates/hotfixes/master/2023_03_22_00_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_22_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_00_hotfixes_enUS.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_00_hotfixes_enUS.sql
index 84045d7971a..84045d7971a 100644
--- a/sql/updates/hotfixes/master/2023_03_25_00_hotfixes_enUS.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_00_hotfixes_enUS.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_01_hotfixes_esMX.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_01_hotfixes_esMX.sql
index 4e847342814..4e847342814 100644
--- a/sql/updates/hotfixes/master/2023_03_25_01_hotfixes_esMX.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_01_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_02_hotfixes_ptBR.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_02_hotfixes_ptBR.sql
index fba371f18e7..fba371f18e7 100644
--- a/sql/updates/hotfixes/master/2023_03_25_02_hotfixes_ptBR.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_02_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_03_hotfixes_frFR.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_03_hotfixes_frFR.sql
index e1a96c26ede..e1a96c26ede 100644
--- a/sql/updates/hotfixes/master/2023_03_25_03_hotfixes_frFR.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_03_hotfixes_frFR.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_04_hotfixes_deDE.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_04_hotfixes_deDE.sql
index 162364139cc..162364139cc 100644
--- a/sql/updates/hotfixes/master/2023_03_25_04_hotfixes_deDE.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_04_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_05_hotfixes_esES.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_05_hotfixes_esES.sql
index 61342d8c8a6..61342d8c8a6 100644
--- a/sql/updates/hotfixes/master/2023_03_25_05_hotfixes_esES.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_05_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_06_hotfixes_itIT.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_06_hotfixes_itIT.sql
index 9a358fcf027..9a358fcf027 100644
--- a/sql/updates/hotfixes/master/2023_03_25_06_hotfixes_itIT.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_06_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_07_hotfixes_ruRU.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_07_hotfixes_ruRU.sql
index ffc063663e8..ffc063663e8 100644
--- a/sql/updates/hotfixes/master/2023_03_25_07_hotfixes_ruRU.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_07_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_08_hotfixes_koKR.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_08_hotfixes_koKR.sql
index ce4e6a2b083..ce4e6a2b083 100644
--- a/sql/updates/hotfixes/master/2023_03_25_08_hotfixes_koKR.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_08_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_09_hotfixes_zhTW.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_09_hotfixes_zhTW.sql
index 21d76e7fa3e..21d76e7fa3e 100644
--- a/sql/updates/hotfixes/master/2023_03_25_09_hotfixes_zhTW.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_09_hotfixes_zhTW.sql
diff --git a/sql/updates/hotfixes/master/2023_03_25_10_hotfixes_zhCN.sql b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_10_hotfixes_zhCN.sql
index 9eac4519619..9eac4519619 100644
--- a/sql/updates/hotfixes/master/2023_03_25_10_hotfixes_zhCN.sql
+++ b/sql/old/10.x/hotfixes/23021_2023_04_02/2023_03_25_10_hotfixes_zhCN.sql
diff --git a/sql/updates/world/master/2023_02_03_12_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_03_12_world.sql
index bb830867eff..bb830867eff 100644
--- a/sql/updates/world/master/2023_02_03_12_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_03_12_world.sql
diff --git a/sql/updates/world/master/2023_02_09_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_09_00_world.sql
index 135a50b6975..135a50b6975 100644
--- a/sql/updates/world/master/2023_02_09_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_09_00_world.sql
diff --git a/sql/updates/world/master/2023_02_09_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_09_01_world.sql
index 71b69f3a170..71b69f3a170 100644
--- a/sql/updates/world/master/2023_02_09_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_09_01_world.sql
diff --git a/sql/updates/world/master/2023_02_10_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_10_00_world.sql
index 2cac0072234..2cac0072234 100644
--- a/sql/updates/world/master/2023_02_10_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_10_00_world.sql
diff --git a/sql/updates/world/master/2023_02_10_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_10_01_world.sql
index fc6244cf21e..fc6244cf21e 100644
--- a/sql/updates/world/master/2023_02_10_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_10_01_world.sql
diff --git a/sql/updates/world/master/2023_02_11_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_11_00_world.sql
index 2d7ecd94b49..2d7ecd94b49 100644
--- a/sql/updates/world/master/2023_02_11_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_11_00_world.sql
diff --git a/sql/updates/world/master/2023_02_11_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_11_01_world.sql
index 4f8a540da29..4f8a540da29 100644
--- a/sql/updates/world/master/2023_02_11_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_11_01_world.sql
diff --git a/sql/updates/world/master/2023_02_17_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_17_00_world.sql
index a048ed08e3c..a048ed08e3c 100644
--- a/sql/updates/world/master/2023_02_17_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_17_00_world.sql
diff --git a/sql/updates/world/master/2023_02_20_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_00_world.sql
index 0a9442503d6..0a9442503d6 100644
--- a/sql/updates/world/master/2023_02_20_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_00_world.sql
diff --git a/sql/updates/world/master/2023_02_20_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_01_world.sql
index 937fb771a87..937fb771a87 100644
--- a/sql/updates/world/master/2023_02_20_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_01_world.sql
diff --git a/sql/updates/world/master/2023_02_20_02_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_02_world.sql
index 7897f36996f..7897f36996f 100644
--- a/sql/updates/world/master/2023_02_20_02_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_02_world.sql
diff --git a/sql/updates/world/master/2023_02_20_03_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_03_world.sql
index 90ca7629d13..90ca7629d13 100644
--- a/sql/updates/world/master/2023_02_20_03_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_03_world.sql
diff --git a/sql/updates/world/master/2023_02_20_04_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_04_world.sql
index 393c48978b4..393c48978b4 100644
--- a/sql/updates/world/master/2023_02_20_04_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_04_world.sql
diff --git a/sql/updates/world/master/2023_02_20_05_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_05_world.sql
index 16476b2a390..16476b2a390 100644
--- a/sql/updates/world/master/2023_02_20_05_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_05_world.sql
diff --git a/sql/updates/world/master/2023_02_20_06_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_06_world.sql
index 184adfe2193..184adfe2193 100644
--- a/sql/updates/world/master/2023_02_20_06_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_06_world.sql
diff --git a/sql/updates/world/master/2023_02_20_07_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_07_world.sql
index 9140e6d7348..9140e6d7348 100644
--- a/sql/updates/world/master/2023_02_20_07_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_07_world.sql
diff --git a/sql/updates/world/master/2023_02_20_08_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_08_world.sql
index a3a78d6a348..a3a78d6a348 100644
--- a/sql/updates/world/master/2023_02_20_08_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_08_world.sql
diff --git a/sql/updates/world/master/2023_02_20_09_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_09_world.sql
index c8b5e304b8d..c8b5e304b8d 100644
--- a/sql/updates/world/master/2023_02_20_09_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_09_world.sql
diff --git a/sql/updates/world/master/2023_02_20_10_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_10_world.sql
index 0574527df8b..0574527df8b 100644
--- a/sql/updates/world/master/2023_02_20_10_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_10_world.sql
diff --git a/sql/updates/world/master/2023_02_20_11_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_11_world.sql
index a3acb229eef..a3acb229eef 100644
--- a/sql/updates/world/master/2023_02_20_11_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_11_world.sql
diff --git a/sql/updates/world/master/2023_02_20_12_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_12_world.sql
index 6c7a4ee1407..6c7a4ee1407 100644
--- a/sql/updates/world/master/2023_02_20_12_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_02_20_12_world.sql
diff --git a/sql/updates/world/master/2023_03_02_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_02_00_world.sql
index 90baa183235..90baa183235 100644
--- a/sql/updates/world/master/2023_03_02_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_02_00_world.sql
diff --git a/sql/updates/world/master/2023_03_02_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_02_01_world.sql
index 7b35b23c9e9..7b35b23c9e9 100644
--- a/sql/updates/world/master/2023_03_02_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_02_01_world.sql
diff --git a/sql/updates/world/master/2023_03_02_02_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_02_02_world.sql
index eed979fcb5b..eed979fcb5b 100644
--- a/sql/updates/world/master/2023_03_02_02_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_02_02_world.sql
diff --git a/sql/updates/world/master/2023_03_02_03_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_02_03_world.sql
index fb96b09521e..fb96b09521e 100644
--- a/sql/updates/world/master/2023_03_02_03_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_02_03_world.sql
diff --git a/sql/updates/world/master/2023_03_04_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_04_00_world.sql
index 4fe9becfa05..4fe9becfa05 100644
--- a/sql/updates/world/master/2023_03_04_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_04_00_world.sql
diff --git a/sql/updates/world/master/2023_03_04_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_04_01_world.sql
index 5de55d0b5db..5de55d0b5db 100644
--- a/sql/updates/world/master/2023_03_04_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_04_01_world.sql
diff --git a/sql/updates/world/master/2023_03_08_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_08_00_world.sql
index 41d0d2c4b3b..41d0d2c4b3b 100644
--- a/sql/updates/world/master/2023_03_08_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_08_00_world.sql
diff --git a/sql/updates/world/master/2023_03_08_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_08_01_world.sql
index 0808126191d..0808126191d 100644
--- a/sql/updates/world/master/2023_03_08_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_08_01_world.sql
diff --git a/sql/updates/world/master/2023_03_08_02_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_08_02_world.sql
index 7acddc44e5a..7acddc44e5a 100644
--- a/sql/updates/world/master/2023_03_08_02_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_08_02_world.sql
diff --git a/sql/updates/world/master/2023_03_09_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_09_00_world.sql
index c8b641a5c3f..c8b641a5c3f 100644
--- a/sql/updates/world/master/2023_03_09_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_09_00_world.sql
diff --git a/sql/updates/world/master/2023_03_25_00_world_enUS.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_00_world_enUS.sql
index 2c56a652193..2c56a652193 100644
--- a/sql/updates/world/master/2023_03_25_00_world_enUS.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_00_world_enUS.sql
diff --git a/sql/updates/world/master/2023_03_25_01_world_esMX.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_01_world_esMX.sql
index eba9f1b15ad..eba9f1b15ad 100644
--- a/sql/updates/world/master/2023_03_25_01_world_esMX.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_01_world_esMX.sql
diff --git a/sql/updates/world/master/2023_03_25_02_world_ptBR.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_02_world_ptBR.sql
index fca8e33408e..fca8e33408e 100644
--- a/sql/updates/world/master/2023_03_25_02_world_ptBR.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_02_world_ptBR.sql
diff --git a/sql/updates/world/master/2023_03_25_03_world_frFR.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_03_world_frFR.sql
index 51180225aab..51180225aab 100644
--- a/sql/updates/world/master/2023_03_25_03_world_frFR.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_03_world_frFR.sql
diff --git a/sql/updates/world/master/2023_03_25_04_world_deDE.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_04_world_deDE.sql
index 013b44398b4..013b44398b4 100644
--- a/sql/updates/world/master/2023_03_25_04_world_deDE.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_04_world_deDE.sql
diff --git a/sql/updates/world/master/2023_03_25_05_world_esES.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_05_world_esES.sql
index 28203fa3966..28203fa3966 100644
--- a/sql/updates/world/master/2023_03_25_05_world_esES.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_05_world_esES.sql
diff --git a/sql/updates/world/master/2023_03_25_06_world_itIT.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_06_world_itIT.sql
index a17ec7497bd..a17ec7497bd 100644
--- a/sql/updates/world/master/2023_03_25_06_world_itIT.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_06_world_itIT.sql
diff --git a/sql/updates/world/master/2023_03_25_07_world_ruRU.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_07_world_ruRU.sql
index 238c0836141..238c0836141 100644
--- a/sql/updates/world/master/2023_03_25_07_world_ruRU.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_07_world_ruRU.sql
diff --git a/sql/updates/world/master/2023_03_25_08_world_koKR.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_08_world_koKR.sql
index 5960330d908..5960330d908 100644
--- a/sql/updates/world/master/2023_03_25_08_world_koKR.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_08_world_koKR.sql
diff --git a/sql/updates/world/master/2023_03_25_09_world_zhTW.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_09_world_zhTW.sql
index a072f65270b..a072f65270b 100644
--- a/sql/updates/world/master/2023_03_25_09_world_zhTW.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_09_world_zhTW.sql
diff --git a/sql/updates/world/master/2023_03_25_10_world_zhCN.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_10_world_zhCN.sql
index 429a0b8a51b..429a0b8a51b 100644
--- a/sql/updates/world/master/2023_03_25_10_world_zhCN.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_10_world_zhCN.sql
diff --git a/sql/updates/world/master/2023_03_25_11_world_poi.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_11_world_poi.sql
index ddb0f7443f6..ddb0f7443f6 100644
--- a/sql/updates/world/master/2023_03_25_11_world_poi.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_25_11_world_poi.sql
diff --git a/sql/updates/world/master/2023_03_28_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_28_00_world.sql
index c8eb8c4b8fe..c8eb8c4b8fe 100644
--- a/sql/updates/world/master/2023_03_28_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_28_00_world.sql
diff --git a/sql/updates/world/master/2023_03_29_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_00_world.sql
index 874b8f836c8..874b8f836c8 100644
--- a/sql/updates/world/master/2023_03_29_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_00_world.sql
diff --git a/sql/updates/world/master/2023_03_29_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_01_world.sql
index 746d8917ee5..746d8917ee5 100644
--- a/sql/updates/world/master/2023_03_29_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_01_world.sql
diff --git a/sql/updates/world/master/2023_03_29_02_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_02_world.sql
index f30381df0ad..f30381df0ad 100644
--- a/sql/updates/world/master/2023_03_29_02_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_02_world.sql
diff --git a/sql/updates/world/master/2023_03_29_03_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_03_world.sql
index cbeaca43c61..cbeaca43c61 100644
--- a/sql/updates/world/master/2023_03_29_03_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_03_world.sql
diff --git a/sql/updates/world/master/2023_03_29_04_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_04_world.sql
index 329c76f93ef..329c76f93ef 100644
--- a/sql/updates/world/master/2023_03_29_04_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_29_04_world.sql
diff --git a/sql/updates/world/master/2023_03_30_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_30_00_world.sql
index 8f35adeee2c..8f35adeee2c 100644
--- a/sql/updates/world/master/2023_03_30_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_30_00_world.sql
diff --git a/sql/updates/world/master/2023_03_31_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_31_00_world.sql
index 44018f696d0..44018f696d0 100644
--- a/sql/updates/world/master/2023_03_31_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_31_00_world.sql
diff --git a/sql/updates/world/master/2023_03_31_01_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_31_01_world.sql
index 9742023c6bd..9742023c6bd 100644
--- a/sql/updates/world/master/2023_03_31_01_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_31_01_world.sql
diff --git a/sql/updates/world/master/2023_03_31_02_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_03_31_02_world.sql
index 11b9e514fa4..11b9e514fa4 100644
--- a/sql/updates/world/master/2023_03_31_02_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_03_31_02_world.sql
diff --git a/sql/updates/world/master/2023_04_01_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_04_01_00_world.sql
index df9724c712f..df9724c712f 100644
--- a/sql/updates/world/master/2023_04_01_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_04_01_00_world.sql
diff --git a/sql/updates/world/master/2023_04_02_00_world.sql b/sql/old/10.x/world/23021_2023_04_02/2023_04_02_00_world.sql
index 91eb2e2bcc1..91eb2e2bcc1 100644
--- a/sql/updates/world/master/2023_04_02_00_world.sql
+++ b/sql/old/10.x/world/23021_2023_04_02/2023_04_02_00_world.sql
diff --git a/sql/updates/auth/master/2023_04_02_00_auth.sql b/sql/updates/auth/master/2023_04_02_00_auth.sql
new file mode 100644
index 00000000000..80ea98771a4
--- /dev/null
+++ b/sql/updates/auth/master/2023_04_02_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 1007.23041 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');
diff --git a/sql/updates/characters/master/2023_04_02_00_characters.sql b/sql/updates/characters/master/2023_04_02_00_characters.sql
new file mode 100644
index 00000000000..e28efd4754a
--- /dev/null
+++ b/sql/updates/characters/master/2023_04_02_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 1007.23041 characters
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED');
diff --git a/sql/updates/hotfixes/master/2023_04_02_00_hotfixes.sql b/sql/updates/hotfixes/master/2023_04_02_00_hotfixes.sql
new file mode 100644
index 00000000000..f09c1193f6a
--- /dev/null
+++ b/sql/updates/hotfixes/master/2023_04_02_00_hotfixes.sql
@@ -0,0 +1,3 @@
+-- TDB 1007.23041 hotfixes
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/hotfixes', 'ARCHIVED');
diff --git a/sql/updates/world/master/2023_04_02_01_world.sql b/sql/updates/world/master/2023_04_02_01_world.sql
new file mode 100644
index 00000000000..df170321525
--- /dev/null
+++ b/sql/updates/world/master/2023_04_02_01_world.sql
@@ -0,0 +1,4 @@
+-- TDB 1007.23041 world
+UPDATE `version` SET `db_version`='TDB 1007.23041', `cache_id`=23041 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/world', 'ARCHIVED');