v7: Schema - remote_contributions table & project_collaborators column #12

New issue

Closed

opened 2026-06-22 23:54:49 +00:00 by rbrooks · 0 comments

rbrooks commented

2026-06-22 23:54:49 +00:00

Owner

Migration for the cross-instance write path.

project_collaborators: add remote_actor_url text (nullable, UNIQUE when not null)
New remote_contributions table: id uuid PK, project_id uuid NOT NULL REFERENCES projects ON DELETE CASCADE, remote_actor_url text NOT NULL, activity_type text NOT NULL CHECK (activity_type IN ('create','update','delete')), entry_id uuid REFERENCES entries ON DELETE SET NULL, payload jsonb NOT NULL, status text NOT NULL DEFAULT 'pending' CHECK (status IN ('pending','applied','rejected','conflict')), conflict_reason text, reviewed_by uuid REFERENCES users ON DELETE SET NULL, reviewed_at timestamptz, created_at timestamptz NOT NULL DEFAULT now()

Imported from ROADMAP.md.

Migration for the cross-instance write path. - [ ] `project_collaborators`: add `remote_actor_url text` (nullable, `UNIQUE` when not null) - [ ] New `remote_contributions` table: `id uuid PK`, `project_id uuid NOT NULL REFERENCES projects ON DELETE CASCADE`, `remote_actor_url text NOT NULL`, `activity_type text NOT NULL CHECK (activity_type IN ('create','update','delete'))`, `entry_id uuid REFERENCES entries ON DELETE SET NULL`, `payload jsonb NOT NULL`, `status text NOT NULL DEFAULT 'pending' CHECK (status IN ('pending','applied','rejected','conflict'))`, `conflict_reason text`, `reviewed_by uuid REFERENCES users ON DELETE SET NULL`, `reviewed_at timestamptz`, `created_at timestamptz NOT NULL DEFAULT now()` --- _Imported from `ROADMAP.md`._

rbrooks added this to the v7.0.0 - Cross-Instance Collaborative Editing milestone

2026-06-22 23:54:49 +00:00

rbrooks added the

enhancement

label

2026-06-22 23:54:49 +00:00