blob: c591fb11612aa303d574f66587d6e0287c43e2b8 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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
)
|