all repos — stealth-developers @ b9d33cd3b741a8075a82d4d1403b7cee6eec9f48

pkgs/bot/src/database/schema/sessions.ts (view raw)

 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
import { sqliteTable, text, integer } from "drizzle-orm/sqlite-core";
import { sql } from "drizzle-orm";

export const sessions = sqliteTable("sessions", {
	id: text("id").primaryKey(),
	userId: text("user_id").notNull(),
	username: text("username").notNull(),
	createdAt: integer("created_at", { mode: "timestamp" })
		.default(sql`(unixepoch())`)
		.notNull(),
});