7 lines
148 B
SQL
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;
|