412 lines
19 KiB
Plaintext
412 lines
19 KiB
Plaintext
/*
|
|
* Update script van FACILITOR schema
|
|
* $Revision$
|
|
* $Id$
|
|
*/
|
|
#include "prologue.inc"
|
|
|
|
COMMIT;
|
|
SET DEFINE OFF
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#64017
|
|
|
|
ALTER TABLE fac_widget DROP CONSTRAINT fac_c_widgettype1;
|
|
ALTER TABLE fac_widget
|
|
ADD CONSTRAINT fac_c_widgettype1 CHECK
|
|
( (fac_widget_type IN ('FAC', 'URL', 'IMG', 'FLR') AND fac_widget_url IS NOT NULL)
|
|
OR (fac_widget_type IN ('MK', 'MI', 'RAP', 'FAQ') AND fac_widget_typerefkey IS NOT NULL)
|
|
OR (fac_widget_type = 'RAW' AND fac_widget_content IS NOT NULL));
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#64044
|
|
|
|
-- Pinned & Favorieten; fac_menu_level => 2
|
|
UPDATE fac_menu
|
|
SET fac_menu_level = 2
|
|
WHERE fac_menu_altgroep IN (5, 6);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// BLOS#70330
|
|
DELETE FROM fac_groeprechten
|
|
WHERE fac_functie_key IN (SELECT fac_functie_key
|
|
FROM fac_functie
|
|
WHERE fac_functie_code in ('FAC_FINUSE','WEB_SCHBOF','WEB_FGCNT')
|
|
);
|
|
DELETE FROM fac_functie WHERE fac_functie_code IN ('FAC_FINUSE', 'WEB_SCHBOF', 'WEB_FGCNT');
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#70518
|
|
DELETE FROM fac_srtnotificatie
|
|
WHERE fac_srtnotificatie_code IN ('ADDPRS','COMPPZ','COMPSC','COMPCP','COMPFC','WIJZNW','WIJZSC','WIJZFC','WIJZSU');
|
|
|
|
BEGIN
|
|
adm.tryalter ('TABLE ins_ol_history DROP CONSTRAINT ins_ol_history_key');
|
|
adm.tryalter ('TABLE ins_ol_history DROP CONSTRAINT ins_ol_history_type');
|
|
adm.tryalter ('TABLE ins_ol_history DROP CONSTRAINT ins_alg_locatie_key');
|
|
adm.trydrop ('TRIGGER ins_t_ins_ol_history_B_IU');
|
|
adm.trydrop ('SEQUENCE ins_s_ins_ol_history_key');
|
|
adm.trydrop ('TABLE ins_ol_history');
|
|
adm.trydrop ('TABLE ins_ol_kenmerk');
|
|
END;
|
|
/
|
|
|
|
DELETE FROM fac_menuitems
|
|
WHERE fac_menuitems_url LIKE '%outlet%';
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// HSLE#68733
|
|
DEF_FAC_FUNCTIE3('WEB_MLDMSA', 'MLD', 0, 0, 2);
|
|
|
|
DECLARE
|
|
functie_key fac_functie.fac_functie_key%TYPE;
|
|
BEGIN
|
|
SELECT fac_functie_key
|
|
INTO functie_key
|
|
FROM fac_functie
|
|
WHERE fac_functie_code = 'WEB_MLDMSA';
|
|
--
|
|
INSERT INTO fac_groeprechten
|
|
( fac_groep_key
|
|
, fac_functie_key
|
|
, fac_gebruiker_prs_level_read, fac_gebruiker_alg_level_read, fac_gebruiker_prs_level_write, fac_gebruiker_alg_level_write
|
|
)
|
|
SELECT g.fac_groep_key, functie_key, -1,-1,-1,-1
|
|
FROM fac_groeprechten g
|
|
, fac_functie f
|
|
WHERE f.fac_functie_key = g.fac_functie_key
|
|
AND f.fac_functie_code = 'WEB_MLDMGT';
|
|
--
|
|
UPDATE fac_menuitems
|
|
SET fac_functie_key = functie_key
|
|
WHERE fac_menuitems_label = 'lcl_menu_mld_afmeldteksten';
|
|
--
|
|
UPDATE fac_menu
|
|
SET fac_functie_key = functie_key
|
|
WHERE fac_menu_altlabel = 'lcl_menu_mld_afmeldteksten'
|
|
AND fac_functie_key = (SELECT fac_functie_key FROM fac_functie WHERE fac_functie_code = 'WEB_MLDMGT');
|
|
END;
|
|
/
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// RWSN#58015
|
|
|
|
DEF_MENUITEM(3, 'lcl_mobile_news' , '', 'FAC', 'appl/pda/portalnews.asp', 0, 0, 'WEB_MLDUSE', 'R', '0', 'fa-newspaper');
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#68072
|
|
ALTER TABLE fac_imp_mld ADD (ins_discipline_image VARCHAR2(255), mld_stdmelding_image VARCHAR2(255));
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#69170
|
|
ALTER TABLE prs_kostenplaatsgrp ADD (
|
|
prs_kostenplaatsgrp_fin_limit1
|
|
NUMBER(8),
|
|
prs_kostenplaatsgrp_fin_limit2
|
|
NUMBER(8)
|
|
);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#71324
|
|
ALTER TABLE bez_afspraak
|
|
MODIFY bez_afspraak_gastheer VARCHAR2 (120);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FMHN#66819
|
|
DEF_FAC_SRTNOT('FAQUPD', 0, 'lcl_noti_FAQUPD', 'faq/fac_faq.asp?faq_key=', '0', 'kennisbank', 60);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// UWVA#71401
|
|
CREATE INDEX bez_i_bez_afspraak_bez8 ON bez_afspraak(mld_opdr_key);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// BLCC#60989
|
|
DEF_FAC_SRTNOT('CNTMEN', 3, 'lcl_noti_CNTMEN', 'cnt/cnt_contract.asp?cnt_key=', '0', 'contract', 10);
|
|
DEF_FAC_SRTNOT('FINMEN', 3, 'lcl_noti_FINMEN', 'fin/fin_factuur.asp?fin_key=', '0', 'factuur', 10);
|
|
DEF_FAC_SRTNOT('INSMEN', 3, 'lcl_noti_INSMEN', 'ins/ins_deel.asp?ins_key=', '0', 'deel', 10);
|
|
DEF_FAC_SRTNOT('MLDMEN', 3, 'lcl_noti_MLDMEN', 'mld/mld_melding.asp?mld_key=', '0', 'melding', 10);
|
|
DEF_FAC_SRTNOT('ORDMEN', 3, 'lcl_noti_ORDMEN', 'mld/mld_opdr.asp?opdr_key=', '0', 'opdracht', 10);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// VOLK#71732
|
|
ALTER TABLE prs_werkplek MODIFY prs_werkplek_volgnr NUMBER(8);
|
|
ALTER TABLE prj_werkplek MODIFY prj_werkplek_volgnr NUMBER(8);
|
|
ALTER TABLE fac_imp_perslid MODIFY prs_werkplek_volgnr NUMBER(8);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// MDUX#64435
|
|
ALTER TABLE bes_bestelopdr_item MODIFY bes_bestelopdr_item_inkprijs NUMBER(11,5);
|
|
ALTER TABLE bes_bestelopdr_item MODIFY bes_bestelopdr_item_brutoprijs NUMBER(11,5);
|
|
ALTER TABLE bes_bestelling_item MODIFY bes_bestelling_item_brutoprijs NUMBER(11,5);
|
|
ALTER TABLE bes_srtdeel_prijs MODIFY bes_srtdeel_prijs_prijs NUMBER(11,5);
|
|
ALTER TABLE bes_srtdeel_prijs MODIFY bes_srtdeel_prijs_inkprijs NUMBER(11,5);
|
|
ALTER TABLE bes_srtprod_prijs MODIFY bes_srtprod_prijs_prijs NUMBER(11,5);
|
|
ALTER TABLE bes_srtprod_prijs MODIFY bes_srtprod_prijs_inkprijs NUMBER(11,5);
|
|
ALTER TABLE bes_bedrijf_srtprod MODIFY bes_bedrijf_srtprod_prijs NUMBER(11,5);
|
|
ALTER TABLE fac_imp_catalogus MODIFY ins_srtdeel_prijs NUMBER(11,5);
|
|
ALTER TABLE fac_imp_catalogus MODIFY ins_srtdeel_inkprijs NUMBER(11,5);
|
|
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// KMMO#71593
|
|
UPDATE fac_setting
|
|
SET fac_setting_pvalue = NULL
|
|
WHERE FAC_SETTING_NAME LIKE 'fac_reserved_number1';
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#71771
|
|
CREATE INDEX fac_i_fac_imp_file1 ON fac_imp_file(fac_import_key);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// VLKC#68725
|
|
ALTER TABLE mld_stdmelding
|
|
ADD prs_kostenplaats_key
|
|
NUMBER(10)
|
|
CONSTRAINT mld_r_prs_kostenplaats_key3 REFERENCES prs_kostenplaats (prs_kostenplaats_key);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#72113
|
|
CREATE INDEX mld_i_mld_opdr18 on mld_opdr(mld_opdr_parent_key);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#65011
|
|
DEF_FAC_FUNCTIE3('WEB_FACRFR', 'FAC', 0, 0, NULL);
|
|
|
|
UPDATE fac_menu
|
|
SET fac_functie_key = (SELECT fac_functie_key FROM fac_functie WHERE fac_functie_code = 'WEB_FACRFR')
|
|
WHERE fac_menu_altlabel = 'lcl_menu_fac_refresh_accept';
|
|
|
|
UPDATE fac_menuitems
|
|
SET fac_functie_key = (SELECT fac_functie_key FROM fac_functie WHERE fac_functie_code = 'WEB_FACRFR')
|
|
WHERE fac_menuitems_label = 'lcl_menu_fac_refresh_accept';
|
|
|
|
ALTER PACKAGE fac COMPILE; // anders (nog) invalid en lukt het volgende niet niet
|
|
ALTER PACKAGE fac COMPILE BODY;
|
|
|
|
INSERT INTO fac_groeprechten
|
|
( fac_groep_key
|
|
, fac_functie_key
|
|
, fac_gebruiker_prs_level_read, fac_gebruiker_alg_level_read, fac_gebruiker_prs_level_write, fac_gebruiker_alg_level_write
|
|
)
|
|
(SELECT gr.fac_groep_key
|
|
, (SELECT fac_functie_key FROM fac_functie WHERE fac_functie_code = 'WEB_FACRFR')
|
|
, -1,-1,-1,-1
|
|
FROM fac_groeprechten gr
|
|
, fac_functie ff
|
|
WHERE ff.fac_functie_key = gr.fac_functie_key
|
|
AND ff.fac_functie_code = 'WEB_PRSSYS'
|
|
);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#72083
|
|
UPDATE fac_menu
|
|
SET fac_menu_alturl = 'https://facilitor.nl/status'
|
|
, fac_menu_altlabel = 'lcl_Facilitor_Status'
|
|
WHERE fac_menu_altlabel = 'lcl_Facilitor_Forum';
|
|
|
|
UPDATE fac_menuitems
|
|
SET fac_menuitems_url = 'https://facilitor.nl/status'
|
|
, fac_menuitems_label = 'lcl_Facilitor_Status'
|
|
WHERE fac_menuitems_label = 'lcl_Facilitor_Forum';
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// KFSG#72129
|
|
DELETE FROM fac_session
|
|
WHERE prs_perslid_key IN
|
|
(SELECT prs_perslid_key
|
|
FROM prs_perslid
|
|
WHERE prs_perslid_inactief IS NOT NULL
|
|
);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// MARX#72091
|
|
ALTER TABLE prs_bedrijf_bedrijf ADD
|
|
( prs_bedrijf_bedrijf_account1 VARCHAR2(60)
|
|
, prs_bedrijf_bedrijf_account2 VARCHAR2(60)
|
|
);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// BAMG#71612
|
|
ALTER TABLE alg_gebouw
|
|
ADD (alg_gebouw_mld NUMBER(1) DEFAULT(1)
|
|
CONSTRAINT alg_c_alg_gebouw_mld CHECK(alg_gebouw_mld IS NULL
|
|
OR alg_gebouw_mld = 1)
|
|
);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// APGR#70293
|
|
ALTER TABLE bes_disc_params
|
|
ADD (bes_disc_params_deliver_fe NUMBER(1) DEFAULT(0) NOT NULL);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#72152
|
|
ALTER TABLE aut_client_perslid
|
|
ADD (aut_client_perslid_appbuild NUMBER(10),
|
|
aut_client_perslid_appversion VARCHAR2 (20));
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// KMMO#71448
|
|
ALTER TABLE prs_bedrijfdienstlocatie ADD prs_perslid_key
|
|
NUMBER(10) CONSTRAINT prs_r_prs_perslid_key21 REFERENCES prs_perslid(prs_perslid_key) ON DELETE CASCADE;
|
|
|
|
ALTER TABLE prs_bedrijfdienstlocatie DROP CONSTRAINT prs_c_prs_bedrijf_key2;
|
|
ALTER TABLE prs_bedrijfdienstlocatie ADD CONSTRAINT prs_c_prs_bdlbp1 CHECK ((prs_bedrijf_key IS NOT NULL AND prs_perslid_key IS NULL) OR (prs_bedrijf_key IS NULL AND prs_perslid_key IS NOT NULL));
|
|
|
|
ALTER TABLE prs_bedrijfdienstlocatie DROP CONSTRAINT prs_u_prs_bedrijfdienstloc_key DROP INDEX;
|
|
ALTER TABLE prs_bedrijfdienstlocatie ADD CONSTRAINT prs_u_prs_bedrijfdienstloc_key UNIQUE (prs_bedrijf_key, prs_perslid_key, prs_dienst_key, alg_locatie_key, alg_gebouw_key);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FMHN#70720
|
|
|
|
CREATE SEQUENCE fac_s_fac_layout_key MINVALUE 100;
|
|
CREATE TABLE fac_layout
|
|
(
|
|
fac_layout_key NUMBER(10)
|
|
CONSTRAINT fac_k_fac_layout_key PRIMARY KEY,
|
|
fac_layout_version NUMBER(2)
|
|
DEFAULT 1 NOT NULL,
|
|
fac_layout_screen VARCHAR2(128) NOT NULL,
|
|
fac_layout_options VARCHAR2(4000), -- JSON
|
|
fac_layout_aanmaak DATE
|
|
DEFAULT SYSDATE
|
|
);
|
|
|
|
DEF_MENUITEM(2, 'lcl_menu_fac_layout', '', 'FAC', 'appl/mgt/fac_layout.asp', 0, 0, 'WEB_FACTAB', 'W', '1', '');
|
|
MENU_INS_AFTER('lcl_menu_fac_layout', 'lcl_menu_wgt_pages', 2);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#71289
|
|
ALTER TABLE fac_rapport
|
|
ADD (fac_rapport_datum DATE DEFAULT SYSDATE);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#65716
|
|
|
|
CREATE VIEW fac_v_rap_auditusage AS SELECT * FROM DUAL;
|
|
DEF_RAPPORT('WEB_FACMGT', 0, 'fac_v_rap_auditusage', 'BEHEER: Audit gebruik', 'Rapport audit gebruik',
|
|
'ADMIN: Audit usage', 'Report audit usage')
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#69983
|
|
CREATE SEQUENCE fac_s_imp_csv_key MINVALUE 1;
|
|
CREATE_TABLE(fac_imp_csv, 0)
|
|
(
|
|
fac_imp_csv_key NUMBER(10) PRIMARY KEY,
|
|
fac_import_key NUMBER(10) CONSTRAINT fac_r_fac_import_key4 REFERENCES fac_import(fac_import_key) ON DELETE CASCADE,
|
|
fac_imp_csv_index NUMBER(10) NOT NULL,
|
|
fac_imp_csv_datum DATE DEFAULT SYSDATE,
|
|
fac_imp_file_line VARCHAR2(4000 CHAR),
|
|
fac_imp_csv_col01 VARCHAR2(4000),
|
|
fac_imp_csv_col02 VARCHAR2(4000),
|
|
fac_imp_csv_col03 VARCHAR2(4000),
|
|
fac_imp_csv_col04 VARCHAR2(4000),
|
|
fac_imp_csv_col05 VARCHAR2(4000),
|
|
fac_imp_csv_col06 VARCHAR2(4000),
|
|
fac_imp_csv_col07 VARCHAR2(4000),
|
|
fac_imp_csv_col08 VARCHAR2(4000),
|
|
fac_imp_csv_col09 VARCHAR2(4000),
|
|
fac_imp_csv_col10 VARCHAR2(4000),
|
|
fac_imp_csv_col11 VARCHAR2(4000),
|
|
fac_imp_csv_col12 VARCHAR2(4000),
|
|
fac_imp_csv_col13 VARCHAR2(4000),
|
|
fac_imp_csv_col14 VARCHAR2(4000),
|
|
fac_imp_csv_col15 VARCHAR2(4000),
|
|
fac_imp_csv_col16 VARCHAR2(4000),
|
|
fac_imp_csv_col17 VARCHAR2(4000),
|
|
fac_imp_csv_col18 VARCHAR2(4000),
|
|
fac_imp_csv_col19 VARCHAR2(4000),
|
|
fac_imp_csv_col20 VARCHAR2(4000),
|
|
fac_imp_csv_col21 VARCHAR2(4000),
|
|
fac_imp_csv_col22 VARCHAR2(4000),
|
|
fac_imp_csv_col23 VARCHAR2(4000),
|
|
fac_imp_csv_col24 VARCHAR2(4000),
|
|
fac_imp_csv_col25 VARCHAR2(4000),
|
|
fac_imp_csv_col26 VARCHAR2(4000),
|
|
fac_imp_csv_col27 VARCHAR2(4000),
|
|
fac_imp_csv_col28 VARCHAR2(4000),
|
|
fac_imp_csv_col29 VARCHAR2(4000),
|
|
fac_imp_csv_col30 VARCHAR2(4000),
|
|
fac_imp_csv_col31 VARCHAR2(4000),
|
|
fac_imp_csv_col32 VARCHAR2(4000),
|
|
fac_imp_csv_col33 VARCHAR2(4000),
|
|
fac_imp_csv_col34 VARCHAR2(4000),
|
|
fac_imp_csv_col35 VARCHAR2(4000),
|
|
fac_imp_csv_col36 VARCHAR2(4000),
|
|
fac_imp_csv_col37 VARCHAR2(4000),
|
|
fac_imp_csv_col38 VARCHAR2(4000),
|
|
fac_imp_csv_col39 VARCHAR2(4000),
|
|
fac_imp_csv_col40 VARCHAR2(4000),
|
|
fac_imp_csv_col41 VARCHAR2(4000),
|
|
fac_imp_csv_col42 VARCHAR2(4000),
|
|
fac_imp_csv_col43 VARCHAR2(4000),
|
|
fac_imp_csv_col44 VARCHAR2(4000),
|
|
fac_imp_csv_col45 VARCHAR2(4000),
|
|
fac_imp_csv_col46 VARCHAR2(4000),
|
|
fac_imp_csv_col47 VARCHAR2(4000),
|
|
fac_imp_csv_col48 VARCHAR2(4000),
|
|
fac_imp_csv_col49 VARCHAR2(4000),
|
|
fac_imp_csv_col50 VARCHAR2(4000),
|
|
fac_imp_csv_col51 VARCHAR2(4000),
|
|
fac_imp_csv_col52 VARCHAR2(4000),
|
|
fac_imp_csv_col53 VARCHAR2(4000),
|
|
fac_imp_csv_col54 VARCHAR2(4000),
|
|
fac_imp_csv_col55 VARCHAR2(4000),
|
|
fac_imp_csv_col56 VARCHAR2(4000),
|
|
fac_imp_csv_col57 VARCHAR2(4000),
|
|
fac_imp_csv_col58 VARCHAR2(4000),
|
|
fac_imp_csv_col59 VARCHAR2(4000),
|
|
fac_imp_csv_col60 VARCHAR2(4000),
|
|
fac_imp_csv_col61 VARCHAR2(4000),
|
|
fac_imp_csv_col62 VARCHAR2(4000),
|
|
fac_imp_csv_col63 VARCHAR2(4000),
|
|
fac_imp_csv_col64 VARCHAR2(4000),
|
|
fac_imp_csv_col65 VARCHAR2(4000),
|
|
fac_imp_csv_col66 VARCHAR2(4000),
|
|
fac_imp_csv_col67 VARCHAR2(4000),
|
|
fac_imp_csv_col68 VARCHAR2(4000),
|
|
fac_imp_csv_col69 VARCHAR2(4000),
|
|
fac_imp_csv_col70 VARCHAR2(4000),
|
|
fac_imp_csv_col71 VARCHAR2(4000),
|
|
fac_imp_csv_col72 VARCHAR2(4000),
|
|
fac_imp_csv_col73 VARCHAR2(4000),
|
|
fac_imp_csv_col74 VARCHAR2(4000),
|
|
fac_imp_csv_col75 VARCHAR2(4000),
|
|
fac_imp_csv_col76 VARCHAR2(4000),
|
|
fac_imp_csv_col77 VARCHAR2(4000),
|
|
fac_imp_csv_col78 VARCHAR2(4000),
|
|
fac_imp_csv_col79 VARCHAR2(4000),
|
|
fac_imp_csv_col80 VARCHAR2(4000),
|
|
fac_imp_csv_col81 VARCHAR2(4000),
|
|
fac_imp_csv_col82 VARCHAR2(4000),
|
|
fac_imp_csv_col83 VARCHAR2(4000),
|
|
fac_imp_csv_col84 VARCHAR2(4000),
|
|
fac_imp_csv_col85 VARCHAR2(4000),
|
|
fac_imp_csv_col86 VARCHAR2(4000),
|
|
fac_imp_csv_col87 VARCHAR2(4000),
|
|
fac_imp_csv_col88 VARCHAR2(4000),
|
|
fac_imp_csv_col89 VARCHAR2(4000),
|
|
fac_imp_csv_col90 VARCHAR2(4000),
|
|
fac_imp_csv_col91 VARCHAR2(4000),
|
|
fac_imp_csv_col92 VARCHAR2(4000),
|
|
fac_imp_csv_col93 VARCHAR2(4000),
|
|
fac_imp_csv_col94 VARCHAR2(4000),
|
|
fac_imp_csv_col95 VARCHAR2(4000),
|
|
fac_imp_csv_col96 VARCHAR2(4000),
|
|
fac_imp_csv_col97 VARCHAR2(4000),
|
|
fac_imp_csv_col98 VARCHAR2(4000),
|
|
fac_imp_csv_col99 VARCHAR2(4000)
|
|
);
|
|
CREATE INDEX fac_i_fac_imp_csv1 ON fac_imp_csv(fac_import_key);
|
|
|
|
DEF_IMPORT('WEB_FACFAC', 'GENERICCSV', 'FIP: Generieke CSV import', 'FIP: Generic CSV import')
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#71204
|
|
UPDATE fac_setting
|
|
SET fac_setting_pvalue =
|
|
REGEXP_REPLACE (fac_setting_pvalue, 'fa-sync', 'fa-fclt-refresh')
|
|
WHERE fac_setting_name = 'buttons_in_hamburger'
|
|
AND fac_setting_pvalue IS NOT NULL;
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// MNNL#71719
|
|
UPDATE fac_functie
|
|
SET fac_functie_groep = 1
|
|
WHERE fac_functie_code = 'WEB_WGTMAN';
|
|
|
|
ALTER TABLE fac_widget_page
|
|
ADD fac_groep_key NUMBER (10)
|
|
CONSTRAINT fac_r_widget_page_groep_key
|
|
REFERENCES fac_groep (fac_groep_key);
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#72515
|
|
ALTER TABLE fac_usrrap_cols DROP CONSTRAINT fac_c_usrrap_cols_visible;
|
|
ALTER TABLE fac_usrrap_cols ADD CONSTRAINT fac_c_usrrap_cols_visible CHECK (fac_usrrap_cols_visible IN ('V', 'C', 'I', 'H', 'S', 'U'));
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#72573
|
|
//DEF_MENUITEM(2, 'lcl_menu_res_reserveerbare_obj', '', 'RES', 'appl/mgt/res_deel.asp?ins_min_level=1', 0, 0, 'WEB_RESMSU', 'W', '1', '');
|
|
DEF_MENUITEM(2, 'lcl_menu_res_reserveerbare_prs', '', 'RES', 'appl/mgt/res_deel.asp?ins_min_level=4', 0, 0, 'WEB_RESMSU', 'W', '1', '');
|
|
DEF_MENUITEM(2, 'lcl_menu_res_reserveerbare_wp' , '', 'RES', 'appl/mgt/res_deel.asp?ins_min_level=5', 0, 0, 'WEB_RESMSU', 'W', '1', '');
|
|
MENU_INS_AFTER('lcl_menu_res_reserveerbare_prs', 'lcl_menu_res_reserveerbare_obj', 2);
|
|
MENU_INS_AFTER('lcl_menu_res_reserveerbare_wp', 'lcl_menu_res_reserveerbare_prs', 2);
|
|
|
|
UPDATE fac_menuitems SET fac_menuitems_url = 'appl/mgt/res_deel.asp?ins_min_level=1'
|
|
WHERE fac_menuitems_label = 'lcl_menu_res_reserveerbare_obj'
|
|
AND fac_menuitems_url = 'appl/mgt/res_deel.asp';
|
|
UPDATE fac_menu SET fac_menu_alturl = 'appl/mgt/res_deel.asp?ins_min_level=1'
|
|
WHERE fac_menu_alturl = 'appl/mgt/res_deel.asp';
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////////////// FCLT#00000
|
|
|
|
REGISTERONCE('$Id$')
|
|
|
|
#include "epilogue.inc"
|