Skip to content

The only tool you need to know what is happening and how to fix it.

312 B
Raw Blame
CREATE TABLE IF NOT EXISTS project_user_roles (
    id SERIAL PRIMARY KEY,
    project_id UUID NOT NULL REFERENCES projects(id),
    user_id INTEGER NOT NULL REFERENCES users(id),
    role TEXT NOT NULL CHECK (role IN ('user','readonly')),
    created_at TIMESTAMPTZ NOT NULL,
    UNIQUE (project_id, user_id)
)