Get current user session

1 files changed, 2 insertions, 1 deletions

diff --git a/src/db/schema.ts b/src/db/schema.ts
index 01b7228..339dfc0 100644
--- a/src/db/schema.ts
+++ b/src/db/schema.ts
@@ -1,4 +1,4 @@
-import { relations } from "drizzle-orm";
+import { relations, sql } from "drizzle-orm";
 import { text, sqliteTable, integer } from "drizzle-orm/sqlite-core";
 
 export const groupTable = sqliteTable("groups", {
@@ -17,6 +17,7 @@ export const sessionTable = sqliteTable("sessions", {
     id: integer().primaryKey(),
     uuid: text().unique().notNull(),
     userId: integer("user_id").notNull(),
+    lastUse: integer("last_use", { mode: "timestamp" }).notNull().default(sql`(unixepoch())`),
 });
 
 export const sessionRelations = relations(sessionTable, ({ one }) => ({