From bb9907f0196544faf16ffc5277c60e5f42fa3748 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 30 Dec 2022 22:54:13 +0100 Subject: Core/Players: Fixed trait config validation Closes #28601 --- sql/base/characters_database.sql | 3 ++- sql/updates/characters/master/2022_12_30_00_characters.sql | 3 +++ 2 files changed, 5 insertions(+), 1 deletion(-) create mode 100644 sql/updates/characters/master/2022_12_30_00_characters.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index ae7a7b33efb..1395c96ae3e 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3690,7 +3690,8 @@ INSERT INTO `updates` VALUES ('2022_11_20_00_characters.sql','4EB8BB24CAF16B0962DF3EF92C77BE05E234CFA6','ARCHIVED','2022-11-20 11:05:20',0), ('2022_12_16_00_characters.sql','36D6220143109ECD37219CC4A84773B31EAE9E50','ARCHIVED','2022-12-16 22:52:19',0), ('2022_12_17_00_characters.sql','3E005BD6B9C60653749B0B3C19CBC497092B9CCB','ARCHIVED','2022-12-17 18:26:43',0), -('2022_12_20_00_characters.sql','75A37A085AF1B953926E4352E439C7916B290924','ARCHIVED','2022-12-20 03:10:07',0); +('2022_12_20_00_characters.sql','75A37A085AF1B953926E4352E439C7916B290924','ARCHIVED','2022-12-20 03:10:07',0), +('2022_12_30_00_characters.sql','5F90C2BFFBB8F6CE0A3327A2CAABCD5CA3C2BA60','RELEASED','2022-12-30 22:50:16',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2022_12_30_00_characters.sql b/sql/updates/characters/master/2022_12_30_00_characters.sql new file mode 100644 index 00000000000..ce1280de0d7 --- /dev/null +++ b/sql/updates/characters/master/2022_12_30_00_characters.sql @@ -0,0 +1,3 @@ +-- delete corrupted trait configs +DELETE FROM `character_trait_entry`; +DELETE FROM `character_trait_config`; -- cgit v1.2.3