ALTER TABLE terhel ADD COLUMN e_tora_tol1 character(15);
ALTER TABLE terhel ADD COLUMN e_tora_ig1 character(15);
ALTER TABLE terhel ADD COLUMN e_tora_allas1 character(15);
ALTER TABLE terhel ADD COLUMN e_tora_allas2 character(15);
ALTER TABLE terhel ADD COLUMN e_tora_kod character(15);

ALTER TABLE terhel ADD COLUMN e_termalora numeric(15,2);
ALTER TABLE terhel ADD COLUMN e_termaloft numeric(15,2);
ALTER TABLE terhel ADD COLUMN e_termalafa character(2);
ALTER TABLE terhel ADD COLUMN e_termaloft_2012 numeric(15,2);
ALTER TABLE terhel ADD COLUMN e_termalafa_2012 character(2);

ALTER TABLE afa_torzs ADD COLUMN termalvizafa character(2);
UPDATE afa_torzs SET termalvizafa = '0';