diff options
| author | Gavin Mogan <github@gavinmogan.com> | 2025-09-09 00:28:48 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-09-09 08:28:48 +0100 |
| commit | 2cb1b28a114185b6f097d6e389375e3f6112f953 (patch) | |
| tree | 3dfdb78cb1d04ad45c3319def65dd84baa6b5f65 | |
| parent | 20f4e4712f332a05030a0f248a2caa8d91ec2a36 (diff) | |
| download | karakeep-2cb1b28a114185b6f097d6e389375e3f6112f953.tar.zst | |
fix: fix migration failing when no user settings are set. fixes #1919 (#1920)
| -rw-r--r-- | packages/db/drizzle/0061_merge_user_settings.sql | 12 |
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`; |