projekt kivitendo

  record_type             => { type => 'text', not_null => 1 },

-- @tag: order_type

-- @description: Persistente Typen in Aufträgen

-- @depends: release_3_7_0

ALTER TABLE oe ADD COLUMN record_type TEXT;

UPDATE oe SET record_type = 'sales_order'

  WHERE customer_id IS NOT NULL and quotation = FALSE;

UPDATE oe SET record_type = 'purchase_order'

  WHERE vendor_id   IS NOT NULL and quotation = FALSE;

UPDATE oe SET record_type = 'sales_quotation'

  WHERE customer_id IS NOT NULL and quotation = TRUE;

UPDATE oe SET record_type = 'request_quotation'

  WHERE vendor_id   IS NOT NULL and quotation = TRUE;

ALTER TABLE oe ALTER COLUMN record_type SET NOT NULL;