1
import { integer, sqliteTable, text, uniqueIndex } from "drizzle-orm/sqlite-core";
2
 
3
import { users } from "@/worker/db/d1/schema/users";
4
 
5
export const tesseraIdentities = sqliteTable(
6
  "tessera_identities",
7
  {
8
    sub: text("sub").primaryKey(),
9
    userId: text("user_id")
10
      .notNull()
11
      .references(() => users.id, { onDelete: "cascade" }),
12
    createdAt: integer("created_at").notNull(),
13
    lastSeenAt: integer("last_seen_at"),
14
  },
15
  (table) => [uniqueIndex("idx_tessera_identities_user_id").on(table.userId)],
16
);