-- zmeny v databaze globis

ALTER TABLE contract ADD COLUMN invoice_papermail BOOLEAN DEFAULT true;
ALTER TABLE contract ADD COLUMN invoice_email BOOLEAN DEFAULT true;

-- pridanie prefix-u pre jednotlivych supplierov na zmluvach
ALTER TABLE contract_type_person ADD COLUMN evid_prefix VARCHAR;
UPDATE contract_type_person SET evid_prefix='770' WHERE supplier='t' AND contract_type=2 AND person=7;
UPDATE contract_type_person SET evid_prefix='220' WHERE supplier='t' AND contract_type=3 AND person=2;
UPDATE contract_type_person SET evid_prefix='880' WHERE supplier='t' AND contract_type=4 AND person=8;
