diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/characters/master/2023_02_08_00_characters.sql | 1 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index ae7ff4dfbb4..16bf4837b27 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1511,6 +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, PRIMARY KEY (`guid`,`skill`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3696,7 +3697,8 @@ INSERT INTO `updates` VALUES ('2022_12_30_00_characters.sql','5F90C2BFFBB8F6CE0A3327A2CAABCD5CA3C2BA60','ARCHIVED','2022-12-30 22:50:16',0), ('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_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); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2023_02_08_00_characters.sql b/sql/updates/characters/master/2023_02_08_00_characters.sql new file mode 100644 index 00000000000..f4f6b459fc8 --- /dev/null +++ b/sql/updates/characters/master/2023_02_08_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `character_skills` ADD `professionSlot` TINYINT NOT NULL DEFAULT -1 AFTER `max`; |