all repos — flounder @ 24ee6c88b1078bc97712ad3c686c455ba152b717

A small site builder for the Gemini protocol

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