ALTER TABLE partner
   ADD COLUMN agrar_kamarai_reg_szam character varying(60) DEFAULT '';
ALTER TABLE partner
   ADD COLUMN ggn_szam character varying(60) DEFAULT '';
   
UPDATE partner SET agrar_kamarai_reg_szam = '' WHERE agrar_kamarai_reg_szam is null;
UPDATE partner SET ggn_szam = '' WHERE ggn_szam is null; 