From ab88f59842f180ff0ebc1452c5403244b407b8bd Mon Sep 17 00:00:00 2001
From: Mohamed Bassem <me@mbassem.com>
Date: Sat, 1 Feb 2025 15:57:32 +0000
Subject: feat: Add a new modifiedAt field to bookmarks table. Fixes #952

---
 packages/db/schema.ts | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'packages/db/schema.ts')

diff --git a/packages/db/schema.ts b/packages/db/schema.ts
index c1706edf..6bd67448 100644
--- a/packages/db/schema.ts
+++ b/packages/db/schema.ts
@@ -19,6 +19,12 @@ function createdAtField() {
     .$defaultFn(() => new Date());
 }
 
+function modifiedAtField() {
+  return integer("modifiedAt", { mode: "timestamp" })
+    .$defaultFn(() => new Date())
+    .$onUpdate(() => new Date());
+}
+
 export const users = sqliteTable("user", {
   id: text("id")
     .notNull()
@@ -103,6 +109,7 @@ export const bookmarks = sqliteTable(
       .primaryKey()
       .$defaultFn(() => createId()),
     createdAt: createdAtField(),
+    modifiedAt: modifiedAtField(),
     title: text("title"),
     archived: integer("archived", { mode: "boolean" }).notNull().default(false),
     favourited: integer("favourited", { mode: "boolean" })
-- 
cgit v1.2.3-70-g09d2