diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/base/auth_database.sql | 23 | ||||
-rw-r--r-- | sql/base/characters_database.sql | 7 | ||||
-rw-r--r-- | sql/base/dev/hotfixes_database.sql | 45 | ||||
-rw-r--r-- | sql/base/dev/world_database.sql | 4 | ||||
-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.sql | 3 | ||||
-rw-r--r-- | sql/updates/characters/master/2023_04_02_00_characters.sql | 3 | ||||
-rw-r--r-- | sql/updates/hotfixes/master/2023_04_02_00_hotfixes.sql | 3 | ||||
-rw-r--r-- | sql/updates/world/master/2023_04_02_01_world.sql | 4 |
90 files changed, 62 insertions, 30 deletions
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'); |