feat: Add a new modifiedAt field to bookmarks table. Fixes #952

1 files changed, 7 insertions, 0 deletions

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" })