packages/db/drizzle/0061_merge_user_settings.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

ALTER TABLE `user` ADD `bookmarkClickAction` text DEFAULT 'open_original_link' NOT NULL;--> statement-breakpoint
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` = coalesce((
    SELECT `bookmarkClickAction` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
  ), 'open_original_link'),
  `archiveDisplayBehaviour` = coalesce((
    SELECT `archiveDisplayBehaviour` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
  ), 'show'),
  `timezone` = coalesce((
    SELECT `timezone` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
  ), 'UTC');--> statement-breakpoint
DROP TABLE `userSettings`;