database/000_init.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE schema_version (
	version INTEGER NOT NULL
);
CREATE TABLE users (
	id INTEGER PRIMARY KEY,
	username TEXT NOT NULL UNIQUE,
	hash TEXT,
	email TEXT,
	created_at DATE DEFAULT (datetime('now'))
);
-- TODO deleted column