Core: Update to 10.1

1 files changed, 8 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2023_05_04_00_characters.sql b/sql/updates/characters/master/2023_05_04_00_characters.sql
new file mode 100644
index 00000000000..39c40b14220
--- /dev/null
+++ b/sql/updates/characters/master/2023_05_04_00_characters.sql
@@ -0,0 +1,8 @@
+
+ALTER TABLE `characters` ADD `power8` int unsigned NOT NULL DEFAULT 0 AFTER `power7`;
+ALTER TABLE `characters` ADD `power9` int unsigned NOT NULL DEFAULT 0 AFTER `power8`;
+ALTER TABLE `characters` ADD `power10` int unsigned NOT NULL DEFAULT 0 AFTER `power9`;
+
+ALTER TABLE `character_stats` ADD `maxpower8` int unsigned NOT NULL DEFAULT 0 AFTER `maxpower7`;
+ALTER TABLE `character_stats` ADD `maxpower9` int unsigned NOT NULL DEFAULT 0 AFTER `maxpower8`;
+ALTER TABLE `character_stats` ADD `maxpower10` int unsigned NOT NULL DEFAULT 0 AFTER `maxpower9`;