CREATE TABLE IF NOT EXISTS apps (
    id TEXT NOT NULL PRIMARY KEY,
    created BIGINT NOT NULL,
    owner TEXT NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    title TEXT NOT NULL,
    homepage TEXT NOT NULL,
    redirect TEXT NOT NULL,
    banned INT NOT NULL,
    grants INT NOT NULL,
    scopes TEXT NOT NULL
)
