/* ********************************************************************** */
/*                            UPDATE db_update_2.02.10_001.sql                   */
/* ---------------------------------------------------------------------- */


/* Update the webservice url names in database. As the eSanté platform does not yet provide ATNA logging, no ATNA server is configured by default (which results in only local logging)*/
DELETE FROM esante.property WHERE name LIKE 'WSDL_%';
INSERT INTO esante.property
(name, value)
VALUES
('WSDL_DSP-10:User Authentication LP', 		E'https://www-integration.esante.lu/dsp-habilitation/UserSAMLService'),
('WSDL_DSP-10:User Authentication X509', 	E'https://www-integration.esante.lu/dsp-habilitation/X509UserSAMLService'),
('WSDL_DSP-11-12:DSP Access', 				E'https://www-integration.esante.lu/dsp-habilitation/AssertionSAMLService'),
('WSDL_ITI-18:Stored Query:sq.b', 			E'https://www-integration.esante.lu/dsp-xdsreg'),
('WSDL_ITI-21:Patient Demographics Query', 	E'https://www-integration.esante.lu/dsp-habilitation/dspAdministrativeService'),
('WSDL_DSP-22:Check Access Rights EHR', 	E'https://www-integration.esante.lu/dsp-habilitation/CheckAccessRightsEhr'),
('WSDL_ITI-41:Provide and Register.b:pr.b', E'https://www-integration.esante.lu/dsp-xdsrep'),
('WSDL_ITI-43:Retrieve.b:ret.b', 			E'https://www-integration.esante.lu/dsp-xdsrep'),
('WSDL_ATNA_SERVER', '');

/**** UPDATE THE SCRIPTNAME BELOW TO THE FILENAME OF THIS FILE !!!!!!!! *****/
-- INSERT INTO core.info (date, key, value) VALUES ('now', 'LAST_UPDATE', 'db_update_2.02.10_001.sql');