Mercurial > lada > lada-server
annotate src/test/resources/datasets/cleanup.sql @ 901:56c9fb1d37c8
probe and messprogramm always need a mst_id and labor_mst_id.
Otherwise no owner can be determined.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 23 Mar 2016 18:52:09 +0100 |
| 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; |