Thinh Lam
14 lines
787 B
SQL
14 lines
787 B
SQL
-- Evidence staff review (approve / reject) on application_artifacts — must match be0/src/initiative_db/models.py ApplicationArtifact
|
|
-- New DBs: loaded by docker-compose postgres init (04_...).
|
|
-- Existing DBs: run once, e.g.
|
|
-- docker exec -i initiative-postgres psql -U initiative -d initiatives < be0/migrations/004_evidence_artifact_review.sql
|
|
-- # or: psql "$INITIATIVE_DATABASE_URL" -f be0/migrations/004_evidence_artifact_review.sql
|
|
|
|
ALTER TABLE application_artifacts
|
|
ADD COLUMN IF NOT EXISTS review_status TEXT,
|
|
ADD COLUMN IF NOT EXISTS reviewed_by UUID REFERENCES users (id) ON DELETE SET NULL,
|
|
ADD COLUMN IF NOT EXISTS reviewed_at TIMESTAMPTZ;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_application_artifacts_review
|
|
ON application_artifacts (initiative_id, review_status);
|