36 lines
925 B
SQL
36 lines
925 B
SQL
-- Customer specific once-script.
|
|
--
|
|
-- (c) 2014 Facilitor bv
|
|
SET ECHO ON
|
|
SPOOL xuwva#30497b.lst
|
|
SET DEFINE OFF
|
|
|
|
--UWVA#30497: Mailontvangst via API
|
|
-- Voeg een gebruiker toe om de api uit te voeren
|
|
INSERT INTO prs_perslid (prs_perslid_module,
|
|
prs_srtperslid_key,
|
|
prs_afdeling_key,
|
|
prs_perslid_naam,
|
|
prs_perslid_oslogin,
|
|
prs_perslid_apikey,
|
|
prs_perslid_flags,
|
|
prs_perslid_systeemadres)
|
|
SELECT 'PRS',
|
|
1436, -- #N/A
|
|
prs_afdeling_key,
|
|
'hMail API user',
|
|
'_HMAIL',
|
|
'tblhgmkARcrEwkvNXkTWuSJnxKFivrzD',
|
|
4,
|
|
NULL
|
|
FROM prs_afdeling
|
|
WHERE prs_afdeling_naam = 'Onbekend';
|
|
|
|
COMMIT;
|
|
|
|
BEGIN adm.systrackscriptId('$Id$'); END;
|
|
/
|
|
|
|
SPOOL OFF;
|
|
|
|
COMMIT; |