DROP TABLE IF EXISTS users;
CREATE TABLE users (
    id INTEGER PRIMARY KEY,
    username TEXT NOT NULL UNIQUE,
    name TEXT,
    salt TEXT,
    password_hash TEXT,
    tz_offset INTEGER,
);

DROP TABLE IF EXISTS domainpermissions;
CREATE TABLE domainpermissions (
    id INTEGER PRIMARY KEY,
    username TEXT NOT NULL,
    domain TEXT NOT NULL,

    FOREIGN KEY (username) REFERENCES users (username)
);