fix: fix migration failing when no user settings are set. fixes #1919 (#1920)

1 files changed, 6 insertions, 6 deletions

diff --git a/packages/db/drizzle/0061_merge_user_settings.sql b/packages/db/drizzle/0061_merge_user_settings.sql
index 46c11739..7a12ef60 100644
--- a/packages/db/drizzle/0061_merge_user_settings.sql
+++ b/packages/db/drizzle/0061_merge_user_settings.sql
@@ -2,13 +2,13 @@ ALTER TABLE `user` ADD `bookmarkClickAction` text DEFAULT 'open_original_link' N
 ALTER TABLE `user` ADD `archiveDisplayBehaviour` text DEFAULT 'show' NOT NULL;--> statement-breakpoint
 ALTER TABLE `user` ADD `timezone` text DEFAULT 'UTC';--> statement-breakpoint
 UPDATE `user` SET
-  `bookmarkClickAction` = (
+  `bookmarkClickAction` = coalesce((
     SELECT `bookmarkClickAction` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
-  ),
-  `archiveDisplayBehaviour` = (
+  ), 'open_original_link'),
+  `archiveDisplayBehaviour` = coalesce((
     SELECT `archiveDisplayBehaviour` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
-  ),
-  `timezone` = (
+  ), 'show'),
+  `timezone` = coalesce((
     SELECT `timezone` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
-  );--> statement-breakpoint
+  ), 'UTC');--> statement-breakpoint
 DROP TABLE `userSettings`;