Files
spsays-bff/migrations/0041_report_resolution_note.up.sql
2026-06-16 19:03:06 +05:30

6 lines
373 B
SQL

-- A resolution note captured when an admin resolves a report (shown in the
-- admin reports table). Additive nullable column on each report table.
ALTER TABLE post_reports ADD COLUMN IF NOT EXISTS resolution_note TEXT;
ALTER TABLE comment_reports ADD COLUMN IF NOT EXISTS resolution_note TEXT;
ALTER TABLE user_reports ADD COLUMN IF NOT EXISTS resolution_note TEXT;