adds SentEmails and SendmailToken tables to DB

1 files changed, 31 insertions, 2 deletions

diff --git a/website/db/config.ts b/website/db/config.ts
index aa0408c..1ff2450 100644
--- a/website/db/config.ts
+++ b/website/db/config.ts
@@ -1,5 +1,34 @@
-import { defineDb } from "astro:db";
+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: {},
+  tables: {
+    Otp,
+    SendmailToken,
+    SentEmails,
+  },
 });