dodil/erp-brick-sales-order

DODIL ERP brick: sales order

src/brick_sales_order/migrations/00007_v8/up.sql

-- 00007_v8 (spec v8) - additive only. The ship-to as the address object (shared.yaml conventions.address): the order keeps the lines (a JSON array), the city,
-- the postcode and the region; the country stays ship_to_country. ADD COLUMN is DISRUPTIVE: migrate the test copy first, the live one at a quiet hour.
ALTER TABLE so_order ADD COLUMN ship_to_address_lines VARCHAR;

ALTER TABLE so_order ADD COLUMN ship_to_address_city VARCHAR;

ALTER TABLE so_order ADD COLUMN ship_to_address_postcode VARCHAR;

ALTER TABLE so_order ADD COLUMN ship_to_address_region VARCHAR;