diff options
Diffstat (limited to 'packages/db/schema.ts')
| -rw-r--r-- | packages/db/schema.ts | 7 |
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" }) |