Skip to main content

max / makenotwork

485 B · 12 lines History Blame Raw
1 CREATE TABLE mod_log (
2 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
3 community_id UUID REFERENCES communities(id) ON DELETE CASCADE,
4 actor_id UUID NOT NULL REFERENCES users(mnw_account_id),
5 action TEXT NOT NULL,
6 target_user UUID REFERENCES users(mnw_account_id),
7 target_id UUID,
8 reason TEXT,
9 created_at TIMESTAMPTZ NOT NULL DEFAULT now()
10 );
11 CREATE INDEX idx_mod_log_community ON mod_log (community_id, created_at DESC);
12