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,
    user_id INTEGER NOT NULL,
    domain TEXT NOT NULL,
    all_domains INTEGER,

    FOREIGN KEY (user_id) REFERENCES users (id)
);

DROP TABLE IF EXISTS permissions;
CREATE TABLE permissions (
    id INTEGER PRIMARY KEY,
    user_id INTEGER NOT NULL,
    is_admin INTEGER,

    FOREIGN KEY (user_id) REFERENCES users (id)
);