dodil/erp-brick-purchasing

DODIL ERP brick: purchasing

src/brick_purchasing/migrations/00003_v8/up.sql

-- 00003_v8 (spec v8): a request cancelled (who, when, why) and its ship-to as the address object; a bill keeps the supplier's VAT number and
-- address as the paper shows them (tax's content check reads them). ADD COLUMN is DISRUPTIVE: migrate the test copy first, the live one at a quiet hour.

ALTER TABLE pur_request ADD COLUMN ship_to_address_lines VARCHAR;

ALTER TABLE pur_request ADD COLUMN ship_to_address_city VARCHAR;

ALTER TABLE pur_request ADD COLUMN ship_to_address_postcode VARCHAR;

ALTER TABLE pur_request ADD COLUMN ship_to_address_region VARCHAR;

ALTER TABLE pur_request ADD COLUMN ship_to_address_country VARCHAR;

ALTER TABLE pur_request ADD COLUMN cancelled_by_email VARCHAR;

ALTER TABLE pur_request ADD COLUMN cancelled_by_sub VARCHAR;

ALTER TABLE pur_request ADD COLUMN cancelled_on DATE;

ALTER TABLE pur_request ADD COLUMN cancel_reason VARCHAR;

ALTER TABLE pur_bill ADD COLUMN supplier_vat_number VARCHAR;

ALTER TABLE pur_bill ADD COLUMN supplier_address VARCHAR;