all repos — flounder @ e806ee97af47b96ed240b2c4ff0e20ee99eb4640

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
10CREATE TABLE cookie_key (
11  value TEXT NOT NULL;
12);