schema.sql (view raw)
1CREATE TABLE user (
2 id INTEGER PRIMARY KEY NOT NULL,
3 username TEXT NOT NULL UNIQUE,
4 email TEXT NOT NULL UNIQUE,
5 password_hash TEXT NOT NULL,
6 approved boolean NOT NULL DEFAULT false,
7 created_at INTEGER DEFAULT (strftime('%s', 'now'))
8);
9
10CREATE TABLE cookie_key (
11 value TEXT NOT NULL;
12);