ALTER TABLE vallalat ADD COLUMN nav_loginname character varying(30);
ALTER TABLE vallalat ADD COLUMN nav_password character varying(30);
ALTER TABLE vallalat ADD COLUMN nav_xmlkey1 character varying(200);
ALTER TABLE vallalat ADD COLUMN nav_xmlkey2 character varying(200);
ALTER TABLE vallalat ADD COLUMN nav_repeat_timer integer;
ALTER TABLE vallalat ADD COLUMN nav_kezdo_datum date;
ALTER TABLE vallalat ADD COLUMN nav_afa_hatar integer;
ALTER TABLE vallalat ADD COLUMN nav_invoice_environment smallint;

UPDATE vallalat SET nav_kezdo_datum = '2018-07-01'; 
UPDATE vallalat SET nav_afa_hatar = 100000;
UPDATE vallalat SET nav_invoice_environment = 0;
UPDATE vallalat SET nav_repeat_timer = 300;
