aboutsummaryrefslogtreecommitdiffstats
path: root/packages
diff options
context:
space:
mode:
Diffstat (limited to 'packages')
-rw-r--r--packages/db/drizzle/0061_merge_user_settings.sql12
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`;