Mercurial > lada > lada-server
view src/test/resources/datasets/cleanup.sql @ 955:58fc5b5fad4b
The database might refuse to delete an object e.g. due to FK constraints.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 25 May 2016 16:51:55 +0200 |
| parents | 075f511243d5 |
| children |
line wrap: on
line source
DELETE FROM land.probe WHERE id = 1000; DELETE FROM land.messprogramm WHERE id = 1000; DELETE FROM stammdaten.datensatz_erzeuger WHERE id = 1000; DELETE FROM stammdaten.probenehmer WHERE id = 1000; DELETE FROM stammdaten.messprogramm_kategorie WHERE id = 1000; DELETE FROM stammdaten.ort WHERE id = 1000;