
UPDATE am_assertions_applies_to set linked_entity_permalink=replace(linked_entity_permalink,'https://ehealthsuisse.ihe-europe.net/','https://cts-acceptance.ihe-europe.net/');
UPDATE am_assertions_links set linked_entity_permalink=replace(linked_entity_permalink,'https://ehealthsuisse.ihe-europe.net/','https://cts-acceptance.ihe-europe.net/');
update am_oasis_ref_source_item set uri=replace(uri,'https://ehealthsuisse.ihe-europe.net/','https://cts-acceptance.ihe-europe.net/')  where uri like 'https://ehealthsuisse.ihe-europe.net/%';
UPDATE am_mbv_service set url=replace(url,'https://ehealthsuisse.ihe-europe.net/','https://cts-acceptance.ihe-europe.net/');





-- select url_doc from tm_test_roles where url_doc is not null and url_doc != '';
update tm_test_roles set url_doc = 'https://cts-acceptance.ihe-europe.net/gazelle-documentation' where url_doc is not null and url_doc != '';

-- update URL which are set in test description
update tm_test_description set description = replace(description, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update tm_test_description_aud set description = replace(description, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');




update evsc_calling_tool set url = replace(url, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update evsc_validation_service set xsl_location = replace(xsl_location, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');







-- \c schematron-validator-prod
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

-- \c authentication-simulator
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
-- update app_configuration set value = replace(value, 'ehealthsuisse.ihe-europe.net', 'cts-acceptance.ihe-europe.net') where variable = 'idp_adapter_wsdl_endpoint';

