366 lines
20 KiB
Plaintext
366 lines
20 KiB
Plaintext
/* DB24TO25.SRC
|
||
* Update script van FACILITOR schema
|
||
* $Revision$
|
||
* $Id$
|
||
*/
|
||
#include "prologue.inc"
|
||
|
||
COMMIT;
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#31594
|
||
ALTER TABLE cad_thema ADD cad_thema_onclick_url VARCHAR2(512);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// PNBR#31470
|
||
ALTER TABLE ins_disc_params ADD ins_disc_params_autonum NUMBER(2) DEFAULT 3;
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// STPH#31353
|
||
ALTER TABLE bes_srtgroep ADD prs_kostensoort_key NUMBER(10)
|
||
CONSTRAINT bes_r_prs_kostensoort_key1 REFERENCES prs_kostensoort(prs_kostensoort_key);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// PCHD#29741
|
||
ALTER TABLE fin_factuur ADD prs_perslid_key_goedkeur NUMBER(10)
|
||
CONSTRAINT fin_r_fin_factuur6 REFERENCES prs_perslid(prs_perslid_key);
|
||
ALTER TABLE fin_factuur DROP CONSTRAINT fin_c_fin_status1;
|
||
ALTER TABLE fin_factuur MODIFY fin_factuur_statuses_key CONSTRAINT fin_c_fin_status1 CHECK(fin_factuur_statuses_key IN (1,2,3,5,6,7));
|
||
|
||
DEF_FAC_FUNCTIE2('WEB_FINGOE', 'Backoffice:Facturen-goedkeuren', 'FIN', 0, 0, 1, 'Om facturen te kunnen goedkeuren');
|
||
|
||
DEF_FAC_SRTNOT('FINGOE', 0, 'Factuur is ter goedkeuring aangeboden', 'fin/fin_factuur.asp?fin_key=', '0', 'factuur', 10);
|
||
DEF_FAC_SRTNOT('FINGNO', 0, 'Factuur afgekeurd', 'fin/fin_factuur.asp?fin_key=', '0', 'factuur', 10);
|
||
DEF_FAC_SRTNOT('FINGUN', 0, 'Factuurfiattering geannuleerd', 'fin/fin_factuur.asp?fin_key=', '0', 'factuur', 10);
|
||
DEF_FAC_SRTNOT('FIN2GO', 3, 'Uw goedkeuring is vereist voor factuur ##KEY##', 'fin/fin_factuur.asp?fin_key=', '0', 'factuur', 10);
|
||
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// LOGI#31433
|
||
ALTER TABLE res_ruimte ADD res_status_fo_key NUMBER(2)
|
||
CONSTRAINT res_c_res_status_fo2 CHECK(res_status_fo_key IN (1,2,3,4));
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#31615
|
||
ALTER TABLE alg_srtruimte MODIFY alg_srtruimte_t_uitvoertijd DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE ins_deel MODIFY ins_deel_t_uitvoertijd DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE mld_stdmelding MODIFY mld_stdmelding_t_accepttijd DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE mld_stdmelding MODIFY mld_stdmelding_t_uitvoertijd DEFAULT MLD_T_UITVOERTIJD(2, 1);
|
||
ALTER TABLE mld_stdmelding MODIFY mld_stdmelding_t_uitvtijd_pr1 DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE mld_stdmelding MODIFY mld_stdmelding_t_uitvtijd_pr2 DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE mld_stdmelding MODIFY mld_stdmelding_t_uitvtijd_pr4 DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE mld_melding MODIFY mld_melding_t_uitvoertijd DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE mld_melding MODIFY mld_melding_t_accepttijd DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE mld_melding MODIFY mld_melding_t_respijt DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
ALTER TABLE prs_bedrijf MODIFY prs_bedrijf_t_uitvoertijd DEFAULT MLD_T_UITVOERTIJD(NULL, NULL);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// PNBR#28834
|
||
ALTER TABLE bes_srtdeel ADD bes_srtdeel_maxbestel NUMBER(1) DEFAULT 0 NOT NULL;
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// RWSN#31113
|
||
ALTER TABLE mld_disc_params ADD mld_disc_params_benotify NUMBER(1) DEFAULT 0 NOT NULL;
|
||
|
||
-- Voor de klanten die de MLDBE2 notificatie aan hebben staan, de waarde van het veld mld_disc_params_benotify voor alle vakgroepen op 1 zetten.
|
||
UPDATE mld_disc_params
|
||
SET mld_disc_params_benotify = 1
|
||
WHERE EXISTS (SELECT sn.fac_srtnotificatie_mode
|
||
FROM fac_srtnotificatie sn
|
||
WHERE sn.fac_srtnotificatie_code = 'MLDBE2'
|
||
AND sn.fac_srtnotificatie_mode > 0);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// MNNL#31770
|
||
ALTER TABLE prs_afdeling MODIFY prs_afdeling_naam VARCHAR2(15);
|
||
ALTER TABLE prs_afdeling MODIFY prs_afdeling_upper VARCHAR2(15);
|
||
ALTER TABLE fac_imp_organisatie MODIFY prs_afdeling_naam VARCHAR2(15);
|
||
ALTER TABLE fac_imp_organisatie MODIFY prs_afdeling_naam_parent VARCHAR2(15);
|
||
ALTER TABLE fac_imp_perslid MODIFY prs_afdeling_naam VARCHAR2(15);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#31542
|
||
ALTER TABLE fac_imp_perslid MODIFY prs_perslid_email VARCHAR2(200);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#32005
|
||
ALTER TABLE fac_imp_inspectie MODIFY ins_srtcontrole_periode VARCHAR2(7);
|
||
ALTER TABLE fac_imp_inspectie ADD ins_srtcontrole_mode VARCHAR2(1);
|
||
ALTER TABLE fac_imp_inspectie ADD ins_srtcontrole_eenheid VARCHAR2(1);
|
||
ALTER TABLE fac_imp_inspectie ADD ins_srtcontrole_bits VARCHAR2(4);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#31698
|
||
CREATE SEQUENCE fac_s_fac_usrrap_cols_key MINVALUE 1;
|
||
|
||
// De kolommen van een rapport
|
||
CREATE_TABLE(fac_usrrap_cols, 0)
|
||
(
|
||
fac_usrrap_cols_key
|
||
NUMBER(10)
|
||
CONSTRAINT fac_k_fac_usrrap_cols_key PRIMARY KEY,
|
||
fac_usrrap_key
|
||
NUMBER(10)
|
||
CONSTRAINT fac_r_usrrap_cols_usrrap_key REFERENCES fac_usrrap(fac_usrrap_key)
|
||
ON DELETE CASCADE,
|
||
fac_usrrap_cols_volgnr
|
||
NUMBER(10),
|
||
fac_usrrap_cols_column_name
|
||
VARCHAR2(32)
|
||
NOT_NULL(fac_usrrap_cols_column_name, fac_c_usrrap_cols_column_name),
|
||
fac_usrrap_cols_caption
|
||
VARCHAR2(60),
|
||
fac_usrrap_cols_filter /* See FAC/fac_usrrap.inc */
|
||
VARCHAR2(3),
|
||
fac_usrrap_cols_filterdefault /* Predefined filterval */
|
||
VARCHAR2(60),
|
||
fac_usrrap_cols_datatype
|
||
VARCHAR2(16)
|
||
NOT NULL,
|
||
fac_usrrap_cols_visible
|
||
VARCHAR2(1)
|
||
DEFAULT 'V'
|
||
NOT NULL
|
||
CONSTRAINT fac_c_usrrap_cols_visible CHECK (fac_usrrap_cols_visible IN ('V', 'I', 'H')),
|
||
fac_usrrap_cols_group
|
||
VARCHAR2(1)
|
||
DEFAULT 'G'
|
||
NOT NULL
|
||
CONSTRAINT fac_c_usrrap_cols_group CHECK (fac_usrrap_cols_group IN ('G', 'S', 'C', 'A', 'H', 'D', 'W', 'M', 'Q', 'Y'))
|
||
);
|
||
|
||
ALTER TABLE fac_usrrap ADD fac_usrrap_urllink VARCHAR2(100) DEFAULT NULL;
|
||
ALTER TABLE fac_usrrap ADD fac_usrrap_groep VARCHAR2(40) DEFAULT NULL;
|
||
ALTER TABLE fac_usrrap MODIFY fac_usrrap_functie NUMBER(3);
|
||
UPDATE fac_menuitems SET fac_menuitems_url = 'appl/fac/fac_reportx_show.asp?mode=list' WHERE fac_menuitems_url = 'appl/fac/fac_usrrap.asp';
|
||
UPDATE fac_menuitems SET fac_menuitems_url = 'appl/fac/fac_reportx.asp' WHERE fac_menuitems_url = 'appl/facmgtVB/fac_userrapgrid.asp';
|
||
|
||
PROMPT oude rapport menu opties:
|
||
SELECT fac_menu_key, fac_menu_altlabel, fac_menu_alturl FROM fac_menu
|
||
WHERE fac_menu_alturl LIKE '%fac_usrrap.asp?%';
|
||
|
||
|
||
--appl/fac/fac_usrrap.asp?rap_name=uwva_v_rap_afd_contact >> appl/fac/fac_report.asp?rap_name=uwva_v_rap_afd_contact
|
||
UPDATE fac_menu m
|
||
SET fac_menu_alturl =
|
||
REPLACE (fac_menu_alturl,
|
||
'fac_usrrap.asp?',
|
||
'fac_report.asp?')
|
||
WHERE fac_menu_alturl LIKE '%fac_usrrap.asp?%'
|
||
AND fac_menu_alturl LIKE '%rap_name=%';
|
||
|
||
-- appl/fac/fac_usrrap.asp?rap_name=pnbr_v_rap_open_cmdb_status&autoexec=1 >> appl/fac/fac_report.asp?mode=list&rap_name=pnbr_v_rap_open_cmdb_status
|
||
-- Autoexec omzetten naar rechtstreeks mode=list
|
||
UPDATE fac_menu m
|
||
SET fac_menu_alturl =
|
||
REPLACE (
|
||
REPLACE (fac_menu_alturl,
|
||
'fac_report.asp?',
|
||
'fac_report.asp?mode=list&'),
|
||
'&autoexec=1',
|
||
'')
|
||
WHERE fac_menu_alturl LIKE '%fac_report.asp?%'
|
||
AND fac_menu_alturl LIKE '%autoexec=1%';
|
||
|
||
--appl/fac/fac_usrrap.asp?fcode=WEB_USER01 >> appl/fac/fac_reportx_show.asp?mode=list?fcode=WEB_USER01
|
||
-- LET OP: bij VIAR handmatig fcode=XXXX vervangen door authorisation=76 voor PRSSYS bijvoorbeeld!
|
||
UPDATE fac_menu m
|
||
SET fac_menu_alturl =
|
||
REPLACE (fac_menu_alturl,
|
||
'fac_usrrap.asp?',
|
||
'fac_reportx_show.asp?mode=list&')
|
||
WHERE fac_menu_alturl LIKE '%fac_usrrap.asp?%'
|
||
AND fac_menu_alturl LIKE '%fcode=%';
|
||
|
||
-- Bij widgets is het altijd autoexec
|
||
-- appl/fac/fac_usrrap.asp?rap_name=skaf_v_rap_mld_status&autoexec=1
|
||
-- naar appl/fac/fac_report.asp?mode=list&rap_name=skaf_v_rap_mld_status
|
||
UPDATE fac_widget m
|
||
SET fac_widget_url =
|
||
REPLACE (
|
||
REPLACE (fac_widget_url,
|
||
'fac_usrrap.asp?',
|
||
'fac_report.asp?mode=list&'),
|
||
'&autoexec=1',
|
||
'')
|
||
WHERE fac_widget_url LIKE '%fac_usrrap.asp?%';
|
||
|
||
/* ROOT reports for User defined Reports (UDR) cloning */
|
||
CREATE VIEW bes_v_udr_bestelling AS SELECT 1 a FROM DUAL;
|
||
CREATE VIEW bez_v_udr_bezoeker AS SELECT 1 a FROM DUAL;
|
||
CREATE VIEW cnt_v_udr_contract AS SELECT 1 a FROM DUAL;
|
||
CREATE VIEW fin_v_udr_factuur AS SELECT 1 a FROM DUAL;
|
||
CREATE VIEW ins_v_udr_deel AS SELECT 1 a FROM DUAL;
|
||
CREATE VIEW mld_v_udr_melding AS SELECT 1 a FROM DUAL;
|
||
CREATE VIEW res_v_udr_reservering AS SELECT 1 a FROM DUAL;
|
||
INSERT INTO fac_usrrap (fac_usrrap_omschrijving, fac_usrrap_view_name,fac_usrrap_info, fac_functie_key)
|
||
SELECT 'UDR: Bestellingen','BES_V_UDR_BESTELLING','Basisrapport voor bestellingsrapportages', fac_functie_key
|
||
FROM fac_functie WHERE fac_functie_code='WEB_PRSSYS'
|
||
AND NOT EXISTS (SELECT '' FROM fac_usrrap WHERE UPPER(fac_usrrap_view_name)='BES_V_UDR_BESTELLING');
|
||
INSERT INTO fac_usrrap (fac_usrrap_omschrijving, fac_usrrap_view_name,fac_usrrap_info, fac_functie_key)
|
||
SELECT 'UDR: Bezoekers','BEZ_V_UDR_BEZOEKER','Basisrapport voor bezoekersrapportages', fac_functie_key
|
||
FROM fac_functie WHERE fac_functie_code='WEB_PRSSYS'
|
||
AND NOT EXISTS (SELECT '' FROM fac_usrrap WHERE UPPER(fac_usrrap_view_name)='BEZ_V_UDR_BEZOEKER');
|
||
INSERT INTO fac_usrrap (fac_usrrap_omschrijving, fac_usrrap_view_name,fac_usrrap_info, fac_functie_key)
|
||
SELECT 'UDR: Contracten','CNT_V_UDR_CONTRACT','Basisrapport voor contractrapportages', fac_functie_key
|
||
FROM fac_functie WHERE fac_functie_code='WEB_PRSSYS'
|
||
AND NOT EXISTS (SELECT '' FROM fac_usrrap WHERE UPPER(fac_usrrap_view_name)='CNT_V_UDR_CONTRACT');
|
||
INSERT INTO fac_usrrap (fac_usrrap_omschrijving, fac_usrrap_view_name,fac_usrrap_info, fac_functie_key)
|
||
SELECT 'UDR: Facturen','FIN_V_UDR_FACTUUR','Basisrapport voor factuurrapportages', fac_functie_key
|
||
FROM fac_functie WHERE fac_functie_code='WEB_PRSSYS'
|
||
AND NOT EXISTS (SELECT '' FROM fac_usrrap WHERE UPPER(fac_usrrap_view_name)='FIN_V_UDR_FACTUUR');
|
||
INSERT INTO fac_usrrap (fac_usrrap_omschrijving, fac_usrrap_view_name,fac_usrrap_info, fac_functie_key)
|
||
SELECT 'UDR: Objecten','INS_V_UDR_DEEL','Basisrapport voor objectrapportages', fac_functie_key
|
||
FROM fac_functie WHERE fac_functie_code='WEB_PRSSYS'
|
||
AND NOT EXISTS (SELECT '' FROM fac_usrrap WHERE UPPER(fac_usrrap_view_name)='INS_V_UDR_DEEL');
|
||
INSERT INTO fac_usrrap (fac_usrrap_omschrijving, fac_usrrap_view_name,fac_usrrap_info, fac_functie_key)
|
||
SELECT 'UDR: Meldingen/opdrachten','MLD_V_UDR_MELDING','Basisrapport voor meldingsrapportages', fac_functie_key
|
||
FROM fac_functie WHERE fac_functie_code='WEB_PRSSYS'
|
||
AND NOT EXISTS (SELECT '' FROM fac_usrrap WHERE UPPER(fac_usrrap_view_name)='MLD_V_UDR_MELDING');
|
||
INSERT INTO fac_usrrap (fac_usrrap_omschrijving, fac_usrrap_view_name,fac_usrrap_info, fac_functie_key)
|
||
SELECT 'UDR: Reserveringen','RES_V_UDR_RESERVERING','Basisrapport voor reserveringsrapportages', fac_functie_key
|
||
FROM fac_functie WHERE fac_functie_code='WEB_PRSSYS'
|
||
AND NOT EXISTS (SELECT '' FROM fac_usrrap WHERE UPPER(fac_usrrap_view_name)='RES_V_UDR_RESERVERING');
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// UWVA#31750
|
||
ALTER TABLE res_deel ADD res_deel_beschikbaar_bits NUMBER(4) DEFAULT 127 NOT NULL;
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// AAIT#29957
|
||
CREATE_TABLE(fac_gui_counter, 0)
|
||
(
|
||
fac_gui_counter_key NUMBER (10) PRIMARY KEY,
|
||
fac_gui_counter_group VARCHAR2 (12),
|
||
fac_gui_counter_refkey NUMBER (10),
|
||
fac_gui_counter_count NUMBER (12),
|
||
fac_gui_counter_info VARCHAR2 (1000),
|
||
fac_gui_counter_date DATE DEFAULT SYSDATE,
|
||
prs_perslid_key NUMBER (10) CONSTRAINT fac_r_guicnt_perslid_key REFERENCES prs_perslid(prs_perslid_key) ON DELETE SET NULL,
|
||
CONSTRAINT fac_u_fac_gui_counter UNIQUE(fac_gui_counter_group, fac_gui_counter_date, fac_gui_counter_refkey, fac_gui_counter_info)
|
||
);
|
||
|
||
CREATE SEQUENCE faq_s_fac_gui_counter_key MINVALUE 1;
|
||
-- trigger follows with recreate
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// ARBO#31920
|
||
ALTER TABLE res_disc_params ADD res_disc_params_maxduur NUMBER(5,2) DEFAULT 0 NOT NULL;
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#31969
|
||
ALTER TABLE ins_srtcontroledl_xcp ADD ins_srtcontroledl_xcp_kosten NUMBER(11,2);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#31968
|
||
ALTER TABLE ins_srtcontrole ADD ins_srtcontrole_type NUMBER(1) DEFAULT (1);
|
||
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// UWVA#31346
|
||
ALTER TABLE mld_afmeldtekst ADD mld_ins_discipline_key NUMBER(10)
|
||
CONSTRAINT mld_r_ins_discipline_key2 REFERENCES ins_tab_discipline(ins_discipline_key);
|
||
|
||
UPDATE fac_menuitems
|
||
SET fac_menuitems_url = 'appl/mgt/mld_afmeldtekst.asp'
|
||
WHERE fac_menuitems_url = 'appl/facmgtVB/mld_afmeldtekstgrid.asp';
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#31783
|
||
ALTER TABLE bes_disc_params ADD bes_disc_params_freeartikel NUMBER(1) DEFAULT 0 NOT NULL;
|
||
|
||
UPDATE bes_disc_params
|
||
SET bes_disc_params_freeartikel = 1,
|
||
bes_disc_params_punchouturl = NULL
|
||
WHERE bes_disc_params_punchouturl = 'FREE';
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// AKZA#31850
|
||
DEF_FAC_FUNCTIE2('WEB_RELUSE', 'Backoffice:Relatiebeheer', 'PRS', 11, 0, 1, 'Om de gegevens van relaties/contactpersonen te kunnen muteren');
|
||
DEF_MENUITEM(1, 'lcl_menu_prs_contactpers' , '', 'PRS', 'appl/prs/prs_contactpersoon_search.asp', 0, 0, 'WEB_RELUSE', 'R', '1', '');
|
||
|
||
ALTER PACKAGE fac COMPILE; // anders (nog) invalid en lukt insert niet
|
||
ALTER PACKAGE fac COMPILE BODY;
|
||
|
||
-- De rechten voor WEB_RELUSE kopi<70>ren van WEB_RELMAN.
|
||
INSERT INTO fac_groeprechten (fac_functie_key,
|
||
fac_groep_key,
|
||
ins_discipline_key,
|
||
fac_gebruiker_alg_level_read,
|
||
fac_gebruiker_alg_level_write,
|
||
fac_gebruiker_prs_level_read,
|
||
fac_gebruiker_prs_level_write)
|
||
SELECT (SELECT ff2.fac_functie_key FROM fac_functie ff2 WHERE ff2.fac_functie_code LIKE 'WEB_RELUSE') fac_functie_key,
|
||
fgr.fac_groep_key,
|
||
fgr.ins_discipline_key,
|
||
fgr.fac_gebruiker_alg_level_read,
|
||
fgr.fac_gebruiker_alg_level_write,
|
||
fgr.fac_gebruiker_prs_level_read,
|
||
fgr.fac_gebruiker_prs_level_write
|
||
FROM fac_functie ff,
|
||
fac_groep fg,
|
||
fac_groeprechten fgr
|
||
WHERE ff.fac_functie_key = fgr.fac_functie_key
|
||
AND fg.fac_groep_key = fgr.fac_groep_key
|
||
AND ff.fac_functie_code = 'WEB_RELMAN';
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#32092
|
||
// Loze prefix ../.. bij onthouden tabs verwijderen
|
||
UPDATE prs_perslid
|
||
SET prs_perslid_options =
|
||
REPLACE (prs_perslid_options, '"u":"../../', '"u":"')
|
||
WHERE prs_perslid_options LIKE '%"u":"../../%';
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// STPH#31881
|
||
ALTER TABLE bes_srtdeel ADD bes_srtdeel_voorraadfactor NUMBER(6) DEFAULT 1;
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// UWVA#31430
|
||
CREATE TABLE fac_sequence
|
||
(
|
||
fac_sequence_name VARCHAR2(50)
|
||
CONSTRAINT fac_k_fac_sequence_name PRIMARY KEY,
|
||
fac_sequence_lastval NUMBER(10),
|
||
fac_sequence_expire DATE
|
||
);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// UWVA#26373
|
||
DELETE FROM fac_bookmark
|
||
WHERE fac_bookmark_expire < SYSDATE;
|
||
ALTER TABLE fac_bookmark ADD fac_bookmark_flags
|
||
NUMBER(3) DEFAULT 1 NOT NULL;
|
||
UPDATE fac_bookmark
|
||
SET fac_bookmark_flags = fac_bookmark_flags + 4 -- PRSSYS mag bewerken
|
||
WHERE prs_perslid_key IS NOT NULL;
|
||
UPDATE fac_bookmark
|
||
SET fac_bookmark_flags = fac_bookmark_flags + 2 -- Gewone gebruikers mogen zien
|
||
WHERE fac_bookmark_path LIKE '/appl/prs/prs_phonebook_list.asp';
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#32140
|
||
ALTER TABLE res_ruimte ADD res_ruimte_friendlyname VARCHAR2(40);
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// UWVA#31346
|
||
CREATE_TABLE(fac_imp_mldafmtxt, 0)
|
||
(
|
||
mld_afmeldtekst_naam VARCHAR2(60)
|
||
, mld_afmeldtekst_omschrijving VARCHAR2(1000)
|
||
, ins_discipline_key NUMBER(10)
|
||
, mld_stdmelding_key NUMBER(10)
|
||
);
|
||
|
||
INSERT INTO fac_import_app
|
||
(fac_import_app_code, fac_import_app_oms, fac_functie_key)
|
||
SELECT 'MLDAFMTXT', 'FIP: Afmeldteksten', fac_functie_key
|
||
FROM fac_functie
|
||
WHERE fac_functie_code = 'WEB_PRSSYS';
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// FSN#32160
|
||
DEF_MENUITEM(3, 'lcl_mobile_messages' , '', 'FAC', 'appl/pda/message_list.asp', 0, 0, 'WEB_MLDUSE', 'R', '0', 'm_overzichten-persoonlijk-mijn-berichten.png');
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// AAIT#30469
|
||
DEF_MENUITEM(3, 'lcl_mobile_rapporten' , '', 'FAC', 'appl/pda/reports.asp', 0, 0, 'WEB_USRRAP', 'R', '0', 'm_overzichten-algemeen-rapporten.png');
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// UWVA#30627
|
||
DELETE FROM fac_menuitems WHERE fac_menuitems_label='lcl_menu_res_ruimte_opstelling';
|
||
|
||
|
||
/////////////////////////////////////////////////////////////////////////////////////////// GENERAL
|
||
BEGIN
|
||
adm.tryalter('TABLE alg_kenmerk MODIFY alg_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE bes_kenmerk MODIFY bes_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE bez_kenmerk MODIFY bez_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE cnt_kenmerk MODIFY cnt_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE faq_kenmerk MODIFY faq_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE fin_kenmerk MODIFY fin_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE ins_kenmerk MODIFY ins_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE mld_kenmerk MODIFY mld_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE prs_kenmerk MODIFY prs_kenmerk_groep DEFAULT 0');
|
||
adm.tryalter('TABLE res_kenmerk MODIFY res_kenmerk_groep DEFAULT 0');
|
||
END;
|
||
/
|
||
/////////////////////////////////////////////////////////////////////////////////////////// CLEANUP
|
||
-- Cleanup from DB24
|
||
|
||
///////////////////////////////////////////////////////////////////////////////////////////
|
||
REGISTERONCE('$Id$')
|
||
#include "epilogue.inc"
|