Files
apskel-pos-backend/migrations/000074_make_purchase_order_due_date_nullable.down.sql
2026-05-29 18:24:14 +07:00

7 lines
148 B
SQL

UPDATE purchase_orders
SET due_date = transaction_date
WHERE due_date IS NULL;
ALTER TABLE purchase_orders
ALTER COLUMN due_date SET NOT NULL;