INSERT INTO public.core_assets (asset_type,asset_name,description,custom,asset_innerhtml,asset_parameters,asset_code,before_trigger,after_trigger,failure_rollback,exec_order,meta,role_id) VALUES
	 ('form','normiranec_self_list_form','Form to add and edit files',false,'','{"form": [[{"id": "count_general.settings.status", "cols": 6, "name": "count_general[settings][status]", "type": "radio", "label": "Status", "values": "Popoldanski normirani SP:popoldanski;Polni normirani SP:polni", "onchange": "jivaCoreOptions.unsavedData=true;", "mandatory": true}, {"id": "count_general.settings.founding_date", "cols": 3, "name": "count_general[settings][founding_date]", "type": "date", "label": "Datum ustanovitve", "onchange": "jivaCoreOptions.unsavedData=true;", "mandatory": true}, {"id": "count_general.settings.starting_date", "cols": 2, "name": "count_general[settings][starting_date]", "type": "hidden", "label": "Začetek uporabe orodja", "default": "today", "onchange": "jivaCoreOptions.unsavedData=true;", "mandatory": true}, {"id": "count_general.settings.letAkontacijaDohodnine", "cols": 3, "name": "count_general[settings][letAkontacijaDohodnine]", "type": "text", "label": "Letošnja akontacija dohodnine", "onchange": "jivaCoreOptions.unsavedData=true;", "mandatory": true, "helperTooltip": "table_self_profile_settings_akontacija_dohodnine_tooltip", "additionalClass": "eur_decimal"}]], "related": {"count_general": {"setting": "count_settings.count_general_configuration"}}}',NULL,NULL,NULL,NULL,NULL,NULL,NULL);

-- Auto-generated SQL script #202312191351
UPDATE public.core_assets
	SET asset_parameters='{
  "form": [
    [
      {
        "id": "select_import",
        "cols": 3,
        "name": "file",
        "type": "file",
        "label": "form_stash_files_select",
        "folder": "settings",
        "filename": "excel_import.xlsx",
        "onchange": "jivaCoreFunc.onChange.fileUpload(this);"
      },
      {
        "id": "",
        "cols": 2,
        "type": "buttons",
        "label": "Process",
        "buttons": [
          {
            "id": "self_normiranec_import_process_button",
            "icon": "<i class=\"fa-solid fa-code-compare\"></i>",
            "onclick": "processFileData();"
          }
        ],
        "mandatory": false
      }
    ]
  ]
}'::jsonb
	WHERE asset_name='normiranec_import_list_form';

CREATE TABLE public.code_list_languages (
	code varchar(5) NOT NULL,
	description varchar(50) NULL,
	ord int8 NULL,
	icon varchar(255) NULL,
	misc varchar(255) NULL,
	properties jsonb NULL,
	CONSTRAINT idx_languages_primary PRIMARY KEY (code)
);
CREATE UNIQUE INDEX code_list_languages_code_idx ON public.code_list_languages USING btree (code);

INSERT INTO public.code_list_languages (code,description,ord,icon,misc,properties) VALUES
	 ('en-EN','english',NULL,NULL,NULL,NULL),
	 ('sl-SL','sloveniščina',NULL,NULL,NULL,NULL),
	 ('it-IT','italiano',NULL,NULL,NULL,NULL);