aboutsummaryrefslogtreecommitdiffstats
path: root/packages/db/drizzle/0041_fat_bloodstrike.sql
diff options
context:
space:
mode:
authorMohamed Bassem <me@mbassem.com>2025-02-01 15:57:32 +0000
committerMohamed Bassem <me@mbassem.com>2025-02-01 15:57:32 +0000
commitab88f59842f180ff0ebc1452c5403244b407b8bd (patch)
treef0eb98f7e774a84a16dc0e2938df93adf94a415d /packages/db/drizzle/0041_fat_bloodstrike.sql
parent76f4e352b601713ab109b25128e93bdb90200ac1 (diff)
downloadkarakeep-ab88f59842f180ff0ebc1452c5403244b407b8bd.tar.zst
feat: Add a new modifiedAt field to bookmarks table. Fixes #952
Diffstat (limited to 'packages/db/drizzle/0041_fat_bloodstrike.sql')
-rw-r--r--packages/db/drizzle/0041_fat_bloodstrike.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/packages/db/drizzle/0041_fat_bloodstrike.sql b/packages/db/drizzle/0041_fat_bloodstrike.sql
new file mode 100644
index 00000000..3db96cb1
--- /dev/null
+++ b/packages/db/drizzle/0041_fat_bloodstrike.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `bookmarks` ADD `modifiedAt` integer;
+--> statement-breakpoint
+UPDATE `bookmarks` SET `modifiedAt` = `createdAt`;