first commit

1 files changed, 19 insertions, 0 deletions

diff --git a/database.txt b/database.txt
new file mode 100644
index 0000000..c591fb1
--- /dev/null
+++ b/database.txt
@@ -0,0 +1,19 @@
+the following tables exist in the database:
+
+CREATE TABLE users (
+  user_id TEXT PRIMARY KEY,
+  email TEXT UNIQUE NOT NULL,
+  email_verified INTEGER NOT NULL
+)
+
+CREATE TABLE signin_keys (
+  user_id TEXT PRIMARY KEY,
+  key TEXT NOT NULL,
+  expires INTEGER NOT NULL
+)
+
+CREATE TABLE sessions (
+  session_id TEXT PRIMARY KEY
+  user_id TEXT UNIQUE NOT NULL,
+  expires INTEGER NOT NULL
+)