Skip to main content

max / makenotwork

454 B · 7 lines History Blame Raw
1 -- Allow a NULL actor_id in the mod log to denote a system action (e.g. a
2 -- flag-threshold auto-hide), mirroring the posts.removed_by IS NULL convention.
3 -- Previously every entry required a user actor, which forced auto-hide to record
4 -- the flagger who tripped the threshold as the "moderator", a false attribution
5 -- on an auditable, exportable ledger. Additive: existing rows are unaffected.
6 ALTER TABLE mod_log ALTER COLUMN actor_id DROP NOT NULL;
7