dnet45/modules/dnet-openaire-datasource-manager/branches/eosc_services/src/main/resources/eu/dnetlib/enabling/datasources/queries/deleteDatasource.sql @ 62012
1 |
BEGIN; |
---|---|
2 |
UPDATE dsm_services SET merged_in = NULL WHERE merged_in = :dsId; |
3 |
DELETE FROM dsm_apiparams USING dsm_api WHERE api = dsm_api.id AND api.service = :dsId; |
4 |
DELETE FROM api WHERE service = :dsId; |
5 |
DELETE FROM dsm_service_organization WHERE service = :dsId; |
6 |
DELETE FROM dsm_servicepids WHERE service = :dsId; |
7 |
DELETE FROM dsm_services WHERE id = :dsId; |
8 |
COMMIT; |