max / makenotwork

573 B · 12 lines History Blame Raw

1	-- User account suspension and appeal fields.
2	-- A user is suspended when suspended_at IS NOT NULL.
3	-- One appeal at a time: admin clears suspension or denies, user can re-appeal after denial.
4
5	ALTER TABLE users ADD COLUMN suspended_at TIMESTAMPTZ;
6	ALTER TABLE users ADD COLUMN suspension_reason TEXT;
7	ALTER TABLE users ADD COLUMN appeal_text TEXT;
8	ALTER TABLE users ADD COLUMN appeal_submitted_at TIMESTAMPTZ;
9	ALTER TABLE users ADD COLUMN appeal_decision TEXT;
10	ALTER TABLE users ADD COLUMN appeal_response TEXT;
11	ALTER TABLE users ADD COLUMN appeal_decided_at TIMESTAMPTZ;
12