fix: Get rid of the userSetting table completely

1 files changed, 14 insertions, 0 deletions

diff --git a/packages/db/drizzle/0061_merge_user_settings.sql b/packages/db/drizzle/0061_merge_user_settings.sql
new file mode 100644
index 00000000..46c11739
--- /dev/null
+++ b/packages/db/drizzle/0061_merge_user_settings.sql
@@ -0,0 +1,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` = (
+    SELECT `bookmarkClickAction` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
+  ),
+  `archiveDisplayBehaviour` = (
+    SELECT `archiveDisplayBehaviour` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
+  ),
+  `timezone` = (
+    SELECT `timezone` FROM `userSettings` WHERE `userSettings`.`userId` = `user`.`id`
+  );--> statement-breakpoint
+DROP TABLE `userSettings`;