aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/characters/master/2022_07_03_00_characters.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2022_07_03_00_characters.sql b/sql/updates/characters/master/2022_07_03_00_characters.sql
new file mode 100644
index 00000000000..11ed0f7e42c
--- /dev/null
+++ b/sql/updates/characters/master/2022_07_03_00_characters.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `character_queststatus_seasonal` ADD `completedTime` bigint NOT NULL DEFAULT '0' AFTER `event`;
+
+UPDATE `character_queststatus_seasonal` SET `completedTime` = UNIX_TIMESTAMP();
+
+DELETE FROM `worldstates` WHERE `entry` BETWEEN 1 AND 85;