BEGIN;

ALTER TABLE purchase_orders ADD COLUMN ship_to_location_id UUID REFERENCES locations(id);
ALTER TABLE purchase_orders ADD COLUMN ship_to_name VARCHAR(255);
ALTER TABLE purchase_orders ADD COLUMN ship_to_address VARCHAR(255);
ALTER TABLE purchase_orders ADD COLUMN ship_to_city VARCHAR(100);
ALTER TABLE purchase_orders ADD COLUMN ship_to_state VARCHAR(50);
ALTER TABLE purchase_orders ADD COLUMN ship_to_zip VARCHAR(20);
ALTER TABLE purchase_orders ADD COLUMN ship_to_phone VARCHAR(50);

VALUES ('010', 'PO ship-to fields');

COMMIT;
