39 lines
1.1 KiB
SQL
39 lines
1.1 KiB
SQL
-- Customer specific once-script UWVA80.
|
|
--
|
|
-- (c) 2013 SG|facilitor bv
|
|
-- $Revision$
|
|
-- $Id$
|
|
--
|
|
-- Support: +31 53 4800700
|
|
SET ECHO ON
|
|
SPOOL xuwva80.lst
|
|
SET DEFINE OFF
|
|
|
|
-- FSN#26211: Per 5.3.1 CNT-importfunctie standaard FIP dus onderstaande kan weg!
|
|
DELETE FROM fac_import WHERE fac_import_app_key = 624;
|
|
DELETE FROM fac_import_app WHERE fac_import_app_key = 624;
|
|
DROP PROCEDURE uwva_import_cnt;
|
|
DROP PROCEDURE uwva_update_cnt;
|
|
DROP TABLE uwva_imp_cnt;
|
|
|
|
-- FSN#25678: Per UWVA80 SCH-foto notificatie (key=157) en job (key=81) vervallen!
|
|
DELETE FROM fac_notificatie_job WHERE fac_notificatie_job_key = 81;
|
|
--UPDATE fac_srtnotificatie SET fac_srtnotificatie_oms = 'VERVALLEN:' || fac_srtnotificatie_oms WHERE fac_srtnotificatie_key = 157;
|
|
DELETE FROM fac_srtnotificatie WHERE fac_srtnotificatie_key = 157;
|
|
DROP VIEW uwva_v_noti_sch_foto;
|
|
|
|
COMMIT;
|
|
|
|
BEGIN adm.systrackscript('$Workfile: uwva80.sql $', '$Revision$', 1); END;
|
|
/
|
|
SPOOL OFF
|
|
|
|
@@uwva_prs.sql
|
|
@@uwva_fin.sql
|
|
@@uwva_hv.sql
|
|
@@uwva_misc.sql
|
|
|
|
BEGIN fac.registercustversion('UWVA', 80); END;
|
|
/
|
|
COMMIT;
|