ALTER TABLE moderation_log
    DROP CONSTRAINT IF EXISTS moderation_log_action_check;

ALTER TABLE moderation_log
    ADD CONSTRAINT moderation_log_action_check
    CHECK (action IN ('approve', 'reject', 'request_changes', 'publish', 'archive'));

ALTER TABLE moderation_log
    DROP COLUMN IF EXISTS old_status,
    DROP COLUMN IF EXISTS new_status;
