dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/deleteDatasource.sql @ 62109
| 1 | 26600 | sandro.lab | BEGIN; |
|---|---|---|---|
| 2 | 62109 | michele.ar | DELETE FROM dsm_apiparams USING dsm_api WHERE api = dsm_api.id AND api.service = :dsId; |
| 3 | DELETE FROM api WHERE service = :dsId; |
||
| 4 | DELETE FROM dsm_service_organization WHERE service = :dsId; |
||
| 5 | DELETE FROM dsm_servicepids WHERE service = :dsId; |
||
| 6 | DELETE FROM dsm_services WHERE id = :dsId; |
||
| 7 | 26600 | sandro.lab | COMMIT; |