9 lines
382 B
SQL
9 lines
382 B
SQL
-- P5-3794 Add EDI invoice type to contract_customers
|
|
|
|
ALTER TABLE contract_customers DROP CONSTRAINT contract_customers_send_invoice_check;
|
|
|
|
ALTER TABLE contract_customers ADD CONSTRAINT contract_customers_send_invoice_check
|
|
CHECK (send_invoice::text = ANY (ARRAY['snail mail'::character varying::text,
|
|
'email'::character varying::text, 'edi'::character varying::text])
|
|
);
|