| 1 | -- Staff suspend an account or a workspace, and block email domains from |
| 2 | -- signing up (src/suspension.rs). Lifting a suspension clears its columns; |
| 3 | -- every change is in the staff audit log. |
| 4 | ALTER TABLE users ADD COLUMN suspended_at TEXT; |
| 5 | ALTER TABLE users ADD COLUMN suspended_reason TEXT; |
| 6 | ALTER TABLE users ADD COLUMN suspended_by TEXT; |
| 7 | ALTER TABLE workspaces ADD COLUMN suspended_at TEXT; |
| 8 | ALTER TABLE workspaces ADD COLUMN suspended_reason TEXT; |
| 9 | ALTER TABLE workspaces ADD COLUMN suspended_by TEXT; |
| 10 | |
| 11 | CREATE TABLE IF NOT EXISTS blocked_domains ( |
| 12 | domain TEXT PRIMARY KEY, |
| 13 | reason TEXT NOT NULL, |
| 14 | blocked_by TEXT NOT NULL, |
| 15 | created_at TEXT NOT NULL |
| 16 | ); |