From 7b89b4cd703ee1123f01e3ddba0ae24911baf410 Mon Sep 17 00:00:00 2001 From: Benji Dial Date: Wed, 7 Feb 2024 19:04:23 -0500 Subject: first commit --- database.txt | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 database.txt (limited to 'database.txt') 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 +) -- cgit v1.2.3