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 active boolean NOT NULL DEFAULT false, 7 created_at INTEGER DEFAULT (strftime('%s', 'now')) 8); 9