aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2022-12-30 22:54:13 +0100
committerShauren <shauren.trinity@gmail.com>2022-12-30 22:54:13 +0100
commitbb9907f0196544faf16ffc5277c60e5f42fa3748 (patch)
tree8aa1219f36d54fd576915c758fa6043ef60ec9c4 /sql
parent9a96d3235058df5929d3acccb379a7252dd53d94 (diff)
Core/Players: Fixed trait config validation
Closes #28601
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql3
-rw-r--r--sql/updates/characters/master/2022_12_30_00_characters.sql3
2 files changed, 5 insertions, 1 deletions
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`;