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