summaryrefslogtreecommitdiff
path: root/website/db/config.ts
blob: 1ff2450ffbcc62694a2ecf819d773c52758245b3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
import { column, defineDb, defineTable } from "astro:db";

const Otp = defineTable({
  columns: {
    userId: column.text(),
    value: column.text(),
    createdAt: column.number(),
    validUntil: column.number(),
  },
});

const SendmailToken = defineTable({
  columns: {
    userId: column.text(),
    value: column.text(),
    createdAt: column.number(),
    validUntil: column.number(),
  },
});

const SentEmails = defineTable({
  columns: {
    messageId: column.text(),
    sentAt: column.number(),
  },
});

export default defineDb({
  tables: {
    Otp,
    SendmailToken,
    SentEmails,
  },
});