Mercurial > lada > lada-server
view src/test/resources/datasets/cleanup.sql @ 954:379480a94c81
Use ON DELETE CASCADE to ease removing queries from database.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 24 May 2016 17:15:44 +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;