ALTER TABLE egysegarak ADD COLUMN deviza_nev character(4);
ALTER TABLE egysegarak ALTER COLUMN deviza_nev SET STORAGE EXTENDED;

update egysegarak set deviza_nev = 'HUF' where deviza_nev is null;

ALTER TABLE _setup_main ADD COLUMN deviza_nev character(4);
ALTER TABLE _setup_main ALTER COLUMN deviza_nev SET STORAGE EXTENDED;

update _setup_main set deviza_nev = 'HUF' where deviza_nev is null;

ALTER TABLE deviza ADD COLUMN bizonylat_vegosszeg_kerekites smallint;
ALTER TABLE deviza ALTER COLUMN bizonylat_vegosszeg_kerekites SET STORAGE PLAIN;
ALTER TABLE deviza ALTER COLUMN bizonylat_vegosszeg_kerekites SET DEFAULT 0;

update deviza set bizonylat_vegosszeg_kerekites = 0 where nev = 'HUF';
update deviza set bizonylat_vegosszeg_kerekites = 2 where nev <> 'HUF';


ALTER TABLE lang_key ADD COLUMN font character(40);
ALTER TABLE lang_key ALTER COLUMN font SET STORAGE EXTENDED;

ALTER TABLE lang_key ADD COLUMN carset character(40);
ALTER TABLE lang_key ALTER COLUMN carset SET STORAGE EXTENDED;

ALTER TABLE lang_key ADD COLUMN key_code_withname character(40);
ALTER TABLE lang_key ALTER COLUMN key_code_withname SET STORAGE EXTENDED;

CREATE TABLE bizonylat_nyelv
(
  kod serial NOT NULL,
  lang_0000040e character varying(120),
  lang_00000409 character varying(120),
  lang_00000407 character varying(120),
  order_field integer,
  CONSTRAINT bizonylat_nyelv_pkey PRIMARY KEY (kod)
)
WITHOUT OIDS;
