Mercurial > lada > lada-server
annotate 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 |
| rev | line source |
|---|---|
|
835
075f511243d5
Added tests for stammdaten
Raimund Renkert <raimund.renkert@intevation.de>
parents:
832
diff
changeset
|
1 DELETE FROM land.probe WHERE id = 1000; |
|
075f511243d5
Added tests for stammdaten
Raimund Renkert <raimund.renkert@intevation.de>
parents:
832
diff
changeset
|
2 DELETE FROM land.messprogramm WHERE id = 1000; |
|
075f511243d5
Added tests for stammdaten
Raimund Renkert <raimund.renkert@intevation.de>
parents:
832
diff
changeset
|
3 DELETE FROM stammdaten.datensatz_erzeuger WHERE id = 1000; |
|
075f511243d5
Added tests for stammdaten
Raimund Renkert <raimund.renkert@intevation.de>
parents:
832
diff
changeset
|
4 DELETE FROM stammdaten.probenehmer WHERE id = 1000; |
|
075f511243d5
Added tests for stammdaten
Raimund Renkert <raimund.renkert@intevation.de>
parents:
832
diff
changeset
|
5 DELETE FROM stammdaten.messprogramm_kategorie WHERE id = 1000; |
|
075f511243d5
Added tests for stammdaten
Raimund Renkert <raimund.renkert@intevation.de>
parents:
832
diff
changeset
|
6 DELETE FROM stammdaten.ort WHERE id = 1000; |