photoplaces/backend/migrations/000009_add_revision_status.up.sql

ALTER TABLE places DROP CONSTRAINT IF EXISTS places_status_check;
ALTER TABLE places ADD CONSTRAINT places_status_check
    CHECK (status IN ('draft', 'pending_moderation', 'published', 'rejected', 'archived', 'revision'));