template-vitrine/backend/migrations/000027_drop_status_from_orders.down.sql

ALTER TABLE orders
    ADD COLUMN status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'preparing', 'shipped', 'completed', 'cancelled'));