dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/deleteDatasource.sql @ 51943
| 1 |
BEGIN; |
|---|---|
| 2 |
DELETE FROM dsm_apiparams USING dsm_api WHERE api=dsm_api.id AND api.datasource= :dsId; |
| 3 |
DELETE FROM api WHERE datasource = :dsId; |
| 4 |
DELETE FROM dsm_datasource_organization WHERE datasource = :dsId; |
| 5 |
DELETE FROM dsm_datasourcepids WHERE datasource = :dsId; |
| 6 |
DELETE FROM datasources WHERE id = :dsId; |
| 7 |
COMMIT; |