dnet40/modules/dnet-openaireplus-datasource-manager-service/trunk/src/main/resources/eu/dnetlib/enabling/datasources/deleteDatasource.sql.st @ 33829
| 1 |
BEGIN; |
|---|---|
| 2 |
DELETE FROM apicollections USING api WHERE api=api.id AND api.datasource=$dsId$; |
| 3 |
DELETE FROM api WHERE datasource=$dsId$; |
| 4 |
DELETE FROM datasources WHERE id=$dsId$; |
| 5 |
COMMIT; |