path: root/makima/migrations/20260217000000_add_order_under_review_status.sql

-- Add under_review status to orders for orders whose steps exist but are not yet merged
ALTER TABLE orders DROP CONSTRAINT IF EXISTS orders_status_check;
ALTER TABLE orders ADD CONSTRAINT orders_status_check
    CHECK (status IN ('open', 'in_progress', 'under_review', 'done', 'archived'));