owpengram-server/deploy/migrations/20260916000001_account_message_restriction_state.down.sql at main - astra/owpengram-server - Zio Git

astra/owpengram-server

Astra f33e25af8d admin: add account spam restriction (join/message gate)

Adds a narrower spam sanction alongside the existing account freeze: a
restricted account keeps every existing membership and conversation, but
cannot join new channels/groups (public join or invite link) and cannot
start a new conversation with a non-contact. Reachable both as a standalone
admin action and as a decision on a reported user's moderation case, with
the same idempotent-supersession and appeal wiring freeze already has.

2026-09-16 14:03:15 +01:00

1 line

51 B

SQL

Raw Permalink Blame History

DROP TABLE IF EXISTS account_message_restrictions;